[mythtv-users] no scheduling data in UI following db restore
Richard Morton
richard.e.morton at gmail.com
Mon Mar 28 22:53:41 UTC 2011
more complete log from mythbackend with the scheduling results...
R
myth at myth-server:~$ mythbackend
2011-03-28 23:47:09.369 mythbackend version:
branches/release-0-23-fixes [26863] www.mythtv.org
2011-03-28 23:47:09.370 Using runtime prefix = /usr
2011-03-28 23:47:09.370 Using configuration directory = /home/myth/.mythtv
2011-03-28 23:47:09.370 Empty LocalHostName.
2011-03-28 23:47:09.370 Using localhost value of myth-server
2011-03-28 23:47:09.378 New DB connection, total: 1
2011-03-28 23:47:09.381 Connected to database 'mythconverg' at host: localhost
2011-03-28 23:47:09.382 Closing DB connection named 'DBManager0'
2011-03-28 23:47:09.382 Connected to database 'mythconverg' at host: localhost
2011-03-28 23:47:09.384 Current MythTV Schema Version (DBSchemaVer): 1254
2011-03-28 23:47:09.385 MythBackend: Starting up as the master server.
2011-03-28 23:47:09.393 New DB connection, total: 2
2011-03-28 23:47:09.393 Connected to database 'mythconverg' at host: localhost
2011-03-28 23:47:09.393 New DB connection, total: 3
2011-03-28 23:47:09.393 Connected to database 'mythconverg' at host: localhost
2011-03-28 23:47:09.567 New DB connection, total: 4
2011-03-28 23:47:09.568 Connected to database 'mythconverg' at host: localhost
2011-03-28 23:47:13.547 DVBChan(6:/dev/dvb/adapter0/frontend0)
Warning: Your frequency setting (11642000) is out of range.
(min/max:950000/2150000)
2011-03-28 23:47:13.602 New DB scheduler connection
2011-03-28 23:47:13.603 Connected to database 'mythconverg' at host: localhost
2011-03-28 23:47:13.605 Error preparing query: UPDATE oldrecorded SET
recstatus = :RSABORTED WHERE recstatus = :RSRECORDING
2011-03-28 23:47:13.606 Driver error was [2/144]:
QMYSQL3: Unable to prepare statement
Database error was:
Table './mythconverg/oldrecorded' is marked as crashed and last
(automatic?) repair failed
2011-03-28 23:47:13.606 DB Error (UpdateAborted):
Query was:
UPDATE oldrecorded SET recstatus = :RSABORTED WHERE recstatus = :RSRECORDING
Bindings were:
:RSABORTED=-4, :RSRECORDING=-2
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 MySQL server version for the right syntax to use
near ':RSABORTED WHERE recstatus = :RSRECORDING' at line 1
2011-03-28 23:47:13.613 Enabling Upnpmedia rebuild thread.
2011-03-28 23:47:14.815 Main::Registering HttpStatus Extension
2011-03-28 23:47:14.815 Enabled verbose msgs: important general
2011-03-28 23:47:14.816 AutoExpire: CalcParams(): Max required Free
Space: 40.0 GB w/freq: 15 min
2011-03-28 23:47:16.606 Reschedule requested for id -1.
2011-03-28 23:47:16.608 Invalid search key in recordid 12
2011-03-28 23:47:16.608 Invalid search key in recordid 455
2011-03-28 23:47:18.191 MainServer::ANN Monitor
2011-03-28 23:47:18.191 adding: myth-server as a client (events: 0)
2011-03-28 23:47:18.191 MainServer::ANN Monitor
2011-03-28 23:47:18.191 adding: myth-server as a client (events: 1)
2011-03-28 23:47:19.262 MainServer::ANN Monitor
2011-03-28 23:47:19.263 adding: myth-bedroom as a client (events: 0)
2011-03-28 23:47:19.263 MainServer::ANN Monitor
2011-03-28 23:47:19.263 adding: myth-bedroom as a client (events: 1)
2011-03-28 23:47:19.962 Error preparing query: UPDATE recordmatch
INNER JOIN sched_temp_record ON (recordmatch.recordid =
sched_temp_record.recordid) INNER JOIN program ON (recordmatch.chanid
= program.chanid AND recordmatch.starttime =
program.starttime AND recordmatch.manualid =
program.manualid) LEFT JOIN oldrecorded ON (
sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND
program.title = oldrecorded.title AND (
(program.programid <> '' AND program.generic = 0 AND
program.programid = oldrecorded.programid) OR
(oldrecorded.findid <> 0 AND oldrecorded.findid = (CASE
sched_temp_record.type WHEN 6 THEN sched_temp_record.findid
WHEN 9 THEN to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) OR ( program.generic = 0 AND
(program.programid = '' OR oldrecorded.programid = '')
AND (((sched_temp_record.dupmethod & 0x02) = 0) OR
(program.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR (program.description <>
'' AND program.description = oldrecorded.description))
AND (((sched_temp_record.dupmethod & 0x08) = 0) OR
(program.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle) OR (program.subtitle = '' AND
oldrecorded.subtitle = '' AND program.description <> '' AND
program.description = oldrecorded.description)) ) ) )
LEFT JOIN sched_temp_recorded recorded ON (
sched_temp_record.dupmethod > 1 AND recorded.duplicate <> 0 AND
program.title = recorded.title AND recorded.recgroup NOT IN
('LiveTV','Deleted') AND ( (program.programid <> ''
AND program.generic = 0 AND program.programid =
recorded.programid) OR (recorded.findid <> 0 AND
recorded.findid = (CASE sched_temp_record.type WHEN 6 THEN
sched_temp_record.findid WHEN 9 THEN
to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute)) WHEN
10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
- sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) OR ( program.generic = 0 AND
(program.programid = '' OR recorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (program.subtitle
<> '' AND program.subtitle = recorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR
(program.description <> '' AND program.description =
recorded.description)) AND
(((sched_temp_record.dupmethod & 0x08) = 0) OR (program.subtitle <> ''
AND program.subtitle = recorded.subtitle) OR
(program.subtitle = '' AND recorded.subtitle = '' AND
program.description <> '' AND program.description =
recorded.description)) ) ) ) LEFT JOIN oldfind ON
(oldfind.recordid = recordmatch.recordid AND oldfind.findid = (CASE
sched_temp_record.type WHEN 6 THEN sched_temp_record.findid
WHEN 9 THEN to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) SET oldrecduplicate = (oldrecorded.endtime IS NOT
NULL), recduplicate = (recorded.endtime IS NOT NULL),
findduplicate = (oldfind.findid IS NOT NULL), oldrecstatus =
oldrecorded.recstatus
2011-03-28 23:47:19.962 Driver error was [2/144]:
QMYSQL3: Unable to prepare statement
Database error was:
Table './mythconverg/oldrecorded' is marked as crashed and last
(automatic?) repair failed
2011-03-28 23:47:19.962 DB Error (AddNewRecords recordmatch):
Query was:
UPDATE recordmatch INNER JOIN sched_temp_record ON
(recordmatch.recordid = sched_temp_record.recordid) INNER JOIN
program ON (recordmatch.chanid = program.chanid AND
recordmatch.starttime = program.starttime AND
recordmatch.manualid = program.manualid) LEFT JOIN oldrecorded ON
( sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate
<> 0 AND program.title = oldrecorded.title AND (
(program.programid <> '' AND program.generic = 0 AND
program.programid = oldrecorded.programid) OR
(oldrecorded.findid <> 0 AND oldrecorded.findid = (CASE
sched_temp_record.type WHEN 6 THEN sched_temp_record.findid
WHEN 9 THEN to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) OR ( program.generic = 0 AND
(program.programid = '' OR oldrecorded.programid = '')
AND (((sched_temp_record.dupmethod & 0x02) = 0) OR
(program.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR (program.description <>
'' AND program.description = oldrecorded.description))
AND (((sched_temp_record.dupmethod & 0x08) = 0) OR
(program.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle) OR (program.subtitle = '' AND
oldrecorded.subtitle = '' AND program.description <> '' AND
program.description = oldrecorded.description)) ) ) )
LEFT JOIN sched_temp_recorded recorded ON (
sched_temp_record.dupmethod > 1 AND recorded.duplicate <> 0 AND
program.title = recorded.title AND recorded.recgroup NOT IN
('LiveTV','Deleted') AND ( (program.programid <> ''
AND program.generic = 0 AND program.programid =
recorded.programid) OR (recorded.findid <> 0 AND
recorded.findid = (CASE sched_temp_record.type WHEN 6 THEN
sched_temp_record.findid WHEN 9 THEN
to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute)) WHEN
10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
- sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) OR ( program.generic = 0 AND
(program.programid = '' OR recorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (program.subtitle
<> '' AND program.subtitle = recorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR
(program.description <> '' AND program.description =
recorded.description)) AND
(((sched_temp_record.dupmethod & 0x08) = 0) OR (program.subtitle <> ''
AND program.subtitle = recorded.subtitle) OR
(program.subtitle = '' AND recorded.subtitle = '' AND
program.description <> '' AND program.description =
recorded.description)) ) ) ) LEFT JOIN oldfind ON
(oldfind.recordid = recordmatch.recordid AND oldfind.findid = (CASE
sched_temp_record.type WHEN 6 THEN sched_temp_record.findid
WHEN 9 THEN to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) SET oldrecduplicate = (oldrecorded.endtime IS NOT
NULL), recduplicate = (recorded.endtime IS NOT NULL),
findduplicate = (oldfind.findid IS NOT NULL), oldrecstatus =
oldrecorded.recstatus
No error type from QSqlError? Strange...
2011-03-28 23:47:20.012 Scheduled 0 items in 3.4 = 3.25 match + 0.11 place
2011-03-28 23:47:20.013 Seem to be woken up by USER
2011-03-28 23:47:23.843 UPnpMedia: BuildMediaMap VIDEO scan starting
in :/var/lib/mythtv/videos:
2011-03-28 23:47:25.017 UPnpMedia: BuildMediaMap Done. Found 3420 objects
2011-03-28 23:48:15.327 PID 0x297 status: Encrypted
2011-03-28 23:48:17.178 PID 0x203 status: Encrypted
2011-03-28 23:48:33.606 AutoExpire: CalcParams(): Max required Free
Space: 40.0 GB w/freq: 15 min
a2011-03-28 23:50:02.049 MainServer::ANN Monitor
2011-03-28 23:50:02.049 adding: myth-server as a client (events: 0)
2011-03-28 23:51:05.051 Reschedule requested for id -1.
2011-03-28 23:51:05.052 Invalid search key in recordid 12
2011-03-28 23:51:05.052 Invalid search key in recordid 455
2011-03-28 23:51:08.421 Error preparing query: UPDATE recordmatch
INNER JOIN sched_temp_record ON (recordmatch.recordid =
sched_temp_record.recordid) INNER JOIN program ON (recordmatch.chanid
= program.chanid AND recordmatch.starttime =
program.starttime AND recordmatch.manualid =
program.manualid) LEFT JOIN oldrecorded ON (
sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND
program.title = oldrecorded.title AND (
(program.programid <> '' AND program.generic = 0 AND
program.programid = oldrecorded.programid) OR
(oldrecorded.findid <> 0 AND oldrecorded.findid = (CASE
sched_temp_record.type WHEN 6 THEN sched_temp_record.findid
WHEN 9 THEN to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) OR ( program.generic = 0 AND
(program.programid = '' OR oldrecorded.programid = '')
AND (((sched_temp_record.dupmethod & 0x02) = 0) OR
(program.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR (program.description <>
'' AND program.description = oldrecorded.description))
AND (((sched_temp_record.dupmethod & 0x08) = 0) OR
(program.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle) OR (program.subtitle = '' AND
oldrecorded.subtitle = '' AND program.description <> '' AND
program.description = oldrecorded.description)) ) ) )
LEFT JOIN sched_temp_recorded recorded ON (
sched_temp_record.dupmethod > 1 AND recorded.duplicate <> 0 AND
program.title = recorded.title AND recorded.recgroup NOT IN
('LiveTV','Deleted') AND ( (program.programid <> ''
AND program.generic = 0 AND program.programid =
recorded.programid) OR (recorded.findid <> 0 AND
recorded.findid = (CASE sched_temp_record.type WHEN 6 THEN
sched_temp_record.findid WHEN 9 THEN
to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute)) WHEN
10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
- sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) OR ( program.generic = 0 AND
(program.programid = '' OR recorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (program.subtitle
<> '' AND program.subtitle = recorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR
(program.description <> '' AND program.description =
recorded.description)) AND
(((sched_temp_record.dupmethod & 0x08) = 0) OR (program.subtitle <> ''
AND program.subtitle = recorded.subtitle) OR
(program.subtitle = '' AND recorded.subtitle = '' AND
program.description <> '' AND program.description =
recorded.description)) ) ) ) LEFT JOIN oldfind ON
(oldfind.recordid = recordmatch.recordid AND oldfind.findid = (CASE
sched_temp_record.type WHEN 6 THEN sched_temp_record.findid
WHEN 9 THEN to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) SET oldrecduplicate = (oldrecorded.endtime IS NOT
NULL), recduplicate = (recorded.endtime IS NOT NULL),
findduplicate = (oldfind.findid IS NOT NULL), oldrecstatus =
oldrecorded.recstatus
2011-03-28 23:51:08.421 Driver error was [2/144]:
QMYSQL3: Unable to prepare statement
Database error was:
Table './mythconverg/oldrecorded' is marked as crashed and last
(automatic?) repair failed
2011-03-28 23:51:08.421 DB Error (AddNewRecords recordmatch):
Query was:
UPDATE recordmatch INNER JOIN sched_temp_record ON
(recordmatch.recordid = sched_temp_record.recordid) INNER JOIN
program ON (recordmatch.chanid = program.chanid AND
recordmatch.starttime = program.starttime AND
recordmatch.manualid = program.manualid) LEFT JOIN oldrecorded ON
( sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate
<> 0 AND program.title = oldrecorded.title AND (
(program.programid <> '' AND program.generic = 0 AND
program.programid = oldrecorded.programid) OR
(oldrecorded.findid <> 0 AND oldrecorded.findid = (CASE
sched_temp_record.type WHEN 6 THEN sched_temp_record.findid
WHEN 9 THEN to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) OR ( program.generic = 0 AND
(program.programid = '' OR oldrecorded.programid = '')
AND (((sched_temp_record.dupmethod & 0x02) = 0) OR
(program.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR (program.description <>
'' AND program.description = oldrecorded.description))
AND (((sched_temp_record.dupmethod & 0x08) = 0) OR
(program.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle) OR (program.subtitle = '' AND
oldrecorded.subtitle = '' AND program.description <> '' AND
program.description = oldrecorded.description)) ) ) )
LEFT JOIN sched_temp_recorded recorded ON (
sched_temp_record.dupmethod > 1 AND recorded.duplicate <> 0 AND
program.title = recorded.title AND recorded.recgroup NOT IN
('LiveTV','Deleted') AND ( (program.programid <> ''
AND program.generic = 0 AND program.programid =
recorded.programid) OR (recorded.findid <> 0 AND
recorded.findid = (CASE sched_temp_record.type WHEN 6 THEN
sched_temp_record.findid WHEN 9 THEN
to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute)) WHEN
10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
- sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) OR ( program.generic = 0 AND
(program.programid = '' OR recorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (program.subtitle
<> '' AND program.subtitle = recorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR
(program.description <> '' AND program.description =
recorded.description)) AND
(((sched_temp_record.dupmethod & 0x08) = 0) OR (program.subtitle <> ''
AND program.subtitle = recorded.subtitle) OR
(program.subtitle = '' AND recorded.subtitle = '' AND
program.description <> '' AND program.description =
recorded.description)) ) ) ) LEFT JOIN oldfind ON
(oldfind.recordid = recordmatch.recordid AND oldfind.findid = (CASE
sched_temp_record.type WHEN 6 THEN sched_temp_record.findid
WHEN 9 THEN to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid
ELSE 0 END) ) SET oldrecduplicate = (oldrecorded.endtime IS NOT
NULL), recduplicate = (recorded.endtime IS NOT NULL),
findduplicate = (oldfind.findid IS NOT NULL), oldrecstatus =
oldrecorded.recstatus
No error type from QSqlError? Strange...
2011-03-28 23:51:08.480 Scheduled 0 items in 3.4 = 3.29 match + 0.09 place
More information about the mythtv-users
mailing list