{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3743","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3743/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3743/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3743/events","html_url":"https://github.com/orientechnologies/orientdb/issues/3743","id":60551463,"number":3743,"title":"UNIQUE HAS INDEX getting corrupted","user":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/core","name":"core","color":"207de5"}],"state":"open","locked":false,"assignee":{"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},"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/4","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.1","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/4/labels","id":227432,"number":4,"title":"2.1","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":93,"closed_issues":88,"state":"open","created_at":"2012-12-10T23:58:21Z","updated_at":"2015-03-31T01:38:30Z","due_on":"2015-04-09T03:00:00Z","closed_at":null},"comments":6,"created_at":"2015-03-10T19:02:29Z","updated_at":"2015-03-31T19:58:25Z","closed_at":null,"body":"Attached is the zip of cluster #2 which was isolated by emanuel and reproduced in our environment. i have sanitized most of the sensetive data, but as mentioned before --- please consider this data with utmost sensitivity, usage of this data is sole for debugging purposes and nothing else. Lastly you would delete all and every copy of the data once debugging is over. \n\nzip file attached."},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/88227575","html_url":"https://github.com/orientechnologies/orientdb/issues/3743#issuecomment-88227575","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3743","id":88227575,"user":{"login":"johnmelba","id":6228988,"avatar_url":"https://avatars.githubusercontent.com/u/6228988?v=3","gravatar_id":"","url":"https://api.github.com/users/johnmelba","html_url":"https://github.com/johnmelba","followers_url":"https://api.github.com/users/johnmelba/followers","following_url":"https://api.github.com/users/johnmelba/following{/other_user}","gists_url":"https://api.github.com/users/johnmelba/gists{/gist_id}","starred_url":"https://api.github.com/users/johnmelba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnmelba/subscriptions","organizations_url":"https://api.github.com/users/johnmelba/orgs","repos_url":"https://api.github.com/users/johnmelba/repos","events_url":"https://api.github.com/users/johnmelba/events{/privacy}","received_events_url":"https://api.github.com/users/johnmelba/received_events","type":"User","site_admin":false},"created_at":"2015-03-31T19:58:25Z","updated_at":"2015-03-31T19:58:25Z","body":"btw this came up again in another of our class/cluster today and the entire table was corrupted with tons of duplicate records going in with a unique hash index field. In this particular case we were NOT using mix mode (i.e. TX and non-TX mode together) it was purely using TX mode and still this issue happened. \nWe had to restore from the daily backup and manually move selected data one by one -- quite painful.\n\nI hope this is resolved in 2.1 for real ! thanks."}}