Could not connect to neo4j aura server

Hi,

The below error occurs frequently and cannot connect to neo4j Aura. But neo4j browser works fine, so its a problem with server down or connector?

py2neo.errors.ServiceUnavailable: Cannot connect to any known routers

conn = Graph("neo4j+s://.databases.neo4j.io:7687",
auth=("neo4j", ""), secure=True)

This is how I connect.

Thanks,
Skanda

I assume you removed the first part of the host name on purpose, right? Or did you try to connect to .databases.neo4j.io:7687 verbatim?

Yes, in the forum textarea I typed it as

<hostname> and <password>

Markdown removed it or somehow it got removed.

I'm not very familiar with py2neo but to me this looks like a network issue between the machine the driver is running on and Aura.

Could you please run this minimal example with the official Python driver and share the logs with us?

from neo4j import GraphDatabase
from neo4j.debug import watch

uri = "..."
driver = GraphDatabase.driver(uri, auth=("neo4j", "password"))

def workload(tx):
    return tx.run("RETURN 1 as n").data()

with watch("neo4j"):  # enable logging
    with driver.session() as session:
        session.write_transaction(workload)

driver.close()

Thanks Rouven, Got it resolved now. May be some issues with availability I guess. I am not seeing such kind of errors now.

I have the same issue and I couldn't figure out how to fix this, it seems like py2neo has a connection time limit at a certain time (maybe 1-2 hours if there's no transaction/activity). Because whenever I reload the flask server, py2neo is still working. Did you resolve the issue with py2neo or instead did you change the driver with the official neo4j driver?

I just tested this code and it works, everything is fine SUCCESS, READY, CONNECTED, etc... but I had to ask what does this means? "Attempting to update routing table from IPv4Address" because when I look at the error py2neo in the server, it says like this:

cx = self._acquire_ro(graph_name)
:   File "/home/rinal/flask-projects/wordgrid/myvenv/lib/python3.8/site-package>
:     ro_profiles, rw_profiles = self._get_profiles(graph_name, readonly=True)
:   File "/home/rinal/flask-projects/wordgrid/myvenv/lib/python3.8/site-package>
:     self.refresh_routing_table(graph_name)
:   File "/home/rinal/flask-projects/wordgrid/myvenv/lib/python3.8/site-package>
:     raise ServiceUnavailable("Cannot connect to any known routers")
: py2neo.errors.ServiceUnavailable: Cannot connect to any known routers