[mythtv-users] Backend Freezing

[Mark Pennock]

My new 0.26 backend is having problems where it freezes up and I have to
reboot.

Looking at the system logs it looks like the mythlogserver is continuously
logging errors.

So the mythbackend log keeps growing extreemly rapidly. Here are the errors
that just keep repeating. Any ideas on what the problem is or on how to
figure it out?

Sep 12 11:01:07 Myth4 mythlogserver: mythbackend[2649]: E TVRecEvent
mythdb.cpp:183 (DBError) DB Error (MarkAsInUse -- select):#012Query
was:#012SELECT count(*) FROM inuseprograms WHERE chanid   = :CHANID   AND
starttime = :STARTTIME AND       hostname = :HOSTNAME AND recusage  =
:RECUSAGE#012Bindings were:#012:CHANID=2228, :HOSTNAME="Myth4",
:RECUSAGE="recorder",#012:STARTTIME=2013-09-12T16:00:00Z#012Driver error
was [2/1064]:#012QMYSQL: Unable to execute query#012Database error
was:#012You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
':CHANID   AND starttime = :STARTTIME AND       hostname = :HOSTNAME AND
recusage' at line 1
Sep 12 11:01:07 Myth4 mythlogserver: mythbackend[2649]: I Logger
logging.cpp:487 (launchLogServer) Starting mythlogserver
Sep 12 11:01:07 Myth4 mythlogserver: mythbackend[2649]: E TVRecEvent
mythdbcon.cpp:837 (prepare) Error preparing query: SELECT count(*) FROM
inuseprograms WHERE chanid   = :CHANID   AND starttime = :STARTTIME AND
  hostname = :HOSTNAME AND recusage  = :RECUSAGE
Sep 12 11:01:07 Myth4 mythlogserver: mythbackend[2649]: E TVRecEvent
mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012Table
'./mythconverg/inuseprograms' is marked as crashed and last (automatic?)
repair failed
Sep 12 11:01:07 Myth4 mythlogserver: mythbackend[2649]: E TVRecEvent
mythdb.cpp:183 (DBError) DB Error (MarkAsInUse -- select):#012Query
was:#012SELECT count(*) FROM inuseprograms WHERE chanid   = :CHANID   AND
starttime = :STARTTIME AND       hostname = :HOSTNAME AND recusage  =
:RECUSAGE#012Bindings were:#012:CHANID=2228, :HOSTNAME="Myth4",
:RECUSAGE="recorder",#012:STARTTIME=2013-09-12T16:00:00Z#012Driver error
was [2/1064]:#012QMYSQL: Unable to execute query#012Database error
was:#012You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
':CHANID   AND starttime = :STARTTIME AND       hostname = :HOSTNAME AND
recusage' at line 1
Sep 12 11:01:08 Myth4 mythlogserver: mythbackend[2649]: E TVRecEvent
mythdbcon.cpp:837 (prepare) Error preparing query: SELECT count(*) FROM
inuseprograms WHERE chanid   = :CHANID   AND starttime = :STARTTIME AND
  hostname = :HOSTNAME AND recusage  = :RECUSAGE
Sep 12 11:01:08 Myth4 mythlogserver: mythbackend[2649]: E TVRecEvent
mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012Table
'./mythconverg/inuseprograms' is marked as crashed and last (automatic?)
repair failed
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130912/71601b4b/attachment.html>