Re: PostgreSQL and OpenVZ

From: Warwick Chapman <w(at)rwick(dot)com>
To: "zlobnynigga(at)yandex(dot)ru" <zlobnynigga(at)yandex(dot)ru>, pgsql-bugs(at)postgresql(dot)org
Cc: Tony Garner <tonyg(at)da(dot)org(dot)za>
Subject: Re: PostgreSQL and OpenVZ
Date: 2013-07-30 20:39:11
Message-ID: CALB3LJNfvPcRrPJgZe6rXtT-GV7XWf6i2BZNZ6GddSRwSotiQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dear Postgres Gurus
>
> Has there been any luck with this strange Postgres on OpenVZ edge case?
> We're also getting the 'could not read block' error.
>
> Warwick
>

On Monday, July 22, 2013, Warwick Chapman wrote:
>
>> Антон
>>
>> Did you manage to make any progress with OpenVZ and PostgreSQL on the
>> issue below in the last two years? We are running into the same problem
>> using OpenVZ VM's.
>>
>> -- Warwick Bruce Chapman | 081 270 1921 | http://wa.rwick.com
>>
>> From: Антон Степаненко <zlobnynigga(at)yandex(dot)ru>
>> To: Greg Smith <greg(at)2ndquadrant(dot)com>
>> Cc: pgsql-bugs(at)postgresql(dot)org
>> Subject: Re: could not read block XXXXX in file "base/YYYYY/ZZZZZZ":
>> read only 160 of 8192 bytes
>> Date: 2011-06-24 16:55:31
>> Message-ID: 1431308934531(at)web58(dot)yandex(dot)ru (view raw)
>>
>> 18.06.2011, 09:58, "Greg Smith" <greg(at)2ndQuadrant(dot)com>:
>> > I suspect you're running into some sort of OpenVZ shared memory handling
>> > bug. The way it handles this is one of the more complicated, and
>> > therefore likely to have odd failure cases, part of the design. There's
>> > notes at http://wiki.openvz.org/Postgresql_and_shared_memory about
>> > container-specific things to tune here, so maybe there's just a setting
>> > to tweak you've missed so far. I'm guessing you already went through
>> > that though.
>> >
>> > A quick look around shows there are far more regularly reported bugs
>> > like this in OpenVZ than there are in PostgreSQL, and Ubuntu is not
>> > known for bug-free release practices either. You're probably chasing
>> > after the wrong thing trying to find a database problem here. Likely to
>> > end up in the same situation as the last one of these I remember:
>> >
>> > http://archives.postgresql.org/pgsql-general/2009-10/msg00125.php
>> > http://lists.debian.org/debian-kernel/2010/03/msg00401.html
>> >
>> > ...waiting for the OpenVZ problem that's the real cause to get fixed and
>> > make its way to your distribution.
>> >
>>
>> Finally I finded out that problem is in OpenVZ, you were right. I've
>> managed to set up one replica on "pure" Linux without OpenVZ. And it works
>> for about a week already with 12Gb shared buffers.
>> I'm not sure what exactly is wrong with OpenVZ, but one thing that annoys
>> me is that I have not the last stable OpenVZ kernel. I will try to compile
>> the last one(unfortunately it requires new vzctl), and then run some tests
>> on it. And if it won't help - I'll go to OpenVZ community mailing lists and
>> brainfuck them =)
>> Thank you very much for your help, I appreciate it a lot. And sorry again
>> for my bad english.
>>
>>
>
> --
> -- Warwick Bruce Chapman | 081 270 1921 | http://wa.rwick.com
>
>

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2013-07-30 21:17:36 Re: BUG #8317: ROUND(double*1/2) != ROUND(1/2*double)
Previous Message Euler Taveira 2013-07-30 18:05:07 Re: Ferramenta de Modelagem