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

[Kevin Johnson]

On Wed, Jul 20, 2022 at 11:57 PM Bill Meek <keemllib at gmail.com> wrote:

> On 7/19/22 21:02, Kevin Johnson wrote:
>
> ...
>
> > 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.
>
> OK, the problem is the missing entry in housekeeping (I removed mine and
> caused the failure.)
>
> In the following, each SQL command is all on one line, in case your email
> client
> folds them.
>
> Do this:
>
> SELECT * FROM housekeeping WHERE tag='MythFillDB';
>
> If there are still no matching entries, then do this:
>
> INSERT INTO housekeeping (tag,lastrun,lastsuccess)
> VALUES('MythFillDB',TIMESTAMP('2022-07-21 03:01:01'),TIMESTAMP('2022-07-21
> 03:01:01')) LIMIT 1;
>
> If (somehow) an entry got added and the timestamps don't make any sends,
> then do this:
>
> UPDATE housekeeping SET lastrun=TIMESTAMP('2022-07-21
> 03:02:01'),lastsuccess=TIMESTAMP('2022-07-21 03:02:01') WHERE
> tag='MythFillDB' LIMIT 1;
>
> --
> Bill
>
> Without knowing exactly what I am doing so I stopped here.

mysql> SELECT * FROM housekeeping WHERE tag='MythFillDB';
ERROR 1046 (3D000): No database selected

Did I miss a step?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220721/2327ea25/attachment.htm>