Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sFV4D-002sm8-Pi for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Jun 2024 08:35:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sFV4B-009o9N-Mh for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Jun 2024 08:35:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sFUSK-009Pn3-9v for pgsql-bugs@lists.postgresql.org; Fri, 07 Jun 2024 07:56:13 +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 1sFUSD-0007ud-R8 for pgsql-bugs@lists.postgresql.org; Fri, 07 Jun 2024 07:56:11 +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=4bLHuSvHHavRY2FmnUx0DJbs1/HnZ6isW0CxBzWKJ3o=; b=f4F+KOylC3Ww3f0z/ykiqe3VqR AgkvCW1EirZd9EExQ2kndbIVj0Y/Zy0ioXiMXMCaweIhCryKoJHleZ0RAjsg1RoQYRORVDd+5q/++ y9GmhR7+S/qMtb6jRWSbH2//1HVOI2UWn7gXITCT7KCN5erzXRKe7KjmoNyZnD1uQ1yOd4z+kIT/P gy+XtD6QDfU+bBTTiApV5vOQHiopgqUZxRaTAhTKrAiMq+z2YZ6Av60DNJvsl3o43FUdwrhXowXa5 4RO8IROdvg1MBT4xkT6RPKKg5UVNAlio4uCFI64uG7Sea//jpkgAhHtmTOYuPCUEGSBbmQeJbzsGN 3BcggzWQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sFUSC-000OsL-82 for pgsql-bugs@lists.postgresql.org; Fri, 07 Jun 2024 07:56: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 1sFUS9-002Glo-S7 for pgsql-bugs@lists.postgresql.org; Fri, 07 Jun 2024 07:56:02 +0000 Content-Type: multipart/mixed; boundary="===============6454043586636298249==" MIME-Version: 1.0 Subject: BUG #18498: Locking a table from a trigger (with using two sessions) causes a deadlock: the bug or the feature? To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: d.koval@postgrespro.ru Reply-To: d.koval@postgrespro.ru, pgsql-bugs@lists.postgresql.org Date: Fri, 07 Jun 2024 07:55:29 +0000 Message-ID: <18498-b95f3ee4c156de45@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 --===============6454043586636298249== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQ5OApMb2dnZWQgYnk6ICAgICAgICAgIERtaXRyeSBLb3ZhbApFbWFp bCBhZGRyZXNzOiAgICAgIGQua292YWxAcG9zdGdyZXNwcm8ucnUKUG9zdGdyZVNRTCB2ZXJzaW9u OiAxN2JldGExCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIyLjA0CkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIaSENCg0KSSBzZWUgc3RyYW5nZSBiZWhhdmlvciBvZiB0aGUgTE9DSyBUQUJMRSBj b21tYW5kIHdoZW4gZXhlY3V0ZWQgZnJvbSBhCnRyaWdnZXIuDQpJZiBMT0NLIFRBQkxFIChmb3Ig dGhlIHNhbWUgdGFibGUpIGlzIGV4ZWN1dGVkIGZyb20gYSB0cmlnZ2VyIGluIHR3bwpkaWZmZXJl bnQgc2Vzc2lvbnMsIHRoZW4gdGhlcmUgaXMgYSBwb3NzaWJpbGl0eSBvZiBhIOKAnGRlYWRsb2Nr IGRldGVjdGVk4oCdCmVycm9yLg0KSXMgdGhpcyBjb3JyZWN0PyAoSSdtIGd1ZXNzaW5nIHRoZSBj b3JyZWN0IGJlaGF2aW9yIGlzIHRoaXMgb25lOiBvbmUgc2Vzc2lvbgpnZXR0aW5nIGEgdGFibGUg bG9jaywgYW5kIGFub3RoZXIgc2Vzc2lvbiB3YWl0cyBmb3IgdGhlIGZpcnN0IHNlc3Npb24ncwp0 cmFuc2FjdGlvbiB0byBjb21wbGV0ZS4pDQoNCkV4YW1wbGUuDQotLS0tLS0tLQ0KMSkgSSB3cm90 ZSBhIHRhcC10ZXN0IHRvIHJlcHJvZHVjZSB0aGUgcHJvYmxlbSAoc2VlIGF0dGFjaGVkIGZpbGUK djEtMDAwMS1MT0NLLVRBQkxFLXdpdGgtZGVhZGxvY2tzLnBhdGNoIGluIG5leHQgZW1haWwpLg0K QWZ0ZXIgYXBwbHlpbmcgdGhlIHBhdGNoIHlvdSBuZWVkIHRvIHJ1biB0aGUgdGVzdCB1c2luZyB0 aGUgY29tbWFuZA0KDQpQUk9WRV9URVNUUz10LzAwNl9wYXJhbGxlbF9pbnNlcnRzLnBsIG1ha2Ug Y2hlY2sgLUMKc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X21pc2MNCg0KVGVzdCBleHBsYW5hdGlvbnMu DQotLS0tLS0tLS0tLS0tLS0tLS0NClRoZSB0ZXN0IGNyZWF0ZXMgQkVGT1JFIElOU0VSVCB0cmln Z2VyLiBUcmlnZ2VyIGZ1bmN0aW9uIGNvbnRhaW5zIHJvd3M6DQoNCiAgUkFJU0UgTE9HICdCZWZv cmUgbG9jayAocGlkICUpJywgcGdfYmFja2VuZF9waWQoKTsNCiAgTE9DSyBUQUJMRSB0ZXN0Ow0K ICBSQUlTRSBMT0cgJ0FmdGVyIGxvY2sgKHBpZCAlKScsIHBnX2JhY2tlbmRfcGlkKCk7DQoNClRo ZSB0ZXN0IHN0YXJ0cyA0IHRocmVhZHMgdGhhdCBpbnNlcnQgcmVjb3JkcywgY2F1c2luZyB0aGUg dHJpZ2dlci4NCkFzIGEgcmVzdWx0IG9mIHJ1bm5pbmcgdGhlIHRlc3QsIHdlIHNlZSBzZXZlcmFs ICJkZWFkbG9jayBkZXRlY3RlZCIgZXJyb3JzCndpdGggZGVidWcgbWVzc2FnZXMgaW4gdGhlIHNl cnZlciBsb2csIGxpa2UgdGhlc2U6DQoNClsyMTk1NjJdIDAwNl9wYXJhbGxlbF9pbnNlcnRzLnBs IExPRzogIEJlZm9yZSBsb2NrIChwaWQgMjE5NTYyKQ0KWzIxOTU2Ml0gMDA2X3BhcmFsbGVsX2lu c2VydHMucGwgQ09OVEVYVDogIFBML3BnU1FMIGZ1bmN0aW9uIHRlc3RfZnVuYygpCmxpbmUgNSBh dCBSQUlTRQ0KWzIxOTU2Ml0gMDA2X3BhcmFsbGVsX2luc2VydHMucGwgU1RBVEVNRU5UOiAgSU5T RVJUIElOVE8gdGVzdCBWQUxVRVMgKDEwLAond29ya2VyXzInKTsNClsyMTk1NjNdIDAwNl9wYXJh bGxlbF9pbnNlcnRzLnBsIExPRzogIEJlZm9yZSBsb2NrIChwaWQgMjE5NTYzKQ0KWzIxOTU2M10g MDA2X3BhcmFsbGVsX2luc2VydHMucGwgQ09OVEVYVDogIFBML3BnU1FMIGZ1bmN0aW9uIHRlc3Rf ZnVuYygpCmxpbmUgNSBhdCBSQUlTRQ0KWzIxOTU2M10gMDA2X3BhcmFsbGVsX2luc2VydHMucGwg U1RBVEVNRU5UOiAgSU5TRVJUIElOVE8gdGVzdCBWQUxVRVMgKDExLAond29ya2VyXzEnKTsNClsy MTk1NjNdIDAwNl9wYXJhbGxlbF9pbnNlcnRzLnBsIEVSUk9SOiAgZGVhZGxvY2sgZGV0ZWN0ZWQN ClsyMTk1NjNdIDAwNl9wYXJhbGxlbF9pbnNlcnRzLnBsIERFVEFJTDogIFByb2Nlc3MgMjE5NTYz IHdhaXRzIGZvcgpBY2Nlc3NFeGNsdXNpdmVMb2NrIG9uIHJlbGF0aW9uIDE2Mzg0IG9mIGRhdGFi YXNlIDU7IGJsb2NrZWQgYnkgcHJvY2VzcwoyMTk1NjIuDQoJUHJvY2VzcyAyMTk1NjIgd2FpdHMg Zm9yIEFjY2Vzc0V4Y2x1c2l2ZUxvY2sgb24gcmVsYXRpb24gMTYzODQgb2YgZGF0YWJhc2UKNTsg YmxvY2tlZCBieSBwcm9jZXNzIDIxOTU2My4NCglQcm9jZXNzIDIxOTU2MzogSU5TRVJUIElOVE8g dGVzdCBWQUxVRVMgKDExLCAnd29ya2VyXzEnKTsNCglQcm9jZXNzIDIxOTU2MjogSU5TRVJUIElO VE8gdGVzdCBWQUxVRVMgKDEwLCAnd29ya2VyXzInKTsNClsyMTk1NjNdIDAwNl9wYXJhbGxlbF9p bnNlcnRzLnBsIEhJTlQ6ICBTZWUgc2VydmVyIGxvZyBmb3IgcXVlcnkgZGV0YWlscy4NClsyMTk1 NjNdIDAwNl9wYXJhbGxlbF9pbnNlcnRzLnBsIENPTlRFWFQ6ICBTUUwgc3RhdGVtZW50ICJMT0NL IFRBQkxFIHRlc3QiDQoJUEwvcGdTUUwgZnVuY3Rpb24gdGVzdF9mdW5jKCkgbGluZSA2IGF0IFNR TCBzdGF0ZW1lbnQNCg0KQXMgd2UgY2FuIHNlZW4sIHR3byBzZXNzaW9ucyAyMTk1NjIgYW5kIDIx OTU2MjMgcmVjZWl2ZWQgYW4KQWNjZXNzRXhjbHVzaXZlTG9jayBsb2NrIG9uIHRoZSB0aGUgc2Ft ZSB0YWJsZSwgYWZ0ZXIgd2hpY2ggYSBkZWFkbG9jayB3YXMKaW1tZWRpYXRlbHkgZGlhZ25vc2Vk Lg0KLS0tLQ0KDQoyKSBJIGhhdmUgYXR0YWNoZWQgYSBzaW1pbGFyIHRhcC10ZXN0IHVzaW5nIHRo ZSBmdW5jdGlvbiwgYnV0IHdpdGhvdXQgdXNpbmcKdGhlIHRyaWdnZXIgKGZpbGUgdjEtMDAwMS1M T0NLLVRBQkxFLXdvLWVycm9ycy5wYXRjaCBpbiBuZXh0IGVtYWlsKS4NCldoZW4gcnVubmluZyB0 aGlzIHRlc3QsIG5vICJkZWFkbG9jayBkZXRlY3RlZCIgZXJyb3JzIG9jY3VyLg0KSXQncyBzdHJh bmdlIGJlY2F1c2UgdGhlIHRlc3RzIGFyZSBzaW1pbGFyLg0KLS0tLQ0KDQpUaGUgbWFpbiBxdWVz dGlvbjogaXMgdGhlICJkZWFkbG9jayBkZXRlY3RlZCIgZXJyb3IgKDEpIGNvcnJlY3Q/DQooSS5l LiBpcyBpdCBuZWNlc3NhcnkgdG8gbG9vayBmb3IgdGhlIHJlYXNvbiBmb3IgdGhpcyBiZWhhdmlv cj8pDQoNCi0tIA0KV2l0aCBiZXN0IHJlZ2FyZHMsDQpEbWl0cnkgS292YWwNCg0KUG9zdGdyZXMg UHJvZmVzc2lvbmFsOiBodHRwOi8vcG9zdGdyZXNwcm8uY29tCgo= --===============6454043586636298249==--