Re: Bug #807: Sequence currupted on recovery after kill -9

From: Darcy Buskermolen <darcy(at)wavefire(dot)com>
To: mthomp(at)tierfleet(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #807: Sequence currupted on recovery after kill -9
Date: 2002-10-29 16:38:55
Message-ID: 200210290838.55170.darcy@wavefire.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On Tuesday 29 October 2002 08:23, Neil Conway wrote:
> pgsql-bugs(at)postgresql(dot)org writes:
> If you create a file with an implied sequence and do a couple of
> inserts, then do a kill -9, when you start up again, the sequence
> will have a corrupted next_value field. In the example, the value
> of last_value is 4 before the kill -9 and 34 when it comes back up.

I'm sure if you read the footers on Tom's email's it's pretty clearly stated
'do not kill -9 the postmaster'.
So I'm not so sure that this is really a bug.

--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Hentosh 2002-10-29 17:18:23 Re: Bug #807: Sequence currupted on recovery after kill -9
Previous Message Neil Conway 2002-10-29 16:23:50 Re: Bug #807: Sequence currupted on recovery after kill -9