Bug #17756 Unstable test case 'sp_notembedded' and test "call bug4902_2()"
Submitted: 27 Feb 2006 22:29 Modified: 8 May 2006 19:26
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S2 (Serious)
Version:5.0 + 5.1 OS:Various Unix
Assigned to: Alexey Botchkov CPU Architecture:Any

[27 Feb 2006 22:29] Kent Boortz 
Description:
Test case 'sp_notembedded' not stable, giving failures on

  call bug4902_2()|
  Id    User    Host    db      Command Time    State   Info
+ #     root    localhost       test    Query   #       Writing to net  drop table t1,t2
  #     root    localhost       test    Query   #       NULL    show processlist
  call bug4902_2()|
  Id    User    Host    db      Command Time    State   Info
+ #     root    localhost       test    Query   #       Writing to net  drop table t1,t2
  #     root    localhost       test    Query   #       NULL    show processlist

How to repeat:
Run test case 'sp_notembedded' a number of times.
[3 Apr 2006 10:12] Joerg Bruehe 
Release (?) build of 5.0.20, based on ChangeSet
  1.2117 06/03/31 11:48:08 lars@mysql.com +1 -0
  BUG#18116: Changed of how mutex is handled for XA and rotating binlog

Similar symptom:
-------------------------------------------------------
*** r/sp_notembedded.result
--- r/sp_notembedded.reject
***************
*** 17,25
--- 17,27
  end|
  call bug4902_2()|
  Id    User    Host    db      Command Time    State   Info
+ #     root    localhost       test    Query   #       freeing items   drop table t1,t2
  #     root    localhost       test    Query   #       NULL    show processlist
  call bug4902_2()|
  Id    User    Host    db      Command Time    State   Info
+ #     root    localhost       test    Query   #       freeing items   drop table t1,t2
  #     root    localhost       test    Query   #       NULL    show processlist
  drop procedure bug4902_2|
  drop function if exists bug5278|
-------------------------------------------------------
OCCURRED:
hp3750-64bit-5.0-cluster.log   normal
hp3750-64bit-5.0-pro-gpl.log   normal
hp3750-64bit-5.0-pro.log   normal
hp3750-64bit-5.0-standard.log   normal
[10 Apr 2006 17:29] Brian Pontz 
5.1.9-pre has this test failure as well.

sp_notembedded                 [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query 'call bug10100p(255, @var)' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1436...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/sp_notembedded.log

Killing Possible Leftover Processes
[12 Apr 2006 8:50] Alexander Barkov 
The patch looks ok to push.
[8 May 2006 19:26] Paul DuBois 
No changelog entry needed.