#support

Resolving Issues with Setting Retention Periods in SigNoz

TLDR Thomas reported issues with setting retention periods in SigNoz. Prashant advised them on increasing the ClickHouse instance resource, and on clearing clickhouse and zookeeper data while keeping all settings/configured dashboards. They also discussed backing up Docker files.

Join the chat

Nov 06, 2023 (3 weeks ago)

Photo of md5-af401a7de1348536292c29d59b359eb6

Thomas

12:28 PM

Setting the retention periods fails in the latest signoz. How to fix that?

Photo of md5-1899629483c7ab1dccfbee6cc2f637b9

Prashant

02:25 PM

Can you "temporarily" increasing the ClickHouse instance resource and try setting the TTL?

02:26

Prashant

02:26 PM

Updating TTL is a resource intensive operation.

Thomas

02:27 PM

Which resource? Disk space? There was enough disk space when I tried, but it failed and now I have run out of it.

02:27

Thomas

02:27 PM

Why? Isn’t it just deleting data older than the TTL?

02:28

Thomas

02:28 PM

Can I manually clear the clickhouse data while keeping all settings/configured dashboards?

Prashant

02:28 PM

are you using SigNoz in Docker Standalone or Kubernetes?

Thomas

02:29 PM

Docker standalone

Prashant

02:30 PM

Run the following to clear data of clickhouse and zookeeper:

make clear-standalone-ch

02:31

Prashant

02:31 PM

make sure to bring down the signoz cluster first, followed by clean up, then back up.

Thomas

02:31 PM

Thanks I will try that. This will not delete users and other settings, right? 🙂

02:32

Thomas

02:32 PM

Related question: when transferring a Docker standalone instance to a new server, how do I backup/restore settings in an ideal way? Or simply move everything including volumes?

Prashant

02:34 PM

> This will not delete users and other settings, right?
it will not. They are stored in SQLite DB file.

02:36

Prashant

02:36 PM

We do not have official guidelines on the backup/restore yet.

For Docker Standalone, copying data folder from deploy/docker/clickhouse-setup/data should work fine.

SigNoz Community

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

Indexed 1023 threads (61% resolved)

Join Our Community

Similar Threads

Issues with SigNoz Setup and Data Persistence in AKS

Vaibhavi experienced issues setting up SigNoz in AKS, and faced data persistence issues after installation. Srikanth provided guidance on ClickHouse version compatibility and resource requirements, helping Vaibhavi troubleshoot and resolve the issue.

8mo

Trouble Setting Trace Retention Days in SigNoz

Jose faced issues with trace retention settings. vishal-signoz advised connecting to SQLite DB and clearing TTL status table to update the retention setting.

8mo

Resolving ClickHouse TTL Issue in SigNoz Documentation

vandr0iy solved a ClickHouse issue with SigNoz log's retention duration, suggesting clarity in documentation. Pranay agreed to enhance the documents.

Issue Resolved: Unable to Update Metrics Retention Period

Asif was having trouble updating metrics retention period. Srikanth suggested a fresh install after deletion. Asif successfully resolved his issue after removing all docker resources and recreating everything.

3mo

Services UI Goes Blank Due to Retention Issue with S3 Bucket

oluchi reports issue with services UI going blank after a while. Conversation explores possible reasons, such as S3 connection problems and disk space, but no resolution is reached.

7mo