pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Сергей Шиндерук <s.shinderuk@postgrespro.ru>
To: s.shinderuk@postgrespro.ru
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map
Date: Thu, 12 Nov 2026 09:51:45 +0300
Message-ID: <E2B2D02B-F389-4654-87D6-38E39948DD9F@postgrespro.ru> (raw)
In-Reply-To: <19894-9d785d87407234dc@postgresql.org>
References: <19894-9d785d87407234dc@postgresql.org>


> 12 нояб. 2026 г., в 03:49, PG Bug reporting form <noreply@postgresql.org> написал(а):
> 
> The following bug has been logged on the website:
> 
> Bug reference:      19894
> Logged by:          Sergey Shinderuk
> Email address:      s.shinderuk@postgrespro.ru
> PostgreSQL version: 17.11
> Operating system:   Ubuntu 24.04
> Description:        
> 
> Hello,
> 
> 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)


Sorry, looks like it's a known issue:
https://www.postgresql.org/message-id/CAAKRu_bK7oJvtrrzL_V-OHouCWDKyU2-ERv+QvV6XM9Wh2dpUg@mail.gmail...
https://www.postgresql.org/message-id/CAAKRu_aaP%3D0GZe%2BD721byOM9Vwjtu94VdAE_em0PNC0r3EK2zg%40mail...

Didn't follow the discussion yet.





view thread (4+ messages)  latest in thread

Message-ID: <E2B2D02B-F389-4654-87D6-38E39948DD9F@postgrespro.ru>
Permalink:  ../E2B2D02B-F389-4654-87D6-38E39948DD9F@postgrespro.ru/
Also on:    postgresql.org/message-id/E2B2D02B-F389-4654-87D6-38E39948DD9F@postgrespro.ru

 · 

reply

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
  Subject: Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map
  In-Reply-To: <E2B2D02B-F389-4654-87D6-38E39948DD9F@postgrespro.ru>
  References: <19894-9d785d87407234dc@postgresql.org> <E2B2D02B-F389-4654-87D6-38E39948DD9F@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