Hi, Do you have a reproducible test case that I could run? What is the database URL? Is this an old database or a fresh one?
Regards, Thomas On Thu, Apr 16, 2015 at 8:27 AM, Sourav Mandal <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > Hi, > We have been using H2 databases in our production, recently due to > one activity somewhat like 800000 records were inserted to a table in that. > And as a result the database got corrupted. As far as we know, it is a bug > in H2 database that it can get corrupted any time. So, it is just heads up > to the team about the recent issue regarding this which we are facing > currently. Please revert back with the suggestion about anything that we > need to do to get out of this situation. > > This is the error we are getting, > > General error: "java.lang.ArrayIndexOutOfBoundsException: 793" [50000-174] > <http://10.134.39.199:8082/login.do?jsessionid=7e62be6ac2e05b843f8cca98b4651bd3> > HY000/50000 (Help) > <http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c50000> > org.h2.jdbc.JdbcSQLException: General error: > "java.lang.ArrayIndexOutOfBoundsException: 793" [50000-174] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:332 > <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=332&build=174>) > > at org.h2.message.DbException.get(DbException.java:161 > <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=161&build=174>) > > at org.h2.message.DbException.convert(DbException.java:284 > <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=284&build=174>) > > at org.h2.table.RegularTable.removeRow(RegularTable.java:394 > <http://h2database.com/html/source.html?file=org/h2/table/RegularTable.java&line=394&build=174>) > > at org.h2.store.PageStore.redo(PageStore.java:1537 > <http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=1537&build=174>) > > at org.h2.store.PageStore.redoDelete(PageStore.java:1511 > <http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=1511&build=174>) > > at org.h2.store.PageLog.recover(PageLog.java:334 > <http://h2database.com/html/source.html?file=org/h2/store/PageLog.java&line=334&build=174>) > > at org.h2.store.PageStore.recover(PageStore.java:1371 > <http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=1371&build=174>) > > at org.h2.store.PageStore.openExisting(PageStore.java:361 > <http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=361&build=174>) > > at org.h2.store.PageStore.open(PageStore.java:285 > <http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=285&build=174>) > > at org.h2.engine.Database.getPageStore(Database.java:2277 > <http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=2277&build=174>) > > at org.h2.engine.Database.open(Database.java:610 > <http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=610&build=174>) > > at org.h2.engine.Database.openDatabase(Database.java:236 > <http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=236&build=174>) > > at org.h2.engine.Database.<init>(Database.java:231 > <http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=231&build=174>) > > at org.h2.engine.Engine.openSession(Engine.java:56 > <http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=56&build=174>) > > at org.h2.engine.Engine.openSession(Engine.java:160 > <http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=160&build=174>) > > at org.h2.engine.Engine.createSessionAndValidate(Engine.java:139 > <http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=139&build=174>) > > at org.h2.engine.Engine.createSession(Engine.java:122 > <http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=122&build=174>) > > at org.h2.engine.Engine.createSession(Engine.java:28 > <http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=28&build=174>) > > at > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:323 > <http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=323&build=174>) > > at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105 > <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=105&build=174>) > > at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90 > <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=90&build=174>) > > at org.h2.Driver.connect(Driver.java:73 > <http://h2database.com/html/source.html?file=org/h2/Driver.java&line=73&build=174>) > > at org.h2.server.web.WebServer.getConnection(WebServer.java:656 > <http://h2database.com/html/source.html?file=org/h2/server/web/WebServer.java&line=656&build=174>) > > at org.h2.server.web.WebApp.login(WebApp.java:904 > <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=904&build=174>) > > at org.h2.server.web.WebApp.process(WebApp.java:209 > <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=209&build=174>) > > at org.h2.server.web.WebApp.processRequest(WebApp.java:168 > <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=168&build=174>) > > at org.h2.server.web.WebThread.process(WebThread.java:138 > <http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=138&build=174>) > > at org.h2.server.web.WebThread.run(WebThread.java:94 > <http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=94&build=174>) > > at java.lang.Thread.run(Unknown Source) > Caused by: java.lang.ArrayIndexOutOfBoundsException: 793 > at org.h2.index.PageBtree.getRow(PageBtree.java:172 > <http://h2database.com/html/source.html?file=org/h2/index/PageBtree.java&line=172&build=174>) > > at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:228 > <http://h2database.com/html/source.html?file=org/h2/index/PageBtreeLeaf.java&line=228&build=174>) > > at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:332 > <http://h2database.com/html/source.html?file=org/h2/index/PageBtreeNode.java&line=332&build=174>) > > at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:332 > <http://h2database.com/html/source.html?file=org/h2/index/PageBtreeNode.java&line=332&build=174>) > > at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:239 > <http://h2database.com/html/source.html?file=org/h2/index/PageBtreeIndex.java&line=239&build=174>) > > at org.h2.table.RegularTable.removeRow(RegularTable.java:376 > <http://h2database.com/html/source.html?file=org/h2/table/RegularTable.java&line=376&build=174> > ) > thanks, > Sourav Mandal > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
