Success Metric dashboard error after update

Hello,

I have updated recently updated from version 150 to 161 and one of my Success Metric dashboard is in error, I have tried to delete it (via api), but I received an error. I can’t access it via the interface and the error message doesn’t give me any clue on how to solve it :

Where is located the detailed error log (I’m deploying Lifecycle on Kubernetes and I can access the pod) ? Is that a known issue and how can I solve it ?

Thanks for your help.

best regards

I just found out this log which is linked to the error screen above.

2023-05-25 07:46:48,978+0000 ERROR [dw-423 - GET /rest/successMetrics/report/3aff940b67e548cc81d93c0a55a9e42a/chartData?timestamp=1685000808899] admin com.sonatype.insight.jaxrs.error.ErrorResponseGenerator - 500 A query statement timeout has occurred. (ID 3a27513a48624703)
org.apache.openjpa.persistence.PersistenceException: A query statement timeout has occurred.
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5323)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:330)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:123)
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:59)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1118)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1076)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:998)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1077)
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:305)
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2537)
at org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:298)
at org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObject(InstanceResultObjectProvider.java:60)
at org.apache.openjpa.lib.rop.EagerResultList.(EagerResultList.java:38)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:343)
at com.sonatype.insight.dataaccess.AbstractDAO$Query.get(AbstractDAO.java:65)
at com.sonatype.insight.dataaccess.AbstractDAO.get(AbstractDAO.java:199)
at com.sonatype.insight.dataaccess.AbstractDAO.get(AbstractDAO.java:195)
at com.sonatype.insight.brain.dataaccess.successmetrics.SuccessMetricsReportDataDAO.getById(SuccessMetricsReportDataDAO.java:22)
at com.sonatype.insight.brain.dataaccess.successmetrics.SuccessMetricsReportDataDAO.getById(SuccessMetricsReportDataDAO.java:15)
at com.sonatype.insight.dataaccess.AbstractDAO.getById(AbstractDAO.java:121)
at com.sonatype.insight.brain.successmetrics.SuccessMetricsReportDataService.getChartData(SuccessMetricsReportDataService.java:130)
at com.sonatype.insight.brain.successmetrics.SuccessMetricsReportResource.getChartData(SuccessMetricsReportResource.java:86)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:134)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:177)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:81)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:478)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:400)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:256)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:235)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:358)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:311)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1656)
at io.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:35)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at io.dropwizard.jersey.filter.AllowedMethodsFilter.handle(AllowedMethodsFilter.java:47)
at io.dropwizard.jersey.filter.AllowedMethodsFilter.doFilter(AllowedMethodsFilter.java:41)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at com.sonatype.insight.brain.service.CspFrameHeaderFilter.doFilter(CspFrameHeaderFilter.java:46)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at com.sonatype.insight.brain.security.AuthenticationLoggingFilter.doFilter(AuthenticationLoggingFilter.java:57)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at com.sonatype.insight.brain.security.SessionExpirationCookieFilter.doFilterInternal(SessionExpirationCookieFilter.java:54)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:147)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at com.sonatype.insight.brain.security.ClientIPAddressFilter.doFilter(ClientIPAddressFilter.java:86)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:458)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:373)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:370)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at com.sonatype.insight.brain.security.ContentTypeOptionsHeaderFilter.doFilter(ContentTypeOptionsHeaderFilter.java:41)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at com.sonatype.insight.brain.security.HttpHeaderValidatorFilter.doFilter(HttpHeaderValidatorFilter.java:75)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at com.sonatype.insight.brain.audit.AuditFilter.doFilter(AuditFilter.java:91)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at com.sonatype.insight.brain.service.BaseUrlFilter.doFilter(BaseUrlFilter.java:40)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at com.sonatype.insight.brain.service.ServerHeaderFilter.doFilter(ServerHeaderFilter.java:45)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at org.eclipse.jetty.servlets.HeaderFilter.doFilter(HeaderFilter.java:117)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:552)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:505)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at com.codahale.metrics.jetty9.InstrumentedHandler.handle(InstrumentedHandler.java:315)
at io.dropwizard.jetty.RoutingHandler.handle(RoutingHandler.java:52)
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:772)
at io.dropwizard.jetty.ZipExceptionHandlingGzipHandler.handle(ZipExceptionHandlingGzipHandler.java:26)
at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:54)
at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:181)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.lang.Thread.run(Thread.java:750)
Suppressed: org.apache.openjpa.persistence.PersistenceException: A query statement timeout has occurred.
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5323)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:708)
at org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:129)
at org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:82)
at org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:3278)
at org.apache.openjpa.kernel.StateManagerImpl.load(StateManagerImpl.java:452)
at org.apache.openjpa.kernel.DetachManager.preDetach(DetachManager.java:167)
at org.apache.openjpa.kernel.DetachManager.detachInternal(DetachManager.java:450)
at org.apache.openjpa.kernel.DetachManager.detachAll(DetachManager.java:333)
at org.apache.openjpa.kernel.BrokerImpl.detachAllInternal(BrokerImpl.java:3608)
at org.apache.openjpa.kernel.BrokerImpl.free(BrokerImpl.java:4579)
at org.apache.openjpa.kernel.BrokerImpl.close(BrokerImpl.java:4566)
at org.apache.openjpa.kernel.DelegatingBroker.close(DelegatingBroker.java:1508)
at org.apache.openjpa.persistence.EntityManagerImpl.close(EntityManagerImpl.java:1598)
at com.sonatype.insight.dataaccess.TransactionContext.close(TransactionContext.java:67)
at com.sonatype.insight.dataaccess.AbstractDAO.getById(AbstractDAO.java:120)
… 138 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: “java.io.IOException: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: “”[70] stream data key:95 pos:11 remaining:0"”. Possible solution: use the recovery tool; SQL statement:
SELECT COMPRESSED, DATA FROM INFORMATION_SCHEMA.LOB_DATA WHERE BLOCK = ? [90030-196]“; “lob: null table: -3 id: 144” [90031-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convertIOException(DbException.java:330)
at org.h2.value.ValueLobDb.getString(ValueLobDb.java:296)
at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:296)
at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:888)
at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:888)
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getString(DelegatingResultSet.java:128)
at org.apache.openjpa.jdbc.sql.DBDictionary.getString(DBDictionary.java:1056)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getStringInternal(ResultSetResult.java:556)
at org.apache.openjpa.jdbc.sql.AbstractResult.getString(AbstractResult.java:910)
at org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy.load(StringFieldStrategy.java:170)
at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:961)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1157)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1103)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:686)
… 152 common frames omitted
Caused by: java.io.IOException: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: “[70] stream data key:95 pos:11 remaining:0”. Possible solution: use the recovery tool; SQL statement:
SELECT COMPRESSED, DATA FROM INFORMATION_SCHEMA.LOB_DATA WHERE BLOCK = ? [90030-196]
at org.h2.message.DbException.convertToIOException(DbException.java:364)
at org.h2.store.LobStorageBackend$LobInputStream.fillBuffer(LobStorageBackend.java:810)
at org.h2.store.LobStorageBackend$LobInputStream.readFully(LobStorageBackend.java:779)
at org.h2.store.LobStorageBackend$LobInputStream.read(LobStorageBackend.java:770)
at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:284)
at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:326)
at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:178)
at java.io.InputStreamReader.read(InputStreamReader.java:184)
at java.io.BufferedReader.fill(BufferedReader.java:161)
at java.io.BufferedReader.read1(BufferedReader.java:212)
at java.io.BufferedReader.read(BufferedReader.java:286)
at org.h2.util.IOUtils.copyAndCloseInput(IOUtils.java:216)
at org.h2.util.IOUtils.readStringAndClose(IOUtils.java:323)
at org.h2.value.ValueLobDb.getString(ValueLobDb.java:286)
… 164 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: “[70] stream data key:95 pos:11 remaining:0”. Possible solution: use the recovery tool; SQL statement:
SELECT COMPRESSED, DATA FROM INFORMATION_SCHEMA.LOB_DATA WHERE BLOCK = ? [90030-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.index.PageDataIndex.getPageOverflow(PageDataIndex.java:220)
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:348)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:101)
at org.h2.index.PageDataCursor.next(PageDataCursor.java:52)
at org.h2.index.IndexCursor.next(IndexCursor.java:305)
at org.h2.table.TableFilter.next(TableFilter.java:499)
at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:519)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111)
at org.h2.store.LobStorageBackend.readBlock(LobStorageBackend.java:227)
at org.h2.store.LobStorageBackend$LobInputStream.fillBuffer(LobStorageBackend.java:806)
… 176 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: “java.io.IOException: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: “”[70] stream data key:95 pos:11 remaining:0"”. Possible solution: use the recovery tool; SQL statement:
SELECT COMPRESSED, DATA FROM INFORMATION_SCHEMA.LOB_DATA WHERE BLOCK = ? [90030-196]”; “lob: null table: -3 id: 143” [90031-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convertIOException(DbException.java:330)
at org.h2.value.ValueLobDb.getString(ValueLobDb.java:296)
at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:296)
at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:888)
at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:888)
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getString(DelegatingResultSet.java:128)
at org.apache.openjpa.jdbc.sql.DBDictionary.getString(DBDictionary.java:1056)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getStringInternal(ResultSetResult.java:556)
at org.apache.openjpa.jdbc.sql.AbstractResult.getString(AbstractResult.java:910)
at org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy.load(StringFieldStrategy.java:170)
at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:961)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1157)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1103)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:430)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:325)
… 163 common frames omitted
Caused by: java.io.IOException: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: “[70] stream data key:95 pos:11 remaining:0”. Possible solution: use the recovery tool; SQL statement:
SELECT COMPRESSED, DATA FROM INFORMATION_SCHEMA.LOB_DATA WHERE BLOCK = ? [90030-196]
at org.h2.message.DbException.convertToIOException(DbException.java:364)
at org.h2.store.LobStorageBackend$LobInputStream.fillBuffer(LobStorageBackend.java:810)
at org.h2.store.LobStorageBackend$LobInputStream.readFully(LobStorageBackend.java:779)
at org.h2.store.LobStorageBackend$LobInputStream.read(LobStorageBackend.java:770)
at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:284)
at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:326)
at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:178)
at java.io.InputStreamReader.read(InputStreamReader.java:184)
at java.io.BufferedReader.fill(BufferedReader.java:161)
at java.io.BufferedReader.read1(BufferedReader.java:212)
at java.io.BufferedReader.read(BufferedReader.java:286)
at org.h2.util.IOUtils.copyAndCloseInput(IOUtils.java:216)
at org.h2.util.IOUtils.readStringAndClose(IOUtils.java:323)
at org.h2.value.ValueLobDb.getString(ValueLobDb.java:286)
… 176 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: “[70] stream data key:95 pos:11 remaining:0”. Possible solution: use the recovery tool; SQL statement:
SELECT COMPRESSED, DATA FROM INFORMATION_SCHEMA.LOB_DATA WHERE BLOCK = ? [90030-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.index.PageDataIndex.getPageOverflow(PageDataIndex.java:220)
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:348)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:101)
at org.h2.index.PageDataCursor.next(PageDataCursor.java:52)
at org.h2.index.IndexCursor.next(IndexCursor.java:305)
at org.h2.table.TableFilter.next(TableFilter.java:499)
at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:519)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111)
at org.h2.store.LobStorageBackend.readBlock(LobStorageBackend.java:227)
at org.h2.store.LobStorageBackend$LobInputStream.fillBuffer(LobStorageBackend.java:806)
… 188 common frames omitted

The database is corrupted. Please use our customer support system at https://support.sonatype.com to get help with this.

Rich

thanks for the advice