[mythtv-users] Still stuck...MythTV Dead

Tom Dale tdmyth at yahoo.com
Tue Jun 6 13:50:37 UTC 2006


Michael T. Dean wrote:
> On 06/03/2006 05:21 AM, Tom Dale wrote:
> > Unfortunately, our problems have mutated and we still have a dead
> > system.  After fixing the database, we could not get mythfilldatabase to
> > work.  It seems to log in, find data, download it to temporary location
> > and then it decides that there is no new program data so it doesn't add
> > to the database.
> ...
> > $ mythfilldatabase --refresh-today --max-days 1 -v all
> > --do_channel_updates 1> /video/TDbackup/mythfill.log 2>& 1
> >   
>
> How about the mythfilldatabase log without all the extra junk (i.e. no 
> "-v all").  You trimmed some of the important information out of the 
> log...
>
> Mike
Also, here is a version of the log with the "verbose database" option. 
I really hope someone can help us figure out why mythfilldatabase won't
work anymore.  This problem occurs after a fresh re-install of the OS
and MythTV.  Thanks!

2006-06-05 21:21:54.543 Using runtime prefix = /usr
2006-06-05 21:21:54.571 New DB connection, total: 1
2006-06-05 21:21:54.579 Connected to database 'mythconverg' at host:
localhost
2006-06-05 21:21:54.581 Enabling Settings Cache.
2006-06-05 21:21:54.581 Clearing Settings Cache.
2006-06-05 21:21:54.583 MSqlQuery: SELECT data FROM settings WHERE
value  = 'LogEnabled' AND hostname = 'mythserver' ;
2006-06-05 21:21:54.584 MSqlQuery: SELECT data FROM settings WHERE value
= 'LogEnabled' AND hostname IS NULL;
2006-06-05 21:21:54.585 MSqlQuery: SELECT data FROM settings WHERE
value  = 'LogMaxCount' AND hostname = 'mythserver' ;
2006-06-05 21:21:54.586 MSqlQuery: SELECT data FROM settings WHERE
value  = 'LogPrintLevel' AND hostname = 'mythserver' ;
2006-06-05 21:21:54.587 MSqlQuery: SELECT
sourceid,name,xmltvgrabber,userid,password,lineupid FROM videosource 
ORDER BY sourceid;
2006-06-05 21:21:54.588 New DB connection, total: 2
2006-06-05 21:21:54.589 Connected to database 'mythconverg' at host:
localhost
2006-06-05 21:21:54.590 MSqlQuery: SELECT MAX(endtime) FROM program
WHERE manualid=0;
2006-06-05 21:21:54.590 Updating source #1 (Charter) with grabber datadirect
2006-06-05 21:21:54.590 Checking day @ offset 0, date: Mon Jun 5 2006
2006-06-05 21:21:54.590 Refreshing data for Mon Jun 5 2006
2006-06-05 21:21:54.591 New DB DataDirect connection
2006-06-05 21:21:54.592 Connected to database 'mythconverg' at host:
localhost
2006-06-05 21:21:54.593 MSqlQuery: UPDATE settings SET data ='2006-06-05
21:21' WHERE value='mythfilldatabaseLastRunStart'
2006-06-05 21:21:54.593 Retrieving datadirect data.
2006-06-05 21:21:54.593 Grabbing data for Mon Jun 5 2006 offset 0
2006-06-05 21:21:54.594 From Mon Jun 5 04:00:00 2006 to Tue Jun 6
04:00:00 2006 (UTC)
--21:21:54-- 
http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
           => `-'
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80...
connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]

    0K .......... .......... .......... .......... ..........   25.77 KB/s
   50K .......... .......... .......... .......... ..........   77.73 KB/s
  100K .......... .......... .......... .......... ..........   59.46 KB/s
  150K .......... .....                                        138.21 MB/s

21:21:59 (48.43 KB/s) - `-' saved [169832]

2006-06-05 21:21:59.036 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_station ( stationid char(12), callsign char(10), stationname
varchar(40), affiliate varchar(25), fccchannelnumber char(15) );
2006-06-05 21:21:59.037 MSqlQuery: TRUNCATE TABLE dd_station;
2006-06-05 21:21:59.038 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_lineup ( lineupid char(100), name char(42), type char(20), postal
char(6), device char(30) );
2006-06-05 21:21:59.039 MSqlQuery: TRUNCATE TABLE dd_lineup;
2006-06-05 21:21:59.040 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_lineupmap ( lineupid char(100), stationid char(12), channel char(5),
channelMinor char(3) );
2006-06-05 21:21:59.041 MSqlQuery: TRUNCATE TABLE dd_lineupmap;
2006-06-05 21:21:59.042 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_v_station ( stationid char(12), callsign char(10), stationname
varchar(40), affiliate varchar(25), fccchannelnumber char(15), channel
char(5), channelMinor char(3) );
2006-06-05 21:21:59.042 MSqlQuery: TRUNCATE TABLE dd_v_station;
2006-06-05 21:21:59.044 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_schedule ( programid char(12), stationid char(12), scheduletime
datetime, duration time, isrepeat bool, stereo bool, subtitled bool,
hdtv bool, closecaptioned bool, tvrating char(5), partnumber int,
parttotal int, endtime datetime, INDEX progidx (programid) );
2006-06-05 21:21:59.045 MSqlQuery: TRUNCATE TABLE dd_schedule;
2006-06-05 21:21:59.046 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_program ( programid char(12) NOT NULL, seriesid char(12), title
varchar(120), subtitle varchar(150), description text, mpaarating
char(5), starrating char(5), runtime time, year char(4), showtype
char(30), category_type char(64), colorcode char(20), originalairdate
date, syndicatedepisodenumber char(20), stars float unsigned, PRIMARY
KEY (programid));
2006-06-05 21:21:59.047 MSqlQuery: TRUNCATE TABLE dd_program;
2006-06-05 21:21:59.048 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_v_program ( chanid int unsigned NOT NULL, starttime datetime NOT
NULL, endtime datetime, title varchar(128), subtitle varchar(128),
description text, category varchar(64), category_type varchar(64),
airdate year, stars float unsigned, previouslyshown tinyint, isrepeat
bool, stereo bool, subtitled bool, hdtv bool,  closecaptioned bool,
partnumber int, parttotal int, seriesid char(12), originalairdate date,
showtype varchar(30), colorcode varchar(20), syndicatedepisodenumber
varchar(20), programid char(12), tvrating char(5), mpaarating char(5),
INDEX progidx (programid));
2006-06-05 21:21:59.049 MSqlQuery: TRUNCATE TABLE dd_v_program;
2006-06-05 21:21:59.050 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_productioncrew ( programid char(12), role char(30), givenname
char(20), surname char(20), fullname char(41), INDEX progidx
(programid), INDEX nameidx (fullname));
2006-06-05 21:21:59.051 MSqlQuery: TRUNCATE TABLE dd_productioncrew;
2006-06-05 21:21:59.052 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS
dd_genre ( programid char(12) NOT NULL, class char(30), relevance
char(1), INDEX progidx (programid));
2006-06-05 21:21:59.053 MSqlQuery: TRUNCATE TABLE dd_genre;
2006-06-05 21:21:59.054 DataDirect: Your subscription expires on
08/24/2006 09:41:57 AM
2006-06-05 21:21:59.055 MSqlQuery: UPDATE settings SET data ='Your
subscription expires on 08/24/2006 09:41:57 AM' WHERE
value='DataDirectMessage'
2006-06-05 21:22:11.751 Grab complete.  Actual data from Mon Jun 5
04:00:00 2006 to Tue Jun 6 04:00:00 2006 (UTC)
2006-06-05 21:22:11.752 MSqlQuery: UPDATE settings SET data ='2006-06-05
21:22' WHERE value='mythfilldatabaseLastRunEnd'
2006-06-05 21:22:11.752 Main temp tables populated.
2006-06-05 21:22:11.752 Updating myth channels.
2006-06-05 21:22:11.753 MSqlQuery: TRUNCATE TABLE dd_v_station;
2006-06-05 21:22:11.754 MSqlQuery: INSERT INTO dd_v_station (stationid,
callsign,     stationname, affiliate, fccchannelnumber, channel,    
channelMinor) SELECT dd_station.stationid, callsign, stationname,    
affiliate, fccchannelnumber, channel, channelMinor FROM dd_station,
dd_lineupmap WHERE     ( (dd_station.stationid = dd_lineupmap.stationid)
AND     ( dd_lineupmap.lineupid = NULL) );
2006-06-05 21:22:11.755 MSqlQuery: SELECT dd_v_station.stationid,       
dd_v_station.callsign,       dd_v_station.stationname,     
dd_v_station.channel,       dd_v_station.fccchannelnumber,
dd_v_station.channelMinor FROM dd_v_station LEFT JOIN channel ON     
dd_v_station.stationid = channel.xmltvid AND      channel.sourceid = 1
WHERE channel.chanid IS NULL;
2006-06-05 21:22:11.755 MSqlQuery: SELECT callsign, stationname,     
stationid,       channel,  fccchannelnumber, channelMinor FROM dd_v_station
2006-06-05 21:22:11.756 Updating icons for sourceid: 1
2006-06-05 21:22:11.757 New DB connection, total: 3
2006-06-05 21:22:11.758 Connected to database 'mythconverg' at host:
localhost
2006-06-05 21:22:11.759 MSqlQuery: SELECT ch.chanid, nim.url FROM
channel ch, callsignnetworkmap csm RIGHT JOIN networkiconmap nim ON
csm.network = nim.network WHERE ch.callsign = csm.callsign AND (icon =
'none' OR icon = '') AND ch.sourceid = 1
2006-06-05 21:22:11.759 Channels updated.
2006-06-05 21:22:11.760 MSqlQuery: TRUNCATE TABLE dd_v_program;
2006-06-05 21:22:11.849 MSqlQuery: INSERT INTO dd_v_program (chanid,
starttime, endtime, title, subtitle, description, airdate, stars,
previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumber,
parttotal, seriesid, originalairdate, showtype, category_type,
colorcode, syndicatedepisodenumber, tvrating, mpaarating, programid)
SELECT chanid, scheduletime, endtime, title, subtitle, description,
year, stars, isrepeat, stereo, subtitled, hdtv, closecaptioned,
partnumber, parttotal, seriesid, originalairdate, showtype,
category_type, colorcode, syndicatedepisodenumber, tvrating, mpaarating,
dd_program.programid FROM channel, dd_schedule, dd_program WHERE  (
(dd_schedule.programid = dd_program.programid) AND    (channel.xmltvid =
dd_schedule.stationid) AND    (channel.sourceid = 1 ));
2006-06-05 21:22:11.849 MSqlQuery: ANALYZE TABLE dd_v_program;
2006-06-05 21:22:11.857 MSqlQuery: ANALYZE TABLE dd_productioncrew;
2006-06-05 21:22:11.858 MSqlQuery: SELECT count(*) from dd_v_program;
2006-06-05 21:22:11.858 Did not find any new program data.
2006-06-05 21:22:11.858 MSqlQuery: SELECT MAX(endtime) FROM program
WHERE manualid=0;
2006-06-05 21:22:11.859 MSqlQuery: DELETE FROM oldprogram WHERE airdate
< DATE_SUB(CURRENT_DATE, INTERVAL 320 DAY);
2006-06-05 21:22:11.860 MSqlQuery: REPLACE INTO oldprogram
(oldtitle,airdate) SELECT title,starttime FROM program WHERE starttime <
NOW() AND manualid = 0 GROUP BY title;
2006-06-05 21:22:11.860 MSqlQuery: DELETE FROM program WHERE starttime
<= DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);
2006-06-05 21:22:11.861 MSqlQuery: DELETE FROM programrating WHERE
starttime <= DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);
2006-06-05 21:22:11.861 MSqlQuery: DELETE FROM programgenres WHERE
starttime <= DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);
2006-06-05 21:22:11.862 MSqlQuery: DELETE FROM credits WHERE starttime
<= DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);
2006-06-05 21:22:11.862 MSqlQuery: DELETE FROM record WHERE (type = 1 OR
type = 7 OR type = 8) AND enddate < NOW();
2006-06-05 21:22:11.863 New DB connection, total: 4
2006-06-05 21:22:11.864 Connected to database 'mythconverg' at host:
localhost
2006-06-05 21:22:11.865 MSqlQuery: SELECT record.recordid FROM record
LEFT JOIN oldfind ON oldfind.recordid = record.recordid WHERE type = 6
AND oldfind.findid IS NOT NULL;
2006-06-05 21:22:11.865 MSqlQuery: DELETE FROM oldfind WHERE findid <
TO_DAYS(NOW()) - 14;
2006-06-05 21:22:11.866 New DB connection, total: 5
2006-06-05 21:22:11.867 Connected to database 'mythconverg' at host:
localhost
2006-06-05 21:22:11.868 MSqlQuery: SELECT data FROM settings WHERE
value  = 'CleanOldRecorded' AND hostname = 'mythserver' ;
2006-06-05 21:22:11.869 MSqlQuery: SELECT data FROM settings WHERE value
= 'CleanOldRecorded' AND hostname IS NULL;
2006-06-05 21:22:11.869 MSqlQuery: DELETE FROM oldrecorded WHERE
recstatus <> -3 AND duplicate = 0 AND endtime < DATE_SUB(CURRENT_DATE,
INTERVAL 10 DAY);
2006-06-05 21:22:11.869 Failed to fetch some program info



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the mythtv-users mailing list