API error | Community
Skip to main content
M
MANDM123
Level 2
June 24, 2024
Solved

API error

  • June 24, 2024
  • 2 replies
  • 801 views

when trying an API call for one of our ACS instance it returns following error.

 

nPGS-220000 PostgreSQL error: connection to server at \"abc-mkt-stage4.chqkifxvjhq8.us-west-2.rds.amazonaws.com\" (xx.xx.xxx.xxx), port 5432 failed: FATAL:  remaining connection slots are reserved for non-replication superuser connections\

 

can someone let me know what this error means and how to fix this?

 

Thanks in advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

Hi Mandm123,

 

This issue typically requires a restart of the application or Apache, as it usually indicates a job that got hung up and is preventing the closure of connections.

 

Please reach out to Campaign Support, as they will need to involve the Campaign Ops (Infrastructure) team.

 

Regards,

Craig

2 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
June 24, 2024

Hi Mandm123,

 

This issue typically requires a restart of the application or Apache, as it usually indicates a job that got hung up and is preventing the closure of connections.

 

Please reach out to Campaign Support, as they will need to involve the Campaign Ops (Infrastructure) team.

 

Regards,

Craig

    vraghav
    Adobe Employee
    vraghavAdobe Employee
    Adobe Employee
    June 25, 2024

    @mandm123 The error is coming from Database where the connections available to Campaign are exhausted. An investigation in the matter will need help from support. If this is happening regularly, you will have to check what processes/workflows are running or if there are too many API calls landing in quick succession.

     

    You might have to rationalise the calls.

      Terms & ConditionsAccessibility statement

      Loading footer...