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 1uclEQ-00GnBP-20 for pgsql-general@arkaria.postgresql.org; Fri, 18 Jul 2025 13:34:34 +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 1uclEO-00Calk-49 for pgsql-general@arkaria.postgresql.org; Fri, 18 Jul 2025 13:34:32 +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 1uclEN-00Calb-PX for pgsql-general@lists.postgresql.org; Fri, 18 Jul 2025 13:34:32 +0000 Received: from mail-wr1-x432.google.com ([2a00:1450:4864:20::432]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uclEM-008S6i-0q for pgsql-general@lists.postgresql.org; Fri, 18 Jul 2025 13:34:32 +0000 Received: by mail-wr1-x432.google.com with SMTP id ffacd0b85a97d-3a6d1369d4eso1295581f8f.2 for ; Fri, 18 Jul 2025 06:34:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1752845669; x=1753450469; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=ZcoTP1/LB3yqcVENyLNDNJUYAAeC0PWyj9IH8IAUv0E=; b=iUMtb4/HFPj6NrkxA1lbgso6vuGYO/bE9eALegA76QNSBChKbBW/oKvJF1F0ePbRHM zVyEYv6+nHd1VzgEBiFKWjzmR+qzqRDFG6mhULw1H4fOOlNfFb+CsIrD2xq8EoCXHS9B qVDIl6h2/m7lzUOyygXCK7AaQ8SdWtRlpMn/G3i9qIRAWsE2o/Mb+Wib4DktyUW1XoYL K/7gOaVmf1DDso7O2Bek8HSNTTgRz1C4dYqn8n5n76i7cW8XyFr1n1Ddh1zaB9T8e8rl 0OrDfgpKDNS2SuroheK8yBVHCgegNn7+aRUHFj4xyjT5u8E/by+U6gAK4SmtsPirnCQ3 1NQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752845669; x=1753450469; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=ZcoTP1/LB3yqcVENyLNDNJUYAAeC0PWyj9IH8IAUv0E=; b=ZgmdWGJbebrs4iWX5xauMcYQJKZhTWewcUvCtgkO3Q5hnMCzz4G7V9Y1r02X2KukKV o4XDKcqvRpjneY83sW+t8seNvpMel6sVzkJk9t0OCAV3b4B9nu/vQII/t1vM6FTcmvhe DD8NM6ZXG80CCMPNrVudWhD16jUi6JgrKgsPZP4ep7q7SGIc5Yt8ijN9Qwhr99O9iEjh AJGmIW3VFppEXU0aL7h4ywPksa1DjDvb7OGeCICldRDt8Fgx8abWDDFdkjXqjV5gYivu nzcsMVm1zyNj1FQcN00jZNOwj5/aYVx8ZpZOk+YnhkfwBppNxTan3BUz9esU9KAq/n+u A/Jg== X-Forwarded-Encrypted: i=1; AJvYcCUYtESt/wRuH7cdYtcCKtvuGHj7KkaVIfvIfdeikNPNtmPhTCzjacpOs1WQDXDHUBahvIRMIplptvDKu3Wf@lists.postgresql.org X-Gm-Message-State: AOJu0YydDfQ7Mk9RcML3i/cGV2jwWsla+mI3eVGONdFHTqZNV2w2qIcY FXBk0rhniJ0E7JiL/vOvcDujPqwAC/WCS50w8djJAJ4irIyHfjLQjJ5OpeMdm3MpY9c= X-Gm-Gg: ASbGncvxuVJSBCE7traCb7yIouBi2oddSEXou1/nPDZ+5tsfmm4qU0vqR5phTxRZn9w Bp605ZLqT+t8Ry1YrtJjp4Tg7OffXtt9xPb/F4tQKiSyiqPq0/zGGBcej+Vjdhl0+hyVhy9HOV1 7GJyACh+gefMpMBUr9xGqTchhfO/ynGqHYDRuja/y5IeH6aeliQfSGfYN/HXD/FE+hByYQRHLAl b2mN+fQgxPLPjEUy7rt6L258B7GaFMT//IQp7Vk4oGE0pZhXgAxFJoHGgodsaqteH+guprutKIF uCMwSvCXktDQ798vfmlN1Lgf12FrAwBrvaONcsYzkma4+KdEgGnmR88bv/PEoSmLl623Gx/Wc1d YD7F9v9noGMFYhbVM20qnDvuc5ytFPLWEQRvPdMz6sj4P/sBFDG7VwturSQMNPw== X-Google-Smtp-Source: AGHT+IGYDV3Emoq1vCoI9jlD7x+kM345uidFtDFXnBkQQXiPPQnuQ4YviLyFzaJp1jjsA0uWkGvcww== X-Received: by 2002:a05:6000:2008:b0:3a4:df80:7284 with SMTP id ffacd0b85a97d-3b60dd652c7mr9541727f8f.1.1752845669069; Fri, 18 Jul 2025 06:34:29 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:5e:3808:4fde:3dab:9616:28c7]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3b61ca487fdsm1854915f8f.48.2025.07.18.06.34.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 18 Jul 2025 06:34:28 -0700 (PDT) Message-ID: Subject: Re: PgBouncer Prepared Statement ERROR From: Laurenz Albe To: KK CHN , pgsql-general@lists.postgresql.org Date: Fri, 18 Jul 2025 15:34:28 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-07-18 at 18:22 +0530, KK CHN wrote: > I am getting error when using=C2=A0 PgBouncer(1.23.1 ) with=C2=A0 Postgre= s 16=C2=A0 (RedHAT 9.4) >=20 > 2025-07-18 00:00:00 IST ERROR: =C2=A0prepared statement "S_243" does not = exist > 2025-07-18 00:00:03 IST ERROR: =C2=A0prepared statement "S_205" does not = exist > 2025-07-18 00:00:03 IST ERROR: =C2=A0prepared statement "S_206" does not = exist > 2025-07-18 00:00:03 IST ERROR: =C2=A0prepared statement "S_207" does not = exist >=20 > How to avoid these prepared statement Errors ?=C2=A0 Use a recent version of pgBouncer and set "max_prepared_statements" high enough. Yours, Laurenz Albe