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

We have set up a new test environment running PostgreSQL v12.2 on macOS 
10.14 and the issue is still there.
One thing I noticed, is that the returning columns do not affect the 
behaviour:

    SELECT * FROM f_gsxws_schedule WHERE UPPER(gwsc_dossier) = 'TEST'

and
    SELECT gwsc_sequence FROM f_gsxws_schedule WHERE UPPER(gwsc_dossier) = 
'TEST'

both kill the postgres service.


I will try to free some time next week to install the Apple developer 
tools and further analyse the problem.

Best regards,

Nick


On 11 Feb 2020, at 12:32, Nick Renders wrote:

> 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@arcict.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.