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

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

From: Antonio Rodriguez Anaya <arodriguez(at)dia(dot)uned(dot)es>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org,Andres Olarte <olarte(dot)andres(at)gmail(dot)com>
Subject: Re: ERROR: The backend has broken the connection -- AND: FATAL:
Date: 2006-01-30 18:08:50
Message-ID: f4a4b8f7bd0376c61e8d9c854e10fd08@dia.uned.es (view raw or whole thread)
Thread:
Lists: pgsql-jdbc
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.

In response to

Responses

pgsql-jdbc by date

Next:From: Marc HerbertDate: 2006-01-30 19:23:35
Subject: Re: encoding question
Previous:From: Kris JurkaDate: 2006-01-30 17:08:40
Subject: Re: encoding question

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