Skip site navigation (1) Skip section navigation (2)

HEAP_MOVED_IN error during vacuum?

From: Stephen Birch <sbirch(at)ironmountainsystems(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: HEAP_MOVED_IN error during vacuum?
Date: 1999-12-30 16:43:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
When I vacuum the database (PostgreSQL 6.5.3 on SuSE 6.3 Linux, 2.2 kernel), I get the
following error message:

ERROR: HEAP_MOVED_IN was not expected.
vacuumdb: database vacuum failed on ntis

This error only seems to occur after I have used the trim function to clean up one of
the rows in the msg table of a database called ntis:

ntis=>update msg set description = trim(description);
UPDATE 12069

To try and track down the problem, I wrote a C program (using ecpg) that trimmed the
table one row at a time and vacuumed between each row operation.  I was hoping that
this program would reveal a problem with the data in one of my records.  Unfortunately
the one row at a time approach did not reveal the problem and each vacuum operated
without error.

Can anyone tell me what a HEAP_MOVED_IN error is - I checked the source but was not
familiar enough to understand it?  Any ideas on why trim() may have cause it?

In response to


pgsql-hackers by date

Next:From: Bruce MomjianDate: 1999-12-30 17:01:29
Subject: Re: [HACKERS] Source code format vote
Previous:From: Tom LaneDate: 1999-12-30 15:11:00
Subject: Re: [HACKERS] Source code format vote

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group