Debian Codegraph @

mysql-test/suite/innodb/r/log_crash.result

raw
1 # Initialize new data directory...
2 # Restart MySQL using the new data directory...
3 # restart: --datadir=tmp/log_crash --log-error=my_restart.err
4 # Prepare schema used in the tests.
5 # Ensure there is a lot of free space in the redo log.
6 SET GLOBAL innodb_log_checkpoint_now = ON;
7 # Disable checkpointing.
8 SET GLOBAL innodb_checkpoint_disabled = ON;
9 # Create connection which generates spam to the redo log.
10 CALL log_spammer();
11 # Create at least few redo records...
12 CREATE TABLE t (a INT) ENGINE=InnoDB;
13 INSERT INTO t(a) VALUES(42);
14 # Kill MySQL...
15 # Kill the server
16 # Start MySQL...
17 # Verify...
18 Pattern "Database was not shutdown normally" found
19 Pattern "Starting crash recovery" found
20 Pattern "Applying a batch of.*redo log records" found
21 Pattern "Apply batch completed" found
22 Pattern "innodb-unknown-compound-v" found
23 # Remove the data directory...
24 ############################################################################################
25 # Cleanup...
26 # Start MySQL...
27 # restart: