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: | Raw Message | Whole Thread | 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 |