[mythtv-users] Mythfilldatabase stopped running - how do I diagnose the problem?
Michael T. Dean
mtdean at thirdcontact.com
Sat May 23 02:18:29 UTC 2009
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
More information about the mythtv-users
mailing list