间歇性的“对等连接重置” SQL Postgres
After a period of inactivity, my go web service is getting a
net.OpError with message
read tcp x.x.x.x:52086->x.x.x.x:24414: read: connection reset by peer when executing the first postgres sql query. After the error, the subsequent requests will work fine.
The postgres database is hosted with compose.com which has haproxy in front of the postgres db. My go web app is using standard sql and sqlx.
I've tried running a ticker invoking
db.Ping() every 15 minutes, but this hasn't fixed the issue.
Why is the go standard
sql lib not handling these connection drops?