Re: page 1 of relation global/11787 was uninitialized

Andres Freund wrote:
>On 2013-04-09 18:21:20 +0200, Stephen R. van den Berg wrote:
>Thats an absolutely outdated version of 9.0. You shouldn't be running
>this in production.

Yes, well, it's one of those things.  It got installed with Debian
and the automatic upgrade didn't upgrade it further, they switched to
9.1 without an automatic upgrade path.

>Yea, and it can cause very hard to recover corruption, its not that you
>only may loose some of the last transactions, in contrast to
>synchronous_commit=off where you can loose the last transactions but
>which never should cause corruption.

Ok, I'll avoid this option in the future, and just run with
synchronous_commit=off for non-critical databases.

>Stephen, could you check how big global/11787 exactly is? Too bad we
>don't know what that relfilenode corresponds to and we can't easily find
>out what it maps to.

This is the filelist of the whole global directory (there is only one active
database on this server), the 11787 file is 16KB exactly:

-rw------- 1 postgres postgres  8192 May 30  2011 11601
-rw------- 1 postgres postgres 24576 May 30  2011 11601_fsm
-rw------- 1 postgres postgres  8192 May 30  2011 11601_vm
-rw------- 1 postgres postgres 16384 May 30  2011 11603
-rw------- 1 postgres postgres 16384 May 30  2011 11604
-rw------- 1 postgres postgres     0 May 30  2011 11770
-rw------- 1 postgres postgres     0 May 30  2011 11772
-rw------- 1 postgres postgres  8192 May 30  2011 11774
-rw------- 1 postgres postgres  8192 May 30  2011 11775
-rw------- 1 postgres postgres  8192 May 30  2011 11776
-rw------- 1 postgres postgres 24576 May 30  2011 11776_fsm
-rw------- 1 postgres postgres  8192 May 30  2011 11776_vm
-rw------- 1 postgres postgres 16384 May 30  2011 11778
-rw------- 1 postgres postgres 16384 May 30  2011 11779
-rw------- 1 postgres postgres  8192 May 30  2011 11780
-rw------- 1 postgres postgres 24576 May 30  2011 11780_fsm
-rw------- 1 postgres postgres  8192 May 30  2011 11780_vm
-rw------- 1 postgres postgres 16384 May 30  2011 11782
-rw------- 1 postgres postgres  8192 May 30  2011 11783
-rw------- 1 postgres postgres 16384 May 30  2011 11785
-rw------- 1 postgres postgres 16384 May 30  2011 11786
-rw------- 1 postgres postgres 16384 Apr  9 18:08 11787
-rw------- 1 postgres postgres 24576 Apr  9 13:09 11787_fsm
-rw------- 1 postgres postgres  8192 Apr  9 14:58 11787_vm
-rw------- 1 postgres postgres 40960 Apr  9 14:51 11789
-rw------- 1 postgres postgres 24576 Nov 25  2011 11789_fsm
-rw------- 1 postgres postgres 16384 Apr  9 14:51 11790
-rw------- 1 postgres postgres  8192 May 30  2011 11791
-rw------- 1 postgres postgres 24576 May 30  2011 11791_fsm
-rw------- 1 postgres postgres  8192 May 30  2011 11791_vm
-rw------- 1 postgres postgres     0 May 30  2011 11793
-rw------- 1 postgres postgres  8192 May 30  2011 11795
-rw------- 1 postgres postgres 16384 May 30  2011 11796
-rw------- 1 postgres postgres  8192 May 30  2011 11867
-rw------- 1 postgres postgres     0 May 30  2011 11869
-rw------- 1 postgres postgres  8192 May 30  2011 11871
-rw------- 1 postgres postgres 16384 May 30  2011 11872
-rw------- 1 postgres postgres 16384 May 30  2011 11873
-- 
Stephen.