[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