Skip to content

3.4.0.2版本中在计数窗口流计算中使用group_concat聚合函数会引发宕机和报错 #34504

@Cabbage-Leon

Description

@Cabbage-Leon

Bug Description
3.4.0.2版本中在计数窗口流计算中使用group_concat聚合函数会引发宕机和报错

Environment (please complete the following information):

  • OS: Linux
  • TDengine Version 3.4.2

Additional Context
Add any other context about the problem here.
建表脚本如下:
taos> CREATE STABLE IF NOT EXISTS s_ptr_data (
> ts TIMESTAMP,
> test_value double,
> test_value_str VARCHAR(16),
> test_flag INT,
> hi_limit double,
> lo_limit double
> ) TAGS (
> factory VARCHAR(32),
> fileid VARCHAR(64),
> testnum INT,
> testtxt VARCHAR(256),
> headnum INT,
> sitenum INT,
> productid VARCHAR(64),
> lotid VARCHAR(64),
> sublotid VARCHAR(64),
> jobname VARCHAR(128),
> flowid VARCHAR(32),
> datatype VARCHAR(10),
> nodename VARCHAR(32),
> dutindex INT
> );
Create OK, 0 row(s) affected (0.015924s)

创建流计算脚本如下
taos>
taos> CREATE STREAM s1 COUNT_WINDOW(10)
> FROM s_ptr_data PARTITION BY tbname
> INTO output
> AS
> SELECT LAST(ts) AS ts, AVG(test_value) AS avg_test_value, GROUP_CONCAT(test_value_str, ',') AS test_value_array
> FROM s_ptr_data;

DB error: Row length exceeds max length 65531 [0x8000263E] (0.029885s)

当s_ptr_data 表写入数据后,会引发所有数据库的连接超时以及宕机
目前观察下来,docker,window端都会崩溃

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions