Re: WEIRD CRASH?!?! - Mailing list pgsql-performance

From Tom Lane
Subject Re: WEIRD CRASH?!?!
Date
Msg-id 28079.1043456647@sss.pgh.pa.us
Whole thread Raw
In response to Re: WEIRD CRASH?!?!  (Noah Silverman <noah@allresearch.com>)
List pgsql-performance
Noah Silverman <noah@allresearch.com> writes:
> One clue.
> I actually moved the pg_xlog directory to another drive and then
> symbolically linked it back to the data directory.

Uh, did you have the postmaster shut down while you did that?

This looks like a collision between two processes both trying to create
the next segment of the xlog at about the same time.  But there are
interlocks that are supposed to prevent that.

I don't think you need to worry about the integrity of your data; the
panic reset should put everything right.  But I'd sure be interested
if you can reproduce this problem.

            regards, tom lane

pgsql-performance by date:

Previous
From: Noah Silverman
Date:
Subject: Re: Multiple databases one directory
Next
From: Kevin Brown
Date:
Subject: Re: Having trouble with backups (was: Re: Crash Recovery)