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

From David G Johnston
Subject Re: BUG #10545: The connection has been closed
Date
Msg-id 1402149374581-5806417.post@n5.nabble.com
Whole thread Raw
In response to BUG #10545: The connection has been closed  (surbhu06@gmail.com)
List 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.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #10548: NpgsqlException - ERROR: 57014: canceling statement due to user request
Next
From: Kevin Grittner
Date:
Subject: Re: uninterruptable loop: concurrent delete in progress within table