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 1kkZ1z-0004d4-KW for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Dec 2020 20:47:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkZ1y-0002p4-CT for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Dec 2020 20:47:18 +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 1kkYeZ-0003Ce-Kf for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 20:23:07 +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 1kkYeX-0006Dx-2k for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 20:23: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=wbs0y67howmKaFWPoR24Cp9CyzDLCtMdOewZJ4PKqOI=; b=5kKA/iydcuHIM9xuoj1usifr+1 cHDlLCwQCJA7bZIae83pgUw3tPLzuyPL6T8p99RFzfgwJIB3vqL+4BOWSDWCHFqYRPQjy1t23P/Aq edkK/Cs6tPZFvq9GjSV1licMsXnMfEcoObramkXx8Gui3nVlvccBcnSUfJ3QC4KXnFO1d90GjiexF QBGM7oM2WyuG8x+RIhmL1P6LkmVV+4qmiWtf6phBMcpgADBshQ0ZW1uPPa68jyJr7dtl3kvdzFg6H vVvAIBMU24TAymRBEV34a9Pf4PdqEtSDUFSUuIUXQxIVnPCv5e1fX7vWB3x6bX/nce3BBsup/rizS dr1Zsk0g==; 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 1kkYeV-00065h-Ah for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 20:23:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkYeU-0000ge-4q for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 20:23:02 +0000 Content-Type: multipart/mixed; boundary="===============4395258509364564907==" MIME-Version: 1.0 Subject: BUG #16760: Standby database missed records for at least 1 table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: abartash@xmatters.com Reply-To: abartash@xmatters.com, pgsql-bugs@lists.postgresql.org Date: Wed, 02 Dec 2020 20:22:37 +0000 Message-ID: <16760-6c90634964ab51b0@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 --===============4395258509364564907== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc2MApMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJpeSBCYXJ0YXNoCkVt YWlsIGFkZHJlc3M6ICAgICAgYWJhcnRhc2hAeG1hdHRlcnMuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTIuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIENlbnRPUzcKRGVzY3JpcHRpb246ICAgICAgICAK CldlIHJ1biBwb3N0Z3JlcyBpbiBHb29nbGUgY2xvdWQgYW5kIEhBIGNvbmZpZ3VyZWQgYXMgZm9s bG93Og0KUHJpbWFyeSBpbnN0YW5jZSBydW5zIGluIFVTLUVBU1QxIHJlZ2lvbg0KMXN0IFNlY29u ZGFyeSBpbiBVUy1FQVNUMSANCjJuZCBTZWNvbmRhcnkgaW4gVVMtQ0VOVFJBTDENClJlY2VudGx5 IHdlIGRpc2NvdmVyZWQgdGhhdCAxc3QgU2Vjb25kYXJ5IGluc3RhbmNlIG1pc3NlZCA4IHJlY29y ZHMgaW4gb25lCnRhYmxlIGF0IGxlYXN0IC4gQXQgdGhlIHNhbWUgdGltZSwgcmVjb3ZlcnkgcHJv Y2VzcyB3YXMgd29ya2luZyBmaW5lIGFuZApjb250aW51ZWQgcmVjb3ZlcmluZy4gVGhlIDJuZCBT ZWNvbmRhcnkgaGFkIHRob3NlIHJlY29yZHMgdGhvdWdoLg0KV2hhdCB3ZSBtaXNzZWQgOiANCjgg cmVjb3JkcyBpbiBhdWRpdF9ldnNfYWxsIHRhYmxlLCBhdWRpdF9ldl9pZCBmcm9tIDIyMTUzNTE1 NCB0byAyMjE1MzUxNjENCldoZXJlIGF1ZGl0X2V2X2lkIGlzIGEgUEsgb2YgYXVkaXRfZXZzX2Fs bA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tDQpCZWxvdyBvdXRwdXQgZnJvbSBQcmltYXJ5DQpzZWxlY3QgYXVkaXRfZXZfaWQs IHdoZW5fY3JlYXRlZCBmcm9tIGF1ZGl0X2V2c19hbGwgIHdoZXJlIGF1ZGl0X2V2X2lkCmJldHdl ZW4gMjIxNTM1MTU0IGFuZCAyMjE1MzUxNjI7DQogYXVkaXRfZXZfaWQgfCAgICAgICAgIHdoZW5f Y3JlYXRlZA0KLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQog ICAyMjE1MzUxNTQgfCAyMDIwLTEyLTAxIDAwOjAwOjIwLjk1NTM0OCswMA0KICAgMjIxNTM1MTU1 IHwgMjAyMC0xMi0wMSAwMDowMDoyMC45NTUzNDgrMDANCiAgIDIyMTUzNTE1NiB8IDIwMjAtMTIt MDEgMDA6MDA6MjAuOTU1MzQ4KzAwDQogICAyMjE1MzUxNTcgfCAyMDIwLTEyLTAxIDAwOjAwOjIw Ljk1NTM0OCswMA0KICAgMjIxNTM1MTU4IHwgMjAyMC0xMi0wMSAwMDowMDoyMC45NTUzNDgrMDAN CiAgIDIyMTUzNTE1OSB8IDIwMjAtMTItMDEgMDA6MDA6MjAuOTU1MzQ4KzAwDQogICAyMjE1MzUx NjAgfCAyMDIwLTEyLTAxIDAwOjAwOjIwLjk1NTM0OCswMA0KICAgMjIxNTM1MTYxIHwgMjAyMC0x Mi0wMSAwMDowMDoyMC45NTUzNDgrMDANCiAgIDIyMTUzNTE2MiB8IDIwMjAtMTItMDEgMDA6MDA6 MjAuOTU1MzQ4KzAwDQooOSByb3dzKQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpTYW1lIHF1ZXJ5J3Mgb3V0cHV0IGZyb20g MXN0IFNlY29uZGFyeQ0Kc2VsZWN0IGF1ZGl0X2V2X2lkLCB3aGVuX2NyZWF0ZWQgZnJvbSBhdWRp dF9ldnNfYWxsICB3aGVyZSBhdWRpdF9ldl9pZApiZXR3ZWVuIDIyMTUzNTE1NCBhbmQgMjIxNTM1 MTYyOw0KIGF1ZGl0X2V2X2lkIHwgICAgICAgICB3aGVuX2NyZWF0ZWQNCi0tLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICAgMjIxNTM1MTYyIHwgMjAyMC0xMi0w MSAwMDowMDoyMC45NTUzNDgrMDANCigxIHJvdykNCg0KV2hlbiBpdCB3YXMgZGlzY292ZXJlZDog cm91Z2hseSA3IGhvdXJzIGFmdGVyLg0KQ29sdW1uIHdoZW5fY3JlYXRlZCByZXByZXNlbnRzIHdo ZW4gdGhlIHJlY29yZCB3YXMgaW5zZXJ0ZWQgaW50byB0aGUgdGFibGUsCnNvLCBhcyBhIHByb29m IHRoYXQgcmVjb3ZlcnkgcHJvY2VzcyB3YXMgcnVubmluZyBmaW5lIHdlIGNhbjoNCnNlbGVjdCBt YXgod2hlbl9jcmVhdGVkKSBmcm9tIGF1ZGl0X2V2c19hbGw7DQogICAgICAgICAgICAgIG1heA0K LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDIwMjAtMTItMDEgMDc6Mzg6MTguMjU4 ODY2KzAwDQooMSByb3cpDQoNCldlIGRpZG4ndCBmaW5kIGFueSBFUlJPUlMgaW4gcG9zdGdyZXMg bG9ncyBvbiBQcmltYXJ5IGVpdGhlciBvbiAxc3QKU2Vjb25kYXJ5IGFyb3VuZCAgMjAyMC0xMi0w MSAwMDowMDoyMC45NTUzNDgrMDAgKGFzIHdlIHNlZSBhbGwgdGhvc2UgOQpyZWNvcmRzIHdlcmUg aW5zZXJ0ZWQgYXQgdGhlIHNhbWUgdGltZSBhcyBhIGJ1bGsgaW5zZXJ0KS4NCldoYXQgd2FzIHJ1 bm5pbmcgb24gMXN0IFNlY29uZGFyeSBhcm91bmQgdGhhdCB0aW1lOiBXZSBoYWQgcGdfZHVtcCBy dW5uaW5nCnRoZXJlIGJldHdlZW4gMTI6MDAgYS5tLiBhbmQgMSBhLm0uLCBzbywgd2Uga25vdyB0 aGF0IHBvc3RncmVzIHN1c3BlbmRlZApyZWNvdmVyeSBwcm9jZXNzIHdoaWxlIHBnX2R1bXAgd2Fz IHdvcmtpbmcgYW5kIGRlZmluaXRlbHkgaXQgY2F1c2VkIHNvbWUgbGFnCmJldHdlZW4gUHJpbWFy eSBhbmQgMXN0IFNlY29uZGFyeS4gDQpXaGVuIHByb2JsZW0gd2FzIGZvdW5kLCAxc3QgU2Vjb25k YXJ5IGluc3RhbmNlIHdhcyByZXN0YXJ0ZWQsIHdlIGhvcGVkIHRoYXQKcG9zdGdyZXMgbWlnaHQg aWRlbnRpZnkgdGhpcyBpc3N1ZSBhbmQgYXBwbHkgbWlzc2VkIHdhbCBmaWxlcyBpZiBhbnksIGJ1 dApub3RoaW5nIGhhcHBlbmVkIGFuZCBpdCBjb250aW51ZWQgYXBwbHlpbmcgbGF0ZXN0IGNoYW5n ZXMgZnJvbSB0aGUKUHJpbWFyeS4NClJlY292ZXJ5IGNvbmZpZyBmcm9tIDFzdCBTZWNvbmRhcnkg KGhvc3QgSVAgcmVwbGFjZWQgd2l0aCB4eC54eC54eC54eCk6DQojIHJlY292ZXJ5LmNvbmYNCnBy aW1hcnlfY29ubmluZm8gPSAndXNlcj1yZXBsaWNhdGlvbiBwYXNzZmlsZT0vdmFyL2xpYi9wZ3Nx bC9wZ3Bhc3MKaG9zdD14eC54eC54eC54eCBwb3J0PTU0MzIgc3NsbW9kZT1wcmVmZXIKYXBwbGlj YXRpb25fbmFtZT1wb3N0Z3Jlcy1wcmQtdXNlYXN0MS1uYXByZDgtMScNCnByaW1hcnlfc2xvdF9u YW1lID0gJ3Bvc3RncmVzX3ByZF91c2Vhc3QxX25hcHJkOF8xJw0KcmVjb3ZlcnlfdGFyZ2V0ID0g JycNCnJlY292ZXJ5X3RhcmdldF9sc24gPSAnJw0KcmVjb3ZlcnlfdGFyZ2V0X25hbWUgPSAnJw0K cmVjb3ZlcnlfdGFyZ2V0X3RpbWUgPSAnJw0KcmVjb3ZlcnlfdGFyZ2V0X3RpbWVsaW5lID0gJ2xh dGVzdCcNCnJlY292ZXJ5X3RhcmdldF94aWQgPSAnJw0KDQpQbGVhc2UgbGV0IG1lIGtub3cgaWYg eW91IG5lZWQgYW55dGhpbmcgZWxzZSBmb3JtIG91ciBlbmQsIHdlIGhhdmUgYSBjb2xkCmJhY2t1 cCBvZiBQR0RBVEEgZnJvbTFzdCBTZWNvbmRhcnkgYXMgd2VsbCBhcyBQb3N0Z3JlcyBsb2dzIGZy b20gUHJpbWFyeSBhbmQKU2Vjb25kYXJ5LiAgIA0KDQpQUzogSXQgaXMgdGhlIHNlY29uZCB0aW1l IHdlIHNlZSB0aGlzIGlzc3VlIGluIG91ciBlbnZpcm9ubWVudCAoYWJvdXQgMzAgUEcKY2x1c3Rl cnMpIHdpdGhpbiBsYXN0IDMgd2Vla3MgYnV0IGRpZmZlcmVudCBjbHVzdGVyICB0aGlzIHRpbWUu Cgo= --===============4395258509364564907==--