Re: BUG #13822: Slave terminated - WAL contains references to invalid page - Mailing list pgsql-bugs
| From | |
|---|---|
| Subject | Re: BUG #13822: Slave terminated - WAL contains references to invalid page |
| Date | |
| Msg-id | f90c2c290bdd4629b3684ca351ab3261@C105S135VM024.eu.tieto.com Whole thread Raw |
| In response to | Re: BUG #13822: Slave terminated - WAL contains references to invalid page (Michael Paquier <michael.paquier@gmail.com>) |
| Responses |
Re: BUG #13822: Slave terminated - WAL contains references to
invalid page
(Michael Paquier <michael.paquier@gmail.com>)
|
| List | pgsql-bugs |
VHJpZWQgdG8gdXNlIHBhZ2VpbnNwZWN0IG1vZHVsZSBmb3IgYWZmZWN0ZWQgcGFnZXMgZnJvbSBs YXN0IHR3byBvY2N1cmVuY2VzOg0KDQoyMDE1LTEyLTE1IDEzOjA1OjM5IENFVCBAICBXQVJOSU5H OiAgcGFnZSA0MzMzMjc1IG9mIHJlbGF0aW9uIGJhc2UvMTY0MjIvMTcyMzAgaXMgdW5pbml0aWFs aXplZA0KMjAxNS0xMi0yMiAwMDoyNToxMSBDRVQgQCAgV0FSTklORzogIHBhZ2UgNzE1NjYgb2Yg cmVsYXRpb24gYmFzZS8xNjQyMi8yMzI1MyBpcyB1bmluaXRpYWxpemVkDQoNCkZvbGxvd2luZyBv dXRwdXRzIGFyZSB0aGUgc2FtZSBmb3IgbWFzdGVyIGFuZCBzbGF2ZToNCg0KIyBzZWxlY3QgcmVs bmFtZSBmcm9tIHBnX2NsYXNzIHdoZXJlIHJlbGZpbGVub2RlIGluICgnMTcyMzAnLCcyMzI1Mycp Ow0KICAgIHJlbG5hbWUgICAgIA0KLS0tLS0tLS0tLS0tLS0tLQ0KIHBnX3RvYXN0XzE3MjI1DQog cGdfdG9hc3RfMjMyNDYNCigyIHJvd3MpDQoNCiMgU0VMRUNUICogRlJPTSBwYWdlX2hlYWRlcihn ZXRfcmF3X3BhZ2UoJ3BnX3RvYXN0LnBnX3RvYXN0XzIzMjQ2JywgNzE1NjYpKTsNCiAgICAgbHNu ICAgICAgfCBjaGVja3N1bSB8IGZsYWdzIHwgbG93ZXIgfCB1cHBlciB8IHNwZWNpYWwgfCBwYWdl c2l6ZSB8IHZlcnNpb24gfCBwcnVuZV94aWQgDQotLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0t LS0tLS0rLS0tLS0tLSstLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0t LS0tLS0tLQ0KIDE4MS8xQkY1OTNBOCB8ICAgICAgICAwIHwgICAgIDQgfCAgICA0NCB8ICAgNjAw IHwgICAgODE5MiB8ICAgICA4MTkyIHwgICAgICAgNCB8ICAgICAgICAgMA0KKDEgcm93KQ0KDQoj IFNFTEVDVCAqIEZST00gcGFnZV9oZWFkZXIoZ2V0X3Jhd19wYWdlKCdwZ190b2FzdC5wZ190b2Fz dF8xNzIyNScsIDQzMzMyNzUpKTsNCiAgICAgbHNuICAgICAgfCBjaGVja3N1bSB8IGZsYWdzIHwg bG93ZXIgfCB1cHBlciB8IHNwZWNpYWwgfCBwYWdlc2l6ZSB8IHZlcnNpb24gfCBwcnVuZV94aWQg DQotLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0rLS0tLS0tLSstLS0tLS0tKy0tLS0t LS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLQ0KIDE3Mi8zMEJFQ0I1OCB8ICAg ICAgICAwIHwgICAgIDQgfCAgICA0MCB8ICAgIDY0IHwgICAgODE5MiB8ICAgICA4MTkyIHwgICAg ICAgNCB8ICAgICAgICAgMA0KKDEgcm93KQ0KDQojIFNFTEVDVCAqIEZST00gaGVhcF9wYWdlX2l0 ZW1zKGdldF9yYXdfcGFnZSgncGdfdG9hc3QucGdfdG9hc3RfMjMyNDYnLCA3MTU2NikpOw0KIGxw IHwgbHBfb2ZmIHwgbHBfZmxhZ3MgfCBscF9sZW4gfCAgdF94bWluICAgfCB0X3htYXggfCB0X2Zp ZWxkMyB8ICB0X2N0aWQgICB8IHRfaW5mb21hc2syIHwgdF9pbmZvbWFzayB8IHRfaG9mZiB8IHRf Yml0cyB8IHRfb2lkIA0KLS0tLSstLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0t LS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLQ0KICAxIHwgICA2MTYwIHwgICAgICAgIDEg fCAgIDIwMzIgfCAzNjQ4OTQ4MjEgfCAgICAgIDAgfCAgICAgICAgMSB8ICg3MTU2NiwxKSB8ICAg ICAgICAgICAzIHwgICAgICAgMjMwNiB8ICAgICAyNCB8ICAgICAgICB8ICAgICAgDQogIDIgfCAg IDUxNjAgfCAgICAgICAgMSB8ICAgIDk5NCB8IDM2NDg5NDgyMSB8ICAgICAgMCB8ICAgICAgICAx IHwgKDcxNTY2LDIpIHwgICAgICAgICAgIDMgfCAgICAgICAyMzA2IHwgICAgIDI0IHwgICAgICAg IHwgICAgICANCiAgMyB8ICAgMzEyOCB8ICAgICAgICAxIHwgICAyMDMyIHwgMzY0ODk0OTM0IHwg ICAgICAwIHwgICAgICAgIDEgfCAoNzE1NjYsMykgfCAgICAgICAgICAgMyB8ICAgICAgIDIzMDYg fCAgICAgMjQgfCAgICAgICAgfCAgICAgIA0KICA0IHwgICAyNjMyIHwgICAgICAgIDEgfCAgICA0 OTYgfCAzNjQ4OTQ5MzQgfCAgICAgIDAgfCAgICAgICAgMSB8ICg3MTU2Niw0KSB8ICAgICAgICAg ICAzIHwgICAgICAgMjMwNiB8ICAgICAyNCB8ICAgICAgICB8ICAgICAgDQogIDUgfCAgICA2MDAg fCAgICAgICAgMSB8ICAgMjAzMiB8IDM2NDg5NTI0MSB8ICAgICAgMCB8ICAgICAgICAxIHwgKDcx NTY2LDUpIHwgICAgICAgICAgIDMgfCAgICAgICAyMzA2IHwgICAgIDI0IHwgICAgICAgIHwgICAg ICANCig1IHJvd3MpDQoNCiMgU0VMRUNUICogRlJPTSBoZWFwX3BhZ2VfaXRlbXMoZ2V0X3Jhd19w YWdlKCdwZ190b2FzdC5wZ190b2FzdF8xNzIyNScsIDQzMzMyNzUpKTsNCiBscCB8IGxwX29mZiB8 IGxwX2ZsYWdzIHwgbHBfbGVuIHwgIHRfeG1pbiAgIHwgdF94bWF4IHwgdF9maWVsZDMgfCAgIHRf Y3RpZCAgICB8IHRfaW5mb21hc2syIHwgdF9pbmZvbWFzayB8IHRfaG9mZiB8IHRfYml0cyB8IHRf b2lkIA0KLS0tLSstLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0t LS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSst LS0tLS0tLSstLS0tLS0tLSstLS0tLS0tDQogIDEgfCAgIDYxNjAgfCAgICAgICAgMSB8ICAgMjAz MiB8IDM2MDIyNDIzOCB8ICAgICAgMCB8ICAgICAgICAxIHwgKDQzMzMyNzUsMSkgfCAgICAgICAg ICAgMyB8ICAgICAgIDIzMDYgfCAgICAgMjQgfCAgICAgICAgfCAgICAgIA0KICAyIHwgICA0MTI4 IHwgICAgICAgIDEgfCAgIDIwMzIgfCAzNjAyMjQyMzggfCAgICAgIDAgfCAgICAgICAgMSB8ICg0 MzMzMjc1LDIpIHwgICAgICAgICAgIDMgfCAgICAgICAyMzA2IHwgICAgIDI0IHwgICAgICAgIHwg ICAgICANCiAgMyB8ICAgMjA5NiB8ICAgICAgICAxIHwgICAyMDMyIHwgMzYwMjI0MjM4IHwgICAg ICAwIHwgICAgICAgIDEgfCAoNDMzMzI3NSwzKSB8ICAgICAgICAgICAzIHwgICAgICAgMjMwNiB8 ICAgICAyNCB8ICAgICAgICB8ICAgICAgDQogIDQgfCAgICAgNjQgfCAgICAgICAgMSB8ICAgMjAz MiB8IDM2MDIyNDIzOCB8ICAgICAgMCB8ICAgICAgICAxIHwgKDQzMzMyNzUsNCkgfCAgICAgICAg ICAgMyB8ICAgICAgIDIzMDYgfCAgICAgMjQgfCAgICAgICAgfCAgICAgIA0KKDQgcm93cykNCg0K DQpOb24tZGVmYXVsdCBwYXJzOg0KDQpsaXN0ZW5fYWRkcmVzc2VzID0gJyonDQptYXhfY29ubmVj dGlvbnMgPSA2MDANCnNzbCA9IG9uDQpzc2xfY2VydF9maWxlID0gJ3h4eC5jcnQnICAgICAgICAg ICANCnNzbF9rZXlfZmlsZSA9ICd4eHgua2V5JyAgICAgICAgICAgIA0Kc3NsX2NhX2ZpbGUgPSAn eHh4LmNydCcNCnNoYXJlZF9idWZmZXJzID0gNEdCDQp3b3JrX21lbSA9IDY5OTBrQg0KbWFpbnRl bmFuY2Vfd29ya19tZW0gPSA4MTlNQg0Kc2hhcmVkX3ByZWxvYWRfbGlicmFyaWVzID0gJ3BnX3N0 YXRfc3RhdGVtZW50cycNCnBnX3N0YXRfc3RhdGVtZW50cy5tYXggPSAxMDAwMA0KcGdfc3RhdF9z dGF0ZW1lbnRzLnRyYWNrID0gYWxsDQp3YWxfbGV2ZWwgPSBob3Rfc3RhbmRieQ0KY2hlY2twb2lu dF9zZWdtZW50cyA9IDMyDQpjaGVja3BvaW50X2NvbXBsZXRpb25fdGFyZ2V0ID0gMC45DQphcmNo aXZlX21vZGUgPSBvbg0KYXJjaGl2ZV9jb21tYW5kID0gJ3JzeW5jIC1hICVwIHh4eEB4eHg6L2Rh dGEvd2FsX2FyY2gvJWYnDQptYXhfd2FsX3NlbmRlcnMgPSA1DQp3YWxfa2VlcF9zZWdtZW50cyA9 IDY0DQpob3Rfc3RhbmRieSA9IG9uDQplZmZlY3RpdmVfY2FjaGVfc2l6ZSA9IDEyR0INCg0KDQpT bGF2ZSByZWJ1aWxkZWQgYW5kIGl0J3MgcnVubmluZyBhbG1vc3QgYSB3ZWVrIGZvciBub3cuDQoN ClJlZ2FyZHMNCk1hcmVrDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBNaWNo YWVsIFBhcXVpZXIgW21haWx0bzptaWNoYWVsLnBhcXVpZXJAZ21haWwuY29tXSANClNlbnQ6IFNh dHVyZGF5LCBEZWNlbWJlciAyNiwgMjAxNSAyOjE1IFBNDQpUbzogUGV0ciBNYXJlayA8TWFyZWsu UGV0ckB0aWV0by5jb20+DQpDYzogUG9zdGdyZVNRTCBtYWlsaW5nIGxpc3RzIDxwZ3NxbC1idWdz QHBvc3RncmVzcWwub3JnPg0KU3ViamVjdDogUmU6IFtCVUdTXSBCVUcgIzEzODIyOiBTbGF2ZSB0 ZXJtaW5hdGVkIC0gV0FMIGNvbnRhaW5zIHJlZmVyZW5jZXMgdG8gaW52YWxpZCBwYWdlDQoNCk9u IFR1ZSwgRGVjIDIyLCAyMDE1IGF0IDk6MDUgUE0sICA8TWFyZWsuUGV0ckB0aWV0by5jb20+IHdy b3RlOg0KPiAyMDE1LTEyLTIyIDAwOjI1OjExIENFVCBAICBXQVJOSU5HOiAgcGFnZSA3MTU2NiBv ZiByZWxhdGlvbiANCj4gYmFzZS8xNjQyMi8yMzI1MyBpcyB1bmluaXRpYWxpemVkDQo+IDIwMTUt MTItMjIgMDA6MjU6MTEgQ0VUIEAgIENPTlRFWFQ6ICB4bG9nIHJlZG8gdmlzaWJsZTogcmVsIA0K PiAxNjYzLzE2NDIyLzIzMjUzOyBibGsgNzE1NjYNCj4gMjAxNS0xMi0yMiAwMDoyNToxMSBDRVQg QCAgUEFOSUM6ICBXQUwgY29udGFpbnMgcmVmZXJlbmNlcyB0byBpbnZhbGlkIA0KPiBwYWdlcw0K PiAyMDE1LTEyLTIyIDAwOjI1OjExIENFVCBAICBDT05URVhUOiAgeGxvZyByZWRvIHZpc2libGU6 IHJlbCANCj4gMTY2My8xNjQyMi8yMzI1MzsgYmxrIDcxNTY2DQo+IDIwMTUtMTItMjIgMDA6MjU6 MTIgQ0VUIEAgIExPRzogIHN0YXJ0dXAgcHJvY2VzcyAoUElEIDI0NDM0KSB3YXMgDQo+IHRlcm1p bmF0ZWQgYnkgc2lnbmFsIDY6IEFib3J0ZWQNCj4gMjAxNS0xMi0yMiAwMDoyNToxMiBDRVQgQCAg TE9HOiAgdGVybWluYXRpbmcgYW55IG90aGVyIGFjdGl2ZSBzZXJ2ZXIgDQo+IHByb2Nlc3Nlcw0K DQpMb29raW5nIG1vcmUgY2xvc2VseSBhdCB0aGF0LCB0aGlzIGlzIHRoZSBjb2RlIHBhdGggb2Yg dGhlIHJlZG8gcm91dGluZSBmb3IgWExPR19IRUFQMl9WSVNJQkxFLiBJIGhhdmUgYmVlbiBsb29r aW5nIGF0IHRoZSBhcmVhIG9mIHRoZSBjb2RlIGFyb3VuZCB2aXNpYmlsaXR5bWFwX3NldCB0byB0 cnkgdG8gc2VlIGlmIHRoZXJlIGNvdWxkIGJlIGEgcmFjZSBjb25kaXRpb24gd2l0aCBhbm90aGVy IGJhY2tlbmQgZXh0ZW5kaW5nIHRoZSByZWxhdGlvbiBhbmQgY2F1c2luZyB0aGUgcGFnZSB0byBi ZSB1bmluaXRpYWxpemVkIGJ1dCBoYXZlIG5vdCBmb3VuZCBhbnl0aGluZyB5ZXQuIDkuNCBoYXMg YmVlbiBvdXQgZm9yIHNvbWUgdGltZSwgYW5kIHRoaXMgaXMgdGhlIGZpcnN0IHJlcG9ydCBvZiB0 aGlzIGtpbmQgZm9yIHRoaXMgcmVkbyByb3V0aW5lLiBTdGlsbCwgeW91IGhhdmUgYmVlbiBhYmxl IHRvIHJlcHJvZHVjZSB0aGUgcHJvYmxlbSB0d2ljZSwgc28gdGhpcyBoYXMgdGhlIHNtZWxsIG9m IGEgYnVnLi4uIE90aGVycywgb3BpbmlvbnM/DQoNCkRpZCB5b3UgcmVidWlsZCBhIG5ldyBzbGF2 ZSBhbmQgbGV0IHRoZSBtYXN0ZXIgcnVubmluZywgYW5kIHBlcmhhcHMgc29tZSBkYXRhIGNvcnJ1 cHRpb24gaXMgY29taW5nIGZyb20gaXQ/IFdoYXQncyB0aGUgc3RhdGUgb2YgdGhlIHNhbWUgcGFn ZXMgb24gdGhlIG1hc3Rlcj8gQXJlIHRoZXkgemVybydlZD8NCg0KQWxzbywgYXJlIHlvdSB1c2lu ZyBhbnkgcGFyYW1ldGVyIHdpdGggYSB2YWx1ZSBkaWZmZXJlbnQgdGhhbiB0aGUgZGVmYXVsdC4g SSBkb24ndCBrbm93IGZzeW5jLCBmdWxsX3BhZ2Vfd3JpdGVzLi4uDQoNCj4gc2VsZWN0IHJlbG5h bWUgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxmaWxlbm9kZSBpbiAoJzE3MjMwJywnMjMyNTMnKTsN Cj4gICAgIHJlbG5hbWUNCj4gLS0tLS0tLS0tLS0tLS0tLQ0KPiAgcGdfdG9hc3RfMTcyMjUNCj4g IHBnX3RvYXN0XzIzMjQ2DQo+ICgyIHJvd3MpDQo+DQo+IEZpcnN0IHRvYXN0J3MgcmVsYXRpb24g aGFzIDM0R0IsIHNlY29uZCAyNDUyIE1CLg0KPiBJcyBpdCBwb3NzaWJsZSB0byBnZXQgbW9yZSBp bmZvIGZyb20gc29tZSBkZWVwZXIgbG9nZ2luZyBmb3IgdGhlIGNhc2UgaXQgd2lsbCBvY2N1ciBh Z2Fpbj8NCg0KSSBhbSBub3Qgc3VyZSB0byB1bmRlcnN0YW5kIHdoYXQgeW91IGFyZSBsb29raW5n IGZvciBoZXJlLiBZb3UgY291bGQgbWFrZSB0aGUgbG9ncyBtb3JlIHZlcmJvc2UgYnV0IHRoaXMg d291bGQgYmxvYXQgeW91ciBsb2cgcGFydGl0aW9uLi4uDQotLQ0KTWljaGFlbA0K
pgsql-bugs by date: