Home > mailing lists
pg_listener entries deleted under heavy NOTIFY load only on Windows - Mailing list pgsql-bugs

From	Ilie, Radu
Subject	pg_listener entries deleted under heavy NOTIFY load only on Windows
Date	December 28, 2009 15:17:42
Msg-id	1262016302.3302.37.camel@arc-dev2.wsicorp.com Whole thread Raw
List	pgsql-bugs
Tree view
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 by date:
From: Matteo Beccati
Date: 25 December 2009, 16:22:02
Subject: Re: BUG #5255: COUNT(*) returns wrong result with LEFT JOIN
From: Heikki Linnakangas
Date: 29 December 2009, 16:45:21
Subject: Re: Postgresql 8.4.2, Windows XP - temporary file leak: File still referenced
pg_listener entries deleted under heavy NOTIFY load only on Windows - Mailing list pgsql-bugs

Previous

Next
