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 1qr6ho-002a9H-JX for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Oct 2023 01:11:08 +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 1qr6hm-00Cgmu-B2 for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Oct 2023 01:11:07 +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 1qr6Ie-00CWFi-28 for pgsql-bugs@lists.postgresql.org; Fri, 13 Oct 2023 00:45:09 +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 1qr6Ib-000D5b-KL for pgsql-bugs@lists.postgresql.org; Fri, 13 Oct 2023 00:45: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=Ywxh25EZQas3ugWnftKGhoI5tR0lVFuEW6aXb0XuRkM=; b=smAaX9ed+b3RUBnustV8otZi3D rjewGXF9X/e4XYle0Gm0zoVFWCSX17VwKPGlccOv7jZlDUX2cG0Ew7YmRo99k93sHZP2dq5iH73g7 DI5NBhH6ReGPpGKgX1itlxZHhfePMELoCefAwvymYQNfowFwdkVHSNilx2kB84rAJFzlHMNqVoucL zqt8wksAYBQHrmXmniWWHP7xzilIpiy9Lq0sFZWgsvGX0VavvDHHEWiGDFB11VdTFIQABVGgterl8 DXNpsJX2C45yyu68ebVwNZ+6F0Ui/BomGaDssUYkpSJobBC5KJhDW/utoDP97DcBVQAfaoLV4IRz1 jCedNkPw==; 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 1qr6Ia-0001pl-Vb for pgsql-bugs@lists.postgresql.org; Fri, 13 Oct 2023 00:45:05 +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 1qr6IX-0010V4-S3 for pgsql-bugs@lists.postgresql.org; Fri, 13 Oct 2023 00:45:03 +0000 Content-Type: multipart/mixed; boundary="===============8924983653958738153==" MIME-Version: 1.0 Subject: BUG #18155: Logical Apply Worker Timeout During TableSync Causes Either Stuckness or Data Loss To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: callaan@amazon.com Reply-To: callaan@amazon.com, pgsql-bugs@lists.postgresql.org Date: Fri, 13 Oct 2023 00:44:33 +0000 Message-ID: <18155-33f555bcc7e1105e@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 --===============8924983653958738153== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE1NQpMb2dnZWQgYnk6ICAgICAgICAgIERyZXcgQ2FsbGFoYW4KRW1h aWwgYWRkcmVzczogICAgICBjYWxsYWFuQGFtYXpvbi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ni4wCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1CkRlc2NyaXB0aW9uOiAgICAgICAgCgpEZXBl bmRpbmcgb24gdGhlIE1ham9yIFZlcnNpb24gYW4gdW50aW1lbHkgdGltZW91dCBvciB0ZXJtaW5h dGlvbiBvZiB0aGUKbWFpbiBhcHBseSB3b3JrZXIgd2hlbiB0aGUgdGFibGUgYXBwbHkgd29ya2Vy IGlzIHdhaXRpbmcgZm9yIHRoZQpzdWJzY3JpcHRpb24gcmVsc3RhdGUgdG8gY2hhbmdlIHRvIFNV QlJFTF9TVEFURV9DQVRDSFVQIGNhbiBsZWFkIHRvIG9uZSBvZgp0d28gcmVhbGx5IHBhaW5mdWwg ZXhwZXJpZW5jZXMuDQoNCklmIG9uIFJlbDE0KywgdGhlIHVudGltZWx5IGV4aXQgY2FuIGxlYWQg dG8gdGhlIG1haW4gYXBwbHkgd29ya2VyIGJlY29taW5nCmluZGVmaW5pdGVseSBzdHVjayB3aGls ZSBpdCB3YWl0cyBmb3IgYSB0YWJsZSBhcHBseSB3b3JrZXIsIHRoYXQgaGFzIGFscmVhZHkKZXhp dGVkIGFuZCB3b24ndCBiZSBsYXVuY2hlZCBhZ2FpbiwgdG8gY2hhbmdlIHRoZSBzdWJzY3JpcHRp b24gcmVsc3RhdGUgdG8KU1VCUkVMX1NUQVRFX1NZTkNET05FLiAgSW4gb3JkZXIgdG8gdW53ZWRn ZSwgYSBzeXN0ZW0gcmVzdGFydCBpcyByZXF1aXJlZCB0bwpjbGVhciB0aGUgY29ycnVwdGVkIHRy YW5zaWVudCBzdWJzY3JpcHRpb24gcmVsc3RhdGUgZGF0YS4NCg0KSWYgb24gUmVsMTMrLCB0aGVu IHRoZSB1bnRpbWVseSBleGl0IGNhbiBsZWFkIHRvIHNpbGVudCBkYXRhIGxvc3MuIFRoaXMgd2ls bApvY2N1ciBpZiB0aGUgdGFibGUgYXBwbHkgd29ya2VyIHBlcmZvcm1lZCBhIGNvcHkgYXQgTFNO IFguIElmIHRoZSBtYWluIGFwcGx5CndvcmtlciBpcyBub3cgYXQgTFNOIFkgPiBYLCB0aGUgc3lz dGVtIHJlcXVpcmVzIHRoZSB0YWJsZSBzeW5jIHdvcmtlciB0bwphcHBseSBhbGwgY2hhbmdlcyBi ZXR3ZWVuIFggJiBZIHRoYXQgd2VyZSBza2lwcGVkIGJ5IHRoZSBtYWluIGFwcGx5IHdvcmtlcgpp biBhIGNhdGNoIHVwIHBoYXNlLiBEdWUgdG8gdGhlIHVudGltZWx5IGV4aXQsIHRoZSB0YWJsZSBh cHBseSB3b3JrZXIgd2lsbAphc3N1bWUgdGhhdCB0aGUgbWFpbiBhcHBseSB3b3JrZXIgd2FzIGFj dHVhbGx5IGJlaGluZCwgc2tpcCB0aGUgY2F0Y2ggdXAKd29yaywgYW5kIGV4aXQuIEFzIGEgcmVz dWx0LCBhbGwgZGF0YSBiZXR3ZWVuIFggJiBZIHdpbGwgYmUgbG9zdCBmb3IgdGhhdAp0YWJsZS4N Cg0KVGhlIGNhdXNlIG9mIGJvdGggaXNzdWVzIGlzIHRoYXQgd2FpdF9mb3Jfd29ya2VyX3N0YXRl X2NoYW5nZSgpIGlzIGhhbmRsZWQKbGlrZSBhIHZvaWQgZnVuY3Rpb24gYnkgdGhlIHRhYmxlIGFw cGx5IHdvcmtlci4gSG93ZXZlciwgaWYgdGhlIG1haW4gYXBwbHkKd29ya2VyIGRvZXMgbm90IGN1 cnJlbnRseSBleGlzdCBvbiB0aGUgc3lzdGVtIGR1ZSB0byBzb21lIGlzc3VlIHN1Y2ggYXMgYQp0 aW1lb3V0IHRyaWdnZXJpbmcgaXQgdG8gc2FmZWx5IGV4aXQsIHRoZW4gdGhlIGZ1bmN0aW9uIHdp bGwgcmV0dXJuICpiZWZvcmUqCnRoZSBzdGF0ZSBjaGFuZ2UgaGFzIG9jY3VycmVkIGFuZCByZXR1 cm4gZmFsc2UuDQoNClRoZSBmaXggZm9yIHRoaXMgaXNzdWUgaXMgcmVsYXRpdmVseSwgd2UganVz dCBuZWVkIHRvIHZhbGlkYXRlIHRoZSBzdGF0ZQphY3R1YWxseSBkaWQgY2hhbmdlLiBJZiBpdCBk aWQgbm90LCB0aGVuIHdlIGNhbiBjaXJjbGUgYmFjayBsYXRlciB0byBjaGVjawphZ2FpbiB3aGlj aCBpcyByZWxhdGl2ZWx5IGNoZWFwIG9uIFJlbDE0Ky4gUGFzdGVkIGEgcG90ZW50aWFsIHNvbHV0 aW9uCmJlbG93LiBBIHNvbHV0aW9uIG9uIFJlbDEzLSB3b3VsZCB3YW50IHRvIGludHJvZHVjZSBh IHJldHJ5IGxvb3AgaW4Kd2FpdF9mb3Jfd29ya2VyX3N0YXRlX2NoYW5nZSgpIHRvIGF2b2lkIGhh dmluZyB0byBkbyB0aGUgZW50aXJlIENPUFkgYWdhaW4KZmlyc3Qgd2hpY2ggaXMgdmVyeSBleHBl bnNpdmUgb24gbGFyZ2UgdGFibGVzLg0KDQpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvcmVwbGlj YXRpb24vbG9naWNhbC90YWJsZXN5bmMuYwpiL3NyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2lj YWwvdGFibGVzeW5jLmMNCmluZGV4IGUyY2VlOTJjZjIuLjI1YmU5NzhlMTUgMTAwNjQ0DQotLS0g YS9zcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3RhYmxlc3luYy5jDQorKysgYi9zcmMv YmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3RhYmxlc3luYy5jDQpAQCAtMTUyOSwxMCArMTUy OSwzMCBAQCBjb3B5X3RhYmxlX2RvbmU6DQogICAgICAgIFNwaW5Mb2NrUmVsZWFzZSgmTXlMb2dp Y2FsUmVwV29ya2VyLT5yZWxtdXRleCk7DQoNCiAgICAgICAgLyoNCi0gICAgICAgICogRmluYWxs eSwgd2FpdCB1bnRpbCB0aGUgbGVhZGVyIGFwcGx5IHdvcmtlciB0ZWxscyB1cyB0byBjYXRjaCB1 cAphbmQNCi0gICAgICAgICogdGhlbiByZXR1cm4gdG8gbGV0IExvZ2ljYWxSZXBBcHBseUxvb3Ag ZG8gaXQuDQorICAgICAgICAqIEZpbmFsbHksIHdhaXQgdW50aWwgdGhlIG1haW4gYXBwbHkgd29y a2VyIHRlbGxzIHVzIHRvIGNhdGNoIHVwCmFuZCB0aGVuDQorICAgICAgICAqIHJldHVybiB0byBs ZXQgTG9naWNhbFJlcEFwcGx5TG9vcCBkbyBpdC4gSWYgdGhpcyB3YWl0IGZhaWxzIGR1ZQp0byB0 aGUNCisgICAgICAgICogYXBwbHkgd29ya2VyIG5vdCBiZWluZyB1cCwgd2UgZmFpbCB0aGlzIGF0 dGVtcHQgYW5kIGZvcmNlIGEKcmV0cnkuDQogICAgICAgICAqLw0KLSAgICAgICB3YWl0X2Zvcl93 b3JrZXJfc3RhdGVfY2hhbmdlKFNVQlJFTF9TVEFURV9DQVRDSFVQKTsNCisgICAgICAgaWYgKCF3 YWl0X2Zvcl93b3JrZXJfc3RhdGVfY2hhbmdlKFNVQlJFTF9TVEFURV9DQVRDSFVQKSkNCisgICAg ICAgew0KKyAgICAgICAgICAgICAgIGVyZXBvcnQoRVJST1IsDQorICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIChlcnJjb2RlKEVSUkNPREVfSU5URVJOQUxfRVJST1IpLA0KKyAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBlcnJtc2coImxvZ2ljYWwgcmVwbGljYXRpb24gdGFibGUK c3luY2hyb25pemF0aW9uIHdvcmtlciBmb3Igc3Vic2NyaXB0aW9uIFwiJXNcIiwgcmVsaWQgXCIl dVwiICINCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICJ1 bmFibGUgdG8gZmluaXNoIGR1ZSB0bwptYWluIGFwcGx5IHdvcmtlciBiZWluZyB1bmF2YWlsYWJs ZS4iLA0KKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgTXlT dWJzY3JpcHRpb24tPm5hbWUsCk15TG9naWNhbFJlcFdvcmtlci0+cmVsaWQpLA0KKyAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBlcnJoaW50KCJ0aGlzIHdvcmtlciB3aWxsIGF0dGVtcHQg dG8gc3luYwp0aGUgdGFibGUgYWdhaW4gb25jZSBsb2dpY2FsIHJlcGxpY2F0aW9uIGhhcyByZXN1 bWVkIikpKTsNCisgICAgICAgfQ0KKw0KKyAgICAgICBpZiAoTXlMb2dpY2FsUmVwV29ya2VyLT5y ZWxzdGF0ZSAhPSBTVUJSRUxfU1RBVEVfQ0FUQ0hVUCkNCisgICAgICAgew0KKyAgICAgICAgICAg ICAgIGVyZXBvcnQoRVJST1IsDQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIChlcnJj b2RlKEVSUkNPREVfSU5URVJOQUxfRVJST1IpLA0KKyAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBlcnJtc2coImxvZ2ljYWwgcmVwbGljYXRpb24gdGFibGUKc3luY2hyb25pemF0aW9uIHdv cmtlciBmb3Igc3Vic2NyaXB0aW9uIFwiJXNcIiwgcmVsaWQgXCIldVwiICINCisgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICJ1bmFibGUgdG8gbWFrZSBwcm9n cmVzcwp3aGlsZSBhcHBseSB3b3JrZXIgaXMgZG93biIsDQorICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBNeVN1YnNjcmlwdGlvbi0+bmFtZSwKTXlMb2dpY2Fs UmVwV29ya2VyLT5yZWxpZCksDQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGVycmhp bnQoInRoaXMgd29ya2VyIHdpbGwgYXR0ZW1wdCB0byBzeW5jCnRoZSB0YWJsZSBhZ2FpbiBvbmNl IGxvZ2ljYWwgcmVwbGljYXRpb24gaGFzIHJlc3VtZWQiKSkpOw0KKyAgICAgICB9DQorDQogICAg ICAgIHJldHVybiBzbG90bmFtZTsNCiB9Cgo= --===============8924983653958738153==--