From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids |
Date: | 2012-05-23 16:40:34 |
Message-ID: | 201205231840.34836.andres@anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wednesday, May 23, 2012 12:30:31 PM Valentine Gogichashvili wrote:
> > > 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 :(
Do you have both, longrunning transactions and transactions with many
subtransactions?
Andres
From | Date | Subject | |
---|---|---|---|
Next Message | Valentine Gogichashvili | 2012-05-23 17:13:55 | Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids |
Previous Message | Andres Freund | 2012-05-23 16:33:09 | Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids |