物联网，设备通过Mqtt上传数据无法写入时序数据库

Blade 未结

关注举报

 1  10

wisedata 剑侠 5小时前

一、该问题的重现步骤是什么？

1. 多次尝试重新发布物模型，且超级表确实创建了

2. 使用设备模拟器发送属性上报消息

3. 消息上传并不会报错，但 server后台报错：

ladex-iot-server | 2026-04-13 18:11:55.970 ERROR 13 --- [ XNIO-1 task-4] o.s.i.t.tdengine.dao.TDEngineTemplate : TdEngine getCountBySql error 请检查产品物模型是否发布, sql:SELECT COUNT(*)

bladex-iot-server | FROM `device_property_jkerjk97oub_bg6tb5vdls4d05gz`

bladex-iot-server | WHERE 1 = 1

bladex-iot-server |

bladex-iot-server | org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT COUNT(*)

bladex-iot-server | FROM `device_property_jkerjk97oub_bg6tb5vdls4d05gz`

bladex-iot-server | WHERE 1 = 1]; SQL state []; error code [9731]; TDengine ERROR (0x2603): sql: SELECT COUNT(*)

bladex-iot-server | FROM `device_property_jkerjk97oub_bg6tb5vdls4d05gz`

bladex-iot-server | WHERE 1 = 1, desc: Fail to get table info, error: Table does not exist

bladex-iot-server | at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1557)

bladex-iot-server | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)

bladex-iot-server | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:476)

bladex-iot-server | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:486)

bladex-iot-server | at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:519)

bladex-iot-server | at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:526)

bladex-iot-server | at org.springblade.iot.tsdb.tdengine.dao.TDEngineTemplate.getCountBySql(TDEngineTemplate.java:306)

bladex-iot-server | at org.springblade.iot.tsdb.tdengine.dao.TDEngineTemplate.getPageBySql(TDEngineTemplate.java:279)

bladex-iot-server | at org.springblade.iot.tsdb.tdengine.dao.TDEngineTemplate.getDevicePageBySql(TDEngineTemplate.java:391)

bladex-iot-server | at org.springblade.iot.tsdb.tdengine.impl.DeviceDataServiceImpl.getDevicePropertyPage(DeviceDataServiceImpl.java:143)

bladex-iot-server | at org.springblade.iot.device.service.impl.DeviceSequenceServiceImpl.getDevicePropertyPage(DeviceSequenceServiceImpl.java:86)

bladex-iot-server | at org.springblade.iot.device.controller.DeviceSequenceController.propertyHistory(DeviceSequenceController.java:90)

bladex-iot-server | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

bladex-iot-server | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

bladex-iot-server | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

bladex-iot-server | at java.base/java.lang.reflect.Method.invoke(Method.java:569)

bladex-iot-server | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360)

bladex-iot-server | at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)

bladex-iot-server | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

bladex-iot-server | at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:174)

bladex-iot-server | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)

bladex-iot-server | at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728)

bladex-iot-server | at org.springblade.iot.device.controller.DeviceSequenceController$$SpringCGLIB$$0.propertyHistory(<generated>)

bladex-iot-server | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

bladex-iot-server | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

bladex-iot-server | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

bladex-iot-server | at java.base/java.lang.reflect.Method.invoke(Method.java:569)

bladex-iot-server | at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:258)

bladex-iot-server | at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:191)

bladex-iot-server | at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)

bladex-iot-server | at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:991)

bladex-iot-server | at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:896)

bladex-iot-server | at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

bladex-iot-server | at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)

bladex-iot-server | at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)

bladex-iot-server | at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)

bladex-iot-server | at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)

bladex-iot-server | at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:633)

bladex-iot-server | at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)

bladex-iot-server | at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:723)

bladex-iot-server | at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)

bladex-iot-server | at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)

bladex-iot-server | at org.springblade.core.tool.request.BladeRequestFilter.doFilter(BladeRequestFilter.java:94)