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

[Nick Rout]

On Oct 7, 2012 1:51 AM, "R KANNAN" <rk111810 at gmail.com> wrote:
>
>
>> 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.

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!)

>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121007/abb6de35/attachment.html>