Home > mailing lists
BUG #14324: Deadlock? between queries and startup process on standby replica. - Mailing list pgsql-bugs

From	maxim.boguk@gmail.com
Subject	BUG #14324: Deadlock? between queries and startup process on standby replica.
Date	September 14, 2016 11:48:12
Msg-id	20160914084756.1420.59188@wrigleys.postgresql.org Whole thread Raw
List	pgsql-bugs
Tree view
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDMyNApMb2dnZWQgYnk6ICAg
ICAgICAgIE1ha3N5bSBCb2d1awpFbWFpbCBhZGRyZXNzOiAgICAgIG1heGlt
LmJvZ3VrQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNC43Ck9w
ZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAK
CkhpLA0KDQpJIGZvdW5kIHN0cmFuZ2UgaXNzdWUgd2hlbiBvbmUgb2Ygc3Rh
bmRieSByZXBsaWNhIHN0b3BwZWQgcmVwbGF5aW5nIHdhbC4NCg0KRHVyaW5n
IGludmVzdGlnYXRpb24gb2YgdGhlIGlzc3VlIEkgZm91bmQgdGhlIGZvbGxv
d2luZyBmYWN0czoNCg0KMSlzdGFydHVwIHByb2Nlc3Mgd2FpdGluZyBmb3Ig
c29tZXRoaW5nOg0KDQpwcyAtYXh1d3cgfCBncmVwIHN0YXJ0dXANCnBvc3Rn
cmVzICAxNTc3ICAyLjEgIDAuMCAxNzczNjAgNzY2MTYgPyAgICAgICAgU3Mg
ICBTZXAxMiAgNTY6NDkgcG9zdGdyZXM6CnN0YXJ0dXAgcHJvY2VzcyAgIHJl
Y292ZXJpbmcgMDAwMDAwMDEwMDAwODc0ODAwMDAwMDJBIHdhaXRpbmcNCih3
YWwgcG9zaXRpb24gZG9lc24ndCBhZHZhbmNlIGF0IGFsbCkNCg0KMilhbGwg
bG9ja3MgZm9yIHBpZD0xNTc3IGFyZSBzZWVtcyB0byBiZSBncmFudGVkOg0K
DQpzZWxlY3QgKiBmcm9tIHBnX2xvY2tzIHdoZXJlIHBpZD0xNTc3Ow0KICBs
b2NrdHlwZSAgfCBkYXRhYmFzZSB8IHJlbGF0aW9uICB8IHBhZ2UgfCB0dXBs
ZSB8IHZpcnR1YWx4aWQgfAp0cmFuc2FjdGlvbmlkIHwgY2xhc3NpZCB8IG9i
amlkIHwgb2Jqc3ViaWQgfCB2aXJ0dWFsdHJhbnNhY3Rpb24gfCBwaWQgIHwg
ICAgCiAgIG1vZGUgICAgICAgICB8IGdyYW50ZWQgfCBmYXN0cGF0aA0KLS0t
LS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tKy0tLS0t
LS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0t
LS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLSst
LS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0NCiB2
aXJ0dWFseGlkIHwgICAgICAgICAgfCAgICAgICAgICAgfCAgICAgIHwgICAg
ICAgfCAxLzEgICAgICAgIHwgICAgICAgICAgICAKICB8ICAgICAgICAgfCAg
ICAgICB8ICAgICAgICAgIHwgMS8wICAgICAgICAgICAgICAgIHwgMTU3NyB8
IEV4Y2x1c2l2ZUxvY2sgIAogICAgfCB0ICAgICAgIHwgdA0KIHJlbGF0aW9u
ICAgfCAgICAxNjQyNCB8IDE2Njc4MjE5OSB8ICAgICAgfCAgICAgICB8ICAg
ICAgICAgICAgfCAgICAgICAgICAgIAogIHwgICAgICAgICB8ICAgICAgIHwg
ICAgICAgICAgfCAxLzAgICAgICAgICAgICAgICAgfCAxNTc3IHwKQWNjZXNz
RXhjbHVzaXZlTG9jayB8IHQgICAgICAgfCBmDQogcmVsYXRpb24gICB8ICAg
IDE2NDI0IHwgMTY2NzgyMTk2IHwgICAgICB8ICAgICAgIHwgICAgICAgICAg
ICB8ICAgICAgICAgICAgCiAgfCAgICAgICAgIHwgICAgICAgfCAgICAgICAg
ICB8IDEvMCAgICAgICAgICAgICAgICB8IDE1NzcgfApBY2Nlc3NFeGNsdXNp
dmVMb2NrIHwgdCAgICAgICB8IGYNCiByZWxhdGlvbiAgIHwgICAgMTY0MjQg
fCAgICAgMTcyNTYgfCAgICAgIHwgICAgICAgfCAgICAgICAgICAgIHwgICAg
ICAgICAgICAKICB8ICAgICAgICAgfCAgICAgICB8ICAgICAgICAgIHwgMS8w
ICAgICAgICAgICAgICAgIHwgMTU3NyB8CkFjY2Vzc0V4Y2x1c2l2ZUxvY2sg
fCB0ICAgICAgIHwgZg0KDQozKXRoZXJlIGFyZSBjdXJpb3MgcmVsYXRpb25z
IGluIHByZXZpb3VzIHBnX2xvY2sgZGF0YSAoMTY2NzgyMTk5ICBhbmQKMTY2
NzgyMTk2KSB3aGljaCBhcmVuJ3QgY29ycmVzcG9uZGluZyBhbnkgZW50cmll
cyBpbiBwZ19jbGFzcyBvbiB0YXJnZXQKZGF0YWJhc2UuDQpJIGNoZWNrZWQg
cGdfY2xhc3Mgb24gdGFyZ2V0IHJlcGxpY2EsIG9uIG1hc3RlciBkYiBhbmQg
KGFzIGxhc3QgYXR0ZW1wdCB0bwpmaW5kIHdoYXRzIGdvaW5nIG9uKSB2aWEg
cGdfZHVtcCAtRiBwIC1zIC0tYmluYXJ5LXVwZ3JhZGUgZGJuYW1lLiBOYWRh
Lg0KDQo0KUV2ZXJ5IG9wZW4gdHJhbnNhY3Rpb24gaW4gdGhpcyBwcm9ibGVt
IHNsYXZlIGhhdmUgKGluIHBnX3N0YXRfYWN0aXZpdHkpIAoNCndhaXRpbmc9
dHJ1ZQ0Kc3RhdGU9YWN0aXZlDQphbmQgYWxsIG9mIHRoZW0gc3R1Y2sgYXJv
dW5kIHRoZSBzYW1lIHRpbWUgYXMgc3RhcnR1cCBwcm9jZXNzIHN0dWNrLg0K
DQo1KUV2ZXJ5IG9wZW4gKGFuZCB3YWl0aW5nIHRyYW5zYWN0aW9ucykgb24g
dGhpcyBzbGF2ZSBoYXZlIG5vdCBncmFudGVkCkFjY2Vzc1NoYXJlTG9jayBv
biByZWxhdGlvbiAxNzI1NiAod2hpY2ggaXMgZXhwZWN0ZWQgYmVjYXVzZSBz
dGFydHVwIHByb2Nlc3MKaGF2ZSBBY2Nlc3NFeGNsdXNpdmVMb2NrIG9uIGl0
KToNCiBsb2NrdHlwZSB8IGRhdGFiYXNlIHwgcmVsYXRpb24gfCBwYWdlIHwg
dHVwbGUgfCB2aXJ0dWFseGlkIHwgdHJhbnNhY3Rpb25pZAp8IGNsYXNzaWQg
fCBvYmppZCB8IG9ianN1YmlkIHwgdmlydHVhbHRyYW5zYWN0aW9uIHwgIHBp
ZCAgfCAgICAgIG1vZGUgICAgICAKfCBncmFudGVkIHwgZmFzdHBhdGgNCi0t
LS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLSstLS0tLS0t
Ky0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0t
LS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tKy0t
LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tDQogcmVsYXRp
b24gfCAgICAxNjQyNCB8ICAgIDE3MjU2IHwgICAgICB8ICAgICAgIHwgICAg
ICAgICAgICB8ICAgICAgICAgICAgICAKfCAgICAgICAgIHwgICAgICAgfCAg
ICAgICAgICB8IDE2Ny84MzggICAgICAgICAgICB8ICAgMzc2IHwgQWNjZXNz
U2hhcmVMb2NrCnwgZiAgICAgICB8IGYNCiByZWxhdGlvbiB8ICAgIDE2NDI0
IHwgICAgMTcyNTYgfCAgICAgIHwgICAgICAgfCAgICAgICAgICAgIHwgICAg
ICAgICAgICAgIAp8ICAgICAgICAgfCAgICAgICB8ICAgICAgICAgIHwgMTcw
LzUwMyAgICAgICAgICAgIHwgICAzNzcgfCBBY2Nlc3NTaGFyZUxvY2sKfCBm
ICAgICAgIHwgZg0KIHJlbGF0aW9uIHwgICAgMTY0MjQgfCAgICAxNzI1NiB8
ICAgICAgfCAgICAgICB8ICAgICAgICAgICAgfCAgICAgICAgICAgICAgCnwg
ICAgICAgICB8ICAgICAgIHwgICAgICAgICAgfCAxNzMvMTYyICAgICAgICAg
ICAgfCAgMTY4MCB8IEFjY2Vzc1NoYXJlTG9jawp8IGYgICAgICAgfCBmDQog
cmVsYXRpb24gfCAgICAxNjQyNCB8ICAgIDE3MjU2IHwgICAgICB8ICAgICAg
IHwgICAgICAgICAgICB8ICAgICAgICAgICAgICAKfCAgICAgICAgIHwgICAg
ICAgfCAgICAgICAgICB8IDE2Ni8xNTU4ICAgICAgICAgICB8ICAxNzI5IHwg
QWNjZXNzU2hhcmVMb2NrCnwgZiAgICAgICB8IGYNCi4uLg0KYW5kIHNvIG9u
Lg0KDQo2KUtpbGxpbmcgZmV3IGluZGl2aWR1YWwgb2xkZXN0IG9wZW4gdHJh
bnNhY3Rpb25zIGRvZXNuJ3QgZml4IGlzc3VlLg0KDQo3KUZ1bGwgbG9jayBp
bmZvIGZvciBzdHVjayB0cmFuc2FjdGlvbiBsb29rIGxpa2UgKHRoZXkgYXJl
IHRoZSBzYW1lIGJ5CnN0cnVjdHVyZSBvZiBxdWVyaWVzKToNCnNlbGVjdCAq
IGZyb20gcGdfbG9ja3Mgd2hlcmUgcGlkPTM3NiA7DQogIGxvY2t0eXBlICB8
IGRhdGFiYXNlIHwgcmVsYXRpb24gfCBwYWdlIHwgdHVwbGUgfCB2aXJ0dWFs
eGlkIHwKdHJhbnNhY3Rpb25pZCB8IGNsYXNzaWQgfCBvYmppZCB8IG9ianN1
YmlkIHwgdmlydHVhbHRyYW5zYWN0aW9uIHwgcGlkIHwgICAgIAptb2RlICAg
ICAgIHwgZ3JhbnRlZCB8IGZhc3RwYXRoDQotLS0tLS0tLS0tLS0rLS0tLS0t
LS0tLSstLS0tLS0tLS0tKy0tLS0tLSstLS0tLS0tKy0tLS0tLS0tLS0tLSst
LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0rLS0tLS0tLS0tLSst
LS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLSstLS0tLS0tLS0tLS0tLS0tLSst
LS0tLS0tLS0rLS0tLS0tLS0tLQ0KIHJlbGF0aW9uICAgfCAgICAxNjQyNCB8
ICAgIDE2OTM3IHwgICAgICB8ICAgICAgIHwgICAgICAgICAgICB8ICAgICAg
ICAgICAgIAogfCAgICAgICAgIHwgICAgICAgfCAgICAgICAgICB8IDE2Ny84
MzggICAgICAgICAgICB8IDM3NiB8IEFjY2Vzc1NoYXJlTG9jayB8CnQgICAg
ICAgfCB0DQogcmVsYXRpb24gICB8ICAgIDE2NDI0IHwgODg3ODE1MjAgfCAg
ICAgIHwgICAgICAgfCAgICAgICAgICAgIHwgICAgICAgICAgICAgCiB8ICAg
ICAgICAgfCAgICAgICB8ICAgICAgICAgIHwgMTY3LzgzOCAgICAgICAgICAg
IHwgMzc2IHwgQWNjZXNzU2hhcmVMb2NrIHwKdCAgICAgICB8IHQNCiByZWxh
dGlvbiAgIHwgICAgMTY0MjQgfCAgICAxODE1MCB8ICAgICAgfCAgICAgICB8
ICAgICAgICAgICAgfCAgICAgICAgICAgICAKIHwgICAgICAgICB8ICAgICAg
IHwgICAgICAgICAgfCAxNjcvODM4ICAgICAgICAgICAgfCAzNzYgfCBBY2Nl
c3NTaGFyZUxvY2sgfAp0ICAgICAgIHwgdA0KIHZpcnR1YWx4aWQgfCAgICAg
ICAgICB8ICAgICAgICAgIHwgICAgICB8ICAgICAgIHwgMTY3LzgzOCAgICB8
ICAgICAgICAgICAgIAogfCAgICAgICAgIHwgICAgICAgfCAgICAgICAgICB8
IDE2Ny84MzggICAgICAgICAgICB8IDM3NiB8IEV4Y2x1c2l2ZUxvY2sgICB8
CnQgICAgICAgfCB0DQogcmVsYXRpb24gICB8ICAgIDE2NDI0IHwgICAgMTcy
NTYgfCAgICAgIHwgICAgICAgfCAgICAgICAgICAgIHwgICAgICAgICAgICAg
CiB8ICAgICAgICAgfCAgICAgICB8ICAgICAgICAgIHwgMTY3LzgzOCAgICAg
ICAgICAgIHwgMzc2IHwgQWNjZXNzU2hhcmVMb2NrIHwKZiAgICAgICB8IGYN
Cg0KOClzdHJhY2UgZm9yIHN0YXJ0dXAgcHJvY2VzcyAoc3RyYWNlIC1wIDE1
NzcpIGRvZXNuJ3QgcHJvZHVjZSBhbnl0aGluZwp1c2VmdWwuLi4gb25seSBl
bmRsZXNzOg0Kc2VsZWN0KDAsIE5VTEwsIE5VTEwsIE5VTEwsIHsxLCAwfSkg
ICAgID0gMCAoVGltZW91dCkNCg0KOSlzaXR1YXRpb24gaGFwcGVuZWQgbm90
IHRoZSBmaXJzdCB0aW1lIChtYXkgYmUgb25jZSBwZXIgbW9udGggb3Igc28p
IGFmdGVyCmNyZWF0aW9uIG9mIGRpZmZlcmVudCBGSyBvbiB0aGUgbWFzdGVy
IGRhdGFiYXNlLg0KVGhpcyB0aW1lIGl0IGhhcHBlbmVkIGFmdGVyIHJ1bm5p
bmc6DQpDUkVBVEUgVEFCTEUgZW1wbG95ZXJfdmFjYW5jeV9wdXNoX3N1YnNj
cmlwdGlvbiAoDQouLi4NCiAgdXNlcl9pZCBJTlRFR0VSIE5PVCBOVUxMIFJF
RkVSRU5DRVMgaGh1c2VyICh1c2VyX2lkKSwNCiAgdmFjYW5jeV9pZCBJTlRF
R0VSIE5PVCBOVUxMIFJFRkVSRU5DRVMgdmFjYW5jeSAodmFjYW5jeV9pZCks
DQouLi4NCik7IA0KVGFibGUgaGh1c2VyIGhhdmUgT0lEPTE3MjU2ICh0aGlz
IGxvY2sgbm90IGdyYW50ZWQgZm9yIGFsbCB3YWl0aW5nCnRyYW5zYWN0aW9u
cykNClRhYmxlIHZhY2FuY3kgaGF2ZSBPSUQ9MTgxNTAgKHdoaWNoIGdyYW50
ZWQgZm9yIGFsbCB3YWl0aW5nIHRyYW5zYWN0aW9ucyksCmJ1dCAocG9zc2li
bGUpIG5vdCBncmFudGVkIGZvciBzdGFydHVwIHByb2Nlc3MuDQoNCg0KMTAp
RXZlbiBraWxsaW5nIHRoZSBhbGwgd2FpdGluZyB0cmFuc2FjdGlvbiBkb2Vz
bid0IGhlbHAsIGJlY2F1c2UgaW4gc2FtZQppbnN0YW50IG1vcmUgc2FtZSB0
cmFuc2FjdGlvbnMgd2lsbCBiZSBvcGVuIChpdCdzIHF1aXRlIGhlYXZ5IGxv
YWQgZXZlbiBpZgpub24taW50ZXJhY3RpdmUgREIpLCBhbmQgc3R1Y2sgdGhl
IHN0YXJ0dXAgcHJvY2VzcyBpbiB0aGUgc2FtZSBwbGFjZQphZ2Fpbi4NCk9u
bHkgbWFudWFsIHBhdXNpbmcgYWxsIGFjdGl2aXR5IHZpYSBwZ2JvdW5jZXIg
YW5kIGtpbGxpbmcgYWxsIHN0dWNrCnRyYW5zYWN0aW9ucyAodG8gbGV0IHN0
YXJ0dXAgcHJvY2VzcyBwcm9ncmVzcyB0aGlzIHdhbCByZWNvcmQpIGZpeGlu
Zwpwcm9ibGVtLg0KDQoNClBvc3NpYmxlIChidXQgbGlrZWx5KSBleHBsYW5h
dGlvbiBvZiB3aGF0J3MgZ29pbmcgb246DQpzdGFydHVwIHByb2Nlc3MgYXR0
ZW1wdCB0byByZXBsYXkgd2FsIHJlY29yZCBmb3IgY3JlYXRlIHRhYmxlLCB3
aGljaCByZXF1aXJlCkFjY2Vzc0V4Y2x1c2l2ZUxvY2sgb24gaGh1c2VyIChP
SUQ9MTcyNTYpIHdoaWNoIGhlIHN1Y2Nlc3NmdWxseSBnZXQsDQpidXQgb25j
ZSBzdGFydHVwIHByb2Nlc3MgYXR0ZW1wdCBncmFiIGEgQWNjZXNzRXhjbHVz
aXZlTG9jayBvbiB2YWNhbmN5CihPSUQ9MTgxNTApIGl0IGNvdWxkIG5vdCBn
ZXQgaXQgYmVjYXVzZSBpdCBhbHJlYWR5IGdyYWJiZWQgYnkgY29uY3VycmVu
dAp0cmFuc2FjdGlvbnMNCih3aGljaCBncmFiIEFjY2Vzc1NoYXJlTG9jayBs
b2NrcyBpbiBvcHBvc2l0ZSBvcmRlciBmaXJzdCBvbiB0aGUgdmFjYW5jeSBh
bmQKb25seSBhZnRlciBvbiB0aGUgaGh1c2VyKS4NCkJ1dCB0aGUgY29uY3Vy
cmVudCB0cmFuc2FjdGlvbnMgY291bGQgbm90IHByb2dyZXNzIGJlY2F1c2Ug
dGhleSBjYW5ub3QgZ3JhYgpBY2Nlc3NTaGFyZUxvY2sgb24gdGhlIGhodXNl
ciAoaXQgYWxyZWFkeSBsb2NrZWQgYnkgc3RhcnR1cCBwcm9jZXNzKS4NCg0K
QXMgYSByZXN1bHQgdGhlIGRhdGFiYXNlIGhhdmUgdW5kZXRlY3RlZCBkZWFk
bG9jayBiZXR3ZWVuIHN0YXJ0dXAgcHJvY2VzcwphbmQgcXVlcmllcyB3aGlj
aCBkb2Vzbid0IHJlc29sdmUgYXV0b21hdGljYWxseSAoYW5kIG5vdCB2aXNp
YmxlIG9uIHBnX2xvY2tzCmluIGNsZWFuIHdheSkuDQoNCktpbmQgUmVnYXJk
cywNCk1ha3N5bQ0KDQoNCg0KDQoNCg0KCgo=
pgsql-bugs by date:
From: Andreas Papst
Date: 14 September 2016, 10:30:13
Subject: Re: BUG #14320: systemd terminates postgresql hot standby instance 90 seconds after start
From: Peter Eisentraut
Date: 15 September 2016, 03:19:38
Subject: Re: BUG #14320: systemd terminates postgresql hot standby instance 90 seconds after start
BUG #14324: Deadlock? between queries and startup process on standby replica. - Mailing list pgsql-bugs

Previous

Next
