<div dir="ltr">My new 0.26 backend is having problems where it freezes up and I have to reboot.<div><br></div><div>Looking at the system logs it looks like the mythlogserver is continuously logging errors.</div><div><br></div>
<div>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?</div><div><br></div><div><div>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</div>
<div>Sep 12 11:01:07 Myth4 mythlogserver: mythbackend[2649]: I Logger logging.cpp:487 (launchLogServer) Starting mythlogserver</div><div>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</div>
<div>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</div>
<div>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</div>
<div>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</div>
<div>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</div>
</div><div><br></div></div>