LiuBo

@gaocegege hello，what is the status of this issue?

resolved by #6012

in local test: ``` create database if not exists db1; use db1 drop table if exists t; create table t (i int, j int); insert into t values (1, 1),...

dup with #9447

该问题的分析见https://github.com/matrixorigin/matrixone/issues/9447#issuecomment-1576675658 后续由 @triump2020 再做一些优化。

ERROR 20503 (HY000) at line 40: stream closed 出现该错误或者其他的连接关闭的错误的原因是，rpc框架中的gc任务会检查每个连接的活跃状态，当超过一定时间（默认1分钟）没有数据时，就会关闭这个连接。 delete语句的commit时间长，导致其连接被gc给close了，所以执行失败，需要优化。

loki上的日志： http://175.178.192.213:30088/explore?panes=%7B%22AAL%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22branch-big-data-nightly-4170547%5C%22%7D%20%21%3D%20%60delete:%20s3:%2F%2Fmo-nightly-gz%60%20%21%3D%20%60cron%20task%20scheduler%20stopped%20or%20is%20stopping%60%20%21%3D%20%60%21%21%21COM_QUIT%21%21%21%60%20%21%3D%20%60ms%20cpu%60%20%21%3D%20%60blockio%2Fpipeline.go%60%20%21%3D%20%60set%20query%20status%20on%20the%20connection%60%20%21%3D%20%60task%2Ftask_scheduler.go%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22,%22maxLines%22:5000%7D%5D,%22range%22:%7B%22from%22:%221706500800000%22,%22to%22:%221706502600000%22%7D%7D%7D&schemaVersion=1&orgId=1

无进展

add some logs to help investigate.

等 https://github.com/matrixorigin/matrixone/pull/15448 合并进去