Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
12.1
-
None
-
Can result in hang or crash
Description
The crash is from galera multi-thread pquery run.
MDEV-36077 CS 12.1.0 678d72e0361b603b3911cfa141e51834561e1dc6 (Optimized) Build 30/07/2025 |
Core was generated by `/test/mtest/MDEV-36077/GAL_MD300725-mariadb-12.1.0-linux-x86_64-opt/bin/mariadb'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 __pthread_kill_implementation (no_tid=0, signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
 |
[Current thread is 1 (LWP 2460913)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=11, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=11)at ./nptl/pthread_kill.c:89
|
#3 0x00005944b2f0a868 in handle_fatal_signal (sig=11)at /test/mtest/MDEV-36077/12.1_opt/sql/signal_handler.cc:298
|
#4 <signal handler called>
|
#5 galera::TrxHandleSlave::global_seqno (this=0x0)at /test/mtest/MDEV-36077/12.0_galera/galera/src/trx_handle.hpp:624
|
#6 galera::ReplicatorSMM::CommitOrder::CommitOrder (mode=galera::ReplicatorSMM::CommitOrder::NO_OOOC, ts=<error reading variable: Cannot access memory at address 0x0>, this=<synthetic pointer>)at /test/mtest/MDEV-36077/12.0_galera/galera/src/replicator_smm.hpp:746
|
#7 galera::ReplicatorSMM::commit_order_leave (this=this@entry=0x5944ca682900, ts=<error reading variable: Cannot access memory at address 0x0>, error=error@entry=0x71c633536e90)at /test/mtest/MDEV-36077/12.0_galera/galera/src/replicator_smm.cpp:1443
|
#8 0x000071ca13c6e48a in galera_commit_order_leave (gh=<optimized out>, ws_handle=<optimized out>, meta=<optimized out>, error=0x71c633536e90)at /test/mtest/MDEV-36077/12.0_galera/galera/src/wsrep_provider.cpp:835
|
#9 0x00005944b36294f0 in wsrep::wsrep_provider_v26::commit_order_leave (this=<optimized out>, ws_handle=<optimized out>, ws_meta=<optimized out>, err=<optimized out>)at /test/mtest/MDEV-36077/12.1_opt/wsrep-lib/src/wsrep_provider_v26.cpp:212
|
#10 0x00005944b3623069 in wsrep::transaction::ordered_commit (this=this@entry=0x71b6c80090b0)at /test/mtest/MDEV-36077/12.1_opt/wsrep-lib/src/transaction.cpp:588
|
#11 0x00005944b3604acd in wsrep::client_state::ordered_commit (this=this@entry=0x71b6c8009048)at /test/mtest/MDEV-36077/12.1_opt/wsrep-lib/src/client_state.cpp:395
|
#12 0x00005944b3045982 in wsrep_ordered_commit (all=<optimized out>, thd=0x71b6c8002918)at /test/mtest/MDEV-36077/12.1_opt/sql/wsrep_trans_observer.h:384
|
#13 MYSQL_BIN_LOG::queue_for_group_commit (this=this@entry=0x5944b3fdbea0 <mysql_bin_log>, orig_entry=orig_entry@entry=0x71c633537020)at /test/mtest/MDEV-36077/12.1_opt/sql/log.cc:8874
|
#14 0x00005944b30490fe in MYSQL_BIN_LOG::write_transaction_with_group_commit (this=this@entry=0x5944b3fdbea0 <mysql_bin_log>, entry=entry@entry=0x71c633537020)at /test/mtest/MDEV-36077/12.1_opt/sql/log.cc:8919
|
#15 0x00005944b3049bb2 in MYSQL_BIN_LOG::write_transaction_to_binlog_events (entry=0x71c633537020, this=0x5944b3fdbea0 <mysql_bin_log>)at /test/mtest/MDEV-36077/12.1_opt/sql/log.cc:8906
|
#16 MYSQL_BIN_LOG::write_transaction_to_binlog (this=this@entry=0x5944b3fdbea0 <mysql_bin_log>, thd=thd@entry=0x71b6c8002918, cache_mngr=cache_mngr@entry=0x71b6c8011ee8, end_ev=end_ev@entry=0x71c633537150, all=all@entry=false, using_stmt_cache=using_stmt_cache@entry=false, using_trx_cache=true, is_ro_1pc=false) at /test/mtest/MDEV-36077/12.1_opt/sql/log.cc:8533
|
#17 0x00005944b304b9bd in binlog_flush_cache (is_ro_1pc=false, using_trx=true, using_stmt=false, all=false, end_ev=0x71c633537150, cache_mngr=0x71b6c8011ee8, thd=0x71b6c8002918)at /test/mtest/MDEV-36077/12.1_opt/sql/log.cc:1911
|
#18 binlog_rollback_flush_trx_cache (thd=thd@entry=0x71b6c8002918, all=all@entry=false, cache_mngr=cache_mngr@entry=0x71b6c8011ee8)at /test/mtest/MDEV-36077/12.1_opt/sql/log.cc:2041
|
#19 0x00005944b304c1d0 in binlog_rollback (thd=0x71b6c8002918, all=<optimized out>) at /test/mtest/MDEV-36077/12.1_opt/sql/log.cc:2479
|
#20 0x00005944b2f0e517 in ha_rollback_trans (thd=thd@entry=0x71b6c8002918, all=all@entry=false) at /test/mtest/MDEV-36077/12.1_opt/sql/handler.cc:2371
|
#21 0x00005944b2dc4541 in trans_rollback_stmt (thd=0x71b6c8002918)at /test/mtest/MDEV-36077/12.1_opt/sql/transaction.cc:567
|
#22 0x00005944b2c347ab in select_create::abort_result_set (this=0x71b6c801b1a8)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_insert.cc:5654
|
#23 0x00005944b2c39fe1 in select_create::send_eof (this=0x71b6c801b1a8)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_insert.cc:5388
|
#24 0x00005944b2cfe9f4 in JOIN::exec_inner (this=this@entry=0x71b6c801b2e8)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_select.cc:4950
|
#25 0x00005944b2cff129 in JOIN::exec (this=this@entry=0x71b6c801b2e8)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_select.cc:4856
|
#26 0x00005944b2cfd588 in mysql_select (thd=thd@entry=0x71b6c8002918, tables=0x0, fields=@0x71b6c8018e50: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x71b6c8019298, last = 0x71b6c801a690, elements = 8}, <No data fields>}, conds=0x0, og_num=0, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=2201187781376, result=0x71b6c801b1a8, unit=0x71b6c8006b40, select_lex=0x71b6c8018b98)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_select.cc:5384
|
#27 0x00005944b2cfdcd4 in handle_select (thd=thd@entry=0x71b6c8002918, lex=lex@entry=0x71b6c8006a60, result=result@entry=0x71b6c801b1a8, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_select.cc:634
|
#28 0x00005944b2d44f5e in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x71b6c8002918)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_table.cc:13625
|
#29 0x00005944b2c78ff6 in mysql_execute_command (thd=thd@entry=0x71b6c8002918, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_parse.cc:5861
|
#30 0x00005944b2c7d543 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x71b6c8002918)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_parse.cc:7884
|
#31 mysql_parse (thd=0x71b6c8002918, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_parse.cc:7806
|
#32 0x00005944b2c7dc53 in wsrep_mysql_parse (thd=0x71b6c8002918, rawbuf=0x71b6c8018030 "CREATE OR REPLACE TABLE t1 AS SELECT TIMESTAMP('2001-01-01 00:00:00','10:10:10'), TIMESTAMP('2001-01-01 00:00:00.1','10:10:10'), TIMESTAMP('2001-01-01 00:00:00.12','10:10:10'), TIMESTAMP('2001-01-01 0"..., length=430, parser_state=0x71c63353a370)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_parse.cc:7694
|
#33 0x00005944b2c7fff5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x71b6c8002918, packet=packet@entry=0x71b6c8009629 "CREATE OR REPLACE TABLE t1 AS SELECT TIMESTAMP('2001-01-01 00:00:00','10:10:10'), TIMESTAMP('2001-01-01 00:00:00.1','10:10:10'), TIMESTAMP('2001-01-01 00:00:00.12','10:10:10'), TIMESTAMP('2001-01-01 0"..., packet_length=packet_length@entry=431, blocking=blocking@entry=true)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_parse.cc:1962
|
#34 0x00005944b2c80f25 in do_command (thd=thd@entry=0x71b6c8002918, blocking=blocking@entry=true)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_parse.cc:1416
|
#35 0x00005944b2db273d in do_handle_one_connection (connect=<optimized out>, put_in_cache=true)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_connect.cc:1414
|
#36 0x00005944b2db2a25 in handle_one_connection (arg=0x5944caa37c98)at /test/mtest/MDEV-36077/12.1_opt/sql/sql_connect.cc:1326
|
#37 0x000071ca14c9caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#38 0x000071ca14d29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Attached full bt
Attachments
Issue Links
- duplicates
-
MDEV-34760 Assertion `state() == s_committing' failed in int wsrep::transaction::ordered_commit()
-
- Open
-