Message-ID: <5ADC176B.3080304@yandex.ru>
Date: Sun, 22 Apr 2018 10:02:35 +0500
From: =?UTF-8?B?0KHQtdGA0LPQtdC5?= <gtm7@yandex.ru>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
To: pgsql-bugs@postgresql.org
Subject: postgres 10.3 no response
References: <5ADC0F59.5000902@yandex.ru>
In-Reply-To: <5ADC0F59.5000902@yandex.ru>
Content-Type: multipart/mixed;
 boundary="------------010004060100060106090800"
Precedence: bulk

This is a multi-part message in MIME format.
--------------010004060100060106090800
Content-Type: multipart/alternative;
 boundary="------------090906090008030500010802"


--------------090906090008030500010802
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit


Hello!

In versions 10.1 and 10.3, an error was detected.

When performing parallel loading of data into a partitioned table (300 
partitions), the PostgreSQL DBMS enters the "no response" state. No new 
connections are possible.

All processes are waiting for the release of the semaphore.

OS version
Linux asu-oko-test 3.0.101-77-ppc64 #1 SMP Tue Jun 14 20:33:58 UTC 2016 
(a082ea6) ppc64 ppc64 ppc64 GNU/Linux

Postgresql version
PostgreSQL 10.3 on powerpc64-unknown-linux-gnu, compiled by gcc-5 (SUSE 
Linux) 5.3.1 20160301 [gcc-5-branch revision 233849], 64-bit

Test case in the attachment


--------------090906090008030500010802
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <br>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    Hello!<br>
    <br>
    In versions 10.1 and 10.3, an error was detected.<br>
    <br>
    When performing parallel loading of data into a partitioned table
    (300 partitions), the PostgreSQL DBMS enters the "no response"
    state. No new connections are possible.<br>
    <br>
    All processes are waiting for the release of the semaphore.<br>
    <br>
    OS version<br>
    Linux asu-oko-test 3.0.101-77-ppc64 #1 SMP Tue Jun 14 20:33:58 UTC
    2016 (a082ea6) ppc64 ppc64 ppc64 GNU/Linux<br>
    <br>
    Postgresql version<br>
    <font face="Calibri" size="2"><span style="font-size:11pt;">PostgreSQL

        10.3 on powerpc64-unknown-linux-gnu, compiled by gcc-5 (SUSE
        Linux) 5.3.1 20160301 [gcc-5-branch revision 233849], 64-bit</span></font><br>
    <br>
    Test case in the attachment<br>
    <br>
  </body>
</html>

--------------090906090008030500010802--

--------------010004060100060106090800
Content-Type: application/octet-stream;
 name="bug_test.tgz"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="bug_test.tgz"

H4sIAE8811oAA+xcbW8b15XO1yWg/3BDC4jYiNTceR+pDKrYiquNLXn1kjTIBipFjqSBSA7D
GVp2AwNN0ja7yKLFLvp1sVvsH0jTZGPHjfMXqH/U59x5pUbjGYljZ7fIGLHJmTPnnnvOc8/b
vczouDu2O77d8k5eeVGXhMtQVfqXG5qU/ldcqiG9whVZ13RZNQz9FYkrmqy/wqQXJlHqmnh+
Z8zYKyPX84/HtpdHV/T8/+l149WVQ2e4ctjxTmq1mv1g5I59du/2rfW99fbivXdvrRxOjg98
2/Nrg9OeM2aLwbNabXR80PX7zPPdUa02HrDmTvLshjN0/N4ha26wdze3uKxx1mz23W6nb7fH
k4Od/db61u5mdL/b7PoPRxefpJns771lXuSAe00z+7q4XQtehSDdEWut/KTVdYdHkXgrtVj4
psvqzRHjpiSZdUZA8Gte37ZHTKmNvA9BED5kzSNG74RL5cN+7Ye2W1XXzKxe0Bi0xvX89c+5
Fq9/Q4YvkLgqKdqP6/9lXAu1ZpPdFAhgI+Df8R13yPzOYd9eqN3c2Vjf22B762/e2WD+kjO8
z5yhz7a299jW/p07yz2f+c4AzqEzGLGh67PhpN9f7nX8DtE12L31nb3Nvc3tLfbme2xnfev2
BiMmjbWFGv2JRqYR3SPmn9jsaDLsRt/PxhBmeAxWrJPIZvcuSPfW/tZNMYZn+wf3+0vdg1BO
+9geL7PuQVrKZXwNxaPHDbazsbe/s7Ub3VioMVx3IOr+OqQd9UfHWBfB3fVdtri4ULu1cfPO
+s7GQu3NjdubW+LRoX3sDAMiZ+jZ8KBg5wYag5KERhrsfqc/sb1APpLDD4UhddCr9oOuPaIp
LtT+4ezEHrLJ0PlwYh/cd9x+oCRoKBwmvCajHhnOp7kz4tWmv17nDO+PbUhxvx2oozPssZ7f
DgZcm+Extv3JeMh4JMWwh0/hTUlYamPr1kJtcXEtsNm7JJr9wO5OhHUoNhwgSLRG/WWIIazn
sTOn34daWOBbegt/N/7y7+1Kme+FjVGQ/ymaoYX+X5FVOcj/NP6j/38ZF/K/iTcWOeDIHvdr
tYlnIxMaO11/Lfhy683NNfFhD050dfXnzo7tsQ/Plo5tn9yqe9TrPGT+/QPyoGP4uAbeGzxk
i2DbXtzYeuej/d2NnUdr4t6t3S3WZnWwXL13vNo7HHYGdpsoGeWd7SARC0h7hycctCBtvoH0
bQjPskTvL7PXXgv++2h94rs33cHA8dtv8OWdjuPZG+OxO26/IS3fG0Oe6NujBlybO2Y9x2b1
mwEz8qdHHaePeILY0g5ke/Wfh/VQ/LvrvzjY+zlCzK21WupLm0uBfP4JXFvvYDgZBN9HI6fX
hpOsOUds6WfrO7ffYe02443aRxg7xQBzEk/flz5Yqz2Kh9rdEEGsrUgh/9O12o3QfSZutXbk
jpfoqdPma4vOT9Ov4vvrr2M4Vls8beMzh9ykxOYbPXepPhPKN98SMXzjF5u7e7vMP1h0UqF6
+y0ErpvbW7t7O+ubW3tsdHoQUOxs3l3feY+9vfGeiOLLCCgN1mBvbe+wd9bv7G/ssrd2tu+y
pUWnwfa28e9pY63eiPS+SEZftcdjgIsmHsnmeJF1CTiXTjA0QzK/RPeYaGiv7onT77Xx+ikx
IiOEt9pSgwkjjAgSrM7YLiX6TDxlgdUYMpfBoT1mAWdwFUBgTFQDS7xBn/sdD2viEbP7HrGf
DHv2UThug31Uo0mmBiFJRE40ngwFM/GiDcKAhHTwqBYIKrADMYjNDYKjPfTxgXwz6/Sd+0jN
Qu+DyuPGGUa02ZJQE6qY9lnH8RuvtpvAmngEcSEtzfjGHnHAByIdt3+JZN/xaIIP48rml2ux
ZhbH8YyZRh9vhJO5mWiKqqYekrBWsFAeUcnokFZqN5rPvYqeh+YI9F+rRS7gCh5Ams8DwBPB
f3kzjiCc/54QKr3kWShPoIYbJGnzjZQ0j1g7XH7B6qP0rDMa9Z2uSOQOhN97LeTbd2eZv5a3
aGqh5TnhJBqV2ItMlL27vfN23qukTlHfHpDPhlbfZzP++4OApDv02/A/wC4T8DrFt8XTnxqI
0vhXLL+ZWfWhgyjvTs1guYtS/fQgzrqXGqurSQoura5G6XeufyBJXn898hOhC9u+e3dz77nT
pASW5EYSmz/RmKjfGXkwfjsdvZZSalqO+ZBrild2eF2CCmHJemuJQ18/WYoGWKHJNBqtOht4
K2O7y+K180MHf1w7kH1gt/wH/osbo6D+V3Qpqv/xUdMo/0Mi+GP+9zKuBcQZe3jcd7wTBLjh
8aRzbFOdJ6o8ZIRwBQMq88hD9vt2X2CcbqBAjypp97L6fFnU8/cCre3+0x348bu7GIqcrHhU
H7qoPb0R8hpbNN98u8W2XDa0zyL3KnIeREMKf54Dpi0SbVMUwqzj+53uyQAcg6FEtOx2EGIH
nVM7GGM0dvHWQLy2PkaIQSgFbx8veasLtVHS/MaCbkbpVifgRdM7JH5OMOBMOxTOB0vZd8cP
F2ozPbSIDenoErWISryT9DnI1UaNDhoQoqZKskQqeh6ngcQjskNiBGtGbcR4MkpTgTVxdSd+
6MGa9ILnQijcG+E2bOp1x87I94SefYhMmlSaXGNAwcQntbrkUDPavRdAJWjiuP2+eyYk9u0R
KXqhtvHAH3e6wXud0BJHFM0ihbb8418RGfUVwDqxTHIzrRhSASU+Yp7EFNHFA3ZnYRX0mejP
DeRhwFBnGKOcLYlecWOhNv2v819PH7Ppl+efT7+fPps+nX43/Rr/Paab30+/wNMvcPMpbj49
/zc8eDZ9wqbf4OZfzn99/ik+fUuUX+HGd9Pvzj8//y14sfOPQf/t+e/A5hkxA5dn0y9Dmk/P
f8/OP8GXP4Pt4/PfnX/Kpn+a/s/036d/TK8Zkum3eO0r0HwSMn12/jHefHb+ByHh17MTbrHp
f5Is34L1t+KxEJdm9rV4GTKBWTTB8z8w8fFLPPhm+lf8/b80AWHR6X9Mn2FIyEd3I31g6K8D
AQTTJ8T0KabzGQZ8QjqAjqCx35//K8hx43sx7T8L5f31/NOA85/ElL6G8oiKhoWcUDPm+phU
dGFpNgPJvwk1TLNKixGYgzQHBdHMhWJJ7L+AcmbVZtdqlvNzzCZGmjHb54x08huA4LvwJQGE
p6RYAsj3oPr4AjguLPHny/CEBriAtS8yWLMYE8j9Ck+fQvmfhfZ6MiNMHlpTjqFJCsS8hUgC
7MLIwtak6K9Itm9pucCyQvvCoH8MBhGLR4AhRtes/T+ncQMAfyFA/BkpNXAwwMFjsTI+CeGX
Wo2Pyd4CaoRfWj0CObj1LzSv6WPhY6b/Da4f04qFiJ9On4iXUrgK5nL+G4Lq9OkFz3PJeDNO
6JLnaSuSSmmdPBaKfRLJ+4wmD1kjfWS80w8d/0PDv9Axnp//abpuqFH+pyqSgfxPNviP+z8v
5Yqm9bOON2m6p26TQL2y/fb2ys765i2NLbIJFaus2Vmo3UEK8IClCZnSklpc4k3DaI5GXV1l
NzjbvXuP7U1s9o+TIeMqk6VVRVnVTLa/dxNfuM6WOpIp2x29wYJ30n/f3tpfEePAVReKNrNA
gz3d1SQxY/WEOI4AdeZ4oi3TSfK7bh8gsMfplG7vJEhPPHZo993hsdjpcJFo4O34Pe8hXhvE
ex3uGWV5hw/ZxAOzeiR+vUXs8J64PZiIno7nErlIXHD3Ph4gmeoihRG+j0bPSBcNQ3vbTqfv
/AqDnTk+0naxLc7qqQ3wYEwwsY86k34qlbWHXVckhCcdpJHdrjumb/2HYIx8n9oUmGWd9tsv
svDtB1TqU+5GaeORczwZB7tSkWDR22GiVRdTuUXp6YjSre6J3T31JoMgo+85HqXDPUEUZ7iJ
7S4xHWu1Wsw9TZF7k8PoDQemip4HfQnBLxR+0HlwkE6OiRJF+mWk3gnE68GtHx1RpSIoZfPu
mzO0D7EmnG5Ii9RzQCI7gxGyYZQWgVroTWDAeZASeFZxAcAiqceT4ZBoDl3X95Asj8JcPCZI
V2PAVjMhjCGRjCz08HDYjUsEWAY6P40fosRb39na3Lq9ClDAFERY92E7LJHOhHYa/bBbJVJs
AbJ0gbFQe8+doN4awrDIqO1gbQD9di+oZrAeTw47wdELqkU8sYaAKFdscrLm+jLu044iDRcc
7hBpfXjjBHMMKrshQU+0cx5iSOiJBec7BHZ2J12xblgkztA9C45yiHeTxRosMyGGyBaoAorO
gdy6FG9NqnaPRZUiGNJbVHPQREgnIUtoVjyGZlvwb2ZTUpvcZNxYleRVbrYsS2Xvbby9x95X
FF2XPmB3tqF0hpIbdagopYds8959lXV6PfgLj9UR/+BX4Vnry2JjJGjVLtSy3K0WgmUh9/2h
84B5bvcUK7S+4g9GKy2vde82KoxWsOWSw1rWUqx5xDrj/+BKvBMkjz1yaR2fXaIEwSdnFFW7
bAIXRwG4gs41tRu6tFM+i0bRlqZFKmwiDEL7zul9j8yRgVIxZvYcUJdFbU8M42HopUZ9Zjv9
OlfIitbC/4UL80nVoBw4JBCN3DN7TDG6ORmeYpENm32K083j4WQZphiMRCcdDuC4221qbGl3
f3eDiVDeYFpLARMK/pIicfa+IGkejjtDRJOxfd+h6TNZUUzV+mCZYYxDB8ttibOxe9agdVds
qFQ2Tga5uMmjqKqiXNzn4XmU6kVKOY9Su0ip5FHqFynVPErjIqWWR2lepNTzKK2LlEYOpSpd
pDTzKPlFSmuhRu5lNVws4UINI1+yVsPWOY+3UeJbcvaWkr2lZ28Z2Vtq9paWvWVlb5mpW2Wm
UxXNxa0FOdhQkFuKrim6aWoGV2VTD7cRsvR6RK9xqq9AS28oufRGRK8rsmHoPHwhl16J6XVT
16yY7jpz4xEvS1YMqXhuakxvKFwyjFDYXHozpjdRe+rBzGQrl14L6FHPGKpkFNNbET3nlsqt
jO5eOCZkFVbgGRtfh2dsV02RLVRzRTiIcWZIimZZZXUlt1RNNk1JC41XDX4MS1MUXogHI7aX
xA1DK4sH8IeSFa0sPoEfy5IkIzPHHHySPFq8tOfUSeIvZFmy1GvxnAM/mIvCTV0t1K0e08uW
ovPy+DEsbqp6JbqK7WshiCpKob14ao7c0gvxYKTosawK5xjbjoNckUv4QZQVhnotv5OLRcnS
DdPKzO2F+zLJMkmtVcwl9suSTmYq9AsJdrlmGFZhzEywyxXdksr7EUtRNfUKOJOs2FGWiOGg
NxEXi313jB/TQtRVKokfZioWWtr1fNlc+NERhNTiGBDbQjFM+JFr4TxXn8gapBhu+fpP8Kko
yBuugE/JMJXivCTBpySrplzJmkpyNdUyDbOEz5MlTSr262aKXjezecS8MRC8MvqdK1YoCBRm
Nr7NpVNuoCIuXudJ7m1q1iXrNgeXwJmsy1wvpE9wSUV6cX4U1w6armiycZWYr1+WI7woH5Fg
TEEY1qrAFnjpXLeUwhxAS+jhGrRKsJjgQMUfrdCuMc6wcE0rG9tz7arKuq4X0yfxBPowi/Oi
pHbQdVW6Xq6Ri12ua9wozrXi2tBA7SZVY5fY72gAxyX143V4xraQZWR7ZvkaliO2SNfL/3Pw
RutWNXSlML4lebIMQBTmUbAB/DTt9xbEwSTv1WSFy5XMLVXDG5I1n/1jW6H+0+TidZD4JRTF
Snb+8/knE9lINb2BBFMG8o9snyMfL0iHFKlQDwleNITW4hwujmvIhzTpen2XHCySzIohS4Uy
pHs/Fs/Sz4Uf3eDQc/n+gaTCMGY1vss0kStUg8UEN3BGSjV+PsGWinyxRC+G8h5ulMegTK2k
Yt3HeFFQSCjzYS/VlzKQeZXvOyoaKtZsjj1XjqQgo5CLa2A5kYE6ENfyM3NhSpUUCaG+tC9S
uILavsp6j3jKnF/Bv8nAlVHs32JsyYZpqcV5e4wfWVKteOlW1EMR27562V47ZDB1TZOriWGK
IcnG9XzrXNjSJDWZcglsIXxbSrbOzseNieTFLJ9HoYiHZ6hkncfYUnVJl4p7Y0Yig4JqoNqc
S0PBL5XIj1QNombX2VzYQuKAKuGl7dkkfku2kGqWrfUhp2EahlYCI6Ay5PI9AeCJa6X3E8Ff
kSWrGhvEmNJUVdXmq8cTLHELrqJ8zo26Vq8MS5y2zKrck4CPsHRDy/r+OfpMFH+4bBXvmyYx
U6d0vDymZDhC/SrxTUeuVc3+RYwpRUMpWdyTtxKdmIZUVe8bC0otrtGTGk3jhvXie+TJvjYS
+xL96aQut1Dtl6jHTV3VJLOsT6P6HZE9mzPm4xYlmcyr9D2QGYm+kY1nuTihfZVq9kiCfTuz
eJ8m2dugrbFqfG9sAwUata4X/3LwRfMysfzK1k5Er5v5oS1pXysqN6tp9yRbawYKrSu0uC1V
1fVsW3GukCVL3JCL27cxDCwUh0pxiE/aAhKVvlW2AGmbjZZ6lakozQs1ZHHJmbQTNNWyit1Y
0i40VemSdtx822CKaenFYSblbminr8oUlo5swY1mW9e5bke3dGSJZVtbdMxKV80sPudr2yDY
XlICz2ULOhdnVCNnghldRm5S6MqS0KohoS59bIras7BGcfsi8T9cjbPvao4IQQZLVuTisJ2U
9jR4iVAJOlO63rbrXOGHK7KlFh+7irEo6aqkXa91lYNFSlVk2LVQhiRllg1uFceAJGVWJMm6
wlE3svAlIfnF20JDQVSc4smJnHGDo1Q6Ro036wrHC8guatYuc/ky8hDzsUoyaFNGPlY4/QRm
mLykVNsRQhFrSFeAFiYvGaVPOcJNa1p6hy0XOtQi1SvpCtDJYhqzsCuQwFCmsxjXCtPzhUXL
sOTiXesYL7pmGiV2GJN0hUuamT3BOhdeJMOySpy6je2qq4qhZdP4XLyYqiLrxaejUqcsDV4R
bExL0fXsgZa5N2TV4mZKktXQjn/xZnsCCVSIvNJNNspaTazxarJ8k/qYxQV3sgmKQHpJ0Z8L
L8tQ9Us2ruY7DKtr9P+tLJ8xKxZXSkc9spmFsFdt5ipjTZbATYwzVF6mmd3gmQs3lsYNNZtZ
ztU00aAnozhjTtwTHRIpHc6CNW8V808d5jV0a765xbjRKTuppiqSE+yaBgrE0ocpJFXR9OwB
7FzcwD1baqVNKarsUXPlj52kEnRAopqKL/E3lqRqxYdbknCmcASJspk7dTlM6ZLD3/MdWlIs
WZ9vs5Wn5m+W+OFPEs8ooS6uHpNNT/FjtEoajqmUUo5hMGecTjCIQBqLWdiNohRTMo1i3CSV
POpDqeJUjGu6Hp1FrepHVaakmFKJSowjSJrFMS+xGZcNPVu65OAG5YBmWVpxGpjCpWG+xB/j
JYdlFZN2f4ryldQPpaxYyjI/HjEVhX7uVyFuAiyqxT8SjTGhmYjr2Rx2vkP6loQ07wp5rmrF
e5JlDvhacLtRo+A5dknwjAIQk3xZ3avkh5eaZujF3f2k3KEOQLHeEj/FVcyqWvzoCu25V9tB
47qhl/ihc4wfA0mbWewfUj8gRBguPtSe2qwzjBI/hkgdONTopyyV1mFUNcvZdTqXv9Is2t4v
2+GG3lTLkLNxcb6a0IIPrEZXSS7NNUvP//FkspuGYUvsnvB0nFOzhxVycWPS4eTsAav5diXo
rHFxlzS2MR3OLHEwLfUDSFO1qtlpjW2MMh4e/go7KVC0kv0fEcyFCVVDrp6tief8waFmXLI7
lmsL2fpbe2eSGzEQQtEr1VzUOvfI/Y8R8MKU1LbAMVKy+G/bWbRizPzpLpvVlh/RCTUX5Rei
83cLKmVOR39Cp705n9bmWWzMpS/HElbX/8nW4QtZ4BdR0dyXVl7WVyKFDqkvpn6/2pbtR7Yp
nUTuEL+r0xnOVB0Td/V9/Jy6/Vy3/g+nGvY4Q+1ShNqe2Mq534pZtNOJWiYu44P6xvyKB/Xz
NL+hXJPtZ7QvwSnZxfT15tkeOT2nN976VfLjVoJEe9pn5SSy2tsUW42+2JVGxFSJN2vWB6J/
fhZ5/a4+uH0GbDRlxNi1xptEqdgi4c3XiRjTfGc1fxq9OsTrZz5UBsmZkwi76Xu8yTFL6TqK
LaRpsUeU30anGAGY2kOjq77WrU1mUQLZOZbm/nWNmKXX4+hBdRy12EayaTiWULflRw6AoSJ+
OazBPjV47sJfUXaP/XOX0pJD3KPbKkVOM8X6CH4liWy/qwenxlwXM8Zbu+QS6ErQ+SrGTtHp
2vFqm+HNEtR310MfYxG589zjANCkmL6Z9osalxMOO+OvWWpMTXfaQWvP/A2J1sLuqWtfYOTU
Pn3Eu1UQTjLInidr/c6WHhTntXcpjfInMyY58GDH5NMmZh8cifw+aHDQT/FrLo//ZruIj0/k
k+8vx7nT//DbAQAAAAAAAAAAAAAAAAAAAAAAAAAA4O/5AWpfjz4AoAAA
--------------010004060100060106090800--