PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> AWS Aurora, stable on 9.6.6/8 for a year, updated to 9.6.12:
> 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
Huh. Can you get a stack trace from that?
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
Also, could we see the definition of the table (psql \d would be
helpful)?
regards, tom lane