Re: BUG #11264: Auto vacuum wraparound job blocking everything - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #11264: Auto vacuum wraparound job blocking everything
Date
Msg-id 20140826040328.GC6343@eldon.alvh.no-ip.org
Whole thread Raw
In response to BUG #11264: Auto vacuum wraparound job blocking everything  (dbhandary@switchfly.com)
Responses Re: BUG #11264: Auto vacuum wraparound job blocking everything  (Dinesh Bhandary <dbhandary@switchfly.com>)
List pgsql-bugs
dbhandary@switchfly.com wrote:

> I am including debug trace here. It seems like auto vacuum is running in an
> infinite loop. Will be happy to provide more info if necessary.
>
> (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?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: dbhandary@switchfly.com
Date:
Subject: BUG #11264: Auto vacuum wraparound job blocking everything
Next
From: zoulx1982@163.com
Date:
Subject: BUG #11266: failed to find conversion function from unknown to bigint