[mythtv-users] Recordings start but do not complete [SOLVED]

[R KANNAN]

> Date: Fri, 5 Oct 2012 18:37:27 -0400
> From: R KANNAN <rk111810 at gmail.com>
> To: mythtv-users at mythtv.org
> Subject: Re: [mythtv-users] Recordings start but do not complete
> Message-ID:
>         <
> CABX2cSFTqYn4OXXYYaOnbfvwsoc4JWTY0tr+byAQyS6e+DKApw at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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
>

Again the problem seems to be something to do with permissions.
mythtv-backend is being run as 'root'. When I ran it as a service (under
'mythtv' as the user) it worked fine.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121006/13aa88bc/attachment.html>