Re: ERROR: MultiXactId XXXXX has not been created yet -- apparent wraparound

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: ERROR: MultiXactId XXXXX has not been created yet -- apparent wraparound
Дата
Msg-id 41635c5b-4fef-eba6-b206-6b91058d3d56@aklaver.com
обсуждение исходный текст
Ответ на Re: ERROR: MultiXactId XXXXX has not been created yet -- apparent wraparound  (Ioana Danes <ioanadanes@gmail.com>)
Ответы Re: ERROR: MultiXactId XXXXX has not been created yet -- apparent wraparound  (Ioana Danes <ioanadanes@gmail.com>)
Список pgsql-general
On 08/15/2016 08:05 AM, Ioana Danes wrote:
>
>
> On Mon, Aug 15, 2016 at 10:52 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>
>
>
>         They are not the same servers but they have similar setup.
>         Fortunately
>         they are qa and development.
>
>
>     Should have asked previously, are they on the same host machine?
>
> No they are on different physical machines.
>
>
>     Basically, something is corrupting data, just trying to narrow it
>     down to hardware or software. Looking to figure out if the
>     problem(s) follow the physical machine or the software the Postgres
>     is running on.
>
> I would say software because on the same physical machines we had SLES +
> XEN running for years without any kind of corruption.
>

I would tend to agree, but one cannot discount the effects of age. Could
be that the OS switch happened just prior to some age induced failure in
hardware.

Still, do you have a running Postgres instance or have you tried running
a Postgres instance on CentOS that is not in a VM?


--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Ioana Danes
Дата:
Сообщение: Re: ERROR: MultiXactId XXXXX has not been created yet -- apparent wraparound
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: 9.2 to 9.5 pg_upgrade losing data