Connect failed to store:1111
InesBlin opened this issue · 2 comments
InesBlin commented
Hi,
I am encountering issues loading DBpedia into the docker container. (latest core in English)
I am using a Mac M1 with 16GB of system RAM, and macOS Monterey (12.0.1)
After checking my memory and to be sure not to have memory issues, I set the following parameters in config.env:
VIRT_PARAMETERS_NUMBEROFBUFFERS=340000
VIRT_PARAMETERS_MAXDIRTYBUFFERS=250000
(Following recommendation from memory settings page)
The error happens when the script is doing the load process, here are the errors that I get:
virtuoso-sparql-endpoint-quickstart-load-1 | [INFO] Starting load process...
virtuoso-sparql-endpoint-quickstart-store-1 | 11:33:14 PL LOG: Loader started
virtuoso-sparql-endpoint-quickstart-load-1 | [ERROR] running the these commands in virtuoso:
virtuoso-sparql-endpoint-quickstart-load-1 | log_enable(2);
virtuoso-sparql-endpoint-quickstart-load-1 | checkpoint_interval(-1);
virtuoso-sparql-endpoint-quickstart-load-1 | set isolation = 'uncommitted';
virtuoso-sparql-endpoint-quickstart-load-1 | rdf_loader_run();
virtuoso-sparql-endpoint-quickstart-load-1 | log_enable(1);
virtuoso-sparql-endpoint-quickstart-load-1 | checkpoint_interval(60);
virtuoso-sparql-endpoint-quickstart-load-1 | error code: 2
virtuoso-sparql-endpoint-quickstart-load-1 | output:
virtuoso-sparql-endpoint-quickstart-load-1 | Connected to OpenLink Virtuoso
virtuoso-sparql-endpoint-quickstart-load-1 | Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
virtuoso-sparql-endpoint-quickstart-load-1 | OpenLink Interactive SQL (Virtuoso), version 0.9849b.
virtuoso-sparql-endpoint-quickstart-load-1 | Type HELP; for help and EXIT; to exit.
virtuoso-sparql-endpoint-quickstart-load-1 | SQL>
virtuoso-sparql-endpoint-quickstart-load-1 | Done. -- 1 msec.
virtuoso-sparql-endpoint-quickstart-load-1 | SQL>
virtuoso-sparql-endpoint-quickstart-load-1 | Done. -- 1 msec.
virtuoso-sparql-endpoint-quickstart-load-1 | SQL>
virtuoso-sparql-endpoint-quickstart-load-1 | Done. -- 1 msec.
virtuoso-sparql-endpoint-quickstart-load-1 | SQL>
virtuoso-sparql-endpoint-quickstart-load-1 | *** Error 08S01: [Virtuoso Driver]CL065: Lost connection to server
virtuoso-sparql-endpoint-quickstart-load-1 | at line 4 of Top-Level:
virtuoso-sparql-endpoint-quickstart-load-1 | rdf_loader_run()
virtuoso-sparql-endpoint-quickstart-load-1 | [INFO] making checkpoint...
virtuoso-sparql-endpoint-quickstart-load-1 | [ERROR] running the these commands in virtuoso:
virtuoso-sparql-endpoint-quickstart-load-1 | checkpoint;
virtuoso-sparql-endpoint-quickstart-load-1 | error code: 3
virtuoso-sparql-endpoint-quickstart-load-1 | output:
virtuoso-sparql-endpoint-quickstart-load-1 |
virtuoso-sparql-endpoint-quickstart-load-1 | *** Error S2801: [Virtuoso Driver]CL033: Connect failed to store:1111 = store:1111.
virtuoso-sparql-endpoint-quickstart-load-1 | at line 0 of Top-Level:
virtuoso-sparql-endpoint-quickstart-load-1 | [INFO] re-activating auto-indexing
virtuoso-sparql-endpoint-quickstart-store-1 exited with code 137
virtuoso-sparql-endpoint-quickstart-load-1 | [ERROR] running the these commands in virtuoso:
virtuoso-sparql-endpoint-quickstart-load-1 | DB.DBA.RDF_OBJ_FT_RULE_ADD (null, null, 'All');
virtuoso-sparql-endpoint-quickstart-load-1 | error code: 3
virtuoso-sparql-endpoint-quickstart-load-1 | output:
virtuoso-sparql-endpoint-quickstart-load-1 |
virtuoso-sparql-endpoint-quickstart-load-1 | *** Error S2801: [Virtuoso Driver]CL033: Connect failed to store:1111 = store:1111.
virtuoso-sparql-endpoint-quickstart-load-1 | at line 0 of Top-Level:
virtuoso-sparql-endpoint-quickstart-load-1 | [ERROR] running the these commands in virtuoso:
virtuoso-sparql-endpoint-quickstart-load-1 | DB.DBA.VT_INC_INDEX_DB_DBA_RDF_OBJ ();
virtuoso-sparql-endpoint-quickstart-load-1 | error code: 3
virtuoso-sparql-endpoint-quickstart-load-1 | output:
virtuoso-sparql-endpoint-quickstart-load-1 | The function gethostbyname returned error 4 for host "store".
virtuoso-sparql-endpoint-quickstart-load-1 |
virtuoso-sparql-endpoint-quickstart-load-1 | *** Error S2801: [Virtuoso Driver]CL033: Connect failed to store:1111 = store:1111.
virtuoso-sparql-endpoint-quickstart-load-1 | at line 0 of Top-Level:
virtuoso-sparql-endpoint-quickstart-load-1 | [INFO] making checkpoint...
virtuoso-sparql-endpoint-quickstart-load-1 | [ERROR] running the these commands in virtuoso:
virtuoso-sparql-endpoint-quickstart-load-1 | checkpoint;
virtuoso-sparql-endpoint-quickstart-load-1 | error code: 3
virtuoso-sparql-endpoint-quickstart-load-1 | output:
virtuoso-sparql-endpoint-quickstart-load-1 | The function gethostbyname returned error 4 for host "store".
virtuoso-sparql-endpoint-quickstart-load-1 |
virtuoso-sparql-endpoint-quickstart-load-1 | *** Error S2801: [Virtuoso Driver]CL033: Connect failed to store:1111 = store:1111.
virtuoso-sparql-endpoint-quickstart-load-1 | at line 0 of Top-Level:
virtuoso-sparql-endpoint-quickstart-load-1 | [INFO] update/filling of geo index
virtuoso-sparql-endpoint-quickstart-load-1 | [ERROR] running the these commands in virtuoso:
virtuoso-sparql-endpoint-quickstart-load-1 | rdf_geo_fill();
virtuoso-sparql-endpoint-quickstart-load-1 | error code: 3
virtuoso-sparql-endpoint-quickstart-load-1 | output:
virtuoso-sparql-endpoint-quickstart-load-1 | The function gethostbyname returned error 4 for host "store".
virtuoso-sparql-endpoint-quickstart-load-1 |
virtuoso-sparql-endpoint-quickstart-load-1 | *** Error S2801: [Virtuoso Driver]CL033: Connect failed to store:1111 = store:1111.
virtuoso-sparql-endpoint-quickstart-load-1 | at line 0 of Top-Level:
virtuoso-sparql-endpoint-quickstart-load-1 | [INFO] making checkpoint...
virtuoso-sparql-endpoint-quickstart-load-1 | [ERROR] running the these commands in virtuoso:
virtuoso-sparql-endpoint-quickstart-load-1 | checkpoint;
virtuoso-sparql-endpoint-quickstart-load-1 | error code: 3
virtuoso-sparql-endpoint-quickstart-load-1 | output:
virtuoso-sparql-endpoint-quickstart-load-1 | The function gethostbyname returned error 4 for host "store".
virtuoso-sparql-endpoint-quickstart-load-1 |
virtuoso-sparql-endpoint-quickstart-load-1 | *** Error S2801: [Virtuoso Driver]CL033: Connect failed to store:1111 = store:1111.
virtuoso-sparql-endpoint-quickstart-load-1 | at line 0 of Top-Level:
virtuoso-sparql-endpoint-quickstart-load-1 | [INFO] bulk load done; terminating loader
virtuoso-sparql-endpoint-quickstart-load-1 exited with code 0
I saw that a similar issue was opened and closed, but could not find a turnaround.
Have you encountered this type of problem?
Thanks a lot for your help,
Inès
magdaaniol commented
Hey, I'm getting the exact same errors on Ubuntu 20.04. Any updates on this issue? Thanks!
InesBlin commented
Hi,
In the end I tried to load DBpedia while reducing the memory used for other applications, but the memory available on my computer was still unsufficient. I am now using the TPF version from Triply: https://triplydb.com