查询报错TDengine ERROR (0x2350): FETCH DATA TIME OUT #32401
Description
报错
### SQL: SELECT data_log_id, org_id, area_group_id, area_group_name, project_id, device_id, project_name, device_code, device_name, sensor_id, key, name, number, name_diy, value, original_value, unit, data_time, lng, latFROMdata_log_systemWHEREproject_id= ? ANDsensor_id= ? ANDvalue!= ? ORDER BYdata_time` DESC LIMIT 10 OFFSET 0
Cause: java.sql.SQLException: TDengine ERROR (0x2350): FETCH DATA TIME OUT
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
at com.mybatisflex.core.mybatis.binding.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:146)
at com.mybatisflex.core.mybatis.binding.FlexMapperProxy.invoke(FlexMapperProxy.java:85)
at jdk.proxy2/jdk.proxy2.$Proxy104.selectListByQuery(Unknown Source)
at com.mybatisflex.core.util.MapperUtil.doPaginate(MapperUtil.java:233)
at com.mybatisflex.core.BaseMapper.paginateAs(BaseMapper.java:1158)
at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:732)
at com.mybatisflex.core.mybatis.binding.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:159)
at com.mybatisflex.core.mybatis.binding.FlexMapperProxy.invoke(FlexMapperProxy.java:85)
at jdk.proxy2/jdk.proxy2.$Proxy104.paginateAs(Unknown Source)
at com.mybatisflex.core.BaseMapper.paginate(BaseMapper.java:1082)
at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:732)
at com.mybatisflex.core.mybatis.binding.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:159)
at com.mybatisflex.core.mybatis.binding.FlexMapperProxy.invoke(FlexMapperProxy.java:85)
at jdk.proxy2/jdk.proxy2.$Proxy104.paginate(Unknown Source)
at vip.xiaonuo.common.mapper.BaseMapperX.selectPage(BaseMapperX.java:61)
at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:732)
at com.mybatisflex.core.mybatis.binding.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:159)
at com.mybatisflex.core.mybatis.binding.FlexMapperProxy.invoke(FlexMapperProxy.java:85)
at jdk.proxy2/jdk.proxy2.$Proxy104.selectPage(Unknown Source)
at vip.xiaonuo.common.mapper.BaseMapperX.selectPage(BaseMapperX.java:33)
at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:732)
at com.mybatisflex.core.mybatis.binding.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:159)
at com.mybatisflex.core.mybatis.binding.FlexMapperProxy.invoke(FlexMapperProxy.java:85)
at jdk.proxy2/jdk.proxy2.$Proxy104.selectPage(Unknown Source)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at com.mybatisflex.solon.transaction.MybatisMapperInterceptor.invoke(MybatisMapperInterceptor.java:28)
at jdk.proxy2/jdk.proxy2.$Proxy104.selectPage(Unknown Source)
at vip.xiaonuo.iot.modular.devicedatalog.service.impl.IotDeviceDataLogServiceImpl.page(IotDeviceDataLogServiceImpl.java:85)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.noear.solon.core.wrap.MethodWrap.invoke(MethodWrap.java:271)
at org.noear.solon.core.wrap.MethodWrap.doIntercept(MethodWrap.java:260)
at org.noear.solon.core.aspect.InterceptorEntity.doIntercept(InterceptorEntity.java:55)
at org.noear.solon.core.aspect.Invocation.invoke(Invocation.java:115)
at org.noear.solon.core.wrap.MethodWrap.invokeByAspect(MethodWrap.java:286)
at org.noear.solon.proxy.BeanInvocationHandler.invoke(BeanInvocationHandler.java:80)
at vip.xiaonuo.iot.modular.devicedatalog.service.impl.IotDeviceDataLogServiceImpl$$SolonAsmProxy.invokeInvocationHandler(Unknown Source)
at vip.xiaonuo.iot.modular.devicedatalog.service.impl.IotDeviceDataLogServiceImpl$$SolonAsmProxy.page(Unknown Source)
at vip.xiaonuo.iot.modular.console.controller.IotConsoleController.page(IotConsoleController.java:209)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.noear.solon.core.wrap.MethodWrap.invoke(MethodWrap.java:271)
at org.noear.solon.core.wrap.MethodWrap.doIntercept(MethodWrap.java:260)
at org.noear.solon.core.aspect.InterceptorEntity.doIntercept(InterceptorEntity.java:55)
at org.noear.solon.core.aspect.Invocation.invoke(Invocation.java:115)
at org.noear.solon.validation.BeanValidateInterceptor.doIntercept(BeanValidateInterceptor.java:33)
at org.noear.solon.core.aspect.InterceptorEntity.doIntercept(InterceptorEntity.java:55)
at org.noear.solon.core.aspect.Invocation.invoke(Invocation.java:115)
at org.noear.solon.core.wrap.MethodWrap.invokeByAspect(MethodWrap.java:286)
at org.noear.solon.core.mvc.ActionDefault.executeDo(ActionDefault.java:389)
at org.noear.solon.core.mvc.ActionDefault.invokeMethodDo(ActionDefault.java:329)
at org.noear.solon.core.mvc.ActionDefault.invokeHandleDo(ActionDefault.java:306)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:51)
at org.noear.solon.core.mvc.ActionDefault.invokeFilterDo(ActionDefault.java:298)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:51)
at org.noear.solon.validation.ContextValidateHandler.doFilter(ContextValidateHandler.java:34)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
at org.noear.solon.core.mvc.ActionDefault.invoke(ActionDefault.java:272)
at org.noear.solon.core.mvc.ActionDefault.handle(ActionDefault.java:249)
at org.noear.solon.core.route.RouterHandler.handleMain(RouterHandler.java:51)
at org.noear.solon.core.route.RouterHandler.handle1(RouterHandler.java:71)
at org.noear.solon.core.route.RouterInterceptorChainImpl.doIntercept(RouterInterceptorChainImpl.java:54)
at vip.xiaonuo.core.config.GlobalConfigure.lambda$addInterceptors$0(GlobalConfigure.java:95)
at org.noear.solon.core.route.RouterInterceptorLimiter.doIntercept(RouterInterceptorLimiter.java:63)
at org.noear.solon.core.route.RouterInterceptorChainImpl.doIntercept(RouterInterceptorChainImpl.java:52)
at cn.dev33.satoken.solon.integration.SaTokenInterceptor.doIntercept(SaTokenInterceptor.java:233)
at org.noear.solon.core.route.RouterInterceptorLimiter.doIntercept(RouterInterceptorLimiter.java:63)
at org.noear.solon.core.route.RouterInterceptorChainImpl.doIntercept(RouterInterceptorChainImpl.java:52)
at org.noear.solon.core.ChainManager.doIntercept(ChainManager.java:199)
at org.noear.solon.core.route.RouterHandler.handle(RouterHandler.java:103)
at org.noear.solon.core.handle.HandlerPipeline.handle(HandlerPipeline.java:53)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:51)
at vip.xiaonuo.ten.filter.TenantFilter.doFilter(TenantFilter.java:98)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
at vip.xiaonuo.core.handler.GlobalErrorFilter.doFilter(GlobalErrorFilter.java:23)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
at vip.xiaonuo.core.config.CorsFilter.doFilter(CorsFilter.java:15)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
at cn.dev33.satoken.solon.integration.SaFirewallCheckFilterForSolon.doFilter(SaFirewallCheckFilterForSolon.java:61)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
at cn.dev33.satoken.solon.integration.SaTokenCorsFilterForSolon.doFilter(SaTokenCorsFilterForSolon.java:49)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
at cn.dev33.satoken.solon.integration.SaTokenContextFilterForSolon.doFilter(SaTokenContextFilterForSolon.java:35)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
at org.noear.solon.logging.integration.LoggingPlugin.lambda$start$1(LoggingPlugin.java:71)
at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
at org.noear.solon.core.ChainManager.doFilter(ChainManager.java:106)
at org.noear.solon.SolonApp.tryHandle(SolonApp.java:529)
at org.noear.solon.boot.smarthttp.http.SmHttpContextHandler.handleDo(SmHttpContextHandler.java:123)
at org.noear.solon.boot.smarthttp.http.SmHttpContextHandler.handle0(SmHttpContextHandler.java:101)
at org.noear.solon.boot.smarthttp.http.SmHttpContextHandler.lambda$handle$0(SmHttpContextHandler.java:86)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.sql.SQLException: TDengine ERROR (0x2350): FETCH DATA TIME OUT
`
jdbcdriver版本
<dependency> <groupId>com.taosdata.jdbc</groupId> <artifactId>taos-jdbcdriver</artifactId> <version>3.6.3</version> </dependency>
服务器版本：3.3.6.13 Community
TDengine服务 与应用服务分别部署在不同服务器上。
控制台执行形同语句是可以正常执行的，测试项目，数据量也不大。而且写入数据、创建超级表、子表都是正常的
