Re: BUG #11264: Auto vacuum wraparound job blocking everything - Mailing list pgsql-bugs
From | Dinesh Bhandary |
---|---|
Subject | Re: BUG #11264: Auto vacuum wraparound job blocking everything |
Date | |
Msg-id | e58c86a7fd5b42b3bf9d18ca0fd18c35@CO2PR05MB569.namprd05.prod.outlook.com Whole thread Raw |
In response to | Re: BUG #11264: Auto vacuum wraparound job blocking everything (Alvaro Herrera <alvherre@2ndquadrant.com>) |
List | pgsql-bugs |
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
pgsql-bugs by date: