[Draft] Galera node hits WSREP: FSM: no such a transition CERTIFYING -> COMMITTED and crashes

2026-04-02 15:38:15 29 [ERROR] WSREP: FSM: no such a transition CERTIFYING -> COMMITTED

260402 15:38:15 [ERROR] /data/bld/main-rel/sql/mysqld got signal 6 ;

#6  0x00007fd7d4766472 in __GI_abort () at ./stdlib/abort.c:79

#7  0x00007fd7d3853eff in galera::FSM<galera::TrxHandle::State, galera::TrxHandle::Transition>::shift_to (this=this@entry=0x77d72c078c68, state=state@entry=galera::TrxHandle::S_COMMITTED, line=line@entry=1448) at ./galera/src/fsm.hp

p:56

#8  0x00007fd7d387883f in galera::TrxHandle::set_state (line=1448, state=galera::TrxHandle::S_COMMITTED, this=0x77d72c078c60) at ./galera/src/trx_handle.hpp:222

#9  galera::TrxHandleSlave::set_state (line=1448, state=galera::TrxHandle::S_COMMITTED, this=0x77d72c078c60) at ./galera/src/trx_handle.hpp:603

#10 galera::ReplicatorSMM::commit_order_leave (this=this@entry=0x5625e0f65b40, ts=..., error=error@entry=0x7fd7cbeceec0) at ./galera/src/replicator_smm.cpp:1448

#11 0x00007fd7d384ff64 in galera_commit_order_leave (gh=<optimized out>, ws_handle=<optimized out>, meta=<optimized out>, error=0x7fd7cbeceec0) at ./galera/src/wsrep_provider.cpp:836

#12 0x00005625d88ac40c in wsrep::wsrep_provider_v26::commit_order_leave (this=<optimized out>, ws_handle=..., ws_meta=..., err=...) at /data/bld/main-rel/wsrep-lib/src/wsrep_provider_v26.cpp:1020

#13 0x00005625d88a6395 in wsrep::transaction::ordered_commit (this=this@entry=0x77d738007810) at /data/bld/main-rel/wsrep-lib/src/transaction.cpp:588

#14 0x00005625d8889879 in wsrep::client_state::ordered_commit (this=this@entry=0x77d7380077a8) at /data/bld/main-rel/wsrep-lib/src/client_state.cpp:395

#15 0x00005625d820158f in wsrep_ordered_commit (all=<optimized out>, thd=0x77d738000c68) at /data/bld/main-rel/sql/wsrep_trans_observer.h:384

#16 MYSQL_BIN_LOG::queue_for_group_commit (this=this@entry=0x5625d9322a20 <mysql_bin_log>, orig_entry=orig_entry@entry=0x7fd7cbecf050) at /data/bld/main-rel/sql/log.cc:10502

#17 0x00005625d8206b2c in MYSQL_BIN_LOG::write_transaction_with_group_commit (this=this@entry=0x5625d9322a20 <mysql_bin_log>, entry=entry@entry=0x7fd7cbecf050) at /data/bld/main-rel/sql/log.cc:10548

#18 0x00005625d8207b2f in MYSQL_BIN_LOG::write_transaction_to_binlog_events (entry=0x7fd7cbecf050, this=0x5625d9322a20 <mysql_bin_log>) at /data/bld/main-rel/sql/log.cc:10534

#19 MYSQL_BIN_LOG::write_transaction_to_binlog (this=this@entry=0x5625d9322a20 <mysql_bin_log>, thd=thd@entry=0x77d738000c68, cache_mngr=cache_mngr@entry=0x77d73802e3a8, end_ev=end_ev@entry=0x7fd7cbecf170, all=all@entry=false, using

_stmt_cache=using_stmt_cache@entry=false, using_trx_cache=<optimized out>, is_ro_1pc=<optimized out>) at /data/bld/main-rel/sql/log.cc:10161

#20 0x00005625d8208b29 in binlog_flush_cache (is_ro_1pc=false, using_trx=true, using_stmt=false, all=false, end_ev=0x7fd7cbecf170, cache_mngr=0x77d73802e3a8, thd=0x77d738000c68) at /data/bld/main-rel/sql/log.cc:2215

#21 binlog_rollback_flush_trx_cache (thd=thd@entry=0x77d738000c68, all=all@entry=false, cache_mngr=cache_mngr@entry=0x77d73802e3a8) at /data/bld/main-rel/sql/log.cc:2454

#22 0x00005625d820a147 in binlog_rollback (thd=thd@entry=0x77d738000c68, all=all@entry=false) at /data/bld/main-rel/sql/log.cc:3089

#23 0x00005625d80b952d in ha_rollback_trans (thd=thd@entry=0x77d738000c68, all=all@entry=false) at /data/bld/main-rel/sql/handler.cc:2392

#24 0x00005625d7f60aff in trans_rollback_stmt (thd=0x77d738000c68) at /data/bld/main-rel/sql/transaction.cc:567

#25 0x00005625d7dc4c53 in select_create::abort_result_set (this=0x77d7380157f0) at /data/bld/main-rel/sql/sql_insert.cc:5743

#26 0x00005625d7dca671 in select_create::send_eof (this=0x77d7380157f0) at /data/bld/main-rel/sql/sql_insert.cc:5480

#27 0x00005625d7e90b3b in do_select (procedure=<optimized out>, join=0x77d738015938) at /data/bld/main-rel/sql/sql_select.cc:24143

#28 JOIN::exec_inner (this=this@entry=0x77d738015938) at /data/bld/main-rel/sql/sql_select.cc:5125

#29 0x00005625d7e90e05 in JOIN::exec (this=this@entry=0x77d738015938) at /data/bld/main-rel/sql/sql_select.cc:4913

#30 0x00005625d7e8f215 in mysql_select (thd=thd@entry=0x77d738000c68, tables=<optimized out>, fields=..., conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=<optimized out>, having=<optimized out>, proc_para

m=<optimized out>, select_options=<optimized out>, result=<optimized out>, unit=<optimized out>, select_lex=<optimized out>) at /data/bld/main-rel/sql/sql_select.cc:5439

#31 0x00005625d7e8f9a4 in handle_select (thd=thd@entry=0x77d738000c68, lex=lex@entry=0x77d7380050c8, result=result@entry=0x77d7380157f0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/bld/main-rel/sql/sql_select.cc:636

#32 0x00005625d7ed6116 in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x77d738000c68) at /data/bld/main-rel/sql/sql_table.cc:13845

#33 0x00005625d7e08b26 in mysql_execute_command (thd=thd@entry=0x77d738000c68, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/main-rel/sql/sql_parse.cc:5902

#34 0x00005625d7e0d446 in mysql_parse (thd=thd@entry=0x77d738000c68, rawbuf=rawbuf@entry=0x77d738013450 "/* WRK-1 QNO 3569 */  CREATE OR REPLACE TABLE `CreateOrReplaceTable` AS SELECT * FROM `simple_db`.`CreateOrReplaceTable` LIMIT 

40761", length=length@entry=132, parser_state=parser_state@entry=0x7fd7cbed23a0) at /data/bld/main-rel/sql/sql_parse.cc:7941

#35 0x00005625d7e0dc3c in wsrep_mysql_parse (thd=0x77d738000c68, rawbuf=0x77d738013450 "/* WRK-1 QNO 3569 */  CREATE OR REPLACE TABLE `CreateOrReplaceTable` AS SELECT * FROM `simple_db`.`CreateOrReplaceTable` LIMIT 40761", length=13

2, parser_state=0x7fd7cbed23a0) at /data/bld/main-rel/sql/sql_parse.cc:7751

#36 0x00005625d7e10bca in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x77d738000c68, packet=packet@entry=0x77d738008d59 "/* WRK-1 QNO 3569 */  CREATE OR REPLACE TABLE `CreateOrReplaceTable` AS SELECT * FROM `si

mple_db`.`CreateOrReplaceTable` LIMIT 40761", packet_length=packet_length@entry=132, blocking=blocking@entry=true) at /data/bld/main-rel/sql/sql_class.h:286

#37 0x00005625d7e114bf in do_command (thd=thd@entry=0x77d738000c68, blocking=blocking@entry=true) at /data/bld/main-rel/sql/sql_parse.cc:1432

#38 0x00005625d7f4dad5 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5625e15ffe68, put_in_cache=put_in_cache@entry=true) at /data/bld/main-rel/sql/sql_connect.cc:1503

#39 0x00005625d7f4de2d in handle_one_connection (arg=arg@entry=0x5625e15ffe68) at /data/bld/main-rel/sql/sql_connect.cc:1415

#40 0x00005625d834cdcc in pfs_spawn_thread (arg=0x5625e1646b68) at /data/bld/main-rel/storage/perfschema/pfs.cc:2198

Connection ID (thread ID): 29

Status: NOT_KILLED

Query (0x77d738013450): /* WRK-1 QNO 3569 */  CREATE OR REPLACE TABLE `CreateOrReplaceTable` AS SELECT * FROM `simple_db`.`CreateOrReplaceTable` LIMIT 40761

2026-04-02 13:39:08 29 [ERROR] WSREP: FSM: no such a transition COMMITTED -> COMMITTED

perl ./run.pl --base-port=14000 --basedir=/data/bld/main-rel --compatibility=130099 --duration=200 --engine=InnoDB --filter=conf/ff/replication.ff --gendata=data/sql/vector_deep_image_96_10K.sql --gendata=data/sql/vector_gist_960_1K.sql --gendata=simple --grammar=conf/preview/cor.yy:2 --grammar=conf/yy/all_selects.yy:0.0001 --grammar=conf/yy/replication.yy --grammar=conf/yy/sequences.yy --grammar=conf/yy/vector.yy --mysqld=--autocommit=OFF --mysqld=--concurrent_insert=NEVER --mysqld=--innodb-lock-wait-timeout=5 --mysqld=--innodb_checksum_algorithm=strict_crc32 --mysqld=--lock-wait-timeout=10 --mysqld=--log-bin --mysqld=--max-statement-time=20 --mysqld=--mhnsw_default_distance=euclidean --mysqld=--mhnsw_ef_search=100 --mysqld=--plugin-maturity=experimental --mysqld=--profiling_history_size=100 --mysqld=--system_versioning_insert_history=ON --queries=1000000 --reporters=Backtrace,Deadlock,FeatureUsage,UniqueConstraintValidity --reporters=OrphanFiles --scenario=Galera   --threads=3 --vardir=/ssd/logs/var-acor-445-1-main --variator=Distinct --variator=ExecuteAsDerived --variator=ExecuteAsExecuteImmediate --seed=1775054132 --user=root