Re: Patron,Etcd and Confd - Mailing list pgsql-admin

From Gokan Atmaca
Subject Re: Patron,Etcd and Confd
Date
Msg-id CAHg8tEAdEKtThKL-V-8YQeogcKN8Art5mQWbZG_Zih_W_bmOiw@mail.gmail.com
Whole thread Raw
In response to Re: Patron,Etcd and Confd  (Mustafa Pekgöz | FORENDA BİLİŞİM TEKNOLOJİLERİ EĞITIM VE DANIŞMANLIK TİCARET LİMİTED ŞİRKETİ <mustafa.pekgoz@forenda.com.tr>)
List pgsql-admin
> could you please share your configuration files? the error indicate your etcd is not running correctly.

I fixed the problem. I upgraded the confd version. Etcd is working.
Because I see leader and replica. (*)
I did a failover test, it works. I'm close to the solution. I have
full faith in victory. :)


(*)
+ Cluster: pgcluster (6998861948336971735) ------+----+-----------+
| Member   | Host            | Role    | State   | TL | Lag in MB |
+----------+-----------------+---------+---------+----+-----------+
| patroni1 | 192.168.120.201 | Replica | running |  6 |         0 |
| patroni2 | 192.168.120.202 | Replica | running |  6 |         0 |
| patroni3 | 192.168.120.203 | Leader  | running |  6 |           |
+----------+-----------------+---------+---------+----+-----------+



On Mon, Aug 23, 2021 at 2:53 PM Mustafa Pekgöz | FORENDA BİLİŞİM
TEKNOLOJİLERİ EĞITIM VE DANIŞMANLIK TİCARET LİMİTED ŞİRKETİ
<mustafa.pekgoz@forenda.com.tr> wrote:
>
> Hello Gokan,
>
> could you please share your configuration files? the error indicate your etcd is not running correctly.
>
> thanks.
>
> On Mon, Aug 23, 2021 at 2:02 PM Gokan Atmaca <linux.gokan@gmail.com> wrote:
>>
>> Hello
>>
>> I am using ETCD as DCS for Patroni. (3.5.0 latest version) My Postgres
>> version is 13. Postgres and Patroni cluster are running. I can see the
>> leader and replicas. Data is synchronized. Patroni and Etcd have no
>> problem running Postgres. I am able to read key variables using
>> etcdctl. It just can't read Confd. The problem seems to be confd. I am
>> getting an error as below.
>>
>> -% Versions:
>> Etcd version: 3.5.0
>> Confd version: 0.11.0
>> Postgres 13.4
>>
>> 2021-08-22T23:09:41+03:00 ha0 confd[4350]: ERROR 501: All the given
>> peers are not reachable (failed to propose on members [404 page not
>> found] twice [last error: Get
>> 404%20page%20not%20found/v2/keys/obcluster?quorum=false&recursive=true&sorted=true:
>> unsupported protocol scheme ""]) [0]
>> ^C2021-08-22T23:09:41+03:00 ha0 confd[4350]: INFO Captured interrupt. Exiting...
>>
>> What could be causing the problem? Has anyone used it before?
>>
>>
>> Thanks.
>>
>>
>>
>> --
>> ⢀⣴⠾⠻⢶⣦⠀
>> ⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system
>> ⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org
>> ⠈⠳⣄⠀⠀⠀⠀
>>
>>



pgsql-admin by date:

Previous
From: Mustafa Pekgöz | FORENDA BİLİŞİM TEKNOLOJİLERİ EĞITIM VE DANIŞMANLIK TİCARET LİMİTED ŞİRKETİ
Date:
Subject: Re: Patron,Etcd and Confd
Next
From: Gokan Atmaca
Date:
Subject: PgBackrest