merge2.stacktrace.txt

text/plain

Filename: merge2.stacktrace.txt
Type: text/plain
Part: 3
Message: Re: support for MERGE
#0  pg_detoast_datum_packed (datum=0x0) at fmgr.c:1756
No locals.
#1  0x000055b83f8609e3 in bpcharcmp (fcinfo=0x7ffd6bf31c40) at varchar.c:905
        arg1 = 0x55b840a95130
        arg2 = <optimized out>
        len1 = <optimized out>
        len2 = <optimized out>
        cmp = <optimized out>
#2  0x000055b83f895893 in FunctionCall2Coll (flinfo=flinfo@entry=0x55b840ad2338, collation=<optimized out>, arg1=<optimized out>, arg2=arg2@entry=0) at fmgr.c:1160
        fcinfodata = {fcinfo = {flinfo = 0x55b840ad2338, context = 0x0, resultinfo = 0x0, fncollation = 100, isnull = false, nargs = 2, args = 0x7ffd6bf31c60}, 
          fcinfo_data = "8#\255@\270U", '\000' <repeats 18 times>, "d\000\000\000\000U\002\000\060Q\251@\270U\000\000\000u`?\270U", '\000' <repeats 11 times>, "\004\260@\270U\000"}
        fcinfo = 0x7ffd6bf31c40
        result = <optimized out>
        __func__ = "FunctionCall2Coll"
#3  0x000055b83f698fca in partition_list_bsearch (partsupfunc=0x55b840ad2338, partcollation=0x55b840ad2390, boundinfo=boundinfo@entry=0x55b840a95098, value=0, is_equal=is_equal@entry=0x7ffd6bf31d0f)
    at partbounds.c:3638
        cmpval = <optimized out>
        lo = -1
        hi = 0
        mid = 0
#4  0x000055b83f59a6f6 in get_partition_for_tuple (pd=pd@entry=0x55b840b1a4d8, values=values@entry=0x7ffd6bf31db0, isnull=isnull@entry=0x7ffd6bf31d90) at execPartition.c:1372
        equal = false
        bound_offset = <optimized out>
        part_index = -1
        key = 0x55b840ad2240
        partdesc = <optimized out>
        boundinfo = 0x55b840a95098
        __func__ = "get_partition_for_tuple"
#5  0x000055b83f59bef5 in ExecFindPartition (mtstate=mtstate@entry=0x55b840affaa8, rootResultRelInfo=rootResultRelInfo@entry=0x55b840affed8, proute=0x55b840b1a448, slot=slot@entry=0x55b840b1a3b0, 
    estate=estate@entry=0x55b840aff800) at execPartition.c:314
        partidx = -1
        is_leaf = <optimized out>
        pd = 0x55b840b1a530
        values = {0, 94249823350511, 94249847625024, 94249847666560, 140726414548480, 15, 94249847729120, 94249847729116, 94249847692344, 94249847692304, 94249847691184, 21474836511, 16, 94249847729119, 
          94249847692344, 4, 94249847624984, 94249847617248, 140446491906016, 94249847618216, 140726414548608, 94249828466970, 94249847729119, 2, 94249847624984, 5, 140726414548640, 94249822988364, 
          94249847618752, 140446491906016, 140726414548752, 94249822989220}
        isnull = {false, 29, 243, 107, 253, 127, false, false, 67, 32, 90, 63, 184, 85, false, false, 88, 22, 176, 64, 184, 85, false, false, 8, 172, 177, 64, 184, 85, false, false}
        rel = 0x7fbc3f419f78
        dispatch = 0x55b840b1a4d8
        partdesc = 0x55b840a95060
        ecxt = 0x55b840b1b158
        ecxt_scantuple_saved = 0x0
        rootslot = 0x55b840b1a3b0
        myslot = 0x0
        oldcxt = 0x55b840aff6e0
        rri = 0x0
        __func__ = "ExecFindPartition"
#6  0x000055b83f5c7f2d in ExecPrepareTupleRouting (mtstate=mtstate@entry=0x55b840affaa8, estate=estate@entry=0x55b840aff800, proute=<optimized out>, targetRelInfo=targetRelInfo@entry=0x55b840affed8, 
    slot=slot@entry=0x55b840b1a3b0, partRelInfo=partRelInfo@entry=0x7ffd6bf31f58) at nodeModifyTable.c:2426
        partrel = <optimized out>
        map = <optimized out>
#7  0x000055b83f5c7ffc in ExecInsert (mtstate=mtstate@entry=0x55b840affaa8, resultRelInfo=resultRelInfo@entry=0x55b840affed8, slot=slot@entry=0x55b840b1a3b0, planSlot=planSlot@entry=0x55b840b15400, 
    estate=estate@entry=0x55b840aff800, actionState=actionState@entry=0x55b840b19a70, canSetTag=true) at nodeModifyTable.c:614
        partRelInfo = 0x55b840affcc0
        resultRelationDesc = <optimized out>
        recheckIndexes = 0x0
        result = 0x0
        ar_insert_trig_tcs = <optimized out>
        node = <optimized out>
        onconflict = ONCONFLICT_NONE
        proute = <optimized out>
        oldContext = <optimized out>
#8  0x000055b83f597fdc in ExecMergeNotMatched (mtstate=mtstate@entry=0x55b840affaa8, resultRelInfo=0x55b840affed8, resultRelInfo@entry=0x55b840affcc0, estate=estate@entry=0x55b840aff800, 
    slot=slot@entry=0x55b840b15400) at execMerge.c:571
        action = 0x55b840b19a70
        commandType = <optimized out>
        l__state = <optimized out>
        econtext = <optimized out>
        rootRelInfo = 0x55b840affed8
        insert_slot = 0x55b840b1a3b0
        actionStates = <optimized out>
        l = <optimized out>
        __func__ = "ExecMergeNotMatched"
#9  0x000055b83f5981d1 in ExecMerge (mtstate=mtstate@entry=0x55b840affaa8, resultRelInfo=0x55b840affcc0, estate=estate@entry=0x55b840aff800, slot=slot@entry=0x55b840b15400) at execMerge.c:143
        econtext = <optimized out>
        tupleid = <optimized out>
        tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0}
        matched = <optimized out>
        datum = <optimized out>
        isNull = <optimized out>
#10 0x000055b83f5c9c03 in ExecModifyTable (pstate=0x55b840affaa8) at nodeModifyTable.c:2579
        datum = <optimized out>
        isNull = <optimized out>
        resultoid = <optimized out>
        node = 0x55b840affaa8
        estate = 0x55b840aff800
        operation = CMD_MERGE
        resultRelInfo = 0x55b840affcc0
        subplanstate = 0x55b840b001f8
        slot = 0x55b840b15400
        planSlot = 0x55b840b15400
        oldSlot = <optimized out>
        tupleid = <optimized out>
        tuple_ctid = {ip_blkid = {bi_hi = 16559, bi_lo = 21944}, ip_posid = 0}
        oldtupdata = {t_len = 1811095808, t_self = {ip_blkid = {bi_hi = 32765, bi_lo = 0}, ip_posid = 15546}, t_tableOid = 21944, t_data = 0x7ffd6bf32100}
        oldtuple = <optimized out>
        proute = 0x55b840b1a448
        relinfos = 0x0
        lc = <optimized out>
        __func__ = "ExecModifyTable"
#11 0x000055b83f59cbf7 in ExecProcNodeFirst (node=0x55b840affaa8) at execProcnode.c:463
No locals.
#12 0x000055b83f593a74 in ExecProcNode (node=0x55b840affaa8) at ../../../src/include/executor/executor.h:257
No locals.
#13 ExecutePlan (estate=estate@entry=0x55b840aff800, planstate=0x55b840affaa8, use_parallel_mode=<optimized out>, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=false, 
    numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x7fbc3f3e8348, execute_once=true) at execMain.c:1555
        slot = <optimized out>
        current_tuple_count = 0
#14 0x000055b83f594715 in standard_ExecutorRun (queryDesc=0x55b840aeb840, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at execMain.c:362
        estate = 0x55b840aff800
        operation = CMD_MERGE
        dest = 0x7fbc3f3e8348
        sendTuples = false
        oldcontext = 0x55b840aeb720
        __func__ = "standard_ExecutorRun"
#15 0x000055b83f5947de in ExecutorRun (queryDesc=queryDesc@entry=0x55b840aeb840, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at execMain.c:306
No locals.
#16 0x000055b83f756768 in ProcessQuery (plan=plan@entry=0x7fbc3f3e69a8, sourceText=<optimized out>, params=0x0, queryEnv=0x0, dest=dest@entry=0x7fbc3f3e8348, qc=qc@entry=0x7ffd6bf324a0) at pquery.c:160
        queryDesc = 0x55b840aeb840
#17 0x000055b83f757382 in PortalRunMulti (portal=portal@entry=0x55b840a6c8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x7fbc3f3e8348, 
    altdest=altdest@entry=0x7fbc3f3e8348, qc=qc@entry=0x7ffd6bf324a0) at pquery.c:1277
        pstmt = 0x7fbc3f3e69a8
        stmtlist_item__state = <optimized out>
        active_snapshot_set = true
        stmtlist_item = 0x7fbc3f3e8308
#18 0x000055b83f757914 in PortalRun (portal=portal@entry=0x55b840a6c8a0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x7fbc3f3e8348, 
    altdest=altdest@entry=0x7fbc3f3e8348, qc=0x7ffd6bf324a0) at pquery.c:791
        _save_exception_stack = 0x7ffd6bf32540
        _save_context_stack = 0x0
        _local_sigjmp_buf = {{__jmpbuf = {0, 6828001597788628319, 94249846584752, 94249847015584, 94249847015584, 140446491640648, 6828001597962691935, 741763848760436063}, __mask_was_saved = 0, 
            __saved_mask = {__val = {94249847027168, 140726414549968, 94249847023792, 94249830163381, 112, 94249846584752, 94249846577040, 0, 162, 140726414550032, 94249828466653, 1, 2, 94249846584752, 
                94249847015584, 140726414550064}}}}
        _do_rethrow = <optimized out>
        result = <optimized out>
        nprocessed = <optimized out>
        saveTopTransactionResourceOwner = 0x55b840a32110
        saveTopTransactionContext = 0x55b840a843c0
        saveActivePortal = 0x0
        saveResourceOwner = 0x55b840a32110
        savePortalContext = 0x0
        saveMemoryContext = 0x55b840a843c0
        __func__ = "PortalRun"
#19 0x000055b83f7539ef in exec_simple_query (
    query_string=query_string@entry=0x55b840a018b0 "MERGE INTO public.part_7 as target_0\nUSING public.tenk1 as ref_0\n  left join public.num_exp_ln as sample_0 \n  on (ref_0.twenty = sample_0.id )\nON target_0.a = sample_0.id \nWHEN MATCHED AND 41 is NULL\n"...) at postgres.c:1215
        snapshot_set = <optimized out>
        per_parsetree_context = 0x0
        plantree_list = 0x7fbc3f3e82f0
        parsetree = 0x55b840a035b0
        commandTag = <optimized out>
        qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0}
        querytree_list = <optimized out>
        portal = 0x55b840a6c8a0
        receiver = 0x7fbc3f3e8348
        format = 0
        parsetree_item__state = <optimized out>
        dest = DestRemote
        oldcontext = 0x55b840a843c0
        parsetree_list = 0x55b840a035e8
        parsetree_item = 0x55b840a03600
        save_log_statement_stats = false
        was_logged = false
        use_implicit_block = false
        msec_str = "\220\203\242@\270U\000\000\b\000\000\000\000\000\000\000\340$\363k\375\177\000\000?\"\212?\270U\000"
        __func__ = "exec_simple_query"
#20 0x000055b83f75594c in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4498
        query_string = 0x55b840a018b0 "MERGE INTO public.part_7 as target_0\nUSING public.tenk1 as ref_0\n  left join public.num_exp_ln as sample_0 \n  on (ref_0.twenty = sample_0.id )\nON target_0.a = sample_0.id \nWHEN MATCHED AND 41 is NULL\n"...
        firstchar = <optimized out>
        input_message = {
          data = 0x55b840a018b0 "MERGE INTO public.part_7 as target_0\nUSING public.tenk1 as ref_0\n  left join public.num_exp_ln as sample_0 \n  on (ref_0.twenty = sample_0.id )\nON target_0.a = sample_0.id \nWHEN MATCHED AND 41 is NULL\n"..., len = 309, maxlen = 1024, cursor = 309}
        local_sigjmp_buf = {{__jmpbuf = {140726414550304, 6828001597845251423, 2478168661, 94249846735760, 8, 94249846735760, 6828001597817988447, 741763847300162911}, __mask_was_saved = 1, __saved_mask = {
              __val = {4194304, 18446744073709551536, 15616, 94249846735760, 140446645740515, 0, 94249846550368, 140726414550544, 15616, 15680, 94249828434542, 0, 94249846550368, 15616, 94249846735760, 8}}}}
        send_ready_for_query = false
        idle_in_transaction_timeout_enabled = false
        idle_session_timeout_enabled = false
        __func__ = "PostgresMain"
#21 0x000055b83f6b1014 in BackendRun (port=port@entry=0x55b840a28390) at postmaster.c:4594
No locals.
#22 0x000055b83f6b41b6 in BackendStartup (port=port@entry=0x55b840a28390) at postmaster.c:4322
        bn = 0x55b840a25cf0
        pid = 0
        __func__ = "BackendStartup"
#23 0x000055b83f6b43d1 in ServerLoop () at postmaster.c:1802
        port = 0x55b840a28390
        i = 2
        rmask = {fds_bits = {128, 0 <repeats 15 times>}}
        selres = <optimized out>
        now = <optimized out>
        readmask = {fds_bits = {224, 0 <repeats 15 times>}}
        nSockets = 8
        last_lockfile_recheck_time = 1641966712
        last_touch_time = 1641966295
        __func__ = "ServerLoop"
#24 0x000055b83f6b5971 in PostmasterMain (argc=3, argv=<optimized out>) at postmaster.c:1474
        opt = <optimized out>
        status = <optimized out>
        userDoption = <optimized out>
        listen_addr_saved = true
        i = <optimized out>
        output_config_variable = <optimized out>
        __func__ = "PostmasterMain"
#25 0x000055b83f5f429b in main (argc=3, argv=0x55b8409faec0) at main.c:198
No locals.