4 DROP TABLE IF EXISTS t1, t2;
5 DROP FUNCTION IF EXISTS f1;
6 DROP FUNCTION IF EXISTS f2;
7 DROP PROCEDURE IF EXISTS p1;
8 DROP PROCEDURE IF EXISTS p2;
9 DROP TRIGGER IF EXISTS tr1;
10 DROP TRIGGER IF EXISTS tr2;
11 DROP VIEW IF EXISTS v1, v2;
13 # Test injecting binlog write error when executing queries
15 SET GLOBAL debug='d,injecting_fault_writing';
16 CREATE TABLE t1 (a INT);
17 CREATE TABLE t1 (a INT);
18 ERROR HY000: Error writing file 'master-bin' ((errno: #)
20 INSERT INTO t1 VALUES (1),(2),(3);
21 SET GLOBAL debug='d,injecting_fault_writing';
22 INSERT INTO t1 VALUES (4),(5),(6);
23 INSERT INTO t1 VALUES (4),(5),(6);
24 ERROR HY000: Error writing file 'master-bin' ((errno: #)
26 SET GLOBAL debug='d,injecting_fault_writing';
29 ERROR HY000: Error writing file 'master-bin' ((errno: #)
31 SET GLOBAL debug='d,injecting_fault_writing';
34 ERROR HY000: Error writing file 'master-bin' ((errno: #)
36 SET GLOBAL debug='d,injecting_fault_writing';
37 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t1 VALUES (new.a + 100);
38 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t1 VALUES (new.a + 100);
39 ERROR HY000: Error writing file 'master-bin' ((errno: #)
41 SET GLOBAL debug='d,injecting_fault_writing';
44 ERROR HY000: Error writing file 'master-bin' ((errno: #)
46 SET GLOBAL debug='d,injecting_fault_writing';
47 ALTER TABLE t1 ADD (b INT);
48 ALTER TABLE t1 ADD (b INT);
49 ERROR HY000: Error writing file 'master-bin' ((errno: #)
51 SET GLOBAL debug='d,injecting_fault_writing';
52 CREATE VIEW v1 AS SELECT a FROM t1;
53 CREATE VIEW v1 AS SELECT a FROM t1;
54 ERROR HY000: Error writing file 'master-bin' ((errno: #)
56 SET GLOBAL debug='d,injecting_fault_writing';
59 ERROR HY000: Error writing file 'master-bin' ((errno: #)
61 SET GLOBAL debug='d,injecting_fault_writing';
62 CREATE PROCEDURE p1(OUT rows INT) SELECT count(*) INTO rows FROM t1;
63 CREATE PROCEDURE p1(OUT rows INT) SELECT count(*) INTO rows FROM t1;
64 ERROR HY000: Error writing file 'master-bin' ((errno: #)
66 SET GLOBAL debug='d,injecting_fault_writing';
69 ERROR HY000: Error writing file 'master-bin' ((errno: #)
71 SET GLOBAL debug='d,injecting_fault_writing';
74 ERROR HY000: Error writing file 'master-bin' ((errno: #)
76 SET GLOBAL debug='d,injecting_fault_writing';
77 CREATE FUNCTION f1() RETURNS INT return 1;
78 CREATE FUNCTION f1() RETURNS INT return 1;
79 ERROR HY000: Error writing file 'master-bin' ((errno: #)
81 SET GLOBAL debug='d,injecting_fault_writing';
84 ERROR HY000: Error writing file 'master-bin' ((errno: #)
86 SET GLOBAL debug='d,injecting_fault_writing';
89 ERROR HY000: Error writing file 'master-bin' ((errno: #)
91 SET GLOBAL debug='d,injecting_fault_writing';
92 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1;
93 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1;
94 ERROR HY000: Error writing file 'master-bin' ((errno: #)
96 SET GLOBAL debug='d,injecting_fault_writing';
99 ERROR HY000: Error writing file 'master-bin' ((errno: #)
104 DROP TABLE IF EXISTS t1, t2;
105 DROP FUNCTION IF EXISTS f1;
106 DROP PROCEDURE IF EXISTS p1;
107 DROP TRIGGER IF EXISTS tr1;
108 DROP VIEW IF EXISTS v1, v2;