pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andres Freund <andres@anarazel.de>
To: Alexandre Garcia <alexandre@vmfarms.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgresql 9.6 - cannot freeze committed xmax
Date: Wed, 28 Feb 2018 13:16:22 -0800
Message-ID: <20180228211621.vikbp5s3rwg47455@alap3.anarazel.de> (raw)
In-Reply-To: <CAPYLKR5h8_zm92wrCSqnszfiBauZ6MMVXQfq57cGDxZ579DfcA@mail.gmail.com>
References: <CAPYLKR6yxV4=pfW0Gwij7aPNiiPx+3ib4USVYnbuQdUtmkMaEA@mail.gmail.com>
	<20180226230931.3m7js5dkzxnu7tbi@alvherre.pgsql>
	<20180226232113.a3aqlzpckcue4drt@alap3.anarazel.de>
	<CAPYLKR5h8_zm92wrCSqnszfiBauZ6MMVXQfq57cGDxZ579DfcA@mail.gmail.com>

Hi,

On 2018-02-28 21:12:58 +0000, Alexandre Garcia wrote:
> Thanks for your answers, took me a little while to restore a backup from
> before the upgrade on an empty 9.2 server but here we are =>
> https://gist.github.com/kuuji/cc73c3c193a0d58aa0e651fbd7bfec58

Thanks.

> > > > Prod starting throwing the following errors during autovacuum ->
> > 'cannot
> > > > freeze committed xmax <xid>' on 2 different tables. Running vacuum
> > manually
> > > > revealed more tables affected by the same error.

What's an example <xid> in that message that triggers for
problematic_table?  I need that to properly interpret the data you
provided.

Thanks,

Andres




view thread (16+ messages)  latest in thread

Message-ID: <20180228211621.vikbp5s3rwg47455@alap3.anarazel.de>
Permalink:  ../20180228211621.vikbp5s3rwg47455@alap3.anarazel.de/
Also on:    postgresql.org/message-id/20180228211621.vikbp5s3rwg47455@alap3.anarazel.de

 · 

reply
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-admin@postgresql.org
  Cc: andres@anarazel.de, alexandre@vmfarms.com, alvherre@alvh.no-ip.org
  Subject: Re: postgresql 9.6 - cannot freeze committed xmax
  In-Reply-To: <20180228211621.vikbp5s3rwg47455@alap3.anarazel.de>

* 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