Bug #32217 rpl_ssl fails with different number of records on master and slave
Submitted: 9 Nov 2007 11:11 Modified: 5 Sep 17:40
Reporter: Magnus Svensson
Status: Closed
Category:Tests: Replication Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Magnus Svensson Target Version:6.0
Triage: D3 (Medium)

[9 Nov 2007 11:11] Magnus Svensson 
Description:
The rpl_ssl test case fails randomly with what appears to be differern number of records
in master and slave server.

rpl.rpl_ssl                    [ fail ]

---
C:/cygwin/home/pushbuild/pb3/pb/mysql-6.0-falcon-kevin/45/mysql-6.0.4-alpha-pb45/mysql-tes
t/suite/rpl/r/rpl_ssl.result	2007-11-08 08:46:47.000000000 +0300
+++
C:\cygwin\home\pushbuild\pb3\pb\mysql-6.0-falcon-kevin\45\mysql-6.0.4-alpha-pb45\mysql-tes
t\suite\rpl\r\rpl_ssl.reject	2007-11-08 09:27:13.212250000 +0300
@@ -102,6 +102,9 @@
 Last_IO_Error	#
 Last_SQL_Errno	0
 Last_SQL_Error	
+master and slave differed in number of rows
+master: 102
+slave: 101
 drop user replssl@localhost;
 drop table t1;
 End of 5.0 tests
vm-win2003-64-b

How to repeat:
Occurs primarily in PushBuild on valgrind hosts and vm-win2003-64-b
[9 Nov 2007 11:17] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/37420

ChangeSet@1.2614, 2007-11-09 11:16:47+01:00, msvensson@pilot.mysql.com +1 -0
  Bug#32217 rpl_ssl fails with different number of records on master and slave
   - Add debug queries
[26 Nov 2007 18:58] Ingo Strüwing 
I wonder why the last comment says "pushed to 5.1-maint", but the bug report is "in
progress" and no review done.

Anyway, I increased the priority because this happens quite frequently in pushbuild. E.g.
https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-6.0-engines&entry=istruewi
ng@stella.local-20071125214152&name=test_rpl_binlog_row&plat=vm-win2003-64-b

Disabling test case for now. When this is fixed (or pushed to main), please re-enable the
test case.
[28 Nov 2007 11:23] Bugs System 
Pushed into 6.0.4-alpha
[8 Dec 2007 0:08] Bugs System 
Pushed into 6.0.5-alpha
[8 Dec 2007 0:09] Bugs System 
Pushed into 5.1.23-rc
[5 Sep 17:40] Magnus Svensson 
Test haven't failed in the last 6 months
[17 Sep 10:28] Sveta Smirnova 
Bug #32756 was marked as duplicated of this one.