BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover
От | nathanmascitelli@geotab.com |
---|---|
Тема | BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover |
Дата | |
Msg-id | 20160419123034.22924.9159@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 14101 Logged by: Nathan Mascitelli Email address: nathanmascitelli@geotab.com PostgreSQL version: 9.4.5 Operating system: Windows Server 2012 R2 Description: Hello, I am running Postgres 9.4 on Windows Server 2012. I have had postgres crash a few times with the following error: FATAL: could not reattach to shared memory (key=00000000000000D0, addr=00000001405E0000): error code 1455 Looking around (http://stackoverflow.com/questions/24614314/postgresql-8-3-7-fatal-could-not-reattach-to-shared-memory-and-warning-wor) it looks like this error was supposed to be fixed back in 8.3. Around the time of the crash it appears to have free RAM available. My server specs: OS: Windows Server 2012 x64 CPU: Intel Xeon CPU 2.30GHz (x2) RAM: 52GB Postgres: 9.4.5 Some settings from postgres: shared_buffers = 512MB effective_cache_size = 39GB work_mem = 90MB maintenance_work_mem = 2000MB Can anyone suggest what might be causing the crash? If you need more info please let me know. Thanks, Nathan
В списке pgsql-bugs по дате отправления: