Content-Type: multipart/mixed; boundary="------------ohRjWCAeoKpDDoZo9r9hlqwL"
Message-ID: <7d763a6d-fad7-49b6-beb0-86f99ce4a6eb@postgrespro.ru>
Date: Tue, 12 Mar 2024 13:44:01 +0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: BUG #18349: ERROR: invalid DSA memory alloc request size
 1811939328, CONTEXT: parallel worker
To: Alexey Ermakov <alexey.ermakov@dataegret.com>,
 Tomas Vondra <tomas.vondra@enterprisedb.com>, pgsql-bugs@lists.postgresql.org
References: <18349-83d33dd3d0c855c3@postgresql.org>
 <512ef568-336e-4087-ba23-f22b006d329d@postgrespro.ru>
 <df93756b-e011-1b09-7bbb-18e6e1ec3ae2@dataegret.com>
 <df297e10-d50f-497d-b278-86a6bce1c44e@enterprisedb.com>
 <7a1f5e5b-632f-4cc5-8078-b18a848e8924@postgrespro.ru>
 <2ff6260b-8722-b301-cf7e-4e66a159778c@dataegret.com>
 <90092199-55cd-4fa3-a608-9a41d8e76c44@postgrespro.ru>
 <a2f83556-5ef0-ddca-c63d-bbcbf5054335@dataegret.com>
Content-Language: en-US
From: Andrei Lepikhov <a.lepikhov@postgrespro.ru>
Organization: Postgres Professional
In-Reply-To: <a2f83556-5ef0-ddca-c63d-bbcbf5054335@dataegret.com>
Archived-At: 
 <https://www.postgresql.org/message-id/7d763a6d-fad7-49b6-beb0-86f99ce4a6eb%40postgrespro.ru>
Precedence: bulk

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

On 11/3/2024 15:12, Alexey Ermakov wrote:
> Would you like to get any additional info from gdb (like number of 
> batches) ?

Can you try to reproduce the case with simple patch attached?

-- 
regards,
Andrei Lepikhov
Postgres Professional

--------------ohRjWCAeoKpDDoZo9r9hlqwL
Content-Type: text/plain; charset=UTF-8;
 name="0001-Strictly-limit-max-size-of-batches-in-Parallel-Hash-.patch"
Content-Disposition: attachment;
 filename*0="0001-Strictly-limit-max-size-of-batches-in-Parallel-Hash-.pa";
 filename*1="tch"
Content-Transfer-Encoding: base64

RnJvbSAwMmQ3NDM2MWMyOGE5MzAxMzU1NDlhZDY3OWI3YmFhMDYxZDZhOTBiIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiAiQW5kcmV5IFYuIExlcGlraG92IiA8YS5sZXBpa2hv
dkBwb3N0Z3Jlc3Byby5ydT4KRGF0ZTogVHVlLCAxMiBNYXIgMjAyNCAxMzozOToyOSArMDcw
MApTdWJqZWN0OiBbUEFUQ0hdIFN0cmljdGx5IGxpbWl0IG1heCBzaXplIG9mIGJhdGNoZXMg
aW4gUGFyYWxsZWwgSGFzaCBKb2luIGJ5CiBEU0EgbGltaXRzLgoKQmVjYXVzZSBiYXRjaCBk
ZXNjcmlwdG9ycyBhbGxvY2F0ZXMgaW4gdGhlIERTQSBhcmVhIHdlIG11c3QgbGltaXQgdGhl
aXIgbnVtYmVyCmJ5IHRoZSBsaW1pdGF0aW9ucyBvZiBtYXhpbXVtIHNpemUgb2YgRFNBIGFy
ZWEgdGhhdCBjYW4gYmUgYWxsb2NhdGVkLgotLS0KIHNyYy9iYWNrZW5kL2V4ZWN1dG9yL25v
ZGVIYXNoLmMgfCA1ICsrKystCiAxIGZpbGUgY2hhbmdlZCwgNCBpbnNlcnRpb25zKCspLCAx
IGRlbGV0aW9uKC0pCgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZUhh
c2guYyBiL3NyYy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVIYXNoLmMKaW5kZXggNjE0ODA3MzNh
MS4uZDk1NzAwYTRmNyAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZUhh
c2guYworKysgYi9zcmMvYmFja2VuZC9leGVjdXRvci9ub2RlSGFzaC5jCkBAIC0xMTQ1LDYg
KzExNDUsNyBAQCBFeGVjUGFyYWxsZWxIYXNoSW5jcmVhc2VOdW1CYXRjaGVzKEhhc2hKb2lu
VGFibGUgaGFzaHRhYmxlKQogCiAJCQkJLyogQWxsb2NhdGUgbmV3IGxhcmdlciBnZW5lcmF0
aW9uIG9mIGJhdGNoZXMuICovCiAJCQkJQXNzZXJ0KGhhc2h0YWJsZS0+bmJhdGNoID09IHBz
dGF0ZS0+bmJhdGNoKTsKKwogCQkJCUV4ZWNQYXJhbGxlbEhhc2hKb2luU2V0VXBCYXRjaGVz
KGhhc2h0YWJsZSwgbmV3X25iYXRjaCk7CiAJCQkJQXNzZXJ0KGhhc2h0YWJsZS0+bmJhdGNo
ID09IHBzdGF0ZS0+bmJhdGNoKTsKIApAQCAtMTI0Niw2ICsxMjQ3LDggQEAgRXhlY1BhcmFs
bGVsSGFzaEluY3JlYXNlTnVtQmF0Y2hlcyhIYXNoSm9pblRhYmxlIGhhc2h0YWJsZSkKIAkJ
CXsKIAkJCQlib29sCQlzcGFjZV9leGhhdXN0ZWQgPSBmYWxzZTsKIAkJCQlib29sCQlleHRy
ZW1lX3NrZXdfZGV0ZWN0ZWQgPSBmYWxzZTsKKwkJCQlpbnQJCQltYXhfYmF0Y2hlcyA9IChp
bnQpIHBnX3ByZXZwb3dlcjJfMzIoKHVpbnQzMikKKwkJCQkJKE1heEFsbG9jU2l6ZSAvIEVz
dGltYXRlUGFyYWxsZWxIYXNoSm9pbkJhdGNoKGhhc2h0YWJsZSkpKTsKIAogCQkJCS8qIE1h
a2Ugc3VyZSB0aGF0IHdlIGhhdmUgdGhlIGN1cnJlbnQgZGltZW5zaW9ucyBhbmQgYnVja2V0
cy4gKi8KIAkJCQlFeGVjUGFyYWxsZWxIYXNoRW5zdXJlQmF0Y2hBY2Nlc3NvcnMoaGFzaHRh
YmxlKTsKQEAgLTEyNzYsNyArMTI3OSw3IEBAIEV4ZWNQYXJhbGxlbEhhc2hJbmNyZWFzZU51
bUJhdGNoZXMoSGFzaEpvaW5UYWJsZSBoYXNodGFibGUpCiAJCQkJfQogCiAJCQkJLyogRG9u
J3Qga2VlcCBncm93aW5nIGlmIGl0J3Mgbm90IGhlbHBpbmcgb3Igd2UnZCBvdmVyZmxvdy4g
Ki8KLQkJCQlpZiAoZXh0cmVtZV9za2V3X2RldGVjdGVkIHx8IGhhc2h0YWJsZS0+bmJhdGNo
ID49IElOVF9NQVggLyAyKQorCQkJCWlmIChleHRyZW1lX3NrZXdfZGV0ZWN0ZWQgfHwgaGFz
aHRhYmxlLT5uYmF0Y2ggPj0gbWF4X2JhdGNoZXMpCiAJCQkJCXBzdGF0ZS0+Z3Jvd3RoID0g
UEhKX0dST1dUSF9ESVNBQkxFRDsKIAkJCQllbHNlIGlmIChzcGFjZV9leGhhdXN0ZWQpCiAJ
CQkJCXBzdGF0ZS0+Z3Jvd3RoID0gUEhKX0dST1dUSF9ORUVEX01PUkVfQkFUQ0hFUzsKLS0g
CjIuNDQuMAoK

--------------ohRjWCAeoKpDDoZo9r9hlqwL--