Connection reset

[Joshua Cano]

I am continually getting a connection reset after 5 minutes when running a long running CYPHER query using the /db/data endpoint. Does anyone have any experience with this? All queries that return within 5 minutes run fine, however once this 5 minute threshold is reached it seems that the connection is being reset. Do you have any plans on moving to the neo4j Transactional cypher endpoint? Thanks in advance.

[Michael Klishin]

On 20 March 2015 at 22:29:34, Joshua Cano (joshua...@gmail.com) wrote:
> I am continually getting a connection reset after 5 minutes
> when running a long running CYPHER query using the /db/data endpoint.
> Does anyone have any experience with this?

Either client or server (or a proxy in the middle) have a request timeout. 
--
@michaelklishin, github.com/michaelklishin

[Rohit Aggarwal]

Regarding the timeout, as Michael said, the timeout is happening either in the client, proxy or the server.

The only doc for handling timeout in the server, I could find about is in Mark Needham's blog:

http://www.markhneedham.com/blog/2013/10/17/neo4j-setting-query-timeout/

For the client, you can explicitly set the connect timeout. I have a basic example here:

https://gist.github.com/ducky427/451b226a344a73639685

Have a look at debugging http calls section in the docs here and also the clj-http docs.

Neocons isn't yet Neo4j 2.2 compatible. But it will be soon. the neo4j transactional cypher endpoint will be added as part of that effort. PR welcome!

[Rohit Aggarwal]

Looking at the API closer, I realised that the Neo4j transaction cypher endpoint already exists. Doc here:

http://reference.clojureneo4j.info/clojurewerkz.neocons.rest.transaction.html#var-in-transaction

[Joshua Cano]

Thanks so much Rohit, I did try and set the timeout like you are doing on the 20th, however same problem persisted, I'm going to try the transaction endpoint and see if I get the same result. Could be some strange setting on the server side, but it only seems to be for remote queries, any long running cypher queries I perform locally run fine.