Bug #35140 Suspected Falcon deadlock in Table::insert
Submitted: 7 Mar 2008 10:11 Modified: 21 May 2008 14:24
Reporter: Philip Stoev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.4 OS:Any
Assigned to: Philip Stoev CPU Architecture:Any
Tags: simpler_testcase_needed

[7 Mar 2008 10:11] Philip Stoev
Description:
When running iuds2 test against a 6.0.4 binary compiled by the build team with 4.0.1, the following output was seen in mysql.err:

Stalled threads
  Thread 0xd721d7c8 (-410371168) sleep=0, grant=0, locks=1, who 0, parent=(nil)
    Pending Table::insert state 0 (1) syncObject 0xf70d2070
  Thread 0xd7376708 (-383984736) sleep=0, grant=0, locks=1, who 0, parent=(nil)
    Pending Table::insert state 0 (1) syncObject 0xf70d2070
Stalled synchronization objects:
  SyncObject f70d2070: state 7, monitor 0, waiters 2
    Waiting thread d721d7c8 (-410371168), type 1; Table::insert
    Waiting thread d7376708 (-383984736), type 1; Table::insert
------------------------------------
Stalled threads
  Thread 0xd7376708 (-383984736) sleep=0, grant=0, locks=1, who 0, parent=(nil)
    Pending Table::insert state 0 (1) syncObject 0xf70d2070
  Thread 0xd721d7c8 (-410371168) sleep=1, grant=0, locks=1, who 0, parent=(nil)
    Pending Table::insert state 0 (1) syncObject 0xf70d2070
Stalled synchronization objects:
  SyncObject f70d2070: state 6, monitor 0, waiters 2
    Waiting thread d721d7c8 (-410371168), type 1; Table::insert
    Waiting thread d7376708 (-383984736), type 1; Table::insert

Those two threads have been stalled for almost the entire lifetime of the test. I did not obtain a backtrace because the server crashed due to another (known)bug.

The purpose of the build made with 4.0.1 is to determine if 4.0.1 is a safe compiler to use for Falcon. Binaries compiled with both gcc 3 and gcc 4.1 have had issues.

How to repeat:
The binary in question is available from

buildc:/data0/mysqldev/tmp-200712031732-6.0.4-alpha-5379/buildc-glibc23/mysql-6.0.4-alpha-linux-i686-glibc23.tar.gz
[7 Mar 2008 15:22] Philip Stoev
Stack dumps for bug 35140

Attachment: bug35140.dump (application/octet-stream, text), 158.81 KiB.

[7 Mar 2008 15:34] Philip Stoev
The stack dump just uploaded shows threads before the bug has fully developed. I will upload a dump once the bug is fully developed shortly.
[21 May 2008 14:24] Philip Stoev
This is no longer repeatable on latest binary with latest GCC.