PSQL exception on third-party addons

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Medium
    • Component/s: 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.

            Assignee:
            Unassigned
            Reporter:
            Azmir Zan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: