Bug #37493 rpl_trunc_temp.test nondeterministic
Submitted: 18 Jun 2008 19:30 Modified: 1 Oct 2008 14:23
Reporter: Timothy Smith Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.1, 6.0 OS:Any
Assigned to: Sven Sandberg CPU Architecture:Any
Tags: pbfail, pushbuild, sporadic, test failure

[18 Jun 2008 19:30] Timothy Smith
Description:
In rare cases, rpl.rpl_trunc_temp fails due to a race condition.

rpl.rpl_trunc_temp             [ fail ]

CURRENT_TEST: rpl.rpl_trunc_temp
--- /Users/henry/pb/bzr_mysql-6.0-rpl/11/mysql-6.0.6-alpha-pb11/mysql-test/suite/rpl/r/rpl_trunc_temp.result	Sat Jun 14 13:43:46 2008
+++ /Users/henry/pb/bzr_mysql-6.0-rpl/11/mysql-6.0.6-alpha-pb11/mysql-test/suite/rpl/r/rpl_trunc_temp.reject	Sat Jun 14 18:07:32 2008
@@ -19,4 +19,4 @@
 Slave_open_temp_tables	1
 show status like 'Slave_open_temp_tables';
 Variable_name	Value
-Slave_open_temp_tables	0
+Slave_open_temp_tables	1

mysqltest: Result content mismatch

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...

This failure has happened 6 times in the past 6 months.
[28 Jun 2008 12:06] Sven Sandberg
Failures are, e.g., here:

  WHERE: 6.0-rpl/aelkin on Sat Jun 14 10:05:24 2008/'powermacg5' -max/ps_stm
  URL: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=11
  --
  WHERE: bk:5.1-maint2/msvensson@pilot.mysql.com on Sun Apr 27 23:30:31 2008/'vm-win2003-32-a' Win32 VS2003 -max-nt/n_mix
  URL: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=mysql-5.1-maint2&order=52
[23 Jul 2008 10:08] 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/50284

2706 Sven Sandberg	2008-07-23
      BUG#37493: rpl_trunc_temp.test nondeterministic
      Problem: the test waits for a 'DROP TEMPORARY TABLE' event to
      appear in the master's binlog, then checks on the slave whether
      the number of temporary tables has decreased. The slave does
      not sync, causing a race.
      Fix: check for the 'DROP TEMPORARY TABLE' event on slave
      instead of on master.
[14 Aug 2008 7: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/51600

2677 He Zhenxing	2008-08-14 [merge]
      Merge with mysql-5.1-rpl-testfixes
[15 Aug 2008 2:01] 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/51688

2769 He Zhenxing	2008-08-15 [merge]
      Merge 6.0-rpl-testfixes -> 6.0
[19 Aug 2008 19:55] Bugs System
Pushed into 6.0.7-alpha  (revid:sven@mysql.com-20080723101355-wmm76qzkt2xgpamy) (version source revid:sven@mysql.com-20080818175803-c1nutd5773r6b4gd) (pib:3)
[19 Aug 2008 20:29] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to Patch Queued pending push of fix into 5.1.x.
[25 Aug 2008 21:04] Chuck Bell
Released in 6.0.7
[27 Aug 2008 1:14] Paul DuBois
No changelog entry needed.
[27 Aug 2008 1:18] Paul DuBois
Setting report to NDI pending push into 5.1.x.
[28 Aug 2008 20:16] Bugs System
Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)
[29 Aug 2008 0:39] Paul DuBois
Setting report to NDI pending push into 5.1.x.
[1 Sep 2008 7:44] Zhenxing He
Test case fix only
[2 Sep 2008 18:17] Paul DuBois
Setting report to NDI pending push into 5.1.x.
[14 Sep 2008 4:27] Bugs System
Pushed into 6.0.7-alpha  (revid:sven@mysql.com-20080723101355-wmm76qzkt2xgpamy) (version source revid:hakan@mysql.com-20080721095625-h2pyxb88uwtjeavf) (pib:3)
[15 Sep 2008 19:08] Paul DuBois
Setting report to NDI pending push into 5.1.x.