[Bug]: create view in pessimistic mode wait for lock.

[Ariznawlll]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):d8e84ac965d2d7451add3045e798ae93a23132d5
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

log.txt

It can't be reproduced locally.

Expected Behavior

No response

Steps to Reproduce

in mo-tester:
./run.sh -n -g -p /matrixone/test/distributed/cases/view/view-subquery-with-in.sql -m run

Additional information

No response

[ouyuanning]

not working on it

[ouyuanning]

you can repro like （in pessimistic mode):

use db1;
drop view v_not_exists;    //here will return error. and I think MO do not unlock mo_tables with table name "v_not_exists"
create view v_not_exists;   // will hung. will wait unlock

[Ariznawlll]

Same behavior as before.

test.txt

[ouyuanning]

就是当ddl语句执行，在commit失败后，需要执行unlock操作的问题。

[zhangxu19830126]

fixed

[Ariznawlll]

Verified!