[mythtv-users] /tmp space fyi - Incorrect key file for table
Greg Oliver
oliver.greg at gmail.com
Fri Jan 14 21:00:25 UTC 2011
Just an fyi - I have been wondering why my system would not show or
schedule upcoming recordings.. My /tmp filesystem is full and
apparently mythtv writes there to create temporary tables for more
complex sql statements. This was causing them to fail..
Just a heads up in case anyone runs into this:
2011-01-14 14:57:01.004 DB Error (AddNewRecords):
Query was:
SELECT c.chanid, c.sourceid, p.starttime,
p.endtime, p.title, p.subtitle,
p.description, c.channum, c.callsign, c.name,
oldrecduplicate, p.category,
sched_temp_record.recpriority, sched_temp_record.dupin,
recduplicate, findduplicate, sched_temp_record.type,
sched_temp_record.recordid, p.starttime - INTERVAL
sched_temp_record.startoffset minute AS recstartts, p.endtime
+ INTERVAL sched_temp_record.endoffset minute AS recendts,
p.previouslyshown,
sched_temp_record.recgroup, sched_temp_record.dupmethod,
c.commmethod, capturecard.cardid,
cardinput.cardinputid,p.seriesid, p.programid,
p.category_type, p.airdate, p.stars,
p.originalairdate, sched_temp_record.inactive,
sched_temp_record.parentid, (CASE sched_temp_record.type WHEN 6
THEN sched_temp_record.findid WHEN 9 THEN
to_days(date_sub(p.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute)) WHEN
10 THEN floor((to_days(date_sub(p.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) , sched_temp_record.playgroup, oldrecstatus.recstatus,
oldrecstatus.reactivate,
p.videoprop+0, p.subtitletypes+0, p.audioprop+0,
sched_temp_record.storagegroup, capturecard.hostname,
recordmatch.oldrecstatus,
sched_temp_record.avg_delay, c.recpriority + cardinput.recpriority +
(cardinput.cardinputid = sched_temp_record.prefinput) * 2 AS
powerpriority FROM recordmatch INNER JOIN sched_temp_record ON
(recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program
AS p ON ( recordmatch.chanid = p.chanid AND
recordmatch.starttime = p.starttime AND recordmatch.manualid =
p.manualid ) INNER JOIN channel AS c ON ( c.chanid = p.chanid ) INNER
JOIN cardinput ON (c.sourceid = cardinput.sourceid) INNER JOIN
capturecard ON (capturecard.cardid = cardinput.cardid) LEFT JOIN
oldrecorded as oldrecstatus ON ( oldrecstatus.station = c.callsign
AND oldrecstatus.starttime = p.starttime AND
oldrecstatus.title = p.title ) WHERE p.endtime >= NOW() - INTERVAL
1 DAY ORDER BY sched_temp_record.recordid DESC
Driver error was [2/126]:
QMYSQL3: Unable to execute statement
Database error was:
Incorrect key file for table '/tmp/#sql_4ff3_0.MYI'; try to repair it
Thanks
-Greg
More information about the mythtv-users
mailing list