From: Andy Marangakis <Andrew.Marangakis@colorado.edu>
To: pgsql-admin@postgresql.org
Subject: runaway processes, data corruption
Date: Mon, 25 Oct 2004 12:48:54 -0600
Message-ID: <417D4A96.2040109@colorado.edu> (raw)
Hi all,
I've encounter a couple of bugaboos recently in a production database I
run (7.3.4 on Solaris 8). One is that killing a query from a client tool
such as dbVisualizer can cause the process on the server to become a
runaway, consuming CPU and causing other processes to go into a
TIME_WAIT state. The other is that a spontaneous reboot of the server
(unknown cause, some hardware/OS wierdness) caused a catastrophic
corruption, requiring rebuild from backup. The error returned was:
PANIC: Invalid page header in block 2462 of 1365344463
I've upgraded to 7.4 in hopes that crash resistance improves. Any other
thoughts on protecting against such occurances in the future? Thanks in
advance.
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Andy Marangakis 303-492-0527
Database Administrator 303-492-4198 fax
Information Technology Services
University of Colorado at Boulder
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Andrew.Marangakis@colorado.edu
Subject: Re: runaway processes, data corruption
In-Reply-To: <417D4A96.2040109@colorado.edu>
References: <417D4A96.2040109@colorado.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox