[mythtv-users] mythfilldatabase stops running after a few days

[Kevin Johnson]

On Tue, Jul 19, 2022 at 9:43 PM Bill Meek <keemllib at gmail.com> wrote:

> On 7/19/22 20:05, Kevin Johnson wrote:
> >
> >
> > On Tue, Jul 19, 2022 at 8:48 PM Bill Meek <keemllib at gmail.com <mailto:
> keemllib at gmail.com>> wrote:
> >
> >     On 7/19/22 19:37, Kevin Johnson wrote:
> >      >
> >      >
> >      > On Tue, Jul 19, 2022 at 8:25 PM Bill Meek <keemllib at gmail.com
> <mailto:keemllib at gmail.com> <mailto:keemllib at gmail.com
> >     <mailto:keemllib at gmail.com>>> wrote:
> >      >
> >      >     On 7/19/22 19:18, Kevin Johnson wrote:
> >      >      > If I run the command like this.
> >      >      > sudo mysql -u root -p mythconverg -e "SELECT * FROM
> housekeeping"
> >      >
> >      >     ^^^ will dump the whole table (mine's 14 lines long).
> >      >
> >      >
> >      >   tag      | hostname | lastrun             | lastsuccess
> |
> >      >
> +----------+----------+---------------------+---------------------+
> >      > | BackupDB | NULL     | 2021-11-28 02:44:58 | 2021-11-28 02:44:58
> |
> >      >
> >
> >     This, or maybe you need to add the -u root as above.
> >
> >         sudo mysqlcheck --verbose mythconverg
> >
> >
> >     Expect all tables to come back marked "OK".
> >
> >     Yes.  Everything came back ok.
>
> The tags are added to the housekeeping table on successful completion of
> the various jobs.
>
> Odd that the only entry above is for BackupDB run last November.
>
> If you look grep for MythFillDB in the mythbackend.log (or syslog or the
> journal,
> wherever you keep the logs), then you should see lines containing these:
>
>   41 .... Registering HouseKeeperTask 'MythFillDB'.
> 342 .... Queueing HouseKeeperTask 'MythFillDB'.
> 344 .... Running HouseKeeperTask 'MythFillDB'.
> 351 .... HouseKeeperTask 'MythFillDB' Finished Successfully.
>
> Note that the line numbers show that the housekeeper early after startup
> and should start mythfilldatabase if it hasn't been run - unless there's a
> bug that doesn't handle missing tags. If you don't see the Finished
> Successfully
> line, then look at the full log and see if there's an error after the
> Running
> line.
>
> --
> Bill
>

It is running,  But as you can see it just stops sometimes.  Did not run
from Jun 30 to July 8
I don't really monitor the backend that much obviously.
I manually ran it today.

Jun 30 18:40:43 hemlock mythbackend: mythbackend[65727]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul  8 18:27:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:663 (RegisterTask) Registering HouseKeeperTask 'MythFillDB'.
Jul  8 18:28:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul  8 18:28:36 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul  8 18:31:26 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul  9 18:29:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul  9 18:29:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul  9 18:31:54 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul 10 19:30:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul 10 19:30:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul 10 19:32:49 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul 11 19:31:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul 11 19:31:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul 11 19:33:54 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul 12 19:32:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul 12 19:32:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul 12 19:34:18 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul 13 19:33:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul 13 19:33:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul 13 19:36:28 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul 14 19:34:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul 14 19:34:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul 14 19:37:06 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul 15 19:35:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul 15 19:35:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul 15 19:38:00 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul 16 19:36:34 hemlock mythbackend: mythbackend[97154]: I CoreContext
housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.
Jul 16 19:36:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.
Jul 16 19:38:56 hemlock mythbackend: mythbackend[97154]: I HouseKeeping
housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished
Successfully.
Jul 19 19:16:11 hemlock mythbackend: mythbackend[139181]: I CoreContext
housekeeper.cpp:663 (RegisterTask) Registering HouseKeeperTask 'MythFillDB'.

It is possible that mythfilldatabase does not start after the backend is
shutdown then restarted.  I know a few days ago I had a power outage.  I
think that was July 16.  Possibly.

I could do a reboot and then see if the issue occurs again.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220719/921feaab/attachment-0001.htm>