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