From shreedhar@lucidindia.net Tue Mar 11 09:23:53 2003 X-Original-To: pgsql-admin@postgresql.org Received: from lucidindia.net (unknown [61.11.73.194]) by postgresql.org (Postfix) with ESMTP id 8408747601F; Tue, 11 Mar 2003 04:23:53 -0500 (EST) Received: from a4005 ([192.168.1.18]) by lucidindia.net (8.11.6/8.11.6) with SMTP id h2B9Nps00519; Tue, 11 Mar 2003 09:23:51 GMT Message-ID: <009401c2e7af$ed7d4c60$1201a8c0@a4005> From: "shreedhar" To: "Postgre Admin" , "Postgre General" Subject: server closed the connection unexpectedly Date: Tue, 11 Mar 2003 14:53:50 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0091_01C2E7DE.07295360" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200303/119 X-Sequence-Number: 7760 This is a multi-part message in MIME format. ------=_NextPart_000_0091_01C2E7DE.07295360 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, If I tried to do any transaction with database i am getting following error= . Server is restarting automatically very frequently. server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost Can any body tell what's the reason. Regards, Sreedhar ------=_NextPart_000_0091_01C2E7DE.07295360 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All,
 
If I tried to do any transaction with data= base i am=20 getting following error. Server is restarting automatically very=20 frequently.
 

server closed the connection unexpectedly

This probably means the server terminated abnormally

before or while processing the request.

connection to server was lost

Can any body tell what's the reason.

Regards,

Sreedhar

------=_NextPart_000_0091_01C2E7DE.07295360-- From rjessil@yahoo.com Mon Aug 20 20:03:20 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0C8DA9F9734 for ; Mon, 20 Aug 2007 17:03:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 84538-06 for ; Mon, 20 Aug 2007 17:03:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56401.mail.re3.yahoo.com (web56401.mail.re3.yahoo.com [216.252.111.80]) by postgresql.org (Postfix) with SMTP id B86FC9F96F2 for ; Mon, 20 Aug 2007 17:03:15 -0300 (ADT) Received: (qmail 71462 invoked by uid 60001); 20 Aug 2007 20:03:14 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=dPscEDHEfR2MCWLcZfq9utDLKCiP4GRHaAtZHeCZm0Aq/A55N0DlzGQYoX11Um025Fk3kb8PfumGcjjg+nE5+JIUlMhlC5qlBcdtb7Z2FR3+k2COOhXuItNQeyI5ZniU/vk1+PzNUmOB/Zp0SocM+PZrBMOzWXyyZ9OMIcEkBPs=; X-YMail-OSG: Mf.d45IVM1kxi82ayyrpOH1dg3EN5YYPZCnTbdN1nA0FF81E_S2W3gAVP24cJ1Oy9d6C5vQFGzKg8vZR3Iw.cVJQg7dOJGnqZ.HV9W2MjjYorU3qfMbBqyn_jw08ST5N Received: from [198.119.134.32] by web56401.mail.re3.yahoo.com via HTTP; Mon, 20 Aug 2007 13:03:14 PDT Date: Mon, 20 Aug 2007 13:03:14 -0700 (PDT) From: Jessica Richard Subject: server closed the connection unexpectedly To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-110182267-1187640194=:70997" Content-Transfer-Encoding: 8bit Message-ID: <160820.70997.qm@web56401.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/232 X-Sequence-Number: 26563 --0-110182267-1187640194=:70997 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit A psql connection was started from one Linux machine, talking to the Postgres server on another Linux machine (both the postgres client and the Postgres server are 8.2.4). Got the following error: If this a Postgres disconnection or a disconnection on the OS side? Thanks!!! server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Succeeded. \copy: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. --------------------------------- Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. --0-110182267-1187640194=:70997 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit A psql connection was started from one Linux machine, talking to the Postgres server on another Linux machine (both the postgres client and the Postgres server are 8.2.4). Got the following error:

If this a Postgres disconnection or a disconnection on the OS side?

Thanks!!!

 

server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 The connection to the server was lost. Attempting reset: Succeeded.
 \copy: server closed the connection unexpectedly
         This probably means the server terminated abnormally
        before or while processing the request.


Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out. --0-110182267-1187640194=:70997-- From tgl@sss.pgh.pa.us Tue Aug 21 03:40:46 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 6DDFF9F9D47 for ; Tue, 21 Aug 2007 00:40:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 76240-03 for ; Tue, 21 Aug 2007 00:40:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 67E239F9E68 for ; Tue, 21 Aug 2007 00:40:43 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7L3egj7020260; Mon, 20 Aug 2007 23:40:42 -0400 (EDT) To: Jessica Richard cc: pgsql-admin@postgresql.org Subject: Re: server closed the connection unexpectedly In-reply-to: <160820.70997.qm@web56401.mail.re3.yahoo.com> References: <160820.70997.qm@web56401.mail.re3.yahoo.com> Comments: In-reply-to Jessica Richard message dated "Mon, 20 Aug 2007 13:03:14 -0700" Date: Mon, 20 Aug 2007 23:40:42 -0400 Message-ID: <20259.1187667642@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/243 X-Sequence-Number: 26574 Jessica Richard writes: > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > If this a Postgres disconnection or a disconnection on the OS side? Well, you can't tell for certain from the client side. The postmaster log would tell. But unless you have a flaky network, this is probably the result of a backend crash :-(. Can you reproduce it, or get a gdb stack trace? regards, tom lane