Content-Type: multipart/mixed; boundary="------------4tAyzL60bLYf50rTIRGTpJM0"
Message-ID: <53a0f263-bece-bc96-e016-1690628a9980@gmail.com>
Date: Tue, 9 Apr 2024 22:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: BUG #17821: Assertion failed in heap_update() due to heap pruning
Content-Language: en-US
To: Melanie Plageman <melanieplageman@gmail.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>, Andres Freund <andres@anarazel.de>,
 pgsql-bugs@lists.postgresql.org
References: <17821-dd8c334263399284@postgresql.org>
 <13d30799-0107-6502-c81c-39ff5f1e7eb0@gmail.com>
 <BEB9A06A-3B05-41DC-AEE4-AD3DC4AD67E5@anarazel.de>
 <25c3399b-58a3-d727-7f97-93394fd1afa9@gmail.com>
 <2a203fd8-e9c8-5f5d-40f8-707848905a1a@gmail.com>
 <CAAKRu_bWz0KhTKW3SzetvhZL3gpsnyekB2WFCn-MO4aCx=37=g@mail.gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: 
 <CAAKRu_bWz0KhTKW3SzetvhZL3gpsnyekB2WFCn-MO4aCx=37=g@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/53a0f263-bece-bc96-e016-1690628a9980%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------4tAyzL60bLYf50rTIRGTpJM0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi Melanie,

09.04.2024 20:41, Melanie Plageman wrote:
> Just to confirm, the original bug was filed against 15, but I see
> ad98fb142 was committed on master as well as backpatched. You are able
> to reproduce  your pg_subscription example on master? I tried your
> repro (including the modification to minfree) and wasn't able to
> reproduce on master on my machine. This could totally be my fault, but
> I just wanted to confirm you were able to repro on master.
>

Yes, I reproduced both cases on master (27074bce0).
Please look at the self-contained script that works for me:
.../repro-17821-SUBSCRIPTION.sh
...
CREATE ROLE
WARNING:  subscription was created, but is not connected
HINT:  To initiate replication, you must manually create the replication slot, enable the subscription, and refresh the 
subscription.
CREATE SUBSCRIPTION
iteration 1
iteration 2
iteration 3
TRAP: failed Assert("ItemIdIsNormal(lp)"), File: "heapam.c", Line: 3296, PID: 1069025
TRAP: failed Assert("ItemIdIsNormal(lp)"), File: "heapam.c", Line: 3296, PID: 1069621

Best regards,
Alexander
--------------4tAyzL60bLYf50rTIRGTpJM0
Content-Type: text/plain; charset=UTF-8;
 name="repro-17821-SUBSCRIPTION.sh.txt"
Content-Disposition: attachment; filename="repro-17821-SUBSCRIPTION.sh.txt"
Content-Transfer-Encoding: base64

c2VkICdzL21pbmZyZWUgPSBNYXgobWluZnJlZSwgQkxDS1NaIFwvIDEwKS9taW5mcmVlID0g
TWF4KG1pbmZyZWUsIEJMQ0tTWiBcLzEpLycgLWkgc3JjL2JhY2tlbmQvYWNjZXNzL2hlYXAv
cHJ1bmVoZWFwLmMKLi9jb25maWd1cmUgLS1lbmFibGUtZGVidWcgLS1lbmFibGUtY2Fzc2Vy
dCAtcSAmJiBtYWtlIC1qOCAtcyAmJiBURVNUUz10ZXN0X3NldHVwIG1ha2UgLXMgY2hlY2st
dGVzdHMKClBHUk9PVD1gcHdkYC90bXBfaW5zdGFsbC91c3IvbG9jYWwvcGdzcWwKZXhwb3J0
IFBHREFUQT1gcHdkYC90bXBkYgoKZXhwb3J0IFBBVEg9IiRQR1JPT1QvYmluOiRQQVRIIgpl
eHBvcnQgTERfTElCUkFSWV9QQVRIPSIkUEdST09UL2xpYiIKClsgLWYgIiRQR0RBVEEvcG9z
dG1hc3Rlci5waWQiIF0gJiYgcGdfY3RsIHN0b3AgLW0gaW1tZWRpYXRlCgpybSAqLmxvZwpy
bSAtcmYgIiRQR0RBVEEiOyBpbml0ZGIgPmluaXRkYi5sb2cgMj4mMQoKZXhwb3J0IFBHUE9S
VD0xNTQzMQplY2hvICIKZnN5bmM9b2ZmCnBvcnQ9JFBHUE9SVAoiID4+ICRQR0RBVEEvcG9z
dGdyZXNxbC5hdXRvLmNvbmYKCnVsaW1pdCAtYyB1bmxpbWl0ZWQKcGdfY3RsIC1sIHNlcnZl
ci5sb2cgc3RhcnQKY3JlYXRlZGIgcmVncmVzc2lvbgpleHBvcnQgUEdEQVRBQkFTRT1yZWdy
ZXNzaW9uCmV4cG9ydCBQR0hPU1Q9MTI3LjAuMC4xCgpyZXM9MAoKZWNobyAiCkNSRUFURSBS
T0xFIHN1IFNVUEVSVVNFUjsKQ1JFQVRFIFNVQlNDUklQVElPTiBzdWIgQ09OTkVDVElPTiAn
ZGJuYW1lPW5vbmV4aXN0aW5nJwogIFBVQkxJQ0FUSU9OIHB1YiBXSVRIIChjb25uZWN0ID0g
ZmFsc2UpOwoiIHwgcHNxbAoKZm9yICgoaT0xO2k8PTIwO2krKykpOyBkbwogIGVjaG8gIml0
ZXJhdGlvbiAkaSIKCiAgZm9yICgoaz0xO2s8PTEwMDtrKyspKTsgZG8KICAgIGZvciAoKGo9
MTtqPD0yMDA7aisrKSk7IGRvIGVjaG8gIgpBTFRFUiBTVUJTQ1JJUFRJT04gc3ViIFNFVCAo
c3luY2hyb25vdXNfY29tbWl0ID0gZmFsc2UpOwogICAgIjsgZG9uZSB8IHBzcWwgPi9kZXYv
bnVsbCAyPiYxICYKIAogICAgZm9yICgoaj0xO2o8PTIwMDtqKyspKTsgZG8gZWNobyAiCkFM
VEVSIFNVQlNDUklQVElPTiBzdWIgT1dORVIgVE8gc3U7CkFMVEVSIFNVQlNDUklQVElPTiBz
dWIgU0VUIChzbG90X25hbWUgPSBOT05FKTsKICAgICI7IGRvbmUgfCBwc3FsID4vZGV2L251
bGwgMj4mMSAmCiAgICB3YWl0CiAgZG9uZQoKZ3JlcCAnVFJBUDonIHNlcnZlci5sb2cgJiYg
YnJlYWs7CmRvbmUKCnBnX2N0bCAtdyAtdCA1IHN0b3AgfHwgcGdfY3RsIHN0b3AgLW0gaW1t
ZWRpYXRlCg==

--------------4tAyzL60bLYf50rTIRGTpJM0--