Database Connectivity Issue with DB Lookup

From: Ashwani Kumar B <ashwani(dot)b(dot)kumar(at)ericsson(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Database Connectivity Issue with DB Lookup
Date: 2018-08-27 07:33:15
Message-ID: VI1PR07MB351853F5DD3BCA949DF88167C00B0@VI1PR07MB3518.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team

I am facing database connectivity issue while using database lookup, issue is that database table keep increasing connections to the database without pooling or releasing earlier connections.
These connections are keep increasing after every 30 minutes (update interval) and cause database unreachability after approaching maximum number of connections reached (100).

Logs:
Failed to run background job.
TableUpdater couldn't update gmp_pre_post_1.
Unable to update memory database lookup table gmp_pre_post_1, Update the table manually or it will update automatically at next update interval.
Failed to connect to the database, Max number of retry reached.
Failed to connect to the PostgreSQL database fm_db_prepost.FATAL: sorry, too many clients already

Regards,

Ashwani Kumar
Solution Architect
Ericsson India Global Services Private Limited
Mobile : +91 9999771339
Skype ID : Ashwani.k.07
www.ericsson.com<http://www.ericsson.com/>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-08-27 08:22:47 Re: Database Connectivity Issue with DB Lookup
Previous Message Mariel Cherkassky 2018-08-26 16:42:06 Re: Could not open file "pg_subtrans/01EB"