From: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: reporting TID/table with corruption error
Date: Thu, 19 Aug 2021 18:36:15 +0100
Message-ID: <87y28xuyk0.fsf@wibble.ilmari.org> (raw)
In-Reply-To: <CAH2-WzmCLNK09r_C+A9ZxmmdZ2AjgDGyCJjVYWBun2LUws_gJw@mail.gmail.com>
References: <202108191637.oqyzrdtnheir@alvherre.pgsql>
<CAH2-WzmCLNK09r_C+A9ZxmmdZ2AjgDGyCJjVYWBun2LUws_gJw@mail.gmail.com>
Peter Geoghegan <pg@bowt.ie> writes:
> On Thu, Aug 19, 2021 at 9:38 AM Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>> A customer recently hit this error message:
>>
>> ERROR: t_xmin is uncommitted in tuple to be updated
>>
>> This was not very informative, so without any clues, we had to let it
>> go. But it did occur to me that we can improve this message so that we
>> know details such as the TID and the relation that caused the issue, so
>> that if it ever occurs again we can at least look at the WAL stream for
>> anything affecting the tuple, maybe it'd help to understand the problem.
>
> I think that this is a very good idea. Ideally this stuff would be
> more standardized.
There are various functions for adding auxilliary fields to the error
report, e.g. errtable() for the schema and table names, but that only
seems to be reported to the client, not logged on the server.
Should we be logging auxiliary error fields? If not by default, maybe
by a higher log_error_verbosity level (possibly a new one between
default and verbose).
- ilmari
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: ilmari@ilmari.org, pg@bowt.ie, alvherre@alvh.no-ip.org, pgsql-hackers@lists.postgresql.org
Subject: Re: reporting TID/table with corruption error
In-Reply-To: <87y28xuyk0.fsf@wibble.ilmari.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox