BUG #2060: Issue with Data base connection - Mailing list pgsql-bugs

From Manideep Kalisetty
Subject BUG #2060: Issue with Data base connection
Date
Msg-id 20051121050848.30A05F0B91@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #2060: Issue with Data base connection
List pgsql-bugs
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.ConnectionFactoryImpl.readStartupMessages(ConnectionF
actoryImpl.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr     R     at
org.postgresql.core.v2.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa
ctoryImpl.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr     R     at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java(
Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr     R     at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.
java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr     R     at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.
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(Driver.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(DriverManager.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr     R     at
java.sql.DriverManager.getConnection(DriverManager.java(Inlined Compiled
Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr     R     at
kanbay.dao.DBAccess.getConnection(DBAccess.java(Compiled Code))
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr     R     at
kanbay.dao.ContributorsDAO.getContributorsOfTheMonth(ContributorsDAO.java:11
9)
[11/21/05 10:28:54:836 IST] 50b9631a SystemErr     R     at
kanbay.com.GenericServlet.doPost(GenericServlet.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.StrictServletInstance.doService(StrictServle
tInstance.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServ
let.java:313)
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java(Inlined Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java
(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidSer
vletReferenceState.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletIns
tanceReference.java(Inlined Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java(Compiled Code))
[11/21/05 10:28:54:846 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java(Compiled Code))
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java:200)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.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.CacheableInvocationContext.invoke(C
acheableInvocationContext.java:116)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java:186)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListene
r.java:334)
[11/21/05 10:28:54:867 IST] 50b9631a SystemErr     R     at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.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)

pgsql-bugs by date:

Previous
From: "Chris Storah"
Date:
Subject: BUG #2059: PGConnect fails when used in a thread
Next
From: "Florian Steinel"
Date:
Subject: BUG #2061: pg_dumpall -f not supported