[mythtv-users] sql query error affecting autoexpire deleting (0.22-fixes via avenard)

[Steven Adeff]

On Mon, Nov 2, 2009 at 10:46 PM, Andy Colson <andy at squeakycode.net> wrote:
> Steven Adeff wrote:
>>
>> On Mon, Nov 2, 2009 at 10:21 PM, Nick Morrott <knowledgejunkie at gmail.com>
>> wrote:
>>>
>>> 2009/11/3 Steven Adeff <adeffs.mythtv at gmail.com>:
>>>>
>>>> anyone know whats going wrong?
>>>
>>> <snip>
>>>
>>>> Database error was:
>>>> Can't find file: './mythconverg/record.frm' (errno: 13)
>>>
>>> Does that file exist?
>>
>> no, but it never seemed to be there (at least according to my backups
>>
>>> Does your database have errors? When did you last run optimize_mythdb.pl?
>>
>> this was just after updating to 0.22, mythbackend stopped deleting
>> expired recordings. upon your email I ran optimize_mythdb.pl and
>> mythbackend decided to start expiring. I hope this (whatever it was)
>> was the problem.
>>
>>
>> Thanks Nick!
>>
>>> Do you have a recent DB backup?
>>>
>>> See
>>> http://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance#Optimize_the_Database
>>> for more info.
>>
>
> ahh.. ./mythconverg is a relative path.  It should be something like
> /var/lib/mysql/mythconverg... or in my case /dbs/mysql.
>
> But ./mythconverg would change depending on the current directory.
>
> -Andy

is it possible that having a non-writeable storage group would prevent
auto-expire from deleting recordings to free up space on the
recordings drive?


-- 
Steve
http://www.mythtv.org/wiki/index.php/User:Steveadeff
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette