Re: BUG #17728: When jdbc calls the stored procedure, portal->stmts in FillPortalStore is null, causing a processing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Cramer <davecramer(at)postgres(dot)rocks>
Cc: dafoer_x(at)163(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17728: When jdbc calls the stored procedure, portal->stmts in FillPortalStore is null, causing a processing
Date: 2022-12-23 04:38:15
Message-ID: 2309554.1671770295@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dave Cramer <davecramer(at)postgres(dot)rocks> writes:
> On Thu, 22 Dec 2022 at 10:49, PG Bug reporting form <noreply(at)postgresql(dot)org>
> wrote:
>> #0 pgss_store (query=0x2d55138 "call p1($1)",
>> queryId=16705933007615826313,
>> query_location=1702063721, query_len=1763734642, kind=PGSS_EXEC,
>> total_time=3341.1963460000002,
>> rows=0, bufusage=0x7ffc2e4ddc20, walusage=0x7ffc2e4ddcf0, jstate=0x0)
>> at pg_stat_statements.c:1225

> I just tried the same code with no issues.

This looks very much like the bug fixed by commit 495e73c20 [1].
I wonder whether the server is really 14.6, or something older,
because that fix shipped in 14.6.

regards, tom lane

[1] https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=495e73c20

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Karina Litskevich 2022-12-23 13:54:56 [PATCH] BUG FIX: inconsistent page found in BRIN_REGULAR_PAGE
Previous Message Dave Cramer 2022-12-22 19:25:57 Re: BUG #17728: When jdbc calls the stored procedure, portal->stmts in FillPortalStore is null, causing a processing