WSREP: FSM: no such a transition COMMITTED -> COMMITTED

2026-03-23 10:37:26 497206 [ERROR] WSREP: FSM: no such a transition COMMITTED -> COMMITTED
260323 10:37:26 [ERROR] /usr/sbin/mariadbd got signal 6 ;
Sorry, we probably made a mistake, and this is a bug.

Your assistance in bug reporting will enable us to fix this for the next release.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
a bug on https://jira.mariadb.org/.

Please include the information from the server start above, to the end of the
information below.

Server version: 10.11.15-MariaDB-log source revision: cb0d6dd835023a7162ace471cd047161f205dd58

WSREP: Suppressing further logging
WSREP: Shutting down network communications

The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
contains instructions to obtain a better version of the backtrace below.
Following these instructions will help MariaDB developers provide a fix quicker.

Attempting backtrace. Include this in the bug report.
(note: Retrieving this information may fail)

Thread pointer: 0x56505bf8e018
stack_bottom = 0x7f21c7c67000 thread_stack 0x49000
/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x565041c8a6be]
/usr/sbin/mariadbd(handle_fatal_signal+0x2fd)[0x565041745cdd]
/lib64/libpthread.so.0(+0x12990)[0x7f27df9c1990]
/lib64/libc.so.6(gsignal+0x10f)[0x7f27deaf45af]
/lib64/libc.so.6(abort+0x127)[0x7f27deac7ee5]
/usr/lib64/galera-4/libgalera_smm.so(+0x50ee5)[0x7f27dc9edee5]
/usr/lib64/galera-4/libgalera_smm.so(+0x79b9f)[0x7f27dca16b9f]
/usr/lib64/galera-4/libgalera_smm.so(+0x4b5eb)[0x7f27dc9e85eb]
/usr/sbin/mariadbd(_ZN5wsrep18wsrep_provider_v2618commit_order_leaveERKNS_9ws_handleERKNS_7ws_metaERKNS_14mutable_bufferE+0x7c)[0x565041d4f27c]
/usr/sbin/mariadbd(_ZN5wsrep11transaction14ordered_commitEv+0xa5)[0x565041d46a35]
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG22queue_for_group_commitEPNS_18group_commit_entryE+0x3fa)[0x5650418671da]
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG34write_transaction_to_binlog_eventsEPNS_18group_commit_entryE+0x1a)[0x5650418675ea]
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG27write_transaction_to_binlogEP3THDP17binlog_cache_mngrP9Log_eventbbbb+0x27a)[0x565041867bca]
/usr/sbin/mariadbd(+0xbb8c98)[0x565041867c98]
/usr/sbin/mariadbd(+0xbb9f09)[0x565041868f09]
/usr/sbin/mariadbd(_Z13binlog_commitP3THDbb+0x2ae)[0x5650418693ae]
/usr/sbin/mariadbd(+0xa9ab90)[0x565041749b90]
/usr/sbin/mariadbd(_Z15ha_commit_transP3THDb+0x6de)[0x56504174ac5e]
/usr/sbin/mariadbd(_Z12trans_commitP3THD+0xa6)[0x5650416269d6]
/usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x32a7)[0x5650414eee79]
/usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x24d)[0x5650414dcc21]
/usr/sbin/mariadbd(+0x82d5db)[0x5650414dc5db]
/usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x287e)[0x5650414ea67a]
/usr/sbin/mariadbd(_Z10do_commandP3THDb+0x138)[0x5650414eae31]
/usr/sbin/mariadbd(_Z11tp_callbackP13TP_connection+0x83)[0x5650416ced63]
/usr/sbin/mariadbd(+0xc192f0)[0x5650418c82f0]
/usr/sbin/mariadbd(+0xcb93f5)[0x5650419683f5]
/lib64/libpthread.so.0(+0x81ca)[0x7f27df9b71ca]
/lib64/libc.so.6(clone+0x43)[0x7f27deadf953]

Connection ID (thread ID): 497206
Status: NOT_KILLED
Query (0x56505988e030): COMMIT

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off

Writing a core file...
Working directory at /u01/mydata/wfselink_ebltdbs
Resource Limits (excludes unlimited resources):
Limit Soft Limit Hard Limit Units
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max processes 127287 127287 processes
Max open files 1048576 1048576 files
Max locked memory 65536 65536 bytes
Max pending signals 127287 127287 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e
-----------

general.log 497206
SET SESSION autocommit=0;
SAVEPOINT `_AP_1`
SELECT MAX(ic_id) ic_id FROM abc WHERE ID = '123456'
select ic_id,ACCT_NO,ACCT_NO_TYPE,HKID,LINKUP_STATUS,SEQ_NO,SUSPEND_IND,RECV_HARDCOPY,RECV_SMS from abc where REC_ID = 9798
select 1 from def A where A.DN_ID = '1333616' and A.SCHEME_TYPE = 'pukljk' and not exists (select 1 from def B where A.DN_REF_NO = B.DN_REF_NO and A.SCHEME_TYPE = B.SCHEME_TYPE and cast(B.DN_ID as decimal(15,0)) > cast(A.DN_ID as decimal(15,0)))
select now()
select nextVal(SEQ_ABC)
SAVEPOINT `_AP_1`
SELECT MAX(ic_id) ic_id FROM abc WHERE HKID = '123456'
select ic_id,ACCT_NO,ACCT_NO_TYPE,HKID,LINKUP_STATUS,SEQ_NO,SUSPEND_IND,RECV_HARDCOPY,RECV_SMS from abc where REC_ID = 3333
select 1 from def A where A.DN_ID = '18999777nd A.SCHEME_TYPE = 'ADLK' and not exists (select 1 from def B where A.DN_REF_NO = B.DN_REF_NO and A.SCHEME_TYPE = B.SCHEME_TYPE and cast(B.DN_ID as decimal(15,0)) > cast(A.DN_ID as decimal(15,0)))
select now()
select nextVal(SEQ_ABC)
COMMIT

CREATE SEQUENCE `SEQ_ABC` start with 1 minvalue 1 maxvalue 99999 increment by 0 nocache cycle ENGINE=InnoDB