Re: Race between datachecksum enablement and create table with the file_copy strategy

> On 21 Jul 2026, at 20:35, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
>> On 21 Jul 2026, at 12:55, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> wrote:

>> There's a small race window between enabling data checksums and
>> creating a new database with the file_copy strategy:
>>
>> Create database checks for in progress data checksums before it
>> inserts a new row into pg_database. If the data checksum worker starts
>> in that window, it can miss the new database completely and skip
>> generating its checksums.
>
> Thanks for the report and patch, I am currently out of the office but will check and apply on Sunday or Monday when back home.

I had a look at this today and came up with the attached v2. Apart from some
comment changes the main difference is that I placed the test in an already
existing testfile to reduce the number of initdb's required, and added a test
for the error message in the logfile.

--
Daniel Gustafsson