My Oracle Support Banner

MySQL Crashes After Installing DDL Replication Followed By Issuing A Create Table (Doc ID 2788508.1)

Last updated on FEBRUARY 09, 2022

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


MySQL Crashes after installing DDL replication followed by issuing a create table plugin was crashing MySQL server

Steps to simulate the problem:
./ install <superuser> <password> <port no>

mysql> create table <table name> (c char(3));

Table gets created but MySQL crashes as seen in the mysq-error.log

02:42:55 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by
malfunctioning hardware.
Thread pointer: 0x7f70480958b0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f78a80e2c70 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned
long)+0x3d) [0x213b8ad]
/usr/sbin/mysqld(handle_fatal_signal+0x313) [0xff5083]
/lib64/ [0x7f78ca341680]
/usr/lib64/mysql/plugin/ [0x7f73881cb3dc]
/usr/sbin/mysqld(Trans_delegate::after_commit(THD*, bool)+0x16e) [0x1ddb9de]
THD*)+0xbe) [0x1d77ebe]
/usr/sbin/mysqld(MYSQL_BIN_LOG::ordered_commit(THD*, bool, bool)+0x239)
/usr/sbin/mysqld(MYSQL_BIN_LOG::commit(THD*, bool)+0x3f5) [0x1d8da85]
/usr/sbin/mysqld(ha_commit_trans(THD*, bool, bool)+0x3b9) [0x11070c9]
/usr/sbin/mysqld(trans_commit_implicit(THD*, bool)+0x5a) [0xfbfbea]
/usr/sbin/mysqld(mysql_create_table(THD*, TABLE_LIST*, HA_CREATE_INFO*,
Alter_info*)+0x735) [0xf5c3d5]
/usr/sbin/mysqld(Sql_cmd_create_table::execute(THD*)+0x721) [0x13196b1]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xc36) [0xebe616]
/usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x38b) [0xec339b]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*,
enum_server_command)+0x1e6f) [0xec56af]
/usr/sbin/mysqld(do_command(THD*)+0x19c) [0xec630c]
/usr/sbin/mysqld() [0xfe6320]
/usr/sbin/mysqld() [0x26cc56e]
/lib64/ [0x7f78ca339dd5]
/lib64/ [0x7f78c8721b3d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f70480e3f48): create table b1 (c char(3))/*oggddlversion=1*/
Connection ID (thread ID): 22

The manual page at contains
information that should help you find out what is causing the crash.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.