Обсуждение: BUG #10545: The connection has been closed

Поиск
Список
Период
Сортировка

BUG #10545: The connection has been closed

От
surbhu06@gmail.com
Дата:
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]

Re: BUG #10545: The connection has been closed

От
Michael Paquier
Дата:
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

Re: BUG #10545: The connection has been closed

От
David G Johnston
Дата:
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.