Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_group_commit_gtid_order.result

raw
1 RESET MASTER;
2 SET @@GLOBAL.DEBUG= '+d, disable_gtid_background_persister';
3 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
4 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
5 SET @free_intervals_mutex_before= (
6 SELECT COUNT_STAR
7 FROM performance_schema.events_waits_summary_global_by_event_name WHERE
8 EVENT_NAME='wait/synch/mutex/sql/Gtid_set::gtid_executed::free_intervals_mutex');
9 SET GLOBAL binlog_group_commit_sync_delay=1000000;
10 # Create two new connections: con1 and con2
11 # At con1
12 SET DEBUG_SYNC='reached_finish_commit SIGNAL go_con2 WAIT_FOR go_con1';
13 INSERT INTO t1 VALUES (1);
14 # At con2
15 # Adding debug point 'leaving_finish_commit' to @@SESSION.debug
16 SET DEBUG_SYNC='now WAIT_FOR go_con2';
17 INSERT INTO t2 VALUES (2);
18 SET DEBUG_SYNC='now WAIT_FOR signal_leaving_finish_commit';
19 SET DEBUG_SYNC='now SIGNAL go_con1';
20 # Removing debug point 'leaving_finish_commit' from @@SESSION.debug
21 # At default connection
22 include/assert.inc ["The first insert has finished"]
23 include/assert.inc ["No gaps should exist in gtid_executed after the second insert"]
24 SET @free_intervals_mutex_after= (
25 SELECT COUNT_STAR
26 FROM performance_schema.events_waits_summary_global_by_event_name WHERE
27 EVENT_NAME='wait/synch/mutex/sql/Gtid_set::gtid_executed::free_intervals_mutex');
28 include/assert.inc ["gtid_executed::free_intervals_mutex wasn't used"]
29 SET GLOBAL binlog_group_commit_sync_delay=0;
30 SET @@GLOBAL.DEBUG= '-d, disable_gtid_background_persister';
31 DROP TABLE t1, t2;
32 RESET MASTER;