galera.galera_sequences                  w1 [ fail ]

        Test ended at 2025-01-24 21:44:25

CURRENT_TEST: galera.galera_sequences

mysqltest: At line 203: 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 /dev/shm/var/1/log/galera_sequences.log

Server [mysqld.1 - pid: 57162, winpid: 57162, exit: 256] failed during test run

Server log from this test:

----------SERVER LOG START-----------

...

2025-01-24 21:43:46 2 [ERROR] Slave SQL: Error 'Unknown table 'test.t1'' on query. Default database: 'test'. Query: 'DROP TABLE t1', Internal MariaDB error code: 1051

2025-01-24 21:43:46 2 [Warning] WSREP: Ignoring error 'Unknown table 'test.t1'' on query. Default database: 'test'. Query: 'DROP TABLE t1', Error_code: 1051

2025-01-24 21:43:46 2 [ERROR] Slave SQL: Error 'Unknown SEQUENCE: 'test.sq2'' on query. Default database: 'test'. Query: 'DROP SEQUENCE sq2', Internal MariaDB error code: 4091

2025-01-24 21:43:46 2 [Warning] WSREP: Ignoring error 'Unknown SEQUENCE: 'test.sq2'' on query. Default database: 'test'. Query: 'DROP SEQUENCE sq2', Error_code: 4091

2025-01-24 21:43:46 12 [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

2025-01-24 21:43:46 12 [ERROR] WSREP: FSM: no such a transition REPLICATING -> COMMITTED

250124 21:43:46 [ERROR] /usr/sbin/mariadbd got signal 6 ;