| 1 |
|
| 2 |
--source include/have_debug_sync.inc |
| 3 |
# This test fails sporadically on valgrind, hence skipping |
| 4 |
--source include/not_valgrind.inc |
| 5 |
|
| 6 |
# Save the initial number of concurrent sessions. |
| 7 |
--source include/count_sessions.inc |
| 8 |
|
| 9 |
connect (con1,localhost,root,,); |
| 10 |
|
| 11 |
connect (con2,localhost,root,,); |
| 12 |
connection default; |
| 13 |
|
| 14 |
CREATE TABLE t (a INT PRIMARY KEY, c TEXT) ENGINE=InnoDB; |
| 15 |
CREATE TABLE u (a INT PRIMARY KEY, b INT, c INT NOT NULL) ENGINE=InnoDB; |
| 16 |
|
| 17 |
INSERT INTO t VALUES (1,'aa'); |
| 18 |
BEGIN; |
| 19 |
INSERT INTO u SET a=1, c=1; |
| 20 |
INSERT INTO u SELECT a+1,NULL,a+1 FROM u; |
| 21 |
INSERT INTO u SELECT a+2,NULL,a+2 FROM u; |
| 22 |
INSERT INTO u SELECT a+4,NULL,a+4 FROM u; |
| 23 |
INSERT INTO u SELECT a+8,NULL,a+8 FROM u; |
| 24 |
INSERT INTO u SELECT a+16,NULL,a+16 FROM u; |
| 25 |
INSERT INTO u SELECT a+32,NULL,a+32 FROM u; |
| 26 |
INSERT INTO u SELECT a+64,NULL,a+64 FROM u; |
| 27 |
INSERT INTO u SELECT a+128,NULL,a+64 FROM u; |
| 28 |
INSERT INTO u SELECT a+256,NULL,a+64 FROM u; |
| 29 |
COMMIT; |
| 30 |
|
| 31 |
BEGIN; |
| 32 |
DELETE FROM u; |
| 33 |
|
| 34 |
connection con2; |
| 35 |
SET DEBUG_SYNC='row_log_apply_before SIGNAL created_u WAIT_FOR dml_done_u'; |
| 36 |
--send |
| 37 |
ALTER TABLE u ADD INDEX (c); |
| 38 |
|
| 39 |
connection default; |
| 40 |
# Check that the above SELECT is blocked |
| 41 |
let $wait_condition= |
| 42 |
SELECT COUNT(*) = 1 from information_schema.processlist |
| 43 |
WHERE state = 'Waiting for table metadata lock' AND |
| 44 |
info = 'ALTER TABLE u ADD INDEX (c)'; |
| 45 |
--source include/wait_condition.inc |
| 46 |
|
| 47 |
COMMIT; |
| 48 |
SET DEBUG_SYNC='now WAIT_FOR created_u'; |
| 49 |
SELECT state FROM information_schema.processlist |
| 50 |
WHERE info='ALTER TABLE u ADD INDEX (c)'; |
| 51 |
|
| 52 |
connection con1; |
| 53 |
SET DEBUG_SYNC='row_log_apply_before SIGNAL created_t WAIT_FOR dml_done_t'; |
| 54 |
--send |
| 55 |
CREATE INDEX c1 ON t (c(1)); |
| 56 |
connection default; |
| 57 |
SET DEBUG_SYNC='now WAIT_FOR created_t'; |
| 58 |
UPDATE t SET c='ab'; |
| 59 |
|
| 60 |
--source include/wait_innodb_all_purged.inc |
| 61 |
|
| 62 |
SET DEBUG_SYNC='now SIGNAL dml_done_u'; |
| 63 |
connection con2; |
| 64 |
reap; |
| 65 |
SET DEBUG_SYNC='now SIGNAL dml_done_t'; |
| 66 |
disconnect con2; |
| 67 |
connection con1; |
| 68 |
reap; |
| 69 |
disconnect con1; |
| 70 |
connection default; |
| 71 |
SET DEBUG_SYNC='RESET'; |
| 72 |
DROP TABLE t,u; |
| 73 |
|
| 74 |
# Check that all connections opened by test cases in this file are really |
| 75 |
# gone so execution of other tests won't be affected by their presence. |
| 76 |
--source include/wait_until_count_sessions.inc |