MIME-Version: 1.0
From: SOzcn <selahattinozcnma@gmail.com>
Date: Wed, 20 Aug 2025 10:40:22 +0300
Message-ID: 
 <CAJyV5AaBZy=b=HzjnW-KiTj2_kvt5R0LW7-Cum5W_nYDwhqTzA@mail.gmail.com>
Subject: PostgreSQL - HA Cluster / Etcd Issue
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e0fd0c063cc71653"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJyV5AaBZy%3Db%3DHzjnW-KiTj2_kvt5R0LW7-Cum5W_nYDwhqTzA%40mail.gmail.com>
Precedence: bulk

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

Hello,

In my database architecture, I use Etcd, Patroni, HAProxy, and Keepalived.

Although many things in this architecture work as expected, Etcd encounters
the error "memberID:5960773920904691185 alarm:NOSPACE" once every 2 or 3
months. The root cause is that the database size reaches the specified
limit and Etcd does not clean it up through rotation. I am aware of this,
but despite reviewing the maintenance documentation, I could not find the
most appropriate parameter values for this rotation. I am sharing an
example of my own Etcd configuration below. I kindly ask you to share your
experience on this matter. I am kinda stuck on this issue.

In particular, is it possible to schedule the parameter that performs this
cleanup with a time setting? For example, can I tell it to run the compact
operation at around 01:00 AM?

Best regards.


[Unit]
Description=etcd service
Documentation=https://github.com/etcd-io/etcd
After=network.target

[Service]
User=etcd
Type=notify
ExecStart=/usr/local/sbin/etcd \
  --name etcd1 \
  --data-dir=/etc/etcd \
  --initial-advertise-peer-urls=http://10.115.208.168:2380 \
  --listen-peer-urls=http://192.168.1.1:2380 \
  --listen-client-urls=http://192.168.1.1:2379,http://127.0.0.1:2379 \
  --advertise-client-urls=192.168.1.1:2379 \
  --initial-cluster-token="etcd-cluster" \
  --initial-cluster="etcd1=http://192.168.1.1:2380,etcd2=
http://192.168.1.2:2380,etcd3=http://3:2380" \
  --initial-cluster-state="new" \
  --log-level="error"

[Install]
WantedBy=multi-user.target

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

<div dir=3D"ltr">Hello,<br><br>In my database architecture, I use Etcd, Pat=
roni, HAProxy, and Keepalived.<br><br>Although many things in this architec=
ture work as expected, Etcd encounters the error &quot;memberID:59607739209=
04691185 alarm:NOSPACE&quot; once every 2 or 3 months. The root cause is th=
at the database size reaches the specified limit and Etcd does not clean it=
 up through rotation. I am aware of this, but despite reviewing the mainten=
ance documentation, I could not find the most appropriate parameter values =
for this rotation. I am sharing an example of my own Etcd configuration bel=
ow. I kindly ask you to share your experience on this matter. I am kinda st=
uck on this issue.<br><br>In particular, is it possible to schedule the par=
ameter that performs this cleanup with a time setting? For example, can I t=
ell it to run the compact operation at around=C2=A001:00=C2=A0AM?<div><br><=
/div><div>Best regards.</div><div><br></div><div><br></div><div>[Unit]<br>D=
escription=3Detcd service<br>Documentation=3D<a href=3D"https://github.com/=
etcd-io/etcd">https://github.com/etcd-io/etcd</a><br>After=3Dnetwork.target=
<br><br>[Service]<br>User=3Detcd<br>Type=3Dnotify<br>ExecStart=3D/usr/local=
/sbin/etcd \<br>=C2=A0 --name etcd1 \<br>=C2=A0 --data-dir=3D/etc/etcd \<br=
>=C2=A0 --initial-advertise-peer-urls=3D<a href=3D"http://10.115.208.168:23=
80">http://10.115.208.168:2380</a> \<br>=C2=A0 --listen-peer-urls=3D<a href=
=3D"http://192.168.1.1:2380">http://192.168.1.1:2380</a> \<br>=C2=A0 --list=
en-client-urls=3D<a href=3D"http://192.168.1.1:2379">http://192.168.1.1:237=
9</a>,<a href=3D"http://127.0.0.1:2379">http://127.0.0.1:2379</a> \<br>=C2=
=A0 --advertise-client-urls=3D<a href=3D"http://192.168.1.1:2379">192.168.1=
.1:2379</a> \<br>=C2=A0 --initial-cluster-token=3D&quot;etcd-cluster&quot; =
\<br>=C2=A0 --initial-cluster=3D&quot;etcd1=3D<a href=3D"http://192.168.1.1=
:2380">http://192.168.1.1:2380</a>,etcd2=3D<a href=3D"http://192.168.1.2:23=
80">http://192.168.1.2:2380</a>,etcd3=3D<a href=3D"http://3:2380">http://3:=
2380</a>&quot; \<br>=C2=A0 --initial-cluster-state=3D&quot;new&quot; \<br>=
=C2=A0 --log-level=3D&quot;error&quot;<br><br>[Install]<br>WantedBy=3Dmulti=
-user.target</div></div>

--000000000000e0fd0c063cc71653--