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?