Re: memory leak in trigger handling (since PG12) - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: memory leak in trigger handling (since PG12)
Date
Msg-id d3acafd0-452e-070e-5891-d5e2f2d4370a@enterprisedb.com
Whole thread Raw
In response to Re: memory leak in trigger handling (since PG12)  (Alexander Pyhalov <a.pyhalov@postgrespro.ru>)
List pgsql-hackers

On 6/23/23 08:03, Alexander Pyhalov wrote:
> Tomas Vondra писал 2023-06-22 17:16:
>> On 6/22/23 13:46, Tomas Vondra wrote:
>>> ...
>>>
>>> I haven't tried the reproducer, but I think I see the issue - we store
>>> the bitmap as part of the event to be executed later, but the bitmap is
>>> in per-tuple context and gets reset. So I guess we need to copy it into
>>> the proper long-lived context (e.g. AfterTriggerEvents).
>>>
>>> I'll get that fixed.
>>>
>>
>> Alexander, can you try if this fixes the issue for you?
>>
>>
>> regard
> 
> Hi.
> The patch fixes the problem and looks good to me.

Thanks, I've pushed the fix, including backpatch to 13+ (12 is not
affected by the oversight, the bitmap was added by 71d60e2aa0).

I think it'd be good to investigate if it's possible to compute the
bitmap only once - as already suggested by Andres, but that's a matter
for separate patch, not a bugfix.

regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Memory leak in incremental sort re-scan
Next
From: Joe Conway
Date:
Subject: Re: Optionally using a better backtrace library?