| 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; |