{"action":"created","issue":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/4051","labels_url":"https://api.github.com/repos/neo4j/neo4j/issues/4051/labels{/name}","comments_url":"https://api.github.com/repos/neo4j/neo4j/issues/4051/comments","events_url":"https://api.github.com/repos/neo4j/neo4j/issues/4051/events","html_url":"https://github.com/neo4j/neo4j/issues/4051","id":58563953,"number":4051,"title":"Missing indices for the available constraints","user":{"login":"srivastavarobin","id":939154,"avatar_url":"https://avatars.githubusercontent.com/u/939154?v=3","gravatar_id":"","url":"https://api.github.com/users/srivastavarobin","html_url":"https://github.com/srivastavarobin","followers_url":"https://api.github.com/users/srivastavarobin/followers","following_url":"https://api.github.com/users/srivastavarobin/following{/other_user}","gists_url":"https://api.github.com/users/srivastavarobin/gists{/gist_id}","starred_url":"https://api.github.com/users/srivastavarobin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srivastavarobin/subscriptions","organizations_url":"https://api.github.com/users/srivastavarobin/orgs","repos_url":"https://api.github.com/users/srivastavarobin/repos","events_url":"https://api.github.com/users/srivastavarobin/events{/privacy}","received_events_url":"https://api.github.com/users/srivastavarobin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-02-23T09:50:06Z","updated_at":"2015-02-23T10:23:58Z","closed_at":null,"body":"#### Quick Intro\r\nThe DB is in a state where the indices are missing for certain constraints. Trying to delete those constraints are giving error related to system's transaction.\r\n\r\n#### Details\r\nAn attempt to set unique constraint (from the browser) on ```id``` property of ```X``` label resulted in a wait for over 10 minutes and ultimately resulted with an ```Unknown Exception```. Another attempt was made for the same thing, however this time it lead to Neo4j not able to honour other incoming requests and it ultimately lead to a freeze. An attempt to restart Neo4j also went into a really long wait. Finally the machine had to be restarted to bring the system live again.\r\n\r\nAfter the restart, Neo4j detected improper shutdown and recovered from it. However, upon checking the ```schema``` it showed the constraint on ```id``` of ```X``` is created but there is no index available for it. Upon trying to create a node with label ```X``` and some value to property ```id``` resulted in errors. An attempt to drop the constraint gives the following error:\r\n\r\n```SystemException: Kernel has encountered some problem, please perform necessary action (tx recovery/restart)```\r\n\r\nFortunately an index created manually on ```id``` of ```X``` resumed the normal process of creation of nodes with that label.\r\n\r\nHow to bring back sanity to the system?\r\n\r\n##### Environment Details\r\n* Primary Server: Hosted on Amazon (m3.large)\r\n* Replication Server: Hosted on Amazon (m3.large)\r\n* The label X already had over 2 million nodes in the database"},"comment":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/comments/75518649","html_url":"https://github.com/neo4j/neo4j/issues/4051#issuecomment-75518649","issue_url":"https://api.github.com/repos/neo4j/neo4j/issues/4051","id":75518649,"user":{"login":"jexp","id":67427,"avatar_url":"https://avatars.githubusercontent.com/u/67427?v=3","gravatar_id":"","url":"https://api.github.com/users/jexp","html_url":"https://github.com/jexp","followers_url":"https://api.github.com/users/jexp/followers","following_url":"https://api.github.com/users/jexp/following{/other_user}","gists_url":"https://api.github.com/users/jexp/gists{/gist_id}","starred_url":"https://api.github.com/users/jexp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jexp/subscriptions","organizations_url":"https://api.github.com/users/jexp/orgs","repos_url":"https://api.github.com/users/jexp/repos","events_url":"https://api.github.com/users/jexp/events{/privacy}","received_events_url":"https://api.github.com/users/jexp/received_events","type":"User","site_admin":false},"created_at":"2015-02-23T10:23:58Z","updated_at":"2015-02-23T10:23:58Z","body":"The previous exception should still be in messages.log if you go further to the beginning of the logfile or perhaps in `data/log/neo4j.log`."}}