From: lst_hoe02@kwsoft.de
To: pgsql-admin@postgresql.org
Subject: Re: Postgres crash during low-traffic period, need advice.
Date: Mon, 20 Dec 2010 15:29:03 +0100
Message-ID: <20101220152903.14587dtjezps3tgc@webmail.kwsoft.de> (raw)
In-Reply-To: <AANLkTinPGEeNFCqJ-_E7idX4F9+_tvvvMX6EjuUfyX2G@mail.gmail.com>
References: <AANLkTinPGEeNFCqJ-_E7idX4F9+_tvvvMX6EjuUfyX2G@mail.gmail.com>
Zitat von Benoit Clennett-Sirois <benoit@lesite.ca>:
> 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
Attachments:
smime.p7s (application/pkcs7-signature, 5.9K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lst_hoe02@kwsoft.de
Subject: Re: Postgres crash during low-traffic period, need advice.
In-Reply-To: <20101220152903.14587dtjezps3tgc@webmail.kwsoft.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox