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
>
>
>
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 |