cancel
Showing results for 
Search instead for 
Did you mean: 

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

amitshipra
Node Clone

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!

3 REPLIES 3

hannah
Node

Hi,

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

and_manousakis
Node Clone

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

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!
Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.