Re: BUG #10545: The connection has been closed

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: surbhu06(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #10545: The connection has been closed
Date: 2014-06-07 07:59:44
Message-ID: CAB7nPqTsDhhWF4ZHEyC+3AJpx0edKAbj+5D3Z_NEWmzVDL--NA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Jun 6, 2014 at 2:49 PM, <surbhu06(at)gmail(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 10545
> Logged by: Suraj Sunar
> Email address: surbhu06(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2014-06-07 08:39:10 Re: BUG #10547: Query too long with order and limit
Previous Message Joe Conway 2014-06-06 23:21:44 Re: BUG #10544: I cannot canceling query during computing of R