Randomly losing connection to the db [WebSocket connection failure]

[and_manousakis]

Hi to everyone!

I ran the following query:

CALL apoc.periodic.iterate(
"MATCH (src:Address)-[:REDEEMED]->(ip:IncomingPayment)-[:INCOMING_PAYMENT]->(tx:Transaction)-[:SENT_COINS]->(op:OutgoingPayment)-[:WAS_SENT_TO]->(dst:Address) RETURN src.AddressID as src, dst.AddressID as dst",
"CREATE (src)-[r:sent_money]->(dst)",
{batchSize:10000})

and I got the following error while I lost the connection to the db:

WebSocket connection failure. Due to security constraints in your web browser, the reason for the failure is not available to this Neo4j Driver. Please use your browsers development console to determine the root cause of the failure. Common reasons include the database being unavailable, using the wrong connection URL or temporary network problems. If you have enabled encryption, ensure your browser is configured to trust the certificate Neo4j is configured to use. WebSocket readyState is: 3

Any idea why this happened?

• Neo4j desktop 3.5.16
• Linux 19.10

Thanks!
Andreas

[rushikesh]

Hey @and.manousakis, may be this will help you :

Explanation of error "WebSocket connection failure. Due to security constraints in your web browser,... Browser

In Neo4j 3.0 and its implementation of the Bolt protocol, if a remote browser connects to Neo4j (http://<remote_neo4j_host>:7474) and attempts to authenticate, the following error may be encountered: [red]#WebSocket connection failure. Due to security constraints in your web browser, the reason for the failure is not available to this Neo4j Driver. Please use your browsers development console to determine the root cause of the failure. Common reasons include the database being unavailable, u…

[and_manousakis]

Hi @rushikesh! I have seen this post, but this line doesn't exist in neo4j.conf. Here are some details about the db:

nodes: ~70.000.000 (5 labels)
relationships: ~90.000.000 (5 types)

About the laptop the db runs on:

Intel Core i7-8750H CPU @ 2.20 x 12
GeForce RTX 2080 with MAX - Q Design
512 SSD

Could it be that the query is too resource hungry for this laptop?

[cristiscu]

well, for dbs with dozens of mills records, I've seen Oracle or SQL-Server queries crushing in similar conditions.

you should rather address the support, I think... could be a bug.