[20:10:22.845] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [20:10:23.205] dumping /tmp/cores/postgres.8791.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:10:23.339] [New LWP 101784] [20:10:23.424] Core was generated by `postgres: postgres regression [local] MERGE'. [20:10:23.424] Program terminated with signal SIGABRT, Aborted. [20:10:23.424] Sent by thr_kill() from pid 8791 and user 1003. [20:10:23.424] #0 0x000000082991641a in thr_kill () from /lib/libc.so.7 [20:10:23.973] [20:10:23.973] Thread 1 (LWP 101784): [20:10:23.973] #0 0x000000082991641a in thr_kill () from /lib/libc.so.7 [20:10:23.973] No symbol table info available. [20:10:23.973] #1 0x000000082988fe64 in raise () from /lib/libc.so.7 [20:10:23.973] No symbol table info available. [20:10:23.973] #2 0x00000008299406f9 in abort () from /lib/libc.so.7 [20:10:23.973] No symbol table info available. [20:10:23.973] #3 0x0000000000a58cd5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [20:10:23.973] No locals. [20:10:23.973] #4 0x000000000073d2df in ExecFetchSlotHeapTuple (slot=0x8211c4060, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [20:10:23.973] No locals. [20:10:23.973] #5 0x0000000000701f97 in ExecIRDeleteTriggers (estate=estate@entry=0x835c04100, relinfo=relinfo@entry=0x835c046b0, slot=slot@entry=0x8211c4060) at ../src/backend/commands/trigger.c:2841 [20:10:23.973] trigger = [20:10:23.973] oldtuple = [20:10:23.973] should_free = false [20:10:23.973] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84117dcb0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [20:10:23.973] trigdesc = 0x835c048c0 [20:10:23.973] newtuple = 0x0 [20:10:23.973] i = 0 [20:10:23.973] #6 0x00000000007624b7 in ExecMergeMatched (context=0x8211c4108, resultRelInfo=0x835c046b0, tupleid=0x0, oldtuple=0x8211c4060, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [20:10:23.973] result = TM_Ok [20:10:23.973] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [20:10:23.973] relaction = 0x835d65438 [20:10:23.973] commandType = CMD_DELETE [20:10:23.973] l__state = {l = 0x835d659f8, i = 0} [20:10:23.973] mtstate = 0x835c044a0 [20:10:23.973] newslot = 0x0 [20:10:23.973] rslot = 0x0 [20:10:23.973] estate = 0x835c04100 [20:10:23.973] mergeActions = [20:10:23.973] econtext = 0x835d64a68 [20:10:23.973] epqstate = 0x835c04588 [20:10:23.973] actionStates = 0x835d659f8 [20:10:23.973] l = [20:10:23.973] isNull = [20:10:23.973] lmerge_matched = [20:10:23.973] __error = [20:10:23.973] l__state = [20:10:23.973] result = [20:10:23.973] updateCxt = [20:10:23.973] relaction = [20:10:23.973] commandType = [20:10:23.973] __error = [20:10:23.973] resultRelationDesc = [20:10:23.973] lockmode = [20:10:23.973] inputslot = [20:10:23.973] epqslot = [20:10:23.973] was_matched = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] #7 ExecMerge (context=0x8211c4108, resultRelInfo=0x835c046b0, tupleid=0x0, oldtuple=0x8211c4060, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [20:10:23.973] matched = [20:10:23.973] rslot = 0x0 [20:10:23.973] #8 ExecModifyTable (pstate=0x835c044a0) at ../src/backend/executor/nodeModifyTable.c:4133 [20:10:23.973] context = {mtstate = 0x835c044a0, epqstate = 0x835c04588, estate = 0x835c04100, planSlot = 0x835c8b2f0, tmfd = {ctid = {ip_blkid = {bi_hi = 63160, bi_lo = 13784}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x835c046b0} [20:10:23.973] tuple_ctid = {ip_blkid = {bi_hi = 53008, bi_lo = 16664}, ip_posid = 8} [20:10:23.973] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835c59118} [20:10:23.973] node = 0x835c044a0 [20:10:23.973] estate = 0x835c04100 [20:10:23.973] operation = CMD_MERGE [20:10:23.973] resultRelInfo = 0x835c046b0 [20:10:23.973] subplanstate = 0x835c05df0 [20:10:23.973] slot = [20:10:23.973] tupleid = 0x0 [20:10:23.973] oldtuple = 0x8211c4060 [20:10:23.973] oldSlot = [20:10:23.973] #9 0x000000000072f54b in ExecProcNode (node=0x835c044a0) at ../src/include/executor/executor.h:278 [20:10:23.973] No locals. [20:10:23.973] #10 ExecutePlan (estate=0x835c04100, planstate=0x835c044a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x832cf0f10, execute_once=) at ../src/backend/executor/execMain.c:1641 [20:10:23.973] current_tuple_count = 0 [20:10:23.973] slot = [20:10:23.973] #11 standard_ExecutorRun (queryDesc=0x832ba3c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [20:10:23.973] estate = 0x835c04100 [20:10:23.973] oldcontext = 0x832cf0c00 [20:10:23.973] operation = CMD_MERGE [20:10:23.973] dest = 0x832cf0f10 [20:10:23.973] sendTuples = true [20:10:23.973] #12 0x00000000009042bf in ProcessQuery (plan=0x835d8efa0, sourceText=, params=0x0, queryEnv=0x0, dest=0x832cf0f10, qc=0x8211c4308) at ../src/backend/tcop/pquery.c:160 [20:10:23.973] queryDesc = 0x832ba3c48 [20:10:23.973] #13 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x832c22100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x832cf0f10, altdest=0xb4a6b0 , qc=qc@entry=0x8211c4308) at ../src/backend/tcop/pquery.c:1287 [20:10:23.973] pstmt = 0x835d8efa0 [20:10:23.973] stmtlist_item__state = {l = 0x835d93858, i = 0} [20:10:23.973] active_snapshot_set = true [20:10:23.973] stmtlist_item = 0x835d93870 [20:10:23.973] #14 0x000000000090336c in FillPortalStore (portal=portal@entry=0x832c22100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [20:10:23.973] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:10:23.973] treceiver = 0x832cf0f10 [20:10:23.973] #15 0x00000000009030db in PortalRun (portal=portal@entry=0x832c22100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835d938a8, altdest=altdest@entry=0x835d938a8, qc=0x8211c4440) at ../src/backend/tcop/pquery.c:763 [20:10:23.973] _local_sigjmp_buf = {{_sjb = {9449597, 35211321600, 34915238712, 34915238944, 34915238720, 35211341824, 12105032, 12138344, 35211314047, 35210449152, 4294967984, 0}}} [20:10:23.973] _save_exception_stack = 0x8211c4510 [20:10:23.973] _save_context_stack = 0x0 [20:10:23.973] _do_rethrow = false [20:10:23.973] saveTopTransactionResourceOwner = 0x832c34798 [20:10:23.973] saveTopTransactionContext = 0x832c27000 [20:10:23.973] saveActivePortal = 0x0 [20:10:23.973] saveResourceOwner = 0x832c34798 [20:10:23.973] savePortalContext = 0x0 [20:10:23.973] saveMemoryContext = 0x832c27000 [20:10:23.973] result = [20:10:23.973] nprocessed = [20:10:23.973] #16 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x832b4d100 "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:1284 [20:10:23.973] cmdtaglen = 5 [20:10:23.973] snapshot_set = [20:10:23.973] per_parsetree_context = 0x0 [20:10:23.973] plantree_list = [20:10:23.973] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:10:23.973] format = 0 [20:10:23.973] parsetree = 0x835d323e8 [20:10:23.973] commandTag = [20:10:23.973] cmdtagname = [20:10:23.973] querytree_list = [20:10:23.973] portal = 0x832c22100 [20:10:23.973] receiver = 0x835d938a8 [20:10:23.973] parsetree_item__state = {l = 0x835d33cb0, i = 0} [20:10:23.973] msec_str = "\000\000\000\000\b", '\000' , ";\203\317f\000\000\000\000\365,.\313\021\r\210-" [20:10:23.973] dest = DestRemote [20:10:23.973] was_logged = [20:10:23.973] oldcontext = 0x832c27000 [20:10:23.973] parsetree_list = 0x835d33cb0 [20:10:23.973] use_implicit_block = false [20:10:23.973] parsetree_item = 0x835d33cc8 [20:10:23.973] save_log_statement_stats = [20:10:23.973] #17 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [20:10:23.973] query_string = 0x832b4d100 "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"... [20:10:23.973] input_message = {data = 0x832b4d100 "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 = 278, maxlen = 1024, cursor = 278} [20:10:23.973] firstchar = [20:10:23.973] local_sigjmp_buf = {{_sjb = {9433510, 34915239184, 34915239144, 34915239728, 12147080, 1, 8192, 8388608, 34915222399, 0, 0, 1}}} [20:10:23.973] send_ready_for_query = false [20:10:23.973] idle_in_transaction_timeout_enabled = false [20:10:23.973] idle_session_timeout_enabled = false [20:10:23.973] #18 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:10:23.973] bsdata = [20:10:23.973] #19 0x0000000000854667 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8211c5254 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211c5190) at ../src/backend/postmaster/launch_backend.c:274 [20:10:23.973] pid = [20:10:23.973] #20 0x0000000000858a28 in BackendStartup (client_sock=0x8211c5190) at ../src/backend/postmaster/postmaster.c:3414 [20:10:23.973] startup_data = {canAcceptConnections = CAC_OK} [20:10:23.973] bn = 0x832b593a8 [20:10:23.973] pid = [20:10:23.973] __error = [20:10:23.973] save_errno = [20:10:23.973] __error = [20:10:23.973] __error = [20:10:23.973] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:10:23.973] 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 = "\000\357\2642\b", '\000' , "\360Q\034!\b\000\000\000hug)\b\000\000\000\v\000\000\000\000\000\000\000^\377g)\b", '\000' , "0R\034!\b\000\000\000\024D\205\000\000\000\000\000@R\034!\b", '\000' }, salen = 16}} [20:10:23.973] i = 0 [20:10:23.973] now = [20:10:23.973] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 697019522, events = 8, fd = 0, user_data = 0x8211c5140}, {pos = 851109336, events = 8, fd = 555503568, user_data = 0x0}, {pos = 0, events = 0, fd = 2039856869, user_data = 0x52e1209830a}, {pos = 696186784, events = 8, fd = 696257912, user_data = 0x8211c4c58}, {pos = 555502800, events = 8, fd = 555502680, user_data = 0x52e1209830a}, {pos = 696165256, events = 8, fd = 696257912, user_data = 0x8211c4c88}, {pos = 555502848, events = 8, fd = 555502728, user_data = 0x8297f9194}, {pos = 565253128, events = 8, fd = 696226196, user_data = 0x8211c4cf0}, {pos = 302593082, events = 1326, fd = 698048560, user_data = 0x1}, {pos = 555502880, events = 8, fd = 302613258, user_data = 0x8297e2858}, {pos = 696257912, events = 8, fd = 555502840, user_data = 0x8211c4d70}, {pos = 555502840, events = 8, fd = 696220940, user_data = 0x821b11408}, {pos = 696220940, events = 8, fd = 555502944, user_data = 0x52e1209343a}, {pos = 555502984, events = 8, fd = 555503432, user_data = 0x8211c4d70}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1408114870, fd = 565276728, user_data = 0x800000001}, {pos = 565253128, events = 8, fd = 696165256, user_data = 0x821b16288}, {pos = 696133720, events = 8, fd = 565253128, user_data = 0x8211c4df8}, {pos = 555503544, events = 8, fd = 555503072, user_data = 0x52e12097ca2}, {pos = 2699790, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 565276728, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 555503800, user_data = 0x21b11408}, {pos = 555503616, events = 8, fd = 555503216, user_data = 0x1}, {pos = 555503544, events = 8, fd = 32, user_data = 0x8211c4e60}, {pos = 302611059, events = 1326, fd = 555503488, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821b17038}, {pos = 1, events = 8, fd = 565253128, user_data = 0x8297e2858}, {pos = 555503800, events = 8, fd = 555503616, user_data = 0x8211c4e70}, {pos = 0, events = 0, fd = 565223432, user_data = 0x20}, {pos = 555503600, events = 8, fd = 302586599, user_data = 0x821b0a008}, {pos = 565224456, events = 8, fd = 565225480, user_data = 0x821b0ac08}, {pos = 565239816, events = 8, fd = 565240840, user_data = 0x821b0e808}, {pos = 565242888, events = 8, fd = 565243912, user_data = 0x821b0f408}, {pos = 565245960, events = 8, fd = 565246984, user_data = 0x821b10008}, {pos = 565249032, events = 8, fd = 565250056, user_data = 0x821b10c08}, {pos = 565252104, events = 8, fd = 565253128, user_data = 0x821b11808}, {pos = 565255176, events = 8, fd = 565256200, user_data = 0x821b12408}, {pos = 565258248, events = 8, fd = 565259272, user_data = 0x821b13008}, {pos = 565261320, events = 8, fd = 565262344, user_data = 0x821b13c08}, {pos = 565268488, events = 8, fd = 565269512, user_data = 0x821b15808}, {pos = 565271560, events = 8, fd = 565223432, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821b17038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555503800, events = 8, fd = 555503216, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 565276728, user_data = 0x1}, {pos = 565223432, events = 8, fd = 314, user_data = 0x8211c50a0}, {pos = 302585327, events = 1326, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565276728, user_data = 0x1}, {pos = 565253128, events = 8, fd = 850644992, user_data = 0x1}, {pos = 850645396, events = 8, fd = 0, user_data = 0x8211c5070}, {pos = 694678892, events = 8, fd = 1, user_data = 0x832b3d000}, {pos = 555503776, events = 8, fd = 694675202, user_data = 0x829914170 }, {pos = 12072120, events = 0, fd = 697385328, user_data = 0x821b11408}, {pos = 555504000, events = 8, fd = 302584798, user_data = 0x832b5b800}, {pos = 1, events = 0, fd = 302584414, user_data = 0x821b0a008}, {pos = 555503784, events = 8, fd = 555504000, user_data = 0x1c38}, {pos = 850718464, events = 8, fd = 302664080, user_data = 0x0}, {pos = 555484031, events = 8, fd = 7886791, user_data = 0x8211c5130}, {pos = 694637584, events = 8, fd = 698048560, user_data = 0x8299b8310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8211c5160}, {pos = 694680477, events = 8, fd = 850644992, user_data = 0x1b01}, {pos = 555504064, events = 8, fd = 694647034, user_data = 0x0}, {pos = 0, events = 0, fd = 2039856869, user_data = 0x0}} [20:10:23.973] last_touch_time = 1724875569 [20:10:23.973] last_lockfile_recheck_time = 1724875569 [20:10:23.973] nevents = 1 [20:10:23.973] #22 0x0000000000856845 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8211c57a8) at ../src/backend/postmaster/postmaster.c:1346 [20:10:23.973] userDoption = [20:10:23.973] listen_addr_saved = [20:10:23.973] output_config_variable = [20:10:23.973] opt = [20:10:23.973] status = [20:10:23.973] #23 0x00000000007924cc in main (argc=8, argv=0x8211c57a8) at ../src/backend/main/main.c:197 [20:10:23.973] do_check_root = [20:10:23.985] [20:10:23.985] [20:10:23.985] [20:10:24.045] dumping /tmp/cores/postgres.9040.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:10:24.165] [New LWP 101799] [20:10:24.229] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [20:10:24.229] Program terminated with signal SIGABRT, Aborted. [20:10:24.229] Sent by thr_kill() from pid 9040 and user 1003. [20:10:24.229] #0 0x000000082c8fa41a in thr_kill () from /lib/libc.so.7 [20:10:24.704] [20:10:24.704] Thread 1 (LWP 101799): [20:10:24.704] #0 0x000000082c8fa41a in thr_kill () from /lib/libc.so.7 [20:10:24.704] No symbol table info available. [20:10:24.704] #1 0x000000082c873e64 in raise () from /lib/libc.so.7 [20:10:24.704] No symbol table info available. [20:10:24.704] #2 0x000000082c9246f9 in abort () from /lib/libc.so.7 [20:10:24.704] No symbol table info available. [20:10:24.704] #3 0x0000000000a58cd5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [20:10:24.704] No locals. [20:10:24.704] #4 0x000000000073d2df in ExecFetchSlotHeapTuple (slot=0x821096f90, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [20:10:24.704] No locals. [20:10:24.704] #5 0x0000000000701f97 in ExecIRDeleteTriggers (estate=estate@entry=0x835b76100, relinfo=relinfo@entry=0x835b766b0, slot=slot@entry=0x821096f90) at ../src/backend/commands/trigger.c:2841 [20:10:24.704] trigger = [20:10:24.704] oldtuple = [20:10:24.704] should_free = false [20:10:24.704] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83808c480, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [20:10:24.704] trigdesc = 0x835b768c0 [20:10:24.704] newtuple = 0x0 [20:10:24.704] i = 0 [20:10:24.704] #6 0x00000000007624b7 in ExecMergeMatched (context=0x821097038, resultRelInfo=0x835b766b0, tupleid=0x0, oldtuple=0x821096f90, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [20:10:24.704] result = TM_Ok [20:10:24.704] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [20:10:24.704] relaction = 0x838190b38 [20:10:24.704] commandType = CMD_DELETE [20:10:24.704] l__state = {l = 0x8381910f8, i = 0} [20:10:24.704] mtstate = 0x835b764a0 [20:10:24.704] newslot = 0x0 [20:10:24.704] rslot = 0x0 [20:10:24.704] estate = 0x835b76100 [20:10:24.704] mergeActions = [20:10:24.704] econtext = 0x838190168 [20:10:24.704] epqstate = 0x835b76588 [20:10:24.704] actionStates = 0x8381910f8 [20:10:24.704] l = [20:10:24.704] isNull = [20:10:24.704] lmerge_matched = [20:10:24.704] __error = [20:10:24.704] l__state = [20:10:24.704] result = [20:10:24.704] updateCxt = [20:10:24.704] relaction = [20:10:24.704] commandType = [20:10:24.704] __error = [20:10:24.704] resultRelationDesc = [20:10:24.704] lockmode = [20:10:24.704] inputslot = [20:10:24.704] epqslot = [20:10:24.704] was_matched = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] #7 ExecMerge (context=0x821097038, resultRelInfo=0x835b766b0, tupleid=0x0, oldtuple=0x821096f90, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [20:10:24.704] matched = [20:10:24.704] rslot = 0x0 [20:10:24.704] #8 ExecModifyTable (pstate=0x835b764a0) at ../src/backend/executor/nodeModifyTable.c:4133 [20:10:24.704] context = {mtstate = 0x835b764a0, epqstate = 0x835b76588, estate = 0x835b76100, planSlot = 0x8380c16f0, tmfd = {ctid = {ip_blkid = {bi_hi = 56952, bi_lo = 14363}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x835b766b0} [20:10:24.704] tuple_ctid = {ip_blkid = {bi_hi = 25568, bi_lo = 17164}, ip_posid = 8} [20:10:24.704] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835bac118} [20:10:24.704] node = 0x835b764a0 [20:10:24.704] estate = 0x835b76100 [20:10:24.704] operation = CMD_MERGE [20:10:24.704] resultRelInfo = 0x835b766b0 [20:10:24.704] subplanstate = 0x835b77df0 [20:10:24.704] slot = [20:10:24.704] tupleid = 0x0 [20:10:24.704] oldtuple = 0x821096f90 [20:10:24.704] oldSlot = [20:10:24.704] #9 0x000000000072f54b in ExecProcNode (node=0x835b764a0) at ../src/include/executor/executor.h:278 [20:10:24.704] No locals. [20:10:24.704] #10 ExecutePlan (estate=0x835b76100, planstate=0x835b764a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835a0af10, execute_once=) at ../src/backend/executor/execMain.c:1641 [20:10:24.704] current_tuple_count = 0 [20:10:24.704] slot = [20:10:24.704] #11 standard_ExecutorRun (queryDesc=0x835a2e448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [20:10:24.704] estate = 0x835b76100 [20:10:24.704] oldcontext = 0x835a0ac00 [20:10:24.704] operation = CMD_MERGE [20:10:24.704] dest = 0x835a0af10 [20:10:24.704] sendTuples = true [20:10:24.704] #12 0x00000000009042bf in ProcessQuery (plan=0x8381bd760, sourceText=, params=0x0, queryEnv=0x0, dest=0x835a0af10, qc=0x821097238) at ../src/backend/tcop/pquery.c:160 [20:10:24.704] queryDesc = 0x835a2e448 [20:10:24.704] #13 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x835a75100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835a0af10, altdest=0xb4a6b0 , qc=qc@entry=0x821097238) at ../src/backend/tcop/pquery.c:1287 [20:10:24.704] pstmt = 0x8381bd760 [20:10:24.704] stmtlist_item__state = {l = 0x8381c2018, i = 0} [20:10:24.704] active_snapshot_set = true [20:10:24.704] stmtlist_item = 0x8381c2030 [20:10:24.704] #14 0x000000000090336c in FillPortalStore (portal=portal@entry=0x835a75100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [20:10:24.704] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:10:24.704] treceiver = 0x835a0af10 [20:10:24.704] #15 0x00000000009030db in PortalRun (portal=portal@entry=0x835a75100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8381c2068, altdest=altdest@entry=0x8381c2068, qc=0x821097370) at ../src/backend/tcop/pquery.c:763 [20:10:24.704] _local_sigjmp_buf = {{_sjb = {9449597, 35259896064, 34914005608, 34914005840, 34914005616, 35259912192, 12105032, 12138344, 35259876223, 35259224320, 4294967984, 0}}} [20:10:24.704] _save_exception_stack = 0x821097440 [20:10:24.704] _save_context_stack = 0x0 [20:10:24.704] _do_rethrow = false [20:10:24.704] saveTopTransactionResourceOwner = 0x835ac4518 [20:10:24.704] saveTopTransactionContext = 0x835a79000 [20:10:24.704] saveActivePortal = 0x0 [20:10:24.704] saveResourceOwner = 0x835ac4518 [20:10:24.704] savePortalContext = 0x0 [20:10:24.704] saveMemoryContext = 0x835a79000 [20:10:24.704] result = [20:10:24.704] nprocessed = [20:10:24.704] #16 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x8359d1100 "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:1284 [20:10:24.704] cmdtaglen = 5 [20:10:24.704] snapshot_set = [20:10:24.704] per_parsetree_context = 0x0 [20:10:24.704] plantree_list = [20:10:24.704] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:10:24.704] format = 0 [20:10:24.704] parsetree = 0x83815e6e8 [20:10:24.704] commandTag = [20:10:24.704] cmdtagname = [20:10:24.704] querytree_list = [20:10:24.704] portal = 0x835a75100 [20:10:24.704] receiver = 0x8381c2068 [20:10:24.704] parsetree_item__state = {l = 0x83815ffb0, i = 0} [20:10:24.704] msec_str = "\000\000\000\000\b", '\000' , "=\203\317f\000\000\000\000\r*\2679\225\036\200h" [20:10:24.704] dest = DestRemote [20:10:24.704] was_logged = [20:10:24.704] oldcontext = 0x835a79000 [20:10:24.704] parsetree_list = 0x83815ffb0 [20:10:24.704] use_implicit_block = false [20:10:24.704] parsetree_item = 0x83815ffc8 [20:10:24.704] save_log_statement_stats = [20:10:24.704] #17 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [20:10:24.704] query_string = 0x8359d1100 "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"... [20:10:24.704] input_message = {data = 0x8359d1100 "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 = 278, maxlen = 1024, cursor = 278} [20:10:24.704] firstchar = [20:10:24.704] local_sigjmp_buf = {{_sjb = {9433510, 34914006080, 34914006040, 34914006624, 12147080, 1, 8192, 8388608, 34913977215, 0, 0, 1}}} [20:10:24.704] send_ready_for_query = false [20:10:24.704] idle_in_transaction_timeout_enabled = false [20:10:24.704] idle_session_timeout_enabled = false [20:10:24.704] #18 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:10:24.704] bsdata = [20:10:24.704] #19 0x0000000000854667 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821098184 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210980c0) at ../src/backend/postmaster/launch_backend.c:274 [20:10:24.704] pid = [20:10:24.704] #20 0x0000000000858a28 in BackendStartup (client_sock=0x8210980c0) at ../src/backend/postmaster/postmaster.c:3414 [20:10:24.704] startup_data = {canAcceptConnections = CAC_OK} [20:10:24.704] bn = 0x8359defb8 [20:10:24.704] pid = [20:10:24.704] __error = [20:10:24.704] save_errno = [20:10:24.704] __error = [20:10:24.704] __error = [20:10:24.704] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:10:24.704] 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 = "\300.\2355\b", '\000' , " \201\t!\b\000\000\000hƠ‘+\b\000\000\000\v\000\000\000\000\000\000\000^_\222+\b", '\000' , "`\201\t!\b\000\000\000\024D\205\000\000\000\000\000p\201\t!\b", '\000' }, salen = 16}} [20:10:24.704] i = 0 [20:10:24.704] now = [20:10:24.704] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 747236482, events = 8, fd = 0, user_data = 0x821098070}, {pos = 899913176, events = 8, fd = 554270464, user_data = 0x0}, {pos = 0, events = 0, fd = -391374337, user_data = 0x1d160260630a}, {pos = 746403744, events = 8, fd = 746474872, user_data = 0x821097b88}, {pos = 554269696, events = 8, fd = 554269576, user_data = 0x1d160260630a}, {pos = 746382216, events = 8, fd = 746474872, user_data = 0x821097bb8}, {pos = 554269744, events = 8, fd = 554269624, user_data = 0x82c7dd194}, {pos = 560653320, events = 8, fd = 746443156, user_data = 0x821097c20}, {pos = 39851066, events = 7446, fd = 748265520, user_data = 0x1}, {pos = 554269776, events = 8, fd = 39871242, user_data = 0x82c7c6858}, {pos = 746474872, events = 8, fd = 554269736, user_data = 0x821097ca0}, {pos = 554269736, events = 8, fd = 746437900, user_data = 0x8216ae408}, {pos = 746437900, events = 8, fd = 554269840, user_data = 0x1d160260143a}, {pos = 554269880, events = 8, fd = 554270328, user_data = 0x821097ca0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2799930217, fd = 560676920, user_data = 0x800000001}, {pos = 560653320, events = 8, fd = 746382216, user_data = 0x8216b3288}, {pos = 746350680, events = 8, fd = 560653320, user_data = 0x821097d28}, {pos = 554270440, events = 8, fd = 554269968, user_data = 0x1d1602605ca2}, {pos = 2699790, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560676920, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554270696, user_data = 0x216ae408}, {pos = 554270512, events = 8, fd = 554270112, user_data = 0x1}, {pos = 554270440, events = 8, fd = 32, user_data = 0x821097d90}, {pos = 39869043, events = 7446, fd = 554270384, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216b4038}, {pos = 1, events = 8, fd = 560653320, user_data = 0x82c7c6858}, {pos = 554270696, events = 8, fd = 554270512, user_data = 0x821097da0}, {pos = 0, events = 0, fd = 560623624, user_data = 0x20}, {pos = 554270496, events = 8, fd = 39844583, user_data = 0x8216a7008}, {pos = 560624648, events = 8, fd = 560625672, user_data = 0x8216a7c08}, {pos = 560640008, events = 8, fd = 560641032, user_data = 0x8216ab808}, {pos = 560643080, events = 8, fd = 560644104, user_data = 0x8216ac408}, {pos = 560646152, events = 8, fd = 560647176, user_data = 0x8216ad008}, {pos = 560649224, events = 8, fd = 560650248, user_data = 0x8216adc08}, {pos = 560652296, events = 8, fd = 560653320, user_data = 0x8216ae808}, {pos = 560655368, events = 8, fd = 560656392, user_data = 0x8216af408}, {pos = 560658440, events = 8, fd = 560659464, user_data = 0x8216b0008}, {pos = 560661512, events = 8, fd = 560662536, user_data = 0x8216b0c08}, {pos = 560668680, events = 8, fd = 560669704, user_data = 0x8216b2808}, {pos = 560671752, events = 8, fd = 560623624, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216b4038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554270696, events = 8, fd = 554270112, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560676920, user_data = 0x1}, {pos = 560623624, events = 8, fd = 314, user_data = 0x821097fd0}, {pos = 39843311, events = 7446, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560676920, user_data = 0x1}, {pos = 560653320, events = 8, fd = 899420160, user_data = 0x1}, {pos = 899420564, events = 8, fd = 0, user_data = 0x821097fa0}, {pos = 731010412, events = 8, fd = 1, user_data = 0x8359c1000}, {pos = 554270672, events = 8, fd = 731006722, user_data = 0x82c8f8170 }, {pos = 12072120, events = 0, fd = 747602288, user_data = 0x8216ae408}, {pos = 554270896, events = 8, fd = 39842782, user_data = 0x8359df800}, {pos = 1, events = 0, fd = 39842398, user_data = 0x8216a7008}, {pos = 554270680, events = 8, fd = 554270896, user_data = 0x1c38}, {pos = 899493568, events = 8, fd = 39922064, user_data = 0x0}, {pos = 554238847, events = 8, fd = 7886791, user_data = 0x821098060}, {pos = 730969104, events = 8, fd = 748265520, user_data = 0x82c99c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821098090}, {pos = 731011997, events = 8, fd = 899420160, user_data = 0x1b32}, {pos = 554270960, events = 8, fd = 730978554, user_data = 0x0}, {pos = 0, events = 0, fd = -391374337, user_data = 0x0}} [20:10:24.705] last_touch_time = 1724875569 [20:10:24.705] last_lockfile_recheck_time = 1724875569 [20:10:24.705] nevents = 1 [20:10:24.705] #22 0x0000000000856845 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8210986d0) at ../src/backend/postmaster/postmaster.c:1346 [20:10:24.705] userDoption = [20:10:24.705] listen_addr_saved = [20:10:24.705] output_config_variable = [20:10:24.705] opt = [20:10:24.705] status = [20:10:24.705] #23 0x00000000007924cc in main (argc=4, argv=0x8210986d0) at ../src/backend/main/main.c:197 [20:10:24.705] do_check_root = [20:10:24.716] [20:10:24.716] [20:10:24.716] [20:10:24.777] dumping /tmp/cores/postgres.15045.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:10:24.898] [New LWP 101807] [20:10:24.964] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [20:10:24.964] Program terminated with signal SIGABRT, Aborted. [20:10:24.964] Sent by thr_kill() from pid 15045 and user 1003. [20:10:24.964] #0 0x000000082c3bc41a in thr_kill () from /lib/libc.so.7 [20:10:25.447] [20:10:25.447] Thread 1 (LWP 101807): [20:10:25.447] #0 0x000000082c3bc41a in thr_kill () from /lib/libc.so.7 [20:10:25.447] No symbol table info available. [20:10:25.447] #1 0x000000082c335e64 in raise () from /lib/libc.so.7 [20:10:25.447] No symbol table info available. [20:10:25.447] #2 0x000000082c3e66f9 in abort () from /lib/libc.so.7 [20:10:25.447] No symbol table info available. [20:10:25.447] #3 0x0000000000a58cd5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [20:10:25.447] No locals. [20:10:25.447] #4 0x000000000073d2df in ExecFetchSlotHeapTuple (slot=0x820ec0500, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [20:10:25.447] No locals. [20:10:25.447] #5 0x0000000000701f97 in ExecIRDeleteTriggers (estate=estate@entry=0x835e9b100, relinfo=relinfo@entry=0x835e9b6b0, slot=slot@entry=0x820ec0500) at ../src/backend/commands/trigger.c:2841 [20:10:25.447] trigger = [20:10:25.447] oldtuple = [20:10:25.447] should_free = false [20:10:25.447] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x838fcdc00, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [20:10:25.447] trigdesc = 0x835e9b8c0 [20:10:25.447] newtuple = 0x0 [20:10:25.447] i = 0 [20:10:25.447] #6 0x00000000007624b7 in ExecMergeMatched (context=0x820ec05a8, resultRelInfo=0x835e9b6b0, tupleid=0x0, oldtuple=0x820ec0500, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [20:10:25.447] result = TM_Ok [20:10:25.447] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [20:10:25.447] relaction = 0x839131d78 [20:10:25.447] commandType = CMD_DELETE [20:10:25.447] l__state = {l = 0x839132338, i = 0} [20:10:25.447] mtstate = 0x835e9b4a0 [20:10:25.447] newslot = 0x0 [20:10:25.447] rslot = 0x0 [20:10:25.447] estate = 0x835e9b100 [20:10:25.447] mergeActions = [20:10:25.447] econtext = 0x8391313a8 [20:10:25.447] epqstate = 0x835e9b588 [20:10:25.447] actionStates = 0x839132338 [20:10:25.447] l = [20:10:25.447] isNull = [20:10:25.447] lmerge_matched = [20:10:25.447] __error = [20:10:25.447] l__state = [20:10:25.447] result = [20:10:25.447] updateCxt = [20:10:25.447] relaction = [20:10:25.447] commandType = [20:10:25.447] __error = [20:10:25.447] resultRelationDesc = [20:10:25.447] lockmode = [20:10:25.447] inputslot = [20:10:25.447] epqslot = [20:10:25.447] was_matched = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] #7 ExecMerge (context=0x820ec05a8, resultRelInfo=0x835e9b6b0, tupleid=0x0, oldtuple=0x820ec0500, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [20:10:25.447] matched = [20:10:25.447] rslot = 0x0 [20:10:25.447] #8 ExecModifyTable (pstate=0x835e9b4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [20:10:25.447] context = {mtstate = 0x835e9b4a0, epqstate = 0x835e9b588, estate = 0x835e9b100, planSlot = 0x835e39770, tmfd = {ctid = {ip_blkid = {bi_hi = 36238, bi_lo = 11323}, ip_posid = 8}, xmax = 143, cmax = 0, traversed = 154}, cpUpdateReturningSlot = 0x6958b3c70976260d} [20:10:25.447] tuple_ctid = {ip_blkid = {bi_hi = 1488, bi_lo = 8428}, ip_posid = 8} [20:10:25.447] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x838fe1118} [20:10:25.447] node = 0x835e9b4a0 [20:10:25.447] estate = 0x835e9b100 [20:10:25.447] operation = CMD_MERGE [20:10:25.447] resultRelInfo = 0x835e9b6b0 [20:10:25.447] subplanstate = 0x835e9cdf0 [20:10:25.447] slot = [20:10:25.447] tupleid = 0x0 [20:10:25.447] oldtuple = 0x820ec0500 [20:10:25.447] oldSlot = [20:10:25.447] #9 0x000000000072f54b in ExecProcNode (node=0x835e9b4a0) at ../src/include/executor/executor.h:278 [20:10:25.447] No locals. [20:10:25.447] #10 ExecutePlan (estate=0x835e9b100, planstate=0x835e9b4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835e73310, execute_once=) at ../src/backend/executor/execMain.c:1641 [20:10:25.447] current_tuple_count = 0 [20:10:25.447] slot = [20:10:25.447] #11 standard_ExecutorRun (queryDesc=0x835d1ec48, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [20:10:25.447] estate = 0x835e9b100 [20:10:25.447] oldcontext = 0x835e73000 [20:10:25.447] operation = CMD_MERGE [20:10:25.447] dest = 0x835e73310 [20:10:25.447] sendTuples = true [20:10:25.447] #12 0x00000008383dc961 in pgss_ExecutorRun (queryDesc=0x835d1ec48, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [20:10:25.447] _local_sigjmp_buf = {{_sjb = {35303311665, 1, 34912077528, 34912077696, 12138344, 34912077536, 1, 35262688328, 34912076671, 7610529, 35264245760, 34359738368}}} [20:10:25.447] _save_exception_stack = 0x820ec0890 [20:10:25.447] _save_context_stack = 0x0 [20:10:25.447] _do_rethrow = false [20:10:25.447] #13 0x00000000009042bf in ProcessQuery (plan=0x8390f5d80, sourceText=, params=0x0, queryEnv=0x0, dest=0x835e73310, qc=0x820ec0858) at ../src/backend/tcop/pquery.c:160 [20:10:25.447] queryDesc = 0x835d1ec48 [20:10:25.447] #14 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x835d67100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835e73310, altdest=0xb4a6b0 , qc=qc@entry=0x820ec0858) at ../src/backend/tcop/pquery.c:1287 [20:10:25.447] pstmt = 0x8390f5d80 [20:10:25.447] stmtlist_item__state = {l = 0x8390fa638, i = 0} [20:10:25.447] active_snapshot_set = true [20:10:25.447] stmtlist_item = 0x8390fa650 [20:10:25.447] #15 0x000000000090336c in FillPortalStore (portal=portal@entry=0x835d67100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [20:10:25.447] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:10:25.447] treceiver = 0x835e73310 [20:10:25.447] #16 0x00000000009030db in PortalRun (portal=portal@entry=0x835d67100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8390fa688, altdest=altdest@entry=0x8390fa688, qc=0x820ec0990) at ../src/backend/tcop/pquery.c:763 [20:10:25.447] _local_sigjmp_buf = {{_sjb = {9449597, 35262984448, 34912077960, 34912078192, 34912077968, 35263078400, 12105032, 12138344, 35262956415, 35262304512, 4294967984, 0}}} [20:10:25.447] _save_exception_stack = 0x820ec0a60 [20:10:25.447] _save_context_stack = 0x0 [20:10:25.447] _do_rethrow = false [20:10:25.447] saveTopTransactionResourceOwner = 0x835db5518 [20:10:25.447] saveTopTransactionContext = 0x835d7e000 [20:10:25.447] saveActivePortal = 0x0 [20:10:25.447] saveResourceOwner = 0x835db5518 [20:10:25.447] savePortalContext = 0x0 [20:10:25.447] saveMemoryContext = 0x835d7e000 [20:10:25.447] result = [20:10:25.447] nprocessed = [20:10:25.447] #17 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x835cc1100 "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:1284 [20:10:25.447] cmdtaglen = 5 [20:10:25.447] snapshot_set = [20:10:25.447] per_parsetree_context = 0x0 [20:10:25.447] plantree_list = [20:10:25.447] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:10:25.447] format = 0 [20:10:25.447] parsetree = 0x8390d13e8 [20:10:25.447] commandTag = [20:10:25.447] cmdtagname = [20:10:25.447] querytree_list = [20:10:25.447] portal = 0x835d67100 [20:10:25.447] receiver = 0x8390fa688 [20:10:25.447] parsetree_item__state = {l = 0x8390d2cb0, i = 0} [20:10:25.447] msec_str = "\000\000\000\000\b", '\000' , "[\203\317f\000\000\000\000\357j\300RG9", [20:10:25.447] dest = DestRemote [20:10:25.447] was_logged = [20:10:25.447] oldcontext = 0x835d7e000 [20:10:25.447] parsetree_list = 0x8390d2cb0 [20:10:25.447] use_implicit_block = false [20:10:25.447] parsetree_item = 0x8390d2cc8 [20:10:25.447] save_log_statement_stats = [20:10:25.447] #18 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [20:10:25.447] query_string = 0x835cc1100 "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"... [20:10:25.447] input_message = {data = 0x835cc1100 "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 = 278, maxlen = 1024, cursor = 278} [20:10:25.447] firstchar = [20:10:25.447] local_sigjmp_buf = {{_sjb = {9433510, 34912078432, 34912078392, 34912078976, 12147080, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [20:10:25.447] send_ready_for_query = false [20:10:25.447] idle_in_transaction_timeout_enabled = false [20:10:25.447] idle_session_timeout_enabled = false [20:10:25.447] #19 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:10:25.447] bsdata = [20:10:25.447] #20 0x0000000000854667 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820ec17a4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820ec16e0) at ../src/backend/postmaster/launch_backend.c:274 [20:10:25.447] pid = [20:10:25.447] #21 0x0000000000858a28 in BackendStartup (client_sock=0x820ec16e0) at ../src/backend/postmaster/postmaster.c:3414 [20:10:25.447] startup_data = {canAcceptConnections = CAC_OK} [20:10:25.447] bn = 0x835ccd5d8 [20:10:25.447] pid = [20:10:25.447] __error = [20:10:25.447] save_errno = [20:10:25.447] __error = [20:10:25.447] __error = [20:10:25.447] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:10:25.447] 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 = " \034\3145\b", '\000' , "@\027\354 \b\000\000\000hUh*\b\000\000\000\v\000\000\000\000\000\000\000^\337h*\b", '\000' , "\200\027\354 \b\000\000\000\024D\205\000\000\000\000\000\220\027\354 \b", '\000' }, salen = 16}} [20:10:25.447] i = 0 [20:10:25.447] now = [20:10:25.447] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 902993368, events = 8, fd = 552342816, user_data = 0x0}, {pos = 309068554, events = 4542, fd = 740906912, user_data = 0x82c2a6d78}, {pos = 552341912, events = 8, fd = 552342032, user_data = 0x820ec1198}, {pos = 309068554, events = 4542, fd = 740885384, user_data = 0x82c2a6d78}, {pos = 552341960, events = 8, fd = 552342080, user_data = 0x820ec11c8}, {pos = 740946324, events = 8, fd = 560325640, user_data = 0x82c29f194}, {pos = 552342064, events = 8, fd = 309048378, user_data = 0x820ec11d0}, {pos = 711472144, events = 8, fd = 742768688, user_data = 0x11be126c030a}, {pos = 740853848, events = 8, fd = 740978040, user_data = 0x820ec1238}, {pos = 552342192, events = 8, fd = 552342072, user_data = 0x82c29dd0c}, {pos = 560325640, events = 8, fd = 740941068, user_data = 0x820ec12a0}, {pos = 309048378, events = 4542, fd = 552342216, user_data = 0x820ec1498}, {pos = 552342192, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821664038}, {pos = 1, events = 1767420871, fd = 560325640, user_data = 0x82c290388}, {pos = 560347080, events = 8, fd = 0, user_data = 0x0}, {pos = 552342328, events = 8, fd = 552342792, user_data = 0x820ec1320}, {pos = 309066914, events = 4542, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 1767420871, fd = 560349240, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820ec1608}, {pos = 560325640, events = 3, fd = 552342864, user_data = 0x821663828}, {pos = 656, events = 0, fd = 552342792, user_data = 0x820ec1338}, {pos = 552342432, events = 8, fd = 309066523, user_data = 0x820ec14d0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 560349240, events = 8, fd = 1, user_data = 0x82165e408}, {pos = 740853848, events = 8, fd = 552343048, user_data = 0x820ec1550}, {pos = 552342448, events = 8, fd = 0, user_data = 0x821657008}, {pos = 33, events = 0, fd = 552342848, user_data = 0x11be126b9ae7}, {pos = 560295944, events = 8, fd = 560296968, user_data = 0x821657808}, {pos = 560299016, events = 8, fd = 560312328, user_data = 0x82165b408}, {pos = 560314376, events = 8, fd = 560315400, user_data = 0x82165c008}, {pos = 560317448, events = 8, fd = 560318472, user_data = 0x82165cc08}, {pos = 560320520, events = 8, fd = 560321544, user_data = 0x82165d808}, {pos = 560323592, events = 8, fd = 560324616, user_data = 0x82165e408}, {pos = 560326664, events = 8, fd = 560327688, user_data = 0x82165f008}, {pos = 560329736, events = 8, fd = 560330760, user_data = 0x82165fc08}, {pos = 560332808, events = 8, fd = 560333832, user_data = 0x821660808}, {pos = 560335880, events = 8, fd = 560341000, user_data = 0x821662408}, {pos = 560343048, events = 8, fd = 560344072, user_data = 0x821665408}, {pos = 255202000, events = 0, fd = 560295944, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821664038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552343048, events = 8, fd = 552342448, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 560349240, user_data = 0x1}, {pos = 560295944, events = 8, fd = 314, user_data = 0x820ec15f0}, {pos = 309040623, events = 4542, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560349240, user_data = 0x1}, {pos = 560325640, events = 8, fd = 902500352, user_data = 0x1}, {pos = 902500756, events = 8, fd = 0, user_data = 0x820ec15c0}, {pos = 711513452, events = 8, fd = 1, user_data = 0x835cb1000}, {pos = 552343024, events = 8, fd = 711509762, user_data = 0x82c3ba170 }, {pos = 12072120, events = 0, fd = 742105456, user_data = 0x82165e408}, {pos = 552343248, events = 8, fd = 309040094, user_data = 0x835ccf800}, {pos = 1, events = 0, fd = 309039710, user_data = 0x821657008}, {pos = 552343032, events = 8, fd = 552343248, user_data = 0x1c38}, {pos = 902568992, events = 8, fd = 309119376, user_data = 0x0}, {pos = 552338303, events = 8, fd = 7886791, user_data = 0x820ec1680}, {pos = 711472144, events = 8, fd = 742768688, user_data = 0x82c45e310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820ec16b0}, {pos = 711515037, events = 8, fd = 902500352, user_data = 0x33c9}, {pos = 552343312, events = 8, fd = 711481594, user_data = 0x0}, {pos = 0, events = 0, fd = 158737933, user_data = 0x0}} [20:10:25.448] last_touch_time = 1724875600 [20:10:25.448] last_lockfile_recheck_time = 1724875600 [20:10:25.448] nevents = 1 [20:10:25.448] #23 0x0000000000856845 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820ec1cf0) at ../src/backend/postmaster/postmaster.c:1346 [20:10:25.448] userDoption = [20:10:25.448] listen_addr_saved = [20:10:25.448] output_config_variable = [20:10:25.448] opt = [20:10:25.448] status = [20:10:25.448] #24 0x00000000007924cc in main (argc=4, argv=0x820ec1cf0) at ../src/backend/main/main.c:197 [20:10:25.448] do_check_root =