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 1pIrQy-0008SH-75 for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Jan 2023 13:27:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pIrQw-0002ak-7K for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Jan 2023 13:27:54 +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 1pIoc6-0005Ks-67 for pgsql-bugs@lists.postgresql.org; Fri, 20 Jan 2023 10:27:14 +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 1pIoby-0005z9-B6 for pgsql-bugs@lists.postgresql.org; Fri, 20 Jan 2023 10:27:13 +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=cuwgMYUv8oTKE7ntmsxcKIuBzgadALce5yxb5f6+kbY=; b=VYAKoQY4j32Wcub+YeDsEivlwS d3XF89La55JzRGPXriDc6szP8VybIBQwyj9SRQBPsUN/oCed3fb78f0SY+DVFSOjk4O8LyXGqZiQh YXoCoSWBETt+atLt4DP1XWK8BOVcq1djbOTnd/03xTMyGJNF6xplP4WpRcs3GiBXzJn0P1u/rajap cUUq1G3/xGspcAnSBHuw/jSFVHkP2Qvlk2qK6CHwVNRW8daaI6DVWqqc7dks7+41KCUHmn41nfkZ7 m+slRXmU6HVs1T5uHirOJPeqFOolkA+rf9xaJillwofHq1Wa5/yIQk8T+16ZQkT5Qcg9cmWsr057v aSJmVhTg==; 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 1pIobx-0005rt-Iq for pgsql-bugs@lists.postgresql.org; Fri, 20 Jan 2023 10:27: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 1pIobt-00H3B7-PL for pgsql-bugs@lists.postgresql.org; Fri, 20 Jan 2023 10:27:02 +0000 Content-Type: multipart/mixed; boundary="===============7779184923711581136==" MIME-Version: 1.0 Subject: BUG #17755: database queries get stuck for certain IDs To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: pavol.sekeres8@gmail.com Reply-To: pavol.sekeres8@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 20 Jan 2023 10:26:48 +0000 Message-ID: <17755-e7333e310e686ae4@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 --===============7779184923711581136== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc1NQpMb2dnZWQgYnk6ICAgICAgICAgIFBhdm9sIFNla2VyZXMKRW1h aWwgYWRkcmVzczogICAgICBwYXZvbC5zZWtlcmVzOEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiBVbnN1cHBvcnRlZC9Vbmtub3duCk9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudE9TIExpbnV4 IDcgKENvcmUpCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIZWxsbywNCg0Kd2UgYXJlIHVzaW5nIFBv c3RncmVTUUwgdmVyc2lvbiA5LjYuOCBvbiBvdXIgcHJvZHVjdGlvbiBlbnZpcm9ubWVudCB3aGlj aCB3ZQpvcGVyYXRlIG91cnNlbHZlcy4gV2UgYXJlIGZhY2luZyBpc3N1ZSB3aXRoIHRoZSBQb3N0 Z3JlU1FMIGRhdGFiYXNlLg0KV2hlbiB3ZSB1c2Ugc2VsZWN0L2luc2VydCBxdWVyeSBvbiBhIHNw ZWNpZmljIHRhYmxlIGl0IHJ1bnMgZmluZSA5OS45OSUgb2YKdGhlIHRpbWUuIEJ1dCB3ZSBhcmUg ZG9pbmcgbWFueSBpbnNlcnRzIHBlciBkYXkgZnJvbSBvdXIgYXBwIChhcm91bmQKMTAwLjAwMCkg YW5kIGl0IGhhcHBlbnMgdG8gdXMgYWxtb3N0IGV2ZXJ5IHdlZWsgdGhhdCBzb21lDQpxdWVyeSB0 byB0aGlzIHRhYmxlIGdldHMgc3R1Y2suIFRoZW4geW91IGNhbiBsaXN0IGl0IHVzaW5nIHBnX3N0 YXRfYWN0aXZpdHkKYW5kIHNlZSB0aGVyZSB0aGF0IGl0IGlzIHJ1bm5pbmcgbG9uZyhob3Vycywg ZGF5cywgZXZlbiB3ZWVrcykuIEZyb20gdGhpcwpwb2ludCB0aGUgb25seSBvcHRpb24gd2UgaGF2 ZSBpcyB0byBraWxsIHRoaXMgcHJvY2VzcyBpbiB3aGljaCB0aGUgcXVlcnkKcnVucy4NClVubGVz cyB3ZSBkbyB0aGlzLCB0aGUgZGF0YWJhc2UgZ2V0cyBidXN5IGJ5IHRoaXMgcHJvY2VzcyBpbmZp bml0ZWx5IHJ1bm5pbmcKcXVlcnkgYW5kIHRoZSBjcHUgdXNhZ2UgcmlzZXMgZHJhbWF0aWNhbGx5 IGNhdXNpbmcgZGF0YWJhc2UgZHJvcC1vdXRzLg0KVGhlIHByb2JsZW0gaXMganVzdCB3aXRoIHRo aXMgdGFibGUgYW5kIHdlIGFyZSB1c2luZyBtYW55IGluIG91ciBkYXRhYmFzZS4NClNvbWUgZnVy dGhlciBpbmZvcm1hdGlvbiBpczogdGhpcyBwcm9ibGVtYXRpYyB0YWJsZSBpcyBjYWxsZWQgcmVx dWVzdF9kYXRhcwphbmQgaGFzIGp1c3QgdHdvIGNvbHVtbnMgOiAxLiByZXF1ZXN0X2lkIC0gaXMg dW5saW1pdGVkIHZhcmNoYXIgY29udGFpbmluZwp0aGUgc3RyaW5nIHJlcHJlc2VudGF0aW9uIG9m IHV1aWQsIDIuIHJlcXVlc3RfZGF0YSAtIGlzIGFnYWluIHVubGltaXRlZAp2YXJjaGFyIGNvbnRh aW5pbmcgc3RyaW5nIHJlcHJlc2VudGF0aW9uIG9mIEpTT04gb2JqZWN0DQpXZSBub3RpY2VkIHRo YXQgdGhlIGluc2VydC9zZWxlY3QgcXVlcmllcyB3aGljaCBnZXQgc3R1Y2sgYW5kIHJ1biBpbmZp bml0ZWx5CmhhdmUgc3BlY2lmaWMgcmVxdWVzdF9pZCAtIHN0YXJ0aW5nIHdpdGggJ2E2YmRhJyBm b3IgZXhhbXBsZQonYTZiZGE3NDgtMGUzMS00ZGE2LThmZWQtMzMxYzZjNGE3Y2RiJy4NCkFsc28g d2UgYXJlIG5vdCBhbHdheXMgcXVlcnlpbmcgdGhlIGRhdGFiYXNlIGRpcmVjdGx5IGJ1dCB3ZSBh cmUgdXNpbmcgamF2YQphcHAgd2l0aCBKREJDIGNvbm5lY3Rpb25zLiBIb3dldmVyIHRoZSBzZWxl Y3QgcXVlcnkgZ2V0cyBzdHVjayBldmVuIHdoZW4KdHJpZ2dlcmVkIGZyb20gdGhlIHBzcWwgY29u c29sZS4NCg0KRnJvbSBvdXIgcG9pbnQgb2YgdmlldyB3ZSBhcmUgdXNpbmcgdGhlIGRhdGFiYXNl IG5vcm1hbGx5IGFuZCB0aGVyZSBpcyBubwpyZWFzb24gd2h5IHNpbXBsZSBzZWxlY3QgcXVlcnkg d2hlcmUgaWQgaXMgZXF1YWwgdG8gc29tZSB2YWx1ZSBzaG91bGQgZ2V0CnN0dWNrIGFuZCBydW4g aW5maW5pdGVseS4NCkRvIHlvdSBrbm93IHdoYXQgY291bGQgYmUgdGhlIGNhdXNlIGZvciBvdXIg cHJvYmxlbXMgYW5kIHBvc3NpYmx5IHN1Z2dlc3QKYW55IHNvbHV0aW9uPw0KDQpUaGFuayB5b3Us DQpCZXN0IHJlZ2FyZHMsDQpQYXZvbAoK --===============7779184923711581136==--