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

Bill Meek keemllib at gmail.com
Wed Jul 20 01:41:46 UTC 2022


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


More information about the mythtv-users mailing list