X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 85B55D1B171 for ; Mon, 2 Aug 2004 14:56:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38979-04 for ; Mon, 2 Aug 2004 17:56:50 +0000 (GMT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 4634FD1B184 for ; Mon, 2 Aug 2004 14:56:49 -0300 (ADT) Received: from mail63.csoft.net (leary3.csoft.net [63.111.22.74]) by www.postgresql.com (Postfix) with SMTP id B4A0BCF4CDE for ; Mon, 2 Aug 2004 14:56:32 -0300 (ADT) Received: (qmail 15074 invoked by uid 1112); 2 Aug 2004 17:44:24 -0000 Date: Mon, 2 Aug 2004 12:44:24 -0500 (EST) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: =?iso-8859-1?q?Smita=20Marda?= Cc: pgsql-sql@postgresql.org Subject: Re: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) In-Reply-To: <20040802065125.3772.qmail@web53104.mail.yahoo.com> Message-ID: References: <20040802065125.3772.qmail@web53104.mail.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/14 X-Sequence-Number: 18511 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