Virtuoso-sparql-endpoint-quickstart - Connection Timeout

Support
,
1

I have done setting up Virtuoso docker image and changed the COLLECTION_URI and VIRTUOSO_ADMIN_PASSWORD in config.env.
COLLECTION_URI = https://databus.dbpedia.org/dbpedia/collections/dbpedia-snapshot-2022-09
However, it’s showing the following error:

download_1  | org.apache.http.conn.HttpHostConnectException: Connect to databus.dbpedia.org:80 [databus.dbpedia.org/95.216.13.238] failed: Connection timed out (Connection timed out)
download_1  | 	at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:156)
download_1  | 	at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:374)
download_1  | 	at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:393)
download_1  | 	at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236)
download_1  | 	at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)
download_1  | 	at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)
download_1  | 	at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)
download_1  | 	at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
download_1  | 	at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
download_1  | 	at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108)
download_1  | 	at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)
download_1  | 	at org.dbpedia.download.Client.get(Client.java:248)
download_1  | 	at org.dbpedia.download.Client.main(Client.java:120)
download_1  | Caused by: java.net.ConnectException: Connection timed out (Connection timed out)
download_1  | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
download_1  | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
download_1  | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
download_1  | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
download_1  | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
download_1  | 	at java.net.Socket.connect(Socket.java:607)
download_1  | 	at org.apache.http.conn.socket.PlainConnectionSocketFactory.connectSocket(PlainConnectionSocketFactory.java:75)
download_1  | 	at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:142)
download_1  | 	... 12 more
download_1  | Removing LOCK at /root/data
virtuoso-sparql-endpoint-quickstart_download_1 exited with code 0
load_1      | will use ISQL port 1111 to connect
load_1      | [INFO] Waiting for store to come online (s)
load_1      | [ERROR] running the these commands in virtuoso:
load_1      | status();
load_1      | error code: 3
load_1      | output:
load_1      | 
load_1      | *** Error S2801: [Virtuoso Driver]CL033: Connect failed to store:1111 = store:1111.
load_1      | at line 0 of Top-Level:
load_1      | .60

I guess there is a problem with Connection Timeout. But, I’m not able to rectify it. Anyone help me.
@jfrey @fab_hop

2

you seem to have a network issue. maybe you have configured an invalid or strange proxy (system wide or for docker) have firewall issues or sth like this.
you can try to run curl databus.dbpedia.org and curl google.com both from within and outside of the docker container to narrow it down. but I can not help with that, I checked and the setup works perfectly fine on our machines.

1 Like
3

I have resolved the issue. Thanks.

4

supberb. and how?

1 Like
5

Thanks to you. I just checked the network and restarted the system. Then, I freshly started the container, it worked. :slightly_smiling_face: It’s on the same connection now also but, worked this time. I exactly don’t know why.

6

btw sir, what is the meaning of this?

store_1 | 06:34:46 *** read-ahead of a free or out of range page dp L=1495877, database not necessarily corrupted.

Also, it says loading has finished but still the loader image keeps running. Most of the queries also resulting in a timeout.

7

as per troubleshooting in the docu
increase the memory settings (BUFFERS options) for the virtuoso database in config.env see here for more details