Re: query_id, pg_stat_activity, extended query protocol - Mailing list pgsql-hackers

From Alexander Lakhin
Subject Re: query_id, pg_stat_activity, extended query protocol
Date
Msg-id cf3547c1-498a-6a61-7b01-819f902a251f@gmail.com
Whole thread Raw
In response to Re: query_id, pg_stat_activity, extended query protocol  (Sami Imseih <samimseih@gmail.com>)
List pgsql-hackers
Hello Michael and Sami,

18.09.2024 08:46, Michael Paquier wrote:
> So, I have applied 0001 down to 14, followed by 0002 on HEAD.
>

Please look at the script, which triggers Assert added by 24f520594:
(assuming shared_preload_libraries=pg_stat_statements)
SELECT repeat('x', 100) INTO t FROM generate_series(1, 100000);
CREATE FUNCTION f() RETURNS int LANGUAGE sql IMMUTABLE RETURN 0;
CREATE INDEX ON t(f());

TRAP: failed Assert("!IsQueryIdEnabled() || pgstat_get_my_query_id() != 0"), File: "execMain.c", Line: 300, PID:
1288609
ExceptionalCondition at assert.c:52:13
ExecutorRun at execMain.c:302:6
postquel_getnext at functions.c:903:24
fmgr_sql at functions.c:1198:15
ExecInterpExpr at execExprInterp.c:746:8
ExecInterpExprStillValid at execExprInterp.c:2034:1
ExecEvalExprSwitchContext at executor.h:367:13
evaluate_expr at clauses.c:4997:14
evaluate_function at clauses.c:4505:1
simplify_function at clauses.c:4092:12
eval_const_expressions_mutator at clauses.c:2591:14
expression_tree_mutator_impl at nodeFuncs.c:3550:12
eval_const_expressions_mutator at clauses.c:3712:1
eval_const_expressions at clauses.c:2267:1
RelationGetIndexExpressions at relcache.c:5079:20
BuildIndexInfo at index.c:2426:7
...

Best regards,
Alexander



pgsql-hackers by date:

Previous
From: Jim Jones
Date:
Subject: XMLSerialize: version and explicit XML declaration
Next
From: Peter Eisentraut
Date:
Subject: Re: Add contrib/pg_logicalsnapinspect