Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

Hi Thomas,

We are setting up a new test environment with 12.1.
Once it is running, I'll try out those commands and get back with the
results.

Thanks,

Nick Renders

On 11 Feb 2020, at 2:51, Thomas Munro wrote:

> On Mon, Feb 10, 2020 at 4:35 AM Marc <postgres(at)arcict(dot)com> wrote:
>> We will keep the 12.1 in place so that we can run additional tests to
>> assist to pin-point the issue.
>>
>> Feel free to ask but allow us to recover from these hectic days ;-)
>
> Here's how to get a stack so we can see what it was doing, assuming
> you have the Apple developer tools installed:
>
> 1. Find the PID of the backend you're connected to with SELECT
> pg_backend_pid().
> 2. "lldb -p PID" from a shell to attach to the process, then "cont"
> to let it continue running.
> 3. Run the query in that backend and wait for the SIGKILL.
> 4. In the lldb session, type "bt".
>
> It'll only make sense if your PostgreSQL build has debug symbols, but
> let's see.