Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YxjPJ-0003yJ-2b for pgsql-performance@arkaria.postgresql.org; Wed, 27 May 2015 22:02:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YxjPI-00049l-2b for pgsql-performance@arkaria.postgresql.org; Wed, 27 May 2015 22:02:36 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YxjPG-00049e-Sq for pgsql-performance@postgresql.org; Wed, 27 May 2015 22:02:35 +0000 Received: from 01.zmailcloud.com ([192.198.85.104] helo=mx-out-1.zmailcloud.com) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1YxjPD-0002RK-Ud for pgsql-performance@postgresql.org; Wed, 27 May 2015 22:02:33 +0000 Received: from smtp.01.com (smtp.01.com [10.10.0.43]) by mx-out-1.zmailcloud.com (Postfix) with ESMTP id 56B48563F7F for ; Wed, 27 May 2015 17:02:31 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 3EC40A045B for ; Wed, 27 May 2015 17:02:31 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id t7bklLKpewXF for ; Wed, 27 May 2015 17:02:31 -0500 (CDT) Received: from smtp.01.com (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 0A440A0474 for ; Wed, 27 May 2015 17:02:31 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id E9337A0473 for ; Wed, 27 May 2015 17:02:30 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id aCtH5sWZkOtu for ; Wed, 27 May 2015 17:02:30 -0500 (CDT) Received: from [172.47.23.103] (50-0-190-244.dsl.dynamic.fusionbroadband.com [50.0.190.244]) by smtp-out-1.01.com (Postfix) with ESMTPSA id 9DB4DA045B for ; Wed, 27 May 2015 17:02:30 -0500 (CDT) Message-ID: <55663EF4.7030500@agliodbs.com> Date: Wed, 27 May 2015 15:02:28 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881 References: In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 05/27/2015 12:50 AM, Tory M Blue wrote: > Greetings and salutations. > > I've got some weirdness. > > Current: > Postgres 9.3.4 > Slony 2.2.3 > CentOS 6.5 > > Prior running Postgres 9.1.2 w/slony 2.1.3 CentOS 6.2 > > I found that if I tried to run a vacuum full on 1 table that I recently > reindexed (out of possibly 8 tables) that I get this error: > > # vacuum full table.ads; > > ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881 > > If I run a vacuum analyze it completes fine, but I can't run a vacuum > full without it throwing an error. I seem to be able to query the table > and I seem to be able to add data to the table and slony seems fine as > does postgres. Is this happening on the Slony master or the replica? There have been serveral bugs since 9.1.2 which could have caused this particular error. Are you certain that this is a recent problem? Note that this error affects just one compressed value or row, so you're not losing other data, unless it's a symptom of an ongoing problem. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance