1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
# ==== Purpose ====
#
# Prove a group of events is logged correctly including
# a terminal Query-log-event(COMMIT), despite a failing atomic DDL
# in front of the group generating query.
#
#
# ==== References ====
# BUG25755137 MASTER IS GENERATING INCOMPLETE TRX ON BINARY LOG (MISSING COMMIT)
#
--source include/have_debug_sync.inc
--source include/have_log_bin.inc
--source include/have_binlog_format_statement.inc
# In order to construct the deadlock error two tables and a view
# based on them are required.
CREATE TABLE t1 (a int);
CREATE TABLE t2 (a int);
CREATE VIEW v_12 AS SELECT t1.a AS a, t2.a AS b FROM t1,t2;
# The Commit-free group generator.
CREATE TEMPORARY TABLE tmp (a INT) ENGINE=innodb;
--connection default
SET DEBUG_SYNC= 'action_after_write_bin_log WAIT_FOR continue';
--send ALTER TABLE t2 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1
# Deadlock's 2nd participant
--connect (con1, localhost, root,,)
DROP TABLE t1,t2;
SET DEBUG_SYNC= 'now SIGNAL continue';
--connection default
--error ER_LOCK_DEADLOCK
--reap
#
# the group generator
#
--source include/save_binlog_position.inc
DELETE FROM tmp;
#
# Proof:
# the whole group of BEGIN; DELETE...; COMMIT must be present
#
--let $gtid_event=!Gtid_or_anon
--let $event_sequence= $gtid_event # !Begin # !Q(DELETE.*) # !Commit
--source include/assert_binlog_events.inc
--let $dont_print_pattern= 0
# Cleanup:
DROP VIEW v_12;
|
