Hello,
We're preparing to upgrade postgresql from 12.8 to 14.2 but still we have some bugs and issues. Most of them are our fault, but now we have problem wedon't know how to play with it.
-- dmesg message
[Sat Apr 2 08:26:24 2022] postmaster[1939250]: segfault at 7f2998f2c000 ip 00007f4a56cfeaaa sp 00007fff5a3e36a8 error 6 in libc-2.28.so[7f4a56b9e000+1bc000][Sat Apr 2 08:26:24 2022] Code: 8e c0 01 00 00 c5 fe 6f 06 c5 fe 6f 4e 20 c5 fe 6f 56 40 c5 fe 6f 5e 60 48 81 c6 80 00 00 00 48 81 ea 80 00 00 00 c5 fd e7 07 fd e7 4f 20 c5 fd e7 57 40 c5 fd e75f 60 48 81 c7 80 00 00 00
-- PostgreSQL Log message
2022-04-02 08:26:24 MSK 00000LOG: server process (PID 1939250) was terminated by signal 11: Segmentation fault2022-04-02 08:26:24 MSK 00000DETAIL: Failed process was running: SELECT "SubdivisionId", "UserId", "UserLogin"FROM powerbi."GetReportRights1002_VIEW" ;2022-04-02 08:26:24 MSK 00000LOG: terminating any other active server processes
-- User error message
54000: index row requires 554440232 bytes, maximum size is 8191
-- We have compiled from the source code with modified macros
sed -i.gres "s/#define NAMEDATALEN 64/#define NAMEDATALEN 320/g" ./src/include/pg_config_manual.h
sed -i.gres "s/#define NAMEDATALEN 64/#define NAMEDATALEN 320/g" ./src/interfaces/ecpg/include/sqlda-native.h
-- In the attachment files
-- DDL
-- The result of the command execution: gdb /usr/pgsql-14/bin/postgres <core dump file> --ex 'bt full' --batch
CREATE OR REPLACE VIEW powerbi."GetReportRights1002_VIEW" AS
SELECT "FT_GetReportRights"."r_SubdivisionId" AS "SubdivisionId",
"FT_GetReportRights"."r_UserId" AS "UserId",
concat("FT_GetReportRights"."r_UserLogin", '@example.com') AS "UserLogin"
FROM rights."FT_GetReportRights"(1002) "FT_GetReportRights"("r_SubdivisionId", "r_UserId", "r_UserLogin")
UNION ALL
SELECT DISTINCT '-999'::integer AS "SubdivisionId",
"FT_GetReportRights"."r_UserId" AS "UserId",
concat("FT_GetReportRights"."r_UserLogin", '@example.com') AS "UserLogin"
FROM rights."FT_GetReportRights"(1002) "FT_GetReportRights"("r_SubdivisionId", "r_UserId", "r_UserLogin");
CREATE OR REPLACE FUNCTION rights."FT_GetReportRights"(IN "par_ReportId" integer DEFAULT NULL::integer)
RETURNS TABLE("r_SubdivisionId" integer, "r_UserId" integer, "r_UserLogin" character varying) AS
$BODY$
DECLARE
--"par_ReportId" integer = 1002;
BEGIN
DROP TABLE IF EXISTS "ListObject" ;
CREATE temp TABLE IF NOT EXISTS "ListObject"(
"idObject" INTEGER
);
WITH RECURSIVE "get_idObjects" AS (
SELECT
o.id
,o."ParentID"
,o.tag_int as "idObject_Subj"
FROM
rights."Objects" o
WHERE
o."idObjectType" = 1
UNION
SELECT
o_parent.id
,o_parent."ParentID"
,o_slave."idObject_Subj"
FROM
"get_idObjects" as o_slave
INNER JOIN rights."Objects" as o_parent
ON o_parent.id = o_slave."ParentID"
AND o_parent."idObjectType" = 2
)
INSERT INTO "ListObject"(
"idObject"
)
SELECT
gio.id
FROM
"get_idObjects" gio
WHERE
gio."idObject_Subj" = "par_ReportId"
;
DROP TABLE IF EXISTS "FullRightsOfStructure" ;
CREATE TEMP TABLE IF NOT EXISTS "FullRightsOfStructure"(
"SubdivisionId" INTEGER
,"UserId" integer
,"UserLogin" VARCHAR(20)
);
INSERT INTO "FullRightsOfStructure"(
"SubdivisionId"
,"UserId"
,"UserLogin"
)
SELECT DISTINCT
(CASE
WHEN o."idObjectType" = 3 THEN o.tag_int
--WHEN o."idObjectType" = 4 THEN ou."SubdivisionId"
ELSE NULL::INTEGER
END) as "SubdivisionId"
,ou."id"
,ou."Login"
FROM
"ListObject" lo
JOIN rights."Rights" r ON r."idObject_Subj" = lo."idObject"
JOIN rights."Users" u ON u.id = r."idRightsUser"
JOIN rights."Objects" o ON o.id = r."idObject"
JOIN dwh."OFAS_Org_User" ou ON ou.id = u."idUser_OFAS"
union
select
os.id as "SubdivisionId",
ou.id as "UserId",
ou."Login" as "UserLogin"
from
dwh."User_See_All" as u_sall
join dwh."OFAS_Org_User" as ou
on u_sall."UserLogin" = ou."Login"
full join dwh."OFAS_Org_Structure" as os
on true
;
DROP TABLE IF EXISTS "tt_Result";
CREATE TEMP TABLE "tt_Result"(
"SubdivisionId" INTEGER
,"UserId" integer
,"UserLogin" VARCHAR(20)
);
insert into "tt_Result" (
"SubdivisionId"
,"UserId"
,"UserLogin"
)
SELECT
coalesce(os_in."id",os.id) as "SubdivisionId"
,fros."UserId"
,fros."UserLogin"
from
"FullRightsOfStructure" as fros
join dwh."OFAS_Org_Structure" as OS on os.id = fros."SubdivisionId"
left join dwh."OFAS_Org_Structure" as OS_in on os_in."id_hierarchy" <@ os."id_hierarchy"
and fros."UserId" = OS."Chief"
group by
coalesce(os_in."id",os.id)
,fros."UserId"
,fros."UserLogin"
;
RETURN QUERY
select
"SubdivisionId" as "r_SubdivisionId"
,"UserId" as "r_UserId"
,"UserLogin" as "r_UserLogin"
from
"tt_Result"
;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
ROWS 1000;
CREATE INDEX "ix_DWH_OFAS_Org_Structure_id_hierarchy"
ON dwh."OFAS_Org_Structure"
USING gist
(id_hierarchy)
WITH (FILLFACTOR=98);
[New LWP 2110127]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `postgres: sql01: powerbi Warehouse 172.27.0.249(57533) SELEC'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x00007fcf4298faaa in __memmove_avx_unaligned_erms () from /lib64/libc.so.6
#0 0x00007fcf4298faaa in __memmove_avx_unaligned_erms () from /lib64/libc.so.6
No symbol table info available.
#1 0x00007fae8505e5aa in copy_ltree (src=0x7fc6e7d57472) at ltree_gist.c:446
dst = 0x7fae6f67d048
dst = <optimized out>
#2 gist_ischild (siglen=<optimized out>, query=0x2ed6e08, key=<optimized out>) at ltree_gist.c:454
left = 0x3585048
right = <optimized out>
res = <optimized out>
left = <optimized out>
right = <optimized out>
res = <optimized out>
#3 ltree_consistent (fcinfo=0x7ffc2f9471e0) at ltree_gist.c:674
entry = <optimized out>
strategy = <optimized out>
recheck = <optimized out>
siglen = <optimized out>
key = <optimized out>
query = 0x2ed6e08
res = false
__func__ = "ltree_consistent"
#4 0x00000000008c4f80 in FunctionCall5Coll (flinfo=flinfo@entry=0x3136aa8, collation=<optimized out>, arg1=arg1@entry=140721106744032, arg2=<optimized out>, arg3=<optimized out>, arg4=<optimized out>, arg5=140721106744031) at fmgr.c:1241
fcinfodata = {fcinfo = {flinfo = 0x3136aa8, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 5, args = 0x7ffc2f947200}, fcinfo_data = "\250j\023\003", '\000' <repeats 26 times>, "\005\000\340r\224/\374\177\000\000\000\000\000\000\000\000\000\000\bn\355\002\000\000\000\000\000\000\000\000\000\000\001\000\v\000\000\000\000\000\000\000\000\004\301\000\000\000\000\000\001@\000\000\000\000\000\000\000\210Q\000\000\000\000\000\337r\224/\374\177\000\000\000\067Q\000\000\000\000"}
fcinfo = 0x7ffc2f9471e0
result = <optimized out>
__func__ = "FunctionCall5Coll"
__errno_location = <optimized out>
#5 0x00000000005137bd in gistindex_keytest (recheck_distances_p=<synthetic pointer>, recheck_p=<synthetic pointer>, offset=3, page=0x7fc6e7555600 "\237=\003", tuple=0x7fc6e7557458, scan=0x3136b28) at gistget.c:222
test = <optimized out>
recheck = false
de = {key = 140492261389408, rel = 0x7fae8567e6d0, page = 0x7fc6e7555600 "\237=\003", offset = 3, leafkey = false}
datum = <optimized out>
isNull = false
so = 0x302f9b8
key = 0x3136a98
distance_p = <optimized out>
giststate = 0x302c2c8
keySize = <optimized out>
r = 0x7fae8567e6d0
so = <optimized out>
giststate = <optimized out>
key = <optimized out>
keySize = <optimized out>
distance_p = <optimized out>
r = <optimized out>
__func__ = "gistindex_keytest"
i = <optimized out>
__errno_location = <optimized out>
datum = <optimized out>
isNull = <optimized out>
test = <optimized out>
recheck = <optimized out>
de = <optimized out>
datum = <optimized out>
isNull = <optimized out>
dist = <optimized out>
recheck = <optimized out>
de = <optimized out>
#6 gistScanPage (scan=<optimized out>, pageItem=<optimized out>, myDistances=<optimized out>, tbm=0x0, ntids=0x0) at gistget.c:438
match = <optimized out>
recheck = <optimized out>
iid = 0x7fc6e7555620
it = 0x7fc6e7557458
recheck_distances = false
so = <optimized out>
giststate = 0x302c2c8
r = 0x7fae8567e6d0
buffer = 12649724
page = 0x7fc6e7555600 "\237=\003"
opaque = <optimized out>
maxoff = 5
i = 3
oldcxt = 0x2ececc0
#7 0x0000000000513f13 in gistgettuple (scan=0x3136b28, dir=<optimized out>) at gistget.c:639
fakeItem = {phNode = {first_child = 0xad, next_sibling = 0x2ffdd00, prev_or_parent = 0x2ffdc18}, blkno = 0, data = {parentlsn = 0, heap = {heapPtr = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0}, recheck = false, recheckDistances = false, recontup = 0x2ed02c0, offnum = 3}}, distances = 0x7ffc2f947388}
so = 0x302f9b8
__func__ = "gistgettuple"
#8 0x000000000053efa1 in index_getnext_tid (scan=0x3136b28, direction=<optimized out>) at indexam.c:533
found = <optimized out>
__func__ = "index_getnext_tid"
__errno_location = <optimized out>
#9 0x000000000053f0bb in index_getnext_slot (scan=scan@entry=0x3136b28, direction=direction@entry=ForwardScanDirection, slot=slot@entry=0x2fff138) at indexam.c:625
tid = <optimized out>
#10 0x0000000000681658 in IndexNext (node=node@entry=0x2ffee98) at nodeIndexscan.c:133
estate = <optimized out>
econtext = 0x2fff0a8
direction = ForwardScanDirection
scandesc = 0x3136b28
slot = 0x2fff138
#11 0x00000000006691a7 in ExecScanFetch (recheckMtd=0x681e40 <IndexRecheck>, accessMtd=0x681600 <IndexNext>, node=0x2ffee98) at execScan.c:133
estate = 0x2ecedd8
estate = <optimized out>
epqstate = <optimized out>
scanrelid = <optimized out>
slot = <optimized out>
slot = <optimized out>
slot = <optimized out>
slot = <optimized out>
#12 ExecScan (node=0x2ffee98, accessMtd=0x681600 <IndexNext>, recheckMtd=0x681e40 <IndexRecheck>) at execScan.c:199
slot = <optimized out>
econtext = 0x2fff0a8
qual = 0x0
projInfo = 0x2fff7e8
#13 0x000000000068b006 in ExecProcNode (node=0x2ffee98) at ../../../src/include/executor/executor.h:257
No locals.
#14 ExecNestLoop (pstate=0x2ecfc50) at nodeNestloop.c:160
node = 0x2ecfc50
nl = 0x2fd4e48
innerPlan = 0x2ffee98
outerPlan = 0x2ecfdf0
outerTupleSlot = <optimized out>
innerTupleSlot = <optimized out>
joinqual = 0x3132ab8
otherqual = 0x0
econtext = 0x2ecfd60
lc = <optimized out>
#15 0x000000000066fc21 in ExecProcNode (node=0x2ecfc50) at ../../../src/include/executor/executor.h:257
No locals.
#16 fetch_input_tuple (aggstate=aggstate@entry=0x2ecf628) at nodeAgg.c:581
slot = <optimized out>
#17 0x0000000000672910 in agg_fill_hash_table (aggstate=0x2ecf628) at nodeAgg.c:2551
outerslot = <optimized out>
tmpcontext = 0x2ecf088
outerslot = <optimized out>
tmpcontext = <optimized out>
#18 ExecAgg (pstate=0x2ecf628) at nodeAgg.c:2172
node = 0x2ecf628
result = 0x0
#19 0x00000000006899e9 in ExecProcNode (node=0x2ecf628) at ../../../src/include/executor/executor.h:257
No locals.
#20 ExecModifyTable (pstate=<optimized out>) at nodeModifyTable.c:2425
node = <optimized out>
estate = 0x2ecedd8
operation = <optimized out>
resultRelInfo = 0x2ecf328
subplanstate = <optimized out>
slot = <optimized out>
planSlot = <optimized out>
oldSlot = <optimized out>
tupleid = <optimized out>
tuple_ctid = {ip_blkid = {bi_hi = 140, bi_lo = 0}, ip_posid = 0}
oldtupdata = {t_len = 1, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 1}, t_tableOid = 0, t_data = 0x1}
oldtuple = <optimized out>
proute = 0x0
relinfos = 0x0
lc = <optimized out>
__func__ = "ExecModifyTable"
#21 0x0000000000660bfb in ExecProcNode (node=0x2ecf118) at ../../../src/include/executor/executor.h:257
No locals.
#22 ExecutePlan (execute_once=<optimized out>, dest=0xa17e60 <spi_printtupDR>, direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>, operation=CMD_INSERT, use_parallel_mode=<optimized out>, planstate=0x2ecf118, estate=0x2ecedd8) at execMain.c:1551
slot = <optimized out>
current_tuple_count = 0
slot = <optimized out>
current_tuple_count = <optimized out>
#23 standard_ExecutorRun (queryDesc=0x312fe50, direction=<optimized out>, count=0, execute_once=<optimized out>) at execMain.c:361
estate = 0x2ecedd8
operation = CMD_INSERT
dest = 0xa17e60 <spi_printtupDR>
sendTuples = <optimized out>
oldcontext = 0x2eacde0
__func__ = "standard_ExecutorRun"
#24 0x00007fcf408995d5 in explain_ExecutorRun (queryDesc=0x312fe50, direction=ForwardScanDirection, count=0, execute_once=<optimized out>) at auto_explain.c:336
_save_exception_stack = 0x7ffc2f9478a0
_save_context_stack = 0x7ffc2f947a10
_local_sigjmp_buf = {{__jmpbuf = {140721106745968, -4310098676335891937, 1, 48087816, 47981080, 7, 4311962713868610079, 4301488524435794463}, __mask_was_saved = 0, __saved_mask = {__val = {49082880, 49082504, 140387539059040, 49082504, 9081735, 2, 5810008, 48086864, 140387539059508, 64, 233, 51576320, 5, 2, 49551056, 2254386009}}}}
_do_rethrow = false
#25 0x00007fcf406926b0 in pgss_ExecutorRun (queryDesc=0x312fe50, direction=ForwardScanDirection, count=0, execute_once=<optimized out>) at pg_stat_statements.c:1001
_save_exception_stack = 0x7ffc2f948080
_save_context_stack = 0x7ffc2f947a10
_local_sigjmp_buf = {{__jmpbuf = {140721106745968, -4310098676335891937, 1, 48087816, 47981080, 7, 4311962713702935071, 4301488244828809759}, __mask_was_saved = 0, __saved_mask = {__val = {9321469, 47981080, 2147483647, 0, 6746315, 51576400, 14363776, 48942560, 140528117716859, 14364256, 140721106745968, 51576400, 0, 1, 140528115602585, 140721106745968}}}}
_do_rethrow = false
#26 0x0000000000697dae in _SPI_pquery (tcount=0, fire_triggers=true, queryDesc=0x312fe50) at spi.c:2808
operation = <optimized out>
eflags = <optimized out>
res = 7
operation = <optimized out>
eflags = <optimized out>
res = <optimized out>
__func__ = "_SPI_pquery"
__errno_location = <optimized out>
#27 _SPI_execute_plan (plan=<optimized out>, options=0x7ffc2f947a70, snapshot=<optimized out>, crosscheck_snapshot=<optimized out>, fire_triggers=<optimized out>) at spi.c:2580
qdesc = 0x312fe50
snap = 0x2dc2218
stmt = <optimized out>
canSetTag = true
dest = <optimized out>
lc2__state = {l = 0x2ddc308, i = 0}
plansource = <optimized out>
stmt_list = 0x2ddc308
lc2 = <optimized out>
lc1__state = <optimized out>
my_res = 0
my_processed = 0
my_tuptable = 0x0
res = <optimized out>
pushed_active_snap = <optimized out>
plan_owner = <optimized out>
spicallbackarg = {query = 0x3006138 "insert into \"tt_Result\" (\r\n \"SubdivisionId\"\r\n ,\"UserId\"\r\n ,\"UserLogin\"\r\n )\r\n SELECT\r\n coalesce(os_in.\"id\",os.id) as \"SubdivisionId\"\r\n ,fros.\"UserId\"\r\n ,fros.\"UserLogin\"\r\n "..., mode = RAW_PARSE_DEFAULT}
spierrcontext = {previous = 0x7ffc2f947ee0, callback = 0x695a50 <_SPI_error_callback>, arg = 0x7ffc2f9479f0}
cplan = <optimized out>
lc1 = <optimized out>
__func__ = "_SPI_execute_plan"
#28 0x000000000069861a in SPI_execute_plan_with_paramlist (plan=0x2fefac8, params=0x0, read_only=<optimized out>, tcount=tcount@entry=0) at spi.c:656
options = {params = 0x0, read_only = false, allow_nonatomic = false, must_return_tuples = false, tcount = 0, dest = 0x0, owner = 0x0}
res = 0
#29 0x00007fae853e33cf in exec_stmt_execsql (estate=0x7ffc2f947f00, stmt=0x2e92a78) at pl_exec.c:4232
paramLI = <optimized out>
tcount = 0
rc = <optimized out>
expr = 0x2e925d8
too_many_rows_level = 0
__func__ = "exec_stmt_execsql"
#30 0x00007fae853e443b in exec_stmts (estate=0x7ffc2f947f00, stmts=0x2e8d248) at pl_exec.c:2059
stmt = 0x2e92a78
rc = <optimized out>
s__state = {l = <optimized out>, i = 8}
save_estmt = <optimized out>
s = <optimized out>
__func__ = "exec_stmts"
#31 0x00007fae853e63cb in exec_stmt_block (estate=estate@entry=0x7ffc2f947f00, block=block@entry=0x2e92d10) at pl_exec.c:1910
rc = -1
i = <optimized out>
__func__ = "exec_stmt_block"
#32 0x00007fae853e649b in exec_toplevel_block (estate=estate@entry=0x7ffc2f947f00, block=0x2e92d10) at pl_exec.c:1608
rc = <optimized out>
#33 0x00007fae853e6c0d in plpgsql_exec_function (func=func@entry=0x2d6c168, fcinfo=fcinfo@entry=0x2e74dc8, simple_eval_estate=simple_eval_estate@entry=0x0, simple_eval_resowner=simple_eval_resowner@entry=0x0, procedure_resowner=procedure_resowner@entry=0x0, atomic=<optimized out>) at pl_exec.c:611
estate = {func = 0x2d6c168, trigdata = 0x0, evtrigdata = 0x0, retval = 0, retisnull = true, rettype = 0, fn_rettype = 2249, retistuple = true, retisset = true, readonly_func = false, atomic = true, exitlabel = 0x0, cur_error = 0x0, tuple_store = 0x0, tuple_store_desc = 0x0, tuple_store_cxt = 0x2e2eea0, tuple_store_owner = 0x2d18e08, rsi = 0x7ffc2f948220, found_varno = 5, ndatums = 6, datums = 0x2e86cb0, datum_context = 0x2e84d20, paramLI = 0x2e84e38, simple_eval_estate = 0x2ea2ea8, simple_eval_resowner = 0x2d6c578, procedure_resowner = 0x0, cast_hash = 0x2ea0e98, cast_hash_context = 0x2e9ed70, stmt_mcontext = 0x0, stmt_mcontext_parent = 0x2e84d20, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x2ea30b8, err_stmt = 0x2e92a78, err_text = 0x0, plugin_info = 0x0}
plerrcontext = {previous = 0x0, callback = 0x7fae853df5a0 <plpgsql_exec_error_callback>, arg = 0x7ffc2f947f00}
i = <optimized out>
rc = <optimized out>
__func__ = "plpgsql_exec_function"
#34 0x00007fae853efdcb in plpgsql_call_handler (fcinfo=0x2e74dc8) at pl_handler.c:277
_save_exception_stack = 0x7ffc2f948500
_save_context_stack = 0x0
_local_sigjmp_buf = {{__jmpbuf = {0, -4310098676336023009, 1, 0, 0, 1, 4311962722016045599, 4283625193669667359}, __mask_was_saved = 0, __saved_mask = {__val = {140528151636634, 0, 140721106747872, 48713160, 7578951, 1, 0, 0, 10570176, 49181760, 48712880, 48619760, 48619248, 48713200, 1, 48621968}}}}
_do_rethrow = false
nonatomic = false
func = 0x2d6c168
save_cur_estate = 0x0
procedure_resowner = 0x0
retval = 0
rc = 1
__func__ = "plpgsql_call_handler"
#35 0x00000000006689ad in ExecMakeTableFunctionResult (setexpr=0x2e5e060, econtext=0x2e5def0, argContext=<optimized out>, expectedDesc=0x2e5f430, randomAccess=false) at execSRF.c:234
result = 140528172503896
tupstore = 0x0
tupdesc = 0x0
funcrettype = 2249
returnsTuple = <optimized out>
returnsSet = true
fcinfo = 0x2e74dc8
fcusage = {fs = 0x2e83520, save_f_total_time = {tv_sec = 5310, tv_nsec = 851798641}, save_total = {tv_sec = 5310, tv_nsec = 851798641}, f_start = {tv_sec = 13181313, tv_nsec = 417587576}}
rsinfo = {type = T_ReturnSetInfo, econtext = 0x2e5def0, expectedDesc = 0x2e5f430, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0}
tmptup = {t_len = 48690192, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 55098}, t_tableOid = 0, t_data = 0x3a}
callerContext = 0x2e2eea0
first_time = true
__func__ = "ExecMakeTableFunctionResult"
#36 0x0000000000678abf in FunctionNext (node=node@entry=0x2e272d8) at nodeFunctionscan.c:94
tstore = 0x0
estate = <optimized out>
direction = ForwardScanDirection
scanslot = 0x2e2f428
alldone = <optimized out>
oldpos = <optimized out>
funcno = <optimized out>
att = <optimized out>
#37 0x00000000006691a7 in ExecScanFetch (recheckMtd=0x6787a0 <FunctionRecheck>, accessMtd=0x6787c0 <FunctionNext>, node=0x2e272d8) at execScan.c:133
estate = 0x2e2efb8
estate = <optimized out>
epqstate = <optimized out>
scanrelid = <optimized out>
slot = <optimized out>
slot = <optimized out>
slot = <optimized out>
slot = <optimized out>
#38 ExecScan (node=0x2e272d8, accessMtd=0x6787c0 <FunctionNext>, recheckMtd=0x6787a0 <FunctionRecheck>) at execScan.c:199
slot = <optimized out>
econtext = 0x2e5def0
qual = 0x0
projInfo = 0x2e6d4e8
#39 0x000000000066fc21 in ExecProcNode (node=0x2e272d8) at ../../../src/include/executor/executor.h:257
No locals.
#40 fetch_input_tuple (aggstate=aggstate@entry=0x2e28e08) at nodeAgg.c:581
slot = <optimized out>
#41 0x0000000000672910 in agg_fill_hash_table (aggstate=0x2e28e08) at nodeAgg.c:2551
outerslot = <optimized out>
tmpcontext = 0x2e30d38
outerslot = <optimized out>
tmpcontext = <optimized out>
#42 ExecAgg (pstate=0x2e28e08) at nodeAgg.c:2172
node = 0x2e28e08
result = 0x0
#43 0x00000000006754c7 in ExecProcNode (node=0x2e28e08) at ../../../src/include/executor/executor.h:257
No locals.
#44 ExecAppend (pstate=0x2e2f218) at nodeAppend.c:360
subnode = 0x2e28e08
node = 0x2e2f218
result = 0x2e29218
#45 0x0000000000660bfb in ExecProcNode (node=0x2e2f218) at ../../../src/include/executor/executor.h:257
No locals.
#46 ExecutePlan (execute_once=<optimized out>, dest=0x2e46af8, direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x2e2f218, estate=0x2e2efb8) at execMain.c:1551
slot = <optimized out>
current_tuple_count = 26023
slot = <optimized out>
current_tuple_count = <optimized out>
#47 standard_ExecutorRun (queryDesc=0x2e26b98, direction=<optimized out>, count=0, execute_once=<optimized out>) at execMain.c:361
estate = 0x2e2efb8
operation = CMD_SELECT
dest = 0x2e46af8
sendTuples = <optimized out>
oldcontext = 0x2e26a80
__func__ = "standard_ExecutorRun"
#48 0x00007fcf408995d5 in explain_ExecutorRun (queryDesc=0x2e26b98, direction=ForwardScanDirection, count=0, execute_once=<optimized out>) at auto_explain.c:336
_save_exception_stack = 0x7ffc2f948610
_save_context_stack = 0x0
_local_sigjmp_buf = {{__jmpbuf = {47890120, -4310101170855204321, 0, 0, 1, 47312112, 4311962721902799391, 4301488524435794463}, __mask_was_saved = 0, __saved_mask = {__val = {1, 48517544, 48399864, 9659429875640, 48397800, 72, 48507248, 16, 48506976, 1, 48426936, 48428664, 6712862, 2, 2, 48506976}}}}
_do_rethrow = false
#49 0x00007fcf406926b0 in pgss_ExecutorRun (queryDesc=0x2e26b98, direction=ForwardScanDirection, count=0, execute_once=<optimized out>) at pg_stat_statements.c:1001
_save_exception_stack = 0x7ffc2f9487a0
_save_context_stack = 0x0
_local_sigjmp_buf = {{__jmpbuf = {47890120, -4310101170855204321, 0, 0, 1, 47312112, 4311962721871342111, 4301488244828809759}, __mask_was_saved = 0, __saved_mask = {__val = {6713492, 48426936, 48523800, 16, 47980480, 24, 1, 0, 1, 47312112, 9320307, 47312112, 47980808, 48393112, 9376955, 47890120}}}}
_do_rethrow = false
#50 0x00000000007b896b in PortalRunSelect (portal=0x2dabec8, forward=<optimized out>, count=0, dest=<optimized out>) at pquery.c:921
queryDesc = 0x2e26b98
direction = <optimized out>
nprocessed = <optimized out>
__func__ = "PortalRunSelect"
#51 0x00000000007b9bc4 in PortalRun (portal=portal@entry=0x2dabec8, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x2e46af8, altdest=altdest@entry=0x2e46af8, qc=0x7ffc2f9488e0) at pquery.c:765
_save_exception_stack = 0x7ffc2f948be0
_save_context_stack = 0x0
_local_sigjmp_buf = {{__jmpbuf = {1, -4310101371202426337, 140721106749664, 48524024, 47890120, 47312112, 4311962721915382303, -4310097805221025249}, __mask_was_saved = 0, __saved_mask = {__val = {10928797, 1, 47901680, 0, 0, 47312112, 48392832, 6, 6, 140721106749662, 112, 47307648, 2, 48523944, 0, 47312112}}}}
_do_rethrow = <optimized out>
result = <optimized out>
nprocessed = <optimized out>
saveTopTransactionResourceOwner = 0x2d5e5c0
saveTopTransactionContext = 0x2dc1fc0
saveActivePortal = 0x0
saveResourceOwner = 0x2d5e5c0
savePortalContext = 0x0
saveMemoryContext = 0x2dc1fc0
__func__ = "PortalRun"
#52 0x00000000007b60bf in exec_simple_query (query_string=0x2d1dc98 "SELECT \n \"SubdivisionId\",\n \"UserId\",\n \"UserLogin\"\nFROM \n powerbi.\"GetReportRights1002_VIEW\" ;") at postgres.c:1214
snapshot_set = <optimized out>
per_parsetree_context = 0x0
plantree_list = <optimized out>
parsetree = 0x2d1ecc0
commandTag = <optimized out>
qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0}
querytree_list = <optimized out>
portal = 0x2dabec8
receiver = 0x2e46af8
format = 0
parsetree_item__state = {l = 0x2d1ecf0, i = 0}
dest = DestRemote
oldcontext = 0x2dc1fc0
parsetree_list = 0x2d1ecf0
parsetree_item = <optimized out>
save_log_statement_stats = false
was_logged = false
use_implicit_block = false
msec_str = '\000' <repeats 16 times>, "\210\315\325\002\000\000\000\000Q\000\000\000\000\000\000"
__func__ = "exec_simple_query"
#53 0x00000000007b7853 in PostgresMain (argc=argc@entry=1, argv=argv@entry=0x7ffc2f948e40, dbname=<optimized out>, username=<optimized out>) at postgres.c:4486
query_string = 0x2d1dc98 "SELECT \n \"SubdivisionId\",\n \"UserId\",\n \"UserLogin\"\nFROM \n powerbi.\"GetReportRights1002_VIEW\" ;"
firstchar = <optimized out>
input_message = {data = 0x2d1dc98 "SELECT \n \"SubdivisionId\",\n \"UserId\",\n \"UserLogin\"\nFROM \n powerbi.\"GetReportRights1002_VIEW\" ;", len = 98, maxlen = 1024, cursor = 98}
local_sigjmp_buf = {{__jmpbuf = {970114892, -4310098676336023009, 47566216, 582, 0, 47515792, 4311962721716152863, -4310097812033623521}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 10493038, 47451728, 47313336, 140721106752544, 47308616, 7590291, 32, 47308633, 844424977647760, 47307648, 3, 47307648, 1024, 3, 582}}}}
send_ready_for_query = false
idle_in_transaction_timeout_enabled = false
idle_session_timeout_enabled = false
__func__ = "PostgresMain"
#54 0x00000000007400b3 in BackendRun (port=<optimized out>, port=<optimized out>) at postmaster.c:4530
av = {0x9100e4 "postgres", 0x0}
ac = 1
av = <optimized out>
ac = <optimized out>
#55 BackendStartup (port=<optimized out>) at postmaster.c:4252
bn = 0x2d50890
pid = 0
bn = <optimized out>
pid = <optimized out>
__func__ = "BackendStartup"
__errno_location = <optimized out>
__errno_location = <optimized out>
save_errno = <optimized out>
__errno_location = <optimized out>
__errno_location = <optimized out>
#56 ServerLoop () at postmaster.c:1745
port = <optimized out>
i = <optimized out>
rmask = {fds_bits = {64, 0 <repeats 15 times>}}
selres = <optimized out>
now = <optimized out>
readmask = {fds_bits = {448, 0 <repeats 15 times>}}
nSockets = 9
last_lockfile_recheck_time = <optimized out>
last_touch_time = 1648961554
__func__ = "ServerLoop"
#57 0x0000000000740e48 in PostmasterMain (argc=argc@entry=3, argv=argv@entry=0x2d17430) at postmaster.c:1417
opt = <optimized out>
status = <optimized out>
userDoption = <optimized out>
listen_addr_saved = true
i = <optimized out>
output_config_variable = <optimized out>
__func__ = "PostmasterMain"
#58 0x00000000004ec342 in main (argc=3, argv=0x2d17430) at main.c:209
No locals.
