pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
2+ messages / 2 participants
[nested] [flat]

* org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
@ 2004-08-02 06:51  Smita Marda <smitamarda@yahoo.co.uk>
  0 siblings, 1 reply; 2+ messages in thread

From: Smita Marda @ 2004-08-02 06:51 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
@ 2004-08-02 17:44  Kris Jurka <books@ejurka.com>
  parent: Smita Marda <smitamarda@yahoo.co.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: Kris Jurka @ 2004-08-02 17:44 UTC (permalink / raw)
  To: Smita Marda <smitamarda@yahoo.co.uk>; +Cc: pgsql-sql



On Mon, 2 Aug 2004, [iso-8859-1] Smita Marda wrote:

> 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 :--
> 
> 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

This looks like it could be a server crash.  Does the server's log show 
anything informative?  Also you don't mention what server and JDBC driver 
version you are using, but the stacktrace tells me the driver must be from 
the 7.2 or earlier release.  If the server log doesn't reveal anything you 
might try upgrading the JDBC driver to a later version.

Kris Jurka



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-08-02 17:44 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-02 06:51 org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) Smita Marda <smitamarda@yahoo.co.uk>
2004-08-02 17:44 ` Kris Jurka <books@ejurka.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox