[21:42:27.409] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [21:42:27.772] dumping /tmp/cores/postgres.8325.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:42:27.909] [New LWP 101783] [21:42:28.000] Core was generated by `postgres: postgres regression [local] MERGE'. [21:42:28.000] Program terminated with signal SIGABRT, Aborted. [21:42:28.000] Sent by thr_kill() from pid 8325 and user 1003. [21:42:28.000] #0 0x000000082cf85dca in thr_kill () from /lib/libc.so.7 [21:42:28.565] [21:42:28.565] Thread 1 (LWP 101783): [21:42:28.565] #0 0x000000082cf85dca in thr_kill () from /lib/libc.so.7 [21:42:28.565] No symbol table info available. [21:42:28.565] #1 0x000000082cefe6f4 in raise () from /lib/libc.so.7 [21:42:28.565] No symbol table info available. [21:42:28.565] #2 0x000000082cfafbc9 in abort () from /lib/libc.so.7 [21:42:28.565] No symbol table info available. [21:42:28.565] #3 0x0000000000a25b77 in ExceptionalCondition (conditionName=, fileName=0x36ccf4 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [21:42:28.565] No locals. [21:42:28.565] #4 0x0000000000716ac0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8213ad1a8, materialize=, shouldFree=shouldFree@entry=0x8213ad086) at ../src/backend/executor/execTuples.c:1649 [21:42:28.565] No locals. [21:42:28.565] #5 0x00000000006de6b8 in ExecIRDeleteTriggers (estate=estate@entry=0x8442d1100, relinfo=relinfo@entry=0x8442d16b0, slot=slot@entry=0x8213ad1a8) at ../src/backend/commands/trigger.c:2841 [21:42:28.565] trigger = [21:42:28.565] oldtuple = [21:42:28.565] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x847d64d28, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:42:28.565] trigdesc = 0x8442d18c0 [21:42:28.565] newtuple = 0x0 [21:42:28.565] i = 0 [21:42:28.565] should_free = false [21:42:28.565] #6 0x000000000073c1c8 in ExecMergeMatched (context=0x8213ad1e0, resultRelInfo=0x8442d16b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [21:42:28.565] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:42:28.565] commandType = CMD_DELETE [21:42:28.565] result = TM_Ok [21:42:28.565] relaction = [21:42:28.565] l__state = {l = 0x84430ef28, i = 0} [21:42:28.565] mtstate = 0x8442d14a0 [21:42:28.565] estate = 0x18d97 [21:42:28.565] econtext = 0x84430e728 [21:42:28.565] epqstate = 0x8442d1588 [21:42:28.565] l = [21:42:28.565] newslot = [21:42:28.565] isNull = [21:42:28.565] __error = [21:42:28.565] l__state = [21:42:28.565] updateCxt = [21:42:28.565] commandType = [21:42:28.565] result = [21:42:28.565] relaction = [21:42:28.565] __error = [21:42:28.565] resultRelationDesc = [21:42:28.565] lockmode = [21:42:28.565] inputslot = [21:42:28.565] epqslot = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] #7 ExecMerge (context=context@entry=0x8213ad1e0, resultRelInfo=resultRelInfo@entry=0x8442d16b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x8213ad1a8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [21:42:28.565] matched = [21:42:28.565] #8 0x000000000073b577 in ExecModifyTable (pstate=0x8442d14a0) at ../src/backend/executor/nodeModifyTable.c:3950 [21:42:28.565] context = {mtstate = 0x8442d14a0, epqstate = 0x8442d1588, estate = 0x8442d1100, planSlot = 0x84430d668, relaction = 0x84430e968, tmfd = {ctid = {ip_blkid = {bi_hi = 4352, bi_lo = 17453}, ip_posid = 8}, xmax = 557503008, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [21:42:28.565] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [21:42:28.565] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8377fa118} [21:42:28.565] node = 0x8442d14a0 [21:42:28.565] estate = 0x8442d1100 [21:42:28.565] operation = CMD_MERGE [21:42:28.565] resultRelInfo = 0x6 [21:42:28.565] subplanstate = 0x8442d2df0 [21:42:28.565] slot = 0x84430d668 [21:42:28.565] tupleid = 0x0 [21:42:28.565] oldtuple = 0x8213ad1a8 [21:42:28.565] oldSlot = [21:42:28.565] #9 0x0000000000710d3b in ExecProcNodeFirst (node=0x8442d14a0) at ../src/backend/executor/execProcnode.c:464 [21:42:28.565] No locals. [21:42:28.565] #10 0x00000000007090ea in ExecProcNode (node=0x8442d14a0) at ../src/include/executor/executor.h:274 [21:42:28.565] No locals. [21:42:28.565] #11 ExecutePlan (estate=0x8442d1100, planstate=0x8442d14a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=, dest=0x84433b520, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:42:28.565] current_tuple_count = [21:42:28.565] slot = [21:42:28.565] #12 standard_ExecutorRun (queryDesc=0x83788d500, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:42:28.565] estate = 0x8442d1100 [21:42:28.565] oldcontext = 0x83788d400 [21:42:28.565] operation = CMD_MERGE [21:42:28.565] dest = 0x84433b520 [21:42:28.565] sendTuples = false [21:42:28.565] #13 0x0000000000708f9f in ExecutorRun (queryDesc=0x18d97, queryDesc@entry=0x83788d500, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:42:28.565] No locals. [21:42:28.565] #14 0x00000000008d864f in ProcessQuery (plan=0x8443376a8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8213ad4e0) at ../src/backend/tcop/pquery.c:160 [21:42:28.565] queryDesc = 0x83788d500 [21:42:28.565] #15 0x00000000008d7bed in PortalRunMulti (portal=portal@entry=0x8377c8100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x84433b520, altdest=altdest@entry=0x84433b520, qc=0x8213ad4e0) at ../src/backend/tcop/pquery.c:1286 [21:42:28.565] pstmt = 0x8443376a8 [21:42:28.565] stmtlist_item__state = {l = 0x84433b4d0, i = 0} [21:42:28.565] active_snapshot_set = true [21:42:28.565] stmtlist_item = 0x84433b4e8 [21:42:28.565] #16 0x00000000008d745b in PortalRun (portal=portal@entry=0x8377c8100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82cf85daa , dest@entry=0x84433b520, altdest=0x0, altdest@entry=0x84433b520, qc=0x8213ad4e0) at ../src/backend/tcop/pquery.c:791 [21:42:28.565] _local_sigjmp_buf = {{_sjb = {9270223, 35290714968, 34917241816, 34917242048, 34917241824, 11905240, 11873024, 35290644736, -6347183290302463105, 35290652928, 3554704, 34359738368}}} [21:42:28.565] _save_exception_stack = 0x8213ad5b0 [21:42:28.565] _save_context_stack = 0x0 [21:42:28.565] _do_rethrow = false [21:42:28.565] saveTopTransactionResourceOwner = 0x8377d9358 [21:42:28.565] saveTopTransactionContext = 0x8376fe000 [21:42:28.565] saveActivePortal = 0x0 [21:42:28.565] saveResourceOwner = 0x8377d9358 [21:42:28.565] savePortalContext = 0x0 [21:42:28.565] saveMemoryContext = 0x8376fe000 [21:42:28.565] result = [21:42:28.565] nprocessed = [21:42:28.565] #17 0x00000000008d633b in exec_simple_query (query_string=query_string@entry=0x8376f2100 "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:1274 [21:42:28.565] cmdtaglen = [21:42:28.565] snapshot_set = [21:42:28.565] per_parsetree_context = 0x0 [21:42:28.565] plantree_list = [21:42:28.565] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:42:28.565] parsetree = 0x8378c6fc8 [21:42:28.565] commandTag = CMDTAG_MERGE [21:42:28.565] cmdtagname = [21:42:28.565] querytree_list = [21:42:28.565] portal = 0x8377c8100 [21:42:28.565] format = 0 [21:42:28.565] receiver = 0x84433b520 [21:42:28.565] parsetree_item__state = {l = 0x8442dd078, i = 0} [21:42:28.565] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:42:28.565] dest = DestRemote [21:42:28.565] was_logged = [21:42:28.565] oldcontext = 0x8376fe000 [21:42:28.565] parsetree_list = 0x8442dd078 [21:42:28.565] use_implicit_block = false [21:42:28.565] parsetree_item = 0x8442dd090 [21:42:28.565] save_log_statement_stats = [21:42:28.565] #18 0x00000000008d4124 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4678 [21:42:28.565] query_string = 0x8376f2100 "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"... [21:42:28.565] input_message = {data = 0x8376f2100 "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} [21:42:28.565] firstchar = [21:42:28.565] local_sigjmp_buf = {{_sjb = {9254384, 34917242288, 34917242248, 34917242848, 11913976, 11860448, 8192, 8388608, 72057628955116415, 0, 0, 34359738369}}} [21:42:28.565] send_ready_for_query = false [21:42:28.565] idle_in_transaction_timeout_enabled = false [21:42:28.565] idle_session_timeout_enabled = false [21:42:28.565] #19 0x0000000000832dba in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [21:42:28.565] No locals. [21:42:28.565] #20 0x0000000000831040 in BackendStartup (client_sock=0x8213ae208) at ../src/backend/postmaster/postmaster.c:4117 [21:42:28.565] bn = 0x8376fe448 [21:42:28.565] cac = CAC_OK [21:42:28.565] pid = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] __error = [21:42:28.565] save_errno = [21:42:28.565] __error = [21:42:28.565] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [21:42:28.565] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X\254\002-\000\000\000\000\001\000\000\000\000\000\000\000p\354\264", '\000' , "`ĵ\000\000\000\000\000\v\000\000\000\000\000\000\000\200\342:!\b\000\000\000\330%\237+\b\000\000\000p\354\264\000\000\000\000\000\016\246\237+\b", '\000' , "\300\342:!\b\000\000\0004\301\202\000\000\000\000"}, salen = 16}} [21:42:28.565] i = 0 [21:42:28.565] now = [21:42:28.565] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 753331300, events = 8, fd = 557504592, user_data = 0x8213ad9e0}, {pos = 563102728, events = 8, fd = 32, user_data = 0x8213ad9d0}, {pos = -651011436, events = 1869, fd = 563073032, user_data = 0x8218fd408}, {pos = 563075080, events = 8, fd = 563076104, user_data = 0x821901008}, {pos = 563090440, events = 8, fd = 563091464, user_data = 0x821901c08}, {pos = 563093512, events = 8, fd = 563094536, user_data = 0x821902808}, {pos = 563096584, events = 8, fd = 563097608, user_data = 0x821903408}, {pos = 563099656, events = 8, fd = 563100680, user_data = 0x821904008}, {pos = 563102728, events = 8, fd = -1, user_data = 0x82d0462e0}, {pos = 557504832, events = 8, fd = 754921897, user_data = 0x0}, {pos = 4096, events = 0, fd = -333777110, user_data = 0x82d0467e8}, {pos = 916495328, events = 8, fd = 160, user_data = 0x0}, {pos = 891797648, events = 8, fd = 557505040, user_data = 0x82cfd192c}, {pos = 4096, events = 0, fd = 753346916, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 563128888, user_data = 0x800000001}, {pos = 563102728, events = 8, fd = 753260760, user_data = 0x8213ada98}, {pos = 557504592, events = 8, fd = 32, user_data = 0x82ce6ec64}, {pos = 563102728, events = 8, fd = 563128888, user_data = 0x0}, {pos = 2625, events = 0, fd = 557505152, user_data = 0x74dd9325645}, {pos = 753346916, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 563128888, events = 8, fd = 1, user_data = 0x821904408}, {pos = 929964032, events = 8, fd = 1, user_data = 0x8376e2194}, {pos = 0, events = 0, fd = 557505104, user_data = 0x82b9f9c0c}, {pos = 1, events = 0, fd = 929964032, user_data = 0x8213ada80}, {pos = 731877044, events = 8, fd = 755073376, user_data = 0x82d018160 }, {pos = 753443008, events = 8, fd = 563102728, user_data = 0x8213adb60}, {pos = -651013076, events = 1869, fd = 891797648, user_data = 0x800000001}, {pos = -651013458, events = 1869, fd = 12240, user_data = 0x8213ada88}, {pos = 557505376, events = 8, fd = 930670568, user_data = 0x8213ae0d0}, {pos = -650932592, events = 1869, fd = 563102728, user_data = 0x8213a037f}, {pos = 754730396, events = 8, fd = 563073032, user_data = 0x0}, {pos = 563102728, events = 8, fd = 12240, user_data = 0x82ce4e000}, {pos = 1964368, events = 0, fd = 755073376, user_data = 0x82ce6ec64}, {pos = 15616, events = 0, fd = 557506560, user_data = 0x8213adbd0}, {pos = 754004366, events = 8, fd = 755111992, user_data = 0x8213adb94}, {pos = 930407898, events = 8, fd = 557506560, user_data = 0x8213adbd0}, {pos = 754095621, events = 8, fd = 557505426, user_data = 0x8213ae000}, {pos = 557506560, events = 8, fd = 0, user_data = 0x6bc8afeeec1af72a}, {pos = 557506560, events = 8, fd = 930407896, user_data = 0x8213ae0d0}, {pos = 755111992, events = 8, fd = 0, user_data = 0x8213ae040}, {pos = 754095885, events = 8, fd = 0, user_data = 0x0}, {pos = 557506928, events = 8, fd = 930407896, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -650984439, events = 1869, fd = 557505832, user_data = 0x82ce6ec64}, {pos = 2503, events = 0, fd = -650984439, user_data = 0x8213add48}, {pos = 753331300, events = 8, fd = 2758, user_data = 0x82ce68120}, {pos = 557505736, events = 8, fd = 563102728, user_data = 0x8213add48}, {pos = 753303840, events = 8, fd = 557505840, user_data = 0x74dd9327465}, {pos = 0, events = 0, fd = 0, user_data = 0x82d03a0f0}, {pos = 753263952, events = 8, fd = 0, user_data = 0x0}, {pos = 755141040, events = 8, fd = 16, user_data = 0x0}, {pos = 557505976, events = 8, fd = 563122312, user_data = 0x74dd932c409}, {pos = 557506040, events = 8, fd = 753331300, user_data = 0xb6c}, {pos = 753304504, events = 8, fd = 557505912, user_data = 0x821904408}, {pos = 557506040, events = 8, fd = 753304504, user_data = 0x8213adde0}, {pos = -651004827, events = 1869, fd = 563126328, user_data = 0x800000001}, {pos = 563102728, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 557506424, user_data = 0x272620}, {pos = 557506528, events = 8, fd = 557506528, user_data = 0x8213adf98}, {pos = 30, events = 0, fd = 753267936, user_data = 0x8213ade88}, {pos = 563122760, events = 8, fd = 557506632, user_data = 0x8213ade70}, {pos = -650986077, events = 1869, fd = 563126328, user_data = 0x29123d}} [21:42:28.565] last_touch_time = 1710452371 [21:42:28.565] last_lockfile_recheck_time = 1710452371 [21:42:28.565] nevents = 1 [21:42:28.565] #22 0x000000000082e336 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8213ae808) at ../src/backend/postmaster/postmaster.c:1478 [21:42:28.565] userDoption = [21:42:28.565] listen_addr_saved = false [21:42:28.565] output_config_variable = [21:42:28.565] opt = [21:42:28.565] status = [21:42:28.565] #23 0x000000000076b895 in main (argc=8, argv=0x8213ae808) at ../src/backend/main/main.c:197 [21:42:28.565] do_check_root = [21:42:28.577] [21:42:28.577] [21:42:28.577] [21:42:28.638] dumping /tmp/cores/postgres.9289.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:42:28.764] [New LWP 101733] [21:42:28.834] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [21:42:28.834] Program terminated with signal SIGABRT, Aborted. [21:42:28.834] Sent by thr_kill() from pid 9289 and user 1003. [21:42:28.834] #0 0x000000082db1bdca in thr_kill () from /lib/libc.so.7 [21:42:29.383] [21:42:29.383] Thread 1 (LWP 101733): [21:42:29.383] #0 0x000000082db1bdca in thr_kill () from /lib/libc.so.7 [21:42:29.383] No symbol table info available. [21:42:29.383] #1 0x000000082da946f4 in raise () from /lib/libc.so.7 [21:42:29.383] No symbol table info available. [21:42:29.383] #2 0x000000082db45bc9 in abort () from /lib/libc.so.7 [21:42:29.383] No symbol table info available. [21:42:29.383] #3 0x0000000000a25b77 in ExceptionalCondition (conditionName=, fileName=0x36ccf4 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [21:42:29.383] No locals. [21:42:29.383] #4 0x0000000000716ac0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821af4778, materialize=, shouldFree=shouldFree@entry=0x821af4656) at ../src/backend/executor/execTuples.c:1649 [21:42:29.383] No locals. [21:42:29.383] #5 0x00000000006de6b8 in ExecIRDeleteTriggers (estate=estate@entry=0x8393c1100, relinfo=relinfo@entry=0x8393c16b0, slot=slot@entry=0x821af4778) at ../src/backend/commands/trigger.c:2841 [21:42:29.383] trigger = [21:42:29.383] oldtuple = [21:42:29.383] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8392f6f60, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:42:29.383] trigdesc = 0x8393c18c0 [21:42:29.383] newtuple = 0x0 [21:42:29.383] i = 0 [21:42:29.383] should_free = false [21:42:29.383] #6 0x000000000073c1c8 in ExecMergeMatched (context=0x821af47b0, resultRelInfo=0x8393c16b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [21:42:29.383] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:42:29.383] commandType = CMD_DELETE [21:42:29.383] result = TM_Ok [21:42:29.383] relaction = [21:42:29.383] l__state = {l = 0x8393fed68, i = 0} [21:42:29.383] mtstate = 0x8393c14a0 [21:42:29.383] estate = 0x18d65 [21:42:29.383] econtext = 0x8393fe568 [21:42:29.383] epqstate = 0x8393c1588 [21:42:29.383] l = [21:42:29.383] newslot = [21:42:29.383] isNull = [21:42:29.383] __error = [21:42:29.383] l__state = [21:42:29.383] updateCxt = [21:42:29.383] commandType = [21:42:29.383] result = [21:42:29.383] relaction = [21:42:29.383] __error = [21:42:29.383] resultRelationDesc = [21:42:29.383] lockmode = [21:42:29.383] inputslot = [21:42:29.383] epqslot = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] #7 ExecMerge (context=context@entry=0x821af47b0, resultRelInfo=resultRelInfo@entry=0x8393c16b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x821af4778, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [21:42:29.383] matched = [21:42:29.383] #8 0x000000000073b577 in ExecModifyTable (pstate=0x8393c14a0) at ../src/backend/executor/nodeModifyTable.c:3950 [21:42:29.383] context = {mtstate = 0x8393c14a0, epqstate = 0x8393c1588, estate = 0x8393c1100, planSlot = 0x8393fd4a8, relaction = 0x8393fe7a8, tmfd = {ctid = {ip_blkid = {bi_hi = 4352, bi_lo = 14652}, ip_posid = 8}, xmax = 565135344, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [21:42:29.383] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [21:42:29.383] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836a6b118} [21:42:29.383] node = 0x8393c14a0 [21:42:29.383] estate = 0x8393c1100 [21:42:29.383] operation = CMD_MERGE [21:42:29.383] resultRelInfo = 0x6 [21:42:29.383] subplanstate = 0x8393c2df0 [21:42:29.383] slot = 0x8393fd4a8 [21:42:29.383] tupleid = 0x0 [21:42:29.383] oldtuple = 0x821af4778 [21:42:29.383] oldSlot = [21:42:29.383] #9 0x0000000000710d3b in ExecProcNodeFirst (node=0x8393c14a0) at ../src/backend/executor/execProcnode.c:464 [21:42:29.383] No locals. [21:42:29.383] #10 0x00000000007090ea in ExecProcNode (node=0x8393c14a0) at ../src/include/executor/executor.h:274 [21:42:29.383] No locals. [21:42:29.383] #11 ExecutePlan (estate=0x8393c1100, planstate=0x8393c14a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=, dest=0x839424320, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:42:29.383] current_tuple_count = [21:42:29.383] slot = [21:42:29.383] #12 standard_ExecutorRun (queryDesc=0x8368f0d00, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:42:29.383] estate = 0x8393c1100 [21:42:29.383] oldcontext = 0x8368f0c00 [21:42:29.383] operation = CMD_MERGE [21:42:29.383] dest = 0x839424320 [21:42:29.383] sendTuples = false [21:42:29.383] #13 0x0000000000708f9f in ExecutorRun (queryDesc=0x18d65, queryDesc@entry=0x8368f0d00, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:42:29.383] No locals. [21:42:29.383] #14 0x00000000008d864f in ProcessQuery (plan=0x8394204a8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821af4ab0) at ../src/backend/tcop/pquery.c:160 [21:42:29.383] queryDesc = 0x8368f0d00 [21:42:29.383] #15 0x00000000008d7bed in PortalRunMulti (portal=portal@entry=0x836952100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x839424320, altdest=altdest@entry=0x839424320, qc=0x821af4ab0) at ../src/backend/tcop/pquery.c:1286 [21:42:29.383] pstmt = 0x8394204a8 [21:42:29.383] stmtlist_item__state = {l = 0x8394242d0, i = 0} [21:42:29.383] active_snapshot_set = true [21:42:29.383] stmtlist_item = 0x8394242e8 [21:42:29.383] #16 0x00000000008d745b in PortalRun (portal=portal@entry=0x836952100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82db1bdaa , dest@entry=0x839424320, altdest=0x0, altdest@entry=0x839424320, qc=0x821af4ab0) at ../src/backend/tcop/pquery.c:791 [21:42:29.383] _local_sigjmp_buf = {{_sjb = {9270223, 35275818968, 34924874152, 34924874384, 34924874160, 11905240, 11873024, 35275481344, -6347183290294795393, 35275489536, 3554704, 34359738368}}} [21:42:29.383] _save_exception_stack = 0x821af4b80 [21:42:29.383] _save_context_stack = 0x0 [21:42:29.383] _do_rethrow = false [21:42:29.383] saveTopTransactionResourceOwner = 0x8369a47d8 [21:42:29.383] saveTopTransactionContext = 0x8368c5000 [21:42:29.383] saveActivePortal = 0x0 [21:42:29.383] saveResourceOwner = 0x8369a47d8 [21:42:29.383] savePortalContext = 0x0 [21:42:29.383] saveMemoryContext = 0x8368c5000 [21:42:29.383] result = [21:42:29.383] nprocessed = [21:42:29.383] #17 0x00000000008d633b in exec_simple_query (query_string=query_string@entry=0x8368b9100 "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:1274 [21:42:29.383] cmdtaglen = [21:42:29.383] snapshot_set = [21:42:29.383] per_parsetree_context = 0x0 [21:42:29.383] plantree_list = [21:42:29.383] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:42:29.383] parsetree = 0x83937bfc8 [21:42:29.383] commandTag = CMDTAG_MERGE [21:42:29.383] cmdtagname = [21:42:29.383] querytree_list = [21:42:29.383] portal = 0x836952100 [21:42:29.383] format = 0 [21:42:29.383] receiver = 0x839424320 [21:42:29.383] parsetree_item__state = {l = 0x8393ccf38, i = 0} [21:42:29.383] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:42:29.383] dest = DestRemote [21:42:29.383] was_logged = [21:42:29.383] oldcontext = 0x8368c5000 [21:42:29.383] parsetree_list = 0x8393ccf38 [21:42:29.383] use_implicit_block = false [21:42:29.383] parsetree_item = 0x8393ccf50 [21:42:29.383] save_log_statement_stats = [21:42:29.383] #18 0x00000000008d4124 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4678 [21:42:29.383] query_string = 0x8368b9100 "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"... [21:42:29.383] input_message = {data = 0x8368b9100 "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} [21:42:29.383] firstchar = [21:42:29.383] local_sigjmp_buf = {{_sjb = {9254384, 34924874624, 34924874584, 34924875184, 11913976, 11860448, 8192, 8388608, 72057628962784127, 0, 0, 34359738369}}} [21:42:29.383] send_ready_for_query = false [21:42:29.383] idle_in_transaction_timeout_enabled = false [21:42:29.383] idle_session_timeout_enabled = false [21:42:29.383] #19 0x0000000000832dba in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [21:42:29.383] No locals. [21:42:29.383] #20 0x0000000000831040 in BackendStartup (client_sock=0x821af57d8) at ../src/backend/postmaster/postmaster.c:4117 [21:42:29.383] bn = 0x8368c54e8 [21:42:29.383] cac = CAC_OK [21:42:29.383] pid = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] __error = [21:42:29.383] save_errno = [21:42:29.383] __error = [21:42:29.383] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [21:42:29.383] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X\f\274-\000\000\000\000\001\000\000\000\000\000\000\000p\354\264", '\000' , "`ĵ\000\000\000\000\000\v\000\000\000\000\000\000\000PX\257!\b\000\000\000\330ey,\b\000\000\000p\354\264\000\000\000\000\000\016\346y,\b", '\000' , "\220X\257!\b\000\000\0004\301\202\000\000\000\000"}, salen = 16}} [21:42:29.383] i = 0 [21:42:29.383] now = [21:42:29.383] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 765480036, events = 8, fd = 565136928, user_data = 0x821af4fb0}, {pos = 568140808, events = 8, fd = 32, user_data = 0x821af4fa0}, {pos = 482552468, events = 2314, fd = 568111112, user_data = 0x821dcb408}, {pos = 568113160, events = 8, fd = 568114184, user_data = 0x821dcf008}, {pos = 568128520, events = 8, fd = 568129544, user_data = 0x821dcfc08}, {pos = 568131592, events = 8, fd = 568132616, user_data = 0x821dd0808}, {pos = 568134664, events = 8, fd = 568135688, user_data = 0x821dd1408}, {pos = 568137736, events = 8, fd = 568138760, user_data = 0x821dd2008}, {pos = 568140808, events = 8, fd = 568160392, user_data = 0x821af5128}, {pos = 565137232, events = 8, fd = 482577827, user_data = 0x0}, {pos = 2565846, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 568164408, events = 8, fd = 1, user_data = 0x821dd2408}, {pos = 765387944, events = 8, fd = 565137960, user_data = 0x821dd2408}, {pos = 565137216, events = 0, fd = 765495652, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 568166968, user_data = 0x1}, {pos = 568140808, events = 8, fd = 765409496, user_data = 0x821af5068}, {pos = 565136928, events = 8, fd = 32, user_data = 0x82da04c64}, {pos = 568140808, events = 8, fd = 568166968, user_data = 0x0}, {pos = 2625, events = 0, fd = 565137488, user_data = 0x90a1cc32645}, {pos = 765495652, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 568166968, events = 8, fd = 1, user_data = 0x821dd2408}, {pos = 915050496, events = 8, fd = 1, user_data = 0x8368a9194}, {pos = 0, events = 0, fd = 565137440, user_data = 0x82c79dc0c}, {pos = 1, events = 0, fd = 915050496, user_data = 0x821af5050}, {pos = 746180276, events = 8, fd = 767222112, user_data = 0x82dbae160 }, {pos = 765591744, events = 8, fd = 568140808, user_data = 0x821af5130}, {pos = 482550828, events = 2314, fd = 568139784, user_data = 0x800000001}, {pos = 482550446, events = 2314, fd = 12240, user_data = 0x821af5058}, {pos = 565137712, events = 8, fd = 915847144, user_data = 0x821af56a0}, {pos = 482631312, events = 2314, fd = 568140808, user_data = 0x821af037f}, {pos = 766878898, events = 8, fd = 568111112, user_data = 0x0}, {pos = 568140808, events = 8, fd = 12240, user_data = 0x82d9e4000}, {pos = 1964368, events = 0, fd = 767222112, user_data = 0x82da04c64}, {pos = 15616, events = 0, fd = 565138896, user_data = 0x821af51a0}, {pos = 766153102, events = 8, fd = 767260728, user_data = 0x821af5164}, {pos = 915502554, events = 8, fd = 565138896, user_data = 0x821af51a0}, {pos = 766244357, events = 8, fd = 565137762, user_data = 0x821af55d0}, {pos = 565138896, events = 8, fd = 0, user_data = 0x6fea82bc1b4da7}, {pos = 565138896, events = 8, fd = 915502552, user_data = 0x821af56a0}, {pos = 767260728, events = 8, fd = 0, user_data = 0x821af5610}, {pos = 766244621, events = 8, fd = 0, user_data = 0x0}, {pos = 565139264, events = 8, fd = 915502552, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 482579465, events = 2314, fd = 565138168, user_data = 0x82da04c64}, {pos = 2503, events = 0, fd = 482579465, user_data = 0x821af5318}, {pos = 765480036, events = 8, fd = 2758, user_data = 0x82d9fe120}, {pos = 565138072, events = 8, fd = 568140808, user_data = 0x821af5318}, {pos = 765452576, events = 8, fd = 565138176, user_data = 0x90a1cc34465}, {pos = 0, events = 0, fd = 0, user_data = 0x82dbd00f0}, {pos = 765412688, events = 8, fd = 0, user_data = 0x0}, {pos = 767289776, events = 8, fd = 16, user_data = 0x0}, {pos = 565138312, events = 8, fd = 568160392, user_data = 0x90a1cc39409}, {pos = 565138376, events = 8, fd = 765480036, user_data = 0xb6c}, {pos = 765453240, events = 8, fd = 565138248, user_data = 0x821dd2408}, {pos = 565138376, events = 8, fd = 765453240, user_data = 0x821af53b0}, {pos = 482559077, events = 2314, fd = 568164408, user_data = 0x800000001}, {pos = 568140808, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 565138760, user_data = 0x272620}, {pos = 565138864, events = 8, fd = 565138864, user_data = 0x821af5568}, {pos = 30, events = 0, fd = 765416672, user_data = 0x821af5458}, {pos = 568160840, events = 8, fd = 565138968, user_data = 0x821af5440}, {pos = 482577827, events = 2314, fd = 568164408, user_data = 0x29123d}} [21:42:29.383] last_touch_time = 1710452373 [21:42:29.383] last_lockfile_recheck_time = 1710452373 [21:42:29.383] nevents = 1 [21:42:29.383] #22 0x000000000082e336 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821af5dd8) at ../src/backend/postmaster/postmaster.c:1478 [21:42:29.383] userDoption = [21:42:29.383] listen_addr_saved = false [21:42:29.383] output_config_variable = [21:42:29.383] opt = [21:42:29.383] status = [21:42:29.383] #23 0x000000000076b895 in main (argc=4, argv=0x821af5dd8) at ../src/backend/main/main.c:197 [21:42:29.383] do_check_root = [21:42:29.393] [21:42:29.393] [21:42:29.393] [21:42:29.453] dumping /tmp/cores/postgres.14910.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:42:29.578] [New LWP 101703] [21:42:29.647] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [21:42:29.647] Program terminated with signal SIGABRT, Aborted. [21:42:29.647] Sent by thr_kill() from pid 14910 and user 1003. [21:42:29.647] #0 0x000000082b390dca in thr_kill () from /lib/libc.so.7 [21:42:30.206] [21:42:30.206] Thread 1 (LWP 101703): [21:42:30.206] #0 0x000000082b390dca in thr_kill () from /lib/libc.so.7 [21:42:30.206] No symbol table info available. [21:42:30.206] #1 0x000000082b3096f4 in raise () from /lib/libc.so.7 [21:42:30.206] No symbol table info available. [21:42:30.206] #2 0x000000082b3babc9 in abort () from /lib/libc.so.7 [21:42:30.206] No symbol table info available. [21:42:30.206] #3 0x0000000000a25b77 in ExceptionalCondition (conditionName=, fileName=0x36ccf4 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [21:42:30.206] No locals. [21:42:30.206] #4 0x0000000000716ac0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820f5b478, materialize=, shouldFree=shouldFree@entry=0x820f5b356) at ../src/backend/executor/execTuples.c:1649 [21:42:30.206] No locals. [21:42:30.206] #5 0x00000000006de6b8 in ExecIRDeleteTriggers (estate=estate@entry=0x83d757100, relinfo=relinfo@entry=0x83d7576b0, slot=slot@entry=0x820f5b478) at ../src/backend/commands/trigger.c:2841 [21:42:30.206] trigger = [21:42:30.206] oldtuple = [21:42:30.206] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83d5d27d8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:42:30.206] trigdesc = 0x83d7578c0 [21:42:30.206] newtuple = 0x0 [21:42:30.206] i = 0 [21:42:30.206] should_free = false [21:42:30.206] #6 0x000000000073c1c8 in ExecMergeMatched (context=0x820f5b4b0, resultRelInfo=0x83d7576b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [21:42:30.206] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:42:30.206] commandType = CMD_DELETE [21:42:30.206] result = TM_Ok [21:42:30.206] relaction = [21:42:30.206] l__state = {l = 0x83d6ed728, i = 0} [21:42:30.206] mtstate = 0x83d7574a0 [21:42:30.206] estate = 0x18d47 [21:42:30.206] econtext = 0x83d6ecf28 [21:42:30.206] epqstate = 0x83d757588 [21:42:30.206] l = [21:42:30.206] newslot = [21:42:30.206] isNull = [21:42:30.206] __error = [21:42:30.206] l__state = [21:42:30.206] updateCxt = [21:42:30.206] commandType = [21:42:30.206] result = [21:42:30.206] relaction = [21:42:30.206] __error = [21:42:30.206] resultRelationDesc = [21:42:30.206] lockmode = [21:42:30.206] inputslot = [21:42:30.206] epqslot = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] #7 ExecMerge (context=context@entry=0x820f5b4b0, resultRelInfo=resultRelInfo@entry=0x83d7576b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820f5b478, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [21:42:30.206] matched = [21:42:30.206] #8 0x000000000073b577 in ExecModifyTable (pstate=0x83d7574a0) at ../src/backend/executor/nodeModifyTable.c:3950 [21:42:30.206] context = {mtstate = 0x83d7574a0, epqstate = 0x83d757588, estate = 0x83d757100, planSlot = 0x83d6ebe68, relaction = 0x83d6ed168, tmfd = {ctid = {ip_blkid = {bi_hi = 55006, bi_lo = 11064}, ip_posid = 8}, xmax = 136, cmax = 0, traversed = 200}, cpUpdateReturningSlot = 0xde05aeb7106c8586} [21:42:30.206] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [21:42:30.206] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836bf4118} [21:42:30.206] node = 0x83d7574a0 [21:42:30.206] estate = 0x83d757100 [21:42:30.206] operation = CMD_MERGE [21:42:30.206] resultRelInfo = 0x6 [21:42:30.206] subplanstate = 0x83d758df0 [21:42:30.206] slot = 0x83d6ebe68 [21:42:30.206] tupleid = 0x0 [21:42:30.206] oldtuple = 0x820f5b478 [21:42:30.206] oldSlot = [21:42:30.206] #9 0x0000000000710d3b in ExecProcNodeFirst (node=0x83d7574a0) at ../src/backend/executor/execProcnode.c:464 [21:42:30.206] No locals. [21:42:30.206] #10 0x00000000007090ea in ExecProcNode (node=0x83d7574a0) at ../src/include/executor/executor.h:274 [21:42:30.206] No locals. [21:42:30.206] #11 ExecutePlan (estate=0x83d757100, planstate=0x83d7574a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=, dest=0x83d715c48, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:42:30.206] current_tuple_count = [21:42:30.206] slot = [21:42:30.206] #12 standard_ExecutorRun (queryDesc=0x836bbe100, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:42:30.206] estate = 0x83d757100 [21:42:30.206] oldcontext = 0x836bbe000 [21:42:30.206] operation = CMD_MERGE [21:42:30.206] dest = 0x83d715c48 [21:42:30.206] sendTuples = false [21:42:30.206] #13 0x00000008392d6963 in pgss_ExecutorRun (queryDesc=0x836bbe100, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [21:42:30.206] _local_sigjmp_buf = {{_sjb = {35319015730, 11905240, 34912712152, 34912712320, 35278020864, 34912712160, 1, 1, 35390817151, 35278020864, 11913968, 34359738368}}} [21:42:30.206] _save_exception_stack = 0x820f5b760 [21:42:30.206] _save_context_stack = 0x0 [21:42:30.206] _do_rethrow = false [21:42:30.206] #14 0x0000000000708f98 in ExecutorRun (queryDesc=0x18d47, queryDesc@entry=0x836bbe100, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [21:42:30.206] No locals. [21:42:30.206] #15 0x00000000008d864f in ProcessQuery (plan=0x83d711dd0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820f5b860) at ../src/backend/tcop/pquery.c:160 [21:42:30.206] queryDesc = 0x836bbe100 [21:42:30.206] #16 0x00000000008d7bed in PortalRunMulti (portal=portal@entry=0x836ac9100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83d715c48, altdest=altdest@entry=0x83d715c48, qc=0x820f5b860) at ../src/backend/tcop/pquery.c:1286 [21:42:30.206] pstmt = 0x83d711dd0 [21:42:30.206] stmtlist_item__state = {l = 0x83d715bf8, i = 0} [21:42:30.206] active_snapshot_set = true [21:42:30.206] stmtlist_item = 0x83d715c10 [21:42:30.206] #17 0x00000000008d745b in PortalRun (portal=portal@entry=0x836ac9100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82b390daa , dest@entry=0x83d715c48, altdest=0x0, altdest@entry=0x83d715c48, qc=0x820f5b860) at ../src/backend/tcop/pquery.c:791 [21:42:30.206] _local_sigjmp_buf = {{_sjb = {9270223, 35277303808, 34912712536, 34912712768, 34912712544, 11905240, 11873024, 35277017344, -6347183290306985089, 35277025536, 3554704, 34359738368}}} [21:42:30.206] _save_exception_stack = 0x820f5b930 [21:42:30.206] _save_context_stack = 0x0 [21:42:30.206] _do_rethrow = false [21:42:30.206] saveTopTransactionResourceOwner = 0x836b0f000 [21:42:30.206] saveTopTransactionContext = 0x836a3a000 [21:42:30.206] saveActivePortal = 0x0 [21:42:30.206] saveResourceOwner = 0x836b0f000 [21:42:30.206] savePortalContext = 0x0 [21:42:30.206] saveMemoryContext = 0x836a3a000 [21:42:30.206] result = [21:42:30.206] nprocessed = [21:42:30.206] #18 0x00000000008d633b in exec_simple_query (query_string=query_string@entry=0x836a2e100 "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:1274 [21:42:30.206] cmdtaglen = [21:42:30.206] snapshot_set = [21:42:30.206] per_parsetree_context = 0x0 [21:42:30.206] plantree_list = [21:42:30.206] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:42:30.206] parsetree = 0x836abefc8 [21:42:30.206] commandTag = CMDTAG_MERGE [21:42:30.206] cmdtagname = [21:42:30.206] querytree_list = [21:42:30.206] portal = 0x836ac9100 [21:42:30.206] format = 0 [21:42:30.206] receiver = 0x83d715c48 [21:42:30.206] parsetree_item__state = {l = 0x83d6ce778, i = 0} [21:42:30.206] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:42:30.206] dest = DestRemote [21:42:30.206] was_logged = [21:42:30.206] oldcontext = 0x836a3a000 [21:42:30.206] parsetree_list = 0x83d6ce778 [21:42:30.206] use_implicit_block = false [21:42:30.206] parsetree_item = 0x83d6ce790 [21:42:30.206] save_log_statement_stats = [21:42:30.206] #19 0x00000000008d4124 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4678 [21:42:30.206] query_string = 0x836a2e100 "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"... [21:42:30.206] input_message = {data = 0x836a2e100 "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} [21:42:30.206] firstchar = [21:42:30.206] local_sigjmp_buf = {{_sjb = {9254384, 34912713008, 34912712968, 34912713568, 11913976, 11860448, 8192, 8388608, 72057628950594431, 0, 0, 1}}} [21:42:30.206] send_ready_for_query = false [21:42:30.206] idle_in_transaction_timeout_enabled = false [21:42:30.206] idle_session_timeout_enabled = false [21:42:30.206] #20 0x0000000000832dba in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [21:42:30.206] No locals. [21:42:30.206] #21 0x0000000000831040 in BackendStartup (client_sock=0x820f5c588) at ../src/backend/postmaster/postmaster.c:4117 [21:42:30.206] bn = 0x836a3a178 [21:42:30.206] cac = CAC_OK [21:42:30.206] pid = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] __error = [21:42:30.206] save_errno = [21:42:30.206] __error = [21:42:30.206] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [21:42:30.206] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X\\C+\000\000\000\000\001\000\000\000\000\000\000\000p\354\264", '\000' , "`ĵ\000\000\000\000\000\v\000\000\000\000\000\000\000\000\306\365 \b\000\000\000\330\305G,\b\000\000\000p\354\264\000\000\000\000\000\016FH,\b", '\000' , "@\306\365 \b\000\000\0004\301\202\000\000\000\000"}, salen = 16}} [21:42:30.206] i = 0 [21:42:30.206] now = [21:42:30.206] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 552975712, events = 8, fd = 564499464, user_data = 0x21}, {pos = 552975696, events = 8, fd = 491473556, user_data = 0x821a52008}, {pos = 564470792, events = 8, fd = 564471816, user_data = 0x821a52c08}, {pos = 564486152, events = 8, fd = 564487176, user_data = 0x821a56808}, {pos = 564489224, events = 8, fd = 564490248, user_data = 0x821a57408}, {pos = 564492296, events = 8, fd = 564493320, user_data = 0x821a58008}, {pos = 564495368, events = 8, fd = 564496392, user_data = 0x821a58c08}, {pos = 564498440, events = 8, fd = 564499464, user_data = 0x821a5e088}, {pos = 552976088, events = 8, fd = 552975600, user_data = 0x26ca1d4bada3}, {pos = 564499464, events = 8, fd = 2565846, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 564523064, user_data = 0x1}, {pos = 564499464, events = 8, fd = 723924136, user_data = 0x820f5bfd8}, {pos = 564499464, events = 8, fd = 552975568, user_data = 0x272620}, {pos = 552976160, events = 8, fd = 724031844, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 564525624, user_data = 0x26ca00000001}, {pos = 564499464, events = 8, fd = 723945688, user_data = 0x820f5be18}, {pos = 552975296, events = 8, fd = 33, user_data = 0x82b279c64}, {pos = 564499464, events = 8, fd = 564525624, user_data = 0x0}, {pos = 2625, events = 0, fd = 552975872, user_data = 0x26ca1d4b4645}, {pos = 724031844, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 564525624, events = 8, fd = 1, user_data = 0x821a59408}, {pos = 916578304, events = 8, fd = 1, user_data = 0x836a1e194}, {pos = 0, events = 0, fd = 552975824, user_data = 0x82c483c0c}, {pos = 1, events = 0, fd = 916578304, user_data = 0x820f5be00}, {pos = 742928052, events = 8, fd = 725758304, user_data = 0x82b423160 }, {pos = 724127936, events = 8, fd = 564499464, user_data = 0x820f5bee0}, {pos = 491471916, events = 9930, fd = 80627796, user_data = 0x1}, {pos = 491471534, events = 9930, fd = 12240, user_data = 0x820f5be08}, {pos = 552976096, events = 8, fd = 917374952, user_data = 0x820f5c450}, {pos = 491552400, events = 9930, fd = 564499464, user_data = 0x820f5037f}, {pos = 725415090, events = 8, fd = 552976400, user_data = 0x26ca00000000}, {pos = 564499464, events = 8, fd = 12240, user_data = 0x82b259000}, {pos = 1964368, events = 0, fd = 725758304, user_data = 0x82b279c64}, {pos = 15616, events = 0, fd = 552977280, user_data = 0x820f5bf50}, {pos = 724689294, events = 8, fd = 725796920, user_data = 0x820f5bf14}, {pos = 917030362, events = 8, fd = 552977280, user_data = 0x820f5bf50}, {pos = 724780549, events = 8, fd = 552976146, user_data = 0x820f5c380}, {pos = 552977280, events = 8, fd = 0, user_data = 0xde05aeb7106c8586}, {pos = 552977280, events = 8, fd = 917030360, user_data = 0x820f5c450}, {pos = 725796920, events = 8, fd = 0, user_data = 0x820f5c3c0}, {pos = 724780813, events = 8, fd = 0, user_data = 0x0}, {pos = 552977648, events = 8, fd = 917030360, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 491500553, user_data = 0x820f5c098}, {pos = 724016228, events = 8, fd = 2503, user_data = 0x26ca1d4bb409}, {pos = 552976568, events = 8, fd = 724016228, user_data = 0xac6}, {pos = 723988768, events = 8, fd = 552976440, user_data = 0x821a59408}, {pos = 552976568, events = 8, fd = 723988768, user_data = 0x820f5c0a0}, {pos = 491480165, events = 9930, fd = 0, user_data = 0x800000000}, {pos = 552976528, events = 8, fd = 723948880, user_data = 0x0}, {pos = 0, events = 0, fd = 552976496, user_data = 0x10}, {pos = 0, events = 0, fd = 552976680, user_data = 0x821a5e088}, {pos = 491500553, events = 9930, fd = 552976744, user_data = 0x82b279c64}, {pos = 2924, events = 0, fd = 723989432, user_data = 0x820f5c0e8}, {pos = 564499464, events = 8, fd = 552976744, user_data = 0x82b2733b8}, {pos = 552976720, events = 8, fd = 491480165, user_data = 0x821a5f038}, {pos = 1, events = 8, fd = 564499464, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x20f5c2f8}, {pos = 2565664, events = 0, fd = 552977248, user_data = 0x820f5c360}, {pos = 552977176, events = 8, fd = 31, user_data = 0x0}, {pos = 552976888, events = 8, fd = 564520840, user_data = 0x820f5c3c8}, {pos = 552976864, events = 8, fd = 491498915, user_data = 0x821a5f038}, {pos = 2691645, events = 0, fd = 448139, user_data = 0x87c96e577}} [21:42:30.207] last_touch_time = 1710452395 [21:42:30.207] last_lockfile_recheck_time = 1710452395 [21:42:30.207] nevents = 1 [21:42:30.207] #23 0x000000000082e336 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f5cb80) at ../src/backend/postmaster/postmaster.c:1478 [21:42:30.207] userDoption = [21:42:30.207] listen_addr_saved = false [21:42:30.207] output_config_variable = [21:42:30.207] opt = [21:42:30.207] status = [21:42:30.207] #24 0x000000000076b895 in main (argc=4, argv=0x820f5cb80) at ../src/backend/main/main.c:197 [21:42:30.207] do_check_root =