neode icon indicating copy to clipboard operation
neode copied to clipboard

Session Expired on Query

Open alex-laycalvert opened this issue 2 years ago • 2 comments

I'm running some queries using the cypher queries and just passing text and parameters and on some instances, the queries error out with a code of Session Expired and a message saying Neo4j Error: No longer possible to write to server at <server>. The actual text length varies and it seems like they are erroring out before even attempting to run.

About my setup, I have a separate singleton class I'm using as a wrapper around Neode which when instantiated for the first time just sets the neode instance to new Neode(...). I don't know if this is screwing up some of the session creation or any pooling that happens.

Is this common on larger queries or is there a connection setting that is going wrong somewhere?

Thanks.

alex-laycalvert avatar Sep 18 '23 20:09 alex-laycalvert

Looks like every time cypher readCypher or writeCypher is called, a new session is made so I don't think there's some global session that's expiring, but maybe I am messing it up with how I have my project configured.

alex-laycalvert avatar Sep 18 '23 20:09 alex-laycalvert

Looks like this is related to this article. I seem to only be having this issue in production.

alex-laycalvert avatar Sep 19 '23 13:09 alex-laycalvert