I have successfully uploaded a file that is 40GB large using the userfile upload command. However, I now want to delete it but I encountered an error. It seems to me that the connection had timed out. Anyone has any idea how to extend the timeout when using the cockroach command?
$ cockroach userfile delete ‘*’ --certs-dir certs --user=xxxxx --url postgresql://10.xxx.xxx.xxx: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/yyyyy.csv.bz2
Failed running “userfile delete”
I am connecting to the cockroachdb server from the local machine, not remotely.