ERROR 1180 (HY000): Got error 131 during COMMIT | ERROR 1064 (42000): You have an error in your SQL syntax | handle_fatal_signal (sig=11) in _my_b_write

[Roel Van de Paar]

Various errors and crashes seen with the following two testcases:

# mysqld options required for replay: --log-bin
SET GLOBAL relay_log_info_repository='TABLE';
SET @@GLOBAL.relay_log_info_repository="FILE";
SET innodb_fake_changes=1;
CHANGE MASTER TO IGNORE_SERVER_IDS=();
SET GLOBAL relay_log_info_repository='TABLE'; #ERROR 1180 (HY000): Got error 131 during COMMIT
SET @@GLOBAL.relay_log_info_repository="FILE"; #ERROR 1180 (HY000): Got error 131 during COMMIT
CHANGE MASTER TO IGNORE_SERVER_IDS=(); #ERROR 2013 (HY000): Lost connection to MySQL server during query (crash 1)

# mysqld options required for replay: --log-bin
SET innodb_fake_changes=1;
SET GLOBAL relay_log_info_repository='TABLE'; #ERROR 1180 (HY000): Got error 131 during COMMIT
SET GLOBAL.relay_log_info_repository='FILE'; #ERROR 1064 (42000): You have an error in your SQL syntax; ...
CHANGE MASTER TO IGNORE_SERVER_IDS=(); #ERROR 2013 (HY000): Lost connection to MySQL server during query (crash 2)

Crash 1:
Core was generated by `/sda/PS260117-percona-server-5.6.35-80.0-linux-x86_64-debug/bin/mysqld --no-def'.
Program terminated with signal 11, Segmentation fault.
#0 0x00007f2b32b30741 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0 0x00007f2b32b30741 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000ac4648 in my_write_core (sig=11) at /sda/PS-5.6.35_dbg/mysys/stacktrace.c:424
#2 0x0000000000737acd in handle_fatal_signal (sig=11) at /sda/PS-5.6.35_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 __memcpy_ssse3_back () at ../sysdeps/x86_64/multiarch/memcpy-ssse3-back.S:2254
#5 0x0000000000aa9a95 in _my_b_write (info=0x7f2b2f03b128, Buffer=0x7f2b33120ad0 "7", Count=1) at /sda/PS-5.6.35_dbg/mysys/mf_iocache.c:1597
#6 0x0000000000aab81b in my_b_vprintf (info=0x7f2b2f03b128, fmt=0xfac231 "d\n", args=0x7f2b33120b90) at /sda/PS-5.6.35_dbg/mysys/mf_iocache2.c:456
#7 0x0000000000aaae84 in my_b_printf (info=0x7f2b2f03b128, fmt=0xfac230 "%d\n") at /sda/PS-5.6.35_dbg/mysys/mf_iocache2.c:305
#8 0x0000000000a9da32 in Rpl_info_file::do_set_info (this=0x7f2b2f03ac00, pos=0, value=7) at /sda/PS-5.6.35_dbg/sql/rpl_info_file.cc:364
#9 0x0000000000a8c7d3 in Rpl_info_handler::set_info<int> (this=0x7f2b2f03ac00, value=7) at /sda/PS-5.6.35_dbg/sql/rpl_info_handler.h:186
#10 0x0000000000a92b58 in Relay_log_info::write_info (this=0x7f2b07fc2000, to=0x7f2b2f03ac00) at /sda/PS-5.6.35_dbg/sql/rpl_rli.cc:2245
#11 0x0000000000a92690 in Relay_log_info::flush_info (this=0x7f2b07fc2000, force=true) at /sda/PS-5.6.35_dbg/sql/rpl_rli.cc:2109
#12 0x0000000000a890f8 in change_master (thd=0x7f2b07f4d000, mi=0x7f2b07fb4000) at /sda/PS-5.6.35_dbg/sql/rpl_slave.cc:9306
#13 0x00000000007ec7a5 in mysql_execute_command (thd=0x7f2b07f4d000) at /sda/PS-5.6.35_dbg/sql/sql_parse.cc:3281
#14 0x00000000007f68e7 in mysql_parse (thd=0x7f2b07f4d000, rawbuf=0x7f2abc81f010 "CHANGE MASTER TO IGNORE_SERVER_IDS=()", length=37, parser_state=0x7f2b331224f0)
    at /sda/PS-5.6.35_dbg/sql/sql_parse.cc:7059
#15 0x00000000007e8466 in dispatch_command (command=COM_QUERY, thd=0x7f2b07f4d000, packet=0x7f2afabf0001 "CHANGE MASTER TO IGNORE_SERVER_IDS=()", packet_length=37)
    at /sda/PS-5.6.35_dbg/sql/sql_parse.cc:1488
#16 0x00000000007e7264 in do_command (thd=0x7f2b07f4d000) at /sda/PS-5.6.35_dbg/sql/sql_parse.cc:1065
#17 0x00000000007ae7b5 in do_handle_one_connection (thd_arg=0x7f2b07f4d000) at /sda/PS-5.6.35_dbg/sql/sql_connect.cc:1553
#18 0x00000000007ae4bc in handle_one_connection (arg=0x7f2b07f4d000) at /sda/PS-5.6.35_dbg/sql/sql_connect.cc:1457
#19 0x0000000000e24767 in pfs_spawn_thread (arg=0x7f2b15ffb6a0) at /sda/PS-5.6.35_dbg/storage/perfschema/pfs.cc:1860
#20 0x00007f2b32b2bdc5 in start_thread (arg=0x7f2b33123700) at pthread_create.c:308
#21 0x00007f2b30f8673d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

Crash 2:
Core was generated by `/sda/PS260117-percona-server-5.6.35-80.0-linux-x86_64-debug/bin/mysqld --no-def'.
Program terminated with signal 6, Aborted.
#0 0x00007fa0c0622741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0 0x00007fa0c0622741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000ac4648 in my_write_core (sig=6) at /sda/PS-5.6.35_dbg/mysys/stacktrace.c:424
#2 0x0000000000737acd in handle_fatal_signal (sig=6) at /sda/PS-5.6.35_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fa0be9b61d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fa0be9b78c8 in __GI_abort () at abort.c:90
#6 0x00007fa0be9af146 in __assert_fail_base (fmt=0x7fa0beb003a8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xecfe2e "! is_set()",
    file=file@entry=0xecfc60 "/sda/PS-5.6.35_dbg/sql/sql_error.cc", line=line@entry=430,
    function=function@entry=0xed01e0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
#7 0x00007fa0be9af1f2 in __GI___assert_fail (assertion=0xecfe2e "! is_set()", file=0xecfc60 "/sda/PS-5.6.35_dbg/sql/sql_error.cc", line=430,
    function=0xed01e0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
#8 0x00000000007b74b4 in Diagnostics_area::set_ok_status (this=0x7fa0957504a8, affected_rows=0, last_insert_id=0, message=0x0) at /sda/PS-5.6.35_dbg/sql/sql_error.cc:430
#9 0x000000000076f670 in my_ok (thd=0x7fa09574d000, affected_rows=0, id=0, message=0x0) at /sda/PS-5.6.35_dbg/sql/sql_class.h:4542
#10 0x0000000000a891fb in change_master (thd=0x7fa09574d000, mi=0x7fa0957b4000) at /sda/PS-5.6.35_dbg/sql/rpl_slave.cc:9323
#11 0x00000000007ec7a5 in mysql_execute_command (thd=0x7fa09574d000) at /sda/PS-5.6.35_dbg/sql/sql_parse.cc:3281
#12 0x00000000007f68e7 in mysql_parse (thd=0x7fa09574d000, rawbuf=0x7fa04a41f010 "CHANGE MASTER TO IGNORE_SERVER_IDS=()", length=37, parser_state=0x7fa0c0c144f0)
    at /sda/PS-5.6.35_dbg/sql/sql_parse.cc:7059
#13 0x00000000007e8466 in dispatch_command (command=COM_QUERY, thd=0x7fa09574d000, packet=0x7fa0883f0001 "CHANGE MASTER TO IGNORE_SERVER_IDS=()", packet_length=37)
    at /sda/PS-5.6.35_dbg/sql/sql_parse.cc:1488
#14 0x00000000007e7264 in do_command (thd=0x7fa09574d000) at /sda/PS-5.6.35_dbg/sql/sql_parse.cc:1065
#15 0x00000000007ae7b5 in do_handle_one_connection (thd_arg=0x7fa09574d000) at /sda/PS-5.6.35_dbg/sql/sql_connect.cc:1553
#16 0x00000000007ae4bc in handle_one_connection (arg=0x7fa09574d000) at /sda/PS-5.6.35_dbg/sql/sql_connect.cc:1457
#17 0x0000000000e24767 in pfs_spawn_thread (arg=0x7fa0a37fb6a0) at /sda/PS-5.6.35_dbg/storage/perfschema/pfs.cc:1860
#18 0x00007fa0c061ddc5 in start_thread (arg=0x7fa0c0c15700) at pthread_create.c:308
#19 0x00007fa0bea7873d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3655