<p><br>
On Oct 7, 2012 1:51 AM, "R KANNAN" <<a href="mailto:rk111810@gmail.com">rk111810@gmail.com</a>> wrote:<br>
><br>
><br>
>> 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">optimize_mythdb.pl</a><br>
>> > > <<a href="http://optimize_mythdb.pl">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">optimize_mythdb.pl</a>? If<br>
>> > not, then running <a href="http://optimize_mythdb.pl">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>
><br>
><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></p>
<p>Why would you run mythbackend as root under ubuntu? The packages are setup to run it as user mythtv. By doing it some other way you are inviting trouble (and seemingly getting it!)</p>
<p>><br>
> _______________________________________________<br>
> mythtv-users mailing list<br>
> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
> <a href="http://www.mythtv.org/mailman/listinfo/mythtv-users">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
><br>
</p>