Обсуждение: BUG #14419: DB connections fails with "could not reserve shared memory region" in postgresql log.
BUG #14419: DB connections fails with "could not reserve shared memory region" in postgresql log.
От
jari.kopponen@patria.fi
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQxOQpMb2dnZWQgYnk6ICAg ICAgICAgIGphcmkga29wcG9uZW4KRW1haWwgYWRkcmVzczogICAgICBqYXJp LmtvcHBvbmVuQHBhdHJpYS5maQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNC40 Ck9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyA3IFByb2Zlc3Npb25hbCwg NjQgYml0IFNQIDEKRGVzY3JpcHRpb246ICAgICAgICAKCkFmdGVyIHdlIGlu c3RhbGxlZCBrYjMxNzc0NjcgKFNlcnZpY2luZyBzdGFjayB1cGRhdGUgZm9y IFdpbmRvd3MgNyBTUDEgYW5kCldpbmRvd3MgU2VydmVyIDIwMDggUjIgU1Ax OiBTZXB0ZW1iZXIgMjAsIDIwMTYpIHdpbmRvd3MgdXBkYXRlLCB3ZSBmYWNl ZApwcm9ibGVtcyB3aXRoIGRhdGFiYXNlIGNvbm5lY3Rpb25zLiBJbiBwb3N0 Z3Jlc3FsIHRoZXJlIGlzIGxvZyBlbnRyaWVzCiJjb3VsZCBub3QgcmVzZXJ2 ZSBzaGFyZWQgbWVtb3J5IHJlZ2lvbiAoYWRkcjp4eHgpIGZvciBjaGlsZCh5 eXkpOiBlcnJvcgpjb2RlIDQ4Ny4gVGhpcyBzZWVtcyB0byBiZSBxdWl0ZSBz aW1pbGFyIHByb2JsZW0gdGhhbiBkZXNjcmliZWQgaW4gOiBCVUcKIzE0MDUw LgoK
On Fri, Nov 11, 2016 at 9:12 PM, <jari.kopponen@patria.fi> wrote: > The following bug has been logged on the website: > > Bug reference: 14419 > Logged by: jari kopponen > Email address: jari.kopponen@patria.fi > PostgreSQL version: 9.4.4 > Operating system: Windows 7 Professional, 64 bit SP 1 > Description: > > After we installed kb3177467 (Servicing stack update for Windows 7 SP1 and > Windows Server 2008 R2 SP1: September 20, 2016) windows update, we faced > problems with database connections. In postgresql there is log entries > "could not reserve shared memory region (addr:xxx) for child(yyy): error > code 487. This seems to be quite similar problem than described in : BUG > #14050. From where are those builds? Is ASLR enabled? I saw patterns of broken shared memory with Win 2k8 R2 because of that. -- Michael
On 11/11/2016 14:47, Michael Paquier wrote: > On Fri, Nov 11, 2016 at 9:12 PM, <jari.kopponen@patria.fi> wrote: >> The following bug has been logged on the website: >> >> Bug reference: 14419 >> Logged by: jari kopponen >> Email address: jari.kopponen@patria.fi >> PostgreSQL version: 9.4.4 >> Operating system: Windows 7 Professional, 64 bit SP 1 >> Description: >> >> After we installed kb3177467 (Servicing stack update for Windows 7 SP1 and >> Windows Server 2008 R2 SP1: September 20, 2016) windows update, we faced >> problems with database connections. In postgresql there is log entries >> "could not reserve shared memory region (addr:xxx) for child(yyy): error >> code 487. This seems to be quite similar problem than described in : BUG >> #14050. > > From where are those builds? Is ASLR enabled? I saw patterns of broken > shared memory with Win 2k8 R2 because of that. > FWIW, there was 3 reports for this issue on french board in the last few days (including pg 9.3.3 and 9.5.5), I think all of them on W7. -- Julien Rouhaud http://dalibo.com - http://dalibo.org
On Fri, Nov 11, 2016 at 11:22 PM, Julien Rouhaud <julien.rouhaud@dalibo.com> wrote: > FWIW, there was 3 reports for this issue on french board in the last few > days (including pg 9.3.3 and 9.5.5), I think all of them on W7. It may be a good idea to check if ASLR is really enabled. Win2k8 R2 and Win7 SP1 have introduced the "force ASLR" feature... https://support.microsoft.com/en-us/kb/2639308 Not sure if that's related directly to that, but the reports popping up with the latest versions of Win7 and win2k8 are pointing out to something that the OS changed... -- Michael
On 12/11/2016 05:57, Michael Paquier wrote: > On Fri, Nov 11, 2016 at 11:22 PM, Julien Rouhaud > <julien.rouhaud@dalibo.com> wrote: >> FWIW, there was 3 reports for this issue on french board in the last few >> days (including pg 9.3.3 and 9.5.5), I think all of them on W7. > > It may be a good idea to check if ASLR is really enabled. Win2k8 R2 > and Win7 SP1 have introduced the "force ASLR" feature... I just asked and provided a link to this thread. I'll provide any new information. > https://support.microsoft.com/en-us/kb/2639308 > Not sure if that's related directly to that, but the reports popping > up with the latest versions of Win7 and win2k8 are pointing out to > something that the OS changed... > Definitely. -- Julien Rouhaud http://dalibo.com - http://dalibo.org
SW5zdGFsbGVyIGhhcyBiZWVuIGRvd25sb2FkZWQgZnJvbTogaHR0cDovL3d3dy5lbnRlcnByaXNl ZGIuY29tLg0KQmFzZWQgb24gUHJvY2VzcyBFeHBsb3JlciwgQUxTUiBJcyBub3QgZW5hYmxlZC4N Ci0tLQ0KSmFyaQ0KDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBNaWNoYWVs IFBhcXVpZXIgW21haWx0bzptaWNoYWVsLnBhcXVpZXJAZ21haWwuY29tXSANClNlbnQ6IDExLiBt YXJyYXNrdXV0YSAyMDE2IDE1OjQ4DQpUbzogSmFyaSBLb3Bwb25lbiA8amFyaS5rb3Bwb25lbkBw YXRyaWEuZmk+DQpDYzogUG9zdGdyZVNRTCBtYWlsaW5nIGxpc3RzIDxwZ3NxbC1idWdzQHBvc3Rn cmVzcWwub3JnPg0KU3ViamVjdDogUmU6IFtCVUdTXSBCVUcgIzE0NDE5OiBEQiBjb25uZWN0aW9u cyBmYWlscyB3aXRoICJjb3VsZCBub3QgcmVzZXJ2ZSBzaGFyZWQgbWVtb3J5IHJlZ2lvbiIgaW4g cG9zdGdyZXNxbCBsb2cuDQoNCk9uIEZyaSwgTm92IDExLCAyMDE2IGF0IDk6MTIgUE0sICA8amFy aS5rb3Bwb25lbkBwYXRyaWEuZmk+IHdyb3RlOg0KPiBUaGUgZm9sbG93aW5nIGJ1ZyBoYXMgYmVl biBsb2dnZWQgb24gdGhlIHdlYnNpdGU6DQo+DQo+IEJ1ZyByZWZlcmVuY2U6ICAgICAgMTQ0MTkN Cj4gTG9nZ2VkIGJ5OiAgICAgICAgICBqYXJpIGtvcHBvbmVuDQo+IEVtYWlsIGFkZHJlc3M6ICAg ICAgamFyaS5rb3Bwb25lbkBwYXRyaWEuZmkNCj4gUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjQuNA0K PiBPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgNyBQcm9mZXNzaW9uYWwsIDY0IGJpdCBTUCAx DQo+IERlc2NyaXB0aW9uOg0KPg0KPiBBZnRlciB3ZSBpbnN0YWxsZWQga2IzMTc3NDY3IChTZXJ2 aWNpbmcgc3RhY2sgdXBkYXRlIGZvciBXaW5kb3dzIDcgU1AxIA0KPiBhbmQgV2luZG93cyBTZXJ2 ZXIgMjAwOCBSMiBTUDE6IFNlcHRlbWJlciAyMCwgMjAxNikgd2luZG93cyB1cGRhdGUsIHdlIA0K PiBmYWNlZCBwcm9ibGVtcyB3aXRoIGRhdGFiYXNlIGNvbm5lY3Rpb25zLiBJbiBwb3N0Z3Jlc3Fs IHRoZXJlIGlzIGxvZyANCj4gZW50cmllcyAiY291bGQgbm90IHJlc2VydmUgc2hhcmVkIG1lbW9y eSByZWdpb24gKGFkZHI6eHh4KSBmb3IgDQo+IGNoaWxkKHl5eSk6IGVycm9yIGNvZGUgNDg3LiBU aGlzIHNlZW1zIHRvIGJlIHF1aXRlIHNpbWlsYXIgcHJvYmxlbSANCj4gdGhhbiBkZXNjcmliZWQg aW4gOiBCVUcgIzE0MDUwLg0KDQpGcm9tIHdoZXJlIGFyZSB0aG9zZSBidWlsZHM/IElzIEFTTFIg ZW5hYmxlZD8gSSBzYXcgcGF0dGVybnMgb2YgYnJva2VuIHNoYXJlZCBtZW1vcnkgd2l0aCBXaW4g Mms4IFIyIGJlY2F1c2Ugb2YgdGhhdC4NCi0tDQpNaWNoYWVsDQo=
Rm9yY2UgQVNMUiBpcyBub3QgZW5hYmxlZCBmb3IgUG9zdGdyZVNRTC4NCg0KSSBtYWRlIGZ1cnRo ZXIgaW52ZXN0aWdhdGlvbnMuIElmIEkgZGVsYXkgUG9zdGdyZVNRTCBzdGFydCAoYnkgdXNpbmcg IkRlbGF5ZWQgU3RhcnQiIC1vcHRpb24gd2l0aCBQb3N0Z3JlU1FMIC1zZXJ2aWNlIG9yIGJ5IHN0 YXJ0aW5nIG1hbnVhbGx5IFBvc3RncmVTUUwpIHRoZSBwcm9ibGVtIGRpc2FwcGVhcnMuDQpTbyB0 cmlnZ2VyIGZvciB0aGUgcHJvYmxlbXMgbWlnaHQgYmUgaGlnaCBDUFUgb2YgaGlnaCBoYXJkLWRp c2sgbG9hZCBvbiB3aW5kb3dzIHN0YXJ0dXAgLXBoYXNlLiBPciBzb21lIGRlcGVuZGVuY3kgdG8g b3RoZXIgd2luZG93cyBzZXJ2aWNlLg0KLS0tDQpKYXJpDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNz YWdlLS0tLS0NCkZyb206IE1pY2hhZWwgUGFxdWllciBbbWFpbHRvOm1pY2hhZWwucGFxdWllckBn bWFpbC5jb21dIA0KU2VudDogMTIuIG1hcnJhc2t1dXRhIDIwMTYgNjo1OA0KVG86IEp1bGllbiBS b3VoYXVkIDxqdWxpZW4ucm91aGF1ZEBkYWxpYm8uY29tPg0KQ2M6IEphcmkgS29wcG9uZW4gPGph cmkua29wcG9uZW5AcGF0cmlhLmZpPjsgUG9zdGdyZVNRTCBtYWlsaW5nIGxpc3RzIDxwZ3NxbC1i dWdzQHBvc3RncmVzcWwub3JnPg0KU3ViamVjdDogUmU6IFtCVUdTXSBCVUcgIzE0NDE5OiBEQiBj b25uZWN0aW9ucyBmYWlscyB3aXRoICJjb3VsZCBub3QgcmVzZXJ2ZSBzaGFyZWQgbWVtb3J5IHJl Z2lvbiIgaW4gcG9zdGdyZXNxbCBsb2cuDQoNCk9uIEZyaSwgTm92IDExLCAyMDE2IGF0IDExOjIy IFBNLCBKdWxpZW4gUm91aGF1ZCA8anVsaWVuLnJvdWhhdWRAZGFsaWJvLmNvbT4gd3JvdGU6DQo+ IEZXSVcsIHRoZXJlIHdhcyAzIHJlcG9ydHMgZm9yIHRoaXMgaXNzdWUgb24gZnJlbmNoIGJvYXJk IGluIHRoZSBsYXN0IA0KPiBmZXcgZGF5cyAoaW5jbHVkaW5nIHBnIDkuMy4zIGFuZCA5LjUuNSks IEkgdGhpbmsgYWxsIG9mIHRoZW0gb24gVzcuDQoNCkl0IG1heSBiZSBhIGdvb2QgaWRlYSB0byBj aGVjayBpZiBBU0xSIGlzIHJlYWxseSBlbmFibGVkLiBXaW4yazggUjIgYW5kIFdpbjcgU1AxIGhh dmUgaW50cm9kdWNlZCB0aGUgImZvcmNlIEFTTFIiIGZlYXR1cmUuLi4NCmh0dHBzOi8vc3VwcG9y dC5taWNyb3NvZnQuY29tL2VuLXVzL2tiLzI2MzkzMDgNCk5vdCBzdXJlIGlmIHRoYXQncyByZWxh dGVkIGRpcmVjdGx5IHRvIHRoYXQsIGJ1dCB0aGUgcmVwb3J0cyBwb3BwaW5nIHVwIHdpdGggdGhl IGxhdGVzdCB2ZXJzaW9ucyBvZiBXaW43IGFuZCB3aW4yazggYXJlIHBvaW50aW5nIG91dCB0byBz b21ldGhpbmcgdGhhdCB0aGUgT1MgY2hhbmdlZC4uLg0KLS0NCk1pY2hhZWwNCg==