Debian Codegraph @

mysql-test/suite/innodb/t/readonly.test

raw
1
2 --echo #
3 --echo # Bug#19904800 - MISSING DBUG_RETURN IN HA_INNOBASE::UPDATE_ROW
4 --echo #
5
6 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB;
7 CREATE TABLE t2(b int PRIMARY KEY) ENGINE=InnoDB;
8
9 INSERT INTO t1 VALUES(1);
10 INSERT INTO t2 VALUES(2);
11
12 --source include/restart_innodb_read_only.inc
13
14 --error ER_OPEN_AS_READONLY
15 UPDATE t1,t2 SET t1.a = 2, t2.b = 2 WHERE t1.a = 1;
16
17 # Restart in normal mode to drop tables
18 let $restart_parameters = restart;
19 --source include/restart_mysqld.inc
20
21 DROP TABLE t1;
22 DROP TABLE t2;
23
24 --echo #
25 --echo # Bug#20578834 - INNODB READ ONLY MODE AND NON EXISTENT TMP DIR CRASHES SERVER
26 --echo #
27
28 --disable_query_log
29 call mtr.add_suppression("Skip updating information_schema metadata in InnoDB read-only mode.");
30 call mtr.add_suppression("Skipped updating resource group metadata in InnoDB read only mode.");
31 --enable_query_log
32
33 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB;
34
35 INSERT INTO t1 VALUES(1);
36
37 --echo # Patch for bug#31377118 rejects startup if tmpdir does not exist.
38
39 # Get hold of data directory, assign a separate log file, stop server.
40 --let $MYSQLD_LOG= $MYSQLTEST_VARDIR/log/tmpdir_err.log
41 --let $MYSQLD_DATADIR= `SELECT @@datadir`
42 --source include/shutdown_mysqld.inc
43
44 # Start with an invalid tmpdir and search the error log for the error message.
45 --error 1,42,134,138,139,-1073741571,-1073741819,-1073740940
46 --exec $MYSQLD --no-defaults --secure-file-priv="" --basedir=$BASEDIR --lc-messages-dir=$MYSQL_SHAREDIR --log-error=$MYSQLD_LOG --datadir=$MYSQLD_DATADIR --tmpdir=no/such/directory > $MYSQLD_LOG 2>&1
47 --let $grep_file= $MYSQLD_LOG
48 --let $grep_pattern= No such file or directory
49 --let $grep_output= print_count
50 --source include/grep_pattern.inc
51
52 # Start in normal mode to drop tables
53 let $restart_parameters = restart;
54 --source include/start_mysqld.inc
55
56 SELECT * FROM t1;
57
58 DROP TABLE t1;
59
60
61 --echo #
62 --echo # Bug#21966795 "FK DEFINITIONS MISSING FROM SHOW CREATE TABLE IN
63 --echo # 'INNODB_READ_ONLY' MODE"
64 --echo #
65
66 CREATE TABLE parent(pk INT PRIMARY KEY);
67 CREATE TABLE child(fk INT, CONSTRAINT c FOREIGN KEY (fk) REFERENCES parent (pk));
68 SHOW CREATE TABLE child;
69
70 --source include/restart_innodb_read_only.inc
71
72 --echo # SHOW CREATE TABLE should still show foreign keys.
73 SHOW CREATE TABLE child;
74
75 --echo # Clean-up.
76 let $restart_parameters = restart;
77 --source include/restart_mysqld.inc
78
79 DROP TABLES child, parent;