Hi team, after we upgrade to 0.55. We want to change the log retention time. But the UI here is keep loading and not let me edit it. Any ways to solve this issue?

First check if there are any mutation running in clickhouse, Since you killed the mutations that were stuck last time, the status didn’t update in the signoz local db. You can go exec into query-service container.

apk add sqlite

sqlite3 /var/lib/signoz/signoz.db

delete from ttl_status;

this would solve it.

@nitya-signoz This works. and one thing I noticed is different from previously version is when I try to change the retention period the UI just finished immediately but for previous version there is a spin keep rolling. Is it expected?

Yeah we introduce a new flag. https://github.com/SigNoz/signoz/issues/5470 which doesn’t go ahead and run mutation on all the existing data.

materialize_ttl_after_modify

https://kb.altinity.com/altinity-kb-queries-and-syntax/ttl/modify-ttl/