Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map

Поиск
Список
Период
Сортировка
Искать

Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map

От:
Сергей Шиндерук <s.shinderuk@postgrespro.ru>
Дата:

> 12 нояб. 2026 г., в 03:49, PG Bug reporting form  написал(а):
> 
> 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.com
https://www.postgresql.org/message-id/CAAKRu_aaP%3D0GZe%2BD721byOM9Vwjtu94VdAE_em0PNC0r3EK2zg%40mail.gmail.com

Didn't follow the discussion yet.

FAQ