Re: [ADMIN] Vacuum return codes (vacuum as db integrity check?)

[Timothy D McKernan]

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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster