Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

DBI Pase_RDF.pl error

Quote Reply
DBI Pase_RDF.pl error
[www@www setup]$ perl Parse_RDF.pl
DBI::db=HASH(0x8180090)->disconnect invalidates 1 active statement handle (eithe
r destroy statement handles or call finish on them before disconnecting) at Pars
e_RDF.pl line 354, <CONTENT_FILE> chunk 422366.
----------------------------------------------------
Does anyone know what is going on here. And how could it be fixed?



Quote Reply
Re: DBI Pase_RDF.pl error In reply to
You are on a shared host, and your ISP is killing the process for using too much CPU.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: DBI Pase_RDF.pl error In reply to
Its not a shared host. Could you please explain how would I go about making the necessary changes in the settings to make the Parse script run. (Even temporarily).


Quote Reply
Re: DBI Pase_RDF.pl error In reply to
Actually, I didn't look at the message carefully enough. If you are getting the program to run, this is an error you can ignore. It's akin to an abnormal termination. If you are not getting the script to work, it means the program is hitting something it can't get past, and the automatic handlers are destroying the handles and pointers rather than the clean up routines.

You need to have Links SQL installed, and set up and working before you can run the parse proram. It uses the Links.pm and .def files to determine what to do with the data and what your database looks like.

Make sure you have the new parse program from the /licensed area, and that you have it in the setup directory. You need to set a few variables in the program -- the name of the input file and hierarchy you want to import.

You need to set all the variables in Links.pm, and you need to go through the proceedure to create the database & tables in the /admin/setup/setup.cgi script.

If all that works, then you should be able to run the parse program.

The problem most people have is it:

1) imports no entries for some reason
2) imports entries psuedo randomly

This is an odd error you are getting, and without knowing more about how you have your system set up and configured (all the parts above) it's tricky to figure out.

It first looked like the #1 problem people have, which is their process is killed by a daemon, but looking at it carefully, that's not what is happening. Some abnormal condition is being hit, and the program is terminating abnormally (or even abnormally abnormal).



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: DBI Pase_RDF.pl error In reply to
thanks pugdog.. it was the Parse script. I was still using the old one. The new one works fine.