为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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:
; 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!/:?]
追加问题描述: 我换了一个环境,dm8数据库部署在独立的服务器上,问题不再复现, 这个错和 服务器 资源紧张有关系吗?

服务器日志,同一分钟能只能看到这些,没有对应错误的日志:
我现在看的日志目录是:/opt/dmdbms/log,有其它地方可以 看到这一报错时刻 dm服务器对应的错误日志吗?