Bug #29560 InnoDB >= 5.0.30 hangs on adaptive hash rw-lock 'waiting for an X-lock'
Submitted: 5 Jul 2007 2:06 Modified: 24 Sep 2008 16:32
Reporter: Yasufumi Kinoshita Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:5.0.41 OS:Any (Multi CPU)
Assigned to: Timothy Smith CPU Architecture:Any
Tags: Contribution

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:

[28 Sep 2007 4:46] Yasufumi Kinoshita 
It test pthread_cond_wait() and pthread_cond_broadcast()

Attachment: pthread_cond_broadcast_test.c (application/octet-stream, text), 4.30 KiB.
[30 Sep 2007 11:13] Yasufumi Kinoshita 
This may not freeze...

Attachment: pthread_cond_broadcast_test2.c (text/x-csrc), 4.93 KiB.
[2 Oct 2007 14:25] Yasufumi Kinoshita 
Suggestion patch to fix os_event_xxx for rw_lock and mutex.

Attachment: mysql-5.0.41_os_event_fix.patch.gz (application/x-gzip, text), 1.26 KiB.
[24 Oct 2007 5:39] Inaam Rana 
patch based on Yasufumi's idea of fixing missed os_event_set() call in sync0arr.

Attachment: os_event_5.0_v2.patch (text/x-diff), 17.22 KiB.
[25 Oct 2007 3:25] Yasufumi Kinoshita 
benchmark results of the patch

Attachment: os_event_5.0_v2.pdf (application/pdf, text), 17.87 KiB.
[16 Nov 2007 8:10] Yasufumi Kinoshita 
Test code for signal implementation of pthread.

Attachment: pthread_cond_broadcast_test3.c (text/x-csrc), 4.51 KiB.