Обсуждение: BUG #1284: The backend has broken the connection.

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)


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


Thanks and Regards,
Shilpa.

"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