注册

在应用系统查询表数据,然后导出数据时提示“无效的页”

超越梦想 2025/01/03 475 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:V8.1
【操作系统】:银河麒麟V10
【CPU】:ARM
【问题描述】*:在数据导出(数据量超过10万)导出报错,查看日志有“无效的页”报错。在达梦在线服务平台咨询后,按照排查思路去排查v$runtime_err_history视图和在数据库执行报错的sql,客户端语句执行未报错,同时v$runtime_err_history视图无对应时间段的有效信息。
同时,另外新建测试库,将表和表数据迁移过来,再次导出正常,可以排除表结构和数据问题。
麻烦各位专家大佬协助排查“无效的页”报错问题
日志如下:
2024-11-25 10:49:51,040 INFO [StateUpdate-pool-1-thread-1] - Update progress {"exportCount":175327,"finishCount":119708,"imageTask":false,"taskId":22990,"taskStateEnum":"RUNNING"} [cn.com.egova.export.service.impl.LocalExportTaskManagerImpl.updateProgress:142]
2024-11-25 10:49:52,857 INFO [AsyncResolver-bootstrap-executor-0] - Resolving eureka endpoints via configuration [com.netflix.discovery.shared.resolver.aws.ConfigClusterResolver.getClusterEndpoints:43]
2024-11-25 10:49:54,045 INFO [StateUpdate-pool-1-thread-1] - Update progress {"exportCount":175327,"finishCount":122608,"imageTask":false,"taskId":22990,"taskStateEnum":"RUNNING"} [cn.com.egova.export.service.impl.LocalExportTaskManagerImpl.updateProgress:142]
2024-11-25 10:49:57,048 INFO [StateUpdate-pool-1-thread-1] - Update progress {"exportCount":175327,"finishCount":125585,"imageTask":false,"taskId":22990,"taskStateEnum":"RUNNING"} [cn.com.egova.export.service.impl.LocalExportTaskManagerImpl.updateProgress:142]
2024-11-25 10:50:00,050 INFO [StateUpdate-pool-1-thread-1] - Update progress {"exportCount":175327,"finishCount":128416,"imageTask":false,"taskId":22990,"taskStateEnum":"RUNNING"} [cn.com.egova.export.service.impl.LocalExportTaskManagerImpl.updateProgress:142]
2024-11-25 10:50:03,054 INFO [StateUpdate-pool-1-thread-1] - Update progress {"exportCount":175327,"finishCount":131715,"imageTask":false,"taskId":22990,"taskStateEnum":"RUNNING"} [cn.com.egova.export.service.impl.LocalExportTaskManagerImpl.updateProgress:142]
2024-11-25 10:50:06,058 INFO [StateUpdate-pool-1-thread-1] - Update progress {"exportCount":175327,"finishCount":135849,"imageTask":false,"taskId":22990,"taskStateEnum":"RUNNING"} [cn.com.egova.export.service.impl.LocalExportTaskManagerImpl.updateProgress:142]
2024-11-25 10:50:07,618 ERROR [egova-export-common-0] dm.jdbc.driver.DMException: 无效的页
at dm.jdbc.driver.DBError.throwException(SourceFile:738)
at dm.jdbc.a.a.y.r(SourceFile:623)
at dm.jdbc.a.a.y.z(SourceFile:555)
at dm.jdbc.a.a.y.L(SourceFile:536)
at dm.jdbc.a.a.a(SourceFile:269)
at dm.jdbc.a.a.a(SourceFile:1327)
at dm.jdbc.internal.AbstractLob.do_length(SourceFile:211)
at dm.jdbc.driver.DmdbClob.loadAllData(SourceFile:376)
at dm.jdbc.driver.DmdbClob.<init>(SourceFile:58)
at dm.jdbc.driver.DmdbClob.newInstance(SourceFile:82)
at dm.jdbc.internal.convert.DB2J.toString(SourceFile:127)
at dm.jdbc.driver.DmdbResultSet.do_getString(SourceFile:701)
at dm.jdbc.filter.BaseFilter.ResultSet_getString(SourceFile:5571)
at dm.jdbc.filter.reconnect.ReconnectFilter.ResultSet_getString(SourceFile:6933)
at dm.jdbc.driver.DmdbResultSet.getString(SourceFile:2203)
at com.zaxxer.hikari.pool.HikariProxyResultSet.getString(HikariProxyResultSet.java)
at cn.com.egova.export.bean.SQLMetaData.getOneRow(SQLMetaData.java:67)
at cn.com.egova.export.core.generator.CursorSXSSExcelGenerator.cursorExport(CursorSXSSExcelGenerator.java:225)
at cn.com.egova.export.core.generator.CursorSXSSExcelGenerator.generate(CursorSXSSExcelGenerator.java:106)
at cn.com.egova.export.core.Exporter.export(Exporter.java:29)
at cn.com.egova.export.service.impl.ExportCoreManagerImpl.cursorQuery(ExportCoreManagerImpl.java:178)
at cn.com.egova.export.service.impl.ExportCoreManagerImpl.doExport(ExportCoreManagerImpl.java:102)
at cn.com.egova.export.service.impl.ExportCoreManagerImpl$$FastClassBySpringCGLIB$$a9843e79.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
at cn.com.egova.export.service.impl.ExportCoreManagerImpl$$EnhancerBySpringCGLIB$$75129ad6.doExport(<generated>)
at cn.com.egova.export.util.ExportTaskExecutor$1.run(ExportTaskExecutor.java:117)
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)

  • 流式查询异常 [cn.com.egova.export.core.generator.CursorSXSSExcelGenerator.cursorExport:366]
    2024-11-25 10:50:07,629 ERROR [egova-export-common-0] dm.jdbc.driver.DMException: 无效的页
    at dm.jdbc.driver.DBError.throwException(SourceFile:738)
    at dm.jdbc.a.a.y.r(SourceFile:623)
    at dm.jdbc.a.a.y.z(SourceFile:555)
    at dm.jdbc.a.a.y.L(SourceFile:536)
    at dm.jdbc.a.a.a(SourceFile:269)
    at dm.jdbc.a.a.a(SourceFile:1327)
    at dm.jdbc.internal.AbstractLob.do_length(SourceFile:211)
    at dm.jdbc.driver.DmdbClob.loadAllData(SourceFile:376)
    at dm.jdbc.driver.DmdbClob.<init>(SourceFile:58)
    at dm.jdbc.driver.DmdbClob.newInstance(SourceFile:82)
    at dm.jdbc.internal.convert.DB2J.toString(SourceFile:127)
    at dm.jdbc.driver.DmdbResultSet.do_getString(SourceFile:701)
    at dm.jdbc.filter.BaseFilter.ResultSet_getString(SourceFile:5571)
    at dm.jdbc.filter.reconnect.ReconnectFilter.ResultSet_getString(SourceFile:6933)
    at dm.jdbc.driver.DmdbResultSet.getString(SourceFile:2203)
    at com.zaxxer.hikari.pool.HikariProxyResultSet.getString(HikariProxyResultSet.java)
    at cn.com.egova.export.bean.SQLMetaData.getOneRow(SQLMetaData.java:67)
    at cn.com.egova.export.core.generator.CursorSXSSExcelGenerator.cursorExport(CursorSXSSExcelGenerator.java:225)
    at cn.com.egova.export.core.generator.CursorSXSSExcelGenerator.generate(CursorSXSSExcelGenerator.java:106)
    at cn.com.egova.export.core.Exporter.export(Exporter.java:29)
    at cn.com.egova.export.service.impl.ExportCoreManagerImpl.cursorQuery(ExportCoreManagerImpl.java:178)
    at cn.com.egova.export.service.impl.ExportCoreManagerImpl.doExport(ExportCoreManagerImpl.java:102)
    at cn.com.egova.export.service.impl.ExportCoreManagerImpl$$FastClassBySpringCGLIB$$a9843e79.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
    at cn.com.egova.export.service.impl.ExportCoreManagerImpl$$EnhancerBySpringCGLIB$$75129ad6.doExport(<generated>)
    at cn.com.egova.export.util.ExportTaskExecutor$1.run(ExportTaskExecutor.java:117)
    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)
  • 导出失败 [cn.com.egova.export.service.impl.ExportCoreManagerImpl.doExport:115]
回答 0
暂无回答
扫一扫
联系客服