<br><br><div class="gmail_quote"><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Date: Wed, 03 Oct 2012 20:29:54 -0400<br>
From: "Michael T. Dean" <<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>><br>
To: Discussion about MythTV <<a href="mailto:mythtv-users@mythtv.org" target="_blank">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" target="_blank">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></blockquote></div><br>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..<br><br>2012-10-05 18:26:57.950558 N AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min<br>
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'<br>
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.<br>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<br>
Oct 5 18:27:49 DVR mythbackend[9022]: I HouseKeeping housekeeper.cpp:225 (RunHouseKeeping) Running housekeep<br><br><br>I tried repairing and optimizing tables but that did not help.<br>