{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4588","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4588/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4588/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4588/events","html_url":"https://github.com/orientechnologies/orientdb/issues/4588","id":95411509,"number":4588,"title":"Create UNIQUE_HASH_INDEX never ends","user":{"login":"zafeirism","id":4510165,"avatar_url":"https://avatars.githubusercontent.com/u/4510165?v=3","gravatar_id":"","url":"https://api.github.com/users/zafeirism","html_url":"https://github.com/zafeirism","followers_url":"https://api.github.com/users/zafeirism/followers","following_url":"https://api.github.com/users/zafeirism/following{/other_user}","gists_url":"https://api.github.com/users/zafeirism/gists{/gist_id}","starred_url":"https://api.github.com/users/zafeirism/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zafeirism/subscriptions","organizations_url":"https://api.github.com/users/zafeirism/orgs","repos_url":"https://api.github.com/users/zafeirism/repos","events_url":"https://api.github.com/users/zafeirism/events{/privacy}","received_events_url":"https://api.github.com/users/zafeirism/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-07-16T11:18:47Z","updated_at":"2015-07-16T12:19:11Z","closed_at":null,"body":"I am using orient community 2.0.10 standalone and just faced the following issue regarding rebuilding/creating an index.\r\n\r\nI have a class with 170k records and decided to do a rebuild index (through orient management portal). Rebuild failed with java out of bounds exception, so I went on droping and recreating the index (UNIQUE_HASH_INDEX). Recreation causes the process to run at 100% CPU and takes forever.\r\n\r\nNOTE: Here is why I decided to rebuild the index: Server reached the maximum number of allowed connections and my services couldn't connect to it, so I tried to restart orient service. Restart never succeeded, so I killed the process and restarted it. However this might caused index corruption because when my services started talking again with orient server I got several exceptions \"Orient.Client.API.Exceptions.OException: com.orientechnologies.orient.core.index.sbtree.local.OSBTreeException: Error during index update with key #23:123882 and value true com.orientechnologies.orient.core.storage.impl.local.paginated.atomicoperations.ONestedRollbackException: atomic operation was rolled back by internal component\". So I decided to rebuild all indexes but faced the issues mentioned earlier.\r\n\r\nI can send the server logs if necessary.\r\n\r\n(posted question for this issue also on google group [here](https://groups.google.com/forum/#!topic/orient-database/Qt5Bj_ReGS8)"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/121941816","html_url":"https://github.com/orientechnologies/orientdb/issues/4588#issuecomment-121941816","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4588","id":121941816,"user":{"login":"laa","id":105066,"avatar_url":"https://avatars.githubusercontent.com/u/105066?v=3","gravatar_id":"","url":"https://api.github.com/users/laa","html_url":"https://github.com/laa","followers_url":"https://api.github.com/users/laa/followers","following_url":"https://api.github.com/users/laa/following{/other_user}","gists_url":"https://api.github.com/users/laa/gists{/gist_id}","starred_url":"https://api.github.com/users/laa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laa/subscriptions","organizations_url":"https://api.github.com/users/laa/orgs","repos_url":"https://api.github.com/users/laa/repos","events_url":"https://api.github.com/users/laa/events{/privacy}","received_events_url":"https://api.github.com/users/laa/received_events","type":"User","site_admin":false},"created_at":"2015-07-16T12:19:11Z","updated_at":"2015-07-16T12:19:11Z","body":"You did export/import and ran repair database on imported DB, did not you ?"}}