[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