Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fuh4r-0001I0-Jl for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 16:42:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fuh4q-0000gt-24 for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 16:42:48 +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.89) (envelope-from ) id 1fuh4p-0000gl-RC for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 16:42:47 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fuh4j-0007ZM-Lo for pgsql-admin@postgresql.org; Tue, 28 Aug 2018 16:42:47 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:1470:e5c0:76e5:bff:fef3:7e00]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 420F0x0SM3z3DyB; Tue, 28 Aug 2018 18:42:41 +0200 (CEST) Date: Tue, 28 Aug 2018 18:42:40 +0200 From: Christoph Berg To: Jorge Torralba Cc: pgsql-admin@postgresql.org Subject: Re: Index corruption after pg_basebackup Message-ID: <20180828164239.GC24526@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Jorge Torralba , pgsql-admin@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Jorge Torralba 2018-08-28 > ERROR: failed to re-find parent key in index "myindex" for deletion target > page 851753 Which data type is that, and which LC_COLLATE setting is used? If it's text (or similar), there's a known incompatibility with de_DE.UTF-8 in different glibc versions. Possibly other locales and libcs are affected as well. Christoph