[mythtv-users] mysql goes away when watching a show that is being recorded

[Kevin Johnson]

I am running mythbuntu with the latest from the bleeding branch of the Avenard repos.
1 hdhomerun dual tuner and two ati hdtv wonder's
Frontend is a zotac ion and backend is amd 64 bit.
If I watch a tv show using live tv, that is also being recorded, as soon as the recording ends, the frontend will freeze and the backend will freeze.
I have to killall mythfrontend and restart the backend.  The frontend shows that mysql has gone away.

mythfronend.log
2010-03-08 21:06:34.536 Error preparing query: SELECT DISTINCT category from recorded;
2010-03-08 21:06:34.536 Driver error was [2/2006]:
QMYSQL3: Unable to prepare statement
Database error was:
MySQL server has gone away

2010-03-08 21:06:34.543 Error preparing query: SELECT data  FROM settings WHERE value = :WHEREVALUE AND hostname = :WHEREHOSTNAME
2010-03-08 21:06:34.543 Driver error was [2/2006]:
QMYSQL3: Unable to prepare statement
Database error was:
MySQL server has gone away

2010-03-08 21:06:34.543 DB Error (SimpleDBStorage::Load()):
Query was:
SELECT data  FROM settings WHERE value = ? AND hostname = ?
Bindings were:
:WHEREHOSTNAME=mythbigscreen, :WHEREVALUE=RealtimePriority
No error type from QSqlError?  Strange...
2010-03-08 21:06:34.544 Error preparing query: SELECT data  FROM settings WHERE value = :WHEREVALUE AND hostname = :WHEREHOSTNAME
2010-03-08 21:06:34.544 Driver error was [2/2006]:
QMYSQL3: Unable to prepare statement
Database error was:
MySQL server has gone away

The backend shows the same thing

mythbackend.log

2010-03-08 21:06:43.837 New DB connection, total: 8
2010-03-08 21:06:43.848 DB Error (CardUtil::GetInputGroups()):
Query was:
SELECT inputgroupid FROM inputgroup WHERE cardinputid = ? ORDER BY inputgroupid, cardinputid, inputgroupname
Bindings were:
:INPUTID=1
No error type from QSqlError?  Strange...
2010-03-08 21:06:43.848 Error preparing query: SELECT chanid, starttime, lastupdatetime, recusage,  hostname FROM inuseprograms;
2010-03-08 21:06:43.854 DB Error (insert_program -- lock):
Query was:

Driver error was [2/2006]:
QMYSQL: Unable to execute query
Database error was:
MySQL server has gone away

2010-03-08 21:06:43.858 Unable to connect to database!
2010-03-08 21:06:43.866 Driver error was [2/2006]:
QMYSQL3: Unable to prepare statement
Database error was:
MySQL server has gone away

2010-03-08 21:06:43.869 DB Error (insert_program -- lock):
Query was:

Driver error was [2/2006]:
QMYSQL: Unable to execute query
Database error was:
MySQL server has gone away


Why is mysql crashing?  



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100308/8efa0372/attachment.htm>