Thread: BUG #14261: Hanged randomly in hash_seq_search
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI2MQpMb2dnZWQgYnk6ICAg ICAgICAgIEFtYXVyeSBEZWNyZW1lCkVtYWlsIGFkZHJlc3M6ICAgICAgYW1k ZWNyZW1lQGFpcmZyYW5jZS5mcgpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNC4x Ck9wZXJhdGluZyBzeXN0ZW06ICAgUmVkIEhhdCBFbnRlcnByaXNlIExpbnV4 IFNlcnZlciByZWxlYXNlIDYuNgpEZXNjcmlwdGlvbjogICAgICAgIAoKSGVs bG8sDQoNCg0KV2hlbiBJIGV4ZWN1dGUgdGhlIGZvbGxvd2luZyByZXF1ZXN0 IGFyb3VuZCAxMC01MCB0aW1lcyBpbiBhIHJvdywgcG9zdGdyZXMKaGFuZ3Mg cmFuZG9tbHkgb24gdGhlIGNvbm5lY3Rpb24uIE5ldyBjb25uZWN0aW9ucyBh cmUgc3RpbGwgd29ya2luZy4NCg0KVGhlIENQVSBwZWFrcyBhdCAxMDAlIGFu ZCB0aGUgcHJvY2VzcyBuZWVkcyB0byBiZSBTSUdLSUxMZWQuIFNJR1RFUk0g aXMgbm90CnRyZWF0ZWQuDQoNClRoZSByZXF1ZXN0IGlzOg0KU0VMRUNUICog RlJPTSBNRUFTVVJFX0ZMQVRfSA0KSU5ORVIgSk9JTiAoDQpTRUxFQ1QgbWF4 KGR0KSBhcyBkdG1heCBGUk9NIE1FQVNVUkVfRkxBVF9IIFdIRVJFIChBU1NF VFNfTkFNRSA9ID8pIEFORAooTUVUUklDX05BTUUgPSA/KQ0KKSBkIE9OIChE LkRUTUFYID0gRFQpDQpXSEVSRSAoQVNTRVRTX05BTUUgPSA/KSBBTkQgKE1F VFJJQ19OQU1FID0gPykNCg0KQXQgdGhpcyBzdGVwLCBubyBsb2NrIGlzIGZv dW5kIGluIHBnX2xvY2tzLg0KDQoNClRoZSBwcm9jZXNzIGNhbiBiZSBmb3Vu ZCBzdHVjayBpbiB0aGUgaGFzaF9zZXFfc2VhcmNoKCkuDQoNCkNhbGwgc3Rh Y2s6DQojMCAgMHgwMDAwMDAwMDAwNzVlOTE5IGluIGhhc2hfc2VxX3NlYXJj aCAoKQ0KIzEgIDB4MDAwMDdmZDBhZjc0ZmIyYiBpbiBwZ3FzX2VudHJ5X2Rl YWxsb2MgKCkNCiAgIGZyb20gL3RlY2gvcG9zdGdyZXMvOS40LjEvc2VydmVy L2xpYi9wZ19xdWFsc3RhdHMuc28NCiMyICAweDAwMDA3ZmQwYWY3NTBhMTUg aW4gcGdxc19FeGVjdXRvckVuZCAoKQ0KICAgZnJvbSAvdGVjaC9wb3N0Z3Jl cy85LjQuMS9zZXJ2ZXIvbGliL3BnX3F1YWxzdGF0cy5zbw0KIzMgIDB4MDAw MDAwMDAwMDU1ZGFkZSBpbiBQb3J0YWxDbGVhbnVwICgpDQojNCAgMHgwMDAw MDAwMDAwNzc0MzhhIGluIFBvcnRhbERyb3AgKCkNCiM1ICAweDAwMDAwMDAw MDA3NzQ3MmEgaW4gUHJlQ29tbWl0X1BvcnRhbHMgKCkNCiM2ICAweDAwMDAw MDAwMDA0YjM2ZWMgaW4gQ29tbWl0VHJhbnNhY3Rpb24gKCkNCiM3ICAweDAw MDAwMDAwMDA0YjRhYjUgaW4gQ29tbWl0VHJhbnNhY3Rpb25Db21tYW5kICgp DQojOCAgMHgwMDAwMDAwMDAwNjdhMjY5IGluIGZpbmlzaF94YWN0X2NvbW1h bmQgKCkNCiM5ICAweDAwMDAwMDAwMDA2N2Q2ODUgaW4gUG9zdGdyZXNNYWlu ICgpDQojMTAgMHgwMDAwMDAwMDAwNjJjMjQ2IGluIFBvc3RtYXN0ZXJNYWlu ICgpDQojMTEgMHgwMDAwMDAwMDAwNWM0YWI4IGluIG1haW4gKCkNCg0KDQpF YWNoIHRpbWUsIEkndmUgc2VlbiB0aGUgcHJvY2VzcyBsb29waW5nIGluZmlu aXRlbHkgZnJvbSA3NWU5MTAgdG8gNzVlOTI3Og0KICAgMHgwMDAwMDAwMDAw NzVlOTEwIDwrOTY+OiAgICBtb3YgICAgKCVyOSwlcmN4LDgpLCVyYXgNCiAg IDB4MDAwMDAwMDAwMDc1ZTkxNCA8KzEwMD46ICAgdGVzdCAgICVyYXgsJXJh eA0KICAgMHgwMDAwMDAwMDAwNzVlOTE3IDwrMTAzPjogICBqbmUgICAgMHg3 NWU5M2MgPGhhc2hfc2VxX3NlYXJjaCsxNDA+DQogICAweDAwMDAwMDAwMDA3 NWU5MTkgPCsxMDU+OiAgIGFkZCAgICAkMHgxLCVlZHgNCi0tLVR5cGUgPHJl dHVybj4gdG8gY29udGludWUsIG9yIHEgPHJldHVybj4gdG8gcXVpdC0tLQ0K PT4gMHgwMDAwMDAwMDAwNzVlOTFjIDwrMTA4PjogICBjbXAgICAgJWVkeCwl ZXNpDQogICAweDAwMDAwMDAwMDA3NWU5MWUgPCsxMTA+OiAgIGpiICAgICAw eDc1ZTk1OCA8aGFzaF9zZXFfc2VhcmNoKzE2OD4NCiAgIDB4MDAwMDAwMDAw MDc1ZTkyMCA8KzExMj46ICAgYWRkICAgICQweDEsJXJjeA0KICAgMHgwMDAw MDAwMDAwNzVlOTI0IDwrMTE2PjogICBjbXAgICAgJXJjeCwlcjgNCiAgIDB4 MDAwMDAwMDAwMDc1ZTkyNyA8KzExOT46ICAgamcgICAgIDB4NzVlOTEwIDxo YXNoX3NlcV9zZWFyY2grOTY+DQoNCg0KKEkga25vdyA5LjQuMSBpcyBub3Qg dGhlIGxhc3QgbWlub3IgcmVsZWFzZSBmb3IgOS40IGJ1dCBJIGRpZG4ndCBm aW5kIHRoaXMKYnVnIHJlcG9ydGVkIGZvciB0aGUgPj05LjQgbWFqb3JzKQ0K DQpEbyB5b3UgaGF2ZSBhbiBpZGVhIG9mIHdoYXQgaXMgY2F1c2luZyB0aGlz IHN0cmFuZ2UgaXNzdWUgPw0KDQoNCkJlc3QgcmVnYXJkcywNCg0KQW1hdXJ5 Cgo=
amdecreme@airfrance.fr writes: > The process can be found stuck in the hash_seq_search(). > Call stack: > #0 0x000000000075e919 in hash_seq_search () > #1 0x00007fd0af74fb2b in pgqs_entry_dealloc () > from /tech/postgres/9.4.1/server/lib/pg_qualstats.so > #2 0x00007fd0af750a15 in pgqs_ExecutorEnd () > from /tech/postgres/9.4.1/server/lib/pg_qualstats.so > #3 0x000000000055dade in PortalCleanup () > #4 0x000000000077438a in PortalDrop () > #5 0x000000000077472a in PreCommit_Portals () > #6 0x00000000004b36ec in CommitTransaction () I do not know what pg_qualstats.so is, but it's certainly not part of the PG core distribution. I suggest asking its author(s) about known bugs in their code ... regards, tom lane
On 19/07/2016 18:58, Tom Lane wrote: > amdecreme@airfrance.fr writes: >> The process can be found stuck in the hash_seq_search(). > >> Call stack: >> #0 0x000000000075e919 in hash_seq_search () >> #1 0x00007fd0af74fb2b in pgqs_entry_dealloc () >> from /tech/postgres/9.4.1/server/lib/pg_qualstats.so >> #2 0x00007fd0af750a15 in pgqs_ExecutorEnd () >> from /tech/postgres/9.4.1/server/lib/pg_qualstats.so >> #3 0x000000000055dade in PortalCleanup () >> #4 0x000000000077438a in PortalDrop () >> #5 0x000000000077472a in PreCommit_Portals () >> #6 0x00000000004b36ec in CommitTransaction () > > I do not know what pg_qualstats.so is, but it's certainly not part of the > PG core distribution. I suggest asking its author(s) about known bugs > in their code ... > Culprit here, and unfortunately that's not a bug that've already been reported. Amaury, could you instead send a bug report on https://github.com/dalibo/pg_qualstats/issues ? -- Julien Rouhaud http://dalibo.com - http://dalibo.org