Mailing List Archive: grabber failure

grabber failure

Oct 30, 2020, 5:52 PM

Post #1 of 7 (524 views)

2020-10-30 20:40:38.121850 E Error preparing query: DELETE FROM
programgenres WHERE starttime >= :FROM AND starttime < :TO AND chanid =
:CHANID ;
2020-10-30 20:40:38.121861 E Driver error was [2/1034]:
QMYSQL3: Unable to prepare statement
Database error was:
Incorrect key file for table 'programgenres'; try to repair it

2020-10-30 20:40:38.121932 I Updated programs: 0 Unchanged programs: 16793
2020-10-30 20:40:38.368444 N Data fetching complete.
2020-10-30 20:40:38.368490 I Adjusting program database end times.
2020-10-30 20:40:38.368801 I 0 replacements made
2020-10-30 20:40:38.368811 I Marking generic episodes.
2020-10-30 20:40:38.484308 I Found 0
2020-10-30 20:40:38.484315 I Extending non-unique programids with multiple
parts.
2020-10-30 20:40:38.553894 I Found 0
2020-10-30 20:40:38.553908 I Fixing missing original airdates.
2020-10-30 20:40:38.815327 I Found 0 with programids
2020-10-30 20:40:38.816180 I Found 0 without programids
2020-10-30 20:40:38.816189 I Marking repeats.
2020-10-30 20:40:38.824684 I Found 0
2020-10-30 20:40:38.824697 I Unmarking new episode rebroadcast repeats.
2020-10-30 20:40:38.901883 I Found 0
2020-10-30 20:40:39.288106 I Marking episode first showings.
2020-10-30 20:40:39.946011 I Found 19472
2020-10-30 20:40:39.946021 I Marking episode last showings.
2020-10-30 20:40:40.604923 I Found 19446
2020-10-30 20:40:40.611487 I
===============================================================
| Attempting to contact the master backend for rescheduling. |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted. |
===============================================================
2020-10-30 20:40:40.613106 N mythfilldatabase run complete.
2020-10-30 20:40:40.613284 I PowerDBus: Closing interfaces
2020-10-30 20:40:40.614069 I Waiting for threads to exit.
2020-10-30 20:40:40.616334 I Exiting
$
The first paragraph repeats quite a lot, then this message prior to
exiting. From the terminal FE>info shows possible failure, when run by
exiting BE, and clicking "yes" to run mythfilldatabase FE>info
shows grabber failed.
There are occasional "unknown" (black) time slots in the schedules grid.
The last couple times I watched the news, near the end of the program it
couldn't skip forward (seek table lost) and I reinstalled mysql then
rebuilt the seektable, I'm thinking these are symptoms of an underlying
problem, any suggestions on where to look etc is greatly appreciated. TIA
Daryl

Re: grabber failure [ In reply to ]

darylangela at gmail

Oct 31, 2020, 6:54 AM

Post #2 of 7 (522 views)

Permalink

On Fri, Oct 30, 2020 at 8:52 PM Daryl McDonald <darylangela@gmail.com>
wrote:

> 2020-10-30 20:40:38.121850 E Error preparing query: DELETE FROM
> programgenres WHERE starttime >= :FROM AND starttime < :TO AND chanid =
> :CHANID ;
> 2020-10-30 20:40:38.121861 E Driver error was [2/1034]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Incorrect key file for table 'programgenres'; try to repair it
>
> 2020-10-30 20:40:38.121932 I Updated programs: 0 Unchanged programs: 16793
> 2020-10-30 20:40:38.368444 N Data fetching complete.
> 2020-10-30 20:40:38.368490 I Adjusting program database end times.
> 2020-10-30 20:40:38.368801 I 0 replacements made
> 2020-10-30 20:40:38.368811 I Marking generic episodes.
> 2020-10-30 20:40:38.484308 I Found 0
> 2020-10-30 20:40:38.484315 I Extending non-unique programids with
> multiple parts.
> 2020-10-30 20:40:38.553894 I Found 0
> 2020-10-30 20:40:38.553908 I Fixing missing original airdates.
> 2020-10-30 20:40:38.815327 I Found 0 with programids
> 2020-10-30 20:40:38.816180 I Found 0 without programids
> 2020-10-30 20:40:38.816189 I Marking repeats.
> 2020-10-30 20:40:38.824684 I Found 0
> 2020-10-30 20:40:38.824697 I Unmarking new episode rebroadcast repeats.
> 2020-10-30 20:40:38.901883 I Found 0
> 2020-10-30 20:40:39.288106 I Marking episode first showings.
> 2020-10-30 20:40:39.946011 I Found 19472
> 2020-10-30 20:40:39.946021 I Marking episode last showings.
> 2020-10-30 20:40:40.604923 I Found 19446
> 2020-10-30 20:40:40.611487 I
> ===============================================================
> | Attempting to contact the master backend for rescheduling. |
> | If the master is not running, rescheduling will happen when |
> | the master backend is restarted. |
> ===============================================================
> 2020-10-30 20:40:40.613106 N mythfilldatabase run complete.
> 2020-10-30 20:40:40.613284 I PowerDBus: Closing interfaces
> 2020-10-30 20:40:40.614069 I Waiting for threads to exit.
> 2020-10-30 20:40:40.616334 I Exiting
> $
> The first paragraph repeats quite a lot, then this message prior to
> exiting. From the terminal FE>info shows possible failure, when run by
> exiting BE, and clicking "yes" to run mythfilldatabase FE>info
> shows grabber failed.
> There are occasional "unknown" (black) time slots in the schedules grid.
> The last couple times I watched the news, near the end of the program it
> couldn't skip forward (seek table lost) and I reinstalled mysql then
> rebuilt the seektable, I'm thinking these are symptoms of an underlying
> problem, any suggestions on where to look etc is greatly appreciated. TIA
> Daryl
>

Here is a mysql error.log: https://paste.ubuntu.com/p/rYHM9hdMXD/ that
was zipped,

and the current one: https://paste.ubuntu.com/p/XmSGKqYgvc/ without
errors even after attempting "mythfilldatabase" unsuccessfully.

Re: grabber failure [ In reply to ]

jharbestonus at gmail

Oct 31, 2020, 8:17 AM

Post #3 of 7 (522 views)

Permalink

> On Oct 31, 2020, at 9:54 AM, Daryl McDonald
> Here is a mysql error.log: https://paste.ubuntu.com/p/rYHM9hdMXD/ <https://paste.ubuntu.com/p/rYHM9hdMXD/> that was zipped,
>
> and the current one: https://paste.ubuntu.com/p/XmSGKqYgvc/ <https://paste.ubuntu.com/p/XmSGKqYgvc/> without errors even after attempting "mythfilldatabase" unsuccessfully.

The errors are telling you that your tables are crashed and that MYSQL has given up, leading mythtv to also give up.

Maybe a mysql expert can tell you how to fix it… Whenever I have had problems with mysql, I have had to go to google and query for crashed tables for a fix..

Regards.

Re: grabber failure [ In reply to ]

klaas.de.waal at gmail

Oct 31, 2020, 8:35 AM

Post #4 of 7 (522 views)

Permalink

In the source tree of mythtv there is the optimize_mythdb.pl script:
mythtv/mythtv/contrib/maintenance/optimize_mythdb.pl
which does analyze/repair/optimize all tables.
I run this periodically from a cron job but you can run this manually as
well.

Hope this helps,
Klaas.

On Sat, 31 Oct 2020 at 16:19, Jay Harbeston <jharbestonus@gmail.com> wrote:

>
>
> On Oct 31, 2020, at 9:54 AM, Daryl McDonald
> Here is a mysql error.log: https://paste.ubuntu.com/p/rYHM9hdMXD/
> that was zipped,
>
> and the current one: https://paste.ubuntu.com/p/XmSGKqYgvc/ without
> errors even after attempting "mythfilldatabase" unsuccessfully.
>
>
>
>
> The errors are telling you that your tables are crashed and that MYSQL has
> given up, leading mythtv to also give up.
>
> Maybe a mysql expert can tell you how to fix it… Whenever I have had
> problems with mysql, I have had to go to google and query for crashed
> tables for a fix..
>
> Regards.
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>

Re: grabber failure [ In reply to ]

darylangela at gmail

Oct 31, 2020, 8:42 AM

Post #5 of 7 (522 views)

Permalink

On Sat, Oct 31, 2020 at 11:36 AM Klaas de Waal <klaas.de.waal@gmail.com>
wrote:

> In the source tree of mythtv there is the optimize_mythdb.pl script:
> mythtv/mythtv/contrib/maintenance/optimize_mythdb.pl
> which does analyze/repair/optimize all tables.
> I run this periodically from a cron job but you can run this manually as
> well.
>
> Hope this helps,
> Klaas.
>
>
>
> On Sat, 31 Oct 2020 at 16:19, Jay Harbeston <jharbestonus@gmail.com>
> wrote:
>
>>
>>
>> On Oct 31, 2020, at 9:54 AM, Daryl McDonald
>> Here is a mysql error.log: https://paste.ubuntu.com/p/rYHM9hdMXD/
>> that was zipped,
>>
>> and the current one: https://paste.ubuntu.com/p/XmSGKqYgvc/ without
>> errors even after attempting "mythfilldatabase" unsuccessfully.
>>
>>
>>
>>
>> The errors are telling you that your tables are crashed and that MYSQL
>> has given up, leading mythtv to also give up.
>>
>> Maybe a mysql expert can tell you how to fix it… Whenever I have had
>> problems with mysql, I have had to go to google and query for crashed
>> tables for a fix..
>>
>> Regards.
>>
>>
>> I have moved the optimize script to cron.daily. I just ran it manually
and tried mythfilldatabase, still no joy.

I remain open to other suggestions.

Re: grabber failure [ In reply to ]

jharbestonus at gmail

Oct 31, 2020, 10:05 AM

Post #6 of 7 (522 views)

Permalink

> On Oct 31, 2020, at 11:42 AM, Daryl McDonald <darylangela@gmail.com> wrote:
>
>
>
> The errors are telling you that your tables are crashed and that MYSQL has given up, leading mythtv to also give up.
>
> Maybe a mysql expert can tell you how to fix it… Whenever I have had problems with mysql, I have had to go to google and query for crashed tables for a fix..
>
> Regards.
>
>

> I have moved the optimize script to cron.daily. I just ran it manually and tried mythfilldatabase, still no joy.
>
> I remain open to other suggestions.

You are going to have to do some ‘intense’ mysql surgery. I refer to the google query above to find instructions for it.

Has the machine lost power recently, or the hard drive had problems? Usually the kind of damage you have has been something happened recently to your hardware.

Regards.

Re: grabber failure [ In reply to ]

darylangela at gmail

Nov 1, 2020, 3:50 AM

Post #7 of 7 (520 views)

Permalink

On Sat, Oct 31, 2020 at 1:06 PM Jay Harbeston <jharbestonus@gmail.com>
wrote:

>
>
> On Oct 31, 2020, at 11:42 AM, Daryl McDonald <darylangela@gmail.com>
> wrote:
>
>
>
> The errors are telling you that your tables are crashed and that MYSQL has
>>> given up, leading mythtv to also give up.
>>>
>>> Maybe a mysql expert can tell you how to fix it… Whenever I have had
>>> problems with mysql, I have had to go to google and query for crashed
>>> tables for a fix..
>>>
>>> Regards.
>>>
>>>
>>>
>
>
> I have moved the optimize script to cron.daily. I just ran it manually and
> tried mythfilldatabase, still no joy.
>
> I remain open to other suggestions.
>
>
>
> You are going to have to do some ‘intense’ mysql surgery. I refer to the
> google query above to find instructions for it.
>
> Has the machine lost power recently, or the hard drive had problems?
> Usually the kind of damage you have has been something happened recently to
> your hardware.
>
> Regards.
>
> No database connection was made the next time I turned the box on, so I
finally purged and reinstalled mythtv. restored a couple of days old
DB-backup, so there will be a few orphans to find and move to videos, but
it is functional again!