[MDEV-37695] Assertion `pause_seqno_.is_undefined() == false' failed in void wsrep::server_state::resume() - Jira

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 11.4, 11.8, 12.1, 12.2
Fix Version/s: 11.4, 11.8, 12.1
Component/s: Galera
Labels:
- debug

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

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

Details

Description

Attachments

Activity

People

Dates

Git Integration