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

Assertion `state_ == s_exec' failed in int wsrep::client_state::start_transaction(const wsrep::transaction_id&)

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6
    • 10.6
    • Galera
    • None

    Description

      The crash is from galera multi-thread pquery run.

      10.6.12 282f75262e98461608d079c46a4e96382aa2c6a3

      mysqld: /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp:319: int wsrep::client_state::start_transaction(const wsrep::transaction_id&): Assertion `state_ == s_exec' failed.
      

      10.6.12 282f75262e98461608d079c46a4e96382aa2c6a3

      Core was generated by `/test/mtest/MDEV-24623/10.6_v2/mariadb-10.6.12-linux-x86_64/bin/mysqld --defaul'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x151b2d152700 (LWP 52338))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055b1a2c5cc71 in my_write_core (sig=6) at /test/mtest/MDEV-24623/10.6_v2/mysys/stacktrace.c:424
      #2  0x000055b1a237b9cc in handle_fatal_signal (sig=6) at /test/mtest/MDEV-24623/10.6_v2/sql/signal_handler.cc:357
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x0000151b81291859 in __GI_abort () at abort.c:79
      #6  0x0000151b81291729 in __assert_fail_base (fmt=0x151b81427588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55b1a2d73a10 "state_ == s_exec", file=0x55b1a2d739c8 "/test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp", line=319, function=<optimized out>) at assert.c:92
      #7  0x0000151b812a2fd6 in __GI___assert_fail (assertion=0x55b1a2d73a10 "state_ == s_exec", file=0x55b1a2d739c8 "/test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp", line=319, function=0x55b1a2d73978 "int wsrep::client_state::start_transaction(const wsrep::transaction_id&)") at assert.c:101
      #8  0x000055b1a1f9644d in wsrep::client_state::start_transaction (this=0x151a90057ef8, id=@0x151b2d150158: {id_ = 5259}) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp:319
      #9  0x000055b1a27866e9 in Wsrep_storage_service::start_transaction (this=0x151a900b8460, ws_handle=@0x151a90007990: {transaction_id_ = {id_ = 5259}, opaque_ = 0x151a8401bf20}) at /test/mtest/MDEV-24623/10.6_v2/sql/wsrep_storage_service.cc:86
      #10 0x000055b1a2d1e67d in wsrep::transaction::certify_fragment (this=0x151a90007930, lock=@0x151b2d150640: {_M_device = 0x151a90007890, _M_owns = false}) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/src/transaction.cpp:1554
      #11 0x000055b1a2d1df63 in wsrep::transaction::streaming_step (this=0x151a90007930, lock=@0x151b2d150640: {_M_device = 0x151a90007890, _M_owns = false}, force=false) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/src/transaction.cpp:1437
      #12 0x000055b1a2d198fd in wsrep::transaction::after_row (this=0x151a90007930) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/src/transaction.cpp:268
      #13 0x000055b1a239a67d in wsrep::client_state::after_row (this=0x151a900078c8) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp:399
      #14 0x000055b1a237cfb7 in wsrep_after_row_internal (thd=0x151a90001138) at /test/mtest/MDEV-24623/10.6_v2/sql/wsrep_trans_observer.h:175
      #15 0x000055b1a2393774 in wsrep_after_row (thd=0x151a90001138) at /test/mtest/MDEV-24623/10.6_v2/sql/handler.cc:7182
      #16 0x000055b1a239546a in handler::ha_write_row (this=0x151a90186100, buf=0x151a9004cca0 "u'") at /test/mtest/MDEV-24623/10.6_v2/sql/handler.cc:7597
      #17 0x000055b1a1f8b7e9 in write_record (thd=0x151a90001138, table=0x151a900494d8, info=0x151b2d1509e0, sink=0x0) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_insert.cc:2156
      #18 0x000055b1a1f883fa in mysql_insert (thd=0x151a90001138, table_list=0x151a90014348, fields=@0x151a90006380: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x151a90014b78, last = 0x151a90015050, elements = 5}, <No data fields>}, values_list=@0x151a900063c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x151a90015d10, last = 0x151a90015d10, elements = 1}, <No data fields>}, update_fields=@0x151a900063b0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b1a394ff20 <end_of_list>, last = 0x151a900063b0, elements = 0}, <No data fields>}, update_values=@0x151a90006398: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b1a394ff20 <end_of_list>, last = 0x151a90006398, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=true, result=0x0) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_insert.cc:1128
      #19 0x000055b1a1fde126 in mysql_execute_command (thd=0x151a90001138, is_called_from_prepared_stmt=false) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:4568
      #20 0x000055b1a1fe9bb8 in mysql_parse (thd=0x151a90001138, rawbuf=0x151a900140d0 "insert ignore into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10101,'impossible_function_1',@category1_id,'description of \\n impossible_function1\\n','example of \\n"..., length=223, parser_state=0x151b2d151320) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:8019
      #21 0x000055b1a1fe92b5 in wsrep_mysql_parse (thd=0x151a90001138, rawbuf=0x151a900140d0 "insert ignore into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10101,'impossible_function_1',@category1_id,'description of \\n impossible_function1\\n','example of \\n"..., length=223, parser_state=0x151b2d151320) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:7831
      #22 0x000055b1a1fd5f44 in dispatch_command (command=COM_QUERY, thd=0x151a90001138, packet=0x151a9000b7e9 "insert ignore into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10101,'impossible_function_1',@category1_id,'description of \\n impossible_function1\\n','example of \\n"..., packet_length=224, blocking=true) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:1883
      #23 0x000055b1a1fd49f2 in do_command (thd=0x151a90001138, blocking=true) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:1409
      #24 0x000055b1a2196ca1 in do_handle_one_connection (connect=0x55b1a5c9cc38, put_in_cache=true) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_connect.cc:1416
      #25 0x000055b1a21969fd in handle_one_connection (arg=0x55b1a5c9cc38) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_connect.cc:1318
      #26 0x000055b1a26cd679 in pfs_spawn_thread (arg=0x55b1a5659d58) at /test/mtest/MDEV-24623/10.6_v2/storage/perfschema/pfs.cc:2201
      #27 0x0000151b817bd609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #28 0x0000151b8138e133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Activity

          People

            janlindstrom Jan Lindström
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.