Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRZNu-000000015PG-3k5J for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Nov 2026 18:18:55 +0000 Received: from localhost ([127.0.0.1]:44890 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xRZNt-00000004KwY-1UEs for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Nov 2026 18:18:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:44152) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRZNs-00000004KwL-3xax for pgsql-bugs@lists.postgresql.org; Thu, 12 Nov 2026 18:18:53 +0000 Received: from mail.postgrespro.ru ([93.174.132.70]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRZNq-00000000cII-39AD for pgsql-bugs@lists.postgresql.org; Thu, 12 Nov 2026 18:18:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1794507526; bh=Vpx3waHwPMEF2xYqCVROta1HsgiKhevtKZfSMckvT6c=; h=Subject:From:In-Reply-To:Date:Cc:Message-Id:References:To:From; b=j8A2hVBoPJ2IF2nfX2//B7F7FVyCMcr+/V3L41zON+2zQaJCR+ODwmiKl8xpBKJA3 wGcaNULmXVs9zfBBkqbLr1KrNEo8CA+Ur7lWAD2r4UBwyg9pBbHmKCUThLMF3e5XdQ eHHJ6XfRvrLGos+sNa7cUrPdsDgY3qtpDHj94+q4CznxrfBQrHuDlkX9w1SaXnP1XJ ldH1Cb40vDsFPTiWQSpEeJr0YwlEQI54mUCf2nAd1IgnfSBcJEhGaW0h3L3aGqqRkm bk4d9bJijNGKdK8jn71T+fOmmWaKVf7EsER6D/V2ZGbItsCbU8Z+Qns/0TUh+4vd7s UkVpZvsfnNt4A== Received: from smtpclient.apple (debian11-template.l.postgrespro.ru [192.168.2.254]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) (Authenticated sender: s.shinderuk@postgrespro.ru) by mail.postgrespro.ru (Postfix/465) with ESMTPSA id 23785618C9; Thu, 12 Nov 2026 21:18:46 +0300 (MSK) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.700.51.1.3\)) Subject: Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map From: =?utf-8?B?0KHQtdGA0LPQtdC5INCo0LjQvdC00LXRgNGD0Lo=?= In-Reply-To: <7D9722EF-48D8-4727-BD0D-FB526D807F97@thebuild.com> Date: Thu, 12 Nov 2026 21:18:35 +0300 Cc: pgsql-bugs@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <19894-9d785d87407234dc@postgresql.org> <7D9722EF-48D8-4727-BD0D-FB526D807F97@thebuild.com> To: Christophe Pettus X-Mailer: Apple Mail (2.3864.700.51.1.3) X-KSMG-AntiPhishing: NotDetected, bases: 2026/11/12 17:16:00 X-KSMG-AntiSpam-Interceptor-Info: not scanned X-KSMG-AntiSpam-Status: not scanned, disabled by settings X-KSMG-AntiVirus: Kaspersky Secure Mail Gateway, version 3.0.0.9059, bases: 2026/11/12 16:20:00 #28860615 X-KSMG-AntiVirus-Status: NotDetected, skipped X-KSMG-LinksScanning: not scanned, disabled by settings X-KSMG-Message-Action: skipped X-KSMG-Rule-ID: 1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > 12 =D0=BD=D0=BE=D1=8F=D0=B1. 2026=E2=80=AF=D0=B3., =D0=B2 20:40, = Christophe Pettus =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0= =BB(=D0=B0): >=20 >> 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) >>=20 >> 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) >=20 >=20 > Why is this a bug? I'm sorry for bothering you. It's already discussed here: = https://www.postgresql.org/message-id/tencent_2E870046716FD94285045E96505A= 2D4E2908@qq.com and here, causing data corruption: = https://www.postgresql.org/message-id/CAAKRu_bK7oJvtrrzL_V-OHouCWDKyU2-ERv= +QvV6XM9Wh2dpUg@mail.gmail.com I should have searched hackers before submitting a bug :(