Re: [JDBC] server process (PID 1188) exited with exit code - Mailing list pgsql-hackers

Here is what I get with loglevel=2

08:47:18.718 (1) PostgreSQL 8.2devel JDBC3 with SSL (build 503)
08:47:18.718 (1) Trying to establish a protocol version 3 connection to 
localhost:5432
08:47:18.859 (1)  FE=> StartupPacket(user=postgres, database=main, 
client_encoding=UNICODE, DateStyle=ISO)
08:47:19.218 (1)  <=BE AuthenticationOk
08:47:19.234 (1)  <=BE ParameterStatus(client_encoding = UNICODE)
08:47:19.234 (1)  <=BE ParameterStatus(DateStyle = ISO, MDY)
08:47:19.234 (1)  <=BE ParameterStatus(integer_datetimes = off)
08:47:19.234 (1)  <=BE ParameterStatus(is_superuser = on)
08:47:19.234 (1)  <=BE ParameterStatus(server_encoding = LATIN1)
08:47:19.234 (1)  <=BE ParameterStatus(server_version = 8.2beta1)
08:47:19.234 (1)  <=BE ParameterStatus(session_authorization = postgres)
08:47:19.234 (1)  <=BE ParameterStatus(standard_conforming_strings = off)
08:47:19.234 (1)  <=BE ParameterStatus(TimeZone = US/Eastern)
08:47:19.234 (1)  <=BE BackendKeyData(pid=3248,ckey=166035706)
08:47:19.234 (1)  <=BE ReadyForQuery(I)
08:47:19.234 (1)     compatible = 8.2
08:47:19.234 (1)     loglevel = 2
08:47:19.234 (1)     prepare threshold = 5
getConnection returning 
driver[className=org.postgresql.Driver,org.postgresql.Driver@747fa2]
08:47:19.296 (1) simple execute, 
handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@18352d8, 
maxRows=0, fetchSize=0, flags=17
08:47:19.296 (1)  FE=> Parse(stmt=null,query="select $1 from (select * from 
pg_database) t",oids={23})
08:47:19.296 (1)  FE=> Bind(stmt=null,portal=null,$1=<1>)
08:47:19.296 (1)  FE=> Describe(portal=null)
08:47:19.296 (1)  FE=> Execute(portal=null,limit=0)
08:47:19.296 (1)  FE=> Sync
08:47:19.718 (1)  FE=> Terminate
08:47:19.718 (1) Discarding IOException on close:
java.net.SocketException: Connection reset by peer: socket write errorat
java.net.SocketOutputStream.socketWrite0(NativeMethod)at java.net.SocketOutputStream.socketWrite(Unknown Source)at
java.net.SocketOutputStream.write(UnknownSource)at java.io.BufferedOutputStream.flushBuffer(Unknown Source)at
java.io.BufferedOutputStream.flush(UnknownSource)at org.postgresql.core.PGStream.flush(PGStream.java:532)at 
 
org.postgresql.core.v3.ProtocolConnectionImpl.close(ProtocolConnectionImpl.java:131)at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:215)at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)at
org.apache.jsp.Test_jsp._jspService(Test_jsp.java:104)at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)at
 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)at
 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)at 
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:831)at 
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1196)atjava.lang.Thread.run(Unknown Source)
 
org.postgresql.util.PSQLException: An I/O error occured while sending to the 
backend.at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:216)at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)at
org.apache.jsp.Test_jsp._jspService(Test_jsp.java:104)at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)at
 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)at
 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)at 
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:831)at 
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1196)atjava.lang.Thread.run(Unknown Source)
 
SQLException: SQLState(08006)

>From: Oliver Jowett <oliver@opencloud.com>
>To: Tom Lane <tgl@sss.pgh.pa.us>
>CC: Dave Cramer <pg@fastcrypt.com>,  JEAN-PIERRE PELLETIER 
><pelletier_32@sympatico.ca>, List <pgsql-jdbc@postgresql.org>,  
>PostgreSQL-development <pgsql-hackers@postgresql.org>
>Subject: Re: [HACKERS] [JDBC] server process (PID 1188) exited with exit 
>code
>Date: Wed, 25 Oct 2006 03:26:07 +0000
>
>Tom Lane wrote:
>
>>                        NULL,    /* let the backend deduce param type */
>
>I think the JDBC driver will be passing the int4 OID for the param type in 
>this case.
>
>Best thing is probably for the OP to run with loglevel=2 and see exactly 
>what's being sent, though.
>
>-O
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly