Re: BUG #13822: Slave terminated - WAL contains references to invalid page

Поиск
Список
Период
Сортировка
От
Тема Re: BUG #13822: Slave terminated - WAL contains references to invalid page
Дата
Msg-id 80e2163be21c4f7da5651ff0106d1f81@C105S135VM024.eu.tieto.com
обсуждение исходный текст
Ответ на BUG #13822: Slave terminated - WAL contains references to invalid page  (marek.petr@tieto.com)
Список pgsql-bugs
Дерево обсуждения 
U2FtZSBpc3N1ZSBzaW11bGF0ZWQgdmlhIFBJVFIgZnJvbSBiYXNlIGJhY2t1cCB1cCB0byA1IG1p
bnV0ZXMgYWZ0ZXIgdGhlIGNyYXNoOg0KDQoyMDE1LTEyLTMwIDA4OjMxOjE5IENFVCBAICBMT0c6
ICBkYXRhYmFzZSBzeXN0ZW0gd2FzIGludGVycnVwdGVkOyBsYXN0IGtub3duIHVwIGF0IDIwMTUt
MTItMjEgMjA6MTU6MDIgQ0VUDQoyMDE1LTEyLTMwIDA4OjMxOjE5IENFVCBAICBMT0c6ICBzdGFy
dGluZyBwb2ludC1pbi10aW1lIHJlY292ZXJ5IHRvIDIwMTUtMTItMjIgMDA6MzA6MDArMDENCjIw
MTUtMTItMzAgMDg6MzE6MTkgQ0VUIEAgIExPRzogIGRhdGFiYXNlIHN5c3RlbSB3YXMgbm90IHBy
b3Blcmx5IHNodXQgZG93bjsgYXV0b21hdGljIHJlY292ZXJ5IGluIHByb2dyZXNzDQoyMDE1LTEy
LTMwIDA4OjMxOjE5IENFVCBAICBMT0c6ICByZWRvIHN0YXJ0cyBhdCAxODYvRDcyNjA1NDANCjIw
MTUtMTItMzAgMDg6MzE6MTkgQ0VUIEAgIExPRzogIGNvbnNpc3RlbnQgcmVjb3Zlcnkgc3RhdGUg
cmVhY2hlZCBhdCAxODYvRDgwMDAwMDANCjIwMTUtMTItMzAgMDg6MzE6MTkgQ0VUIEAgIExPRzog
IGRhdGFiYXNlIHN5c3RlbSBpcyByZWFkeSB0byBhY2NlcHQgcmVhZCBvbmx5IGNvbm5lY3Rpb25z
DQoyMDE1LTEyLTMwIDA4OjMxOjE5IENFVCBAICBMT0c6ICByZXN0b3JlZCBsb2cgZmlsZSAiMDAw
MDAwMDEwMDAwMDE4NjAwMDAwMEQ4IiBmcm9tIGFyY2hpdmUNCjIwMTUtMTItMzAgMDg6MzE6MjAg
Q0VUIEAgIExPRzogIHJlc3RvcmVkIGxvZyBmaWxlICIwMDAwMDAwMTAwMDAwMTg2MDAwMDAwRDki
IGZyb20gYXJjaGl2ZQ0KLy4uLi8NCjIwMTUtMTItMzAgMDg6MzI6NDggQ0VUIEAgIExPRzogIHJl
c3RvcmVkIGxvZyBmaWxlICIwMDAwMDAwMTAwMDAwMTg3MDAwMDAwOUQiIGZyb20gYXJjaGl2ZQ0K
MjAxNS0xMi0zMCAwODozMjo1MCBDRVQgQCAgTE9HOiAgcmVzdG9yZWQgbG9nIGZpbGUgIjAwMDAw
MDAxMDAwMDAxODcwMDAwMDA5RSIgZnJvbSBhcmNoaXZlDQoyMDE1LTEyLTMwIDA4OjMyOjUxIENF
VCBAICBXQVJOSU5HOiAgcGFnZSA3MzE3MiBvZiByZWxhdGlvbiBiYXNlLzE2NDIyLzIzMjUzIGlz
IHVuaW5pdGlhbGl6ZWQNCjIwMTUtMTItMzAgMDg6MzI6NTEgQ0VUIEAgIENPTlRFWFQ6ICB4bG9n
IHJlZG8gdmlzaWJsZTogcmVsIDE2NjMvMTY0MjIvMjMyNTM7IGJsayA3MzE3Mg0KMjAxNS0xMi0z
MCAwODozMjo1MSBDRVQgQCAgUEFOSUM6ICBXQUwgY29udGFpbnMgcmVmZXJlbmNlcyB0byBpbnZh
bGlkIHBhZ2VzDQoyMDE1LTEyLTMwIDA4OjMyOjUxIENFVCBAICBDT05URVhUOiAgeGxvZyByZWRv
IHZpc2libGU6IHJlbCAxNjYzLzE2NDIyLzIzMjUzOyBibGsgNzMxNzINCjIwMTUtMTItMzAgMDg6
MzI6NTEgQ0VUIEAgIExPRzogIHN0YXJ0dXAgcHJvY2VzcyAoUElEIDI5MzI0KSB3YXMgdGVybWlu
YXRlZCBieSBzaWduYWwgNjogQWJvcnRlZA0KMjAxNS0xMi0zMCAwODozMjo1MSBDRVQgQCAgTE9H
OiAgdGVybWluYXRpbmcgYW55IG90aGVyIGFjdGl2ZSBzZXJ2ZXIgcHJvY2Vzc2VzDQoNClJlZ2Fy
ZHMNCk1hcmVrDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBQZXRyIE1hcmVr
IA0KU2VudDogVHVlc2RheSwgRGVjZW1iZXIgMjksIDIwMTUgNDo1MiBQTQ0KVG86ICdNaWNoYWVs
IFBhcXVpZXInIDxtaWNoYWVsLnBhcXVpZXJAZ21haWwuY29tPg0KQ2M6IFBvc3RncmVTUUwgbWFp
bGluZyBsaXN0cyA8cGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZz4NClN1YmplY3Q6IFJFOiBbQlVH
U10gQlVHICMxMzgyMjogU2xhdmUgdGVybWluYXRlZCAtIFdBTCBjb250YWlucyByZWZlcmVuY2Vz
IHRvIGludmFsaWQgcGFnZQ0KDQpJIHVzZWQgZnJlc2ggYmFzZSBiYWNrdXAgZm9yIHNsYXZlIGFm
dGVyIGJvdGggY3Jhc2hlcy4NCkFsc28gdHJpZWQgdG8gc2NhbiBhcmNoaXZlZCB3YWxzIHNldmVy
YWwgaG91cnMgYmVmb3JlIGxhc3QgY3Jhc2ggYW5kIGZvdW5kIG9ubHkgdGhlIGZvbGxvd2luZyBm
b3Igc3RyaW5nIDcxNTY2Og0KDQpybWdyOiBIZWFwMiAgICAgICBsZW4gKHJlYy90b3QpOiAgICAg
MjAvICAgIDUyLCB0eDogICAgICAgICAgMCwgbHNuOiAxODcvOTg3ODU5RDgsIHByZXYgMTg3Lzk4
Nzg1OUEwLCBia3A6IDAwMDAsIGRlc2M6IHZpc2libGU6IHJlbCAxNjYzLzE2NDIyLzE3MjE2OyBi
bGsgNzE1NjYNCnJtZ3I6IEhlYXAyICAgICAgIGxlbiAocmVjL3RvdCk6ICAgICAyMC8gICAgNTIs
IHR4OiAgICAgICAgICAwLCBsc246IDE4Ny85Q0M1OTAyMCwgcHJldiAxODcvOUNDNThGRTgsIGJr
cDogMDAwMCwgZGVzYzogdmlzaWJsZTogcmVsIDE2NjMvMTY0MjIvMTcyMjA7IGJsayA3MTU2Ng0K
cm1ncjogSGVhcDIgICAgICAgbGVuIChyZWMvdG90KTogICAgIDIwLyAgICA1MiwgdHg6ICAgICAg
ICAgIDAsIGxzbjogMTg3LzlFMzU2RDk4LCBwcmV2IDE4Ny85RTM1NkQ2MCwgYmtwOiAwMDAwLCBk
ZXNjOiB2aXNpYmxlOiByZWwgMTY2My8xNjQyMi8yMzI1MzsgYmxrIDcxNTY2DQoNClJlZ2FyZHMN
Ck1hcmVrDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBNaWNoYWVsIFBhcXVp
ZXIgW21haWx0bzptaWNoYWVsLnBhcXVpZXJAZ21haWwuY29tXSANClNlbnQ6IE1vbmRheSwgRGVj
ZW1iZXIgMjgsIDIwMTUgNDoyOSBQTQ0KVG86IFBldHIgTWFyZWsgPE1hcmVrLlBldHJAdGlldG8u
Y29tPg0KQ2M6IFBvc3RncmVTUUwgbWFpbGluZyBsaXN0cyA8cGdzcWwtYnVnc0Bwb3N0Z3Jlc3Fs
Lm9yZz4NClN1YmplY3Q6IFJlOiBbQlVHU10gQlVHICMxMzgyMjogU2xhdmUgdGVybWluYXRlZCAt
IFdBTCBjb250YWlucyByZWZlcmVuY2VzIHRvIGludmFsaWQgcGFnZQ0KDQpPbiBNb24sIERlYyAy
OCwgMjAxNSBhdCA4OjUwIFBNLCAgPE1hcmVrLlBldHJAdGlldG8uY29tPiB3cm90ZToNCj4gVHJp
ZWQgdG8gdXNlIHBhZ2VpbnNwZWN0IG1vZHVsZSBmb3IgYWZmZWN0ZWQgcGFnZXMgZnJvbSBsYXN0
IHR3byBvY2N1cmVuY2VzOg0KPg0KPiAyMDE1LTEyLTE1IDEzOjA1OjM5IENFVCBAICBXQVJOSU5H
OiAgcGFnZSA0MzMzMjc1IG9mIHJlbGF0aW9uIA0KPiBiYXNlLzE2NDIyLzE3MjMwIGlzIHVuaW5p
dGlhbGl6ZWQNCj4gMjAxNS0xMi0yMiAwMDoyNToxMSBDRVQgQCAgV0FSTklORzogIHBhZ2UgNzE1
NjYgb2YgcmVsYXRpb24gDQo+IGJhc2UvMTY0MjIvMjMyNTMgaXMgdW5pbml0aWFsaXplZA0KPg0K
PiBGb2xsb3dpbmcgb3V0cHV0cyBhcmUgdGhlIHNhbWUgZm9yIG1hc3RlciBhbmQgc2xhdmU6DQo+
DQo+IFtyZXN1bHRzXQ0KDQpIbSwgT0suDQoNCj4gTm9uLWRlZmF1bHQgcGFyczoNCj4NCj4gW3Bh
cmFtc10NCg0KVGhlcmUgaXMgbm90aGluZyBmaXNoeSBoZXJlLg0KDQo+IFNsYXZlIHJlYnVpbGRl
ZCBhbmQgaXQncyBydW5uaW5nIGFsbW9zdCBhIHdlZWsgZm9yIG5vdy4NCg0KSG0uIEhhcyB0aGlz
IHNsYXZlIHJlcGxheWVkIHRoZSBzYW1lIFdBTCByZWNvcmRzIGFzIHRoZSBzbGF2ZSB0aGF0IGhh
cyBmYWlsZWQgcHJldmlvdXNseT8gT3IgZGlkIGl0IHVzZSBhIGZyZXNoZXIgYmFzZSBiYWNrdXA/
IElmIHRoYXQncyB0aGUgbGF0dGVyIHRoZSBwcm9ibGVtIHdvdWxkIGhhdmUgYmVlbiBmaXhlZCBi
eSBpdHNlbGYgZm9yIHRob3NlIHR3byByZWxhdGlvbiBwYWdlcyBhcyB0aGV5IHdvdWxkIGhhdmUg
YmVlbiBjb3JyZWN0bHkgY3JlYXRlZCBieSB0aGUgQW5kIGFuZCBub3QgdGhlIFdBTCByZXBsYXku
IFBlcmhhcHMgdGhhdCdzIHRvbyBsYXRlLCBidXQgY291bGQgaXQgYmUgcG9zc2libGUgdG8gc2Nh
biB0aGUgV0FMIHNlZ21lbnRzIHlvdSBoYXZlIGFuZCBzZWUgaWYgdGhlcmUgaXMgcmVjb3JkIHJl
ZmVycmluZyB0byB0aG9zZSBwYWdlcyBiZWluZyBpbml0aWFsaXplZCBvciBub3Q/IFlvdSB3b3Vs
ZCBuZWVkIHRvIGZpbmQgYSByZWNvcmQgbGlrZSB0aGF0Og0KW2luc2VydHx1cGRhdGV8bXVsdGkt
aW5zZXJ0fGhvdF91cGRhdGVdKGluaXQpICByZWwgJXUvJXUvJXU7IHRpZCAldS8ldSB0aWQgaXMg
dF9jdGlkIHJlZmVycmVkIGluIHRob3NlIHVwcGVyIHJlc3VsdHMgeW91IGp1c3Qgc2VudC4gQW5k
IHRoaXMgcmVjb3JkIHNob3VsZCBub3JtYWxseSBiZSBwcmVzZW50IGJlZm9yZSB0aGUgb25lcyB0
aGF0IGNhdXNlZCB0aGUgUEFOSUMgc2V0dGluZyB0aGUgdmlzaWJpbGl0eSBtYXAgYml0LiBJZiB0
aGF0J3Mgbm90IHRoZSBjYXNlLCBpdCBtYXkgYmUgcG9zc2libGUgdGhhdCB0aGVyZSBpcyBhY3R1
YWxseSBhIGJ1ZyBpZiB0aGUgcGFnZSBpcyBub3QgZm91bmQgYXMgYmVpbmcgaW5pdGlhbGl6ZWQg
cHJvcGVybHkgZmlyc3QuIEF0IGxlYXN0IHdlIGFyZSBzdXJlIHRoYXQgdGhlIGNvcnJ1cHRpb24g
aXMgbm90IGNvbWluZyBmcm9tIHRoZSBtYXN0ZXIuDQotLQ0KTWljaGFlbA0K

В списке pgsql-bugs по дате отправления:

Предыдущее
От: alirazaidi@hotmail.com
Дата:
Сообщение: BUG #13839: command line restart server fail
Следующее
От: Greg Clough
Дата:
Сообщение: Re: BUG #13770: Extending recovery_min_apply_delay on Standby causes it to be unavailable for a while