Skip to content

Instantly share code, notes, and snippets.

@cjdaly
Created August 5, 2015 05:17
Show Gist options
  • Save cjdaly/aa5334b58c34eeff85fa to your computer and use it in GitHub Desktop.
Save cjdaly/aa5334b58c34eeff85fa to your computer and use it in GitHub Desktop.
Cypher In:
{
"statements": [
{
"statement": "MATCH node WHERE id(node)={nodeId} SET node.__lock=true RETURN node.__lock",
"parameters": {
"nodeId": 2
}
},
{
"statement": "MATCH node WHERE id(node)={nodeId} SET node.`fold_OrdinalCounter_vitals_Vitals`=COALESCE(node.`fold_OrdinalCounter_vitals_Vitals`, 0) + 1 SET node.__lock=false RETURN node.`fold_OrdinalCounter_vitals_Vitals`",
"parameters": {
"nodeId": 2
}
}
]
}
------
Cypher Out:
{
"results": [
{
"columns": [
"node.__lock"
],
"data": [
{
"row": [
true
]
}
]
},
{
"columns": [
"node.`fold_OrdinalCounter_vitals_Vitals`"
],
"data": [
{
"row": [
31
]
}
]
}
],
"errors": [
{
"code": "Neo.DatabaseError.Transaction.CouldNotCommit",
"message": "org.neo4j.kernel.api.exceptions.TransactionFailureException: Database constraints have changed (txId=162) after this transaction (txId=160) started, which is not yet supported. Please retry your transaction to ensure all constraints are executed.",
"stackTrace": "java.lang.RuntimeException: org.neo4j.kernel.api.exceptions.TransactionFailureException: Database constraints have changed (txId=162) after this transaction (txId=160) started, which is not yet supported. Please retry your transaction to ensure all constraints are executed.\n\tat org.neo4j.server.rest.transactional.TransitionalTxManagementKernelTransaction.commit(TransitionalTxManagementKernelTransaction.java:87)\n\tat org.neo4j.server.rest.transactional.TransactionHandle.closeContextAndCollectErrors(TransactionHandle.java:278)\n\tat org.neo4j.server.rest.transactional.TransactionHandle.commit(TransactionHandle.java:147)\n\tat org.neo4j.server.rest.web.TransactionalService$2.write(TransactionalService.java:211)\n\tat com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:71)\n\tat com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:57)\n\tat com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:302)\n\tat com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1510)\n\tat com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)\n\tat com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)\n\tat com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)\n\tat com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)\n\tat com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:790)\n\tat org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)\n\tat org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)\n\tat org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)\n\tat org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)\n\tat org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)\n\tat org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)\n\tat org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)\n\tat org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\n\tat org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)\n\tat org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)\n\tat org.eclipse.jetty.server.Server.handle(Server.java:497)\n\tat org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)\n\tat org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)\n\tat org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)\n\tat org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)\n\tat org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)\n\tat java.lang.Thread.run(Thread.java:745)\nCaused by: org.neo4j.kernel.api.exceptions.TransactionFailureException: Database constraints have changed (txId=162) after this transaction (txId=160) started, which is not yet supported. Please retry your transaction to ensure all constraints are executed.\n\tat org.neo4j.kernel.impl.transaction.state.IntegrityValidator.validateTransactionStartKnowledge(IntegrityValidator.java:69)\n\tat org.neo4j.kernel.impl.transaction.state.TransactionRecordState.extractCommands(TransactionRecordState.java:124)\n\tat org.neo4j.kernel.impl.api.KernelTransactionImplementation.commit(KernelTransactionImplementation.java:476)\n\tat org.neo4j.kernel.impl.api.KernelTransactionImplementation.close(KernelTransactionImplementation.java:418)\n\tat org.neo4j.server.rest.transactional.TransitionalTxManagementKernelTransaction.commit(TransitionalTxManagementKernelTransaction.java:83)\n\t... 30 more\n"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment