[mythtv-users] grabber failure

[Daryl McDonald]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20201030/cb54bfd0/attachment.htm>