注册

x86服务器-正常连接DM8,频繁操作一个功能时,对应的一个sq了查询会偶发性的报错: dm.jdbc.driver.DMException: Communication error

Learner2090 2023/10/17 1054 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8 -开发版本
【操作系统】: Utuntu20.10
【CPU】: 16核- i7-10700 CPU @ 2.90GHz
【问题描述】*: 正常连接DM8,频繁操作一个功能时,对应的一个sq了查询会偶发性的报错,错误日志如下:

15:02:14,195 ERROR [http-nio-16105-exec-9] base.controller.RestExceptionHandler - [TID: N/A] - 服务器出现未知异常

org.springframework.dao.DataAccessResourceFailureException:

Error querying database. Cause: dm.jdbc.driver.DMException: Communication error

The error may exist in darwin/ordovician/file/management/starter/dao/FileInfoMapper.java (best guess)

The error may involve darwin.ordovician.file.management.starter.dao.FileInfoMapper.selectBatchIds

The error occurred while executing a query

SQL: SELECT id,bucket_name,access_path,thumb_file_key,thumb_access_path,is_logic_file AS logicFile,file_category,file_type,is_valid AS valid,is_finished AS finished,create_time,update_time,backup_status,backup_time,parent_id,md5_digest,size,file_key,name,suffix FROM file_info WHERE id IN ( ? )

Cause: dm.jdbc.driver.DMException: Communication error

; Communication error; nested exception is dm.jdbc.driver.DMException: Communication error

    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107) ~[spring-jdbc-5.3.23.jar!/:5.3.23]

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.23.jar!/:5.3.23]

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-5.3.23.jar!/:5.3.23]

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-5.3.23.jar!/:5.3.23]

    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) ~[mybatis-spring-2.0.5.jar!/:2.0.5]

    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) ~[mybatis-spring-2.0.5.jar!/:2.0.5]

    at com.sun.proxy.$Proxy150.selectList(Unknown Source) ~[?:?]

    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223) ~[mybatis-spring-2.0.5.jar!/:2.0.5]

    at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:173) ~[mybatis-plus-core-3.4.1.jar!/:3.4.1]

    at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78) ~[mybatis-plus-core-3.4.1.jar!/:3.4.1]

    at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.1.jar!/:3.4.1]

    at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.1.jar!/:3.4.1]

    at com.sun.proxy.$Proxy160.selectBatchIds(Unknown Source) ~[?:?]

    at sun.reflect.GeneratedMethodAccessor317.invoke(Unknown Source) ~[?:?]

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_201]

    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_201]

    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.3.23.jar!/:5.3.23]

    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.3.23.jar!/:5.3.23]

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.23.jar!/:5.3.23]

    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.23.jar!/:5.3.23]

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.23.jar!/:5.3.23]

    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) ~[spring-aop-5.3.23.jar!/:5.3.23]

    at com.sun.proxy.$Proxy161.selectBatchIds(Unknown Source) ~[?:?]

    at com.baomidou.mybatisplus.extension.service.IService.listByIds(IService.java:210) ~[mybatis-plus-extension-3.4.1.jar!/:3.4.1]

    at com.baomidou.mybatisplus.extension.service.IService$$FastClassBySpringCGLIB$$f8525d18.invoke(<generated>) ~[mybatis-plus-extension-3.4.1.jar!/:3.4.1]

    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.23.jar!/:5.3.23]

    at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386) ~[spring-aop-5.3.23.jar!/:5.3.23]

    at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85) ~[spring-aop-5.3.23.jar!/:5.3.23]

    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704) ~[spring-aop-5.3.23.jar!/:5.3.23]

。。。。
Caused by: dm.jdbc.driver.DMException: Communication error

    at dm.jdbc.driver.DBError.throwException(DBError.java:759) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.b.a.a(DBAccess.java:235) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.b.a.a(DBAccess.java:690) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(DmdbPreparedStatement.java:267) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbPreparedStatement.allocateHandle(DmdbPreparedStatement.java:224) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:126) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:176) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:712) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:698) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbConnection.prepareStatement(DmdbConnection.java:1317) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337) ~[HikariCP-4.0.3.jar!/:?]

    at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) ~[HikariCP-4.0.3.jar!/:?]

    at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86) ~[mybatis-3.5.6.jar!/:3.5.6]

    ... 90 more

Caused by: java.net.SocketTimeoutException: Read timed out

    at java.net.SocketInputStream.socketRead0(Native Method) ~[?:1.8.0_201]

    at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) ~[?:1.8.0_201]

    at java.net.SocketInputStream.read(SocketInputStream.java:171) ~[?:1.8.0_201]

    at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[?:1.8.0_201]

    at dm.jdbc.b.a.c.a(ByteArrayNode.java:129) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.b.a.a.a(Buffer.java:365) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.b.a.e(DBAccess.java:315) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.b.a.a(DBAccess.java:225) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.b.a.a(DBAccess.java:690) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(DmdbPreparedStatement.java:267) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbPreparedStatement.allocateHandle(DmdbPreparedStatement.java:224) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]

    at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:126) ~[DmJdbcDriver18-8.1.2.141.jar!/:?]
回答 0
暂无回答
扫一扫
联系客服