Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids - Mailing list pgsql-bugs

From Valentine Gogichashvili
Subject Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids
Date
Msg-id CAP93muXirKNS=TO+a9hP6g-A4irrc7oyx7v8x1yJT6CGx6Wy1w@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids  (Andres Freund <andres@anarazel.de>)
Responses Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids  (Andres Freund <andres@2ndquadrant.com>)
Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
>
> > 2012-05-22 21:20:27.868 CEST,,,23804,,4fbbe69e.5cfc,130,,2012-05-22
> > 21:18:54 CEST,1/0,0,FATAL,XX000,"out-of-order XID insertion in
> > KnownAssignedXids",,,,,"xlog redo  running xacts: nextXid 3674728633
> > latestCompletedXid 3674728632 oldestRunningXid 3674726497; 4 xacts:
> > 3674727041 3674727042 3674727128 3674726497",,,,""
> > 2012-05-22 21:20:27.939 CEST,,,23793,,4fbbe69e.5cf1,1,,2012-05-22
> 21:18:54
> > CEST,,0,LOG,00000,"startup process (PID 23804) exited with exit code
> > 1",,,,,,,,,""
> > 2012-05-22 21:20:27.939 CEST,,,23793,,4fbbe69e.5cf1,2,,2012-05-22
> 21:18:54
> > CEST,,0,LOG,00000,"terminating any other active server
> > processes",,,,,,,,,""
> Could you provide a log with log_min_messages=DEBUG4? This will be quite
> long
> though...
>
> Andres
>

Hm... I have the data directory, but not the WAL files any more. Forgot to
back them up :(

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids
Next
From: Magnus Hagander
Date:
Subject: Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP