Hi everyone,
I'm having a problem with MySQL and mythfilldatabase. My mythfilldatabase is execcuting automaticly, but I'm receiving the:
Quote: Last mythfilldatabase run started on 2006-08-10 14:23 and ended on 2006-08-10 14:23. mythfilldatabase ran, but did not insert any new data into the Guide. This can indicate a potential grabber failure.
Suggested next mythfilldatabase run: 2006-08-11 03:00.
There's guide data until 2006-08-22 22:30 (12 days).
DataDirect Status: Your subscription expires on 09/28/06 05:31:59 error.
This mythconverg database was imported from a R5B7 install automagiclly from tjc's backup/restore scripts and yes, I used his check_backup.sh script and everything checked out. It was running fine for a few weeks.
At the same time, the mysql.log file is HUGE! This morning it was nearly 900MB. To prevent it from killing my root partition I moved it to a samba share and created a new file in it's place
Code: # touch /var/log/mysql/mysql.log
# chown mysql:adm /var/log/mysql/mysql.log
# chmod 640 /var/log/mysql/mysql.log
After this, I rebooted the machine and when it came back up, I ran mythfilldatabase again. I checked the size of the mysql.log and it was nearly 200MB already! Obviously, there's something wrong. Nothing blatantly sticks out to me in the mysql.log and the mysql.err log is empty. The only thing that I can see are some lines in the log that are duplicated. Some end with:
Quote: hostname = 'mythbox' and that makes sense because that's what my box is called, but some entries end with
Quote: hostname IS NULL here are a couple examples:
Code: 5 Query SELECT data FROM settings WHERE value = 'AutoCommflagWhileRecording' AND hostname = 'mythbox'
5 Query SELECT data FROM settings WHERE value = 'AutoCommflagWhileRecording' AND hostname IS NULL
4 Query SELECT data FROM settings WHERE value = 'AutoExpireLiveTVMaxAge' AND hostname = 'mythbox'
4 Query SELECT data FROM settings WHERE value = 'AutoExpireLiveTVMaxAge' AND hostname IS NULL
4 Query SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname = 'mythbox'
4 Query SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname IS NULL
4 Query SELECT data FROM settings WHERE value = 'RecordPreRoll' AND hostname = 'mythbox'
4 Query SELECT data FROM settings WHERE value = 'RecordPreRoll' AND hostname IS NULL
10 Query SELECT data FROM settings WHERE value = 'MythFillGrabberSuggestsTime' AND hostname = 'mythbox'
10 Query SELECT data FROM settings WHERE value = 'MythFillGrabberSuggestsTime' AND hostname IS NU$
10 Query SELECT data FROM settings WHERE value = 'MythFillPeriod' AND hostname = 'mythbox'
10 Query SELECT data FROM settings WHERE value = 'MythFillPeriod' AND hostname IS NULL
12 Query UPDATE settings SET data = '7' WHERE value = 'MythFillMinHour'
12 Query UPDATE settings SET data = '9' WHERE value = 'MythFillMaxHour'
12 Query UPDATE settings SET data = '2006-08-11T07:44:04' WHERE value = 'MythFillSuggestedRunTime'
10 Query SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname = 'mythbox'
10 Query SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname IS NULL
10 Query SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname = 'mythbox'
10 Query SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname IS NULL
Also, I have oodles and oodles of entries like this:
Code: 12 Query INSERT INTO dd_productioncrew (programid, role, givenname, surname, fullname) VALUES('EPP3803410062','Guest_Star','Romy','Rosemont','Romy Rosemont')
along with lots of others that say similar things, but say INSERT INTO dd_schedule, INSERT INTO dd_genre, and so on. There are literally pages and pages of this stuff. I don't know how normal that is.
When I use WebMin to look at mythconverg --> settings table --> search field values for "mythfill" and here is what comes back:
Code: value data hostname
mythfilldatabaseLastRunStart 2006-08-10 09:58
mythfilldatabaseLastRunEnd 2006-08-10 09:58
mythfilldatabaseLastRunStatus mythfilldatabase ran, but did not insert any new data into the Guide. This can indicate a potential grabber failure.
MythFillSuggestedRunTime 2006-08-11T07:44:04
MythFillGrabberSuggestsTime 1
MythFillEnabled 1
MythFillDatabasePath /usr/bin/mythfilldatabase
MythFillDatabaseArgs --quiet mythbox
MythFillDatabaseLog /var/log/mythfilldatabse.log
MythFillPeriod 1
MythFillMinHour 7
MythFillMaxHour 9
The only line with a hostname is the MythFillDatabaseArgs. Everything else is NULL. Could this be the problem? I changed all NULL instances to "mythbox" (without the quotes, of course) and re-ran mythfilldatabase, but I still got the same error about not being able to insert any data. The mysql.log doubled it's size. I tried to clear my capture card and channel info from mythtv-setup as well. That did not do it. I did recently (~ a week ago) get the channels icons setup. I followed the instructions at http://www.mythtvtalk.com/forum/archive/o_t/t_3140/mkiconmap.pl_returns_invalid_postal_code_solved.html, but it only started giving me a problem on Sunday/Monday. It worked just fine for several days. Can anyone think of anything else I can try?
|
