Re: BUG #17821: Assertion failed in heap_update() due to heap pruning

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>

To: pgsql-bugs@lists.postgresql.org, Alexander Lakhin <exclusion@gmail.com>

Date: 2023-03-04T16:48:32Z

Lists: pgsql-bugs

Hi

On March 3, 2023 10:00:00 PM PST, Alexander Lakhin <exclusion@gmail.com> wrote:
>02.03.2023 16:00, PG Bug reporting form wrote:
>So we have only the second question left.

My first suspicion would be that we aren't holding a lock in the right moment, to enforce cache invalidation processing.

Greetings,

Andres
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix test races between syscache-update-pruned.spec and autovacuum.
- 42bb4fb7281e 17.5 landed
- 5bbc596391ae 18.0 landed
At update of non-LP_NORMAL TID, fail instead of corrupting page header.
- dc02b98bd1c8 15.11 landed
- 8bfd2cebab0a 13.19 landed
- 25e99483c411 14.16 landed
- f4af4515bb5f 17.3 landed
- 9311fcb86480 16.7 landed
- d28cd3e7b21c 18.0 landed
Disable runningcheck for src/test/modules/injection_points/specs.
- eca456edc1ca 17.3 landed
- 4f6ec3831d3e 18.0 landed
Merge copies of converting an XID to a FullTransactionId.
- 1587f7b9fc1a 17.3 landed
- 81772a495ec9 18.0 landed
Disable vacuum page skipping in selected test cases.
- c2dc1a79767a 14.0 cited