Postgres Pro
Downloads
Home   >   mailing lists

Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint - Mailing list pgsql-hackers

From Ashutosh Sharma
Subject Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint
Date
Msg-id CAE9k0P=NeA9D4TQYE=KW-9tVb5jbK5AiZqsZ9UG+nm0ErXSkwQ@mail.gmail.com
Whole thread Raw
In response to Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint  (Andreas Seltenreich <seltenreich@gmx.de>)
List pgsql-hackers
Tree view
On Mar 28, 2017 00:00, "Andreas Seltenreich" <seltenreich@gmx.de> wrote:
Ashutosh Sharma writes:
>> TRAP: FailedAssertion("!(LWLockHeldByMe(((LWLock*) (&(bufHdr)->content_lock))))", File: "bufmgr.c", Line: 3397)
> Thanks for reporting this problem. Could you please let me know on for
> how long did you run sqlsmith to get this crash.

I got about one TRAP per hour when testing on 20 nodes with one postgres
and 5 sqlsmithes on each.  Nodes are tiny consumer machines with
low-power 4-core sandy bridges.

Okay. Thanks for sharing this information. I tried running running sqlsmith on a single node. I ran it for an hour but didn't find any crash. Let me also try running multiple sqlsmith at a time...May be 5 like you are doing on a single node.


> [2. reacquire_lock_hashkillitems_if_required.patch]

I'll test with your patch applied as soon as time permits and report
back.

Sure, Thanks a lot.

With Regards,
Ashutosh Sharma

pgsql-hackers by date:

Previous
From: Stas Kelvich
Date:
Subject: Re: logical decoding of two-phase transactions
Next
From: Andres Freund
Date:
Subject: Re: logical decoding of two-phase transactions