[mythtv-users] grabber failure

[Daryl McDonald]

On Sat, Oct 31, 2020 at 11:36 AM Klaas de Waal <klaas.de.waal at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20201031/ce0c3e2a/attachment.htm>