Re: BUG #10545: The connection has been closed

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #10545: The connection has been closed
Date: 2014-06-07 13:56:14
Message-ID: 1402149374581-5806417.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message hannes.janetzek@gmail.com 2014-06-07 16:11:01 Re: BUG #10542: infinite loop in index.c when trying to reindex system tables (probably corrupted db state)
Previous Message Michael Paquier 2014-06-07 08:49:09 Re: BUG #10548: NpgsqlException - ERROR: 57014: canceling statement due to user request