Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1og9df-0004FG-G6 for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Oct 2022 19:01:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1og9de-0002ik-B9 for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Oct 2022 19:01:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1og9de-0002iG-1u for pgsql-hackers@lists.postgresql.org; Wed, 05 Oct 2022 19:01:02 +0000 Received: from mail-pg1-x52f.google.com ([2607:f8b0:4864:20::52f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1og9db-0001NO-Gp for pgsql-hackers@lists.postgresql.org; Wed, 05 Oct 2022 19:01:01 +0000 Received: by mail-pg1-x52f.google.com with SMTP id f193so16057060pgc.0 for ; Wed, 05 Oct 2022 12:00:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date; bh=inXSkQeDdjhNn6cWUjFt/VYAbIjkDXOKuqhsicVNWGg=; b=fT3omQI2gsEJrlWjBWdDWQoEJOKyUxuHSAGu9MOVphNAp86DiQnwm6L4bcaGUiX1Xu Ih0S8Xrz+uD1d2KP1UkvNi8RrtwBAQS16FM/0R/RLJMaGwtY+5+V7wIeRMvl/pFAz63R QGGmGZhvhyOAQGTVlO8VgJ2Rw1amt47508f1lZX8DJ7sIWdN2py56RYhektJeoLjrwtb PMNeGtJzPFOOvPJRwrbyqx/BTH1AdHXEH/O9vNfFU6c24PwpSWVVy/mvjHJIrFCfUgoO v+M4ceHmTImh8i8/pBM/dPf1CRfx1cMrtzZluzZMWJ+WFAVbsNkZb0vvBYarhVwkGAIz +Qlg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date; bh=inXSkQeDdjhNn6cWUjFt/VYAbIjkDXOKuqhsicVNWGg=; b=EgjAsR5ejKxyJDbCjt0LtfTrhP1G1gmIwVMu2jU5kTz/eDH02EZjtyULdRPvfnijxs ywkXUivtHvcKVOR3xq+8LIjowHEX0LMeWe2kpnQesu8+XGIeSKLJ8/OyDG0xwSQx52Ni 421r03i9esNdOPlR0F95bZleFc8eBf4J9WfQ5yU5M4Sq/ZxXb/JaLEwE7tCOCUPuO4du f9LF0fGOi+X+l8ybEn1f08u4JyFmqnO3qXOZEPRJ8g183yuVKt+quzxZos8UyBLQMz0R wTiHpasXMN56qYYikj+N+KioDraGbnAjO+TKo5Moq78G0G4QCx1iN/TwwX9ACoyINvyZ MIwQ== X-Gm-Message-State: ACrzQf2r6TULEcDYvC3hXPzUyGs+nM6+gs/3PLduVT1KqHP4AmnJl/tS e2PbMzwMwRcr75xb2M1z4FU= X-Google-Smtp-Source: AMsMyM6UWGrcO8bJ13HVYZ334okCVBYluOrr7/FlEUryYYmb9Y2u4CObrDeQm9ThQ96LfywVnsRWlA== X-Received: by 2002:a62:c584:0:b0:558:2095:e5ed with SMTP id j126-20020a62c584000000b005582095e5edmr1252325pfg.64.1664996457433; Wed, 05 Oct 2022 12:00:57 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id s9-20020a63ff49000000b0043be31d490dsm68015pgk.67.2022.10.05.12.00.56 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 05 Oct 2022 12:00:56 -0700 (PDT) Date: Wed, 5 Oct 2022 12:00:55 -0700 From: Nathan Bossart To: Tom Lane Cc: Kyotaro Horiguchi , dgrowleyml@gmail.com, kuzmin.db4@gmail.com, pgsql-hackers@lists.postgresql.org Subject: Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records Message-ID: <20221005190055.GC201192@nathanxps13> References: <2138765.1664924048@sss.pgh.pa.us> <2208668.1664927591@sss.pgh.pa.us> <20221005001531.GC779730@nathanxps13> <20221005.104103.1560341327554683899.horikyota.ntt@gmail.com> <2414481.1664983822@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2414481.1664983822@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Oct 05, 2022 at 11:30:22AM -0400, Tom Lane wrote: > One other point to discuss: should we consider back-patching? I've > got mixed feelings about that myself. I don't think that cases where > this helps significantly are at all mainstream, so I'm kind of leaning > to "patch HEAD only". +1. It can always be back-patched in the future if there are additional reports. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com