{"action":"created","issue":{"url":"https://api.github.com/repos/fbiville/liquigraph/issues/76","repository_url":"https://api.github.com/repos/fbiville/liquigraph","labels_url":"https://api.github.com/repos/fbiville/liquigraph/issues/76/labels{/name}","comments_url":"https://api.github.com/repos/fbiville/liquigraph/issues/76/comments","events_url":"https://api.github.com/repos/fbiville/liquigraph/issues/76/events","html_url":"https://github.com/fbiville/liquigraph/issues/76","id":152538244,"number":76,"title":"Error when running in larger changeset","user":{"login":"airomega","id":3540387,"avatar_url":"https://avatars.githubusercontent.com/u/3540387?v=3","gravatar_id":"","url":"https://api.github.com/users/airomega","html_url":"https://github.com/airomega","followers_url":"https://api.github.com/users/airomega/followers","following_url":"https://api.github.com/users/airomega/following{/other_user}","gists_url":"https://api.github.com/users/airomega/gists{/gist_id}","starred_url":"https://api.github.com/users/airomega/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/airomega/subscriptions","organizations_url":"https://api.github.com/users/airomega/orgs","repos_url":"https://api.github.com/users/airomega/repos","events_url":"https://api.github.com/users/airomega/events{/privacy}","received_events_url":"https://api.github.com/users/airomega/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/fbiville/liquigraph/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-05-02T11:47:21Z","updated_at":"2016-05-02T12:59:50Z","closed_at":null,"body":"I created a changeset with 17 create statements. When running liquigraph it would hang for a minute then throw the error below.\r\n\r\nSplitting the 17 changesets into two seperate changesets fixed the error. \r\n\r\n```\r\n12:32:53.167 [main] ERROR o.l.core.io.lock.LockableConnection - Cannot remove __LiquigraphLock during cleanup.\r\njava.sql.SQLException: Error executing statement\r\n\tat org.neo4j.jdbc.internal.rest.TransactionalQueryExecutor.executeQuery(TransactionalQueryExecutor.java:224) ~[liquigraph-cli.jar:na]\r\n\tat org.neo4j.jdbc.internal.Neo4jConnection.executeQuery(Neo4jConnection.java:370) ~[liquigraph-cli.jar:na]\r\n\tat org.neo4j.jdbc.internal.Neo4jPreparedStatement.execute(Neo4jPreparedStatement.java:55) ~[liquigraph-cli.jar:na]\r\n\tat org.liquigraph.core.io.lock.LockableConnection.releaseLock(LockableConnection.java:310) [liquigraph-cli.jar:na]\r\n\tat org.liquigraph.core.io.lock.LockableConnection.close(LockableConnection.java:89) [liquigraph-cli.jar:na]\r\n\tat org.liquigraph.core.io.lock.LockableConnection.acquire(LockableConnection.java:71) [liquigraph-cli.jar:na]\r\n\tat org.liquigraph.core.io.GraphJdbcConnector.connect(GraphJdbcConnector.java:43) [liquigraph-cli.jar:na]\r\n\tat org.liquigraph.core.api.MigrationRunner.runMigrations(MigrationRunner.java:68) [liquigraph-cli.jar:na]\r\n\tat org.liquigraph.core.api.Liquigraph.runMigrations(Liquigraph.java:63) [liquigraph-cli.jar:na]\r\n\tat org.liquigraph.cli.LiquigraphCli.main(LiquigraphCli.java:119) [liquigraph-cli.jar:na]\r\nCaused by: org.restlet.resource.ResourceException: Error executing statement\r\n\tat org.restlet.resource.ClientResource.doError(ClientResource.java:612) ~[liquigraph-cli.jar:na]\r\n\tat org.neo4j.jdbc.internal.rest.Resources$TransactionClientResource.doError(Resources.java:283) ~[liquigraph-cli.jar:na]\r\n\tat org.restlet.resource.ClientResource.handleInbound(ClientResource.java:1202) ~[liquigraph-cli.jar:na]\r\n\tat org.restlet.resource.ClientResource.handle(ClientResource.java:1069) ~[liquigraph-cli.jar:na]\r\n\tat org.restlet.resource.ClientResource.handle(ClientResource.java:1044) ~[liquigraph-cli.jar:na]\r\n\tat org.restlet.resource.ClientResource.post(ClientResource.java:1453) ~[liquigraph-cli.jar:na]\r\n\tat org.neo4j.jdbc.internal.rest.TransactionalQueryExecutor.post(TransactionalQueryExecutor.java:98) ~[liquigraph-cli.jar:na]\r\n\tat org.neo4j.jdbc.internal.rest.TransactionalQueryExecutor.begin(TransactionalQueryExecutor.java:76) ~[liquigraph-cli.jar:na]\r\n\tat org.neo4j.jdbc.internal.rest.TransactionalQueryExecutor.executeQuery(TransactionalQueryExecutor.java:214) ~[liquigraph-cli.jar:na]\r\n\t... 9 common frames omitted\r\nError executing statement (404) - {\"results\":[],\"errors\":[{\"code\":\"Neo.ClientError.Transaction.UnknownId\",\"message\":\"Unrecognized transaction id. Transaction may have timed out and been rolled back.\"}]}\r\n\tat org.restlet.resource.ClientResource.doError(ClientResource.java:612)\r\n\tat org.neo4j.jdbc.internal.rest.Resources$TransactionClientResource.doError(Resources.java:283)\r\n\tat org.restlet.resource.ClientResource.handleInbound(ClientResource.java:1202)\r\n\tat org.restlet.resource.ClientResource.handle(ClientResource.java:1069)\r\n\tat org.restlet.resource.ClientResource.handle(ClientResource.java:1044)\r\n\tat org.restlet.resource.ClientResource.handle(ClientResource.java:950)\r\n\tat org.restlet.resource.ClientResource.delete(ClientResource.java:570)\r\n\tat org.neo4j.jdbc.internal.rest.TransactionalQueryExecutor.rollback(TransactionalQueryExecutor.java:187)\r\n\tat org.neo4j.jdbc.internal.Neo4jConnection.close(Neo4jConnection.java:245)\r\n\tat org.liquigraph.core.io.lock.LockableConnection.close(LockableConnection.java:90)\r\n\tat org.liquigraph.core.io.lock.LockableConnection.acquire(LockableConnection.java:71)\r\n\tat org.liquigraph.core.io.GraphJdbcConnector.connect(GraphJdbcConnector.java:43)\r\n\tat org.liquigraph.core.api.MigrationRunner.runMigrations(MigrationRunner.java:68)\r\n\tat org.liquigraph.core.api.Liquigraph.runMigrations(Liquigraph.java:63)\r\n\tat org.liquigraph.cli.LiquigraphCli.main(LiquigraphCli.java:119)\r\nException in thread \"main\" org.liquigraph.core.exception.LiquigraphLockException: Cannot create __LiquigraphLock lock\r\n\tLikely another Liquigraph execution is going on or has crashed.\r\n\tat org.liquigraph.core.io.lock.LockableConnection.tryWriteLock(LockableConnection.java:358)\r\n\tat org.liquigraph.core.io.lock.LockableConnection.acquireLock(LockableConnection.java:323)\r\n\tat org.liquigraph.core.io.lock.LockableConnection.acquire(LockableConnection.java:67)\r\n\tat org.liquigraph.core.io.GraphJdbcConnector.connect(GraphJdbcConnector.java:43)\r\n\tat org.liquigraph.core.api.MigrationRunner.runMigrations(MigrationRunner.java:68)\r\n\tat org.liquigraph.core.api.Liquigraph.runMigrations(Liquigraph.java:63)\r\n\tat org.liquigraph.cli.LiquigraphCli.main(LiquigraphCli.java:119)\r\nCaused by: java.sql.SQLException: Error executing query CREATE (:__LiquigraphLock {name:'John', uuid:{1}})\r\n with params {1=4689adcb-4f39-493a-a82a-faa7f8bf24be}\r\n\tat org.neo4j.jdbc.internal.Neo4jConnection.executeQuery(Neo4jConnection.java:379)\r\n\tat org.neo4j.jdbc.internal.Neo4jPreparedStatement.execute(Neo4jPreparedStatement.java:55)\r\n\tat org.liquigraph.core.io.lock.LockableConnection.tryWriteLock(LockableConnection.java:354)\r\n\t... 6 more\r\nCaused by: java.lang.RuntimeException: Error executing cypher statement(s) [{code=Neo.ClientError.Schema.ConstraintViolation, message=Node 6 already exists with label __LiquigraphLock and property \"name\"=[John]}]\r\n\tat org.neo4j.jdbc.internal.rest.StreamingParser.handleErrors(StreamingParser.java:341)\r\n\tat org.neo4j.jdbc.internal.rest.StreamingParser.skipTo(StreamingParser.java:315)\r\n\tat org.neo4j.jdbc.internal.rest.StreamingParser.nextResult(StreamingParser.java:130)\r\n\tat org.neo4j.jdbc.internal.rest.StreamingParser$2.hasNext(StreamingParser.java:265)\r\n\tat org.neo4j.jdbc.internal.rest.TransactionalQueryExecutor.executeQuery(TransactionalQueryExecutor.java:215)\r\n\tat org.neo4j.jdbc.internal.Neo4jConnection.executeQuery(Neo4jConnection.java:370)\r\n\t... 8 more\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/fbiville/liquigraph/issues/comments/216228329","html_url":"https://github.com/fbiville/liquigraph/issues/76#issuecomment-216228329","issue_url":"https://api.github.com/repos/fbiville/liquigraph/issues/76","id":216228329,"user":{"login":"airomega","id":3540387,"avatar_url":"https://avatars.githubusercontent.com/u/3540387?v=3","gravatar_id":"","url":"https://api.github.com/users/airomega","html_url":"https://github.com/airomega","followers_url":"https://api.github.com/users/airomega/followers","following_url":"https://api.github.com/users/airomega/following{/other_user}","gists_url":"https://api.github.com/users/airomega/gists{/gist_id}","starred_url":"https://api.github.com/users/airomega/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/airomega/subscriptions","organizations_url":"https://api.github.com/users/airomega/orgs","repos_url":"https://api.github.com/users/airomega/repos","events_url":"https://api.github.com/users/airomega/events{/privacy}","received_events_url":"https://api.github.com/users/airomega/received_events","type":"User","site_admin":false},"created_at":"2016-05-02T12:59:50Z","updated_at":"2016-05-02T12:59:50Z","body":"I've sent via email."}}