[mythtv-users] Mythfilldatabase taking FOREVER

Larry Kennedy lunchtimelarry at gmail.com
Sun Jun 5 02:21:19 UTC 2022


On Sat, Jun 4, 2022 at 9:33 PM Larry Kennedy <lunchtimelarry at gmail.com>
wrote:

> Recently, I'm noticing that mythfilldtabase is taking something like 12
> hours to finish. I know we had some issues with SD and the backend
> maintenance, so not sure if that has been fully resolved.
>
> I'm on Ubuntu 18.04 and mythtv v30.0.  I use the sdjson_sqlite grabber
> v1.109 and xmltv v0.5.70.  I only have about 100 channels set as "selected"
> in the sqlite database.
>
> Mythfilldatabase sits forever on the message "pruning local database"
>
> I see very low CPU utilization on a four vCPU i7 VM with 8GB RAM.
>
> Any thoughts on why this is taking so long?
>
> Larry
>

More log details:  With system,xmltv logging turned on, I see that it is
taking up to 20 seconds per program to insert:

2022-06-04 22:15:41.833789 I  Removing existing program:
2022-06-17T00:00:00Z - 2022-06-17T00:51:00Z I114759.json.schedulesdirect.org
Dark Winds
2022-06-04 22:15:42.257005 I  Inserting new program    :
2022-06-17T00:00:00Z - 2022-06-17T00:51:00Z I114759.json.schedulesdirect.org
Dark Winds
2022-06-04 22:15:47.151660 I  Removing existing program:
2022-06-17T00:51:00Z - 2022-06-17T01:42:00Z I114759.json.schedulesdirect.org
Dark Winds
2022-06-04 22:15:47.784472 I  Inserting new program    :
2022-06-17T00:51:00Z - 2022-06-17T01:42:00Z I114759.json.schedulesdirect.org
Dark Winds
2022-06-04 22:15:54.196309 I  Inserting new program    :
2022-06-21T03:11:00Z - 2022-06-21T03:56:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:16:17.185399 I  Inserting new program    :
2022-06-21T03:56:00Z - 2022-06-21T04:41:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:16:33.053704 I  Inserting new program    :
2022-06-21T04:41:00Z - 2022-06-21T05:26:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:16:50.177901 I  Inserting new program    :
2022-06-21T05:26:00Z - 2022-06-21T06:19:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:17:04.171445 I  Inserting new program    :
2022-06-21T06:19:00Z - 2022-06-21T07:05:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:17:17.125686 I  Inserting new program    :
2022-06-21T07:05:00Z - 2022-06-21T07:50:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:17:40.029102 I  Inserting new program    :
2022-06-21T07:50:00Z - 2022-06-21T08:35:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:17:58.823123 I  Inserting new program    :
2022-06-21T08:35:00Z - 2022-06-21T09:17:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:18:15.070319 I  Inserting new program    :
2022-06-21T09:17:00Z - 2022-06-21T10:00:00Z I114759.json.schedulesdirect.org
Fear the Walking Dead
2022-06-04 22:18:35.823610 I  Inserting new program    :
2022-06-21T10:00:00Z - 2022-06-21T10:51:00Z I114759.json.schedulesdirect.org
The Walking Dead
2022-06-04 22:18:59.061001 I  Inserting new program    :
2022-06-21T10:51:00Z - 2022-06-21T11:40:00Z I114759.json.schedulesdirect.org
The Walking Dead
2022-06-04 22:19:18.485766 I  Inserting new program    :
2022-06-21T11:40:00Z - 2022-06-21T12:40:00Z I114759.json.schedulesdirect.org
The Walking Dead

Does that seem right?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220604/02bfbe7a/attachment.htm>


More information about the mythtv-users mailing list