Postgres Pro
Downloads
Home   >   mailing lists

Re: 9.3.9 and pg_multixact corruption - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: 9.3.9 and pg_multixact corruption
Date
Msg-id 20150910223534.GU2912@alvherre.pgsql
Whole thread Raw
In response to 9.3.9 and pg_multixact corruption  (Bernd Helmle <bernd@oopsware.de>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Multi-tenancy with RLS
Next
From: Alvaro Herrera
Date:
Subject: Re: 9.3.9 and pg_multixact corruption