I have a 3 node cockroachdb cluster and I recently uploaded a 40GB file using userfile upload.
Now, I want to delete it but i got the error:
cockroach userfile delete ‘*’ --certs-dir certs --user=xxxx --url postgresql://10.yyy.yyy.yyy:26257 --echo-sql
E210329 07:22:36.543159 1 cli/error.go:398 failed to delete from the payload table: driver: bad connection
ERROR: failed to delete from the payload table: driver: bad connection
DETAIL: deletion failed at userfile://defaultdb.public.userfiles_xxxx/zzzzz.csv.bz2
Failed running “userfile delete”
Any ideas? I am connecting directly from the localhost itself.