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
• Status: Can't repeat
• 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.