From: Kevin Lewis Date: November 4 2008 9:20pm Subject: Re: Single Thread Deadlock List-Archive: http://lists.mysql.com/falcon/136 Message-Id: <4910BCBB.6090802@sun.com> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 Content-Transfer-Encoding: 7BIT Thanks, Jim, I'll get this into Falcon. Is there any way to make a repeatable testcase with a single engine? Jim Starkey wrote: > 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. >