DB limit open connections

[Legogris]

When using Postgresql as a database, we see that despite very low activity, new connections keep getting opened and are left idle.

I see that open connections are already limited for Sqlite:

chainlink/core/store/dbutil/dbutil.go

Line 43 in 12a0352

db.DB().SetMaxOpenConns(1)

I see a couple of options here:

• Do the same (but maybe with a higher value, say 5-10?) for Postgres
• Limiting SetMaxIdleCons for Postgres (some discussion here https://github.com/jinzhu/gorm/issues/246)
• Expose these as env variables (more flexible, but maybe overkill at this point)

[se3000]

@Legogris we believe this has been fixed now. We have improved the database locking logic. Are you still seeing this error?

[se3000]

No response. We believe this is fixed with the new Postgres locking strategy. Please reopen if you continue to run into the issue.