Postmaster Crashing - Postgres 11 when JIT is enabled

From: Mukesh Chhatani <chhatani(dot)mukesh(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Postmaster Crashing - Postgres 11 when JIT is enabled
Date: 2020-06-09 19:00:06
Message-ID: CACnmOY+PttqRpHKRVJwocDAjyd8Lt_9_78Af_Vk2pWJWFrVvQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello Team,

We are experiencing issues around Postmaster crashing due to cancellation
of a simple query

Postgres Version - 11.6
Environment - AWS RDS
Table Size - 50 GB

Few ways I resolved the issue :
1. Vacuum analyze the table and then execute the query and cancel it.
2. Disable JIT
3. Set max_parallel_workers_per_gather = 0

Attached is the file containing DEBUG logs and ERROR we are experiencing
issues with.

Regards,
Mukesh

Attachment Content-Type Size
postgres11_crash_issue.txt text/plain 6.0 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2020-06-09 19:11:55 Re: Postmaster Crashing - Postgres 11 when JIT is enabled
Previous Message Odin Ugedal 2020-06-09 15:22:58 Re: [Bus error] huge_pages default value (try) not fall back