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 1tSLtv-00Fte7-Ji for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 19:58:08 +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 1tSLtt-00EabL-T6 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Dec 2024 19:58:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tSLtt-00EabD-Dr for pgsql-admin@lists.postgresql.org; Mon, 30 Dec 2024 19:58:05 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tSLtp-002OQb-W9 for pgsql-admin@postgresql.org; Mon, 30 Dec 2024 19:58:04 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-5f340d6db09so4093024eaf.1 for ; Mon, 30 Dec 2024 11:58:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735588680; x=1736193480; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=AXKmyu9o+DYaXO6RDKJluEYgb8rQSoFYnb2AjJ8TCOc=; b=QdtWjxwS3gA42/2fYE/E53AEfZhTckIlN/IBQgryJNk83F9ELLTkfGjSjDbOXaSxwa EV2coPGQGMy7fk2Huzr5qFklfKN9cY7sp9a8OzDbzAAkdzb+TKAjuQui8PVTWqQ+WdXA tGgBXTj6cwjj04pnQlQ7oqL5CcWmBmPwMm+pGB4XQYXgoYIzS6dryuIDOEh2jKwBjaSZ il9CxdpWvnkEQUrtveO1q8cRq5LUd4VibtK6fv7pSR3LXrGPx2ihIVT2mAst6+4W+45w wwT21B/nMnzPLWydVntS99/dPdMys/cRO7LNvhJ4O8YXo0yLViKnz8MfeuDtglklWKJl 3VNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735588680; x=1736193480; h=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=AXKmyu9o+DYaXO6RDKJluEYgb8rQSoFYnb2AjJ8TCOc=; b=PD/gSPapWIhbJ1SWyTSQEQ95QY8hTNx6KbAvECgvUOptcWcUKKLWL+asVYHAf+S/5H 5/rX3HlHT9sMLFUhgdnzkhR/0M1gG9NPv6uSBTugyo2ax1xHcQH0aOrqXyuQTG4XMBs0 DgxXXlFkloxeasy4y4chwbhsoB5C7uOVwGAPeQH4DQ2UZ5X6qTkV8zU7iW9ONT6rB6mL nlg+tv6z9QFduN5vOdpipCdP9j69txc5LK7JnDrwPlMGWzjpVN5fMX1mx1mQckIEAcTA Xsqahia4svcyNbfBjQmTBeDVafyt6IT4FaHzCpEzWXz3BpJLSO8dNvy3COwHVdkpzgzR x4Nw== X-Gm-Message-State: AOJu0YxRknIghj0TSDhehpPavuM5bFJJhLy0JQeqONYTKHnJfRn6WJID ILrTjSpF2kf5iQqidL9lyv470KCRmz4zW5cfVXeJ+IuFr2+HrmR5OPaH69Y4+K9GT5bWGlPJZXi JDgqXSDEZiXOrcs/T9gokQJnzftUUGcTY X-Gm-Gg: ASbGncs17oyGTuDVrKML1Ddmypta+MlSmrFSJUtFKrjaHNG1IHRBIlEt3UE/oXDYjNL 5wDDirJacBqOMYK0SeNOvZwVR+4IMgqUmuB3fBqg4pQP3Zp4mjXgUoeOtmoyJTWbeyR9OHH7Y X-Google-Smtp-Source: AGHT+IH/QoniMCIX/QsbVt4oD6oj4l2JhCFqBMacVfROd0xn2SAA0hcAnhJgCDwvmjfb9sPmXMtBREZh3C5l+nFtf+o= X-Received: by 2002:a05:6871:d109:b0:296:bbc8:4a82 with SMTP id 586e51a60fabf-2a7fb4d01b6mr23402788fac.27.1735588679719; Mon, 30 Dec 2024 11:57:59 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 30 Dec 2024 14:57:48 -0500 Message-ID: Subject: Re: Postgres exporter v0.14.0 Connection Leak Issue To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000bb2259062a823a8a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000bb2259062a823a8a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Have you tried reading the release notes for later releases? Have you tried opening an issue on GitHub? On Mon, Dec 30, 2024 at 1:56=E2=80=AFPM kamal deen = wrote: > Yes , this is the one but we have installed v0.14.0 > > On Mon, Dec 30, 2024, 11:44=E2=80=AFPM Ron Johnson > wrote: > >> Is this the project, or some other postgres exporter? >> https://github.com/prometheus-community/postgres_exporter >> >> On Mon, Dec 30, 2024 at 1:04=E2=80=AFPM kamal deen >> wrote: >> >>> >>> We have seen *sudden spikes* in the number of idle connections after >>> installed Postgres Exporter v0.14.0. >>> >>> >>> On Mon, Dec 30, 2024, 11:30=E2=80=AFPM Ron Johnson >>> wrote: >>> >>>> Have these spikes *suddenly started happening*, after months/years of >>>> not having lots of idle connections? >>>> OR >>>> Have you seen *sudden spikes* in the number of idle connections for as >>>> long as you've been running Postgres Exporter v0.14.0? >>>> >>>> On Mon, Dec 30, 2024 at 12:56=E2=80=AFPM kamal deen >>>> wrote: >>>> >>>>> Hi John, >>>>> >>>>> Example. >>>>> >>>>> >>>>> Out of 200 max connections , 160 idle connections consumed by postgre= s >>>>> exporter suddenly during non peak hours. There's is no specific time >>>>> pattern. >>>>> >>>>> Please let me know if need any other details. >>>>> >>>>> SK >>>>> >>>>> >>>>> On Mon, Dec 30, 2024, 11:14=E2=80=AFPM Ron Johnson >>>>> wrote: >>>>> >>>>>> On Mon, Dec 30, 2024 at 11:53=E2=80=AFAM kamal deen >>>>>> wrote: >>>>>> >>>>>>> Hi All, >>>>>>> >>>>>>> We have observed sudden connection spikes in some of our prod >>>>>>> instances >>>>>>> >>>>>> >>>>>> Define "sudden". >>>>>> >>>>>> >>>>>>> due to idle session which was created by postgres exporters. >>>>>>> >>>>>>> We have fixed this post restarted the postgres exporter services. >>>>>>> >>>>>>> Kindly share if we have any bug fixes for the same. >>>>>>> >>>>>>> >>>>>>> Thanks in advance. >>>>>>> >>>>>>> SK >>>>>>> >>>>>>> >> -- >> Death to , and butter sauce. >> Don't boil me, I'm still alive. >> lobster! >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000bb2259062a823a8a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Have you tried reading the release notes for later re= leases?
Have you tr= ied opening an issue on GitHub?

On Mon, Dec= 30, 2024 at 1:56=E2=80=AFPM kamal deen <kamaldeendba@gmail.com> wrote:
Yes , this is the o= ne but we have installed v0.14.0

On Mon, Dec 30, 2024, 11:44=E2=80=AFPM Ron Jo= hnson <ronl= johnsonjr@gmail.com> wrote:
Is this the project, o= r some other postgres exporter?

On Mon, Dec 30,= 2024 at 1:04=E2=80=AFPM kamal deen <kamaldeendba@gmail.com> = wrote:

We have seen=C2=A0sudden spik= es=C2=A0in the number of idle connections after installed Postgres Expo= rter v0.14.0.


On = Mon, Dec 30, 2024, 11:30=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmai= l.com> wrote:
Have these spikes suddenly started happening, = after months/years of not having lots of idle connections?
OR
Have you seen sudden spikes in the number of idle connections for a= s long as you've been running Postgres Exporter v0.14.0?
On Mon, D= ec 30, 2024 at 12:56=E2=80=AFPM kamal deen <kamaldeendba@= gmail.com> wrote:
Hi John,

Example.

Out of 200 max connections , 160 idle connections= consumed by postgres exporter suddenly during non peak hours. There's = is no specific time pattern.

Please let me know if need any other details.
<= br>
SK


On Mon, Dec 30, 20= 24, 11:14=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.co= m> wrote:
On Mon, Dec 30, 2024 at 11:53=E2=80=AFAM= kamal deen <kamaldeendba@gmail.com> wr= ote:
Hi All,

We have observed sudden connection spikes in some of our prod ins= tances

Define "sudden"= ;.
=C2=A0
=
due to idle session which was created = by postgres exporters.=C2=A0

We have fixed this=C2=A0 post restarted the postgres exporter services= .

Kindly share if we hav= e any bug fixes for the same.


Thanks in advance.

SK


--
Death to <Redacted>, and butter sauce.
Do= n't boil me, I'm still alive.
<Redacted> lobster= !


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--000000000000bb2259062a823a8a--