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 1uUIoN-0015Do-Bj for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Jun 2025 05:36:43 +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 1uUIoL-00HX49-Du for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Jun 2025 05:36:42 +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 1uUIoL-00HX40-4k for pgsql-bugs@lists.postgresql.org; Wed, 25 Jun 2025 05:36:41 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uUIoJ-003xYc-2e for pgsql-bugs@lists.postgresql.org; Wed, 25 Jun 2025 05:36:41 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-ad89ee255easo1117028566b.3 for ; Tue, 24 Jun 2025 22:36:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1750829798; x=1751434598; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=gVLvLEmqmxNcHH0vUzjMRCsgIP0T0GwdKy9D3mhy94I=; b=Cd1oi3C6vVsoAIGLx8ZN65eUonW/ZMZIXqJWpUaFrN3gL6lq+2j/I+jlTmw/mXXhU7 pjk7y6Ev3qygBkd3kk/MT1bs2SZP/TGNAdFpym0ix2xI5zkt69zdG+Wt9Py2l95s7S9j 0/GY4w7v7/ZjkddcVit2n927eLMV7qJdoDjMKGMG6N4S0SgWqYyf8ltAlH3BH94sJQQU cAdWltupDA7lphgxA43ZLoROXUtcoGHvNXdh1KwoqY1hk0pCugWXOhKC+9OLdlH9cl6s BiTclYGxRR5lS0A4kCklPnHRqEvrLeE+YyVgQBjmixBU1PY9CO7TgKZ9lcPCxJzCZZ1y iXSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750829798; x=1751434598; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=gVLvLEmqmxNcHH0vUzjMRCsgIP0T0GwdKy9D3mhy94I=; b=GgOBJ+Z4WXyqRHvAro/+SHXpPnKmjKUCcCO0fnqnnHJHc6ZPpdFrinBu7QA3NzvOBi rpPv+kNfwhiMtZzKHGoWBb9B1QZC8N+uhRSQuvfquVD3TYQv3iZHi3PMajE6i9msuC2+ nWIbmhjOTDT2B06COclsxvGCsKNn9EBDVR0IQCU8tBzhfNpfT/vus1gTd2868GmOBkAC z97RfqaSO+2nOtOXTlsIeIZeRTVd0VlksIy+pmZYnPPK/91U6YPoZaRjNEEQwEDmc3DZ WdAICA0lPUErR9C1Ah9JSXAVssitkyRHnfG7APZPMQelhOo38eqk8+0gSC42Zevmf0Bz EO1Q== X-Gm-Message-State: AOJu0YxlemjkmFvzog++IN9EWOwid24NCJFCsBsXL6yaMaeC7jjOdKvk 3eEZyLtb3pdobM8SIcx9IaSv3ZR7PCeVUneYxn54a/HmF45KeyF9DPd//D8GuZHbOSmRH1y11Dw /fDnb X-Gm-Gg: ASbGncvHHKLyMjOpt/VoI5GxFm30nkB/3ys2j9+Uxq5wj5AxsPgA28Yjc/Khq8s09Pu BljLjtGiy5l3et8elsKeP3X1ifReqX1KEY3bJEhbdpRf9GvuLz0pMT6xrVbAJc7hHw2XTk112OK aNWVQM3KPAzCD9o97+GpIneOCltzIypWtdKNH0XxO1iLFc/jBKdLbD9cJWr2RjhZNQKAp5ZJs0P 5A3UCYYaT/+vBQxh2HmDvEHvypjhi40k9kjjofauhIYLptjAks2yb8JopqpdnvqzHtv8BkNjr/4 n4Xdf7vKWP/k9W0D2Mm4kqfQyOu6zM1AbDB/wyMGFgVHsBrMVawgXj8+g+k/66c= X-Google-Smtp-Source: AGHT+IF92F9wJY+nOMcMaKmwXTa9JJTjOFQWXlDMGCe7RPOFs7oG0y1S3547IgpRvlZiJn33dkSmZg== X-Received: by 2002:a17:907:da4:b0:ad5:3156:2c06 with SMTP id a640c23a62f3a-ae0be9bcc02mr144602766b.28.1750829798121; Tue, 24 Jun 2025 22:36:38 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([213.208.157.35]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ae0541bc9a0sm989887566b.146.2025.06.24.22.36.37 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 24 Jun 2025 22:36:37 -0700 (PDT) Message-ID: Subject: Re: BUG #18966: Invalid SQL queries hang indefinitely until server restart From: Laurenz Albe To: Tom Lane , jeremy.spriet@gmail.com Cc: pgsql-bugs@lists.postgresql.org Date: Wed, 25 Jun 2025 07:36:35 +0200 In-Reply-To: <1152253.1750792153@sss.pgh.pa.us> References: <18966-8ca097723a0753f5@postgresql.org> <1152253.1750792153@sss.pgh.pa.us> 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 Tue, 2025-06-24 at 15:09 -0400, Tom Lane wrote: > PG Bug reporting form writes: > > I=E2=80=99m running PostgreSQL 16.9 in Docker (PostgreSQL 16.9 (Debian > > 16.9-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc 12.2.0, 64-bi= t), > > and intermittently observe that invalid SQL queries hang indefinitely > > instead of immediately returning an error. > > Valid queries continue to work normally and return results right away. >=20 > You've not provided nearly enough info to do more than > speculate, however. Yes. One speculation that occurs to me is that the control group settings of your container are such that a process that exceeds the memory quota is suspended until enough memory becomes free. Yours, Laurenz Albe