From:
Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
To:
"'Boszormenyi Zoltan'" <zb(at)cybertec(dot)at>
Cc:
"'Fujii Masao'" <masao(dot)fujii(at)gmail(dot)com>,
"'Heikki Linnakangas'"<hlinnakangas(at)vmware(dot)com>,
<pgsql-hackers(at)postgresql(dot)org>,
"'Amit kapila'"<amit(dot)kapila(at)huawei(dot)com>
Subject:
Re: Review of "pg_basebackup and pg_receivexlog to use non-blocking socket communication", was: Re: Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown
Date:
2013-01-04 12:43:08
Message-ID:
007701cdea79$0cf35b30$26da1190$@kommi@huawei.com (view raw or flat )
Thread:
2012-09-12 11:54:59 from amit(dot)kapila(at)huawei(dot)com
2012-09-12 16:41:44 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-09-13 04:00:24 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-12 16:45:05 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-13 04:22:08 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-13 17:27:52 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-14 13:01:37 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-15 05:57:12 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-15 07:26:05 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-15 18:44:19 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-16 06:10:43 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-17 07:03:28 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-18 12:32:43 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-18 12:50:33 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-21 11:18:01 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-01 10:38:49 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-01 15:06:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-02 07:43:50 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-01 16:57:34 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-02 00:02:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-02 03:50:42 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-02 07:36:39 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-02 08:26:24 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-04 10:12:30 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-04 12:27:52 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-08 14:08:00 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-08 14:42:23 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-09 12:29:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-09 13:04:31 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-10 15:44:34 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-11 10:17:11 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-11 14:52:40 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-11 15:52:25 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-13 16:35:12 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-15 10:13:01 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-15 14:27:56 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-15 16:31:09 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-16 12:31:08 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-18 16:48:31 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-07 17:22:04 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-11-08 16:40:47 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-08 16:56:41 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-17 11:46:04 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-17 13:07:30 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-18 15:19:30 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-19 11:42:16 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-08 08:33:42 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-11-08 08:53:53 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-08 17:12:14 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-09 06:03:32 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-12 14:53:58 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-13 04:06:51 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-13 16:02:05 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-15 13:59:12 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-16 11:40:03 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-01 16:48:48 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-02 07:11:15 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-04 12:43:08 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-07 14:23:02 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-09 04:02:58 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-16 07:48:17 from Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com>
2013-01-16 10:31:54 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-18 06:50:58 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-18 10:15:53 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-18 11:41:36 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-18 12:05:05 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-18 13:24:54 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-19 12:19:28 from Magnus Hagander <magnus(at)hagander(dot)net>
2013-01-22 09:56:44 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-24 15:13:50 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-18 13:43:08 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-19 12:20:23 from Magnus Hagander <magnus(at)hagander(dot)net>
2013-01-19 17:05:02 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-19 17:33:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-19 20:06:37 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-20 16:45:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-21 12:51:44 from Magnus Hagander <magnus(at)hagander(dot)net>
2013-01-22 06:31:14 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-28 09:45:10 from Magnus Hagander <magnus(at)hagander(dot)net>
Lists:
pgsql-bugs pgsql-hackers
On January 02, 2013 12:41 PM Hari Babu wrote:
>On January 01, 2013 10:19 PM Boszormenyi Zoltan wrote:
>>I am reviewing your patch.
>> Is the patch in context diff format?
>>Yes.
>
>Thanks for reviewing the patch.
>
>> Does it apply cleanly to the current git master?
>>Not quite cleanly but it doesn't produce rejects or fuzz, only offset
warnings:
>
>Will rebase the patch to head.
>
>> Does it include reasonable tests, necessary doc patches, etc?
>>The test cases are not applicable. There is no test framework for
>>testing network outage in "make check".
>>
>>There are no documentation patches for the new --recvtimeout=INTERVAL
>>and --conntimeout=INTERVAL options for either pg_basebackup or
>>pg_receivexlog.
>
>I will add the documentation for the same.
>
>>Per the previous comment, no. But those are for the backend
>>to notice network breakdowns and as such, they need a
>>separate patch.
>
>I also think it is better to handle it as a separate patch for walsender.
>
>> Are the comments sufficient and accurate?
>>This chunk below removes a comment which seems obvious enough
>>so it's not needed:
>>***************
>>*** 518,524 **** ReceiveXlogStream(PGconn *conn, XLogRecPtr startpos,
uint32 timeline,
>> goto error;
>> }
>>
>>! /* Check the message type. */
>> if (copybuf[0] == 'k')
>> {
>> int pos;
>>--- 559,568 ----
>> goto error;
>> }
>>
>>! /* Set the last reply timestamp */
>>! last_recv_timestamp = localGetCurrentTimestamp();
>>! ping_sent = false;
>>!
>> if (copybuf[0] == 'k')
>> {
>> int pos;
>>***************
>>
>>Other comments are sufficient and accurate.
>
>I will fix and update the patch.
The attached V2 patch in the mail handles all the review comments identified
above.
Regards,
Hari babu.
In response to
Responses
pgsql-hackers by date
Next :From: Amit KapilaDate: 2013-01-04 13:53:58
Subject : Re: Performance Improvement by reducing WAL for Update Operation
Previous :From : Samuel VogelDate : 2013-01-04 12:00:21
Subject : Re: Print b-tree tuples
pgsql-bugs by date
Next :From: dagDate: 2013-01-04 14:06:51
Subject : BUG #7785: Bad plan for UNION ALL view containing JOIN
Previous :From : Dave PageDate : 2013-01-04 11:39:36
Subject : Re: BUG #7781: pgagent incorrect installation