galera.galera_sequences [ pass ] 31663 galera.galera_sequences [ 2 pass ] 27514 galera.galera_sequences [ 3 pass ] 34150 galera.galera_sequences [ 4 pass ] 27946 galera.galera_sequences [ 5 fail ] Test ended at 2025-01-28 03:59:08 CURRENT_TEST: galera.galera_sequences mysqltest: At line 204: query 'INSERT INTO t1(b) values (1)' failed with wrong errno <Unknown> (2013): 'Lost connection to server during query', instead of (0)... The result from queries just before the failure was: < snip > CREATE SEQUENCE t INCREMENT BY 1 NOCACHE ENGINE=INNODB; CREATE TABLE t1(a int not null primary key default nextval(t), b int) engine=innodb; connection node_2; # Wait DDL to replicate connection node_1; SELECT @@auto_increment_increment; @@auto_increment_increment 2 SELECT @@auto_increment_offset; @@auto_increment_offset 1 SET SESSION wsrep_sync_wait=0; connection node_2; SELECT @@auto_increment_increment; @@auto_increment_increment 2 SELECT @@auto_increment_offset; @@auto_increment_offset 2 SET SESSION wsrep_sync_wait=0; More results from queries before failure can be found in /home/panda/maria-10.6/build/mysql-test/var/log/galera_sequences.log Server [mysqld.1 - pid: 2701065, winpid: 2701065, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2025-01-28 3:58:41 38 [Warning] WSREP: Ignoring error 'This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'' on query. Default database: 'test'. Query: 'alter table Seq1_1 engine=myisam', Error_code: 1235 2025-01-28 3:58:44 0 [Note] WSREP: Member 1.0 (panda) desyncs itself from group 2025-01-28 3:58:44 0 [Note] WSREP: Member 1.0 (panda) resyncs itself to group. 2025-01-28 3:58:44 0 [Note] WSREP: Member 1.0 (panda) synced with group. 2025-01-28 3:58:44 0 [Note] WSREP: Member 1.0 (panda) desyncs itself from group 2025-01-28 3:58:44 0 [Note] WSREP: Member 1.0 (panda) resyncs itself to group. 2025-01-28 3:58:44 0 [Note] WSREP: Member 1.0 (panda) synced with group. 2025-01-28 3:58:44 1 [ERROR] Slave SQL: Error 'Unknown table 'test.t1'' on query. Default database: 'test'. Query: 'DROP TABLE t1', Internal MariaDB error code: 1051 2025-01-28 3:58:44 1 [Warning] WSREP: Ignoring error 'Unknown table 'test.t1'' on query. Default database: 'test'. Query: 'DROP TABLE t1', Error_code: 1051 2025-01-28 3:58:45 1 [ERROR] Slave SQL: Error 'Unknown SEQUENCE: 'test.sq2'' on query. Default database: 'test'. Query: 'DROP SEQUENCE sq2', Internal MariaDB error code: 4091 2025-01-28 3:58:45 1 [Warning] WSREP: Ignoring error 'Unknown SEQUENCE: 'test.sq2'' on query. Default database: 'test'. Query: 'DROP SEQUENCE sq2', Error_code: 4091 2025-01-28 3:58:51 38 [Warning] WSREP: Ignoring error 'This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'' on query. Default database: 'test'. Query: 'ALTER TABLE t ENGINE=MyISAM', Error_code: 1235 mariadbd: /home/panda/maria-10.6/wsrep-lib/src/transaction.cpp:579: int wsrep::transaction::ordered_commit(): Assertion `state() == s_committing' failed. 250128 3:58:56 [ERROR] mysqld 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 We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.6.21-17-MariaDB-debug-log source revision: 2b68eff224194f1f291f341519b7f6ef3c7b2862 key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=2 max_threads=153 thread_count=4 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63959 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. WSREP: Suppressing further logging WSREP: Shutting down network communications Thread pointer: 0x7face4000dc8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7fad175b5000 thread_stack 0x49000 mysys/stacktrace.c:215(my_print_stacktrace)[0x55e6d8efa0ca] sql/signal_handler.cc:247(handle_fatal_signal)[0x55e6d84e1bd8] libc_sigaction.c:0(__restore_rt)[0x7fad3f08d520] nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7fad3f0e19fc] posix/raise.c:27(__GI_raise)[0x7fad3f08d476] stdlib/abort.c:81(__GI_abort)[0x7fad3f0737f3] intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fad3f07371b] /lib/x86_64-linux-gnu/libc.so.6(+0x39e96)[0x7fad3f084e96] src/transaction.cpp:580(wsrep::transaction::ordered_commit())[0x55e6d91588fa] src/client_state.cpp:396(wsrep::client_state::ordered_commit())[0x55e6d9133eff] 2025-01-28 3:58:57 0 [Note] WSREP: (74a95803-a383, 'ssl://0.0.0.0:19062') turning message relay requesting on, nonlive peers: ssl://127.0.0.1:19065 sql/wsrep_trans_observer.h:465(wsrep_ordered_commit(THD*, bool))[0x55e6d863ad77] sql/log.cc:8166(MYSQL_BIN_LOG::queue_for_group_commit(MYSQL_BIN_LOG::group_commit_entry*))[0x55e6d8653133] sql/log.cc:8193(MYSQL_BIN_LOG::write_transaction_to_binlog_events(MYSQL_BIN_LOG::group_commit_entry*))[0x55e6d8653318] sql/log.cc:7825(MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool, bool))[0x55e6d86525fa] sql/log.cc:1781(binlog_flush_cache(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool, bool))[0x55e6d863edfd] sql/log.cc:1834(binlog_commit_flush_stmt_cache(THD*, bool, binlog_cache_mngr*))[0x55e6d863f1cd] sql/log.cc:2301(binlog_rollback(handlerton*, THD*, bool))[0x55e6d8640cdd] 2025-01-28 3:58:58 0 [Note] WSREP: Failed to establish connection: Operation aborted. sql/handler.cc:2300(ha_rollback_trans(THD*, bool))[0x55e6d84ea174] sql/handler.cc:2051(ha_commit_trans(THD*, bool))[0x55e6d84e9622] 2025-01-28 3:58:58 0 [Note] WSREP: (74a95803-a383, 'ssl://0.0.0.0:19062') reconnecting to 756ee710-b1d7 (ssl://127.0.0.1:19065), attempt 0 sql/transaction.cc:497(trans_commit_stmt(THD*))[0x55e6d82ec54d] sql/sql_parse.cc:6227(mysql_execute_command(THD*, bool))[0x55e6d80dd133] sql/sql_parse.cc:8221(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55e6d80e3298] sql/sql_parse.cc:8043(wsrep_mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55e6d80e27ab] sql/sql_parse.cc:1902(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55e6d80ce111] sql/sql_parse.cc:1428(do_command(THD*, bool))[0x55e6d80ccb14] sql/sql_connect.cc:1407(do_handle_one_connection(CONNECT*, bool))[0x55e6d82cb992] sql/sql_connect.cc:1321(handle_one_connection)[0x55e6d82cb70c] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55e6d8851a6e] nptl/pthread_create.c:442(start_thread)[0x7fad3f0dfac3] x86_64/clone3.S:83(__clone3)[0x7fad3f171850] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7face4014670): INSERT INTO t1(b) values (1) Connection ID (thread ID): 38 Status: KILL_QUERY 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,sargable_casefold=off The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /home/panda/maria-10.6/build/mysql-test/var/mysqld.1/data Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size unlimited unlimited bytes Max resident set unlimited unlimited bytes Max processes 63453 63453 processes Max open files 1024 1024 files Max locked memory 2094178304 2094178304 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 63453 63453 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -- %E Kernel version: Linux version 5.15.0-118-generic (buildd@lcy02-amd64-080) (gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #128-Ubuntu SMP Fri Jul 5 09:28:59 UTC 2024 ----------SERVER LOG END------------- - saving '/home/panda/maria-10.6/build/mysql-test/var/log/galera.galera_sequences/' to '/home/panda/maria-10.6/build/mysql-test/var/log/galera.galera_sequences/' ***Warnings generated in error logs during shutdown after running tests: galera.galera_sequences mariadbd: /home/panda/maria-10.6/wsrep-lib/src/transaction.cpp:579: int wsrep::transaction::ordered_commit(): Assertion `state() == s_committing' failed. Attempting backtrace. You can use the following information to find out galera.galera_sequences [ 6 pass ] 29087 galera.galera_sequences CURRENT_TEST: galera.galera_sequences CURRENT_TEST: galera.galera_sequences CURRENT_TEST: galera.galera_sequences CURRENT_TEST: galera.galera_sequences mysqltest: At line 204: query 'INSERT INTO t1(b) values (1)' failed with wrong errno <Unknown> (2013): 'Lost connection to server during query', instead of (0)... The result from queries just before the failure was: < snip > CREATE SEQUENCE t INCREMENT BY 1 NOCACHE ENGINE=INNODB; CREATE TABLE t1(a int not null primary key default nextval(t), b int) engine=innodb; connection node_2; # Wait DDL to replicate connection node_1; SELECT @@auto_increment_increment; @@auto_increment_increment 2 SELECT @@auto_increment_offset; @@auto_increment_offset 1 SET SESSION wsrep_sync_wait=0; connection node_2; SELECT @@auto_increment_increment; @@auto_increment_increment 2 SELECT @@auto_increment_offset; @@auto_increment_offset 2 SET SESSION wsrep_sync_wait=0; More results from queries before failure can be found in /home/panda/maria-10.6/build/mysql-test/var/log/galera_sequences.log CURRENT_TEST: galera.galera_sequences [ fail ] Test ended at 2025-01-28 04:00:16