Thread: BUG #11910: Database connection exhaustion

BUG #11910: Database connection exhaustion

From
nisam76@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      11910
Logged by:          nissam
Email address:      nisam76@gmail.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

Re: BUG #11910: Database connection exhaustion

From
John R Pierce
Date:
On 11/8/2014 5:16 AM, nisam76@gmail.com wrote:
> LOG:  connection received: host=127.0.0.1 port=62175
> LOG:  connection authorized: user=admin database=truesight

some pierce of external software is making that connection, and not
disconnecting.





--
john r pierce                                      37N 122W
somewhere on the middle of the left coast