Re: BUG #11264: Auto vacuum wraparound job blocking everything

Hi Alvaro,

Here is the output of pg_controldata. We also looked at latest 9.3.5 fix fo=
r pg_upgrade and ran the query to check if we have to remove  $PGDATA/pg_mu=
ltixact/offsets/0000, but the query returned false.=20


pg_control version number:            937
Catalog version number:               201306121
Database system identifier:           6037642065780369403
Database cluster state:               in production
pg_control last modified:             Tue 26 Aug 2014 02:40:19 PM UTC
Latest checkpoint location:           1054/17E0BE30
Prior checkpoint location:            1054/15B2DEB8
Latest checkpoint's REDO location:    1054/16EC6028
Latest checkpoint's REDO WAL file:    000000010000105400000016
Latest checkpoint's TimeLineID:       1
Latest checkpoint's PrevTimeLineID:   1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/1004399358
Latest checkpoint's NextOID:          1303270531
Latest checkpoint's NextMultiXactId:  23431
Latest checkpoint's NextMultiOffset:  5678
Latest checkpoint's oldestXID:        801997459
Latest checkpoint's oldestXID's DB:   16428
Latest checkpoint's oldestActiveXID:  1004399358
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 16423
Time of latest checkpoint:            Tue 26 Aug 2014 02:37:48 PM UTC
Fake LSN counter for unlogged rels:   0/1
Minimum recovery ending location:     0/0
Min recovery ending loc's timeline:   0
Backup start location:                0/0
Backup end location:                  0/0
End-of-backup record required:        no
Current wal_level setting:            hot_standby
Current max_connections setting:      1024
Current max_prepared_xacts setting:   0
Current max_locks_per_xact setting:   64
Maximum data alignment:               8
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        1996
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value
Data page checksum version:           0


Thanks
Dinesh

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@2ndquadrant.com]=20
Sent: Monday, August 25, 2014 9:03 PM
To: Dinesh Bhandary
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #11264: Auto vacuum wraparound job blocking everyth=
ing

dbhandary@switchfly.com wrote:

> I am including debug trace here. It seems like auto vacuum is running=20
> in an infinite loop. Will be happy to provide more info if necessary.
>=20
> (gdb) bt
> #0  0x00007fb9740eb5b3 in __select_nocancel () from /lib64/libc.so.6
> #1  0x000000000075ad7a in pg_usleep ()
> #2  0x00000000004ae2d4 in GetMultiXactIdMembers ()
> #3  0x000000000047f6cc in heap_prepare_freeze_tuple ()
> #4  0x000000000057d036 in lazy_vacuum_rel ()

Can you please provide pg_controldata output?

--=20
=C1lvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services