matrixone
matrixone copied to clipboard
Published
20 hours ago •
matrixorigin
matrixorigin
[Bug]: `empty set`
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):nightly-bd9f86e8
- Hardware parameters:
- OS type:
- Others: freetier-01
Actual Behavior
Expected Behavior
statement_info 有很多数据。不应该会有空行。
Steps to Reproduce
1, enter the debug pod of DanialZhang. `kubectl exec -it test bash -n default`
2,connect mo by proxy(get password offline). mysql -h proxy.freetier-01 -P6001 -udump -pxxxx.
3, execute `SELECT COUNT(*) as count FROM system.statement_info GROUP BY statement_id, status;`
you may get empty set of the sql above. but mostly the cn is killed by oom.
Additional information
No response
Suspect this has something to do how mysql protocol handles timeout/interrupt/cancel etc. It just happily prints whatever it get and drop the error on the floor. It is so wrong ...
mysql> select * from t;
^C
^C -- query aborted
+------+------+
| i | j |
+------+------+
| 1 | 2 |
+------+------+
100 rows in set (3.51 sec)
mysql>
