https://signoz.io logo
#support
Title
# support
r

Romario Lopez C

05/09/2023, 6:39 PM
🥹
a

Ankit Nayan

05/09/2023, 6:53 PM
that's usually a lot of data to delete and doing that after the disk is full is usually unsuccessful.
r

Romario Lopez C

05/09/2023, 6:54 PM
How can I fix it?
I want to remove old data
a

Ankit Nayan

05/09/2023, 6:54 PM
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

Romario Lopez C

05/09/2023, 6:54 PM
Docker standalone (docker compose)
a

Ankit Nayan

05/09/2023, 6:55 PM
try dropping tables directly by connecting to clickhouse and restarting otel-collector to apply migrations to create tables again
r

Romario Lopez C

05/09/2023, 6:55 PM
how do I do that?
a

Ankit Nayan

05/09/2023, 6:56 PM
or truncate table, I think that would retain the schema
install clickhouse client
Copy code
./clickhouse client -h IP_OF_THE_MACHINE
r

Romario Lopez C

05/09/2023, 6:57 PM
image.png
a

Ankit Nayan

05/09/2023, 6:58 PM
also run
docker system prune -a
if that clears up some space
r

Romario Lopez C

05/09/2023, 6:58 PM
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

Ankit Nayan

05/09/2023, 6:58 PM
ok
Copy code
use signoz_traces;
above is the DB
r

Romario Lopez C

05/09/2023, 7:00 PM
Got it, and then?
a

Ankit Nayan

05/09/2023, 7:01 PM
Copy code
truncate table signoz_traces.signoz_index_v2 on cluster cluster;
truncate tables
signoz_spans
and
durationSort
too
r

Romario Lopez C

05/09/2023, 7:03 PM
Can't connect to the DB, it says: segmentation fault
a

Ankit Nayan

05/09/2023, 7:10 PM
after truncating tables?
r

Romario Lopez C

05/09/2023, 7:11 PM
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

Ankit Nayan

05/09/2023, 7:12 PM
what's the output of
pwd
?
r

Romario Lopez C

05/09/2023, 7:12 PM
/root
a

Ankit Nayan

05/09/2023, 7:13 PM
```./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

Romario Lopez C

05/09/2023, 7:14 PM
Tried all of them
image.png
a

Ankit Nayan

05/09/2023, 7:14 PM
docker-compose up clickhouse
this won't work from root. We specify config files to clickhouse from our docker-compose.yaml
r

Romario Lopez C

05/09/2023, 7:14 PM
Yes, I'm not on root
I'm on
/root/signoz/deploy/docker/clickhouse-setup
Just the clickhouse bin is on
/root
a

Ankit Nayan

05/09/2023, 7:16 PM
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

Romario Lopez C

05/09/2023, 7:21 PM
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

Ankit Nayan

05/10/2023, 4:05 AM
🙌