Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dOQS8-00062Y-MZ for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Jun 2017 15:24:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dOQS8-00042i-9F for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Jun 2017 15:24:56 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dOQQZ-00016b-If for pgsql-hackers@postgresql.org; Fri, 23 Jun 2017 15:23:19 +0000 Received: from mail-lf0-x235.google.com ([2a00:1450:4010:c07::235]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dOQQX-0003Zc-3N for pgsql-hackers@postgresql.org; Fri, 23 Jun 2017 15:23:18 +0000 Received: by mail-lf0-x235.google.com with SMTP id l13so32849889lfl.1 for ; Fri, 23 Jun 2017 08:23:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=id5pbH/Ra+6g4W3sem9qb5eGSAk/e+EXBsnM/iBft04=; b=jmnjdoXY7vmNIhnGAqS3dTuJ6snXLJagkkL+WftFWaBbmpIueP3GF38KNjF7pYGGOa AkfN1cECKpcErGc573fBcZKE4YIEIE34+Egbe7rhAAS9WgiFsTBGL0Bww+abloAFVgxI JumOr8SJqwZakZPqmIrfltAbXB9caKVAyCCsNUJxx/XPBe4f/zeQgmQ9heyTj4oAQCHy 5OpTrvWWBPLeYxlAQMjsXQRGQ8PmQAiN72IoKK7RSiuQvoDyQnAkDEbtTHleUfffxy8b X9WCj6o52sGytGT7aVCzh6yYxVwAVSLkVAzMbOymSIiDBF/lp+sX1VMV4ujFIJwbiLdz aYgw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=id5pbH/Ra+6g4W3sem9qb5eGSAk/e+EXBsnM/iBft04=; b=FH62rsdStEAnjjmvcAgDHgVjLFKO3Q9DYPk6fm/yrFyoXJJpszY7Nq0MbgcOLhi0fY PnJ48j3qP72itX0/L2H4pr8k8H1BXgLaTQ3nrHmWepJkgV64HuMStL+HlDSm00lfX6MB uaGfiakbrcbEgdI9ML37eCtY0ZZ+HP3nV/OFW2jhVidnJEpL9aJ5YLaTycf2Pg9HggJp knVaPsM34A7RdfigS7GlkhqyzHfcmRjHiSYV3VYPQVX3Dsd+0i9oTu8FSI/SJVvQrABd aiGFJTFBgsie+pMTgTTTolczdSgfwt9GKOS6fyaFOOSsA7wfygDrYPOwikQT0qzneXAV lryQ== X-Gm-Message-State: AKS2vOyu65IvSxqCNVt9x/w3fD8HyZACDLNYnAR/jqHxub9sngeFgaQn LJwFMnu2S5gUVA== X-Received: by 10.25.125.198 with SMTP id y189mr2239230lfc.79.1498231394776; Fri, 23 Jun 2017 08:23:14 -0700 (PDT) Received: from seb.koffice.internal (koffice.avito.ru. [195.151.206.25]) by smtp.gmail.com with ESMTPSA id 123sm1412577lfz.47.2017.06.23.08.23.13 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 23 Jun 2017 08:23:13 -0700 (PDT) From: Sergey Burladyan To: Bruce Momjian Cc: Amit Kapila , PostgreSQL-development , Dmitriy Sarafannikov , Vladimir Borodin Subject: Re: Broken hint bits (freeze) References: <20170619222113.GF3180@momjian.us> <20170620025919.GA28277@momjian.us> <20170620033726.GB28277@momjian.us> <87h8zb6kbx.fsf@seb.koffice.internal> <8760fq7pfe.fsf@seb.koffice.internal> <20170621163356.GB9358@momjian.us> <87lgoi68dg.fsf@seb.koffice.internal> Date: Fri, 23 Jun 2017 18:23:12 +0300 In-Reply-To: <87lgoi68dg.fsf@seb.koffice.internal> (Sergey Burladyan's message of "Fri, 23 Jun 2017 18:17:47 +0300") Message-ID: <87h8z6684f.fsf@seb.koffice.internal> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --=-=-= Content-Type: text/plain Sergey Burladyan writes: > 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. Missed test script for it. -- Sergey Burladyan --=-=-= Content-Type: application/x-sh Content-Disposition: attachment; filename=test_hash.sh Content-Transfer-Encoding: base64 IyEvYmluL2Jhc2gKCldEPSQocmVhZGxpbmsgLWYgLi90ZXN0KQojV0Q9L21u dC9tZW1vcnkKUEc5Ml9CSU49fi9pbnN0L3BnOS4yL2JpbgpQRzk0X0JJTj1+ L2luc3QvcGc5LjQvYmluCgpleHBvcnQgTENfQUxMPUMKZXhwb3J0IFBHREFU QUJBU0U9dGVzdAoKW1sgIiRXRCIgXV0gfHwgZXhpdCAxCltbIC13ICIkV0Qi ICYmIC14ICIkV0QiIF1dIHx8IGV4aXQgMQpjZCAiJFdEIiB8fCBleGl0IDEK CnRyeV9ydW4gKCkKewogICAgZXhlYyAzPiYxIDQ+JjIKICAgIGV4ZWMgPiBs b2dmaWxlIDI+JjEKCiAgICBlY2hvICJpbml0IiA+JjQKCiAgICBta2RpciBt IHMgdwoKICAgICIkUEc5Ml9CSU4iL2luaXRkYiAtQSB0cnVzdCAtRSBVVEYt OCAtLWxvY2FsZT1DIG0vOS4yIHx8IGV4aXQgMQogICAgIiRQRzk0X0JJTiIv aW5pdGRiIC1BIHRydXN0IC1FIFVURi04IC0tbG9jYWxlPUMgbS85LjQgfHwg ZXhpdCAxCgogICAgY2F0IDw8RU9GID4gbS85LjIvcG9zdGdyZXNxbC5jb25m CnBvcnQgPSA1NDMwCnNoYXJlZF9idWZmZXJzID0gMzJNQgp3YWxfbGV2ZWwg PSBob3Rfc3RhbmRieQphcmNoaXZlX21vZGUgPSBvbgphcmNoaXZlX2NvbW1h bmQgPSAndGVzdCAhIC1mICIkV0Qvdy8lZiIgJiYgY3AgJXAgIiRXRC93LyVm IicKbWF4X3dhbF9zZW5kZXJzID0gNQpob3Rfc3RhbmRieSA9IG9uCmxvZ19s aW5lX3ByZWZpeCA9ICcldCAnCmxvZ19jaGVja3BvaW50cyA9IG9uCmxjX21l c3NhZ2VzID0gQwphdXRvdmFjdXVtID0gb2ZmCmxvZ19taW5fbWVzc2FnZXMg PSBkZWJ1ZzIKRU9GCiAgICBjYXQgPDxFT0YgPj4gbS85LjIvcGdfaGJhLmNv bmYKbG9jYWwgICByZXBsaWNhdGlvbiAgICAgYWxsICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICB0cnVzdApob3N0ICAgIHJlcGxpY2F0aW9uICAg ICBhbGwgICAgICAgIDEyNy4wLjAuMS8zMiAgICAgICAgICAgIHRydXN0Cmhv c3QgICAgcmVwbGljYXRpb24gICAgIGFsbCAgICAgICAgOjoxLzEyOCAgICAg ICAgICAgICAgICAgdHJ1c3QKRU9GCgogICAgY3AgbS85LjIvcG9zdGdyZXNx bC5jb25mIG0vOS40L3Bvc3RncmVzcWwuY29uZgogICAgY3AgbS85LjIvcGdf aGJhLmNvbmYgbS85LjQvcGdfaGJhLmNvbmYKCiAgICBlY2hvICJzdGFydCBt YXN0ZXIgOS4yIiA+JjQKCiAgICAiJFBHOTJfQklOIi9wZ19jdGwgLXcgLUQg bS85LjIgLWwgbG9nZmlsZS5tLjkyIHN0YXJ0IHx8IGV4aXQgMQoKICAgIGVj aG8gImJhc2UgYmFja3VwIiA+JjQKCiAgICAiJFBHOTJfQklOIi9wZ19iYXNl YmFja3VwIC1wIDU0MzAgLWMgZmFzdCAtWCBzdHJlYW0gLUQgcy85LjIvIHx8 IGV4aXQgMQogICAgY2F0IDw8RU9GID4+IHMvOS4yL3Bvc3RncmVzcWwuY29u Zgpwb3J0ID0gNTQzMQpFT0YKICAgIGNhdCA8PEVPRiA+IHJlY292ZXJ5LmNv bmYKcmVzdG9yZV9jb21tYW5kID0gJ2NwICIkV0Qvdy8lZiIgJXAnCnN0YW5k YnlfbW9kZSA9IG9uCkVPRgogICAgY3Agcy85LjIvcG9zdGdyZXNxbC5jb25m IHNiX3Bvc3RncmVzcWwuY29uZgogICAgY3AgcmVjb3ZlcnkuY29uZiBzLzku Mi9yZWNvdmVyeS5jb25mCgogICAgZWNobyAic3RhcnQgc3RhbmRieSA5LjIi ID4mNAoKICAgICIkUEc5Ml9CSU4iL3BnX2N0bCAtdyAtRCBzLzkuMiAtbCBs b2dmaWxlLnMuOTIgc3RhcnQgfHwgZXhpdCAxCgogICAgIwogICAgIiRQRzky X0JJTiIvcHNxbCAtWCAtcSAtcCA1NDMwIC1kIHBvc3RncmVzIC1jICdjcmVh dGUgZGF0YWJhc2UgdGVzdCcgfHwgZXhpdCAxCiAgICAiJFBHOTJfQklOIi9w c3FsIC1YIC1xIC1wIDU0MzAgLWYtIDw8RU9GIHx8IGV4aXQgMQpjcmVhdGUg dW5sb2dnZWQgdGFibGUgdGVzdCAoaWQgaW50IHByaW1hcnkga2V5LCB2IHRl eHQpOwpjcmVhdGUgaW5kZXggb24gdGVzdCB1c2luZyBoYXNoIChpZCk7Cmlu c2VydCBpbnRvIHRlc3Qgc2VsZWN0IG4sICd0aGlzIGlzIGxvbmcgbGluZSBm b3IgZmlsbCB0YWJsZSwgbGluZSBudW1iZXIgJyB8fCBuIGZyb20gZ2VuZXJh dGVfc2VyaWVzKDEsIDEwMDAwMDApIG47CkVPRgoKICAgIGxzbj0kKCIkUEc5 Ml9CSU4iL3BzcWwgLVggLUF0IC1xIC1wIDU0MzAgLWMgJ3NlbGVjdCBwZ19j dXJyZW50X3hsb2dfaW5zZXJ0X2xvY2F0aW9uKCknKSB8fCBleGl0IDEKCiAg ICBlY2hvICJzdG9wIG1hc3RlciA5LjIiID4mNAoKICAgICIkUEc5Ml9CSU4i L3BnX2N0bCAtdyAtRCBtLzkuMiBzdG9wIHx8IGV4aXQgMQoKICAgIGVjaG8g IndhaXQgZm9yIHN0YW5kYnkgY2F0Y2ggdXAgbWFzdGVyOiAkbHNuIiA+JjQK ICAgIGRpZmY9LTEKICAgIHdoaWxlIFtbICIkZGlmZiIgLWx0IDAgXV07IGRv CiAgICAgICAgc2xlZXAgMTsKICAgICAgICBkaWZmPSQoIiRQRzkyX0JJTiIv cHNxbCAtWCAtQXQgLXEgLXAgNTQzMSAtYyAic2VsZWN0IHBnX3hsb2dfbG9j YXRpb25fZGlmZihwZ19sYXN0X3hsb2dfcmVwbGF5X2xvY2F0aW9uKCksICck bHNuJykiKQogICAgICAgIGVjaG8gImRpZmY6ICRkaWZmIiA+JjQKICAgIGRv bmUKCiAgICBlY2hvICJwcm9tb3RlIHN0YW5kYnkgOS4yIiA+JjQKICAgICIk UEc5Ml9CSU4iL3BnX2N0bCAtdyAtRCBzLzkuMiBwcm9tb3RlIHx8IGV4aXQg MQoKICAgIGVjaG8gIndhaXQgZm9yIHByb21vdGlvbiIgPiY0CiAgICBwcm9t b3RlZD0nJwogICAgd2hpbGUgW1sgISAkcHJvbW90ZWQgXV07IGRvCiAgICAg ICAgc2xlZXAgMTsKICAgICAgICBwcm9tb3RlZD0kKCIkUEc5Ml9CSU4iL3Bz cWwgLVggLUF0IC1xIC1wIDU0MzEgLWMgInNlbGVjdCBudWxsaWYocGdfaXNf aW5fcmVjb3ZlcnkoKSwgdHJ1ZSkiKQogICAgICAgIGVjaG8gInByb21vdGVk OiAkcHJvbW90ZWQiID4mNAogICAgZG9uZQoKICAgIGVjaG8gInN0b3AgcHJv bW90ZWQgbmV3IG1hc3RlciA5LjIiID4mNAoKICAgICIkUEc5Ml9CSU4iL3Bn X2N0bCAtdyAtRCBzLzkuMiBzdG9wIHx8IGV4aXQgMQoKICAgICIkUEc5Ml9C SU4iL3BnX2NvbnRyb2xkYXRhIHMvOS4yLwoKICAgICMgdXBncmFkZQoKICAg IGVjaG8gInJ1biB1cGdyYWRlIiA+JjQKCiAgICAiJFBHOTRfQklOIi9wZ191 cGdyYWRlIC1iICIkUEc5Ml9CSU4iIC1CICIkUEc5NF9CSU4iIC1kIHMvOS4y IC1EIG0vOS40IC1rIC1jIHx8IGV4aXQgMQoKICAgICIkUEc5NF9CSU4iL3Bn X3VwZ3JhZGUgLWIgIiRQRzkyX0JJTiIgLUIgIiRQRzk0X0JJTiIgLWQgcy85 LjIgLUQgbS85LjQgLWsgfHwgZXhpdCAxCgogICAgZWNobyAicmVzZXQgd2Fs X2xldmVsIiA+JjQKICAgICIkUEc5NF9CSU4iL3BnX2N0bCAtdyAtRCBtLzku NCAtbCBsb2dmaWxlLm0uOTQgc3RhcnQgfHwgZXhpdCAxCiAgICAiJFBHOTRf QklOIi9wZ19jdGwgLXcgLUQgbS85LjQgc3RvcCB8fCBleGl0IDEKCiAgICBw cyBheHUgfCBncmVwIHBvc3RncmVzCgogICAgZXhlYyAxPiYzIDI+JjQKfQoK cm0gLXIgbSBzIHcgbG9nZmlsZS4qIGNvbnRyb2xkYXRhLiogYW5hbHl6ZV9u ZXdfY2x1c3Rlci5zaCBkZWxldGVfb2xkX2NsdXN0ZXIuc2ggcmVjb3Zlcnku Y29uZiByc3luYy5sb2cgbG9nZmlsZSBzYl9wb3N0Z3Jlc3FsLmNvbmYKCnRy eV9ydW4gfHwgZXhpdCAxCg== --=-=-= Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --=-=-=--