<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Date: Fri, 5 Oct 2012 18:37:27 -0400<br>
From: R KANNAN <<a href="mailto:rk111810@gmail.com">rk111810@gmail.com</a>><br>
To: <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
Subject: Re: [mythtv-users] Recordings start but do not complete<br>
Message-ID:<br>
<<a href="mailto:CABX2cSFTqYn4OXXYYaOnbfvwsoc4JWTY0tr%2BbyAQyS6e%2BDKApw@mail.gmail.com">CABX2cSFTqYn4OXXYYaOnbfvwsoc4JWTY0tr+byAQyS6e+DKApw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Date: Wed, 03 Oct 2012 20:29:54 -0400<br>
> From: "Michael T. Dean" <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>><br>
> To: Discussion about MythTV <<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>><br>
> Subject: Re: [mythtv-users] Recordings start but do not complete<br>
> Message-ID: <<a href="mailto:506CD882.50103@thirdcontact.com">506CD882.50103@thirdcontact.com</a>><br>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>
><br>
> On 10/03/2012 08:18 PM, R KANNAN wrote:<br>
> > Something seem to have gone wrong with the database and now MythTV<br>
> > thinks there is no space left and cannot autoexpre any programs.<br>
> > Programs start getting recorded but stop after a few minutes. One of<br>
> > the messages in the log is as follows:<br>
> ><br>
> > AutoExpire: Filesystem Info cache is empty, unable to determine what<br>
> > Recordings to expire<br>
> ><br>
> > This started happening after I ran<br>
> > '/usr/share/doc/mythtv-backend/contrib/maintenance/<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a><br>
> > <<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>>'.<br>
> ><br>
> > Fortunately, I backed up the database before running this. Should I<br>
> > restore this backup?<br>
><br>
> Did you have any crashed tables before you ran <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a>? If<br>
> not, then running <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> is unrelated to the failure.<br>
><br>
> If you had crashed tables, are you certain that you did the backup<br>
> /before/ you had any crashed tables (because if you have crashed tables,<br>
> they will cause the backup to fail--meaning you'd only have a partial<br>
> backup).<br>
><br>
> Regardless, you likely just need to go into mythtv-setup and fix your<br>
> Storage Groups configuration.<br>
><br>
> Mike<br>
><br>
><br>
><br>
There seems to be some issue with the database that is causing the programs<br>
not Auto-epire though they have been marked to auto-epire. I get the<br>
following in the log file..<br>
<br>
2012-10-05 18:26:57.950558 N AutoExpire: CalcParams(): Max required Free<br>
Space: 1.0 GB w/freq: 15 min<br>
AND starttime = ?#012Bindings were:#012:CHANID=1073,<br>
:NEWEND=2012-10-06T23:30:00,<br>
:NEWSTART=2012-10-06T22:30:00,#012:OLDSTART=2012-10-06T22:00:00#012Driver<br>
error was [2/1062]:#012QMYSQL3: Unable to execute statement#012Database<br>
error was:#012Duplicate entry '1073-2012-10-06 22:30:00-0' for key 'PRIMARY'<br>
Oct 5 18:26:20 DVR mythbackend[9022]: E Expire autoexpire.cpp:161<br>
(CalcParams) AutoExpire: Filesystem Info cache is empty, unable to<br>
calculate necessary parameters.<br>
Oct 5 18:26:20 DVR mythbackend[9022]: E Expire autoexpire.cpp:421<br>
(ExpireRecordings) AutoExpire: Filesystem Info cache is empty, unable to<br>
determine what Recordings to expire<br>
Oct 5 18:27:49 DVR mythbackend[9022]: I HouseKeeping housekeeper.cpp:225<br>
(RunHouseKeeping) Running housekeep<br>
<br>
<br>
I tried repairing and optimizing tables but that did not help<br></blockquote><div><br>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. <br>
</div></div>