Bug #29560 InnoDB >= 5.0.30 hangs on adaptive hash rw-lock 'waiting for an X-lock'
Submitted: 5 Jul 2007 4:06 Modified: 24 Sep 2008 18:32
Reporter: Yasufumi Kinoshita
Status: Closed
Category:Server: InnoDB Severity:S2 (Serious)
Version:5.0.41 OS:Any (Multi CPU)
Assigned to: Timothy Smith Target Version:
Tags: Contribution
Triage: 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-29560.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.

[28 Sep 2007 6: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 13:13] Yasufumi Kinoshita 
This may not freeze...

Attachment: pthread_cond_broadcast_test2.c (text/x-csrc), 4.93 KiB.
[2 Oct 2007 16: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 7: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 5:25] Yasufumi Kinoshita 
benchmark results of the patch

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

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