Connect failed to store:1111

[InesBlin]

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]

Hey, I'm getting the exact same errors on Ubuntu 20.04. Any updates on this issue? Thanks!

[InesBlin]

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