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

Assertion `pause_seqno_.is_undefined() == false' failed in void wsrep::server_state::resume()

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4, 11.8, 12.1, 12.2
    • 11.4, 11.8, 12.1
    • Galera

    Description

      --source include/galera_cluster.inc
       
      SET @@character_set_database=utf8;
      SET GLOBAL wsrep_IGNORE_apply_errors=0;
      --ERROR ER_SP_DOES_NOT_EXIST
      GRANT EXECUTE ON FUNCTION func TO user@localhost;
      SET @@character_set_database=true;
      SET character_set_collations='ucs2=uca1400_croatian_ai_cs';
      SET GLOBAL read_only=ON;
      

      Leads to

      CS 12.2.0 b8a77289639a3b10ada64cf892f02b5cecdb1603 (Debug) Build 19/09/2025

      mariadbd: /test/12.2_dbg/wsrep-lib/src/server_state.cpp:587: void wsrep::server_state::resume(): Assertion `pause_seqno_.is_undefined() == false' failed.
      

      CS 12.2.0 b8a77289639a3b10ada64cf892f02b5cecdb1603 (Debug) Build 19/09/2025

      Core was generated by `/test/GAL_MD190925-mariadb-12.2.0-linux-x86_64-dbg/bin/mariadbd --defaults-file'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 3137663)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=6)at ./nptl/pthread_kill.c:89
      #3  0x0000584308ede2f2 in my_write_core (sig=6)at /test/12.2_dbg/mysys/stacktrace.c:424
      #4  0x000058430859c229 in handle_fatal_signal (sig=6)at /test/12.2_dbg/sql/signal_handler.cc:298
      #5  <signal handler called>
      #6  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #7  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #8  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #9  0x00007b60b244527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #10 0x00007b60b24288ff in __GI_abort () at ./stdlib/abort.c:79
      #11 0x00007b60b242881b in __assert_fail_base (fmt=0x7b60b25d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5843098f28a0 "pause_seqno_.is_undefined() == false", file=file@entry=0x5843098f2358 "/test/12.2_dbg/wsrep-lib/src/server_state.cpp", line=line@entry=587, function=function@entry=0x5843098f2878 "void wsrep::server_state::resume()") at ./assert/assert.c:96
      #12 0x00007b60b243b517 in __assert_fail (assertion=0x5843098f28a0 "pause_seqno_.is_undefined() == false", file=0x5843098f2358 "/test/12.2_dbg/wsrep-lib/src/server_state.cpp", line=587, function=0x5843098f2878 "void wsrep::server_state::resume()")at ./assert/assert.c:105
      #13 0x000058430916ce35 in wsrep::server_state::resume (this=0x584328f24cb0)at /test/12.2_dbg/wsrep-lib/src/server_state.cpp:587
      #14 0x0000584308740203 in Global_read_lock::unlock_global_read_lock (this=0x7b3638004b58, thd=0x7b3638000d58) at /test/12.2_dbg/sql/lock.cc:1196
      #15 0x0000584308378a41 in fix_read_only (self=0x58430a027a60 <Sys_readonly>, thd=0x7b3638000d58, type=SHOW_OPT_GLOBAL)at /test/12.2_dbg/sql/sys_vars.cc:3276
      #16 0x00005843080315d1 in sys_var::update (this=0x58430a027a60 <Sys_readonly>, thd=0x7b3638000d58, var=0x7b363801a080)at /test/12.2_dbg/sql/set_var.cc:212
      #17 0x000058430803351a in set_var::update (this=0x7b363801a080, thd=0x7b3638000d58) at /test/12.2_dbg/sql/set_var.cc:871
      #18 0x0000584308033028 in sql_set_variables (thd=0x7b3638000d58, var_list=0x7b3638006140, free=true) at /test/12.2_dbg/sql/set_var.cc:752
      #19 0x000058430816dd53 in mysql_execute_command (thd=0x7b3638000d58, is_called_from_prepared_stmt=false) at /test/12.2_dbg/sql/sql_parse.cc:4855
      #20 0x00005843081776b4 in mysql_parse (thd=0x7b3638000d58, rawbuf=0x7b3638019f50 "SET GLOBAL read_only=ON", length=23, parser_state=0x7b590054a2b0) at /test/12.2_dbg/sql/sql_parse.cc:7883
      #21 0x0000584308176db1 in wsrep_mysql_parse (thd=0x7b3638000d58, rawbuf=0x7b3638019f50 "SET GLOBAL read_only=ON", length=23, parser_state=0x7b590054a2b0) at /test/12.2_dbg/sql/sql_parse.cc:7693
      #22 0x0000584308164244 in dispatch_command (command=COM_QUERY, thd=0x7b3638000d58, packet=0x7b363800b2c9 "SET GLOBAL read_only=ON", packet_length=23, blocking=true) at /test/12.2_dbg/sql/sql_parse.cc:1865
      #23 0x0000584308162f0b in do_command (thd=0x7b3638000d58, blocking=true)at /test/12.2_dbg/sql/sql_parse.cc:1417
      #24 0x000058430835537a in do_handle_one_connection (connect=0x5843295f7828, put_in_cache=true) at /test/12.2_dbg/sql/sql_connect.cc:1414
      #25 0x0000584308355125 in handle_one_connection (arg=0x584329613738)at /test/12.2_dbg/sql/sql_connect.cc:1326
      #26 0x00007b60b249caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #27 0x00007b60b2529c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Galera Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
       
      CS  10.6   dbg  190925  764b893cb7f7492b587541fea1880cd7cc91d743  No bug found
      CS  10.6   opt  190925  764b893cb7f7492b587541fea1880cd7cc91d743  No bug found
      CS  10.11  dbg  190925  62b21714d0bab340872de0aec572cce5b5dd3b09  No bug found
      CS  10.11  opt  190925  62b21714d0bab340872de0aec572cce5b5dd3b09  No bug found
      CS  11.4   opt  190925  acd3db4e44648d55387e51052a9dbd7e63b2c0d1  No bug found  
      CS  11.4   dbg  190925  acd3db4e44648d55387e51052a9dbd7e63b2c0d1  pause_seqno_.is_undefined() == false|SIGABRT|wsrep::server_state::resume|Global_read_lock::unlock_global_read_lock|fix_read_only|sys_var::update 
      CS  11.8   dbg  180925  d203a8a5df95e2c5778a304a885fb7aedfbc095e  pause_seqno_.is_undefined() == false|SIGABRT|wsrep::server_state::resume|Global_read_lock::unlock_global_read_lock|fix_read_only|sys_var::update
      CS  11.8   opt  180925  d203a8a5df95e2c5778a304a885fb7aedfbc095e  No bug found
      CS  12.1   dbg  190925  667c5e0b002a24bc595d60955950200a588f4fb7  pause_seqno_.is_undefined() == false|SIGABRT|wsrep::server_state::resume|Global_read_lock::unlock_global_read_lock|fix_read_only|sys_var::update
      CS  12.1   opt  190925  667c5e0b002a24bc595d60955950200a588f4fb7  No bug found
      CS  12.2   dbg  190925  b8a77289639a3b10ada64cf892f02b5cecdb1603  pause_seqno_.is_undefined() == false|SIGABRT|wsrep::server_state::resume|Global_read_lock::unlock_global_read_lock|fix_read_only|sys_var::update
      CS  12.2   opt  190925  b8a77289639a3b10ada64cf892f02b5cecdb1603  No bug found
      ES  10.6   dbg  060525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  pause_seqno_.is_undefined() == false|SIGABRT|wsrep::server_state::resume|Global_read_lock::unlock_global_read_lock|fix_read_only|sys_var::update
      ES  10.6   opt  060525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  No bug found
      ES  11.4   dbg  190925  0ddbffaced6c2b50ef4c6e0d8685b1fa25148875  pause_seqno_.is_undefined() == false|SIGABRT|wsrep::server_state::resume|Global_read_lock::unlock_global_read_lock|fix_read_only|sys_var::update
      ES  11.4   opt  190925  0ddbffaced6c2b50ef4c6e0d8685b1fa25148875  No bug found
      ES  11.8   dbg  190925  0d06f96e3bd9ccbe19f23876a7b3117054c3a0fd  pause_seqno_.is_undefined() == false|SIGABRT|wsrep::server_state::resume|Global_read_lock::unlock_global_read_lock|fix_read_only|sys_var::update
      ES  11.8   opt  190925  0d06f96e3bd9ccbe19f23876a7b3117054c3a0fd  No bug found
      

      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.