Обсуждение: Database Connectivity Issue with DB Lookup

Поиск
Список
Период
Сортировка

Database Connectivity Issue with DB Lookup

От
Ashwani Kumar B
Дата:

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,

Description: Description: Description: Description: line

Ashwani Kumar

Solution Architect
Ericsson India Global Services Private Limited

Mobile : +91 9999771339

Skype ID : Ashwani.k.07
www.ericsson.com

 

Вложения

Re: Database Connectivity Issue with DB Lookup

От
Shreeyansh Dba
Дата:

H
i  Ashwani,

It seems you have reached the maximum connection limit set in your configuration postgresql.conf file. You need to increase max connection in postgresql.conf and this required restart.

Hope this helps.

On Mon, Aug 27, 2018 at 1:03 PM Ashwani Kumar B <ashwani.b.kumar@ericsson.com> wrote:

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,

Description: Description: Description: Description: line

Ashwani Kumar

Solution Architect
Ericsson India Global Services Private Limited

Mobile : +91 9999771339

Skype ID : Ashwani.k.07
www.ericsson.com

 

Вложения

Re: Database Connectivity Issue with DB Lookup

От
Scott Ribe
Дата:
> On Aug 27, 2018, at 1:33 AM, Ashwani Kumar B <ashwani.b.kumar@ericsson.com> wrote:
>
> ...issue is that database table keep increasing connections to the database...

You need to figure out why your client always opens new connections and never closes them, then fix that bug. Until
thenas a workaround you could change that client to exit after each update, or set up a periodic task to kill it.

Re: Database Connectivity Issue with DB Lookup

От
Scott Ribe
Дата:
> On Aug 27, 2018, at 1:33 AM, Ashwani Kumar B <ashwani.b.kumar@ericsson.com> wrote:
>
> ...issue is that database table keep increasing connections to the database...

You need to figure out why your client always opens new connections and never closes them, then fix that bug. Until
thenas a workaround you could change that client to exit after each update, or set up a periodic task to kill it.