Bug #86321 Test binlog.binlog_gtid_state_update_deadlock is failing
Submitted: 15 May 2017 9:03 Modified: 15 May 2017 10:40
Reporter: Robert Golebiowski (OCA) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.7.18 OS:Linux
Assigned to: CPU Architecture:Any

[15 May 2017 9:03] Robert Golebiowski
Description:
Test binlog.binlog_gtid_state_update_deadlock is failing is failing on 5.7:

MTR's internal check of the test case 'binlog.binlog_gtid_state_update_deadlock' failed.
This means that the test case does not preserve the state that existed
before the test case was executed.  Most likely the test case did not
do a proper clean-up. It could also be caused by the previous test run
by this thread, if the server wasn't restarted.
This is the diff of the states of the servers before and after the test case was executed:

WAIT_TIMEOUT	28800
VARIABLE_NAME	VARIABLE_VALUE
-DEBUG_SYNC	ON - signals: ''
+DEBUG_SYNC	ON - signals: 'have_gtid_mode_lock'
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH
def	information_schema	utf8	utf8_general_ci	NULL
def	mtr	latin1	latin1_swedish_ci	NULL

How to repeat:
Run test binlog.binlog_gtid_state_update_deadlock.
[15 May 2017 10:00] Robert Golebiowski
Pull request: https://github.com/mysql/mysql-server/pull/143
[15 May 2017 10:40] Miguel Solorzano
Thank you for the bug report. I couldn't repeat on my recent source server:

miguel@ural:~/build/2017MAY01/mysql-5.7/mysql-test $ ./mtr binlog.binlog_gtid_state_update_deadlock --big-test
Logging: ./mtr  binlog.binlog_gtid_state_update_deadlock --big-test
MySQL Version 5.7.19
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
 - adding combinations for binlog
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/miguel/build/2017MAY01/mysql-5.7/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
binlog.binlog_gtid_state_update_deadlock 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
binlog.binlog_gtid_state_update_deadlock 'row' [ skipped ]  Doesn't support --binlog-format='row'
binlog.binlog_gtid_state_update_deadlock 'stmt' [ pass ]  601965
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 601.965 of 631 seconds executing testcases

Completed: All 1 tests were successful.

2 tests were skipped, 0 by the test itself.

miguel@ural:~/build/2017MAY01/mysql-5.7/mysql