From: Jim Starkey
Date: November 4 2008 8:27pm
Subject: Single Thread Deadlock
List-Archive: http://lists.mysql.com/falcon/134
Message-Id: <4910B047.3090702@nimbusdb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

There is a single thread deadlock in Database::upgradeSystemTables().  
It starts by getting a shared lock on Database::syncSysDDL.  If it 
decides that it actually needs to do a database upgrade, it then tried 
to get an exclusive lock on the same SyncObject.  Deadlock.

Changing the initial lock from Shared to Exclusive does the trick nicely.

-- 
Jim Starkey
President, NimbusDB, Inc.
978 526-1376