Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1golwc-0004Lf-Vm
	for pgsql-performance@arkaria.postgresql.org; Wed, 30 Jan 2019 09:14:07 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1golwb-0005zs-Gv
	for pgsql-performance@arkaria.postgresql.org; Wed, 30 Jan 2019 09:14:05 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1golwb-0005zl-8s
	for pgsql-performance@lists.postgresql.org; Wed, 30 Jan 2019 09:14:05 +0000
Received: from mail-ed1-x541.google.com ([2a00:1450:4864:20::541])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1golwY-0007uY-Qt
	for pgsql-performance@lists.postgresql.org; Wed, 30 Jan 2019 09:14:04 +0000
Received: by mail-ed1-x541.google.com with SMTP id a20so18356640edc.8
        for <pgsql-performance@lists.postgresql.org>;
 Wed, 30 Jan 2019 01:14:02 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=cmrjUik3T2Z3kaXyEWWwpoTBJtZWJB6hRltNBapAO5M=;
        b=YXeExVGv8ofMrTSizzT///STNJVOBIYMN5E1t6ROuJMOWO02ByCIUzEg5jBUycLcID
         msAak93TC7RrAdjzOTMBhlQXRmtkPlc6qZyP6k+TfCr3nHllzBNSn1UBbqasPvQv4YUU
         V5spuEZg3vouuDySXZGn6dK9MFLzG4pXpNuPoLQnF7f746bS0Czp6mKZ/mtLg1+0Iuhl
         X350IBCB66o5Mbi7KXRB6v9B80dvfKyJoymc2wTl1nBfW/0XrRGE89qkBxJjkFV9wVop
         24DEugzfIzOEO0UI2WTnaUsMykeHeU3lE0JIepN23NYa6SalD0hijIiP3Xx6wN0DoZkU
         SfWg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=cmrjUik3T2Z3kaXyEWWwpoTBJtZWJB6hRltNBapAO5M=;
        b=l7KvmPVKfoFXvRZeMDykgj/uXHsOruAiLoqtwn5Z+sWzBC/YiLdKKYG85B1Uwby8CD
         xyuuUTcPTx8YM3YyTp5hPgEk20wB/DEF3wHwYXbCZPb94+nfX2MIMyZTe1Vagsbvp1he
         QQ21NmVw04XZgcBkaIYsepivVOyEel+zBMkJGKhgbYfLcEfV7W71luGQQc0lqt2r42fi
         +TvudHiz0B7gMZam35pq7Ico2fzmp+hCenBs+DKE17Ydnpxrx1qdJC5XmlWd27eNB9yr
         WQ1k54v6Or0yaLl3tiOuqcYcaT4YJ0dBZaYRWl4Z1BelHGlThkTvZuRRsG9+tnjNob9j
         ypVQ==
X-Gm-Message-State: AJcUukf7r1vc6ztrCyTJ2PNeYTnIW/QQN7748kbM/hhga5JYdzpbhSKH
	CmaBfCHIngnwjnMPJBbJ6eiFFg==
X-Google-Smtp-Source: 
 ALg8bN6C7DTh4IgqvCx0fugnIacLx29S7hSYu2G4DgGrGU+d5BCRscpOlfBIJXlqJ8EnEdezgBEA1g==
X-Received: by 2002:a50:898f:: with SMTP id
 g15mr27757477edg.257.1548839641392;
        Wed, 30 Jan 2019 01:14:01 -0800 (PST)
Received: from alvin.alvh.no-ip.org ([212.76.254.98])
        by smtp.gmail.com with ESMTPSA id
 x58sm366620edm.10.2019.01.30.01.14.00
        (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256);
        Wed, 30 Jan 2019 01:14:00 -0800 (PST)
Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000)
	id EEB5A497; Wed, 30 Jan 2019 06:13:59 -0300 (-03)
Date: Wed, 30 Jan 2019 06:13:59 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Adrien NAYRAT <adrien.nayrat@anayrat.info>,
	pgsql-performance@lists.postgresql.org
Subject: Re: ERROR: found xmin from before relfrozenxid
Message-ID: <201901300913.qvob2dylsw2n@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CA+t6e1nh2LaAytEuMUc9Jj4RXipOi0Yw6J4VGm+pYCYbkbTQ0g@mail.gmail.com>
User-Agent: NeoMutt/20180716-1013-2c1e88
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

On 2019-Jan-30, Mariel Cherkassky wrote:

> It seems that the version of the db is 9.6.10 :
> 
> psql -U db -d db -c "select version()";
> Password for user db:
> version
> -----------------------------------------------------------------------------------------------------------
> PostgreSQL 9.6.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7
> 20120313 (Red Hat 4.4.7-23), 64-bit
> (1 row)
> 
> 
> and the error is still exist..

Did you apply the suggested SELECT .. FOR UPDATE to the problem table?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services