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

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