Re: 9.3.9 and pg_multixact corruption

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Bernd Helmle <bernd(at)oopsware(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 9.3.9 and pg_multixact corruption
Date: 2015-09-10 22:35:34
Message-ID: 20150910223534.GU2912@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bernd Helmle wrote:

> 2015-09-08 11:40:59 CEST [27047] DETAIL: Could not seek in file
> "pg_multixact/members/FFFF5FC4" to offset 4294950912: Invalid argument.
> 2015-09-08 11:40:59 CEST [27047] CONTEXT: xlog redo create mxid 1068235595
> offset 2147483648 nmembers 2: 2896635220 (upd) 2896635510 (keysh)

I just noticed that this offset number 2147483648 is exactly 2^31.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2015-09-10 22:45:46 Re: 9.3.9 and pg_multixact corruption
Previous Message Joe Conway 2015-09-10 21:50:38 Re: Multi-tenancy with RLS