#0 0x0000560c01ffe642 in get_segment_by_index (area=0x560c03626e58, index=3) at dsa.c:1716 __func__ = "get_segment_by_index" #1 0x0000560c01ffee4d in get_best_segment (area=0x560c03626e58, npages=8) at dsa.c:2002 next = 0x560c03626ee0 new_bin = 0 segment_map = 0x560c03626ee0 next_segment_index = 3 contiguous_pages = 0 threshold = 128 segment_index = 3 bin = 8 #2 0x0000560c01ffc889 in dsa_allocate_extended (area=0x560c03626e58, size=32768, flags=0) at dsa.c:700 npages = 8 first_page = 140725227103296 span_pointer = 16492677255560 pool = 0x7fcb1ba76010 size_class = 28672 start_pointer = 1974272 segment_map = 0x100560c01e3ff9f result = 2377900603788492800 __func__ = "dsa_allocate_extended" #3 0x0000560c01c9efd6 in ExecParallelHashTupleAlloc (hashtable=0x7fcb1ba06078, size=40, shared=0x7ffd252c2510) at nodeHash.c:2837 pstate = 0x7fcb1ba74e20 chunk_shared = 140510291828680 chunk = 0x7fcb1a07a000 chunk_size = 32768 result = 0x20000040000 curbatch = 33 #4 0x0000560c01c9d53b in ExecParallelHashTableInsertCurrentBatch (hashtable=0x7fcb1ba06078, slot=0x7fcb1ba040b8, hashvalue=3364144574) at nodeHash.c:1747 tuple = 0x560c03768918 hashTuple = 0x7fcb1ba040b8 shared = 3298536890312 batchno = 33 bucketno = 50622 #5 0x0000560c01ca1a00 in ExecParallelHashJoinNewBatch (hjstate=0x560c03631cb8) at nodeHashjoin.c:1153 inner_tuples = 0x560c0373dc98 batch_barrier = 0x7fcb1ad52498 hashvalue = 3364144574 tuple = 0x560c03768918 slot = 0x7fcb1ba040b8 hashtable = 0x7fcb1ba06078 start_batchno = 33 batchno = 33 __func__ = "ExecParallelHashJoinNewBatch" #6 0x0000560c01ca0a0c in ExecHashJoinImpl (pstate=0x560c03631cb8, parallel=true) at nodeHashjoin.c:534 node = 0x560c03631cb8 outerNode = 0x560c03631750 hashNode = 0x560c03632cf8 joinqual = 0x0 otherqual = 0x0 econtext = 0x560c03631ec8 hashtable = 0x7fcb1ba06078 outerTupleSlot = 0x0 hashvalue = 623650368 batchno = 32765 parallel_state = 0x7fcb1ba74e20 __func__ = "ExecHashJoinImpl" #7 0x0000560c01ca0ae9 in ExecParallelHashJoin (pstate=0x560c03631cb8) at nodeHashjoin.c:581 No locals. #8 0x0000560c01cb36a1 in ExecProcNode (node=0x560c03631cb8) at ../../../src/include/executor/executor.h:237 No locals. #9 0x0000560c01cb37db in ExecSort (pstate=0x560c03631890) at nodeSort.c:107 plannode = 0x560c035a5c60 outerNode = 0x560c03631cb8 tupDesc = 0x7fcb1ba04168 node = 0x560c03631890 estate = 0x560c03630f90 dir = ForwardScanDirection tuplesortstate = 0x560c037185c0 slot = 0x7fcb1ba04278 #10 0x0000560c01c84b23 in ExecProcNodeFirst (node=0x560c03631890) at execProcnode.c:445 No locals. #11 0x0000560c01c8fd46 in ExecProcNode (node=0x560c03631890) at ../../../src/include/executor/executor.h:237 No locals. #12 0x0000560c01c901a9 in fetch_input_tuple (aggstate=0x560c036319a0) at nodeAgg.c:406 slot = 0x560c036316c0 #13 0x0000560c01c92431 in agg_retrieve_direct (aggstate=0x560c036319a0) at nodeAgg.c:1736 node = 0x560c035a59d0 econtext = 0x560c03631c08 tmpcontext = 0x560c03631630 peragg = 0x7fcb1ba06878 pergroups = 0x7fcb1ba084d0 outerslot = 0x7ffd252c27e0 firstSlot = 0x7fcb1ba05e68 result = 0x0 hasGroupingSets = false numGroupingSets = 1 currentSet = 32765 nextSetSize = 0 numReset = 1 i = 1 #14 0x0000560c01c92087 in ExecAgg (pstate=0x560c036319a0) at nodeAgg.c:1551 node = 0x560c036319a0 result = 0x0 #15 0x0000560c01c84b23 in ExecProcNodeFirst (node=0x560c036319a0) at execProcnode.c:445 No locals. #16 0x0000560c01c7a117 in ExecProcNode (node=0x560c036319a0) at ../../../src/include/executor/executor.h:237 No locals. #17 0x0000560c01c7c73f in ExecutePlan (estate=0x560c03630f90, planstate=0x560c036319a0, use_parallel_mode=false, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x560c035a5870, execute_once=true) at execMain.c:1721 slot = 0x7ffd252c28a0 current_tuple_count = 0 #18 0x0000560c01c7a612 in standard_ExecutorRun (queryDesc=0x560c03624cf8, direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:362 estate = 0x560c03630f90 operation = CMD_SELECT dest = 0x560c035a5870 sendTuples = true oldcontext = 0x560c035a5260 __func__ = "standard_ExecutorRun" #19 0x0000560c01c7a4a9 in ExecutorRun (queryDesc=0x560c03624cf8, direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:305 No locals. #20 0x0000560c01c815bb in ParallelQueryMain (seg=0x560c0353b578, toc=0x7fcb1ba72000) at execParallel.c:1322 fpes = 0x7fcb1baf4d00 buffer_usage = 0x7fcb1bb0cd40 receiver = 0x560c035a5870 queryDesc = 0x560c03624cf8 instrumentation = 0x0 instrument_options = 0 area_space = 0x7fcb1ba74f20 area = 0x560c03626e58 pwcxt = {seg = 0x560c0353b578, toc = 0x7fcb1ba72000} #21 0x0000560c01ad5395 in ParallelWorkerMain (main_arg=304158916) at parallel.c:1398 seg = 0x560c0353b578 toc = 0x7fcb1ba72000 fps = 0x7fcb1bb0d460 error_queue_space = 0x7fcb1baf4d40 "" mq = 0x7fcb1bb00d40 mqh = 0x560c03542f60 libraryspace = 0x7fcb1bb0d440 "" entrypointstate = 0x7fcb1baf4d20 "postgres" library_name = 0x7fcb1baf4d20 "postgres" function_name = 0x7fcb1baf4d29 "ParallelQueryMain" entrypt = 0x560c01c813ce gucspace = 0x7fcb1bb0ce40 "\304\005" combocidspace = 0x7fcb1bb0ce20 "" tsnapspace = 0x7fcb1bb0cde0 "\367\005" asnapspace = 0x7fcb1bb0cda0 "\367\005" tstatespace = 0x7fcb1bb0cd60 "\001" reindexspace = 0x7fcb1bb0cd40 "" msgbuf = {data = 0x0, len = 8, maxlen = 1024, cursor = 75} session_dsm_handle_space = 0x7fcb1bb0cd80 "(\024}\f" __func__ = "ParallelWorkerMain" #22 0x0000560c01da7921 in StartBackgroundWorker () at bgworker.c:834 local_sigjmp_buf = {{__jmpbuf = {0, 4685308575649678302, 94609573359424, 140725227107728, 0, 0, 4685308575620318174, 1362275939243967454}, __mask_was_saved = 1, __saved_mask = {__val = {18446744066192964103, 94609595390144, 94609595245520, 140725227105120, 94609573132398, 140725227105088, 94609595245520, 1024, 94609595245736, 94609595245520, 94609595245520, 94609578233056, 94609595224272, 140725227105152, 94609573163167, 0}}}} worker = 0x560c0350d9e0 entrypt = 0x560c01ad4de6 __func__ = "StartBackgroundWorker" #23 0x0000560c01dbb63d in do_start_bgworker (rw=0x560c03533780) at postmaster.c:5698 worker_pid = 0 __func__ = "do_start_bgworker" #24 0x0000560c01dbb9e8 in maybe_start_bgworkers () at postmaster.c:5911 rw = 0x560c03533780 num_launched = 2 now = 0 iter = {cur = 0x560c035339c0, next = 0x560c03533c10, prev = 0x560c03536bc0} #25 0x0000560c01dba927 in sigusr1_handler (postgres_signal_arg=10) at postmaster.c:5091 save_errno = 4 __func__ = "sigusr1_handler" #26 No locals. #27 0x00007fcb5ee44a8e in __GI___select (nfds=6, readfds=0x7ffd252c3310, writefds=0x0, exceptfds=0x0, timeout=0x7ffd252c3280) at ../sysdeps/unix/sysv/linux/select.c:41 resultvar = 18446744073709551612 sc_ret = #28 0x0000560c01db61e0 in ServerLoop () at postmaster.c:1670 timeout = {tv_sec = 59, tv_usec = 969436} rmask = {fds_bits = {56, 0 }} selres = 1 now = 1537135503 readmask = {fds_bits = {56, 0 }} nSockets = 6 last_lockfile_recheck_time = 1537135457 last_touch_time = 1537135157 __func__ = "ServerLoop" #29 0x0000560c01db5b0a in PostmasterMain (argc=3, argv=0x560c0350d020) at postmaster.c:1379 opt = -1 status = 0 userDoption = 0x560c0352eea0 "/mnt/raid/data" listen_addr_saved = true i = 64 output_config_variable = 0x0 __func__ = "PostmasterMain" #30 0x0000560c01ce10f3 in main (argc=3, argv=0x560c0350d020) at main.c:228 do_check_root = true