Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1duq0z-0003qH-6P for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Sep 2017 01:10:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1duq0y-0001gF-03 for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Sep 2017 01:10:52 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1duq0F-0000Kb-9b for pgsql-bugs@postgresql.org; Thu, 21 Sep 2017 01:10:07 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1duq0B-0002c7-Tq for pgsql-bugs@postgresql.org; Thu, 21 Sep 2017 01:10:06 +0000 MIME-Version: 1.0 Subject: BUG #14821: idle_in_transaction_session_timeout sometimes gets ignored when statement timeout is pending To: pgsql-bugs@postgresql.org From: lukas@fittl.com Cc: lukas@fittl.com Date: Thu, 21 Sep 2017 01:09:56 +0000 Message-ID: <20170921010956.17345.61461@wrigleys.postgresql.org> Content-Transfer-Encoding: base64 Content-Type: text/plain; charset="utf-8" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDgyMQpMb2dnZWQgYnk6ICAg ICAgICAgIEx1a2FzIEZpdHRsCkVtYWlsIGFkZHJlc3M6ICAgICAgbHVrYXNA Zml0dGwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogOS42LjQKT3BlcmF0aW5n IHN5c3RlbTogICBBbWF6b24gTGludXggUkhFTCA2CkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIaSBhbGwsDQoNCkkndmUgYmVlbiBvYnNlcnZpbmcgYSBwcm9i bGVtIG9uIDkuNi40LCBidXQgaW4gbXkgdW5kZXJzdGFuZGluZyB0aGlzIHN0 aWxsCmFwcGxpZXMgb24gbWFzdGVyIHRvby4NCg0KUmVsZXZhbnQgY29uZmln Og0KDQppZGxlX2luX3RyYW5zYWN0aW9uX3Nlc3Npb25fdGltZW91dCA9IDMw cw0Kc3RhdGVtZW50X3RpbWVvdXQgPSAzMHMNCg0KQmFja2VuZCB0aGF0cyBp ZGxlIGluIHRyYW5zYWN0aW9uIGFuZCBzaG91bGQgaGF2ZSBiZWVuIGNhbmNl bGxlZDoNCg0KPT4gU0VMRUNUIHBpZCwgc3RhdGUsIG5vdygpIC0gYmFja2Vu ZF9zdGFydCBBUyBiYWNrZW5kX2FnZSwgbm93KCkgLQp4YWN0X3N0YXJ0IEFT IHhhY3RfYWdlLCBub3coKSAtIHN0YXRlX2NoYW5nZSBBUyBzdGF0ZV9hZ2Us IHF1ZXJ5IEZST00KcGdfc3RhdF9hY3Rpdml0eSBXSEVSRSBzdGF0ZSA9ICdp ZGxlIGluIHRyYW5zYWN0aW9uJyBPUkRFUiBCWQpiYWNrZW5kX3N0YXJ0Ow0K IHBpZCAgfCAgICAgICAgc3RhdGUgICAgICAgIHwgICBiYWNrZW5kX2FnZSAg IHwgICAgeGFjdF9hZ2UgICAgIHwgICAKc3RhdGVfYWdlICAgIHwgICAgICBx dWVyeSAgICAgICANCi0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tDQogNDAwNSB8IGlkbGUgaW4gdHJh bnNhY3Rpb24gfCAwNDoyOTo1MS44NDQwNjMgfCAwMToxOToxMC45ODQ5NzIg fAowMToxOToxMC45ODQ5NDcgfCBCRUdJTiBSRUFEIFdSSVRFDQooMSByb3cp DQoNCkJhY2t0cmFjZSBmcm9tIHRoYXQgYmFja2VuZDoNCg0KKGdkYikgYnQN CiMwICAweDAwMDA3ZjlkZmZiMjk4YzMgaW4gX19lcG9sbF93YWl0X25vY2Fu Y2VsICgpIGF0Ci4uL3N5c2RlcHMvdW5peC9zeXNjYWxsLXRlbXBsYXRlLlM6 ODENCiMxICAweDAwMDAwMDAwMDA2YTA2ZDYgaW4gV2FpdEV2ZW50U2V0V2Fp dEJsb2NrIChuZXZlbnRzPTEsCm9jY3VycmVkX2V2ZW50cz0weDdmZmYwZTBm M2NmMCwgY3VyX3RpbWVvdXQ9LTEsIHNldD0weDI5ZWExYTgpIGF0CmxhdGNo LmM6MTA1Mw0KIzIgIFdhaXRFdmVudFNldFdhaXQgKHNldD0weDI5ZWExYTgs IHRpbWVvdXQ9dGltZW91dEBlbnRyeT0tMSwKb2NjdXJyZWRfZXZlbnRzPW9j Y3VycmVkX2V2ZW50c0BlbnRyeT0weDdmZmYwZTBmM2NmMCwKbmV2ZW50cz1u ZXZlbnRzQGVudHJ5PTEpIGF0IGxhdGNoLmM6MTAwNw0KIzMgIDB4MDAwMDAw MDAwMDVlNDk4NSBpbiBzZWN1cmVfcmVhZCAocG9ydD0weDJhNDJmMzAsIHB0 cj0weGMwOTI2MAo8UHFSZWN2QnVmZmVyPiwgbGVuPTgxOTIpIGF0IGJlLXNl Y3VyZS5jOjE0OQ0KIzQgIDB4MDAwMDAwMDAwMDVlZDg5OCBpbiBwcV9yZWN2 YnVmICgpIGF0IHBxY29tbS5jOjk0MA0KIzUgIDB4MDAwMDAwMDAwMDVlZTNh NSBpbiBwcV9nZXRieXRlICgpIGF0IHBxY29tbS5jOjk4Mw0KIzYgIDB4MDAw MDAwMDAwMDZiZjAxMiBpbiBTb2NrZXRCYWNrZW5kIChpbkJ1Zj0weDdmZmYw ZTBmM2U4MCkgYXQKcG9zdGdyZXMuYzozMjYNCiM3ICBSZWFkQ29tbWFuZCAo aW5CdWY9MHg3ZmZmMGUwZjNlODApIGF0IHBvc3RncmVzLmM6NDk5DQojOCAg UG9zdGdyZXNNYWluIChhcmdjPTxvcHRpbWl6ZWQgb3V0PiwgYXJndj1hcmd2 QGVudHJ5PTB4MmE0YzRmOCwKZGJuYW1lPTB4MmE0YzQ2OCAibXlkYiIsIHVz ZXJuYW1lPTxvcHRpbWl6ZWQgb3V0PikgYXQgcG9zdGdyZXMuYzo0MDE5DQoj OSAgMHgwMDAwMDAwMDAwNDZlZDJiIGluIEJhY2tlbmRSdW4gKHBvcnQ9MHgy YTQyZjMwKSBhdCBwb3N0bWFzdGVyLmM6NDI5NA0KIzEwIEJhY2tlbmRTdGFy dHVwIChwb3J0PTB4MmE0MmYzMCkgYXQgcG9zdG1hc3Rlci5jOjM5NjgNCiMx MSBTZXJ2ZXJMb29wICgpIGF0IHBvc3RtYXN0ZXIuYzoxNzE5DQojMTIgMHgw MDAwMDAwMDAwNjY2OTQ2IGluIFBvc3RtYXN0ZXJNYWluIChhcmdjPWFyZ2NA ZW50cnk9MywKYXJndj1hcmd2QGVudHJ5PTB4MjllODZiMCkgYXQgcG9zdG1h c3Rlci5jOjEzMjcNCiMxMyAweDAwMDAwMDAwMDA0NmY4YTIgaW4gbWFpbiAo YXJnYz0zLCBhcmd2PTB4MjllODZiMCkgYXQgbWFpbi5jOjIyOA0KDQpTbyBh cyB5b3UgY2FuIHNlZSBpdHMgd2FpdGluZyBvbiBsaW5lIDMyNiBvZiB0Y29w L3Bvc3RncmVzLmMgZm9yIGRhdGEgZnJvbQpwcV9nZXRieXRlKCkuIEFuZCB0 aGUgcmVhc29uIHRoYXQgUHJvY2Vzc0ludGVycnVwdHMoKSBjYW4ndCBtb3Zl IGZvcndhcmQgaXMKZHVlIHRvIHRoZSBIT0xEX0NBTkNFTF9JTlRFUlJVUFRT KCkganVzdCBiZWZvcmUgdGhhdCBpbiBjb21iaW5hdGlvbiB3aXRoIGEKcGVu ZGluZyBxdWVyeSBjYW5jZWxsYXRpb24uDQoNClJlbGV2YW50IHZhcmlhYmxl czoNCg0KKGdkYikgcCBJbnRlcnJ1cHRIb2xkb2ZmQ291bnQNCiQxMyA9IDAN CihnZGIpIHAgQ3JpdFNlY3Rpb25Db3VudA0KJDE0ID0gMA0KKGdkYikgcCBR dWVyeUNhbmNlbEhvbGRvZmZDb3VudA0KJDE2ID0gMQ0KKGdkYikgcCBRdWVy eUNhbmNlbFBlbmRpbmcNCiQxNyA9IDEgJ1wwMDEnDQooZ2RiKSBwIElkbGVJ blRyYW5zYWN0aW9uU2Vzc2lvblRpbWVvdXQNCiQxID0gMzAwMDANCihnZGIp IHAgSWRsZUluVHJhbnNhY3Rpb25TZXNzaW9uVGltZW91dFBlbmRpbmcNCiQy ID0gMSAnXDAwMScNCihnZGIpIHAgYWxsX3RpbWVvdXRzW0lETEVfSU5fVFJB TlNBQ1RJT05fU0VTU0lPTl9USU1FT1VUXQ0KJDMgPSB7aW5kZXggPSBJRExF X0lOX1RSQU5TQUNUSU9OX1NFU1NJT05fVElNRU9VVCwgaW5kaWNhdG9yID0g MSAnXDAwMScsCnRpbWVvdXRfaGFuZGxlciA9IDB4N2JhZWUwIDxJZGxlSW5U cmFuc2FjdGlvblNlc3Npb25UaW1lb3V0SGFuZGxlcj4sCnN0YXJ0X3RpbWUg PSA1NTkyNjYzODQwMzExMzcsIGZpbl90aW1lID0gNTU5MjY2NDE0MDMxMTM3 fQ0KDQpJdCBzZWVtcyB0byBtZSB0aGF0IFByb2Nlc3NJbnRlcnJ1cHRzKCkg c2hvdWxkIGNoZWNrIGZvciB0aGUgaWRsZSBpbgp0cmFuc2FjdGlvbiB0aW1l b3V0IGZpcnN0LCBzaW5jZSBpdCBzaG9ydC1jaXJjdWl0cyBhbmQgcmV0dXJu cyBlYXJseSBpZgpRdWVyeUNhbmNlbFBlbmRpbmcgJiYgUXVlcnlDYW5jZWxI b2xkb2ZmQ291bnQgIT0gMCBiZWZvcmUgZXZlbiBnZXR0aW5nCnRoZXJlLg0K DQpCZXN0LA0KTHVrYXMKCgotLSAKU2VudCB2aWEgcGdzcWwtYnVncyBtYWls aW5nIGxpc3QgKHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2Ug Y2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0 Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1idWdzCg==