Error while adding relationships: "No RelationshipState for added relationship!"

[amitshipra]

While trying to run the Cypher query which is supposed to add a new relationship (approx 1.7 M), we are getting this error. Any hints would be helpful.

Neo4j : 3.5.5
Driver : Python 1.7.2

Server Error:

2019-05-31 15:48:12.097+0000 ERROR [o.n.b.v.r.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: No RelationshipState for added relationship!, reference 182a1379-d574-44ef-9747-70748eb342db.
2019-05-31 15:48:12.098+0000 ERROR [o.n.b.v.r.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: No RelationshipState for added relationship!, reference 182a1379-d574-44ef-9747-70748eb342db. No RelationshipState for added relationship!
java.lang.IllegalStateException: No RelationshipState for added relationship!
at org.neo4j.kernel.impl.api.state.TxState.accept(TxState.java:133)
at org.neo4j.kernel.impl.api.KernelTransactionImplementation.rollback(KernelTransactionImplementation.java:760)
at org.neo4j.kernel.impl.api.KernelTransactionImplementation.closeTransaction(KernelTransactionImplementation.java:580)
at org.neo4j.internal.kernel.api.Transaction.close(Transaction.java:178)
at org.neo4j.bolt.v1.runtime.TransactionStateMachine$State.closeTransaction(TransactionStateMachine.java:469)
at org.neo4j.bolt.v1.runtime.TransactionStateMachine$State$1.execute(TransactionStateMachine.java:310)
at org.neo4j.bolt.v1.runtime.TransactionStateMachine$State$1.run(TransactionStateMachine.java:269)
at org.neo4j.bolt.v1.runtime.TransactionStateMachine.run(TransactionStateMachine.java:110)
at org.neo4j.bolt.v3.runtime.ReadyState.processRunMessage(ReadyState.java:85)
at org.neo4j.bolt.v3.runtime.ReadyState.processUnsafe(ReadyState.java:56)
at org.neo4j.bolt.v3.runtime.FailSafeBoltStateMachineState.process(FailSafeBoltStateMachineState.java:48)
at org.neo4j.bolt.v1.runtime.BoltStateMachineV1.nextState(BoltStateMachineV1.java:144)
at org.neo4j.bolt.v1.runtime.BoltStateMachineV1.process(BoltStateMachineV1.java:92)
at org.neo4j.bolt.messaging.BoltRequestMessageReader.lambda$doRead$1(BoltRequestMessageReader.java:89)
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:191)
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:139)
at org.neo4j.bolt.runtime.ExecutorBoltScheduler.executeBatch(ExecutorBoltScheduler.java:171)
at org.neo4j.bolt.runtime.ExecutorBoltScheduler.lambda$scheduleBatchOrHandleError$2(ExecutorBoltScheduler.java:154)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Client Stacktrace:

Traceback (most recent call last):
File "C:/Projects/PyMktDeps/mkt_data_deps/official/query_graph.py", line 55, in
main()
File "C:/Projects/PyMktDeps/mkt_data_deps/official/query_graph.py", line 42, in main
result = session.run(q, **kw)
File "C:\Users\anaconda3\lib\site-packages\neo4j_init_.py", line 499, in run
self._connection.fetch()
File "C:\Users\anaconda3\lib\site-packages\neobolt\direct.py", line 416, in fetch
return self._fetch()
File "C:\Users\anaconda3\lib\site-packages\neobolt\direct.py", line 454, in _fetch
response.on_failure(summary_metadata or {})
File "C:\Users\anaconda3\lib\site-packages\neobolt\direct.py", line 744, in on_failure
raise CypherError.hydrate(**metadata)
neobolt.exceptions.DatabaseError: No RelationshipState for added relationship!

[hannah]

Hi,

Did you find a solution? I am having the same issue and cannot fix it...

[and_manousakis]

I have the same issue as well... any solution?

[michelle-rascat]

Do you have any more server logs? Mine seems to be related to OOM:

2020-08-26 20:37:03.783+0000 WARN [io.netty.util.concurrent.SingleThreadEventExecutor] Unexpected exception from an event executor:  Java
 heap space
java.lang.OutOfMemoryError: Java heap space
2020-08-26 20:37:03.793+0000 ERROR [o.n.b.v.r.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError
]: No RelationshipState for added relationship!, reference ######.
2020-08-26 20:37:03.793+0000 ERROR [o.n.b.v.r.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: No RelationshipState for added relationship!, reference ######. No RelationshipState for added relationship!
java.lang.IllegalStateException: No RelationshipState for added relationship!