I solved it by increasing the clickhouse resourse. When you do that retension, it run extensive query and clickhouse needs resources