{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6853","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6853/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6853/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6853/events","html_url":"https://github.com/orientechnologies/orientdb/issues/6853","id":185697806,"number":6853,"title":"Failure to open database after recovery: \"Can not close file with id 0 because it is still in use\"","user":{"login":"Ken-Michalak","id":4564238,"avatar_url":"https://avatars.githubusercontent.com/u/4564238?v=3","gravatar_id":"","url":"https://api.github.com/users/Ken-Michalak","html_url":"https://github.com/Ken-Michalak","followers_url":"https://api.github.com/users/Ken-Michalak/followers","following_url":"https://api.github.com/users/Ken-Michalak/following{/other_user}","gists_url":"https://api.github.com/users/Ken-Michalak/gists{/gist_id}","starred_url":"https://api.github.com/users/Ken-Michalak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ken-Michalak/subscriptions","organizations_url":"https://api.github.com/users/Ken-Michalak/orgs","repos_url":"https://api.github.com/users/Ken-Michalak/repos","events_url":"https://api.github.com/users/Ken-Michalak/events{/privacy}","received_events_url":"https://api.github.com/users/Ken-Michalak/received_events","type":"User","site_admin":false},"labels":[{"id":197557840,"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/bug","name":"bug","color":"fc2929","default":true},{"id":356638774,"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/storage%20team","name":"storage team","color":"c5def5","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-27T15:13:53Z","updated_at":"2016-10-28T07:52:09Z","closed_at":null,"body":"## OrientDB Version, operating system, or hardware.\r\nv2.2.4\r\n\r\n## Operating System\r\n- [x] Linux\r\n- [ ] MacOSX\r\n- [ ] Windows\r\n- [ ] Other Unix\r\n- [ ] Other, name? \r\n\r\n## Java\r\njava version \"1.7.0_79\"\r\nOpenJDK Runtime Environment (IcedTea 2.5.6) (7u79-2.5.6-0ubuntu1.14.04.1)\r\nOpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode)\r\n\r\n## Expected behavior and actual behavior\r\n\r\nExpected: After recovering a database from a forced shutdown, the server successfully connects to it.\r\n\r\nActual: It fails to open the database and gives this error: `Internal server error:\r\ncom.orientechnologies.orient.core.exception.OStorageException: Can not close file with id 0 because it is still in use`\r\n\r\n## Steps to reproduce the problem\r\n\r\nAfter attempting to shut down the database for an extended period of time, I had to run a \"kill -9\". One of the databases that wasn't even in use at the time got corrupted, and I cannot open it when connecting remotely or locally.\r\n\r\nThis is from orientdb.err:\r\n> 2016-10-27 14:38:15:202 WARNI {db=dbname} Storage 'dbname' was not closed properly. Will try to recover from write ahead log [OLocalPaginatedStorage]\r\n> 2016-10-27 14:38:15:202 INFO  {db=dbname} Looking for last checkpoint... [OLocalPaginatedStorage]\r\n> 2016-10-27 14:38:15:203 INFO  {db=dbname} Checkpoints are absent, the restore will start from the beginning. [OLocalPaginatedStorage]\r\n> 2016-10-27 14:38:15:203 INFO  {db=dbname} Data restore procedure is started. [OLocalPaginatedStorage]\r\n> 2016-10-27 14:38:15:280 WARNI {db=dbname} Non tx operation was used during data modification we will need index rebuild. [OLocalPaginatedStorage]\r\n> 2016-10-27 14:38:15:283 SEVER {db=dbname} Data restore was paused because of exception. The rest of changes will be rolled back and WAL files will be backed up. Please report issue about this exception to bug tracker and provide WAL files which are backed up in 'wal_backup' directory. [OLocalPaginatedStorage]\r\n> 2016-10-27 14:38:27:199 INFO  {db=dbname} Storage data recover was completed [OLocalPaginatedStorage]\r\n> 2016-10-27 14:38:27:205 SEVER {db=dbname} Internal server error:\r\n> com.orientechnologies.orient.core.exception.OStorageException: Can not close file with id 0 because it is still in use\r\n> \tDB name=\"dbname\" [ONetworkProtocolHttpDb]\r\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/256858777","html_url":"https://github.com/orientechnologies/orientdb/issues/6853#issuecomment-256858777","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6853","id":256858777,"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":"2016-10-28T07:52:09Z","updated_at":"2016-10-28T07:52:09Z","body":"HI @Ken-Michalak \" Data restore was paused because of exception. The rest of changes will be rolled back and WAL files will be backed up. Please report issue about this exception to bug tracker and provide WAL files which are backed up in 'wal_backup' directory.\" Could you send this data to me ?"}}
{"actor":{"display_login":"laa"}}