[mythtv-users] System lockup on autoexpire of non-existent file
Jason Antman
jason at jasonantman.com
Wed Aug 6 04:15:24 UTC 2008
Lately my MythTV machine has been locking up seemingly randomly. The
interesting part is that this isn't exclusively happening when watching
TV, but also when it's not actively being used. This has become a
problem because, coincidentally, this box serves only two other purposes
- providing SSH access to my other boxes in my apartment, and forwarding
syslog back to my main systems.
I did some poking around in the logs, and couldn't find anything on the
OS level. However, at the time of the last crash, I identified this in
the backend log:
2008-08-05 17:20:48.993 Expiring Unsolved History "Plots to Kill
Lincoln" from Tue Aug 5 17:00:00 2008, 22 MBytes, forced expire (LiveTV
recording)
2008-08-05 17:20:58.040 DB Error (Recorded program delete recordedseek):
Query was:
DELETE FROM recordedseek WHERE chanid = '1173' AND starttime =
'2008-08-05T17:17:39';
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/recordedseek' is marked as crashed and should be
repaired
2008-08-05 17:21:04.133 DB Error (Recorded program delete recordedseek):
Query was:
DELETE FROM recordedseek WHERE chanid = '1173' AND starttime =
'2008-08-05T17:17:47';
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/recordedseek' is marked as crashed and should be
repaired
2008-08-05 17:29:49.134 AutoExpire: ERROR when trying to autoexpire
file: /mnt/video-storage/1027_20080722180000.mpg. File doesn't exist.
Database metadata will not be removed.
2008-08-05 17:29:49.175 AutoExpire: ERROR when trying to autoexpire
file: /mnt/video-storage/1037_20080722180841.mpg. File doesn't exist.
Database metadata will not be removed.
2008-08-05 17:29:49.208 AutoExpire: ERROR when trying to autoexpire
file: /mnt/video-storage/1037_20080722190001.mpg. File doesn't exist.
Database metadata will not be removed.
Immediately thereafter, the box locked up. Now, I know a table crash
might be a problem. I also recently replaced my video storage disk, but
first manually expired (and checked that the files were purged) all of
my previous recordings.
Any thoughts? As far as I'm concerned, the autoexpire function isn't
central to the logic of what the backend does, and should be
sufficiently protected (a simple try/catch) that a problem with
expiration of a recording doesn't kill the backend.
This is extremely troublesome, as the machine that I'm running on is
standard desktop PC hardware, without LOM/iLO or a network-controllable
PDU, so if the machine locks up when I'm away for the weekend, none of
my scheduled recordings will happen until I return and am able to
physically perform a hard reset on the machine.
Thanks,
Jason
More information about the mythtv-users
mailing list