[mythtv] [mythtv-commits] Ticket #5584: Frontend will hang is schemalock is still locked

[Chris Pinkham]

* On Wed Jul 30, 2008 at 04:02:41AM -0000, MythTV wrote:
> #5584: Frontend will hang is schemalock is still locked
> --------------------+-------------------------------------------------------
>  Reporter:  nigel   |       Owner:  ijr 
>      Type:  patch   |      Status:  new 
>  Priority:  minor   |   Milestone:  0.22
> Component:  mythtv  |     Version:  head
>  Severity:  medium  |     Mlocked:  0   
> --------------------+-------------------------------------------------------
>  If the table schemalock is locked, both the schema upgrade tests (which
>  call lockSchema()), and the DB backup (mysqldump --lock-tables), will sit
>  there forever. Attached patch fixes this for me.

If an upgrade fails and the MySQL connection used for the schemalock lock
is terminated, then the lock is automatically released by MySQL.  If you
have failures that aren't unlocking the table it sounds like some code
path isn't calling unlockSchema() like it should.

Also, 10 seconds may not be long enough to wait for some schema upgrades
on slower systems.

--
Chris