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

[Stephen Worthington]

On Thu, 21 Jul 2022 09:15:34 -0400, you wrote:

>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?

Yes, you need to select the database.  On the mysql command line add
the parameter "mythconverg", or at the "mysql>" prompt, run the
command:

use mythconverg;