From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Willy-Bas Loos <willybas@gmail.com>
Cc: lst_hoe02@kwsoft.de, pgsql-admin <pgsql-admin@postgresql.org>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: [ADMIN]openvz and shared memory trouble
Date: Mon, 31 Mar 2014 12:21:03 -0700
Message-ID: <5339C01F.5000301@aklaver.com> (raw)
In-Reply-To: <16649.1396279693@sss.pgh.pa.us>
References: <CAHnozTjxUrfbaZVFbzibLQmhzR-n9ty+ktyRN2a0Tyr9PhApqQ@mail.gmail.com>
<53357E83.2040101@aklaver.com>
<CAHnozThQ9WkE+b3b1kXGpgNfnpP6NsxpFNSmvgsw_ZnqGfc+CA@mail.gmail.com>
<53370026.2040509@aklaver.com>
<CAHnozTjVQeisMGKPsPMbYJ=_jqBNNvZ81x0ohRuta364J9cdmg@mail.gmail.com>
<53397DE7.2070903@aklaver.com>
<15934.1396278062@sss.pgh.pa.us>
<5339865C.9020209@aklaver.com>
<16649.1396279693@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On 03/31/2014 08:28 AM, Tom Lane wrote:
> Adrian Klaver <adrian.klaver@aklaver.com> writes:
>> At this point the memory allocation as a problem is as much conjecture
>> as anything else, at least to me. So what is causing SIGBUS is an open
>> question in my mind.
>
> Agreed, it's unproven what's causing the SIGBUS in the case at hand.
> However, in the case I investigated for Josh Kupershmidt, it was provably
> the fault of the kernel for failing to supply memory to back the shared
> memory segment that it had previously agreed to allocate. The fact that
> both users are trying to run their standby server under OpenVZ is, shall
> we say, merely suggestive.
Yes, the fact that the problem seems to go away with a change in
shared_buffers seems to point in that direction also. To get through the
smoke to the fire, there are more questions to be answered:
1) The OP says the shared_buffered setting that failed was 4GB and that
'tuning' down the setting solved the problem. So it would be nice to
know what setting worked?
2) In hand with 1), the memory settings for the virtualization host and
the container(s) involved are?
3) What is the host OS?
4) What version of OpenVZ?
5) What is the layout?
Are the primary and standby on the same container, different containers
or some other arrangement?
In other words could there be some other resource conflict going on, say
network?
6) Are the crashes random or do they follow some pattern?
>
> regards, tom lane
>
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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: adrian.klaver@aklaver.com, tgl@sss.pgh.pa.us, willybas@gmail.com, pgsql-general@postgresql.org
Subject: Re: [ADMIN]openvz and shared memory trouble
In-Reply-To: <5339C01F.5000301@aklaver.com>
* 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