Hi Jens,

Can you provide copy or the URL to download the geonames dataset you are trying to load ? A copy of your virtuoso.log file would be usedful to have in case their are any additional messages reported that may be related. As stated initially this is an old procedure Fred used sometime ago for importing geonames data, thus perhaps the structure has changed since.

Also, if you are still at ISWC and can locate Ivan and Co. again perhaps they can assist ...

Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support

On 29 Oct 2008, at 06:43, Jens Lehmann wrote:


Hello,

Hugh Williams wrote:
Hi Jens,

[...]

DB.DBA.import_geonames_dataset('/dbs/rdfdata/rdfdumps/geonames/all- geonames-rdf.txt',
'http://geonames.org');

When using the procedure, Virtuoso aborts after importing a few thousand
resources (of 6+ million overall). The following are the last lines of
the output including the error messages:

===
http://sws.geonames.org/6669150/
http://sws.geonames.org/6670165/
Checkpoint in progress...
Checkpoint in finished
http://sws.geonames.org/6671175/
http://sws.geonames.org/6672189/
http://sws.geonames.org/6674137/
http://sws.geonames.org/6675192/
http://sws.geonames.org/6676376/
http://sws.geonames.org/6677396/
http://sws.geonames.org/6678715/
http://sws.geonames.org/6680233/
http://sws.geonames.org/6681367/
http://sws.geonames.org/6682376/
http://sws.geonames.org/6683381/
http://sws.geonames.org/6684405/
http://sws.geonames.org/6685440/
http://sws.geonames.org/6686448/
http://sws.geonames.org/6687464/
http://sws.geonames.org/6688484/
http://sws.geonames.org/6689499/
http://sws.geonames.org/6690544/

*** Error 08003: [Virtuoso Driver][Virtuoso Server]HT033: cannot read
from session
at line 1 of Command-Line-Load geonames.isql:
DB.DBA.import_geonames_dataset('/opt/lvddn/all-geonames-rdf.txt',
'http://geonames.org')
===

Do you have an idea why this error message appears?

geonames.isql contains the command (using the send procedure):
DB.DBA.import_geonames_dataset('/opt/lvddn/all-geonames-rdf.txt',
'http://geonames.org');

Our Virtuoso version should now be 5.0.9rc6 according to Ivan.

Kind regards,

Jens


--
Dipl. Inf. Jens Lehmann
Department of Computer Science, University of Leipzig
Homepage: http://www.jens-lehmann.org
GPG Key: http://jens-lehmann.org/jens_lehmann.asc

Reply via email to