BUG #11910: Database connection exhaustion

From: nisam76(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11910: Database connection exhaustion
Date: 2014-11-08 13:16:13
Message-ID: 20141108131613.2524.55277@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11910
Logged by: nissam
Email address: nisam76(at)gmail(dot)com
PostgreSQL version: 9.3.5
Operating system: Windows 7
Description:

Number of database connection reaching the limit 100 though my application
doesn't do any activity.

The log says continuous update as below and each of this looks like creating
a new connection and not closing the same.
I set the following property in the postgresql.conf already.
extra_float_digits = 3
Appreciate your help on this.

LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
LOG: connection received: host=127.0.0.1 port=62175
LOG: connection authorized: user=admin database=truesight
LOG: duration: 0.000 ms
LOG: duration: 0.000 ms
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
LOG: connection received: host=127.0.0.1 port=62192
LOG: connection authorized: user=admin database=truesight
LOG: duration: 0.000 ms
LOG: duration: 0.000 ms
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
LOG: connection received: host=127.0.0.1 port=62208
LOG: connection authorized: user=admin database=truesight
LOG: duration: 0.000 ms
LOG: duration: 0.000 ms
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
LOG: connection received: host=127.0.0.1 port=62226
LOG: connection authorized: user=admin database=truesight
LOG: duration: 0.000 ms
LOG: duration: 0.000 ms
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message gavin.panella 2014-11-08 23:42:36 BUG #11919: Serializable isolation issue: one session seeing writes from another session.
Previous Message Michael Paquier 2014-11-08 06:00:43 Re: BUG #11903: Segmentation fault