From: | nathanmascitelli(at)geotab(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover |
Date: | 2016-04-19 12:30:34 |
Message-ID: | 20160419123034.22924.9159@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14101
Logged by: Nathan Mascitelli
Email address: nathanmascitelli(at)geotab(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | John Lumby | 2016-04-19 14:45:11 | Re: BUG #14098: misleading message "out of shared memory" when lock table space exhausted |
Previous Message | Prashant Hunnure | 2016-04-19 12:14:06 | Postgresql 9.4 installation error |