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

From Andres Freund
Subject Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids
Date
Msg-id 201205230849.59825.andres@anarazel.de
Whole thread Raw
In response to BUG #6661: out-of-order XID insertion in KnownAssignedXids  (valgog@gmail.com)
Responses Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids  (Valentine Gogichashvili <valgog@gmail.com>)
List pgsql-bugs
Hi Valentine,

On Tuesday, May 22, 2012 11:36:23 PM valgog@gmail.com wrote:
> 2012-05-22 21:20:27.868 CEST,,,23804,,4fbbe69e.5cfc,129,,2012-05-22
> 21:18:54 CEST,1/0,0,LOG,00000,"4 KnownAssignedXids (num=4 tail=0 head=916)
> [0]=3674726497 [1]=3674727041 [2]=3674727042 [3]=3674727128 ",,,,,"xlog
> redo running xacts: nextXid 3674728633 latestCompletedXid 3674728632
> oldestRunningXid 3674726497; 4 xacts: 3674727041 3674727042 3674727128
> 3674726497",,,,""
> 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

pgsql-bugs by date:

Previous
From: Edmund Horner
Date:
Subject: Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP
Next
From: Valentine Gogichashvili
Date:
Subject: Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids