| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Greg Stark <stark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Freeze avoidance of very large table. |
| Date: | 2015-11-18 20:54:14 |
| Message-ID: | CAMkU=1w5wSX2J83ufEczqJ=d+19gXXQ_SAcgoOf3zgvzarehXg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Nov 18, 2015 at 11:18 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
> I get an error when running pg_upgrade from 9.4 to 9.6-this
>
> error while copying relation "mediawiki.archive"
> ("/tmp/data/base/16414/21043_vm" to
> "/tmp/data_fm/base/16400/21043_vm"): No such file or directory
OK, so the problem seems to be that rewriteVisibilitymap can get
called with errno already set to a nonzero value.
It never clears it, and then fails at the end despite that no error
has actually occurred.
Just setting it to 0 at the top of the function seems to be correct
thing to do. Or does it need to save the old value and restore it?
But now when I want to do the upgrade faster, I run into this:
"This utility cannot upgrade from PostgreSQL version from 9.5 or
before to 9.6 or later with link mode."
Is this really an acceptable a tradeoff? Surely we can arrange to
link everything else and rewrite just the _vm, which is a tiny portion
of the data directory. I don't think that -k promises to link
everything it possibly can.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2015-11-18 20:55:05 | Re: Patch: Implement failover on libpq connect level. |
| Previous Message | Robert Haas | 2015-11-18 20:29:10 | Re: Minor comment improvement to create_foreignscan_plan |