| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: can't shrink relation |
| Date: | 2002-01-17 15:16:05 |
| Message-ID: | 23610.1011280565@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> writes:
> I am getting a NOTICE in logs about once a day:
> NOTICE: Rel s: TID 212/16: DeleteTransactionInProgress 0 - can't
> shrink relation
AFAICT, the only way to get that message is if you have a tuple with
good (committed) t_xmin, but t_xmax is 0, and yet HEAP_XMAX_INVALID
is not set. Bizarre. Does the tuple appear valid otherwise?
(Try "select * from s where ctid = '(212,16)'" to view it.)
> Moreover, this error is occuring in the same database I reported as
> saying 'Relation pg_shadow does not exist' the other day.
You've got something mighty weird going on there. Possibly time for
a dump/initdb/reload. Possibly time to run some memory & disk
diagnostics.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-17 15:33:24 | Re: [ADMIN] CREATE OR REPLACE VIEW / TRIGGER |
| Previous Message | Jan Wieck | 2002-01-17 15:04:26 | Re: [HACKERS] CREATE OR REPLACE VIEW / TRIGGER |