topic "DB connection pool is depleted" errors and alfresco did not respond anymore in Alfresco Forum

"DB connection pool is depleted" errors and alfresco did not respond anymore

koichinakata — Wed, 20 Sep 2017 12:03:03 GMT

Hi experts,My alfresco CE is 201706GA environment on amazon linux, m4.2xlarge, postgresql, solr4.The instance is set both db.pool.max (alfresco-global.properties) and max_connections(postgresql.conf) as 300.Today we have outages where the alfresco process is running but the application does not resp

Re: "DB connection pool is depleted" errors and alfresco did not respond anymore

jpotts — Mon, 19 Feb 2018 19:22:35 GMT

Your DB connection pool is depleted as shown in the logs. Once the pool is depleted, a restart is the only way to fix the problem. Maybe your question is "What caused my DB connection pool to be depleted?" but we aren't going to be able to answer that without additional context. Have you seen a spike in usage? Were you doing a large import? What has the DB connection trend been over time leading up to this point? What changed?

Re: "DB connection pool is depleted" errors and alfresco did not respond anymore

lmaorence — Wed, 28 Mar 2018 14:40:25 GMT

This may be caused by too many concurrent connections to your database that ended up using and depleting the maximum connection pool. I suggest you try increasing your connection pools both alfresco and in database given that your memory can handle the load and see if this issue persists.