node hanging in secondary index test
Bug #815079 reported by
Seppo Jaakola
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Medium
|
Seppo Jaakola | ||
0.8 |
Fix Released
|
Medium
|
Seppo Jaakola | ||
Trunk |
Fix Released
|
Medium
|
Seppo Jaakola |
Bug Description
Reproduced in 2 node multi-master topology with test case:
seppo@pitbull:
seppo@pitbull:
This issue has been see only with builtin innobase, maybe plugin version is not vulnerable
During the test load, one node can remain hanging in a state where slave applier is waiting for a victim thread to abort lock wait and grant the blocking lock to slave applier.
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Applier: cond_wait@ @GLIBC_ 2.3.2 () at ../nptl/ sysdeps/ unix/sysv/ linux/x86_ 64/pthread_ cond_wait. S:162 mysql_thread (thr=0x7f33e049 a8d8) at srv/srv0srv.c:1567 handle_ errors (new_err= 0x7f33bdb9db50, trx=0x7f33e046c8b8, thr=0x7f33e049a8d8, savept= 0x7f33bdb9db20) at row/row0mysql.c:497 for_mysql (mysql_ rec=0x7f33b8037 048 "\341\021", prebuilt= 0x7f33e04618b8) at row/row0mysql. c:1177 :write_ row (this=0x7f33b80 36e58, record= 0x7f33b8037048 "\341\021") at handler/ ha_innodb. cc:4473 :ha_write_ row (this=0x7f33b80 36e58, buf=0x7f33b8037048 "\341\021") at handler.cc:4722 event:: write_row (this=0x7f33b80 d0b68, rli=0x48d8ce0, overwrite=false) at log_event.cc:8675 log_event: :do_exec_ row (this=0x7f33b80 d0b68, rli=0x48d8ce0) at log_event.cc:8846 event:: do_apply_ event (this=0x7f33b80 d0b68, rli=0x48d8ce0) at log_event.cc:7617 :apply_ event (this=0x7f33b80 d0b68, rli=0x48d8ce0) at log_event.h:1067 0x7f33b00ae000 "\a,)N\023", buf_len=0) at sql_parse.cc:8420 ea80, global_ seqno=986647) at sql_parse.cc:8502 work/testing/ node2/galera/ lib/libgalera_ smm.so work/testing/ node2/galera/ lib/libgalera_ smm.so :ReplicatorSMM: :apply_ trx(void* , galera::TrxHandle*) () from /home/seppo/ work/testing/ node2/galera/ lib/libgalera_ smm.so :ReplicatorSMM: :process_ trx(void* , galera::TrxHandle*) () from /home/seppo/ work/testing/ node2/galera/ lib/libgalera_ smm.so :GcsActionSourc e::dispatch( void*, void const*, unsigned long, gcs_act_type, long, long) () from /home/seppo/ work/testing/ node2/galera/ lib/libgalera_ smm.so :GcsActionSourc e::process( void*) () from /home/seppo/ work/testing/ node2/galera/ lib/libgalera_ smm.so :ReplicatorSMM: :async_ recv(void* ) () from /home/seppo/ work/testing/ node2/galera/ lib/libgalera_ smm.so work/testing/ node2/galera/ lib/libgalera_ smm.so on_process (thd=0x48c73e8) at sql_parse.cc:8619 create. c:304 unix/sysv/ linux/x86_ 64/clone. S:112
Thread 7 (Thread 0x7f33bdba0700 (LWP 30721)):
#0 pthread_
#1 0x00000000009bc3ff in safe_cond_wait (cond=0x23b5db8, mp=0x23b5d40, file=0xb1d002 "os/os0sync.c", line=422) at thr_mutex.c:237
#2 0x00000000008c747f in os_event_wait_low (event=0x23b5d40, reset_sig_count=0) at os/os0sync.c:422
#3 0x00000000008f089a in srv_suspend_
#4 0x00000000008db22b in row_mysql_
#5 0x00000000008dc2fc in row_insert_
#6 0x00000000008698a6 in ha_innobase:
#7 0x000000000077ae2c in handler:
#8 0x000000000073b94e in Rows_log_
#9 0x000000000073baa7 in Write_rows_
#10 0x0000000000737326 in Rows_log_
#11 0x0000000000639e50 in Log_event:
#12 0x0000000000637c9e in wsrep_bf_apply_rbr (thd=0x48c73e8, rbr_buf=
#13 0x0000000000638286 in wsrep_bf_apply_cb (ctx=0x48c73e8, data=0x7f33bdb9
#14 0x00007f33bfa39db6 in ?? () from /home/seppo/
#15 0x00007f33bfa3b951 in ?? () from /home/seppo/
#16 0x00007f33bfa3be5e in galera:
#17 0x00007f33bfa41440 in galera:
#18 0x00007f33bfa37c23 in galera:
#19 0x00007f33bfa38091 in galera:
#20 0x00007f33bfa3cf50 in galera:
#21 0x00007f33bfa4ecc3 in galera_recv () from /home/seppo/
#22 0x00000000006386fc in wsrep_replicati
#23 0x00000000006153f8 in start_wsrep_THD (arg=0x638632) at mysqld.cc:4484
#24 0x00007f33e2b20971 in start_thread (arg=<value optimized out>) at pthread_
#25 0x00007f33e1d8a92d in clone () at ../sysdeps/
#26 0x0000000000000000 in ?? ()
Victim:
#0 pth...