Thread: BUG #14419: DB connections fails with "could not reserve shared memory region" in postgresql log.

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==