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.96) (envelope-from ) id 1wVQNy-001x0R-2Y for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Jun 2026 08:58:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wVQNw-00B8wx-0K for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Jun 2026 08:58:36 +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.96) (envelope-from ) id 1wVQNv-00B8wp-2k for pgsql-bugs@lists.postgresql.org; Fri, 05 Jun 2026 08:58:35 +0000 Received: from mail-pf1-x431.google.com ([2607:f8b0:4864:20::431]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wVQNt-00000001OKR-3ZVN for pgsql-bugs@lists.postgresql.org; Fri, 05 Jun 2026 08:58:35 +0000 Received: by mail-pf1-x431.google.com with SMTP id d2e1a72fcca58-842848fd613so1282262b3a.3 for ; Fri, 05 Jun 2026 01:58:33 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1780649911; cv=none; d=google.com; s=arc-20240605; b=JvIhWJfQt6N7qT3GmDA60C7F6BF85ezOcppT3wjOEknFgV0LmkQ8cIVStyb8kU4qJW Jd5dfJ9jlX9BjhDueuL0cnlasUN7UoKtJR6iCqoab1D8W/WodqIH+rM549Xy0KkAQB26 b/ujq3DTVAg27wEvq3jMigja5jfOz/t0nqMKe+D4FOCzcB347ec9KruMtFYXfCMKGCn3 1FS8NJqDtpgHFRp1sA6wDczvi/7ACYdGN/f+G+xmaq7T7R9hHGFztS7xPqPxXTZeP9IV ylPprWETeJOyI2xxuBh/ndjcWT0FPCtVO10NQ0LoXXQZ7vtjDRBPtRX01g8miJKcCW/B IU4Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=bwyfp/Ovr17hUz7PG6jY9q4lkU6zsErnsEZnoH8Kg44=; fh=fCZQw3IqsR8vzj9d4kXKXxzmVYkRv1WVa/WurSC+yVE=; b=O5JgUUzwq1PNEz5WIL5fz29pRQJHTZYQ6a+UPjXes6qU5Y1u39u22FRHhJIhsldYis pL295k/p7SFYCCoiB7LkTVpLa5WxgCwyniSGQxY8nC3jMjkJCcr3LiD7UYMFO5qubnvT l8Hviyd8z+L3H9EBk47VDRKI2YEHwgAMzaUXy5CTk163pYofFZHK58EoMiiuKoE9P9kl pQjIKC1pZer97GMyQtNBIW9F6FKfcruzzaKGZSMhwnxGIjmlWWq5yyO1Pff5II7NicY7 kVsbuIlSSHBoDLjjRSeCzX97P+zzjuf9MCwgKeoZNf2zJsLq2Px4x1JbndDex4FWIEz3 HpUg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1780649911; x=1781254711; 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=bwyfp/Ovr17hUz7PG6jY9q4lkU6zsErnsEZnoH8Kg44=; b=mNLdCCYKU0OStpOnh6IO9WiIlsZkBjkCQBnmLNIazc+H06Q6BlKnkBqsh+/n4lUcdq c/rJxGUABYxEMoILwLMGIPeVv5QVyw0Niuzdn5JKzyLRgABGrJu9g+UKaiFygBbw+1mN jpLfm/BaUluLuPa2VBuYcpGFc8CChL3fgG9AD8/Su9I1sKYhPWNVdKCeTNN2IHJkCQg0 K4Mmw9W442v+0hs/Hfw7Vghj6CPp4I4uvs+ax6KRripw6IdGfJ7Fi9zM/RIUsstGzvcy YUXw3eDPun60gcgZRsm3oyKSmLTgB9SGK1XmVhBR0ETQgSU/8N1fiAuOHPF0BkvAy96E EVMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780649911; x=1781254711; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=bwyfp/Ovr17hUz7PG6jY9q4lkU6zsErnsEZnoH8Kg44=; b=KwFChrOaNDGYgHi3ebsIz2Z7d7UeKsRPBdrPgu5BK8TF5mYdGagOvLLcGgmiEwDTwA mtqpcBmCqiD6oSi5Y0+j2+rtq/PmxovuSiBS6ck3fQUpUMCDEgekVjCSnZWnhO52sFWC 8uPDXZjuMN4p9KODK7JLyVLPgtW4B8kHs5TWrsYtNR3OVQIbRMGXA3TnRUVfvHFttnj6 r2itMrxgOidaQ6WtlrsTtCp3/xTcOtw/+qAFaw+3cWwc2+A/UJpVkx9/Qy+EGS/yJ+k5 FPapFeuJkopyoKZg5evkKJBc7lUyJqL2HQtCKbW6cT/oRqHAeKUfKSA+Etb0jVIaQQjN BysA== X-Forwarded-Encrypted: i=1; AFNElJ+Zj7/0kGsc1T5wE6d2stFphrzAJWFyVgDn+AHQ6OMxqaoPiuVEQdoc/LnH13UekgsQDEg3RSuSyVv+@lists.postgresql.org X-Gm-Message-State: AOJu0Yz6eA1/7QwWF+ki3w1u0FxoNQh6qPKhTb/81zikRKTVUfrHuQQP 6gBdm+2U8k9U6RC29RJU9GH0BmjIOPHMnIcE+QZ8NZn0PON3BxJp4aqR2Qw+d+bt/pjFPuUT9d3 lyVZu4sAt9vH5m2SPT8e4JSky6P+g9v5KPe9e X-Gm-Gg: Acq92OH3Mr3VD3HLG/caGPdMjayf5QzlzwnwAKjDVWB5T0N3xkDeBKeod83YgOsyOYM vLJKI87YLc1RT0qcVoqQnmTl1+O5R9cW5mKFaM8a0RlJrvNS615pDE5G4KybGx618c6z0nfw2Wh zCwewwVK/xCfyWwU4MTMG/onzV1QlmgP5wlIZoPL3cyIXAw5N1W+tj7F4Tq3IZrDfXmj26AY8B+ DRXHAv+GNygFo7vkmkqL59pjuI/ZOcfgVJFlOfkAEe0M3uneCPEKUaBdYxOmK+FgTZ5HXb5R+NV hy0w6SQ85hZuThBFyronbDqbCXM2dgbuk6FV5W2i5B2nnOFjw8KFkwqVzF0wesh8gomnvjycymw = X-Received: by 2002:a05:6a00:1146:b0:835:405a:7e6f with SMTP id d2e1a72fcca58-842b0ee00ffmr2434316b3a.14.1780649910606; Fri, 05 Jun 2026 01:58:30 -0700 (PDT) MIME-Version: 1.0 References: <19458-a69c98bc498333ba@postgresql.org> <6DE4A9D6-6D5C-41C0-8AFE-F51CFBDDAD5A@yandex-team.ru> <674AEA44-D9C5-423D-B118-693CA130106E@yandex-team.ru> In-Reply-To: <674AEA44-D9C5-423D-B118-693CA130106E@yandex-team.ru> From: Amit Langote Date: Fri, 5 Jun 2026 17:58:14 +0900 X-Gm-Features: AVHnY4JST3H7nEwd8K3u-uySTCFLd00s7Oqkyf_-eBVvKUBHQGwHNe00mAasBUU Message-ID: Subject: Re: BUG #19458: OOM killer in jsonb_path_exists_opr (@?) with malformed JSONPath containing non-existent variables To: Andrey Borodin Cc: Nikita Malakhov , Andrey Rachitskiy , PostgreSQL mailing lists , Nikolay Shaplov Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Before I dig into the patch properly after the weekend, one question on the report itself: has anyone traced why the old path runs away on memory? We've characterized it as missing-var, then null, then evaluation continues, then OOM, but I don't think the actual growing allocation has been pinned down. Mostly want to understand whether the same runaway is reachable without a missing variable, since raising the error early wouldn't catch those cases. - Thanks, Amit