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

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Cc: valgog(at)gmail(dot)com
Subject: Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids
Date: 2012-05-23 06:49:59
Message-ID: 201205230849.59825.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Valentine,

On Tuesday, May 22, 2012 11:36:23 PM valgog(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrzej Krawiec 2012-05-23 09:29:15 Re: BUG #6650: CPU system time utilization rising few times a day
Previous Message Edmund Horner 2012-05-23 03:50:47 Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP