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.94.2) (envelope-from ) id 1uFeVt-00776B-RO for pgsql-general@arkaria.postgresql.org; Thu, 15 May 2025 19:45:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uFeVs-00GKg3-DU for pgsql-general@arkaria.postgresql.org; Thu, 15 May 2025 19:45:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uFeVs-00GKfv-2g for pgsql-general@lists.postgresql.org; Thu, 15 May 2025 19:45:04 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uFeVp-0024tJ-1O for pgsql-general@lists.postgresql.org; Thu, 15 May 2025 19:45:03 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-5fcc96b6a64so2641424a12.0 for ; Thu, 15 May 2025 12:45:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747338301; x=1747943101; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=zXCWTtbEkOLWwEdXJm2Dr+LoXQpVROgI9vAftQmtrQY=; b=MrYy8QjTRWQV0PuMJCSJK1+Nmx90jl1Y+odw1nfVUZfdQ6OeaPsNfuHWlwGzuK9VX+ d6Tff56+dzSNY4D8T//FW/urVLlAkGS5+DfwHihDurGqm1AqL3Tm+nfWZE9iX+9CWGoW CTN5RE3FDRxVZBEmlqWKL9PZXU0RpOIMx7ReZGGJaiwwrwfFwqcWeF0ezDs2nVrFJK5C JH8rufF/I8BCvsRwrO1iJ1fSz4FkqFPCtE+9V5EJmwnziNhHVaWFrSV47SLXu9SVBEkk zEuO/Vk+R7mAh0a+nOnmvYa4cxQJ7R/t0uG5XNba9EFZFNY1QWSJaINWD8WwtIlm1udC pEww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747338301; x=1747943101; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=zXCWTtbEkOLWwEdXJm2Dr+LoXQpVROgI9vAftQmtrQY=; b=MGuIMJMKpwE0tqFs1Y1YIzezlcytbFzfHp+fL3LLnYC2XXbFlNFc001sSpEULhCRWH XPp3mSnp0RqbViTTWwWQj5V4YAUaXVjC2/cILKDTJPAnfQKv1co7GXfLrAiSexC24Ay1 jtPSaB8W4XIntALeyDwpDWATXBovmICJjT7D4/+p47F6WP8W7kqBBAEsBmdjjDS5+wu7 /i/+679hqfAoR4O91CpwN71WYq8mPa+IF7Oh1bXS/kwT0f+ge11J6FmZ0ohoI+3eoNAJ X8HPnjH5AFy8aaGFujExhAqPOWpjfY8Occo8MIfiBbQZR2yQmEKF8saj0UP6TZ141naX 3WjA== X-Gm-Message-State: AOJu0Yy54pMJ0lvWjpzL6sxchTgzqeNNqMVv4EwdPtyz1hyMbVSkXhYu DEUDdZs40yyvBZODP5sfbewW6OZR/IrsEzmhDCO03tSBp7VHNX63DKQRNsBK3okyxwhHIjAlgeb Egr/dNAKYWN+LRBHTD4JEhrmizpsl5K0= X-Gm-Gg: ASbGnctEAC4LmX0IxNcDH1nMjsI+V4CPI2kOFALss2fElQMkULw5YNePvyOZ8NaY7yU txrvpNkqDDLfqUMqLD0lW2VCiJF/AqQlkbVASuY0KwZyvkeEQpeVARKZLjaxJjiZirjIusKz8R0 50KZgS0z++4PUhsG7HxJKVrDDz09/OPe8= X-Google-Smtp-Source: AGHT+IG0yQXULW4RFkGJMkjkGNygPvYYOd+VYo8NNYZaTZDQeipbopW2WqlyEdlESCf3s7B2bIBvv7IY/LqyzHNUckE= X-Received: by 2002:a17:906:c105:b0:ad2:2d84:ab80 with SMTP id a640c23a62f3a-ad52d65f554mr99637066b.58.1747338300714; Thu, 15 May 2025 12:45:00 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: yi zhao Date: Thu, 15 May 2025 12:44:48 -0700 X-Gm-Features: AX0GCFuP_bTM0ZjlJ3LIniVQrgesZBwcu_h-ghDtWgPO9e59ETH8xaC6Fsv3nKg Message-ID: Subject: Re: unexpected pageaddr in WAL segment To: Luca Ferrari Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000b773c6063531e666" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b773c6063531e666 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Maybe disk block corruption, try to delete it in standby if it has been applied. Best regards, Steven On Wed, May 14, 2025 at 12:22=E2=80=AFAM Luca Ferrari = wrote: > In one physical replica running version 17.4 I'm seeing this entries > repeated in the logs: > > unexpected pageaddr 0/4000000 in WAL segment 000000010000000000000009, > LSN 0/9000000, offset 0 > > the system is working correctly, what does the above mean? > > Thanks, > Luca > > > --=20 best regards, Steven Zhao --000000000000b773c6063531e666 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Maybe disk block corruption, try to delete it in standby i= f it has been applied.

Best regards,
Steven

On Wed, May 14, 2025 at 12:22=E2=80=AFAM Luca Ferr= ari <fluca1978@gmail.com> = wrote:
In one ph= ysical replica running version 17.4 I'm seeing this entries
repeated in the logs:

unexpected pageaddr 0/4000000 in WAL segment 000000010000000000000009,
LSN 0/9000000, offset 0

the system is working correctly, what does the above mean?

Thanks,
Luca




--
best regards,
Steven Zhao
--000000000000b773c6063531e666--