Re: Redo record at high number

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Boes <jboes(at)nexcerpt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Redo record at high number
Date: 2001-10-05 19:38:30
Message-ID: 3705826352029646A3E91C53F7189E320167B6@sectorbase2.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> > We have noticed this line in our server log:
> > Redo record at (5, 4209179252); Undo record at (0, 0); Shutdown TRUE
>
> > That second number seems awfully high; should this give us cause for
> > concern?
>
> Looks fishy to me too --- the offset shouldn't exceed 24 bits AFAIR.
> Vadim, what do you think?

Log record ptr is 4 bytes for log file ID and 4 bytes for record offset.
# of segmets in log file (2^32 - 1) / 2^24 = 255
Max offset *in segment* is 2^24 , but max offset *in log file*
is 255 * 2^24 = 4278190080

Vadim

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-10-05 19:44:01 Re: Redo record at high number
Previous Message Chris Pesko 2001-10-05 19:25:18 Problem with "password" authentication