Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M208381=pgsql-general-arkari@postgresql.org>)
 id 1XUsyT-00064u-T8
 for pgsql-general@arkaria.postgresql.org; Fri, 19 Sep 2014 07:51:26 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M208381=pgsql-general-arkari@postgresql.org>)
 id 1XUsyT-0008LY-8H
 for pgsql-general@arkaria.postgresql.org; Fri, 19 Sep 2014 07:51:25 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <devdas.kumkar@gmail.com>)
 id 1XUsyR-0008LL-Bc; Fri, 19 Sep 2014 07:51:23 +0000
Received: from mail-la0-x229.google.com ([2a00:1450:4010:c03::229])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <devdas.kumkar@gmail.com>)
 id 1XUsyN-0000m9-CH; Fri, 19 Sep 2014 07:51:20 +0000
Received: by mail-la0-f41.google.com with SMTP id s18so2663750lam.28
 for <multiple recipients>; Fri, 19 Sep 2014 00:51:17 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:date:message-id:subject:from:to
 :cc:content-type;
 bh=BKS9T86t7z5ic/82b3a7C7mG1XvvIHD0pKpmliBzx2s=;
 b=bzIMlDoTTlO0L5mKj8mFVQ/s/KLsRPwAnr7vU6lW7gMPOg13ajphEgDf/RP79UWUzJ
 7Z0nyjkNK3B5bd6KH/e60tqqduB8xhuGnqVeINM5/vWcPrqjWiZJGzkJzpRs9uLUNpQj
 yFb1Vpn0Bn5VlHyKvNw7EUPaHHx4s0MkwRAg4+sBBjdgAACrh8mQmVoadNODh3Ajp7zX
 FOO3JuDeQZQyTIsjBqQYhEoCIE5MZUb6ALMWJFPRwSgTqE+CkSzIZo6CILCmJzyDNEw1
 AKOYzvEfWQY8l9LFwBKcUACvq2cW8ObVMVZgA+9MZkt3ZVa9vr0X0ec4XkmRlrSuqC5R
 baaA==
MIME-Version: 1.0
X-Received: by 10.112.53.199 with SMTP id d7mr1145861lbp.106.1411113077034;
 Fri, 19 Sep 2014 00:51:17 -0700 (PDT)
Received: by 10.112.51.6 with HTTP; Fri, 19 Sep 2014 00:51:16 -0700 (PDT)
In-Reply-To: <20140919023755.GS4701@eldon.alvh.no-ip.org>
References: 
 <CALSLE1P4knmyFa5BzdeYo7fVnjw-1-TwW9dXTEW-9nJjK4fQMg@mail.gmail.com>
 <54198AEB.2070508@aklaver.com>
 <CALSLE1Pywi4SAyvOVHn+FfxTHMF88t4esgPXxwS9etWMzeE0Rg@mail.gmail.com>
 <CALSLE1MAgy4QC0-xLju6MBxO6Upp6=84xwAMt2dkfiGbd6pB9Q@mail.gmail.com>
 <5419F908.2080303@aklaver.com>
 <CALSLE1NT9c9eYs95Q3=7C5dWkzrrULQTy6bcSkFsP1OKA+AXHg@mail.gmail.com>
 <20140918103338.GF17265@alap3.anarazel.de>
 <CALSLE1Mngj=vyA-hdKaB-HWQ=gU_A3vDRE4ddyKwViTRFXmLFg@mail.gmail.com>
 <20140919023755.GS4701@eldon.alvh.no-ip.org>
Date: Fri, 19 Sep 2014 13:21:16 +0530
Message-ID: 
 <CALSLE1MSyf_68KoAXSq8ayUcCwMGCDcbUBpm63TPm75SzYAdNw@mail.gmail.com>
Subject: Re: [SQL] pg_multixact issues
From: Dev Kumkar <devdas.kumkar@gmail.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Andres Freund <andres@2ndquadrant.com>,
 Adrian Klaver <adrian.klaver@aklaver.com>,
 "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>,
 pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=001a1133d09eb1d28d0503665dbb
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

--001a1133d09eb1d28d0503665dbb
Content-Type: text/plain; charset=UTF-8

On Fri, Sep 19, 2014 at 8:07 AM, Alvaro Herrera <alvherre@2ndquadrant.com>
wrote:

> Can you paste the pg_controldata output please?
>

pg_controldata output as follows:

pg_control version number:            937
Catalog version number:               201306121
Database system identifier:           6023658189132429183
Database cluster state:               in production
pg_control last modified:             Fri Sep 19 12:09:05 2014
Latest checkpoint location:           2D3/5DB461C0
Prior checkpoint location:            2D3/5D08D0D0
Latest checkpoint's REDO location:    2D3/5D68EFE0
Latest checkpoint's REDO WAL file:    00000001000002D30000005D
Latest checkpoint's TimeLineID:       1
Latest checkpoint's PrevTimeLineID:   1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/10882952
Latest checkpoint's NextOID:          3443291
Latest checkpoint's NextMultiXactId:  3622064
Latest checkpoint's NextMultiOffset:  4294172074
Latest checkpoint's oldestXID:        1673
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Time of latest checkpoint:            Fri Sep 19 12:06:35 2014
Fake LSN counter for unlogged rels:   0/1
Minimum recovery ending location:     0/0
Min recovery ending loc's timeline:   0
Backup start location:                0/0
Backup end location:                  0/0
End-of-backup record required:        no
Current wal_level setting:            minimal
Current max_connections setting:      100
Current max_prepared_xacts setting:   0
Current max_locks_per_xact setting:   64
Maximum data alignment:               8
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        1996
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value
Data page checksum version:           0



> Also, what files are there in pg_multixact/offsets/ ?
>
Currently there are about 56 files in  pg_multixact/offsets/.

0000  0002  0004  0006  0008  000A  000C  000E  0010  0012  0014  0016
0018  001A  001C  001E  0020  0022  0024  0026  0028  002A  002C  002E
0030  0032  0034  0036
0001  0003  0005  0007  0009  000B  000D  000F  0011  0013  0015  0017
0019  001B  001D  001F  0021  0023  0025  0027  0029  002B  002D  002F
0031  0033  0035  0037

Regards...

--001a1133d09eb1d28d0503665dbb
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+PGRpdiBjbGFzcz0iZ21haWxfZXh0cmEiPjxkaXYgY2xhc3M9ImdtYWls
X3F1b3RlIj5PbiBGcmksIFNlcCAxOSwgMjAxNCBhdCA4OjA3IEFNLCBBbHZhcm8gSGVycmVyYSA8
c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzphbHZoZXJyZUAybmRxdWFkcmFudC5j
b20iIHRhcmdldD0iX2JsYW5rIj5hbHZoZXJyZUAybmRxdWFkcmFudC5jb208L2E+Jmd0Ozwvc3Bh
bj4gd3JvdGU6PGJyPjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdp
bjowcHQgMHB0IDBwdCAwLjhleDtib3JkZXItbGVmdDoxcHggc29saWQgcmdiKDIwNCwyMDQsMjA0
KTtwYWRkaW5nLWxlZnQ6MWV4Ij48c3BhbiBjbGFzcz0iIj48L3NwYW4+PHNwYW4gY2xhc3M9IiI+
DQo8L3NwYW4+Q2FuIHlvdSBwYXN0ZSB0aGUgcGdfY29udHJvbGRhdGEgb3V0cHV0IHBsZWFzZT88
YnI+PC9ibG9ja3F1b3RlPjxkaXY+PGJyPnBnX2NvbnRyb2xkYXRhIG91dHB1dCBhcyBmb2xsb3dz
Ojxicj48YnI+cGdfY29udHJvbCB2ZXJzaW9uIG51bWJlcjrCoMKgwqDCoMKgwqDCoMKgwqDCoMKg
IDkzNzxicj5DYXRhbG9nIHZlcnNpb24gbnVtYmVyOsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg
wqAgMjAxMzA2MTIxPGJyPkRhdGFiYXNlIHN5c3RlbSBpZGVudGlmaWVyOsKgwqDCoMKgwqDCoMKg
wqDCoMKgIDYwMjM2NTgxODkxMzI0MjkxODM8YnI+RGF0YWJhc2UgY2x1c3RlciBzdGF0ZTrCoMKg
wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIGluIHByb2R1Y3Rpb248YnI+cGdfY29udHJvbCBsYXN0
IG1vZGlmaWVkOsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBGcmkgU2VwIDE5IDEyOjA5OjA1IDIw
MTQ8YnI+TGF0ZXN0IGNoZWNrcG9pbnQgbG9jYXRpb246wqDCoMKgwqDCoMKgwqDCoMKgwqAgMkQz
LzVEQjQ2MUMwPGJyPlByaW9yIGNoZWNrcG9pbnQgbG9jYXRpb246wqDCoMKgwqDCoMKgwqDCoMKg
wqDCoCAyRDMvNUQwOEQwRDA8YnI+TGF0ZXN0IGNoZWNrcG9pbnQmIzM5O3MgUkVETyBsb2NhdGlv
bjrCoMKgwqAgMkQzLzVENjhFRkUwPGJyPkxhdGVzdCBjaGVja3BvaW50JiMzOTtzIFJFRE8gV0FM
IGZpbGU6wqDCoMKgIDAwMDAwMDAxMDAwMDAyRDMwMDAwMDA1RDxicj5MYXRlc3QgY2hlY2twb2lu
dCYjMzk7cyBUaW1lTGluZUlEOsKgwqDCoMKgwqDCoCAxPGJyPkxhdGVzdCBjaGVja3BvaW50JiMz
OTtzIFByZXZUaW1lTGluZUlEOsKgwqAgMTxicj5MYXRlc3QgY2hlY2twb2ludCYjMzk7cyBmdWxs
X3BhZ2Vfd3JpdGVzOiBvbjxicj5MYXRlc3QgY2hlY2twb2ludCYjMzk7cyBOZXh0WElEOsKgwqDC
oMKgwqDCoMKgwqDCoCAwLzEwODgyOTUyPGJyPkxhdGVzdCBjaGVja3BvaW50JiMzOTtzIE5leHRP
SUQ6wqDCoMKgwqDCoMKgwqDCoMKgIDM0NDMyOTE8YnI+TGF0ZXN0IGNoZWNrcG9pbnQmIzM5O3Mg
TmV4dE11bHRpWGFjdElkOsKgIDM2MjIwNjQ8YnI+TGF0ZXN0IGNoZWNrcG9pbnQmIzM5O3MgTmV4
dE11bHRpT2Zmc2V0OsKgIDQyOTQxNzIwNzQ8YnI+TGF0ZXN0IGNoZWNrcG9pbnQmIzM5O3Mgb2xk
ZXN0WElEOsKgwqDCoMKgwqDCoMKgIDE2NzM8YnI+TGF0ZXN0IGNoZWNrcG9pbnQmIzM5O3Mgb2xk
ZXN0WElEJiMzOTtzIERCOsKgwqAgMTxicj5MYXRlc3QgY2hlY2twb2ludCYjMzk7cyBvbGRlc3RB
Y3RpdmVYSUQ6wqAgMDxicj5MYXRlc3QgY2hlY2twb2ludCYjMzk7cyBvbGRlc3RNdWx0aVhpZDrC
oMKgIDE8YnI+TGF0ZXN0IGNoZWNrcG9pbnQmIzM5O3Mgb2xkZXN0TXVsdGkmIzM5O3MgREI6IDE8
YnI+VGltZSBvZiBsYXRlc3QgY2hlY2twb2ludDrCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIEZyaSBT
ZXAgMTkgMTI6MDY6MzUgMjAxNDxicj5GYWtlIExTTiBjb3VudGVyIGZvciB1bmxvZ2dlZCByZWxz
OsKgwqAgMC8xPGJyPk1pbmltdW0gcmVjb3ZlcnkgZW5kaW5nIGxvY2F0aW9uOsKgwqDCoMKgIDAv
MDxicj5NaW4gcmVjb3ZlcnkgZW5kaW5nIGxvYyYjMzk7cyB0aW1lbGluZTrCoMKgIDA8YnI+QmFj
a3VwIHN0YXJ0IGxvY2F0aW9uOsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCAwLzA8YnI+
QmFja3VwIGVuZCBsb2NhdGlvbjrCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIDAv
MDxicj5FbmQtb2YtYmFja3VwIHJlY29yZCByZXF1aXJlZDrCoMKgwqDCoMKgwqDCoCBubzxicj5D
dXJyZW50IHdhbF9sZXZlbCBzZXR0aW5nOsKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgbWluaW1hbDxi
cj5DdXJyZW50IG1heF9jb25uZWN0aW9ucyBzZXR0aW5nOsKgwqDCoMKgwqAgMTAwPGJyPkN1cnJl
bnQgbWF4X3ByZXBhcmVkX3hhY3RzIHNldHRpbmc6wqDCoCAwPGJyPkN1cnJlbnQgbWF4X2xvY2tz
X3Blcl94YWN0IHNldHRpbmc6wqDCoCA2NDxicj5NYXhpbXVtIGRhdGEgYWxpZ25tZW50OsKgwqDC
oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgODxicj5EYXRhYmFzZSBibG9jayBzaXplOsKgwqDCoMKg
wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgODE5Mjxicj5CbG9ja3MgcGVyIHNlZ21lbnQgb2Yg
bGFyZ2UgcmVsYXRpb246IDEzMTA3Mjxicj5XQUwgYmxvY2sgc2l6ZTrCoMKgwqDCoMKgwqDCoMKg
wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCA4MTkyPGJyPkJ5dGVzIHBlciBXQUwgc2VnbWVu
dDrCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgMTY3NzcyMTY8YnI+TWF4aW11bSBsZW5n
dGggb2YgaWRlbnRpZmllcnM6wqDCoMKgwqDCoMKgwqAgNjQ8YnI+TWF4aW11bSBjb2x1bW5zIGlu
IGFuIGluZGV4OsKgwqDCoMKgwqDCoMKgwqDCoCAzMjxicj5NYXhpbXVtIHNpemUgb2YgYSBUT0FT
VCBjaHVuazrCoMKgwqDCoMKgwqDCoCAxOTk2PGJyPkRhdGUvdGltZSB0eXBlIHN0b3JhZ2U6wqDC
oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCA2NC1iaXQgaW50ZWdlcnM8YnI+RmxvYXQ0IGFyZ3Vt
ZW50IHBhc3Npbmc6wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgYnkgdmFsdWU8YnI+RmxvYXQ4
IGFyZ3VtZW50IHBhc3Npbmc6wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgYnkgdmFsdWU8YnI+
RGF0YSBwYWdlIGNoZWNrc3VtIHZlcnNpb246wqDCoMKgwqDCoMKgwqDCoMKgwqAgMDxicj7CoDwv
ZGl2PjxkaXY+wqA8L2Rpdj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJt
YXJnaW46MHB0IDBwdCAwcHQgMC44ZXg7Ym9yZGVyLWxlZnQ6MXB4IHNvbGlkIHJnYigyMDQsMjA0
LDIwNCk7cGFkZGluZy1sZWZ0OjFleCI+DQpBbHNvLCB3aGF0IGZpbGVzIGFyZSB0aGVyZSBpbiBw
Z19tdWx0aXhhY3Qvb2Zmc2V0cy8gPzxicj48L2Jsb2NrcXVvdGU+PGRpdj5DdXJyZW50bHkgdGhl
cmUgYXJlIGFib3V0IDU2IGZpbGVzIGluwqAgcGdfbXVsdGl4YWN0L29mZnNldHMvLjxicj48YnI+
MDAwMMKgIDAwMDLCoCAwMDA0wqAgMDAwNsKgIDAwMDjCoCAwMDBBwqAgMDAwQ8KgIDAwMEXCoCAw
MDEwwqAgMDAxMsKgIDAwMTTCoCAwMDE2wqAgMDAxOMKgIDAwMUHCoCAwMDFDwqAgMDAxRcKgIDAw
MjDCoCAwMDIywqAgMDAyNMKgIDAwMjbCoCAwMDI4wqAgMDAyQcKgIDAwMkPCoCAwMDJFwqAgMDAz
MMKgIDAwMzLCoCAwMDM0wqAgMDAzNjxicj4wMDAxwqAgMDAwM8KgIDAwMDXCoCAwMDA3wqAgMDAw
OcKgIDAwMELCoCAwMDBEwqAgMDAwRsKgIDAwMTHCoCAwMDEzwqAgMDAxNcKgIDAwMTfCoCAwMDE5
wqAgMDAxQsKgIDAwMUTCoCAwMDFGwqAgMDAyMcKgIDAwMjPCoCAwMDI1wqAgMDAyN8KgIDAwMjnC
oCAwMDJCwqAgMDAyRMKgIDAwMkbCoCAwMDMxwqAgMDAzM8KgIDAwMzXCoCAwMDM3PGJyPjxicj48
L2Rpdj48ZGl2PlJlZ2FyZHMuLi48YnI+PC9kaXY+PC9kaXY+PC9kaXY+PC9kaXY+DQo=
--001a1133d09eb1d28d0503665dbb--