Is there a way to manually prune logs?
I tried set...
# generalo
Ola Ahlman
11/27/2024, 2:45 PMIs there a way to manually prune logs?
I tried setting the Logs retention period to 1h, but now, 2h later, it still hasn't deleted old records. I managed to mess up a deployment so it spammed and filled db(disk). Still ~100gb left but I want to clear out all logs to start fresh.
n
nitya-signoz
11/27/2024, 3:07 PMCheck the note in this doc, https://signoz.io/docs/userguide/retention-period/ .
The ttl is only applied to new data that will be ingested not the existing data, You can materialized the TTL for old data by going into clickhouse and running
alter table signoz_logs.logs_v2 on cluster cluster materialize ttlo
Ola Ahlman
11/27/2024, 3:31 PMok thanks
Ola Ahlman
11/27/2024, 3:59 PM@nitya-signoz whats the proper way to enter and execute the command?
I did:
Copy code
# enter container
docker exec -it <container_id> bash
# enter clickhouse
clickhouse
# execute command
alter table signoz_logs.logs_v2 on cluster cluster materialize ttln
nitya-signoz
11/27/2024, 3:59 PMuse
clickhouse clientclickhouseo
Ola Ahlman
11/27/2024, 4:00 PMok, that returned right away, does it process the request in a background thread?
n
nitya-signoz
11/27/2024, 4:01 PMyes you can check that by
select * from system.mutations where is_done=068 Views