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

[Michael T. Dean]

On 01/19/2010 07:43 PM, Christopher X. Candreva wrote:
> I'm running Mythtv 0.22 from At RPMS (mythtv-0.22-224.fc12)
>
> I'm seeing something very strange in my mythweb status screen:
>
>   Last mythfilldatabase run started on 2010-01-17 15:59 and ended on 
>   2010-01-17 15:59. mythfilldatabase ran, but did not insert any new data 
>   into the Guide for 1 of 1 sources. This can indicate a potential grabber failure.
>
>   Suggested next mythfilldatabase run: 2010-01-18 20:35.
>
> Since it is now Jan 19, there is obviously some kind of problem. :-)
>
> Running 'mythfilldatabase' from the coomand line (with no options for this 
> test) seems to have exited normally. Any suggestions as to what is wrong ?
>   

mythbackend thinks mythfilldatabase is still running (because one of the
mythfilldatabase processes did not complete).

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.

Thanks,
Mike