[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 = #2 gist_ischild (siglen=, query=0x2ed6e08, key=) at ltree_gist.c:454 left = 0x3585048 right = res = left = right = res = #3 ltree_consistent (fcinfo=0x7ffc2f9471e0) at ltree_gist.c:674 entry = strategy = recheck = siglen = key = query = 0x2ed6e08 res = false __func__ = "ltree_consistent" #4 0x00000000008c4f80 in FunctionCall5Coll (flinfo=flinfo@entry=0x3136aa8, collation=, arg1=arg1@entry=140721106744032, arg2=, arg3=, arg4=, 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' , "\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 = __func__ = "FunctionCall5Coll" __errno_location = #5 0x00000000005137bd in gistindex_keytest (recheck_distances_p=, recheck_p=, offset=3, page=0x7fc6e7555600 "\237=\003", tuple=0x7fc6e7557458, scan=0x3136b28) at gistget.c:222 test = recheck = false de = {key = 140492261389408, rel = 0x7fae8567e6d0, page = 0x7fc6e7555600 "\237=\003", offset = 3, leafkey = false} datum = isNull = false so = 0x302f9b8 key = 0x3136a98 distance_p = giststate = 0x302c2c8 keySize = r = 0x7fae8567e6d0 so = giststate = key = keySize = distance_p = r = __func__ = "gistindex_keytest" i = __errno_location = datum = isNull = test = recheck = de = datum = isNull = dist = recheck = de = #6 gistScanPage (scan=, pageItem=, myDistances=, tbm=0x0, ntids=0x0) at gistget.c:438 match = recheck = iid = 0x7fc6e7555620 it = 0x7fc6e7557458 recheck_distances = false so = giststate = 0x302c2c8 r = 0x7fae8567e6d0 buffer = 12649724 page = 0x7fc6e7555600 "\237=\003" opaque = maxoff = 5 i = 3 oldcxt = 0x2ececc0 #7 0x0000000000513f13 in gistgettuple (scan=0x3136b28, dir=) 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=) at indexam.c:533 found = __func__ = "index_getnext_tid" __errno_location = #9 0x000000000053f0bb in index_getnext_slot (scan=scan@entry=0x3136b28, direction=direction@entry=ForwardScanDirection, slot=slot@entry=0x2fff138) at indexam.c:625 tid = #10 0x0000000000681658 in IndexNext (node=node@entry=0x2ffee98) at nodeIndexscan.c:133 estate = econtext = 0x2fff0a8 direction = ForwardScanDirection scandesc = 0x3136b28 slot = 0x2fff138 #11 0x00000000006691a7 in ExecScanFetch (recheckMtd=0x681e40 , accessMtd=0x681600 , node=0x2ffee98) at execScan.c:133 estate = 0x2ecedd8 estate = epqstate = scanrelid = slot = slot = slot = slot = #12 ExecScan (node=0x2ffee98, accessMtd=0x681600 , recheckMtd=0x681e40 ) at execScan.c:199 slot = 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 = innerTupleSlot = joinqual = 0x3132ab8 otherqual = 0x0 econtext = 0x2ecfd60 lc = #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 = #17 0x0000000000672910 in agg_fill_hash_table (aggstate=0x2ecf628) at nodeAgg.c:2551 outerslot = tmpcontext = 0x2ecf088 outerslot = tmpcontext = #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=) at nodeModifyTable.c:2425 node = estate = 0x2ecedd8 operation = resultRelInfo = 0x2ecf328 subplanstate = slot = planSlot = oldSlot = tupleid = 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 = proute = 0x0 relinfos = 0x0 lc = __func__ = "ExecModifyTable" #21 0x0000000000660bfb in ExecProcNode (node=0x2ecf118) at ../../../src/include/executor/executor.h:257 No locals. #22 ExecutePlan (execute_once=, dest=0xa17e60 , direction=, numberTuples=0, sendTuples=, operation=CMD_INSERT, use_parallel_mode=, planstate=0x2ecf118, estate=0x2ecedd8) at execMain.c:1551 slot = current_tuple_count = 0 slot = current_tuple_count = #23 standard_ExecutorRun (queryDesc=0x312fe50, direction=, count=0, execute_once=) at execMain.c:361 estate = 0x2ecedd8 operation = CMD_INSERT dest = 0xa17e60 sendTuples = oldcontext = 0x2eacde0 __func__ = "standard_ExecutorRun" #24 0x00007fcf408995d5 in explain_ExecutorRun (queryDesc=0x312fe50, direction=ForwardScanDirection, count=0, execute_once=) 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=) 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 = eflags = res = 7 operation = eflags = res = __func__ = "_SPI_pquery" __errno_location = #27 _SPI_execute_plan (plan=, options=0x7ffc2f947a70, snapshot=, crosscheck_snapshot=, fire_triggers=) at spi.c:2580 qdesc = 0x312fe50 snap = 0x2dc2218 stmt = canSetTag = true dest = lc2__state = {l = 0x2ddc308, i = 0} plansource = stmt_list = 0x2ddc308 lc2 = lc1__state = my_res = 0 my_processed = 0 my_tuptable = 0x0 res = pushed_active_snap = plan_owner = 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 = lc1 = __func__ = "_SPI_execute_plan" #28 0x000000000069861a in SPI_execute_plan_with_paramlist (plan=0x2fefac8, params=0x0, read_only=, 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 = tcount = 0 rc = 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 = s__state = {l = , i = 8} save_estmt = s = __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 = __func__ = "exec_stmt_block" #32 0x00007fae853e649b in exec_toplevel_block (estate=estate@entry=0x7ffc2f947f00, block=0x2e92d10) at pl_exec.c:1608 rc = #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=) 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 , arg = 0x7ffc2f947f00} i = rc = __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=, expectedDesc=0x2e5f430, randomAccess=false) at execSRF.c:234 result = 140528172503896 tupstore = 0x0 tupdesc = 0x0 funcrettype = 2249 returnsTuple = 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 = direction = ForwardScanDirection scanslot = 0x2e2f428 alldone = oldpos = funcno = att = #37 0x00000000006691a7 in ExecScanFetch (recheckMtd=0x6787a0 , accessMtd=0x6787c0 , node=0x2e272d8) at execScan.c:133 estate = 0x2e2efb8 estate = epqstate = scanrelid = slot = slot = slot = slot = #38 ExecScan (node=0x2e272d8, accessMtd=0x6787c0 , recheckMtd=0x6787a0 ) at execScan.c:199 slot = 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 = #41 0x0000000000672910 in agg_fill_hash_table (aggstate=0x2e28e08) at nodeAgg.c:2551 outerslot = tmpcontext = 0x2e30d38 outerslot = tmpcontext = #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=, dest=0x2e46af8, direction=, numberTuples=0, sendTuples=, operation=CMD_SELECT, use_parallel_mode=, planstate=0x2e2f218, estate=0x2e2efb8) at execMain.c:1551 slot = current_tuple_count = 26023 slot = current_tuple_count = #47 standard_ExecutorRun (queryDesc=0x2e26b98, direction=, count=0, execute_once=) at execMain.c:361 estate = 0x2e2efb8 operation = CMD_SELECT dest = 0x2e46af8 sendTuples = oldcontext = 0x2e26a80 __func__ = "standard_ExecutorRun" #48 0x00007fcf408995d5 in explain_ExecutorRun (queryDesc=0x2e26b98, direction=ForwardScanDirection, count=0, execute_once=) 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=) 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=, count=0, dest=) at pquery.c:921 queryDesc = 0x2e26b98 direction = nprocessed = __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 = result = nprocessed = 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 = per_parsetree_context = 0x0 plantree_list = parsetree = 0x2d1ecc0 commandTag = qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} querytree_list = portal = 0x2dabec8 receiver = 0x2e46af8 format = 0 parsetree_item__state = {l = 0x2d1ecf0, i = 0} dest = DestRemote oldcontext = 0x2dc1fc0 parsetree_list = 0x2d1ecf0 parsetree_item = save_log_statement_stats = false was_logged = false use_implicit_block = false msec_str = '\000' , "\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=, username=) at postgres.c:4486 query_string = 0x2d1dc98 "SELECT \n \"SubdivisionId\",\n \"UserId\",\n \"UserLogin\"\nFROM \n powerbi.\"GetReportRights1002_VIEW\" ;" firstchar = 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=, port=) at postmaster.c:4530 av = {0x9100e4 "postgres", 0x0} ac = 1 av = ac = #55 BackendStartup (port=) at postmaster.c:4252 bn = 0x2d50890 pid = 0 bn = pid = __func__ = "BackendStartup" __errno_location = __errno_location = save_errno = __errno_location = __errno_location = #56 ServerLoop () at postmaster.c:1745 port = i = rmask = {fds_bits = {64, 0 }} selres = now = readmask = {fds_bits = {448, 0 }} nSockets = 9 last_lockfile_recheck_time = last_touch_time = 1648961554 __func__ = "ServerLoop" #57 0x0000000000740e48 in PostmasterMain (argc=argc@entry=3, argv=argv@entry=0x2d17430) at postmaster.c:1417 opt = status = userDoption = listen_addr_saved = true i = output_config_variable = __func__ = "PostmasterMain" #58 0x00000000004ec342 in main (argc=3, argv=0x2d17430) at main.c:209 No locals.