[mythtv-users] "Suggested next mythfilldatabase" date in the past

[Christopher X. Candreva]

On Tue, 19 Jan 2010, Michael T. Dean wrote:

> Can you:
> 
> a) execute the SQL below, keeping the log output (called
> mfdb-debug-log*.txt)
> 
> b) see if now--after your command-line run of mythfilldatabase--the
> backend status says the next mfdb run is suggested for 2010-01-20 18:14
> 
> c) if so, restart your myth system (everything including mythbackend)
> 
> d) see if it runs again, tomorrow.
> 
> If not (for either of the above "if's"), please post the output of:
> 
> cat << "EOF" | mysql -umythtv -p mythconverg 2>&1 |\
> tee mfdb-debug-log-`date +'%Y%m%d_%H%M%S'`.txt
> SELECT * FROM housekeeping;
> SELECT * FROM settings WHERE value LIKE 'mythfill%';
> EOF
> 
> executed before and after the above.


OK, the first day it ran fine. Now on the second day, I again have a next 
date in the past:

Last mythfilldatabase run started on 2010-01-21 15:06 and ended on 
2010-01-21 15:06. Successful.
Suggested next mythfilldatabase run: 2010-01-22 03:02.


Here is the debug output after I had run mythfilldatabase by hand:

tag	lastrun
DailyCleanup	2010-01-19 19:04:34
JobQueueRecover-dorcas.westnet.com	2010-01-19 04:29:16
LogClean	2010-01-15 23:05:20
MythFillDB	2010-01-14 10:53:33
BackupDB	2009-11-27 19:24:14
DBCleanup	2009-11-27 19:12:32
value	data	hostname
mythfilldatabase.urlmap.LyngSat	http://lyngsat-logo.com/logo	NULL
mythfilldatabase.urlmap.PBS	http://www.pbs.org/images/stations/standard	NULL
MythFillDatabaseArgs		NULL
mythfilldatabaseLastRunEnd	2010-01-19 19:41	NULL
mythfilldatabaseLastRunStart	2010-01-19 19:41	NULL
mythfilldatabaseLastRunStatus	Successful.	NULL
MythFillDatabaseLog		NULL
MythFillDatabasePath	/usr/bin/mythfilldatabase	NULL
MythFillEnabled	1	NULL
MythFillFixProgramIDsHasRunOnce	1	dorcas.westnet.com
MythFillFixProgramIDsHasRunOnce	1	hilda
MythFillFixProgramIDsHasRunOnce	1	lazarus.westnet.com
MythFillFixProgramIDsHasRunOnce	1	maverick.westnet.com
MythFillFixProgramIDsHasRunOnce	1	polux.westnet.com
MythFillGrabberSuggestsTime	1	NULL
MythFillMaxHour	22	NULL
MythFillMinHour	20	NULL
MythFillPeriod	1	NULL
MythFillSuggestedRunTime	2010-01-20T18:14:24	NULL



And this morning after seeing the date in tbe past again:

tag	lastrun
DailyCleanup	2010-01-22 08:42:55
JobQueueRecover-dorcas.westnet.com	2010-01-22 07:31:57
LogClean	2010-01-15 23:05:20
MythFillDB	2010-01-21 15:05:45
BackupDB	2009-11-27 19:24:14
DBCleanup	2009-11-27 19:12:32
value	data	hostname
mythfilldatabase.urlmap.LyngSat	http://lyngsat-logo.com/logo	NULL
mythfilldatabase.urlmap.PBS	http://www.pbs.org/images/stations/standard	NULL
MythFillDatabaseArgs		NULL
mythfilldatabaseLastRunEnd	2010-01-21 15:06	NULL
mythfilldatabaseLastRunStart	2010-01-21 15:06	NULL
mythfilldatabaseLastRunStatus	Successful.	NULL
MythFillDatabaseLog		NULL
MythFillDatabasePath	/usr/bin/mythfilldatabase	NULL
MythFillEnabled	1	NULL
MythFillFixProgramIDsHasRunOnce	1	dorcas.westnet.com
MythFillFixProgramIDsHasRunOnce	1	hilda
MythFillFixProgramIDsHasRunOnce	1	lazarus.westnet.com
MythFillFixProgramIDsHasRunOnce	1	maverick.westnet.com
MythFillFixProgramIDsHasRunOnce	1	polux.westnet.com
MythFillGrabberSuggestsTime	1	NULL
MythFillMaxHour	22	NULL
MythFillMinHour	20	NULL
MythFillPeriod	1	NULL
MythFillSuggestedRunTime	2010-01-22T03:02:23	NULL


==========================================================
Chris Candreva  -- chris at westnet.com -- (914) 948-3162
WestNet Internet Services of Westchester
http://www.westnet.com/