mythnettv creates locked table issue with mysql 5.5

Bug #1131776 reported by Sean Whitney
8
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.

Tags: patch mysql
Revision history for this message
Sean Whitney (sean-whitney) wrote :
Revision history for this message
Ubuntu Foundations Team Bug Bot (crichton) wrote :

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.]

tags: added: patch
Changed in mythnettv (Ubuntu):
status: New → Triaged
importance: Undecided → High
Mathew Hodson (mhodson)
tags: removed: 5.5 lock meta mythtv table
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.