| 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@web58.yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2011-06-24 18:28:46 | Re: BUG #6076: Unexpected "Security Definer / invoker" interaction |
| Previous Message | Dmitry Grebeniuk | 2011-06-24 16:43:56 | BUG #6077: documentation on PQfmod for numeric data types |