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 1iBFPY-0001mR-Mi for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Sep 2019 09:41:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iBFPX-0003NM-D1 for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Sep 2019 09:41:07 +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 1iBFPX-0003N1-4k for pgsql-bugs@lists.postgresql.org; Fri, 20 Sep 2019 09:41:07 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iBFPU-0003zo-6j for pgsql-bugs@lists.postgresql.org; Fri, 20 Sep 2019 09:41:06 +0000 Content-Type: multipart/mixed; boundary="===============4013394063807196756==" MIME-Version: 1.0 Subject: BUG #16016: deadlock with startup process, AccessExclusiveLock on pg_statistic's toast table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: alexey.ermakov@dataegret.com Reply-To: alexey.ermakov@dataegret.com, pgsql-bugs@lists.postgresql.org Date: Fri, 20 Sep 2019 09:40:31 +0000 Message-ID: <16016-ed0345229ddc484c@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4013394063807196756== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjAxNgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhleSBFcm1ha292CkVt YWlsIGFkZHJlc3M6ICAgICAgYWxleGV5LmVybWFrb3ZAZGF0YWVncmV0LmNvbQpQb3N0Z3JlU1FM IHZlcnNpb246IDExLjUKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMTYuMDQuNiBMVFMKRGVz Y3JpcHRpb246ICAgICAgICAKCkhlbGxvLA0KDQpyZWNlbnRseSBJIGVuY291bnRlcmVkIHN0cmFu Z2Ugc2l0dWF0aW9uIHdoZW4gcmVwbGljYSBzZXJ2ZXIgc3RvcHBlZCBzZXJ2aW5nCnF1ZXJpZXMu IG1vc3QgbGlrZWx5IGl0IGhhcHBlbmVkIGJlY2F1c2Ugc3RhcnR1cCBwcm9jZXNzIHdhcyBob2xk aW5nIGFjY2VzcwpleGNsdXNpdmUgbG9jayBvbiBwZ19zdGF0aXN0aWMncyB0b2FzdCB0YWJsZSBh bmQgd2FzIHdhaXRpbmcgZm9yIHNvbWUKYmFja2VuZCB3aGljaCBsZWFkIHRvIGRlYWRsb2NrLg0K c2l0dWF0aW9uIHJlc29sdmVkIGFmdGVyIG1heF9zdGFuZGJ5X3N0cmVhbWluZ19kZWxheSB0aW1l b3V0IGtpY2tlZCBpbiBhbmQKY29uZmxpY3RpbmcgYmFja2VuZCdzIHF1ZXJpZXMgd2VyZSBjYW5j ZWxlZC4NCg0KbW9yZSBkZXRhaWxzOg0KDQoxKSBmaXJzdCB3YWl0aW5nIGJhY2tlbmQgaW4gbG9n czoNCjIwMTktMDktMTkgMTI6MTQ6MTEuMzE0IFVUQyAxNDQyODUgdXNlckBkYiBmcm9tIFtsb2Nh bF0gW3Z4aWQ6MjEvMTA2MzUwMTg5CnR4aWQ6MF0gW0JJTkQgd2FpdGluZ10gTE9HOiAgcHJvY2Vz cyAxNDQyODUgc3RpbGwgd2FpdGluZyBmb3IKQWNjZXNzU2hhcmVMb2NrIG9uIHJlbGF0aW9uIDI4 NDAgb2YgZGF0YWJhc2UgMTYzODkgYWZ0ZXIgMTAwMC4xMTUgbXMNCjIwMTktMDktMTkgMTI6MTQ6 MTEuMzE0IFVUQyAxNDQyODUgdXNlckBkYiBmcm9tIFtsb2NhbF0gW3Z4aWQ6MjEvMTA2MzUwMTg5 CnR4aWQ6MF0gW0JJTkQgd2FpdGluZ10gREVUQUlMOiAgUHJvY2VzcyBob2xkaW5nIHRoZSBsb2Nr OiA2MDAyLiBXYWl0IHF1ZXVlOgoxNDQyODUsIDEzNjY0OSwgMTI3MzQ5LCA3NjQxNywgOTczNTAs IDkzMDE5LCAxMDkwMTAsIDEwMzE2MywgMTM2MzAwLg0KDQoyKSA2MDAyIHBpZCBpcyBpbmRlZWQg c3RhcnR1cCBwcm9jZXNzOg0KcHMgYXggfCBncmVwIDYwMDINCjYwMDIgPyAgICAgICAgU3MgICAy MDA6MTYgcG9zdGdyZXM6IDExL21haW46IHN0YXJ0dXAgICByZWNvdmVyaW5nCjAwMDAwMDAxMDAw MDQyNTkwMDAwMDA5NA0KDQozKSBsb2NrZWQgcmVsYXRpb24gaXMgcGdfc3RhdGlzdGljJ3MgdG9h c3QgdGFibGU6DQoNCnNlbGVjdCAyODQwOjpyZWdjbGFzczsNCiAgICAgICAgcmVnY2xhc3MNCi0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIHBnX3RvYXN0LnBnX3RvYXN0XzI2MTkNCg0Kc2VsZWN0 IDI2MTk6OnJlZ2NsYXNzOw0KICAgcmVnY2xhc3MNCi0tLS0tLS0tLS0tLS0tDQogcGdfc3RhdGlz dGljDQoNCjQpIEkgZ3Vlc3MgYXV0b3ZhY3V1bSB3YXMgd29ya2luZyBvbiBwZ19zdGF0aXN0aWMg dGFibGUgb24gbWFzdGVyIHNlcnZlcgpyaWdodCBiZWZvcmUgcHJvYmxlbSBvY2N1cnJlZCBhbmQg Y2xlYW5lZCB1cCBzb21lIHBhZ2VzIGF0IHRoZSBlbmQgb2YKcmVsYXRpb24uDQpidXQgY2FuJ3Qg Y29uZmlybSwgbG9nX2F1dG92YWN1dW1fbWluX2R1cmF0aW9uID0gMXMgYW5kIG5vIGVudHJpZXMg aW4gbG9ncywKYnV0IHRhYmxlIGlzIHByZXR0eSBzbWFsbCAofjJNQikgc28gYXV0b3ZhY3V1bSBt aWdodCBiZSBmaW5pc2hlZCBpbiBsZXNzCnRoYW4gMXMuDQoNCjUpIGFjY29yZGluZyB0byBjbGll bnQgbm8gREIgbWlncmF0aW9ucyB3ZXJlIHBlcmZvcm1lZCBhdCB0aGF0IHRpbWUuDQoNCg0Kc2Ft ZSB0aGluZyAoYWdhaW4gdG9hc3QgdGFibGUgb2YgcGdfc3RhdGlzdGljKSBhbHNvIGhhcHBlbmVk IHllYXIgYWdvIHR3aWNlCm9uIDkuNi42IHZlcnNpb24gb24gY29tcGxldGVseSBkaWZmZXJlbnQg c2VydmVyIGFuZCBwcm9qZWN0Lg0KdW5mb3J0dW5hdGVseSBJIHdhc24ndCBhYmxlIHRvIGdldCBn ZGIgYmFja3RyYWNlIG9mIHN0YXJ0dXAgcHJvY2Vzcywgc28gaXQKbWlnaHQgYmUgZGlmZmljdWx0 IHRvIHVuZGVyc3RhbmQgd2hlcmUgaXQgZ290IHN0dWNrIDooDQoNCmF0IHllYXIncyBhZ28gY2Fz ZSBJIHdhcyBhYmxlIHRvIGdldCBvdXRwdXQgb2YgcGdfbG9ja3MsIGJ1dCBub3QgbXVjaAppbnRl cmVzdGluZyB0aGVyZToNCg0Kc2VsZWN0ICogZnJvbSBwZ19sb2NrczsNCiAgbG9ja3R5cGUgIHwg ZGF0YWJhc2UgfCByZWxhdGlvbiB8IHBhZ2UgfCB0dXBsZSB8IHZpcnR1YWx4aWQgIHwKdHJhbnNh Y3Rpb25pZCB8IGNsYXNzaWQgfCBvYmppZCB8IG9ianN1YmlkIHwgdmlydHVhbHRyYW5zYWN0aW9u IHwgIHBpZCAgIHwgIAogICAgIG1vZGUgICAgICAgICB8IGdyYW50ZWQgfCBmYXN0cGF0aA0KLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0rLS0tLS0tLSstLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0t LS0tLS0tLQ0KLi4udHJ1bmNhdGVkLCBJIGNhbiBzaG93IGZ1bGwgb3V0cHV0IGlmIGl0IG1pZ2h0 IGhlbHAuLi4NCiB2aXJ0dWFseGlkIHwgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgfCAgICAg ICB8IDEyLzE5MDg5MDU1IHwgICAgICAgICAgICAKICB8ICAgICAgICAgfCAgICAgICB8ICAgICAg ICAgIHwgMTIvMTkwODkwNTUgICAgICAgIHwgIDkxMTQ1IHwgRXhjbHVzaXZlTG9jawogICAgICB8 IHQgICAgICAgfCB0DQogdmlydHVhbHhpZCB8ICAgICAgICAgIHwgICAgICAgICAgfCAgICAgIHwg ICAgICAgfCAxLzEgICAgICAgICB8ICAgICAgICAgICAgCiAgfCAgICAgICAgIHwgICAgICAgfCAg ICAgICAgICB8IDEvMCAgICAgICAgICAgICAgICB8ICAxNjE0MSB8IEV4Y2x1c2l2ZUxvY2sKICAg ICAgfCB0ICAgICAgIHwgdA0KIHJlbGF0aW9uICAgfCAgICAyMDUwOCB8ICAgICAyODQwIHwgICAg ICB8ICAgICAgIHwgICAgICAgICAgICAgfCAgICAgICAgICAgIAogIHwgICAgICAgICB8ICAgICAg IHwgICAgICAgICAgfCAxMi8xOTA4OTA1NSAgICAgICAgfCAgOTExNDUgfApBY2Nlc3NTaGFyZUxv Y2sgICAgIHwgZiAgICAgICB8IGYNCiByZWxhdGlvbiAgIHwgICAgMjA1MDggfCAgICAgMjg0MCB8 ICAgICAgfCAgICAgICB8ICAgICAgICAgICAgIHwgICAgICAgICAgICAKICB8ICAgICAgICAgfCAg ICAgICB8ICAgICAgICAgIHwgMjQvMTg0Mjc3NDAgICAgICAgIHwgIDk0Njk4IHwKQWNjZXNzU2hh cmVMb2NrICAgICB8IGYgICAgICAgfCBmDQogcmVsYXRpb24gICB8ICAgIDIwNTA4IHwgICAgIDI4 NDAgfCAgICAgIHwgICAgICAgfCAgICAgICAgICAgICB8ICAgICAgICAgICAgCiAgfCAgICAgICAg IHwgICAgICAgfCAgICAgICAgICB8IDI2LzE1OTY0MTU5ICAgICAgICB8ICA5NjM4NyB8CkFjY2Vz c1NoYXJlTG9jayAgICAgfCBmICAgICAgIHwgZg0KIHJlbGF0aW9uICAgfCAgICAyMDUwOCB8ICAg ICAyODQwIHwgICAgICB8ICAgICAgIHwgICAgICAgICAgICAgfCAgICAgICAgICAgIAogIHwgICAg ICAgICB8ICAgICAgIHwgICAgICAgICAgfCAyNy8xMTMzNzM0MyAgICAgICAgfCAxMDc0NDggfApB Y2Nlc3NTaGFyZUxvY2sgICAgIHwgZiAgICAgICB8IGYNCiByZWxhdGlvbiAgIHwgICAgMjA1MDgg fCAgICAgMjg0MCB8ICAgICAgfCAgICAgICB8ICAgICAgICAgICAgIHwgICAgICAgICAgICAKICB8 ICAgICAgICAgfCAgICAgICB8ICAgICAgICAgIHwgMjgvOTY2NjAyMiAgICAgICAgIHwgIDk5MTEw IHwKQWNjZXNzU2hhcmVMb2NrICAgICB8IGYgICAgICAgfCBmDQogcmVsYXRpb24gICB8ICAgIDIw NTA4IHwgICAgIDI4NDAgfCAgICAgIHwgICAgICAgfCAgICAgICAgICAgICB8ICAgICAgICAgICAg CiAgfCAgICAgICAgIHwgICAgICAgfCAgICAgICAgICB8IDEvMCAgICAgICAgICAgICAgICB8ICAx NjE0MSB8CkFjY2Vzc0V4Y2x1c2l2ZUxvY2sgfCB0ICAgICAgIHwgZg0KKDU2IHJvd3MpDQoNCmlu IHRoYXQgY2FzZSBwaWQgMTYxNDEgLSBzdGFydHVwIHByb2Nlc3MgYW5kIGFnYWluIDI4NDAgLSBv aWQgb2YgdG9hc3QgdGFibGUKb2YgcGdfc3RhdGlzdGljLg0KMTYxNDEgPyAgICAgICAgU3MgICAx NDE2OToxNCBwb3N0Z3JlczogOS42L21haW46IHN0YXJ0dXAgcHJvY2VzcyAgCnJlY292ZXJpbmcg MDAwMDAwMDIwMDAwQTNFMzAwMDAwMERDIHdhaXRpbmcNCg0KLS0NClRoYW5rcywNCkFsZXhleSBF cm1ha292Cgo= --===============4013394063807196756==--