Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37353

SIGSEGV in galera::TrxHandleSlave::global_seqno | galera::ReplicatorSMM::CommitOrder::CommitOrder

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 12.1
    • N/A
    • Galera
    • 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

        1. full_bt.txt
          60 kB
          Ramesh Sivaraman

        Issue Links

          Activity

            People

              sysprg Julius Goryavsky (Inactive)
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.