matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: CN OOM when query from statement_info

Open DanielZhangQD opened this issue 1 year ago • 27 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Branch Name

1.1-dev

Commit ID

83b8499b3

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Execute the following sql and CN OOM:

SELECT statement_id, status, COUNT(*) as count      FROM system.statement_info      GROUP BY statement_id, status      HAVING COUNT(*) > 1;
MySQL [system_metrics]> SELECT statement_id, status, COUNT(*) as count      FROM system.statement_info      GROUP BY statement_id, status      HAVING COUNT(*) > 1;
Connection id:    129312394
Current database: system_metrics

ERROR 20503 (HY000): stream closed
default-cn-4cm7t                       0/1     OOMKilled   2 (78s ago)     25h

Expected Behavior

SQL succeeds

Steps to Reproduce

Run the above sql in Cloud Dev

Additional information

No response

DanielZhangQD avatar Jan 26 '24 12:01 DanielZhangQD

看着应该是agg的哈希基数过大造成的。辛苦龙冉帮忙看看

ouyuanning avatar Jan 29 '24 02:01 ouyuanning

not working on it today

aunjgr avatar Feb 01 '24 11:02 aunjgr

在解决中移物联的issue

aunjgr avatar Feb 22 '24 12:02 aunjgr

not working on it today

aunjgr avatar Feb 28 '24 10:02 aunjgr

not working on it today

aunjgr avatar Mar 04 '24 12:03 aunjgr

not working on it today

aunjgr avatar Mar 08 '24 11:03 aunjgr

not working on it today

aunjgr avatar Mar 13 '24 11:03 aunjgr

not working on it today

aunjgr avatar Mar 19 '24 11:03 aunjgr

not working on it today

aunjgr avatar Mar 25 '24 15:03 aunjgr

not working on it today

aunjgr avatar Apr 01 '24 11:04 aunjgr

not working on it today

aunjgr avatar Apr 09 '24 11:04 aunjgr

not working on it today

aunjgr avatar Apr 15 '24 11:04 aunjgr

not working on it today

aunjgr avatar Apr 19 '24 12:04 aunjgr

not working on it today

aunjgr avatar Apr 25 '24 12:04 aunjgr

not working on it today

aunjgr avatar May 06 '24 12:05 aunjgr

not working on it today

aunjgr avatar May 10 '24 14:05 aunjgr

not working on it today

aunjgr avatar May 15 '24 11:05 aunjgr

not working on it today

aunjgr avatar May 20 '24 12:05 aunjgr

not working on it today

aunjgr avatar May 24 '24 12:05 aunjgr

not working on it today

aunjgr avatar May 29 '24 11:05 aunjgr

not working on it today

aunjgr avatar Jun 03 '24 11:06 aunjgr

not working on it today

aunjgr avatar Jun 07 '24 11:06 aunjgr

not working on it today

aunjgr avatar Jun 11 '24 11:06 aunjgr

not working on it today

aunjgr avatar Jun 17 '24 12:06 aunjgr

not working on it today

aunjgr avatar Jun 21 '24 11:06 aunjgr

not working on it today

aunjgr avatar Jun 26 '24 12:06 aunjgr

on leave

aunjgr avatar Jul 03 '24 15:07 aunjgr

not working on it today

aunjgr avatar Jul 09 '24 13:07 aunjgr

not working on it today

aunjgr avatar Jul 15 '24 12:07 aunjgr

not working on it today

aunjgr avatar Jul 19 '24 09:07 aunjgr