matrixone
matrixone copied to clipboard
matrixorigin
[Bug]: Duplicate statement_id in statement_info table
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Environment
- Version or commit-id (e.g. v0.1.0 or 8b23a93): 1.0 nightly-90dac68d
- Hardware parameters:
- OS type:
- Others:
Actual Behavior
Two statements with the same statement_id but different response_at:
select statement_id,stats,response_at from system.statement_info where statement_id = 'b92b7375-9955-11ee-ade0-2e67831535c5' and response_at >= '2023-12-13 01:19:00.000' and response_at < '2023-12-13 01:21:00.000';
+--------------------------------------+--------------------------------------+----------------------------+
| statement_id | stats | response_at |
+--------------------------------------+--------------------------------------+----------------------------+
| b92b7375-9955-11ee-ade0-2e67831535c5 | [3,378238,2238.000,0,0,189,2] | 2023-12-13 01:19:57.681341 |
| b92b7375-9955-11ee-ade0-2e67831535c5 | [3,26754532,8385262.067,0,0,10725,2] | 2023-12-13 01:20:00.000000 |
+--------------------------------------+--------------------------------------+----------------------------+
2 rows in set (0.04 sec)
Expected Behavior
Statement_id is uniq
Steps to Reproduce
NA
Additional information
Prod cluster
Reproduced in cloud qa env, 1.0.2
MySQL [mo_cloud]> select statement_id,request_at,response_at,stats,duration from system.statement_info where statement_id = 'dae73140-b5b0-11ee-a8aa-86b79c86c056' and request_at >= '2024-01-18 03:00:00.000';
+--------------------------------------+----------------------------+----------------------------+----------------------------------+----------+
| statement_id | request_at | response_at | stats | duration |
+--------------------------------------+----------------------------+----------------------------+----------------------------------+----------+
| dae73140-b5b0-11ee-a8aa-86b79c86c056 | 2024-01-18 03:22:50.000000 | 2024-01-18 03:22:55.000000 | [3,7301105,233332.483,0,0,278,2] | 10315601 |
| dae73140-b5b0-11ee-a8aa-86b79c86c056 | 2024-01-18 03:22:50.000000 | 2024-01-18 03:22:55.000000 | [3,7301105,233332.483,0,0,278,2] | 10315601 |
| dae73140-b5b0-11ee-a8aa-86b79c86c056 | 2024-01-18 03:22:55.000000 | 2024-01-18 03:23:00.000000 | [3,7301105,468432.000,0,0,278,2] | 10315601 |
+--------------------------------------+----------------------------+----------------------------+----------------------------------+----------+
3 rows in set (0.00 sec)
