PostgreSQL Bugs - BUG #2060: Issue with Data base connection

Author

BUG #2060: Issue with Data base connection

Manideep Kalisetty

2005-11-21, 9:24 am

The following bug has been logged online:

Bug reference: 2060
Logged by: Manideep Kalisetty
Email address: mani7deep@yahoo.com
PostgreSQL version: 7.2.2
Operating system: Windows and Linux
Description: Issue with Data base connection
Details:

I am using postgresql-8.1dev-402.jdbc3.jar JDBC driver and websphere
application server. Even though I am successfully closing connections, the
error message I am receivng is "Backend start-up failed: FATAL 1: Sorry,
too many clients already". Please refer to the Exception report below:

[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R
org.postgresql.util.PSQLException: Backend start-up failed: FATAL 1: Sorry,
too many clients already
..
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
org.postgresql.core.v2. ConnectionFactoryImp
l. readStartupMessages(
ConnectionF
actoryImpl.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
org.postgresql.core.v2. ConnectionFactoryImp
l. openConnectionImpl(C
onnectionFa
ctoryImpl.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
org.postgresql.core.ConnectionFactory. openConnection(Conne
ctionFactory.java(
Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
org.postgresql.jdbc2. AbstractJdbc2Connect
ion.<init> (AbstractJdbc2Connec
tion.
java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
org.postgresql.jdbc3. AbstractJdbc3Connect
ion.<init> (AbstractJdbc3Connec
tion.
java(Inlined Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java(Inlined
Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
org.postgresql.Driver. makeConnection(Drive
r.java(Inlined Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
org.postgresql.Driver.connect(Driver.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
java.sql.DriverManager. getConnection(Driver
Manager.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
java.sql.DriverManager. getConnection(Driver
Manager.java(Inlined Compiled
Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
kanbay.dao.DBAccess. getConnection(DBAcce
ss.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
kanbay.dao.ContributorsDAO. getContributorsOfThe
Month(ContributorsDA
O.java:11
9)
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
kanbay.com.GenericServlet. doPost(GenericServle
t.java:124)
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr R at
kanbay.com.GenericServlet. doGet(GenericServlet
.java:48)
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.servlet. StrictServletInstanc
e. doService(StrictServ
le
tInstance.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.servlet. StrictLifecycleServl
et. _service(StrictLifec
y
cleServlet.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.servlet.IdleServletState. service(StrictLifecy
cleServ
let.java:313)
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.servlet. StrictLifecycleServl
et. service(StrictLifecy
c
leServlet.java(Inlined Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.servlet.ServletInstance. service(ServletInsta
nce.java
(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.servlet. ValidServletReferenc
eState.dispatch(ValidSer
vletReferenceState.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.servlet. ServletInstanceRefer
ence.dispatch(ServletIns
tanceReference.java(Inlined Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.webapp. WebAppRequestDispatc
her. handleWebAppDispatch
(
WebAppRequestDispatc
her.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.webapp. WebAppRequestDispatc
her. dispatch(WebAppReque
s
tDispatcher.java(Compiled Code))
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.webapp. WebAppRequestDispatc
her. forward(WebAppReques
t
Dispatcher.java:200)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.srt.WebAppInvoker. doForward(WebAppInvo
ker.java:119)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.srt.WebAppInvoker. handleInvocationHook
(WebAppInvoker
..java:276)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(C
achedInvocation.java:71)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.cache.invocation. CacheableInvocationC
ontext.invoke(C
acheableInvocationCo
ntext.java:116)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.srp. ServletRequestProces
sor. dispatchByURI(Servle
tReq
uestProcessor.java:186)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.oselistener. OSEListenerDispatche
r.service(OSEListene
r.java:334)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.webcontainer.http.HttpConnection. handleRequest(HttpCo
nnection.jav
a:56)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.http.HttpConnection. readAndHandleRequest
(HttpConnection.java:618)

[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr R at
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Kris Jurka

2005-11-21, 8:25 pm

On Mon, 21 Nov 2005, Manideep Kalisetty wrote:

> Bug reference: 2060
> Email address: mani7deep@yahoo.com
> PostgreSQL version: 7.2.2
> Description: Issue with Data base connection
> Details:
>
> I am using postgresql-8.1dev-402.jdbc3.jar JDBC driver and websphere
> application server. Even though I am successfully closing connections, the
> error message I am receivng is "Backend start-up failed: FATAL 1: Sorry,
> too many clients already". Please refer to the Exception report below:
>

Well, something is leaving connections open. Checking the results of
SELECT * FROM pg_stat_activity; will tell you what database and username
they are connected to which may help. While this code doesn't appear to
be using a connection pool, perhaps you have another application that is
using a pool that is configured to open too many connections? Still, the
most likely cause is a coding error failing to close connections.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links