Debian Codegraph @

mysql-test/suite/wsrep/t/wsrep-recover-gtid-nobinlog.test

raw
1 # Test wsrep GTID recovery with binlog off. The test restarts the server
2 # and verifies that the GTID returned by SELECT WSREP_LAST_SEEN_GTID()
3 # gets initialized properly during server restart.
4 #
5 --source include/have_wsrep.inc
6 --source include/have_wsrep_provider.inc
7 --source include/have_innodb.inc
8 --source include/have_debug_sync.inc
9
10 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
11
12 --echo # Case 1: Server goes through graceful shutdown and is restarted
13 --connection default
14 INSERT INTO t1 VALUES (1);
15
16 --echo Expect 100-10-2
17 SELECT WSREP_LAST_SEEN_GTID();
18
19 --source include/shutdown_mysqld.inc
20 --let $galera_wsrep_recover_server_id = 1
21 --source suite/galera/include/galera_wsrep_recover.inc
22 --source suite/galera/include/start_mysqld.inc
23
24 --echo Expect 100-10-2
25 SELECT WSREP_LAST_SEEN_GTID();
26 SELECT * FROM t1;
27
28 DROP TABLE t1;