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 1u9ZNo-003WTZ-GR for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Apr 2025 01:03:36 +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 1u9ZNm-004Jsr-Gy for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Apr 2025 01:03:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u9ZNm-004Jsi-7v for pgsql-hackers@lists.postgresql.org; Tue, 29 Apr 2025 01:03:35 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u9ZNl-0005yc-0u for pgsql-hackers@postgresql.org; Tue, 29 Apr 2025 01:03:34 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-54d65cb6e8aso7015421e87.1 for ; Mon, 28 Apr 2025 18:03:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745888612; x=1746493412; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=PPfiTYMXe4b1Pm+ISjfIcR4sDJTQKWM9c4iweWaobqg=; b=fV+fKLxKplh4Q0HqHF8L8ur16RmWD+EgCCHf5oPTYrkrPJfK4eNV+c47fEv+pSRBzk OZ+X7XowEbJpCqk3tzsxUGbaUC9AuRH5lsdDHzC6LCeOXiVqMEU0n8OFkCvEMNjrlNTp K36/Yrx0tFw5bQBxLCXLQxh3reHnoJl9bYaZ2Hy+WY3DEYDBlyLTG7Cv9DtUHOBO4naE VWkrxpH58cyEsN/vDXaGHcnPUP8kA078zoqmSihqzIccRKpzLXoyaEbQUFBivkNJJzkS ENygIYYSm7NjIF1KbAficqzDWjls0Et+38EfVjsd6chUi1o2q56yfjby37v2Cg/kXCge 61JA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745888612; x=1746493412; h=content-transfer-encoding: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=PPfiTYMXe4b1Pm+ISjfIcR4sDJTQKWM9c4iweWaobqg=; b=ELhfZLbiZc6OeYKkF7ZyUhhApRgaoTEi00yqXfER/FjVHHZLD4HF5+cF+BovFf/cH5 /j8SLKQ7R4HYhmWStuNB3NJhCFjqdH0MPx8ZWGc/G2Zs7plb2hE0xS2h02GilxJ7HXfb 18Opfgdinkqg6VcYP3QJbWJ0wGxUSiaZt7NvUDT60ldeuLgT08FtgBED+9Purub5Sr+J bHthEmiDBso/gg3BiPumaueMOAjdADHP+xjG0POmFrJBQ8g3n3FmmnTu4HWEDkJpJgPT i+yP8sKGV3mAYBQc0HWuwflLWMj5VwkHZrVzvu10UxHr2FVYIEWFqmGb9O2oQ3mi/1zU Avyw== X-Forwarded-Encrypted: i=1; AJvYcCX1fmRFuc8dsC7hyTfCSqeTsc/z+xvBFYbqPaWB9S3ujc1aCda77xh/I5lXBOzztIY1EJ/N9PIktT1thog4@postgresql.org X-Gm-Message-State: AOJu0Yw5vFHqfHUVnPzxeBvfvb/zssE2jrbQJpEa2pCULPjS8L21w4U9 OtG8dlMHGtkxoFYXbM4aEhkVfxwLp01UQ2TD80XMXvlmNPldvehGdZnJ7MgJZRqMY1DKZwJddRI yMRooWUtgTgalsphz/+pJk8WGNG4= X-Gm-Gg: ASbGnctgLtp2/kcqX4OGs+qyzTbfT6oA5CjCDWi8GqlBIJJQ2NwQWN3Z0EmyhOQ0506 6iFBC8EBainvDZEtJ2ndCaxxToDjMdT0+fScn+6/0uzenRnzMf9sR5z7AoB+jTv75P14wwj23/P lQguiArznJmB809O02sgRk0TwafSIn6+5nlw== X-Google-Smtp-Source: AGHT+IEcFXKDdbmssKaqhu4aKQjmRpRBpHWKie99bRfFfQIzBmb/qf6N0b5UDMCcpa9hfIZsy3aitwoSMzrOrT3vKEc= X-Received: by 2002:a05:6512:ac3:b0:54d:6df8:ac19 with SMTP id 2adb3069b0e04-54e9e537bf3mr215797e87.6.1745888611479; Mon, 28 Apr 2025 18:03:31 -0700 (PDT) MIME-Version: 1.0 References: <1d12d2-67235980-35-19a406a0@63439497> <683f3c82-d38e-436d-88fd-27722af62005@vondra.me> <8679fea7-94ce-4a52-8e48-1a8cd0857fcb@vondra.me> <135e8-675c4600-21-304d7f40@228322535> <1538a2-67c5c700-7-77ec5a80@179382871> <27589a-680a4b80-6d-6e07880@117064404> In-Reply-To: From: Masahiko Sawada Date: Mon, 28 Apr 2025 18:02:55 -0700 X-Gm-Features: ATxdqUFSZcgYX9ny6NJE4UIXccf6mlKdhhH-6oVFTZWXkSn1Vwh5y2CxaWD9sYM Message-ID: Subject: Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly To: Alexander Korotkov Cc: Vitaly Davydov , pgsql-hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Apr 28, 2025 at 8:17=E2=80=AFAM Alexander Korotkov wrote: > > > I have a question - is there any interest to backport the solution into > > existing major releases? > > As long as this is the bug, it should be backpatched to all supported > affected releases. Yes, but I think we cannot back-patch the proposed fix to back branches as it changes the ReplicationSlot struct defined in slot.h, which breaks ABI compatibility. Regards, --=20 Masahiko Sawada Amazon Web Services: https://aws.amazon.com