Database connection not closed properly

Troubleshooting
#1
  • Is this your first time deploying Airbyte: No
  • OS Version / Instance: Ubuntu 20.04 / ec2
  • Memory / Disk: 32Gb / 500Gb SSD
  • Deployment: Docker
  • Airbyte Version: 0.35.15-alpha
  • Description: Connections to the database are not being closed properly. After a all the connections to the database are used and airbyte server is not able to connect to posgres db. This results in the scheduled job not working etc. Can you please check this issue.

Restarting the server resolves the issue temporarily. this keeps on happening very frequently. Earlier it used to work fine without any problems

#3

Can you run this in the airbyte-db to identify the open connections?

select pid, datname, usename, application_name, query_start, wait_event_type, wait_event from pg_stat_activity;

#4

Here are the results of the query

MicrosoftTeams-image (3)
MicrosoftTeams-image (3)1920×599 133 KB

#5

Prudhvi doens’t look anything strange in your image. Does the problem continue?

#6

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.

#7