BUG #5915: OldSerXidAdd inflates pg_serial too much

From: "YAMAMOTO Takashi" <yamt(at)mwd(dot)biglobe(dot)ne(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5915: OldSerXidAdd inflates pg_serial too much
Date: 2011-03-04 12:41:13
Message-ID: 201103041241.p24CfDZV063217@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5915
Logged by: YAMAMOTO Takashi
Email address: yamt(at)mwd(dot)biglobe(dot)ne(dot)jp
PostgreSQL version: 9.1devel
Operating system: NetBSD
Description: OldSerXidAdd inflates pg_serial too much
Details:

a seemingly wrong math in OldSerXidAdd makes it busy writing zeros
to pg_serial.

diff --git a/src/backend/storage/lmgr/predicate.c
b/src/backend/storage/lmgr/predicate.c
index aa657fa..297508b 100644
--- a/src/backend/storage/lmgr/predicate.c
+++ b/src/backend/storage/lmgr/predicate.c
@@ -755,7 +755,7 @@ OldSerXidAdd(TransactionId xid, SerCommitSeqNo
minConflictCommitSeqNo)
{
page = OldSerXidPage(tailXid);
oldSerXidControl->tailSegment = OldSerXidSegment(page);
- page = oldSerXidControl->tailSegment * OLDSERXID_ENTRIESPERPAGE;
+ page = oldSerXidControl->tailSegment * SLRU_PAGES_PER_SEGMENT;
isNewPage = true;
}
else

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2011-03-04 13:21:47 Re: Missing Bug-Report #5904?
Previous Message Torsten Zühlsdorff 2011-03-04 09:16:24 Missing Bug-Report #5904?