Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6, 10.7, 10.8, 10.9, 10.10
Description
Testcase
Start 3 node cluster and run following RQG test to reproduce the crash
|
# RQG data load
|
perl gendata.pl --dsn=dbi:mysql:host=127.0.0.1:port=35130:user=root:database=test --spec=conf/galera/galera_stress.zz
|
|
# Initiate stress test on Node1
|
perl gentest.pl --dsn=dbi:mysql:host=127.0.0.1:port=35130:user=root:database=test --grammar=conf/galera/galera_stress.yy --duration=10300 --queries=100000000 --threads=32 &
|
|
# Initiate stress test on Node2
|
perl gentest.pl --dsn=dbi:mysql:host=127.0.0.1:port=17115:user=root:database=test --grammar=conf/galera/galera_stress.yy --duration=10300 --queries=100000000 --threads=32 &
|
10.7.0 76149650764ea9660ae05d4987ea6c91534851ab (Debug) |
#0 0x0000000070000002 in ?? ()
|
#1 0x0000071129e6b766 in _raw_syscall () at /home/roc/rr/rr/src/preload/raw_syscall.S:120
|
#2 0x0000071129e6704e in traced_raw_syscall (call=<optimized out>) at /home/roc/rr/rr/src/preload/syscallbuf.c:272
|
#3 0x0000071129e6a4d1 in syscall_hook_internal (call=0x1475199fcfa0) at /home/roc/rr/rr/src/preload/syscallbuf.c:3295
|
#4 syscall_hook (call=0x1475199fcfa0) at /home/roc/rr/rr/src/preload/syscallbuf.c:3329
|
#5 0x0000071129e66e50 in _syscall_hook_trampoline () at /home/roc/rr/rr/src/preload/syscall_hook.S:313
|
#6 0x0000071129e66eaf in __morestack () at /home/roc/rr/rr/src/preload/syscall_hook.S:458
|
#7 0x0000071129e66f08 in _syscall_hook_trampoline_89_c2_f7_da () at /home/roc/rr/rr/src/preload/syscall_hook.S:504
|
#8 0x000072123158af0c in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#9 0x000055903e0995f6 in my_write_core (sig=sig@entry=6) at /test/10.7_dbg/mysys/stacktrace.c:424
|
#10 0x000055903d8912d9 in handle_fatal_signal (sig=6) at /test/10.7_dbg/sql/signal_handler.cc:345
|
#11 <signal handler called>
|
#12 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#13 0x00003dce6cc0a859 in __GI_abort () at abort.c:79
|
#14 0x00003dce6cc0a729 in __assert_fail_base (fmt=0x3dce6cda0588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",
|
assertion=0x55903e493160 "lock_rec_has_expl(LOCK_X | 1024U, g.cell(), id, heap_no, &trx)",
|
file=0x55903e4921b8 "/test/10.7_dbg/storage/innobase/lock/lock0lock.cc", line=5773, function=<optimized out>) at assert.c:92
|
#15 0x00003dce6cc1bf36 in __GI___assert_fail (
|
assertion=assertion@entry=0x55903e493160 "lock_rec_has_expl(LOCK_X | 1024U, g.cell(), id, heap_no, &trx)",
|
file=file@entry=0x55903e4921b8 "/test/10.7_dbg/storage/innobase/lock/lock0lock.cc", line=line@entry=5773,
|
function=function@entry=0x55903e4930e0 "bool lock_trx_has_expl_x_lock(const trx_t&, const dict_table_t&, page_id_t, ulint)")
|
at assert.c:101
|
#16 0x000055903dcc954a in lock_trx_has_expl_x_lock (trx=..., table=..., id=..., heap_no=heap_no@entry=42)
|
at /test/10.7_dbg/storage/innobase/include/lock0lock.h:949
|
#17 0x000055903de1a401 in row_upd_clust_step (node=node@entry=0x104c2003c320, thr=thr@entry=0x104c2003c6a8)
|
at /test/10.7_dbg/storage/innobase/include/buf0buf.h:821
|
#18 0x000055903de1d258 in row_upd (thr=0x104c2003c6a8, node=0x104c2003c320) at /test/10.7_dbg/storage/innobase/row/row0upd.cc:2907
|
#19 row_upd_step (thr=thr@entry=0x104c2003c6a8) at /test/10.7_dbg/storage/innobase/row/row0upd.cc:3051
|
#20 0x000055903ddc231b in row_update_for_mysql (prebuilt=0x104c2003b7e8) at /test/10.7_dbg/storage/innobase/row/row0mysql.cc:1717
|
#21 0x000055903dc46a66 in ha_innobase::update_row (this=0x104c2003a670, old_row=0x104c2003a210 <incomplete sequence \351>,
|
new_row=0x104c2003a1e8 <incomplete sequence \351>) at /test/10.7_dbg/storage/innobase/handler/ha_innodb.cc:8588
|
#22 0x000055903d8a6357 in handler::ha_update_row (this=0x104c2003a670, old_data=0x104c2003a210 <incomplete sequence \351>,
|
new_data=0x104c2003a1e8 <incomplete sequence \351>) at /test/10.7_dbg/sql/handler.cc:7569
|
#23 0x000055903d6b1b50 in mysql_update (thd=thd@entry=0x4bbb4c000db8, table_list=<optimized out>, fields=..., values=...,
|
conds=<optimized out>, order_num=<optimized out>, order=<optimized out>, limit=18446744073709551613, ignore=<optimized out>,
|
found_return=<optimized out>, updated_return=<optimized out>) at /test/10.7_dbg/sql/sql_update.cc:1081
|
#24 0x000055903d599b8c in mysql_execute_command (thd=thd@entry=0x4bbb4c000db8,
|
is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.7_dbg/sql/sql_limit.h:83
|
#25 0x000055903d584c5f in mysql_parse (thd=thd@entry=0x4bbb4c000db8,
|
rawbuf=rawbuf@entry=0x4bbb4c013dd0 "UPDATE IGNORE `table0_innodb_int_autoinc` AS X SET `col_int_key` = 1 /* QNO 12891 CON_ID 27 */",
|
length=length@entry=95, parser_state=parser_state@entry=0x7aca75f3e400) at /test/10.7_dbg/sql/sql_parse.cc:8036
|
#26 0x000055903d5845e5 in wsrep_mysql_parse (thd=thd@entry=0x4bbb4c000db8,
|
rawbuf=0x4bbb4c013dd0 "UPDATE IGNORE `table0_innodb_int_autoinc` AS X SET `col_int_key` = 1 /* QNO 12891 CON_ID 27 */", length=95,
|
parser_state=parser_state@entry=0x7aca75f3e400) at /test/10.7_dbg/sql/sql_parse.cc:7849
|
#27 0x000055903d593943 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x4bbb4c000db8,
|
packet=packet@entry=0x4bbb4c00b739 "UPDATE IGNORE `table0_innodb_int_autoinc` AS X SET `col_int_key` = 1 /* QNO 12891 CON_ID 27 */ ",
|
packet_length=packet_length@entry=96, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_class.h:1358
|
#28 0x000055903d596d3a in do_command (thd=0x4bbb4c000db8, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_parse.cc:1404
|
#29 0x000055903d70e8a7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x7112a2f0d58,
|
put_in_cache=put_in_cache@entry=true) at /test/10.7_dbg/sql/sql_connect.cc:1418
|
--Type <RET> for more, q to quit, c to continue without paging--
|
#30 0x000055903d70eeaf in handle_one_connection (arg=arg@entry=0x7112a2f0d58) at /test/10.7_dbg/sql/sql_connect.cc:1312
|
#31 0x000055903db7ad13 in pfs_spawn_thread (arg=0x7112a294ee8) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201
|
#32 0x0000721231582609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#33 0x00003dce6cd07293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|
Attachments
Issue Links
- is duplicated by
-
MDEV-29081 trx_t::lock.was_chosen_as_deadlock_victim race in lock_wait_end()
-
- Closed
-