2793 Rafal Somla 2009-03-23
Remove SELECTs from I_S.PROCESSLIST from tests, because such selects are unstable
in the current server (see bug#37990, bug#41346, bug#43357). These selects increase
feedback given by test and thus increases chances of detecting problems, but are
not essential for test purposes.
@ mysql-test/suite/backup/include/bml_test.inc
Comment-out SELECTs from I_S.PROCESSLIST.
@ mysql-test/suite/backup/t/backup_bml.test
Comment-out SELECTs from I_S.PROCESSLIST.
@ mysql-test/suite/backup_engines/include/backup_restore_interrupt.inc
Comment-out SELECTs from I_S.PROCESSLIST.
modified:
mysql-test/suite/backup/include/bml_test.inc
mysql-test/suite/backup/r/backup_bml.result
mysql-test/suite/backup/t/backup_bml.test
mysql-test/suite/backup_engines/include/backup_restore_interrupt.inc
mysql-test/suite/backup_engines/r/backup_interruption.result
2792 Jorgen Loland 2009-03-24
Bug#39063 - Online Backup: Backup behavior changes with the case used for the database name
Followup patch:
* rename backup_dbname_notwin to backup_dbname_lctn0 for uniformity
* make backup_dbname_lctn0 execute on case sensitive file systems only
* make backup_dbname_lctn2 execute on case insensitive file systems only
@ mysql-test/suite/backup/r/backup_dbname_lctn0.result
Rename test file
@ mysql-test/suite/backup/t/backup_dbname_lctn0-master.opt
Explicitly execute backup_dbname_lctn0.test with system variable lower_case_table_names=0
@ mysql-test/suite/backup/t/backup_dbname_lctn0.test
Rename test file and make it run on servers with case sensitive file systems only
@ mysql-test/suite/backup/t/backup_dbname_lctn2.test
Make test run on servers with case insensitive file systems only
added:
mysql-test/suite/backup/t/backup_dbname_lctn0-master.opt
renamed:
mysql-test/suite/backup/r/backup_dbname_notwin.result => mysql-test/suite/backup/r/backup_dbname_lctn0.result
mysql-test/suite/backup/t/backup_dbname_notwin.test => mysql-test/suite/backup/t/backup_dbname_lctn0.test
modified:
mysql-test/suite/backup/t/backup_dbname_lctn2.test
mysql-test/suite/backup/t/backup_dbname_lctn0.test
=== modified file 'mysql-test/suite/backup/include/bml_test.inc'
--- a/mysql-test/suite/backup/include/bml_test.inc 2009-03-10 16:18:25 +0000
+++ b/mysql-test/suite/backup/include/bml_test.inc 2009-03-23 18:46:10 +0000
@@ -183,11 +183,17 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
--echo # DDL3= $DDL3
--echo # DDL4= $DDL4
--echo #
-eval SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
- WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "$DDL1%"
- OR info LIKE "$DDL2%";
+#
+# SELECTs from I_S.PROCESSLIST commented out because such selects are unstable
+# in the current server (v6.0 as of Mar 2009). See bug#37990, bug#41346,
+# bug#43357. When I_S quality is improved, the following lines could be
+# re-enabled increasing sensitivity of this test to potential problems.
+#
+#eval SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
+# WHERE info LIKE "BACKUP DATABASE%"
+# OR info LIKE "RESTORE FROM%"
+# OR info LIKE "$DDL1%"
+# OR info LIKE "$DDL2%";
--echo # Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
--echo # Checking that DDL1 and DDL2 have not executed.
@@ -219,9 +225,15 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
--echo # DDL3= $DDL3
--echo # DDL4= $DDL4
--echo #
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
- WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
+#
+# SELECTs from I_S.PROCESSLIST commented out because such selects are unstable
+# in the current server (v6.0 as of Mar 2009). See bug#37990, bug#41346,
+# bug#43357. When I_S quality is improved, the following lines could be
+# re-enabled increasing sensitivity of this test to potential problems.
+#
+#SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
+# WHERE info LIKE "BACKUP DATABASE%"
+# OR info LIKE "RESTORE FROM%";
--echo # Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
--echo ==================
@@ -261,9 +273,15 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
--echo # DDL3= $DDL3
--echo # DDL4= $DDL4
--echo #
-eval SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
- WHERE info LIKE "$DDL3%"
- OR info LIKE "$DDL4%";
+#
+# SELECTs from I_S.PROCESSLIST commented out because such selects are unstable
+# in the current server (v6.0 as of Mar 2009). See bug#37990, bug#41346,
+# bug#43357. When I_S quality is improved, the following lines could be
+# re-enabled increasing sensitivity of this test to potential problems.
+#
+#eval SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
+# WHERE info LIKE "$DDL3%"
+# OR info LIKE "$DDL4%";
--echo # Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
--echo ==================
=== modified file 'mysql-test/suite/backup/r/backup_bml.result'
--- a/mysql-test/suite/backup/r/backup_bml.result 2009-03-10 16:18:25 +0000
+++ b/mysql-test/suite/backup/r/backup_bml.result 2009-03-23 18:46:10 +0000
@@ -172,15 +172,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= DROP DATABASE bml_test_db1
# DDL4= CREATE TABLE t1(a int)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "CREATE VIEW v1 AS SELECT * FROM t2%"
- OR info LIKE "DROP FUNCTION f1%";
-state info
-BML: waiting for all statements to leave BACKUP DATABASE bml_test TO 'bml_test.bkp'
-debug sync point: before_execute_sql_command DROP FUNCTION f1
-debug sync point: before_execute_sql_command CREATE VIEW v1 AS SELECT * FROM t2
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -218,11 +209,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= DROP DATABASE bml_test_db1
# DDL4= CREATE TABLE t1(a int)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: before_backup_meta BACKUP DATABASE bml_test TO 'bml_test.bkp'
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Database (bml%)
@@ -263,12 +249,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= DROP DATABASE bml_test_db1
# DDL4= CREATE TABLE t1(a int)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "DROP DATABASE bml_test_db1%"
- OR info LIKE "CREATE TABLE t1(a int)%";
-state info
-BML: waiting until released CREATE TABLE t1(a int)
-BML: waiting until released DROP DATABASE bml_test_db1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Database (bml%)
@@ -407,15 +387,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= DROP VIEW v1
# DDL4= CREATE FUNCTION f1() RETURNS int RETURN 1
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "CREATE DATABASE bml_test_db1%"
- OR info LIKE "DROP TABLE t1%";
-state info
-BML: waiting for all statements to leave RESTORE FROM 'bml_test.bkp' OVERWRITE
-debug sync point: before_execute_sql_command DROP TABLE t1
-debug sync point: before_execute_sql_command CREATE DATABASE bml_test_db1
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -453,11 +424,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= DROP VIEW v1
# DDL4= CREATE FUNCTION f1() RETURNS int RETURN 1
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: start_do_restore RESTORE FROM 'bml_test.bkp' OVERWRITE
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Database (bml%)
@@ -498,12 +464,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= DROP VIEW v1
# DDL4= CREATE FUNCTION f1() RETURNS int RETURN 1
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "DROP VIEW v1%"
- OR info LIKE "CREATE FUNCTION f1() RETURNS int RETURN 1%";
-state info
-BML: waiting until released CREATE FUNCTION f1() RETURNS int RETURN 1
-BML: waiting until released DROP VIEW v1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Database (bml%)
@@ -644,15 +604,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= DROP PROCEDURE p1
# DDL4= CREATE EVENT e1 ON SCHEDULE EVERY 1 YEAR DISABLE DO SET @foo=1
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW SET @foo=1%"
- OR info LIKE "DROP INDEX i1 ON t2%";
-state info
-BML: waiting for all statements to leave BACKUP DATABASE bml_test TO 'bml_test.bkp'
-debug sync point: before_execute_sql_command DROP INDEX i1 ON t2
-debug sync point: before_execute_sql_command CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW SET @foo=1
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -689,11 +640,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= DROP PROCEDURE p1
# DDL4= CREATE EVENT e1 ON SCHEDULE EVERY 1 YEAR DISABLE DO SET @foo=1
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: before_backup_meta BACKUP DATABASE bml_test TO 'bml_test.bkp'
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Database (bml%)
@@ -733,12 +679,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= DROP PROCEDURE p1
# DDL4= CREATE EVENT e1 ON SCHEDULE EVERY 1 YEAR DISABLE DO SET @foo=1
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "DROP PROCEDURE p1%"
- OR info LIKE "CREATE EVENT e1 ON SCHEDULE EVERY 1 YEAR DISABLE DO SET @foo=1%";
-state info
-BML: waiting until released CREATE EVENT e1 ON SCHEDULE EVERY 1 YEAR DISABLE DO SET @foo=1
-BML: waiting until released DROP PROCEDURE p1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Database (bml%)
@@ -874,15 +814,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= DROP TRIGGER r1
# DDL4= CREATE INDEX i1 ON t2(b)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "CREATE PROCEDURE p1() SET @foo=1%"
- OR info LIKE "DROP EVENT e1%";
-state info
-BML: waiting for all statements to leave RESTORE FROM 'bml_test.bkp' OVERWRITE
-debug sync point: before_execute_sql_command DROP EVENT e1
-debug sync point: before_execute_sql_command CREATE PROCEDURE p1() SET @foo=1
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -919,11 +850,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= DROP TRIGGER r1
# DDL4= CREATE INDEX i1 ON t2(b)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: start_do_restore RESTORE FROM 'bml_test.bkp' OVERWRITE
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Database (bml%)
@@ -963,12 +889,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= DROP TRIGGER r1
# DDL4= CREATE INDEX i1 ON t2(b)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "DROP TRIGGER r1%"
- OR info LIKE "CREATE INDEX i1 ON t2(b)%";
-state info
-BML: waiting until released CREATE INDEX i1 ON t2(b)
-BML: waiting until released DROP TRIGGER r1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Database (bml%)
@@ -1147,15 +1067,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= ALTER VIEW v1 AS SELECT 1
# DDL4= ALTER FUNCTION f1 COMMENT 'testing alter'
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "ALTER DATABASE bml_test_db1 CHARACTER SET = utf8%"
- OR info LIKE "ALTER TABLE t1 ADD INDEX `i` (a)%";
-state info
-BML: waiting for all statements to leave BACKUP DATABASE bml_test TO 'bml_test.bkp'
-debug sync point: before_execute_sql_command ALTER TABLE t1 ADD INDEX `i` (a)
-debug sync point: before_execute_sql_command ALTER DATABASE bml_test_db1 CHARACTER SET = utf8
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -1195,11 +1106,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= ALTER VIEW v1 AS SELECT 1
# DDL4= ALTER FUNCTION f1 COMMENT 'testing alter'
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: before_backup_meta BACKUP DATABASE bml_test TO 'bml_test.bkp'
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Database Create Database
@@ -1243,12 +1149,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= ALTER VIEW v1 AS SELECT 1
# DDL4= ALTER FUNCTION f1 COMMENT 'testing alter'
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "ALTER VIEW v1 AS SELECT 1%"
- OR info LIKE "ALTER FUNCTION f1 COMMENT 'testing alter'%";
-state info
-BML: waiting until released ALTER FUNCTION f1 COMMENT 'testing alter'
-BML: waiting until released ALTER VIEW v1 AS SELECT 1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Database Create Database
@@ -1399,15 +1299,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= ALTER PROCEDURE p1 COMMENT 'testing alter'
# DDL4= ALTER EVENT e1 RENAME TO e2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "ALTER VIEW v1 AS SELECT 1%"
- OR info LIKE "ALTER FUNCTION f1 COMMENT 'testing alter'%";
-state info
-BML: waiting for all statements to leave RESTORE FROM 'bml_test.bkp' OVERWRITE
-debug sync point: before_execute_sql_command ALTER FUNCTION f1 COMMENT 'testing alter'
-debug sync point: before_execute_sql_command ALTER VIEW v1 AS SELECT 1
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -1447,11 +1338,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= ALTER PROCEDURE p1 COMMENT 'testing alter'
# DDL4= ALTER EVENT e1 RENAME TO e2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: start_do_restore RESTORE FROM 'bml_test.bkp' OVERWRITE
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Database Create Database
@@ -1495,12 +1381,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= ALTER PROCEDURE p1 COMMENT 'testing alter'
# DDL4= ALTER EVENT e1 RENAME TO e2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "ALTER PROCEDURE p1 COMMENT 'testing alter'%"
- OR info LIKE "ALTER EVENT e1 RENAME TO e2%";
-state info
-BML: waiting until released ALTER EVENT e1 RENAME TO e2
-BML: waiting until released ALTER PROCEDURE p1 COMMENT 'testing alter'
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Database Create Database
@@ -1651,15 +1531,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= ALTER DATABASE bml_test_db1 CHARACTER SET = utf8
# DDL4= ALTER TABLE t1 ADD INDEX `i` (a)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "ALTER PROCEDURE p1 COMMENT 'testing alter'%"
- OR info LIKE "ALTER EVENT e1 RENAME TO e2%";
-state info
-BML: waiting for all statements to leave BACKUP DATABASE bml_test TO 'bml_test.bkp'
-debug sync point: before_execute_sql_command ALTER EVENT e1 RENAME TO e2
-debug sync point: before_execute_sql_command ALTER PROCEDURE p1 COMMENT 'testing alter'
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -1699,11 +1570,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= ALTER DATABASE bml_test_db1 CHARACTER SET = utf8
# DDL4= ALTER TABLE t1 ADD INDEX `i` (a)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: before_backup_meta BACKUP DATABASE bml_test TO 'bml_test.bkp'
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Database Create Database
@@ -1747,12 +1613,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= ALTER DATABASE bml_test_db1 CHARACTER SET = utf8
# DDL4= ALTER TABLE t1 ADD INDEX `i` (a)
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "ALTER DATABASE bml_test_db1 CHARACTER SET = utf8%"
- OR info LIKE "ALTER TABLE t1 ADD INDEX `i` (a)%";
-state info
-BML: waiting until released ALTER TABLE t1 ADD INDEX `i` (a)
-BML: waiting until released ALTER DATABASE bml_test_db1 CHARACTER SET = utf8
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Database Create Database
@@ -1903,15 +1763,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= ALTER VIEW v1 AS SELECT 1
# DDL4= ALTER FUNCTION f1 COMMENT 'testing alter'
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "ALTER DATABASE bml_test_db1 CHARACTER SET = utf8%"
- OR info LIKE "ALTER TABLE t1 ADD INDEX `i` (a)%";
-state info
-BML: waiting for all statements to leave RESTORE FROM 'bml_test.bkp' OVERWRITE
-debug sync point: before_execute_sql_command ALTER TABLE t1 ADD INDEX `i` (a)
-debug sync point: before_execute_sql_command ALTER DATABASE bml_test_db1 CHARACTER SET = utf8
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -1951,11 +1802,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= ALTER VIEW v1 AS SELECT 1
# DDL4= ALTER FUNCTION f1 COMMENT 'testing alter'
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: start_do_restore RESTORE FROM 'bml_test.bkp' OVERWRITE
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Database Create Database
@@ -1999,12 +1845,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= ALTER VIEW v1 AS SELECT 1
# DDL4= ALTER FUNCTION f1 COMMENT 'testing alter'
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "ALTER VIEW v1 AS SELECT 1%"
- OR info LIKE "ALTER FUNCTION f1 COMMENT 'testing alter'%";
-state info
-BML: waiting until released ALTER FUNCTION f1 COMMENT 'testing alter'
-BML: waiting until released ALTER VIEW v1 AS SELECT 1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Database Create Database
@@ -2181,15 +2021,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= RENAME USER bml_u2 TO bml_u2_renamed
# DDL4= DROP TABLESPACE bml_ts1 ENGINE=falcon
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "RENAME TABLE t1 TO t1_renamed%"
- OR info LIKE "DROP USER bml_u1%";
-state info
-BML: waiting for all statements to leave BACKUP DATABASE bml_test TO 'bml_test.bkp'
-debug sync point: before_execute_sql_command DROP USER bml_u1
-debug sync point: before_execute_sql_command RENAME TABLE t1 TO t1_renamed
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -2224,11 +2055,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= RENAME USER bml_u2 TO bml_u2_renamed
# DDL4= DROP TABLESPACE bml_ts1 ENGINE=falcon
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: before_backup_meta BACKUP DATABASE bml_test TO 'bml_test.bkp'
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Tables_in_bml_test
@@ -2265,12 +2091,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= RENAME USER bml_u2 TO bml_u2_renamed
# DDL4= DROP TABLESPACE bml_ts1 ENGINE=falcon
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "RENAME USER bml_u2 TO bml_u2_renamed%"
- OR info LIKE "DROP TABLESPACE bml_ts1 ENGINE=falcon%";
-state info
-BML: waiting until released DROP TABLESPACE bml_ts1 ENGINE=falcon
-BML: waiting until released RENAME USER bml_u2 TO bml_u2_renamed
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Tables_in_bml_test
@@ -2395,15 +2215,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= RENAME TABLE t1_renamed TO t1
# DDL4= GRANT ALL ON bml_test.* TO bml_u2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "RENAME USER bml_u2_renamed TO bml_u2%"
- OR info LIKE "GRANT ALL ON bml_test.* TO bml_u3%";
-state info
-BML: waiting for all statements to leave RESTORE FROM 'bml_test.bkp' OVERWRITE
-debug sync point: before_execute_sql_command GRANT ALL ON bml_test.* TO bml_u3
-debug sync point: before_execute_sql_command RENAME USER bml_u2_renamed TO bml_u2
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -2436,11 +2247,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= RENAME TABLE t1_renamed TO t1
# DDL4= GRANT ALL ON bml_test.* TO bml_u2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: start_do_restore RESTORE FROM 'bml_test.bkp' OVERWRITE
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Tables_in_bml_test
@@ -2477,12 +2283,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= RENAME TABLE t1_renamed TO t1
# DDL4= GRANT ALL ON bml_test.* TO bml_u2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "RENAME TABLE t1_renamed TO t1%"
- OR info LIKE "GRANT ALL ON bml_test.* TO bml_u2%";
-state info
-BML: waiting until released GRANT ALL ON bml_test.* TO bml_u2
-BML: waiting until released RENAME TABLE t1_renamed TO t1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Tables_in_bml_test
@@ -2611,15 +2411,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= DROP USER bml_u2
# DDL4= REVOKE ALL ON bml_test.* FROM bml_u3
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "DROP TABLESPACE bml_ts2 ENGINE=falcon%"
- OR info LIKE "REVOKE ALL ON bml_test.* FROM bml_u2%";
-state info
-BML: waiting for all statements to leave BACKUP DATABASE bml_test TO 'bml_test.bkp'
-debug sync point: before_execute_sql_command REVOKE ALL ON bml_test.* FROM bml_u2
-debug sync point: before_execute_sql_command DROP TABLESPACE bml_ts2 ENGINE=falcon
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -2654,11 +2445,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= DROP USER bml_u2
# DDL4= REVOKE ALL ON bml_test.* FROM bml_u3
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: before_backup_meta BACKUP DATABASE bml_test TO 'bml_test.bkp'
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Tables_in_bml_test
@@ -2694,12 +2480,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= DROP USER bml_u2
# DDL4= REVOKE ALL ON bml_test.* FROM bml_u3
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "DROP USER bml_u2%"
- OR info LIKE "REVOKE ALL ON bml_test.* FROM bml_u3%";
-state info
-BML: waiting until released REVOKE ALL ON bml_test.* FROM bml_u3
-BML: waiting until released DROP USER bml_u2
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Tables_in_bml_test
@@ -2845,15 +2625,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= TRUNCATE TABLE t1
# DDL4= TRUNCATE TABLE t2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "OPTIMIZE TABLE t1%"
- OR info LIKE "REPAIR TABLE t2 USE_FRM%";
-state info
-BML: waiting for all statements to leave BACKUP DATABASE bml_test TO 'bml_test.bkp'
-debug sync point: before_execute_sql_command REPAIR TABLE t2 USE_FRM
-debug sync point: before_execute_sql_command OPTIMIZE TABLE t1
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -2892,11 +2663,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= TRUNCATE TABLE t1
# DDL4= TRUNCATE TABLE t2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: before_backup_meta BACKUP DATABASE bml_test TO 'bml_test.bkp'
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Tables_in_bml_test
@@ -2933,12 +2699,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= TRUNCATE TABLE t1
# DDL4= TRUNCATE TABLE t2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "TRUNCATE TABLE t1%"
- OR info LIKE "TRUNCATE TABLE t2%";
-state info
-BML: waiting until released TRUNCATE TABLE t2
-BML: waiting until released TRUNCATE TABLE t1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Tables_in_bml_test
@@ -3067,15 +2827,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR bup_waitin
# DDL3= REPAIR TABLE t1
# DDL4= OPTIMIZE TABLE t2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%"
- OR info LIKE "TRUNCATE t1%"
- OR info LIKE "TRUNCATE t2%";
-state info
-BML: waiting for all statements to leave RESTORE FROM 'bml_test.bkp' OVERWRITE
-debug sync point: before_execute_sql_command TRUNCATE t2
-debug sync point: before_execute_sql_command TRUNCATE t1
# Checking that BACKUP is blocked by DDLs.
SELECT object, notes, error_num FROM mysql.backup_progress WHERE backup_id=500;
object notes error_num
@@ -3109,11 +2860,6 @@ SET DEBUG_SYNC= 'now SIGNAL continue_bup
# DDL3= REPAIR TABLE t1
# DDL4= OPTIMIZE TABLE t2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "RESTORE FROM%";
-state info
-debug sync point: start_do_restore RESTORE FROM 'bml_test.bkp' OVERWRITE
# Checking that DDL1 and DDL2 have executed.
CALL test.check_results();
Tables_in_bml_test
@@ -3150,12 +2896,6 @@ SET DEBUG_SYNC= 'now WAIT_FOR ddl4_block
# DDL3= REPAIR TABLE t1
# DDL4= OPTIMIZE TABLE t2
#
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "REPAIR TABLE t1%"
- OR info LIKE "OPTIMIZE TABLE t2%";
-state info
-BML: waiting until released OPTIMIZE TABLE t2
-BML: waiting until released REPAIR TABLE t1
# Checking that DDL3 and DDL4 have not executed.
CALL test.check_results();
Tables_in_bml_test
@@ -3237,13 +2977,6 @@ SET SESSION debug="+d,set_backup_id";
BACKUP DATABASE bml_test TO 'bml_test.bkp';;
# Waiting for BACKUP to reach its synchronization point.
SET DEBUG_SYNC= 'now WAIT_FOR bup_started TIMEOUT 3';
-# Check the state of both statements.
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "CREATE USER%";
-state info
-debug sync point: after_backup_start_backup BACKUP DATABASE bml_test TO 'bml_test.bkp'
-debug sync point: before_execute_sql_command CREATE USER bml_usr
# Checking that CREATE USER has not executed yet.
SELECT User, Password FROM mysql.user WHERE User like 'bml%';
User Password
@@ -3299,13 +3032,6 @@ SET SESSION debug="+d,set_backup_id";
RESTORE FROM 'bml_test.bkp' OVERWRITE;;
# Waiting for RESTORE to reach its synchronization point.
SET DEBUG_SYNC= 'now WAIT_FOR bup_started TIMEOUT 3';
-# Check the state of both statements.
-SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE info LIKE "RESTORE FROM%"
- OR info LIKE "DROP SERVER%";
-state info
-debug sync point: after_backup_start_restore RESTORE FROM 'bml_test.bkp' OVERWRITE
-debug sync point: before_execute_sql_command DROP SERVER bml_srv
# Checking that DROP SERVER has not executed yet.
SELECT Server_name FROM mysql.servers WHERE Server_name like 'bml%';
Server_name
=== modified file 'mysql-test/suite/backup/t/backup_bml.test'
--- a/mysql-test/suite/backup/t/backup_bml.test 2009-02-20 16:40:19 +0000
+++ b/mysql-test/suite/backup/t/backup_bml.test 2009-03-23 18:46:10 +0000
@@ -564,10 +564,16 @@ connection default;
--echo # Waiting for BACKUP to reach its synchronization point.
SET DEBUG_SYNC= 'now WAIT_FOR bup_started TIMEOUT 3';
---echo # Check the state of both statements.
-eval SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
- WHERE info LIKE "BACKUP DATABASE%"
- OR info LIKE "CREATE USER%";
+#
+# SELECTs from I_S.PROCESSLIST commented out because such selects are unstable
+# in the current server (v6.0 as of Mar 2009). See bug#37990, bug#41346,
+# bug#43357. When I_S quality is improved, the following lines could be
+# re-enabled increasing sensitivity of this test to potential problems.
+#
+#--echo # Check the state of both statements.
+#eval SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
+# WHERE info LIKE "BACKUP DATABASE%"
+# OR info LIKE "CREATE USER%";
--echo # Checking that CREATE USER has not executed yet.
SELECT User, Password FROM mysql.user WHERE User like 'bml%';
--echo # Checking that BACKUP is not blocked by DDL.
@@ -637,10 +643,16 @@ connection default;
--echo # Waiting for RESTORE to reach its synchronization point.
SET DEBUG_SYNC= 'now WAIT_FOR bup_started TIMEOUT 3';
---echo # Check the state of both statements.
-eval SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
- WHERE info LIKE "RESTORE FROM%"
- OR info LIKE "DROP SERVER%";
+#
+# SELECTs from I_S.PROCESSLIST commented out because such selects are unstable
+# in the current server (v6.0 as of Mar 2009). See bug#37990, bug#41346,
+# bug#43357. When I_S quality is improved, the following lines could be
+# re-enabled increasing sensitivity of this test to potential problems.
+#
+#--echo # Check the state of both statements.
+#eval SELECT state, info FROM INFORMATION_SCHEMA.PROCESSLIST
+# WHERE info LIKE "RESTORE FROM%"
+# OR info LIKE "DROP SERVER%";
--echo # Checking that DROP SERVER has not executed yet.
SELECT Server_name FROM mysql.servers WHERE Server_name like 'bml%';
--echo # Checking that RESTORE is not blocked by DDL.
=== modified file 'mysql-test/suite/backup_engines/include/backup_restore_interrupt.inc'
--- a/mysql-test/suite/backup_engines/include/backup_restore_interrupt.inc 2009-03-16 14:38:05 +0000
+++ b/mysql-test/suite/backup_engines/include/backup_restore_interrupt.inc 2009-03-23 18:46:10 +0000
@@ -69,8 +69,14 @@ eval $command;
--echo # then kill it.
--echo #
SET DEBUG_SYNC='now WAIT_FOR here';
- --replace_regex /id=[0-9]+/id=<query id>/
- eval SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=$id;
+#
+# SELECTs from I_S.PROCESSLIST commented out because such selects are unstable
+# in the current server (v6.0 as of Mar 2009). See bug#37990, bug#41346,
+# bug#43357. When I_S quality is improved, the following lines could be
+# re-enabled increasing sensitivity of this test to potential problems.
+#
+# --replace_regex /id=[0-9]+/id=<query id>/
+# eval SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=$id;
--replace_regex /QUERY [0-9]+/QUERY <query id>/
eval KILL QUERY $id;
SET DEBUG_SYNC='now SIGNAL go';
=== modified file 'mysql-test/suite/backup_engines/r/backup_interruption.result'
--- a/mysql-test/suite/backup_engines/r/backup_interruption.result 2009-03-16 14:38:05 +0000
+++ b/mysql-test/suite/backup_engines/r/backup_interruption.result 2009-03-23 18:46:10 +0000
@@ -28,9 +28,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_command
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -72,9 +69,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_prepare
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -116,9 +110,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_logger_init
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -160,9 +151,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_common_prepare
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -207,9 +195,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_privileges
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -254,9 +239,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_single_op
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -301,9 +283,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_ddl_block
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -348,9 +327,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_stream_open
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -395,9 +371,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_catalog
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -442,9 +415,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: after_backup_start_backup
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -489,9 +459,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_do_backup
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -536,9 +503,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_meta
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -583,9 +547,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: backup_before_write_preamble
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -630,9 +591,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_data
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -677,9 +635,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_data_init
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -724,9 +679,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_data_prepare
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -771,9 +723,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_data_lock
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -819,9 +768,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_data_unlock
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -867,9 +813,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: after_backup_binlog
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -917,9 +860,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_data_finish
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -967,9 +907,6 @@ BACKUP DATABASE bup_intr TO 'bup_intr.bk
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_backup_summary
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1021,9 +958,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_prepare
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1065,9 +999,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_logger_init
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1109,9 +1040,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_common_prepare
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1156,9 +1084,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_stream_open
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1203,9 +1128,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_catalog
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1250,9 +1172,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_read_header
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1297,9 +1216,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_read_catalog
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1344,9 +1260,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_binlog
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1391,9 +1304,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: after_backup_start_restore
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1438,9 +1348,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_fkey_disable
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1485,9 +1392,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_read_metadata
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1532,9 +1436,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_locks_tables
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1580,9 +1481,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_table_data
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1628,9 +1526,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: restore_before_drivers_create
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1676,9 +1571,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: restore_before_drivers_init
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1724,9 +1616,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: restore_before_read_data_chunk
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1772,9 +1661,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: restore_before_sending_data
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1820,9 +1706,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: restore_table_data_before_end
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1868,9 +1751,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_triggers
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
@@ -1916,9 +1796,6 @@ RESTORE FROM 'bup_intr.bkp';
# then kill it.
#
SET DEBUG_SYNC='now WAIT_FOR here';
-SELECT state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=<query id>;
-state
-debug sync point: before_restore_completed
KILL QUERY <query id>;
SET DEBUG_SYNC='now SIGNAL go';
#
Attachment: [text/bzr-bundle] bzr/rafal.somla@sun.com-20090323184610-gobu30u63x5btoo6.bundle
| Thread |
|---|
| • bzr push into mysql-6.0-backup branch (Rafal.Somla:2792 to 2793)Bug#37990 Bug#41346 Bug#43357 | Rafal Somla | 24 Mar |
