Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTscausing segmentation fault
| От | Steve |
|---|---|
| Тема | Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTscausing segmentation fault |
| Дата | |
| Msg-id | CAJr1J1c9jmbOwrx0qW8kP4d-mqkWWLVfeMKqhnMh5JeN2Hc9gw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTscausing segmentation fault (Euler Taveira <euler@timbira.com.br>) |
| Ответы |
Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTs causing segmentation fault
|
| Список | 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@timbira.com.br> wrote:
Em ter, 21 de mai de 2019 às 11:27, PG Bug reporting form
<noreply@postgresql.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
В списке pgsql-bugs по дате отправления: