pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase Connectivity Issue with DB Lookup
4+ messages / 3 participants
[nested] [flat]
* Database Connectivity Issue with DB Lookup
@ 2018-08-27 07:33 Ashwani Kumar B <ashwani.b.kumar@ericsson.com>
0 siblings, 3 replies; 4+ messages in thread
From: Ashwani Kumar B @ 2018-08-27 07:33 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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/;
Attachments:
image001.gif (image/gif, 1.4K) download
view image
* Re: Database Connectivity Issue with DB Lookup
@ 2018-08-27 08:22 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Ashwani Kumar B <ashwani.b.kumar@ericsson.com>
2 siblings, 0 replies; 4+ messages in thread
From: Shreeyansh Dba @ 2018-08-27 08:22 UTC (permalink / raw)
To: Ashwani Kumar B <ashwani.b.kumar@ericsson.com>; +Cc: pgsql-admin@lists.postgresql.org
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,*
>
> [image: 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
>
>
>
Attachments:
image001.gif (image/gif, 1.4K) download
view image
image001.gif (image/gif, 1.4K) download
view image
* Re: Database Connectivity Issue with DB Lookup
@ 2018-08-27 19:14 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Ashwani Kumar B <ashwani.b.kumar@ericsson.com>
2 siblings, 0 replies; 4+ messages in thread
From: Scott Ribe @ 2018-08-27 19:14 UTC (permalink / raw)
To: Ashwani Kumar B <ashwani.b.kumar@ericsson.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
> 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 then as a workaround you could change that client to exit after each update, or set up a periodic task to kill it.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Database Connectivity Issue with DB Lookup
@ 2018-08-28 03:31 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Ashwani Kumar B <ashwani.b.kumar@ericsson.com>
2 siblings, 0 replies; 4+ messages in thread
From: Scott Ribe @ 2018-08-28 03:31 UTC (permalink / raw)
To: Ashwani Kumar B <ashwani.b.kumar@ericsson.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
> 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 then as a workaround you could change that client to exit after each update, or set up a periodic task to kill it.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-08-28 03:31 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-08-27 07:33 Database Connectivity Issue with DB Lookup Ashwani Kumar B <ashwani.b.kumar@ericsson.com>
2018-08-27 08:22 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-08-27 19:14 ` Scott Ribe <scott_ribe@elevated-dev.com>
2018-08-28 03:31 ` Scott Ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox