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

[Bill Meek]

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