[mythtv-users] './mythconverg/recordedseek' is marked as crashed

Mike Holden mikeholden99+mythtv at gmail.com
Wed Jul 29 03:23:44 UTC 2015


On 29 July 2015 at 13:17, Stephen Worthington <stephen_agent at jsw.gen.nz>
wrote:

> And also check for the recordedseek entries still present belonging to
> recordings that have been deleted.  This might work, but will take a
> long time to run on a large database:
>
> select rs.chanid,rs.starttime from recordedseek rs where not exists
> (select 'x' from recorded r where r.chanid=rs.chanid and
> r.starttime=rs.starttime);
>
> There is probably a more efficient query using left outer join.  Then
> you would need to delete all those entries the query listed.
>
>
>
recordedseek entries for already-deleted programs will be tidied up by
background housekeeping, so you can skip that. Just let the housekeeping
thread deal with it in its own time.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150729/c7a5d16f/attachment.html>


More information about the mythtv-users mailing list