mythnettv creates locked table issue with mysql 5.5
Bug #1131776 reported by
Sean Whitney
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| mythnettv (Ubuntu) |
Triaged
|
High
|
Unassigned | ||
Bug Description
I was having issues with the MythTV backend locking up and having a lot of mysql processes with a status of "waiting for metadata lock". This seems to have been caused by autocommit=false (which I believe is new with MySQL 5.5). The MythTV 0.25 seems to have avoided this problem, but I don't believe mythnettv did.
Anyway this patch fixed the problem for me.
Revision history for this message
| Sean Whitney (sean-whitney) wrote | #1 |
Revision history for this message
| Ubuntu Foundations Team Bug Bot (crichton) wrote | #2 |
| tags: | added: patch |
| Changed in mythnettv (Ubuntu): | |
| status: | New → Triaged |
| importance: | Undecided → High |
| tags: | removed: 5.5 lock meta mythtv table |
To post a comment you must log in.
The attachment "Add autocommit(True) to database.py" of this bug report has been identified as being a patch. The ubuntu-reviewers team has been subscribed to the bug report so that they can review the patch. In the event that this is in fact not a patch you can resolve this situation by removing the tag 'patch' from the bug report and editing the attachment so that it is not flagged as a patch. Additionally, if you are member of the ubuntu-reviewers team please also unsubscribe the team from this bug report.
[This is an automated message performed by a Launchpad user owned by Brian Murray. Please contact him regarding any issues with the action taken in this bug report.]