X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 182515400F for ; Thu, 12 May 2005 16:56:01 -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 33186-08 for ; Thu, 12 May 2005 19:55:59 +0000 (GMT) Received: from presinet-main.presinet.com (presinet.com [209.53.156.1]) by svr1.postgresql.org (Postfix) with ESMTP id 71E8C5400A for ; Thu, 12 May 2005 16:55:54 -0300 (ADT) Received: from [10.10.1.151] (BRICK [10.10.1.151]) by presinet-main.presinet.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2658.3) id KJAKMBZC; Thu, 12 May 2005 12:52:44 -0700 Message-ID: <4283B4CB.9040700@PresiNET.com> Date: Thu, 12 May 2005 12:55:55 -0700 From: Bricklen Anderson User-Agent: Debian Thunderbird 1.0.2 (X11/20050331) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joel Fradkin Cc: pgsql-admin@postgresql.org Subject: Re: catastrophic error References: <000a01c55728$8abe41c0$797ba8c0@jfradkin> In-Reply-To: <000a01c55728$8abe41c0$797ba8c0@jfradkin> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.026 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/173 X-Sequence-Number: 17602 Joel Fradkin wrote: > Hi, > > > > I have been live for 4 days (vacuums run each night and backups done > each night). > > Today around 2:30 PM EST my web app returned a catastrophic error. > > Both web servers appeared to have the issue. > > I could go on them and get data via pgadmin. > > I could log on the server (IIS servers are win2k and pg is Redhat AS4 > running 8.0.2) and see it was not using much memory or cpu. > > Neither the web or database servers seemed stressed? > > Any ideas what I should look at? > > I re-booted the IIS servers and it did not fix the issue. > > I rebooted the database server and the web servers are back to connecting. > > > > Being new to postgres I am not sure what to look at for the cause and > hopefully permanent fix to this. > > > > Thanks in advance to any ideas (I did search the archive, but only saw a > mention of pre 8 versions and oid numbering wraparound). > > > > Joel Fradkin Any messages in syslog on db server? Any web error logs that you can check? -- _______________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. _______________________________