cambyzju opened a new issue, #20387: URL: https://github.com/apache/doris/issues/20387
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version master ### What's Wrong? 1. create 3 test tables inside the same database ``` CREATE TABLE IF NOT EXISTS t1 ( k1 date NOT NULL, k2 varchar(20) NOT NULL, k3 int sum NOT NULL ) AGGREGATE KEY(k1,k2) PARTITION BY RANGE(k1) ( ) DISTRIBUTED BY HASH(k1) BUCKETS 1 PROPERTIES ( "dynamic_partition.enable"="true", "dynamic_partition.end"="3", "dynamic_partition.buckets"="1", "dynamic_partition.start"="-3", "dynamic_partition.prefix"="p", "dynamic_partition.time_unit"="DAY", "dynamic_partition.create_history_partition"="true", "dynamic_partition.replication_allocation" = "tag.location.default: 1"); ``` 2. alter dynamic_partition.end for different tables at the same time. for example: ``` mysql -h127.0.0.1 -uroot -P9030 example_db -e "alter table t1 set('dynamic_partition.end'='9')" & mysql -h127.0.0.1 -uroot -P9030 example_db -e "alter table t2 set('dynamic_partition.end'='9')" & mysql -h127.0.0.1 -uroot -P9030 example_db -e "alter table t3 set('dynamic_partition.end'='9')" & ``` 3. Then we could found mysql client will never return, and the fe.warn.log found following logs: `2023-06-02 20:42:55,730 WARN (tablet stat mgr|32) [Table.tryWriteLock():183] Failed to try table t3's write lock. timeout 3000 MILLISECONDS. Current owner: Thread[mysql-nio-pool-4,5,main]` ### What You Expected? fix ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
