Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group