https://signoz.io logo
Join Slack
Powered by
:face_holding_back_tears:
# support
r
🥹
a
that's usually a lot of data to delete and doing that after the disk is full is usually unsuccessful.
r
How can I fix it?
I want to remove old data
a
Are you on k8s? Try increasing the pv size. It takes a few minutes to take effect https://signoz.io/docs/operate/clickhouse/increase-clickhouse-pv/
r
Docker standalone (docker compose)
a
try dropping tables directly by connecting to clickhouse and restarting otel-collector to apply migrations to create tables again
r
how do I do that?
a
or truncate table, I think that would retain the schema
install clickhouse client
Copy code
./clickhouse client -h IP_OF_THE_MACHINE
r
image.png
a
also run 
docker system prune -a
if that clears up some space
r
What's the query to truncate the tables?
The table that is big is the traces one, I'm not using metrics nor logs
a
ok
Copy code
use signoz_traces;
above is the DB
r
Got it, and then?
a
Copy code
truncate table signoz_traces.signoz_index_v2 on cluster cluster;
truncate tables 
signoz_spans
and 
durationSort
too
r
Can't connect to the DB, it says: segmentation fault
a
after truncating tables?
r
The DB doesn't even start
I'm running just clickhouse with: 
docker-compose up clickhouse
And then
Copy code
./clickhouse client 127.0.0.1:9000
Segmentation fault
a
what's the output of 
pwd
?
r
/root
a
```./clickhouse client 127.0.0.1:9000
Segmentation fault```
host:port is not the format
just the IP default port is 9000
and default host is localhost
r
Tried all of them
image.png
a
docker-compose up clickhouse
this won't work from root. We specify config files to clickhouse from our docker-compose.yaml
r
Yes, I'm not on root
I'm on 
/root/signoz/deploy/docker/clickhouse-setup
Just the clickhouse bin is on 
/root
a
can you go to 
/deploy
folder and run docker-compose with the file specified using 
-f
?
Copy code
docker-compose -f docker/clickhouse-setup/docker-compose.yaml up -d
r
Ok the issue is how I installe the clickhouse client
image.png
Now I'm trying to delete but it says that lightweight delete is not supported for table signoz_index_v2
oh truncate removed all data
yay
image.png
It's going to start pruning data
thanks!
a
🙌
6 Views
Open in Slack
PreviousNext
Powered by