I'm evaluating H2 in our product, which is under active development, and so I run it a lot under a debugger (within Eclipse). Pretty much repeatably if I stop the process by hitting Stop in the debugger the next time I run I get this error out of H2
Unique index or primary key violation: "T137_DATA ON """".T137(C0, C1)" [23505-170]<http://192.168.1.110:8082/test.do?jsessionid=72b207545db5c45dea4a25f4d8d48aaa#> 23505/23505 (Help)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c23505> org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "T137_DATA ON """".T137(C0, C1)" [23505-170] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=329&build=170> ) at org.h2.message.DbException.get(DbException.java:169<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=169&build=170> ) at org.h2.message.DbException.get(DbException.java:146<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=146&build=170> ) at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:81<http://h2database.com/html/source.html?file=org/h2/index/BaseIndex.java&line=81&build=170> ) at org.h2.index.PageDataIndex.getDuplicateKeyException(PageDataIndex.java:97<http://h2database.com/html/source.html?file=org/h2/index/PageDataIndex.java&line=97&build=170> ) at org.h2.index.PageDataLeaf.findInsertionPoint(PageDataLeaf.java:157<http://h2database.com/html/source.html?file=org/h2/index/PageDataLeaf.java&line=157&build=170> ) at org.h2.index.PageDataLeaf.addRowTry(PageDataLeaf.java:194<http://h2database.com/html/source.html?file=org/h2/index/PageDataLeaf.java&line=194&build=170> ) at org.h2.index.PageDataIndex.addTry(PageDataIndex.java:169<http://h2database.com/html/source.html?file=org/h2/index/PageDataIndex.java&line=169&build=170> ) at org.h2.index.PageDataIndex.add(PageDataIndex.java:132<http://h2database.com/html/source.html?file=org/h2/index/PageDataIndex.java&line=132&build=170> ) at org.h2.table.RegularTable.addRow(RegularTable.java:122<http://h2database.com/html/source.html?file=org/h2/table/RegularTable.java&line=122&build=170> ) at org.h2.store.PageStore.redo(PageStore.java:1529<http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=1529&build=170> ) at org.h2.store.PageLog.recover(PageLog.java:318<http://h2database.com/html/source.html?file=org/h2/store/PageLog.java&line=318&build=170> ) at org.h2.store.PageStore.recover(PageStore.java:1365<http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=1365&build=170> ) at org.h2.store.PageStore.openExisting(PageStore.java:361<http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=361&build=170> ) at org.h2.store.PageStore.open(PageStore.java:285<http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=285&build=170> ) at org.h2.engine.Database.getPageStore(Database.java:2114<http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=2114&build=170> ) at org.h2.engine.Database.open(Database.java:576<http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=576&build=170> ) at org.h2.engine.Database.openDatabase(Database.java:221<http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=221&build=170> ) at org.h2.engine.Database.<init>(Database.java:216<http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=216&build=170> ) at org.h2.engine.Engine.openSession(Engine.java:56<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=56&build=170> ) at org.h2.engine.Engine.openSession(Engine.java:159<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=159&build=170> ) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=138&build=170> ) at org.h2.engine.Engine.createSession(Engine.java:121<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=121&build=170> ) at org.h2.engine.Engine.createSession(Engine.java:28<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=28&build=170> ) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305<http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=305&build=170> ) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:109<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=109&build=170> ) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:93<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=93&build=170> ) at org.h2.Driver.connect(Driver.java:72<http://h2database.com/html/source.html?file=org/h2/Driver.java&line=72&build=170> ) at org.h2.server.web.WebServer.getConnection(WebServer.java:645<http://h2database.com/html/source.html?file=org/h2/server/web/WebServer.java&line=645&build=170> ) at org.h2.server.web.WebApp.test(WebApp.java:839<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=839&build=170> ) at org.h2.server.web.WebApp.process(WebApp.java:215<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=215&build=170> ) at org.h2.server.web.WebApp.processRequest(WebApp.java:164<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=164&build=170> ) at org.h2.server.web.WebThread.process(WebThread.java:137<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=137&build=170> ) at org.h2.server.web.WebThread.run(WebThread.java:93<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=93&build=170> ) I appreciate hitting Stop is equivalent to power failure, so it's a rough test, but this happens every time, and RECOVER doesn't seem to help. Any thoughts? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/f5T76FEDmTkJ. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
