mirror of
https://github.com/MariaDB/server.git
synced 2025-04-04 22:35:33 +02:00
b167730499
Problem was that initial GTID was set on wsrep_before_prepare out-of-order. In practice GTID was set to same as previous executed transaction GTID. In recovery valid GTID was found from prepared transaction and this transaction is committed leading to fact that same GTID was executed twice. This is fixed by setting invalid GTID at wsrep_before_prepare and later in wsrep_before_commit actual correct GTID is set and this setting is done while we are in commit monitor i.e. assigment is done in order of replication. In recovery if prepared transaction is found we check its GTID, if it is invalid transaction will be rolled back and if it is valid it will be committed. Initialize gtid seqno from recovered seqno when bootstrapping a new cluster. Added two test cases for both mariabackup and rsync SST methods to show that GTIDs remain consistent on cluster and that all expected rows are in the table. Added tests for wsrep GTID recovery with binlog on and off. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
28 lines
840 B
Text
28 lines
840 B
Text
# Test wsrep GTID recovery with binlog off. The test restarts the server
|
|
# and verifies that the GTID returned by SELECT WSREP_LAST_SEEN_GTID()
|
|
# gets initialized properly during server restart.
|
|
#
|
|
--source include/have_wsrep.inc
|
|
--source include/have_wsrep_provider.inc
|
|
--source include/have_innodb.inc
|
|
--source include/have_debug_sync.inc
|
|
|
|
CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
|
|
|
|
--echo # Case 1: Server goes through graceful shutdown and is restarted
|
|
--connection default
|
|
INSERT INTO t1 VALUES (1);
|
|
|
|
--echo Expect 100-10-2
|
|
SELECT WSREP_LAST_SEEN_GTID();
|
|
|
|
--source include/shutdown_mysqld.inc
|
|
--let $galera_wsrep_recover_server_id = 1
|
|
--source suite/galera/include/galera_wsrep_recover.inc
|
|
--source suite/galera/include/start_mysqld.inc
|
|
|
|
--echo Expect 100-10-2
|
|
SELECT WSREP_LAST_SEEN_GTID();
|
|
SELECT * FROM t1;
|
|
|
|
DROP TABLE t1;
|