Hi,
I have been using SOFIA framework and postgres
database as a backend.
i noticed as the database started growing larger..
today
encountered some error while firing a query to save a
record. The table in which i am going to save the
record, has two columns having datatype text. the data
of these two column contains 2652 and 5817 characters.
If I reduce some characters from both columns, it
saves the record successfully. But i reduce some
characters from only single column(whether it has 2652
chars or 5817 chars whereas both have the same
datatype), it gives me the following error :--
[Stack Trace
The backend has broken the connection. Possibly the
action you have attempted has caused it to close.
at
org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:68)
at
org.postgresql.Connection.ExecSQL(Connection.java:398)
at
org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at
org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:113)
at
com.salmonllc.sql.DSDataSourceJDBC.updateRow(DSDataSourceJDBC.java:753)
at
com.salmonllc.sql.DataStore.update(DataStore.java:1965)
at
com.salmonllc.sql.DataStore.update(DataStore.java:1907)
at
com.eq.model.operations.contractChargeModel.update(contractChargeModel.java:426)
at
com.eq.model.operations.ContractWrapModel.update(ContractWrapModel.java:381)
at
com.eq.controller.operations.contractDefineVariableChargesController.submitPerformed(contractDefineVariableChargesController.java:153)
at
com.salmonllc.html.HtmlSubmitButton.executeEvent(HtmlSubmitButton.java:126)
at
com.salmonllc.jsp.JspForm.executeEvent(JspForm.java:270)
at
com.salmonllc.html.HtmlContainer.executeEvent(HtmlContainer.java:82)
at
com.salmonllc.html.HtmlPage.processParms(HtmlPage.java:1263)
at
com.salmonllc.jsp.JspController.doPost(JspController.java:554)
at
com.salmonllc.jsp.tags.PageTag.doStartTag(PageTag.java:188)
at
org.apache.jsp.contractDefineVariableCharges_jsp._jspx_meth_salmon_page_0(contractDefineVariableCharges_jsp.java:164)
at
org.apache.jsp.contractDefineVariableCharges_jsp._jspService(contractDefineVariableCharges_jsp.java:130)
at
com.salmonllc.jsp.JspServlet.service(JspServlet.java:300)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
com.eq.src.compressionFilters.CompressionFilter.doFilter(CompressionFilter.java:238)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
at java.lang.Thread.run(Thread.java:536)
___________________________________________________________ALL-NEW Yahoo! Messenger -
all new features - even more fun! http://uk.messenger.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
