You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE CONTINUOUS QUERY rpp_mean_data ON device BEGIN
SELECT max(floatValue) AS "floatValue"
INTO device.rpp_y1_data.jt2hl
FROM device.m1_data.jt2hl
WHERE "deviceName" =~ /列头/
GROUP BY deviceName, deviceObjectName, deviceCode, deviceObjectCode, time(5m) TZ('Asia/Shanghai')
END
CREATE CONTINUOUS QUERY rpp_mean_data ON device BEGIN
SELECT max(floatValue) AS "floatValue"
INTO device.rpp_y1_data.jt2hl
FROM device.m1_data.jt2hl
WHERE "deviceName" =~ /列头/
GROUP BY deviceName, deviceObjectName, deviceCode, deviceObjectCode, time(5m) TZ('Asia/Shanghai')
END
zedware
changed the title
创建连续插入时,指定写入数据的retention未创建的情况下,保存连续查询时,当连续查询执行时会直接使ts-sql停止运行
Continous query stops ts-sql when data retation is not created
May 17, 2024
Describe the bug(Bug 描述)
创建连续查询去插入数据时,在指定写入数据的retention未创建的情况下,连续查询创建成功。当连续查询执行时会直接使ts-sql停止运行。具体情况是创建连续查询:
但是存储策略rpp_y1_data并未创建。创建语句执行成功。当存储策略执行时,ts-sql停止运行,然后再次启动,存储策略执行时,ts-sql依旧会停止运行。
To Reproduce(Bug 复现步骤)
其中使用的存储策略rpp_y1_data未创建。
连续查询创建成功后,等待其执行
ts-sql服务停止
查看sql_extra.log,内容如下:
然后查看sql.log,会发现其中有error信息,此处只截取日志部分内容:
Expected behavior(期望结果)
创建连续查询,如果使用的存储策略未创建或者语句有问题,只是在日志中进行错误日志的输出,不影响ts-sql或者其他服务的正常运行
Screenshots(屏幕截图)
Logs(完整的错误日志)
[sql.error.log](https://github.com/openGemini/openGemini/files/15293234/sql.error.log) [sql.log](https://github.com/openGemini/openGemini/files/15293235/sql.log)
Additional context(其他的一些补充内容)
No response
The text was updated successfully, but these errors were encountered: