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.96) (envelope-from ) id 1wrD9J-000DKv-1X for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Aug 2026 11:17:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wrD8I-00618J-3B for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Aug 2026 11:16:31 +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.96) (envelope-from ) id 1wrD8I-006189-1n for pgsql-hackers@lists.postgresql.org; Tue, 04 Aug 2026 11:16:31 +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 1wrD8F-00000000A68-3kJI for pgsql-hackers@lists.postgresql.org; Tue, 04 Aug 2026 11:16:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1785842184; bh=2D57quPwPwMK9Xl1RmPdW/c/WMuWlFmY0xkv4pWeyvI=; h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From: In-Reply-To:From; b=In5Mz/yoKHFlSeKXuNLw0h9KgOUBCWTEW3+uaSXMo0oQY3F5CDEH70W4NtRYJIYEU lKH9mbE1k6Yb3K9j9G2v9YK1legM6Dcn4+DgI/ikeYhGYklshdM74XhKMaYmzRF3jJ f/cG+sRP5Y6Y3QjZafsZ9ICe33DJF/HdGX40j5/mS0mH5YYR42UOd56m5l+8DDQ89A cZumeIjhJUOmavCzVx31OhQ8dsXhRhvAPTUPpmmXwWpghXh8cy7/pJRznXZ4hwgFcz QNRqWP/XWQQqhlQRFcpDecbukSuKUngKJR3OV3tQCht/xX/gMip4e5/1sbeGA/wknm /1YCJOgn854Lw== Received: from [172.30.50.166] (debian11-template.l.postgrespro.ru [192.168.2.254]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange x25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (Client did not present a certificate) (Authenticated sender: v.davydov@postgrespro.ru) by mail.postgrespro.ru (Postfix/465) with ESMTPSA id 60B1E615FE; Tue, 04 Aug 2026 14:16:24 +0300 (MSK) Message-ID: Date: Tue, 4 Aug 2026 14:16:24 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Deadlock detector fails to activate on a hot standby replica To: JoongHyuk Shin Cc: Xuneng Zhou , Fujii Masao , pgsql-hackers@lists.postgresql.org References: <44c24dcf-5710-410f-b1b6-d10b315f3d51@postgrespro.ru> <279402b1-7f16-43fa-9dbf-df96a93245dd@postgrespro.ru> <16cdffd4-f06c-4957-9132-1849a719f3d4@postgrespro.ru> <790719db-f518-4300-8ce7-8f168cd0af84@postgrespro.ru> <7b1e8353-3d0a-48a1-bac6-2ac6ca91fbde@postgrespro.ru> <5c50d50c-5a9c-4a9e-9592-183cf4de1c80@postgrespro.ru> Content-Language: en-US From: Vitaly Davydov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-KSMG-AntiPhishing: NotDetected, bases: 2026/08/04 08:51: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/08/04 09:28:00 #28645557 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 Hi JH Shin, On 8/4/26 08:30, JoongHyuk Shin wrote: > On Thu, Jul 2, 2026 at 12:57 AM Vitaly Davydov > wrote: >> It seems, the patch should be completely rewritten. I will try to >> prepare a new patch version. > > Hi Vitaly, > > Any update on the new version you mentioned in your last message? I can't give you an exact time right now because of the issues highlighted in the last review that need to be elaborated on. Sorry, I've just started looking at it again. It might take a week or two. If your patch is ready for commit, please go ahead with it. As I see it, the main change in your patch avoids periodic message logging by passing the log_recovery_conflict variable from the caller. Once your changes are committed, I don't foresee any problems merging them into my patch. Vitaly Davydov vitcpp@mail.ru