BUG #1284: The backend has broken the connection.

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:

We are getting the following error:
The backend has broken the connection. Possibly the action you have
attempted has caused it to close.

The information you've provided is quite useless for resolving a
server-side problem :-(. What query were you executing? What shows up
in the postmaster log? If there's a server core dump, get a backtrace
from it with gdb.

regards, tom lane

PostgreSQL Bugs List wrote:

The following bug has been logged online:

Bug reference: 1284
Logged by: Shilpa Upadhye

Email address: snupadhye@hotmail.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(PG_Stream.java:143)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:68)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java
at :113)
at com.salmonllc.sql.DSDataSourceJDBC.insertRow(DSDataSourceJDBC.java:182)
at com.salmonllc.sql.DataStore.update(DataStore.java:1977)
at com.salmonllc.sql.DataStore.update(DataStore.java:1907)
com.eq.model.operations.contractChargeModel.update(contractChargeModel.java
at :426)
at
com.eq.model.operations.ContractWrapModel.update(ContractWrapModel.java:381)
com.eq.controller.operations.ContractDetailsController.submitPerformed(Cont
at ractDetailsController.java:378)

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.

Regards
Gaetano Mendola