Search code examples
clickhousetabix

ClickHouse How to change queue_max_wait_ms value in system.settings table

My ClickHouse queries are failing because of exceeding max waiting time with the error:

Code: 159, e.displayText() = DB::Exception: Timeout exceeded: elapsed 5.380073004 seconds, maximum: 5

The timeout is specified in system.settings table but I can not find a way to change it.

It doesn't exist in /etc/clickhouse-server/config.xml and /etc/clickhouse-server/user.xml files.

Could someone please advice me how to change the value?

Solution

  • @antonk it's a tabix default setting. Under settings on the right / max execution time 5 seconds