Debian Codegraph @

mysql-test/suite/binlog_encryption/binlog_write_error.result

raw
1 call mtr.add_suppression("Write to binary log failed: Error writing file*");
2 #
3 # Test injecting binlog write error when executing queries
4 #
5 set @saved_dbug = @@global.debug_dbug;
6 SET GLOBAL debug_dbug='d,injecting_fault_writing';
7 CREATE TABLE t1 (a INT);
8 CREATE TABLE t1 (a INT);
9 ERROR HY000: Error writing file 'master-bin' ((errno: #)
10 set @@global.debug_dbug = @saved_dbug;
11 INSERT INTO t1 VALUES (1),(2),(3);
12 set @saved_dbug = @@global.debug_dbug;
13 SET GLOBAL debug_dbug='d,injecting_fault_writing';
14 INSERT INTO t1 VALUES (4),(5),(6);
15 INSERT INTO t1 VALUES (4),(5),(6);
16 ERROR HY000: Error writing file 'master-bin' ((errno: #)
17 set @@global.debug_dbug = @saved_dbug;
18 set @saved_dbug = @@global.debug_dbug;
19 SET GLOBAL debug_dbug='d,injecting_fault_writing';
20 UPDATE t1 set a=a+1;
21 UPDATE t1 set a=a+1;
22 ERROR HY000: Error writing file 'master-bin' ((errno: #)
23 set @@global.debug_dbug = @saved_dbug;
24 set @saved_dbug = @@global.debug_dbug;
25 SET GLOBAL debug_dbug='d,injecting_fault_writing';
26 DELETE FROM t1;
27 DELETE FROM t1;
28 ERROR HY000: Error writing file 'master-bin' ((errno: #)
29 set @@global.debug_dbug = @saved_dbug;
30 set @saved_dbug = @@global.debug_dbug;
31 SET GLOBAL debug_dbug='d,injecting_fault_writing';
32 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t1 VALUES (new.a + 100);
33 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t1 VALUES (new.a + 100);
34 ERROR HY000: Error writing file 'master-bin' ((errno: #)
35 set @@global.debug_dbug = @saved_dbug;
36 set @saved_dbug = @@global.debug_dbug;
37 SET GLOBAL debug_dbug='d,injecting_fault_writing';
38 DROP TRIGGER tr1;
39 DROP TRIGGER tr1;
40 ERROR HY000: Error writing file 'master-bin' ((errno: #)
41 set @@global.debug_dbug = @saved_dbug;
42 set @saved_dbug = @@global.debug_dbug;
43 SET GLOBAL debug_dbug='d,injecting_fault_writing';
44 ALTER TABLE t1 ADD (b INT);
45 ALTER TABLE t1 ADD (b INT);
46 ERROR HY000: Error writing file 'master-bin' ((errno: #)
47 set @@global.debug_dbug = @saved_dbug;
48 set @saved_dbug = @@global.debug_dbug;
49 SET GLOBAL debug_dbug='d,injecting_fault_writing';
50 CREATE VIEW v1 AS SELECT a FROM t1;
51 CREATE VIEW v1 AS SELECT a FROM t1;
52 ERROR HY000: Error writing file 'master-bin' ((errno: #)
53 set @@global.debug_dbug = @saved_dbug;
54 set @saved_dbug = @@global.debug_dbug;
55 SET GLOBAL debug_dbug='d,injecting_fault_writing';
56 DROP VIEW v1;
57 DROP VIEW v1;
58 ERROR HY000: Error writing file 'master-bin' ((errno: #)
59 set @@global.debug_dbug = @saved_dbug;
60 set @saved_dbug = @@global.debug_dbug;
61 SET GLOBAL debug_dbug='d,injecting_fault_writing';
62 CREATE PROCEDURE p1(OUT rows_cnt INT) SELECT count(*) INTO rows_cnt FROM t1;
63 CREATE PROCEDURE p1(OUT rows_cnt INT) SELECT count(*) INTO rows_cnt FROM t1;
64 ERROR HY000: Error writing file 'master-bin' ((errno: #)
65 set @@global.debug_dbug = @saved_dbug;
66 set @saved_dbug = @@global.debug_dbug;
67 SET GLOBAL debug_dbug='d,injecting_fault_writing';
68 DROP PROCEDURE p1;
69 DROP PROCEDURE p1;
70 ERROR HY000: Error writing file 'master-bin' ((errno: #)
71 set @@global.debug_dbug = @saved_dbug;
72 set @saved_dbug = @@global.debug_dbug;
73 SET GLOBAL debug_dbug='d,injecting_fault_writing';
74 DROP TABLE t1;
75 DROP TABLE t1;
76 ERROR HY000: Error writing file 'master-bin' ((errno: #)
77 set @@global.debug_dbug = @saved_dbug;
78 set @saved_dbug = @@global.debug_dbug;
79 SET GLOBAL debug_dbug='d,injecting_fault_writing';
80 CREATE FUNCTION f1() RETURNS INT return 1;
81 CREATE FUNCTION f1() RETURNS INT return 1;
82 ERROR HY000: Error writing file 'master-bin' ((errno: #)
83 set @@global.debug_dbug = @saved_dbug;
84 set @saved_dbug = @@global.debug_dbug;
85 SET GLOBAL debug_dbug='d,injecting_fault_writing';
86 DROP FUNCTION f1;
87 DROP FUNCTION f1;
88 ERROR HY000: Error writing file 'master-bin' ((errno: #)
89 set @@global.debug_dbug = @saved_dbug;
90 set @saved_dbug = @@global.debug_dbug;
91 SET GLOBAL debug_dbug='d,injecting_fault_writing';
92 CREATE USER user1;
93 CREATE USER user1;
94 ERROR HY000: Error writing file 'master-bin' ((errno: #)
95 set @@global.debug_dbug = @saved_dbug;
96 set @saved_dbug = @@global.debug_dbug;
97 SET GLOBAL debug_dbug='d,injecting_fault_writing';
98 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1;
99 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1;
100 ERROR HY000: Error writing file 'master-bin' ((errno: #)
101 set @@global.debug_dbug = @saved_dbug;
102 set @saved_dbug = @@global.debug_dbug;
103 SET GLOBAL debug_dbug='d,injecting_fault_writing';
104 SET PASSWORD FOR user1=PASSWORD('foobar');
105 SET PASSWORD FOR user1=PASSWORD('foobar');
106 ERROR HY000: Error writing file 'master-bin' ((errno: #)
107 set @@global.debug_dbug = @saved_dbug;
108 set @saved_dbug = @@global.debug_dbug;
109 SET GLOBAL debug_dbug='d,injecting_fault_writing';
110 DROP USER user1;
111 DROP USER user1;
112 ERROR HY000: Error writing file 'master-bin' ((errno: #)
113 set @@global.debug_dbug = @saved_dbug;