I have been trying to understand the purpose of the below env in term of a problem that we are facing in our system.
We have a system with client A wanting to connect a standalone Cockroachdb server’s B via HaProxy.
A <—> haproxy <—> B
Now every now and then we happened to see “Broken Pipe” error.
Now, all that I know about
COCKROACH_SQL_TCP_KEEP_ALIVE is set to send TCP keepalive request every 60 sec.
Also, we have used HAProxy settings mention in Cockroachdb guide
# TCP keep-alive on Client side. Server already enables them. option clitcpka
With the following option, I’m assuming the Client and HAProxy connection would be Keepalive enable.
At last, I want to understand does
would actually help.