Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint

Поиск
Список
Период
Сортировка
От Ashutosh Sharma
Тема Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint
Дата
Msg-id CAE9k0P=NeA9D4TQYE=KW-9tVb5jbK5AiZqsZ9UG+nm0ErXSkwQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint  (Andreas Seltenreich <seltenreich@gmx.de>)
Список pgsql-hackers
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Stas Kelvich
Дата:
Сообщение: Re: logical decoding of two-phase transactions
Следующее
От: Andres Freund
Дата:
Сообщение: Re: logical decoding of two-phase transactions