MIME-Version: 1.0
References: 
 <CAFC+CByoZmvgNZbi9hZiZ_g7Vwbc5mHsjxN3cydj0sLW5RqOgA@mail.gmail.com>
 <CAM+6J9706uiLAtCXdk6Pd_L49fi7rjxvwNxb=rq5nT6Po9EOxw@mail.gmail.com>
In-Reply-To: 
 <CAM+6J9706uiLAtCXdk6Pd_L49fi7rjxvwNxb=rq5nT6Po9EOxw@mail.gmail.com>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Wed, 7 Jul 2021 14:25:09 +0530
Message-ID: 
 <CAM+6J94kdFHbFDbfXepaG7bTY6CnSwyFZMpWwuzSfLW9WD7L2Q@mail.gmail.com>
Subject: Re: Patroni configuration issue
To: Deepak tyagi <deepaktyagi454@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000baa8cc05c684b24e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAM%2B6J94kdFHbFDbfXepaG7bTY6CnSwyFZMpWwuzSfLW9WD7L2Q%40mail.gmail.com>
Precedence: bulk

--000000000000baa8cc05c684b24e
Content-Type: text/plain; charset="UTF-8"

On Tue, 6 Jul 2021 at 03:37, Vijaykumar Jain <
vijaykumarjain.github@gmail.com> wrote:

> I may be wrong in my simulation (my first time), but in that case you will
> have to describe how did you setup your cluster, did you use any reference
> etc?
> maybe that might help me understand this more.
>
>
just following up on this, I was new to etcd and installed v3.5.x and was
not sure how to list all keys etc,
turns out, I had to set ETCDCTL_API=2, and use the old version commands to
list and del key.

export ETCDCTL_API=2 # ls does not work on v3
alias ee='etcdctl --endpoints=http://127.0.0.1:2379 '

# i used default namespace and cluster name, so
postgres@db:~/patroni_demo$ ee ls  --recursive /
/service
/service/batman
/service/batman/members
/service/batman/members/postgresql0
/service/batman/members/postgresql1
/service/batman/initialize   --- this is the key we need to delete to
reinit the db
/service/batman/config
/service/batman/leader
/service/batman/optime
/service/batman/optime/leader

postgres@db:~/patroni_demo$ ee get /service/batman/initialize
6981912157875070537

# solve i am not leader, server not starting up
ee rm /service/batman/initialize
PrevNode.Value: 6981912157875070537

and then run patroni <config> again as a fresh setup, and you get your
leaders and replica just fine.

--000000000000baa8cc05c684b24e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di=
r=3D"ltr"><br></div><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Tue, 6 Jul 2021 at 03:37, Vijaykumar Jain &lt;<a href=3D"mailt=
o:vijaykumarjain.github@gmail.com">vijaykumarjain.github@gmail.com</a>&gt; =
wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr=
"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div =
dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">I may be wrong in my simulati=
on (my first time), but in that case you will have to describe how did you =
setup your cluster, did you use any reference etc?<br></div><div class=3D"g=
mail_quote"><div>maybe that might help me understand this more.</div><div><=
br></div></div></div></div></div></div></div></div></div></div></div></div>=
</div></blockquote></div><div><br></div><div>just following up on this, I w=
as new to etcd and installed v3.5.x and was not sure how to list all keys e=
tc,</div><div>turns out, I had to set ETCDCTL_API=3D2, and use the old vers=
ion commands to list and del key.=C2=A0</div><div><br></div><div><div>expor=
t ETCDCTL_API=3D2 # ls does not work on v3</div><div>alias ee=3D&#39;etcdct=
l --endpoints=3D<a href=3D"http://127.0.0.1:2379">http://127.0.0.1:2379</a>=
 &#39;</div><div><br></div><div># i used default namespace and cluster name=
, so</div><div>postgres@db:~/patroni_demo$=C2=A0ee ls=C2=A0 --recursive /</=
div><div>/service</div><div>/service/batman</div><div>/service/batman/membe=
rs</div><div>/service/batman/members/postgresql0</div><div>/service/batman/=
members/postgresql1</div><div>/service/batman/initialize=C2=A0 =C2=A0--- th=
is is the key we need to delete to reinit the db</div><div>/service/batman/=
config</div><div>/service/batman/leader</div><div>/service/batman/optime</d=
iv><div>/service/batman/optime/leader</div><div><br></div><div>postgres@db:=
~/patroni_demo$ ee get /service/batman/initialize<br></div><div>69819121578=
75070537</div><div><br></div><div># solve i am not leader, server not start=
ing up</div><div>ee rm /service/batman/initialize</div><div>PrevNode.Value:=
 6981912157875070537</div></div><div><br></div><div>and then run patroni &l=
t;config&gt; again as a fresh setup, and you get your leaders and replica j=
ust fine.</div><div><br></div><div><br></div></div></div></div></div>

--000000000000baa8cc05c684b24e--