{"action":"opened","issue":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/10276","repository_url":"https://api.github.com/repos/neo4j/neo4j","labels_url":"https://api.github.com/repos/neo4j/neo4j/issues/10276/labels{/name}","comments_url":"https://api.github.com/repos/neo4j/neo4j/issues/10276/comments","events_url":"https://api.github.com/repos/neo4j/neo4j/issues/10276/events","html_url":"https://github.com/neo4j/neo4j/issues/10276","id":265074508,"number":10276,"title":"Attempting to create a uniqueness constraint causes Neo4J to hang.","user":{"login":"TomGroves","id":19835296,"avatar_url":"https://avatars2.githubusercontent.com/u/19835296?v=4","gravatar_id":"","url":"https://api.github.com/users/TomGroves","html_url":"https://github.com/TomGroves","followers_url":"https://api.github.com/users/TomGroves/followers","following_url":"https://api.github.com/users/TomGroves/following{/other_user}","gists_url":"https://api.github.com/users/TomGroves/gists{/gist_id}","starred_url":"https://api.github.com/users/TomGroves/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TomGroves/subscriptions","organizations_url":"https://api.github.com/users/TomGroves/orgs","repos_url":"https://api.github.com/users/TomGroves/repos","events_url":"https://api.github.com/users/TomGroves/events{/privacy}","received_events_url":"https://api.github.com/users/TomGroves/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-10-12T20:26:03Z","updated_at":"2017-10-12T20:26:03Z","closed_at":null,"author_association":"NONE","body":"\r\nAttempting to create a uniqueness constraint causes Neo4J to hang.\r\n\r\n**Neo4j Version:** 3.2.6\r\n**Operating System:** Ubuntu 16.04\r\n**API:** Cypher in web interface, also occurs from Py2Neo\r\n\r\n### Steps to reproduce\r\n1. With new, empty graph, enter in web interface\r\n`CREATE CONSTRAINT ON (book:Book) ASSERT book.isbn IS UNIQUE`\r\n### Expected behavior\r\nConstraint should be created\r\n\r\n### Actual behavior\r\nNeo4J server hangs, apparently while trying to create an index. The request, and all other requests in the web interface, are just met with a spinner.\r\nFrom debug.log:\r\n\r\n`2017-10-12 13:29:17.245+0000 INFO [o.n.k.i.DiagnosticsManager] --- SERVER STARTED END ---\r\n2017-10-12 13:29:56.701+0000 INFO [o.n.k.i.a.i.IndexPopulationJob] Index population started: [:Book(isbn) [provider: {key=lucene, version=1.0}]]\r\n2017-10-12 13:29:57.088+0000 INFO [o.n.k.i.a.i.IndexPopulationJob] Completed node store scan. Flushing all pending updates.\r\nBatchingMultipleIndexPopulator{activeTasks=0, executor=java.util.concurrent.ThreadPoolExecutor@1cf9354b[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0], batchedUpdates = [], queuedUpdates = 0}\r\n2017-10-12 13:29:57.088+0000 INFO [o.n.k.i.a.i.IndexPopulationJob] Shutting down executor.\r\nBatchingMultipleIndexPopulator{activeTasks=0, executor=java.util.concurrent.ThreadPoolExecutor@1cf9354b[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0], batchedUpdates = [], queuedUpdates = 0}\r\n2017-10-12 13:51:15.551+0000 INFO [o.n.k.i.t.l.c.CheckPointerImpl] Check Pointing triggered by scheduler for time threshold [4]:  Starting check pointing...\r\n2017-10-12 13:51:15.552+0000 INFO [o.n.k.i.t.l.c.CheckPointerImpl] Check Pointing triggered by scheduler for time threshold [4]:  Starting store flush...`\r\n\r\nDiscussed on [stackoverflow](https://stackoverflow.com/questions/46710894/uniqueness-constraint-causes-neo4j-to-hang)"}}
{"actor":{"display_login":"TomGroves"}}