<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
I have over 2.5 million rows in my RecordedSeek table and when I ran
this query (as suggested in the maillist):<br>
<br>
select count(*) from recordedseek where not exists (select * from
recorded where chanid=recordedseek.chanid and
starttime=recordedseek.starttime); <br>
<br>
it says that I have 33,143 "orphan" records. I tried the
"myth.find_orphans.pl" script but it doesn't fix recordedseek tables,
nor does it work with the 20.2 stable release. How do/should I get rid
of those orphans?<br>
<br>
The reason I went looking for DB problems was because I have been
trying to find the source of persistent errors:<br>
<pre wrap="">2007-10-11 09:00:09.134 MainServer::HandleQueryRecordings()
Couldn't find backend for:
: ""</pre>
which seem to eventually crash the backend process.<br>
<br>
I also get lots of these:<br>
<pre wrap="">RingBuf(??/1004_20070921080000.mpg.png): Could not open ??/1004_20070921080000.mpg.png.</pre>
or these:<br>
<pre wrap="">RingBuf(??ythTV/recordings/1004_20070924080000.mpg): Could not open ??ythTV/recordings/1004_20070924080000.mpg.
??
My system setup is <a
href="http://www.mythtv.org/wiki/index.php/User:Mrsdonovan">here</a> [mythtv.org/wiki].
</pre>
-- <br>
<pre class="moz-signature" cols="72">Cheers,
Sean.</pre>
</body>
</html>