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

From: Neil Conway <neilc(at)samurai(dot)com>
To: mthomp(at)tierfleet(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #807: Sequence currupted on recovery after kill -9
Date: 2002-10-29 16:23:50
Message-ID: 877kg12oyx.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

What version of PostgreSQL is this?

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Darcy Buskermolen 2002-10-29 16:38:55 Re: Bug #807: Sequence currupted on recovery after kill -9
Previous Message Magnus Enbom 2002-10-29 15:41:42 Wrong order of rows in result during regression test.