[05:17:36.100] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [05:17:36.449] dumping /tmp/cores/postgres.6623.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [05:17:36.581] [New LWP 100138] [05:17:36.664] Core was generated by `postgres: postgres regression [local] MERGE'. [05:17:36.664] Program terminated with signal SIGABRT, Aborted. [05:17:36.664] Sent by thr_kill() from pid 6623 and user 1003. [05:17:36.664] #0 0x000000082e2d0dca in thr_kill () from /lib/libc.so.7 [05:17:37.209] [05:17:37.209] Thread 1 (LWP 100138): [05:17:37.209] #0 0x000000082e2d0dca in thr_kill () from /lib/libc.so.7 [05:17:37.209] No symbol table info available. [05:17:37.209] #1 0x000000082e2496f4 in raise () from /lib/libc.so.7 [05:17:37.209] No symbol table info available. [05:17:37.209] #2 0x000000082e2fabc9 in abort () from /lib/libc.so.7 [05:17:37.209] No symbol table info available. [05:17:37.209] #3 0x0000000000a1d197 in ExceptionalCondition (conditionName=, fileName=0x36c374 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [05:17:37.209] No locals. [05:17:37.209] #4 0x000000000070ef90 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82188ceb8, materialize=, shouldFree=shouldFree@entry=0x82188cd96) at ../src/backend/executor/execTuples.c:1649 [05:17:37.209] No locals. [05:17:37.209] #5 0x00000000006d6c28 in ExecIRDeleteTriggers (estate=estate@entry=0x838236100, relinfo=relinfo@entry=0x8382366b0, slot=slot@entry=0x82188ceb8) at ../src/backend/commands/trigger.c:2848 [05:17:37.209] trigger = [05:17:37.209] oldtuple = [05:17:37.209] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x836222d38, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:17:37.209] trigdesc = 0x8382368c0 [05:17:37.209] newtuple = 0x0 [05:17:37.209] i = 0 [05:17:37.209] should_free = false [05:17:37.209] #6 0x00000000007346b4 in ExecMergeMatched (context=0x82188cef0, resultRelInfo=0x8382366b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2980 [05:17:37.209] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:17:37.209] commandType = CMD_DELETE [05:17:37.209] result = TM_Ok [05:17:37.209] relaction = [05:17:37.209] l__state = {l = 0x838273ce8, i = 0} [05:17:37.209] mtstate = 0x8382364a0 [05:17:37.209] estate = 0x1872a [05:17:37.209] econtext = 0x8382734e8 [05:17:37.209] epqstate = 0x838236588 [05:17:37.209] l = [05:17:37.209] newslot = [05:17:37.209] isNull = [05:17:37.209] __error = [05:17:37.209] l__state = [05:17:37.209] updateCxt = [05:17:37.209] commandType = [05:17:37.209] result = [05:17:37.209] relaction = [05:17:37.209] __error = [05:17:37.209] resultRelationDesc = [05:17:37.209] lockmode = [05:17:37.209] inputslot = [05:17:37.209] epqslot = [05:17:37.209] __error = [05:17:37.209] __error = [05:17:37.209] __error = [05:17:37.209] __error = [05:17:37.209] __error = [05:17:37.209] __error = [05:17:37.209] __error = [05:17:37.209] #7 ExecMerge (context=context@entry=0x82188cef0, resultRelInfo=resultRelInfo@entry=0x8382366b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x82188ceb8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2777 [05:17:37.209] matched = [05:17:37.209] #8 0x0000000000733a67 in ExecModifyTable (pstate=0x8382364a0) at ../src/backend/executor/nodeModifyTable.c:3923 [05:17:37.209] context = {mtstate = 0x8382364a0, epqstate = 0x838236588, estate = 0x838236100, planSlot = 0x838272428, relaction = 0x838273728, tmfd = {ctid = {ip_blkid = {bi_hi = 24832, bi_lo = 14371}, ip_posid = 8}, xmax = 562614064, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [05:17:37.209] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [05:17:37.209] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8361e2118} [05:17:37.209] node = 0x8382364a0 [05:17:37.209] estate = 0x838236100 [05:17:37.209] operation = CMD_MERGE [05:17:37.209] resultRelInfo = 0x6 [05:17:37.209] subplanstate = 0x838237df0 [05:17:37.209] slot = 0x838272428 [05:17:37.209] tupleid = 0x0 [05:17:37.209] oldtuple = 0x82188ceb8 [05:17:37.209] oldSlot = [05:17:37.209] #9 0x000000000070920b in ExecProcNodeFirst (node=0x8382364a0) at ../src/backend/executor/execProcnode.c:464 [05:17:37.209] No locals. [05:17:37.209] #10 0x00000000007015fa in ExecProcNode (node=0x8382364a0) at ../src/include/executor/executor.h:274 [05:17:37.209] No locals. [05:17:37.209] #11 ExecutePlan (estate=0x838236100, planstate=0x8382364a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x8382990a0, execute_once=) at ../src/backend/executor/execMain.c:1647 [05:17:37.209] current_tuple_count = [05:17:37.209] slot = [05:17:37.209] #12 standard_ExecutorRun (queryDesc=0x83627cd00, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:366 [05:17:37.209] estate = 0x838236100 [05:17:37.209] oldcontext = 0x83627cc00 [05:17:37.209] operation = CMD_MERGE [05:17:37.209] dest = 0x8382990a0 [05:17:37.209] sendTuples = false [05:17:37.209] #13 0x00000000007014bf in ExecutorRun (queryDesc=0x1872a, queryDesc@entry=0x83627cd00, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:310 [05:17:37.209] No locals. [05:17:37.209] #14 0x00000000008cff1f in ProcessQuery (plan=0x838295228, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82188d1f0) at ../src/backend/tcop/pquery.c:160 [05:17:37.209] queryDesc = 0x83627cd00 [05:17:37.209] #15 0x00000000008cf4bd in PortalRunMulti (portal=portal@entry=0x8361af100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8382990a0, altdest=altdest@entry=0x8382990a0, qc=0x82188d1f0) at ../src/backend/tcop/pquery.c:1286 [05:17:37.209] pstmt = 0x838295228 [05:17:37.209] stmtlist_item__state = {l = 0x838299050, i = 0} [05:17:37.209] active_snapshot_set = true [05:17:37.209] stmtlist_item = 0x838299068 [05:17:37.209] #16 0x00000000008ced2b in PortalRun (portal=portal@entry=0x8361af100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82e2d0daa , dest@entry=0x8382990a0, altdest=0x0, altdest@entry=0x8382990a0, qc=0x82188d1f0) at ../src/backend/tcop/pquery.c:791 [05:17:37.209] _local_sigjmp_buf = {{_sjb = {9235615, 35267541744, 34922352872, 34922353104, 34922352880, 11863800, 11831584, 35267473664, -6347183290297351297, 35267481856, 3552155, 34359738368}}} [05:17:37.209] _save_exception_stack = 0x82188d2c0 [05:17:37.209] _save_context_stack = 0x0 [05:17:37.209] _do_rethrow = false [05:17:37.209] saveTopTransactionResourceOwner = 0x8361bfaf0 [05:17:37.209] saveTopTransactionContext = 0x8360e5000 [05:17:37.209] saveActivePortal = 0x0 [05:17:37.209] saveResourceOwner = 0x8361bfaf0 [05:17:37.209] savePortalContext = 0x0 [05:17:37.209] saveMemoryContext = 0x8360e5000 [05:17:37.209] result = [05:17:37.209] nprocessed = [05:17:37.209] #17 0x00000000008cdc0b in exec_simple_query (query_string=query_string@entry=0x8360d9100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1273 [05:17:37.209] cmdtaglen = [05:17:37.209] snapshot_set = [05:17:37.209] per_parsetree_context = 0x0 [05:17:37.209] plantree_list = [05:17:37.209] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:17:37.209] parsetree = 0x8362aafc8 [05:17:37.209] commandTag = CMDTAG_MERGE [05:17:37.209] cmdtagname = [05:17:37.209] querytree_list = [05:17:37.209] portal = 0x8361af100 [05:17:37.209] format = 0 [05:17:37.209] receiver = 0x8382990a0 [05:17:37.209] parsetree_item__state = {l = 0x838242b38, i = 0} [05:17:37.209] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:17:37.209] dest = DestRemote [05:17:37.209] was_logged = [05:17:37.209] oldcontext = 0x8360e5000 [05:17:37.209] parsetree_list = 0x838242b38 [05:17:37.209] use_implicit_block = false [05:17:37.209] parsetree_item = 0x838242b50 [05:17:37.209] save_log_statement_stats = [05:17:37.209] #18 0x00000000008cb9f4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [05:17:37.209] query_string = 0x8360d9100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [05:17:37.209] input_message = {data = 0x8360d9100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 241, maxlen = 1024, cursor = 241} [05:17:37.209] firstchar = [05:17:37.209] local_sigjmp_buf = {{_sjb = {9219776, 34922353344, 34922353304, 34922353904, 11872536, 11819024, 8192, 8388608, 72057628960228223, 0, 0, 34359738369}}} [05:17:37.209] send_ready_for_query = false [05:17:37.209] idle_in_transaction_timeout_enabled = false [05:17:37.209] idle_session_timeout_enabled = false [05:17:37.209] #19 0x000000000082b275 in BackendRun (port=port@entry=0x8361ac000) at ../src/backend/postmaster/postmaster.c:4477 [05:17:37.209] No locals. [05:17:37.209] #20 0x00000000008295ad in BackendStartup (port=0x8361ac000) at ../src/backend/postmaster/postmaster.c:4153 [05:17:37.209] bn = 0x8360e50d8 [05:17:37.209] pid = [05:17:37.209] __error = [05:17:37.209] __error = [05:17:37.209] __error = [05:17:37.209] save_errno = [05:17:37.209] __error = [05:17:37.209] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1771 [05:17:37.209] port = 0x8361ac000 [05:17:37.209] i = 0 [05:17:37.209] now = [05:17:37.209] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 570426376, events = 8, fd = 570427400, user_data = 0x822000c08}, {pos = 570429448, events = 8, fd = 570430472, user_data = 0x822001808}, {pos = 570432520, events = 8, fd = 570433544, user_data = 0x822002408}, {pos = -1, events = 0, fd = 775492320, user_data = 0x82188d5e0}, {pos = 775152041, events = 8, fd = 0, user_data = 0x1000}, {pos = -324015172, events = 539793955, fd = 775493608, user_data = 0x835809be0}, {pos = 160, events = 0, fd = 0, user_data = 0x834619090}, {pos = 562615984, events = 8, fd = 775014700, user_data = 0x1000}, {pos = 773577060, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 570460728, events = 8, fd = 1, user_data = 0x822002408}, {pos = 773490904, events = 8, fd = 562616120, user_data = 0x82188d4f0}, {pos = 32, events = 18, fd = 773561444, user_data = 0x822002408}, {pos = 570460728, events = 8, fd = 0, user_data = 0xa41}, {pos = 562616096, events = 8, fd = -127203771, user_data = 0x82e1bd964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822008a38}, {pos = 1, events = 0, fd = 570434568, user_data = 0x8360c9000}, {pos = 1, events = 0, fd = 906793364, user_data = 0x0}, {pos = 562616048, events = 8, fd = 719453196, user_data = 0x1}, {pos = 906792960, events = 8, fd = 562616096, user_data = 0x82ae1eeb4}, {pos = 775303520, events = 8, fd = 775303520, user_data = 0x82e1d50c0}, {pos = 570434568, events = 8, fd = 562616320, user_data = 0x3283f86b042c}, {pos = 878809232, events = 8, fd = 1, user_data = 0x3283f86b02ae}, {pos = 12240, events = 0, fd = 562616104, user_data = 0x82188d800}, {pos = 907499496, events = 8, fd = 562617712, user_data = 0x3283f86c3e90}, {pos = 570434568, events = 8, fd = 562561919, user_data = 0x82e30f59c}, {pos = 570404872, events = 8, fd = 0, user_data = 0x822002408}, {pos = 12240, events = 0, fd = 773427200, user_data = 0x1df950}, {pos = 775303520, events = 8, fd = 773561444, user_data = 0x3d00}, {pos = 562617504, events = 8, fd = 562616432, user_data = 0x82e25e18e }, {pos = 775342136, events = 8, fd = 562616372, user_data = 0x8361355da}, {pos = 562617504, events = 8, fd = 562616432, user_data = 0x82e274605}, {pos = 562616370, events = 8, fd = 562617504, user_data = 0x82188dca0}, {pos = 0, events = 16777216, fd = -324015172, user_data = 0x82188dca0}, {pos = 907236824, events = 8, fd = 562617712, user_data = 0x82e36c838}, {pos = 0, events = 0, fd = 562617568, user_data = 0x82e27470d}, {pos = 0, events = 0, fd = 0, user_data = 0x82188de10}, {pos = 907236824, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3283f86b7409}, {pos = 562616776, events = 8, fd = 773561444, user_data = 0x9c7}, {pos = -127175671, events = 12931, fd = 562616808, user_data = 0x82e1b9c64}, {pos = 2758, events = 0, fd = 773533984, user_data = 0x82188d968}, {pos = 570434568, events = 8, fd = 562616808, user_data = 0x82e1b3120}, {pos = 562616784, events = 8, fd = -127196059, user_data = 0x0}, {pos = 0, events = 0, fd = 775442672, user_data = 0x82e1a9550}, {pos = 0, events = 0, fd = 0, user_data = 0x82e3739b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x82188da58}, {pos = 570454152, events = 8, fd = -127175671, user_data = 0x82188da98}, {pos = 773561444, events = 8, fd = 2924, user_data = 0x82e1b33b8}, {pos = 562616856, events = 8, fd = 570434568, user_data = 0x82188da98}, {pos = 773534648, events = 8, fd = 562616960, user_data = 0x3283f86b2465}, {pos = 570458168, events = 8, fd = 1, user_data = 0x822002408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562617368, events = 0, fd = 2564724, user_data = 0x82188dc80}, {pos = 562617472, events = 8, fd = 562617400, user_data = 0x1e}, {pos = 773498080, events = 8, fd = 562617128, user_data = 0x822007248}, {pos = 562617576, events = 8, fd = 562617104, user_data = 0x3283f86b6da3}, {pos = 570458168, events = 8, fd = 2690717, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 570458168, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82188dde8}, {pos = 570434568, events = 8, fd = 562617456, user_data = 0x272274}, {pos = 562617648, events = 8, fd = 562617648, user_data = 0x82188dce8}, {pos = 32, events = 0, fd = 562617232, user_data = 0x3283f86b6b83}} [05:17:37.210] last_touch_time = 1709356375 [05:17:37.210] last_lockfile_recheck_time = 1709356375 [05:17:37.210] nevents = 1 [05:17:37.210] #22 0x00000000008268c0 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82188e4a8) at ../src/backend/postmaster/postmaster.c:1470 [05:17:37.210] userDoption = [05:17:37.210] listen_addr_saved = false [05:17:37.210] output_config_variable = [05:17:37.210] opt = [05:17:37.210] status = [05:17:37.210] #23 0x0000000000763cd5 in main (argc=8, argv=0x82188e4a8) at ../src/backend/main/main.c:198 [05:17:37.210] do_check_root = [05:17:37.220] [05:17:37.220] [05:17:37.220] [05:17:37.281] dumping /tmp/cores/postgres.7050.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [05:17:37.406] [New LWP 100137] [05:17:37.471] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [05:17:37.471] Program terminated with signal SIGABRT, Aborted. [05:17:37.471] Sent by thr_kill() from pid 7050 and user 1003. [05:17:37.471] #0 0x000000082b8bcdca in thr_kill () from /lib/libc.so.7 [05:17:38.015] [05:17:38.015] Thread 1 (LWP 100137): [05:17:38.015] #0 0x000000082b8bcdca in thr_kill () from /lib/libc.so.7 [05:17:38.015] No symbol table info available. [05:17:38.015] #1 0x000000082b8356f4 in raise () from /lib/libc.so.7 [05:17:38.015] No symbol table info available. [05:17:38.015] #2 0x000000082b8e6bc9 in abort () from /lib/libc.so.7 [05:17:38.015] No symbol table info available. [05:17:38.015] #3 0x0000000000a1d197 in ExceptionalCondition (conditionName=, fileName=0x36c374 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [05:17:38.015] No locals. [05:17:38.015] #4 0x000000000070ef90 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821a34b18, materialize=, shouldFree=shouldFree@entry=0x821a349f6) at ../src/backend/executor/execTuples.c:1649 [05:17:38.015] No locals. [05:17:38.015] #5 0x00000000006d6c28 in ExecIRDeleteTriggers (estate=estate@entry=0x8373ee100, relinfo=relinfo@entry=0x8373ee6b0, slot=slot@entry=0x821a34b18) at ../src/backend/commands/trigger.c:2848 [05:17:38.015] trigger = [05:17:38.015] oldtuple = [05:17:38.015] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x837324bf0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:17:38.015] trigdesc = 0x8373ee8c0 [05:17:38.015] newtuple = 0x0 [05:17:38.015] i = 0 [05:17:38.015] should_free = false [05:17:38.015] #6 0x00000000007346b4 in ExecMergeMatched (context=0x821a34b50, resultRelInfo=0x8373ee6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2980 [05:17:38.015] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:17:38.015] commandType = CMD_DELETE [05:17:38.015] result = TM_Ok [05:17:38.015] relaction = [05:17:38.015] l__state = {l = 0x83742bc68, i = 0} [05:17:38.015] mtstate = 0x8373ee4a0 [05:17:38.015] estate = 0x18729 [05:17:38.015] econtext = 0x83742b468 [05:17:38.015] epqstate = 0x8373ee588 [05:17:38.015] l = [05:17:38.015] newslot = [05:17:38.015] isNull = [05:17:38.015] __error = [05:17:38.015] l__state = [05:17:38.015] updateCxt = [05:17:38.015] commandType = [05:17:38.015] result = [05:17:38.015] relaction = [05:17:38.015] __error = [05:17:38.015] resultRelationDesc = [05:17:38.015] lockmode = [05:17:38.015] inputslot = [05:17:38.015] epqslot = [05:17:38.015] __error = [05:17:38.015] __error = [05:17:38.015] __error = [05:17:38.015] __error = [05:17:38.015] __error = [05:17:38.015] __error = [05:17:38.015] __error = [05:17:38.015] #7 ExecMerge (context=context@entry=0x821a34b50, resultRelInfo=resultRelInfo@entry=0x8373ee6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x821a34b18, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2777 [05:17:38.015] matched = [05:17:38.015] #8 0x0000000000733a67 in ExecModifyTable (pstate=0x8373ee4a0) at ../src/backend/executor/nodeModifyTable.c:3923 [05:17:38.015] context = {mtstate = 0x8373ee4a0, epqstate = 0x8373ee588, estate = 0x8373ee100, planSlot = 0x83742a3a8, relaction = 0x83742b6a8, tmfd = {ctid = {ip_blkid = {bi_hi = 57600, bi_lo = 14142}, ip_posid = 8}, xmax = 564349840, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [05:17:38.015] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [05:17:38.015] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x837345118} [05:17:38.015] node = 0x8373ee4a0 [05:17:38.015] estate = 0x8373ee100 [05:17:38.015] operation = CMD_MERGE [05:17:38.015] resultRelInfo = 0x6 [05:17:38.015] subplanstate = 0x8373efdf0 [05:17:38.015] slot = 0x83742a3a8 [05:17:38.015] tupleid = 0x0 [05:17:38.015] oldtuple = 0x821a34b18 [05:17:38.015] oldSlot = [05:17:38.015] #9 0x000000000070920b in ExecProcNodeFirst (node=0x8373ee4a0) at ../src/backend/executor/execProcnode.c:464 [05:17:38.015] No locals. [05:17:38.015] #10 0x00000000007015fa in ExecProcNode (node=0x8373ee4a0) at ../src/include/executor/executor.h:274 [05:17:38.015] No locals. [05:17:38.015] #11 ExecutePlan (estate=0x8373ee100, planstate=0x8373ee4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x837458060, execute_once=) at ../src/backend/executor/execMain.c:1647 [05:17:38.015] current_tuple_count = [05:17:38.015] slot = [05:17:38.015] #12 standard_ExecutorRun (queryDesc=0x834f17900, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:366 [05:17:38.015] estate = 0x8373ee100 [05:17:38.015] oldcontext = 0x834f17800 [05:17:38.015] operation = CMD_MERGE [05:17:38.015] dest = 0x837458060 [05:17:38.015] sendTuples = false [05:17:38.015] #13 0x00000000007014bf in ExecutorRun (queryDesc=0x18729, queryDesc@entry=0x834f17900, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:310 [05:17:38.015] No locals. [05:17:38.015] #14 0x00000000008cff1f in ProcessQuery (plan=0x8374541e8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821a34e50) at ../src/backend/tcop/pquery.c:160 [05:17:38.015] queryDesc = 0x834f17900 [05:17:38.015] #15 0x00000000008cf4bd in PortalRunMulti (portal=portal@entry=0x834f5d100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x837458060, altdest=altdest@entry=0x837458060, qc=0x821a34e50) at ../src/backend/tcop/pquery.c:1286 [05:17:38.015] pstmt = 0x8374541e8 [05:17:38.015] stmtlist_item__state = {l = 0x837458010, i = 0} [05:17:38.015] active_snapshot_set = true [05:17:38.015] stmtlist_item = 0x837458028 [05:17:38.015] #16 0x00000000008ced2b in PortalRun (portal=portal@entry=0x834f5d100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82b8bcdaa , dest@entry=0x837458060, altdest=0x0, altdest@entry=0x837458060, qc=0x821a34e50) at ../src/backend/tcop/pquery.c:791 [05:17:38.015] _local_sigjmp_buf = {{_sjb = {9235615, 35248559088, 34924088648, 34924088880, 34924088656, 11863800, 11831584, 35248263424, -6347183290295581825, 35248271616, 3552155, 34359738368}}} [05:17:38.015] _save_exception_stack = 0x821a34f20 [05:17:38.015] _save_context_stack = 0x0 [05:17:38.015] _do_rethrow = false [05:17:38.015] saveTopTransactionResourceOwner = 0x834fa53f0 [05:17:38.015] saveTopTransactionContext = 0x834ed0000 [05:17:38.015] saveActivePortal = 0x0 [05:17:38.015] saveResourceOwner = 0x834fa53f0 [05:17:38.015] savePortalContext = 0x0 [05:17:38.015] saveMemoryContext = 0x834ed0000 [05:17:38.015] result = [05:17:38.015] nprocessed = [05:17:38.015] #17 0x00000000008cdc0b in exec_simple_query (query_string=query_string@entry=0x834ec4100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1273 [05:17:38.015] cmdtaglen = [05:17:38.015] snapshot_set = [05:17:38.015] per_parsetree_context = 0x0 [05:17:38.015] plantree_list = [05:17:38.015] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:17:38.015] parsetree = 0x83506cfc8 [05:17:38.015] commandTag = CMDTAG_MERGE [05:17:38.015] cmdtagname = [05:17:38.015] querytree_list = [05:17:38.015] portal = 0x834f5d100 [05:17:38.015] format = 0 [05:17:38.015] receiver = 0x837458060 [05:17:38.015] parsetree_item__state = {l = 0x8373fa9b8, i = 0} [05:17:38.015] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:17:38.015] dest = DestRemote [05:17:38.015] was_logged = [05:17:38.015] oldcontext = 0x834ed0000 [05:17:38.015] parsetree_list = 0x8373fa9b8 [05:17:38.015] use_implicit_block = false [05:17:38.015] parsetree_item = 0x8373fa9d0 [05:17:38.015] save_log_statement_stats = [05:17:38.015] #18 0x00000000008cb9f4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [05:17:38.015] query_string = 0x834ec4100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [05:17:38.015] input_message = {data = 0x834ec4100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 241, maxlen = 1024, cursor = 241} [05:17:38.015] firstchar = [05:17:38.015] local_sigjmp_buf = {{_sjb = {9219776, 34924089120, 34924089080, 34924089680, 11872536, 11819024, 8192, 8388608, 72057628961997695, 0, 0, 34359738369}}} [05:17:38.015] send_ready_for_query = false [05:17:38.015] idle_in_transaction_timeout_enabled = false [05:17:38.015] idle_session_timeout_enabled = false [05:17:38.015] #19 0x000000000082b275 in BackendRun (port=port@entry=0x834f77000) at ../src/backend/postmaster/postmaster.c:4477 [05:17:38.015] No locals. [05:17:38.015] #20 0x00000000008295ad in BackendStartup (port=0x834f77000) at ../src/backend/postmaster/postmaster.c:4153 [05:17:38.015] bn = 0x834ed05d8 [05:17:38.015] pid = [05:17:38.015] __error = [05:17:38.015] __error = [05:17:38.015] __error = [05:17:38.015] save_errno = [05:17:38.015] __error = [05:17:38.015] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1771 [05:17:38.015] port = 0x834f77000 [05:17:38.015] i = 0 [05:17:38.015] now = [05:17:38.015] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 578880520, events = 8, fd = 578881544, user_data = 0x822810c08}, {pos = 578883592, events = 8, fd = 578884616, user_data = 0x822811808}, {pos = 578886664, events = 8, fd = 578887688, user_data = 0x822812408}, {pos = 578908296, events = 8, fd = 564352088, user_data = 0x821a35280}, {pos = -57307741, events = 6267, fd = 0, user_data = 0x27232a}, {pos = 115249317, events = 0, fd = -25761258, user_data = 0x822818038}, {pos = 1, events = 0, fd = 578888712, user_data = 0x82b78f4a8}, {pos = 564352344, events = 8, fd = 578888712, user_data = 0x21a35270}, {pos = 729454948, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 578914872, events = 8, fd = 1, user_data = 0x822812408}, {pos = 729368792, events = 8, fd = 564351896, user_data = 0x821a35150}, {pos = 32, events = 18, fd = 729439332, user_data = 0x822812408}, {pos = 578914872, events = 8, fd = 0, user_data = 0xa41}, {pos = 564351872, events = 8, fd = -57334203, user_data = 0x82b7a9964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822818a38}, {pos = 1, events = 0, fd = 578888712, user_data = 0x834eb4000}, {pos = 1, events = 0, fd = 887832980, user_data = 0x0}, {pos = 564351824, events = 8, fd = 713280524, user_data = 0x1}, {pos = 887832576, events = 8, fd = 564351872, user_data = 0x82a83beb4}, {pos = 731181408, events = 8, fd = 731181408, user_data = 0x82b7c10c0}, {pos = 578888712, events = 8, fd = 564352096, user_data = 0x187bfc95242c}, {pos = 578887688, events = 8, fd = 1, user_data = 0x187bfc9522ae}, {pos = 12240, events = 0, fd = 564351880, user_data = 0x821a35460}, {pos = 888612840, events = 8, fd = 564353488, user_data = 0x187bfc965e90}, {pos = 578888712, events = 8, fd = 564331391, user_data = 0x82b8fb4b2}, {pos = 578859016, events = 8, fd = 0, user_data = 0x822812408}, {pos = 12240, events = 0, fd = 729305088, user_data = 0x1df950}, {pos = 731181408, events = 8, fd = 729439332, user_data = 0x3d00}, {pos = 564353280, events = 8, fd = 564352208, user_data = 0x82b84a18e }, {pos = 731220024, events = 8, fd = 564352148, user_data = 0x834f225da}, {pos = 564353280, events = 8, fd = 564352208, user_data = 0x82b860605}, {pos = 564352146, events = 8, fd = 564353280, user_data = 0x821a35900}, {pos = 0, events = 16777216, fd = -1265648688, user_data = 0x821a35900}, {pos = 888284632, events = 8, fd = 564353488, user_data = 0x82b958838}, {pos = 0, events = 0, fd = 564353344, user_data = 0x82b86070d}, {pos = 0, events = 0, fd = 0, user_data = 0x821a35a70}, {pos = 888284632, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x187bfc959409}, {pos = 564352552, events = 8, fd = 729439332, user_data = 0x9c7}, {pos = -57306103, events = 6267, fd = 564352584, user_data = 0x82b7a5c64}, {pos = 2758, events = 0, fd = 729411872, user_data = 0x821a355c8}, {pos = 578888712, events = 8, fd = 564352584, user_data = 0x82b79f120}, {pos = 564352560, events = 8, fd = -57326491, user_data = 0x0}, {pos = 0, events = 0, fd = 731320560, user_data = 0x82b795550}, {pos = 0, events = 0, fd = 0, user_data = 0x82b95f9b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x821a356b8}, {pos = 578908296, events = 8, fd = -57306103, user_data = 0x821a356f8}, {pos = 729439332, events = 8, fd = 2924, user_data = 0x82b79f3b8}, {pos = 564352632, events = 8, fd = 578888712, user_data = 0x821a356f8}, {pos = 729412536, events = 8, fd = 564352736, user_data = 0x187bfc954465}, {pos = 578912312, events = 8, fd = 1, user_data = 0x822812408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 564353144, events = 0, fd = 2564724, user_data = 0x821a358e0}, {pos = 564353248, events = 8, fd = 564353176, user_data = 0x1e}, {pos = 729375968, events = 8, fd = 564352904, user_data = 0x822817248}, {pos = 564353352, events = 8, fd = 564352880, user_data = 0x187bfc958da3}, {pos = 578912312, events = 8, fd = 2690717, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 578912312, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821a35a48}, {pos = 578888712, events = 8, fd = 564353232, user_data = 0x272274}, {pos = 564353424, events = 8, fd = 564353424, user_data = 0x821a35948}, {pos = 32, events = 0, fd = 564353008, user_data = 0x187bfc958b83}} [05:17:38.015] last_touch_time = 1709356377 [05:17:38.015] last_lockfile_recheck_time = 1709356377 [05:17:38.015] nevents = 1 [05:17:38.015] #22 0x00000000008268c0 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a36108) at ../src/backend/postmaster/postmaster.c:1470 [05:17:38.015] userDoption = [05:17:38.015] listen_addr_saved = false [05:17:38.015] output_config_variable = [05:17:38.015] opt = [05:17:38.015] status = [05:17:38.015] #23 0x0000000000763cd5 in main (argc=4, argv=0x821a36108) at ../src/backend/main/main.c:198 [05:17:38.015] do_check_root = [05:17:38.027] [05:17:38.027] [05:17:38.027] [05:17:38.091] dumping /tmp/cores/postgres.13562.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [05:17:38.220] [New LWP 101625] [05:17:38.287] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [05:17:38.287] Program terminated with signal SIGABRT, Aborted. [05:17:38.287] Sent by thr_kill() from pid 13562 and user 1003. [05:17:38.287] #0 0x000000082d483dca in thr_kill () from /lib/libc.so.7 [05:17:38.822] [05:17:38.822] Thread 1 (LWP 101625): [05:17:38.822] #0 0x000000082d483dca in thr_kill () from /lib/libc.so.7 [05:17:38.822] No symbol table info available. [05:17:38.822] #1 0x000000082d3fc6f4 in raise () from /lib/libc.so.7 [05:17:38.822] No symbol table info available. [05:17:38.822] #2 0x000000082d4adbc9 in abort () from /lib/libc.so.7 [05:17:38.822] No symbol table info available. [05:17:38.822] #3 0x0000000000a1d197 in ExceptionalCondition (conditionName=, fileName=0x36c374 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [05:17:38.822] No locals. [05:17:38.822] #4 0x000000000070ef90 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821266188, materialize=, shouldFree=shouldFree@entry=0x821266066) at ../src/backend/executor/execTuples.c:1649 [05:17:38.822] No locals. [05:17:38.822] #5 0x00000000006d6c28 in ExecIRDeleteTriggers (estate=estate@entry=0x83c32b100, relinfo=relinfo@entry=0x83c32b6b0, slot=slot@entry=0x821266188) at ../src/backend/commands/trigger.c:2848 [05:17:38.822] trigger = [05:17:38.822] oldtuple = [05:17:38.822] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83e662678, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:17:38.822] trigdesc = 0x83c32b8c0 [05:17:38.822] newtuple = 0x0 [05:17:38.822] i = 0 [05:17:38.822] should_free = false [05:17:38.822] #6 0x00000000007346b4 in ExecMergeMatched (context=0x8212661c0, resultRelInfo=0x83c32b6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2980 [05:17:38.822] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:17:38.822] commandType = CMD_DELETE [05:17:38.822] result = TM_Ok [05:17:38.822] relaction = [05:17:38.822] l__state = {l = 0x83c2ff2e8, i = 0} [05:17:38.822] mtstate = 0x83c32b4a0 [05:17:38.822] estate = 0x18cf9 [05:17:38.822] econtext = 0x83c2feae8 [05:17:38.822] epqstate = 0x83c32b588 [05:17:38.822] l = [05:17:38.822] newslot = [05:17:38.822] isNull = [05:17:38.822] __error = [05:17:38.822] l__state = [05:17:38.822] updateCxt = [05:17:38.822] commandType = [05:17:38.822] result = [05:17:38.822] relaction = [05:17:38.822] __error = [05:17:38.822] resultRelationDesc = [05:17:38.822] lockmode = [05:17:38.822] inputslot = [05:17:38.822] epqslot = [05:17:38.822] __error = [05:17:38.822] __error = [05:17:38.822] __error = [05:17:38.822] __error = [05:17:38.822] __error = [05:17:38.822] __error = [05:17:38.822] __error = [05:17:38.822] #7 ExecMerge (context=context@entry=0x8212661c0, resultRelInfo=resultRelInfo@entry=0x83c32b6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x821266188, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2777 [05:17:38.822] matched = [05:17:38.822] #8 0x0000000000733a67 in ExecModifyTable (pstate=0x83c32b4a0) at ../src/backend/executor/nodeModifyTable.c:3923 [05:17:38.822] context = {mtstate = 0x83c32b4a0, epqstate = 0x83c32b588, estate = 0x83c32b100, planSlot = 0x83c2fda28, relaction = 0x83c2fed28, tmfd = {ctid = {ip_blkid = {bi_hi = 1758, bi_lo = 11592}, ip_posid = 8}, xmax = 147, cmax = 0, traversed = 28}, cpUpdateReturningSlot = 0x5a8e96ba6f36ccba} [05:17:38.822] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [05:17:38.822] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836b96118} [05:17:38.822] node = 0x83c32b4a0 [05:17:38.822] estate = 0x83c32b100 [05:17:38.822] operation = CMD_MERGE [05:17:38.822] resultRelInfo = 0x6 [05:17:38.822] subplanstate = 0x83c32cdf0 [05:17:38.822] slot = 0x83c2fda28 [05:17:38.822] tupleid = 0x0 [05:17:38.822] oldtuple = 0x821266188 [05:17:38.822] oldSlot = [05:17:38.822] #9 0x000000000070920b in ExecProcNodeFirst (node=0x83c32b4a0) at ../src/backend/executor/execProcnode.c:464 [05:17:38.822] No locals. [05:17:38.822] #10 0x00000000007015fa in ExecProcNode (node=0x83c32b4a0) at ../src/include/executor/executor.h:274 [05:17:38.822] No locals. [05:17:38.822] #11 ExecutePlan (estate=0x83c32b100, planstate=0x83c32b4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x83c2e79c8, execute_once=) at ../src/backend/executor/execMain.c:1647 [05:17:38.822] current_tuple_count = [05:17:38.822] slot = [05:17:38.822] #12 standard_ExecutorRun (queryDesc=0x836b5e500, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:366 [05:17:38.822] estate = 0x83c32b100 [05:17:38.822] oldcontext = 0x836b5e400 [05:17:38.822] operation = CMD_MERGE [05:17:38.822] dest = 0x83c2e79c8 [05:17:38.822] sendTuples = false [05:17:38.822] #13 0x0000000838a34963 in pgss_ExecutorRun (queryDesc=0x836b5e500, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [05:17:38.822] _local_sigjmp_buf = {{_sjb = {35309963570, 11863800, 34915902184, 34915902352, 35277628672, 34915902192, 1, 1, 35369649023, 35277628672, 11872528, 34359738368}}} [05:17:38.822] _save_exception_stack = 0x821266470 [05:17:38.822] _save_context_stack = 0x0 [05:17:38.822] _do_rethrow = false [05:17:38.822] #14 0x00000000007014b8 in ExecutorRun (queryDesc=0x18cf9, queryDesc@entry=0x836b5e500, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:308 [05:17:38.822] No locals. [05:17:38.822] #15 0x00000000008cff1f in ProcessQuery (plan=0x83c2e3b50, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821266570) at ../src/backend/tcop/pquery.c:160 [05:17:38.822] queryDesc = 0x836b5e500 [05:17:38.822] #16 0x00000000008cf4bd in PortalRunMulti (portal=portal@entry=0x836a69100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83c2e79c8, altdest=altdest@entry=0x83c2e79c8, qc=0x821266570) at ../src/backend/tcop/pquery.c:1286 [05:17:38.822] pstmt = 0x83c2e3b50 [05:17:38.822] stmtlist_item__state = {l = 0x83c2e7978, i = 0} [05:17:38.822] active_snapshot_set = true [05:17:38.822] stmtlist_item = 0x83c2e7990 [05:17:38.822] #17 0x00000000008ced2b in PortalRun (portal=portal@entry=0x836a69100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82d483daa , dest@entry=0x83c2e79c8, altdest=0x0, altdest@entry=0x83c2e79c8, qc=0x821266570) at ../src/backend/tcop/pquery.c:791 [05:17:38.822] _local_sigjmp_buf = {{_sjb = {9235615, 35276937856, 34915902568, 34915902800, 34915902576, 11863800, 11831584, 35276624128, -6347183290303773825, 35276632320, 3552155, 34359738368}}} [05:17:38.822] _save_exception_stack = 0x821266640 [05:17:38.822] _save_context_stack = 0x0 [05:17:38.822] _do_rethrow = false [05:17:38.822] saveTopTransactionResourceOwner = 0x836ab5a80 [05:17:38.822] saveTopTransactionContext = 0x8369da000 [05:17:38.822] saveActivePortal = 0x0 [05:17:38.822] saveResourceOwner = 0x836ab5a80 [05:17:38.822] savePortalContext = 0x0 [05:17:38.822] saveMemoryContext = 0x8369da000 [05:17:38.822] result = [05:17:38.822] nprocessed = [05:17:38.822] #18 0x00000000008cdc0b in exec_simple_query (query_string=query_string@entry=0x8369ce100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1273 [05:17:38.822] cmdtaglen = [05:17:38.822] snapshot_set = [05:17:38.822] per_parsetree_context = 0x0 [05:17:38.822] plantree_list = [05:17:38.822] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:17:38.822] parsetree = 0x836a5efc8 [05:17:38.822] commandTag = CMDTAG_MERGE [05:17:38.822] cmdtagname = [05:17:38.822] querytree_list = [05:17:38.822] portal = 0x836a69100 [05:17:38.822] format = 0 [05:17:38.822] receiver = 0x83c2e79c8 [05:17:38.822] parsetree_item__state = {l = 0x83c2a0af8, i = 0} [05:17:38.822] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:17:38.822] dest = DestRemote [05:17:38.822] was_logged = [05:17:38.822] oldcontext = 0x8369da000 [05:17:38.822] parsetree_list = 0x83c2a0af8 [05:17:38.822] use_implicit_block = false [05:17:38.822] parsetree_item = 0x83c2a0b10 [05:17:38.822] save_log_statement_stats = [05:17:38.822] #19 0x00000000008cb9f4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [05:17:38.822] query_string = 0x8369ce100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [05:17:38.822] input_message = {data = 0x8369ce100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 241, maxlen = 1024, cursor = 241} [05:17:38.822] firstchar = [05:17:38.822] local_sigjmp_buf = {{_sjb = {9219776, 34915903040, 34915903000, 34915903600, 11872536, 11819024, 8192, 8388608, 72057628953805695, 0, 0, 1}}} [05:17:38.822] send_ready_for_query = false [05:17:38.822] idle_in_transaction_timeout_enabled = false [05:17:38.822] idle_session_timeout_enabled = false [05:17:38.822] #20 0x000000000082b275 in BackendRun (port=port@entry=0x836aab000) at ../src/backend/postmaster/postmaster.c:4477 [05:17:38.822] No locals. [05:17:38.822] #21 0x00000000008295ad in BackendStartup (port=0x836aab000) at ../src/backend/postmaster/postmaster.c:4153 [05:17:38.822] bn = 0x8369da3f8 [05:17:38.822] pid = [05:17:38.822] __error = [05:17:38.822] __error = [05:17:38.822] __error = [05:17:38.822] save_errno = [05:17:38.822] __error = [05:17:38.822] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1771 [05:17:38.822] port = 0x836aab000 [05:17:38.822] i = 0 [05:17:38.822] now = [05:17:38.822] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 562523144, events = 8, fd = 562524168, user_data = 0x821877408}, {pos = 562526216, events = 8, fd = 562527240, user_data = 0x821878008}, {pos = 562529288, events = 8, fd = 562548872, user_data = 0x821266b78}, {pos = 556165520, events = 8, fd = 184618403, user_data = 0x821878408}, {pos = 2564906, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 562552888, events = 8, fd = 1, user_data = 0x821878408}, {pos = 758473896, events = 8, fd = 556166264, user_data = 0x821878408}, {pos = 556165488, events = 0, fd = 2564724, user_data = 0x821266bc0}, {pos = 758581604, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 562555448, events = 8, fd = 1, user_data = 0x821878408}, {pos = 758495448, events = 8, fd = 556165816, user_data = 0x821266860}, {pos = 33, events = 18, fd = 758565988, user_data = 0x821878408}, {pos = 562555448, events = 8, fd = 0, user_data = 0xa41}, {pos = 556165792, events = 8, fd = 184591941, user_data = 0x82d370964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x82187ea38}, {pos = 1, events = 0, fd = 562529288, user_data = 0x8369be000}, {pos = 1, events = 0, fd = 916185492, user_data = 0x0}, {pos = 556165744, events = 8, fd = 736603148, user_data = 0x1}, {pos = 916185088, events = 8, fd = 556165792, user_data = 0x82be79eb4}, {pos = 760308064, events = 8, fd = 760308064, user_data = 0x82d3880c0}, {pos = 562529288, events = 8, fd = 556166016, user_data = 0x16080b00a42c}, {pos = 80627796, events = 0, fd = 1, user_data = 0x16080b00a2ae}, {pos = 12240, events = 0, fd = 556165800, user_data = 0x821266b80}, {pos = 916981736, events = 8, fd = 556167408, user_data = 0x16080b01de90}, {pos = 562529288, events = 8, fd = 556139391, user_data = 0x82d4c24b2}, {pos = 556166320, events = 8, fd = 0, user_data = 0x821878408}, {pos = 12240, events = 0, fd = 758431744, user_data = 0x1df950}, {pos = 760308064, events = 8, fd = 758565988, user_data = 0x3d00}, {pos = 556167200, events = 8, fd = 556166128, user_data = 0x82d41118e }, {pos = 760346680, events = 8, fd = 556166068, user_data = 0x836a2c5da}, {pos = 556167200, events = 8, fd = 556166128, user_data = 0x82d427605}, {pos = 556166066, events = 8, fd = 556167200, user_data = 0x821267020}, {pos = 0, events = 16777216, fd = 1865862330, user_data = 0x821267020}, {pos = 916637144, events = 8, fd = 556167408, user_data = 0x82d51f838}, {pos = 0, events = 0, fd = 556167264, user_data = 0x82d42770d}, {pos = 0, events = 0, fd = 0, user_data = 0x821267190}, {pos = 916637144, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 184620041, events = 5640, fd = 556166456, user_data = 0x82d36cc64}, {pos = 2503, events = 0, fd = 184620041, user_data = 0x821266d58}, {pos = 758565988, events = 8, fd = 2758, user_data = 0x82d366120}, {pos = 556166360, events = 8, fd = 562529288, user_data = 0x821266d58}, {pos = 758538528, events = 8, fd = 556166464, user_data = 0x16080b00c465}, {pos = 0, events = 0, fd = 0, user_data = 0x821266d30}, {pos = 758498640, events = 8, fd = 0, user_data = 0x0}, {pos = 556166416, events = 8, fd = 16, user_data = 0x0}, {pos = 556166600, events = 8, fd = 562548872, user_data = 0x16080b011409}, {pos = 556166664, events = 8, fd = 758565988, user_data = 0xb6c}, {pos = 758539192, events = 8, fd = 556166536, user_data = 0x821878408}, {pos = 556166664, events = 8, fd = 758539192, user_data = 0x821266df0}, {pos = 184599653, events = 5640, fd = 562552888, user_data = 0x800000001}, {pos = 562529288, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 556167064, user_data = 0x272274}, {pos = 556167168, events = 8, fd = 556167168, user_data = 0x821266fb8}, {pos = 31, events = 0, fd = 0, user_data = 0x821266e98}, {pos = 562550664, events = 8, fd = 556167272, user_data = 0x821266e80}, {pos = 184618403, events = 5640, fd = 562552888, user_data = 0x290e9d}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82187e038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556167528, events = 8, fd = 0, user_data = 0x321266ff0}, {pos = 562550760, events = 8, fd = 556167344, user_data = 0x290}, {pos = 556167272, events = 8, fd = 556166808, user_data = 0x821266f00}, {pos = 184618029, events = 5640, fd = 562518024, user_data = 0x0}} [05:17:38.822] last_touch_time = 1709356434 [05:17:38.822] last_lockfile_recheck_time = 1709356434 [05:17:38.822] nevents = 1 [05:17:38.822] #23 0x00000000008268c0 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821267820) at ../src/backend/postmaster/postmaster.c:1470 [05:17:38.822] userDoption = [05:17:38.822] listen_addr_saved = false [05:17:38.822] output_config_variable = [05:17:38.822] opt = [05:17:38.822] status = [05:17:38.822] #24 0x0000000000763cd5 in main (argc=4, argv=0x821267820) at ../src/backend/main/main.c:198 [05:17:38.822] do_check_root =