Re: spgist recovery assertion failure

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Piotr Stefaniak <postgres(at)piotr-stefaniak(dot)me>
Cc: Noah Misch <noah(at)leadboat(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: spgist recovery assertion failure
Date: 2015-07-27 13:24:47
Message-ID: CAB7nPqSNgiAMRKB33GB5C6R56Y3+1bXOPDkrb798Ep7ZJOfLyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jul 27, 2015 at 2:33 PM, Piotr Stefaniak
<postgres(at)piotr-stefaniak(dot)me> wrote:
> On 07/27/2015 07:19 AM, Michael Paquier wrote:
>>
>> On Mon, Jul 27, 2015 at 2:00 PM, Noah Misch <noah(at)leadboat(dot)com> wrote:
>>>
>>> When I caused a crash during the create_index regression test, recovery
>>> hit an
>>> assertion failure. Minimal test case:
>>>
>>> psql -X <<EOSQL
>>> CREATE TABLE t (c text);
>>> INSERT INTO t SELECT 'P0123456789abcdef' FROM generate_series(1,1000);
>>> INSERT INTO t VALUES ('P0123456789abcdefF');
>>> CREATE INDEX ON t USING spgist (c);
>>> EOSQL
>>> pg_ctl -m immediate -w restart
>>
>>
>> On which platform are you seeing the failure? I am afraid I could not
>> reproduce the failure on Linux and OSX after testing it on HEAD.
>>
>
> I'm having the same symptoms with
> 159cff58cf3b565be3c17901698a74238e9e23f8 on Ubuntu Linux 3.4.39 armv7l.

Yes, on armv7l this can be indeed reproduced.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kouhei Kaigai 2015-07-27 13:25:45 Re: [DESIGN] ParallelAppend
Previous Message Michael Paquier 2015-07-27 13:18:06 Re: creating extension including dependencies