Re: Reviewing freeze map code
От
Masahiko Sawada
Тема
Re: Reviewing freeze map code
Дата
Msg-id
CAD21AoDQxJvqQQKOtv+7js8u2+nbF+Fh1o6UbNhTxB1K9-kavQ@mail.gmail.com
Ответ на
Re: Reviewing freeze map code (Robert Haas)
Список
Дерево обсуждения
Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Thomas Munro <thomas.munro@enterprisedb.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code "Joshua D. Drake" <jd@commandprompt.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code "Joshua D. Drake" <jd@commandprompt.com>
Re: Reviewing freeze map code Stephen Frost <sfrost@snowman.net>
Re: Reviewing freeze map code "Joshua D. Drake" <jd@commandprompt.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Tom Lane <tgl@sss.pgh.pa.us>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Tom Lane <tgl@sss.pgh.pa.us>
Re: Reviewing freeze map code Tom Lane <tgl@sss.pgh.pa.us>
Re: Reviewing freeze map code Michael Paquier <michael.paquier@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Stephen Frost <sfrost@snowman.net>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Stephen Frost <sfrost@snowman.net>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Thomas Munro <thomas.munro@enterprisedb.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Thomas Munro <thomas.munro@enterprisedb.com>
Re: Reviewing freeze map code Thomas Munro <thomas.munro@enterprisedb.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Noah Misch <noah@leadboat.com>
Re: Reviewing freeze map code Thomas Munro <thomas.munro@enterprisedb.com>
Re: Reviewing freeze map code Noah Misch <noah@leadboat.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Tom Lane <tgl@sss.pgh.pa.us>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Michael Paquier <michael.paquier@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Tom Lane <tgl@sss.pgh.pa.us>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Noah Misch <noah@leadboat.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Noah Misch <noah@leadboat.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Thomas Munro <thomas.munro@enterprisedb.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Thomas Munro <thomas.munro@enterprisedb.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Amit Kapila <amit.kapila16@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Peter Geoghegan <pg@heroku.com>
Re: Reviewing freeze map code Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Reviewing freeze map code Tom Lane <tgl@sss.pgh.pa.us>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Andres Freund <andres@anarazel.de>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Noah Misch <noah@leadboat.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Robert Haas <robertmhaas@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
Re: Reviewing freeze map code Masahiko Sawada <sawada.mshk@gmail.com>
On Sat, May 7, 2016 at 5:42 AM, Robert Haas wrote:
> On Thu, May 5, 2016 at 2:20 PM, Andres Freund wrote:
>> On 2016-05-02 14:48:18 -0700, Andres Freund wrote:
>>> 7087166 pg_upgrade: Convert old visibility map format to new format.
>>
>> +const char *
>> +rewriteVisibilityMap(const char *fromfile, const char *tofile, bool force)
>> ...
>>
>> + while ((bytesRead = read(src_fd, buffer, BLCKSZ)) == BLCKSZ)
>> + {
>> ..
>>
>> Uh, shouldn't we actually fail if we read incompletely? Rather than
>> silently ignoring the problem? Ok, this causes no corruption, but it
>> indicates that something went significantly wrong.
>
> Sure, that's reasonable.
>
Fixed.
>> + char new_vmbuf[BLCKSZ];
>> + char *new_cur = new_vmbuf;
>> + bool empty = true;
>> + bool old_lastpart;
>> +
>> + /* Copy page header in advance */
>> + memcpy(new_vmbuf, &pageheader, SizeOfPageHeaderData);
>>
>> Shouldn't we zero out new_vmbuf? Afaics we're not necessarily zeroing it
>> with old_lastpart && !empty, right?
>
> Oh, dear. That seems like a possible data corruption bug. Maybe we'd
> better fix that right away (although I don't actually have time before
> the wrap).
Since the force is always set true, I removed the force from argument
of copyFile() and rewriteVisibilityMap().
And destination file is always opened with O_RDWR, O_CREAT, O_TRUNC flags .
>> + if ((dst_fd = open(tofile, O_RDWR | O_CREAT | (force ? 0 : O_EXCL), S_IRUSR | S_IWUSR)) < 0)
>> + {
>> + close(src_fd);
>> + return getErrorText();
>> + }
>>
>> I know you guys copied this, but what's the force thing about?
>> Expecially as it's always set to true by the callers (i.e. what is the
>> parameter even about?)? Wouldn't we at least have to specify O_TRUNC in
>> the force case?
>
> I just work here.
>
>> + old_cur += BITS_PER_HEAPBLOCK_OLD;
>> + new_cur += BITS_PER_HEAPBLOCK;
>>
>> I'm not sure I'm understanding the point of the BITS_PER_HEAPBLOCK_OLD
>> stuff - as long as it's hardcoded into rewriteVisibilityMap() we'll not
>> be able to have differing ones anyway, should we decide to add a third
>> bit?
>
> I think that's just a matter of style.
So this comments is not incorporated.
Attached patch, please review it.
Regards,
--
Masahiko Sawada
В списке pgsql-hackers по дате отправления