Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ip8k1-00077j-EF for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Jan 2020 10:39:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ip8k0-0003tM-8s for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Jan 2020 10:39:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ip8k0-0003tF-0y for pgsql-bugs@lists.postgresql.org; Wed, 08 Jan 2020 10:39:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ip8jx-0004Mp-4T for pgsql-bugs@lists.postgresql.org; Wed, 08 Jan 2020 10:39:07 +0000 Content-Type: multipart/mixed; boundary="===============5272329585624004017==" MIME-Version: 1.0 Subject: BUG #16197: pg_advisory_xact_lock error To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andy.ye@gtssz.net Reply-To: andy.ye@gtssz.net, pgsql-bugs@lists.postgresql.org Date: Wed, 08 Jan 2020 10:38:43 +0000 Message-ID: <16197-95f237f0ed016e22@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5272329585624004017== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE5NwpMb2dnZWQgYnk6ICAgICAgICAgIGFuZHkgeWUKRW1haWwgYWRk cmVzczogICAgICBhbmR5LnllQGd0c3N6Lm5ldApQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4xMgpP cGVyYXRpbmcgc3lzdGVtOiAgIHVidW50dSAxNi4wNApEZXNjcmlwdGlvbjogICAgICAgIAoKZXJy b3IgbG9nOg0KMjAyMC0wMS0wNyAwOTo0NToyMSBVVEM6MTcyLjIxLjEuMTI2KDQxODgyKTpkYWxh ZG1pbkBtb2JpbWUtcHJlOlsyMTYzNl06TE9HOgogc3RhdGVtZW50OiBCRUdJTg0KMjAyMC0wMS0w NyAwOTo0NToyMSBVVEM6MTcyLjIxLjEuMTI2KDQxODgyKTpkYWxhZG1pbkBtb2JpbWUtcHJlOlsy MTYzNl06TE9HOgogc3RhdGVtZW50OiBTRUxFQ1QgcGdfYWR2aXNvcnlfeGFjdF9sb2NrKDEwMDA2 LCA0OTg0MDgpOw0KMjAyMC0wMS0wNyAxNTo0MzoxNCBVVEM6MTcyLjIxLjEuMTI2KDQxODgyKTpk YWxhZG1pbkBtb2JpbWUtcHJlOlsyMTYzNl06TE9HOgogZHVyYXRpb246IDIxNDcyNDIzLjE5MyBt cw0KDQpIZWxsbzoNCkkgZm91bmQgdGhhdCB0aGUgb2ZmaWNpYWwgZG9jdW1lbnRhdGlvbiBzZWVt cyB0byBpbnRyb2R1Y2UgdmVyeSBsaXR0bGUgYWJvdXQKcGdfYWR2aXNvcnlfeGFjdF9sb2NrLiBX aGVuIEkgY2hlY2sgdGhlIHBvc3RncmVzcWwgbG9nLCBJIGZpbmQgdGhhdCBpdCBjYW4ndAphY3F1 aXJlIHRoZSBsb2NrIGZvciBhIGxvbmcgdGltZS4gRG9lcyB0aGlzIG1lYW4gdGhhdCB0aGUgbGFz dCBsb2NrIHdhcyBub3QKcmVsZWFzZWQgb3Igbm90IHJlbGVhc2VkIGNvbXBsZXRlbHk/IEF0IHBy ZXNlbnQgSSBtYXkgbmVlZCBzb21lIGhlbHA6DQoxLiBWaWV3IHRoZSBTUUwgdGhhdCBleGlzdHMg aW4gdGhlIGRhdGFiYXNlIHBnX2Fkdmlzb3J5X3hhY3RfbG9jayBhbmQgdGhlClNRTCB0aGF0IHdh cyBtYW51YWxseSByZWxlYXNlZA0KMi4gQ29ycmVzcG9uZHMgdG8gdGhlIGZhY3QgdGhhdCBJIGhh dmUgbm90IG9idGFpbmVkIHRoZSBsb2NrIGZvciBhIGxvbmcKdGltZS4gQ2FuIEkgc2V0IHRoZSBs b2NrIGxpZmV0aW1lIGFuZCBhdXRvbWF0aWNhbGx5IHJlbGVhc2UgaXQgZm9yIGEgbG9uZwp0aW1l IHdpdGhvdXQgcmVsZWFzZSwgdGhhdCBpcywgaWYgdGhlIGxvY2sgaGFzIG5vdCBiZWVuIHJlbGVh c2VkIGZvciBhIGxvbmcKdGltZSBsYXN0IHRpbWUsIGl0IHdpbGwgbm90IGFmZmVjdCB0aGUgYWNx dWlzaXRpb24gb2YgdGhlIG5leHQgbG9jay4gV2hhdApzaG91bGQgSSBkbz8gRG8sIHNpbmNlIHRo ZSBvZmZpY2lhbCBkb2N1bWVudGF0aW9uIGlzIGxlc3MsIEkgbmVlZCB5b3VyCmhlbHANClNpbmNl cmUgdGhhbmtzDQpEZWFyJ3MgQW5keQoK --===============5272329585624004017==--