BUG #10545: The connection has been closed
The following bug has been logged on the website:
Bug reference: 10545
Logged by: Suraj Sunar
Email address: surbhu06@gmail.com
PostgreSQL version: 9.1.13
Operating system: Window/linux
Description:
Dear Team,
We are migrating database from oracle to postgres and its all done by now.
But we are facing problem after multiple logins.
All transaction is working fine but suddenly the connection get closed.
Kindly help in the matter.
17:11:40,424 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/bvm].[faces]]
Servlet.service() for servlet faces threw exception:
org.postgresql.util.PSQLException: This connection has been closed.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
[:]
at
org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:274)
[:]
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:467)
[:6.1.0.Final]
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:462)
[:6.1.0.Final]
at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:253)
[:6.1.0.Final]
at
com.ultimatix.framework.jsf.util.UserProfile.registerProfile(UserProfile.java:55)
[:]
at
com.ultimatix.framework.jsf.util.UserBean.validateLoginPage(UserBean.java:560)
[:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_22]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [:1.6.0_22]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
[:1.6.0_22]
at java.lang.reflect.Method.invoke(Unknown Source) [:1.6.0_22]
at
org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
[:1.1.5]
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
[:1.1.5]
at javax.faces.component.UICommand.broadcast(UICommand.java:109) [:1.1.5]
at
org.ajax4jsf.framework.ajax.AjaxViewRoot.processEvents(AjaxViewRoot.java:180)
[:1.1.1]
at
org.ajax4jsf.framework.ajax.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:158)
[:1.1.1]
at
org.ajax4jsf.framework.ajax.AjaxViewRoot.processApplication(AjaxViewRoot.java:346)
[:1.1.1]
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Fri, Jun 6, 2014 at 2:49 PM, <surbhu06@gmail.com> wrote:
The following bug has been logged on the website:
Bug reference: 10545
Logged by: Suraj Sunar
Email address: surbhu06@gmail.com
PostgreSQL version: 9.1.13
Operating system: Window/linux
Description:Dear Team,
We are migrating database from oracle to postgres and its all done by now.
But we are facing problem after multiple logins.All transaction is working fine but suddenly the connection get closed.
Kindly help in the matter.17:11:40,424 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/bvm].[faces]]
Servlet.service() for servlet faces threw exception:
org.postgresql.util.PSQLException: This connection has been closed.
This is not a bug related to Postgres itself. Btw, with the limited
amount of information you are providing, it is hard to guess why this
connection is being closed. You should have a look at your server logs
and check what is happening there. More verbose logging like setting
log_connections to on would be helpful to spot your problem.
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
surbhu06 wrote
The following bug has been logged on the website:
Bug reference: 10545
Logged by: Suraj Sunar
Email address:
surbhu06@
PostgreSQL version: 9.1.13
Operating system: Window/linux
Description:Dear Team,
We are migrating database from oracle to postgres and its all done by now.
But we are facing problem after multiple logins.All transaction is working fine but suddenly the connection get closed.
Kindly help in the matter.17:11:40,424 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/bvm].[faces]]
Servlet.service() for servlet faces threw exception:
org.postgresql.util.PSQLException: This connection has been closed.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
[:]
at
org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:274)
With the limited info provided my best guess is that you are improperly
sharing connections between threads.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-10545-The-connection-has-been-closed-tp5806351p5806417.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs