[22:27:56.320] src/tools/ci/cores_backtrace.sh linux /tmp/cores [22:27:56.508] dumping /tmp/cores/postgres-6-18236.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:56.748] [New LWP 18236] [22:27:56.748] [22:27:56.748] This GDB supports auto-downloading debuginfo from the following URLs: [22:27:56.748] [22:27:56.748] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:27:56.748] Debuginfod has been disabled. [22:27:56.748] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:27:56.864] [Thread debugging using libthread_db enabled] [22:27:56.864] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:27:56.864] Core was generated by `postgres: postgres regression [local] MERGE '. [22:27:56.864] Program terminated with signal SIGABRT, Aborted. [22:27:56.864] #0 0x00007fc0a88a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:57.780] [22:27:57.780] Thread 1 (Thread 0x7fc0a681df00 (LWP 18236)): [22:27:57.780] #0 0x00007fc0a88a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:57.780] No symbol table info available. [22:27:57.780] #1 0x00007fc0a885afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:57.780] No symbol table info available. [22:27:57.780] #2 0x00007fc0a8845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:57.780] No symbol table info available. [22:27:57.780] #3 0x0000560a821019b8 in ExceptionalCondition (conditionName=conditionName@entry=0x560a8234ff85 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x560a82374790 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [22:27:57.780] No locals. [22:27:57.780] #4 0x0000560a81aaae75 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffce5cf01b0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffce5cf003f) at ../src/backend/executor/execTuples.c:1737 [22:27:57.780] No locals. [22:27:57.780] #5 0x0000560a81a2e800 in ExecIRDeleteTriggers (estate=estate@entry=0x560a8480e790, relinfo=relinfo@entry=0x560a8480ed40, slot=slot@entry=0x7ffce5cf01b0) at ../src/backend/commands/trigger.c:2842 [22:27:57.780] trigger = 0x560a8480efa0 [22:27:57.780] oldtuple = [22:27:57.780] trigdesc = 0x560a8480ef50 [22:27:57.780] newtuple = 0x0 [22:27:57.780] should_free = false [22:27:57.780] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fc09cfc3138, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [22:27:57.780] i = 0 [22:27:57.780] #6 0x0000560a81b07eb9 in ExecMergeMatched (context=, resultRelInfo=resultRelInfo@entry=0x560a8480ed40, tupleid=0x0, oldtuple=0x7ffce5cf01b0, canSetTag=true, matched=matched@entry=0x7ffce5cf014f) at ../src/backend/executor/nodeModifyTable.c:3082 [22:27:57.780] relaction = 0x560a8489c9b0 [22:27:57.780] commandType = CMD_DELETE [22:27:57.780] result = TM_Ok [22:27:57.780] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [22:27:57.780] l__state = [22:27:57.780] mtstate = 0x560a8480eb30 [22:27:57.780] mergeActions = 0x560a8480ee50 [22:27:57.780] lockedtid = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0} [22:27:57.780] actionStates = 0x560a8489cf70 [22:27:57.780] newslot = 0x0 [22:27:57.780] rslot = 0x0 [22:27:57.780] estate = 0x560a8480e790 [22:27:57.780] econtext = 0x560a8489bfc0 [22:27:57.780] isNull = false [22:27:57.780] epqstate = 0x560a8480ec18 [22:27:57.780] l = [22:27:57.780] __func__ = "ExecMergeMatched" [22:27:57.780] lmerge_matched = [22:27:57.780] #7 0x0000560a81b08ad6 in ExecMerge (context=context@entry=0x7ffce5cf01d0, resultRelInfo=resultRelInfo@entry=0x560a8480ed40, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffce5cf01b0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [22:27:57.780] rslot = 0x0 [22:27:57.780] matched = true [22:27:57.780] #8 0x0000560a81b0a29b in ExecModifyTable (pstate=0x560a8480eb30) at ../src/backend/executor/nodeModifyTable.c:4197 [22:27:57.780] node = 0x560a8480eb30 [22:27:57.780] context = {mtstate = 0x560a8480eb30, epqstate = 0x560a8480ec18, estate = 0x560a8480e790, planSlot = 0x560a8489a3a8, tmfd = {ctid = {ip_blkid = {bi_hi = 2, bi_lo = 0}, ip_posid = 0}, xmax = 2223964792, cmax = 22026, traversed = 10}, cpUpdateReturningSlot = 0x560a82144960 } [22:27:57.780] estate = 0x560a8480e790 [22:27:57.780] operation = CMD_MERGE [22:27:57.780] resultRelInfo = 0x560a8480ed40 [22:27:57.780] subplanstate = 0x560a8480f470 [22:27:57.780] slot = [22:27:57.780] oldSlot = [22:27:57.780] tuple_ctid = {ip_blkid = {bi_hi = 33301, bi_lo = 22026}, ip_posid = 0} [22:27:57.780] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x560a84869e88} [22:27:57.780] oldtuple = 0x7ffce5cf01b0 [22:27:57.780] tupleid = 0x0 [22:27:57.780] tuplock = [22:27:57.780] __func__ = "ExecModifyTable" [22:27:57.780] #9 0x0000560a81a9d399 in ExecProcNodeFirst (node=0x560a8480eb30) at ../src/backend/executor/execProcnode.c:469 [22:27:57.780] No locals. [22:27:57.780] #10 0x0000560a81a886fb in ExecProcNode (node=node@entry=0x560a8480eb30) at ../src/include/executor/executor.h:278 [22:27:57.780] No locals. [22:27:57.780] #11 0x0000560a81a888b0 in ExecutePlan (estate=estate@entry=0x560a8480e790, planstate=0x560a8480eb30, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x560a84885bb0, execute_once=true) at ../src/backend/executor/execMain.c:1659 [22:27:57.780] slot = [22:27:57.780] current_tuple_count = 0 [22:27:57.780] #12 0x0000560a81a8a66b in standard_ExecutorRun (queryDesc=queryDesc@entry=0x560a8488ed38, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:364 [22:27:57.780] estate = 0x560a8480e790 [22:27:57.780] operation = CMD_MERGE [22:27:57.780] dest = 0x560a84885bb0 [22:27:57.780] sendTuples = [22:27:57.780] oldcontext = 0x560a848858a0 [22:27:57.780] __func__ = "standard_ExecutorRun" [22:27:57.780] #13 0x0000560a81a8a8f2 in ExecutorRun (queryDesc=queryDesc@entry=0x560a8488ed38, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:305 [22:27:57.780] No locals. [22:27:57.780] #14 0x0000560a81e7437e in ProcessQuery (plan=plan@entry=0x560a848f2c60, sourceText=0x560a846fab50 "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"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x560a84885bb0, qc=qc@entry=0x7ffce5cf0420) at ../src/backend/tcop/pquery.c:160 [22:27:57.780] queryDesc = 0x560a8488ed38 [22:27:57.780] #15 0x0000560a81e75fb3 in PortalRunMulti (portal=portal@entry=0x560a8477d0f0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x560a84885bb0, altdest=0x560a8267eee0 , qc=qc@entry=0x7ffce5cf0420) at ../src/backend/tcop/pquery.c:1278 [22:27:57.780] pstmt = 0x560a848f2c60 [22:27:57.780] stmtlist_item__state = [22:27:57.780] active_snapshot_set = true [22:27:57.780] stmtlist_item = 0x560a848f2d88 [22:27:57.780] #16 0x0000560a81e76505 in FillPortalStore (portal=portal@entry=0x560a8477d0f0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [22:27:57.780] treceiver = 0x560a84885bb0 [22:27:57.780] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:57.780] __func__ = "FillPortalStore" [22:27:57.780] #17 0x0000560a81e76ad6 in PortalRun (portal=portal@entry=0x560a8477d0f0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x560a848f2dc0, altdest=altdest@entry=0x560a848f2dc0, qc=0x7ffce5cf0600) at ../src/backend/tcop/pquery.c:763 [22:27:57.780] _save_exception_stack = 0x7ffce5cf06b0 [22:27:57.780] _save_context_stack = 0x0 [22:27:57.780] _local_sigjmp_buf = {{__jmpbuf = {0, -5034121600377686679, 94603172106480, 94603173236480, 94603172106480, 94603173236408, -1598787128228186775, -5034109851300399767}, __mask_was_saved = 0, __saved_mask = {__val = {94603132029280, 94603171572304, 112, 4, 94603132033697, 3855549839, 4, 94603173236408, 112, 163, 94603172106480, 94603173236480, 94603173236456, 94603173236408, 94603132120900, 1}}}} [22:27:57.780] _do_rethrow = [22:27:57.780] result = [22:27:57.780] nprocessed = [22:27:57.780] saveTopTransactionResourceOwner = 0x560a84739da8 [22:27:57.780] saveTopTransactionContext = 0x560a8478ed00 [22:27:57.780] saveActivePortal = 0x0 [22:27:57.780] saveResourceOwner = 0x560a84739da8 [22:27:57.780] savePortalContext = 0x0 [22:27:57.780] saveMemoryContext = 0x560a8478ed00 [22:27:57.780] __func__ = "PortalRun" [22:27:57.780] #18 0x0000560a81e6fbd3 in exec_simple_query (query_string=query_string@entry=0x560a846fab50 "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 [22:27:57.780] cmdtaglen = 5 [22:27:57.780] snapshot_set = [22:27:57.780] per_parsetree_context = 0x0 [22:27:57.780] plantree_list = 0x560a848f2d70 [22:27:57.780] parsetree = 0x560a84890eb8 [22:27:57.780] commandTag = [22:27:57.780] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:57.780] querytree_list = [22:27:57.780] portal = 0x560a8477d0f0 [22:27:57.780] receiver = 0x560a848f2dc0 [22:27:57.780] format = 0 [22:27:57.780] cmdtagname = [22:27:57.780] parsetree_item__state = [22:27:57.780] dest = DestRemote [22:27:57.780] oldcontext = 0x560a8478ed00 [22:27:57.780] parsetree_list = 0x560a84890ee8 [22:27:57.780] parsetree_item = 0x560a84890f00 [22:27:57.780] save_log_statement_stats = false [22:27:57.780] was_logged = false [22:27:57.780] use_implicit_block = false [22:27:57.780] msec_str = "`\b\317\345\374\177\000\000fw\022\202\nV\000\000\220\006\317\345\374\177\000\000\026\001\000\000\000\000\000" [22:27:57.780] __func__ = "exec_simple_query" [22:27:57.780] #19 0x0000560a81e72957 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [22:27:57.780] query_string = 0x560a846fab50 "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"... [22:27:57.780] firstchar = [22:27:57.780] input_message = {data = 0x560a846fab50 "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} [22:27:57.780] local_sigjmp_buf = {{__jmpbuf = {94603144589592, -5034116555280091799, 4, 140724164036704, 140724164036848, 140724164036852, -1598787128299489943, -5034109849229593239}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94603171303024, 15616, 94603144583680, 94603171827040, 140724164036848, 94603132033245, 0, 9, 2, 94603144589600, 94603171303024, 94603144583680, 140724164036704, 140724164036848, 140724164036852}}}} [22:27:57.780] send_ready_for_query = false [22:27:57.780] idle_in_transaction_timeout_enabled = false [22:27:57.780] idle_session_timeout_enabled = false [22:27:57.780] __func__ = "PostgresMain" [22:27:57.780] #20 0x0000560a81e687ce in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:27:57.780] bsdata = [22:27:57.780] #21 0x0000560a81d2016d in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffce5cf080c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffce5cf0860) at ../src/backend/postmaster/launch_backend.c:274 [22:27:57.780] pid = [22:27:57.780] #22 0x0000560a81d25c21 in BackendStartup (client_sock=client_sock@entry=0x7ffce5cf0860) at ../src/backend/postmaster/postmaster.c:3420 [22:27:57.780] bn = 0x560a847231b8 [22:27:57.780] pid = [22:27:57.780] startup_data = {canAcceptConnections = CAC_OK} [22:27:57.780] __func__ = "BackendStartup" [22:27:57.780] #23 0x0000560a81d26183 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [22:27:57.780] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\317\345\374\177\000\000\364\b\317\345\374\177", '\000' , "\306\177\356\200\nV\000\000\220g\352\200\nV\000\000\300\t\317\345\374\177\000\000\270\t\317\345\374\177\000\000\225[\362\001\000\000\000\000\2404\003\251\300\177\000\000+", '\000' , "\333~\356\200\nV\000\000hv\020\252\300\177\000\00006\003\251\300\177\000", __ss_align = 140465463653088}, salen = 2}} [22:27:57.780] i = 0 [22:27:57.780] now = [22:27:57.780] last_lockfile_recheck_time = 1727562262 [22:27:57.780] last_touch_time = 1727562262 [22:27:57.780] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -1441761688, user_data = 0x0}, {pos = -1441762592, events = 32704, fd = 2090263927, user_data = 0x7ffce5cf0a40}, {pos = -1441932728, events = 32704, fd = 15, user_data = 0x7fc0a9033630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1441762592, events = 32704, fd = -439416392, user_data = 0x7ffce5cf09c0}, {pos = -1441761688, events = 32704, fd = 0, user_data = 0x560a846fac10}, {pos = -2112278099, events = 22026, fd = 32768, user_data = 0x1}, {pos = -2073048752, events = 22026, fd = -1, user_data = 0x7fc0a882e020}, {pos = -1445761120, events = 32704, fd = -2072872984, user_data = 0x560a847276c8}, {pos = -2072864543, events = 22026, fd = -1441907010, user_data = 0x1}, {pos = -1441762592, events = 32704, fd = 438, user_data = 0x560a8269edb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x560a846fac10}, {pos = -1441907010, events = 32704, fd = 1, user_data = 0x0}, {pos = -1467817952, events = 32704, fd = -1467011648, user_data = 0x10}, {pos = -439415248, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1441898054, user_data = 0x0}, {pos = -1467290332, events = 32704, fd = 0, user_data = 0x560a82d2faa0 }, {pos = 2, events = 0, fd = 7, user_data = 0x560a846bcf10}, {pos = -2116015211, events = 22026, fd = -2072846981, user_data = 0x560a81e067ce }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x560a846fac10}, {pos = -1441907010, events = 32704, fd = 1, user_data = 0x0}, {pos = -1467783992, events = 32704, fd = -1467365248, user_data = 0x423}, {pos = -1467256851, events = 32704, fd = 2, user_data = 0x560a847264b0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -1465967520, events = 32704, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x6147736f2d737365}, {pos = 168446842, events = 824188960, fd = 822763892, user_data = 0x30340a3236323236}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = -2112599712, events = 22026, fd = -2072870704, user_data = 0x7fc0a88b56eb}, {pos = -1465984544, events = 32704, fd = -1467346578, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x1b797279b1c75700}, {pos = -1465981472, events = 32704, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2072873592, user_data = 0x560a82145223 }, {pos = -2072873792, events = 22026, fd = 3, user_data = 0x0}, {pos = 16123, events = 0, fd = -328, user_data = 0x0}, {pos = -2073056240, events = 22026, fd = -1467011117, user_data = 0x7ffce5cf0ee8}, {pos = -2112516396, events = 22026, fd = -2100039472, user_data = 0x560a82147991 }, {pos = -2072873792, events = 22026, fd = -2073056688, user_data = 0x560a847274c0}, {pos = -1467262914, events = 32704, fd = 0, user_data = 0x560a821595fb }, {pos = -2072873792, events = 1, fd = -2112514236, user_data = 0x560a846faa50}, {pos = -1312336128, events = 460943993, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1467340111, user_data = 0x7fc0a88a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1312336128, user_data = 0x560a846d2180}, {pos = -1312336128, events = 460943993, fd = 11, user_data = 0x1b797279b1c75700}, {pos = 0, events = 0, fd = -1467633095, user_data = 0x1}, {pos = -2116944278, events = 22026, fd = 4194304, user_data = 0x560a82147825 }, {pos = -2073222784, events = 22026, fd = -2073056688, user_data = 0x560a846d2180}, {pos = 1, events = 0, fd = 0, user_data = 0x560a821595fb }, {pos = -2073222784, events = 22026, fd = -2112514236, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x560a81b55876 }, {pos = 0, events = 0, fd = -2118800458, user_data = 0xb}, {pos = -2116923121, events = 22026, fd = -2103638928, user_data = 0x560a846fb428}} [22:27:57.780] nevents = 1 [22:27:57.780] __func__ = "ServerLoop" [22:27:57.780] #24 0x0000560a81d27906 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x560a846b8dd0) at ../src/backend/postmaster/postmaster.c:1351 [22:27:57.780] opt = [22:27:57.780] status = [22:27:57.780] userDoption = [22:27:57.780] listen_addr_saved = false [22:27:57.780] output_config_variable = [22:27:57.780] __func__ = "PostmasterMain" [22:27:57.780] #25 0x0000560a81b65c52 in main (argc=8, argv=0x560a846b8dd0) at ../src/backend/main/main.c:197 [22:27:57.780] do_check_root = [22:27:57.814] -e [22:27:57.814] [22:27:57.814] [22:27:57.874] dumping /tmp/cores/postgres-6-19165.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:27:58.108] [New LWP 19165] [22:27:58.108] [22:27:58.108] This GDB supports auto-downloading debuginfo from the following URLs: [22:27:58.108] [22:27:58.108] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:27:58.108] Debuginfod has been disabled. [22:27:58.108] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:27:58.208] [Thread debugging using libthread_db enabled] [22:27:58.208] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:27:58.208] Core was generated by `postgres: old_node: postgres regression [local] MERGE '. [22:27:58.208] Program terminated with signal SIGABRT, Aborted. [22:27:58.208] #0 0x00007f92ceaa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:59.091] [22:27:59.091] Thread 1 (Thread 0x7f92cca36f00 (LWP 19165)): [22:27:59.091] #0 0x00007f92ceaa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:59.091] No symbol table info available. [22:27:59.091] #1 0x00007f92cea5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:59.091] No symbol table info available. [22:27:59.091] #2 0x00007f92cea45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:59.091] No symbol table info available. [22:27:59.091] #3 0x00005564ffc769b8 in ExceptionalCondition (conditionName=conditionName@entry=0x5564ffec4f85 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x5564ffee9790 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [22:27:59.091] No locals. [22:27:59.091] #4 0x00005564ff61fe75 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fff1fb15df0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fff1fb15c7f) at ../src/backend/executor/execTuples.c:1737 [22:27:59.091] No locals. [22:27:59.091] #5 0x00005564ff5a3800 in ExecIRDeleteTriggers (estate=estate@entry=0x556500db9d30, relinfo=relinfo@entry=0x556500dba2e0, slot=slot@entry=0x7fff1fb15df0) at ../src/backend/commands/trigger.c:2842 [22:27:59.091] trigger = 0x556500dba540 [22:27:59.091] oldtuple = [22:27:59.091] trigdesc = 0x556500dba4f0 [22:27:59.091] newtuple = 0x0 [22:27:59.091] should_free = false [22:27:59.091] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f92c3472738, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [22:27:59.091] i = 0 [22:27:59.091] #6 0x00005564ff67ceb9 in ExecMergeMatched (context=, resultRelInfo=resultRelInfo@entry=0x556500dba2e0, tupleid=0x0, oldtuple=0x7fff1fb15df0, canSetTag=true, matched=matched@entry=0x7fff1fb15d8f) at ../src/backend/executor/nodeModifyTable.c:3082 [22:27:59.091] relaction = 0x556500eb4430 [22:27:59.091] commandType = CMD_DELETE [22:27:59.091] result = TM_Ok [22:27:59.091] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [22:27:59.091] l__state = [22:27:59.091] mtstate = 0x556500dba0d0 [22:27:59.091] mergeActions = 0x556500dba3f0 [22:27:59.091] lockedtid = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0} [22:27:59.091] actionStates = 0x556500eb49f0 [22:27:59.091] newslot = 0x0 [22:27:59.091] rslot = 0x0 [22:27:59.091] estate = 0x556500db9d30 [22:27:59.091] econtext = 0x556500eb3a40 [22:27:59.091] isNull = false [22:27:59.091] epqstate = 0x556500dba1b8 [22:27:59.091] l = [22:27:59.091] __func__ = "ExecMergeMatched" [22:27:59.091] lmerge_matched = [22:27:59.091] #7 0x00005564ff67dad6 in ExecMerge (context=context@entry=0x7fff1fb15e10, resultRelInfo=resultRelInfo@entry=0x556500dba2e0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fff1fb15df0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [22:27:59.091] rslot = 0x0 [22:27:59.091] matched = true [22:27:59.091] #8 0x00005564ff67f29b in ExecModifyTable (pstate=0x556500dba0d0) at ../src/backend/executor/nodeModifyTable.c:4197 [22:27:59.091] node = 0x556500dba0d0 [22:27:59.091] context = {mtstate = 0x556500dba0d0, epqstate = 0x556500dba1b8, estate = 0x556500db9d30, planSlot = 0x556500eb1e28, tmfd = {ctid = {ip_blkid = {bi_hi = 2, bi_lo = 0}, ip_posid = 0}, xmax = 15361208, cmax = 21861, traversed = 10}, cpUpdateReturningSlot = 0x5564ffcb9960 } [22:27:59.091] estate = 0x556500db9d30 [22:27:59.091] operation = CMD_MERGE [22:27:59.091] resultRelInfo = 0x556500dba2e0 [22:27:59.091] subplanstate = 0x556500dbaa10 [22:27:59.091] slot = [22:27:59.091] oldSlot = [22:27:59.091] tuple_ctid = {ip_blkid = {bi_hi = 65484, bi_lo = 21860}, ip_posid = 0} [22:27:59.091] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x556500e1ff68} [22:27:59.091] oldtuple = 0x7fff1fb15df0 [22:27:59.091] tupleid = 0x0 [22:27:59.091] tuplock = [22:27:59.091] __func__ = "ExecModifyTable" [22:27:59.091] #9 0x00005564ff612399 in ExecProcNodeFirst (node=0x556500dba0d0) at ../src/backend/executor/execProcnode.c:469 [22:27:59.091] No locals. [22:27:59.091] #10 0x00005564ff5fd6fb in ExecProcNode (node=node@entry=0x556500dba0d0) at ../src/include/executor/executor.h:278 [22:27:59.091] No locals. [22:27:59.091] #11 0x00005564ff5fd8b0 in ExecutePlan (estate=estate@entry=0x556500db9d30, planstate=0x556500dba0d0, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x556500e423b0, execute_once=true) at ../src/backend/executor/execMain.c:1659 [22:27:59.091] slot = [22:27:59.091] current_tuple_count = 0 [22:27:59.091] #12 0x00005564ff5ff66b in standard_ExecutorRun (queryDesc=queryDesc@entry=0x556500e37ec8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:364 [22:27:59.091] estate = 0x556500db9d30 [22:27:59.091] operation = CMD_MERGE [22:27:59.091] dest = 0x556500e423b0 [22:27:59.091] sendTuples = [22:27:59.091] oldcontext = 0x556500e420a0 [22:27:59.091] __func__ = "standard_ExecutorRun" [22:27:59.091] #13 0x00005564ff5ff8f2 in ExecutorRun (queryDesc=queryDesc@entry=0x556500e37ec8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:305 [22:27:59.091] No locals. [22:27:59.091] #14 0x00005564ff9e937e in ProcessQuery (plan=plan@entry=0x556500ea8ea0, sourceText=0x556500cb0ad0 "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"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x556500e423b0, qc=qc@entry=0x7fff1fb16060) at ../src/backend/tcop/pquery.c:160 [22:27:59.091] queryDesc = 0x556500e37ec8 [22:27:59.091] #15 0x00005564ff9eafb3 in PortalRunMulti (portal=portal@entry=0x556500d33720, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x556500e423b0, altdest=0x5565001f3ee0 , qc=qc@entry=0x7fff1fb16060) at ../src/backend/tcop/pquery.c:1278 [22:27:59.091] pstmt = 0x556500ea8ea0 [22:27:59.091] stmtlist_item__state = [22:27:59.091] active_snapshot_set = true [22:27:59.091] stmtlist_item = 0x556500ea8fc8 [22:27:59.091] #16 0x00005564ff9eb505 in FillPortalStore (portal=portal@entry=0x556500d33720, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [22:27:59.091] treceiver = 0x556500e423b0 [22:27:59.091] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:59.091] __func__ = "FillPortalStore" [22:27:59.091] #17 0x00005564ff9ebad6 in PortalRun (portal=portal@entry=0x556500d33720, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x556500ea9000, altdest=altdest@entry=0x556500ea9000, qc=0x7fff1fb16240) at ../src/backend/tcop/pquery.c:763 [22:27:59.091] _save_exception_stack = 0x7fff1fb162f0 [22:27:59.091] _save_context_stack = 0x0 [22:27:59.091] _local_sigjmp_buf = {{__jmpbuf = {0, 7948122454818152463, 93892293900064, 93892294998976, 93892293900064, 93892294998904, 4285555429752037391, 7948459350741344271}, __mask_was_saved = 0, __saved_mask = {__val = {93892276623712, 93892293364176, 112, 4, 93892276628129, 531718607, 4, 93892294998904, 112, 163, 93892293900064, 93892294998976, 93892294998952, 93892294998904, 93892276715332, 1}}}} [22:27:59.091] _do_rethrow = [22:27:59.091] result = [22:27:59.091] nprocessed = [22:27:59.091] saveTopTransactionResourceOwner = 0x556500cf08d8 [22:27:59.091] saveTopTransactionContext = 0x556500d44700 [22:27:59.091] saveActivePortal = 0x0 [22:27:59.091] saveResourceOwner = 0x556500cf08d8 [22:27:59.091] savePortalContext = 0x0 [22:27:59.091] saveMemoryContext = 0x556500d44700 [22:27:59.091] __func__ = "PortalRun" [22:27:59.091] #18 0x00005564ff9e4bd3 in exec_simple_query (query_string=query_string@entry=0x556500cb0ad0 "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 [22:27:59.091] cmdtaglen = 5 [22:27:59.091] snapshot_set = [22:27:59.091] per_parsetree_context = 0x0 [22:27:59.091] plantree_list = 0x556500ea8fb0 [22:27:59.091] parsetree = 0x556500e3fb78 [22:27:59.091] commandTag = [22:27:59.091] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:59.091] querytree_list = [22:27:59.091] portal = 0x556500d33720 [22:27:59.091] receiver = 0x556500ea9000 [22:27:59.091] format = 0 [22:27:59.091] cmdtagname = [22:27:59.091] parsetree_item__state = [22:27:59.091] dest = DestRemote [22:27:59.091] oldcontext = 0x556500d44700 [22:27:59.091] parsetree_list = 0x556500e3fba8 [22:27:59.091] parsetree_item = 0x556500e3fbc0 [22:27:59.091] save_log_statement_stats = false [22:27:59.091] was_logged = true [22:27:59.091] use_implicit_block = false [22:27:59.091] msec_str = "\240d\261\037\377\177\000\000f\307\311\377dU\000\000\320b\261\037\377\177\000\000\026\001\000\000\000\000\000" [22:27:59.091] __func__ = "exec_simple_query" [22:27:59.091] #19 0x00005564ff9e7957 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [22:27:59.091] query_string = 0x556500cb0ad0 "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"... [22:27:59.091] firstchar = [22:27:59.091] input_message = {data = 0x556500cb0ad0 "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} [22:27:59.091] local_sigjmp_buf = {{__jmpbuf = {93892289184024, 7948122722687377423, 4, 140733725107360, 140733725107504, 140733725107508, 4285555429689122831, 7948459353084780559}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93892293094992, 14336, 93892289178112, 93892293621904, 140733725107504, 93892276627677, 0, 9, 2, 93892289184032, 93892293094992, 93892289178112, 140733725107360, 140733725107504, 140733725107508}}}} [22:27:59.091] send_ready_for_query = false [22:27:59.091] idle_in_transaction_timeout_enabled = false [22:27:59.091] idle_session_timeout_enabled = false [22:27:59.091] __func__ = "PostgresMain" [22:27:59.091] #20 0x00005564ff9dd7ce in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:27:59.091] bsdata = [22:27:59.091] #21 0x00005564ff89516d in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff1fb1644c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff1fb164a0) at ../src/backend/postmaster/launch_backend.c:274 [22:27:59.091] pid = [22:27:59.091] #22 0x00005564ff89ac21 in BackendStartup (client_sock=client_sock@entry=0x7fff1fb164a0) at ../src/backend/postmaster/postmaster.c:3420 [22:27:59.091] bn = 0x556500ce5ca8 [22:27:59.091] pid = [22:27:59.091] startup_data = {canAcceptConnections = CAC_OK} [22:27:59.091] __func__ = "BackendStartup" [22:27:59.091] #23 0x00005564ff89b183 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [22:27:59.091] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\261\037\377\177\000\0004e\261\037\377\177", '\000' , "\306ϥ\376dU\000\000\220\267\241\376dU\000\000\000f\261\037\377\177\000\000\370e\261\037\377\177\000\000\225[\362\001\000\000\000\000\240\264\362ϒ\177\000\000+", '\000' , "\333Υ\376dU\000\000h\226HВ\177\000\0000\266\362ϒ\177\000", __ss_align = 140268536369888}, salen = 2}} [22:27:59.091] i = 0 [22:27:59.091] now = [22:27:59.091] last_lockfile_recheck_time = 1727562265 [22:27:59.091] last_touch_time = 1727562265 [22:27:59.091] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -22687802, events = 21860, fd = -800549272, user_data = 0x7f92cff2b630}, {pos = -800550176, events = 32658, fd = 2090263927, user_data = 0x7fff1fb16680}, {pos = -800720312, events = 32658, fd = 15, user_data = 0x7f92cff2b630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -800550176, events = 32658, fd = 531719672, user_data = 0x7fff1fb16600}, {pos = -800549272, events = 32658, fd = 0, user_data = 0x556500cb0ae8}, {pos = -3112531, events = 21860, fd = 32768, user_data = 0x1}, {pos = 13314192, events = 21861, fd = -1, user_data = 0x7f92cea2e020}, {pos = -805470304, events = 32658, fd = 13497352, user_data = 0x556500cdf2e8}, {pos = 13496513, events = 21861, fd = -800694594, user_data = 0x1}, {pos = -800550176, events = 32658, fd = 438, user_data = 0x556500213db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x556500cb0ae8}, {pos = -800694594, events = 32658, fd = 1, user_data = 0x0}, {pos = -828186592, events = 32658, fd = -827380288, user_data = 0x10}, {pos = 531720816, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -800685638, user_data = 0x0}, {pos = -827658972, events = 32658, fd = 0, user_data = 0x5565008a4aa0 }, {pos = 2, events = 0, fd = 7, user_data = 0x556500c72ef0}, {pos = -6849643, events = 21860, fd = 13514923, user_data = 0x5564ff97b7ce }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x556500cb0ae8}, {pos = -800694594, events = 32658, fd = 1, user_data = 0x0}, {pos = -828152632, events = 32658, fd = -827733888, user_data = 0x423}, {pos = -827625849, events = 32658, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -826336160, events = 32658, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = -3434144, events = 21860, fd = 13470432, user_data = 0x7f92ceab56eb}, {pos = -826353184, events = 32658, fd = -827715218, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x936ce55f582d9b00}, {pos = -826350112, events = 32658, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 13496744, user_data = 0x5564ffcba223 }, {pos = 13496544, events = 21861, fd = 3, user_data = 0x0}, {pos = 16759, events = 0, fd = -328, user_data = 0x0}, {pos = 13306600, events = 21861, fd = -827379757, user_data = 0x7fff1fb16b28}, {pos = -3350828, events = 21860, fd = 9126096, user_data = 0x5564ffcbc991 }, {pos = 13496544, events = 21861, fd = 13306320, user_data = 0x556500cdf0e0}, {pos = -827631893, events = 32658, fd = 0, user_data = 0x5564ffcce5fb }, {pos = 13496544, events = 1, fd = -3348668, user_data = 0x556500cb09d0}, {pos = 1479383808, events = 2473387359, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -827708751, user_data = 0x7f92ceaa14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1479383808, user_data = 0x556500c88100}, {pos = 1479383808, events = 2473387359, fd = 11, user_data = 0x936ce55f582d9b00}, {pos = 0, events = 0, fd = -828001735, user_data = 0x1}, {pos = -7778710, events = 21860, fd = 4194304, user_data = 0x5564ffcbc825 }, {pos = 13140224, events = 21861, fd = 13306320, user_data = 0x556500c88100}, {pos = 1, events = 0, fd = 0, user_data = 0x5564ffcce5fb }, {pos = 13140224, events = 21861, fd = -3348668, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5564ff6ca876 }, {pos = 0, events = 0, fd = -9634890, user_data = 0xb}, {pos = -7757553, events = 21860, fd = 5526640, user_data = 0x556500cb1378}} [22:27:59.091] nevents = 1 [22:27:59.091] __func__ = "ServerLoop" [22:27:59.091] #24 0x00005564ff89c906 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x556500c6ed60) at ../src/backend/postmaster/postmaster.c:1351 [22:27:59.091] opt = [22:27:59.091] status = [22:27:59.091] userDoption = [22:27:59.091] listen_addr_saved = false [22:27:59.091] output_config_variable = [22:27:59.091] __func__ = "PostmasterMain" [22:27:59.091] #25 0x00005564ff6dac52 in main (argc=4, argv=0x556500c6ed60) at ../src/backend/main/main.c:197 [22:27:59.091] do_check_root = [22:27:59.126] -e [22:27:59.126] [22:27:59.126] [22:27:59.185] dumping /tmp/cores/postgres-6-25253.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:27:59.437] [New LWP 25253] [22:27:59.437] [22:27:59.437] This GDB supports auto-downloading debuginfo from the following URLs: [22:27:59.437] [22:27:59.437] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:27:59.437] Debuginfod has been disabled. [22:27:59.437] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:27:59.537] [Thread debugging using libthread_db enabled] [22:27:59.537] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:27:59.537] Core was generated by `postgres: primary: postgres regression [local] MERGE '. [22:27:59.537] Program terminated with signal SIGABRT, Aborted. [22:27:59.537] #0 0x00007f9dd3ea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:28:00.434] [22:28:00.434] Thread 1 (Thread 0x7f9dd3dd5f00 (LWP 25253)): [22:28:00.434] #0 0x00007f9dd3ea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:28:00.434] No symbol table info available. [22:28:00.434] #1 0x00007f9dd3e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:28:00.434] No symbol table info available. [22:28:00.434] #2 0x00007f9dd3e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:28:00.434] No symbol table info available. [22:28:00.434] #3 0x000056115fde59b8 in ExceptionalCondition (conditionName=conditionName@entry=0x561160033f85 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x561160058790 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [22:28:00.434] No locals. [22:28:00.434] #4 0x000056115f78ee75 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffd0c035260, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffd0c0350ef) at ../src/backend/executor/execTuples.c:1737 [22:28:00.434] No locals. [22:28:00.434] #5 0x000056115f712800 in ExecIRDeleteTriggers (estate=estate@entry=0x5611615ebb90, relinfo=relinfo@entry=0x5611615ec140, slot=slot@entry=0x7ffd0c035260) at ../src/backend/commands/trigger.c:2842 [22:28:00.434] trigger = 0x5611615ec3a0 [22:28:00.434] oldtuple = [22:28:00.434] trigdesc = 0x5611615ec350 [22:28:00.434] newtuple = 0x0 [22:28:00.434] should_free = false [22:28:00.434] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f9dcf91a2d0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [22:28:00.434] i = 0 [22:28:00.434] #6 0x000056115f7ebeb9 in ExecMergeMatched (context=, resultRelInfo=resultRelInfo@entry=0x5611615ec140, tupleid=0x0, oldtuple=0x7ffd0c035260, canSetTag=true, matched=matched@entry=0x7ffd0c0351ff) at ../src/backend/executor/nodeModifyTable.c:3082 [22:28:00.434] relaction = 0x561161745940 [22:28:00.434] commandType = CMD_DELETE [22:28:00.434] result = TM_Ok [22:28:00.434] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [22:28:00.434] l__state = [22:28:00.434] mtstate = 0x5611615ebf30 [22:28:00.434] mergeActions = 0x5611615ec250 [22:28:00.434] lockedtid = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0} [22:28:00.434] actionStates = 0x561161745f00 [22:28:00.434] newslot = 0x0 [22:28:00.434] rslot = 0x0 [22:28:00.434] estate = 0x5611615ebb90 [22:28:00.434] econtext = 0x561161744f50 [22:28:00.434] isNull = false [22:28:00.434] epqstate = 0x5611615ec018 [22:28:00.434] l = [22:28:00.434] __func__ = "ExecMergeMatched" [22:28:00.434] lmerge_matched = [22:28:00.434] #7 0x000056115f7ecad6 in ExecMerge (context=context@entry=0x7ffd0c035280, resultRelInfo=resultRelInfo@entry=0x5611615ec140, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffd0c035260, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [22:28:00.434] rslot = 0x0 [22:28:00.434] matched = true [22:28:00.434] #8 0x000056115f7ee29b in ExecModifyTable (pstate=0x5611615ebf30) at ../src/backend/executor/nodeModifyTable.c:4197 [22:28:00.434] node = 0x5611615ebf30 [22:28:00.434] context = {mtstate = 0x5611615ebf30, epqstate = 0x5611615ec018, estate = 0x5611615ebb90, planSlot = 0x561161743338, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 3483322064, cmax = 32669, traversed = 8}, cpUpdateReturningSlot = 0x5611615ec018} [22:28:00.434] estate = 0x5611615ebb90 [22:28:00.434] operation = CMD_MERGE [22:28:00.434] resultRelInfo = 0x5611615ec140 [22:28:00.434] subplanstate = 0x5611615ec870 [22:28:00.434] slot = [22:28:00.434] oldSlot = [22:28:00.434] tuple_ctid = {ip_blkid = {bi_hi = 24446, bi_lo = 22033}, ip_posid = 0} [22:28:00.434] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x5611616fe2b8} [22:28:00.434] oldtuple = 0x7ffd0c035260 [22:28:00.434] tupleid = 0x0 [22:28:00.434] tuplock = [22:28:00.434] __func__ = "ExecModifyTable" [22:28:00.434] #9 0x000056115f781399 in ExecProcNodeFirst (node=0x5611615ebf30) at ../src/backend/executor/execProcnode.c:469 [22:28:00.434] No locals. [22:28:00.434] #10 0x000056115f76c6fb in ExecProcNode (node=node@entry=0x5611615ebf30) at ../src/include/executor/executor.h:278 [22:28:00.434] No locals. [22:28:00.434] #11 0x000056115f76c8b0 in ExecutePlan (estate=estate@entry=0x5611615ebb90, planstate=0x5611615ebf30, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x561161720010, execute_once=true) at ../src/backend/executor/execMain.c:1659 [22:28:00.434] slot = [22:28:00.434] current_tuple_count = 0 [22:28:00.434] #12 0x000056115f76e66b in standard_ExecutorRun (queryDesc=queryDesc@entry=0x5611617c16a8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:364 [22:28:00.434] estate = 0x5611615ebb90 [22:28:00.434] operation = CMD_MERGE [22:28:00.434] dest = 0x561161720010 [22:28:00.434] sendTuples = [22:28:00.434] oldcontext = 0x56116171fd00 [22:28:00.434] __func__ = "standard_ExecutorRun" [22:28:00.434] #13 0x00007f9dd1e28813 in pgss_ExecutorRun (queryDesc=0x5611617c16a8, direction=ForwardScanDirection, count=0, execute_once=) at ../contrib/pg_stat_statements/pg_stat_statements.c:1024 [22:28:00.434] _save_exception_stack = 0x7ffd0c035680 [22:28:00.434] _save_context_stack = 0x0 [22:28:00.434] _local_sigjmp_buf = {{__jmpbuf = {94632649954984, 2468117043392084457, 0, 1, 0, 0, -2469490637148587543, -2487358519688234519}, __mask_was_saved = 0, __saved_mask = {__val = {6, 94632649483272, 400, 0, 2147483647, 94632649293840, 0, 0, 94632623206212, 0, 1, 0, 94632616239864, 94632649954984, 94632635674912, 94632649293056}}}} [22:28:00.434] _do_rethrow = false [22:28:00.434] #14 0x000056115f76e8b4 in ExecutorRun (queryDesc=queryDesc@entry=0x5611617c16a8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:303 [22:28:00.434] No locals. [22:28:00.434] #15 0x000056115fb5837e in ProcessQuery (plan=plan@entry=0x561161751310, sourceText=0x561161598af0 "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"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x561161720010, qc=qc@entry=0x7ffd0c0355e0) at ../src/backend/tcop/pquery.c:160 [22:28:00.434] queryDesc = 0x5611617c16a8 [22:28:00.434] #16 0x000056115fb59fb3 in PortalRunMulti (portal=portal@entry=0x56116161a030, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x561161720010, altdest=0x561160362ee0 , qc=qc@entry=0x7ffd0c0355e0) at ../src/backend/tcop/pquery.c:1278 [22:28:00.434] pstmt = 0x561161751310 [22:28:00.434] stmtlist_item__state = [22:28:00.434] active_snapshot_set = true [22:28:00.434] stmtlist_item = 0x561161751438 [22:28:00.434] #17 0x000056115fb5a505 in FillPortalStore (portal=portal@entry=0x56116161a030, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [22:28:00.434] treceiver = 0x561161720010 [22:28:00.434] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:28:00.434] __func__ = "FillPortalStore" [22:28:00.434] #18 0x000056115fb5aad6 in PortalRun (portal=portal@entry=0x56116161a030, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x561161751470, altdest=altdest@entry=0x561161751470, qc=0x7ffd0c0357c0) at ../src/backend/tcop/pquery.c:763 [22:28:00.434] _save_exception_stack = 0x7ffd0c035870 [22:28:00.434] _save_context_stack = 0x0 [22:28:00.434] _local_sigjmp_buf = {{__jmpbuf = {0, -8186908922740016663, 94632648220720, 94632649356096, 94632648220720, 94632649356024, -2469490636968232471, -8186914975930451479}, __mask_was_saved = 0, __saved_mask = {__val = {94632623114592, 94632647690736, 112, 4, 94632623119009, 201545551, 4, 94632649356024, 112, 163, 94632648220720, 94632649356096, 94632649356072, 94632649356024, 94632623206212, 1}}}} [22:28:00.434] _do_rethrow = [22:28:00.434] result = [22:28:00.434] nprocessed = [22:28:00.434] saveTopTransactionResourceOwner = 0x5611615d9508 [22:28:00.434] saveTopTransactionContext = 0x56116162c460 [22:28:00.434] saveActivePortal = 0x0 [22:28:00.434] saveResourceOwner = 0x5611615d9508 [22:28:00.434] savePortalContext = 0x0 [22:28:00.434] saveMemoryContext = 0x56116162c460 [22:28:00.434] __func__ = "PortalRun" [22:28:00.434] #19 0x000056115fb53bd3 in exec_simple_query (query_string=query_string@entry=0x561161598af0 "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 [22:28:00.434] cmdtaglen = 5 [22:28:00.434] snapshot_set = [22:28:00.434] per_parsetree_context = 0x0 [22:28:00.434] plantree_list = 0x561161751420 [22:28:00.434] parsetree = 0x56116172f2f8 [22:28:00.434] commandTag = [22:28:00.434] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:28:00.434] querytree_list = [22:28:00.434] portal = 0x56116161a030 [22:28:00.434] receiver = 0x561161751470 [22:28:00.434] format = 0 [22:28:00.434] cmdtagname = [22:28:00.434] parsetree_item__state = [22:28:00.434] dest = DestRemote [22:28:00.434] oldcontext = 0x56116162c460 [22:28:00.434] parsetree_list = 0x56116172f328 [22:28:00.434] parsetree_item = 0x56116172f340 [22:28:00.434] save_log_statement_stats = false [22:28:00.434] was_logged = true [22:28:00.434] use_implicit_block = false [22:28:00.434] msec_str = " Z\003\f\375\177\000\000f\267\340_\021V\000\000PX\003\f\375\177\000\000\026\001\000\000\000\000\000" [22:28:00.434] __func__ = "exec_simple_query" [22:28:00.434] #20 0x000056115fb56957 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [22:28:00.434] query_string = 0x561161598af0 "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"... [22:28:00.434] firstchar = [22:28:00.434] input_message = {data = 0x561161598af0 "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} [22:28:00.434] local_sigjmp_buf = {{__jmpbuf = {94632635674904, -8186908485901157911, 4, 140724804999712, 140724804999856, 140724804999860, -2469490637442188823, -8186914973973677591}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94632647940576, 0, 168, 94632623119111, 0, 10, 2, 94632635674912, 94632647421584, 94632635668992, 140724804999712, 140724804999856, 140724804999860}}}} [22:28:00.434] send_ready_for_query = false [22:28:00.434] idle_in_transaction_timeout_enabled = false [22:28:00.434] idle_session_timeout_enabled = false [22:28:00.434] __func__ = "PostgresMain" [22:28:00.434] #21 0x000056115fb4c7ce in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:28:00.434] bsdata = [22:28:00.434] #22 0x000056115fa0416d in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd0c0359cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd0c035a20) at ../src/backend/postmaster/launch_backend.c:274 [22:28:00.434] pid = [22:28:00.434] #23 0x000056115fa09c21 in BackendStartup (client_sock=client_sock@entry=0x7ffd0c035a20) at ../src/backend/postmaster/postmaster.c:3420 [22:28:00.434] bn = 0x5611615c51a8 [22:28:00.434] pid = [22:28:00.434] startup_data = {canAcceptConnections = CAC_OK} [22:28:00.434] __func__ = "BackendStartup" [22:28:00.434] #24 0x000056115fa0a183 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [22:28:00.434] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\003\f\375\177\000\000\264Z\003\f\375\177", '\000' , "ƿ\274^\021V\000\000\220\247\270^\021V\000\000\200[\003\f\375\177\000\000x[\003\f\375\177\000\000\225[\362\001\000\000\000\000\020+\\a\021V\000\000,", '\000' , "۾\274^\021V\000\000hv|՝\177\000\0000fcԝ\177\000", __ss_align = 140315868295904}, salen = 2}} [22:28:00.434] i = 0 [22:28:00.434] now = [22:28:00.434] last_lockfile_recheck_time = 1727562292 [22:28:00.434] last_touch_time = 1727562292 [22:28:00.434] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1589428166, events = 22033, fd = -713263512, user_data = 0x7f9dd4636630}, {pos = -713264416, events = 32669, fd = 2090263927, user_data = 0x7ffd0c035c00}, {pos = -713434552, events = 32669, fd = 15, user_data = 0x7f9dd4636630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -713264416, events = 32669, fd = 201546616, user_data = 0x7ffd0c035b80}, {pos = -713263512, events = 32669, fd = 0, user_data = 0x56116159a930}, {pos = 1609003437, events = 22033, fd = 32768, user_data = 0x1}, {pos = 1633261072, events = 22033, fd = -1, user_data = 0x7f9dd3e2e020}, {pos = -717492320, events = 32669, fd = 1633436584, user_data = 0x5611615c4288}, {pos = 1633454385, events = 22033, fd = -713408834, user_data = 0x1}, {pos = -713264416, events = 32669, fd = 438, user_data = 0x561160382db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x56116159a930}, {pos = -713408834, events = 32669, fd = 1, user_data = 0x0}, {pos = -740106208, events = 32669, fd = -739299904, user_data = 0x10}, {pos = 201547760, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -713399878, user_data = 0x0}, {pos = -739578588, events = 32669, fd = 0, user_data = 0x561160a13aa0 }, {pos = 2, events = 0, fd = 7, user_data = 0x56116155af30}, {pos = 1605266325, events = 22033, fd = 1633475067, user_data = 0x56115faea7ce }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x56116159a930}, {pos = -713408834, events = 32669, fd = 1, user_data = 0x0}, {pos = -740072248, events = 32669, fd = -739653504, user_data = 0x423}, {pos = -739545107, events = 32669, fd = 2, user_data = 0x5611615cd9a0}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -738255776, events = 32669, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa36}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -731679424, user_data = 0x7f9dd4637a80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1608681824, events = 22033, fd = 1633450288, user_data = 0x7f9dd3eb583e}, {pos = -738272800, events = 32669, fd = -739634834, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xd3200640ce327700}, {pos = -738269728, events = 32669, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1633435976, user_data = 0x56115fe29223 }, {pos = 1633435776, events = 22033, fd = 3, user_data = 0x0}, {pos = 23352, events = 0, fd = -328, user_data = 0x0}, {pos = 1633265968, events = 22033, fd = -739299373, user_data = 0x7ffd0c0360a8}, {pos = 1608765140, events = 22033, fd = 1621242064, user_data = 0x56115fe2b991 }, {pos = 1633435776, events = 22033, fd = 1633257968, user_data = 0x5611615c4080}, {pos = -739551170, events = 32669, fd = 0, user_data = 0x56115fe3d5fb }, {pos = 1633435776, events = 1, fd = 1608767300, user_data = 0x5611615989f0}, {pos = -835553536, events = 3542091328, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -739628367, user_data = 0x7f9dd3ea14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -835553536, user_data = 0x561161570120}, {pos = -835553536, events = 3542091328, fd = 11, user_data = 0xd3200640ce327700}, {pos = 0, events = 0, fd = -739921351, user_data = 0x1}, {pos = 1604337258, events = 22033, fd = 4194304, user_data = 0x56115fe2b825 }, {pos = 1633091872, events = 22033, fd = 1633257968, user_data = 0x561161570120}, {pos = 1, events = 0, fd = 0, user_data = 0x56115fe3d5fb }, {pos = 1633091872, events = 22033, fd = 1608767300, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x56115f839876 }, {pos = 0, events = 0, fd = 1602481078, user_data = 0xb}, {pos = 1604358415, events = 22033, fd = 1617642608, user_data = 0x5611615993a8}} [22:28:00.434] nevents = 1 [22:28:00.434] __func__ = "ServerLoop" [22:28:00.434] #25 0x000056115fa0b906 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x561161556d90) at ../src/backend/postmaster/postmaster.c:1351 [22:28:00.434] opt = [22:28:00.434] status = [22:28:00.434] userDoption = [22:28:00.434] listen_addr_saved = false [22:28:00.434] output_config_variable = [22:28:00.434] __func__ = "PostmasterMain" [22:28:00.434] #26 0x000056115f849c52 in main (argc=4, argv=0x561161556d90) at ../src/backend/main/main.c:197 [22:28:00.434] do_check_root =