TCP error on idle connection

[imraan-go]

After the connection idles for few hours, the first few request fails with TCP error:

write tcp 192.168.3.4:65383->3.1.14.XXX:5432: write: broken pipe

This is the code i'm using on startup of my application:

dsn := fmt.Sprintf("postgres://%v:%s@%v:5432/%v?sslmode=disable", dbconfig.Get("dbuser").(string), url.QueryEscape(dbconfig.Get("dbpass").(string)), dbconfig.Get("dbhost").(string), dbconfig.Get("dbname").(string))
	sqldb := sql.OpenDB(pgdriver.NewConnector(pgdriver.WithDSN(dsn)))

	if err != nil {
		log.Fatal(err)
	}
	err = sqldb.Ping()
	if err != nil {
		log.Fatal(err)
	}

	db := bun.NewDB(sqldb, pgdialect.New())
	db.AddQueryHook(bundebug.NewQueryHook(bundebug.WithVerbose()))

I didn't have that issue with lib/pq driver before.

[imraan-go]

The fix should be similar to this: lib/pq#1013

[vmihailenco]

Thanks for bringing this 👍