| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Rich Ryan" <rich(at)usedcars(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Vacuum errors and warnings |
| Date: | 2001-12-11 00:32:43 |
| Message-ID: | 5778.1008030763@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Rich Ryan" <rich(at)usedcars(dot)com> writes:
> Vacuuming
> (These messages I receive every night)
> NOTICE: RegisterSharedInvalid: SI buffer overflow
> NOTICE: RegisterSharedInvalid: SI buffer overflow
> NOTICE: InvalidateSharedInvalid: cache state reset
These are ignorable.
> NOTICE: Rel r_maryland: Uninitialized page 730 - fixing
> NOTICE: Index cfsoidmaryland: pointer to EmptyPage (blk 730 off 4) - fixing
> NOTICE: Index cfsoidmaryland: pointer to EmptyPage (blk 730 off 8) - fixing
These are not good. Is it possible you've got disk hardware problems?
A possible answer is to rebuild that damaged index with REINDEX, but if
the problems keep coming back then you've got something very wrong.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Laub | 2001-12-11 00:38:37 | Re: referential integrity on existing table |
| Previous Message | Tom Lane | 2001-12-11 00:30:31 | Re: idle in transaction |