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 1otrmk-0000RB-Ga for pgsql-bugs@arkaria.postgresql.org; Sat, 12 Nov 2022 14:47:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1otrll-0007D3-6f for pgsql-bugs@arkaria.postgresql.org; Sat, 12 Nov 2022 14:46:05 +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 1oteb7-0005BJ-Da for pgsql-bugs@lists.postgresql.org; Sat, 12 Nov 2022 00:42:13 +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 1oteb0-0002Wx-0Q for pgsql-bugs@lists.postgresql.org; Sat, 12 Nov 2022 00:42:12 +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=QR5plOAWP/I6Ew/tFEgiRcDv+MlUpjos31hTvF2Kw9E=; b=J2Xr9pLGENsr5j04naL6u6HHPC /1ezks7ho3mwEJDrWK2lzAwyzhHSR0GZ4YmUYqSRYLd2n2nnmXRde813cD3qcRMvGveBC84dIW6XK EbVnwW8p2b5/3o1tAOV1ccKB1ZYG8zqGgj3TTG7Roe16NpN+QROG8NqxYtgvAmfZ1dNMHzkfd+uQr MsJtxO+BSljRbXsJQJp6Ubvg5gVT5SjAZAzWnzVVlRF9Dr4y8MS2QPk4DQVvWvBmIB3P2cH7cPTfj MEQfh/paZl1WHEznAQqjyMdHd5jDq83kV4Jr1lnS4iUKvhNDDtXXp5i5djveH9/pLB0l1mXhg2pef BX/rTJwg==; 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 1oteaz-0007oR-98 for pgsql-bugs@lists.postgresql.org; Sat, 12 Nov 2022 00:42: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 1oteav-0032G9-Ad for pgsql-bugs@lists.postgresql.org; Sat, 12 Nov 2022 00:42:02 +0000 Content-Type: multipart/mixed; boundary="===============2759930052239467573==" MIME-Version: 1.0 Subject: BUG #17686: SELECT pg_advisory_lock(...) with low lock_timeout sometimes times out but the lock is acquired To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mike.adelson314@gmail.com Reply-To: mike.adelson314@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 12 Nov 2022 00:41:43 +0000 Message-ID: <17686-fb1fa3870138e394@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 --===============2759930052239467573== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzY4NgpMb2dnZWQgYnk6ICAgICAgICAgIE1pa2UgQWRlbHNvbgpFbWFp bCBhZGRyZXNzOiAgICAgIG1pa2UuYWRlbHNvbjMxNEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyAxMApEZXNjcmlwdGlvbjogICAg ICAgIAoKSSBhbSB0cnlpbmcgdG8gdXNlIHRoZSBwZ19hZHZpc29yeV9sb2NrIGZ1bmN0aW9uIGlu IGNvbWJpbmF0aW9uIHdpdGggc2V0dGluZwpsb2NrX3RpbWVvdXQgdG8gd2FpdCBvbiB0aGUgbG9j ayB3aXRoIGEgdGltZW91dC4NCg0KSGVyZSBpcyBteSBxdWVyeToNCmBgYA0KU0VUIExPQ0FMIHN0 YXRlbWVudF90aW1lb3V0ID0gMDsNClNFVCBMT0NBTCBsb2NrX3RpbWVvdXQgPSAyMDA7DQpTRUxF Q1QgcGdfY2F0YWxvZy5wZ19hZHZpc29yeV9sb2NrKDEyMzQ1KQ0KYGBgDQoNCkknbSBmaW5kaW5n IHRoYXQgd2l0aCByZWxhdGl2ZWx5IHNtYWxsIHZhbHVlcyBvZiBsb2NrX3RpbWVvdXQgYW5kIHdo ZW4gdGhlCnN5c3RlbSBpcyB1bmRlciBsb2FkIChlLmcuIDggY29ubmVjdGlvbnMgYWNxdWlyaW5n IGNvbmN1cnJlbnRseSksIEkgd2lsbAplbmNvdW50ZXIgYSBjYXNlIHdoZXJlIHRoZSBxdWVyeSBl eGl0cyB3aXRoIHN0YXRlIDU1UDAzIChsb2NrX25vdF9hdmFpbGFibGUpCmFuZCB5ZXQgdGhlIGxv Y2sgd2FzIGFjdHVhbGx5IGFjcXVpcmVkIChJIGNhbiB0ZWxsIGl0IGhhcyBiZWVuIGFjcXVpcmVk IGJ5CnF1ZXJ5aW5nIHBnX2xvY2tzIGFuZCBiZWNhdXNlIG90aGVyIGNvbm5lY3Rpb25zJyBjYWxs cyB0byBwZ19hZHZpc29yeV9sb2NrCmJsb2NrKS4NCg0KSGVyZSdzIGEgc3RhbmRhbG9uZSByZXBy byBhcHBsaWNhdGlvbiB3aGljaCByZWxpYWJseSByZWNyZWF0ZXMgdGhlIGJlaGF2aW9yCmZvciBt ZTogaHR0cHM6Ly9naXRodWIuY29tL1R6YWNoaTAwOS9kaXN0cmlidXRlZC1sb2Nrcy1pc3N1ZQ0K TW9yZSBkaXNjdXNzaW9uIGhlcmU6IGh0dHBzOi8vZ2l0aHViLmNvbS9tYWRlbHNvbi9EaXN0cmli dXRlZExvY2svaXNzdWVzLzE0NwoK --===============2759930052239467573==--