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 1rMXyM-0058uZ-KI for pgsql-bugs@arkaria.postgresql.org; Sun, 07 Jan 2024 18:34:11 +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 1rMXyK-00HAZw-4Z for pgsql-bugs@arkaria.postgresql.org; Sun, 07 Jan 2024 18:34:08 +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 1rMXyJ-00HAZn-NS for pgsql-bugs@lists.postgresql.org; Sun, 07 Jan 2024 18:34:07 +0000 Received: from forwardcorp1c.mail.yandex.net ([178.154.239.200]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rMXyD-000MOq-Rx for pgsql-bugs@postgresql.org; Sun, 07 Jan 2024 18:34:05 +0000 Received: from mail-nwsmtp-smtp-corp-main-26.myt.yp-c.yandex.net (mail-nwsmtp-smtp-corp-main-26.myt.yp-c.yandex.net [IPv6:2a02:6b8:c00:1918:0:640:433:0]) by forwardcorp1c.mail.yandex.net (Yandex) with ESMTPS id A3DDF6148D; Sun, 7 Jan 2024 21:33:57 +0300 (MSK) Received: from smtpclient.apple (unknown [2a02:6b8:b081:6516::1:38]) by mail-nwsmtp-smtp-corp-main-26.myt.yp-c.yandex.net (smtpcorp/Yandex) with ESMTPSA id uXksBFJIkSw0-pDGR9Hw5; Sun, 07 Jan 2024 21:33:57 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru; s=default; t=1704652437; bh=/esWP0ID2IHuDSdiA/swDc2bpnWbPN+OXA1/UDsaBG8=; h=Message-Id:To:Date:References:Cc:In-Reply-To:From:Subject; b=pp+azKTAmx/45EojbsCIFft5YxB6ZXM6OAWfybpy7RO3shpRgoG5PdVP7H/kR3rAV SqCWhwBYwI49R1laLSmwKyubZIC6gOsDYemxfpZ2KOzigsr+yH6rUyDURglgCMLK5i jBMJ7bTrfx0awzNl+BPdFpX3EvRLvxep1bxqTeNA= Authentication-Results: mail-nwsmtp-smtp-corp-main-26.myt.yp-c.yandex.net; dkim=pass header.i=@yandex-team.ru Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.4\)) Subject: Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum From: "Andrey M. Borodin" In-Reply-To: <0FDE2089-D306-4CBB-AD1F-EC4B419E3B33@yandex-team.ru> Date: Sun, 7 Jan 2024 23:33:56 +0500 Cc: pgsql-bugs@postgresql.org, y sokolov , Alexander Lakhin Content-Transfer-Encoding: quoted-printable Message-Id: <2570ACF2-F1B8-49F2-BA06-7AF9F807BDA6@yandex-team.ru> References: <7bdbe559-d61a-4ae4-a6e1-48abdf3024cc@postgrespro.ru> <0FDE2089-D306-4CBB-AD1F-EC4B419E3B33@yandex-team.ru> To: Michael Zhilin X-Mailer: Apple Mail (2.3696.120.41.1.4) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 7 Jan 2024, at 23:04, Andrey M. Borodin = wrote: >=20 > I see that using a temp file in PG_ABS_SRCDIR is common approach. But = still I want to ask, maybe can we develop some clever way to reproduce = the bug without external file? BTW this stuff is causing problems in CFbot [0,1] COPY varlena_bug TO :'filename'; +ERROR: could not open file = "/tmp/cirrus-ci-build/contrib/amcheck/results/varlena_bug.dmp" for = writing: No such file or directory +HINT: COPY TO instructs the PostgreSQL server process to write a file. = You may want a client-side facility such as psql's \copy. Best regards, Andrey Borodin. [0] = https://api.cirrus-ci.com/v1/artifact/task/4880592609738752/testrun/build/= testrun/amcheck/regress/regression.diffs [1] https://github.com/x4m/postgres_g/runs/20240081462