Unfortunately we do not know how to predictively reproduce this scenario. It seems to occur at higher probability, when the Android device runs out of battery. Thank you for the hint using PageStore, this may help us continuing to use the H2 database.
Am Montag, 11. April 2016 20:10:36 UTC+2 schrieb Noel Grandin: > > That is some kind of DB corruption. If you can supply a test-case, we > could try to track it down. Otherwise I would suggest using the older > PageStore engine for now, by appending "MV_STORE=false" to your DB URL. > > On 11 April 2016 at 10:10, Stefan Dangl <[email protected] <javascript:>> > wrote: > >> Hello, >> >> we are currently running the H2-database successfully on Android using >> multiple apps to acces it via the mixed-mode. >> Occasionally we get an error when opening the database: The file seems to >> be locked. >> Restarting the device (and thus all apps accessing the database) leads to >> the exception below. >> We assume, the database has become corrupt at some point. But this is not >> acceptable. Maybe we have to switch to another database... (painful) :-( >> >> >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: >> "java.lang.StackOverflowError" >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: General error: "java.lang.StackOverflowError" [50000-191] >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.engine.Database.openDatabase(Database.java:301) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.engine.Database.<init>(Database.java:264) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.engine.Engine.openSession(Engine.java:65) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.engine.Engine.openSession(Engine.java:175) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> org.h2.engine.Engine.createSessionAndValidate(Engine.java:153) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.engine.Engine.createSession(Engine.java:136) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.engine.Engine.createSession(Engine.java:28) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:107) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:91) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.Driver.connect(Driver.java:72) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> java.sql.DriverManager.getConnection(DriverManager.java:179) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> java.sql.DriverManager.getConnection(DriverManager.java:144) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> com.mobidat.wp2.databaseaccess.DbHelper.getDatabaseConnection(DbHelper.java:80) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> com.mobidat.wp2.databaseaccess.DbHelper.ensureUp2Date(DbHelper.java:131) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> com.mobidat.wp2.communicationservice.CommunicationService$2.run(CommunicationService.java:86) >> 04-11 09:57:01.715 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: Caused by: java.lang.StackOverflowError >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> java.lang.AbstractStringBuilder.append0(AbstractStringBuilder.java:147) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at java.lang.StringBuilder.append(StringBuilder.java:216) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.Chunk.getMetaKey(Chunk.java:172) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> org.h2.mvstore.MVStore.getChunkIfFound(MVStore.java:954) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVStore.getChunk(MVStore.java:931) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVStore.readPage(MVStore.java:1930) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.readPage(MVMap.java:736) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.Page.getChildPage(Page.java:217) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.binarySearch(MVMap.java:468) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.get(MVMap.java:450) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at >> org.h2.mvstore.MVStore.getChunkIfFound(MVStore.java:954) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVStore.getChunk(MVStore.java:931) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVStore.readPage(MVStore.java:1930) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.readPage(MVMap.java:736) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.Page.getChildPage(Page.java:217) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.binarySearch(MVMap.java:468) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) >> 04-11 09:57:01.725 2857-2986/com.mobidat.wp2.communicationservice >> W/System.err: at org.h2.mvstore.MVMap.get(MVMap.java:450) >> ( [...] function-calls repeat from last call to getChunkIfFound) >> >> -- >> 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:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
