Mailing List Archive: MythTV: Users

sql query error affecting autoexpire deleting (0.22-fixes via avenard)

Index | Next | Previous | View Threaded

adeffs.mythtv at gmail

Nov 2, 2009, 7:07 PM

Post #1 of 5 (152 views)
Permalink

sql query error affecting autoexpire deleting (0.22-fixes via avenard)

anyone know whats going wrong?

2009-11-02 22:05:42.743 Error preparing query: SELECT NULL from record
WHERE type = :FINDONE AND findid <= 0;
2009-11-02 22:05:42.765 Driver error was [2/1017]:
QMYSQL3: Unable to prepare statement
Database error was:
Can't find file: './mythconverg/record.frm' (errno: 13)

2009-11-02 22:05:42.766 DB Error (UpdateMatches):
Query was:
SELECT NULL from record WHERE type = ? AND findid <= 0;
Bindings were:
:FINDONE=6
No error type from QSqlError? Strange...
2009-11-02 22:05:42.769 Error preparing query: SELECT
recordid,title,maxepisodes,maxnewest FROM record;
2009-11-02 22:05:42.780 Driver error was [2/1017]:
QMYSQL3: Unable to prepare statement
Database error was:
Can't find file: './mythconverg/record.frm' (errno: 13)

2009-11-02 22:05:42.781 DB Error (CheckTooMany):
Query was:
SELECT recordid,title,maxepisodes,maxnewest FROM record;
No error type from QSqlError? Strange...
2009-11-02 22:05:42.783 Error preparing query: SELECT record.recordid,
record.type, record.chanid, record.starttime, record.startdate,
record.endtime, record.enddate, record.startoffset, record.endoffset,
record.title, record.subtitle, record.description, channel.channum,
channel.callsign, channel.name FROM record INNER JOIN channel ON
(channel.chanid = record.chanid) LEFT JOIN recordmatch on
record.recordid = recordmatch.recordid WHERE (type = 1 OR type = 2 OR
type = 5 OR type = 7) AND recordmatch.chanid IS NULL
2009-11-02 22:05:42.792 Driver error was [2/1017]:
QMYSQL3: Unable to prepare statement
Database error was:
Can't find file: './mythconverg/record.frm' (errno: 13)

2009-11-02 22:05:42.793 DB Error (AddNotListed):
Query was:
SELECT record.recordid, record.type, record.chanid, record.starttime,
record.startdate, record.endtime, record.enddate, record.startoffset,
record.endoffset, record.title, record.subtitle, record.description,
channel.channum, channel.callsign, channel.name FROM record INNER
JOIN channel ON (channel.chanid = record.chanid) LEFT JOIN
recordmatch on record.recordid = recordmatch.recordid WHERE (type = 1
OR type = 2 OR type = 5 OR type = 7) AND recordmatch.chanid IS NULL
No error type from QSqlError? Strange...
2009-11-02 22:05:42.809 Error preparing query: SELECT recordid,
next_record FROM record;
2009-11-02 22:05:42.826 Driver error was [2/1017]:
QMYSQL3: Unable to prepare statement
Database error was:
Can't find file: './mythconverg/record.frm' (errno: 13)

--
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
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

knowledgejunkie at gmail

Nov 2, 2009, 7:21 PM

Post #2 of 5 (139 views)
Permalink

Re: sql query error affecting autoexpire deleting (0.22-fixes via avenard) [In reply to]

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?

Does your database have errors? When did you last run optimize_mythdb.pl?

Do you have a recent DB backup?

See http://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance#Optimize_the_Database
for more info.

Cheers,
Nick

--
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

adeffs.mythtv at gmail

Nov 2, 2009, 7:40 PM

Post #3 of 5 (139 views)
Permalink

Re: sql query error affecting autoexpire deleting (0.22-fixes via avenard) [In reply to]

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.

--
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
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

andy at squeakycode

Nov 2, 2009, 7:46 PM

Post #4 of 5 (139 views)
Permalink

Re: sql query error affecting autoexpire deleting (0.22-fixes via avenard) [In reply to]

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
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

adeffs.mythtv at gmail

Nov 3, 2009, 7:45 AM

Post #5 of 5 (110 views)
Permalink

Re: sql query error affecting autoexpire deleting (0.22-fixes via avenard) [In reply to]

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
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com