Bug #63196 set innodb_adaptive_hash_index=0 hangs server
Submitted: 11 Nov 2011 6:19 Modified: 17 Jul 2013 14:14
Reporter: Mark Callaghan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S1 (Critical)
Version:5.1.52 OS:Any
Assigned to: CPU Architecture:Any
Tags: adaptive, hang, hash, innodb

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[11 Nov 2011 8:55] Shane Bester
i got a hang.  check thread 23.

Attachment: bug63196_5.5.17_hang.txt (text/plain), 195.44 KiB.

[11 Nov 2011 9:05] Shane Bester
thread apply all bt full

Attachment: bug63196_5.5.17_hang_thread_apply_all_bt_full.txt.zip (application/octet-stream, text), 49.28 KiB.

[11 Nov 2011 14:56] Shane Bester
same testcase as above, with 5.5.13, also hangup after a while.

Attachment: gdb_5.5.13_hang_stacks.txt (text/plain), 201.64 KiB.

[11 Nov 2011 15:11] Shane Bester
repeated a hang quicker on 5.1.59+plugin.... stacks.

Attachment: gdb_5.1.59_plugin_hang_stacks.txt (text/plain), 115.82 KiB.