Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory

Поиск
Список
Период
Сортировка
От Mike Williams
Тема Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory
Дата
Msg-id 719e433b1c118d4d8de72f171199678a.squirrel@mail.brad.office.comodo.net
обсуждение исходный текст
Ответ на Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory  (Alex Hunsaker <badalex@gmail.com>)
Список pgsql-admin
On Sun, March 28, 2010 8:49 pm, Tom Lane wrote:
>> The server is Gentoo, and I don't have an identical server to use. This
>> machines HA partner is staying at 8.3.5 until we're completely and
>> entirely sure 8.3.10 works right.
>
> I wasn't really suggesting that you need an *identical* machine.  If
> this is a software problem, as seems moderately likely at this point,
> it should be possible to reproduce it on a different machine.  Even more
> to the point, it's going to be difficult to find the problem without
> tracing through the fault case with a debugger --- which isn't something
> you're going to want to do on a production server.  Have you got a test
> machine you can load the data onto?  Preferably one you could give a PG
> developer access to?

We do have a test system, and the only significant difference from
production is the kernel.
Test are para-virt VMs with "regular" kernels, production are real
machines with hardened kernels (grsec+pax).
I got prod onto a regular kernel and nothing in nearly an hour.

8.3.5 has worked forever and a day on this type of setup.

--
Mike Williams


В списке pgsql-admin по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Socket & TCP connections
Следующее
От: Nilesh Govindarajan
Дата:
Сообщение: Re: Socket & TCP connections