Bug #14970 Test "mysqldump" hangs if using the Perl test suite script
Submitted: 16 Nov 2005 9:02 Modified: 18 Jan 2006 14:35
Reporter: Joerg Bruehe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.16 OS:various Unix
Assigned to: Kristian Nielsen CPU Architecture:Any

[16 Nov 2005 9:02] Joerg Bruehe
Description:
(Missing category: Test suite and tools)

Test "mysqldump" does not terminate (sometimes) if the suite is run by the Perl script.

Symptom:
=== cut ===
mysqldump                      [ fail ]  timeout

Errors are (from PATH/mysqltest-time) :

(the last lines may be the most important ones)

Ending Tests
=== cut ===

It is not "mysqld" that hangs but "mysqladmin".

Occurred in the GPL builds of 5.0.16 in these runs:
hpita2-64bit-5.0-max.log   normal
aix52-5.0-debug.log   normal
butch-64bit-5.0-debug.log   normal
butch-64bit-5.0-debug.log   ps-protocol
cane-linuxthreads-5.0-debug.log   normal
ita2-rhas21-5.0-debug.log   normal
ita2-rhas21-5.0-debug.log   ps-protocol
sol10-x86-5.0-debug.log   ps-protocol
sol9x86-5.0-debug.log   normal
sol9x86-5.0-debug.log   ps-protocol
butch-64bit-5.0-standard.log   ps-protocol
ita2-rhas21-5.0-standard.log   normal
powermacg5-5.0-standard.log   ps-protocol
sol9x86-5.0-standard.log   normal

Kristian Nielsen has done a detailed analysis which he will append.

How to repeat:
Test suite problem, but sometimes only.

Suggested fix:
Extend the Perl script to also but a watchdog around "mysqladmin",
or prevent that tool from hanging.
[16 Nov 2005 9:18] Kristian Nielsen
gdb `thread apply all bt full' for mysqld process

Attachment: 2 (application/octet-stream, text), 29.47 KiB.