v.19.14Improvement

Fixed Deadlock When We Have at Least Two Queries That Read at Least Two Tables in Different Order and Another Query That Performs DDL Operation on One of Tables

Fixed deadlock when we have at least two queries that read at least two tables in different order and another query that performs DDL operation on one of tables. Fixed another very rare deadlock. #6764 (alexey-milovidov)
Fixed deadlock scenarios involving concurrent queries and DDL operations.

Why it matters

This update resolves deadlocks that occurred when multiple queries read multiple tables in different orders simultaneously with DDL operations on those tables. It also fixes another rare deadlock scenario, improving stability and concurrency in ClickHouse.

How to use it

Users benefit from this fix automatically after upgrading to the new ClickHouse version; no special configuration or action is required.