Bug #37809 main.create fails sporadically

• Submitted: 2 Jul 2008 16:52
• Modified: 23 Sep 2008 11:53
• Reporter: Alexander Nozdrin
• Status: Can't repeat
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 6.0-BK
• OS: Any
• Assigned to: Matthias Leich
• CPU Architecture: Any
• Tags: pushbuild, sporadic, test failure

[2 Jul 2008 16:52] Alexander Nozdrin

Description:
@@ -288,7 +288,7 @@
 Error	1062	Duplicate entry '3' for key 'PRIMARY'
 show status like "Opened_tables";
 Variable_name	Value
-Opened_tables	2
+Opened_tables	3
 select * from t1;
 a	b
 1	1

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.create
Date: 2008-07-01

[28 Jul 2008 13:52] Alexander Nozdrin

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

[23 Sep 2008 11:53] Matthias Leich

1. Within the Pushbuild history we have only two cases
(https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...)
   where this test failed with the symptoms described.
   They appeared in July 2008.
2. I made stability tests - a lot runs of this test with and without
   high parallel load - on my box and was unable to reproduce the problem.
   So it looks like as if the two failing Pushbuild runs were caused
   by a temporary bad state of mysql-6.0 server sources.