[mythtv-users] finding recordings with bad seek tables
Garrick Staples
garrick at usc.edu
Thu Jul 10 05:56:52 UTC 2008
I've been finding random shows that obviously have bad seek table information
(the OSD shows a stupidly long length). I thought I should figure out a way to
go through the entire store and automate the process. The only way I could
find to detect bad seek info is by the lack of rows in the recordedseek table.
Is that a valid assumption?
I'm currently letting this run...
for a in ????_??????????????.mpg;do
chanid=$(IFS=_.; set -- $a; echo $1);
starttime=$(IFS=_.; set -- $a; echo $2);
echo 'select count(*),"'$a'" from recordedseek where chanid='$chanid' and starttime='$starttime';';
done | mysql mythconverg | \
grep -v count | grep ^0 | \
awk '{print "mythcommflag --rebuild -f "$2}' | sh -x
I'm finding some old files that error. Should I just delete these?
+ mythcommflag --rebuild -f 1003_20060505210000.mpg
2008-07-09 22:48:06.732 Using runtime prefix = /usr
2008-07-09 22:48:06.743 Empty LocalHostName.
2008-07-09 22:48:06.850 New DB connection, total: 1
2008-07-09 22:48:06.858 Closing DB connection named 'DBManager0'
mythcommflag: ERROR: Unable to find DB info for 1003_20060505210000.mpg
--
Garrick Staples, GNU/Linux HPCC SysAdmin
University of Southern California
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20080709/717488b5/attachment.pgp
More information about the mythtv-users
mailing list