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

Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed.

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3
    • 10.4, 10.5, 10.6, 10.11, 11.1, 11.2
    • Galera
    • None

    Description

      SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6';
      

      Leads to

      10.6.16 7a6684b0b0ad32efb003ef21902ad3255c93db64 (Optimized)

      Core was generated by `/test/codership/GAL_MD150923-mariadb-10.6.16-linux-x86_64-opt/bin/mysqld --defa'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x15410154b700 (LWP 1687170))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055cd578fb29f in my_write_core (sig=sig@entry=11) at /test/codership/10.6_opt/mysys/stacktrace.c:424
      #2  0x000055cd57430110 in handle_fatal_signal (sig=11) at /test/codership/10.6_opt/sql/signal_handler.cc:360
      #3  <signal handler called>
      #4  galera::TrxHandle::state (this=<optimized out>) at /test/codership/galera_4x/galera/src/trx_handle.hpp:196
      #5  galera::ReplicatorSMM::replay_trx (this=0x55cd58ccd640, trx=Python Exception <class 'gdb.error'> No type named std::__detail::_Hash_node<class galera::TrxHandle::Transition, true>.: 
      @0x1540a40177c0: {<galera::TrxHandle> = {_vptr.TrxHandle = 0x1541372e59e8 <vtable for galera::TrxHandleMaster+16>, static TRXHANDLE_FLAGS_MASK = 33791, static EXPLICIT_ROLLBACK_FLAGS = 10, static FLAGS_MATCH_API_FLAGS = true, static num_states_ = 12, state_ = {delete_ = false, trans_map_ = 0x1541372eb620 <galera::TrxHandleMaster::trans_map_>, state_ = {
                  first = galera::TrxHandle::S_EXECUTING,
                  second = 0
                }, state_hist_ = std::vector of length 0, capacity 0}, source_id_ = {data = "%\035S\250U\365\021\356\230(SU\267\230\024\230", alignment = 17154762203875974437}, conn_id_ = 18446744073709551615, trx_id_ = 20, timestamp_ = 1695022202956141567, version_ = 5, write_set_flags_ = 64, local_ = true, master_ = true}, static Defaults = {working_dir_ = ".", version_ = -1, key_format_ = galera::KeySet::FLAT16A, record_set_ver_ = gu::RecordSet::VER2, max_write_set_size_ = 0}, mutex_ = {value_ = {sys_mutex = pthread_mutex_t = {
                  Type = Normal,
                  Status = Acquired, possibly with no waiters,
                  Owner ID = 1687170,
                  Robust = No,
                  Shared = No,
                  Protocol = None
                }, opaque = 0x0, opaque2 = 0x0, ts_mutex = 0x0}}, mem_pool_ = @0x55cd58cce318, static trans_map_ = {impl_ = std::unordered_set with 22 elements}, params_ = {working_dir_ = "/test/codership/GAL_MD150923-mariadb-10.6.16-linux-x86_64-opt/node1/", version_ = 5, key_format_ = galera::KeySet::FLAT8, record_set_ver_ = gu::RecordSet::VER2, max_write_set_size_ = 2147483647}, ts_ = {px = 0x0, pn = {pi_ = 0x0}}, wso_buf_size_ = 7912, gcs_handle_ = -1, wso_ = true, last_ts_seqno_ = -1, deferred_abort_ = false}, lock=@0x154101549b10: {trx_ = @0x1540a40177c0, locked_ = true}, trx_ctx=0x154101549d50) at /test/codership/galera_4x/galera/src/replicator_smm.cpp:1053
      #6  0x0000154137095b9c in galera_replay_trx (gh=<optimized out>, trx_handle=<optimized out>, recv_ctx=0x154101549d50) at /test/codership/galera_4x/galera/src/wsrep_provider.cpp:339
      #7  0x000055cd57a8d3fd in wsrep::wsrep_provider_v26::replay (this=<optimized out>, ws_handle=<optimized out>, reply_service=<optimized out>) at /test/codership/10.6_opt/wsrep-lib/src/wsrep_provider_v26.cpp:209
      #8  0x000055cd57698aa0 in Wsrep_client_service::replay (this=0x1540a4006f80) at /test/codership/10.6_opt/wsrep-lib/include/wsrep/transaction.hpp:225
      #9  0x000055cd57a8aa6a in wsrep::transaction::replay (this=0x1540a4007000, lock=@0x15410154a270: {_M_device = 0x1540a4006f60, _M_owns = false}) at /test/codership/10.6_opt/wsrep-lib/src/transaction.cpp:2047
      #10 0x000055cd57a8afbd in wsrep::transaction::after_statement (this=this@entry=0x1540a4007000, lock=@0x15410154a270: {_M_device = 0x1540a4006f60, _M_owns = false}) at /test/codership/10.6_opt/wsrep-lib/src/transaction.cpp:882
      #11 0x000055cd57a7106e in wsrep::client_state::after_statement (this=this@entry=0x1540a4006f98) at /test/codership/10.6_opt/wsrep-lib/src/client_state.cpp:265
      #12 0x000055cd571f0874 in wsrep_after_statement (thd=0x1540a4000c58) at /test/codership/10.6_opt/sql/sql_class.h:5490
      #13 wsrep_mysql_parse (thd=0x1540a4000c58, rawbuf=0x1540a4010700 "SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'", length=40, parser_state=0x15410154a3d0) at /test/codership/10.6_opt/sql/sql_parse.cc:7892
      #14 0x000055cd571fe065 in dispatch_command (command=COM_QUERY, thd=0x1540a4000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/codership/10.6_opt/sql/sql_parse.cc:1981
      #15 0x000055cd571fed3e in do_command (thd=0x1540a4000c58, blocking=blocking@entry=true) at /test/codership/10.6_opt/sql/sql_parse.cc:1409
      #16 0x000055cd57308c17 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55cd58f509f8, put_in_cache=put_in_cache@entry=true) at /test/codership/10.6_opt/sql/sql_connect.cc:1416
      #17 0x000055cd57308efd in handle_one_connection (arg=0x55cd58f509f8) at /test/codership/10.6_opt/sql/sql_connect.cc:1318
      #18 0x0000154137b56609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #19 0x0000154137742133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.4.32 b3d287288c9d7e4d3c5dd1e9ae35de62ff57e8f9 (Debug)

      mysqld: /test/codership/10.4_dbg/wsrep-lib/src/transaction.cpp:449: int wsrep::transaction::before_commit(): Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed.
      

      10.4.32 b3d287288c9d7e4d3c5dd1e9ae35de62ff57e8f9 (Debug)

      Core was generated by `/test/codership/GAL_MD180923-mariadb-10.4.32-linux-x86_64-dbg/bin/mysqld --defa'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x148d6c34e700 (LWP 2123548))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055ca4846ae5c in my_write_core (sig=sig@entry=6) at /test/codership/10.4_dbg/mysys/stacktrace.c:386
      #2  0x000055ca47c789fa in handle_fatal_signal (sig=6) at /test/codership/10.4_dbg/sql/signal_handler.cc:372
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x0000148da7f06859 in __GI_abort () at abort.c:79
      #6  0x0000148da7f06729 in __assert_fail_base (fmt=0x148da809c588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55ca48b16740 "state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying", file=0x55ca48b15328 "/test/codership/10.4_dbg/wsrep-lib/src/transaction.cpp", line=449, function=<optimized out>) at assert.c:92
      #7  0x0000148da7f17fd6 in __GI___assert_fail (assertion=assertion@entry=0x55ca48b16740 "state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying", file=file@entry=0x55ca48b15328 "/test/codership/10.4_dbg/wsrep-lib/src/transaction.cpp", line=line@entry=449, function=function@entry=0x55ca48b166e0 "int wsrep::transaction::before_commit()") at assert.c:101
      #8  0x000055ca485bfa9f in wsrep::transaction::before_commit (this=this@entry=0x148d24006e20) at /test/codership/10.4_dbg/wsrep-lib/src/transaction.cpp:535
      #9  0x000055ca485a1614 in wsrep::client_state::before_commit (this=this@entry=0x148d24006db8) at /test/codership/10.4_dbg/wsrep-lib/src/client_state.cpp:389
      #10 0x000055ca47c7dfff in wsrep_before_commit (all=false, thd=0x148d24000d28) at /test/codership/10.4_dbg/sql/sql_class.h:5041
      #11 ha_commit_trans (thd=thd@entry=0x148d24000d28, all=all@entry=false) at /test/codership/10.4_dbg/sql/handler.cc:1614
      #12 0x000055ca47b86acc in rpl_slave_state::record_gtid (this=this@entry=0x55ca4b098310, thd=thd@entry=0x148d24000d28, gtid=gtid@entry=0x148d6c34b8a0, sub_id=sub_id@entry=2, in_transaction=in_transaction@entry=false, in_statement=in_statement@entry=true, out_hton=0x148d6c34b898) at /test/codership/10.4_dbg/sql/rpl_gtid.cc:749
      #13 0x000055ca47b8837b in rpl_slave_state::load (this=0x55ca4b098310, thd=thd@entry=0x148d24000d28, state_from_master=<optimized out>, len=<optimized out>, reset=reset@entry=true, in_statement=in_statement@entry=true) at /test/codership/10.4_dbg/sql/rpl_gtid.cc:1407
      #14 0x000055ca47a286f4 in rpl_gtid_pos_update (thd=thd@entry=0x148d24000d28, str=<optimized out>, len=<optimized out>) at /test/codership/10.4_dbg/sql/sql_repl.cc:4728
      #15 0x000055ca47b3b080 in Sys_var_gtid_slave_pos::global_update (this=<optimized out>, thd=0x148d24000d28, var=0x148d24012670) at /test/codership/10.4_dbg/sql/sys_vars.cc:1858
      #16 0x000055ca4792d588 in sys_var::update (this=0x55ca48e97040 <Sys_gtid_slave_pos>, thd=0x148d24000d28, var=0x148d24012670) at /test/codership/10.4_dbg/sql/set_var.cc:208
      #17 0x000055ca4792dacf in set_var::update (this=<optimized out>, thd=<optimized out>) at /test/codership/10.4_dbg/sql/set_var.cc:837
      #18 0x000055ca4792ed4d in sql_set_variables (thd=thd@entry=0x148d24000d28, var_list=var_list@entry=0x148d24005a60, free=free@entry=true) at /test/codership/10.4_dbg/sql/set_var.cc:740
      #19 0x000055ca479fe411 in mysql_execute_command (thd=thd@entry=0x148d24000d28) at /test/codership/10.4_dbg/sql/sql_parse.cc:5045
      #20 0x000055ca47a04408 in mysql_parse (thd=thd@entry=0x148d24000d28, rawbuf=rawbuf@entry=0x148d240124c0 "SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'", length=length@entry=40, parser_state=parser_state@entry=0x148d6c34d3b0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/codership/10.4_dbg/sql/sql_parse.cc:8010
      #21 0x000055ca47a050eb in wsrep_mysql_parse (thd=thd@entry=0x148d24000d28, rawbuf=0x148d240124c0 "SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'", length=40, parser_state=parser_state@entry=0x148d6c34d3b0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/codership/10.4_dbg/sql/sql_parse.cc:7812
      #22 0x000055ca47a06fa8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148d24000d28, packet=packet@entry=0x148d24019599 "SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'", packet_length=packet_length@entry=40, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/codership/10.4_dbg/sql/sql_class.h:1231
      #23 0x000055ca47a09819 in do_command (thd=0x148d24000d28) at /test/codership/10.4_dbg/sql/sql_parse.cc:1378
      #24 0x000055ca47b281a2 in do_handle_one_connection (connect=<optimized out>) at /test/codership/10.4_dbg/sql/sql_connect.cc:1420
      #25 0x000055ca47b2825e in handle_one_connection (arg=<optimized out>) at /test/codership/10.4_dbg/sql/sql_connect.cc:1324
      #26 0x0000148da8417609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #27 0x0000148da8003133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        1. n1.cnf
          1 kB
        2. n2.cnf
          1 kB

        Issue Links

          Activity

            People

              janlindstrom Jan Lindström
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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