pg_listener entries deleted under heavy NOTIFY load only on Windows
| От | Ilie, Radu |
|---|---|
| Тема | pg_listener entries deleted under heavy NOTIFY load only on Windows |
| Дата | |
| Msg-id | 1262016302.3302.37.camel@arc-dev2.wsicorp.com обсуждение исходный текст |
| Список | pgsql-bugs |
T24gYSBXaW5kb3dzIHNlcnZlciB1bmRlciBoZWF2eSBsb2FkIG9mIE5PVElG WSBldmVudHMsIGVudHJpZXMgaW4NCnBnX2xpc3RlbmVyIHRhYmxlIGZvciBz b21lIGV2ZW50cyBhcmUgZGVsZXRlZC4gSXQgaXMgbGlrZSBVTkxJU1RFTiB3 YXMNCmNhbGxlZC4NCg0KUG9zdGdyZVNRTCB2ZXJzaW9uOiA4LjMuOS4NCk9w ZXJhdGluZyBTeXN0ZW06IFdpbmRvd3MgWFAuDQoNClBvc3RncmVTUUwgYmVs aWV2ZXMgdGhhdCBpZiBpdCBmYWlscyB0byBub3RpZnkgYSBsaXN0ZW5lciAo Ynkgc2lnbmFsaW5nDQp0aGUgcmVzcGVjdGl2ZSBiYWNrZW5kKSwgdGhlbiB0 aGUgYmFja2VuZCBkb2Vzbid0IGV4aXN0IGFueW1vcmUgYW5kIHNvDQppdCBz aG91bGQgZ2V0IHJpZCBvZiB0aGUgcGdfbGlzdGVuZXIgZW50cnkuIFRoZSBy ZWxldmFudCBjb2RlIGlzIGluDQpzcmMvYmFja2VuZC9jb21tYW5kcy9hc3lu Yy5jLCBmdW5jdGlvbiBTZW5kX05vdGlmeToNCg0KCQkJaWYgKGtpbGwobGlz dGVuZXJQSUQsIFNJR1VTUjIpIDwgMCkNCgkJCXsNCgkJCQkvKg0KCQkJCSAq IEdldCByaWQgb2YgcGdfbGlzdGVuZXIgZW50cnkgaWYgaXQgcmVmZXJzIHRv IGEgUElEIHRoYXQgbm8NCgkJCQkgKiBsb25nZXIgZXhpc3RzLiAgUHJlc3Vt YWJseSwgdGhhdCBiYWNrZW5kIGNyYXNoZWQgd2l0aG91dA0KCQkJCSAqIGRl bGV0aW5nIGl0cyBwZ19saXN0ZW5lciBlbnRyaWVzLiBUaGlzIGNvZGUgdXNl ZCB0byBvbmx5DQoJCQkJICogZGVsZXRlIHRoZSBlbnRyeSBpZiBlcnJubz09 RVNSQ0gsIGJ1dCBhcyBmYXIgYXMgSSBjYW4gc2VlDQoJCQkJICogd2Ugc2hv dWxkIGp1c3QgZG8gaXQgZm9yIGFueSBmYWlsdXJlIChjZXJ0YWlubHkgYXQg bGVhc3QNCgkJCQkgKiBmb3IgRVBFUk0gdG9vLi4uKQ0KCQkJCSAqLw0KCQkJ CXNpbXBsZV9oZWFwX2RlbGV0ZShsUmVsLCAmbFR1cGxlLT50X3NlbGYpOw0K CQkJfQ0KDQpUaGUgcHJvYmxlbSBpcyB0aGF0IHVuZGVyIFdpbmRvd3MsIGtp bGwgY2FuIGZhaWwgZXZlbiBpZiB0aGUgcHJvY2VzcyBpcw0Kc3RpbGwgYWxp dmUuIFBvc3RncmVTUUwgdXNlcyBuYW1lZCBwaXBlcyB1bmRlciBXaW5kb3dz IHRvIHNlbmQgc2lnbmFscw0KdG8gYmFja2VuZHMuIFRoZSBwcmVzZW50IGlt cGxlbWVudGF0aW9uIGhhcyBhIGJ1ZyB0aGF0IGNhdXNlcyBhIGNsaWVudA0K dG8gZmFpbCB0byB3cml0ZSBkYXRhIHRvIHRoZSBuYW1lZCBwaXBlLCBldmVu IHRob3VnaCB0aGUgc2VydmVyIHByb2Nlc3MNCmlzIGFsaXZlLiBUaGlzIGlz IGJlY2F1c2UgdGhlIHNlcnZlciBkb2Vzbid0IG1haW50YWluIHRoZSBuYW1l ZCBwaXBlIGF0DQphbGwgdGltZXMuIFRoZSBidWcgaXMgcHJlc2VudCBpbiBm aWxlIHNyYy9iYWNrZW5kL3BvcnQvd2luMzIvc2lnbmFsLmMsDQpmdW5jdGlv biBwZ19zaWduYWxfdGhyZWFkLg0KDQpUaGUgc2VydmVyIGNvZGUgc3RheXMg aW4gYSBsb29wIGluIHdoaWNoIGl0IGNvbnRpbnVvdXNseSBjcmVhdGVzIGFu DQppbnN0YW5jZSBvZiB0aGUgbmFtZWQgcGlwZSAodmlhIENyZWF0ZU5hbWVk UGlwZSkgYW5kIHdhaXRzIGZvciBhIGNsaWVudA0KcHJvY2VzcyB0byBjb25u ZWN0ICh2aWEgQ29ubmVjdE5hbWVkUGlwZSkuIE9uY2UgYSBjbGllbnQgY29u bmVjdHMsIHRoZQ0KY29tbXVuaWNhdGlvbiB3aXRoIHRoZSBjbGllbnQgaXMg aGFuZGxlZCBpbiBhIG5ldyB0aHJlYWQsIHdpdGggdGhlDQp0aHJlYWQgcHJv Y2VkdXJlIHBnX3NpZ25hbF9kaXNwYXRjaF90aHJlYWQuIFRoaXMgZnVuY3Rp b24gaXMgdmVyeQ0Kc2ltcGxlOiBpdCByZWFkcyBvbmUgYnl0ZSBmcm9tIHRo ZSBuYW1lZCBwaXBlLCBpdCB3cml0ZXMgaXQgYmFjayBhbmQNCih2ZXJ5IGlt cG9ydGFudCkgY2xvc2VzIHRoZSBoYW5kbGUgdG8gdGhlIG5hbWVkIHBpcGUg aW5zdGFuY2UuIFRoZSBtYWluDQpsb29wIGNyZWF0ZXMgYW5vdGhlciBpbnN0 YW5jZSBvZiB0aGUgbmFtZWQgcGlwZSBhbmQgd2FpdHMgZm9yIGFub3RoZXIN CmNsaWVudCB0byBjb25uZWN0Lg0KDQpOb3cgaW1hZ2luZSB0aGF0IHRoZSBz ZXJ2ZXIgaXMgdW5kZXIgaGVhdnkgbG9hZC4gVGhlcmUgYXJlIGRvemVucyBv Zg0KYmFja2VuZHMgYW5kIHRocmVhZHMgcnVubmluZyBhbmQgdGhlIENQVSB1 c2FnZSBpcyBjbG9zZSB0byAxMDAlLiBUaGUNCmZvbGxvd2luZyBzdWNjZXNz aW9uIG9mIGV2ZW50cyBpcyBwb3NzaWJsZToNCg0KMS4gU2VydmVyIHNpZ25h bCBoYW5kbGluZyB0aHJlYWQgKGluIGZ1bmN0aW9uIHBnX3NpZ25hbF90aHJl YWQpIGNyZWF0ZXMNCnRoZSBmaXJzdCwgb25lIGFuZCBvbmx5IGluc3RhbmNl IG9mIHRoZSBuYW1lZCBwaXBlIHZpYSBDcmVhdGVOYW1lZFBpcGUuDQoyLiBT ZXJ2ZXIgY29kZSBzdGFydHMgd2FpdGluZyBmb3IgY2xpZW50cyB0byBjb25u ZWN0IHdpdGgNCkNvbm5lY3ROYW1lZFBpcGUuDQozLiBDbGllbnQgd2lzaGVz IHRvIG1ha2UgYSB0cmFuc2FjdGlvbiBvbiB0aGUgbmFtZWQgcGlwZSBhbmQg Y2FsbHMNCkNhbGxOYW1lZFBpcGUgKGluIGZpbGUgc3JjL3BvcnQva2lsbC5j LCBmdW5jdGlvbiBwZ2tpbGwpLg0KNC4gU2VydmVyIGNvZGUgcmV0dXJucyBm cm9tIENvbm5lY3ROYW1lZFBpcGUuIEl0IGNyZWF0ZXMgYSBuZXcgdGhyZWFk DQp3aXRoIHRoZSB0aHJlYWQgcHJvY2VkdXJlIHBnX3NpZ25hbF9kaXNwYXRj aF90aHJlYWQuDQo1LiBUaGUgc2lnbmFsIGRpc3BhdGNoIHRocmVhZCBpcyBz Y2hlZHVsZWQgZm9yIGV4ZWN1dGlvbiBhbmQgaXQgcnVucyB0bw0KY29tcGxl dGlvbi4gQXMgeW91IGNhbiBzZWUsIHRoZSBsYXN0IHRoaW5nIGl0IGRvZXMg cmVsYXRlZCB0byB0aGUgbmFtZWQNCnBpcGUgaXMgdG8gY2xvc2UgdGhlIGhh bmRsZSB2aWEgQ2xvc2VIYW5kbGUgKGluIGZ1bmN0aW9uDQpwZ19zaWduYWxf ZGlzcGF0Y2hfdGhyZWFkKS4gVGhpcyBjbG9zZXMgdGhlIGxhc3QgaW5zdGFu Y2Ugb2YgdGhlIG5hbWVkDQpwaXBlLiBUaGUgbmFtZWQgcGlwZSBpcyBnb25l LiBUaGVyZSBpcyBubyBtb3JlIG5hbWVkIHBpcGUuIFRoZSBzaWduYWwNCmhh bmRsaW5nIHRocmVhZCB3YXMgbm90IHlldCBzY2hlZHVsZWQgYnkgdGhlIG9w ZXJhdGluZyBzeXN0ZW0gZm9yDQpleGVjdXRpb24gYW5kIHRodXMgZGlkbid0 IGhhdmUgYW4gb3Bwb3J0dW5pdHkgdG8gY2FsbCBDcmVhdGVOYW1lZFBpcGUu DQo2LiBBbm90aGVyIGNsaWVudCAob3IgdGhlIHNhbWUgb25lLCBpdCBkb2Vz bid0IG1hdHRlcikgdHJpZXMgdG8gd3JpdGUgdG8NCnRoZSBuYW1lZCBwaXBl IHZpYSBDYWxsTmFtZWRQaXBlLiBUaGUgY2FsbCByZXR1cm5zIEVSUk9SX0ZJ TEVfTk9UX0ZPVU5ELA0KYmVjYXVzZSB0aGUgbmFtZWQgcGlwZSBpcyBnb25l LiBUaGUgY2xpZW50IGJlbGlldmVzIHRoZSBiYWNrZW5kIGlzIGdvbmUNCmFu ZCBpdCByZW1vdmVzIHRoZSBlbnRyeSBmcm9tIHBnX2xpc3RlbmVyLg0KNy4g VGhlIHNpZ25hbCBoYW5kbGluZyB0aHJlYWQgKGluIGZ1bmN0aW9uIHBnX3Np Z25hbF90aHJlYWQpIGlzIGZpbmFsbHkNCnNjaGVkdWxlZCBmb3IgZXhlY3V0 aW9uIGFuZCBpdCBjYWxscyBDcmVhdGVOYW1lZFBpcGUuIFdlIG5vdyBoYXZl IGFuDQppbnN0YW5jZSBvZiB0aGUgbmFtZWQgcGlwZSBhdmFpbGFibGUuDQoN ClNvIHdlIGVuZCB1cCB3aXRoIHRoZSBzZXJ2ZXIgYmFja2VuZCBhbGl2ZSwg dGhlIG5hbWVkIHBpcGUgaXMgdGhlcmUsIGJ1dA0KdGhlIHJvdyBpcyBnb25l IGZyb20gcGdfbGlzdGVuZXIuIFRoaXMgaXMgZWFzeSB0byByZXByb2R1Y2Ug dW5kZXINCldpbmRvd3MuIEkgdXNlZCB0aGUgc2NyaXB0cyBwb3N0ZWQgYnkg U3RldmUgTWFyc2hhbGwgaW4gYSBzaW1pbGFyIHRocmVhZA0KZnJvbSAwMS8x NS8yMDA5IGFuZCB0aGUgcHJvYmxlbSBhcHBlYXJzIHdpdGhpbiBvbmUgbWlu dXRlIGFsbCB0aGUgdGltZS4NCkZvciB0ZXN0aW5nIEkgdXNlZCBhIFdpbmRv d3MgWFAgbWFjaGluZSB3aXRoIDIgY29yZXMgYW5kIDJHQiBvZiBSQU0uIFRo ZQ0KQ1BVIHVzYWdlIHdhcyBvdmVyIDcwJSBkdXJpbmcgdGhlIHRyaWFscy4N Cg0KVGhlIHNvbHV0aW9uIGlzIHRvIGNyZWF0ZSBhIG5ldyBpbnN0YW5jZSBv ZiB0aGUgbmFtZWQgcGlwZSBiZWZvcmUNCmxhdW5jaGluZyB0aGUgc2lnbmFs IGRpc3BhdGNoIHRocmVhZC4gVGhpcyBtZWFucyBjaGFuZ2luZyB0aGUgY29k ZSBpbg0Kc3JjL2JhY2tlbmQvcG9ydC93aW4zMi9zaWduYWwuYyB0byBsb29r IGxpa2UgdGhpczoNCg0KQEAgLTI1MCw2ICsyNTAsNyBAQA0KIHsNCiAgICAg ICAgY2hhciAgICAgICAgICAgIHBpcGVuYW1lWzEyOF07DQogICAgICAgIEhB TkRMRSAgICAgICAgICBwaXBlID0gcGd3aW4zMl9pbml0aWFsX3NpZ25hbF9w aXBlOw0KKyAgICAgICBIQU5ETEUgICAgICAgICAgbmV3X3BpcGUgPSBwZ3dp bjMyX2luaXRpYWxfc2lnbmFsX3BpcGU7DQogDQogICAgICAgIHNucHJpbnRm KHBpcGVuYW1lLCBzaXplb2YocGlwZW5hbWUpLCAiXFxcXC5cXHBpcGVcXHBn c2lnbmFsXyV1IiwNCkdldEN1cnJlbnRQcm9jZXNzSWQoKSk7DQogDQpAQCAt Mjc1LDYgKzI3NiwxMCBAQA0KICAgICAgICAgICAgICAgIGZDb25uZWN0ZWQg PSBDb25uZWN0TmFtZWRQaXBlKHBpcGUsIE5VTEwpID8gVFJVRSA6DQooR2V0 TGFzdEVycm9yKCkgPT0gRVJST1JfUElQRV9DT05ORUNURUQpOw0KICAgICAg ICAgICAgICAgIGlmIChmQ29ubmVjdGVkKQ0KICAgICAgICAgICAgICAgIHsN CisgICAgICAgICAgICAgICAgICAgICAgIG5ld19waXBlID0gQ3JlYXRlTmFt ZWRQaXBlKHBpcGVuYW1lLA0KUElQRV9BQ0NFU1NfRFVQTEVYLA0KKyAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFBJUEVfVFlQ RV9NRVNTQUdFIHwNClBJUEVfUkVBRE1PREVfTUVTU0FHRSB8IFBJUEVfV0FJ VCwNCisNClBJUEVfVU5MSU1JVEVEX0lOU1RBTkNFUywgMTYsIDE2LCAxMDAw LCBOVUxMKTsNCisNCiAgICAgICAgICAgICAgICAgICAgICAgIGhUaHJlYWQg PSBDcmVhdGVUaHJlYWQoTlVMTCwgMCwNCg0KKExQVEhSRUFEX1NUQVJUX1JP VVRJTkUpIHBnX3NpZ25hbF9kaXNwYXRjaF90aHJlYWQsDQoNCihMUFZPSUQp IHBpcGUsIDAsIE5VTEwpOw0KQEAgLTI4OCw4ICsyOTMsNyBAQA0KICAgICAg ICAgICAgICAgICAgICAgICAgLyogQ29ubmVjdGlvbiBmYWlsZWQuIENsZWFu dXAgYW5kIHRyeSBhZ2FpbiAqLw0KICAgICAgICAgICAgICAgICAgICAgICAg Q2xvc2VIYW5kbGUocGlwZSk7DQogDQotICAgICAgICAgICAgICAgLyogU2V0 IHVwIHNvIHdlIGNyZWF0ZSBhIG5ldyBwaXBlIG9uIG5leHQgbG9vcCAqLw0K LSAgICAgICAgICAgICAgIHBpcGUgPSBJTlZBTElEX0hBTkRMRV9WQUxVRTsN CisgICAgICAgICAgICAgICBwaXBlID0gbmV3X3BpcGU7DQogICAgICAgIH0N CiAgICAgICAgcmV0dXJuIDA7DQogfQ0KDQpUaGlzIHdpbGwgZ3VhcmFudGVl IHRoYXQgd2UgaGF2ZSBhbiBpbnN0YW5jZSBvZiB0aGUgbmFtZWQgcGlwZSBh dmFpbGFibGUNCmF0IGFueSBnaXZlbiBtb21lbnQuIElmIHdlIGRvIHRoaXMs IHdlIGNhbiBhbHNvIHJlbW92ZSB0aGUgMyB0cmllcyBsb29wDQpmcm9tIHNy Yy9wb3J0L2tpbGwuYzoNCg0KQEAgLTI1LDcgKzI1LDYgQEANCiAgICAgICAg QllURSAgICAgICAgICAgIHNpZ0RhdGEgPSBzaWc7DQogICAgICAgIEJZVEUg ICAgICAgICAgICBzaWdSZXQgPSAwOw0KICAgICAgICBEV09SRCAgICAgICAg ICAgYnl0ZXM7DQotICAgICAgIGludCAgICAgICAgICAgICAgICAgICAgIHBp cGVfdHJpZXM7DQogDQogICAgICAgIC8qIHdlIGFsbG93IHNpZ25hbCAwIGhl cmUsIGJ1dCBpdCB3aWxsIGJlIGlnbm9yZWQgaW4NCnBnX3F1ZXVlX3NpZ25h bCAqLw0KICAgICAgICBpZiAoc2lnID49IFBHX1NJR05BTF9DT1VOVCB8fCBz aWcgPCAwKQ0KQEAgLTQxLDE0ICs0MCw2IEBADQogICAgICAgIH0NCiAgICAg ICAgc25wcmludGYocGlwZW5hbWUsIHNpemVvZihwaXBlbmFtZSksICJcXFxc LlxccGlwZVxccGdzaWduYWxfJXUiLA0KcGlkKTsNCiANCi0gICAgICAgLyoN Ci0gICAgICAgICogV3JpdGluZyBkYXRhIHRvIHRoZSBuYW1lZCBwaXBlIGNh biBmYWlsIGZvciB0cmFuc2llbnQNCnJlYXNvbnMuDQotICAgICAgICAqIFRo ZXJlZm9yZSwgaXQgaXMgdXNlZnVsIHRvIHJldHJ5IGlmIGl0IGZhaWxzLiAg VGhlIG1heGltdW0NCm51bWJlciBvZg0KLSAgICAgICAgKiBjYWxscyB0byBt YWtlIHdhcyBlbXBpcmljYWxseSBkZXRlcm1pbmVkIGZyb20gYSA5MC1ob3Vy DQpub3RpZmljYXRpb24NCi0gICAgICAgICogc3RyZXNzIHRlc3QuDQotICAg ICAgICAqLw0KLSAgICAgICBmb3IgKHBpcGVfdHJpZXMgPSAwOyBwaXBlX3Ry aWVzIDwgMzsgcGlwZV90cmllcysrKQ0KLSAgICAgICB7DQogICAgICAgICAg ICAgICAgaWYgKENhbGxOYW1lZFBpcGUocGlwZW5hbWUsICZzaWdEYXRhLCAx LCAmc2lnUmV0LCAxLA0KJmJ5dGVzLCAxMDAwKSkNCiAgICAgICAgICAgICAg ICB7DQogICAgICAgICAgICAgICAgICAgICAgICBpZiAoYnl0ZXMgIT0gMSB8 fCBzaWdSZXQgIT0gc2lnKQ0KQEAgLTU4LDcgKzQ5LDYgQEANCiAgICAgICAg ICAgICAgICAgICAgICAgIH0NCiAgICAgICAgICAgICAgICAgICAgICAgIHJl dHVybiAwOw0KICAgICAgICAgICAgICAgIH0NCi0gICAgICAgfQ0KIA0KICAg ICAgICBpZiAoR2V0TGFzdEVycm9yKCkgPT0gRVJST1JfRklMRV9OT1RfRk9V TkQpDQogICAgICAgICAgICAgICAgZXJybm8gPSBFU1JDSDsNCg0KQXMgYSBu b3RlLCB0aGUgb3JpZ2luYWwgY29kZSBoYXMgYSB0aW1lb3V0IG9mIDEwMDAg bWlsbGlzZWNvbmRzDQpzcGVjaWZpZWQgaW4gdGhlIGNhbGwgdG8gQ2FsbE5h bWVkUGlwZSBpbiBraWxsLmMuIFRoYXQgdGltZW91dCBkb2Vzbid0DQpoZWxw IGZvciB0aGlzIGJ1ZywgYmVjYXVzZSBpdCBpcyB0aGUgdGltZW91dCB0aGF0 IHRoZSBjbGllbnQgd2lsbCB3YWl0DQpmb3IgYW4gaW5zdGFuY2Ugb2YgdGhl IG5hbWVkIHBpcGUgdG8gYmUgYXZhaWxhYmxlIGZvciBjb21tdW5pY2F0aW9u Lg0KVGhpcyBtZWFucyBpdCBoZWxwcyBpbiB0aGUgY2FzZSB3aGVuIHdlIGhh dmUgb25lIGNsaWVudCBhbHJlYWR5IHVzaW5nDQp0aGF0IGluc3RhbmNlIHRv IHJlYWQvd3JpdGUgdG8gdGhlIHNlcnZlciBhbmQgdGhpcyBzZWNvbmQgY2xp ZW50IHdpbGwNCndhaXQgdW50aWwgdGhlIGZpcnN0IG9uZSBmaW5pc2hlcy4g SXQgZG9lcyBub3QgaGVscCBpZiB0aGVyZSBpcyBubw0KaW5zdGFuY2UgYXQg YWxsLiBJbiB0aGF0IGNhc2UgdGhlIENhbGxOYW1lZFBpcGUgcmV0dXJucyBp bW1lZGlhdGVseSB3aXRoDQpFUlJPUl9GSUxFX05PVF9GT1VORC4NCg0KVGhh bmtzLA0KUmFkdQ0KDQoNCg==
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Matteo BeccatiДата:
Сообщение: Re: BUG #5255: COUNT(*) returns wrong result with LEFT JOIN
Следующее
От: Heikki LinnakangasДата:
Сообщение: Re: Postgresql 8.4.2, Windows XP - temporary file leak: File still referenced