Re: hung backends stuck in spinlock heavy endless loop

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: hung backends stuck in spinlock heavy endless loop
Date: 2015-01-28 18:52:23
Message-ID: CAHyXU0yHtge9Q++CdUspqVheVsBzJ05Ynfp9VwG5zcr-JBM3nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jan 28, 2015 at 12:47 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
>> ...hm, I spoke to soon. So I deleted everything, and booted up a new
>> instance 9.4 vanilla with asserts on and took no other action.
>> Applying the script with no data activity fails an assertion every
>> single time:
>
>> TRAP: FailedAssertion("!(flags & 0x0010)", File: "dynahash.c", Line: 330)
>
> There's no Assert at line 330 in 9.4, though there is in HEAD. I suspect
> what you've got here is a version mismatch; in particular commit
> 4a14f13a0abfbf7e7d44a3d2689444d1806aa9dc changed the API for dynahash.c
> such that external modules would need to be recompiled to use it without
> error. I'm not real sure though how you are getting past the
> loadable-module version check. Anyway, I'd try "make distclean" and
> full rebuild before anything else.

you're right -- git got confused and built a 9.5 devel at some random
commit. I reran it again on 9.4 and it worked ok :(.

merlin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-01-28 18:52:30 Re: Misaligned BufferDescriptors causing major performance problems on AMD
Previous Message Tom Lane 2015-01-28 18:47:46 Re: hung backends stuck in spinlock heavy endless loop