[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.222.162.161: ~ $ 
SET GLOBAL innodb_file_per_table = 1;
SELECT @@innodb_file_per_table;
@@innodb_file_per_table
1
SET GLOBAL innodb_file_format = `Barracuda`;
SELECT @@innodb_file_format;
@@innodb_file_format
Barracuda
set global innodb_large_prefix=1;
SELECT @@innodb_large_prefix;
@@innodb_large_prefix
1
DROP DATABASE IF EXISTS testdb_wl6445;
CREATE DATABASE testdb_wl6445;
case # 1
USE testdb_wl6445;
CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB;
INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
CREATE USER 'test1'@'localhost' IDENTIFIED BY '123';
GRANT ALL ON testdb_wl6445.* TO 'test1'@'localhost';
CREATE USER 'test2'@'localhost' IDENTIFIED BY '123';
GRANT ALL ON *.* TO 'test2'@'localhost';
CREATE TABLE otherlocation (id int PRIMARY KEY) 
ENGINE=InnoDB , DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
INSERT INTO otherlocation VALUES (1),(2),(3);
SELECT * FROM otherlocation ORDER BY id;
id
1
2
3
SET GLOBAL innodb_file_per_table = 1;
SET GLOBAL innodb_file_format = `Barracuda`;
CREATE USER 'test3'@'localhost' IDENTIFIED BY '123';
GRANT ALL ON testdb_wl6445.* TO 'test3'@'localhost';
USE testdb_wl6445;
SELECT i FROM t1 ORDER BY i;
i
1
2
3
INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
# connection con_test1_user try to modify
SELECT user();
user()
test1@localhost
USE testdb_wl6445;
INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
CREATE TABLE t2 ( i int ,j blob) ENGINE = Innodb;
ERROR HY000: InnoDB is in read only mode.
UPDATE t1 SET i = i+1;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
# disconnect con_test1_user
# connection con_test2_user 
SELECT user();
user()
test2@localhost
USE testdb_wl6445;
INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb;
ERROR HY000: InnoDB is in read only mode.
UPDATE t1 SET i = i+1;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
FLUSH STATUS;
FLUSH LOGS;
FLUSH TABLES t1;
FLUSH TABLES WITH READ LOCK;
UNLOCK TABLES;
# disconnect con_test2_user
# connection default
USE testdb_wl6445;
INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb;
ERROR HY000: InnoDB is in read only mode.
UPDATE t1 SET i = i+1;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
INSERT INTO otherlocation VALUES (1),(2),(3);
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT * FROM otherlocation ORDER BY id;
id
1
2
3
FLUSH STATUS;
FLUSH LOGS;
FLUSH TABLES t1;
FLUSH TABLES WITH READ LOCK;
UNLOCK TABLES;
USE testdb_wl6445;
DROP USER 'test1'@'localhost';
DROP USER 'test2'@'localhost';
DROP USER 'test3'@'localhost';
DROP TABLE otherlocation;
DROP DATABASE testdb_wl6445;
case # 2
DROP DATABASE IF EXISTS testdb_wl6445;
CREATE DATABASE testdb_wl6445;
SET GLOBAL innodb_file_per_table = 1;
SET GLOBAL innodb_file_format = `Barracuda`;
USE testdb_wl6445;
CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB;
INSERT INTO t1 VALUES (1,repeat('a',4000)),(2,repeat('b',4000)),(3,repeat('c',4000));
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
START TRANSACTION;
SAVEPOINT A;
SAVEPOINT B;
ROLLBACK TO A;
"---commit first 50 records "
COMMIT;
SELECT COUNT(*) FROM testdb_wl6445.t1;
COUNT(*)
50
USE testdb_wl6445;
INSERT INTO t1 VALUES (211,repeat('a',200)),(212,repeat('b',200)),(213,repeat('c',200));
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i;
i	LEFT(j,20)
10	a10a10a10a10a10a10a1
20	a20a20a20a20a20a20a2
30	a30a30a30a30a30a30a3
40	a40a40a40a40a40a40a4
50	a50a50a50a50a50a50a5
CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb;
ERROR HY000: InnoDB is in read only mode.
UPDATE t1 SET i = i+1;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT i,LEFT(j,20) FROM t1  WHERE i%10=0  ORDER BY i;
i	LEFT(j,20)
10	a10a10a10a10a10a10a1
20	a20a20a20a20a20a20a2
30	a30a30a30a30a30a30a3
40	a40a40a40a40a40a40a4
50	a50a50a50a50a50a50a5
START TRANSACTION;
SET GLOBAL innodb_flush_log_at_trx_commit = 0;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SAVEPOINT A;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SAVEPOINT B;
ROLLBACK TO A;
"---commit first 50 records with innodb_flush_log_at_trx_commit = 0 --"
COMMIT;
SELECT i,LEFT(j,20) FROM t1  WHERE i%10=0  ORDER BY i;
i	LEFT(j,20)
10	a10a10a10a10a10a10a1
20	a20a20a20a20a20a20a2
30	a30a30a30a30a30a30a3
40	a40a40a40a40a40a40a4
50	a50a50a50a50a50a50a5
START TRANSACTION;
SET GLOBAL innodb_flush_log_at_trx_commit = 1;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SAVEPOINT A;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SAVEPOINT B;
ROLLBACK TO A;
"---commit first 50 records with innodb_flush_log_at_trx_commit = 1 --"
COMMIT;
SELECT i,LEFT(j,20) FROM t1  WHERE i%10=0  ORDER BY i;
i	LEFT(j,20)
10	a10a10a10a10a10a10a1
20	a20a20a20a20a20a20a2
30	a30a30a30a30a30a30a3
40	a40a40a40a40a40a40a4
50	a50a50a50a50a50a50a5
START TRANSACTION;
SET GLOBAL innodb_flush_log_at_trx_commit = 2;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SAVEPOINT A;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SAVEPOINT B;
ROLLBACK TO A;
"---commit first 50 records with innodb_flush_log_at_trx_commit = 2 --"
COMMIT;
FLUSH STATUS;
FLUSH LOGS;
FLUSH TABLES t1;
FLUSH TABLES WITH READ LOCK;
UNLOCK TABLES;
USE testdb_wl6445;
DROP DATABASE testdb_wl6445;
case # 3
DROP DATABASE IF EXISTS testdb_wl6445;
CREATE DATABASE testdb_wl6445;
USE testdb_wl6445;
CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB;
CREATE TABLE t2 ( t2_i int PRIMARY KEY , t2_j blob) ENGINE = InnoDB;
CREATE TABLE t3 ( i int PRIMARY KEY , j VARCHAR(20)) ENGINE = InnoDB;
CREATE TABLE t4 (val INT)
PARTITION BY LIST(val)(
PARTITION mypart_odd VALUES IN (1,3,5),
PARTITION MyPart_even VALUES IN (2,4,6));
INSERT INTO testdb_wl6445.t4 VALUES (1),(2),(3),(4),(5),(6);
SELECT * FROM testdb_wl6445.t4 ORDER BY val;
val
1
2
3
4
5
6
CREATE TRIGGER TRIGGER_1 BEFORE INSERT ON testdb_wl6445.t1 FOR EACH ROW BEGIN
INSERT INTO testdb_wl6445.t2 SET t2_i = NEW.i , t2_j = NEW.j;
END;//
CREATE PROCEDURE proc1 (OUT param1 INT)
BEGIN
SELECT COUNT(*) INTO param1 FROM testdb_wl6445.t1;
END;//
CREATE PROCEDURE proc2 (IN param1 INT,IN param2 VARCHAR(20))
BEGIN
INSERT INTO testdb_wl6445.t3 VALUES (param1,param2);
END;//
INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
SELECT t2_i,LEFT(t2_j,20) FROM t2 ORDER BY t2_i;
t2_i	LEFT(t2_j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
CALL proc1(@a);
SELECT @a;
@a
3
CALL proc2(1,'test1');
SELECT * FROM t3;
i	j
1	test1
SET GLOBAL innodb_file_per_table = 1;
SET GLOBAL innodb_file_format = `Barracuda`;
USE testdb_wl6445;
INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
SELECT t2_i,LEFT(t2_j,20) FROM t2 ORDER BY t2_i;
t2_i	LEFT(t2_j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
CALL proc1(@a);
SELECT @a;
@a
3
CALL proc2(2,'test2');
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT * FROM t3;
i	j
1	test1
CREATE TEMPORARY TABLE temp_1 ( i INT ) ENGINE = Innodb;
ERROR HY000: InnoDB is in read only mode.
INSERT INTO testdb_wl6445.t4 VALUES (1),(2),(3),(4),(5),(6);
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT * FROM testdb_wl6445.t4 ORDER BY val;
val
1
2
3
4
5
6
FLUSH STATUS;
FLUSH LOGS;
FLUSH TABLES t1,t2,t3;
FLUSH TABLES WITH READ LOCK;
UNLOCK TABLES;
USE testdb_wl6445;
DROP DATABASE testdb_wl6445;
case # 4
DROP DATABASE IF EXISTS testdb_wl6445;
CREATE DATABASE testdb_wl6445;
USE testdb_wl6445;
CREATE TABLE t1 ( i int PRIMARY KEY , j VARCHAR(300), FULLTEXT KEY (j)) ENGINE = InnoDB;
CREATE INDEX idx1 ON testdb_wl6445.t1(i);
INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
INSERT INTO t1 VALUES (4,'mysql database'),(5,'mysql database innodb support'),(6,'innodb engine');
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
4	mysql database
5	mysql database innod
6	innodb engine
SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ;
i	j
4	mysql database
5	mysql database innodb support
SET GLOBAL innodb_max_purge_lag = 10;
SET GLOBAL innodb_max_purge_lag_delay = 10;
SET GLOBAL innodb_purge_batch_size = 600;
SET GLOBAL relay_log_purge = 0;
SET GLOBAL innodb_change_buffer_max_size = 30;
SET GLOBAL innodb_change_buffering = 'changes';
SET GLOBAL innodb_print_all_deadlocks = 'ON';
USE testdb_wl6445;
INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
UPDATE t1 SET i = i + 1;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
DELETE FROM t1 ;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
SELECT @@innodb_max_purge_lag,@@innodb_max_purge_lag_delay,@@innodb_purge_batch_size,
@@innodb_purge_threads,@@relay_log_purge,@@innodb_buffer_pool_size,
@@innodb_change_buffer_max_size,@@innodb_change_buffering,@@innodb_print_all_deadlocks;
@@innodb_max_purge_lag	@@innodb_max_purge_lag_delay	@@innodb_purge_batch_size	@@innodb_purge_threads	@@relay_log_purge	@@innodb_buffer_pool_size	@@innodb_change_buffer_max_size	@@innodb_change_buffering	@@innodb_print_all_deadlocks
10	10	600	5	0	16777216	30	changes	1
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
4	mysql database
5	mysql database innod
6	innodb engine
SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ;
i	j
4	mysql database
5	mysql database innodb support
SELECT * FROM t1 WHERE MATCH (j) AGAINST ('innodb') ;
i	j
5	mysql database innodb support
6	innodb engine
USE testdb_wl6445;
DROP DATABASE testdb_wl6445;
case # 5
DROP DATABASE IF EXISTS testdb_wl6445;
CREATE DATABASE testdb_wl6445;
USE testdb_wl6445;
CREATE TABLE t1 ( i int PRIMARY KEY , j VARCHAR(300), FULLTEXT KEY (j)) ENGINE = InnoDB;
CREATE INDEX idx1 ON testdb_wl6445.t1(i);
INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
INSERT INTO t1 VALUES (4,'mysql database'),(5,'mysql database innodb support'),(6,'innodb engine');
SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ;
i	j
4	mysql database
5	mysql database innodb support
SELECT * FROM t1 WHERE MATCH (j) AGAINST ('innodb') ;
i	j
5	mysql database innodb support
6	innodb engine
USE testdb_wl6445;
INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
UPDATE t1 SET i = i + 20;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
DELETE FROM t1;
ERROR HY000: Can't lock file (errno: 165 - Table is read only)
CREATE TABLE t2 ( i INT ) ENGINE = Innodb;
ERROR HY000: InnoDB is in read only mode.
CREATE USER 'test5'@'localhost' IDENTIFIED BY '123';
GRANT ALL ON testdb_wl6445.* TO 'test5'@'localhost';
USE testdb_wl6445;
INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
4	mysql database
5	mysql database innod
6	innodb engine
11	aaaaaaaaaaaaaaaaaaaa
12	bbbbbbbbbbbbbbbbbbbb
13	cccccccccccccccccccc
UPDATE t1 SET i = i + 20;
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
21	aaaaaaaaaaaaaaaaaaaa
22	bbbbbbbbbbbbbbbbbbbb
23	cccccccccccccccccccc
24	mysql database
25	mysql database innod
26	innodb engine
31	aaaaaaaaaaaaaaaaaaaa
32	bbbbbbbbbbbbbbbbbbbb
33	cccccccccccccccccccc
DELETE FROM t1;
SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
i	LEFT(j,20)
CREATE TABLE t2 ( i INT ) ENGINE = Innodb;
CREATE USER 'test5_2'@'localhost' IDENTIFIED BY '123';
GRANT ALL ON testdb_wl6445.* TO 'test5_2'@'localhost';
USE testdb_wl6445;
DROP USER 'test5_2'@'localhost';
DROP USER 'test5'@'localhost';
DROP DATABASE testdb_wl6445;
case # 6
DROP DATABASE IF EXISTS testdb_wl6445;
CREATE DATABASE testdb_wl6445;
USE testdb_wl6445;
CREATE TABLE t1 ( i int PRIMARY KEY ) ENGINE = InnoDB;
CREATE INDEX idx1 ON testdb_wl6445.t1(i);
INSERT INTO t1 VALUES (1),(2),(3);
SELECT i FROM t1 ORDER BY i;
i
1
2
3
# Creating a temp sql file to be loaded.
USE testdb_wl6445;
: 1036, Table 't1' is read only, when using table: t1
SELECT i FROM t1 ORDER BY i;
i
1
2
3
USE testdb_wl6445;
DROP DATABASE testdb_wl6445;

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ innodb/ r/
Name Type Size Permission Actions
add_foreign_key.result File 1.28 KB 0644
alter_rename_existing.result File 2.96 KB 0644
analyze_table.result File 538 B 0644
autoinc_debug.result File 2.52 KB 0644
blob-update-debug.result File 489 B 0644
blob_redo.result File 1.1 KB 0644
bulk_create_index_online.result File 760 B 0644
checksum.result File 372 B 0644
create-index.result File 1.17 KB 0644
create_isl_with_direct.result File 328 B 0644
dropdb.result File 222 B 0644
end_range_check.result File 1.53 KB 0644
events-merge-tmp-path.result File 1.33 KB 0644
flush-hang.result File 1.27 KB 0644
foreign_key.result File 3.24 KB 0644
ibuf_not_empty.result File 1.01 KB 0644
import.result File 1.79 KB 0644
import_tablespace_schema_missmatch.result File 2.14 KB 0644
import_update_stats.result File 2.86 KB 0644
index_length.result File 1.44 KB 0644
index_tree_operation.result File 1.65 KB 0644
innodb-2byte-collation.result File 3.28 KB 0644
innodb-ac-non-locking-select.result File 861 B 0644
innodb-alter-autoinc.result File 4.46 KB 0644
innodb-alter-debug.result File 2.66 KB 0644
innodb-alter-discard.result File 1.18 KB 0644
innodb-alter-nullable.result File 1.59 KB 0644
innodb-alter-tempfile.result File 1.42 KB 0644
innodb-alter.result File 32.02 KB 0644
innodb-analyze.result File 58 B 0644
innodb-autoinc-18274.result File 805 B 0644
innodb-autoinc-44030.result File 722 B 0644
innodb-autoinc-56228.result File 847 B 0644
innodb-autoinc-optimize.result File 321 B 0644
innodb-autoinc.result File 39.22 KB 0644
innodb-blob.result File 3.76 KB 0644
innodb-bug-14068765.result File 3 KB 0644
innodb-bug-14084530.result File 898 B 0644
innodb-bug12552164.result File 1.73 KB 0644
innodb-bug14219515.result File 244 B 0644
innodb-change-buffer-recovery.result File 1.04 KB 0644
innodb-consistent.result File 670 B 0644
innodb-double-write.result File 8.72 KB 0644
innodb-index-debug.result File 2.87 KB 0644
innodb-index-online-delete.result File 642 B 0644
innodb-index-online-fk.result File 23.42 KB 0644
innodb-index-online-norebuild.result File 897 B 0644
innodb-index-online-purge.result File 1.2 KB 0644
innodb-index-online.result File 13.59 KB 0644
innodb-index.result File 34.22 KB 0644
innodb-index_ucs2.result File 2.74 KB 0644
innodb-lock-inherit-read_commited.result File 3.36 KB 0644
innodb-lock.result File 2.86 KB 0644
innodb-log-file-size-1.result File 4.91 KB 0644
innodb-log-file-size.result File 1.18 KB 0644
innodb-multiple-tablespaces.result File 13.19 KB 0644
innodb-read-view.result File 2.06 KB 0644
innodb-replace.result File 445 B 0644
innodb-semi-consistent.result File 1.35 KB 0644
innodb-status-output.result File 2.2 KB 0644
innodb-system-table-view.result File 5.26 KB 0644
innodb-table-online.result File 12.88 KB 0644
innodb-tablespace.result File 21.6 KB 0644
innodb-timeout.result File 953 B 0644
innodb-truncate.result File 2.28 KB 0644
innodb-ucs2.result File 15.36 KB 0644
innodb-update-insert.result File 948 B 0644
innodb-use-sys-malloc.result File 1.47 KB 0644
innodb-wl5522-1.result File 28.06 KB 0644
innodb-wl5522-debug.result File 32.19 KB 0644
innodb-wl5522.result File 20.52 KB 0644
innodb-wl5980-alter.result File 35.51 KB 0644
innodb-wl5980-debug.result File 1.33 KB 0644
innodb-wl5980-discard.result File 28.63 KB 0644
innodb-wl5980-linux.result File 5.29 KB 0644
innodb-wl5980-windows.result File 5.77 KB 0644
innodb-wl6445-1.result File 68.57 KB 0644
innodb-wl6445-2.result File 3.9 KB 0644
innodb-wl6445.result File 1.78 KB 0644
innodb.result File 97.48 KB 0644
innodb_autoinc_lock_mode_zero.result File 1.22 KB 0644
innodb_autoinc_reset.result File 423 B 0644
innodb_blob_unrecoverable_crash.result File 764 B 0644
innodb_buffer_pool_load.result File 978 B 0644
innodb_bug-13628249.result File 973 B 0644
innodb_bug11754376.result File 180 B 0644
innodb_bug11766634.result File 396 B 0644
innodb_bug11789106.result File 394 B 0644
innodb_bug11933790.result File 229 B 0644
innodb_bug12400341.result File 1 KB 0644
innodb_bug12429573.result File 708 B 0644
innodb_bug12661768.result File 524 B 0644
innodb_bug13635833.result File 1.61 KB 0644
innodb_bug13867871.result File 3.71 KB 0644
innodb_bug14006907.result File 934 B 0644
innodb_bug14007109.result File 223 B 0644
innodb_bug14007649.result File 1.17 KB 0644
innodb_bug14147491.result File 1.29 KB 0644
innodb_bug14169459.result File 1.51 KB 0644
innodb_bug14676111.result File 1.99 KB 0644
innodb_bug14704286.result File 1.12 KB 0644
innodb_bug21704.result File 2.69 KB 0644
innodb_bug30423.result File 3.04 KB 0644
innodb_bug30919.result File 17.44 KB 0644
innodb_bug34053.result File 35 B 0644
innodb_bug34300.result File 173 B 0644
innodb_bug35220.result File 35 B 0644
innodb_bug38231.result File 35 B 0644
innodb_bug39438.result File 35 B 0644
innodb_bug40360.result File 134 B 0644
innodb_bug40565.result File 311 B 0644
innodb_bug41904.result File 195 B 0644
innodb_bug42101-nonzero.result File 810 B 0644
innodb_bug42101.result File 704 B 0644
innodb_bug42419.result File 858 B 0644
innodb_bug44032.result File 313 B 0644
innodb_bug44369.result File 300 B 0644
innodb_bug44571.result File 334 B 0644
innodb_bug45357.result File 290 B 0644
innodb_bug46000.result File 905 B 0644
innodb_bug46676.result File 362 B 0644
innodb_bug47167.result File 990 B 0644
innodb_bug47621.result File 777 B 0644
innodb_bug47622.result File 748 B 0644
innodb_bug47777.result File 516 B 0644
innodb_bug48024.result File 592 B 0644
innodb_bug49164.result File 633 B 0644
innodb_bug51378.result File 2.19 KB 0644
innodb_bug51920.result File 316 B 0644
innodb_bug52199.result File 175 B 0644
innodb_bug52663.result File 857 B 0644
innodb_bug53046.result File 1016 B 0644
innodb_bug53290.result File 771 B 0644
innodb_bug53592.result File 1.54 KB 0644
innodb_bug53674.result File 234 B 0644
innodb_bug53756.result File 2.39 KB 0644
innodb_bug54044.result File 678 B 0644
innodb_bug56143.result File 73.65 KB 0644
innodb_bug56716.result File 168 B 0644
innodb_bug56947.result File 406 B 0644
innodb_bug57252.result File 89 B 0644
innodb_bug57255.result File 501 B 0644
innodb_bug57904.result File 1.3 KB 0644
innodb_bug59307.result File 476 B 0644
innodb_bug59410.result File 529 B 0644
innodb_bug59641.result File 898 B 0644
innodb_bug59733.result File 802 B 0644
innodb_bug60049.result File 430 B 0644
innodb_bug60196.result File 2.9 KB 0644
innodb_bug60229.result File 955 B 0644
innodb_bug70867.result File 171 B 0644
innodb_copy_col_in_partition.result File 976 B 0644
innodb_corrupt_bit.result File 2.97 KB 0644
innodb_ctype_ldml.result File 27.54 KB 0644
innodb_deadlock_with_autoinc.result File 565 B 0644
innodb_file_format.result File 1.68 KB 0644
innodb_file_limit_check.result File 319 B 0644
innodb_force_recovery.result File 3.22 KB 0644
innodb_gis.result File 25.08 KB 0644
innodb_i_s_innodb_locks.result File 4.33 KB 0644
innodb_i_s_innodb_trx.result File 2.85 KB 0644
innodb_information_schema_buffer.result File 2.23 KB 0644
innodb_io_pf.result File 407 B 0644
innodb_lock_wait_timeout_1.result File 8.29 KB 0644
innodb_misc1.result File 28.04 KB 0644
innodb_multi_update.result File 1.58 KB 0644
innodb_mysql.result File 77.3 KB 0644
innodb_mysql_rbk.result File 629 B 0644
innodb_notembedded.result File 637 B 0644
innodb_page_size_func.result File 1.48 KB 0644
innodb_prefix_index_restart_server.result File 2.91 KB 0644
innodb_replace.result File 2.33 KB 0644
innodb_stats.result File 11.62 KB 0644
innodb_stats_auto_recalc.result File 1.33 KB 0644
innodb_stats_auto_recalc_ddl.result File 1.13 KB 0644
innodb_stats_auto_recalc_lots.result File 2.07 KB 0644
innodb_stats_auto_recalc_on_nonexistent.result File 2.19 KB 0644
innodb_stats_create_on_corrupted.result File 893 B 0644
innodb_stats_create_table.result File 1.1 KB 0644
innodb_stats_del_mark.result File 2.81 KB 0644
innodb_stats_drop_locked.result File 1.55 KB 0644
innodb_stats_external_pages.result File 880 B 0644
innodb_stats_fetch.result File 3.35 KB 0644
innodb_stats_fetch_corrupted.result File 1.2 KB 0644
innodb_stats_fetch_nonexistent.result File 980 B 0644
innodb_stats_flag_global_off.result File 7.34 KB 0644
innodb_stats_flag_global_on.result File 7.34 KB 0644
innodb_stats_rename_table.result File 1.48 KB 0644
innodb_stats_rename_table_if_exists.result File 1.89 KB 0644
innodb_stats_sample_pages.result File 1023 B 0644
innodb_stats_table_flag_auto_recalc.result File 3 KB 0644
innodb_stats_table_flag_sample_pages.result File 4.27 KB 0644
innodb_sys_var_valgrind.result File 2.35 KB 0644
innodb_timeout_rollback.result File 570 B 0644
innodb_trx_weight.result File 35 B 0644
innodb_upd_stats_if_needed_not_inited.result File 457 B 0644
innodb_ut_format_name.result File 140 B 0644
insert_debug.result File 380 B 0644
monitor.result File 22.89 KB 0644
monitor_debug.result File 569 B 0644
sp_temp_table.result File 5.72 KB 0644
strict_checksum.result File 787 B 0644
strict_mode.result File 3.47 KB 0644
timestamp.result File 790 B 0644
tmpdir.result File 1.8 KB 0644
undo_space_id.result File 155 B 0644
xa_recovery.result File 352 B 0644