[mythtv-users] Mythfilldatabase stopped running - how do I diagnose the problem?

[Greg Mitchell]

Michael T. Dean wrote:
> Shut down all your myth systems (frontends/backends).  Do a database 
> backup (you've been warned, so it's not my fault, anymore :) as 
> described at http://www.mythtv.org/wiki/Database_Backup_and_Restore .  
> Then run:
> 
> YESTERDAY=`date  -d "25 hours ago" +"%Y-%m-%d %H:%M"`
> echo "UPDATE housekeeping SET lastrun = '${YESTERDAY}:00' "\
>     "WHERE tag = 'MythFillDB';" | mysql -umythtv -p mythconverg
> echo "UPDATE settings SET data = '${YESTERDAY}' "\
>     "WHERE value IN ('mythfilldatabaseLastRunStart', " \
>     "'mythfilldatabaseLastRunEnd');" | mysql -umythtv -p mythconverg
> NOW=`date -d "yesterday" +"%Y-%m-%dT%H:%M:%S"`
> echo "UPDATE settings SET data = '${NOW}' " \
>     "WHERE value = 'MythFillSuggestedRunTime';" |
>  mysql -umythtv -p mythconverg
> unset YESTERDAY
> unset NOW
> 
> Then restart.  Within an hour of restarting, mythfilldatabase should run.

Perfect - thanks.  It looks like the housekeeping record was the 
culprit, because the other two values were sane.  I guess it would have 
resolved itself if I'd let it sit another few days.

Thanks again,

Greg