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

-DEBUG_SYNC	ON - signals: ''
+DEBUG_SYNC	ON - signals: 'have_gtid_mode_lock'
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.