Postgres Pro
Downloads
Home   >   mailing lists

VACUUM FULL PROBLEM - Mailing list pgsql-general

From Erol Oz
Subject VACUUM FULL PROBLEM
Date
Msg-id 010d01c31078$feaff450$0b00000a@erol
Whole thread Raw
List pgsql-general
Tree view
Hi,
I have a problem during VACUUM FULL with version 7.2.3.
Could someone give me hint on what the problem is?
Thanks in advance
Erol
 
Messages as follows:

NOTICE: Rel pg_type: TID 5/6: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_type: TID 5/7: InsertTransactionInProgress 74704911 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/7: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/8: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/9: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/10: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/11: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/12: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/13: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/14: InsertTransactionInProgress 74704292 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/15: InsertTransactionInProgress 74704911 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/16: InsertTransactionInProgress 74704911 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/17: InsertTransactionInProgress 74704911 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/18: InsertTransactionInProgress 74704911 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/19: InsertTransactionInProgress 74704911 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/20: InsertTransactionInProgress 74704911 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/21: InsertTransactionInProgress 74704911 - can't shrink relation

NOTICE: Rel pg_attribute: TID 47/22: InsertTransactionInProgress 74704911 - can't shrink relation

ERROR: Parent tuple was not found

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: qsort (was Re: Solaris)
Next
From: Mark Kirkwood
Date:
Subject: Re: qsort (was Re: Solaris)