一、该问题的重现步骤是什么?
设备数据已经通过Node-Red发布到了MQTT中如下图:
2. 涛思时序库中已有创建表,如下如:
3. 设备日志中查询没有,如下图:
二、你期待的结果是什么?实际看到的又是什么?
三、你正在使用的是什么产品,什么版本?在什么操作系统上?
四、请提供详细的错误堆栈信息,这很重要。
五、若有更多详细信息,请在下面提供。
后台报错:
这个表需要手动创建吗?
看一下对应的产品物模型有没有提前做发布的操作
已确认做了【发布上线】,但依然出现找不到表的错误
2025-07-08 16:57:42.083 DEBUG 28876 --- [ biz-worker-10] o.s.i.b.l.l.BladeMqttMessageListener : clientId:erabydau6tc2 topic:/blade/sys/KONz2t2KfAP9/erabydau6tc2/thing/event/property/post payload:{"id":1751965062082,"version":"1.0","params":{"PointX":64,"PointY":14,"PointZ":1,"Status":1}}
2025-07-08 16:57:42.083 DEBUG 28876 --- [ biz-worker-10] o.s.i.b.l.listener.MqttMessageListener : clientId:erabydau6tc2 username:erabydau6tc2&KONz2t2KfAP9 ip:127.0.0.1 port:64606
2025-07-08 16:57:42.086 DEBUG 28876 --- [ biz-worker-17] o.s.i.b.l.l.BladeMqttMessageListener : clientId:PkycjuAnYw3vT9RP topic:/blade/sys/lZEFnnW9In8Y/EmfYjwv2d0v6lFJQ/thing/event/property/post payload:{"id":1751965062085,"version":"1.0","params":{"PointX":91,"PointY":29,"PointZ":74,"Status":21}}
2025-07-08 16:57:42.086 DEBUG 28876 --- [ biz-worker-17] o.s.i.b.l.listener.MqttMessageListener : clientId:PkycjuAnYw3vT9RP username:PkycjuAnYw3vT9RP&KONz2t2KfAP9 ip:127.0.0.1 port:64607
2025-07-08 16:57:42.319 ERROR 28876 --- [pool-3-thread-1] o.s.iot.core.task.BaseBatchTask : 批量消费失败,数据可能会丢失
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `device_logger_konz2t2kfap9_erabydau6tc2` USING `device_logger` TAGS ('KONz2t2KfAP9', 'erabydau6tc2') (`time`, `topic`, `message`) VALUES (?, ?, ?) `device_property_konz2t2kfap9_erabydau6tc2` USING `device_property_konz2t2kfap9` TAGS ('KONz2t2KfAP9', 'erabydau6tc2') (`time`, `Status`, `PointY`, `PointX`, `PointZ`) VALUES (?, ?, ?, ?, ?) `device_logger_lzefnnw9in8y_emfyjwv2d0v6lfjq` USING `device_logger` TAGS ('lZEFnnW9In8Y', 'EmfYjwv2d0v6lFJQ') (`time`, `topic`, `message`) VALUES (?, ?, ?) `device_property_lzefnnw9in8y_emfyjwv2d0v6lfjq` USING `device_property_lzefnnw9in8y` TAGS ('lZEFnnW9In8Y', 'EmfYjwv2d0v6lFJQ') (`time`, `Status`, `PointY`, `PointX`, `PointZ`) VALUES (?, ?, ?, ?, ?);]; SQL state []; error code [9731]; TDengine ERROR (0x2603): sql: INSERT INTO `device_logger_konz2t2kfap9_erabydau6tc2` USING `device_logger` TAGS ('KONz2t2KfAP9', 'erabydau6tc2') (`time`, `topic`, `message`) VALUES (1751965062083, '/blade/sys/KONz2t2KfAP9/erabydau6tc2/thing/event/property/post', '{"id":1751965062082,"version":"1.0","params":{"PointX":64,"PointY":14,"PointZ":1,"Status":1}}') `device_property_konz2t2kfap9_erabydau6tc2` USING `device_property_konz2t2kfap9` TAGS ('KONz2t2KfAP9', 'erabydau6tc2') (`time`, `Status`, `PointY`, `PointX`, `PointZ`) VALUES (1751965062083, 1, 14, 64, 1) `device_logger_lzefnnw9in8y_emfyjwv2d0v6lfjq` USING `device_logger` TAGS ('lZEFnnW9In8Y', 'EmfYjwv2d0v6lFJQ') (`time`, `topic`, `message`) VALUES (1751965062086, '/blade/sys/lZEFnnW9In8Y/EmfYjwv2d0v6lFJQ/thing/event/property/post', '{"id":1751965062085,"version":"1.0","params":{"PointX":91,"PointY":29,"PointZ":74,"Status":21}}') `device_property_lzefnnw9in8y_emfyjwv2d0v6lfjq` USING `device_property_lzefnnw9in8y` TAGS ('lZEFnnW9In8Y', 'EmfYjwv2d0v6lFJQ') (`time`, `Status`, `PointY`, `PointX`, `PointZ`) VALUES (1751965062086, 21, 29, 91, 74);, desc: Table does not exist
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1549)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:677)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1014)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1024)
at org.springblade.iot.tsdb.tdengine.dao.TDEngineTemplate.saveBatch(TDEngineTemplate.java:108)
at org.springblade.iot.core.task.BaseBatchTask.consumerQueueData(BaseBatchTask.java:72)
at org.springblade.iot.core.task.BaseBatchTask$1.run(BaseBatchTask.java:53)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
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:842)
Caused by: java.sql.SQLException: TDengine ERROR (0x2603): sql: INSERT INTO `device_logger_konz2t2kfap9_erabydau6tc2` USING `device_logger` TAGS ('KONz2t2KfAP9', 'erabydau6tc2') (`time`, `topic`, `message`) VALUES (1751965062083, '/blade/sys/KONz2t2KfAP9/erabydau6tc2/thing/event/property/post', '{"id":1751965062082,"version":"1.0","params":{"PointX":64,"PointY":14,"PointZ":1,"Status":1}}') `device_property_konz2t2kfap9_erabydau6tc2` USING `device_property_konz2t2kfap9` TAGS ('KONz2t2KfAP9', 'erabydau6tc2') (`time`, `Status`, `PointY`, `PointX`, `PointZ`) VALUES (1751965062083, 1, 14, 64, 1) `device_logger_lzefnnw9in8y_emfyjwv2d0v6lfjq` USING `device_logger` TAGS ('lZEFnnW9In8Y', 'EmfYjwv2d0v6lFJQ') (`time`, `topic`, `message`) VALUES (1751965062086, '/blade/sys/lZEFnnW9In8Y/EmfYjwv2d0v6lFJQ/thing/event/property/post', '{"id":1751965062085,"version":"1.0","params":{"PointX":91,"PointY":29,"PointZ":74,"Status":21}}') `device_property_lzefnnw9in8y_emfyjwv2d0v6lfjq` USING `device_property_lzefnnw9in8y` TAGS ('lZEFnnW9In8Y', 'EmfYjwv2d0v6lFJQ') (`time`, `Status`, `PointY`, `PointX`, `PointZ`) VALUES (1751965062086, 21, 29, 91, 74);, desc: Table does not exist
at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:95)
at com.taosdata.jdbc.rs.RestfulStatement.execute(RestfulStatement.java:97)
at com.taosdata.jdbc.rs.RestfulStatement.execute(RestfulStatement.java:77)
at com.taosdata.jdbc.rs.RestfulStatement.executeUpdate(RestfulStatement.java:55)
at com.taosdata.jdbc.rs.RestfulPreparedStatement.executeUpdate(RestfulPreparedStatement.java:59)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:241)
at org.springframework.jdbc.core.JdbcTemplate.lambda$update$2(JdbcTemplate.java:975)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:658)
... 12 common frames omitted
录个视频,看看你怎么操作的,完整流程的视频发我们邮箱 bladejava@qq.com
或者把你部署的平台临时映射到外网发我们邮箱,我们来看一下
INSERT INTO `device_logger_konz2t2kfap9_erabydau6tc2` USING `device_logger` TAGS ('KONz2t2KfAP9', 'erabydau6tc2') (`time`, `topic`, `message`) VALUES ( 1751965062083, '/blade/sys/KONz2t2KfAP9/erabydau6tc2/thing/event/property/post', '{"id":1751965062082,"version":"1.0","params":{"PointX":64,"PointY":14,"PointZ":1,"Status":1}}' ) `device_property_konz2t2kfap9_erabydau6tc2` USING `device_property_konz2t2kfap9` TAGS ('KONz2t2KfAP9', 'erabydau6tc2') ( `time`, `Status`, `PointY`, `PointX`, `PointZ` ) VALUES (1751965062083, 1, 14, 64, 1) `device_logger_lzefnnw9in8y_emfyjwv2d0v6lfjq` USING `device_logger` TAGS ( 'lZEFnnW9In8Y', 'EmfYjwv2d0v6lFJQ' ) (`time`, `topic`, `message`) VALUES ( 1751965062086, '/blade/sys/lZEFnnW9In8Y/EmfYjwv2d0v6lFJQ/thing/event/property/post', '{"id":1751965062085,"version":"1.0","params":{"PointX":91,"PointY":29,"PointZ":74,"Status":21}}' ) `device_property_lzefnnw9in8y_emfyjwv2d0v6lfjq` USING `device_property_lzefnnw9in8y` TAGS ( 'lZEFnnW9In8Y', 'EmfYjwv2d0v6lFJQ' ) ( `time`, `Status`, `PointY`, `PointX`, `PointZ` ) VALUES (1751965062086, 21, 29, 91, 74);
设计到 2个产品物模型表,device_property_konz2t2kfap9 和 device_property_lzefnnw9in8y,检查这2个物模型是否发布。还有可以更改 TDEngineBatchTemplate 此处代码,改成 batchLogsTask,dev 分支已修复。这样日志就会和数据分开。
讨论(0)
- 热议问题
-
4.6.0bladex-boot启动差表act_ge_property
1
-
avue3 富文本上传图片
1
-
表单设计,请求地址如何动态拼接参数
2
-
项目启动相关
1
-
短信配置
1
-
springboot 通过http获取jar包内静态文件报404
1
-
更换模型APIkey不生效的问题
1
-
Blade AI 大模型接入协议
1
-
代码生成主子表有bug
1
-
你好,现在docker镜像拉不下来了, 针对bladex的部署,还能用docker吗,该怎么拉部署的镜像
1
扫一扫访问 Blade技术社区 移动端