[Bug]: streaming: drop dynamic table not succeed

heni02 commented 9 months ago

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):c4b255cbd0ee319c50210706a94eaf5d6084aadf
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

drop table后再创建dynamic table报存在 step 1:

企业微信截图_572fc1f0-4727-4e92-bd88-65429dac5614

step 2:

企业微信截图_54fc3b65-e8e2-43b1-a053-1e3698d8c99f

sql： create dynamic table db.dt4 as select from stream_7; drop table dt4; create dynamic table db.dt4 as select from db.stream_7; drop table db.dt4; create dynamic table db.dt4 as select * from db.stream_7;

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

gavinyue commented 9 months ago

目前drop table的时候connector没有处理，是有问题的。需要用户手动drop connector.

gavinyue commented 9 months ago

drop table的问题和创建的时候数据库名缺失有关系，预计明天一起解决。

gavinyue commented 9 months ago

https://github.com/matrixorigin/matrixone/pull/13348

heni02 commented 9 months ago

confirm commit：09b923d8ca3ecef29c7ec6a6b80eb2c63e17cb9d

企业微信截图_51da8802-31d7-41b0-affa-ec2ba5375d1b

不过drop table后很快再create，像是connector还没删完，这里能否create dynamic的时候等一下，不然因为时间差问题会报错会有歧义 @gavinyue

gavinyue commented 9 months ago

明天解决

gavinyue commented 8 months ago

删除daemon task 也有延迟

gavinyue commented 8 months ago

Pending

gavinyue commented 8 months ago

Pending

gavinyue commented 8 months ago

Pending

gavinyue commented 8 months ago

Pending

heni02 commented 8 months ago

目前还是有问题，集中drop很多dt表，connector drop不掉，2个小时前下发的drop table

企业微信截图_8722b7b5-e887-47b9-a037-777d8d63026b

企业微信截图_a02ee8f9-7e98-4578-af9e-2907eeffbc35

qingxinhome commented 7 months ago

We will handle it later

qingxinhome commented 7 months ago

We will handle it later

qingxinhome commented 7 months ago

We will handle it later