Bug #42686 Sporadic failure of rpl_server_id1 test, inside show_rpl_debug_info.inc
Submitted: 9 Feb 2009 11:10 Modified: 21 May 2009 7:03
Reporter: Rafal Somla Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:6.0-backup-merge OS:Any
Assigned to: Zhenxing He CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[9 Feb 2009 11:10] Rafal Somla
Description:
This is a sporadic pushbuild failure observed on vm-win2003-32-a architecture.

MTR reports:

mysqltest: In included file ".\include\show_rpl_debug_info.inc": At line 80: query 'SHOW BINLOG EVENTS IN '$master_binlog_name_sql'' failed: 1220: Error when executing command SHOW BINLOG EVENTS: Could not find target log

In the above PB run the test was executed 3 times and passed 2 of these 3 times:

> rpl.rpl_server_id1                       [ fail ]
>         Test ended at 2009-02-07 14:07:41
...
> 
> Retrying test, attempt(2/3)...
> 
> rpl.rpl_server_id1                       [ pass ]    766
> 
> Retrying test, attempt(3/3)...
> 
> rpl.rpl_server_id1                       [ pass ]   1187

This can be related to slow execution times on vm machine and the test or include file being non-deterministic wrt. how fast they are executed.

Note: the problem might be not in rpl_server_id1 test but in the include file show_rpl_debug_info.inc, which, as far as I understand, can be included during excecution of any rpl test.

How to repeat:
See this PB on vm-win2003-32-a:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-backup-merge&ord...