Trouble Setting Trace Retention Days in SigNoz
TLDR Jose faced issues with trace retention settings. vishal-signoz advised connecting to SQLite DB and clearing TTL status table to update the retention setting.
Mar 26, 2023 (6 months ago)
Mar 27, 2023 (6 months ago)
In latest version there are some improvements on retention.
Mar 29, 2023 (6 months ago)
If you are using docker follow below steps:
Connect to query-service
docker exec -it query-service sh
Run the following:
# install sqlite apk update apk add sqlite # open sqlite with signoz.db sqlite3 /var/lib/signoz/signoz.db # (sqlite shell) check existing ttl status select * from ttl_status; # delete all rows of ttl_status DELETE FROM ttl_status;
Indexed 825 threads (61% resolved)
Self-hosted Signoz Retains All Traces Beyond Limit
Prashant has a problem with Signoz retaining traces beyond the default limit, causing storage to be full. Srikanth suggests using "OPTIMIZE TABLE ..." command in Clickhouse to trigger cleanup.
SigNoz Install Script Errors
Nishant encountered errors with the install.sh script. Prashant suggested using `bash install.sh` or `./install.sh` instead of `sh`.
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.