Re: ERROR: The backend has broken the connection -- AND: FATAL:

Hi,

I have followed the recommendations and I have installed in other
computer the newest versión and I have added "?loglevel=2" to the end
on my JDBC URL. The results are:

JDBC: 8.2; Postgresql: 8.2

Java error:

18:36:11.202 (1) simple execute,
handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandl
er(at)2c3327, maxRows=0, fetchSize=0, flags=17
18:36:11.204 (1) FE=> Parse(stmt=null,query="SELECT
insert_op_hour('[samap-opening-plan-23431-act-23432]', 'opening_hours',
2, 2) AS id",oids={})
18:36:11.207 (1) FE=> Bind(stmt=null,portal=null)
18:36:11.209 (1) FE=> Describe(portal=null)
18:36:11.212 (1) FE=> Execute(portal=null,limit=0)
18:36:11.215 (1) FE=> Sync
18:36:11.241 (1) <=BE ErrorMessage(ERROR: insufficient data left in
message)
org.postgresql.util.PSQLException: ERROR: insufficient data left in
message
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1514)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1299)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
190)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:332)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:231)
at infoplan.GetPlanInfo.SelDB(GetPlanInfo.java:90)
at infoplan.ReadPlanFile.TimeToDB(ReadPlanFile.java:256)
at infoplan.ReadPlanFile.<init>(ReadPlanFile.java:162)
at infoplan.ReadPlanFile.main(ReadPlanFile.java:334)
SQLException: SQLState(08P01)
18:36:11.296 (1) <=BE ReadyForQuery(I)
Error en la ejecucion de: SELECT
insert_op_hour('[samap-opening-plan-23431-act-23432]', 'opening_hours',
2, 2) AS id ErrorCode: 0 Message: ERROR: insufficient data left in
message State: 08P01

Exception in thread "main" java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:259)
at infoplan.ReadPlanFile.TimeToDB(ReadPlanFile.java:257)
at infoplan.ReadPlanFile.<init>(ReadPlanFile.java:162)
at infoplan.ReadPlanFile.main(ReadPlanFile.java:334)

Postgrsql error:

LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database
"postgres"
ERROR: insufficient data left in message
LOG: unexpected EOF on client connection

JDBC: 8.2; Postgresql: 7.3

Java error:
18:42:38.110 (1) FE=> Query("SELECT
insert_op_hour('[samap-opening-plan-23431-act-23432]', 'opening_hours',
15, 15) AS id")
18:42:38.175 (1) <=BE PortalName(blank)
18:42:38.176 (1) <=BE RowDescription(1)
18:42:38.177 (1) <=BE DataRow
18:42:38.178 (1) <=BE CommandStatus(SELECT)
18:42:38.178 (1) <=BE ReadyForQuery
Ejecutando: SELECT
insert_op_hour('[samap-opening-plan-23431-act-23432]', 'opening_hours',
15, 15) AS id
558
18:42:38.179 (1) FE=> Query("SELECT insert_timetable
('[samap-timetable-plan-23431-act-23432]', 'timetable') AS id")
18:42:38.179 (1) <=BE ErrorResponse(FATAL: Socket command type
unknown)
org.postgresql.util.PSQLException: FATAL: Socket command type unknown
at
org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage(QueryExecut
orImpl.java:542)
at
org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:466)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:
364)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:
258)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:332)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:231)
at infoplan.GetPlanInfo.SelDB(GetPlanInfo.java:90)
at infoplan.ReadPlanFile.TimeToDB(ReadPlanFile.java:262)
at infoplan.ReadPlanFile.<init>(ReadPlanFile.java:162)
at infoplan.ReadPlanFile.main(ReadPlanFile.java:334)
SQLException: SQLState()
18:42:38.188 (1) FE=> Terminate
18:42:38.188 (1) Discarding IOException on close:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
at org.postgresql.core.PGStream.flush(PGStream.java:500)
at
org.postgresql.core.v2.ProtocolConnectionImpl.close(ProtocolConnectionIm
pl.java:130)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:
368)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:
258)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:332)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:231)
at infoplan.GetPlanInfo.SelDB(GetPlanInfo.java:90)
at infoplan.ReadPlanFile.TimeToDB(ReadPlanFile.java:262)
at infoplan.ReadPlanFile.<init>(ReadPlanFile.java:162)
at infoplan.ReadPlanFile.main(ReadPlanFile.java:334)
org.postgresql.util.PSQLException: Un error de E/S ha ocurrido mientras
se enviaba al backend.
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:
369)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:
258)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:332)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:231)
at infoplan.GetPlanInfo.SelDB(GetPlanInfo.java:90)
at infoplan.ReadPlanFile.TimeToDB(ReadPlanFile.java:262)
at infoplan.ReadPlanFile.<init>(ReadPlanFile.java:162)
at infoplan.ReadPlanFile.main(ReadPlanFile.java:334)
SQLException: SQLState(08006)
Error en la ejecucion de: SELECT insert_timetable
('[samap-timetable-plan-23431-act-23432]', 'timetable') AS id
ErrorCode: 0 Message: FATAL: Socket command type unknown State:

Exception in thread "main" java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:259)
at infoplan.ReadPlanFile.TimeToDB(ReadPlanFile.java:264)
at infoplan.ReadPlanFile.<init>(ReadPlanFile.java:162)
at infoplan.ReadPlanFile.main(ReadPlanFile.java:334)

Postgresql error:

LOG: database system is ready
FATAL: unsupported frontend protocol
FATAL: Socket command type unknown

Note: the error happens on versión 7.3 in the following query than on
versión 8.2.

Thanks,

Toni.