注册

简单的查询报错 Communication error

phily 2024/07/08 886 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:--03134284044-20230417-187846-20040
【操作系统】:麒麟V10
【CPU】:
JDBC:8.1.3.140
【问题描述】*:使用简单的查询sql,显示Communication error
只有一张表有这个问题, 其他表都是正常,非常奇怪!

image.png

如图, 非常简单的SQL,我用disql查询没有问题,但是在程序中查询就会报错

代码也非常的简单!

image.png

其他表查询都是正常的,研究了2天了,没有头绪,求救!

附上完整报错信息

2024-07-08 17:55:55.077 [scheduling-1] INFO o.j.c.background.MerchantDriveManageController:123 - 开始同步!
2024-07-08 17:56:05.090 [scheduling-1] ERROR o.s.s.support.TaskUtils$LoggingErrorHandler:95 - Unexpected error occurred in scheduled task
org.springframework.dao.DataAccessResourceFailureException:

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

The error may exist in org/jeecg/modules/base/mapper/ProIotSmokeDeviceStatusAlarmDetailsMapper.java (best guess)

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT id, device_id, device_name, state, alarm_name, alarm_time, alarm_data, devState, org_id, org_name, manager, manager_phone, dev_addr, ar

_addr, product_name, product_no, product_id, org_addr, tag_entity, params, description, coordinate_info, dispose_update_time, bln_valid, create_by, cre
ate_time, update_by, update_time FROM pro_iot_smoke_device_status_alarm_details ORDER BY alarm_time DESC LIMIT 500

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)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy165.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy257.selectList(Unknown Source)
at com.baomidou.mybatisplus.extension.service.IService.list(IService.java:370)
at com.baomidou.mybatisplus.extension.service.IService$$FastClassBySpringCGLIB$$f8525d18.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
at org.jeecg.modules.system.service.impl.ProIotSmokeDeviceStatusAlarmDetailsServiceImpl$$EnhancerBySpringCGLIB$$3314bddd.list(<generated>)
at org.jeecg.controller.background.MerchantDriveManageController.saveOrders(MerchantDriveManageController.java:124)
at org.jeecg.controller.background.MerchantDriveManageController$$FastClassBySpringCGLIB$$ae616ccb.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
at org.jeecg.controller.background.MerchantDriveManageController$$EnhancerBySpringCGLIB$$7eecc33c.saveOrders(<generated>)
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.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
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:750)
Caused by: dm.jdbc.driver.DMException: Communication error
at dm.jdbc.driver.DBError.throwException(SourceFile:801)
at dm.jdbc.a.a.a(SourceFile:274)
at dm.jdbc.a.a.a(SourceFile:1218)
at dm.jdbc.a.a.b(SourceFile:1045)
at dm.jdbc.a.a.a(SourceFile:829)
at dm.jdbc.driver.DmdbPreparedStatement.executeInner(SourceFile:513)
at dm.jdbc.driver.DmdbPreparedStatement.do_execute(SourceFile:593)
at dm.jdbc.filter.BaseFilter.PreparedStatement_execute(SourceFile:4990)
at dm.jdbc.filter.log.LogFilter.PreparedStatement_execute(SourceFile:8092)
at dm.jdbc.driver.DmdbPreparedStatement$6.run(SourceFile:2154)
at dm.jdbc.driver.DmdbPreparedStatement$6.run(SourceFile:1)
at dm.jdbc.driver.DmdbPreparedStatement.execute(SourceFile:2166)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at sun.reflect.GeneratedMethodAccessor200.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
at com.sun.proxy.$Proxy462.query(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at sun.reflect.GeneratedMethodAccessor199.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
at com.sun.proxy.$Proxy461.query(Unknown Source)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy461.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at sun.reflect.GeneratedMethodAccessor261.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
... 38 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at dm.jdbc.util.buffer.ByteArrayNode.load(SourceFile:129)
at dm.jdbc.util.buffer.Buffer.load(SourceFile:365)
at dm.jdbc.a.c.a(SourceFile:208)
at dm.jdbc.a.a.e(SourceFile:389)
at dm.jdbc.a.a.a(SourceFile:263)
... 75 common frames omitted

回答 0
暂无回答
扫一扫
联系客服