Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DAEFB475ADD for ; Fri, 24 Jan 2003 19:03:03 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 227B54758E6 for ; Fri, 24 Jan 2003 19:03:03 -0500 (EST) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2324930; Fri, 24 Jan 2003 16:03:09 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Noah Silverman Subject: Re: WEIRD CRASH?!?! Date: Fri, 24 Jan 2003 16:03:42 -0800 X-Mailer: KMail [version 1.4] Cc: pgsql-performance@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200301241603.42263.josh@agliodbs.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/298 X-Sequence-Number: 945 Noah, > I think my server crashed and then restarted itself. Does anybody know= =20 > what all this means: >=20 > 2003-01-24 18:28:06 PANIC: link from=20 > /RAID/pgsql/pg_xlog/00000009000000BC to=20 > /RAID/pgsql/pg_xlog/00000009000000C4 (initialization of log file 9,=20 > segment 196) failed: File exists > 2003-01-24 18:28:06 LOG: server process (pid 1574) was terminated by=20 > signal 6 > 2003-01-24 18:28:06 LOG: terminating any other active server processes > 2003-01-24 18:28:06 WARNING: Message from PostgreSQL backend: > The Postmaster has informed me that some other backend > died abnormally and possibly corrupted shared memory. > I have rolled back the current transaction and am > going to terminate your database system connection and exit. > Please reconnect to the database system and repeat your query. This means that somebody KILL -9'd a postgres process or the postmaster, an= d=20 Postgres restarted in order to clear the shared buffers. If the database= =20 started up again, you are fine. --=20 -Josh Berkus Aglio Database Solutions San Francisco