invalid tid errors.

From: wade <wade(at)wavefire(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: invalid tid errors.
Date: 2002-12-13 00:16:55
Message-ID: 3.0.32.20021212161655.01cda420@mail.wavefire.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,
Using Postgresql 7.3 (CVS REL7_3_STABLE today), I received the following
error:

dropsites=> delete from cart_stores;
ERROR: heap_update: (am)invalid tid

This came from a database that was dumped from 7.2.1 using 7.2.1's pg_dump
and imported into 7.3. I was able to delete the rows individually with a
where clause ( WHERE id = ... ). The problem attempting to delete all rows
persisted even when there was only 1 row left, even though this last row
deleted fine when I specified it explicitly with a where clause. I was
able to delete the contents of other tables in the db without incident. I
was also able to reproduce this on a second box, also CVS REL7_3_STABLE
from about a week ago. This problem is not exhibited under 7.2.1.

So, the question is, how do I go about tracking this down? Has anyone seen
this? It was suggested by one person that memory may be the issue, but the
fact that it is exhibited on two boxen makes that seem unlikely.

FYI:
Machine 1:
PIII 600 w/ 256MB
FreeBSD 4.6 STABLE
Machine 2:
Dual PIII 600 w/ 512MB
FreeBSD 4.7 STABLE

Thanx in advance.
-Wade Klaver

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2002-12-13 03:10:00 Re: Creating a zero-column table
Previous Message Stephan Szabo 2002-12-13 00:09:51 Re: Postgres syscalls