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 1vV1Pw-00C2g5-28 for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Dec 2025 05:46:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vV1Ov-00Ff4u-0f for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Dec 2025 05:45:41 +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.96) (envelope-from ) id 1vUxaI-00F1OL-2g for pgsql-bugs@lists.postgresql.org; Mon, 15 Dec 2025 01:41:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vUxaE-000mJj-1i for pgsql-bugs@lists.postgresql.org; Mon, 15 Dec 2025 01:41:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=CBZ78hazmrDi0+/OhBlmRux9h3E6OXRGWByrXhr93MM=; b=nzFcnZ6R//DdqX4XHsZpiJKlNT tPtHQ/aYDRvggDZcGIQJJyUOJYR8WttT6ehLQUm9EF4w7QlMgUVzV4uE+T8mE/Ewc9Cng7hEpW24a YL8kZ1exX+8dCQo5Mb5S0Ke+Chux926Y2obV+P2GHol3+NBkUvGH/k1fYI5xZ1hsKG90198/JEUhy 4HpGtpV6YxvPCR7KOIrn2VDgCgVwzKs0hAM3q3Gt6hr9A22UNGl4AcjAVctVGvrvwDiMptTAz1j3j ne2o9HgnnbGBjwp1usiBHv7tkyiT55cREfZaS7qw/cFoA+JgKsQ4UFvDxEAWP/mWmWdCudh47HJKn fmZCEA3Q==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vUxaD-0025hc-1q for pgsql-bugs@lists.postgresql.org; Mon, 15 Dec 2025 01:41:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vUxaA-003lqC-2T for pgsql-bugs@lists.postgresql.org; Mon, 15 Dec 2025 01:41:03 +0000 Content-Type: multipart/mixed; boundary="===============4201870283760462387==" MIME-Version: 1.0 Subject: BUG #19355: Attempt to insert data unexpectedly during concurrent update To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: wangbihua.cn@gmail.com Reply-To: wangbihua.cn@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 15 Dec 2025 01:40:55 +0000 Message-ID: <19355-57d7d52ea4980dc6@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4201870283760462387== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM1NQpMb2dnZWQgYnk6ICAgICAgICAgIEJpaHVhIFdhbmcKRW1haWwg YWRkcmVzczogICAgICB3YW5nYmlodWEuY25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTguMQpPcGVyYXRpbmcgc3lzdGVtOiAgIGxpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpTdGFy dCB0d28gdHJhbnNhY3Rpb24gYW5kIHVwZGF0ZSBvbiBzYW1lIHR1cGxlLCByYWlzZSBjb25jdXJy ZW50IHVwZGF0ZSBhbmQKZXZhbHBsYW5xdWFsLiAgSXQgd2lsbCBiZSBmb3VuZCBvdXQgdGhhdCB0 aGUgc2Vzc2lvbiB3aXRoIGV2YWxwbGFucXVhbCBkaWQKbm90IHN1Y2Nlc3NmdWxseSB1cGRhdGUg dGhlIGRhdGEsIGJ1dCBpbnN0ZWFkIGF0dGVtcHRlZCB0byBpbnNlcnQgYSByb3cgb2YKZGF0YSBp bmNvcnJlY3RseS4KCi0tIHBvc3RncmVzcWwgdmVyc2lvbgpwc3FsICgxOC4xKQpUeXBlICJoZWxw IiBmb3IgaGVscC4KCnBvc3RncmVzPSMgU0VMRUNUIHZlcnNpb24oKTsKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHZlcnNpb24KLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiBQb3N0Z3JlU1FMIDE4LjEgb24geDg2 XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDQuOC41CjIwMTUwNjIzIChF dWxlck9TIDQuOC41LTI4KSwgNjQtYml0CgotLSBwcmVwYXJlIHJlbGF0aW9uCmRyb3AgdGFibGUg dDEsdDIsdDM7CmNyZWF0ZSB0YWJsZSB0MShhIGludCBwcmltYXJ5IGtleSwgYiBpbnQpOwpjcmVh dGUgdGFibGUgdDIoYSBpbnQsIGIgaW50KTsKY3JlYXRlIHRhYmxlIHQzKGEgaW50LCBiIGludCk7 CgppbnNlcnQgaW50byB0MSB2YWx1ZXMoMSwwKSwoMiwwKTsKaW5zZXJ0IGludG8gdDIgdmFsdWVz KDEsMSksKDIsMik7Cmluc2VydCBpbnRvIHQzIHZhbHVlcygzLDMpOwotLSB0ZXN0IHNxbAptZXJn ZSAvKisgbmVzdGxvb3AodDMgdDEpKSAqLyBpbnRvIHQxIHVzaW5nCiAgICAgICAgKHNlbGVjdCB0 Mi5hIGFzIGEgZnJvbSB0MiBncm91cCBieSB0Mi5hKSBhcyB0MwogICAgICAgIG9uICh0MS5hID0g dDMuYSkKd2hlbiBtYXRjaGVkIHRoZW4KICAgICAgICB1cGRhdGUgc2V0IGIgPSB0MS5iICsgMQp3 aGVuIG5vdCBtYXRjaGVkIHRoZW4KICAgICAgICBpbnNlcnQgKGEsYikgdmFsdWVzICgxLDEpOwoK LS1tYWtlIHN1cmUgcGxhbiBsaWtlIHRoaXMsIG1heSBuZWVkIHRvIGV4ZWN1dGUgICJzZXQgZW5h YmxlX2hhc2hqb2luPW9mZiIKaWYgbmVjZXNzYXkKcG9zdGdyZXM9KiMgIGV4cGxhaW4gbWVyZ2Ug LyorIG5lc3Rsb29wKHQzIHQxKSkgKi8gaW50byB0MSB1c2luZwogICAgICAgIChzZWxlY3QgdDIu YSBhcyBhIGZyb20gdDIgZ3JvdXAgYnkgdDIuYSkgYXMgdDMKICAgICAgICBvbiAodDEuYSA9IHQz LmEpCndoZW4gbWF0Y2hlZCB0aGVuCiAgICAgICAgdXBkYXRlIHNldCBiID0gdDEuYiArIDEKd2hl biBub3QgbWF0Y2hlZCB0aGVuCiAgICAgICAgaW5zZXJ0IChhLGIpIHZhbHVlcyAoMSwxKTsKcG9z dGdyZXMtKiMgcG9zdGdyZXMtKiMgcG9zdGdyZXMtKiMgcG9zdGdyZXMtKiMgcG9zdGdyZXMtKiMg cG9zdGdyZXMtKiMKUVVFUlkgUExBTgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiBNZXJnZSBvbiB0 MSAgKGNvc3Q9MzguNDEuLjEyNC43NSByb3dzPTAgd2lkdGg9MCkKICAgLT4gIE5lc3RlZCBMb29w IExlZnQgSm9pbiAgKGNvc3Q9MzguNDEuLjEyNC43NSByb3dzPTIwMCB3aWR0aD0zNCkKICAgICAg ICAgLT4gIFN1YnF1ZXJ5IFNjYW4gb24gdDMgIChjb3N0PTM4LjI1Li40Mi4yNSByb3dzPTIwMCB3 aWR0aD0zMikKICAgICAgICAgICAgICAgLT4gIEhhc2hBZ2dyZWdhdGUgIChjb3N0PTM4LjI1Li40 MC4yNSByb3dzPTIwMCB3aWR0aD00KQogICAgICAgICAgICAgICAgICAgICBHcm91cCBLZXk6IHQy LmEKICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHQyICAoY29zdD0wLjAwLi4z Mi42MCByb3dzPTIyNjAKd2lkdGg9NCkKICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgdDFf cGtleSBvbiB0MSAgKGNvc3Q9MC4xNS4uMC40MSByb3dzPTEKd2lkdGg9MTApCiAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6IChhID0gdDMuYSkKKDggcm93cykKCgotLSBzZXNzaW9uIDE6CnBvc3Rn cmVzPSMgYmVnaW47CkJFR0lOCnBvc3RncmVzPSojICBleHBsYWluIG1lcmdlIC8qKyBuZXN0bG9v cCh0MyB0MSkpICovIGludG8gdDEgdXNpbmcKICAgICAgICAoc2VsZWN0IHQyLmEgYXMgYSBmcm9t IHQyIGdyb3VwIGJ5IHQyLmEpIGFzIHQzCiAgICAgICAgb24gKHQxLmEgPSB0My5hKQp3aGVuIG1h dGNoZWQgdGhlbgogICAgICAgIHVwZGF0ZSBzZXQgYiA9IHQxLmIgKyAxCndoZW4gbm90IG1hdGNo ZWQgdGhlbgogICAgICAgIGluc2VydCAoYSxiKSB2YWx1ZXMgKDEsMSk7CnBvc3RncmVzLSojIHBv c3RncmVzLSojIHBvc3RncmVzLSojIHBvc3RncmVzLSojIHBvc3RncmVzLSojIHBvc3RncmVzLSoj ClFVRVJZIFBMQU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogTWVyZ2Ugb24gdDEgIChjb3N0PTM4 LjQxLi4xMjQuNzUgcm93cz0wIHdpZHRoPTApCiAgIC0+ICBOZXN0ZWQgTG9vcCBMZWZ0IEpvaW4g IChjb3N0PTM4LjQxLi4xMjQuNzUgcm93cz0yMDAgd2lkdGg9MzQpCiAgICAgICAgIC0+ICBTdWJx dWVyeSBTY2FuIG9uIHQzICAoY29zdD0zOC4yNS4uNDIuMjUgcm93cz0yMDAgd2lkdGg9MzIpCiAg ICAgICAgICAgICAgIC0+ICBIYXNoQWdncmVnYXRlICAoY29zdD0zOC4yNS4uNDAuMjUgcm93cz0y MDAgd2lkdGg9NCkKICAgICAgICAgICAgICAgICAgICAgR3JvdXAgS2V5OiB0Mi5hCiAgICAgICAg ICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiB0MiAgKGNvc3Q9MC4wMC4uMzIuNjAgcm93cz0y MjYwCndpZHRoPTQpCiAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIHQxX3BrZXkgb24gdDEg IChjb3N0PTAuMTUuLjAuNDEgcm93cz0xCndpZHRoPTEwKQogICAgICAgICAgICAgICBJbmRleCBD b25kOiAoYSA9IHQzLmEpCig4IHJvd3MpCgpwb3N0Z3Jlcz0qIyBtZXJnZSAvKisgbmVzdGxvb3Ao dDMgdDEpKSAqLyBpbnRvIHQxIHVzaW5nCiAgICAgICAgKHNlbGVjdCB0Mi5hIGFzIGEgZnJvbSB0 MiBncm91cCBieSB0Mi5hKSBhcyB0MwogICAgICAgIG9uICh0MS5hID0gdDMuYSkKd2hlbiBtYXRj aGVkIHRoZW4KICAgICAgICB1cGRhdGUgc2V0IGIgPSB0MS5iICsgMQp3aGVuIG5vdCBtYXRjaGVk IHRoZW4KICAgICAgICBpbnNlcnQgKGEsYikgdmFsdWVzICgxLDEpOwpwb3N0Z3Jlcy0qIyBwb3N0 Z3Jlcy0qIyBwb3N0Z3Jlcy0qIyBwb3N0Z3Jlcy0qIyBwb3N0Z3Jlcy0qIyBwb3N0Z3Jlcy0qIwpN RVJHRSAyCnBvc3RncmVzPSojIGVuZDsKQ09NTUlUCgotLSBzZXNzaW9uIDIKcG9zdGdyZXM9IyBi ZWdpbjsKQkVHSU4KcG9zdGdyZXM9KiMgZXhwbGFpbiBtZXJnZSAvKisgbmVzdGxvb3AodDMgdDEp KSAqLyBpbnRvIHQxIHVzaW5nCiAgICAgICAgKHNlbGVjdCB0Mi5hIGFzIGEgZnJvbSB0MiBncm91 cCBieSB0Mi5hKSBhcyB0MwogICAgICAgIG9uICh0MS5hID0gdDMuYSkKd2hlbiBtYXRjaGVkIHRo ZW4KICAgICAgICB1cGRhdGUgc2V0IGIgPSB0MS5iICsgMQp3aGVuIG5vdCBtYXRjaGVkIHRoZW4K ICAgICAgICBpbnNlcnQgKGEsYikgdmFsdWVzICgxLDEpOwpwb3N0Z3Jlcy0qIyBwb3N0Z3Jlcy0q IyBwb3N0Z3Jlcy0qIyBwb3N0Z3Jlcy0qIyBwb3N0Z3Jlcy0qIyBwb3N0Z3Jlcy0qIwpRVUVSWSBQ TEFOCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KIE1lcmdlIG9uIHQxICAoY29zdD0zOC40MS4uMTI0 Ljc1IHJvd3M9MCB3aWR0aD0wKQogICAtPiAgTmVzdGVkIExvb3AgTGVmdCBKb2luICAoY29zdD0z OC40MS4uMTI0Ljc1IHJvd3M9MjAwIHdpZHRoPTM0KQogICAgICAgICAtPiAgU3VicXVlcnkgU2Nh biBvbiB0MyAgKGNvc3Q9MzguMjUuLjQyLjI1IHJvd3M9MjAwIHdpZHRoPTMyKQogICAgICAgICAg ICAgICAtPiAgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9MzguMjUuLjQwLjI1IHJvd3M9MjAwIHdpZHRo PTQpCiAgICAgICAgICAgICAgICAgICAgIEdyb3VwIEtleTogdDIuYQogICAgICAgICAgICAgICAg ICAgICAtPiAgU2VxIFNjYW4gb24gdDIgIChjb3N0PTAuMDAuLjMyLjYwIHJvd3M9MjI2MAp3aWR0 aD00KQogICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB0MV9wa2V5IG9uIHQxICAoY29zdD0w LjE1Li4wLjQxIHJvd3M9MQp3aWR0aD0xMCkKICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGEg PSB0My5hKQooOCByb3dzKQoKcG9zdGdyZXM9KiMgbWVyZ2UgLyorIG5lc3Rsb29wKHQzIHQxKSkg Ki8gaW50byB0MSB1c2luZwogICAgICAgIChzZWxlY3QgdDIuYSBhcyBhIGZyb20gdDIgZ3JvdXAg YnkgdDIuYSkgYXMgdDMKICAgICAgICBvbiAodDEuYSA9IHQzLmEpCndoZW4gbWF0Y2hlZCB0aGVu CiAgICAgICAgdXBkYXRlIHNldCBiID0gdDEuYiArIDEKd2hlbiBub3QgbWF0Y2hlZCB0aGVuCiAg ICAgICAgaW5zZXJ0IChhLGIpIHZhbHVlcyAoMSwxKTsKcG9zdGdyZXMtKiMgcG9zdGdyZXMtKiMg cG9zdGdyZXMtKiMgcG9zdGdyZXMtKiMgcG9zdGdyZXMtKiMgcG9zdGdyZXMtKiMKRVJST1I6ICBk dXBsaWNhdGUga2V5IHZhbHVlIHZpb2xhdGVzIHVuaXF1ZSBjb25zdHJhaW50ICJ0MV9wa2V5IgpE RVRBSUw6ICBLZXkgKGEpPSgxKSBhbHJlYWR5IGV4aXN0cy4KCg== --===============4201870283760462387==--