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

[Michael T. Dean]

On 05/22/2009 08:57 PM, Greg Mitchell wrote:
> I've been running Myth for a long time, and this is a new one to me.  
> I had an unscheduled power outage that outlasted my ups.  When the 
> system came back up, it thought it was several weeks in the future.  I 
> set the system clock properly, got ntp going etc.
>
> Since that day though, mythfilldatabase doesn't seem to run 
> automatically.  When I log in as the user that all myth-related 
> applications run as, I'm able to run it, and refresh the data with no 
> problem.
>
> I can't find reference to mythfilldatabase in the backend log.  Any 
> idea where I should be looking to see what's going on?
>
> Further info - I'm on Schedules Direct, and my subscription is up to 
> date. 

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.

Mike