From: Сергей Шиндерук <s.shinderuk@postgrespro.ru>
To: Christophe Pettus <xof@thebuild.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map
Date: Thu, 12 Nov 2026 21:18:35 +0300
Message-ID: <FDA04131-ADAF-4859-AC34-C003BBD5519D@postgrespro.ru> (raw)
In-Reply-To: <7D9722EF-48D8-4727-BD0D-FB526D807F97@thebuild.com>
References: <19894-9d785d87407234dc@postgresql.org>
<7D9722EF-48D8-4727-BD0D-FB526D807F97@thebuild.com>
> 12 нояб. 2026 г., в 20:40, Christophe Pettus <xof@thebuild.com> написал(а):
>
>> after CREATE DATABASE on a primary
>> select * from pg_visibility_map('pg_class')
>> blkno | all_visible | all_frozen
>> -------+-------------+------------
>> 0 | t | t
>> 1 | t | t
>> 2 | t | t
>> 3 | t | t
>> 4 | t | t
>> 5 | t | t
>> 6 | t | t
>> 7 | t | t
>> 8 | t | t
>> 9 | t | t
>> 10 | t | t
>> 11 | t | t
>> 12 | t | t
>> 13 | t | t
>> (14 rows)
>>
>> but on a standby:
>> blkno | all_visible | all_frozen
>> -------+-------------+------------
>> 0 | f | f
>> 1 | f | f
>> 2 | f | f
>> 3 | f | f
>> 4 | f | f
>> 5 | f | f
>> 6 | f | f
>> 7 | f | f
>> 8 | f | f
>> 9 | f | f
>> 10 | f | f
>> 11 | f | f
>> 12 | f | f
>> 13 | f | f
>> (14 rows)
>
>
> Why is this a bug?
I'm sorry for bothering you. It's already discussed here:
https://www.postgresql.org/message-id/tencent_2E870046716FD94285045E96505A2D4E2908@qq.com
and here, causing data corruption:
https://www.postgresql.org/message-id/CAAKRu_bK7oJvtrrzL_V-OHouCWDKyU2-ERv+QvV6XM9Wh2dpUg@mail.gmail...
I should have searched hackers before submitting a bug :(
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-bugs@postgresql.org
Cc: s.shinderuk@postgrespro.ru, xof@thebuild.com
Subject: Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map
In-Reply-To: <FDA04131-ADAF-4859-AC34-C003BBD5519D@postgrespro.ru>
References: <19894-9d785d87407234dc@postgresql.org> <7D9722EF-48D8-4727-BD0D-FB526D807F97@thebuild.com> <FDA04131-ADAF-4859-AC34-C003BBD5519D@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox