pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

Message-ID: <417D4A96.2040109@colorado.edu>
Permalink:  ../417D4A96.2040109@colorado.edu/
Also on:    postgresql.org/message-id/417D4A96.2040109@colorado.edu

 · 

reply

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