Bug #34891 sp_notembedded.test fails sporadically
Submitted: 27 Feb 2008 16:26 Modified: 26 Mar 2008 16:27
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.1-bk OS:Any
Assigned to: Davi Arnaut CPU Architecture:Any

[27 Feb 2008 16:26] Alexander Nozdrin 
Description:
sp_notembedded.test fails from time to time.

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.sp_notembedded
[28 Feb 2008 14:27] 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/43152

ChangeSet@1.2550, 2008-02-28 17:28:33+03:00, anozdrin@quad. +2 -0
  Disable test case due to Bug#34891: sp_notembedded.test fails
  sporadically.
[28 Feb 2008 14:41] Alexander Nozdrin 
Test case has been disabled.

Pushed into 5.1-runtime.
[3 Mar 2008 18:19] Bugs System 
Pushed into 5.1.24-rc
[3 Mar 2008 18:19] Bugs System 
Pushed into 6.0.5-alpha
[12 Mar 2008 0:02] 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/43779

ChangeSet@1.2558, 2008-03-11 14:58:35-03:00, davi@mysql.com +2 -0
  Bug#34891 sp_notembedded.test fails sporadically
  
  Clean up sp_notembedded test case to avoid test failures
  due to timing issues.
[13 Mar 2008 17:54] 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/43951

ChangeSet@1.2563, 2008-03-13 14:54:29-03:00, davi@mysql.com +6 -0
  Bug#34891 sp_notembedded.test fails sporadically
  
  The problem is that since MyISAM's concurrent_insert is on by
  default some concurrent SELECT statements might not see changes
  made by INSERT statements in other connections, even if the
  INSERT statement has returned.
  
  The solution is to disable concurrent_insert so that INSERT
  statements returns after the data is actually visible to other
  statements.
[13 Mar 2008 17:56] Davi Arnaut 
Queued in 5.1-runtime
[26 Mar 2008 14:13] Bugs System 
Pushed into 5.1.24-rc
[26 Mar 2008 16:27] Paul DuBois 
Test case changes. No changelog entry needed.
[27 Mar 2008 17:50] Bugs System 
Pushed into 6.0.5-alpha