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