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

Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids

From: Valentine Gogichashvili <valgog(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids
Date: 2012-05-23 10:30:31
Message-ID: CAP93muXirKNS=TO+a9hP6g-A4irrc7oyx7v8x1yJT6CGx6Wy1w@mail.gmail.com (view raw or flat)
Thread:
Lists: 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 :(

In response to

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2012-05-23 13:20:30
Subject: Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP
Previous:From: Andrzej KrawiecDate: 2012-05-23 09:29:15
Subject: Re: BUG #6650: CPU system time utilization rising few times a day

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