Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint

Поиск
Список
Период
Сортировка
От Andreas Seltenreich
Тема Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint
Дата
Msg-id 87a8868td0.fsf@credativ.de
обсуждение исходный текст
Ответ на [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint  (Andreas Seltenreich <seltenreich@gmx.de>)
Ответы Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Список pgsql-hackers
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.

> [2. reacquire_lock_hashkillitems_if_required.patch]

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

regards,
Andreas



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jesper Pedersen
Дата:
Сообщение: Re: [POC] A better way to expand hash indexes.
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: \if, \elseif, \else, \endif (was Re: PSQL commands:\quit_if, \quit_unless)