[mythtv] Database corruption, maybe

David Highley dhighley at highley-recommended.com
Mon Jan 20 06:25:12 UTC 2014


Did a reboot of the system and then restored once again the most recent
backup. The first errors listed are now gone, but we new errors. Yet
Mythtv seems to be working. Bummed, missed recording the NFC
championship game.

2014-01-19 22:13:24.350816 E [1501/1560] TVRecEvent mythdbcon.cpp:837 (prepare) - Error preparing query: SELECT SUM(useeit) FROM videosource, cardinput WHERE videosource.sourceid = cardinput.sourceid AND      cardinput.cardid     = :CARDID
2014-01-19 22:13:24.350827 E [1501/1560] TVRecEvent mythdbcon.cpp:839 (prepare) - Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.videosource' doesn't exist

2014-01-19 22:13:24.350993 E [1501/1560] TVRecEvent mythdb.cpp:183 (DBError) - DB Error (get_use_eit):
Query was:
SELECT SUM(useeit) FROM videosource, cardinput WHERE videosource.sourceid = cardinput.sourceid AND      cardinput.cardid     = :CARDID
Bindings were:
:CARDID=3
Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':CARDID' at line 1

2014-01-19 22:13:54.735812 E [1501/2393] JobQueue mythdbcon.cpp:837 (prepare) - Error preparing query: SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r   ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
2014-01-19 22:13:54.735824 E [1501/2393] JobQueue mythdbcon.cpp:839 (prepare) - Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.recorded' doesn't exist

2014-01-19 22:13:54.735969 E [1501/2393] JobQueue mythdb.cpp:183 (DBError) - DB Error (Error in JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):
Query was:
SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r   ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
Driver error was [2/1146]:
QMYSQL: Unable to execute query
Database error was:
Table 'mythconverg.recorded' doesn't exist



More information about the mythtv-dev mailing list