Seeing multiple DB corruptions in the field with the following stack trace.
In addition, the maindb.trace.db is logging enormous quantities of writes
unbounded and is filling up the disk. I thought that this file was limited
to 16MB in size as the default behavior, why is it growing unbounded?
Every 2 hours a "shutdown" command is executed which allows a compaction
cycle to run. We suspect that the corruption is happening during the
compaction operation. This behavior did not occur with previous versions
of the DB.
2019-04-18 18:53:21 database: opening /maindb
org.h2.message.DbException: IO Exception: null [90028-198]
at org.h2.message.DbException.get(DbException.java:194)
at
org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:197)
at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:173)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:95)
at org.h2.engine.Database.getPageStore(Database.java:2740)
at org.h2.engine.Database.open(Database.java:769)
at org.h2.engine.Database.openDatabase(Database.java:319)
at org.h2.engine.Database.<init>(Database.java:313)
at org.h2.engine.Engine.openSession(Engine.java:69)
at org.h2.engine.Engine.openSession(Engine.java:201)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:178)
at org.h2.engine.Engine.createSession(Engine.java:161)
at org.h2.engine.Engine.createSession(Engine.java:31)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:336)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:124)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:103)
at org.h2.Driver.connect(Driver.java:69)
at
org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:189)
at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:352)
at
org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:384)
at
org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:234)
at
org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199)
at
com.ni.eseries.aa.devicemgt.datamgr.rdms.DBManager.getConnection(DBManager.java:453)
at
com.ni.eseries.aa.devicemgt.datamgr.H2DataManager.findLastId(H2DataManager.java:606)
at
com.ni.eseries.aa.devicemgt.datamgr.H2DataManager.findLastId(H2DataManager.java:599)
at
com.ni.eseries.aa.devicemgt.distlogger.NetworkLoggerService.persistLogMessage(NetworkLoggerService.java:263)
at
com.ni.eseries.aa.devicemgt.distlogger.NetworkLoggerService.lambda$processLoggerMessage$75(NetworkLoggerService.java:240)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: IO Exception: null
[90028-198]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
... 34 more
Caused by: java.lang.IllegalStateException: Reading from nio:/maindb.mv.db
failed; file length 645287936 read length 1536 at 668681732 [1.4.198/1]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:883)
at org.h2.mvstore.DataUtils.readFully(DataUtils.java:420)
at org.h2.mvstore.FileStore.readFully(FileStore.java:98)
at org.h2.mvstore.MVStore.readBufferForPage(MVStore.java:1048)
at org.h2.mvstore.MVStore.readPage(MVStore.java:2186)
at org.h2.mvstore.MVMap.readPage(MVMap.java:554)
at org.h2.mvstore.Page$NonLeaf.getChildPage(Page.java:1086)
at org.h2.mvstore.Cursor.hasNext(Cursor.java:53)
at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:793)
at org.h2.mvstore.MVStore.<init>(MVStore.java:401)
at org.h2.mvstore.MVStore$Builder.open(MVStore.java:3343)
at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:162)
... 31 more
Caused by: java.io.EOFException
at org.h2.mvstore.DataUtils.readFully(DataUtils.java:408)
... 41 more
--
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.
