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 1ifLck-0000xS-Db for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Dec 2019 10:23:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ifLcj-0000oY-46 for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Dec 2019 10:23:09 +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 1ifLci-0000nH-QX for pgsql-bugs@lists.postgresql.org; Thu, 12 Dec 2019 10:23:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ifLcf-0004Sn-Og for pgsql-bugs@lists.postgresql.org; Thu, 12 Dec 2019 10:23:08 +0000 Content-Type: multipart/mixed; boundary="===============4061022961852368364==" MIME-Version: 1.0 Subject: BUG #16162: create index using gist_trgm_ops leads to panic To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kunert@cms.hu-berlin.de Reply-To: kunert@cms.hu-berlin.de, pgsql-bugs@lists.postgresql.org Date: Thu, 12 Dec 2019 10:22:21 +0000 Message-ID: <16162-45d21b7b6c1a3105@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4061022961852368364== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE2MgpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJlYXMgS3VuZXJ0CkVt YWlsIGFkZHJlc3M6ICAgICAga3VuZXJ0QGNtcy5odS1iZXJsaW4uZGUKUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMi4xCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDE2LjA0CkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIZWxsbywNCg0Kd2hpbGUgdGVzdGluZyBhbiB1cGNvbWluZyBtaWdyYXRpb24gb2Yg b3VyIGRhdGFiYXNlIHNlcnZlciB0byBhIG5ldyBoYXJkd2FyZQppbmNsdWRpbmcgYW4gdXBkYXRl IHRvIGEgbmV3IHBvc3RncmVzIHZlcnNpb24gSSBvYnNlcnZlZCB0aGUgZm9sbG93aW5nCmJlaGF2 aW9yIG9uIHRoZSBuZXcgc2VydmVyIHJ1bm5pbmcgYSBzZWxmLWNvbXBpbGVkIFBvc3RncmVzIDEy LjEgdW5kZXIKVWJ1bnR1IDE2LjA0Og0KDQpXaGVuIGltcG9ydGluZyBhIGNvbXBsZXRlIHBnX2R1 bXAsIGFib3V0IG9uZSBpbiB0aHJlZSB0aW1lcyBhIHBhbmljIG9jY3Vycwp3aGlsZSB0cnlpbmcg dG8gY3JlYXRlIGEgcGdfdHJnbSBnaXN0IGluZGV4IGFuZCB0aGVuIHRoZSBjbHVzdGVyIHJlc3Rh cnRzLgpUaGUgYWNjb3JkaW5nIGV4Y2VycHQgZnJvbSB0aGUgbG9nOg0KDQoyMDE5LTEyLTEyIDEw OjMyOjAzLjg4NiBDRVQgWzM2OTk5XSBMT0c6ICBzdGF0ZW1lbnQ6IENSRUFURSBJTkRFWCBnaXN0 X2lkeApPTiBwdWJsaWMubXl0YWJsZSBVU0lORyBnaXN0IChhbV9kZXNjcmlwdGlvbiBwdWJsaWMu Z2lzdF90cmdtX29wcyk7DQoyMDE5LTEyLTEyIDEwOjMyOjA0LjM3MCBDRVQgWzM2OTk5XSBQQU5J QzogIGludmFsaWQgaW5kZXggb2ZmbnVtOiA0DQoyMDE5LTEyLTEyIDEwOjMyOjA0LjM3MCBDRVQg WzM2OTk5XSBTVEFURU1FTlQ6ICBDUkVBVEUgSU5ERVggZ2lzdF9pZHggT04KcHVibGljLm15dGFi bGUgVVNJTkcgZ2lzdCAoYW1fZGVzY3JpcHRpb24gcHVibGljLmdpc3RfdHJnbV9vcHMpOw0KMjAx OS0xMi0xMiAxMDozMjowNC45MTQgQ0VUIFszMTMzNl0gTE9HOiAgc2VydmVyIHByb2Nlc3MgKFBJ RCAzNjk5OSkgd2FzCnRlcm1pbmF0ZWQgYnkgc2lnbmFsIDY6IEFib3J0ZWQNCjIwMTktMTItMTIg MTA6MzI6MDQuOTE0IENFVCBbMzEzMzZdIERFVEFJTDogIEZhaWxlZCBwcm9jZXNzIHdhcyBydW5u aW5nOgpDUkVBVEUgSU5ERVggZ2lzdF9pZHggT04gcHVibGljLm15dGFibGUgVVNJTkcgZ2lzdCAo YW1fZGVzY3JpcHRpb24KcHVibGljLmdpc3RfdHJnbV9vcHMpOw0KMjAxOS0xMi0xMiAxMDozMjow NC45MTQgQ0VUIFszMTMzNl0gTE9HOiAgdGVybWluYXRpbmcgYW55IG90aGVyIGFjdGl2ZQpzZXJ2 ZXIgcHJvY2Vzc2VzDQoNCkkgY291bGQgc3VjY2Vzc2Z1bGx5IHJlY3JlYXRlIHRoZSBiZWhhdmlv dXIgb24gYW5vdGhlciBzZXJ2ZXIgKHJ1bm5pbmcgYQpkZWZhdWx0LWNvbmZpZ3VyZWQgcGFja2Fn ZWQgdmVyc2lvbiBvZiBwb3N0Z3JlcyAxMiBmb3IgdWJ1bnR1IDE2LjA0IG9uIGEKZ2VybWFuIGxv Y2FsZSkgLSB0aGUgbG9nIGxvb2sgbGlrZSB0aGlzOg0KDQoyMDE5LTEyLTExIDE3OjE1OjAwLjcz NSBDRVQgWzE0OTU5XSB0ZXN0X2dpc3RfaW5kZXhAdGVzdF9naXN0X2luZGV4IFBBTklLOiAKaW52 YWxpZCBpbmRleCBvZmZudW06IDUNCjIwMTktMTItMTEgMTc6MTU6MDAuNzM1IENFVCBbMTQ5NTld IHRlc3RfZ2lzdF9pbmRleEB0ZXN0X2dpc3RfaW5kZXgKQU5XRUlTVU5HOiAgQ1JFQVRFIElOREVY IGdpc3RfaWR4IE9OIHB1YmxpYy5teXRhYmxlIFVTSU5HCmdpc3QoYW1fZGVzY3JpcHRpb24gcHVi bGljLmdpc3RfdHJnbV9vcHMpOw0KMjAxOS0xMi0xMSAxNzoxNTowNy41MDEgQ0VUIFs3NDM2XSBM T0c6ICBTZXJ2ZXJwcm96ZXNzIChQSUQgMTQ5NTkpIHd1cmRlIHZvbgpTaWduYWwgNiBiZWVuZGV0 OiBBYmdlYnJvY2hlbg0KMjAxOS0xMi0xMSAxNzoxNTowNy41MDEgQ0VUIFs3NDM2XSBERVRBSUw6 ICBEZXIgZmVobGdlc2NobGFnZW5lIFByb3plc3MKZsO8aHJ0ZSBhdXM6IENSRUFURSBJTkRFWCBn aXN0X2lkeCBPTiBwdWJsaWMubXl0YWJsZSBVU0lORwpnaXN0KGFtX2Rlc2NyaXB0aW9uIHB1Ymxp Yy5naXN0X3RyZ21fb3BzKTsNCjIwMTktMTItMTEgMTc6MTU6MDcuNTAxIENFVCBbNzQzNl0gTE9H OiAgYWt0aXZlIFNlcnZlcnByb3plc3NlIHdlcmRlbgphYmdlYnJvY2hlbg0KMjAxOS0xMi0xMSAx NzoxNTowNy41MTUgQ0VUIFs3NDM2XSBMT0c6ICBhbGxlIFNlcnZlcnByb3plc3NlIGJlZW5kZXQ7 CmluaXRpYWxpc2llcmUgbmV1DQoNCg0KVW5mb3J0dW5hdGVseSB0aGUgZGF0YWJhc2UgY29udGFp bnMgc2Vuc2l0aXZlIGRhdGEgYnV0IGFmdGVyIGEgY291cGxlIG9mCmRheXMgYW5kIGVuZGxlc3Mg dGVzdHMgSSBtYW5hZ2VkIHRvIGNyZWF0ZSBhIHNpbWlsYXJseSBidWlsdCBkYXRhYmFzZQpjb250 YWluaW5nIG9ubHkgcmFuZG9tIGRhdGEgd2hpY2ggcHJvdm9rZXMgdGhlIHNhbWUgYmVoYXZpb3Vy ICh0aGUgbG9nCm1lc3NhZ2VzIGFib3ZlIGNhbWUgZnJvbSBteSB0ZXN0IGRhdGFiYXNlKS4gSXQg Y29uc2lzdHMgb2Ygb25seSBvbiB0YWJsZQp3aXRoIHR3byBjb2x1bW5zIChzZXJpYWwsIHRleHQp IGNvbnRhaW5pbmcgMjAwMDAwIGxpbmVzIGZpbGxlZCB3aXRoIHJhbmRvbQpzdHJpbmdzIG9mIGxl bmd0aHMgdmFyeWluZyBmcm9tIDEgdG8gMTAwMC4NCg0KQSBwZXJsIHNjcmlwdCBjcmVhdGluZyB0 aGUgZGF0YWJhc2UsIGNyZWF0aW5nIGFuZCBmaWxsaW5nIHRoZSB0YWJsZSBhbmQKZmluYWxseSBp dGVyYXRpdmVseSBjcmVhdGluZyBhbmQgZHJvcHBpbmcgdGhlIGluZGV4IGlzIGF0IHRoZSBlbmQg b2YgdGhpcwptYWlsLg0KDQpTaW5jZSB0aGUgZXJyb3Igb25seSBvY2N1cnMgb25jZSBpbiBhIHdo aWxlIGl0IGNhbiB0YWtlIGEgY291cGxlIG9mCml0ZXJhdGlvbnMgKGluIG15IHRlc3RzIHVzdWFs bHkgYXQgbGVhc3QgNyBhdHRlbXB0cykuDQoNCkkgaG9wZSBJIGRpZCBub3QgbWFrZSBhIGZ1bmRh bWVudGFsIG1pc3Rha2UgYW5kIG1vcmVvdmVyIEkgaG9wZSB5b3UgY2FuCnJlcHJvZHVjZSB0aGUg YmVoYXZpb3IuDQoNClJlZ2FyZHMsDQpBbmRyZWFzDQoNCg0KDQoNCg0KLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KRGF0YWJhc2UgY3JlYXRpb24NCi0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KQ1JFQVRFIFJPTEUgInRlc3RfZ2lzdF9p bmRleCIgTE9HSU4gUEFTU1dPUkQgJ1hYWFhYJyBOT0lOSEVSSVQ7DQpDUkVBVEUgREFUQUJBU0Ug InRlc3RfZ2lzdF9pbmRleCIgT1dORVIgInRlc3RfZ2lzdF9pbmRleCI7DQpcYyB0ZXN0X2dpc3Rf aW5kZXgNCkNSRUFURSBFWFRFTlNJT04gSUYgTk9UIEVYSVNUUyBwZ190cmdtOw0KDQoNCg0KLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQpQZXJsIHNjcmlwdCBjcmVhdGluZyBhbmQgZmlsbGluZyB0aGUgdGFibGUgYW5kIHJ1bm5p bmcgdGhlIHRlc3QNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQojIS91c3IvYmluL3BlcmwNCg0KdXNlIHN0cmljdDsNCnVz ZSB3YXJuaW5nczsNCnVzZSBEQkk7DQpTVERPVVQtPmF1dG9mbHVzaCgxKTsNCg0KDQojIGdlbmVy YXRlIGFscGhhYmV0IHNpbWlsYXIgdG8gdGhlIG9uZSBpbiB0aGUNCiMgb3JpZ2luYWwgZXJyb3It cHJvbmUgZGF0YWJhc2UNCg0KbXkgQGFscGhhYmV0c3RyaW5nOw0KDQpmb3IgKG15ICRqPTA7ICRq PDM7ICRqKyspIHsNCglmb3IgKG15ICRpPTY1OyAkaTw2NSsyNjsgJGkrKykgew0KCQlwdXNoKEBh bHBoYWJldHN0cmluZywgY2hyKCRpKSk7ICAgICAgICAjIEEtWg0KCQlwdXNoKEBhbHBoYWJldHN0 cmluZywgY2hyKCRpKzk3LTY1KSk7ICAjIGEteg0KCX0NCglmb3IgKG15ICRpPTA7ICRpPDEwOyAk aSsrKSB7DQoJCXB1c2goQGFscGhhYmV0c3RyaW5nLCBjaHIoJGkrNDgpKTsgICAgICMgMC05DQoJ CXB1c2goQGFscGhhYmV0c3RyaW5nLCAnICcpOw0KCX0NCn0NCg0KcHVzaChAYWxwaGFiZXRzdHJp bmcsIHF3KMOkIMO2IMO8IMOEIMOWIMOcICwgOyA6IFsgXSBcKCBcKSAvIC0gPSkpOw0KDQojIGRh dGFiYXNlIGNvbm5lY3Rpb24NCg0KbXkgJGRiaCA9IERCSS0+Y29ubmVjdCgiREJJOlBnOmRibmFt ZT10ZXN0X2dpc3RfaW5kZXg7aG9zdD1YWFhYWCIsCiJ0ZXN0X2dpc3RfaW5kZXgiLCAiWFhYWFgi LCB7J1JhaXNlRXJyb3InID0+IDF9KTsNCiRkYmgtPntwZ19lbmFibGVfdXRmOH0gPSAwOw0KDQoj IChyZSljcmVhdGUgdGVzdCB0YWJsZQ0KDQpteSAkc3RoMSA9ICRkYmgtPnByZXBhcmUoIkRST1Ag VEFCTEUgSUYgRVhJU1RTIG15dGFibGU7IENSRUFURSBUQUJMRSBteXRhYmxlCihhbV9pZCBzZXJp YWwsIGFtX2Rlc2NyaXB0aW9uIHRleHQpOyAiKTsNCiRzdGgxLT5leGVjdXRlKCk7DQoNCiMgZmls bCB0YWJsZSB3aXRoIHJhbmRvbSBzdHJpbmdzIG9mIGFyYml0cmFyeSBsZW5ndGgNCg0KbXkgJHN0 aDIgPSAkZGJoLT5wcmVwYXJlKCJJTlNFUlQgSU5UTyBteXRhYmxlIChhbV9kZXNjcmlwdGlvbikg VkFMVUVTCig/KSIpOw0KDQpmb3IgKG15ICRpPTE7ICRpPD0yMDAwMDA7ICRpKyspIHsNCg0KCW15 ICRzdHJpbmdsZW5ndGggPSBpbnQocmFuZCgxMDAwKSk7DQoJbXkgJG15c3RyaW5nID0gJyc7DQoN Cglmb3IgKG15ICRqPTA7ICRqPD0kc3RyaW5nbGVuZ3RoOyAkaisrKSB7DQoNCgkJbXkgJHJhbmRv bWNoYXIgPSBAYWxwaGFiZXRzdHJpbmdbaW50KHJhbmQoc2NhbGFyIEBhbHBoYWJldHN0cmluZykp XTsNCgkJJG15c3RyaW5nIC49ICRyYW5kb21jaGFyOw0KDQoJfQ0KCSRzdGgyLT5leGVjdXRlKCRt eXN0cmluZyk7DQoJDQoJaWYgKCRpICUgMTAwMCA9PSAwKSB7IHByaW50ICIuIjsgfQ0KCWlmICgk aSAlIDEwMDAwID09IDApIHsgcHJpbnQgIiAtICRpXG4iOyB9DQp9DQoNCiMgdGVzdCBnaXN0IGlu ZGV4IGNyZWF0aW9uDQoNCmZvciAobXkgJGk9MTsgJGk8PTIwOyAkaSsrKSB7DQoJcHJpbnQgIlxu YnVpbGRpbmcgZ2lzdCAkaVxuIjsNCglteSAkc3RoMyA9ICRkYmgtPnByZXBhcmUoIkRST1AgSU5E RVggSUYgRVhJU1RTIGdpc3RfaWR4OyIpOw0KCXByaW50ICRzdGgzLT5leGVjdXRlKCk7DQoNCglt eSAkc3RoNCA9ICRkYmgtPnByZXBhcmUoIkNSRUFURSBJTkRFWCBnaXN0X2lkeCBPTiBwdWJsaWMu bXl0YWJsZSBVU0lORwpnaXN0IChhbV9kZXNjcmlwdGlvbiBwdWJsaWMuZ2lzdF90cmdtX29wcyk7 Iik7DQoJcHJpbnQgJHN0aDQtPmV4ZWN1dGUoKTsNCg0KfQ0KDQpwcmludCAiXG4iOw0KDQokZGJo LT5kaXNjb25uZWN0KCk7Cgo= --===============4061022961852368364==--