Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sXRCO-0042LQ-PE for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Jul 2024 20:05:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sXRCM-00HKck-Vo for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Jul 2024 20:05:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sXQIS-00GjSq-Cj for pgsql-bugs@lists.postgresql.org; Fri, 26 Jul 2024 19:08:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sXQIP-001bIe-IP for pgsql-bugs@lists.postgresql.org; Fri, 26 Jul 2024 19:08:07 +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=K6yw6IqX6d/Zw4cc8gbOAip8rqjsb4OUYLSK55A1uUE=; b=6C6axAiVJUDtkHXBEsPqHGZy2d /BC3kdPpk/tvYaEWkN4hF3ElnotXHnLGTsUKWIkyt0R23okJ4Mb24tdsweAnB0Zqw2bBRUje8UMY5 TN8Nw/yHlfeB13oixJOW9I8OGK5O5jVawAaAUvA9guPTMyu4tA1r+jjHorTuGCZUHQnEvg82jVPEC 3/rMnFJdK2HkMhF2qflwG9hydSMczNlkk6uGKTiQ87zwWQX3cisEX6RAbSaveLfEYgJbO2DGmxQgR OjAdq4yasbvYudp5y6wIeXi6gOTrlxapCPKQbRPq6WZY6tLNGH3PwqzgtG82xRf2sWeFtAXFUBqks OiYNeNBg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sXQIO-0050LW-U5 for pgsql-bugs@lists.postgresql.org; Fri, 26 Jul 2024 19:08:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sXQIM-006rrA-KS for pgsql-bugs@lists.postgresql.org; Fri, 26 Jul 2024 19:08:03 +0000 Content-Type: multipart/mixed; boundary="===============5900411504640881609==" MIME-Version: 1.0 Subject: BUG #18556: Parallel operation error during CREATE TABLE AS statement To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: shaun@tembo.io Reply-To: shaun@tembo.io, pgsql-bugs@lists.postgresql.org Date: Fri, 26 Jul 2024 19:07:52 +0000 Message-ID: <18556-06f52f915c19f7c0@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5900411504640881609== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU1NgpMb2dnZWQgYnk6ICAgICAgICAgIFNoYXVuIFRob21hcwpFbWFp bCBhZGRyZXNzOiAgICAgIHNoYXVuQHRlbWJvLmlvClBvc3RncmVTUUwgdmVyc2lvbjogMTYuMwpP cGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNC40IExUUwpEZXNjcmlwdGlvbjogICAgICAg IAoKV2UgaGF2ZSBiZWVuIHdpdG5lc3NpbmcgYW4gaW50ZXJtaXR0ZW50IGVycm9yIGZyb20gYSBQ b3N0Z3JlcyAxNi4zIGluc3RhbmNlCmlmIGEgdGFibGUgaXMgY3JlYXRlZCB1c2luZyBhIFNFTEVD VCBzdGF0ZW1lbnQuIFRoZSBlcnJvciBpczoNCg0KRVJST1I6IGNhbm5vdCBzdGFydCBjb21tYW5k cyBkdXJpbmcgYSBwYXJhbGxlbCBvcGVyYXRpb24NCg0KVGhlIHN0YXRlbWVudCBpdHNlbGYgaXMg dmVyeSBpbm5vY3VvdXM6DQoNCkNSRUFURSBURU1QIFRBQkxFIHBhcmFsbGVsX2JvbmsgQVMgKA0K ICAgIFNFTEVDVA0KICAgICAgICBkb2N1bWVudF9rZXksDQogICAgICAgIGZ1bGxfZG9jdW1lbnQN CiAgICBGUk9NIHNvbWVfc2NoZW1hLnNvdXJjZV90YWJsZQ0KICAgIFdIRVJFIGRvY3VtZW50X2tl eSAtPj4gJ19pZCcgSU4gKCd4eXonLCAncGRxJykNCik7DQoNCkp1c3QgdG8gZWxpbWluYXRlIHNv bWUgcG90ZW50aWFsIHZhcmlhYmxlcywgdGhpcyBpcyBhIDU0LW1pbGxpb24gcm93IEhFQVAKdGFi bGUgd2l0aCB0aGUgZm9sbG93aW5nIGRlZmluaXRpb246DQoNCiAgICAgICAgICAgICAgQ29sdW1u ICAgICAgICAgICAgICAgfCAgICAgICAgICAgVHlwZSAgICAgICAgICAgfCBDb2xsYXRpb24gfApO dWxsYWJsZSB8IERlZmF1bHQgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0t LQ0KIF9pZCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8IGpzb25iICAgICAgICAgICAg ICAgICAgICB8ICAgICAgICAgICB8Cm5vdCBudWxsIHwgDQogb3BlcmF0aW9uX3R5cGUgICAgICAg ICAgICAgICAgICAgIHwgdGV4dCAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgCiAg ICAgICAgfCANCiBmdWxsX2RvY3VtZW50ICAgICAgICAgICAgICAgICAgICAgfCBqc29uYiAgICAg ICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCAKICAgICAgICB8IA0KIG5zX2RiICAgICAgICAg ICAgICAgICAgICAgICAgICAgICB8IHRleHQgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAg ICB8IAogICAgICAgIHwgDQogbnNfY29sbCAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgdGV4 dCAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgCiAgICAgICAgfCANCiB0b19kYiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgfCB0ZXh0ICAgICAgICAgICAgICAgICAgICAgfCAg ICAgICAgICAgfCAKICAgICAgICB8IA0KIHRvX2NvbGwgICAgICAgICAgICAgICAgICAgICAgICAg ICB8IHRleHQgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IAogICAgICAgIHwgDQog ZG9jdW1lbnRfa2V5ICAgICAgICAgICAgICAgICAgICAgIHwganNvbmIgICAgICAgICAgICAgICAg ICAgIHwgICAgICAgICAgIHwKbm90IG51bGwgfCANCiB1cGRhdGVfZGVzY3JpcHRpb25fdXBkYXRl ZF9maWVsZHMgfCBqc29uYiAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCAKICAgICAg ICB8IA0KIHVwZGF0ZV9kZXNjcmlwdGlvbl9yZW1vdmVkX2ZpZWxkcyB8IHRleHRbXSAgICAgICAg ICAgICAgICAgICB8ICAgICAgICAgICB8IAogICAgICAgIHwgDQogY2x1c3Rlcl90aW1lICAgICAg ICAgICAgICAgICAgICAgIHwganNvbmIgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwg CiAgICAgICAgfCANCiB0eG5fbnVtYmVyICAgICAgICAgICAgICAgICAgICAgICAgfCBiaWdpbnQg ICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCAKICAgICAgICB8IA0KIGxzaWRfaWQgICAg ICAgICAgICAgICAgICAgICAgICAgICB8IHRleHQgICAgICAgICAgICAgICAgICAgICB8ICAgICAg ICAgICB8IAogICAgICAgIHwgDQogbHNpZF91aWQgICAgICAgICAgICAgICAgICAgICAgICAgIHwg dGV4dCAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgCiAgICAgICAgfCANCiBrYWZr YV90b3BpYyAgICAgICAgICAgICAgICAgICAgICAgfCB0ZXh0ICAgICAgICAgICAgICAgICAgICAg fCAgICAgICAgICAgfApub3QgbnVsbCB8IA0KIGthZmthX3BhcnRpdGlvbiAgICAgICAgICAgICAg ICAgICB8IGludGVnZXIgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8Cm5vdCBudWxsIHwg DQoga2Fma2Ffb2Zmc2V0ICAgICAgICAgICAgICAgICAgICAgIHwgYmlnaW50ICAgICAgICAgICAg ICAgICAgIHwgICAgICAgICAgIHwKbm90IG51bGwgfCANCiBrYWZrYV90aW1lc3RhbXAgICAgICAg ICAgICAgICAgICAgfCB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUgfCAgICAgICAgICAgfApub3Qg bnVsbCB8IA0KSW5kZXhlczoNCiAgICAic291cmNlX3RhYmxlX3BrZXkiIFBSSU1BUlkgS0VZLCBi dHJlZSAoZG9jdW1lbnRfa2V5KQ0KICAgICJzb3VyY2VfdGFibGVfa2Fma2Ffb2Zmc2V0X2lkeCIg VU5JUVVFLCBidHJlZSAoa2Fma2Ffb2Zmc2V0IERFU0MpDQoNCk5vdGUgdGhhdCB0aGVyZSBhcmUg bm8gdHJpZ2dlcnMsIHJ1bGVzLCBjb25zdHJhaW50cywgcGFydGl0aW9ucywgb3IgYW55CnBhcmFs bGVsLXVuc2FmZSBlbnRpdGllcyBhc3NvY2lhdGVkIHdpdGggdGhpcyB0YWJsZS4gVGhlIGFzc29j aWF0ZWQgcXVlcnkKcGxhbiBsb29rcyBsaWtlIHRoaXM6DQoNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgICAgICAgICAgICAgICAK ICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEdh dGhlciAgKGNvc3Q9MTAwMC4wMC4uNDA0NTYyNy45MyByb3dzPTU0NDc1MSB3aWR0aD00NzkpDQog ICBXb3JrZXJzIFBsYW5uZWQ6IDgNCiAgIC0+ICBQYXJhbGxlbCBTZXEgU2NhbiBvbiBzb3VyY2Vf dGFibGUgIChjb3N0PTAuMDAuLjM5OTAxNTIuODMgcm93cz02ODA5NAp3aWR0aD00NzkpDQogICAg ICAgICBGaWx0ZXI6ICgoZG9jdW1lbnRfa2V5IC0+PiAnX2lkJzo6dGV4dCkgPSBBTlkKKCd7eHl6 LHBkcX0nOjp0ZXh0W10pKQ0KIEpJVDoNCiAgIEZ1bmN0aW9uczogNA0KICAgT3B0aW9uczogSW5s aW5pbmcgdHJ1ZSwgT3B0aW1pemF0aW9uIHRydWUsIEV4cHJlc3Npb25zIHRydWUsIERlZm9ybWlu Zwp0cnVlDQoNCk5vdGUgdGhhdCB0aGUgcHJvYmxlbSBwZXJzaXN0cyByZWdhcmRsZXNzIG9mIHRo ZSBKSVQgc2V0dGluZy4gVGhpcyBhcHBlYXJzCnRvIGJlIHJlbGF0ZWQgdG8gdGhlIHBhcmFsbGVs IHdvcmtlcnMgaW4gc29tZSBtYW5uZXIuIFdlIGhhdmVuJ3QgYmVlbiBhYmxlCnRvIGRpc3RpbGwg dGhpcyBkb3duIHRvIGEgc2ltcGxlIG9yIHJlbGlhYmxlIHJlcHJvIGNhc2UgeWV0LCBhcyB0aGUg cHJvYmxlbQpzZWVtcyB0byBvY2N1ciBlbnRpcmVseSBhdCByYW5kb20sIHN1Z2dlc3RpbmcgaXQn cyBzb21lIGtpbmQgb2YgcGFyYWxsZWwKb3BlcmF0aW9uIHJhY2UgY29uZGl0aW9uLg0KDQpUaGVy ZSBoYXZlIGJlZW4gb3RoZXIgc2ltaWxhciBkaXNjdXNzaW9ucyByZWdhcmRpbmcgdGhlIGRidCBQ b3N0Z3JlcyBFVEwKdG9vbGtpdC4gSXQgYXBwZWFycyB0aGlzIEVUTCBraXQgdXRpbGl6ZXMgYSBs b2FkaW5nIHByb2NlZHVyZSB0aGF0IGlzIG1vcmUKbGlrZWx5IHRvIHRyaWdnZXIgdGhpcyBlZGdl IGNhc2UuCgo= --===============5900411504640881609==--