James Leigh wrote:
> I am using 6.4.2 postgresql from a Mandrake rpm. That I cannot change
> :(.
Whow - now that's old.
> Is this a bug? I get it some times when deleting a record. This is
> happening inside a C program and it segfaults after writing this error.
> It is hard to reproduce, but it happens. Any old dogs know what this
> means?
>
> ERROR: heap_delete: (am)invalid tid
Not totally sure, it's hard to tell. Actually the heap access
method is trying to delete a row that shouldn't have been
found according to HeapTupleSatisfies() in the first place.
So the question is why has it been found?
Could it be that you had a transaction ID wrap around? I
mean, v6.4.2, that system might be running without
dump/reload for some time. Such a wrap around could result
in major corruption of your data, so you might stop recycling
any of your old backup tapes until you know for sure what the
reason is/was and that your database is still consistent.
How big is the data/pg_log file?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
