Bug #17332 changing key_buffer_size on a running server can crash under load
Submitted: 12 Feb 2006 22:38 Modified: 7 Oct 3:04
Reporter: Shane Bester
Status: Closed
Category:Server: MyISAM Severity:S2 (Serious)
Version:4.1BK,5.0.18, 5.0.19-bk,5.0.21-bk OS:Linux (Linux,Windows)
Assigned to: Ingo Strüwing Target Version:5.0+
Tags: crash, key_buffer_size, load index, myisam
Triage: Triaged: D1 (Critical)

File: Maximum allowed size is 500KB.
Description:
Privacy:

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-17332.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.

[12 Feb 2006 22:39] Shane Bester
insert statements

Attachment: thread1.zip (application/zip, text), 4.24 KiB.

[12 Feb 2006 22:42] Shane Bester
set key_buffer_size

Attachment: thread2.zip (application/zip, text), 190.47 KiB.

[12 Feb 2006 23:43] Shane Bester
proper backtrace, using 5.0.19-debug on Windows.

Attachment: win_stack_trace.txt (text/plain), 1.46 KiB.

[20 Apr 2006 23:28] Shane Bester
5.0.21-bk, crash when INSERT and key_cache_block_size changes.

Attachment: key_cache_block_size.stack.txt (text/plain), 2.09 KiB.

[23 Jun 2006 3:01] Shane Bester
multithreaded C program. see top of file for compile details

Attachment: bug20540.c (text/x-csrc), 5.37 KiB.

[1 Nov 2006 17:38] Shane Bester
yes, 4.1.22 is also affected..

Attachment: 4.1_bk.txt (plain/text, text), 1010 bytes.

[8 Dec 2006 14:57] Ingo Strüwing
My current test script. Run on an installed version (BASEDIR, DATADIR).

Attachment: bug17332-8.sh (application/x-sh, text), 24.24 KiB.

[31 Jan 2007 18:45] Ingo Strüwing
My current test script. Run on an installed version (BASEDIR, DATADIR).

Attachment: bug17332-9.sh (application/x-sh, text), 14.30 KiB.

[31 Jan 2007 18:48] Ingo Strüwing
Detailed description for todays changeset and some general key cache information.

Attachment: keycache-changes.txt (text/plain), 63.38 KiB.

[22 Mar 2007 13:15] Shane Bester
stack trace and variables

Attachment: load_index_crash.txt (text/plain), 2.93 KiB.