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