Re: streaming replication: could not receive data from client: Connection reset by peer

From: Anson Abraham <anson(dot)abraham(at)gmail(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: streaming replication: could not receive data from client: Connection reset by peer
Date: 2013-10-22 15:08:18
Message-ID: CAC9g-He6UCPS2DuBfZJ-pA=WCjExnBW_O3cS1aV=L2sywBfuDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No client connecting to the slave. It's just streamed replication for HA.
This occurs when the slave starts immediately. SSL is used. And as I
mentioned the libraries are identical on both slave and master.
Interestingly, another slave that replicates from master does not have
this issue. The one difference between the two slaves, the slave w/ the
message is a VM. But other master dbs i have w/ slaves (that are VMs) and
have no issues. So it's kind of odd, that this message occurs.

On Mon, Oct 21, 2013 at 6:50 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> Anson Abraham wrote:
> > I'm on Debian Wheezy running postgres 9.3
> >
> > both boxes are identical.
> >
> > I see in log file on slaves:
> > LOG: could not receive data from client: Connection reset by peer
>
> That looks to me like a client that is connected to the slave
> is dying.
>
> Do you have hot standby turned on?
>
> Are there any other messages on master or slave around this time?
>
> Does this message come right away whan you start the slave or only
> after a certain time?
>
> > OpenSSL is the same version on master and slaves. The libssl is also
> too.
>
> Do you use SSL for streaming replication?
>
> What connection options does the slave use to connect to the master?
>
> > I set ssl_renegotiation=0. So not sure why i'm seeing this in the logs
> on my slave environments.
> > doing research (aka googling), i see that everyone says to set
> ssl_renegotiation=0 but already done
> > that. also mentions of libssl library / OpenSSL could be different
> versions, but that's not the case
> > either.
>
> That would help if you have a renegotiation problem, i.e.
> streaming replication has a problem after a time of correct operation.
>
> Yours,
> Laurenz Albe
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-10-22 15:11:22 Re: Backup Question
Previous Message Elliot 2013-10-22 15:01:05 Re: Count of records in a row