Greetings. At least for me, 2.2.224 was not a good release while 2.2.232 is a really stable and good one. So I only can advise to migrate/upgrade asap. Also you can try the recovery tool on your corrupted DB. But again, this recover tool works great for me with 2.2.232 -- but I never got anything recovered before that version.
Cheers and good luck Andreas On Wed, 2024-11-20 at 14:04 +0530, 'Balamurali Krishna Ippili' via H2 Database wrote: > Hi Team, > > Any suggestions on this issue? > > Thanks, > Balamurali > > On Tue, Nov 19, 2024 at 11:28 AM Balamurali Krishna Ippili > <[email protected]> wrote: > > I am seeing the following error in the trace logs: > > > > 2024-11-08 17:43:10.711000Z database: flush > > org.h2.message.DbException: General error: > > "org.h2.mvstore.MVStoreException: Double mark: 96/42 [2-ae, b3-b7, > > db-] [2.2.224/6]" [50000-224] > > at org.h2.message.DbException.get(DbException.java:212) > > at org.h2.message.DbException.convert(DbException.java:407) > > at org.h2.mvstore.db.Store.lambda$new$0(Store.java:122) > > at org.h2.mvstore.MVStore.handleException(MVStore.java:1546) > > at org.h2.mvstore.MVStore.panic(MVStore.java:371) > > at org.h2.mvstore.MVStore.<init>(MVStore.java:291) > > at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2035) > > at org.h2.mvstore.db.Store.<init>(Store.java:133) > > at org.h2.engine.Database.<init>(Database.java:326) > > at org.h2.engine.Engine.openSession(Engine.java:92) > > at org.h2.engine.Engine.openSession(Engine.java:222) > > at org.h2.engine.Engine.createSession(Engine.java:201) > > at > > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.j > > ava:343) > > at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:125) > > at org.h2.Driver.connect(Driver.java:59) > > at java.sql.DriverManager.getConnection(DriverManager.java:664) > > at java.sql.DriverManager.getConnection(DriverManager.java:208) > > at > > com.j256.ormlite.jdbc.JdbcConnectionSource.makeConnection(JdbcConne > > ctionSource.java:252) > > at > > com.j256.ormlite.jdbc.JdbcConnectionSource.getReadWriteConnection(J > > dbcConnectionSource.java:184) > > at > > com.j256.ormlite.jdbc.JdbcConnectionSource.getReadOnlyConnection(Jd > > bcConnectionSource.java:170) > > at > > com.ca.integration.normalization.common.persistence.DbPersistenceHe > > lper.testDbConnection(DbPersistenceHelper.java:87) > > at > > com.ca.integration.normalization.common.persistence.DbPersistenceHe > > lper.initialize(DbPersistenceHelper.java:75) > > at > > com.ca.integration.normalization.common.NIMServletContextListener.i > > nitializePersistence(NIMServletContextListener.java:627) > > at > > com.ca.integration.normalization.common.NIMServletContextListener.i > > nitializeNIMWithDbDatastore(NIMServletContextListener.java:215) > > at > > com.ca.integration.normalization.common.NIMServletContextListener.c > > ontextInitialized(NIMServletContextListener.java:133) > > at > > org.apache.catalina.core.StandardContext.listenerStart(StandardCont > > ext.java:4462) > > at > > org.apache.catalina.core.StandardContext.startInternal(StandardCont > > ext.java:4914) > > at > > org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171 > > ) > > at > > org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBas > > e.java:1332) > > at > > org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBas > > e.java:1322) > > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > > at > > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas > > k.access$201(ScheduledThreadPoolExecutor.java:180) > > at > > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas > > k.run(ScheduledThreadPoolExecutor.java:293) > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecuto > > r.java:1149) > > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecut > > or.java:624) > > at > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(Task > > Thread.java:61) > > at java.lang.Thread.run(Thread.java:750) > > Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: > > "org.h2.mvstore.MVStoreException: Double mark: 96/42 [2-ae, b3-b7, > > db-] > > > > > > Thanks, > > Balamurali > > > > On Tue, Nov 19, 2024 at 11:15 AM Balamurali Krishna Ippili > > <[email protected]> wrote: > > > Hi Team, > > > > > > We are using H2 DB 2.2.224 in our component and it is crashing > > > intermittently and giving the below error: > > > > > > SQL Exception occurred - SQL State 90030: File corrupted while > > > reading record: > > > "/opt/cloakware/cspmserver_thirdparty/tomcat/webapps/ca-nim- > > > sm/WEB-INF/data/nim-sm-customizations.mv.db". Possible solution: > > > use the recovery tool [90030-224] > > > > > > I saw an article saying the below root cause but in our case this > > > might not be the issue: > > > > > > The error indicates that a database corruption has occurred in > > > the H2 database. This can happen for different reasons such as > > > disk space limitations or an abrupt server shutdown. > > > > > > Also saw a comment saying that it is a checksum issue. > > > > > > We are unable to determine the root cause for this issue as it is > > > an intermittent issue at our end so could anyone please provide > > > some insights on this issue? Any help on this will be highly > > > appreciated!!! > > > > > > Thanks, > > > Balamurali > > This electronic communication and the information and any files > transmitted with it, or attached to it, are confidential and are > intended solely for the use of the individual or entity to whom it is > addressed and may contain information that is confidential, legally > privileged, protected by privacy laws, or otherwise restricted from > disclosure to anyone else. If you are not the intended recipient or > the person responsible for delivering the e-mail to the intended > recipient, you are hereby notified that any use, copying, > distributing, dissemination, forwarding, printing, or copying of this > e-mail is strictly prohibited. If you received this e-mail in error, > please return the e-mail to the sender, delete it from your computer, > and destroy any printed copy of it. > -- > 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 view this discussion visit > https://groups.google.com/d/msgid/h2-database/CAG6_yCDJc8cnz1%3D7PbcAL7pfGv-BQgAL9C-wq6ECOyNDBhgM4w%40mail.gmail.com > [1]. [1] https://groups.google.com/d/msgid/h2-database/CAG6_yCDJc8cnz1%3D7PbcAL7pfGv-BQgAL9C-wq6ECOyNDBhgM4w%40mail.gmail.com https://groups.google.com/d/msgid/h2-database/CAG6_yCDJc8cnz1%3D7PbcAL7pfGv-BQgAL9C-wq6ECOyNDBhgM4w%40mail.gmail.com?utm_medium=email&utm_source=footer -- 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 view this discussion visit https://groups.google.com/d/msgid/h2-database/bd73f5d3e8fc6e7e2523a4ac769020c2edce1bcb.camel%40manticore-projects.com.
