Re: simultaneous autovacuum and postmaster crash - Mailing list pgsql-bugs

From Tom Lane
Subject Re: simultaneous autovacuum and postmaster crash
Date
Msg-id 4378.1325100090@sss.pgh.pa.us
Whole thread Raw
In response to simultaneous autovacuum and postmaster crash  (lsq@nym.hush.com)
List pgsql-bugs
lsq@nym.hush.com writes:
> I got a simultaneous autovacuum and postmaster crash, then another
> postmaster crash a few seconds later on restart.  After a third
> restart the system was stable.  I haven't found anything obviously
> matching this defect on-line.

Those stack traces are pretty fascinating, but after studying them
I have to think that you had some sort of hardware or VM glitch.
"Bus error" is an uncommon event on x86_64 platforms, and for three
different processes to all get that, in three unrelated places, at
nearly the same time pushes the bounds of credulity.  What's more,
all three of those places are frequently-executed code paths, so if
there were some kind of PG bug there I'm sure we'd have seen it before.

I'm not too sure about the wisdom of running packages built for Centos
on Ubuntu, but as for this particular event, I'd write it off to cosmic
rays or something.  (Speaking of which, does that box have ECC memory?)

            regards, tom lane

pgsql-bugs by date:

Previous
From: tracy.anderson@teamquest.com
Date:
Subject: BUG #6362: pg_ctl register puts wrong slash in
Next
From: Tom Lane
Date:
Subject: Re: BUG #6362: pg_ctl register puts wrong slash in