Re: what does this mean: "running xacts with xcnt == 0"

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: what does this mean: "running xacts with xcnt == 0"
Date: 2014-11-12 14:09:32
Message-ID: 20141112140932.GA25234@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2014-11-12 09:03:40 -0500, Peter Eisentraut wrote:
> Could someone translate this detail message to English:
>
> ereport(LOG,
> (errmsg("logical decoding found consistent point at %X/%X",
> (uint32) (lsn >> 32), (uint32) lsn),
> errdetail("running xacts with xcnt == 0")));

It means there a xl_running_xacts record was encountered that had xcnt =
0 - allowing logical decoding to find a consistent start point

> (or downgrade to debug message, if appropriate)?

The message generally is quite relevant, as the process of finding a
consistent start point can take quite a while. we don't really have a
nice way to make errdetail() only be logged on a certain severity level
as far as I am aware off.

So maybe 'Encountered xl_running_xacts record with xcnt = 0.'?

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-11-12 14:56:01 Re: what does this mean: "running xacts with xcnt == 0"
Previous Message Peter Eisentraut 2014-11-12 14:03:40 what does this mean: "running xacts with xcnt == 0"