v.21.1Improvements

Avoid Deadlock in INSERT SELECT Operations with TinyLog and Log Engines

Official CH changelog text
Avoid deadlock when executing INSERT SELECT into itself from a table with TinyLog or Log table engines. This closes #6802. This closes #18691. This closes #16812. This closes #14570. #15260 (alexey-milovidov).
Avoid deadlock when executing INSERT SELECT statements into the same table with TinyLog or Log table engines.

Why it matters

This feature resolves deadlock issues that occurred when performing INSERT SELECT operations on the same table using TinyLog or Log engines. It improves the stability and reliability of such concurrent write operations, ensuring smoother and deadlock-free data insertion for these table types.

How to use it

Users can execute INSERT INTO <table> SELECT ... FROM <same_table> statements on tables with TinyLog or Log engines without any additional configuration. The deadlock avoidance mechanism is applied automatically in these scenarios.

Related resources

PreviousNext