FATAL: too many connections for role

Question

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 : Got exception while saving attachment in attachment store. Exception: org.postgresql.util.PSQLException: FATAL: too many connections for role "" caused by: FATAL: too many connections for role ""

Earl McCutcheon · Answer

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

Balu_b3xap5 · Answer

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 · Answer

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