hansoffate@mythlinux:~$ tail -50 /var/log/mythtv/mythbackend.log
2007-04-01 11:30:55.793 Seem to be woken up by USER
2007-04-01 11:31:01.534 mythbackend: Running housekeeping thread
2007-04-01 11:37:53.894 Using runtime prefix = /usr
2007-04-01 11:37:53.976 New DB connection, total: 1
2007-04-01 11:37:53.987 Connected to database 'mythconverg' at host: localhost
2007-04-01 11:37:53.996 Current Schema Version: 1160
Starting up as the master server.
2007-04-01 11:37:54.010 mythbackend: MythBackend started as master server
2007-04-01 11:37:54.023 New DB connection, total: 2
2007-04-01 11:37:54.032 Connected to database 'mythconverg' at host: localhost
2007-04-01 11:37:54.037 EITHelper: localtime offset -7:00:00
2007-04-01 11:37:54.047 New DB connection, total: 3
2007-04-01 11:37:54.049 Connected to database 'mythconverg' at host: localhost
sh: /usr/local/bin/change-channel-lirc.pl: Permission denied
2007-04-01 11:37:55.087 ret_pid(6042) child(6042) status(0x7e00)
2007-04-01 11:37:55.091 ChannelBase: external tuning program exited with error 126
sh: /usr/local/bin/change-channel-lirc.pl: Permission denied
2007-04-01 11:37:56.103 ret_pid(6044) child(6044) status(0x7e00)
2007-04-01 11:37:56.107 ChannelBase: external tuning program exited with error 126
2007-04-01 11:37:56.108 TVRec(1) Error: Setting start channel '3' failed,
and backup '3' failed as well.
2007-04-01 11:37:56.132 New DB scheduler connection
2007-04-01 11:37:56.134 Connected to database 'mythconverg' at host: localhost
2007-04-01 11:37:56.138 Main::Starting HttpServer
2007-04-01 11:37:56.151 Main::Registering HttpStatus Extension
2007-04-01 11:37:56.165 mythbackend version: 0.20.20060828-3 www.mythtv.org
2007-04-01 11:37:56.174 Enabled verbose msgs: important general
2007-04-01 11:37:56.176 AutoExpire: Found 1 recorders w/max rate of 72 MiB/min
2007-04-01 11:37:56.179 AutoExpire: Required Free Space: 2.1 GB w/freq: 10 min
2007-04-01 11:37:58.187 Reschedule requested for id -1.
2007-04-01 11:37:58.195 DB Error (UpdateMatches):
Query was:
DELETE FROM program WHERE manualid = -1 OR (manualid <> 0 AND -1 = -1)
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/program' is marked as crashed and should be repaired
2007-04-01 11:37:58.230 DB Error (AddNewRecords):
Query was:
SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime, program.endtime, program.title, program.subtitle, program.description, channel.channum, channel.callsign, channel.name, oldrecorded.endtime IS NOT NULL AS oldrecduplicate, program.category, record.recpriority, record.dupin, recorded.endtime IS NOT NULL AS recduplicate, oldfind.findid IS NOT NULL AS findduplicate, record.type, record.recordid, program.starttime - INTERVAL record.startoffset minute AS recstartts, program.endtime + INTERVAL record.endoffset minute AS recendts, program.previouslyshown, record.recgroup, record.dupmethod, channel.commfree, capturecard.cardid, cardinput.cardinputid, UPPER(cardinput.shareable) = 'Y' AS shareable, program.seriesid, program.programid, program.category_type, program.airdate, program.stars, program.originalairdate, record.inactive, record.parentid, (CASE record.type WHEN 6 THEN record.findid WHEN 9 THEN to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) - record.findday)/7) * 7 + record.findday WHEN 7 THEN record.findid ELSE 0 END) , record.playgroup, oldrecstatus.recstatus, oldrecstatus.reactivate, channel.recpriority + cardinput.recpriority, record.prefinput, program.hdtv, program.closecaptioned, program.first, program.last, program.stereo FROM recordmatch INNER JOIN record ON (recordmatch.recordid = record.recordid) INNER JOIN program ON (recordmatch.chanid = program.chanid AND recordmatch.starttime = program.starttime AND recordmatch.manualid = program.manualid) INNER JOIN channel ON (channel.chanid = program.chanid) INNER JOIN cardinput ON (channel.sourceid = cardinput.sourceid) INNER JOIN capturecard ON (capturecard.cardid = cardinput.cardid) LEFT JOIN oldrecorded as oldrecstatus ON ( oldrecstatus.station = channel.callsign AND oldrecstatus.starttime = program.starttime AND oldrecstatus.title = program.title ) LEFT JOIN oldrecorded ON ( 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 record.type WHEN 6 THEN record.findid WHEN 9 THEN to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) - record.findday)/7) * 7 + record.findday WHEN 7 THEN record.findid ELSE 0 END) ) OR ( program.generic = 0 AND (program.programid = '' OR oldrecorded.programid = '') AND (((record.dupmethod & 0x02) = 0) OR (program.subtitle <> '' AND program.subtitle = oldrecorded.subtitle)) AND (((record.dupmethod & 0x04) = 0) OR (program.description <> '' AND program.description = oldrecorded.description)) ) ) ) LEFT JOIN recorded ON ( record.dupmethod > 1 AND recorded.duplicate <> 0 AND program.title = recorded.title AND recorded.recgroup <> 'LiveTV' AND ( (program.programid <> '' AND program.generic = 0 AND program.programid = recorded.programid) OR (recorded.findid <> 0 AND recorded.findid = (CASE record.type WHEN 6 THEN record.findid WHEN 9 THEN to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) - record.findday)/7) * 7 + record.findday WHEN 7 THEN record.findid ELSE 0 END) ) OR ( program.generic = 0 AND (program.programid = '' OR recorded.programid = '') AND (((record.dupmethod & 0x02) = 0) OR (program.subtitle <> '' AND program.subtitle = recorded.subtitle)) AND (((record.dupmethod & 0x04) = 0) OR (program.description <> '' AND program.description = recorded.description)) ) ) ) LEFT JOIN oldfind ON (oldfind.recordid = recordmatch.recordid AND oldfind.findid = (CASE record.type WHEN 6 THEN record.findid WHEN 9 THEN to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) - record.findday)/7) * 7 + record.findday WHEN 7 THEN record.findid ELSE 0 END) ) ORDER BY record.recordid DESC
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/program' is marked as crashed and should be repaired
2007-04-01 11:37:58.235 Scheduled 0 items in 0.0 = 0.01 match + 0.04 place
2007-04-01 11:37:58.241 scheduler: Scheduled items: Scheduled 0 items in 0.0 = 0.01 match + 0.04 place
2007-04-01 11:37:58.250 Seem to be woken up by USER
2007-04-01 11:38:04.030 mythbackend: Running housekeeping thread