Обсуждение: BUG #14324: Deadlock? between queries and startup process on standby replica.
BUG #14324: Deadlock? between queries and startup process on standby replica.
От
maxim.boguk@gmail.com
Дата:
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=