Short reads in hash indexes (was: [sqlsmith] Failed assertion in _hash_splitbucket_guts)

Поиск
Список
Период
Сортировка
От Andreas Seltenreich
Тема Short reads in hash indexes (was: [sqlsmith] Failed assertion in _hash_splitbucket_guts)
Дата
Msg-id 877f7c1eu7.fsf_-_@credativ.de
обсуждение исходный текст
Ответ на Re: [sqlsmith] Failed assertion in _hash_splitbucket_guts  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: [sqlsmith] Short reads in hash indexes  (Andreas Seltenreich <seltenreich@gmx.de>)
Список pgsql-hackers
Amit Kapila writes:

> On Sat, Dec 3, 2016 at 3:44 PM, Andreas Seltenreich <seltenreich@gmx.de> wrote:
>> Amit Kapila writes:
>>
>>> [2. text/x-diff; fix_hash_bucketsplit_sqlsmith_v1.patch]
>> Ok, I'll do testing with the patch applied.

Good news: the assertion hasn't fired since the patch is in.

However, these are still getting logged:

smith=# select * from state_report where sqlstate = 'XX001';
-[ RECORD 1 ]------------------------------------------------------------------------------
count    | 10
sqlstate | XX001
sample   | ERROR:  could not read block 1173 in file "base/16384/17256": read only 0 of 8192 bytes
hosts    | {airbisquit,frell,gorgo,marbit,pillcrow,quakken}

> Hmm, I am not sure if this is related to previous problem, but it
> could be.  Is it possible to get the operation and or callstack for
> above failure?

Ok, will turn the elog into an assertion to get at the backtraces.

regards,
Andreas



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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Back-patch use of unnamed POSIX semaphores for Linux?
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Quorum commit for multiple synchronous replication.