Home > mailing lists
BUG #14189: Corrupted WAL through replication protocol - Mailing list pgsql-bugs

From	root@simply.name
Subject	BUG #14189: Corrupted WAL through replication protocol
Date	June 14, 2016 13:35:07
Msg-id	20160614103415.5796.6885@wrigleys.postgresql.org Whole thread Raw
Responses	Re: BUG #14189: Corrupted WAL through replication protocol (Alvaro Herrera <alvherre@2ndquadrant.com>)
List	pgsql-bugs
Tree view
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE4OQpMb2dnZWQgYnk6ICAg
ICAgICAgIFZsYWRpbWlyIEJvcm9kaW4KRW1haWwgYWRkcmVzczogICAgICBy
b290QHNpbXBseS5uYW1lClBvc3RncmVTUUwgdmVyc2lvbjogOS41LjIKT3Bl
cmF0aW5nIHN5c3RlbTogICBSSEVMIDYKRGVzY3JpcHRpb246ICAgICAgICAK
CkhpIGFsbC4NCg0KT25lIG9mIG91ciBzdHJlYW1pbmcgcGh5c2ljYWwgc3Rh
bmRieXMgZ290IGEgYmFkIFdBTCB0aHJvdWdoIHJlcGxpY2F0aW9uCnByb3Rv
Y29sICh3ZSB1c2UgcmVwbGljYXRpb24gc2xvdHMpIGFmdGVyIG5ldHdvcmsg
ZmxhcCBiZXR3ZWVuIHByaW1hcnkgYW5kCnRoaXMgc3RhbmRieS4gQW5vdGhl
ciBzdHJlYW1pbmcgc3RhbmRieSBhbmQgYXJjaGl2ZSBnb3QgYSB2YWxpZCBX
QUwuIEJlbG93CmFyZSBzb21lIGRldGFpbHMuDQoNCkxvZyBvbiBwcmltYXJ5
Og0KWyAyMDE2LTA2LTE0IDExOjA0OjA0LjYyMyBNU0sKeGRiMjAxOGZfbWFp
bF95YW5kZXhfbmV0LHJlcGwsW3Vua25vd25dLDI1MjAxLDAwMDAwIF06TE9H
OiAgdGVybWluYXRpbmcKd2Fsc2VuZGVyIHByb2Nlc3MgZHVlIHRvIHJlcGxp
Y2F0aW9uIHRpbWVvdXQNCg0KTG9nIG9uIHN0YW5kYnk6DQpbIDIwMTYtMDYt
MTQgMTE6MDQ6MDQuNjI1IE1TSyAsLCwxOTEwMyxYWDAwMCBdOkZBVEFMOiAg
Y291bGQgbm90IHJlY2VpdmUKZGF0YSBmcm9tIFdBTCBzdHJlYW06IHNlcnZl
ciBjbG9zZWQgdGhlIGNvbm5lY3Rpb24gdW5leHBlY3RlZGx5DQogICAgICAg
ICAgICAgICAgVGhpcyBwcm9iYWJseSBtZWFucyB0aGUgc2VydmVyIHRlcm1p
bmF0ZWQgYWJub3JtYWxseQ0KICAgICAgICAgICAgICAgIGJlZm9yZSBvciB3
aGlsZSBwcm9jZXNzaW5nIHRoZSByZXF1ZXN0Lg0KDQpbIDIwMTYtMDYtMTQg
MTE6MDQ6MDQuNjI1IE1TSyAsLCwzMjYzMSxYWDAwMCBdOkZBVEFMOiAgaW52
YWxpZCBtZW1vcnkgYWxsb2MKcmVxdWVzdCBzaXplIDI2ODQzNzA5NDQNClsg
MjAxNi0wNi0xNCAxMTowNDowNC42MjggTVNLICwsLDMyNjI0LDAwMDAwIF06
TE9HOiAgc3RhcnR1cCBwcm9jZXNzIChQSUQKMzI2MzEpIGV4aXRlZCB3aXRo
IGV4aXQgY29kZSAxDQpbIDIwMTYtMDYtMTQgMTE6MDQ6MDQuNjI4IE1TSyAs
LCwzMjYyNCwwMDAwMCBdOkxPRzogIHRlcm1pbmF0aW5nIGFueSBvdGhlcgph
Y3RpdmUgc2VydmVyIHByb2Nlc3Nlcw0KDQpBbGwgb3RoZXIgYXR0ZW1wdHMg
dG8gc3RhcnQvcmVzdGFydCBmYWlsIHdpdGggdGhlIHNhbWUgZXJyb3IgbWVz
c2FnZSBiZWNhdXNlCm9mIGNvcnJ1cHRlZCBXQUwgb24gc3RhbmRieSdzIGZp
bGVzeXN0ZW0uDQoNClsgMjAxNi0wNi0xNCAxMTowNDowNC42NzIgTVNLIFt1
bmtub3duXSx3ZWIsbWFpbGRiLDk0OTEsNTdQMDMgXTpGQVRBTDogIHRoZQpk
YXRhYmFzZSBzeXN0ZW0gaXMgaW4gcmVjb3ZlcnkgbW9kZQ0KWyAyMDE2LTA2
LTE0IDExOjA1OjQ3LjA0NiBNU0sgLCwsMTI4NjksMDAwMDAgXTpMT0c6ICBk
YXRhYmFzZSBzeXN0ZW0gd2FzCmludGVycnVwdGVkIHdoaWxlIGluIHJlY292
ZXJ5IGF0IGxvZyB0aW1lIDIwMTYtMDYtMTQgMTA6MzE6MjUgTVNLDQpbIDIw
MTYtMDYtMTQgMTE6MDU6NDcuMDQ2IE1TSyAsLCwxMjg2OSwwMDAwMCBdOkhJ
TlQ6ICBJZiB0aGlzIGhhcyBvY2N1cnJlZAptb3JlIHRoYW4gb25jZSBzb21l
IGRhdGEgbWlnaHQgYmUgY29ycnVwdGVkIGFuZCB5b3UgbWlnaHQgbmVlZCB0
byBjaG9vc2UgYW4KZWFybGllciByZWNvdmVyeSB0YXJnZXQuDQpbIDIwMTYt
MDYtMTQgMTE6MDU6NTAuMjI5IE1TSyAsLCwxMjg2OSwwMDAwMCBdOkxPRzog
IGVudGVyaW5nIHN0YW5kYnkgbW9kZQ0KWyAyMDE2LTA2LTE0IDExOjA1OjUw
LjM1NSBNU0sgLCwsMTI4NjksMDAwMDAgXTpMT0c6ICByZWRvIHN0YXJ0cyBh
dAoyNERBLzhGMDA5N0QwDQpbIDIwMTYtMDYtMTQgMTE6MDY6MTMuMzc1IE1T
SyAsLCwxMjg2OSwwMDAwMCBdOkxPRzogIGNvbnNpc3RlbnQgcmVjb3ZlcnkK
c3RhdGUgcmVhY2hlZCBhdCAyNERCLzcxRUEwNEM4DQpbIDIwMTYtMDYtMTQg
MTE6MDY6MTMuMzc2IE1TSyAsLCwxMjg2MCwwMDAwMCBdOkxPRzogIGRhdGFi
YXNlIHN5c3RlbSBpcwpyZWFkeSB0byBhY2NlcHQgcmVhZCBvbmx5IGNvbm5l
Y3Rpb25zDQpbIDIwMTYtMDYtMTQgMTE6MDY6MTMuMzg5IE1TSyAsLCwxMjg2
OSxYWDAwMCBdOkZBVEFMOiAgaW52YWxpZCBtZW1vcnkgYWxsb2MKcmVxdWVz
dCBzaXplIDI2ODQzNzA5NDQNClsgMjAxNi0wNi0xNCAxMTowNjoxMy4zOTEg
TVNLICwsLDEyODYwLDAwMDAwIF06TE9HOiAgc3RhcnR1cCBwcm9jZXNzIChQ
SUQKMTI4NjkpIGV4aXRlZCB3aXRoIGV4aXQgY29kZSAxDQpbIDIwMTYtMDYt
MTQgMTE6MDY6MTMuMzkyIE1TSyAsLCwxMjg2MCwwMDAwMCBdOkxPRzogIHRl
cm1pbmF0aW5nIGFueSBvdGhlcgphY3RpdmUgc2VydmVyIHByb2Nlc3Nlcw0K
DQoNCldBTCBmaWxlIDAwMDAwMDAxMDAwMDI0REIwMDAwMDA3MiBvbiB0d28g
c3RhbmRieXMgZGlmZmVyczoNCg0Kcm9vdEB4ZGIyMDE4ZiAvdG1wICMgbWQ1
c3VtIC90bXAve25vcm1hbCxwcm9ibGVtfS8wMDAwMDAwMTAwMDAyNERCMDAw
MDAwNzINCmRmZDEyMzI4OWFjN2E3ZGJlOGMxMzU1NjU0YzJjZmM3ICAvdG1w
L25vcm1hbC8wMDAwMDAwMTAwMDAyNERCMDAwMDAwNzINCmI4YWFlOTkxMGY5
ZTgzM2NmMjFlMWQyNDEwNTFhNzMyICAvdG1wL3Byb2JsZW0vMDAwMDAwMDEw
MDAwMjREQjAwMDAwMDcyDQpyb290QHhkYjIwMThmIC90bXAgIw0KDQpCdXQg
bm90IHRoZSB3aG9sZSBmaWxlLCBvbmx5IGFmdGVyIGNlcnRhaW4gTFNOOg0K
DQpyb290QHhkYjIwMThmIH4gIyAvdXNyL3Bnc3FsLTkuNS9iaW4vcGdfeGxv
Z2R1bXAKL3RtcC9ub3JtYWwvMDAwMDAwMDEwMDAwMjREQjAwMDAwMDcyIC90
bXAvbm9ybWFsLzAwMDAwMDAxMDAwMDI0REIwMDAwMDA3MiAtZQoyNERCLzcy
MDk1Q0M4IHwgbWQ1c3VtDQoyNGEyNGRiMGIwZDMyZWM1ZDQyZWFjNjE5NTVj
MjMxYiAgLQ0Kcm9vdEB4ZGIyMDE4ZiB+ICMgL3Vzci9wZ3NxbC05LjUvYmlu
L3BnX3hsb2dkdW1wCi90bXAvcHJvYmxlbS8wMDAwMDAwMTAwMDAyNERCMDAw
MDAwNzIgL3RtcC9wcm9ibGVtLzAwMDAwMDAxMDAwMDI0REIwMDAwMDA3Mgot
ZSAyNERCLzcyMDk1Q0M4IHwgbWQ1c3VtDQoyNGEyNGRiMGIwZDMyZWM1ZDQy
ZWFjNjE5NTVjMjMxYiAgLQ0Kcm9vdEB4ZGIyMDE4ZiB+ICMNCg0Kcm9vdEB4
ZGIyMDE4ZiAvdG1wICMgL3Vzci9wZ3NxbC05LjUvYmluL3BnX3hsb2dkdW1w
Ci90bXAvbm9ybWFsLzAwMDAwMDAxMDAwMDI0REIwMDAwMDA3MiAvdG1wL25v
cm1hbC8wMDAwMDAwMTAwMDAyNERCMDAwMDAwNzIgfApmZ3JlcCAtQzEgMjRE
Qi83MjA5NUNDOA0Kcm1ncjogR2luICAgICAgICAgbGVuIChyZWMvdG90KTog
ICAgICAyLyAgMzg3NSwgdHg6ICAxOTM4MjA3MTIsIGxzbjoKMjREQi83MjA5
NERBMCwgcHJldiAyNERCLzcyMDk0NDYwLCBkZXNjOiBJTlNFUlQgaXNkYXRh
OiBGIGlzbGVhZjogVAppc2RlbGV0ZTogVCwgYmxrcmVmICMwOiByZWwgMTY2
My8xNjQwMC8xODAzMCBibGsgMzY4MzUwIEZQVw0Kcm1ncjogR2luICAgICAg
ICAgbGVuIChyZWMvdG90KTogICAgICAyLyAgIDM4OCwgdHg6ICAxOTM4MjA3
MTIsIGxzbjoKMjREQi83MjA5NUNDOCwgcHJldiAyNERCLzcyMDk0REEwLCBk
ZXNjOiBJTlNFUlQgaXNkYXRhOiBGIGlzbGVhZjogVAppc2RlbGV0ZTogVCwg
YmxrcmVmICMwOiByZWwgMTY2My8xNjQwMC8xODAzMCBibGsgMzY4MzUwDQpy
bWdyOiBHaW4gICAgICAgICBsZW4gKHJlYy90b3QpOiAgICAgIDIvICAgNDEy
LCB0eDogIDE5MzgyMDcxMiwgbHNuOgoyNERCLzcyMDk1RTUwLCBwcmV2IDI0
REIvNzIwOTVDQzgsIGRlc2M6IElOU0VSVCBpc2RhdGE6IEYgaXNsZWFmOiBU
CmlzZGVsZXRlOiBULCBibGtyZWYgIzA6IHJlbCAxNjYzLzE2NDAwLzE4MDMw
IGJsayAzNjgzNTANCnJtZ3I6IEJ0cmVlICAgICAgIGxlbiAocmVjL3RvdCk6
ICAgICAgMi8gIDMzMjMsIHR4OiAgMTkzODIwNzA0LCBsc246CjI0REIvNzIw
OTVGRjAsIHByZXYgMjREQi83MjA5NUU1MCwgZGVzYzogSU5TRVJUX0xFQUYg
b2ZmIDk0LCBibGtyZWYgIzA6IHJlbAoxNjYzLzE2NDAwLzE3NTY1IGJsayA3
NDg4MDQwIEZQVw0Kcm9vdEB4ZGIyMDE4ZiAvdG1wICMNCg0Kcm9vdEB4ZGIy
MDE4ZiAvdG1wICMgL3Vzci9wZ3NxbC05LjUvYmluL3BnX3hsb2dkdW1wCi90
bXAvcHJvYmxlbS8wMDAwMDAwMTAwMDAyNERCMDAwMDAwNzIgL3RtcC9wcm9i
bGVtLzAwMDAwMDAxMDAwMDI0REIwMDAwMDA3Mgp8IGZncmVwIC1DMSAyNERC
LzcyMDk1Q0M4DQpwZ194bG9nZHVtcDogRkFUQUw6ICBlcnJvciBpbiBXQUwg
cmVjb3JkIGF0IDI0REIvNzIwOTVFNTA6IHVuZXhwZWN0ZWQKcGFnZWFkZHIg
MjREOS8yMzA5NjAwMCBpbiBsb2cgc2VnbWVudCAwMDAwMDAwMDAwMDAyNERC
MDAwMDAwNzIsIG9mZnNldAo2MTQ0MDANCnJtZ3I6IEdpbiAgICAgICAgIGxl
biAocmVjL3RvdCk6ICAgICAgMi8gIDM4NzUsIHR4OiAgMTkzODIwNzEyLCBs
c246CjI0REIvNzIwOTREQTAsIHByZXYgMjREQi83MjA5NDQ2MCwgZGVzYzog
SU5TRVJUIGlzZGF0YTogRiBpc2xlYWY6IFQKaXNkZWxldGU6IFQsIGJsa3Jl
ZiAjMDogcmVsIDE2NjMvMTY0MDAvMTgwMzAgYmxrIDM2ODM1MCBGUFcNCg0K
cm1ncjogR2luICAgICAgICAgbGVuIChyZWMvdG90KTogICAgICAyLyAgIDM4
OCwgdHg6ICAxOTM4MjA3MTIsIGxzbjoKMjREQi83MjA5NUNDOCwgcHJldiAy
NERCLzcyMDk0REEwLCBkZXNjOiBJTlNFUlQgaXNkYXRhOiBGIGlzbGVhZjog
VAppc2RlbGV0ZTogVCwgYmxrcmVmICMwOiByZWwgMTY2My8xNjQwMC8xODAz
MCBibGsgMzY4MzUwDQpybWdyOiBHaW4gICAgICAgICBsZW4gKHJlYy90b3Qp
OiAgICAgIDIvICAgNDEyLCB0eDogIDE5MzgyMDcxMiwgbHNuOgoyNERCLzcy
MDk1RTUwLCBwcmV2IDI0REIvNzIwOTVDQzgsIGRlc2M6IElOU0VSVCBpc2Rh
dGE6IEYgaXNsZWFmOiBUCmlzZGVsZXRlOiBULCBibGtyZWYgIzA6IHJlbCAx
NjYzLzE2NDAwLzE4MDMwIGJsayAzNjgzNTANCnJvb3RAeGRiMjAxOGYgL3Rt
cCAjDQoNCkJvdGggV0FMcyAobm9ybWFsIGFuZCBwcm9ibGVtIGNvdWxkIGJl
IGRvd25sb2FkZWQgZnJvbQpodHRwczovL3lhZGkuc2svZC9MalZIOHA0enNV
SHR5KS4gT3RoZXIgV0FMcyBhZnRlciAwMDAwMDAwMTAwMDAyNERCMDAwMDAw
NzIKYWxzbyBkaWZmZXIuDQoNClJlY292ZXJ5LmNvbmYgb24gc3RhbmRieToN
CnJvb3RAeGRiMjAxOGYgfiAjIGNhdCAvdmFyL2xpYi9wZ3NxbC85LjUvZGF0
YS9yZWNvdmVyeS5jb25mDQpzdGFuZGJ5X21vZGUgPSAnb24nDQpyZWNvdmVy
eV90YXJnZXRfdGltZWxpbmUgPSAnbGF0ZXN0Jw0KcHJpbWFyeV9jb25uaW5m
byA9ICdob3N0PXhkYjIwMThnLm1haWwueWFuZGV4Lm5ldCBwb3J0PTU0MzIg
dXNlcj1yZXBsCmFwcGxpY2F0aW9uX25hbWU9eGRiMjAxOGZfbWFpbF95YW5k
ZXhfbmV0Jw0KcHJpbWFyeV9zbG90X25hbWUgPSAneGRiMjAxOGZfbWFpbF95
YW5kZXhfbmV0Jw0Kcm9vdEB4ZGIyMDE4ZiB+ICMNCg0KUmVwbGljYXRpb25z
IHNldHRpbmdzIGluIHBvc3RncmVzcWwuY29uZiAodGhlIHNhbWUgb24gYm90
aCBwcmltYXJ5IGFuZCBhbGwKc3RhbmRieXMpOg0KeGRiMjAxOGYvcG9zdGdy
ZXMgUiAjIFNFTEVDVCBuYW1lLCBzZXR0aW5nIEZST00gcGdfc2V0dGluZ3MN
CldIRVJFIGNhdGVnb3J5IExJS0UgJ1dyaXRlLUFoZWFkIExvZyUnIE9SIGNh
dGVnb3J5IExJS0UgJ1JlcGxpY2F0aW9uJSc7DQogICAgICAgICAgICAgbmFt
ZSAgICAgICAgICAgICB8ICAgIHNldHRpbmcNCi0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0NCiBhcmNoaXZlX2NvbW1h
bmQgICAgICAgICAgICAgIHwgY3AgJXAgd2Fscy8lZg0KIGFyY2hpdmVfbW9k
ZSAgICAgICAgICAgICAgICAgfCBvbg0KIGFyY2hpdmVfdGltZW91dCAgICAg
ICAgICAgICAgfCAwDQogY2hlY2twb2ludF9jb21wbGV0aW9uX3RhcmdldCB8
IDAuOQ0KIGNoZWNrcG9pbnRfdGltZW91dCAgICAgICAgICAgfCAzNjAwDQog
Y2hlY2twb2ludF93YXJuaW5nICAgICAgICAgICB8IDQyMA0KIGNvbW1pdF9k
ZWxheSAgICAgICAgICAgICAgICAgfCAwDQogY29tbWl0X3NpYmxpbmdzICAg
ICAgICAgICAgICB8IDUNCiBmc3luYyAgICAgICAgICAgICAgICAgICAgICAg
IHwgb24NCiBmdWxsX3BhZ2Vfd3JpdGVzICAgICAgICAgICAgIHwgb24NCiBo
b3Rfc3RhbmRieSAgICAgICAgICAgICAgICAgIHwgb24NCiBob3Rfc3RhbmRi
eV9mZWVkYmFjayAgICAgICAgIHwgb24NCiBtYXhfcmVwbGljYXRpb25fc2xv
dHMgICAgICAgIHwgMTANCiBtYXhfc3RhbmRieV9hcmNoaXZlX2RlbGF5ICAg
IHwgMzAwMDANCiBtYXhfc3RhbmRieV9zdHJlYW1pbmdfZGVsYXkgIHwgMzAw
MDANCiBtYXhfd2FsX3NlbmRlcnMgICAgICAgICAgICAgIHwgMTANCiBtYXhf
d2FsX3NpemUgICAgICAgICAgICAgICAgIHwgMTAyNA0KIG1pbl93YWxfc2l6
ZSAgICAgICAgICAgICAgICAgfCA2NA0KIHN5bmNocm9ub3VzX2NvbW1pdCAg
ICAgICAgICAgfCBvbg0KIHN5bmNocm9ub3VzX3N0YW5kYnlfbmFtZXMgICAg
fA0KIHRyYWNrX2NvbW1pdF90aW1lc3RhbXAgICAgICAgfCBvZmYNCiB2YWN1
dW1fZGVmZXJfY2xlYW51cF9hZ2UgICAgIHwgMA0KIHdhbF9idWZmZXJzICAg
ICAgICAgICAgICAgICAgfCAyMDQ4DQogd2FsX2NvbXByZXNzaW9uICAgICAg
ICAgICAgICB8IG9uDQogd2FsX2tlZXBfc2VnbWVudHMgICAgICAgICAgICB8
IDY0DQogd2FsX2xldmVsICAgICAgICAgICAgICAgICAgICB8IGhvdF9zdGFu
ZGJ5DQogd2FsX2xvZ19oaW50cyAgICAgICAgICAgICAgICB8IG9mZg0KIHdh
bF9yZWNlaXZlcl9zdGF0dXNfaW50ZXJ2YWwgfCAxDQogd2FsX3JlY2VpdmVy
X3RpbWVvdXQgICAgICAgICB8IDYwMDAwDQogd2FsX3JldHJpZXZlX3JldHJ5
X2ludGVydmFsICB8IDUwMDANCiB3YWxfc2VuZGVyX3RpbWVvdXQgICAgICAg
ICAgIHwgMzAwMA0KIHdhbF9zeW5jX21ldGhvZCAgICAgICAgICAgICAgfCBm
ZGF0YXN5bmMNCiB3YWxfd3JpdGVyX2RlbGF5ICAgICAgICAgICAgIHwgMjAw
DQooMzMgcm93cykNCg0KVGltZTogMS4wMDcgbXMNCnhkYjIwMThmL3Bvc3Rn
cmVzIFIgIw0KDQpQR0RBVEEgYW5kIHBnX3hsb2cgZGlyZWN0b3J5IGFyZSBi
b3RoIG1kYWRtIHJhaWQxMCBhcnJheXMgYW5kIG1vdW50ZWQgd2l0aApzdGFu
ZGFyZCBvcHRpb25zOg0Kcm9vdEB4ZGIyMDE4ZiB+ICMgbW91bnQgfCBmZ3Jl
cCBwZ3NxbA0KL2Rldi9tZDQgb24gL3Zhci9saWIvcGdzcWwvOS41L2RhdGEg
dHlwZSBleHQ0IChydyxub2F0aW1lLG5vZGlyYXRpbWUpDQovZGV2L21kMyBv
biAvdmFyL2xpYi9wZ3NxbC85LjUvZGF0YS9wZ194bG9nIHR5cGUgZXh0NAoo
cncsbm9hdGltZSxub2RpcmF0aW1lKQ0Kcm9vdEB4ZGIyMDE4ZiB+ICMNCg0K
U2hvdWxkIEkgcHJvdmlkZSBzb21lIG1vcmUgZGlhZ25vc3RpY3M/Cgo=
pgsql-bugs by date:
From: gabrimonfa@gmail.com
Date: 14 June 2016, 12:49:05
Subject: BUG #14188: "FOR SELECT DISTINCT, ORDER BY expressions must appear IN SELECT list" error and table alias
From: Tom Lane
Date: 14 June 2016, 16:30:02
Subject: Re: BUG #13907: Restore materialized view throw permission denied
BUG #14189: Corrupted WAL through replication protocol - Mailing list pgsql-bugs

Previous

Next
