| 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; |