| Bug #23312 | server hangs 'closing tables' with insert delayed,flush tables,alter table | ||
|---|---|---|---|
| Submitted: | 16 Oct 2006 0:59 | Modified: | 16 Jan 2007 8:27 |
| Reporter: | Shane Bester | ||
| Status: | Closed | ||
| Category: | Server: Locking | Severity: | S1 (Critical) |
| Version: | 5.1.12, 5.0.26,5.0.27-debug, 4.1.21,4.0.27 | OS: | Linux (suse 9.3 x86/Win2000) |
| Assigned to: | Sergey Vojtovich | Target Version: | |
| Tags: | insert delayed closing tables opening tables hang alter table | ||
If the data you need to attach is more than 500KB, you should create
a compressed archive of the data and a README file that describes the data
with a filename that includes the bug number (example:
bug-data-23312.zip), and use FTP to upload the archive
to ftp://ftp.mysql.com/pub/mysql/upload/.
Once you have uploaded the file, add a comment to this bug to notify us about
it. Note: This directory is unlistable, which means that once you
have uploaded your file, you will not be able to see it.
All entries become the exclusive editorial property of Sun Microsystems, Inc.
[16 Oct 2006 1:03]
Shane Bester
[16 Oct 2006 1:12]
Shane Bester
show full processlist during a hangup
Attachment: processlist.txt (plain/text, text), 11.11 KiB.
[16 Oct 2006 1:42]
Shane Bester
happens on windows too, so it cannot be nptl related
Attachment: stacktraces_windows.txt (plain/text, text), 15.10 KiB.
[16 Oct 2006 2:23]
Shane Bester
affects 4.0.27 too
Attachment: processlist_4.0.27.txt (plain/text, text), 6.26 KiB.
[16 Oct 2006 10:02]
Shane Bester
stack traces 5.0.26-windows with more debug information
Attachment: 5.0.26_vs.net_threads.txt (plain/text, text), 59.60 KiB.
