Debian Codegraph @

mysql-test/suite/binlog/r/binlog_write_error.result

raw
1 #
2 # Initialization
3 #
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;
12 #
13 # Test injecting binlog write error when executing queries
14 #
15 CREATE TABLE t1 (a INT);
16 CREATE TABLE t1 (a INT);
17 ERROR HY000: Error writing file 'binlog' ((errno: #)
18 # The above CREATE TABLE should be rolled back.
19 # Now we check this fact and create table for real.
20 SELECT * FROM t1;
21 ERROR 42S02: Table 'test.t1' doesn't exist
22 CREATE TABLE t1 (a INT);
23 INSERT INTO t1 VALUES (1),(2),(3);
24 INSERT INTO t1 VALUES (4),(5),(6);
25 INSERT INTO t1 VALUES (4),(5),(6);
26 ERROR HY000: Error writing file 'binlog' ((errno: #)
27 UPDATE t1 set a=a+1;
28 UPDATE t1 set a=a+1;
29 ERROR HY000: Error writing file 'binlog' ((errno: #)
30 DELETE FROM t1;
31 DELETE FROM t1;
32 ERROR HY000: Error writing file 'binlog' ((errno: #)
33 # Check that the above DML statements were rolled back and
34 # had no effect on t1.
35 SELECT * FROM t1;
36 a
37 1
38 2
39 3
40 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t1 VALUES (new.a + 100);
41 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t1 VALUES (new.a + 100);
42 ERROR HY000: Error writing file 'binlog' ((errno: #)
43 SHOW CREATE TRIGGER tr1;
44 ERROR HY000: Trigger does not exist
45 ALTER TABLE t1 ADD (b INT);
46 ALTER TABLE t1 ADD (b INT);
47 ERROR HY000: Error writing file 'binlog' ((errno: #)
48 # The above ALTER TABLE was rolled back. Check this.
49 SHOW CREATE TABLE t1;
50 Table Create Table
51 t1 CREATE TABLE `t1` (
52 `a` int DEFAULT NULL
53 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
54 CREATE VIEW v1 AS SELECT a FROM t1;
55 CREATE VIEW v1 AS SELECT a FROM t1;
56 ERROR HY000: Error writing file 'binlog' ((errno: #)
57 # The above CREATE VIEW was rolled back. Check this.
58 SHOW CREATE VIEW v1;
59 ERROR 42S02: Table 'test.v1' doesn't exist
60 CREATE PROCEDURE p1(OUT `rows` INT) SELECT count(*) INTO `rows` FROM t1;
61 CREATE PROCEDURE p1(OUT `rows` INT) SELECT count(*) INTO `rows` FROM t1;
62 ERROR HY000: Error writing file 'binlog' ((errno: #)
63 # The above CREATE Procedure was rolled back. Check this.
64 SHOW CREATE PROCEDURE p1;
65 ERROR 42000: PROCEDURE p1 does not exist
66 DROP TABLE t1;
67 DROP TABLE t1;
68 ERROR HY000: Error writing file 'binlog' ((errno: #)
69 # The above DROP TABLE was rolled back. Delete it for real
70 # this also checks that table was not deleted by the above
71 # attempt.
72 DROP TABLE t1;
73 CREATE FUNCTION f1() RETURNS INT return 1;
74 CREATE FUNCTION f1() RETURNS INT return 1;
75 ERROR HY000: Error writing file 'binlog' ((errno: #)
76 # The above CREATE Procedure was rolled back. Check this.
77 SHOW CREATE FUNCTION f1;
78 ERROR 42000: FUNCTION f1 does not exist
79 CREATE USER user1;
80 CREATE USER user1;
81 ERROR HY000: Error writing file 'binlog' ((errno: #)
82 # Since the previous CREATE USER is failed due to an error while writing
83 # to binlog and changes made by the statement has been rolled back
84 # we have to create user1 to be able to test REVOKE ALL and DROP USER.
85 CREATE USER user1;
86 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1;
87 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1;
88 ERROR HY000: Error writing file 'binlog' ((errno: #)
89 DROP USER user1;
90 DROP USER user1;
91 ERROR HY000: Error writing file 'binlog' ((errno: #)
92 # Since the previous DROP USER is failed we have to do a clean up explicitly.
93 DROP USER user1;
94 #
95 # Cleanup
96 #
97 DROP FUNCTION IF EXISTS f1;
98 DROP PROCEDURE IF EXISTS p1;
99 DROP VIEW IF EXISTS v1, v2;