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 1nKDVd-00084q-FW for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Feb 2022 06:09:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nKDVb-0003WQ-Hn for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Feb 2022 06:09:47 +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 1nKDVb-0003WE-6n for pgsql-hackers@lists.postgresql.org; Wed, 16 Feb 2022 06:09:47 +0000 Received: from mail-pf1-x42e.google.com ([2607:f8b0:4864:20::42e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nKDVY-0004B6-Jd for pgsql-hackers@postgresql.org; Wed, 16 Feb 2022 06:09:46 +0000 Received: by mail-pf1-x42e.google.com with SMTP id g1so1339608pfv.1 for ; Tue, 15 Feb 2022 22:09:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:message-id:to:cc:subject:from:in-reply-to:references :user-agent:mime-version:content-transfer-encoding; bh=CGJAe2ou4eZFAEHbUhEY1GHQ8Osh45/ZsdFYdSUDf7k=; b=KPNtjDDCOZ/Rru9ZV0mArGJd08VmYA9O0dYtBqCEdCPY92wyPFTsNacwML1723o7t7 /PGNylkf83+4pCvbdgU8XD3glOW0aKSWN/7NwGcukmfoQlwak29yowaQMeZ5JCuz8KVA 50a0yEsQaqocmZFEJXtJUJwfzem4iQVBK9y6/P2IXbPSO3KD4BiYPVMfPb7i6AdClVV/ 21EfnnAKqC2uJLo1DJlH5jDlAjeL/kDShzKF2KoWiVNF2kgMBRW8S3tOnalyssVLnmJs zdLRl65C9IWjH3sELWpphtdcluvpEIXFfjaWCESnYeRFl/Ts0bmZxkfxOuYbvoMPsRtT NKXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:message-id:to:cc:subject:from:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=CGJAe2ou4eZFAEHbUhEY1GHQ8Osh45/ZsdFYdSUDf7k=; b=OwBXvMHCGNf3/+NjdNrrWnPhgCXulYJckg5g8JXNlJ5mcfqucuRg9VMv7nKahPD0kX vo52AcxgjAhBesD1UEr2wk4gqCBxzatWYEa6u7plKP2M4zPAPd/v8uS1Ro0BH2dy545u nfeldj3DpmAsCiyTii/SD+8oWCrMxeuQm1o6wLobtCv1F2uH8wLXblfhYlBrn3yEHcAR jIidZl3PguM5da8C79AqksyHw9f4Od96BWVxxheik+aGjBx7eWKe8lROxmNuSGmglxGr gagL6J8fcS7KVgH/gKwVlRfAH2cW5L18ynGkYjxsgjWhg3+UYApno7l8B525t85eC63M N6yw== X-Gm-Message-State: AOAM531J04f/8LqCPGSe/rSbUDcTlZI2J3iJMYhRRfubbIRZjQJnCE9r cgRyi5gA6H9vu2vNRJI7ytE= X-Google-Smtp-Source: ABdhPJweBgYJSVWWDqn5YCPc28C/jdDG4lax8X//fCXsQ7ounr0bE7A5br/FF7xCC1je1wFVIaeQHg== X-Received: by 2002:a63:f24b:0:b0:343:9666:eca9 with SMTP id d11-20020a63f24b000000b003439666eca9mr1075789pgk.274.1644991781947; Tue, 15 Feb 2022 22:09:41 -0800 (PST) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id u39sm3346043pfg.195.2022.02.15.22.09.39 (version=TLS1_3 cipher=TLS_CHACHA20_POLY1305_SHA256 bits=256/256); Tue, 15 Feb 2022 22:09:41 -0800 (PST) Date: Wed, 16 Feb 2022 15:09:38 +0900 (JST) Message-Id: <20220216.150938.760580034521958485.horikyota.ntt@gmail.com> To: sawada.mshk@gmail.com Cc: andres@anarazel.de, hlinnaka@iki.fi, pgsql-hackers@postgresql.org Subject: Re: Race conditions in 019_replslot_limit.pl From: Kyotaro Horiguchi In-Reply-To: References: <20220215235157.jknqi73c5scietxe@alap3.anarazel.de> <20220216.142637.1918987197255698649.horikyota.ntt@gmail.com> User-Agent: Mew version 6.8 on Emacs 26.1 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk At Wed, 16 Feb 2022 14:58:23 +0900, Masahiko Sawada wrote in > On Wed, Feb 16, 2022 at 2:26 PM Kyotaro Horiguchi > wrote: > > > > At Tue, 15 Feb 2022 15:51:57 -0800, Andres Freund wrote in > > > I guess it's conceivable that the backend was still working through process > > > shutdown? But it doesn't seem too likely, given that several other connections > > > manage to get through entire connect / disconnect cycles? > > > > Yes, but since postmaster seems thinking that process is gone. > > Or it's possible that the process took a time to clean up the > temporary replication slot? Ugg, it's immediate shutdown. So postmaster kills the walsender no matter what state the waldender is under, nd leaves no log about the end ofwalsender. Sorry for the confusion. regards. -- Kyotaro Horiguchi NTT Open Source Software Center