[mythtv-users] Recordings start but do not complete

[R KANNAN]

Date: Wed, 03 Oct 2012 20:29:54 -0400
> From: "Michael T. Dean" <mtdean at thirdcontact.com>
> To: Discussion about MythTV <mythtv-users at mythtv.org>
> Subject: Re: [mythtv-users] Recordings start but do not complete
> Message-ID: <506CD882.50103 at thirdcontact.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 10/03/2012 08:18 PM, R KANNAN wrote:
> > Something seem to have gone wrong with the database and now MythTV
> > thinks there is no space left and cannot autoexpre any programs.
> > Programs start getting recorded but stop after a few minutes. One of
> > the messages in the log is as follows:
> >
> > AutoExpire: Filesystem Info cache is empty, unable to determine what
> > Recordings to expire
> >
> > This started happening after I ran
> > '/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
> > <http://optimize_mythdb.pl>'.
> >
> > Fortunately, I backed up the database before running this. Should I
> > restore this backup?
>
> Did you have any crashed tables before you ran optimize_mythdb.pl?  If
> not, then running optimize_mythdb.pl is unrelated to the failure.
>
> If you had crashed tables, are you certain that you did the backup
> /before/ you had any crashed tables (because if you have crashed tables,
> they will cause the backup to fail--meaning you'd only have a partial
> backup).
>
> Regardless, you likely just need to go into mythtv-setup and fix your
> Storage Groups configuration.
>
> Mike
>
>
>
There seems to be some issue with the database that is causing the programs
not Auto-epire though they have been marked to auto-epire. I get the
following in the log file..

2012-10-05 18:26:57.950558 N  AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
 AND       starttime = ?#012Bindings were:#012:CHANID=1073,
:NEWEND=2012-10-06T23:30:00,
:NEWSTART=2012-10-06T22:30:00,#012:OLDSTART=2012-10-06T22:00:00#012Driver
error was [2/1062]:#012QMYSQL3: Unable to execute statement#012Database
error was:#012Duplicate entry '1073-2012-10-06 22:30:00-0' for key 'PRIMARY'
Oct  5 18:26:20 DVR mythbackend[9022]: E Expire autoexpire.cpp:161
(CalcParams) AutoExpire: Filesystem Info cache is empty, unable to
calculate necessary parameters.
Oct  5 18:26:20 DVR mythbackend[9022]: E Expire autoexpire.cpp:421
(ExpireRecordings) AutoExpire: Filesystem Info cache is empty, unable to
determine what Recordings to expire
Oct  5 18:27:49 DVR mythbackend[9022]: I HouseKeeping housekeeper.cpp:225
(RunHouseKeeping) Running housekeep


I tried repairing and optimizing tables but that did not help.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121005/3e6d36d1/attachment.html>