Re: Synch Replication

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: "K, Niranjan (NSN - IN/Bangalore)" <niranjan(dot)k(at)nsn(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Synch Replication
Date: 2009-02-06 08:40:22
Message-ID: 3f0b79eb0902060040r13865421s89354ff0b254dd06@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Fri, Feb 6, 2009 at 2:14 PM, K, Niranjan (NSN - IN/Bangalore)
<niranjan(dot)k(at)nsn(dot)com> wrote:
> Hi,
>
>> * server log
>> * walreceiver_trace.out
>> * netstat -nap (before and after replication crashes)
>> * tcpdump -i lo -n tcp
>>
> In addition to the requested logs, I have provided the network interface
> information.

Your tcpdump.log shows that walsender doesn't send any invalid messages,
but walreceiver seems to receive it. So, I suspect libpq functions which
walreceiver uses as the cause of the trouble. I changed synch-rep to dump
all the behaviors of those libpq functions.

http://senduit.com/42da75

Please retry new synch-rep code and report the following information.

* server log
* <installation_directory>/sbydata/walreceiver_trace.out
* tcpdump -i lo -n tcp

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message K, Niranjan (NSN - IN/Bangalore) 2009-02-06 09:46:53 Re: Synch Replication
Previous Message Simon Riggs 2009-02-06 08:17:14 Re: Hot standby, recovery infra