| From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | can't shrink relation |
| Date: | 2002-01-17 14:50:47 |
| Message-ID: | Pine.LNX.4.21.0201180144230.17690-100000@linuxworld.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I am getting a NOTICE in logs about once a day:
NOTICE: Rel s: TID 212/16: DeleteTransactionInProgress 0 - can't
shrink relation
This is generated by vacuum. This does not happen after removing the
contents of the relation and re-inserting the data. I noticed this kind of
error in relation to a post on pg-general. Moreover, this error is
occuring in the same database I reported as saying 'Relation pg_shadow
does not exist' the other day.
oup=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)
Running on Linux 2.2 series kernel. The system has not crashed recently,
no disk failures, etc. In fact, postgres had been up since a few days
after 7.1.3 was released.
Thanks in advance,
Gavin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2002-01-17 15:04:26 | Re: [HACKERS] CREATE OR REPLACE VIEW / TRIGGER |
| Previous Message | Tom Lane | 2002-01-17 14:22:36 | Re: tuptoaster.c must *not* use SnapshotAny |