Bug #32217 rpl_ssl fails with different number of records on master and slave
Submitted: 9 Nov 2007 10:11 Modified: 5 Sep 2008 15:40
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Magnus Blåudd CPU Architecture:Any

[9 Nov 2007 10:11] Magnus Blåudd 
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-test/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-test\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 10: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 17: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...

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