MySQL Bugs: #13796: Missing restart makes "show full processlist" results differ

Bug #13796	Missing restart makes "show full processlist" results differ
Submitted:	6 Oct 2005 8:49	Modified:	31 Oct 2005 18:17
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed
Category:	Server	Severity:	S3 (Non-critical)
Version:	5.0.14 and others	OS:	Unix (various)
Assigned to:	Jim Winstead	Target Version:

Description:
This seems to be a general issue with the test suite,
but the bug DB has no such category any more :-\

For 4.1, a similar symptom in "ps_grant" is reported in bug#11943, probably resulting
from different timing;
for 5.0.14-rc, that also occurred in test "skip_name_resolve", added to that bug report.

Here it is more obvious IMO.

-------------------------------------------------------
*** r/not_embedded_server.result
--- r/not_embedded_server.reject
***************
*** 1,5
--- 1,6
  prepare stmt1 from ' show full processlist ';
  execute stmt1;
  Id    User    Host    db      Command Time    State   Info
+ number        root    localhost       test    Query   time    Writing to net  drop
table t1
  number        root    localhost       test    Query   time    NULL    show full
processlist
  deallocate prepare stmt1;
-------------------------------------------------------

Occurred: powermacg5-5.0-pro.log   normal

The comment in the test file states explicitly:
#
# Show full process list with prepare
# To not show other connections, this must be the first test and we must
# have a server restart before this one
#
As this statement is the only one run in the test, it seems the condition in the comment
is not met.
IMO, a forced restart is needed, or a delay.

How to repeat:
Run the test suite, prefereably on a slow / loaded machine.

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/internals/31054

Fixed in 4.1.16 and 5.0.16.