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 ) id 1gmOZQ-0008Ux-Sp for pgsql-performance@arkaria.postgresql.org; Wed, 23 Jan 2019 19:52:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmOYR-0005UR-Cr for pgsql-performance@arkaria.postgresql.org; Wed, 23 Jan 2019 19:51:19 +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 ) id 1gmOYR-0005UK-5S for pgsql-performance@lists.postgresql.org; Wed, 23 Jan 2019 19:51:19 +0000 Received: from resqmta-ch2-12v.sys.comcast.net ([2001:558:fe21:29:69:252:207:44]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmOYN-000785-PF for pgsql-performance@lists.postgresql.org; Wed, 23 Jan 2019 19:51:18 +0000 Received: from resomta-ch2-09v.sys.comcast.net ([69.252.207.105]) by resqmta-ch2-12v.sys.comcast.net with ESMTP id mOR6gecuM5AkPmOYIgMVTW; Wed, 23 Jan 2019 19:51:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20161114; t=1548273070; bh=0BtiPHj63KOiOJcmUp1A7ZqCjuHmw/GmDoY6abA67eM=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=Pky0oerd/d/7vY19vap0STbHagxDJKW5cOHzHfpovchOT8ReMgu/9CdnZwc4XiiO5 rM47NQ1thsBBeqcPRc75NeJ4gY5LB1F5c+FXYuF9FY7C0nNZWQDwDiS+w3rdsrjGGd tiX48Kq9ppxkjT0ITlGnZKElHPbkTYVa/HkCAMXB/iD8XXHEcgCUY4E1NJ2qLkRJ/P D/tsjDWZHDDvUvNDeHMsWfJsfvOCxrCyDfIQGV2ZBjgmi3ojVv81o/nD1j3Y+Xxu3u xxzWMho4o7yhj++zQEfpAdbvpGQMQqcmWOSrtHIAtxSv5XWAoIYLHDJ9ShlroS5bg0 TMmpQKnYdBF+A== Received: from jsievers.comcast.net ([12.187.116.132]) by resomta-ch2-09v.sys.comcast.net with ESMTPA id mOY9gOWJC9uakmOY9g73Vw; Wed, 23 Jan 2019 19:51:07 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgedtledriedtgddufeduucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuvehomhgtrghsthdqtfgvshhipdfqfgfvpdfpqffurfetoffkrfenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurhephffvufhfffgjkfgfgggtgfesthhqredttderjeenucfhrhhomheplfgvrhhrhicuufhivghvvghrshcuoehgshhivghvvghrshduleestghomhgtrghsthdrnhgvtheqnecukfhppeduvddrudekjedrudduiedrudefvdenucfrrghrrghmpehhvghlohepjhhsihgvvhgvrhhsrdgtohhmtggrshhtrdhnvghtpdhinhgvthepuddvrddukeejrdduudeirddufedvpdhmrghilhhfrhhomhepghhsihgvvhgvrhhsudelsegtohhmtggrshhtrdhnvghtpdhrtghpthhtohepmhgrrhhivghlrdgthhgvrhhkrghsshhkhiesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhpvghrfhhorhhmrghntggvsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedt X-Xfinity-VMeta: sc=-100;st=legit Received: from jsievers.enova.com (localhost [127.0.0.1]) by jsievers.comcast.net (Postfix) with ESMTP id 1EB74260056; Wed, 23 Jan 2019 13:42:49 -0600 (CST) From: Jerry Sievers To: Mariel Cherkassky Cc: pgsql-performance@lists.postgresql.org Subject: Re: ERROR: found xmin from before relfrozenxid References: Date: Wed, 23 Jan 2019 13:42:49 -0600 In-Reply-To: (Mariel Cherkassky's message of "Wed, 23 Jan 2019 17:25:33 +0200") Message-ID: <87k1ivupmu.fsf@jsievers.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Mariel Cherkassky writes: > Hey, > I'm trying to help a guy that is using pg9.6 but I'm not so familiar > with the error message :=C2=A0 > ERROR:=C2=A0 found xmin 16804535 from before relfrozenxid 90126924 > CONTEXT:=C2=A0 automatic vacuum of table db1.public.table_1" 9.6.?... That error or a very similar one was fixed in a recent point release. HTH --=20 Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net