[BUG v13] Crash with event trigger in extension

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: [BUG v13] Crash with event trigger in extension
Date: 2020-09-02 17:37:15
Message-ID: 20200902193715.6e0269d4@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

Philippe Beaudoin reported to me a crash he was able to reproduce with some
extension update script. Please, find in attachment a script that triggers it.
Just edit the three first vars to point to a temporary installation and
instance.

Some git bisect shows the bug was introduced by b5810de3f4, where
multi-statement query strings are using different short memory contexts.

To make it short, any ALTER TABLE command in an extension script is
currently calling lappend to add its command to the
currentEventTriggerState->commandList list from its own short context instead
of using the context of currentEventTriggerState.

Because of this, when we call EventTriggerCollectSimpleCommand() for the top
level "ALTER EXTENSION" query, the list has long been removed and a new call of
lappend on currentEventTriggerState->commandList raise
Assert(IsPointerList(list)).

Please, find in attachement a bug fix proposal. I did a very quick look at
other ->commandList manipulations in event_trigger.c. They all appear to
be in the correct context in a first look.

Regards,

Attachment Content-Type Size
bug-ext.bash application/octet-stream 1.1 KB
v1-0001-Fix-crash-with-alter-table-event-triggers-in-extensi.patch text/x-patch 1.5 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2020-09-02 17:53:28 Re: [BUG v13] Crash with event trigger in extension
Previous Message Dave Cramer 2020-09-02 15:39:17 Re: BUG #16557: getProcedureColumns() function returns columns, when there is no existing Stored Procedure in the DB