[mythtv-users] sql query error affecting autoexpire deleting (0.22-fixes via avenard)
adeffs.mythtv at gmail.com
Tue Nov 3 15:45:55 UTC 2009
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>
>>> 2009/11/3 Steven Adeff <adeffs.mythtv at gmail.com>:
>>>> anyone know whats going wrong?
>>>> 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?
>>> 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.
is it possible that having a non-writeable storage group would prevent
auto-expire from deleting recordings to free up space on the
Before you ask, read the FAQ!
then search the Wiki, and this list,
Mailinglist etiquette -
More information about the mythtv-users