Skip site navigation (1) Skip section navigation (2)

Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol forhot standby.

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol forhot standby.
Date: 2008-10-22 18:08:52
Message-ID: 1224698932.27145.398.camel@ebony.2ndQuadrant (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
On Wed, 2008-10-22 at 13:25 -0400, Tom Lane wrote:
> #5  0x171680 in TransactionIdSetStatusBit (xid=2063810256,
> status=2063810248, 
>     lsn={xlogid = 0, xrecoff = 0}, slotno=0) at clog.c:330
> #6  0x1714e8 in TransactionIdSetPageStatus (xid=84, nsubxids=1, 
>     subxids=0x4008dd78, status=2063840993, lsn={xlogid = 0, xrecoff =
> 0}, 
>     pageno=0) at clog.c:290
> #7  0x1712dc in TransactionIdSetTreeStatus (xid=19394, nsubxids=1, 
>     subxids=0x4008dd78, status=1, lsn={xlogid = 0, xrecoff = 0}) at
> clog.c:204
> #8  0x1722f8 in TransactionIdCommitTree (xid=2063670312,
> nxids=2063839972, 
>     xids=0x7b011cf0) at transam.c:266
> #9  0x1785b8 in xact_redo_commit (xlrec=0x4008dd48, xid=19394) at
> xact.c:4222

These traces look weird. Look at the way the xid changes value as we
move from call to call. It looks like something is screwy there. If
those values are correct we should have failed an earlier assertion.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2008-10-22 18:43:24
Subject: Re: minimal update
Previous:From: Simon RiggsDate: 2008-10-22 17:57:42
Subject: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol forhot standby.

pgsql-committers by date

Next:From: Tom LaneDate: 2008-10-22 19:18:51
Subject: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby.
Previous:From: Simon RiggsDate: 2008-10-22 17:57:42
Subject: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol forhot standby.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group