BUG #14556: Sorry, Too many clients already

From: naveenallin(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14556: Sorry, Too many clients already
Date: 2017-02-20 08:24:13
Message-ID: 20170220082413.1256.75340@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: 14556
Logged by: Naveen Chalmeti
Email address: naveenallin(at)gmail(dot)com
PostgreSQL version: 9.6.1
Operating system: Ubuntu 14.04 LTS
Description:

We are using postgresql(9.6.1) for more than three months and every
two/three days once we need to restart our servers with an error "Sorry, too
many connections already". Using a script we found that the postgresql
driver query listed below is not getting closed and remain unclosed.

16384 | SGDatabase | 18953 | 10 | postgres | |
127.0.0.1 | | 57979 | 2017-02-17
13:27:31.990945+05:30 | | 2017-02-17
13:29:56.433781+05:30 | 2017-02-17 13:29:56.435756+05:30 | |
| idle | | | select
n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen,
a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid,
pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype
else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner
join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 22796)
inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum >
0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid =
a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum

this query was executed three days before and remains unclosed.

We are using unixODBC driver and enabled connection pooling for 5mins. I'm
not sure whether this causing any problem.

Please help us out.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message coladict 2017-02-20 14:11:04 BUG #14558: to_timestamp() format lies about supporting timezone
Previous Message Maphumulo, Ncebo 2017-02-20 07:56:06 Posgresql 9.6.1 Bug