File: log_crash.result

package info (click to toggle)
mysql-8.0 8.0.43-3
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 1,273,924 kB
  • sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (27 lines) | stat: -rw-r--r-- 984 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
# Initialize new data directory...
# Restart MySQL using the new data directory...
# restart: --datadir=tmp/log_crash --log-error=my_restart.err
# Prepare schema used in the tests.
# Ensure there is a lot of free space in the redo log.
SET GLOBAL innodb_log_checkpoint_now = ON;
# Disable checkpointing.
SET GLOBAL innodb_checkpoint_disabled = ON;
# Create connection which generates spam to the redo log.
CALL log_spammer();
# Create at least few redo records...
CREATE TABLE t (a INT) ENGINE=InnoDB;
INSERT INTO t(a) VALUES(42);
# Kill MySQL...
# Kill the server
# Start MySQL...
# Verify...
Pattern "Database was not shutdown normally" found
Pattern "Starting crash recovery" found
Pattern "Applying a batch of.*redo log records" found
Pattern "Apply batch completed" found
Pattern "innodb-unknown-compound-v" found
# Remove the data directory...
############################################################################################
# Cleanup...
# Start MySQL...
# restart: