[mythtv-users] grabber failure

[Daryl McDonald]

On Fri, Oct 30, 2020 at 8:52 PM Daryl McDonald <darylangela at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20201031/27acbe08/attachment.htm>