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

From: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <rhaas(at)postgresql(dot)org>
Subject: Short reads in hash indexes (was: [sqlsmith] Failed assertion in _hash_splitbucket_guts)
Date: 2016-12-07 05:35:28
Message-ID: 877f7c1eu7.fsf_-_@credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Amit Kapila writes:

> On Sat, Dec 3, 2016 at 3:44 PM, Andreas Seltenreich <seltenreich(at)gmx(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2016-12-07 05:49:38 Re: Quorum commit for multiple synchronous replication.
Previous Message Tatsuo Ishii 2016-12-07 05:13:41 Re: Back-patch use of unnamed POSIX semaphores for Linux?