| 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: | Whole Thread | Raw Message | 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
| 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 |