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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Prashant Hunnure
Дата:
Сообщение: Fwd: Postgresql 9.4 installation error
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Fwd: Postgresql 9.4 installation error