Any other suggestions how curruptions like below could arise ?
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "22081 of 21060". Possible solution: use the recovery tool [90030-190] at org.h2.store.PageStore.readPage(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.store.PageStore.getPage(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.index.PageDataIndex.getPage(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.index.PageDataIndex.<init>(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.table.RegularTable.<init>(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.store.PageStore.addMeta(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.store.PageStore.readMetaData(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.store.PageStore.recover(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.store.PageStore.openExisting(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.store.PageStore.open(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Database.getPageStore(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Database.open(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Database.openDatabase(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Database.<init>(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Engine.openSession(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Engine.openSession(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Engine.createSessionAndValidate(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Engine.createSession(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.Engine.createSession(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.engine.SessionRemote.connectEmbeddedOrServer(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.jdbc.JdbcConnection.<init>(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.jdbc.JdbcConnection.<init>(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.Driver.connect(Unknown Source) ~[h2-1.4.190.jar:1.4.190] Op dinsdag 8 november 2016 14:21:49 UTC+1 schreef Rinse Lemstra: > > We open our database with: > > > > Connection connection = new > org.h2.Driver().connect(“jdbc:h2:file:\\Data;FILE_LOCK=FILE;AUTO_SERVER=TRUE;MODE=REGULAR;MV_STORE=FALSE;DB_CLOSE_DELAY=0", > > new Properties() ); > > > > We close our database with: > > > > connection.close(); > > > > > > What will happen if the user in (auto_server) server role performs a > connection.close while a user in (auto_server) client role is still > performing updates? > > > > Could this lead to database corruptions? > > > > regards, > > > Rinse > > > -- 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.
