Re: Segmentation Fault in logical decoding get/peek API - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: Segmentation Fault in logical decoding get/peek API
Date
Msg-id CAH2-WzkXxqtEH8CpUrpSewFfiZFqyjrhjQ1nLeYb_n-kR_uU0Q@mail.gmail.com
Whole thread Raw
In response to Re: Segmentation Fault in logical decoding get/peek API  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: Segmentation Fault in logical decoding get/peek API
List pgsql-bugs
On Tue, Feb 20, 2018 at 1:35 PM, Tomas Vondra
<tomas.vondra@2ndquadrant.com> wrote:
> And if it's segfaulting, it has to mean specinsert is NULL. So either we
> never got REORDER_BUFFER_CHANGE_INTERNAL_SPEC_INSERT, or we threw it
> away in the "change_done" part. Seems strange in both cases.
>
> Sudalai, are you using speculative inserts in the transaction?

He means ON CONFLICT DO UPDATE.  :-)

The speculative insertion case handling in reorderbuffer.c is likely
something that is hardly ever used, since speculative insertion
conflicts are presumably generally very rare. Though at the same time,
they're surely very common for certain workloads (such as my testing
script for ON CONFLICT DO UPDATE [1]).

[1] https://github.com/petergeoghegan/jjanes_upsert
-- 
Peter Geoghegan


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_upgrade and materialized views
Next
From: Sudalai
Date:
Subject: Re: Segmentation Fault in logical decoding get/peek API