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 1iwQva-0003bV-Iv for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Jan 2020 13:29:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iwQvY-0007sY-Jj for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Jan 2020 13:29:12 +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 1iwQvY-0007sR-Bb for pgsql-bugs@lists.postgresql.org; Tue, 28 Jan 2020 13:29:12 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1iwQvQ-0002Ia-Nh for pgsql-bugs@lists.postgresql.org; Tue, 28 Jan 2020 13:29:11 +0000 Content-Type: multipart/mixed; boundary="===============8760958327255912314==" MIME-Version: 1.0 Subject: BUG #16237: When restoring database, backend disconnects or crashes when foreign key is created To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dsnover@electrainfo.com Reply-To: dsnover@electrainfo.com, pgsql-bugs@lists.postgresql.org Date: Tue, 28 Jan 2020 13:28:15 +0000 Message-ID: <16237-4b97757867332823@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8760958327255912314== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjIzNwpMb2dnZWQgYnk6ICAgICAgICAgIERhcnJ5bCBTbm92ZXIKRW1h aWwgYWRkcmVzczogICAgICBkc25vdmVyQGVsZWN0cmFpbmZvLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDEyLjEKT3BlcmF0aW5nIHN5c3RlbTogICBNYWMgT1MgQ2F0YWxpbmEgMTAuMTUuMiwgRURC IEluc3RhbGwgSW1hZ2UKRGVzY3JpcHRpb246ICAgICAgICAKCldoZW4gcmVzdG9yaW5nIGEgZnVs bCBkYXRhYmFzZSBkdW1wIChwc3FsIC1mIGZpbGVuYW1lKSwgb24gb25lIG9mIHRoZSB0aHJlZQpk YXRhYmFzZXMsIHdoZW4gcmVzdG9yaW5nLCB0aGlzIGVycm9yIGlzIG9jY3VycmluZy4gIElzIHJl cGVhdGFibGUgb24gYQpkaWZmZXJlbnQgTWFjLiAgTWFjaW50b3NoIG1vZGVsczogIE1hY0Jvb2sg UHJvIDE2LCBjbGVhbiBPUyBpbnN0YWxsZWQsIG5ldwptYWNoaW5lLiAgQWxzbyByYW4gb24gMjAx MiBNYWMgTWluaSBTZXJ2ZXIsIHdpdGggTWFjIE9TIFggTW9qYXZlIDEwLjE0LCB3aXRoCnNhbWUg ZXJyb3JzLg0KDQpNYW51YWxseSBjcmVhdGluZyB0aGUgY29uc3RyYWludCBvciBhbnkgc2ltaWxh ciBjb25zdHJhaW50IGNhdXNlcyB0aGUgc2FtZQpmYWlsdXJlLg0KDQpMb2c6DQoNCnBnX3Jlc3Rv cmU6IGNyZWF0aW5nIEZLIENPTlNUUkFJTlQKInB1YmxpYy5maWxlX3RyYW5zaXRfdHJhbnNhY3Rp b25fZmlsZV90cmFuc2l0X2lkX2ZrZXkiDQpwZ19yZXN0b3JlOiBmcm9tIFRPQyBlbnRyeSAzOTcy OyAyNjA2IDQxNzc3OTIgRksgQ09OU1RSQUlOVApmaWxlX3RyYW5zaXRfdHJhbnNhY3Rpb25fZmls ZV90cmFuc2l0X2lkX2ZrZXkgcG9zdGdyZXMNCnBnX3Jlc3RvcmU6IGVycm9yOiBjb3VsZCBub3Qg ZXhlY3V0ZSBxdWVyeTogc2VydmVyIGNsb3NlZCB0aGUgY29ubmVjdGlvbgp1bmV4cGVjdGVkbHkN CglUaGlzIHByb2JhYmx5IG1lYW5zIHRoZSBzZXJ2ZXIgdGVybWluYXRlZCBhYm5vcm1hbGx5DQoJ YmVmb3JlIG9yIHdoaWxlIHByb2Nlc3NpbmcgdGhlIHJlcXVlc3QuDQpDb21tYW5kIHdhczogQUxU RVIgVEFCTEUgT05MWSBmaWxlX3RyYW5zaXRfdHJhbnNhY3Rpb24NCiAgICBBREQgQ09OU1RSQUlO VCBmaWxlX3RyYW5zaXRfdHJhbnNhY3Rpb25fZmlsZV90cmFuc2l0X2lkX2ZrZXkgRk9SRUlHTiBL RVkKKGZpbGVfdHJhbnNpdF9pZCkgUkVGRVJFTkNFUyBmaWxlX3RyYW5zaXQoZmlsZV90cmFuc2l0 X2lkKTsNCg0KQ1JBU0ggUkVQT1JUIEVYQU1QRSAoYWxsIGFyZSBpZGVudGljYWwgaW4gdGhhdCB0 aGV5IGFsbCBzaG93IHNhbWUgZXhjZXB0aW9uCnR5cGUpLg0KDQpQcm9jZXNzOiAgICAgICAgICAg ICAgIHBvc3RncmVzIFs4OTg0XQ0KUGF0aDogICAgICAgICAgICAgICAgICAvVXNlcnMvVVNFUi8q L3Bvc3RncmVzDQpJZGVudGlmaWVyOiAgICAgICAgICAgIHBvc3RncmVzDQpWZXJzaW9uOiAgICAg ICAgICAgICAgID8/Pw0KQ29kZSBUeXBlOiAgICAgICAgICAgICBYODYtNjQgKE5hdGl2ZSkNClBh cmVudCBQcm9jZXNzOiAgICAgICAgcG9zdGdyZXMgWzYzOTZdDQpSZXNwb25zaWJsZTogICAgICAg ICAgIHBvc3RncmVzIFs2Mzk2XQ0KVXNlciBJRDogICAgICAgICAgICAgICA1MDMNCg0KRGF0ZS9U aW1lOiAgICAgICAgICAgICAyMDIwLTAxLTI1IDE1OjExOjM1LjU4NSAtMDUwMA0KT1MgVmVyc2lv bjogICAgICAgICAgICBNYWMgT1MgWCAxMC4xNS4yICgxOUM1NykNClJlcG9ydCBWZXJzaW9uOiAg ICAgICAgMTINCkJyaWRnZSBPUyBWZXJzaW9uOiAgICAgNC4yICgxN1AyNTUxKQ0KQW5vbnltb3Vz IFVVSUQ6ICAgICAgICBDOEU3NTc5OS01QkJBLTBFMDUtQjA0Ri1CNkFERTFENzIxNTgNCg0KU2xl ZXAvV2FrZSBVVUlEOiAgICAgICA3MDM5MkI1My1ERjVBLTQwOEYtOTlDQS00M0U1OEEwQ0UzMTIN Cg0KVGltZSBBd2FrZSBTaW5jZSBCb290OiAyNzAwMCBzZWNvbmRzDQpUaW1lIFNpbmNlIFdha2U6 ICAgICAgIDM1MDAgc2Vjb25kcw0KDQpTeXN0ZW0gSW50ZWdyaXR5IFByb3RlY3Rpb246IGVuYWJs ZWQNCg0KQ3Jhc2hlZCBUaHJlYWQ6ICAgICAgICAwICBEaXNwYXRjaCBxdWV1ZTogY29tLmFwcGxl Lm1haW4tdGhyZWFkDQoNCkV4Y2VwdGlvbiBUeXBlOiAgICAgICAgRVhDX0JBRF9BQ0NFU1MgKENv ZGUgU2lnbmF0dXJlIEludmFsaWQpDQpFeGNlcHRpb24gQ29kZXM6ICAgICAgIDB4MDAwMDAwMDAw MDAwMDAzMiwgMHgwMDAwMDAwMTBkZDAwMmQwDQpFeGNlcHRpb24gTm90ZTogICAgICAgIEVYQ19D T1JQU0VfTk9USUZZDQoNClRlcm1pbmF0aW9uIFJlYXNvbjogICAgTmFtZXNwYWNlIENPREVTSUdO SU5HLCBDb2RlIDB4Mg0KDQprZXJuZWwgbWVzc2FnZXM6DQoNClZNIFJlZ2lvbnMgTmVhciAweDEw ZGQwMDJkMDoNCiAgICBWTV9BTExPQ0FURSAgICAgICAgICAgIDAwMDAwMDAxMGRjZmYwMDAtMDAw MDAwMDEwZGQwMDAwMCBbICAgIDRLXQpyLXgvcnd4IFNNPVBSViAgDQotLT4gVk1fQUxMT0NBVEUg ICAgICAgICAgICAwMDAwMDAwMTBkZDAwMDAwLTAwMDAwMDAxMGRkMDEwMDAgWyAgICA0S10Kci14 L3J3eCBTTT1QUlYgIA0KICAgIF9fVEVYVCAgICAgICAgICAgICAgICAgMDAwMDAwMDEwZGQwMTAw MC0wMDAwMDAwMTBkZDhkMDAwIFsgIDU2MEtdCnIteC9yd3ggU009Q09XICAvVXNlcnMvVVNFUi8q LyouZHlsaWINCg0KQXBwbGljYXRpb24gU3BlY2lmaWMgSW5mb3JtYXRpb246DQpjcmFzaGVkIG9u IGNoaWxkIHNpZGUgb2YgZm9yayBwcmUtZXhlYw0KDQpUaHJlYWQgMCBDcmFzaGVkOjogRGlzcGF0 Y2ggcXVldWU6IGNvbS5hcHBsZS5tYWluLXRocmVhZA0KMCAgID8/PyAgICAgICAgICAgICAgICAg ICAgICAgICAgIAkweDAwMDAwMDAxMGRkMDAyZDAgMCArIDQ1MjY3MDMzMTINCjEgICBwb3N0bWFz dGVyICAgICAgICAgICAgICAgICAgICAJMHgwMDAwMDAwMTBkNTYwYTc0IEV4ZWNTY2FuICsgNDUy CihleGVjU2Nhbi5jOjIyOCkNCjIgICBwb3N0bWFzdGVyICAgICAgICAgICAgICAgICAgICAJMHgw MDAwMDAwMTBkNTc0NDVkIEV4ZWNIYXNoSm9pbiArIDEwNjkKKG5vZGVIYXNoam9pbi5jOjI2MikN CjMgICBwb3N0bWFzdGVyICAgICAgICAgICAgICAgICAgICAJMHgwMDAwMDAwMTBkNTU4ZDBmIHN0 YW5kYXJkX0V4ZWN1dG9yUnVuICsKMjg3IChleGVjTWFpbi5jOjE2NTIpDQo0ICAgcG9zdG1hc3Rl ciAgICAgICAgICAgICAgICAgICAgCTB4MDAwMDAwMDEwZDU4YmM1MiBfU1BJX2V4ZWN1dGVfcGxh biArCjEzNDYgKHNwaS5jOjI1MjMpDQo1ICAgcG9zdG1hc3RlciAgICAgICAgICAgICAgICAgICAg CTB4MDAwMDAwMDEwZDU4YzJiYSBTUElfZXhlY3V0ZV9zbmFwc2hvdCArCjI5OCAoc3BpLmM6NjE2 KQ0KNiAgIHBvc3RtYXN0ZXIgICAgICAgICAgICAgICAgICAgIAkweDAwMDAwMDAxMGQ3ODM5OTMg UklfSW5pdGlhbF9DaGVjayArCjIwOTkgKHJpX3RyaWdnZXJzLmM6MTQ4OCkNCjcgICBwb3N0bWFz dGVyICAgICAgICAgICAgICAgICAgICAJMHgwMDAwMDAwMTBkNTIyZGYyCnZhbGlkYXRlRm9yZWln bktleUNvbnN0cmFpbnQgKyAyMTAgKHRhYmxlY21kcy5jOjk3ODQpDQo4ICAgcG9zdG1hc3RlciAg ICAgICAgICAgICAgICAgICAgCTB4MDAwMDAwMDEwZDUxZDRiMCBBVENvbnRyb2xsZXIgKyAxNjY0 Cih0YWJsZWNtZHMuYzo0NzE1KQ0KOSAgIHBvc3RtYXN0ZXIgICAgICAgICAgICAgICAgICAgIAkw eDAwMDAwMDAxMGQ2YzBhMjkgUHJvY2Vzc1V0aWxpdHlTbG93ICsKMjcxMyAodXRpbGl0eS5jOjEx MzEpDQoxMCAgcG9zdG1hc3RlciAgICAgICAgICAgICAgICAgICAgCTB4MDAwMDAwMDEwZDZiZjUx NwpzdGFuZGFyZF9Qcm9jZXNzVXRpbGl0eSArIDE5NzUgKHV0aWxpdHkuYzo5MzMpDQoxMSAgcG9z dG1hc3RlciAgICAgICAgICAgICAgICAgICAgCTB4MDAwMDAwMDEwZDZiZWEyZiBQb3J0YWxSdW5V dGlsaXR5ICsgMTU5CihwcXVlcnkuYzoxMTg0KQ0KMTIgIHBvc3RtYXN0ZXIgICAgICAgICAgICAg ICAgICAgIAkweDAwMDAwMDAxMGQ2YmUwNGEgUG9ydGFsUnVuTXVsdGkgKyAyMzQKKHBxdWVyeS5j OjEzMjgpDQoxMyAgcG9zdG1hc3RlciAgICAgICAgICAgICAgICAgICAgCTB4MDAwMDAwMDEwZDZi ZGE2NyBQb3J0YWxSdW4gKyA1MTkKKHBxdWVyeS5jOjgwMCkNCjE0ICBwb3N0bWFzdGVyICAgICAg ICAgICAgICAgICAgICAJMHgwMDAwMDAwMTBkNmJjYTU1IGV4ZWNfc2ltcGxlX3F1ZXJ5ICsKMTQ0 NSAocG9zdGdyZXMuYzoxMjIzKQ0KMTUgIHBvc3RtYXN0ZXIgICAgICAgICAgICAgICAgICAgIAkw eDAwMDAwMDAxMGQ2YmE4ZGQgUG9zdGdyZXNNYWluICsgMzkwMQoocG9zdGdyZXMuYzo0MjM4KQ0K MTYgIHBvc3RtYXN0ZXIgICAgICAgICAgICAgICAgICAgIAkweDAwMDAwMDAxMGQ2M2I1YTggUG9z dG1hc3Rlck1haW4gKyA3ODMyCihwb3N0bWFzdGVyLmM6MjQ1OCkNCjE3ICBwb3N0bWFzdGVyICAg ICAgICAgICAgICAgICAgICAJMHgwMDAwMDAwMTBkNWE4NGFlIG1haW4gKyAxNjc4DQoxOCAgbGli ZHlsZC5keWxpYiAgICAgICAgICAgICAgICAgCTB4MDAwMDdmZmY2ODFmMjdmZCBzdGFydCArIDEN Cg0KVGhyZWFkIDAgY3Jhc2hlZCB3aXRoIFg4NiBUaHJlYWQgU3RhdGUgKDY0LWJpdCk6DQogIHJh eDogMHgwMDAwMDAwMTBkZDAwMmQwICByYng6IDB4MDAwMDdmYzVmZjA1YjU4MCAgcmN4OiAweDAw MDAwMDAxMjc5YjM4ZDggCnJkeDogMHgwMDAwN2ZmZWUyODUwYWE2DQogIHJkaTogMHgwMDAwN2Zj NWZmMDVjMzIwICByc2k6IDB4MDAwMDdmYzVmZjA1YjU4MCAgcmJwOiAweDAwMDA3ZmZlZTI4NTBh ZDAgCnJzcDogMHgwMDAwN2ZmZWUyODUwYTc4DQogICByODogMHgwMDAwMDAwMDAwMDQ4NTBkICAg cjk6IDB4ZmZmZmZmZmYwMDAwMDAwMCAgcjEwOiAweDAwMDAwMDAxMjc5YjM4ZDAgCnIxMTogMHgw MDAwMDAwMDAwMDAwMDAwDQogIHIxMjogMHgwMDAwN2ZjNWZmMDVjMzIwICByMTM6IDB4MDAwMDAw MDEwZGEyNDIyMCAgcjE0OiAweDAwMDA3ZmM1ZmYwNWI2MzAgCnIxNTogMHgwMDAwN2ZjNWZmMDVi NDcwDQogIHJpcDogMHgwMDAwMDAwMTBkZDAwMmQwICByZmw6IDB4MDAwMDAwMDAwMDAxMDI0NiAg Y3IyOiAweDAwMDAwMDAxMGRkMDAyZDAKCg== --===============8760958327255912314==--