Received: from prodserver1.goatelecom.com ([210.212.161.28]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fABFmtm87115 for ; Sun, 11 Nov 2001 10:48:56 -0500 (EST) (envelope-from sharmad@goatelecom.com) Received: from sharmad.sanico.org by prodserver1.goatelecom.com (8.9.3/1.1.20.3/07Jul00-0916AM) id VAA0000001875; Sun, 11 Nov 2001 21:26:57 +0530 (IST) Received: (from sharmad@localhost) by sharmad.sanico.org (8.11.2/8.11.2) id fABFhFF00635; Sun, 11 Nov 2001 21:13:15 +0530 X-Authentication-Warning: sharmad.sanico.org: sharmad set sender to sharmad@goatelecom.com using -f Date: Sun, 11 Nov 2001 21:13:15 +0530 From: Sharmad Naik To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: error in postgresql Message-ID: <20011111211315.A630@goatelecom.com> Reply-To: Sharmad Naik References: <3bde7ee4.753.0@punweb01> <2628.1004478416@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <2628.1004478416@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Tue, Oct 30, 2001 at 04:46:56PM -0500 X-Archive-Number: 200111/169 X-Sequence-Number: 5553 Hi, Firstly I'm Sorry for the delay in replying. When I gave a search for core file I didn't seems to exist.pg_dump didnot create the core file well if i tried to even query the table of the database it would directly close the connection with the backend giving the prompt like #> and displaying a similar message shown below. Pls direct me. -TIA Sharmad Pls cc a copy to sharmad@softhome.net On Tue, Oct 30, 2001 at 04:46:56PM -0500, Tom Lane wrote: > sharmad@goatelecom.com writes: > > postgres@linux:~ > pg_dumpall > alllms_30-10-2001.bak > > SQL query to dump the contents of Table 'common_to_three' did not execute. Explanation from backend: 'pqReadData() -- backend closed the channel unexpectedly. > > This probably means the backend terminated abnormally > > before or while processing the request. > > '. > > The query was: 'COPY "common_to_three" TO stdout; > > Hm. The only cases I can recall of backend crashes during COPY OUT > were caused by corrupted data. Do you get similar failures if you > do "SELECT * FROM common_to_three"? > > You could investigate more closely by using gdb to look at the core > file left by the crashed backend. A backtrace would give us at least > some idea of the nature of the problem. -- Feel free to contact me (flames about my english and the useless of this driver will be redirected to /dev/null, oh no, it's full...). (Michael Beck, describing the PC-speaker sound device) --------------------- __ _ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/ "What we cannot speak about we must pass over in silence." Ludwig Wittgenstein (1889-1951), Austrian philosopher