Bug Description
创建流后,刚开始可以执行,跑一段时间后出现错误。
create stream if not exists aircraft_data.dock_state_stream state_window(mode_code, charge_state) from aircraft_data.dock_osd partition by tbname, dock_sn stream_options(fill_history | max_delay(10m)) into aircraft_data.dock_state_window output_subtable(concat('dock_state_', %%2)) tags (dock_sn varchar(64) as dock_sn) as select _twstart as ts, mode_code, case mode_code when 0 then '空闲中' when 1 then '现场调试' when 2 then '远程调试' when 3 then '固件升级中' when 4 then '作业中' when 5 then '待标定' else '未知' end as mode_name, charge_state, case charge_state when 0 then '空闲' when 1 then '充电中' else '未知' end as charge_state_name, _twduration as duration_ms, _twstart as start_time, _twend as end_time, _twrownum as sample_count from %%trows;
Screenshots
Environment (please complete the following information):
- OS: openEuler 24.03
- 8cpu,16g内存,1T硬盘
- docker部署tdengine/tsdb:3.4.2.2
Bug Description
创建流后,刚开始可以执行,跑一段时间后出现错误。
create stream if not exists aircraft_data.dock_state_stream state_window(mode_code, charge_state) from aircraft_data.dock_osd partition by tbname, dock_sn stream_options(fill_history | max_delay(10m)) into aircraft_data.dock_state_window output_subtable(concat('dock_state_', %%2)) tags (dock_sn varchar(64) as dock_sn) as select _twstart as ts, mode_code, case mode_code when 0 then '空闲中' when 1 then '现场调试' when 2 then '远程调试' when 3 then '固件升级中' when 4 then '作业中' when 5 then '待标定' else '未知' end as mode_name, charge_state, case charge_state when 0 then '空闲' when 1 then '充电中' else '未知' end as charge_state_name, _twduration as duration_ms, _twstart as start_time, _twend as end_time, _twrownum as sample_count from %%trows;
Screenshots
Environment (please complete the following information):