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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Euler Taveira
Дата:
Сообщение: Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTscausing segmentation fault
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15815: Upgraded from 9.6.8 > 9.6.12 on AWS Aurora: SELECTs causing segmentation fault