LinHES Forums
http://forum.linhes.org/

[solved] R5B7 mythfilldatabase error UK tv_grab_uk_rt
http://forum.linhes.org/viewtopic.php?f=11&t=9376		 Page 1 of 2
Author:  gravety [ Thu Mar 30, 2006 5:47 am ]
Post subject:  [solved] R5B7 mythfilldatabase error UK tv_grab_uk_rt
Hi,

Just done a manual install of R5B7 (from an old R5A22 inst) and I now get the following when trying to run mythfilldatabase:

2006-03-30 11:42:07.476 Using runtime prefix = /usr
2006-03-30 11:42:07.500 New DB connection, total: 1
2006-03-30 11:42:07.505 Connected to database 'mythconverg' at host: localhost
2006-03-30 11:42:07.515 New DB connection, total: 2
2006-03-30 11:42:07.518 Connected to database 'mythconverg' at host: localhost
2006-03-30 11:42:07.520 Updating source #1 (ant) with grabber tv_grab_uk_rt
2006-03-30 11:42:07.523 ----------------- Start of XMLTV output -----------------
2006-03-30 11:42:07.526 New DB connection, total: 3
2006-03-30 11:42:07.528 Connected to database 'mythconverg' at host: localhost
Undefined argument in option spec
Undefined argument in option spec
2006-03-30 11:42:08.071 ------------------ End of XMLTV output ------------------
Error in 1:1: unexpected end of file
2006-03-30 11:42:08.074 Updating icons for sourceid: 1
2006-03-30 11:42:08.075 New DB connection, total: 4
2006-03-30 11:42:08.076 Connected to database 'mythconverg' at host: localhost
Updated programs: 0 Unchanged programs: 0
2006-03-30 11:42:08.699 New DB connection, total: 5
2006-03-30 11:42:08.700 Connected to database 'mythconverg' at host: localhost
2006-03-30 11:42:08.704 Failed to fetch some program info

I have tried searching with no luck! I performed a backup (basically followed 'Some Hints for upgrading to R5B7') manual install (due to SATA, well Pundit-r sata anyway) retrieved some files from /etc, and the xmltv file, and did a restore.

I did do a apt-get install firefox though....

Now everything seems to work except for the above!

Advice please
Author:  tjc [ Thu Mar 30, 2006 7:53 am ]
Post subject:  Re: R5B7 mythfilldatabase error
gravety wrote:
I did do a apt-get install firefox though....

Well I have been posting blood curdling warnings about that for a reason... ;-)

Have you tried logging in as the mythtv user and running mythfilldatabase by hand with the --verbose option to see if you can get a more detailed error message?

Other than pursuing that type of troubleshooting my advice is going to be to re upgrade to R5B7 and then avoid playing with apt-get install since it's a really risky proposition at the moment. There's already a browser built into MythTV after all.
Author:  gravety [ Thu Mar 30, 2006 8:22 am ]
Post subject:  Re: R5B7 mythfilldatabase error
tjc wrote:
Well I have been posting blood curdling warnings about that for a reason... ;-)


Yeah I know!

Quote:
Have you tried logging in as the mythtv user and running mythfilldatabase by hand with the --verbose option to see if you can get a more detailed error message?


Yup:
----------------------
sh-3.00$ mythfilldatabase -v all
2006-03-30 15:12:08.098 Using runtime prefix = /usr
2006-03-30 15:12:08.124 New DB connection, total: 1
2006-03-30 15:12:08.131 Connected to database 'mythconverg' at host: localhost
2006-03-30 15:12:08.138 Enabling Settings Cache.
2006-03-30 15:12:08.142 Clearing Settings Cache.
2006-03-30 15:12:08.148 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname = 'mythtv' ;
2006-03-30 15:12:08.154 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname IS NULL;
2006-03-30 15:12:08.160 MSqlQuery: SELECT data FROM settings WHERE value = 'LogMaxCount' AND hostname = 'mythtv' ;
2006-03-30 15:12:08.166 MSqlQuery: SELECT data FROM settings WHERE value = 'LogPrintLevel' AND hostname = 'mythtv' ;
2006-03-30 15:12:08.171 MSqlQuery: SELECT sourceid,name,xmltvgrabber,userid,password,lineupid FROM videosource ORDER BY sourceid;
2006-03-30 15:12:08.177 New DB connection, total: 2
2006-03-30 15:12:08.182 Connected to database 'mythconverg' at host: localhost
2006-03-30 15:12:08.187 MSqlQuery: SELECT MAX(endtime) FROM program WHERE manualid=0;
2006-03-30 15:12:08.192 Updating source #1 (ant) with grabber tv_grab_uk_rt
2006-03-30 15:12:08.197 ----------------- Start of XMLTV output -----------------
2006-03-30 15:12:08.202 New DB connection, total: 3
2006-03-30 15:12:08.207 Connected to database 'mythconverg' at host: localhost
2006-03-30 15:12:08.213 MSqlQuery: UPDATE settings SET data ='2006-03-30 15:12' WHERE value='mythfilldatabaseLastRunStart'
2006-03-30 15:12:08.218 MSqlQuery: UPDATE settings SET data ='currently running.' WHERE value='mythfilldatabaseLastRunStatus'
Undefined argument in option spec
Undefined argument in option spec
2006-03-30 15:12:08.765 MSqlQuery: UPDATE settings SET data ='2006-03-30 15:12' WHERE value='mythfilldatabaseLastRunEnd'
2006-03-30 15:12:08.766 MSqlQuery: UPDATE settings SET data ='FAILED: xmltv returned error code 512.' WHERE value='mythfilldatabaseLastRunStatus'
2006-03-30 15:12:08.766 ------------------ End of XMLTV output ------------------
Error in 1:1: unexpected end of file
2006-03-30 15:12:08.769 Updating icons for sourceid: 1
2006-03-30 15:12:08.769 New DB connection, total: 4
2006-03-30 15:12:08.770 Connected to database 'mythconverg' at host: localhost
2006-03-30 15:12:08.771 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
Updated programs: 0 Unchanged programs: 0
2006-03-30 15:12:08.772 MSqlQuery: SELECT MAX(endtime) FROM program WHERE manualid=0;
2006-03-30 15:12:08.790 MSqlQuery: DELETE FROM oldprogram WHERE airdate < DATE_SUB(CURRENT_DATE, INTERVAL 320 DAY);
2006-03-30 15:12:09.155 MSqlQuery: REPLACE INTO oldprogram (oldtitle,airdate) SELECT title,starttime FROM program WHERE starttime < NOW() AND manualid = 0 GROUP BY title;
2006-03-30 15:12:09.385 MSqlQuery: DELETE FROM program WHERE starttime <= DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);
2006-03-30 15:12:09.386 MSqlQuery: DELETE FROM programrating WHERE starttime <= DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);
2006-03-30 15:12:09.386 MSqlQuery: DELETE FROM programgenres WHERE starttime <= DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);
2006-03-30 15:12:09.403 MSqlQuery: DELETE FROM credits WHERE starttime <= DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);
2006-03-30 15:12:09.404 MSqlQuery: DELETE FROM record WHERE (type = 1 OR type = 7 OR type = 8) AND enddate < NOW();
2006-03-30 15:12:09.404 MSqlQuery: SELECT record.recordid FROM record LEFT JOIN oldfind ON oldfind.recordid = record.recordid WHERE type = 6 AND oldfind.findid IS NOT NULL;
2006-03-30 15:12:09.405 MSqlQuery: DELETE FROM oldfind WHERE findid < TO_DAYS(NOW()) - 14;
2006-03-30 15:12:09.406 New DB connection, total: 5
2006-03-30 15:12:09.407 Connected to database 'mythconverg' at host: localhost
2006-03-30 15:12:09.408 MSqlQuery: SELECT data FROM settings WHERE value = 'CleanOldRecorded' AND hostname = 'mythtv' ;
2006-03-30 15:12:09.409 MSqlQuery: SELECT data FROM settings WHERE value = 'CleanOldRecorded' AND hostname IS NULL;
2006-03-30 15:12:09.411 MSqlQuery: DELETE FROM oldrecorded WHERE recstatus <> -3 AND duplicate = 0 AND endtime < DATE_SUB(CURRENT_DATE, INTERVAL 10 DAY);
2006-03-30 15:12:09.412 Failed to fetch some program info
--------------------------


Quote:
Other than pursuing that type of troubleshooting my advice is going to be to re upgrade to R5B7 and then avoid playing with apt-get install since it's a really risky proposition at the moment. There's already a browser built into MythTV after all.


Thought you would suggest that! No, probs I kinda guessed where this would be going when the search turned up no results!!

I know there's a browser built in I just like my FireFox when i'm messing around on the console! :) Guess compiling would be fine?

If no-one has any bright idea's i'll wipe and start over this evening.

Cheers, Graham
Author:  Xsecrets [ Thu Mar 30, 2006 10:07 am ]
Post subject: 
Quote:
Guess compiling would be fine?


Well if you are just talking about firefox you don't even have to compile. there are linux binaries, though you still have to download them outside of apt to be safe.
Author:  gravety [ Thu Mar 30, 2006 2:56 pm ]
Post subject: 
Hmmm,

Well I have done a complete format/re-install (re-partition to remove cache as well ;) ) and I still have the same problem :(

All I have done is re-install, restore, download firefox tar, run ati driver install, replace XFree86-4/fstab/modules...

myisamchk runs fine.

Any ideas??
Author:  gravety [ Thu Mar 30, 2006 5:04 pm ]
Post subject:  Solved it!
Right, it appears there is an issue with xmltv and perl:

[ 1440322 ] tv_grab_uk_rt option processing broken with new Getopt::Long

The bug is listed here: https://sourceforge.net/tracker/?func=detail&atid=424135&aid=1440322&group_id=39046

Along with a patch to apply. I have applied it tonight and am currently running mythfilldatabase.

Hope this helps someone!!

Regards, Graham
Author:  tjc [ Thu Mar 30, 2006 7:20 pm ]
Post subject: 
Argh... Sorry... :oops: I didn't catch the "tv_grab_uk_rt" bit.

A word to the wise, if you're outside the "NTSC-M/zap2it zone" you may want to ring a bell or something on this kind of question. Especially if you're relatively new ... Setting at least minimal "Location:" info in the profile can be very helpful.
Author:  gushy [ Tue Apr 18, 2006 9:14 am ]
Post subject: 
that patched fixed it for me, thanks. :-)
Author:  Pyrofer [ Wed May 03, 2006 7:49 am ]
Post subject: 
Um, How do I "apply" this .patch file?
Author:  Pyrofer [ Fri May 05, 2006 1:52 pm ]
Post subject: 
Any chance of a hint?

Im sure its not that much of a secret...
Author:  crasarx [ Fri May 05, 2006 8:45 pm ]
Post subject: 
Use the 'patch' command

'man patch' in a shell to figure out how
Author:  mac [ Fri May 05, 2006 10:06 pm ]
Post subject: 
Go to line 108 of the file /usr/bin/tv_grab_uk_rt - it is the section in the patch.
In this case the patch is telling you the fixed /usr/bin/tv_grab_uk_rt has two
lines that are different from broken /usr/bin/tv_grab_uk_rt. The differences
between the files are denoted by lines starting with "-" and "+".

Pico or nano both are easy to use editors that you can use for fixing your file.

if you download the patch and look at it, this what you will see:

======================= Patch
diff -urNad xmltv/grab/uk_rt/tv_grab_uk_rt.in /tmp/dpep.br6bJI/xmltv/grab/uk_rt/tv_grab_uk_rt.in
--- xmltv/grab/uk_rt/tv_grab_uk_rt.in 2006-01-18 11:22:33.000000000 +0000
+++ /tmp/dpep.br6bJI/xmltv/grab/uk_rt/tv_grab_uk_rt.in 2006-02-28 13:16:36.000000000 +0000
@@ -108,8 +108,8 @@
'share=s' => \ my $opt_share, # also undocumented
'quiet' => \ my $opt_quiet,
'list-channels' => \ my $opt_list_channels,
- 'days' => undef, # ignored
- 'offset' => undef, # ignored
+ 'days' => \ my $opt_ignored_1, # ignored
+ 'offset' => \ my $opt_ignored_2, # ignored
)
or usage(0);
if ($opt_help) {
========================
Author:  Pyrofer [ Mon May 08, 2006 7:22 am ]
Post subject: 
Thanks MAC. I manualy edited the file, and it seems to match exactly what the patch said, but now it crashes.

When Myth tries to run the script after setting up a source in "Video Sources" it goes instantly to "50%" then locks up forever.

If I run tv_grab_uk_rt from a shell, it seems to run ok, at least i get a load of messages about channels and it didnt lock up.
Author:  mac [ Tue May 09, 2006 1:25 am ]
Post subject: 
Don't know why its not working for you. I don't use this grabber, so..

while its stuck at 50% open a shell (remotely over ssh, or an xterm locally) and
run "ps auxwww|grep grab"

you should see the command line for that script.

Try running the command from a shell with same command line to see if you get errors or
clues as to why it is hanging. The first number in that line is the PID of the process.
you can also run "strace -p <PID>" to look for clues also. If strace is not installed do
apt-get update
apt-get install strace

If the apt-get install wants do a ton of junk, post back before you tell it go ahead so that
you can get feedback, apt-get install can hose things up good if your not careful.
Author:  Pyrofer [ Tue May 09, 2006 3:10 am ]
Post subject: 
Ok, I got the command,

xxxxxx 4173 4.4 5.5 15888 14088 ttyp1 S+ 11:03 0:01 /usr/bin/perl /usr/bin/tv_grab_uk_rt --config-file /root/.mythtv/TV.xmltv --configure

I tried running it manualy and got this,

xxxxxx@mythtv:~# tv_grab_uk_rt --config-file /root/.mythtv/TV.xmltv --configure
All data is the copyright of the Radio Times website
<http://www.radiotimes.com> and the use of this data is restricted to
personal use only.

HASH(0x8b51e18)
RT id 1971 (FX+) not known in channel ids file
RT id 1972 (More4 +1) not known in channel ids file
RT id 1973 (Sky Movies 10) not known in channel ids file
RT id 1984 (Disney Cinemagic) not known in channel ids file
RT id 1981 (CITV) not known in channel ids file
RT id 1985 (Disney Cinemagic +1) not known in channel ids file
channel xtraview.co.uk (1885) not seen on site at /usr/bin/tv_grab_uk_rt line 203.
channel toon.disney.co.uk (422) not seen on site at /usr/bin/tv_grab_uk_rt line 203.
channel itn.co.uk (184) not seen on site at /usr/bin/tv_grab_uk_rt line 203.
A nonempty configuration file /root/.mythtv/TV.xmltv
already exists. There is currently no support for altering an
existing configuration: you have to reconfigure from scratch.

Do you wish to overwrite the old configuration? [yes,no (default=no)]


Does that mean that the 50% hang is actualy waiting for input?

I fiddled with running it manualy before and got a question about adding channels,
ABC1 do you wish to add this channel (yes,no,all) ?

I can run it from command line and get a huge xml file with all the channels, but ive not managed to find how to import this back into the database yet :(
Page 1 of 2 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/