Bug #58083 Test rpl.rpl_server_uuid fails after 5 minutes in trunk-bugfixing
Submitted: 9 Nov 2010 13:27 Modified: 10 Nov 2010 13:45
Reporter: Bjørn Munch Email Updates:
Status: Duplicate Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any

[9 Nov 2010 13:27] Bjørn Munch
Description:
The test consistently fails on my OpenSolaris x86 after having been stuck somwehere for 5+ minutes:

rpl.rpl_server_uuid 'mix'                [ fail ]
        Test ended at 2010-11-09 14:23:05

CURRENT_TEST: rpl.rpl_server_uuid
mysqltest: In included file "./include/wait_for_slave_param.inc": At line 83: 

The result from queries just before the failure was:
< snip >
**** SHOW BINLOG EVENTS on master ****
SHOW BINLOG EVENTS IN 'master-bin.000001';
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
master-bin.000001       4       Format_desc     1       107     Server ver: 5.6.1-m4-debug-log, Binlog ver: 4
master-bin.000001       107     Query   1       174     BEGIN
master-bin.000001       174     Query   1       383     use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Slave I/O thread .* register on master' COLLATE 'latin1_swedish_ci'))
master-bin.000001       383     Query   1       451     COMMIT
master-bin.000001       451     Query   1       518     BEGIN
master-bin.000001       518     Query   1       744     use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Slave I/O: Master command COM_REGISTER_SLAVE failed: .*' COLLATE 'latin1_swedish_ci'))
master-bin.000001       744     Query   1       812     COMMIT
master-bin.000001       812     Query   1       879     BEGIN
master-bin.000001       879     Query   1       1100    use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'.*master and slave have equal MySQL server UUIDs.*' COLLATE 'latin1_swedish_ci'))
master-bin.000001       1100    Query   1       1168    COMMIT
master-bin.000001       1168    Query   1       1235    BEGIN
master-bin.000001       1235    Query   1       1451    use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Master\'s UUID has changed, its old UUID is.*' COLLATE 'latin1_swedish_ci'))
master-bin.000001       1451    Query   1       1519    COMMIT
master-bin.000001       1519    Stop    1       1538
SHOW BINLOG EVENTS IN 'master-bin.000002';
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
master-bin.000002       4       Format_desc     1       107     Server ver: 5.6.1-m4-debug-log, Binlog ver: 4

How to repeat:
On debug build from mysql-trunk-bugfixing:

./mtr rpl.rpl_server_uuid

Also seen in PB2 under Linux gcov, only debug build that has been run for (current) last pageful of pushes.

This test requires debug build and this isn't seen failing on non-debug builds in PB2.
[10 Nov 2010 13:45] Bjørn Munch
Further analysis shows this was caused by the master not re-reading auto.cnf and thus not getting a new UUID.

This is reported in Bug #58109, closing as duplicate.