rpl.percona_bug1331586 'stmt' crashes debug build with "sql/rpl_slave.cc:4455: int exec_relay_log_event(THD*, Relay_log_info*): Assertion `thd->transaction.all.cannot_safely_rollback()' failed." intermittently
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
New
|
Undecided
|
Unassigned | |||
5.6 |
Triaged
|
High
|
Unassigned | |||
5.7 |
New
|
Undecided
|
Unassigned |
Bug Description
On 5.6 trunk, http://
rpl.percona_
Test ended at 2017-02-16 08:02:53
CURRENT_TEST: rpl.percona_
mysqltest: In included file "./include/
included from ./include/
At line 82: query 'STOP SLAVE' failed: 2013: Lost connection to MySQL server during query
...
mysqld-debug: /mnt/workspace/
...
Thread 27 (Thread 0x7f7352bb6940 (LWP 12244)):
#0 0x00007f7364435019 in pthread_
from /lib64/
#1 0x0000000000ad8b9e in safe_cond_wait (cond=0x32402d8, mp=0x3240268,
file=0xfcc740 "/mnt/workspace
at /mnt/workspace/
#2 0x0000000000aa5bf8 in inline_
mutex=
src_
at /mnt/workspace/
#3 0x0000000000aab14a in pop_jobs_item (worker=0x323cfa0,
job_
at /mnt/workspace/
#4 0x0000000000aab2e6 in slave_worker_
rli=
at /mnt/workspace/
#5 0x0000000000a8d66b in handle_slave_worker (arg=0x323cfa0)
at /mnt/workspace/
#6 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x316c350)
at /mnt/workspace/
#7 0x00007f736443083d in start_thread () from /lib64/
#8 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 26 (Thread 0x7f7364946940 (LWP 12241)):
#0 0x00007f7362a120b6 in poll () from /lib64/libc.so.6
#1 0x0000000000e9c1ed in vio_io_wait (vio=0x7f73481d
event=
at /mnt/workspace/
#2 0x0000000000e9a6ee in vio_socket_io_wait (vio=0x7f73481d
event=
at /mnt/workspace/
#3 0x0000000000e9a7ce in vio_read (vio=0x7f73481d
buf=
at /mnt/workspace/
#4 0x000000000072d399 in net_read_raw_loop (net=0x7f73481d
at /mnt/workspace/
#5 0x000000000072d567 in net_read_
at /mnt/workspace/
#6 0x000000000072d666 in net_read_packet (net=0x7f73481d
complen=
at /mnt/workspace/
#7 0x000000000072d88a in my_net_read (net=0x7f73481d
at /mnt/workspace/
#8 0x00000000007ed1a0 in do_command (thd=0x7f73481d
at /mnt/workspace/
#9 0x00000000007b3eef in do_handle_
at /mnt/workspace/
#10 0x00000000007b3bf6 in handle_
at /mnt/workspace/
#11 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x7f734810
at /mnt/workspace/
#12 0x00007f736443083d in start_thread () from /lib64/
#13 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 25 (Thread 0x7f7364905940 (LWP 12242)):
#0 0x00007f7362a120b6 in poll () from /lib64/libc.so.6
#1 0x0000000000e9c1ed in vio_io_wait (vio=0x3134c40,
event=
at /mnt/workspace/
#2 0x0000000000e9a6ee in vio_socket_io_wait (vio=0x3134c40,
event=
at /mnt/workspace/
#3 0x0000000000e9a7ce in vio_read (vio=0x3134c40, buf=0x3336260 "1",
size=16384)
at /mnt/workspace/
#4 0x0000000000e9a985 in vio_read_buff (vio=0x3134c40, buf=0x333a270 "",
size=4)
at /mnt/workspace/
#5 0x000000000072d399 in net_read_raw_loop (net=0x3044900, count=4)
at /mnt/workspace/
#6 0x000000000072d599 in net_read_
at /mnt/workspace/
#7 0x000000000072d666 in net_read_packet (net=0x3044900,
complen=
at /mnt/workspace/
#8 0x000000000072d88a in my_net_read (net=0x3044900)
at /mnt/workspace/
#9 0x00000000008db1ff in cli_safe_read (mysql=0x3044900)
at /mnt/workspace/
#10 0x0000000000a89125 in read_event (mysql=0x3044900, mi=0x7f73480873e0,
suppress_
at /mnt/workspace/
#11 0x0000000000a8c4e0 in handle_slave_io (arg=0x7f734808
at /mnt/workspace/
#12 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x31569a0)
at /mnt/workspace/
#13 0x00007f736443083d in start_thread () from /lib64/
#14 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 24 (Thread 0x7f7364987940 (LWP 12240)):
#0 0x00007f7362a120b6 in poll () from /lib64/libc.so.6
#1 0x0000000000e9c1ed in vio_io_wait (vio=0x7f73481d
event=
at /mnt/workspace/
#2 0x0000000000e9a6ee in vio_socket_io_wait (vio=0x7f73481d
event=
at /mnt/workspace/
#3 0x0000000000e9a7ce in vio_read (vio=0x7f73481d
buf=
at /mnt/workspace/
#4 0x000000000072d399 in net_read_raw_loop (net=0x7f73481d
at /mnt/workspace/
#5 0x000000000072d567 in net_read_
at /mnt/workspace/
#6 0x000000000072d666 in net_read_packet (net=0x7f73481d
complen=
at /mnt/workspace/
#7 0x000000000072d88a in my_net_read (net=0x7f73481d
at /mnt/workspace/
#8 0x00000000007ed1a0 in do_command (thd=0x7f73481d
at /mnt/workspace/
#9 0x00000000007b3eef in do_handle_
at /mnt/workspace/
#10 0x00000000007b3bf6 in handle_
at /mnt/workspace/
#11 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x7f73480f
at /mnt/workspace/
#12 0x00007f736443083d in start_thread () from /lib64/
#13 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 23 (Thread 0x7f7347fff940 (LWP 12232)):
#0 0x00007f7362a14172 in select () from /lib64/libc.so.6
#1 0x0000000000b9b351 in os_thread_sleep (tm=1000000)
at /mnt/workspace/
#2 0x0000000000cf2ee6 in page_cleaner_
next_
at /mnt/workspace/
#3 0x0000000000cf31fb in buf_flush_
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 22 (Thread 0x7f7352b75940 (LWP 12245)):
#0 0x00007f7364435019 in pthread_
from /lib64/
#1 0x0000000000ad8b9e in safe_cond_wait (cond=0x3297628, mp=0x32975b8,
file=0xfcc740 "/mnt/workspace
at /mnt/workspace/
#2 0x0000000000aa5bf8 in inline_
mutex=
src_
at /mnt/workspace/
#3 0x0000000000aab14a in pop_jobs_item (worker=0x32942f0,
job_
at /mnt/workspace/
#4 0x0000000000aab2e6 in slave_worker_
rli=
at /mnt/workspace/
#5 0x0000000000a8d66b in handle_slave_worker (arg=0x32942f0)
at /mnt/workspace/
#6 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x31686c0)
at /mnt/workspace/
#7 0x00007f736443083d in start_thread () from /lib64/
#8 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 21 (Thread 0x7f7353fb7940 (LWP 12199)):
#0 0x00007f73642295b4 in ?? () from /usr/lib64/
#1 0x0000000000b98198 in os_aio_
seg_size=256)
at /mnt/workspace/
#2 0x0000000000b9852c in os_aio_linux_handle (global_seg=5,
message1=
space_
at /mnt/workspace/
#3 0x0000000000d4e9c6 in fil_aio_wait (segment=5)
at /mnt/workspace/
#4 0x0000000000c5a9d0 in io_handler_thread (arg=0x1840648)
at /mnt/workspace/
#5 0x00007f736443083d in start_thread () from /lib64/
#6 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 20 (Thread 0x7f735138d940 (LWP 12228)):
#0 0x00007f7362a14172 in select () from /lib64/libc.so.6
#1 0x0000000000b9b351 in os_thread_sleep (tm=1000000)
at /mnt/workspace/
#2 0x0000000000c56f13 in srv_master_sleep ()
at /mnt/workspace/
#3 0x0000000000c57056 in srv_master_thread (arg=0x0)
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 19 (Thread 0x7f73567b9940 (LWP 12197)):
#0 0x00007f73642295b4 in ?? () from /usr/lib64/
#1 0x0000000000b98198 in os_aio_
seg_size=256)
at /mnt/workspace/
#2 0x0000000000b9852c in os_aio_linux_handle (global_seg=3,
message1=
space_
at /mnt/workspace/
#3 0x0000000000d4e9c6 in fil_aio_wait (segment=3)
at /mnt/workspace/
#4 0x0000000000c5a9d0 in io_handler_thread (arg=0x1840638)
at /mnt/workspace/
#5 0x00007f736443083d in start_thread () from /lib64/
#6 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 18 (Thread 0x7f7364a09940 (LWP 12238)):
#0 0x00007f7364435280 in pthread_
from /lib64/
#1 0x0000000000ad8d6b in safe_cond_timedwait (cond=0x7f73480
mp=
file=0xfbfda0 "/mnt/workspace
at /mnt/workspace/
#2 0x0000000000a7e6a3 in inline_
mutex=
src_
at /mnt/workspace/
#3 0x0000000000a8165f in terminate_
term_
slave_
at /mnt/workspace/
#4 0x0000000000a80f57 in terminate_
thread_mask=3, need_lock_
at /mnt/workspace/
#5 0x0000000000a96a26 in stop_slave (thd=0x7f73480e
net_
at /mnt/workspace/
#6 0x00000000007f38c2 in mysql_execute_
at /mnt/workspace/
#7 0x00000000007fcc21 in mysql_parse (thd=0x7f73480e
rawbuf=
at /mnt/workspace/
#8 0x00000000007ee633 in dispatch_command (command=COM_QUERY,
thd=
at /mnt/workspace/
#9 0x00000000007ed411 in do_command (thd=0x7f73480e
at /mnt/workspace/
#10 0x00000000007b3eef in do_handle_
at /mnt/workspace/
#11 0x00000000007b3bf6 in handle_
at /mnt/workspace/
#12 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x7f734812
at /mnt/workspace/
#13 0x00007f736443083d in start_thread () from /lib64/
#14 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 17 (Thread 0x7f734eb8a940 (LWP 12227)):
#0 0x00007f7364435280 in pthread_
from /lib64/
#1 0x0000000000b9a69d in os_cond_wait_timed (cond=0x2f2e168,
fast_
at /mnt/workspace/
#2 0x0000000000b9acae in os_event_
time_
at /mnt/workspace/
#3 0x0000000000c55763 in srv_error_
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 16 (Thread 0x7f7364a4b720 (LWP 12192)):
#0 0x00007f7362a120b6 in poll () from /lib64/libc.so.6
#1 0x0000000000632c4c in handle_
at /mnt/workspace/
#2 0x0000000000631c2a in mysqld_main (argc=90, argv=0x2f2d448)
at /mnt/workspace/
#3 0x00000000006257e0 in main (argc=12, argv=0x7ffc5882
at /mnt/workspace/
Thread 15 (Thread 0x7f73553b8940 (LWP 12198)):
#0 0x00007f73642295b4 in ?? () from /usr/lib64/
#1 0x0000000000b98198 in os_aio_
seg_size=256)
at /mnt/workspace/
#2 0x0000000000b9852c in os_aio_linux_handle (global_seg=4,
message1=
space_
at /mnt/workspace/
#3 0x0000000000d4e9c6 in fil_aio_wait (segment=4)
at /mnt/workspace/
#4 0x0000000000c5a9d0 in io_handler_thread (arg=0x1840640)
at /mnt/workspace/
#5 0x00007f736443083d in start_thread () from /lib64/
#6 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 14 (Thread 0x7f7357bba940 (LWP 12196)):
#0 0x00007f73642295b4 in ?? () from /usr/lib64/
#1 0x0000000000b98198 in os_aio_
seg_size=256)
at /mnt/workspace/
#2 0x0000000000b9852c in os_aio_linux_handle (global_seg=2,
message1=
space_
at /mnt/workspace/
#3 0x0000000000d4e9c6 in fil_aio_wait (segment=2)
at /mnt/workspace/
#4 0x0000000000c5a9d0 in io_handler_thread (arg=0x1840630)
at /mnt/workspace/
#5 0x00007f736443083d in start_thread () from /lib64/
#6 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 13 (Thread 0x7f73443fc940 (LWP 12235)):
#0 0x00007f7364435280 in pthread_
from /lib64/
#1 0x0000000000b9a69d in os_cond_wait_timed (cond=0x312e118,
fast_
at /mnt/workspace/
#2 0x0000000000b9acae in os_event_
time_
at /mnt/workspace/
#3 0x0000000000d3d3ef in dict_stats_thread (arg=0x0)
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 12 (Thread 0x7f73457fd940 (LWP 12234)):
#0 0x00007f7364435019 in pthread_
from /lib64/
#1 0x0000000000b9a785 in os_cond_wait (cond=0x303ade8, fast_mutex=
at /mnt/workspace/
#2 0x0000000000b9aab8 in os_event_wait_low (event=0x303adb0,
reset_
at /mnt/workspace/
#3 0x0000000000ceb043 in buf_dump_thread (arg=0x0)
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 11 (Thread 0x7f7346bfe940 (LWP 12233)):
#0 0x00007f7362a14172 in select () from /lib64/libc.so.6
#1 0x0000000000b9b351 in os_thread_sleep (tm=999000)
at /mnt/workspace/
#2 0x0000000000cf2ee6 in page_cleaner_
next_
at /mnt/workspace/
#3 0x0000000000cf379b in buf_flush_
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 10 (Thread 0x7f73649c8940 (LWP 12239)):
#0 0x00007f7362a120b6 in poll () from /lib64/libc.so.6
#1 0x0000000000e9c1ed in vio_io_wait (vio=0x7f73481c
event=
at /mnt/workspace/
#2 0x0000000000e9a6ee in vio_socket_io_wait (vio=0x7f73481c
event=
at /mnt/workspace/
#3 0x0000000000e9a7ce in vio_read (vio=0x7f73481c
buf=
at /mnt/workspace/
#4 0x000000000072d399 in net_read_raw_loop (net=0x7f73481c
at /mnt/workspace/
#5 0x000000000072d567 in net_read_
at /mnt/workspace/
#6 0x000000000072d666 in net_read_packet (net=0x7f73481c
complen=
at /mnt/workspace/
#7 0x000000000072d88a in my_net_read (net=0x7f73481c
at /mnt/workspace/
#8 0x00000000007ed1a0 in do_command (thd=0x7f73481c
at /mnt/workspace/
#9 0x00000000007b3eef in do_handle_
at /mnt/workspace/
#10 0x00000000007b3bf6 in handle_
at /mnt/workspace/
#11 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x7f734812
at /mnt/workspace/
#12 0x00007f736443083d in start_thread () from /lib64/
#13 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 9 (Thread 0x7f734d789940 (LWP 12229)):
#0 0x00007f7364435019 in pthread_
from /lib64/
#1 0x0000000000b9a785 in os_cond_wait (cond=0x2f2e0f8, fast_mutex=
at /mnt/workspace/
#2 0x0000000000b9aab8 in os_event_wait_low (event=0x2f2e0c0,
reset_
at /mnt/workspace/
#3 0x0000000000c57a0b in srv_purge_
rseg_
at /mnt/workspace/
#4 0x0000000000c57f1d in srv_purge_
at /mnt/workspace/
#5 0x00007f736443083d in start_thread () from /lib64/
#6 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 8 (Thread 0x7f7342ffb940 (LWP 12236)):
#0 0x00007f7364435280 in pthread_
from /lib64/
#1 0x0000000000b9a69d in os_cond_wait_timed (cond=0x7f73480
fast_
at /mnt/workspace/
#2 0x0000000000b9acae in os_event_
time_
at /mnt/workspace/
#3 0x0000000000c99cf6 in ib_wqueue_timedwait (wq=0x7f734803b368,
wait_
at /mnt/workspace/
#4 0x0000000000d7be61 in fts_optimize_thread (arg=0x7f734803
at /mnt/workspace/
#5 0x00007f736443083d in start_thread () from /lib64/
#6 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 7 (Thread 0x7f7364a4a940 (LWP 12237)):
#0 0x00007f73644389c8 in do_sigwait () from /lib64/
#1 0x00007f7364438a6d in sigwait () from /lib64/
#2 0x000000000062cd7e in signal_hand (arg=0x0)
at /mnt/workspace/
#3 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x7f734805
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 6 (Thread 0x7f735a3bc940 (LWP 12194)):
#0 0x00007f73642295b4 in ?? () from /usr/lib64/
#1 0x0000000000b98198 in os_aio_
seg_size=256)
at /mnt/workspace/
#2 0x0000000000b9852c in os_aio_linux_handle (global_seg=0,
message1=
space_
at /mnt/workspace/
#3 0x0000000000d4e9c6 in fil_aio_wait (segment=0)
at /mnt/workspace/
#4 0x0000000000c5a9d0 in io_handler_thread (arg=0x1840620)
at /mnt/workspace/
#5 0x00007f736443083d in start_thread () from /lib64/
#6 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 5 (Thread 0x7f734ff8b940 (LWP 12226)):
#0 0x00007f7364435280 in pthread_
from /lib64/
#1 0x0000000000b9a69d in os_cond_wait_timed (cond=0x3120798,
fast_
at /mnt/workspace/
#2 0x0000000000b9acae in os_event_
time_
at /mnt/workspace/
#3 0x0000000000b70cef in lock_wait_
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 4 (Thread 0x7f7358fbb940 (LWP 12195)):
#0 0x00007f73642295b4 in ?? () from /usr/lib64/
#1 0x0000000000b98198 in os_aio_
seg_size=256)
at /mnt/workspace/
#2 0x0000000000b9852c in os_aio_linux_handle (global_seg=1,
message1=
space_
at /mnt/workspace/
#3 0x0000000000d4e9c6 in fil_aio_wait (segment=1)
at /mnt/workspace/
#4 0x0000000000c5a9d0 in io_handler_thread (arg=0x1840628)
at /mnt/workspace/
#5 0x00007f736443083d in start_thread () from /lib64/
#6 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 3 (Thread 0x7f735278e940 (LWP 12200)):
#0 0x00007f7364435280 in pthread_
from /lib64/
#1 0x0000000000b9a69d in os_cond_wait_timed (cond=0x303ad78,
fast_
at /mnt/workspace/
#2 0x0000000000b9acae in os_event_
time_
at /mnt/workspace/
#3 0x0000000000c5515e in srv_monitor_thread (arg=0x0)
at /mnt/workspace/
#4 0x00007f736443083d in start_thread () from /lib64/
#5 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 2 (Thread 0x7f735c4c0940 (LWP 12193)):
#0 0x00007f73629774a4 in do_sigwaitinfo () from /lib64/libc.so.6
#1 0x00007f736297755d in sigwaitinfo () from /lib64/libc.so.6
#2 0x0000000000adc6f0 in timer_notify_thread (arg=0x7ffc5882
at /mnt/workspace/
#3 0x00007f736443083d in start_thread () from /lib64/
#4 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Thread 1 (Thread 0x7f73648c4940 (LWP 12243)):
#0 0x00007f7364435e32 in pthread_kill () from /lib64/
#1 0x0000000000ad478a in my_write_core (sig=6)
at /mnt/workspace/
#2 0x000000000073b133 in handle_fatal_signal (sig=6)
at /mnt/workspace/
#3 <signal handler called>
#4 0x00007f7362975fc5 in raise () from /lib64/libc.so.6
#5 0x00007f7362977a70 in abort () from /lib64/libc.so.6
#6 0x00007f736296f466 in __assert_fail () from /lib64/libc.so.6
#7 0x0000000000a8adc8 in exec_relay_
rli=
at /mnt/workspace/
#8 0x0000000000a909a8 in handle_slave_sql (arg=0x7f734808
at /mnt/workspace/
#9 0x0000000000e3bcb1 in pfs_spawn_thread (arg=0x3134e40)
at /mnt/workspace/
#10 0x00007f736443083d in start_thread () from /lib64/
#11 0x00007f7362a1afdd in clone () from /lib64/libc.so.6
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-3648