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(PG_Stream.jav a:143)
at org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:68)
at org.postgresql.Connection.ExecSQL(Connection.java: 398)
at org.postgresql.jdbc2.Statement.execute(Statement.j ava:130)
at org.postgresql.jdbc2.Statement.executeUpdate(State ment.java:73)
org.postgresql.jdbc2.PreparedStatement.executeUpda te(PreparedStatement.java
at :113)
at com.salmonllc.sql.DSDataSourceJDBC.insertRow(DSDat aSourceJDBC.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(C ontractWrapModel.java:381)
com.eq.controller.operations.ContractDetailsContro ller.submitPerformed(Cont
at ractDetailsController.java:378)


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


Thanks and Regards,
Shilpa.




---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

PostgreSQL Bugs List wrote:
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.

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




---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly