<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jul 19, 2022 at 9:43 PM Bill Meek <<a href="mailto:keemllib@gmail.com">keemllib@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 7/19/22 20:05, Kevin Johnson wrote:<br>
> <br>
> <br>
> On Tue, Jul 19, 2022 at 8:48 PM Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a> <mailto:<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>>> wrote:<br>
> <br>
> On 7/19/22 19:37, Kevin Johnson wrote:<br>
> ><br>
> ><br>
> > On Tue, Jul 19, 2022 at 8:25 PM Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a> <mailto:<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>> <mailto:<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a><br>
> <mailto:<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>>>> wrote:<br>
> ><br>
> > On 7/19/22 19:18, Kevin Johnson wrote:<br>
> > > If I run the command like this.<br>
> > > sudo mysql -u root -p mythconverg -e "SELECT * FROM housekeeping"<br>
> ><br>
> > ^^^ will dump the whole table (mine's 14 lines long).<br>
> ><br>
> ><br>
> > tag | hostname | lastrun | lastsuccess |<br>
> > +----------+----------+---------------------+---------------------+<br>
> > | BackupDB | NULL | 2021-11-28 02:44:58 | 2021-11-28 02:44:58 |<br>
> ><br>
> <br>
> This, or maybe you need to add the -u root as above.<br>
> <br>
> sudo mysqlcheck --verbose mythconverg<br>
> <br>
> <br>
> Expect all tables to come back marked "OK".<br>
> <br>
> Yes. Everything came back ok.<br>
<br>
The tags are added to the housekeeping table on successful completion of<br>
the various jobs.<br>
<br>
Odd that the only entry above is for BackupDB run last November.<br>
<br>
If you look grep for MythFillDB in the mythbackend.log (or syslog or the journal,<br>
wherever you keep the logs), then you should see lines containing these:<br>
<br>
41 .... Registering HouseKeeperTask 'MythFillDB'.<br>
342 .... Queueing HouseKeeperTask 'MythFillDB'.<br>
344 .... Running HouseKeeperTask 'MythFillDB'.<br>
351 .... HouseKeeperTask 'MythFillDB' Finished Successfully.<br>
<br>
Note that the line numbers show that the housekeeper early after startup<br>
and should start mythfilldatabase if it hasn't been run - unless there's a<br>
bug that doesn't handle missing tags. If you don't see the Finished Successfully<br>
line, then look at the full log and see if there's an error after the Running<br>
line.<br>
<br>
-- <br>
Bill<br></blockquote><div><br></div><div>It is running, But as you can see it just stops sometimes. Did not run from Jun 30 to July 8</div><div>I don't really monitor the backend that much obviously.</div><div>I manually ran it today.</div><div><br></div><div>Jun 30 18:40:43 hemlock mythbackend: mythbackend[65727]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 8 18:27:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:663 (RegisterTask) Registering HouseKeeperTask 'MythFillDB'.<br>Jul 8 18:28:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 8 18:28:36 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 8 18:31:26 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 9 18:29:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 9 18:29:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 9 18:31:54 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 10 19:30:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 10 19:30:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 10 19:32:49 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 11 19:31:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 11 19:31:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 11 19:33:54 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 12 19:32:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 12 19:32:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 12 19:34:18 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 13 19:33:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 13 19:33:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 13 19:36:28 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 14 19:34:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 14 19:34:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 14 19:37:06 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 15 19:35:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 15 19:35:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 15 19:38:00 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 16 19:36:34 hemlock mythbackend: mythbackend[97154]: I CoreContext housekeeper.cpp:754 (Run) Queueing HouseKeeperTask 'MythFillDB'.<br>Jul 16 19:36:34 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:144 (Run) Running HouseKeeperTask 'MythFillDB'.<br>Jul 16 19:38:56 hemlock mythbackend: mythbackend[97154]: I HouseKeeping housekeeper.cpp:164 (Run) HouseKeeperTask 'MythFillDB' Finished Successfully.<br>Jul 19 19:16:11 hemlock mythbackend: mythbackend[139181]: I CoreContext housekeeper.cpp:663 (RegisterTask) Registering HouseKeeperTask 'MythFillDB'.<br></div><div><br></div><div>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.</div><div><br></div><div>I could do a reboot and then see if the issue occurs again.</div></div></div>