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

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