Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.13-galera, 10.1.0
Description
InnoDB: Assertion failure in thread 140492273628928 in file lock0lock.cc line 4033
InnoDB: Failing assertion: lock != ctx->wait_lock
Found using rqg with following command line (does not repeat every time):
perl ./runall-new.pl --grammar=conf/engines/engine_stress.yy --gendata=conf/engi
|
nes/engine_stress.zz --duration=2000 --queries=100M --threads=8 --galera=mmm --b
|
asedir=/home/jan/mysql/10.0-galera --vardir=/home/jan/mysql/galera-test "--mysql
|
d=--wsrep-provider=/usr/lib/libgalera_smm.so" "--mysqld=--wsrep_sst_method=rsync"
|
ddd stack trace:
(gdb) where
|
#0 0x00007fc6e8fd6621 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
|
#1 0x0000000000ea285b in my_write_core (sig=6) at /home/jan/mysql/10.0-galera/mysys/stacktrace.c:457
|
#2 0x00000000008979f6 in handle_fatal_signal (sig=6) at /home/jan/mysql/10.0-galera/sql/signal_handler.cc:262
|
#3 <signal handler called>
|
#4 0x00007fc6e842bbb9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
|
#5 0x00007fc6e842efc8 in __GI_abort () at abort.c:89
|
#6 0x0000000000c27ce8 in lock_get_first_lock (ctx=0x7fc6e80ff300, heap_no=0x7fc6e80ff2a8) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:4033
|
#7 0x0000000000c28742 in lock_deadlock_search (ctx=0x7fc6e80ff300, waitee_ptr=0x0) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:4303
|
#8 0x0000000000c28c92 in lock_deadlock_check_and_resolve (lock=0x7fc6ac46f738, trx=0x7fc6ac47e678) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:4467
|
#9 0x0000000000c243ff in lock_rec_enqueue_waiting (c_lock=0x7fc6ac071120, type_mode=1027, block=0x7fc6befca1d0, heap_no=71, index=0x7fc6d91b4ff8, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:2259
|
#10 0x0000000000c25000 in lock_rec_lock_slow (impl=0, mode=1027, block=0x7fc6befca1d0, heap_no=71, index=0x7fc6d91b4ff8, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:2602
|
#11 0x0000000000c252af in lock_rec_lock (impl=0, mode=1027, block=0x7fc6befca1d0, heap_no=71, index=0x7fc6d91b4ff8, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:2670
|
#12 0x0000000000c2f32f in lock_clust_rec_read_check_and_lock (flags=0, block=0x7fc6befca1d0, rec=0x7fc6c6b28dc9 "\200", index=0x7fc6d91b4ff8, offsets=0x7fc6e80ff880, mode=LOCK_X, gap_mode=1024, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/lock/lock0lock.cc:7028
|
#13 0x0000000000cf4d27 in sel_set_rec_lock (block=0x7fc6befca1d0, rec=0x7fc6c6b28dc9 "\200", index=0x7fc6d91b4ff8, offsets=0x7fc6e80ff880, mode=3, type=1024, thr=0x7fc6ad597780) at /home/jan/mysql/10.0-galera/storage/xtradb/row/row0sel.cc:1011
|
#14 0x0000000000cfb432 in row_search_for_mysql (buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>, mode=1, prebuilt=0x7fc6ad597078, match_mode=0, direction=1) at /home/jan/mysql/10.0-galera/storage/xtradb/row/row0sel.cc:4513
|
#15 0x0000000000bd286c in ha_innobase::general_fetch (this=0x7fc6ad55e088, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>, direction=1, match_mode=0) at /home/jan/mysql/10.0-galera/storage/xtradb/handler/ha_innodb.cc:9515
|
#16 0x0000000000bd2dc2 in ha_innobase::rnd_next (this=0x7fc6ad55e088, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>) at /home/jan/mysql/10.0-galera/storage/xtradb/handler/ha_innodb.cc:9732
|
#17 0x000000000089db32 in handler::ha_rnd_next (this=0x7fc6ad55e088, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>) at /home/jan/mysql/10.0-galera/sql/handler.cc:2617
|
#18 0x0000000000e6b464 in ha_partition::rnd_next (this=0x7fc6ad4ee888, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>) at /home/jan/mysql/10.0-galera/sql/ha_partition.cc:4910
|
#19 0x000000000089db32 in handler::ha_rnd_next (this=0x7fc6ad4ee888, buf=0x7fc6ad44d3a0 "\377", ' ' <repeats 12 times>) at /home/jan/mysql/10.0-galera/sql/handler.cc:2617
|
#20 0x00000000008935ca in find_all_keys (param=0x7fc6e81005b0, select=0x7fc6ac423b00, fs_info=0x7fc6e8100540, buffpek_pointers=0x7fc6e81007d0, tempfile=0x7fc6e8100630, pq=0x0, found_rows=0x7fc6e8100a80) at /home/jan/mysql/10.0-galera/sql/filesort.cc:757
|
#21 0x0000000000891fff in filesort (thd=0x7fc6bd633070, table=0x7fc6ad4d0470, sortorder=0x7fc6ac4a1088, s_length=5, select=0x7fc6ac423b00, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7fc6e8100a60, found_rows=0x7fc6e8100a80) at /home/jan/mysql/10.0-galera/sql/filesort.cc:299
|
#22 0x00000000009facb3 in mysql_delete (thd=0x7fc6bd633070, table_list=0x7fc6ac422370, conds=0x7fc6ac422e00, order_list=0x7fc6bd637900, limit=3, options=0, result=0x7fc6ac423748) at /home/jan/mysql/10.0-galera/sql/sql_delete.cc:484
|
#23 0x00000000006833ed in mysql_execute_command (thd=0x7fc6bd633070) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:3931
|
#24 0x000000000068c909 in mysql_parse (thd=0x7fc6bd633070, rawbuf=0x7fc6ac422088 "DELETE LOW_PRIORITY IGNORE FROM `table100_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 28 , 155 , 4 , 9 , 'f' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3", length=198, parser_state=0x7fc6e8102220) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:7010
|
#25 0x000000000068c07a in wsrep_mysql_parse (thd=0x7fc6bd633070, rawbuf=0x7fc6ac422088 "DELETE LOW_PRIORITY IGNORE FROM `table100_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 28 , 155 , 4 , 9 , 'f' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3", length=198, parser_state=0x7fc6e8102220) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:6832
|
#26 0x000000000067d0b4 in dispatch_command (command=COM_QUERY, thd=0x7fc6bd633070, packet=0x7fc6bd639071 "DELETE LOW_PRIORITY IGNORE FROM `table100_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 28 , 155 , 4 , 9 , 'f' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3", packet_length=198) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:1485
|
#27 0x000000000067bda8 in do_command (thd=0x7fc6bd633070) at /home/jan/mysql/10.0-galera/sql/sql_parse.cc:1087
|
#28 0x00000000007a6f4c in do_handle_one_connection (thd_arg=0x7fc6bd633070) at /home/jan/mysql/10.0-galera/sql/sql_connect.cc:1396
|
#29 0x00000000007a6ca4 in handle_one_connection (arg=0x7fc6bd633070) at /home/jan/mysql/10.0-galera/sql/sql_connect.cc:1307
|
#30 0x00007fc6e8fd1182 in start_thread (arg=0x7fc6e8103700) at pthread_create.c:312
|
#31 0x00007fc6e84effbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Attachments
Issue Links
- relates to
-
MDEV-6564 BF-BF X lock conflict
- Closed
-
MDEV-10544 Galera: Failing assertion: (lock->trx)->wait_lock == lock
- Closed