Skip to content

Instantly share code, notes, and snippets.

@ValentinChirikov

ValentinChirikov/gist:84859eb5a54963eaafdcbd88e0556b9d

Created June 29, 2020 12:56
Show Gist options
  • Save ValentinChirikov/84859eb5a54963eaafdcbd88e0556b9d to your computer and use it in GitHub Desktop.
Save ValentinChirikov/84859eb5a54963eaafdcbd88e0556b9d to your computer and use it in GitHub Desktop.
Download ZIP
Full bt
Raw
gistfile1.txt
#0 0x00007f4ed37daeb3 in epoll_wait () from /lib64/libc.so.6
No symbol table info available.
#1 0x00000000007259fe in WaitEventSetWaitBlock (nevents=1, occurred_events=0x7ffc785dfa40, cur_timeout=-1, set=0x133a4f8) at latch.c:1048
returned_events = 0
cur_event = <optimized out>
rc = <optimized out>
cur_epoll_event = <optimized out>
#2 WaitEventSetWait (set=set@entry=0x133a4f8, timeout=timeout@entry=-1, occurred_events=occurred_events@entry=0x7ffc785dfa40, nevents=nevents@entry=1, wait_event_info=wait_event_info@entry=134217731) at latch.c:1000
returned_events = 0
start_time = {tv_sec = 1, tv_nsec = 1}
cur_time = {tv_sec = 1, tv_nsec = 152}
cur_timeout = -1
#3 0x0000000000725e5b in WaitLatchOrSocket (latch=0x7ed0c42710d4, wakeEvents=wakeEvents@entry=1, sock=sock@entry=-1, timeout=-1, timeout@entry=0, wait_event_info=wait_event_info@entry=134217731) at latch.c:385
ret = 0
rc = <optimized out>
event = {pos = 0, events = 0, fd = 19271192, user_data = 0x0}
set = 0x133a4f8
#4 0x0000000000725f10 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=1, timeout=timeout@entry=0, wait_event_info=wait_event_info@entry=134217731) at latch.c:339
No locals.
#5 0x000000000061b3ca in gather_readnext (gatherstate=<optimized out>) at nodeGather.c:367
reader = <optimized out>
tup = <optimized out>
readerdone = false
nvisited = <optimized out>
#6 gather_getnext (gatherstate=0x1260c58) at nodeGather.c:256
outerPlan = 0x1260e18
fslot = 0x1256fc8
#7 ExecGather (pstate=0x1260c58) at nodeGather.c:207
node = 0x1260c58
econtext = 0x1260d68
#8 0x000000000060c8f8 in ExecProcNodeInstr (node=0x1260c58) at execProcnode.c:461
result = <optimized out>
#9 0x00000000006145f9 in ExecProcNode (node=0x1260c58) at ../../../src/include/executor/executor.h:247
No locals.
#10 fetch_input_tuple (aggstate=aggstate@entry=0x12607f0) at nodeAgg.c:407
slot = <optimized out>
#11 0x0000000000615fd0 in agg_retrieve_direct (aggstate=0x12607f0) at nodeAgg.c:1746
econtext = 0x1260ba8
firstSlot = 0x1257288
numGroupingSets = 1
node = 0x1296ab0
tmpcontext = 0x1260a18
peragg = 0x1257ad8
outerslot = <optimized out>
nextSetSize = <optimized out>
pergroups = 0x1258b78
result = <optimized out>
hasGroupingSets = false
currentSet = <optimized out>
numReset = 1
i = <optimized out>
#12 ExecAgg (pstate=0x12607f0) at nodeAgg.c:1561
node = 0x12607f0
result = 0x0
#13 0x000000000060c8f8 in ExecProcNodeInstr (node=0x12607f0) at execProcnode.c:461
result = <optimized out>
#14 0x0000000000605dca in ExecProcNode (node=0x12607f0) at ../../../src/include/executor/executor.h:247
No locals.
#15 ExecutePlan (execute_once=<optimized out>, dest=0xcf4380 <donothingDR>, direction=<optimized out>, numberTuples=0, sendTuples=true, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x12607f0, estate=0x12605b0)
at execMain.c:1723
slot = <optimized out>
current_tuple_count = 0
#16 standard_ExecutorRun (queryDesc=0x1310848, direction=<optimized out>, count=0, execute_once=<optimized out>) at execMain.c:364
estate = 0x12605b0
operation = CMD_SELECT
dest = 0xcf4380 <donothingDR>
sendTuples = <optimized out>
oldcontext = 0x12527c0
__func__ = "standard_ExecutorRun"
#17 0x00000000005a5d8c in ExplainOnePlan (plannedstmt=plannedstmt@entry=0x1310738, into=into@entry=0x0, es=es@entry=0x129ff70,
queryString=queryString@entry=0x12528d0 "explain analyze verbose\r\nselect\r\n sum(t1._fld1184 / T3._Fld898)\r\nfrom _accumrg1162_y2020_m03 T1\r\nLEFT OUTER JOIN _InfoRg896 T3\r\n ON (('\\\\200\\\\337\\\\014\\\\304z4\\\\233\\\\341\\\\021\\\\346H\\\\306\\\\210\\\\"..., params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, planduration=planduration@entry=0x7ffc785dfd10) at explain.c:536
dir = <optimized out>
dest = <optimized out>
queryDesc = 0x1310848
starttime = {tv_sec = 428944, tv_nsec = 859426791}
totaltime = 0
eflags = <optimized out>
instrument_option = <optimized out>
#18 0x00000000005a6097 in ExplainOneQuery (query=<optimized out>, cursorOptions=<optimized out>, into=0x0, es=0x129ff70,
queryString=0x12528d0 "explain analyze verbose\r\nselect\r\n sum(t1._fld1184 / T3._Fld898)\r\nfrom _accumrg1162_y2020_m03 T1\r\nLEFT OUTER JOIN _InfoRg896 T3\r\n ON (('\\\\200\\\\337\\\\014\\\\304z4\\\\233\\\\341\\\\021\\\\346H\\\\306\\\\210\\\\"..., params=0x0, queryEnv=0x0) at explain.c:372
plan = 0x1310738
planstart = {tv_sec = 428944, tv_nsec = 858595524}
planduration = {tv_sec = 0, tv_nsec = 830777}
params = 0x0
queryString = 0x12528d0 "explain analyze verbose\r\nselect\r\n sum(t1._fld1184 / T3._Fld898)\r\nfrom _accumrg1162_y2020_m03 T1\r\nLEFT OUTER JOIN _InfoRg896 T3\r\n ON (('\\\\200\\\\337\\\\014\\\\304z4\\\\233\\\\341\\\\021\\\\346H\\\\306\\\\210\\\\"...
es = 0x129ff70
into = 0x0
queryEnv = 0x0
cursorOptions = <optimized out>
query = <optimized out>
#19 0x00000000005a6584 in ExplainQuery (pstate=pstate@entry=0x129fe60, stmt=stmt@entry=0x11993d8,
queryString=queryString@entry=0x12528d0 "explain analyze verbose\r\nselect\r\n sum(t1._fld1184 / T3._Fld898)\r\nfrom _accumrg1162_y2020_m03 T1\r\nLEFT OUTER JOIN _InfoRg896 T3\r\n ON (('\\\\200\\\\337\\\\014\\\\304z4\\\\233\\\\341\\\\021\\\\346H\\\\306\\\\210\\\\"..., params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=dest@entry=0x1252ae0) at explain.c:255
l = 0x1287f90
es = 0x129ff70
tstate = <optimized out>
rewritten = <optimized out>
lc = <optimized out>
timing_set = <optimized out>
summary_set = <optimized out>
__func__ = "ExplainQuery"
#20 0x000000000074b46d in standard_ProcessUtility (pstmt=0x11992c8,
queryString=0x12528d0 "explain analyze verbose\r\nselect\r\n sum(t1._fld1184 / T3._Fld898)\r\nfrom _accumrg1162_y2020_m03 T1\r\nLEFT OUTER JOIN _InfoRg896 T3\r\n ON (('\\\\200\\\\337\\\\014\\\\304z4\\\\233\\\\341\\\\021\\\\346H\\\\306\\\\210\\\\"..., context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x1252ae0, completionTag=0x7ffc785dff70 "") at utility.c:675
parsetree = 0x11993d8
isTopLevel = true
isAtomicContext = false
pstate = 0x129fe60
__func__ = "standard_ProcessUtility"
#21 0x00007f4ec70ba795 in onlineAnalyzeHookerUtility (pstmt=0x11992c8,
queryString=0x12528d0 "explain analyze verbose\r\nselect\r\n sum(t1._fld1184 / T3._Fld898)\r\nfrom _accumrg1162_y2020_m03 T1\r\nLEFT OUTER JOIN _InfoRg896 T3\r\n ON (('\\\\200\\\\337\\\\014\\\\304z4\\\\233\\\\341\\\\021\\\\346H\\\\306\\\\210\\\\"..., context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=<optimized out>, dest=<optimized out>, completionTag=0x7ffc785dff70 "") at online_analyze.c:913
tblnames = 0x0
op = CK_INSERT
parsetree = <optimized out>
#22 0x0000000000748916 in PortalRunUtility (portal=0x11debc0, pstmt=0x11992c8, isTopLevel=<optimized out>, setHoldSnapshot=<optimized out>, dest=0x1252ae0, completionTag=0x7ffc785dff70 "") at pquery.c:1178
utilityStmt = <optimized out>
snapshot = 0x11963b0
#23 0x0000000000749652 in FillPortalStore (portal=portal@entry=0x11debc0, isTopLevel=isTopLevel@entry=true) at pquery.c:1038
treceiver = 0x1252ae0
completionTag = "\000\377\377\377\000\000\000\000\360\265\364\325N\177\000\000\270\265#\001\000\000\000\000\365\273\207\000\000\000\000\000\070\375)\001\000\000\000\000\360\265\364\325N\177\000\000\a\000\000\000\000\000\000\000\227\225\203\000\000\000\000"
__func__ = "FillPortalStore"
#24 0x000000000074a0df in PortalRun (portal=<optimized out>, count=2000, isTopLevel=<optimized out>, run_once=<optimized out>, dest=0x1126ae0, altdest=0x1126ae0, completionTag=0x7ffc785e0390 "") at pquery.c:768
save_exception_stack = 0x7ffc785e02a0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {0, 1300979453110099545, 17984224, 10030162, 18738112, 18738112, -1299586114352996775, 1300978451542941273}, __mask_was_saved = 0, __saved_mask = {__val = {8765264, 64, 17983184, 0,
139435109403128, 2, 262, 19212496, 8440174, 1593434716, 112, 2000, 17982912, 10030162, 8883934, 3}}}}
result = <optimized out>
nprocessed = <optimized out>
saveTopTransactionResourceOwner = 0x11a5b48
saveTopTransactionContext = 0x1196270
saveActivePortal = 0x0
saveResourceOwner = 0x11a5b48
savePortalContext = 0x0
saveMemoryContext = 0x11265c0
__func__ = "PortalRun"
#25 0x00000000007479ad in PostgresMain (argc=<optimized out>, argv=<optimized out>, dbname=<optimized out>, username=<optimized out>) at postgres.c:2036
firstchar = 3
input_message = {data = 0x11266d0 "", len = 5, maxlen = 1024, cursor = 5}
local_sigjmp_buf = {{__jmpbuf = {18465528, 1300979453284294233, 18433552, 0, 0, 18360752, -1299586084342751655, 1300978457811066457}, __mask_was_saved = 1, __saved_mask = {__val = {0, 18360752, 139976532499752, 8589934592,
206158430256, 140722327913464, 140722327913248, 0, 459561508864, 0, 4, 0, 18098912, 0, 18433552, 0}}}}
send_ready_for_query = false
disable_idle_in_transaction_timeout = <optimized out>
__func__ = "PostgresMain"
#26 0x00000000004807f6 in BackendRun (port=0x1194610) at postmaster.c:4364
ac = 1
secs = 646749683
usecs = 195624
i = 1
av = 0x119c550
maxac = <optimized out>
#27 BackendStartup (port=0x1194610) at postmaster.c:4036
bn = 0x11829b0
pid = 0
#28 ServerLoop () at postmaster.c:1707
rmask = {fds_bits = {32, 0 <repeats 15 times>}}
selres = <optimized out>
now = <optimized out>
readmask = {fds_bits = {240, 0 <repeats 15 times>}}
last_lockfile_recheck_time = <optimized out>
last_touch_time = 1593431929
__func__ = "ServerLoop"
#29 0x00000000006d9fd9 in PostmasterMain (argc=argc@entry=3, argv=argv@entry=0x1121270) at postmaster.c:1380
opt = <optimized out>
status = <optimized out>
userDoption = <optimized out>
listen_addr_saved = true
i = <optimized out>
output_config_variable = <optimized out>
__func__ = "PostmasterMain"
#30 0x000000000048167f in main (argc=3, argv=0x1121270) at main.c:228
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment