Fixing File Corruption after VM Shutdown in ClickHouse
TLDR Fernando encountered a corrupted ClickHouse system after a VM shutdown. Srikanth suggested a way to reinstall the system without losing user data, which resolved the issue.
Jun 26, 2023 (5 months ago)
Fernando
07:33 PM
Srikanth
08:24 PMFernando
08:32 PMFernando
08:33 PMFernando
08:34 PMSrikanth
08:37 PMYes, and if you can avoid this that would be great.
> Is it possible to reinstall the system from scratch, without losing users/passwords?
You can purge the ClickHouse data but retain the rest. delete the ClickHouse data under
deploy/docker/clickhouse-setup/data/clickhouse*Fernando
08:39 PMFernando
09:11 PM
SigNoz Community
Indexed 1023 threads (61% resolved)
Similar Threads
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.
Problems Encountered with ClickHouse After Fresh Install
Romil experienced issues after a fresh install of ClickHouse. Prashant advised restarting certain pods, but that wasn't fully successful. Srikanth acknowledged the issue and pointed to a related open problem on GitHub.
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.
Troubleshooting SigNoz Local Setup on M1 Mac
Sindhu had issues with their local SigNoz installation using Docker on an M1 Mac. Srikanth helped diagnose the problem. It was resolved by manually starting the ClickHouse container and then starting SigNoz via Docker Compose in the terminal.
SigNoz crashing in k8s due to ClickHouse OOM
Travis reported SigNoz crashing in k8s due to ClickHouse OOM. The team suggested increasing resources for ClickHouse, and other troubleshooting steps, but the issue remains unresolved.