[mythtv-users] RecordedSeek Orphans & Backend Errors

[Michael T. Dean]

On 10/12/2007 06:29 PM, Sean Donovan wrote:
> I have over 2.5 million rows in my RecordedSeek table and when I ran
> this query (as suggested in the maillist):
>
> select count(*) from recordedseek where not exists (select * from
> recorded where chanid=recordedseek.chanid and
> starttime=recordedseek.starttime);
>
> it says that I have 33,143 "orphan" records.  I tried the
> "myth.find_orphans.pl" script but it doesn't fix recordedseek tables,

It only finds files in the recordings directory that don't have metadata
associated with them--things worthwhile for a user to fix.

> nor does it work with the 20.2 stable release.  How do/should I get
> rid of those orphans?

They'll get cleaned up properly when you upgrade to 0.21.  In the
meantime, don't worry about them.  That's only 9min 12sec worth of seek
table--nothing to waste time/risk breaking your DB over.  It's also only
1.3% of the total records (=not a big deal).

> The reason I went looking for DB problems was because I have been
> trying to find the source of persistent errors:
> 2007-10-11 09:00:09.134 MainServer::HandleQueryRecordings()
> 			Couldn't find backend for: 
> 			 : ""
> which seem to eventually crash the backend process.

That's more likely a broken configuration than bad data.  See
http://www.gossamer-threads.com/lists/mythtv/users/289395#289395 .

Mike