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

Mike Perkins mikep at randomtraveller.org.uk
Tue Mar 9 11:27:42 UTC 2010


Kevin Johnson wrote:
> 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?  
> 
I have seen this message on rare occasions, and it does not necessarily mean 
that mysql is actually dead, just that mythtv can't talk to it. Asking the 
obvious question, have you checked that mysql is still running?

Whether it is or it isn't you will need to look at your system logs to gather 
additional information: dmesg, /var/log/messages, the mysql logs, etc...

-- 

Mike Perkins



More information about the mythtv-users mailing list