Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l2iSN-0007yl-Oq for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Jan 2021 22:29:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l2iRq-0004m7-P6 for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Jan 2021 22:29:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l2iGM-0001ts-89 for pgsql-bugs@lists.postgresql.org; Thu, 21 Jan 2021 22:17:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l2iGJ-0000Xb-DV for pgsql-bugs@lists.postgresql.org; Thu, 21 Jan 2021 22:17:09 +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=CTuyijL4I92z7yQSX8UG5cr7Z3OGSWCEz/eQN6ZOTak=; b=gj2unvUsRWU6yGNvkjzkKoNYXF atwF/Ws18zY+AQ+bXuCzdssH/UpnxWERqiltyTCrG/DhfCGnuUALW/fh34sGxHoVRbx5Aw164pa4K cKzuZWDrnNQgVAUpn69IjikC6F7O/MFo4bqL4RWQ3ehj1DN08du29nD+SzKa3qCqWBFoQl4aDqG6J d3hSk9QljOKlnU5Luwy5IczzfAa+sLndNVkO0Q7z5WMnBVA5JZZWiS/Gw1CrUP8y16mbUKov54diG U+KURcxxyvJ3wNy6paszeLoZamCPrz9+F+LCtAJQ59ySOkXph1PLNufIl9UugnCFkHd8q12ArIa/w P5nek1og==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l2iGH-0001we-B5 for pgsql-bugs@lists.postgresql.org; Thu, 21 Jan 2021 22:17:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l2iGE-0006hm-Tu for pgsql-bugs@lists.postgresql.org; Thu, 21 Jan 2021 22:17:02 +0000 Content-Type: multipart/mixed; boundary="===============9087088397679448449==" MIME-Version: 1.0 Subject: BUG #16832: Interrupted system call when working with large data tables To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kimon.krenz@part9.com Reply-To: kimon.krenz@part9.com, pgsql-bugs@lists.postgresql.org Date: Thu, 21 Jan 2021 22:16:55 +0000 Message-ID: <16832-943d33fd58eb26e4@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============9087088397679448449== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjgzMgpMb2dnZWQgYnk6ICAgICAgICAgIEtpbW9uIEtyZW56CkVtYWls IGFkZHJlc3M6ICAgICAga2ltb24ua3JlbnpAcGFydDkuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTMuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIG1hY09TIEJpZyBTdXIgdi4gMTEuMC4xCkRlc2NyaXB0 aW9uOiAgICAgICAgCgpJJ3ZlIHJlY2VudGx5IHVwZGF0ZWQgbWFjT1MgdG8gQmlnIFN1ciwgYW5k IHNpbXVsdGFuZW91c2x5IHRvIFBvc3RncmVTUUwKMTMuMS4NClNpbmNlIHRoZXNlIHVwZGF0ZXMg UG9zdGdyZVNRTCBrZWVwcyB0aHJvd2luZyAnSW50ZXJydXB0ZWQgc3lzdGVtIGNhbGwnCmVycm9y cyBpbiB0aHJlZSBpbnN0YW5jZXMsIHdoaWNoIHByb2R1Y2Ugc2ltaWxhciAnY291bGQgbm90IG9w ZW4gZmlsZQpwZ193YWwvIiBlcnJvcnMgKHNlZSBiZWxvdyAxLiwyLiBhbmQgMy4pLg0KVGhlIHBy b2JsZW0gbWlnaHQgYmUgbGlua2VkIHRvIEJVRyAjMTY4Mjc6IG1hY09TIGludGVycnVwdGVkIHN5 c2NhbGwgbGVhZHMKdG8gYSBjcmFzaC4NCg0KVW5mb3J0dW5hdGVseSwgdGhlICdJbnRlcnJ1cHRl ZCBzeXN0ZW0gY2FsbCcgZXJyb3Igb2NjdXJzIGZyZXF1ZW50bHksIGJ1dAppbmNvbnNpc3RlbnRs eSB3aGVuIHVzaW5nIHRoZSBzYW1lIHRhYmxlLiBUaGUgb25seSBjb21tb24gZGVtb25pbmF0b3Ig aXMKdGhhdCB0aGUgZXJyb3IgbW9yZSBmcmVxdWVudCB3aGVuIGxhcmdlIHRhYmxlcyBpLmUuICs0 R0IgYXJlIGVtcGxveWVkLiBJCmhhdmUgdW5zdWNjZXNmdWxseSBzcGVuZCBzb21ldGltZSBvbiBh IHJlcHJvZHVjYWJsZSBjYXNlLCB0aGlzIGlzIG1haW5seQpiZWNhdXNlIHRoZSBzYW1lIHRhYmxl IGRvZXMgbm90IGFsd2F5cyBsZWFkIHRvIGFuIGVycm9yLg0KDQoxLiBXaGVuIFZBQ1VVTSBGVUxM IG9uIGVudGlyZSBkYXRhYmFzZSBvciBzaW5nbGUgbGFyZ2UgdGFibGVzOiANCg0KdGVybWluYWwg Y29tbWFuZDoNCg0KdWRsPSMgVkFDVVVNIChGVUxMLFZFUkJPU0UpOw0KSU5GTzogIHZhY3V1bWlu ZyAiaXRuXzIwMDcucm9hZGxpbmtfbXMiDQpJTkZPOiAgInJvYWRsaW5rX21zIjogZm91bmQgMCBy ZW1vdmFibGUsIDQwMDUyMjMgbm9ucmVtb3ZhYmxlIHJvdyB2ZXJzaW9ucwppbiAyNzkwNDYgcGFn ZXMNCkRFVEFJTDogIDAgZGVhZCByb3cgdmVyc2lvbnMgY2Fubm90IGJlIHJlbW92ZWQgeWV0Lg0K Q1BVOiB1c2VyOiA2LjAzIHMsIHN5c3RlbTogMTEuNjEgcywgZWxhcHNlZDogMzYuNTYgcy4NCldB Uk5JTkc6ICB0ZXJtaW5hdGluZyBjb25uZWN0aW9uIGJlY2F1c2Ugb2YgY3Jhc2ggb2YgYW5vdGhl ciBzZXJ2ZXIKcHJvY2Vzcw0KREVUQUlMOiAgVGhlIHBvc3RtYXN0ZXIgaGFzIGNvbW1hbmRlZCB0 aGlzIHNlcnZlciBwcm9jZXNzIHRvIHJvbGwgYmFjayB0aGUKY3VycmVudCB0cmFuc2FjdGlvbiBh bmQgZXhpdCwgYmVjYXVzZSBhbm90aGVyIHNlcnZlciBwcm9jZXNzIGV4aXRlZAphYm5vcm1hbGx5 IGFuZCBwb3NzaWJseSBjb3JydXB0ZWQgc2hhcmVkIG1lbW9yeS4NCkhJTlQ6ICBJbiBhIG1vbWVu dCB5b3Ugc2hvdWxkIGJlIGFibGUgdG8gcmVjb25uZWN0IHRvIHRoZSBkYXRhYmFzZSBhbmQKcmVw ZWF0IHlvdXIgY29tbWFuZC4NCnNlcnZlciBjbG9zZWQgdGhlIGNvbm5lY3Rpb24gdW5leHBlY3Rl ZGx5DQoJVGhpcyBwcm9iYWJseSBtZWFucyB0aGUgc2VydmVyIHRlcm1pbmF0ZWQgYWJub3JtYWxs eQ0KCWJlZm9yZSBvciB3aGlsZSBwcm9jZXNzaW5nIHRoZSByZXF1ZXN0Lg0KVGhlIGNvbm5lY3Rp b24gdG8gdGhlIHNlcnZlciB3YXMgbG9zdC4gQXR0ZW1wdGluZyByZXNldDogRmFpbGVkLg0KIT8+ IA0KDQpwb3N0Z3Jlcy5sb2c6DQoyMDIxLTAxLTIxIDIxOjE0OjQ1LjQ3MCBHTVQgWzU4NjkxXSBQ QU5JQzogIFhYMDAwOiBjb3VsZCBub3Qgb3BlbiBmaWxlCiJwZ193YWwvMDAwMDAwMDEwMDAwMDBB QzAwMDAwMDQ1IjogSW50ZXJydXB0ZWQgc3lzdGVtIGNhbGwNCjIwMjEtMDEtMjEgMjE6MTQ6NDUu NDcwIEdNVCBbNTg2OTFdIExPQ0FUSU9OOiAgWExvZ0ZpbGVJbml0LCB4bG9nLmM6MzI3Nw0KMjAy MS0wMS0yMSAyMToxNDo0NS40NzEgR01UIFszMTA4M10gTE9HOiAgMDAwMDA6IFdBTCB3cml0ZXIg cHJvY2VzcyAoUElECjU4NjkxKSB3YXMgdGVybWluYXRlZCBieSBzaWduYWwgNjogQWJvcnQgdHJh cDogNg0KMjAyMS0wMS0yMSAyMToxNDo0NS40NzEgR01UIFszMTA4M10gTE9DQVRJT046ICBMb2dD aGlsZEV4aXQsCnBvc3RtYXN0ZXIuYzozNzUzDQoyMDIxLTAxLTIxIDIxOjE0OjQ1LjQ3MSBHTVQg WzMxMDgzXSBMT0c6ICAwMDAwMDogdGVybWluYXRpbmcgYW55IG90aGVyCmFjdGl2ZSBzZXJ2ZXIg cHJvY2Vzc2VzDQoyMDIxLTAxLTIxIDIxOjE0OjQ1LjQ3MSBHTVQgWzMxMDgzXSBMT0NBVElPTjog IEhhbmRsZUNoaWxkQ3Jhc2gsCnBvc3RtYXN0ZXIuYzozNDc0DQoyMDIxLTAxLTIxIDIxOjE0OjQ1 LjQ3MSBHTVQgWzU4OTkzXSBXQVJOSU5HOiAgNTdQMDI6IHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24K YmVjYXVzZSBvZiBjcmFzaCBvZiBhbm90aGVyIHNlcnZlciBwcm9jZXNzDQoyMDIxLTAxLTIxIDIx OjE0OjQ1LjQ3MSBHTVQgWzU4OTkzXSBERVRBSUw6ICBUaGUgcG9zdG1hc3RlciBoYXMgY29tbWFu ZGVkCnRoaXMgc2VydmVyIHByb2Nlc3MgdG8gcm9sbCBiYWNrIHRoZSBjdXJyZW50IHRyYW5zYWN0 aW9uIGFuZCBleGl0LCBiZWNhdXNlCmFub3RoZXIgc2VydmVyIHByb2Nlc3MgZXhpdGVkIGFibm9y bWFsbHkgYW5kIHBvc3NpYmx5IGNvcnJ1cHRlZCBzaGFyZWQKbWVtb3J5Lg0KMjAyMS0wMS0yMSAy MToxNDo0NS40NzEgR01UIFs1ODk5M10gSElOVDogIEluIGEgbW9tZW50IHlvdSBzaG91bGQgYmUg YWJsZSB0bwpyZWNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlIGFuZCByZXBlYXQgeW91ciBjb21tYW5k Lg0KMjAyMS0wMS0yMSAyMToxNDo0NS40NzEgR01UIFs1ODk5M10gTE9DQVRJT046ICBxdWlja2Rp ZSwgcG9zdGdyZXMuYzoyODAyDQoyMDIxLTAxLTIxIDIxOjE0OjQ1LjQ3MSBHTVQgWzU5Njk3XSBX QVJOSU5HOiAgNTdQMDI6IHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24KYmVjYXVzZSBvZiBjcmFzaCBv ZiBhbm90aGVyIHNlcnZlciBwcm9jZXNzDQoyMDIxLTAxLTIxIDIxOjE0OjQ1LjQ3MSBHTVQgWzU5 Njk3XSBERVRBSUw6ICBUaGUgcG9zdG1hc3RlciBoYXMgY29tbWFuZGVkCnRoaXMgc2VydmVyIHBy b2Nlc3MgdG8gcm9sbCBiYWNrIHRoZSBjdXJyZW50IHRyYW5zYWN0aW9uIGFuZCBleGl0LCBiZWNh dXNlCmFub3RoZXIgc2VydmVyIHByb2Nlc3MgZXhpdGVkIGFibm9ybWFsbHkgYW5kIHBvc3NpYmx5 IGNvcnJ1cHRlZCBzaGFyZWQKbWVtb3J5Lg0KDQpPUg0KDQoyMDIxLTAxLTIxIDIxOjUxOjUxLjA5 MyBHTVQgWzYwMTA2XSBQQU5JQzogIFhYMDAwOiBjb3VsZCBub3Qgb3BlbiBmaWxlCiJwZ193YWwv MDAwMDAwMDEwMDAwMDBCNzAwMDAwMDc5IjogSW50ZXJydXB0ZWQgc3lzdGVtIGNhbGwNCjIwMjEt MDEtMjEgMjE6NTE6NTEuMDkzIEdNVCBbNjAxMDZdIExPQ0FUSU9OOiAgWExvZ0ZpbGVJbml0LCB4 bG9nLmM6MzI3Nw0KMjAyMS0wMS0yMSAyMTo1MTo1MS4wOTQgR01UIFszMTA4M10gTE9HOiAgMDAw MDA6IFdBTCB3cml0ZXIgcHJvY2VzcyAoUElECjYwMTA2KSB3YXMgdGVybWluYXRlZCBieSBzaWdu YWwgNjogQWJvcnQgdHJhcDogNg0KMjAyMS0wMS0yMSAyMTo1MTo1MS4wOTQgR01UIFszMTA4M10g TE9DQVRJT046ICBMb2dDaGlsZEV4aXQsCnBvc3RtYXN0ZXIuYzozNzUzDQoyMDIxLTAxLTIxIDIx OjUxOjUxLjA5NCBHTVQgWzMxMDgzXSBMT0c6ICAwMDAwMDogdGVybWluYXRpbmcgYW55IG90aGVy CmFjdGl2ZSBzZXJ2ZXIgcHJvY2Vzc2VzDQoyMDIxLTAxLTIxIDIxOjUxOjUxLjA5NCBHTVQgWzMx MDgzXSBMT0NBVElPTjogIEhhbmRsZUNoaWxkQ3Jhc2gsCnBvc3RtYXN0ZXIuYzozNDc0DQoyMDIx LTAxLTIxIDIxOjUxOjUxLjA5NSBHTVQgWzYwMjI4XSBXQVJOSU5HOiAgNTdQMDI6IHRlcm1pbmF0 aW5nIGNvbm5lY3Rpb24KYmVjYXVzZSBvZiBjcmFzaCBvZiBhbm90aGVyIHNlcnZlciBwcm9jZXNz DQoyMDIxLTAxLTIxIDIxOjUxOjUxLjA5NSBHTVQgWzYwMjI4XSBERVRBSUw6ICBUaGUgcG9zdG1h c3RlciBoYXMgY29tbWFuZGVkCnRoaXMgc2VydmVyIHByb2Nlc3MgdG8gcm9sbCBiYWNrIHRoZSBj dXJyZW50IHRyYW5zYWN0aW9uIGFuZCBleGl0LCBiZWNhdXNlCmFub3RoZXIgc2VydmVyIHByb2Nl c3MgZXhpdGVkIGFibm9ybWFsbHkgYW5kIHBvc3NpYmx5IGNvcnJ1cHRlZCBzaGFyZWQKbWVtb3J5 Lg0KMjAyMS0wMS0yMSAyMTo1MTo1MS4wOTUgR01UIFs2MDIyOF0gSElOVDogIEluIGEgbW9tZW50 IHlvdSBzaG91bGQgYmUgYWJsZSB0bwpyZWNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlIGFuZCByZXBl YXQgeW91ciBjb21tYW5kLg0KMjAyMS0wMS0yMSAyMTo1MTo1MS4wOTUgR01UIFs2MDIyOF0gTE9D QVRJT046ICBxdWlja2RpZSwgcG9zdGdyZXMuYzoyODAyDQoNCjIuIFdoZW4gcGVyZm9ybWluZyBh IHNpbXBsZSBpbm5lciBqb2luICh0YWJsZTEgNC41R0IsIHRhYmxlMiA5MDBNQik6DQoNCnVkbD0j IGRyb3AgdGFibGUgaWYgZXhpc3RzIGl0bl8yMDE5LnJvYWRsaW5rX21zbl8yOw0KCWNyZWF0ZSB0 YWJsZSBpdG5fMjAxOS5yb2FkbGlua19tc25fMiBhcw0KCXNlbGVjdCAqDQoJZnJvbSANCglpdG5f MjAxOS5yb2FkbGlua19tcyBsZWZ0IGpvaW4gaXRuXzIwMTkucm9hZF9uYW1lcw0KCU9OIGZpZCA9 IGZpZDI7DQoNCg0KMjAyMS0wMS0yMSAyMTowMTo1MS41NDUgR01UIFs1ODcxMV0gRVJST1I6ICBY WDAwMDogY291bGQgbm90IG9wZW4gdGVtcG9yYXJ5CmZpbGUgImJhc2UvcGdzcWxfdG1wL3Bnc3Fs X3RtcDU4NzExLjAuc2hhcmVkZmlsZXNldC9pMm9mMTI4LnAwLjAiOgpJbnRlcnJ1cHRlZCBzeXN0 ZW0gY2FsbA0KMjAyMS0wMS0yMSAyMTowMTo1MS41NDUgR01UIFs1ODcxMV0gTE9DQVRJT046ICBQ YXRoTmFtZU9wZW5UZW1wb3JhcnlGaWxlLApmZC5jOjE3NjQNCjIwMjEtMDEtMjEgMjE6MDE6NTEu NTQ1IEdNVCBbNTg3MTFdIFNUQVRFTUVOVDogIGRyb3AgdGFibGUgaWYgZXhpc3RzCml0bl8yMDE5 LnJvYWRsaW5rX21zbl8yOw0KCWNyZWF0ZSB0YWJsZSBpdG5fMjAxOS5yb2FkbGlua19tc25fMiBh cw0KCXNlbGVjdCAqDQoJZnJvbSANCglpdG5fMjAxOS5yb2FkbGlua19tcyBsZWZ0IGpvaW4gaXRu XzIwMTkucm9hZF9uYW1lcw0KCU9OIGZpZCA9IGZpZDI7DQoyMDIxLTAxLTIxIDIxOjAxOjUxLjU0 NiBHTVQgWzU5Mjc2XSBFUlJPUjogIFhYMDAwOiBjb3VsZCBub3Qgb3BlbiB0ZW1wb3JhcnkKZmls ZSAiYmFzZS9wZ3NxbF90bXAvcGdzcWxfdG1wNTg3MTEuMC5zaGFyZWRmaWxlc2V0L2kxb2YxMjgu cDIuMCI6CkludGVycnVwdGVkIHN5c3RlbSBjYWxsDQoyMDIxLTAxLTIxIDIxOjAxOjUxLjU0NiBH TVQgWzU5Mjc2XSBMT0NBVElPTjogIFBhdGhOYW1lT3BlblRlbXBvcmFyeUZpbGUsCmZkLmM6MTc2 NA0KMjAyMS0wMS0yMSAyMTowMTo1MS41NDYgR01UIFs1OTI3Nl0gU1RBVEVNRU5UOiAgZHJvcCB0 YWJsZSBpZiBleGlzdHMKaXRuXzIwMTkucm9hZGxpbmtfbXNuXzI7DQoJY3JlYXRlIHRhYmxlIGl0 bl8yMDE5LnJvYWRsaW5rX21zbl8yIGFzDQoJc2VsZWN0ICoNCglmcm9tIA0KCWl0bl8yMDE5LnJv YWRsaW5rX21zIGxlZnQgam9pbiBpdG5fMjAxOS5yb2FkX25hbWVzDQoJT04gZmlkID0gZmlkMjsN CjIwMjEtMDEtMjEgMjE6MDE6NTEuNTQ4IEdNVCBbMzEwODNdIExPRzogIDAwMDAwOiBiYWNrZ3Jv dW5kIHdvcmtlciAicGFyYWxsZWwKd29ya2VyIiAoUElEIDU5Mjc2KSBleGl0ZWQgd2l0aCBleGl0 IGNvZGUgMQ0KMjAyMS0wMS0yMSAyMTowMTo1MS41NDggR01UIFszMTA4M10gTE9DQVRJT046ICBM b2dDaGlsZEV4aXQsCnBvc3RtYXN0ZXIuYzozNzMxDQoNCjMuIFdoZW4gcmVzdG9yaW5nIGVudGly ZSBkYXRhYmFzZSAoMTUwR0IpIHVzaW5nIHBnX3Jlc3RvcmUuIEkgZW5kZWQgdXAKcmVzdG9yaW5n IGV2ZXJ5IHRhYmxlIG1hbnVhbGx5IGZyb20gdGhlIGR1bXAgdGFyIGZpbGUsIGFzIHRoZSBzYW1l IHRhYmxlCnNvbWV0aW1lcyByZXN0b3JlZCB3aXRob3V0IGEgcHJvYmxlbSBhbmQgc29tZXRpbWVz IHRocmV3IGZpcnN0IGFuCidJbnRlcnJ1cHRlZCBzeXN0ZW0gY2FsbCcgZXJyb3IsIGJ1dCB0aGUg c2Vjb25kIG9yIHRoaXJkIHRpbWUgd2FzIHJlc3RvcmVkCndpdGhvdXQgcHJvYmxlbXMuDQoNCkJl c3QsDQpLaW1vbgoK --===============9087088397679448449==--