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: Uninitialized pages notices
Date: 2002-11-08 04:47:11
Message-ID: 3DCB41CF.1070507@dyrectmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Our client is running a large-ish database, and has infrequently been
getting the following messages:

Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
page 6 - fixing
Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
page 7 - fixing
Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
page 8 - fixing
Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
page 9 - fixing
Nov 6 04:17:09 dolidb-n1 logger: NOTICE: Rel pg_type: Uninitialized
page 10 - fixing

This goes on for about 2000 lines. A google search found Tom Lane
telling someone with this symptom that they might have a serious
hardware problem. However, _that_ person was getting these messages on
a consistent basis, whereas we haven't seen this message in about 4
months, and then all of a sudden the other night during a nightly vacuum
it popped up.

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

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

Thanks,
Tim

--
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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-11-08 07:44:22 Re: Uninitialized pages notices
Previous Message Bruce Momjian 2002-11-08 04:46:23 Re: loading and unloading rows