backtrace.txt

text/plain

Filename: backtrace.txt
Type: text/plain
Part: 1
Message: infinite loop in parallel hash joins / DSA / get_best_segment
#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 <ParallelQueryMain>
        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 <ParallelWorkerMain>
        __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 <signal handler called>
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 = <optimized out>
#28 0x0000560c01db61e0 in ServerLoop () at postmaster.c:1670
        timeout = {tv_sec = 59, tv_usec = 969436}
        rmask = {fds_bits = {56, 0 <repeats 15 times>}}
        selres = 1
        now = 1537135503
        readmask = {fds_bits = {56, 0 <repeats 15 times>}}
        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