Date: Wed, 28 Jun 2017 22:11:35 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Sergey Burladyan <eshkinkot@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>,
	Dmitriy Sarafannikov <dsarafannikov@yandex.ru>,
	Vladimir Borodin <root@simply.name>
Subject: Re: Broken hint bits (freeze)
Message-ID: <20170629021135.GD16576@momjian.us>
References: 
 <CAJ2ymdg=0knii-bavVLpKEGc9DanaZC+UXjnipx_n-gFvOkdcg@mail.gmail.com>
 <20170620025919.GA28277@momjian.us>
 <20170620033726.GB28277@momjian.us>
 <87h8zb6kbx.fsf@seb.koffice.internal>
 <CAA4eK1JmEAj9qUMbS-=u7b4Boqsr3mAoadevT9LDWm4JgxamBg@mail.gmail.com>
 <8760fq7pfe.fsf@seb.koffice.internal>
 <CAA4eK1JxV1+UTyU3T2WM6rhiDEZy6zk3cx+Y3TaXCXAwQxcU1Q@mail.gmail.com>
 <CAA4eK1+o6ErVAh484VtE91wow1-uOysohSvb0TS52Ei76PzOKg@mail.gmail.com>
 <20170621163356.GB9358@momjian.us>
 <87lgoi68dg.fsf@seb.koffice.internal>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <87lgoi68dg.fsf@seb.koffice.internal>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On Fri, Jun 23, 2017 at 06:17:47PM +0300, Sergey Burladyan wrote:
> PS:
> I successfully upgraded last night from 9.2 to 9.4 and find other issue :-)
> 
> It is about hash index and promote:
> 1. create master
> 2. create standby from it
> 3. create unlogged table and hash index like:
>  create unlogged table test (id int primary key, v text);
>  create index on test using hash (id);
> 3. stop master
> 4. promote standby
> 
> now, if you try to upgrade this new promoted master pg_upgrade will stop
> on this hash index:
> error while creating link for relation "public.test_id_idx" ("s/9.2/base/16384/16393" to "m/9.4/base/16422/16393"): No such file or directory
> Failure, exiting
> 
> I touch this file (s/9.2/base/16384/16393) and rerun pg_upgrade from
> scratch and it complete successfully.

Sergey, can you please test if the table "test" is not unlogged, does
pg_upgrade still fail on the hash index file?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers