BUG #10545: The connection has been closed - Mailing list pgsql-bugs

From surbhu06@gmail.com
Subject BUG #10545: The connection has been closed
Date
Msg-id 20140606054910.2711.3367@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #10545: The connection has been closed  (Michael Paquier <michael.paquier@gmail.com>)
Re: BUG #10545: The connection has been closed  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-bugs
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]

pgsql-bugs by date:

Previous
From: macro.yu.yang@gmail.com
Date:
Subject: BUG #10544: I cannot canceling query during computing of R
Next
From: alamy@ltutech.com
Date:
Subject: BUG #10547: Query too long with order and limit