Fix deletion of speculatively inserted TOAST on conflict
authorAndres Freund <andres@anarazel.de>
Thu, 18 Aug 2016 00:03:36 +0000 (17:03 -0700)
committerAndres Freund <andres@anarazel.de>
Thu, 18 Aug 2016 00:03:36 +0000 (17:03 -0700)
commit07ef035129586ca26a713c4cd15e550dfe35e643
tree80165becad5aa3b5e999f578cbec19aa54733ce4
parentcf9b0fea5f6d1bcc9b2c66f5c30ecb04684a0919
Fix deletion of speculatively inserted TOAST on conflict

INSERT ..  ON CONFLICT runs a pre-check of the possible conflicting
constraints before performing the actual speculative insertion.  In case
the inserted tuple included TOASTed columns the ON CONFLICT condition
would be handled correctly in case the conflict was caught by the
pre-check, but if two transactions entered the speculative insertion
phase at the same time, one would have to re-try, and the code for
aborting a speculative insertion did not handle deleting the
speculatively inserted TOAST datums correctly.

TOAST deletion would fail with "ERROR: attempted to delete invisible
tuple" as we attempted to remove the TOAST tuples using
simple_heap_delete which reasoned that the given tuples should not be
visible to the command that wrote them.

This commit updates the heap_abort_speculative() function which aborts
the conflicting tuple to use itself, via toast_delete, for deleting
associated TOAST datums.  Like before, the inserted toast rows are not
marked as being speculative.

This commit also adds a isolationtester spec test, exercising the
relevant code path. Unfortunately 9.5 cannot handle two waiting
sessions, and thus cannot execute this test.

Reported-By: Viren Negi, Oskari Saarenmaa
Author: Oskari Saarenmaa, edited a bit by me
Bug: #14150
Discussion: <20160519123338.12513.20271@wrigleys.postgresql.org>
Backpatch: 9.5, where ON CONFLICT was introduced
src/backend/access/heap/heapam.c
src/backend/access/heap/tuptoaster.c
src/backend/utils/time/tqual.c
src/include/access/tuptoaster.h
src/test/isolation/expected/insert-conflict-toast.out [new file with mode: 0644]
src/test/isolation/isolation_schedule
src/test/isolation/specs/insert-conflict-toast.spec [new file with mode: 0644]