Re: Postgres crash during low-traffic period, need advice.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Zitat von Benoit Clennett-Sirois <benoit@xxxxxxxxx>:

Hi,

We have a front-end server taking care of Nginx, memcached and
Postgresql. Last night the postgres daemon crashed (traffic was very
low at that time) with the following error:

2010-12-20 03:34:30 EST DETAIL:  Failed system call was
shmget(key=5432001, size=1124474880, 03600).
2010-12-20 03:34:30 EST HINT:  This error usually means that
PostgreSQL's request for a shared memory segment exceeded available
memory or swap space. To reduce the request size (currently 1124474880
bytes), reduce PostgreSQL's shared_buffers parameter (currently
131072) and/or its max_connections parameter (currently 963).

For me this looks like you have shared_buffers at the default value of 128kb eg. 131072 Byte which would be way to low for 963 connections...
Not sure if this is a reason to crash.

Regards

Andreas


Attachment: smime.p7s
Description: S/MIME Cryptographic Signature


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux