Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-71836

PSQL exception on third-party addons

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium Medium
    • None

      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.

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

                Created:
                Updated:
                Resolved: