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 19.0.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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

Steps to simulate the problem:
./ddl_install.sh 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/libpthread.so.0(+0xf680) [0x7f78ca341680]
/usr/lib64/mysql/plugin/ddl_metadata_8.so(+0x793dc) [0x7f73881cb3dc]
/usr/sbin/mysqld(Trans_delegate::after_commit(THD*, bool)+0x16e) [0x1ddb9de]
/usr/sbin/mysqld(MYSQL_BIN_LOG::process_after_commit_stage_queue(THD*,
THD*)+0xbe) [0x1d77ebe]
/usr/sbin/mysqld(MYSQL_BIN_LOG::ordered_commit(THD*, bool, bool)+0x239)
[0x1d8bb89]
/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/libpthread.so.0(+0x7dd5) [0x7f78ca339dd5]
/lib64/libc.so.6(clone+0x6d) [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
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

 

Cause

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
Symptoms
Cause
Solution
References


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