[21:11:55.306] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [21:11:55.697] dumping /tmp/cores/postgres.7774.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:11:55.836] [New LWP 100148] [21:11:55.925] Core was generated by `postgres: postgres regression [local] MERGE'. [21:11:55.925] Program terminated with signal SIGABRT, Aborted. [21:11:55.925] Sent by thr_kill() from pid 7774 and user 1003. [21:11:55.925] #0 0x000000082e4ecdca in thr_kill () from /lib/libc.so.7 [21:11:56.532] [21:11:56.532] Thread 1 (LWP 100148): [21:11:56.532] #0 0x000000082e4ecdca in thr_kill () from /lib/libc.so.7 [21:11:56.532] No symbol table info available. [21:11:56.532] #1 0x000000082e4656f4 in raise () from /lib/libc.so.7 [21:11:56.532] No symbol table info available. [21:11:56.532] #2 0x000000082e516bc9 in abort () from /lib/libc.so.7 [21:11:56.532] No symbol table info available. [21:11:56.532] #3 0x0000000000a25ba7 in ExceptionalCondition (conditionName=, fileName=0x36cd0b "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [21:11:56.532] No locals. [21:11:56.532] #4 0x0000000000716ac0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82135c9b8, materialize=, shouldFree=shouldFree@entry=0x82135c896) at ../src/backend/executor/execTuples.c:1649 [21:11:56.532] No locals. [21:11:56.532] #5 0x00000000006de6b8 in ExecIRDeleteTriggers (estate=estate@entry=0x845538100, relinfo=relinfo@entry=0x8455386b0, slot=slot@entry=0x82135c9b8) at ../src/backend/commands/trigger.c:2841 [21:11:56.532] trigger = [21:11:56.532] oldtuple = [21:11:56.532] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84544bf00, 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:11:56.532] trigdesc = 0x8455388c0 [21:11:56.532] newtuple = 0x0 [21:11:56.532] i = 0 [21:11:56.532] should_free = false [21:11:56.532] #6 0x000000000073c1c8 in ExecMergeMatched (context=0x82135c9f0, resultRelInfo=0x8455386b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [21:11:56.532] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:11:56.532] commandType = CMD_DELETE [21:11:56.532] result = TM_Ok [21:11:56.532] relaction = [21:11:56.532] l__state = {l = 0x845575a28, i = 0} [21:11:56.532] mtstate = 0x8455384a0 [21:11:56.532] estate = 0x18734 [21:11:56.532] econtext = 0x845575228 [21:11:56.532] epqstate = 0x845538588 [21:11:56.532] l = [21:11:56.532] newslot = [21:11:56.532] isNull = [21:11:56.532] __error = [21:11:56.532] l__state = [21:11:56.532] updateCxt = [21:11:56.532] commandType = [21:11:56.532] result = [21:11:56.532] relaction = [21:11:56.532] __error = [21:11:56.532] resultRelationDesc = [21:11:56.532] lockmode = [21:11:56.532] inputslot = [21:11:56.532] epqslot = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] #7 ExecMerge (context=context@entry=0x82135c9f0, resultRelInfo=resultRelInfo@entry=0x8455386b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x82135c9b8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [21:11:56.532] matched = [21:11:56.532] #8 0x000000000073b577 in ExecModifyTable (pstate=0x8455384a0) at ../src/backend/executor/nodeModifyTable.c:3950 [21:11:56.532] context = {mtstate = 0x8455384a0, epqstate = 0x845538588, estate = 0x845538100, planSlot = 0x845574168, relaction = 0x845575468, tmfd = {ctid = {ip_blkid = {bi_hi = 33024, bi_lo = 17747}, ip_posid = 8}, xmax = 557173296, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [21:11:56.532] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [21:11:56.532] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x838a61118} [21:11:56.532] node = 0x8455384a0 [21:11:56.532] estate = 0x845538100 [21:11:56.532] operation = CMD_MERGE [21:11:56.532] resultRelInfo = 0x6 [21:11:56.532] subplanstate = 0x845539df0 [21:11:56.532] slot = 0x845574168 [21:11:56.532] tupleid = 0x0 [21:11:56.532] oldtuple = 0x82135c9b8 [21:11:56.532] oldSlot = [21:11:56.532] #9 0x0000000000710d3b in ExecProcNodeFirst (node=0x8455384a0) at ../src/backend/executor/execProcnode.c:464 [21:11:56.532] No locals. [21:11:56.532] #10 0x00000000007090ea in ExecProcNode (node=0x8455384a0) at ../src/include/executor/executor.h:274 [21:11:56.532] No locals. [21:11:56.532] #11 ExecutePlan (estate=0x845538100, planstate=0x8455384a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=, dest=0x84559be20, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:11:56.532] current_tuple_count = [21:11:56.532] slot = [21:11:56.532] #12 standard_ExecutorRun (queryDesc=0x838af4500, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:11:56.532] estate = 0x845538100 [21:11:56.532] oldcontext = 0x838af4400 [21:11:56.532] operation = CMD_MERGE [21:11:56.532] dest = 0x84559be20 [21:11:56.532] sendTuples = false [21:11:56.532] #13 0x0000000000708f9f in ExecutorRun (queryDesc=0x18734, queryDesc@entry=0x838af4500, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:11:56.532] No locals. [21:11:56.532] #14 0x00000000008d867f in ProcessQuery (plan=0x845597fa8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82135ccf0) at ../src/backend/tcop/pquery.c:160 [21:11:56.532] queryDesc = 0x838af4500 [21:11:56.532] #15 0x00000000008d7c1d in PortalRunMulti (portal=portal@entry=0x838a2f100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x84559be20, altdest=altdest@entry=0x84559be20, qc=0x82135ccf0) at ../src/backend/tcop/pquery.c:1286 [21:11:56.532] pstmt = 0x845597fa8 [21:11:56.532] stmtlist_item__state = {l = 0x84559bdd0, i = 0} [21:11:56.532] active_snapshot_set = true [21:11:56.532] stmtlist_item = 0x84559bde8 [21:11:56.532] #16 0x00000000008d748b in PortalRun (portal=portal@entry=0x838a2f100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82e4ecdaa , dest@entry=0x84559be20, altdest=0x0, altdest@entry=0x84559be20, qc=0x82135ccf0) at ../src/backend/tcop/pquery.c:791 [21:11:56.532] _local_sigjmp_buf = {{_sjb = {9270271, 35310013528, 34916912104, 34916912336, 34916912112, 11905240, 11873024, 35309940992, 4852089727, 35309949184, 3554671, 34359738368}}} [21:11:56.532] _save_exception_stack = 0x82135cdc0 [21:11:56.532] _save_context_stack = 0x0 [21:11:56.532] _do_rethrow = false [21:11:56.532] saveTopTransactionResourceOwner = 0x838a40c58 [21:11:56.532] saveTopTransactionContext = 0x838965000 [21:11:56.532] saveActivePortal = 0x0 [21:11:56.532] saveResourceOwner = 0x838a40c58 [21:11:56.532] savePortalContext = 0x0 [21:11:56.532] saveMemoryContext = 0x838965000 [21:11:56.532] result = [21:11:56.532] nprocessed = [21:11:56.532] #17 0x00000000008d636b in exec_simple_query (query_string=query_string@entry=0x838959100 "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:11:56.532] cmdtaglen = [21:11:56.532] snapshot_set = [21:11:56.532] per_parsetree_context = 0x0 [21:11:56.532] plantree_list = [21:11:56.532] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:11:56.532] parsetree = 0x845513fc8 [21:11:56.532] commandTag = CMDTAG_MERGE [21:11:56.532] cmdtagname = [21:11:56.532] querytree_list = [21:11:56.532] portal = 0x838a2f100 [21:11:56.532] format = 0 [21:11:56.532] receiver = 0x84559be20 [21:11:56.532] parsetree_item__state = {l = 0x845543f78, i = 0} [21:11:56.532] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:11:56.532] dest = DestRemote [21:11:56.532] was_logged = [21:11:56.532] oldcontext = 0x838965000 [21:11:56.532] parsetree_list = 0x845543f78 [21:11:56.532] use_implicit_block = false [21:11:56.532] parsetree_item = 0x845543f90 [21:11:56.532] save_log_statement_stats = [21:11:56.532] #18 0x00000000008d4154 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:11:56.532] query_string = 0x838959100 "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:11:56.532] input_message = {data = 0x838959100 "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:11:56.532] firstchar = [21:11:56.532] local_sigjmp_buf = {{_sjb = {9254432, 34916912576, 34916912536, 34916913136, 11913976, 11860448, 8192, 8388608, 72057628954788735, 0, 0, 34359738369}}} [21:11:56.532] send_ready_for_query = false [21:11:56.532] idle_in_transaction_timeout_enabled = false [21:11:56.532] idle_session_timeout_enabled = false [21:11:56.532] #19 0x0000000000832dea in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [21:11:56.532] No locals. [21:11:56.532] #20 0x0000000000831070 in BackendStartup (client_sock=0x82135da18) at ../src/backend/postmaster/postmaster.c:4117 [21:11:56.532] bn = 0x838965308 [21:11:56.532] cac = CAC_OK [21:11:56.532] pid = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] __error = [21:11:56.532] save_errno = [21:11:56.532] __error = [21:11:56.532] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [21:11:56.532] 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\034Y.\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\220\3325!\b\000\000\000ؕ\301+\b\000\000\000p\354\264\000\000\000\000\000\016\026\302+\b", '\000' , "\320\3325!\b\000\000\000d\301\202\000\000\000\000"}, salen = 16}} [21:11:56.532] i = 0 [21:11:56.532] now = [21:11:56.532] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 775773284, events = 8, fd = 557174880, user_data = 0x82135d1f0}, {pos = 573035528, events = 8, fd = 32, user_data = 0x82135d1e0}, {pos = 1323698836, events = 13371, fd = 573005832, user_data = 0x822276408}, {pos = 573007880, events = 8, fd = 573008904, user_data = 0x82227a008}, {pos = 573023240, events = 8, fd = 573024264, user_data = 0x82227ac08}, {pos = 573026312, events = 8, fd = 573027336, user_data = 0x82227b808}, {pos = 573029384, events = 8, fd = 573030408, user_data = 0x82227c408}, {pos = 573032456, events = 8, fd = 573033480, user_data = 0x82227d008}, {pos = 573035528, events = 8, fd = -1, user_data = 0x82e5ad2e0}, {pos = 557175120, events = 8, fd = 777363881, user_data = 0x0}, {pos = 4096, events = 0, fd = -681530652, user_data = 0x82e5ad7e8}, {pos = 943758304, events = 8, fd = 160, user_data = 0x0}, {pos = 928583824, events = 8, fd = 557175328, user_data = 0x82e53892c}, {pos = 4096, events = 0, fd = 775788900, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 573061688, user_data = 0x800000001}, {pos = 573035528, events = 8, fd = 775702744, user_data = 0x82135d2a8}, {pos = 557174880, events = 8, fd = 32, user_data = 0x82e3d5c64}, {pos = 573035528, events = 8, fd = 573061688, user_data = 0x0}, {pos = 2625, events = 0, fd = 557175440, user_data = 0x343b4ee60645}, {pos = 775788900, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 573061688, events = 8, fd = 1, user_data = 0x82227d408}, {pos = 949260288, events = 8, fd = 1, user_data = 0x838949194}, {pos = 0, events = 0, fd = 557175392, user_data = 0x82bc20c0c}, {pos = 1, events = 0, fd = 949260288, user_data = 0x82135d290}, {pos = 734133940, events = 8, fd = 777515360, user_data = 0x82e57f160 }, {pos = 775884992, events = 8, fd = 573035528, user_data = 0x82135d370}, {pos = 1323697196, events = 13371, fd = 928583824, user_data = 0x800000001}, {pos = 1323696814, events = 13371, fd = 12240, user_data = 0x82135d298}, {pos = 557175664, events = 8, fd = 949966824, user_data = 0x82135d8e0}, {pos = 1323777680, events = 13371, fd = 573035528, user_data = 0x82135037f}, {pos = 777172380, events = 8, fd = 573005832, user_data = 0x0}, {pos = 573035528, events = 8, fd = 12240, user_data = 0x82e3b5000}, {pos = 1964368, events = 0, fd = 777515360, user_data = 0x82e3d5c64}, {pos = 15616, events = 0, fd = 557176848, user_data = 0x82135d3e0}, {pos = 776446350, events = 8, fd = 777553976, user_data = 0x82135d3a4}, {pos = 949704154, events = 8, fd = 557176848, user_data = 0x82135d3e0}, {pos = 776537605, events = 8, fd = 557175714, user_data = 0x82135d810}, {pos = 557176848, events = 8, fd = 0, user_data = 0x68326810d760aae4}, {pos = 557176848, events = 8, fd = 949704152, user_data = 0x82135d8e0}, {pos = 777553976, events = 8, fd = 0, user_data = 0x82135d850}, {pos = 776537869, events = 8, fd = 0, user_data = 0x0}, {pos = 557177216, events = 8, fd = 949704152, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1323725833, events = 13371, fd = 557176120, user_data = 0x82e3d5c64}, {pos = 2503, events = 0, fd = 1323725833, user_data = 0x82135d558}, {pos = 775773284, events = 8, fd = 2758, user_data = 0x82e3cf120}, {pos = 557176024, events = 8, fd = 573035528, user_data = 0x82135d558}, {pos = 775745824, events = 8, fd = 557176128, user_data = 0x343b4ee62465}, {pos = 0, events = 0, fd = 0, user_data = 0x82e5a10f0}, {pos = 775705936, events = 8, fd = 0, user_data = 0x0}, {pos = 777583024, events = 8, fd = 16, user_data = 0x0}, {pos = 557176264, events = 8, fd = 573055112, user_data = 0x343b4ee67409}, {pos = 557176328, events = 8, fd = 775773284, user_data = 0xb6c}, {pos = 775746488, events = 8, fd = 557176200, user_data = 0x82227d408}, {pos = 557176328, events = 8, fd = 775746488, user_data = 0x82135d5f0}, {pos = 1323705445, events = 13371, fd = 573059128, user_data = 0x800000001}, {pos = 573035528, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 557176712, user_data = 0x272620}, {pos = 557176816, events = 8, fd = 557176816, user_data = 0x82135d7a8}, {pos = 30, events = 0, fd = 775709920, user_data = 0x82135d698}, {pos = 573055560, events = 8, fd = 557176920, user_data = 0x82135d680}, {pos = 1323724195, events = 13371, fd = 573059128, user_data = 0x29123d}} [21:11:56.532] last_touch_time = 1710623348 [21:11:56.532] last_lockfile_recheck_time = 1710623348 [21:11:56.532] nevents = 1 [21:11:56.532] #22 0x000000000082e366 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82135e010) at ../src/backend/postmaster/postmaster.c:1478 [21:11:56.532] userDoption = [21:11:56.532] listen_addr_saved = false [21:11:56.532] output_config_variable = [21:11:56.532] opt = [21:11:56.532] status = [21:11:56.532] #23 0x000000000076b895 in main (argc=8, argv=0x82135e010) at ../src/backend/main/main.c:197 [21:11:56.532] do_check_root = [21:11:56.543] [21:11:56.543] [21:11:56.543] [21:11:56.608] dumping /tmp/cores/postgres.8388.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:11:56.737] [New LWP 100133] [21:11:56.805] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [21:11:56.805] Program terminated with signal SIGABRT, Aborted. [21:11:56.805] Sent by thr_kill() from pid 8388 and user 1003. [21:11:56.805] #0 0x000000082c161dca in thr_kill () from /lib/libc.so.7 [21:11:57.392] [21:11:57.392] Thread 1 (LWP 100133): [21:11:57.392] #0 0x000000082c161dca in thr_kill () from /lib/libc.so.7 [21:11:57.392] No symbol table info available. [21:11:57.392] #1 0x000000082c0da6f4 in raise () from /lib/libc.so.7 [21:11:57.392] No symbol table info available. [21:11:57.392] #2 0x000000082c18bbc9 in abort () from /lib/libc.so.7 [21:11:57.392] No symbol table info available. [21:11:57.392] #3 0x0000000000a25ba7 in ExceptionalCondition (conditionName=, fileName=0x36cd0b "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [21:11:57.392] No locals. [21:11:57.392] #4 0x0000000000716ac0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821014508, materialize=, shouldFree=shouldFree@entry=0x8210143e6) at ../src/backend/executor/execTuples.c:1649 [21:11:57.392] No locals. [21:11:57.392] #5 0x00000000006de6b8 in ExecIRDeleteTriggers (estate=estate@entry=0x843ef2100, relinfo=relinfo@entry=0x843ef26b0, slot=slot@entry=0x821014508) at ../src/backend/commands/trigger.c:2841 [21:11:57.392] trigger = [21:11:57.392] oldtuple = [21:11:57.392] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x843e28a90, 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:11:57.392] trigdesc = 0x843ef28c0 [21:11:57.392] newtuple = 0x0 [21:11:57.392] i = 0 [21:11:57.392] should_free = false [21:11:57.392] #6 0x000000000073c1c8 in ExecMergeMatched (context=0x821014540, resultRelInfo=0x843ef26b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [21:11:57.392] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:11:57.392] commandType = CMD_DELETE [21:11:57.392] result = TM_Ok [21:11:57.392] relaction = [21:11:57.392] l__state = {l = 0x843f2fae8, i = 0} [21:11:57.392] mtstate = 0x843ef24a0 [21:11:57.392] estate = 0x18725 [21:11:57.392] econtext = 0x843f2f2e8 [21:11:57.392] epqstate = 0x843ef2588 [21:11:57.392] l = [21:11:57.392] newslot = [21:11:57.392] isNull = [21:11:57.392] __error = [21:11:57.392] l__state = [21:11:57.392] updateCxt = [21:11:57.392] commandType = [21:11:57.392] result = [21:11:57.392] relaction = [21:11:57.392] __error = [21:11:57.392] resultRelationDesc = [21:11:57.392] lockmode = [21:11:57.392] inputslot = [21:11:57.392] epqslot = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] #7 ExecMerge (context=context@entry=0x821014540, resultRelInfo=resultRelInfo@entry=0x843ef26b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x821014508, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [21:11:57.392] matched = [21:11:57.392] #8 0x000000000073b577 in ExecModifyTable (pstate=0x843ef24a0) at ../src/backend/executor/nodeModifyTable.c:3950 [21:11:57.392] context = {mtstate = 0x843ef24a0, epqstate = 0x843ef2588, estate = 0x843ef2100, planSlot = 0x843f2e228, relaction = 0x843f2f528, tmfd = {ctid = {ip_blkid = {bi_hi = 8448, bi_lo = 17391}, ip_posid = 8}, xmax = 553731456, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [21:11:57.392] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [21:11:57.392] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8360d2118} [21:11:57.392] node = 0x843ef24a0 [21:11:57.392] estate = 0x843ef2100 [21:11:57.392] operation = CMD_MERGE [21:11:57.392] resultRelInfo = 0x6 [21:11:57.392] subplanstate = 0x843ef3df0 [21:11:57.392] slot = 0x843f2e228 [21:11:57.392] tupleid = 0x0 [21:11:57.392] oldtuple = 0x821014508 [21:11:57.392] oldSlot = [21:11:57.392] #9 0x0000000000710d3b in ExecProcNodeFirst (node=0x843ef24a0) at ../src/backend/executor/execProcnode.c:464 [21:11:57.392] No locals. [21:11:57.392] #10 0x00000000007090ea in ExecProcNode (node=0x843ef24a0) at ../src/include/executor/executor.h:274 [21:11:57.392] No locals. [21:11:57.392] #11 ExecutePlan (estate=0x843ef2100, planstate=0x843ef24a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=, dest=0x843f558e0, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:11:57.392] current_tuple_count = [21:11:57.392] slot = [21:11:57.392] #12 standard_ExecutorRun (queryDesc=0x835f58100, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:11:57.392] estate = 0x843ef2100 [21:11:57.392] oldcontext = 0x835f58000 [21:11:57.392] operation = CMD_MERGE [21:11:57.392] dest = 0x843f558e0 [21:11:57.392] sendTuples = false [21:11:57.392] #13 0x0000000000708f9f in ExecutorRun (queryDesc=0x18725, queryDesc@entry=0x835f58100, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:11:57.392] No locals. [21:11:57.392] #14 0x00000000008d867f in ProcessQuery (plan=0x843f51a68, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821014840) at ../src/backend/tcop/pquery.c:160 [21:11:57.392] queryDesc = 0x835f58100 [21:11:57.392] #15 0x00000000008d7c1d in PortalRunMulti (portal=portal@entry=0x835fb9100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x843f558e0, altdest=altdest@entry=0x843f558e0, qc=0x821014840) at ../src/backend/tcop/pquery.c:1286 [21:11:57.392] pstmt = 0x843f51a68 [21:11:57.392] stmtlist_item__state = {l = 0x843f55890, i = 0} [21:11:57.392] active_snapshot_set = true [21:11:57.392] stmtlist_item = 0x843f558a8 [21:11:57.392] #16 0x00000000008d748b in PortalRun (portal=portal@entry=0x835fb9100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82c161daa , dest@entry=0x843f558e0, altdest=0x0, altdest@entry=0x843f558e0, qc=0x821014840) at ../src/backend/tcop/pquery.c:791 [21:11:57.392] _local_sigjmp_buf = {{_sjb = {9270271, 35265755352, 34913470264, 34913470496, 34913470272, 11905240, 11873024, 35265417472, 4848681855, 35265425664, 3554671, 34359738368}}} [21:11:57.392] _save_exception_stack = 0x821014910 [21:11:57.392] _save_context_stack = 0x0 [21:11:57.392] _do_rethrow = false [21:11:57.392] saveTopTransactionResourceOwner = 0x83600b8d8 [21:11:57.392] saveTopTransactionContext = 0x835f2c000 [21:11:57.392] saveActivePortal = 0x0 [21:11:57.392] saveResourceOwner = 0x83600b8d8 [21:11:57.392] savePortalContext = 0x0 [21:11:57.392] saveMemoryContext = 0x835f2c000 [21:11:57.392] result = [21:11:57.392] nprocessed = [21:11:57.392] #17 0x00000000008d636b in exec_simple_query (query_string=query_string@entry=0x835f20100 "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:11:57.392] cmdtaglen = [21:11:57.392] snapshot_set = [21:11:57.392] per_parsetree_context = 0x0 [21:11:57.392] plantree_list = [21:11:57.392] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:11:57.392] parsetree = 0x843eacfc8 [21:11:57.392] commandTag = CMDTAG_MERGE [21:11:57.392] cmdtagname = [21:11:57.392] querytree_list = [21:11:57.392] portal = 0x835fb9100 [21:11:57.392] format = 0 [21:11:57.392] receiver = 0x843f558e0 [21:11:57.392] parsetree_item__state = {l = 0x843efe538, i = 0} [21:11:57.392] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:11:57.392] dest = DestRemote [21:11:57.392] was_logged = [21:11:57.392] oldcontext = 0x835f2c000 [21:11:57.392] parsetree_list = 0x843efe538 [21:11:57.392] use_implicit_block = false [21:11:57.392] parsetree_item = 0x843efe550 [21:11:57.392] save_log_statement_stats = [21:11:57.392] #18 0x00000000008d4154 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:11:57.392] query_string = 0x835f20100 "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:11:57.392] input_message = {data = 0x835f20100 "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:11:57.392] firstchar = [21:11:57.392] local_sigjmp_buf = {{_sjb = {9254432, 34913470736, 34913470696, 34913471296, 11913976, 11860448, 8192, 8388608, 72057628951380863, 0, 0, 34359738369}}} [21:11:57.392] send_ready_for_query = false [21:11:57.392] idle_in_transaction_timeout_enabled = false [21:11:57.392] idle_session_timeout_enabled = false [21:11:57.392] #19 0x0000000000832dea in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [21:11:57.392] No locals. [21:11:57.392] #20 0x0000000000831070 in BackendStartup (client_sock=0x821015568) at ../src/backend/postmaster/postmaster.c:4117 [21:11:57.392] bn = 0x835f2c3f8 [21:11:57.392] cac = CAC_OK [21:11:57.392] pid = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] __error = [21:11:57.392] save_errno = [21:11:57.392] __error = [21:11:57.392] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [21:11:57.392] 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 = "Xl ,\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\340U\001!\b\000\000\000\330\205N*\b\000\000\000p\354\264\000\000\000\000\000\016\006O*\b", '\000' , " V\001!\b\000\000\000d\301\202\000\000\000\000"}, salen = 16}} [21:11:57.392] i = 0 [21:11:57.392] now = [21:11:57.392] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 738503780, events = 8, fd = 553733040, user_data = 0x821014d40}, {pos = 568992776, events = 8, fd = 32, user_data = 0x821014d30}, {pos = -143635820, events = 5226, fd = 568963080, user_data = 0x821e9b408}, {pos = 568965128, events = 8, fd = 568966152, user_data = 0x821e9f008}, {pos = 568980488, events = 8, fd = 568981512, user_data = 0x821e9fc08}, {pos = 568983560, events = 8, fd = 568984584, user_data = 0x821ea0808}, {pos = 568986632, events = 8, fd = 568987656, user_data = 0x821ea1408}, {pos = 568989704, events = 8, fd = 568990728, user_data = 0x821ea2008}, {pos = 568992776, events = 8, fd = 569012360, user_data = 0x821014eb8}, {pos = 553733344, events = 8, fd = -143610461, user_data = 0x0}, {pos = 2565846, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 569016376, events = 8, fd = 1, user_data = 0x821ea2408}, {pos = 738411688, events = 8, fd = 553734072, user_data = 0x821ea2408}, {pos = 553733328, events = 0, fd = 738519396, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 569018936, user_data = 0x1}, {pos = 568992776, events = 8, fd = 738433240, user_data = 0x821014df8}, {pos = 553733040, events = 8, fd = 32, user_data = 0x82c04ac64}, {pos = 568992776, events = 8, fd = 569018936, user_data = 0x0}, {pos = 2625, events = 0, fd = 553733600, user_data = 0x146af7704645}, {pos = 738519396, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 569018936, events = 8, fd = 1, user_data = 0x821ea2408}, {pos = 904986624, events = 8, fd = 1, user_data = 0x835f10194}, {pos = 0, events = 0, fd = 553733552, user_data = 0x82a4efc0c}, {pos = 1, events = 0, fd = 904986624, user_data = 0x821014de0}, {pos = 709815988, events = 8, fd = 740245856, user_data = 0x82c1f4160 }, {pos = 738615488, events = 8, fd = 568992776, user_data = 0x821014ec0}, {pos = -143637460, events = 5226, fd = 568991752, user_data = 0x800000001}, {pos = -143637842, events = 5226, fd = 12240, user_data = 0x821014de8}, {pos = 553733824, events = 8, fd = 905783272, user_data = 0x821015430}, {pos = -143556976, events = 5226, fd = 568992776, user_data = 0x82101037f}, {pos = 739902642, events = 8, fd = 568963080, user_data = 0x0}, {pos = 568992776, events = 8, fd = 12240, user_data = 0x82c02a000}, {pos = 1964368, events = 0, fd = 740245856, user_data = 0x82c04ac64}, {pos = 15616, events = 0, fd = 553735008, user_data = 0x821014f30}, {pos = 739176846, events = 8, fd = 740284472, user_data = 0x821014ef4}, {pos = 905438682, events = 8, fd = 553735008, user_data = 0x821014f30}, {pos = 739268101, events = 8, fd = 553733874, user_data = 0x821015360}, {pos = 553735008, events = 8, fd = 0, user_data = 0x95ec07276ebec2a1}, {pos = 553735008, events = 8, fd = 905438680, user_data = 0x821015430}, {pos = 740284472, events = 8, fd = 0, user_data = 0x8210153a0}, {pos = 739268365, events = 8, fd = 0, user_data = 0x0}, {pos = 553735376, events = 8, fd = 905438680, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -143608823, events = 5226, fd = 553734280, user_data = 0x82c04ac64}, {pos = 2503, events = 0, fd = -143608823, user_data = 0x8210150a8}, {pos = 738503780, events = 8, fd = 2758, user_data = 0x82c044120}, {pos = 553734184, events = 8, fd = 568992776, user_data = 0x8210150a8}, {pos = 738476320, events = 8, fd = 553734288, user_data = 0x146af7706465}, {pos = 0, events = 0, fd = 0, user_data = 0x82c2160f0}, {pos = 738436432, events = 8, fd = 0, user_data = 0x0}, {pos = 740313520, events = 8, fd = 16, user_data = 0x0}, {pos = 553734424, events = 8, fd = 569012360, user_data = 0x146af770b409}, {pos = 553734488, events = 8, fd = 738503780, user_data = 0xb6c}, {pos = 738476984, events = 8, fd = 553734360, user_data = 0x821ea2408}, {pos = 553734488, events = 8, fd = 738476984, user_data = 0x821015140}, {pos = -143629211, events = 5226, fd = 569016376, user_data = 0x800000001}, {pos = 568992776, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 553734872, user_data = 0x272620}, {pos = 553734976, events = 8, fd = 553734976, user_data = 0x8210152f8}, {pos = 30, events = 0, fd = 738440416, user_data = 0x8210151e8}, {pos = 569012808, events = 8, fd = 553735080, user_data = 0x8210151d0}, {pos = -143610461, events = 5226, fd = 569016376, user_data = 0x29123d}} [21:11:57.392] last_touch_time = 1710623351 [21:11:57.392] last_lockfile_recheck_time = 1710623351 [21:11:57.392] nevents = 1 [21:11:57.392] #22 0x000000000082e366 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821015b60) at ../src/backend/postmaster/postmaster.c:1478 [21:11:57.392] userDoption = [21:11:57.392] listen_addr_saved = false [21:11:57.392] output_config_variable = [21:11:57.392] opt = [21:11:57.392] status = [21:11:57.392] #23 0x000000000076b895 in main (argc=4, argv=0x821015b60) at ../src/backend/main/main.c:197 [21:11:57.392] do_check_root = [21:11:57.404] [21:11:57.404] [21:11:57.404] [21:11:57.467] dumping /tmp/cores/postgres.13996.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:11:57.593] [New LWP 100125] [21:11:57.663] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [21:11:57.663] Program terminated with signal SIGABRT, Aborted. [21:11:57.663] Sent by thr_kill() from pid 13996 and user 1003. [21:11:57.663] #0 0x0000000828ce9dca in thr_kill () from /lib/libc.so.7 [21:11:58.264] [21:11:58.264] Thread 1 (LWP 100125): [21:11:58.264] #0 0x0000000828ce9dca in thr_kill () from /lib/libc.so.7 [21:11:58.264] No symbol table info available. [21:11:58.264] #1 0x0000000828c626f4 in raise () from /lib/libc.so.7 [21:11:58.264] No symbol table info available. [21:11:58.264] #2 0x0000000828d13bc9 in abort () from /lib/libc.so.7 [21:11:58.264] No symbol table info available. [21:11:58.264] #3 0x0000000000a25ba7 in ExceptionalCondition (conditionName=, fileName=0x36cd0b "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [21:11:58.264] No locals. [21:11:58.264] #4 0x0000000000716ac0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821445108, materialize=, shouldFree=shouldFree@entry=0x821444fe6) at ../src/backend/executor/execTuples.c:1649 [21:11:58.264] No locals. [21:11:58.264] #5 0x00000000006de6b8 in ExecIRDeleteTriggers (estate=estate@entry=0x835732100, relinfo=relinfo@entry=0x8357326b0, slot=slot@entry=0x821445108) at ../src/backend/commands/trigger.c:2841 [21:11:58.264] trigger = [21:11:58.264] oldtuple = [21:11:58.264] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8355c2fe0, 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:11:58.264] trigdesc = 0x8357328c0 [21:11:58.264] newtuple = 0x0 [21:11:58.264] i = 0 [21:11:58.264] should_free = false [21:11:58.264] #6 0x000000000073c1c8 in ExecMergeMatched (context=0x821445140, resultRelInfo=0x8357326b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [21:11:58.264] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:11:58.264] commandType = CMD_DELETE [21:11:58.264] result = TM_Ok [21:11:58.264] relaction = [21:11:58.264] l__state = {l = 0x835708728, i = 0} [21:11:58.264] mtstate = 0x8357324a0 [21:11:58.264] estate = 0x1871d [21:11:58.264] econtext = 0x835707f28 [21:11:58.264] epqstate = 0x835732588 [21:11:58.264] l = [21:11:58.264] newslot = [21:11:58.264] isNull = [21:11:58.264] __error = [21:11:58.264] l__state = [21:11:58.264] updateCxt = [21:11:58.264] commandType = [21:11:58.264] result = [21:11:58.264] relaction = [21:11:58.264] __error = [21:11:58.264] resultRelationDesc = [21:11:58.264] lockmode = [21:11:58.264] inputslot = [21:11:58.264] epqslot = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] #7 ExecMerge (context=context@entry=0x821445140, resultRelInfo=resultRelInfo@entry=0x8357326b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x821445108, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [21:11:58.264] matched = [21:11:58.264] #8 0x000000000073b577 in ExecModifyTable (pstate=0x8357324a0) at ../src/backend/executor/nodeModifyTable.c:3950 [21:11:58.264] context = {mtstate = 0x8357324a0, epqstate = 0x835732588, estate = 0x835732100, planSlot = 0x835706e68, relaction = 0x835708168, tmfd = {ctid = {ip_blkid = {bi_hi = 26334, bi_lo = 10446}, ip_posid = 8}, xmax = 105, cmax = 0, traversed = 236}, cpUpdateReturningSlot = 0x23d9f021cd061fbd} [21:11:58.264] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [21:11:58.264] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8355e4118} [21:11:58.264] node = 0x8357324a0 [21:11:58.264] estate = 0x835732100 [21:11:58.264] operation = CMD_MERGE [21:11:58.264] resultRelInfo = 0x6 [21:11:58.264] subplanstate = 0x835733df0 [21:11:58.264] slot = 0x835706e68 [21:11:58.264] tupleid = 0x0 [21:11:58.264] oldtuple = 0x821445108 [21:11:58.264] oldSlot = [21:11:58.264] #9 0x0000000000710d3b in ExecProcNodeFirst (node=0x8357324a0) at ../src/backend/executor/execProcnode.c:464 [21:11:58.264] No locals. [21:11:58.264] #10 0x00000000007090ea in ExecProcNode (node=0x8357324a0) at ../src/include/executor/executor.h:274 [21:11:58.264] No locals. [21:11:58.264] #11 ExecutePlan (estate=0x835732100, planstate=0x8357324a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=, dest=0x8356f0558, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:11:58.264] current_tuple_count = [21:11:58.264] slot = [21:11:58.264] #12 standard_ExecutorRun (queryDesc=0x8332c2900, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:11:58.264] estate = 0x835732100 [21:11:58.264] oldcontext = 0x8332c2800 [21:11:58.264] operation = CMD_MERGE [21:11:58.264] dest = 0x8356f0558 [21:11:58.264] sendTuples = false [21:11:58.264] #13 0x00000008348b8963 in pgss_ExecutorRun (queryDesc=0x8332c2900, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [21:11:58.264] _local_sigjmp_buf = {{_sjb = {35241298226, 11905240, 34917864040, 34917864208, 35218270464, 34917864048, 1, 1, 35256468351, 35218270464, 11913968, 34359738368}}} [21:11:58.264] _save_exception_stack = 0x8214453f0 [21:11:58.264] _save_context_stack = 0x0 [21:11:58.264] _do_rethrow = false [21:11:58.264] #14 0x0000000000708f98 in ExecutorRun (queryDesc=0x1871d, queryDesc@entry=0x8332c2900, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [21:11:58.264] No locals. [21:11:58.264] #15 0x00000000008d867f in ProcessQuery (plan=0x8356ec6e0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8214454f0) at ../src/backend/tcop/pquery.c:160 [21:11:58.264] queryDesc = 0x8332c2900 [21:11:58.264] #16 0x00000000008d7c1d in PortalRunMulti (portal=portal@entry=0x83334f100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8356f0558, altdest=altdest@entry=0x8356f0558, qc=0x8214454f0) at ../src/backend/tcop/pquery.c:1286 [21:11:58.264] pstmt = 0x8356ec6e0 [21:11:58.264] stmtlist_item__state = {l = 0x8356f0508, i = 0} [21:11:58.264] active_snapshot_set = true [21:11:58.264] stmtlist_item = 0x8356f0520 [21:11:58.264] #17 0x00000000008d748b in PortalRun (portal=portal@entry=0x83334f100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x828ce9daa , dest@entry=0x8356f0558, altdest=0x0, altdest@entry=0x8356f0558, qc=0x8214454f0) at ../src/backend/tcop/pquery.c:791 [21:11:58.264] _local_sigjmp_buf = {{_sjb = {9270271, 35219131136, 34917864424, 34917864656, 34917864432, 11905240, 11873024, 35218845952, 4853072767, 35218854144, 3554671, 34359738368}}} [21:11:58.264] _save_exception_stack = 0x8214455c0 [21:11:58.264] _save_context_stack = 0x0 [21:11:58.264] _do_rethrow = false [21:11:58.264] saveTopTransactionResourceOwner = 0x833394b00 [21:11:58.264] saveTopTransactionContext = 0x8332c0000 [21:11:58.264] saveActivePortal = 0x0 [21:11:58.264] saveResourceOwner = 0x833394b00 [21:11:58.264] savePortalContext = 0x0 [21:11:58.264] saveMemoryContext = 0x8332c0000 [21:11:58.264] result = [21:11:58.264] nprocessed = [21:11:58.264] #18 0x00000000008d636b in exec_simple_query (query_string=query_string@entry=0x8332b4100 "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:11:58.264] cmdtaglen = [21:11:58.264] snapshot_set = [21:11:58.264] per_parsetree_context = 0x0 [21:11:58.264] plantree_list = [21:11:58.264] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:11:58.264] parsetree = 0x833344fc8 [21:11:58.264] commandTag = CMDTAG_MERGE [21:11:58.264] cmdtagname = [21:11:58.264] querytree_list = [21:11:58.264] portal = 0x83334f100 [21:11:58.264] format = 0 [21:11:58.264] receiver = 0x8356f0558 [21:11:58.264] parsetree_item__state = {l = 0x8356a9538, i = 0} [21:11:58.264] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:11:58.264] dest = DestRemote [21:11:58.264] was_logged = [21:11:58.264] oldcontext = 0x8332c0000 [21:11:58.264] parsetree_list = 0x8356a9538 [21:11:58.264] use_implicit_block = false [21:11:58.264] parsetree_item = 0x8356a9550 [21:11:58.264] save_log_statement_stats = [21:11:58.264] #19 0x00000000008d4154 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:11:58.264] query_string = 0x8332b4100 "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:11:58.264] input_message = {data = 0x8332b4100 "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:11:58.264] firstchar = [21:11:58.264] local_sigjmp_buf = {{_sjb = {9254432, 34917864896, 34917864856, 34917865456, 11913976, 11860448, 8192, 8388608, 72057628955771775, 0, 0, 1}}} [21:11:58.264] send_ready_for_query = false [21:11:58.264] idle_in_transaction_timeout_enabled = false [21:11:58.264] idle_session_timeout_enabled = false [21:11:58.264] #20 0x0000000000832dea in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [21:11:58.264] No locals. [21:11:58.264] #21 0x0000000000831070 in BackendStartup (client_sock=0x821446218) at ../src/backend/postmaster/postmaster.c:4117 [21:11:58.264] bn = 0x8332c02b8 [21:11:58.264] cac = CAC_OK [21:11:58.264] pid = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] __error = [21:11:58.264] save_errno = [21:11:58.264] __error = [21:11:58.264] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [21:11:58.264] 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\354\330(\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\220bD!\b\000\000\000\330ŵ(\b\000\000\000p\354\264\000\000\000\000\000\016F\266(\b", '\000' , "\320bD!\b\000\000\000d\301\202\000\000\000\000"}, salen = 16}} [21:11:58.264] i = 0 [21:11:58.264] now = [21:11:58.264] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 558127600, events = 8, fd = 558367752, user_data = 0x21}, {pos = 558127584, events = 8, fd = 2128202388, user_data = 0x821479008}, {pos = 558339080, events = 8, fd = 558340104, user_data = 0x821479c08}, {pos = 558354440, events = 8, fd = 558355464, user_data = 0x82147d808}, {pos = 558357512, events = 8, fd = 558358536, user_data = 0x82147e408}, {pos = 558360584, events = 8, fd = 558361608, user_data = 0x82147f008}, {pos = 558363656, events = 8, fd = 558364680, user_data = 0x82147fc08}, {pos = 558366728, events = 8, fd = 558367752, user_data = 0x821485088}, {pos = 558127976, events = 8, fd = 558127488, user_data = 0x36647eda2da3}, {pos = 558367752, events = 8, fd = 2565846, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 558391352, user_data = 0x1}, {pos = 558367752, events = 8, fd = 683394216, user_data = 0x821445c68}, {pos = 558367752, events = 8, fd = 558127456, user_data = 0x272620}, {pos = 558128048, events = 8, fd = 683501924, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 558393912, user_data = 0x366400000001}, {pos = 558367752, events = 8, fd = 683415768, user_data = 0x821445aa8}, {pos = 558127184, events = 8, fd = 33, user_data = 0x828bd2c64}, {pos = 558367752, events = 8, fd = 558393912, user_data = 0x0}, {pos = 2625, events = 0, fd = 558127760, user_data = 0x36647ed9c645}, {pos = 683501924, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 558393912, events = 8, fd = 1, user_data = 0x821480408}, {pos = 858406912, events = 8, fd = 1, user_data = 0x8332a4194}, {pos = 0, events = 0, fd = 558127712, user_data = 0x828b63c0c}, {pos = 1, events = 0, fd = 858406912, user_data = 0x821445a90}, {pos = 683028148, events = 8, fd = 685228384, user_data = 0x828d7c160 }, {pos = 683598016, events = 8, fd = 558367752, user_data = 0x821445b70}, {pos = 2128200748, events = 13924, fd = 80627796, user_data = 0x1}, {pos = 2128200366, events = 13924, fd = 12240, user_data = 0x821445a98}, {pos = 558127984, events = 8, fd = 859203560, user_data = 0x8214460e0}, {pos = 2128281232, events = 13924, fd = 558367752, user_data = 0x82144037f}, {pos = 684885170, events = 8, fd = 558128288, user_data = 0x366400000000}, {pos = 558367752, events = 8, fd = 12240, user_data = 0x828bb2000}, {pos = 1964368, events = 0, fd = 685228384, user_data = 0x828bd2c64}, {pos = 15616, events = 0, fd = 558129168, user_data = 0x821445be0}, {pos = 684159374, events = 8, fd = 685267000, user_data = 0x821445ba4}, {pos = 858858970, events = 8, fd = 558129168, user_data = 0x821445be0}, {pos = 684250629, events = 8, fd = 558128034, user_data = 0x821446010}, {pos = 558129168, events = 8, fd = 0, user_data = 0x23d9f021cd061fbd}, {pos = 558129168, events = 8, fd = 858858968, user_data = 0x8214460e0}, {pos = 685267000, events = 8, fd = 0, user_data = 0x821446050}, {pos = 684250893, events = 8, fd = 0, user_data = 0x0}, {pos = 558129536, events = 8, fd = 858858968, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2128229385, user_data = 0x821445d28}, {pos = 683486308, events = 8, fd = 2503, user_data = 0x36647eda3409}, {pos = 558128456, events = 8, fd = 683486308, user_data = 0xac6}, {pos = 683458848, events = 8, fd = 558128328, user_data = 0x821480408}, {pos = 558128456, events = 8, fd = 683458848, user_data = 0x821445d30}, {pos = 2128208997, events = 13924, fd = 0, user_data = 0x800000000}, {pos = 558128416, events = 8, fd = 683418960, user_data = 0x0}, {pos = 0, events = 0, fd = 558128384, user_data = 0x10}, {pos = 0, events = 0, fd = 558128568, user_data = 0x821485088}, {pos = 2128229385, events = 13924, fd = 558128632, user_data = 0x828bd2c64}, {pos = 2924, events = 0, fd = 683459512, user_data = 0x821445d78}, {pos = 558367752, events = 8, fd = 558128632, user_data = 0x828bcc3b8}, {pos = 558128608, events = 8, fd = 2128208997, user_data = 0x821486038}, {pos = 1, events = 8, fd = 558367752, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x21445f88}, {pos = 2565664, events = 0, fd = 558129136, user_data = 0x821445ff0}, {pos = 558129064, events = 8, fd = 31, user_data = 0x0}, {pos = 558128776, events = 8, fd = 558389128, user_data = 0x821446058}, {pos = 558128752, events = 8, fd = 2128227747, user_data = 0x821486038}, {pos = 2691645, events = 0, fd = 448139, user_data = 0x87c96e577}} [21:11:58.264] last_touch_time = 1710623371 [21:11:58.264] last_lockfile_recheck_time = 1710623371 [21:11:58.264] nevents = 1 [21:11:58.264] #23 0x000000000082e366 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821446818) at ../src/backend/postmaster/postmaster.c:1478 [21:11:58.264] userDoption = [21:11:58.264] listen_addr_saved = false [21:11:58.264] output_config_variable = [21:11:58.264] opt = [21:11:58.264] status = [21:11:58.264] #24 0x000000000076b895 in main (argc=4, argv=0x821446818) at ../src/backend/main/main.c:197 [21:11:58.264] do_check_root =