Fix "Attempted to delete invisible tuple" upsert errors

Title

Topic

Bug Fixes

Created

2016-07-22 17:36:21

Last modified

2016-08-18 12:37:27 (8 years, 3 months ago)

Latest email

2016-08-19 00:37:28 (8 years, 3 months ago)

Status

2016-09: Committed

Target version

Authors

Oskari Saarenmaa (os)

Reviewers

Peter Geoghegan (pgeoghegan)Become reviewer

Committer

Andres Freund (andresfreund)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/681
git checkout commitfest/cf/681

Emails

BUG #14150: Attempted to delete invisible tuple: First at 2016-05-19 12:33:38 by virendra at idyllic-software.com
Latest at 2016-08-19 00:37:28 by Peter Geoghegan <pg at heroku.com>
Latest attachment (0001-Fix-deletion-of-speculatively-inserted-TOAST-on-conf.patch) at 2016-08-05 21:37:08 from Oskari Saarenmaa <os at aiven.io>
    Attachment (0001-Fix-deletion-of-speculatively-inserted-TOAST-on-conf.patch) at 2016-08-05 21:37:08 from Oskari Saarenmaa <os at aiven.io> (Patch: Yes)
    Attachment (heap_delete_speculative.patch) at 2016-07-07 19:43:59 from Oskari Saarenmaa <os at aiven.io> (Patch: Yes)
    Attachment (force-precheck.patch) at 2016-07-07 00:48:06 from Peter Geoghegan <pg at heroku.com> (Patch: Yes)
    Attachment (0001-Delete-current-command-s-TOAST-when-aborting-specula.patch) at 2016-07-06 10:30:57 from Oskari Saarenmaa <os at aiven.io> (Patch: Yes)
    Attachment (toast-upsert-bug.script.pgbench) at 2016-06-28 23:40:34 from Peter Geoghegan <pg at heroku.com> (Patch: No)
    Attachment (toast-bug-records.txt) at 2016-06-28 05:57:28 from Peter Geoghegan <pg at heroku.com> (Patch: No)
    Attachment (delete-invisible-panic.patch) at 2016-06-13 20:45:53 from Peter Geoghegan <pg at heroku.com> (Patch: Yes)

History

When	Who	What
2016-08-18 12:37:27	Oskari Saarenmaa (os)	Closed in commitfest 2016-09 with status: Committed
2016-08-18 12:37:04	Oskari Saarenmaa (os)	Changed reviewers to Peter Geoghegan (pgeoghegan)
2016-08-18 12:37:04	Oskari Saarenmaa (os)	Changed committer to andresfreund
2016-07-27 10:20:03	Oskari Saarenmaa (os)	Changed authors to Oskari Saarenmaa (os)
2016-07-22 17:36:21	Oskari Saarenmaa (os)	Attached mail thread 20160519123338.12513.20271@wrigleys.postgresql.org
2016-07-22 17:36:21	Oskari Saarenmaa (os)	Created patch record