Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uor7Q-00Bdhf-GA for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 22:17:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uor7P-00BmzY-7G for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 22:17:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uor7O-00BmzQ-Nx for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 22:17:19 +0000 Received: from mail-wm1-x32c.google.com ([2a00:1450:4864:20::32c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uor7M-000umd-2N for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 22:17:18 +0000 Received: by mail-wm1-x32c.google.com with SMTP id 5b1f17b1804b1-45a1b0bde14so1906065e9.2 for ; Wed, 20 Aug 2025 15:17:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755728235; x=1756333035; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=aSsY2yjEh3Zl7n7QRdpyc7twYYRV/sHjeiYxQ9nWRLU=; b=an/S6ANR7Fj6McjJGH1f8tbpmu/TXax0YTJwebV9YBh2ul13p0qWkayyadCcMNzqk+ zEZHyUZhTgGzZiLvL+kGfI5jUhkLEiQ/Xx8wXCaQKxWKRPJImGmic2AcChn2kuY/fXFd IL1/78iYMMxQBPh34oPaE5WBULfsn7fagODmbny9P/mzBLfkGtxG7ySxcbqLnMvwKMxJ 0kNz4wSpVkkvYgNspKBLxJacqwlP6wBtMWOMIbCzDN32vUuDxDkcgyPAhRLOiIiA94y2 JL8Ik9f8qjDUwbcEqxJ5YhwNAz323Z/5rZh3kqjeNm6+cmRiNN0hoJjlvWMRYi4r/6ly n+gg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755728235; x=1756333035; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=aSsY2yjEh3Zl7n7QRdpyc7twYYRV/sHjeiYxQ9nWRLU=; b=ihTFdn24PkJSKywbxTJjvZdYLU1NCUuVxeXmgc7LDLe2qA8Grt+7twcPpYVveH5/au U+X9FMcG54hDg5QHhyXqa2HYUvpzpSod9BZHzd2zvHsHrGI+dC1Ag99grHJ+CPvfp3DL 0LeCCr4WZqEzMBk9emRa2iTKU3S0bzudE972jbdnNiN9uP1RB1Xjz1f3AqerAmRoGN7l FiaqS9l84b4XjvfOkQK5PodZoGDC5fMJkxfk5FV5CZEuLVwBNADKM4RNpxMA+ThujvDl deiqIlQpE6S1j6RWVNlIgMYaVqeajxhMaS2duyLsFYhLxfFANbUIU5wfudVYhLSU6KHw EkLA== X-Gm-Message-State: AOJu0YzV3HJLdhnAMe7AxB41q3bnYmxGyf9PzzAHAYVYu9sjkLKE8RKD vdclUXCb7g8092oEi5vNWsViYfd5sTdq85N241OLZFo9tsWRJpLoALjtirtaOVB732I1Zt8mSDf 3SS1FBqcKhDUK4q+UL3I9KAqcO7xGByTN9Ha5w63NVA== X-Gm-Gg: ASbGncvPeh5Zb+vjtH9sCPY7x9cR4eQA0BQfMiO+pKqRK/eDNvcSteGOExBAc4onafe kZGTTjC5s4ka3BwAgduFeeJicu68HjlaJu20im+zCI8S5yEP20K1K2AHzoefT2a9sdI5B+EMQ61 /DQ859vysDM3gvDLAnmAQAqFi/3Jpff3wXkVdBnz5FNOvERInWuEa/zTrUUPwjmkVCwqLaO4UgM 9xWu8es X-Google-Smtp-Source: AGHT+IGRErz3JLDx3h73iN7kWQfos+5eOYyk5HugFIYNRj7sOd86dWjsmIh8l67D4m9CIytCNCB/goijHBVpTdM94i8= X-Received: by 2002:a05:600c:4f12:b0:459:d709:e5b0 with SMTP id 5b1f17b1804b1-45b4d7cc8b0mr1236945e9.5.1755728234764; Wed, 20 Aug 2025 15:17:14 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: SOzcn Date: Thu, 21 Aug 2025 01:17:03 +0300 X-Gm-Features: Ac12FXzoOWoA3Nj9PDZmyhYVwVwwztBEMi5obaepkOIRsnKlZxINXqQmrtC3Yu8 Message-ID: Subject: Re: PostgreSQL - HA Cluster / Etcd Issue To: Ozgur Kulu Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000c15f80063cd355e9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c15f80063cd355e9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello Ozgur, Thanks for the reply. If i up to etcd size from 2 to 8 GB it's make much problem but if defrag is fix the "no space" issue can you share your experience? By example is it spent too much rss etc. and are you doing that with cronjob or manuel. As i know if etcd went to error with "no space" defrag methot also doesn't work. Have a nice day. Ozgur Kulu , 20 A=C4=9Fu 2025 =C3=87ar, 19:51 tarihind= e =C5=9Funu yazd=C4=B1: > Hi there, > > Etcd database should be extended from 2 gb to 8gb. On the other hand, you > can use defrag or again created the etcd db. > > Have a nice day, > > 20 A=C4=9Fu 2025 =C3=87ar 10:40 tarihinde SOzcn =C5=9Funu > yazd=C4=B1: > >> Hello, >> >> In my database architecture, I use Etcd, Patroni, HAProxy, and Keepalive= d. >> >> 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 th= e >> specified limit and Etcd does not clean it up through rotation. I am awa= re >> of this, but despite reviewing the maintenance documentation, I could no= t >> find the most appropriate parameter values for this rotation. I am shari= ng >> 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=3Detcd service >> Documentation=3Dhttps://github.com/etcd-io/etcd >> After=3Dnetwork.target >> >> [Service] >> User=3Detcd >> Type=3Dnotify >> ExecStart=3D/usr/local/sbin/etcd \ >> --name etcd1 \ >> --data-dir=3D/etc/etcd \ >> --initial-advertise-peer-urls=3Dhttp://10.115.208.168:2380 \ >> --listen-peer-urls=3Dhttp://192.168.1.1:2380 \ >> --listen-client-urls=3Dhttp://192.168.1.1:2379,http://127.0.0.1:2379 \ >> --advertise-client-urls=3D192.168.1.1:2379 \ >> --initial-cluster-token=3D"etcd-cluster" \ >> --initial-cluster=3D"etcd1=3Dhttp://192.168.1.1:2380,etcd2=3D >> http://192.168.1.2:2380,etcd3=3Dhttp://3:2380" \ >> --initial-cluster-state=3D"new" \ >> --log-level=3D"error" >> >> [Install] >> WantedBy=3Dmulti-user.target >> > --000000000000c15f80063cd355e9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Ozgur,

Thanks fo= r the reply.=C2=A0

If i up to etcd size from 2 to 8 GB it's make= much problem but if defrag is fix the "no space" issue can you s= hare your experience? By example is it spent too much rss etc. and are you = doing that with cronjob or manuel. As i know if etcd went to error with &qu= ot;no space" defrag methot also doesn't work.

Have a nice d= ay.

Ozgur Kulu <kuluozgur@gmail.com>, 20 A=C4=9Fu 2025 =C3=87ar, 19:51 tarihin= de =C5=9Funu yazd=C4=B1:
Hi there,=C2=A0

Etcd database should be extended from 2 gb to 8gb. On the ot= her hand, you can use defrag or again created the etcd db.

Have a nice day,

20 A=C4=9Fu 2025 = =C3=87ar 10:40 tarihinde SOzcn <selahattinozcnma@gmail.com> =C5=9Funu yazd= =C4=B1:
Hello,

In my database architecture, I use Etcd, Patroni, HA= Proxy, and Keepalived.

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

In particular, is it possible to schedule the parameter t= hat performs this cleanup with a time setting? For example, can I tell it t= o run the compact operation at around=C2=A001:00=C2=A0AM?

Best regards.


--000000000000c15f80063cd355e9--