67 lines
2.4 KiB
Plaintext
67 lines
2.4 KiB
Plaintext
#
|
|
# Try various things when InnoDB runs out of free undo logs.
|
|
#
|
|
# These first three injection points are during DDL_Log removal
|
|
# after a CREATE TABLE
|
|
# Inject error #1
|
|
SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_1';
|
|
CREATE TABLE t1 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
ERROR HY000: Too many active concurrent transactions
|
|
SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_1';
|
|
# Try more DDL, restart, try more DDL
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# restart
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# Inject error #2
|
|
SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_2';
|
|
CREATE TABLE t1 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
ERROR HY000: Too many active concurrent transactions
|
|
SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_2';
|
|
# Try more DDL, restart, try more DDL
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# restart
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# Inject error #3
|
|
SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_3';
|
|
CREATE TABLE t1 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
ERROR HY000: Too many active concurrent transactions
|
|
SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_3';
|
|
# Try more DDL, restart, try more DDL
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# restart
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# These next two injection points are during DDL_Log removal
|
|
# after a RENAME TABLE
|
|
CREATE TABLE t1 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
# Inject error #4
|
|
SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_4';
|
|
ALTER TABLE t1 RENAME TO t2;
|
|
ERROR HY000: Error on rename of 'OLD_FILE_NAME' to 'NEW_FILE_NAME' (errno: 177 - Too many active concurrent transactions)
|
|
SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_4';
|
|
ALTER TABLE t1 RENAME TO t2;
|
|
# Try more DDL, restart, try more DDL
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# restart
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# Inject error #5
|
|
SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_5';
|
|
ALTER TABLE t2 RENAME TO t1;
|
|
ERROR HY000: Error on rename of 'OLD_FILE_NAME' to 'NEW_FILE_NAME' (errno: 177 - Too many active concurrent transactions)
|
|
SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_5';
|
|
ALTER TABLE t2 RENAME TO t1;
|
|
DROP TABLE t1;
|
|
# Try more DDL, restart, try more DDL
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|
|
# restart
|
|
CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
|
|
DROP TABLE t9;
|