blade / BladeX-Links启动问题

Blade 未结 1 24

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

  1. 启动ServerApplication、BrokerApplication、DeviceSimulatorApplication后报错日志如下,同时tdengine  的启动命令如下

docker run -d  --name tdengine  -p 6030-6049:6030-6049  -p 6030-6049:6030-6049/udp  -p 6060:6060   -v /home/tdengine/data:/var/lib/taos  -v /home/tdengine/log:/var/log/taos  tdengine/tdengine:3.3.6.9


org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO `device_event_jkerjk97oub_27oy29bmmln` USING `device_event` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `output`, `identifier`, `eventName`, `eventType`) VALUES (?, ?, ?, ?, ?) `device_command_jkerjk97oub_27oy29bmmln` USING `device_command` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `output`, `input`, `identifier`, `commandName`) VALUES (?, ?, ?, ?, ?) `device_property_jkerjk97oub_27oy29bmmln` USING `device_property_jkerjk97oub` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `LightSwitch`) VALUES (?, ?);]; SQL state []; error code [9731]; TDengine ERROR (0x2603): sql: INSERT INTO `device_event_jkerjk97oub_27oy29bmmln` USING `device_event` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `output`, `identifier`, `eventName`, `eventType`) VALUES (1765877388298, '{"BatteryLevel":20}', 'LowBatteyEvent', '电量低事件', 'alert') `device_command_jkerjk97oub_27oy29bmmln` USING `device_command` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `output`, `input`, `identifier`, `commandName`) VALUES (1765877388298, '{"RebootTime":1765872979208}', '{"RebootStatus":"true"}', 'Reboot', '重启服务') `device_property_jkerjk97oub_27oy29bmmln` USING `device_property_jkerjk97oub` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `LightSwitch`) VALUES (1765877388298, '1');, 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$$$capture(FutureTask.java:264)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java)

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_event_jkerjk97oub_27oy29bmmln` USING `device_event` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `output`, `identifier`, `eventName`, `eventType`) VALUES (1765877388298, '{"BatteryLevel":20}', 'LowBatteyEvent', '电量低事件', 'alert') `device_command_jkerjk97oub_27oy29bmmln` USING `device_command` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `output`, `input`, `identifier`, `commandName`) VALUES (1765877388298, '{"RebootTime":1765872979208}', '{"RebootStatus":"true"}', 'Reboot', '重启服务') `device_property_jkerjk97oub_27oy29bmmln` USING `device_property_jkerjk97oub` TAGS ('JkerjK97oub', '27OY29BMmLn') (`time`, `LightSwitch`) VALUES (1765877388298, '1');, desc: Table does not exist

at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:95)

at com.taosdata.jdbc.rs.RestfulStatement.execute(RestfulStatement.java:98)

at com.taosdata.jdbc.rs.RestfulStatement.execute(RestfulStatement.java:78)

at com.taosdata.jdbc.rs.RestfulStatement.executeUpdate(RestfulStatement.java:56)

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)

... 13 common frames omitted

2.使用启动命令启动nodered,命令如下
docker run -it  -p 1880:1880   -v /home/fhzz/node_red_pro_data:/data  --name nodered  -e TZ=Asia/Shanghai  -e MYSQL_HOST=8.112.6.167  -e MYSQL_PORT=3306  -e MYSQL_USER=root  -e MYSQL_PASSWORD=Hsdad#766282  -e MYSQL_DATABASE=bladex_iot  bladex/node-red-pro
报错错误如下
image.png


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


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


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


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

1条回答
  •  1. 进入产品管理的物模型,每个物模型的草稿界面都要点击 【发布上线】,发布后tdengine才会创建超级表,数据才能入库

     2. node-red默认的demo配置加载后无法根据默认配置访问,你清空 iot_edge_flows 的数据再启动就行了


    以上俩问题文档都有说明,建议仔细过两遍后再开始操作就能提前熟悉

    技术文档:https://iot.bladex.cn/tech/prologue/intro.html

    操作文档:https://iot.bladex.cn/feature/prologue/intro.html


    0 讨论(0)
提交回复