Re: Uninitialized pages notices

From: Timothy D McKernan <tdm4(at)dyrectmedia(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Uninitialized pages notices
Date: 2002-11-11 16:11:24
Message-ID: 3DCFD6AC.30401@dyrectmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Lane wrote:
> 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.

Yes, we have a dual processor board. Per your suggestion we'll be
upgrading the system soon and watching the results of that.

Thanks,
Tim

>
> regards, tom lane
>

--
Dyrect Media Group
P.O. Box 486
6000 Goodrich Rd
Clarence Center, NY 14032-0486

OFFICE: 716-504-1141 ext 208
CELL: 716-510-2451
AIM: somecallmetim100

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gary DeSorbo 2002-11-11 17:49:48 Monitor Tools
Previous Message Jodi Kanter 2002-11-11 16:07:43 constraint notices