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