Re: BUG #10533: 9.4 beta1 assertion failure in autovacuum process

From: Keith Fiske <keith(at)omniti(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: levertond <levertond(at)googlemail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #10533: 9.4 beta1 assertion failure in autovacuum process
Date: 2014-06-20 18:52:05
Message-ID: CAG1_KcBG00pQQ5Zw9+A+QQ_0Ys2tEXWjtikK+D=joQ8E2jgW_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Jun 20, 2014 at 6:11 AM, Andres Freund <andres(at)2ndquadrant(dot)com>
wrote:

> Hi David, Keith,
>
> I've pushed a fix for the problem.
>
> On 2014-06-05 18:01:21 +0000, levertond(at)googlemail(dot)com wrote:
> > Our application's test suite triggers an assertion failure in an
> autovacuum
> > process under 9.4 beta1. I wasn't able to reduce it to a nice test case,
> > but I hope the backtrace illustrates the problem:
>
> Any chance you could rerun the testsuite now (using master) or after
> beta2?
>
> Thanks!
>
> Andres Freund
>
> --
> Andres Freund http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>

Andres,

Running my test suite against current HEAD
(ecac0e2b9e8e8e78d771b20fe441e95bb02db2fa), this seems to have fixed it at
least in my case. I confirmed autovacuum was running during the later
tests. I ran it 4 consecutive times with zero errors.

Thanks!

--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2014-06-20 21:38:16 Re: [BUGS] BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Previous Message Bruce Momjian 2014-06-20 18:42:24 Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts