MySQL Bugs: #42083: main.mysql_client_test fails randomly in ps_stm

Bug #42083	main.mysql_client_test fails randomly in ps_stm_threadpool mode
Submitted:	13 Jan 2009 14:19	Modified:	28 May 2009 9:59
Reporter:	Alexander Nozdrin	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	6.0-TRUNK	OS:	Solaris (sol10-amd64-a)
Assigned to:	Alexey Botchkov	CPU Architecture:	Any
Tags:	pushbuild, sporadic, test failure

Description:
mysql_client_test failed randomly in ps_stm_threadpool mode.

Symptoms:
main.mysql_client_test         [ fail ]

mysqltest: At line 12: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.out.log 2>&1" failed

The result from queries just before the failure was:
exec of '/export/home/pushbuild/pb/bzr_mysql-6.0/114/mysql-6.0.10-alpha-pb114/tests/mysql_client_test --no-defaults --testcase --user=root --port=10060 --socket=/tmp/pbtmp-ps_stm_threadpool-6/master.sock --vardir=/tmp/var-ps_stm_threadpool-6 --getopt-ll-test=25600M >> /tmp/var-ps_stm_threadpool-6/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 29

More results from queries before failure can be found in /tmp/var-ps_stm_threadpool-6/log/mysql_client_test.log

Stopping All Servers

How to repeat:
XRef: http://preview.tinyurl.com/9ztl9z

Verified to also fail in this same fashion on the following:

MySQL Version 5.0.81

On Operating Systems:

Redhat Enterprise Linux 3 ES 32bit
Redhat Enterprise Linux 4 ES 32bit
Redhat Enterprise Linux 5 Server 32bit

As a follow-up, this test case did _not_ fail on the following:

MySQL Version 5.0.81

On Operating Systems:

Redhat Enterprise Linux 3 ES 64bit
Redhat Enterprise Linux 4 ES 64bit
Redhat Enterprise Linux 5 Server 64bit

Can't repeat this one and see that it doesn't happen in the PB for the long time.

5.0.81 version doesn't have the threadpool mode at all, so have no idea how it works there with this switch.