-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
3
-
Severity 3 - Minor
-
Description
Vendors reported an issue about REST API timeouts and we are seeing PSQL exception on the affected instances
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Unable to establish a connection with the database. (PSQL_TOO_MANY_CONNECTIONS Exception already occurred in this workcontext, skipping next getConnection)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByAnd(DefaultOfBizDelegator.java:91)
at com.atlassian.jira.application.OfBizApplicationRoleStore.getById(OfBizApplicationRoleStore.java:150)
at com.atlassian.jira.application.OfBizApplicationRoleStore.get(OfBizApplicationRoleStore.java:50)
at com.atlassian.jira.application.DelegatingApplicationRoleStore.get(DelegatingApplicationRoleStore.java:34)
at com.atlassian.jira.application.DefaultApplicationRoleManager.applicationRoleDefinitionToApplicationRole(DefaultApplicationRoleManager.java:652)
at com.atlassian.jira.application.DefaultApplicationRoleManager.lambda$findDefinitionApplicationRole$18(DefaultApplicationRoleManager.java:647)
at com.atlassian.fugue.Option.map(Option.java:272)
at com.atlassian.jira.application.DefaultApplicationRoleManager.findDefinitionApplicationRole(DefaultApplicationRoleManager.java:647)
at com.atlassian.jira.application.DefaultApplicationRoleManager.loadRole(DefaultApplicationRoleManager.java:639)
at com.atlassian.jira.application.DefaultApplicationRoleManager.lambda$getRole$1(DefaultApplicationRoleManager.java:173)
at com.atlassian.vcache.internal.core.metrics.TimedSupplier.get(TimedSupplier.java:32)
at com.atlassian.vcache.internal.core.service.DefaultRequestCache.lambda$get$2(DefaultRequestCache.java:52)
at java.util.Optional.orElseGet(Optional.java:267)
Side note
The spike can been seen between 12am and 6am on Apr, 3 SYD time (GMT +11) originate from the us-east-1. Please raised a Support ticket if you experiencing the same behavior.
- duplicates
-
JRACLOUD-70291 500 "FATAL: too many connections for role" caused by Edge malfunction
- Closed
- is related to
-
DEVHELP-2504 Loading...