Skip site navigation (1) Skip section navigation (2)

Re: BUG #1284: The backend has broken the connection.

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: snupadhye(at)hotmail(dot)com
Subject: Re: BUG #1284: The backend has broken the connection.
Date: 2004-10-12 14:08:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
PostgreSQL Bugs List wrote:
> The following bug has been logged online:
> Bug reference:      1284
> Logged by:          Shilpa Upadhye
> Email address:      snupadhye(at)hotmail(dot)com
> PostgreSQL version: 8.0 Beta
> Operating system:   Redhat Linux 9.0
> Description:        The backend has broken the connection. 
> Details: 
> Hi,
> We have postgres 7.4.5 on Redhat Linux 9.0. We are using 
> jakarta-tomcat-4.1.27,jdk 1.4.x,SOFIA 2.1 and pg74.214.jdbc2.jar 
> We are getting the following error:
> The backend has broken the connection. Possibly the action you have 
> attempted has caused it to close. 
> 	at org.postgresql.PG_Stream.ReceiveChar(
> 	at org.postgresql.core.QueryExecutor.execute(
> 	at org.postgresql.Connection.ExecSQL(
> 	at org.postgresql.jdbc2.Statement.execute(
> 	at org.postgresql.jdbc2.Statement.executeUpdate(
> org.postgresql.jdbc2.PreparedStatement.executeUpdate(
> 	at :113) 
> 	at com.salmonllc.sql.DSDataSourceJDBC.insertRow(
> 	at com.salmonllc.sql.DataStore.update(
> 	at com.salmonllc.sql.DataStore.update(
> com.eq.model.operations.contractChargeModel.update(
> 	at :426) 
> 	at 
> com.eq.model.operations.ContractWrapModel.update( 
> com.eq.controller.operations.ContractDetailsController.submitPerformed(Cont
> 	at 

This doesn't help that much, for sure you are trying to perform an operation
that crash the backend, are you using a store procedure in C, are you using
third part contrib modules ? Could be also interesting see the postgresql log
at the time of crash in order to see what you were doing.

> Sometimes I also get the error 'Database is in recovery mode'

This is normal if you try to reconnect the DB immediately after the error above,
this because the engine perform a recovery after have close all connections.

Gaetano Mendola

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-10-12 19:52:24
Subject: Re: Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3
Previous:From: Tom LaneDate: 2004-10-12 14:02:52
Subject: Re: BUG #1284: The backend has broken the connection.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group