Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cWVYE-0005f2-3Z for pgsql-admin@arkaria.postgresql.org; Wed, 25 Jan 2017 21:56:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cWVYD-0004gi-Gr for pgsql-admin@arkaria.postgresql.org; Wed, 25 Jan 2017 21:56:21 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cWV9Z-0000kN-PK for pgsql-admin@postgresql.org; Wed, 25 Jan 2017 21:30:53 +0000 Received: from mx-lv-r1.lailio.net ([178.16.28.24]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cWV9W-00031v-46 for pgsql-admin@postgresql.org; Wed, 25 Jan 2017 21:30:52 +0000 Received: from z1.cloud.zimbrazilla.net (unknown [178.16.20.83]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by mx-lv-r1.lailio.net (Postfix) with ESMTPS id 9BCDCED15D; Wed, 25 Jan 2017 23:31:55 +0200 (EET) Received: from z1.cloud.zimbrazilla.net ([127.0.0.1]) by localhost (z1.cloud.zimbrazilla.net [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id 2V_O6xLv93YF; Wed, 25 Jan 2017 23:30:47 +0200 (EET) X-Virus-Scanned: amavisd-new at cloud.zimbrazilla.net Received: from z1.cloud.zimbrazilla.net ([127.0.0.1]) by localhost (z1.cloud.zimbrazilla.net [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id PePjBhYXaRUx; Wed, 25 Jan 2017 23:30:47 +0200 (EET) Received: from z1.cloud.zimbrazilla.net (localhost [127.0.0.1]) by z1.cloud.zimbrazilla.net (Postfix) with ESMTP id 20D18620636; Wed, 25 Jan 2017 23:30:47 +0200 (EET) Date: Wed, 25 Jan 2017 23:30:47 +0200 (EET) From: Maris Jansons To: Jorge Torralba Cc: pgsql-admin Message-ID: <1715943237.23967907.1485379847032.JavaMail.zimbra@lailio.net> In-Reply-To: References: <2141896725.20994473.1485356017414.JavaMail.zimbra@lailio.net> Subject: Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_b2d6d97b-c46d-46fa-ad97-0e07e34cda33" Thread-Topic: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 Thread-Index: Kub04OtEB59SXkeSy2yEqa96B7MDuQ== X-Pg-Spam-Score: -5.1 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --=_b2d6d97b-c46d-46fa-ad97-0e07e34cda33 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hello, > A couple things you can try. > 1. reindex your toast table. > 2. write a loop that .. I already have done both, did not help, check the original message for details. Best Regards, Maris. --=_b2d6d97b-c46d-46fa-ad97-0e07e34cda33 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
Hello,
> A couple things you can try.
> 1. reindex your toast table.
> 2. write a loop that ..

I already have done both, did not help, check the original message for details.

Best Regards,
Maris.

--=_b2d6d97b-c46d-46fa-ad97-0e07e34cda33--