Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCcUs-0002pw-28 for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Jun 2023 08:50:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qCcUq-0000Gb-VD for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Jun 2023 08:50:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCR86-0006CM-0W for pgsql-bugs@lists.postgresql.org; Thu, 22 Jun 2023 20:42:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qCR82-003gLr-HH for pgsql-bugs@lists.postgresql.org; Thu, 22 Jun 2023 20:42:08 +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=W2IvWpmmP8HigRIouCLalf2rFDSida54/02hHmh7i3M=; b=af1ecAAmI0ORtvTCjB+H73u5X6 4OFmVwv+AnsRBeA/9gJEK+7ESGFU+1/ClZY/OupM9ykO2DPSKhfgYlQ1YsoSH039Ew38k0i3ihXkf qJaZjN1jln1paMuYSuGhsFQ8H7hO5trTEaTf1WHrblioVp2wD7feSu2u8NWDmcH4c16M3E22P+2lV GxIoDVzoEgx19Hdqz/2W8rn5JS+LUD644QbS++aeqS1x62dXR4+C3oDybGlsXqccX/o/iQ4Wq4+kC odihGHv5JKTTvvpwlIxIY2eKgiuwn5GV4kt5ql9yetNkoISsw0hG6sx1kVZezrLdygeDCKdQNhGX8 WcIhXN3w==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCR81-0001yz-UR for pgsql-bugs@lists.postgresql.org; Thu, 22 Jun 2023 20:42:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qCR7x-00Aroo-HA for pgsql-bugs@lists.postgresql.org; Thu, 22 Jun 2023 20:42:02 +0000 Content-Type: multipart/mixed; boundary="===============8941268280560154994==" MIME-Version: 1.0 Subject: BUG #17990: PSQL Process hangs in parallel mode To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ess.bee59@gmail.com Reply-To: ess.bee59@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 22 Jun 2023 20:41:41 +0000 Message-ID: <17990-9d1f9082303b62e2@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 --===============8941268280560154994== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk5MApMb2dnZWQgYnk6ICAgICAgICAgIGVzcyBiZWUKRW1haWwgYWRk cmVzczogICAgICBlc3MuYmVlNTlAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTQuOApP cGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dS0yMjA0LWphbW15LWFtZDY0LWJhc2UKRGVzY3JpcHRp b246ICAgICAgICAKCkRlYXIgcG9zdGdyZXNxbCB0ZWFtIQ0KDQpJIGFtIHVzaW5nIHBvc3RncmVz cWwvcG9zdGdpcyB0byBjYWxjdWxhdGUgKGJldHRlciAiZXN0aW1hdGUiKSBwc2V1ZG8tb3NtCnRh Z3MgdG8gZW5oYW5jZSB0aGUgcm91dGUtY2FsY3VsYXRpb24gaW4gdGhlICJCcm91dGVyIiBmb3Ig YmlrZXJzIC4NCkVhY2ggY29udGluZW50IGlzIGNhbGN1bGF0ZWQgaW4gYSBzZXBhcmF0ZSBkYXRh YmFzZSAoRXVyb3BlLCBub3J0aC1hbWVyaWNhLApldGMuLikNCg0KRm9yIHRoZSBwbGFuZXQgdGhl IHNlcXVlbnRpYWwgY2FsY3VsYXRpb24gY3VycmVudGx5IG5lZWQgMjYgaG91cnMuIE15IGdvYWwK aXMgbm93IHRvIHJlZHVjZSB0aGlzIGR1cmF0aW9uLg0KDQpVbmZvcnR1bmF0ZWx5IHRoZSAibG9u ZyIgU1FMwrRzIChqb2lucykgdXNlZCBhcmUgcnVubmluZyBhcyBtb25vLXByb2Nlc3MKKHRoZXkg YXJlIG9ubHkgMSBvciAyICUgb2YgdGhlIHRpbWUgcnVubmluZyBpbiAzIHBhcmFsbGVsIHByb2Nl c3NlcykuDQpUaGF0IGZvciBJIHRyaWVkIHRvIHN0YXJ0IDIgcGFyYWxsZWwgcHNxbCBwcm9jZXNz ZXMgIChFdXJvcGUgcGFyYWxsZWwgdG8gdGhlCnJlc3Qgb2YgdGhlIHBsYW5ldCkNCg0KVGhlIHBy b2JsZW06DQpCeSB0aGUgZmlyc3QgMiB0ZXN0cyBvbmUgb2YgdGhlIDIgcHNxbCBQcm9jZXNzIHdh cyAgImhhbmdpbmciIGhvdXJzIC8gbm90CmVuZGluZyBvbiBhIHNlbGVjdC9qb2luISAoZmlyc3Qg aGFuZyBhcHBlYXJzIGFmdGVyIDIgaG91cnMgb2YgcHJvY2Vzc2luZywKdGhlIHNlY29uZCBhZnRl ciA2IGhvdXJzKSANCk5vIG1lc3NhZ2UgYXQgYWxsIGluIHRoZSBwb3N0Z3Jlc3FsIG9yIExpbnV4 IGxvZ3MhDQpKdXN0IHRoZSBDUFUgbG9hZCBpbmRpY2F0ZWQgdGhhdCB0aGUgcHJvY2VzcyB3YXMg c3RpbGwgInJ1bm5pbmciLg0KQWxzbyBhZnRlciB0aGUgc3VjY2Vzc2Z1bCB0ZXJtaW5hdGlvbiBv ZiB0aGUgb3RoZXIgcHJvY2VzcywgdGhlIGhhbmdpbmcKcHJvY2VzcyByZW1haW5lZCBpbiB0aGF0 IHN0YXRlLg0KDQogIA0KTXkgY29uZmlndXJhdGlvbjoNCj09PiBQb3N0Z3JlU1FMIDE0LjggKFVi dW50dSAxNC44LTB1YnVudHUwLjIyLjA0LjEpIG9uIHg4Nl82NC1wYy1saW51eC1nbnUsCmNvbXBp bGVkIGJ5IGdjYyAoVWJ1bnR1IDExLjMuMC0xdWJ1bnR1MX4yMi4wNC4xKSAxMS4zLjAsIDY0LWJp dA0KPT0+IHBvc3RncmVzQFVidW50dS0yMjA0LWphbW15LWFtZDY0LWJhc2UNCg0KSXQgaXMgZGlm ZmljdWx0IHRvIGRvY3VtZW50IHRoZSBmdWxsIHNpdHVhdGlvbiwgaGVyZSBqdXN0IHRoZSBTUUwK ImhhbmdpbmciDQpTRUxFQ1QNCiAgICBtLm9zbV9pZCBsb3NtaWQsIG0uaGlnaHdheSBsaGlnaHdh eSwgcS5oaWdod2F5IGFzIHFoaWdod2F5LApxLm1heHNwZWVkX2NsYXNzLA0KICAgIGNhc2UgDQog ICAgd2hlbiBxLmhpZ2h3YXkgaW4gKCdtb3RvcndheScsICdtb3RvcndheV9saW5rJywndHJ1bmsn LCd0cnVua19saW5rJykgYW5kCnEubWF4c3BlZWRfY2xhc3MgPCAxLjEgdGhlbg0KICAgICAJc3Rf YXJlYShzdF9pbnRlcnNlY3Rpb24obS53YXksIFNUX1VuaW9uKCBxLndheSkpKSAgICAgIC8Kc3Rf YXJlYShtLndheSkNCiAgICB3aGVuIHEuaGlnaHdheSBpbiAoJ21vdG9yd2F5JywgJ21vdG9yd2F5 X2xpbmsnLCd0cnVuaycsJ3RydW5rX2xpbmsnKSAKdGhlbg0KICAgICAJc3RfYXJlYShzdF9pbnRl cnNlY3Rpb24obS53YXksIFNUX1VuaW9uKCBxLndheSkpKSAgIAkgLyAoMS41ICoKc3RfYXJlYSht LndheSkpDQoNCiAgICB3aGVuIHEuaGlnaHdheSBpbiAoJ3ByaW1hcnknLCdwcmltYXJ5X2xpbmsn KSAgICAgICAgICAgICAgICAgICAgICAgIGFuZApxLm1heHNwZWVkX2NsYXNzIDwgMi4xICB0aGVu DQoJc3RfYXJlYShzdF9pbnRlcnNlY3Rpb24obS53YXksIFNUX1VuaW9uKCBxLndheSkpKSAgICAJ LyAoMiAqCnN0X2FyZWEobS53YXkpKQ0KICAgIHdoZW4gcS5oaWdod2F5IGluICgncHJpbWFyeScs J3ByaW1hcnlfbGluaycpICAgICAgdGhlbg0KCXN0X2FyZWEoc3RfaW50ZXJzZWN0aW9uKG0ud2F5 LCBTVF9VbmlvbiggcS53YXkpKSkgICAgIC8gKDMgKgpzdF9hcmVhKG0ud2F5KSkNCg0KICAgIHdo ZW4gcS5oaWdod2F5IGluICgnc2Vjb25kYXJ5JykgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBhbmQKcS5tYXhzcGVlZF9jbGFzcyA8IDIuMSB0aGVuDQoJc3RfYXJlYShzdF9pbnRl cnNlY3Rpb24obS53YXksIFNUX1VuaW9uKCBxLndheSkpKSAgICAJLyAoMyAqCnN0X2FyZWEobS53 YXkpKQ0KICAgIHdoZW4gcS5oaWdod2F5IGluICgnc2Vjb25kYXJ5JykgdGhlbiANCglzdF9hcmVh KHN0X2ludGVyc2VjdGlvbihtLndheSwgU1RfVW5pb24oIHEud2F5KSkpICAgIAkvICg1ICoKc3Rf YXJlYShtLndheSkpDQogICAgZW5kDQphcyBub2lzZV9mYWN0b3INCmludG8gdGFibGUgbm9pc2Vf dG1wDQpGUk9NIG9zbV9saW5lX2J1Zl81MCBBUyBtDQpJTk5FUiBKT0lOIG9zbV9saW5lX2J1Zl81 MCBBUyBxIE9OIFNUX0ludGVyc2VjdHMobS53YXksIHEud2F5KSANCldIRVJFIG0uaGlnaHdheSBp cyBub3QgbnVsbA0KYW5kIHEuaGlnaHdheSBpbiAoJ21vdG9yd2F5JywKJ21vdG9yd2F5X2xpbmsn LCd0cnVuaycsJ3RydW5rX2xpbmsnLCdwcmltYXJ5JywncHJpbWFyeV9saW5rJywnc2Vjb25kYXJ5 JykNCkdST1VQIEJZIGxvc21pZCwgbGhpZ2h3YXksIG0ud2F5LCBxLmhpZ2h3YXksIHEubWF4c3Bl ZWRfY2xhc3MNCm9yZGVyIGJ5IG5vaXNlX2ZhY3RvciBkZXNjOw0KDQpNeSBxdWVzdGlvbnM6IChh cyBJIGNvdWxkIG5vdCBmaW5kIGEgY29ycmVzcG9uZGluZyBidWcgaW4gdGhlIHBnc3FsLWJ1Z3Mp DQpJcyBhIHNpbWlsYXIgaXNzdWUgYWxscmVhZHkga25vd24/DQpDYW4gYW55Ym9keSByZWNvbW1l bmQgYSBjaGFuZ2UgKHVwZGF0ZSwgcGF0Y2gsIGNvbmZpZ3VyYXRpb24gcGFyYW1ldGVyKT8NCldo YXQgY291bGQgSSBwcm92aWRlIGZvciBmdXJ0aGVyIGFuYWx5c2lzIChwZ19zdGF0X2FjdGl2aXR5 KSA/DQoNClJlZ2FyZHMgKGFuZCB0aGFuayBmb3IgdGhlIGZhbnRhc3RpYyBzb2Z0d2FyZSEpDQpF c3MgQmVlCgo= --===============8941268280560154994==--