Re: Segmentation fault with PG-12 - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: Segmentation fault with PG-12
Date
Msg-id VisenaEmail.15.c4570dd9ef6841fc.16dbfc04734@tc7-visena
Whole thread Raw
In response to Re: Segmentation fault with PG-12  (Andres Freund <andres@anarazel.de>)
List pgsql-general
På torsdag 10. oktober 2019 kl. 22:21:13, skrev Andres Freund <andres@anarazel.de>:
On 2019-10-10 15:32:38 -0400, Tom Lane wrote:
> Andres Freund <andres@anarazel.de> writes:
> > On 2019-10-09 10:16:37 -0400, Tom Lane wrote:
> >> Well, it shows that the failure is occurring while trying to evaluate
> >> a variable in a trigger's WHEN clause during
> >> "UPDATE origo_email_delivery SET folder_id=$1, created=$2\nWHERE entity_id IN ($3)\nRETURNING entity_id"
> >> And I'd bet that the root cause is something to do with Andres' tuple slot
> >> work.  But (at least to my eye) it's not apparent exactly what's wrong.
>
> > It looks like this could "just" be another report of #16036, which was
> > already fixed in:
> > commit d986d4e87f61c68f52c68ebc274960dc664b7b4e
> > Author: Andres Freund <andres@anarazel.de>
> > Date:   2019-10-04 11:59:34 -0700
> >     Fix crash caused by EPQ happening with a before update trigger present.
>
> Bingo.  I can reproduce the crash (using concurrent updates of the same
> table row, in the schema Andreas sent off-list) on the predecessor of
> that commit, but on that commit it's fine.

Cool, and thanks for checking.
 
 
No crashes in production after deploying the fix.
 
--
Andreas Joseph Krogh
 

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: SELECT d02name::bytea FROM ... && DBI::Pg
Next
From: Christoph Moench-Tegeder
Date:
Subject: Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to theserver