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 02:49:56
Message-ID: 3f0b79eb0902051849wf5395d0m7a5b815cca4d5f2b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Niranjan,

On Thu, Feb 5, 2009 at 10:50 PM, K, Niranjan (NSN - IN/Bangalore)
<niranjan(dot)k(at)nsn(dot)com> wrote:
>> I changed the code to dump all messages for replication, so
>> please try it and report the result. The messages which the
>> standby server receives are logged in the file (*1). Please
>> send also that file.
>>
>> (*1) <installation_directory>/sbydata/walreceiver_trace.out
>
> Refer attachments.

Thanks for interesting results!

According to the logs, walreceiver receives 'c' message (which is invalid
for walreceiver) though walsender doesn't send it. So, next, I should
diagnose more carefully the messages between those processes.
Please test synch-rep again and report the following information.

* server log
* walreceiver_trace.out
* netstat -nap (before and after replication crashes)
* 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 Fujii Masao 2009-02-06 03:08:11 Re: 8.4 release planning
Previous Message Euler Taveira de Oliveira 2009-02-06 02:25:47 Re: autovacuum and reloptions