Debian Codegraph @

mysql-test/suite/binlog/r/binlog_xa_recover_using_new_server_id.result

raw
1 ========= Set server_id to 99 and prepare test table.
2 SET GLOBAL server_id= 99;
3 CREATE TABLE t1 (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=Innodb;
4 ========= Crash the server.
5 SET SESSION debug_dbug="+d,crash_commit_after_log";
6 INSERT INTO t1 VALUES (1, NULL);
7 Got one of the listed errors
8 ========= Restart the server with default config file in which server_id= 1.
9 ========= Check that recover succeeds and server is up.
10 connection default;
11 ========= Check that all transactions are recovered.
12 SELECT a FROM t1 ORDER BY a;
13 a
14 1
15 ========= Cleanup.
16 connection default;
17 DROP TABLE t1;