Test rpl.rpl_init_slave_errors crashes server intermittently

Bug #1638897 reported by Laurynas Biveinis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
Fix Released
High
Laurynas Biveinis
5.6
Fix Released
High
Laurynas Biveinis
5.7
Invalid
Undecided
Unassigned

Bug Description

On 5.5 trunk:

rpl.rpl_init_slave_errors 'mix' w2 [ fail ]
        Test ended at 2016-10-31 08:06:57

CURRENT_TEST: rpl.rpl_init_slave_errors
mysqltest: In included file "./include/wait_for_slave_param.inc":
included from ./include/wait_for_slave_param.inc at line 115:
included from ./include/wait_for_slave_sql_error.inc at line 41:
At line 115: query 'let $_show_slave_status_value= query_get_value("SHOW SLAVE STATUS", $slave_param, 1)' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
include/master-slave.inc
[connection master]
stop slave;
reset slave;
SET GLOBAL debug= "d,simulate_io_slave_error_on_init,simulate_sql_slave_error_on_init";
start slave;
include/wait_for_slave_sql_error.inc [errno=1593]
Last_SQL_Error = 'Failed during slave thread initialization'
call mtr.add_suppression("Failed during slave.* thread initialization");
SET GLOBAL debug= "";
reset slave;
SET GLOBAL init_slave= "garbage";
start slave;
include/wait_for_slave_sql_error.inc [errno=1064]
safe_process[23134]: Child process: 23135, exit: 1
...
161031 15:06:57 [ERROR] Slave SQL: Failed during slave thread initialization, Error_code: 1593
mysqld: /mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/sql/slave.cc:894: bool io_slave_killed(THD*, Master_info*): Assertion `mi->io_thd == thd' failed.
12:06:57 UTC - mysqld got signal 6 ;
...
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
62 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
[Current thread is 1 (Thread 0x7f8e103e1700 (LWP 23161))]
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
#1 0x0000000000808653 in my_write_core (sig=sig@entry=6) at /mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/mysys/stacktrace.c:433
#2 0x00000000006c5df3 in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/sql/signal_handler.cc:250
#3 <signal handler called>
#4 0x00007f8e13af3428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#5 0x00007f8e13af502a in __GI_abort () at abort.c:89
#6 0x00007f8e13aebbd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0xab0751 "mi->io_thd == thd", file=file@entry=0xab13f0 "/mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/sql/slave.cc", line=line@entry=894, function=function@entry=0xab4de0 <io_slave_killed(THD*, Master_info*)::__PRETTY_FUNCTION__> "bool io_slave_killed(THD*, Master_info*)") at assert.c:92
#7 0x00007f8e13aebc82 in __GI___assert_fail (assertion=assertion@entry=0xab0751 "mi->io_thd == thd", file=file@entry=0xab13f0 "/mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/sql/slave.cc", line=line@entry=894, function=function@entry=0xab4de0 <io_slave_killed(THD*, Master_info*)::__PRETTY_FUNCTION__> "bool io_slave_killed(THD*, Master_info*)") at assert.c:101
#8 0x000000000051fde1 in io_slave_killed (mi=0x1d718e0, thd=0x7f8de0000a70) at /mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/sql/slave.cc:894
#9 connect_to_master (thd=thd@entry=0x7f8de0000a70, mysql=mysql@entry=0x7f8de0012ee0, mi=mi@entry=0x1d718e0, reconnect=reconnect@entry=false, suppress_warnings=<optimized out>, suppress_warnings@entry=false) at /mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/sql/slave.cc:4367
#10 0x000000000052a311 in safe_connect (mi=0x1d718e0, mysql=0x7f8de0012ee0, thd=0x7f8de0000a70) at /mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/sql/slave.cc:4287
#11 handle_slave_io (arg=arg@entry=0x1d718e0) at /mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/sql/slave.cc:2890
#12 0x00000000008219fa in pfs_spawn_thread (arg=0x7f8df4055b80) at /mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/debug/Host/ubuntu-xenial-64bit/storage/perfschema/pfs.cc:1015
#13 0x00007f8e1500270a in start_thread (arg=0x7f8e103e1700) at pthread_create.c:333
#14 0x00007f8e13bc482d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Tags: ci upstream
tags: added: ci upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.