Opened 11 years ago

Closed 11 years ago

#5584 closed patch (invalid)

Frontend will hang is schemalock is still locked

Reported by: Nigel Owned by: Isaac Richards
Priority: minor Milestone: 0.22
Component: mythtv Version: head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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.

Attachments (1)

wait-schemalock.patch (4.9 KB) - added by Nigel 11 years ago.
Please test me

Download all attachments as: .zip

Change History (2)

Changed 11 years ago by Nigel

Attachment: wait-schemalock.patch added

Please test me

comment:1 Changed 11 years ago by Nigel

Resolution: invalid
Status: newclosed

Chris rightly pointed out:

MySQL should automatically release this table lock when the

backend's MySQL connections terminate. If there's another case of a failure occurring while the program stays running and the hence the MySQL connection stays open so the lock is not released, then it sounds like some code path isn't calling unlockSchema() where it should.

which is absolutely correct. I was testing the locking with a mysql session that wasn't closed. As soon as it closed, the lock did too, which means this ticket is about to do the same :-)

Note: See TracTickets for help on using tickets.