Opened 17 years ago
Closed 17 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)
Change History (2)
Changed 17 years ago by
| Attachment: | wait-schemalock.patch added |
|---|
comment:1 Changed 17 years ago by
| Resolution: | → invalid |
|---|---|
| Status: | new → closed |
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 :-)
Please test me