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 1uSTrE-0086qA-7z for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Jun 2025 05:00:08 +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 1uSTrC-00GqDc-BE for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Jun 2025 05:00:06 +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 1uSTrB-00GqDP-VU for pgsql-bugs@lists.postgresql.org; Fri, 20 Jun 2025 05:00:06 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uSTrA-0034Fg-0o for pgsql-bugs@lists.postgresql.org; Fri, 20 Jun 2025 05:00:06 +0000 Received: by mail-wm1-x335.google.com with SMTP id 5b1f17b1804b1-451dbe494d6so16467295e9.1 for ; Thu, 19 Jun 2025 22:00:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750395603; x=1751000403; darn=lists.postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=liq90GwbHGL7FO1Lqp9dXFtDqpG4j7FL7hzp1/itQ5A=; b=A6pPj+nsxqGmP9AAB46eUFTKGsVfybDUbJUU33CEY7WY0dtHO7kA8bhUPVupoZlDsS 9oRBVSQ+U89GtHntroiwaUFyX9ROjSuGZ3OWW72zA48yLQDvcDuS0QI/p+hFgGRPUqx/ MF7VDxUFNebXGuaT7EmnjbDczajZQbCXzfpqph6s+1+zFbQUuv66qCxvox0Sur7MMcyC HjLMNUM1nbpYDTik73hkLoWZcnVKN5PlZt34pA1W6Fuxh7BVGfTrImqRa+/CyItXNWr3 qhTTL/+k8MaFkfTbzPeO5bp6cz/zBNEuYk7cTg2QDfPeE4x9aJIbSOE5LOgfVpFnI8U0 /VQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750395603; x=1751000403; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=liq90GwbHGL7FO1Lqp9dXFtDqpG4j7FL7hzp1/itQ5A=; b=RnhFSO5qEmbJUoP6rZb81gvzXP3zZcMl1R//EgyL6awKtynvJ2Q5+PZtRzhw0IzcTc JQJ2jIW7SNCiDQvFUYPMcEc4LiMMSoB/1qH8M7NrCHPZG0L/+mi+EAo0bJ1+pgkLm24O 0LLxq61x04rekbqEmMp9SsY5hhCfuKlw0ytGL9liRoOLjzsEhb4xpJ7HfKmDHBjjqVHK ULTh8Lf8kKuJwXQE6MgCckVPvl+++L0/uru1i4l8VuFiKPgvzPhOp7rkJSRRHPFf/VmX HlI4vjUTEBL/ZfxfxbJUcsHenw5nI7pS09HDCkwPSw8jN1w2RG7zcLR2uaDutI6kn46k 1hTA== X-Forwarded-Encrypted: i=1; AJvYcCX0TjjgVu6jzZSlMGl4ri2kCTp1sLUPsoSVHUo8wJDDmxq/XtLbCVtZ4XSVJCLu2i4ECHVjF0iPvXq/@lists.postgresql.org X-Gm-Message-State: AOJu0Yy39LxxpDLjR76lwZ0vywtDXNHTfZfjHoyWrtJyjovYjtD8foYR rWmWsuMDZTFtIMdAPuP1h+Mx+i3xfI97HhAqP5k94kC1fQSx5BeiNDDK X-Gm-Gg: ASbGncslPrCLqow/aIHcmy8L/63bdcnJoeUEUBtQKdXXoHvxWnl724Wrl9+zS9zy8jh +SOOxKUuXA8NuR3TaY3BASjdX2hBFyrCaxlbIm/fgqpxiEONT0z/V2wrc0XcxAoiQ6u2BL1+lkI cHj7MFQJbYkNHXywWZHO5YhY/d9Sb4pjOKtXKoi2W9J7nynf+gHfsgpFLpQyPJjOvc0sB7uvwVM JakZqEvjLz0ibyGbwf72VP6Ic29btJCJYMWykH80Q33Tn1Y4axBJl+AlgVBfbSWLT2i6VXtJONO cRZrkjVGaA1LuW1KEEEWt6IYZlirOtrYO6/JA4Y9/vXZWkZKL1OF0C9ZSExSufQK5Q== X-Google-Smtp-Source: AGHT+IFI6ZOd0Xu1cofUIU3dp1QEsK3QxXHPKIuytsed9FDACiLcgBD6VPMUo/5qEiLuCtv5KvpFJQ== X-Received: by 2002:a05:600c:1c98:b0:450:cf00:20f5 with SMTP id 5b1f17b1804b1-45367067893mr2489815e9.9.1750395602943; Thu, 19 Jun 2025 22:00:02 -0700 (PDT) Received: from [192.168.0.50] ([89.149.120.224]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-45364708658sm12914735e9.39.2025.06.19.22.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 19 Jun 2025 22:00:02 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------x0YWfs023zI0eBIvGE0TaUkk" Message-ID: Date: Fri, 20 Jun 2025 08:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Logical replication 'invalid memory alloc request size 1585837200' after upgrading to 17.5 To: Masahiko Sawada , vignesh C Cc: Amit Kapila , "Hayato Kuroda (Fujitsu)" , Duncan Sands , "pgsql-bugs@lists.postgresql.org" References: <680bdaf6-f7d1-4536-b580-05c2760c67c6@deepbluecap.com> Content-Language: en-US From: Alexander Lakhin In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------x0YWfs023zI0eBIvGE0TaUkk Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hello Sawada-san, 17.06.2025 20:40, Masahiko Sawada wrote: > Pushed the fix (d87d07b7ad3). Thank you for working on this fix. As buildfarm [1] shows, the test case added to invalidation_distribution with 1230be12f fails against -DCLOBBER_CACHE_ALWAYS on REL_13_STABLE: diff -U3 /home/buildfarm/trilobite/buildroot/REL_13_STABLE/pgsql.build/contrib/test_decoding/expected/invalidation_distribution.out /home/buildfarm/trilobite/buildroot/REL_13_STABLE/pgsql.build/contrib/test_decoding/output_iso/results/invalidation_distribution.out --- /home/buildfarm/trilobite/buildroot/REL_13_STABLE/pgsql.build/contrib/test_decoding/expected/invalidation_distribution.out 2025-06-17 10:24:24.382768613 +0200 +++ /home/buildfarm/trilobite/buildroot/REL_13_STABLE/pgsql.build/contrib/test_decoding/output_iso/results/invalidation_distribution.out 2025-06-17 15:01:53.921913314 +0200 @@ -31,7 +31,7 @@  step s2_get_binary_changes: SELECT count(data) FROM pg_logical_slot_get_binary_changes('isolation_slot', NULL, NULL, 'proto_version', '1', 'publication_names', 'pub') WHERE get_byte(data, 0) = 73;  count  ----- -    0 +    1  (1 row)  ?column? I could reproduce this locally and also checked that the test passes on REL_14_STABLE and master. Could you look at this, please? [1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=trilobite&dt=2025-06-17%2008%3A24%3A00 Best regards, Alexander --------------x0YWfs023zI0eBIvGE0TaUkk Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Hello Sawada-san,

17.06.2025 20:40, Masahiko Sawada wrote:
Pushed the fix (d87d07b7ad3). Thank you for working on this fix.

As buildfarm [1] shows, the test case added to invalidation_distribution
with 1230be12f fails against -DCLOBBER_CACHE_ALWAYS on REL_13_STABLE:
diff -U3 /home/buildfarm/trilobite/buildroot/REL_13_STABLE/pgsql.build/contrib/test_decoding/expected/invalidation_distribution.out /home/buildfarm/trilobite/buildroot/REL_13_STABLE/pgsql.build/contrib/test_decoding/output_iso/results/invalidation_distribution.out
--- /home/buildfarm/trilobite/buildroot/REL_13_STABLE/pgsql.build/contrib/test_decoding/expected/invalidation_distribution.out    2025-06-17 10:24:24.382768613 +0200
+++ /home/buildfarm/trilobite/buildroot/REL_13_STABLE/pgsql.build/contrib/test_decoding/output_iso/results/invalidation_distribution.out    2025-06-17 15:01:53.921913314 +0200
@@ -31,7 +31,7 @@
 step s2_get_binary_changes: SELECT count(data) FROM pg_logical_slot_get_binary_changes('isolation_slot', NULL, NULL, 'proto_version', '1', 'publication_names', 'pub') WHERE get_byte(data, 0) = 73;
 count
 -----
-    0
+    1
 (1 row)
 
 ?column?

I could reproduce this locally and also checked that the test passes on
REL_14_STABLE and master.

Could you look at this, please?

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=trilobite&dt=2025-06-17%2008%3A24%3A00

Best regards,
Alexander
--------------x0YWfs023zI0eBIvGE0TaUkk--