Re: [GENERAL] NOTICE from the backend - Mailing list pgsql-general

From Vadim Mikheev
Subject Re: [GENERAL] NOTICE from the backend
Date
Msg-id 372AF27E.C4491D5@krs.ru
Whole thread Raw
In response to NOTICE from the backend  (Ulf Mehlig <umehlig@uni-bremen.de>)
Responses Re: [GENERAL] NOTICE from the backend  (Ulf Mehlig <umehlig@uni-bremen.de>)
List pgsql-general
Ulf Mehlig wrote:
>
> Hello PostgreSQL specialists! Short Question: What does the message
>
>   "NOTICE: Rel li64_dkopf: TID 1/7: TID IN TUPLEHEADER 4/2 IS NOT THE
>   SAME. TUPGONE 0."
>
> mean? Anything dangerous? (it appeared with lots of others of the same
        ^^^^^^^^^^^^^^^^^^
Yes.

> type after a "vacuum analyze").

As result of attempt to update 7th tuple in 1st block 2nd tuple
in 4th block will be updated. Dump/reload this table...

Seems that when I added this check I should add code to
set TID in header to valid value... -:(

Unfortunately, I don't know from where this TID difference comes
and this is very important to find it. After what operations/
assertions/FATALs you got this vacuum NOTICE?

Vadim

pgsql-general by date:

Previous
From: Ulf Mehlig
Date:
Subject: NOTICE from the backend
Next
From: "Mario Simeone"
Date:
Subject: