Re: Problems with 8.3 - Mailing list pgsql-general

Ok - lookint at the pg log, it appears that the server process is seg
faulting :(.  This might conceivably be my fault.  I have 3 stored
procedures written in C, but they've been on the server for months,
and unless I didn't deploy them correctly originally I don't think
it's them.

I'm thinking I need a core file.  I'm guessing I just restart
postgresql from a user whos core file size limit is set to non zero?

Alex

On Thu, Mar 6, 2008 at 3:49 PM, Alex Turner <armtuk@gmail.com> wrote:
> I'm getting the back end closing connections early for some reason.
>  Here is an exception report from my servlet.  This first started
>  happening with my instance of Trac, but now it's happening to my Java
>  apps too.  I hope someone can shed some light on what is going on
>  here.
>
>  Alex
>
>
>  HTTP Status 500 -
>
>  type Exception report
>
>  message
>
>  description The server encountered an internal error () that prevented
>  it from fulfilling this request.
>
>  exception
>
>  org.apache.jasper.JasperException: javax.servlet.ServletException:
>  javax.servlet.jsp.JspException:
>
>
>         select venue,
>  city, a.state from venue a, city b, subscriber c where
>  a.city_id=b.city_id and
>  distance(deg2rad(c.latitude),deg2rad(c.longitude), deg2rad(a.latitude),
>  deg2rad(a.longitude))<60.0 and c.subscriber_id=?
>
>
>
>
>         : An I/O
>  error occured while sending to the backend.
>
>  org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
>
>  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
>
>  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
>
>  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
>
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>
>  root cause
>
>  javax.servlet.ServletException: javax.servlet.jsp.JspException:
>
>
>         select venue,
>  city, a.state from venue a, city b, subscriber c where
>  a.city_id=b.city_id and
>  distance(deg2rad(c.latitude),deg2rad(c.longitude), deg2rad(a.latitude),
>  deg2rad(a.longitude))<60.0 and c.subscriber_id=?
>
>
>
>
>         : An I/O
>  error occured while sending to the backend.
>
>  org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
>
>  org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspService(find_005fsubscriber_jsp.java:420)
>
>  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
>
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
>
>  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
>
>  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
>
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>
>  root cause
>
>  org.postgresql.util.PSQLException: An I/O error occured while
>  sending to the backend.
>
>  org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:217)
>
>  org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>
>  org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
>
>  org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
>
>  org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:215)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspx_meth_sql_005fquery_005f2(find_005fsubscriber_jsp.java:1388)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspx_meth_c_005fif_005f6(find_005fsubscriber_jsp.java:933)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspx_meth_c_005fforEach_005f0(find_005fsubscriber_jsp.java:752)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspx_meth_c_005fif_005f2(find_005fsubscriber_jsp.java:543)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspService(find_005fsubscriber_jsp.java:220)
>
>  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
>
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
>
>  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
>
>  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
>
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>
>  root cause
>
>  java.io.EOFException
>
>  org.postgresql.core.PGStream.ReceiveChar(PGStream.java:257)
>
>  org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1165)
>
>  org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
>
>  org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>
>  org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
>
>  org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
>
>  org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:215)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspx_meth_sql_005fquery_005f2(find_005fsubscriber_jsp.java:1388)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspx_meth_c_005fif_005f6(find_005fsubscriber_jsp.java:933)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspx_meth_c_005fforEach_005f0(find_005fsubscriber_jsp.java:752)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspx_meth_c_005fif_005f2(find_005fsubscriber_jsp.java:543)
>
>  org.apache.jsp.admin.find_005fsubscriber_jsp._jspService(find_005fsubscriber_jsp.java:220)
>
>  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
>
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
>
>  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
>
>  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
>
>  javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>
>  note The full stack trace of the root cause is available in the Apache
>  Tomcat/6.0.14 logs.
>