Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hawq.incubator.apache.org
MIME-Version: 1.0
In-Reply-To: <CAHVwNMi25XCF7YzXqeg6G1oqRfAHy5csyAxx4ZUJkLzrUfJtzA@mail.gmail.com>
References: <CAHVwNMi25XCF7YzXqeg6G1oqRfAHy5csyAxx4ZUJkLzrUfJtzA@mail.gmail.com>
From: Lei Chang <chang.lei.cn@gmail.com>
Date: Tue, 14 Nov 2017 08:32:57 +0800
Message-ID: <CAE44UQcWX33ik89hv1jWRKB_kpZrv3Qtpy9n6c-fs417uZTD4Q@mail.gmail.com>
Subject: Re: Hawq standby sync fails if there are existing connections to master
To: dev <dev@hawq.incubator.apache.org>
Content-Type: multipart/alternative; boundary="94eb2c19dbf25b2c3a055de68722"
archived-at: Tue, 14 Nov 2017 00:33:14 -0000

--94eb2c19dbf25b2c3a055de68722
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Shubham,

The behavior is intentional. If there are connections when HAWQ init
standby, it is better to warn the client instead of cutting the connections
brutally.

Cheers
Lei


On Mon, Nov 13, 2017 at 11:58 AM, Shubham Sharma <ssharma@pivotal.io> wrote=
:

> Hello folks,
>
> Recently observed a behaviour while re-syncing standby from hawq command
> line.
>
> Here are the reproduction steps -
>
> 1 - Open a client connection to hawq using psql
> 2 - From a different terminal run command - hawq init standby -n -v -M fa=
st
> 3 - Standby resync fails with error
>
>
> 20171113:03:49:21:158354 hawq_stop:hdp3:gpadmin-[WARNING]:-There are
> other connections to this instance, shutdown mode smart aborted
>
> 20171113:03:49:21:158354 hawq_stop:hdp3:gpadmin-[WARNING]:-Either
> remove connections, or use 'hawq stop master -M fast' or 'hawq stop
> master -M immediate'
>
> 20171113:03:49:21:158354 hawq_stop:hdp3:gpadmin-[WARNING]:-See hawq
> stop --help for all options
>
> 20171113:03:49:21:158354 hawq_stop:hdp3:gpadmin-[ERROR]:-Active
> connections. Aborting shutdown...
>
> 20171113:03:49:21:158143 hawq_init:hdp3:gpadmin-[ERROR]:-Stop hawq
> cluster failed, exit
>
> 4 - My understanding is when -M (stop mode) is passed it should terminate
> existing client connections. Also, it seems like a good practice to
> terminate client connections before standby master resync.
>
> Is this an expected behavior in hawq ? If not, I can open a JIRA and work
> on a pull request to fix this.
>
> Looking forward to your thoughts on this.
> =E2=80=8B
> --
> Regards,
> Shubham Sharma
>

--94eb2c19dbf25b2c3a055de68722--