Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTs causing segmentation fault

From: Steve <postgres-ca(at)byrequest(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: Euler Taveira <euler(at)timbira(dot)com(dot)br>, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTs causing segmentation fault
Date: 2019-05-21 15:35:04
Message-ID: CAJr1J1c9jmbOwrx0qW8kP4d-mqkWWLVfeMKqhnMh5JeN2Hc9gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I probably need AWS hands to get a trace from behind the curtain. Started a
thread there
https://forums.aws.amazon.com/thread.jspa?threadID=303488&tstart=0

Column | Type | Modifiers
----------------+---------+------------------------------------------------------
a | integer | not null default
nextval('{table3}_seq'::regclass)
b | integer |
c | integer |
d | text |
Indexes:
… PRIMARY KEY, btree (a)
… UNIQUE CONSTRAINT, btree (b, c)
… btree (b)
… btree (c)
… btree (lower("substring"(d, 1, 1000)) text_pattern_ops, b)
… btree (lower("substring"(d, 1, 1000)), b)
Foreign-key constraints:
… FOREIGN KEY (b) REFERENCES {table2}(b)
… FOREIGN KEY (c) REFERENCES {table1}(c)

> 200G so it would/will take time to run tests on stock Postgres.

On Tue, May 21, 2019 at 8:46 AM Euler Taveira <euler(at)timbira(dot)com(dot)br> wrote:

> Em ter, 21 de mai de 2019 às 11:27, PG Bug reporting form
> <noreply(at)postgresql(dot)org> escreveu:
> >
> > AWS Aurora, stable on 9.6.6/8 for a year, updated to 9.6.12:
> >
> Aurora is a Postgres fork so you should report it to Amazon. However, ...
>
> > LOG: server process (PID 31294) was terminated by signal 11:
> Segmentation
> > fault
> > DETAIL: Failed process was running:
> > simplied >>> SELECT value FROM {table} WHERE
> lower(substring(value,1,1000))
> > >= '{string}'
> > LOG: terminating any other active server processes
> > FATAL: Can't handle storage runtime process crash
> >
> Could you reproduce it with stock Postgres? Could you provide a test case?
>
>
> --
> Euler Taveira Timbira -
> http://www.timbira.com.br/
> PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
>
>
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-05-21 15:43:45 Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTs causing segmentation fault
Previous Message Euler Taveira 2019-05-21 14:46:18 Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTs causing segmentation fault