Debian Codegraph @

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

raw
1 SET GLOBAL innodb_file_per_table=0;
2 Warnings:
3 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
4 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
5 # restart: --innodb-log-file-size=4m
6 CHECK TABLE t1;
7 Table Op Msg_type Msg_text
8 test.t1 check status OK
9 # restart: --innodb-log-file-size=20M
10 BEGIN;
11 INSERT INTO t1 VALUES (42);
12 # restart: --innodb-log-file-size=12M
13 SELECT * FROM t1;
14 a
15 INSERT INTO t1 VALUES (42);
16 BEGIN;
17 DELETE FROM t1;
18 # restart: --innodb-log-file-size=5M
19 SELECT * FROM t1;
20 a
21 42
22 INSERT INTO t1 VALUES (0),(123);
23 BEGIN;
24 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
25 INSERT INTO t1 VALUES (124),(125),(126),(127),(128),(129);
26 DELETE FROM t1 WHERE a>0;
27 # Persist the state of the above incomplete transaction by
28 # causing a redo log write for another transaction.
29 connect con1, localhost, root;
30 SET GLOBAL innodb_flush_log_at_trx_commit=1;
31 DELETE FROM t1 WHERE a=0;
32 disconnect con1;
33 connection default;
34 # Kill the server
35 # restart: --innodb-log-group-home-dir=foo\;bar
36 SELECT * FROM t1;
37 ERROR 42000: Unknown storage engine 'InnoDB'
38 FOUND 1 /syntax error in innodb_log_group_home_dir/ in mysqld.1.err
39 # restart: --debug-dbug=d,innodb_log_abort_1
40 SELECT * FROM t1;
41 ERROR 42000: Unknown storage engine 'InnoDB'
42 FOUND 1 /InnoDB: Starting crash recovery from checkpoint LSN=.*/ in mysqld.1.err
43 # restart: --innodb-log-file-size=5M
44 SELECT * FROM t1;
45 a
46 42
47 123
48 # restart: --debug-dbug=d,innodb_log_abort_5
49 SELECT * FROM t1;
50 ERROR 42000: Unknown storage engine 'InnoDB'
51 FOUND 1 /redo log from 5\.000MiB to [0-9.]*[KMGT]iB/ in mysqld.1.err
52 # restart
53 SELECT * FROM t1;
54 a
55 42
56 123
57 # restart
58 SELECT * FROM t1;
59 ERROR 42000: Unknown storage engine 'InnoDB'
60 FOUND 1 /InnoDB: File .*ib_logfile0 is too small/ in mysqld.1.err
61 # restart
62 SELECT * FROM t1;
63 ERROR 42000: Unknown storage engine 'InnoDB'
64 FOUND 1 /InnoDB: Expecting only ib_logfile0/ in mysqld.1.err
65 # restart
66 FOUND 1 /InnoDB: File .*ib_logfile0 was not found/ in mysqld.1.err
67 # restart
68 SELECT * FROM t1;
69 a
70 42
71 123
72 DROP TABLE t1;
73 FOUND 2 /InnoDB: Resizing redo log from 5\.000MiB to [0-9.]*[KMGT]iB; LSN=\d+\b/ in mysqld.1.err