Re: Problems with 8.3

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(at)gmail(dot)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.
>