{"action":"created","issue":{"url":"https://api.github.com/repos/h2database/h2database/issues/296","repository_url":"https://api.github.com/repos/h2database/h2database","labels_url":"https://api.github.com/repos/h2database/h2database/issues/296/labels{/name}","comments_url":"https://api.github.com/repos/h2database/h2database/issues/296/comments","events_url":"https://api.github.com/repos/h2database/h2database/issues/296/events","html_url":"https://github.com/h2database/h2database/issues/296","id":157617075,"number":296,"title":"`NoSuchElementException` in `removeTemporaryLobs`","user":{"login":"kno10","id":3997899,"avatar_url":"https://avatars.githubusercontent.com/u/3997899?v=3","gravatar_id":"","url":"https://api.github.com/users/kno10","html_url":"https://github.com/kno10","followers_url":"https://api.github.com/users/kno10/followers","following_url":"https://api.github.com/users/kno10/following{/other_user}","gists_url":"https://api.github.com/users/kno10/gists{/gist_id}","starred_url":"https://api.github.com/users/kno10/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kno10/subscriptions","organizations_url":"https://api.github.com/users/kno10/orgs","repos_url":"https://api.github.com/users/kno10/repos","events_url":"https://api.github.com/users/kno10/events{/privacy}","received_events_url":"https://api.github.com/users/kno10/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-31T08:31:55Z","updated_at":"2016-06-02T09:35:20Z","closed_at":null,"body":"Using H2 1.4.192, but IIRC the database was initially created (and maybe populated) with 1.4.191 (so it may have been corrupted by #255 ? I will keep an eye on this issue if it also happens on databases never touched by 1.4.191).\r\nThe database contains mostly BLOBs, storing HTML pages collected by a web spider.\r\n```\r\nClosing database: conn41: url=jdbc:h2:/path/to/file user=\r\norg.h2.jdbc.JdbcSQLException: General error: \"java.util.NoSuchElementException\" [50000-192]\r\n        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)\r\n        at org.h2.message.DbException.get(DbException.java:168)\r\n        at org.h2.message.DbException.convert(DbException.java:295)\r\n        at org.h2.message.DbException.toSQLException(DbException.java:268)\r\n        at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)\r\n        at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:117)\r\n[... in my code, triggered by `statement.executeUpdate(\"SHUTDOWN\");` ...]\r\nCaused by: java.util.NoSuchElementException\r\n        at java.util.LinkedList.getFirst(LinkedList.java:244)\r\n        at org.h2.engine.Session.removeTemporaryLobs(Session.java:670)\r\n        at org.h2.engine.Session.commit(Session.java:619)\r\n        at org.h2.command.Command.stop(Command.java:156)\r\n        at org.h2.command.Command.executeUpdate(Command.java:288)\r\n        at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:130)\r\n        at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:115)\r\n        ... 2 more\r\n```\r\n\r\nI used to have a `SHUTDOWN DEFRAG` there, thats why I'm doing an explicit call to `SHUTDOWN`.\r\n\r\nSorry, I don't have an easy test case to reproduce this."},"comment":{"url":"https://api.github.com/repos/h2database/h2database/issues/comments/223242823","html_url":"https://github.com/h2database/h2database/issues/296#issuecomment-223242823","issue_url":"https://api.github.com/repos/h2database/h2database/issues/296","id":223242823,"user":{"login":"kno10","id":3997899,"avatar_url":"https://avatars.githubusercontent.com/u/3997899?v=3","gravatar_id":"","url":"https://api.github.com/users/kno10","html_url":"https://github.com/kno10","followers_url":"https://api.github.com/users/kno10/followers","following_url":"https://api.github.com/users/kno10/following{/other_user}","gists_url":"https://api.github.com/users/kno10/gists{/gist_id}","starred_url":"https://api.github.com/users/kno10/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kno10/subscriptions","organizations_url":"https://api.github.com/users/kno10/orgs","repos_url":"https://api.github.com/users/kno10/repos","events_url":"https://api.github.com/users/kno10/events{/privacy}","received_events_url":"https://api.github.com/users/kno10/received_events","type":"User","site_admin":false},"created_at":"2016-06-02T09:35:20Z","updated_at":"2016-06-02T09:35:20Z","body":"My method handling the close is synchronized, and sets the connection to `null` afterwards. So exactly one close should happen."}}
{"actor":{"display_login":"kno10"}}