Re: (SQL/PGQ) cache lookup failed for label - Mailing list pgsql-hackers

From Andres Freund
Subject Re: (SQL/PGQ) cache lookup failed for label
Date
Msg-id bwfvxtdfmi6takrzrcvq5d6gd7jemvo3gy5wxypk3m3q2d635c@bgpfu6onhaoi
Whole thread
In response to Re: (SQL/PGQ) cache lookup failed for label  (Ewan Young <kdbase.hack@gmail.com>)
Responses Re: (SQL/PGQ) cache lookup failed for label
List pgsql-hackers
Hi,

On 2026-06-04 19:21:48 +0800, Ewan Young wrote:
> The patch is against master and passes make check. On top of your
> v20260601 series only the test-file hunks conflict (both append to
> graph_table.sql); the code hunk applies cleanly.

Unfortunately this fails in CI:
https://github.com/postgresql-cfbot/postgresql/actions/runs/27163049887

#4  0x598104c3 in ExceptionalCondition (conditionName=0x59adcb6c "var->varlevelsup > 0 && var->varlevelsup <
root->query_level",fileName=0x59adcb40 "../src/backend/optimizer/util/paramassign.c", lineNumber=126) at
../src/backend/utils/error/assert.c:65
No locals.
#5  0x592911f8 in replace_outer_var (root=0x5c92f418, var=0x5c92f708) at
../src/backend/optimizer/util/paramassign.c:126
        retval = <optimized out>
        i = <optimized out>
#6  0x59258569 in replace_correlation_vars_mutator (node=0x5c92f708, root=0x5c92f418) at
../src/backend/optimizer/plan/subselect.c:2168
No locals.
#7  0x59191152 in expression_tree_mutator_impl (node=<optimized out>, mutator=0x592584b0
<replace_correlation_vars_mutator>,context=0x5c92f418) at ../src/backend/nodes/nodeFuncs.c:3556
 
        targetentry = 0x5c92f6dc
        newnode = 0x5c92fa60
        __func__ = "expression_tree_mutator_impl"
#8  0x59258541 in replace_correlation_vars_mutator (node=0x5c92f6dc, root=0x5c92f418) at
../src/backend/optimizer/plan/subselect.c:2198
No locals.

For a full backtrace, see "Core backtraces" e.g. on
https://github.com/postgresql-cfbot/postgresql/actions/runs/27163049887/job/80183542083

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Zsolt Parragi
Date:
Subject: Re: pg_rewind does not rewind diverging timelines
Next
From: Zsolt Parragi
Date:
Subject: Re: Remove redundant DISTINCT when GROUP BY already guarantees uniqueness