发表新帖
发表新帖

设备日志：没有数据

Blade 未结
关注 举报
3 164
280066922@qq.co
280066922@qq.co 剑圣 2025-07-08 11:42

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

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

    image.png

    image.png

2.  涛思时序库中已有创建表，如下如：

image.png


3. 设备日志中查询没有，如下图：

image.png


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


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


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


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

3条回答
  • 280066922@qq.co
    2025-07-08 13:29

    后台报错：image.png

    image.png

    这个表需要手动创建吗？

    0 讨论(0)
  • admin - BladeX作者
    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 
  (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 分支已修复。这样日志就会和数据分开。

    image.png

    0 讨论(0)
 看不清?
提交回复
官方产品
BladeX 企业级开发平台 BladeX 可视化数据大屏
官方新品
BladeX 大模型开发平台 BladeX 物联网开发平台
热议问题
Oauth2的客户端认证：client_credentials，如何做scope限制？ 1
数据入库出现主键id重复问题 1
账号登录失败锁定时间怎么调整？？ 1
修改token有效时间 1
想所有的租户都用同一个前端，但是又不想让用户选择哪个租户，是不是可以将用户名设置唯一？ 1
MCP工具填写不可达地址后，无限重连 1
物联网平台能否支持硬件socket接入 1
MqttSenderImpl publish 方法发布消息到 kafka ，然后是怎么发送到MQTT 里面的 1
BladeX-AI 项目依赖包下载不了 1
bladex4.6.0进行信创改造 1
layui

扫一扫访问 Blade技术社区 移动端

Blade技术社区 2025 © 上海布雷德科技有限公司 沪ICP备2023009528号-1 苏公网安备 32041102000998号