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 1okKgP-0003Wh-29 for pgsql-bugs@arkaria.postgresql.org; Mon, 17 Oct 2022 07:37:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1okKgO-0006BG-1r for pgsql-bugs@arkaria.postgresql.org; Mon, 17 Oct 2022 07:37:08 +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 1okDIe-0005pi-Hl for pgsql-bugs@lists.postgresql.org; Sun, 16 Oct 2022 23:44:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1okDIc-00020O-BU for pgsql-bugs@lists.postgresql.org; Sun, 16 Oct 2022 23:44:07 +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=At95zsgBl+1DqI1UpUCumEB5M70jGfIUJHyNwInTeIo=; b=anv74/9NCtTMmGPlTi4FA+YbsI uGabPnzyu82hjlp4L3O96kCVFlEexhmq/dxKo6S9d4k+zjy6wyoV2pPefePluA7U3O9zxODlSnlu/ AhKjDQ6P/X088Wi6XX/Ibzvke/6mv4YTBzpQO4wBZtc7vyk+O7EkMEwAyA8c1kaEMOZFFe27FwrZW fL4jrPUbg9DbbVYWcRJjSgMY+0nUDi6q6UXd6yRnFOgkA8gtBeKDJ3VNncSpnn1/gQ+ljQZw8bAJy O6wspoCvZ7wFZrz0xupXVwYyCF8Y1duPBiNZ6hYBWeWcNWJyjQ5AkmNI9bsJDvrDog3GJrSuGMDhW uz99meww==; 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 1okDIZ-0005mX-JS for pgsql-bugs@lists.postgresql.org; Sun, 16 Oct 2022 23:44:05 +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 1okDIY-008LJR-97 for pgsql-bugs@lists.postgresql.org; Sun, 16 Oct 2022 23:44:02 +0000 Content-Type: multipart/mixed; boundary="===============7173834599540844447==" MIME-Version: 1.0 Subject: BUG #17645: Strange queries that stuck in database system To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: thien.phan@apollo.edu.vn Reply-To: thien.phan@apollo.edu.vn, pgsql-bugs@lists.postgresql.org Date: Sun, 16 Oct 2022 23:43:24 +0000 Message-ID: <17645-7cbc0f9bf94bb2a6@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 --===============7173834599540844447== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzY0NQpMb2dnZWQgYnk6ICAgICAgICAgIFRoaWVuLCBQaGFuIFBodW9j CkVtYWlsIGFkZHJlc3M6ICAgICAgdGhpZW4ucGhhbkBhcG9sbG8uZWR1LnZuClBvc3RncmVTUUwg dmVyc2lvbjogMTQuMApPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgU2VydmVyIDIwMTIgUjIK RGVzY3JpcHRpb246ICAgICAgICAKCkhpLA0KDQpXaGVuIEkgcnVuIHRoaXMgcXVlcnkNCg0KU0VM RUNUICBOT1coKSAtIHF1ZXJ5X3N0YXJ0IEFTIGVsYXBzZWQsIHBpZCwgY2xpZW50X2FkZHIsIHF1 ZXJ5LApxdWVyeV9zdGFydCwgKg0KRlJPTSBwZ19zdGF0X2FjdGl2aXR5DQpXSEVSRSBxdWVyeSAh PSAnPElETEU+JyAgQU5EIHF1ZXJ5IE5PVCBJTElLRSAnJXBnX3N0YXRfYWN0aXZpdHklJw0KT1JE RVIgQlkgcXVlcnlfc3RhcnQgREVTYzsNCg0KSSBub3RpY2VkIHRoYXQgdGhlcmUgYXJlIG1hbnkg cXVlcmllcyAoYXMgYmVsb3cpIHRoYXQgY3JlYXRlIG1hbnkgV2luZG93cwpwcm9jZXNzZXMgYW5k IENQVSBpcyAxMDAlLiBJcyBpdCBhIGJ1Zz8gUGxlYXNlIGhlbHAhDQpUaGFuayB5b3UgdmVyeSBt dWNoIQ0KVGhpZW4gUGhhbg0KDQotLSBMb2FkIGZpZWxkIGRlZmluaXRpb25zIGZvciAoZnJlZS1z dGFuZGluZykgY29tcG9zaXRlIHR5cGVzDQoNCglTRUxFQ1QgdHlwLm9pZCwgYXR0LmF0dG5hbWUs IGF0dC5hdHR0eXBpZA0KDQoJRlJPTSBwZ190eXBlIEFTIHR5cA0KDQoJSk9JTiBwZ19uYW1lc3Bh Y2UgQVMgbnMgT04gKG5zLm9pZCA9IHR5cC50eXBuYW1lc3BhY2UpDQoNCglKT0lOIHBnX2NsYXNz IEFTIGNscyBPTiAoY2xzLm9pZCA9IHR5cC50eXByZWxpZCkNCg0KCUpPSU4gcGdfYXR0cmlidXRl IEFTIGF0dCBPTiAoYXR0LmF0dHJlbGlkID0gdHlwLnR5cHJlbGlkKQ0KDQoJV0hFUkUNCg0KCSAg KHR5cC50eXB0eXBlID0gJ2MnIEFORCBjbHMucmVsa2luZD0nYycpIEFORA0KDQoJICBhdHRudW0g PiAwIEFORCAgICAgLS0gRG9uJ3QgbG9hZCBzeXN0ZW0gYXR0cmlidXRlcw0KDQoJICBOT1QgYXR0 aXNkcm9wcGVkDQoNCglPUkRFUiBCWSB0eXAub2lkLCBhdHQuYXR0bnVtDQoyMDIyLTEwLTE3IDAw OjAxOjIxLjExNyArMDcgW1t1bmtub3duXV1bNDgwMF1bYXBvbGxvX3BvcnRhbF0gRkFUQUw6IAp0 ZXJtaW5hdGluZyBjb25uZWN0aW9uIGR1ZSB0byBhZG1pbmlzdHJhdG9yIGNvbW1hbmQNCjIwMjIt MTAtMTcgMDA6MDE6MjEuMTE3ICswNyBbW3Vua25vd25dXVs0ODAwXVthcG9sbG9fcG9ydGFsXSBT VEFURU1FTlQ6ICAtLQpMb2FkIGZpZWxkIGRlZmluaXRpb25zIGZvciAoZnJlZS1zdGFuZGluZykg Y29tcG9zaXRlIHR5cGVzDQoNCglTRUxFQ1QgdHlwLm9pZCwgYXR0LmF0dG5hbWUsIGF0dC5hdHR0 eXBpZA0KDQoJRlJPTSBwZ190eXBlIEFTIHR5cA0KDQoJSk9JTiBwZ19uYW1lc3BhY2UgQVMgbnMg T04gKG5zLm9pZCA9IHR5cC50eXBuYW1lc3BhY2UpDQoNCglKT0lOIHBnX2NsYXNzIEFTIGNscyBP TiAoY2xzLm9pZCA9IHR5cC50eXByZWxpZCkNCg0KCUpPSU4gcGdfYXR0cmlidXRlIEFTIGF0dCBP TiAoYXR0LmF0dHJlbGlkID0gdHlwLnR5cHJlbGlkKQ0KDQoJV0hFUkUNCg0KCSAgKHR5cC50eXB0 eXBlID0gJ2MnIEFORCBjbHMucmVsa2luZD0nYycpIEFORA0KDQoJICBhdHRudW0gPiAwIEFORCAg ICAgLS0gRG9uJ3QgbG9hZCBzeXN0ZW0gYXR0cmlidXRlcw0KDQoJICBOT1QgYXR0aXNkcm9wcGVk DQoNCglPUkRFUiBCWSB0eXAub2lkLCBhdHQuYXR0bnVtDQoyMDIyLTEwLTE3IDAwOjAxOjIxLjEx OCArMDcgW1t1bmtub3duXV1bNjM0MF1bYXBvbGxvX3BvcnRhbF0gTE9HOiAgY291bGQgbm90CnNl bmQgZGF0YSB0byBjbGllbnQ6IEFuIGVzdGFibGlzaGVkIGNvbm5lY3Rpb24gd2FzIGFib3J0ZWQg YnkgdGhlIHNvZnR3YXJlCmluIHlvdXIgaG9zdCBtYWNoaW5lLg0KDQoJDQoyMDIyLTEwLTE3IDAw OjAxOjIxLjExOCArMDcgW1t1bmtub3duXV1bNjM0MF1bYXBvbGxvX3BvcnRhbF0gU1RBVEVNRU5U OiAgLS0KTG9hZCBmaWVsZCBkZWZpbml0aW9ucyBmb3IgKGZyZWUtc3RhbmRpbmcpIGNvbXBvc2l0 ZSB0eXBlcw0KDQoJU0VMRUNUIHR5cC5vaWQsIGF0dC5hdHRuYW1lLCBhdHQuYXR0dHlwaWQNCg0K CUZST00gcGdfdHlwZSBBUyB0eXANCg0KCUpPSU4gcGdfbmFtZXNwYWNlIEFTIG5zIE9OIChucy5v aWQgPSB0eXAudHlwbmFtZXNwYWNlKQ0KDQoJSk9JTiBwZ19jbGFzcyBBUyBjbHMgT04gKGNscy5v aWQgPSB0eXAudHlwcmVsaWQpDQoNCglKT0lOIHBnX2F0dHJpYnV0ZSBBUyBhdHQgT04gKGF0dC5h dHRyZWxpZCA9IHR5cC50eXByZWxpZCkNCg0KCVdIRVJFDQoNCgkgICh0eXAudHlwdHlwZSA9ICdj JyBBTkQgY2xzLnJlbGtpbmQ9J2MnKSBBTkQNCg0KCSAgYXR0bnVtID4gMCBBTkQgICAgIC0tIERv bid0IGxvYWQgc3lzdGVtIGF0dHJpYnV0ZXMNCg0KCSAgTk9UIGF0dGlzZHJvcHBlZA0KDQoJT1JE RVIgQlkgdHlwLm9pZCwgYXR0LmF0dG51bQoK --===============7173834599540844447==--