Обсуждение: 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]
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
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.