MySQL Bugs: #18987: Crashes during test "connect"

Bug #18987	Crashes during test "connect"
Submitted:	10 Apr 2006 20:12	Modified:	4 Oct 2006 17:55
Reporter:	Joerg Bruehe	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.20 + 5.1.10	OS:	different Unix
Assigned to:	Magnus Blåudd	CPU Architecture:	Any

Description:
Release build of 5.0.20

=====
connect                        [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query 'connect (fail_con,localhost,root,z,)' failed with wrong errno 2013: 'Lost connection to MySQ
L server during query', instead of 1045...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/connect.log

Killing Possible Leftover Processes
Restoring snapshot of databases
Resuming Tests
===
powermacg5-5.0-max.log   normal

=====
connect                        [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query 'connect (fail_con,localhost,test,,"")' failed with wrong errno 2013: 'Lost connection to MyS
QL server during query', instead of 1045...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/connect.log

Killing Possible Leftover Processes
Restoring snapshot of databases
Resuming Tests
===
rx2620b-icc-glibc23-5.0-cluster.log   normal

=====
connect                        [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query 'connect (fail_con,localhost,test,zorro,)' failed with wrong errno 2013: 'Lost connection to
MySQL server during query', instead of 1045...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/connect.log

Killing Possible Leftover Processes
Restoring snapshot of databases
Resuming Tests
===
hpux11-64bit-5.0-max.log   ps
rx2620b-icc-glibc23-5.0-max.log   ps

=====
connect                        [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query 'connect (fail_con,localhost,test,zorro,test2)' failed with wrong errno 2013: 'Lost connectio
n to MySQL server during query', instead of 1045...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/connect.log

Killing Possible Leftover Processes
Restoring snapshot of databases
Resuming Tests
===
sunfire100b-5.0-standard.log   ps
granny-5.0-pro-gpl.log   ps

How to repeat:
Run the test suite.

First such effect occurred in 5.0.19 and 5.1.9-beta
(according to the test isolation, may be incomplete),
in 5.0.20 and 5.1.10-beta it increased.

Tested with latest 5.0 and 5.1, cannot repeat the problem. Tests pass. Using latest bk source, 5.0.23 and 5.1.12-beta.

Platform: SuSE 10.0, i686
gcc: 4.0.2 (standard SuSE package)

If someone can repeatedly repeat this problem, please turn on the debug with mysql-test-run. mysql-test-run --debug. Please include also information on the platform used. Please attach also information about the build; was it compiled from source or a binary?

Once started with --debug, please check the trace file after a broken test. It should be compared with a trace file of the same test on a platform where it passes. Source must the same for both.

I confirm Jani's last result:
In test builds, both 5.0.23 and 5.1.12 pass this test on all platforms.
It seems some in-between change fixed this as a by-product.

Sorry about bad news:


The bug re-occurred in the release build for 5.0.25,
In the "prepared statement" run of a "standard" build on SCO.

I will try to repeat it, using the "debug" test run as asked by Jani (above).