[04:46:59.634] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [04:47:00.012] dumping /tmp/cores/postgres.6572.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [04:47:00.142] [New LWP 100100] [04:47:00.229] Core was generated by `postgres: postgres regression [local] MERGE'. [04:47:00.229] Program terminated with signal SIGABRT, Aborted. [04:47:00.229] Sent by thr_kill() from pid 6572 and user 1003. [04:47:00.229] #0 0x000000082d0b0dca in thr_kill () from /lib/libc.so.7 [04:47:00.838] [04:47:00.838] Thread 1 (LWP 100100): [04:47:00.838] #0 0x000000082d0b0dca in thr_kill () from /lib/libc.so.7 [04:47:00.838] No symbol table info available. [04:47:00.838] #1 0x000000082d0296f4 in raise () from /lib/libc.so.7 [04:47:00.838] No symbol table info available. [04:47:00.838] #2 0x000000082d0dabc9 in abort () from /lib/libc.so.7 [04:47:00.838] No symbol table info available. [04:47:00.838] #3 0x0000000000a1d217 in ExceptionalCondition (conditionName=, fileName=0x36c43c "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [04:47:00.838] No locals. [04:47:00.838] #4 0x000000000070ef40 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82120c128, materialize=, shouldFree=shouldFree@entry=0x82120c006) at ../src/backend/executor/execTuples.c:1649 [04:47:00.838] No locals. [04:47:00.838] #5 0x00000000006d6bd8 in ExecIRDeleteTriggers (estate=estate@entry=0x844e99100, relinfo=relinfo@entry=0x844e996b0, slot=slot@entry=0x82120c128) at ../src/backend/commands/trigger.c:2848 [04:47:00.838] trigger = [04:47:00.838] oldtuple = [04:47:00.838] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x846ce1a18, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [04:47:00.838] trigdesc = 0x844e998c0 [04:47:00.838] newtuple = 0x0 [04:47:00.838] i = 0 [04:47:00.838] should_free = false [04:47:00.838] #6 0x0000000000734664 in ExecMergeMatched (context=0x82120c160, resultRelInfo=0x844e996b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2980 [04:47:00.838] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [04:47:00.838] commandType = CMD_DELETE [04:47:00.838] result = TM_Ok [04:47:00.838] relaction = [04:47:00.838] l__state = {l = 0x844ed6ae8, i = 0} [04:47:00.838] mtstate = 0x844e994a0 [04:47:00.838] estate = 0x18704 [04:47:00.838] econtext = 0x844ed62e8 [04:47:00.838] epqstate = 0x844e99588 [04:47:00.838] l = [04:47:00.838] newslot = [04:47:00.838] isNull = [04:47:00.838] __error = [04:47:00.838] l__state = [04:47:00.838] updateCxt = [04:47:00.838] commandType = [04:47:00.838] result = [04:47:00.838] relaction = [04:47:00.838] __error = [04:47:00.838] resultRelationDesc = [04:47:00.838] lockmode = [04:47:00.838] inputslot = [04:47:00.838] epqslot = [04:47:00.838] __error = [04:47:00.838] __error = [04:47:00.838] __error = [04:47:00.838] __error = [04:47:00.838] __error = [04:47:00.838] __error = [04:47:00.838] __error = [04:47:00.838] #7 ExecMerge (context=context@entry=0x82120c160, resultRelInfo=resultRelInfo@entry=0x844e996b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x82120c128, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2777 [04:47:00.838] matched = [04:47:00.838] #8 0x0000000000733a17 in ExecModifyTable (pstate=0x844e994a0) at ../src/backend/executor/nodeModifyTable.c:3923 [04:47:00.838] context = {mtstate = 0x844e994a0, epqstate = 0x844e99588, estate = 0x844e99100, planSlot = 0x844ed5228, relaction = 0x844ed6528, tmfd = {ctid = {ip_blkid = {bi_hi = 37120, bi_lo = 17641}, ip_posid = 8}, xmax = 555794848, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [04:47:00.838] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [04:47:00.838] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836da4118} [04:47:00.838] node = 0x844e994a0 [04:47:00.838] estate = 0x844e99100 [04:47:00.838] operation = CMD_MERGE [04:47:00.838] resultRelInfo = 0x6 [04:47:00.838] subplanstate = 0x844e9adf0 [04:47:00.838] slot = 0x844ed5228 [04:47:00.838] tupleid = 0x0 [04:47:00.838] oldtuple = 0x82120c128 [04:47:00.838] oldSlot = [04:47:00.838] #9 0x00000000007091bb in ExecProcNodeFirst (node=0x844e994a0) at ../src/backend/executor/execProcnode.c:464 [04:47:00.838] No locals. [04:47:00.838] #10 0x00000000007015aa in ExecProcNode (node=0x844e994a0) at ../src/include/executor/executor.h:274 [04:47:00.838] No locals. [04:47:00.838] #11 ExecutePlan (estate=0x844e99100, planstate=0x844e994a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x844efcfa0, execute_once=) at ../src/backend/executor/execMain.c:1647 [04:47:00.838] current_tuple_count = [04:47:00.838] slot = [04:47:00.838] #12 standard_ExecutorRun (queryDesc=0x836d99100, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:366 [04:47:00.838] estate = 0x844e99100 [04:47:00.838] oldcontext = 0x836d99000 [04:47:00.838] operation = CMD_MERGE [04:47:00.838] dest = 0x844efcfa0 [04:47:00.838] sendTuples = false [04:47:00.838] #13 0x000000000070146f in ExecutorRun (queryDesc=0x18704, queryDesc@entry=0x836d99100, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:310 [04:47:00.838] No locals. [04:47:00.838] #14 0x00000000008cffbf in ProcessQuery (plan=0x844ef9128, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82120c460) at ../src/backend/tcop/pquery.c:160 [04:47:00.838] queryDesc = 0x836d99100 [04:47:00.838] #15 0x00000000008cf55d in PortalRunMulti (portal=portal@entry=0x836d71100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x844efcfa0, altdest=altdest@entry=0x844efcfa0, qc=0x82120c460) at ../src/backend/tcop/pquery.c:1286 [04:47:00.838] pstmt = 0x844ef9128 [04:47:00.838] stmtlist_item__state = {l = 0x844efcf50, i = 0} [04:47:00.838] active_snapshot_set = true [04:47:00.838] stmtlist_item = 0x844efcf68 [04:47:00.838] #16 0x00000000008cedcb in PortalRun (portal=portal@entry=0x836d71100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82d0b0daa , dest@entry=0x844efcfa0, altdest=0x0, altdest@entry=0x844efcfa0, qc=0x82120c460) at ../src/backend/tcop/pquery.c:791 [04:47:00.838] _local_sigjmp_buf = {{_sjb = {9235775, 35279869680, 34915533656, 34915533888, 34915533664, 11863832, 11831616, 35279802624, -6347183290304167041, 35279810816, 3552455, 34359738368}}} [04:47:00.838] _save_exception_stack = 0x82120c530 [04:47:00.838] _save_context_stack = 0x0 [04:47:00.838] _do_rethrow = false [04:47:00.838] saveTopTransactionResourceOwner = 0x836d816f0 [04:47:00.838] saveTopTransactionContext = 0x836ca7000 [04:47:00.838] saveActivePortal = 0x0 [04:47:00.838] saveResourceOwner = 0x836d816f0 [04:47:00.838] savePortalContext = 0x0 [04:47:00.838] saveMemoryContext = 0x836ca7000 [04:47:00.838] result = [04:47:00.838] nprocessed = [04:47:00.838] #17 0x00000000008cdcab in exec_simple_query (query_string=query_string@entry=0x836c9b100 "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 [04:47:00.838] cmdtaglen = [04:47:00.838] snapshot_set = [04:47:00.838] per_parsetree_context = 0x0 [04:47:00.838] plantree_list = [04:47:00.838] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:47:00.838] parsetree = 0x844e56fc8 [04:47:00.838] commandTag = CMDTAG_MERGE [04:47:00.838] cmdtagname = [04:47:00.838] querytree_list = [04:47:00.838] portal = 0x836d71100 [04:47:00.838] format = 0 [04:47:00.838] receiver = 0x844efcfa0 [04:47:00.838] parsetree_item__state = {l = 0x844ea5978, i = 0} [04:47:00.838] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [04:47:00.838] dest = DestRemote [04:47:00.838] was_logged = [04:47:00.838] oldcontext = 0x836ca7000 [04:47:00.838] parsetree_list = 0x844ea5978 [04:47:00.838] use_implicit_block = false [04:47:00.838] parsetree_item = 0x844ea5990 [04:47:00.838] save_log_statement_stats = [04:47:00.838] #18 0x00000000008cba94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [04:47:00.838] query_string = 0x836c9b100 "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"... [04:47:00.838] input_message = {data = 0x836c9b100 "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} [04:47:00.838] firstchar = [04:47:00.838] local_sigjmp_buf = {{_sjb = {9219936, 34915534128, 34915534088, 34915534688, 11872568, 11819056, 8192, 8388608, 72057628953412479, 0, 0, 34359738369}}} [04:47:00.838] send_ready_for_query = false [04:47:00.838] idle_in_transaction_timeout_enabled = false [04:47:00.838] idle_session_timeout_enabled = false [04:47:00.838] #19 0x000000000082b1f5 in BackendRun (port=port@entry=0x836d6e000) at ../src/backend/postmaster/postmaster.c:4477 [04:47:00.838] No locals. [04:47:00.838] #20 0x000000000082952d in BackendStartup (port=0x836d6e000) at ../src/backend/postmaster/postmaster.c:4153 [04:47:00.838] bn = 0x836ca70d8 [04:47:00.838] pid = [04:47:00.838] __error = [04:47:00.838] __error = [04:47:00.838] __error = [04:47:00.838] save_errno = [04:47:00.838] __error = [04:47:00.838] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1771 [04:47:00.838] port = 0x836d6e000 [04:47:00.838] i = 0 [04:47:00.838] now = [04:47:00.838] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 567268360, events = 8, fd = 567269384, user_data = 0x821cfdc08}, {pos = 567271432, events = 8, fd = 567272456, user_data = 0x821cfe808}, {pos = 567274504, events = 8, fd = 567275528, user_data = 0x821cff408}, {pos = -1, events = 0, fd = 756486880, user_data = 0x82120c850}, {pos = 756146601, events = 8, fd = 0, user_data = 0x1000}, {pos = -553345958, events = 860922024, fd = 756488168, user_data = 0x836a09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x834714090}, {pos = 555796768, events = 8, fd = 756009260, user_data = 0x1000}, {pos = 754571620, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 567302712, events = 8, fd = 1, user_data = 0x821cff408}, {pos = 754485464, events = 8, fd = 555796904, user_data = 0x82120c760}, {pos = 32, events = 18, fd = 754556004, user_data = 0x821cff408}, {pos = 567302712, events = 8, fd = 0, user_data = 0xa41}, {pos = 555796880, events = 8, fd = 1748842053, user_data = 0x82cf9d964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821d05a38}, {pos = 1, events = 0, fd = 567276552, user_data = 0x836c8b000}, {pos = 1, events = 0, fd = 919122324, user_data = 0x0}, {pos = 555796832, events = 8, fd = 728460300, user_data = 0x1}, {pos = 919121920, events = 8, fd = 555796880, user_data = 0x82b6b5eb4}, {pos = 756298080, events = 8, fd = 756298080, user_data = 0x82cfb50c0}, {pos = 567276552, events = 8, fd = 555797104, user_data = 0x2728683d342c}, {pos = 879837328, events = 8, fd = 1, user_data = 0x2728683d32ae}, {pos = 12240, events = 0, fd = 555796888, user_data = 0x82120ca70}, {pos = 919828456, events = 8, fd = 555798496, user_data = 0x2728683e6e90}, {pos = 567276552, events = 8, fd = 555746175, user_data = 0x82d0ef59c}, {pos = 567246856, events = 8, fd = 0, user_data = 0x821cff408}, {pos = 12240, events = 0, fd = 754421760, user_data = 0x1df950}, {pos = 756298080, events = 8, fd = 754556004, user_data = 0x3d00}, {pos = 555798288, events = 8, fd = 555797216, user_data = 0x82d03e18e }, {pos = 756336696, events = 8, fd = 555797156, user_data = 0x836cf75da}, {pos = 555798288, events = 8, fd = 555797216, user_data = 0x82d054605}, {pos = 555797154, events = 8, fd = 555798288, user_data = 0x82120cf10}, {pos = 0, events = 16777216, fd = -553345958, user_data = 0x82120cf10}, {pos = 919565784, events = 8, fd = 555798496, user_data = 0x82d14c838}, {pos = 0, events = 0, fd = 555798352, user_data = 0x82d05470d}, {pos = 0, events = 0, fd = 0, user_data = 0x82120d080}, {pos = 919565784, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x2728683da409}, {pos = 555797560, events = 8, fd = 754556004, user_data = 0x9c7}, {pos = 1748870153, events = 10024, fd = 555797592, user_data = 0x82cf99c64}, {pos = 2758, events = 0, fd = 754528544, user_data = 0x82120cbd8}, {pos = 567276552, events = 8, fd = 555797592, user_data = 0x82cf93120}, {pos = 555797568, events = 8, fd = 1748849765, user_data = 0x0}, {pos = 0, events = 0, fd = 756437232, user_data = 0x82cf89550}, {pos = 0, events = 0, fd = 0, user_data = 0x82d1539b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x82120ccc8}, {pos = 567296136, events = 8, fd = 1748870153, user_data = 0x82120cd08}, {pos = 754556004, events = 8, fd = 2924, user_data = 0x82cf933b8}, {pos = 555797640, events = 8, fd = 567276552, user_data = 0x82120cd08}, {pos = 754529208, events = 8, fd = 555797744, user_data = 0x2728683d5465}, {pos = 567300152, events = 8, fd = 1, user_data = 0x821cff408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 555798152, events = 0, fd = 2564688, user_data = 0x82120cef0}, {pos = 555798256, events = 8, fd = 555798184, user_data = 0x1e}, {pos = 754492640, events = 8, fd = 555797912, user_data = 0x821d04248}, {pos = 555798360, events = 8, fd = 555797888, user_data = 0x2728683d9da3}, {pos = 567300152, events = 8, fd = 2690673, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567300152, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82120d058}, {pos = 567276552, events = 8, fd = 555798240, user_data = 0x272250}, {pos = 555798432, events = 8, fd = 555798432, user_data = 0x82120cf58}, {pos = 32, events = 0, fd = 555798016, user_data = 0x2728683d9b83}} [04:47:00.838] last_touch_time = 1709527338 [04:47:00.838] last_lockfile_recheck_time = 1709527338 [04:47:00.838] nevents = 1 [04:47:00.838] #22 0x0000000000826840 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82120d718) at ../src/backend/postmaster/postmaster.c:1470 [04:47:00.838] userDoption = [04:47:00.838] listen_addr_saved = false [04:47:00.838] output_config_variable = [04:47:00.838] opt = [04:47:00.838] status = [04:47:00.838] #23 0x0000000000763c85 in main (argc=8, argv=0x82120d718) at ../src/backend/main/main.c:198 [04:47:00.838] do_check_root = [04:47:00.849] [04:47:00.849] [04:47:00.849] [04:47:00.912] dumping /tmp/cores/postgres.6981.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:47:01.037] [New LWP 100107] [04:47:01.103] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [04:47:01.103] Program terminated with signal SIGABRT, Aborted. [04:47:01.103] Sent by thr_kill() from pid 6981 and user 1003. [04:47:01.103] #0 0x000000082a207dca in thr_kill () from /lib/libc.so.7 [04:47:01.704] [04:47:01.704] Thread 1 (LWP 100107): [04:47:01.704] #0 0x000000082a207dca in thr_kill () from /lib/libc.so.7 [04:47:01.704] No symbol table info available. [04:47:01.704] #1 0x000000082a1806f4 in raise () from /lib/libc.so.7 [04:47:01.704] No symbol table info available. [04:47:01.704] #2 0x000000082a231bc9 in abort () from /lib/libc.so.7 [04:47:01.704] No symbol table info available. [04:47:01.704] #3 0x0000000000a1d217 in ExceptionalCondition (conditionName=, fileName=0x36c43c "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [04:47:01.704] No locals. [04:47:01.704] #4 0x000000000070ef40 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821a767e8, materialize=, shouldFree=shouldFree@entry=0x821a766c6) at ../src/backend/executor/execTuples.c:1649 [04:47:01.704] No locals. [04:47:01.704] #5 0x00000000006d6bd8 in ExecIRDeleteTriggers (estate=estate@entry=0x8419e5100, relinfo=relinfo@entry=0x8419e56b0, slot=slot@entry=0x821a767e8) at ../src/backend/commands/trigger.c:2848 [04:47:01.704] trigger = [04:47:01.704] oldtuple = [04:47:01.704] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84191b840, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [04:47:01.704] trigdesc = 0x8419e58c0 [04:47:01.704] newtuple = 0x0 [04:47:01.704] i = 0 [04:47:01.704] should_free = false [04:47:01.704] #6 0x0000000000734664 in ExecMergeMatched (context=0x821a76820, resultRelInfo=0x8419e56b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2980 [04:47:01.704] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [04:47:01.704] commandType = CMD_DELETE [04:47:01.704] result = TM_Ok [04:47:01.704] relaction = [04:47:01.704] l__state = {l = 0x841a22d28, i = 0} [04:47:01.704] mtstate = 0x8419e54a0 [04:47:01.704] estate = 0x1870b [04:47:01.704] econtext = 0x841a22528 [04:47:01.704] epqstate = 0x8419e5588 [04:47:01.704] l = [04:47:01.704] newslot = [04:47:01.704] isNull = [04:47:01.704] __error = [04:47:01.704] l__state = [04:47:01.704] updateCxt = [04:47:01.704] commandType = [04:47:01.704] result = [04:47:01.704] relaction = [04:47:01.704] __error = [04:47:01.704] resultRelationDesc = [04:47:01.704] lockmode = [04:47:01.704] inputslot = [04:47:01.704] epqslot = [04:47:01.704] __error = [04:47:01.704] __error = [04:47:01.704] __error = [04:47:01.704] __error = [04:47:01.704] __error = [04:47:01.704] __error = [04:47:01.704] __error = [04:47:01.704] #7 ExecMerge (context=context@entry=0x821a76820, resultRelInfo=resultRelInfo@entry=0x8419e56b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x821a767e8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2777 [04:47:01.704] matched = [04:47:01.704] #8 0x0000000000733a17 in ExecModifyTable (pstate=0x8419e54a0) at ../src/backend/executor/nodeModifyTable.c:3923 [04:47:01.704] context = {mtstate = 0x8419e54a0, epqstate = 0x8419e5588, estate = 0x8419e5100, planSlot = 0x841a21468, relaction = 0x841a22768, tmfd = {ctid = {ip_blkid = {bi_hi = 20736, bi_lo = 16798}, ip_posid = 8}, xmax = 564619360, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [04:47:01.704] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [04:47:01.704] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x84193c118} [04:47:01.704] node = 0x8419e54a0 [04:47:01.704] estate = 0x8419e5100 [04:47:01.704] operation = CMD_MERGE [04:47:01.704] resultRelInfo = 0x6 [04:47:01.704] subplanstate = 0x8419e6df0 [04:47:01.704] slot = 0x841a21468 [04:47:01.704] tupleid = 0x0 [04:47:01.704] oldtuple = 0x821a767e8 [04:47:01.704] oldSlot = [04:47:01.704] #9 0x00000000007091bb in ExecProcNodeFirst (node=0x8419e54a0) at ../src/backend/executor/execProcnode.c:464 [04:47:01.704] No locals. [04:47:01.704] #10 0x00000000007015aa in ExecProcNode (node=0x8419e54a0) at ../src/include/executor/executor.h:274 [04:47:01.704] No locals. [04:47:01.704] #11 ExecutePlan (estate=0x8419e5100, planstate=0x8419e54a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x841a48f20, execute_once=) at ../src/backend/executor/execMain.c:1647 [04:47:01.704] current_tuple_count = [04:47:01.704] slot = [04:47:01.704] #12 standard_ExecutorRun (queryDesc=0x834874500, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:366 [04:47:01.704] estate = 0x8419e5100 [04:47:01.704] oldcontext = 0x834874400 [04:47:01.704] operation = CMD_MERGE [04:47:01.704] dest = 0x841a48f20 [04:47:01.704] sendTuples = false [04:47:01.704] #13 0x000000000070146f in ExecutorRun (queryDesc=0x1870b, queryDesc@entry=0x834874500, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:310 [04:47:01.704] No locals. [04:47:01.704] #14 0x00000000008cffbf in ProcessQuery (plan=0x841a450a8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821a76b20) at ../src/backend/tcop/pquery.c:160 [04:47:01.704] queryDesc = 0x834874500 [04:47:01.704] #15 0x00000000008cf55d in PortalRunMulti (portal=portal@entry=0x834744100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x841a48f20, altdest=altdest@entry=0x841a48f20, qc=0x821a76b20) at ../src/backend/tcop/pquery.c:1286 [04:47:01.704] pstmt = 0x841a450a8 [04:47:01.704] stmtlist_item__state = {l = 0x841a48ed0, i = 0} [04:47:01.704] active_snapshot_set = true [04:47:01.704] stmtlist_item = 0x841a48ee8 [04:47:01.704] #16 0x00000000008cedcb in PortalRun (portal=portal@entry=0x834744100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82a207daa , dest@entry=0x841a48f20, altdest=0x0, altdest@entry=0x841a48f20, qc=0x821a76b20) at ../src/backend/tcop/pquery.c:791 [04:47:01.704] _local_sigjmp_buf = {{_sjb = {9235775, 35240069168, 34924358168, 34924358400, 34924358176, 11863832, 11831616, 35239772416, -6347183290295319681, 35239780608, 3552455, 34359738368}}} [04:47:01.704] _save_exception_stack = 0x821a76bf0 [04:47:01.704] _save_context_stack = 0x0 [04:47:01.704] _do_rethrow = false [04:47:01.704] saveTopTransactionResourceOwner = 0x83478c830 [04:47:01.704] saveTopTransactionContext = 0x8346b7000 [04:47:01.704] saveActivePortal = 0x0 [04:47:01.704] saveResourceOwner = 0x83478c830 [04:47:01.704] savePortalContext = 0x0 [04:47:01.704] saveMemoryContext = 0x8346b7000 [04:47:01.704] result = [04:47:01.704] nprocessed = [04:47:01.704] #17 0x00000000008cdcab in exec_simple_query (query_string=query_string@entry=0x8346ab100 "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 [04:47:01.704] cmdtaglen = [04:47:01.704] snapshot_set = [04:47:01.704] per_parsetree_context = 0x0 [04:47:01.704] plantree_list = [04:47:01.704] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:47:01.704] parsetree = 0x834853fc8 [04:47:01.704] commandTag = CMDTAG_MERGE [04:47:01.704] cmdtagname = [04:47:01.704] querytree_list = [04:47:01.704] portal = 0x834744100 [04:47:01.704] format = 0 [04:47:01.704] receiver = 0x841a48f20 [04:47:01.704] parsetree_item__state = {l = 0x8419f1478, i = 0} [04:47:01.704] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [04:47:01.704] dest = DestRemote [04:47:01.704] was_logged = [04:47:01.704] oldcontext = 0x8346b7000 [04:47:01.704] parsetree_list = 0x8419f1478 [04:47:01.704] use_implicit_block = false [04:47:01.704] parsetree_item = 0x8419f1490 [04:47:01.704] save_log_statement_stats = [04:47:01.704] #18 0x00000000008cba94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [04:47:01.704] query_string = 0x8346ab100 "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"... [04:47:01.704] input_message = {data = 0x8346ab100 "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} [04:47:01.704] firstchar = [04:47:01.704] local_sigjmp_buf = {{_sjb = {9219936, 34924358640, 34924358600, 34924359200, 11872568, 11819056, 8192, 8388608, 72057628962259839, 0, 0, 34359738369}}} [04:47:01.704] send_ready_for_query = false [04:47:01.704] idle_in_transaction_timeout_enabled = false [04:47:01.704] idle_session_timeout_enabled = false [04:47:01.704] #19 0x000000000082b1f5 in BackendRun (port=port@entry=0x83475e000) at ../src/backend/postmaster/postmaster.c:4477 [04:47:01.704] No locals. [04:47:01.704] #20 0x000000000082952d in BackendStartup (port=0x83475e000) at ../src/backend/postmaster/postmaster.c:4153 [04:47:01.704] bn = 0x8346b7088 [04:47:01.704] pid = [04:47:01.704] __error = [04:47:01.704] __error = [04:47:01.704] __error = [04:47:01.704] save_errno = [04:47:01.704] __error = [04:47:01.704] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1771 [04:47:01.704] port = 0x83475e000 [04:47:01.704] i = 0 [04:47:01.704] now = [04:47:01.704] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 570835976, events = 8, fd = 570837000, user_data = 0x822064c08}, {pos = 570839048, events = 8, fd = 570840072, user_data = 0x822065808}, {pos = 570842120, events = 8, fd = 570843144, user_data = 0x822066408}, {pos = 570863752, events = 8, fd = 564621608, user_data = 0x821a76f50}, {pos = 137137571, events = 15194, fd = 0, user_data = 0x272306}, {pos = 115249317, events = 0, fd = -25761258, user_data = 0x82206c038}, {pos = 1, events = 0, fd = 570844168, user_data = 0x82a0da4a8}, {pos = 564621864, events = 8, fd = 570844168, user_data = 0x21a76f40}, {pos = 705644900, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 570870328, events = 8, fd = 1, user_data = 0x822066408}, {pos = 705558744, events = 8, fd = 564621416, user_data = 0x821a76e20}, {pos = 32, events = 18, fd = 705629284, user_data = 0x822066408}, {pos = 570870328, events = 8, fd = 0, user_data = 0xa41}, {pos = 564621392, events = 8, fd = 137111109, user_data = 0x82a0f4964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x82206ca38}, {pos = 1, events = 0, fd = 570844168, user_data = 0x83469b000}, {pos = 1, events = 0, fd = 879341972, user_data = 0x0}, {pos = 564621344, events = 8, fd = 692493324, user_data = 0x1}, {pos = 879341568, events = 8, fd = 564621392, user_data = 0x829468eb4}, {pos = 707371360, events = 8, fd = 707371360, user_data = 0x82a10c0c0}, {pos = 570844168, events = 8, fd = 564621616, user_data = 0x3b5a082c242c}, {pos = 570843144, events = 8, fd = 1, user_data = 0x3b5a082c22ae}, {pos = 12240, events = 0, fd = 564621400, user_data = 0x821a77130}, {pos = 880121832, events = 8, fd = 564623008, user_data = 0x3b5a082d5e90}, {pos = 570844168, events = 8, fd = 564593535, user_data = 0x82a2464b2}, {pos = 570814472, events = 8, fd = 0, user_data = 0x822066408}, {pos = 12240, events = 0, fd = 705495040, user_data = 0x1df950}, {pos = 707371360, events = 8, fd = 705629284, user_data = 0x3d00}, {pos = 564622800, events = 8, fd = 564621728, user_data = 0x82a19518e }, {pos = 707409976, events = 8, fd = 564621668, user_data = 0x8347095da}, {pos = 564622800, events = 8, fd = 564621728, user_data = 0x82a1ab605}, {pos = 564621666, events = 8, fd = 564622800, user_data = 0x821a775d0}, {pos = 0, events = 16777216, fd = -823980586, user_data = 0x821a775d0}, {pos = 879793624, events = 8, fd = 564623008, user_data = 0x82a2a3838}, {pos = 0, events = 0, fd = 564622864, user_data = 0x82a1ab70d}, {pos = 0, events = 0, fd = 0, user_data = 0x821a77740}, {pos = 879793624, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3b5a082c9409}, {pos = 564622072, events = 8, fd = 705629284, user_data = 0x9c7}, {pos = 137139209, events = 15194, fd = 564622104, user_data = 0x82a0f0c64}, {pos = 2758, events = 0, fd = 705601824, user_data = 0x821a77298}, {pos = 570844168, events = 8, fd = 564622104, user_data = 0x82a0ea120}, {pos = 564622080, events = 8, fd = 137118821, user_data = 0x0}, {pos = 0, events = 0, fd = 707510512, user_data = 0x82a0e0550}, {pos = 0, events = 0, fd = 0, user_data = 0x82a2aa9b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x821a77388}, {pos = 570863752, events = 8, fd = 137139209, user_data = 0x821a773c8}, {pos = 705629284, events = 8, fd = 2924, user_data = 0x82a0ea3b8}, {pos = 564622152, events = 8, fd = 570844168, user_data = 0x821a773c8}, {pos = 705602488, events = 8, fd = 564622256, user_data = 0x3b5a082c4465}, {pos = 570867768, events = 8, fd = 1, user_data = 0x822066408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 564622664, events = 0, fd = 2564688, user_data = 0x821a775b0}, {pos = 564622768, events = 8, fd = 564622696, user_data = 0x1e}, {pos = 705565920, events = 8, fd = 564622424, user_data = 0x82206b248}, {pos = 564622872, events = 8, fd = 564622400, user_data = 0x3b5a082c8da3}, {pos = 570867768, events = 8, fd = 2690673, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 570867768, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821a77718}, {pos = 570844168, events = 8, fd = 564622752, user_data = 0x272250}, {pos = 564622944, events = 8, fd = 564622944, user_data = 0x821a77618}, {pos = 32, events = 0, fd = 564622528, user_data = 0x3b5a082c8b83}} [04:47:01.704] last_touch_time = 1709527340 [04:47:01.704] last_lockfile_recheck_time = 1709527340 [04:47:01.704] nevents = 1 [04:47:01.704] #22 0x0000000000826840 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a77dd8) at ../src/backend/postmaster/postmaster.c:1470 [04:47:01.704] userDoption = [04:47:01.704] listen_addr_saved = false [04:47:01.704] output_config_variable = [04:47:01.704] opt = [04:47:01.704] status = [04:47:01.704] #23 0x0000000000763c85 in main (argc=4, argv=0x821a77dd8) at ../src/backend/main/main.c:198 [04:47:01.704] do_check_root = [04:47:01.715] [04:47:01.715] [04:47:01.715] [04:47:01.777] dumping /tmp/cores/postgres.13711.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:47:01.914] [New LWP 101680] [04:47:01.982] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [04:47:01.982] Program terminated with signal SIGABRT, Aborted. [04:47:01.982] Sent by thr_kill() from pid 13711 and user 1003. [04:47:01.982] #0 0x000000082d582dca in thr_kill () from /lib/libc.so.7 [04:47:02.590] [04:47:02.590] Thread 1 (LWP 101680): [04:47:02.590] #0 0x000000082d582dca in thr_kill () from /lib/libc.so.7 [04:47:02.590] No symbol table info available. [04:47:02.590] #1 0x000000082d4fb6f4 in raise () from /lib/libc.so.7 [04:47:02.590] No symbol table info available. [04:47:02.590] #2 0x000000082d5acbc9 in abort () from /lib/libc.so.7 [04:47:02.590] No symbol table info available. [04:47:02.590] #3 0x0000000000a1d217 in ExceptionalCondition (conditionName=, fileName=0x36c43c "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [04:47:02.590] No locals. [04:47:02.590] #4 0x000000000070ef40 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8212b2ce8, materialize=, shouldFree=shouldFree@entry=0x8212b2bc6) at ../src/backend/executor/execTuples.c:1649 [04:47:02.590] No locals. [04:47:02.590] #5 0x00000000006d6bd8 in ExecIRDeleteTriggers (estate=estate@entry=0x83d371100, relinfo=relinfo@entry=0x83d3716b0, slot=slot@entry=0x8212b2ce8) at ../src/backend/commands/trigger.c:2848 [04:47:02.590] trigger = [04:47:02.590] oldtuple = [04:47:02.590] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83d20d270, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [04:47:02.590] trigdesc = 0x83d3718c0 [04:47:02.590] newtuple = 0x0 [04:47:02.590] i = 0 [04:47:02.590] should_free = false [04:47:02.590] #6 0x0000000000734664 in ExecMergeMatched (context=0x8212b2d20, resultRelInfo=0x83d3716b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2980 [04:47:02.590] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [04:47:02.590] commandType = CMD_DELETE [04:47:02.590] result = TM_Ok [04:47:02.590] relaction = [04:47:02.590] l__state = {l = 0x83d3459e8, i = 0} [04:47:02.590] mtstate = 0x83d3714a0 [04:47:02.590] estate = 0x18d30 [04:47:02.590] econtext = 0x83d3451e8 [04:47:02.590] epqstate = 0x83d371588 [04:47:02.590] l = [04:47:02.590] newslot = [04:47:02.590] isNull = [04:47:02.590] __error = [04:47:02.590] l__state = [04:47:02.590] updateCxt = [04:47:02.590] commandType = [04:47:02.590] result = [04:47:02.590] relaction = [04:47:02.590] __error = [04:47:02.590] resultRelationDesc = [04:47:02.590] lockmode = [04:47:02.590] inputslot = [04:47:02.590] epqslot = [04:47:02.590] __error = [04:47:02.590] __error = [04:47:02.590] __error = [04:47:02.590] __error = [04:47:02.590] __error = [04:47:02.590] __error = [04:47:02.590] __error = [04:47:02.590] #7 ExecMerge (context=context@entry=0x8212b2d20, resultRelInfo=resultRelInfo@entry=0x83d3716b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x8212b2ce8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2777 [04:47:02.590] matched = [04:47:02.590] #8 0x0000000000733a17 in ExecModifyTable (pstate=0x83d3714a0) at ../src/backend/executor/nodeModifyTable.c:3923 [04:47:02.590] context = {mtstate = 0x83d3714a0, epqstate = 0x83d371588, estate = 0x83d371100, planSlot = 0x83d344128, relaction = 0x83d345428, tmfd = {ctid = {ip_blkid = {bi_hi = 63198, bi_lo = 11607}, ip_posid = 8}, xmax = 159, cmax = 0, traversed = 224}, cpUpdateReturningSlot = 0x51c4d33c780e0cc8} [04:47:02.590] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [04:47:02.590] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x837022118} [04:47:02.590] node = 0x83d3714a0 [04:47:02.590] estate = 0x83d371100 [04:47:02.590] operation = CMD_MERGE [04:47:02.590] resultRelInfo = 0x6 [04:47:02.590] subplanstate = 0x83d372df0 [04:47:02.590] slot = 0x83d344128 [04:47:02.590] tupleid = 0x0 [04:47:02.590] oldtuple = 0x8212b2ce8 [04:47:02.590] oldSlot = [04:47:02.590] #9 0x00000000007091bb in ExecProcNodeFirst (node=0x83d3714a0) at ../src/backend/executor/execProcnode.c:464 [04:47:02.590] No locals. [04:47:02.590] #10 0x00000000007015aa in ExecProcNode (node=0x83d3714a0) at ../src/include/executor/executor.h:274 [04:47:02.590] No locals. [04:47:02.590] #11 ExecutePlan (estate=0x83d371100, planstate=0x83d3714a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x83d32dc48, execute_once=) at ../src/backend/executor/execMain.c:1647 [04:47:02.590] current_tuple_count = [04:47:02.590] slot = [04:47:02.590] #12 standard_ExecutorRun (queryDesc=0x836feb900, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:366 [04:47:02.590] estate = 0x83d371100 [04:47:02.590] oldcontext = 0x836feb800 [04:47:02.590] operation = CMD_MERGE [04:47:02.590] dest = 0x83d32dc48 [04:47:02.590] sendTuples = false [04:47:02.590] #13 0x0000000838f28963 in pgss_ExecutorRun (queryDesc=0x836feb900, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [04:47:02.590] _local_sigjmp_buf = {{_sjb = {35315157298, 11863832, 34916216392, 34916216560, 35282401536, 34916216400, 1, 1, 35386753919, 35282401536, 11872560, 34359738368}}} [04:47:02.590] _save_exception_stack = 0x8212b2fd0 [04:47:02.590] _save_context_stack = 0x0 [04:47:02.590] _do_rethrow = false [04:47:02.590] #14 0x0000000000701468 in ExecutorRun (queryDesc=0x18d30, queryDesc@entry=0x836feb900, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:308 [04:47:02.590] No locals. [04:47:02.590] #15 0x00000000008cffbf in ProcessQuery (plan=0x83d329dd0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8212b30d0) at ../src/backend/tcop/pquery.c:160 [04:47:02.590] queryDesc = 0x836feb900 [04:47:02.590] #16 0x00000000008cf55d in PortalRunMulti (portal=portal@entry=0x836ef5100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83d32dc48, altdest=altdest@entry=0x83d32dc48, qc=0x8212b30d0) at ../src/backend/tcop/pquery.c:1286 [04:47:02.590] pstmt = 0x83d329dd0 [04:47:02.590] stmtlist_item__state = {l = 0x83d32dbf8, i = 0} [04:47:02.590] active_snapshot_set = true [04:47:02.590] stmtlist_item = 0x83d32dc10 [04:47:02.590] #17 0x00000000008cedcb in PortalRun (portal=portal@entry=0x836ef5100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82d582daa , dest@entry=0x83d32dc48, altdest=0x0, altdest@entry=0x83d32dc48, qc=0x8212b30d0) at ../src/backend/tcop/pquery.c:791 [04:47:02.590] _local_sigjmp_buf = {{_sjb = {9235775, 35281707904, 34916216776, 34916217008, 34916216784, 11863832, 11831616, 35281391872, -6347183290303446145, 35281400064, 3552455, 34359738368}}} [04:47:02.590] _save_exception_stack = 0x8212b31a0 [04:47:02.590] _save_context_stack = 0x0 [04:47:02.590] _do_rethrow = false [04:47:02.590] saveTopTransactionResourceOwner = 0x836f42380 [04:47:02.590] saveTopTransactionContext = 0x836e66000 [04:47:02.590] saveActivePortal = 0x0 [04:47:02.590] saveResourceOwner = 0x836f42380 [04:47:02.590] savePortalContext = 0x0 [04:47:02.590] saveMemoryContext = 0x836e66000 [04:47:02.590] result = [04:47:02.590] nprocessed = [04:47:02.590] #18 0x00000000008cdcab in exec_simple_query (query_string=query_string@entry=0x836e5a100 "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 [04:47:02.590] cmdtaglen = [04:47:02.590] snapshot_set = [04:47:02.590] per_parsetree_context = 0x0 [04:47:02.590] plantree_list = [04:47:02.590] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:47:02.590] parsetree = 0x836eeafc8 [04:47:02.590] commandTag = CMDTAG_MERGE [04:47:02.590] cmdtagname = [04:47:02.590] querytree_list = [04:47:02.590] portal = 0x836ef5100 [04:47:02.590] format = 0 [04:47:02.590] receiver = 0x83d32dc48 [04:47:02.590] parsetree_item__state = {l = 0x83d2e62b8, i = 0} [04:47:02.590] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [04:47:02.590] dest = DestRemote [04:47:02.590] was_logged = [04:47:02.590] oldcontext = 0x836e66000 [04:47:02.590] parsetree_list = 0x83d2e62b8 [04:47:02.590] use_implicit_block = false [04:47:02.590] parsetree_item = 0x83d2e62d0 [04:47:02.590] save_log_statement_stats = [04:47:02.590] #19 0x00000000008cba94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [04:47:02.590] query_string = 0x836e5a100 "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"... [04:47:02.590] input_message = {data = 0x836e5a100 "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} [04:47:02.590] firstchar = [04:47:02.590] local_sigjmp_buf = {{_sjb = {9219936, 34916217248, 34916217208, 34916217808, 11872568, 11819056, 8192, 8388608, 72057628954133375, 0, 0, 1}}} [04:47:02.590] send_ready_for_query = false [04:47:02.590] idle_in_transaction_timeout_enabled = false [04:47:02.590] idle_session_timeout_enabled = false [04:47:02.590] #20 0x000000000082b1f5 in BackendRun (port=port@entry=0x836f37000) at ../src/backend/postmaster/postmaster.c:4477 [04:47:02.590] No locals. [04:47:02.590] #21 0x000000000082952d in BackendStartup (port=0x836f37000) at ../src/backend/postmaster/postmaster.c:4153 [04:47:02.590] bn = 0x836e660d8 [04:47:02.590] pid = [04:47:02.590] __error = [04:47:02.590] __error = [04:47:02.590] __error = [04:47:02.590] save_errno = [04:47:02.590] __error = [04:47:02.590] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1771 [04:47:02.590] port = 0x836f37000 [04:47:02.590] i = 0 [04:47:02.590] now = [04:47:02.590] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 562564104, events = 8, fd = 562565128, user_data = 0x821881408}, {pos = 562567176, events = 8, fd = 562568200, user_data = 0x821882008}, {pos = 562570248, events = 8, fd = 562589832, user_data = 0x8212b36d8}, {pos = 556479728, events = 8, fd = 664759715, user_data = 0x821882408}, {pos = 2564870, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 562593848, events = 8, fd = 1, user_data = 0x821882408}, {pos = 759518376, events = 8, fd = 556480472, user_data = 0x821882408}, {pos = 556479696, events = 0, fd = 2564688, user_data = 0x8212b3720}, {pos = 759626084, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 562596408, events = 8, fd = 1, user_data = 0x821882408}, {pos = 759539928, events = 8, fd = 556480024, user_data = 0x8212b33c0}, {pos = 33, events = 18, fd = 759610468, user_data = 0x821882408}, {pos = 562596408, events = 8, fd = 0, user_data = 0xa41}, {pos = 556480000, events = 8, fd = 664733253, user_data = 0x82d46f964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821888a38}, {pos = 1, events = 0, fd = 562570248, user_data = 0x836e4a000}, {pos = 1, events = 0, fd = 920953236, user_data = 0x0}, {pos = 556479952, events = 8, fd = 733920268, user_data = 0x1}, {pos = 920952832, events = 8, fd = 556480000, user_data = 0x82bbeaeb4}, {pos = 761352544, events = 8, fd = 761352544, user_data = 0x82d4870c0}, {pos = 562570248, events = 8, fd = 556480224, user_data = 0xfa6279f042c}, {pos = 80627796, events = 0, fd = 1, user_data = 0xfa6279f02ae}, {pos = 12240, events = 0, fd = 556480008, user_data = 0x8212b36e0}, {pos = 921749480, events = 8, fd = 556481616, user_data = 0xfa627a03e90}, {pos = 562570248, events = 8, fd = 556467071, user_data = 0x82d5c14b2}, {pos = 556480528, events = 8, fd = 0, user_data = 0x821882408}, {pos = 12240, events = 0, fd = 759476224, user_data = 0x1df950}, {pos = 761352544, events = 8, fd = 759610468, user_data = 0x3d00}, {pos = 556481408, events = 8, fd = 556480336, user_data = 0x82d51018e }, {pos = 761391160, events = 8, fd = 556480276, user_data = 0x836eb85da}, {pos = 556481408, events = 8, fd = 556480336, user_data = 0x82d526605}, {pos = 556480274, events = 8, fd = 556481408, user_data = 0x8212b3b80}, {pos = 0, events = 16777216, fd = 2014186696, user_data = 0x8212b3b80}, {pos = 921404888, events = 8, fd = 556481616, user_data = 0x82d61e838}, {pos = 0, events = 0, fd = 556481472, user_data = 0x82d52670d}, {pos = 0, events = 0, fd = 0, user_data = 0x8212b3cf0}, {pos = 921404888, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 664761353, events = 4006, fd = 556480664, user_data = 0x82d46bc64}, {pos = 2503, events = 0, fd = 664761353, user_data = 0x8212b38b8}, {pos = 759610468, events = 8, fd = 2758, user_data = 0x82d465120}, {pos = 556480568, events = 8, fd = 562570248, user_data = 0x8212b38b8}, {pos = 759583008, events = 8, fd = 556480672, user_data = 0xfa6279f2465}, {pos = 0, events = 0, fd = 0, user_data = 0x8212b3890}, {pos = 759543120, events = 8, fd = 0, user_data = 0x0}, {pos = 556480624, events = 8, fd = 16, user_data = 0x0}, {pos = 556480808, events = 8, fd = 562589832, user_data = 0xfa6279f7409}, {pos = 556480872, events = 8, fd = 759610468, user_data = 0xb6c}, {pos = 759583672, events = 8, fd = 556480744, user_data = 0x821882408}, {pos = 556480872, events = 8, fd = 759583672, user_data = 0x8212b3950}, {pos = 664740965, events = 4006, fd = 562593848, user_data = 0x800000001}, {pos = 562570248, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 556481272, user_data = 0x272250}, {pos = 556481376, events = 8, fd = 556481376, user_data = 0x8212b3b18}, {pos = 31, events = 0, fd = 0, user_data = 0x8212b39f8}, {pos = 562591624, events = 8, fd = 556481480, user_data = 0x8212b39e0}, {pos = 664759715, events = 4006, fd = 562593848, user_data = 0x290e71}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821888038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556481736, events = 8, fd = 0, user_data = 0x3212b3b50}, {pos = 562591720, events = 8, fd = 556481552, user_data = 0x290}, {pos = 556481480, events = 8, fd = 556481016, user_data = 0x8212b3a60}, {pos = 664759341, events = 4006, fd = 562558984, user_data = 0x0}} [04:47:02.590] last_touch_time = 1709527395 [04:47:02.590] last_lockfile_recheck_time = 1709527395 [04:47:02.590] nevents = 1 [04:47:02.590] #23 0x0000000000826840 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212b4388) at ../src/backend/postmaster/postmaster.c:1470 [04:47:02.590] userDoption = [04:47:02.590] listen_addr_saved = false [04:47:02.590] output_config_variable = [04:47:02.590] opt = [04:47:02.590] status = [04:47:02.590] #24 0x0000000000763c85 in main (argc=4, argv=0x8212b4388) at ../src/backend/main/main.c:198 [04:47:02.590] do_check_root =