设备日志:没有数据

Blade 未结 3 180

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

  1. 设备数据已经通过Node-Red发布到了MQTT中如下图:

    image.png

    image.png

2.  涛思时序库中已有创建表,如下如:

image.png


3. 设备日志中查询没有,如下图:

image.png


二、你期待的结果是什么?实际看到的又是什么?


三、你正在使用的是什么产品,什么版本?在什么操作系统上?


四、请提供详细的错误堆栈信息,这很重要。


五、若有更多详细信息,请在下面提供。

3条回答
  • 2025-07-08 13:29

    后台报错:image.png

    image.png

    这个表需要手动创建吗?

    0 讨论(0)
  • 2025-07-08 13:32

    看一下对应的产品物模型有没有提前做发布的操作

    CleanShot20250708133226@2x.png

    作者追问:2025-07-08 17:00

    已确认做了【发布上线】,但依然出现找不到表的错误


    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


    回答: 2025-07-08 17:18

    录个视频,看看你怎么操作的,完整流程的视频发我们邮箱 bladejava@qq.com

    回答: 2025-07-08 17:19

    或者把你部署的平台临时映射到外网发我们邮箱,我们来看一下

    0 讨论(0)
  • 2025-07-09 16:18
    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 
      (1751965062083114641`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 
      (175196506208621299174);

    设计到 2个产品物模型表,device_property_konz2t2kfap9 和 device_property_lzefnnw9in8y,检查这2个物模型是否发布。还有可以更改 TDEngineBatchTemplate  此处代码,改成 batchLogsTask,dev 分支已修复。这样日志就会和数据分开。

    image.png

    0 讨论(0)
代码语言
提交回复