MySQL Bugs: #11943: Test failure: "ps

Bug #11943	Test failure: "ps_grant"
Submitted:	14 Jul 2005 16:09	Modified:	9 Apr 2008 9:22
Reporter:	Lenz Grimmer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1.13-pre + 5.0.14-rc	OS:	FreeBSD (FreeBSD, Linux/IA64)
Assigned to:		CPU Architecture:	Any

Description:
The following test result difference currently occurs in the ongoing 4.1.13 release builds, but only on two platforms: Linux/IA64 (Red Hat AS 2.1) and FreeBSD/x86 4.8 with LinuxThreads:

08566: ps_grant                       [ fail ]
08567: 
08568: Errors are (from /home/mysqldev/ita2-rhas21/test/mysql-debug-4.1.13-unknown-linux-gnu-ia64-rhas21/mysql-test/var/log/mysqltest-time) :
08569: /home/mysqldev/ita2-rhas21/test/mysql-debug-4.1.13-unknown-linux-gnu-ia64-rhas21/bin/mysqltest: At line 121: Result length mismatch
08570: (the last lines may be the most important ones)
08571: Below are the diffs between actual and expected results:
08572: -------------------------------------------------------
08573: *** r/ps_grant.result	Wed Jul 13 15:44:42 2005
08574: --- r/ps_grant.reject	Thu Jul 14 01:14:55 2005
08575: ***************
08576: *** 79,81 ****
08577: --- 79,82 ----
08578:   execute stmt4;
08579:   Id	User	Host	db	Command	Time	State	Info
08580:   number	root	localhost	test	Execute	time	NULL	show full processlist
08581: + number	second_user	localhost	mysqltest	Execute	time	Writing to net	select a as my_col from t1
08582: -------------------------------------------------------

How to repeat:
Run the ps_grant test on said platforms

I have the same problem on Linux (Slackware 8.0 on Intel PIII) with mysql 4.1.13:

software@minerva:~/mysql-4.1.13/mysql-test=>mysql-test-run --local ps_grant 
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb     --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb     --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
ps_grant                       [ fail ]

Errors are (from /usr/local/src/mysql-4.1.13/mysql-test/var/log/mysqltest-time) :
/usr/local/src/mysql-4.1.13/client/.libs/lt-mysqltest: At line 121: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ps_grant.result   Fri Jul 15 13:50:20 2005
--- r/ps_grant.reject   Fri Jul 29 14:33:43 2005
***************
*** 79,81 ****
--- 79,82 ----
  execute stmt4;
  Id    User    Host    db      Command Time    State   Info
  number        root    localhost       test    Execute time    NULL    show full processlist
+ number        second_user     localhost       mysqltest       Execute time    Writing to net  select a as my_col from t1
-------------------------------------------------------

This test is practically the same one of version 4.1.12.
I have seen that this code moved from row 4 to the end, may be this the problem?
In result hhe state changed from Query to Execute

The ps_grant.test of 4.1.12 run ok on 4.1.13 after replace Query with Excecute in pg_grant.result (copied from 4.1.12).

Similar issue in 5.0.14-rc:

-------------------------------------------------------
*** r/skip_name_resolve.result
--- r/skip_name_resolve.reject
***************
*** 10,14
  #
  show processlist;
  Id    User    Host    db      Command Time    State   Info
! #     root    #       test    Sleep   #               NULL
  #     root    #       test    Query   #       NULL    show processlist
--- 10,14
  #
  show processlist;
  Id    User    Host    db      Command Time    State   Info
! #     root    #       test    Query   #       Writing to net  DROP USER mysqltest_1@'127.0.0.1/255.255.255.255'
  #     root    #       test    Query   #       NULL    show processlist
-------------------------------------------------------

Occurred:
powermacg5-5.0-debug.log   normal
xserve-5.0-max.log   normal

It might be necessary to insert delays into the test stream, before a "show processlist".

Kent, Calvin, Antony, I believe this is not relevant any more.