Re: Uninitialized pages notices

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Timothy D McKernan <tdm4(at)dyrectmedia(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Uninitialized pages notices
Date: 2002-11-08 07:44:22
Message-ID: 3404.1036741462@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Timothy D McKernan <tdm4(at)dyrectmedia(dot)com> writes:
> Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
> page 6 - fixing

> I'd like to know what this means to our system - what causes an
> uninitialized page? What could cause it to be so infrequent?

"Uninitialized" means "page contains zeroes" (or at least a few critical
page-header fields contain zeroes, which they should never do). Usually
I take this as an indication of hardware problems. But:

> Here are our system details:
> postgre: 7.2.3 (~4GB in size)
> os: Redhat 7.1sbe (Seawolf)
> kernel: 2.4.9-12smp
> ram: ~1GB ECC

SMP? Are you actually using SMP hardware? I seem to recall that the
2.4 Linux kernels weren't stable on SMP machines till 2.4.15 or
thereabouts. In any case, RedHat 7.1 is pretty long in the tooth.
Perhaps an OS update would make life better.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-11-08 12:21:00 problem with DBMirror.pl ...
Previous Message Timothy D McKernan 2002-11-08 04:47:11 Uninitialized pages notices