strapi-postgres icon indicating copy to clipboard operation
strapi-postgres copied to clipboard

Published 20 hours ago • verified publisher icon render-examples

Add connection pool settings

Open johnbeynon opened this issue 2 years ago • 1 comments

This hopefully resolves the issues experienced by customers in #inc-2022-06-03-strapi-database-connection-terminates-unexpectedly

It typically manifested as a Server unhealthy message with this in the logs:

May 31 11:12:01 AM [2022-05-31 10:12:01.823] debug: ⛔️ Server wasn't able to start properly.

May 31 11:12:01 AM [2022-05-31 10:12:01.824] error: select "t0"."id" from "admin_users" as "t0" limit $1 - Connection terminated unexpectedly

May 31 11:12:01 AM error Command failed with exit code 1.

May 31 11:12:01 AM Error: select "t0"."id" from "admin_users" as "t0" limit $1 - Connection terminated unexpectedly at Connection.<anonymous>

https://render.zendesk.com/agent/tickets/17938 https://github.com/strapi/strapi/issues/11860

johnbeynon avatar Jun 13 '22 14:06 johnbeynon

Also validated by comment here - https://github.com/strapi/strapi/issues/11860#issuecomment-1154937496

johnbeynon avatar Jun 14 '22 09:06 johnbeynon