FATAL: too many connections for role

[Balu]

In JIRA Cloud, I am trying to create Xray test execution, linking a couple of Xray tests to the same. For each test, there are a bunch of test evidence, say 60-70. The evidence is being added to issue as well. I got the below error 

Error creating evidence on Jira: Got error while saving attachment <my attachment>: Got exception while saving attachment in attachment store. Exception: org.postgresql.util.PSQLException: FATAL: too many connections for role "<my role>" caused by: FATAL: too many connections for role "<my role>"

[Earl McCutcheon]

Hi Balu,

This is happening on a User role limit in the Postgres database settings directly, we have the following KB article that goes into a bit more detail but the fix is to set the connection limit to -1 for unlimited connections:

• 'FATAL too many connections' error when using PostgreSQL database due to user-specific connection limit

ALTER ROLE jirauser CONNECTION LIMIT -1;

Regards,
Earl

[Balu]

Hi @Earl McCutcheon ,

We are using Jira cloud, I don't know where to configure the database for the cloud, could you help me with that?

[Earl McCutcheon]

Hi Balu,

Thanks for the clarification on the platform, and it looks like there is currently a Bug in cloud on Bulk rest api calls that causes the DB connection errors to occur on a rate limit, and the X-ray tests must be triggering the rate limit exception in the bug.  More details can be seen here:

• https://jira.atlassian.com/browse/JRACLOUD-71874

Currently the only way to avoide the limit is to lower retry frequency on the failed attempts, so either lowering the input values of the test, or I would also recomend reaching out to the Xpand IT support channel with the Bug info to see if they are aware of any other workarounds for the application to lower the retry frequency.

Regards,
Earl