Re: BUG #7600: Database crash with data corruption - Mailing list pgsql-bugs

From Michał Hankiewicz
Subject Re: BUG #7600: Database crash with data corruption
Date
Msg-id CAMpaLZqdWaSj5kKAEmR10GC1UVmODgCyv4VrhUqLbWnHM=yAqQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #7600: Database crash with data corruption  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-bugs
On Mon, Oct 15, 2012 at 3:31 PM, Craig Ringer <ringerc@ringerc.id.au> wrote:

OK, that sounds more like a problem. It wasn't clear from your original post that it was replaying used sequence values.

SIGINT should normally just terminate the statement, eg:

regress=# SELECT pg_sleep(100);
ERROR:  canceling statement due to user request

so I agree that something isn't right here.

Is this something you've been able to reproduce? Or is it a one-off incident so far?

--
Craig Ringer


It is just one-off incident. We have increased sequences values and since friday everything is running fine.
We haven't tried to reproduce this situation.

Michał Hankiewicz

pgsql-bugs by date:

Previous
From: Michał Hankiewicz
Date:
Subject: Re: BUG #7600: Database crash with data corruption
Next
From: daniel.heden@sweco.se
Date:
Subject: BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.