Re: incremental backup breakage in BlockRefTableEntryGetBlocks - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: incremental backup breakage in BlockRefTableEntryGetBlocks
Date
Msg-id c5d73d14-f818-462c-97de-c32bf8133777@enterprisedb.com
Whole thread Raw
In response to [MASSMAIL]incremental backup breakage in BlockRefTableEntryGetBlocks  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: incremental backup breakage in BlockRefTableEntryGetBlocks
List pgsql-hackers
On 4/4/24 19:38, Robert Haas wrote:
> Hi,
> 
> Yesterday, Tomas Vondra reported to me off-list that he was seeing
> what appeared to be data corruption after taking and restoring an
> incremental backup. Overnight, Jakub Wartak further experimented with
> Tomas's test case, did some initial analysis, and made it very easy to
> reproduce. I spent this morning tracking down the problem, for which I
> attach a patch.
> 

Thanks, I can confirm this fixes the issue I've observed/reported. On
master 10 out of 10 runs failed, with the patch no failures.

The test is very simple:

1) init pgbench
2) full backup
3) run short pgbench
4) incremental backup
5) compare pg_dumpall on the instance vs. restored backup


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Wolfgang Walther
Date:
Subject: Re: Building with musl in CI and the build farm
Next
From: Alexander Korotkov
Date:
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands