[15:27:43.458] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [15:27:43.829] dumping /tmp/cores/postgres.8069.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:27:43.964] [New LWP 101702] [15:27:44.063] Core was generated by `postgres: postgres regression [local] MERGE'. [15:27:44.063] Program terminated with signal SIGABRT, Aborted. [15:27:44.063] Sent by thr_kill() from pid 8069 and user 1003. [15:27:44.063] #0 0x000000082c48741a in thr_kill () from /lib/libc.so.7 [15:27:44.670] [15:27:44.670] Thread 1 (LWP 101702): [15:27:44.670] #0 0x000000082c48741a in thr_kill () from /lib/libc.so.7 [15:27:44.670] No symbol table info available. [15:27:44.670] #1 0x000000082c400e64 in raise () from /lib/libc.so.7 [15:27:44.670] No symbol table info available. [15:27:44.670] #2 0x000000082c4b16f9 in abort () from /lib/libc.so.7 [15:27:44.670] No symbol table info available. [15:27:44.670] #3 0x0000000000a5dff5 in ExceptionalCondition (conditionName=0x2d0bb3 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:27:44.670] No locals. [15:27:44.670] #4 0x00000000007402bf in ExecFetchSlotHeapTuple (slot=0x820d88470, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [15:27:44.670] No locals. [15:27:44.670] #5 0x0000000000704f77 in ExecIRDeleteTriggers (estate=estate@entry=0x838360100, relinfo=relinfo@entry=0x8383606b0, slot=slot@entry=0x820d88470) at ../src/backend/commands/trigger.c:2841 [15:27:44.670] trigger = [15:27:44.670] oldtuple = [15:27:44.670] should_free = false [15:27:44.670] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x838392060, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:27:44.670] trigdesc = 0x8383608c0 [15:27:44.670] newtuple = 0x0 [15:27:44.670] i = 0 [15:27:44.670] #6 0x0000000000765497 in ExecMergeMatched (context=0x820d88518, resultRelInfo=0x8383606b0, tupleid=0x0, oldtuple=0x820d88470, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [15:27:44.670] result = TM_Ok [15:27:44.670] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:27:44.670] relaction = 0x8384da278 [15:27:44.670] commandType = CMD_DELETE [15:27:44.670] l__state = {l = 0x8384da838, i = 0} [15:27:44.670] mtstate = 0x8383604a0 [15:27:44.670] newslot = 0x0 [15:27:44.670] rslot = 0x0 [15:27:44.670] estate = 0x838360100 [15:27:44.670] mergeActions = [15:27:44.670] econtext = 0x8384d98a8 [15:27:44.670] epqstate = 0x838360588 [15:27:44.670] actionStates = 0x8384da838 [15:27:44.670] l = [15:27:44.670] isNull = [15:27:44.670] lmerge_matched = [15:27:44.670] __error = [15:27:44.670] l__state = [15:27:44.670] result = [15:27:44.670] updateCxt = [15:27:44.670] relaction = [15:27:44.670] commandType = [15:27:44.670] __error = [15:27:44.670] resultRelationDesc = [15:27:44.670] lockmode = [15:27:44.670] inputslot = [15:27:44.670] epqslot = [15:27:44.670] was_matched = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] #7 ExecMerge (context=0x820d88518, resultRelInfo=0x8383606b0, tupleid=0x0, oldtuple=0x820d88470, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [15:27:44.670] matched = [15:27:44.670] rslot = 0x0 [15:27:44.670] #8 ExecModifyTable (pstate=0x8383604a0) at ../src/backend/executor/nodeModifyTable.c:4133 [15:27:44.670] context = {mtstate = 0x8383604a0, epqstate = 0x838360588, estate = 0x838360100, planSlot = 0x83845e270, tmfd = {ctid = {ip_blkid = {bi_hi = 20216, bi_lo = 14416}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8383606b0} [15:27:44.670] tuple_ctid = {ip_blkid = {bi_hi = 51920, bi_lo = 14666}, ip_posid = 8} [15:27:44.670] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8383b5118} [15:27:44.670] node = 0x8383604a0 [15:27:44.670] estate = 0x838360100 [15:27:44.670] operation = CMD_MERGE [15:27:44.670] resultRelInfo = 0x8383606b0 [15:27:44.670] subplanstate = 0x838361df0 [15:27:44.670] slot = [15:27:44.670] tupleid = 0x0 [15:27:44.670] oldtuple = 0x820d88470 [15:27:44.670] oldSlot = [15:27:44.670] #9 0x000000000073252b in ExecProcNode (node=0x8383604a0) at ../src/include/executor/executor.h:278 [15:27:44.670] No locals. [15:27:44.670] #10 ExecutePlan (estate=0x838360100, planstate=0x8383604a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x836abcb10, execute_once=) at ../src/backend/executor/execMain.c:1641 [15:27:44.670] current_tuple_count = 0 [15:27:44.670] slot = [15:27:44.670] #11 standard_ExecutorRun (queryDesc=0x83696fc48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [15:27:44.670] estate = 0x838360100 [15:27:44.670] oldcontext = 0x836abc800 [15:27:44.670] operation = CMD_MERGE [15:27:44.670] dest = 0x836abcb10 [15:27:44.670] sendTuples = true [15:27:44.670] #12 0x000000000090958f in ProcessQuery (plan=0x8385047e0, sourceText=, params=0x0, queryEnv=0x0, dest=0x836abcb10, qc=0x820d88718) at ../src/backend/tcop/pquery.c:160 [15:27:44.670] queryDesc = 0x83696fc48 [15:27:44.670] #13 0x0000000000908b2d in PortalRunMulti (portal=portal@entry=0x8369ee100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x836abcb10, altdest=0xb4fda0 , qc=qc@entry=0x820d88718) at ../src/backend/tcop/pquery.c:1287 [15:27:44.670] pstmt = 0x8385047e0 [15:27:44.670] stmtlist_item__state = {l = 0x838509098, i = 0} [15:27:44.670] active_snapshot_set = true [15:27:44.670] stmtlist_item = 0x8385090b0 [15:27:44.670] #14 0x000000000090863c in FillPortalStore (portal=portal@entry=0x8369ee100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:27:44.670] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:27:44.670] treceiver = 0x836abcb10 [15:27:44.670] #15 0x00000000009083ab in PortalRun (portal=portal@entry=0x8369ee100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8385090e8, altdest=altdest@entry=0x8385090e8, qc=0x820d88850) at ../src/backend/tcop/pquery.c:763 [15:27:44.670] _local_sigjmp_buf = {{_sjb = {9470797, 35276120320, 34910799688, 34910799920, 34910799696, 35276140544, 12127288, 12160552, 35276129151, 35275247872, 4294967984, 0}}} [15:27:44.670] _save_exception_stack = 0x820d88920 [15:27:44.670] _save_context_stack = 0x0 [15:27:44.670] _do_rethrow = false [15:27:44.670] saveTopTransactionResourceOwner = 0x836a005d8 [15:27:44.670] saveTopTransactionContext = 0x8369f3000 [15:27:44.670] saveActivePortal = 0x0 [15:27:44.670] saveResourceOwner = 0x836a005d8 [15:27:44.670] savePortalContext = 0x0 [15:27:44.670] saveMemoryContext = 0x8369f3000 [15:27:44.670] result = [15:27:44.670] nprocessed = [15:27:44.670] #16 0x0000000000907272 in exec_simple_query (query_string=query_string@entry=0x836919100 "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 [15:27:44.670] cmdtaglen = 5 [15:27:44.670] snapshot_set = [15:27:44.670] per_parsetree_context = 0x0 [15:27:44.670] plantree_list = [15:27:44.670] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:27:44.670] format = 0 [15:27:44.670] parsetree = 0x8384a77a8 [15:27:44.670] commandTag = [15:27:44.670] cmdtagname = [15:27:44.670] querytree_list = [15:27:44.670] portal = 0x8369ee100 [15:27:44.670] receiver = 0x8385090e8 [15:27:44.670] parsetree_item__state = {l = 0x8384a9070, i = 0} [15:27:44.670] msec_str = "\000\000\000\000\b", '\000' , "z\006\306f\000\000\000\0000=}}$ޏO" [15:27:44.670] dest = DestRemote [15:27:44.670] was_logged = [15:27:44.670] oldcontext = 0x8369f3000 [15:27:44.670] parsetree_list = 0x8384a9070 [15:27:44.670] use_implicit_block = false [15:27:44.670] parsetree_item = 0x8384a9088 [15:27:44.670] save_log_statement_stats = [15:27:44.670] #17 0x0000000000904fe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [15:27:44.670] query_string = 0x836919100 "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"... [15:27:44.670] input_message = {data = 0x836919100 "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} [15:27:44.670] firstchar = [15:27:44.670] local_sigjmp_buf = {{_sjb = {9454710, 34910800160, 34910800120, 34910800704, 12169288, 1, 8192, 8388608, 34910765951, 0, 0, 1}}} [15:27:44.670] send_ready_for_query = false [15:27:44.670] idle_in_transaction_timeout_enabled = false [15:27:44.670] idle_session_timeout_enabled = false [15:27:44.670] #18 0x00000000008ff7b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:27:44.670] bsdata = [15:27:44.670] #19 0x00000000008599d7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d89664 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d895a0) at ../src/backend/postmaster/launch_backend.c:274 [15:27:44.670] pid = [15:27:44.670] #20 0x000000000085dd98 in BackendStartup (client_sock=0x820d895a0) at ../src/backend/postmaster/postmaster.c:3414 [15:27:44.670] startup_data = {canAcceptConnections = CAC_OK} [15:27:44.670] bn = 0x836925088 [15:27:44.670] pid = [15:27:44.670] __error = [15:27:44.670] save_errno = [15:27:44.670] __error = [15:27:44.670] __error = [15:27:44.670] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:27:44.670] 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\257\2216\b", '\000' , "\226\330 \b\000\000\000h5]*\b\000\000\000\v\000\000\000\000\000\000\000^\277]*\b", '\000' , "@\226\330 \b\000\000\000\204\227\205\000\000\000\000\000P\226\330 \b", '\000' }, salen = 16}} [15:27:44.670] i = 0 [15:27:44.670] now = [15:27:44.670] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 742571138, events = 8, fd = 0, user_data = 0x820d89550}, {pos = 915908056, events = 8, fd = 551064544, user_data = 0x0}, {pos = 0, events = 0, fd = 558578236, user_data = 0x71329d9c30a}, {pos = 741738400, events = 8, fd = 741809528, user_data = 0x820d89068}, {pos = 551063776, events = 8, fd = 551063656, user_data = 0x71329d9c30a}, {pos = 741716872, events = 8, fd = 741809528, user_data = 0x820d89098}, {pos = 551063824, events = 8, fd = 551063704, user_data = 0x82c36a194}, {pos = 557909000, events = 8, fd = 741777812, user_data = 0x820d89100}, {pos = 702116922, events = 1811, fd = 743600176, user_data = 0x1}, {pos = 551063856, events = 8, fd = 702137098, user_data = 0x82c353858}, {pos = 741809528, events = 8, fd = 551063816, user_data = 0x820d89180}, {pos = 551063816, events = 8, fd = 741772556, user_data = 0x821410408}, {pos = 741772556, events = 8, fd = 551063920, user_data = 0x71329d9743a}, {pos = 551063960, events = 8, fd = 551064408, user_data = 0x820d89180}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1997182213, fd = 557932600, user_data = 0x800000001}, {pos = 557909000, events = 8, fd = 741716872, user_data = 0x821415288}, {pos = 741685336, events = 8, fd = 557909000, user_data = 0x820d89208}, {pos = 551064520, events = 8, fd = 551064048, user_data = 0x71329d9bca2}, {pos = 2699959, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 557932600, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 551064776, user_data = 0x21410408}, {pos = 551064592, events = 8, fd = 551064192, user_data = 0x1}, {pos = 551064520, events = 8, fd = 32, user_data = 0x820d89270}, {pos = 702134899, events = 1811, fd = 551064464, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821416038}, {pos = 1, events = 8, fd = 557909000, user_data = 0x82c353858}, {pos = 551064776, events = 8, fd = 551064592, user_data = 0x820d89280}, {pos = 0, events = 0, fd = 557879304, user_data = 0x20}, {pos = 551064576, events = 8, fd = 702110439, user_data = 0x821409008}, {pos = 557880328, events = 8, fd = 557881352, user_data = 0x821409c08}, {pos = 557895688, events = 8, fd = 557896712, user_data = 0x82140d808}, {pos = 557898760, events = 8, fd = 557899784, user_data = 0x82140e408}, {pos = 557901832, events = 8, fd = 557902856, user_data = 0x82140f008}, {pos = 557904904, events = 8, fd = 557905928, user_data = 0x82140fc08}, {pos = 557907976, events = 8, fd = 557909000, user_data = 0x821410808}, {pos = 557911048, events = 8, fd = 557912072, user_data = 0x821411408}, {pos = 557914120, events = 8, fd = 557915144, user_data = 0x821412008}, {pos = 557917192, events = 8, fd = 557918216, user_data = 0x821412c08}, {pos = 557924360, events = 8, fd = 557925384, user_data = 0x821414808}, {pos = 557927432, events = 8, fd = 557879304, user_data = 0x2932b7}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821416038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551064776, events = 8, fd = 551064192, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 557932600, user_data = 0x1}, {pos = 557879304, events = 8, fd = 314, user_data = 0x820d894b0}, {pos = 702109167, events = 1811, fd = 2699959, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557932600, user_data = 0x1}, {pos = 557909000, events = 8, fd = 915443712, user_data = 0x1}, {pos = 915444116, events = 8, fd = 0, user_data = 0x820d89480}, {pos = 710784364, events = 8, fd = 1, user_data = 0x836909000}, {pos = 551064752, events = 8, fd = 710780674, user_data = 0x82c485170 }, {pos = 12094376, events = 0, fd = 742936944, user_data = 0x821410408}, {pos = 551064976, events = 8, fd = 702108638, user_data = 0x836927800}, {pos = 1, events = 8, fd = 702108254, user_data = 0x821409008}, {pos = 551064760, events = 8, fd = 551064976, user_data = 0x1c38}, {pos = 915517184, events = 8, fd = 702187920, user_data = 0x0}, {pos = 551027583, events = 8, fd = 7899047, user_data = 0x820d89540}, {pos = 710743056, events = 8, fd = 743600176, user_data = 0x82c529310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d89570}, {pos = 710785949, events = 8, fd = 915443712, user_data = 0x1793}, {pos = 551065040, events = 8, fd = 710752506, user_data = 0x0}, {pos = 0, events = 0, fd = 558578236, user_data = 0x0}} [15:27:44.670] last_touch_time = 1724253807 [15:27:44.670] last_lockfile_recheck_time = 1724253807 [15:27:44.670] nevents = 1 [15:27:44.670] #22 0x000000000085bbb5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d89bb0) at ../src/backend/postmaster/postmaster.c:1346 [15:27:44.670] userDoption = [15:27:44.670] listen_addr_saved = [15:27:44.670] output_config_variable = [15:27:44.670] opt = [15:27:44.670] status = [15:27:44.670] #23 0x00000000007954ac in main (argc=8, argv=0x820d89bb0) at ../src/backend/main/main.c:197 [15:27:44.670] do_check_root = [15:27:44.682] [15:27:44.682] [15:27:44.682] [15:27:44.748] dumping /tmp/cores/postgres.8206.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:27:44.875] [New LWP 101745] [15:27:44.945] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [15:27:44.945] Program terminated with signal SIGABRT, Aborted. [15:27:44.945] Sent by thr_kill() from pid 8206 and user 1003. [15:27:44.945] #0 0x000000082abe741a in thr_kill () from /lib/libc.so.7 [15:27:45.523] [15:27:45.523] Thread 1 (LWP 101745): [15:27:45.523] #0 0x000000082abe741a in thr_kill () from /lib/libc.so.7 [15:27:45.523] No symbol table info available. [15:27:45.523] #1 0x000000082ab60e64 in raise () from /lib/libc.so.7 [15:27:45.523] No symbol table info available. [15:27:45.523] #2 0x000000082ac116f9 in abort () from /lib/libc.so.7 [15:27:45.523] No symbol table info available. [15:27:45.523] #3 0x0000000000a5dff5 in ExceptionalCondition (conditionName=0x2d0bb3 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:27:45.523] No locals. [15:27:45.523] #4 0x00000000007402bf in ExecFetchSlotHeapTuple (slot=0x82147afc0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [15:27:45.523] No locals. [15:27:45.523] #5 0x0000000000704f77 in ExecIRDeleteTriggers (estate=estate@entry=0x835395100, relinfo=relinfo@entry=0x8353956b0, slot=slot@entry=0x82147afc0) at ../src/backend/commands/trigger.c:2841 [15:27:45.523] trigger = [15:27:45.523] oldtuple = [15:27:45.523] should_free = false [15:27:45.523] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84470f128, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:27:45.523] trigdesc = 0x8353958c0 [15:27:45.523] newtuple = 0x0 [15:27:45.523] i = 0 [15:27:45.523] #6 0x0000000000765497 in ExecMergeMatched (context=0x82147b068, resultRelInfo=0x8353956b0, tupleid=0x0, oldtuple=0x82147afc0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [15:27:45.523] result = TM_Ok [15:27:45.523] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:27:45.523] relaction = 0x8425f6638 [15:27:45.523] commandType = CMD_DELETE [15:27:45.523] l__state = {l = 0x8425f6bf8, i = 0} [15:27:45.523] mtstate = 0x8353954a0 [15:27:45.523] newslot = 0x0 [15:27:45.523] rslot = 0x0 [15:27:45.523] estate = 0x835395100 [15:27:45.523] mergeActions = [15:27:45.523] econtext = 0x8425f5c68 [15:27:45.523] epqstate = 0x835395588 [15:27:45.523] actionStates = 0x8425f6bf8 [15:27:45.523] l = [15:27:45.523] isNull = [15:27:45.523] lmerge_matched = [15:27:45.523] __error = [15:27:45.523] l__state = [15:27:45.523] result = [15:27:45.523] updateCxt = [15:27:45.523] relaction = [15:27:45.523] commandType = [15:27:45.523] __error = [15:27:45.523] resultRelationDesc = [15:27:45.523] lockmode = [15:27:45.523] inputslot = [15:27:45.523] epqslot = [15:27:45.523] was_matched = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] #7 ExecMerge (context=0x82147b068, resultRelInfo=0x8353956b0, tupleid=0x0, oldtuple=0x82147afc0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [15:27:45.523] matched = [15:27:45.523] rslot = 0x0 [15:27:45.523] #8 ExecModifyTable (pstate=0x8353954a0) at ../src/backend/executor/nodeModifyTable.c:4133 [15:27:45.523] context = {mtstate = 0x8353954a0, epqstate = 0x835395588, estate = 0x835395100, planSlot = 0x84250e6f0, tmfd = {ctid = {ip_blkid = {bi_hi = 17272, bi_lo = 16994}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8353956b0} [15:27:45.523] tuple_ctid = {ip_blkid = {bi_hi = 52576, bi_lo = 17521}, ip_posid = 8} [15:27:45.523] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8353a9118} [15:27:45.523] node = 0x8353954a0 [15:27:45.523] estate = 0x835395100 [15:27:45.523] operation = CMD_MERGE [15:27:45.523] resultRelInfo = 0x8353956b0 [15:27:45.523] subplanstate = 0x835396df0 [15:27:45.523] slot = [15:27:45.523] tupleid = 0x0 [15:27:45.523] oldtuple = 0x82147afc0 [15:27:45.523] oldSlot = [15:27:45.523] #9 0x000000000073252b in ExecProcNode (node=0x8353954a0) at ../src/include/executor/executor.h:278 [15:27:45.523] No locals. [15:27:45.523] #10 ExecutePlan (estate=0x835395100, planstate=0x8353954a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x83522b310, execute_once=) at ../src/backend/executor/execMain.c:1641 [15:27:45.523] current_tuple_count = 0 [15:27:45.523] slot = [15:27:45.523] #11 standard_ExecutorRun (queryDesc=0x83524e448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [15:27:45.523] estate = 0x835395100 [15:27:45.523] oldcontext = 0x83522b000 [15:27:45.523] operation = CMD_MERGE [15:27:45.523] dest = 0x83522b310 [15:27:45.523] sendTuples = true [15:27:45.523] #12 0x000000000090958f in ProcessQuery (plan=0x842623c60, sourceText=, params=0x0, queryEnv=0x0, dest=0x83522b310, qc=0x82147b268) at ../src/backend/tcop/pquery.c:160 [15:27:45.523] queryDesc = 0x83524e448 [15:27:45.523] #13 0x0000000000908b2d in PortalRunMulti (portal=portal@entry=0x835295100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x83522b310, altdest=0xb4fda0 , qc=qc@entry=0x82147b268) at ../src/backend/tcop/pquery.c:1287 [15:27:45.523] pstmt = 0x842623c60 [15:27:45.523] stmtlist_item__state = {l = 0x842628518, i = 0} [15:27:45.523] active_snapshot_set = true [15:27:45.523] stmtlist_item = 0x842628530 [15:27:45.523] #14 0x000000000090863c in FillPortalStore (portal=portal@entry=0x835295100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:27:45.523] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:27:45.523] treceiver = 0x83522b310 [15:27:45.523] #15 0x00000000009083ab in PortalRun (portal=portal@entry=0x835295100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x842628568, altdest=altdest@entry=0x842628568, qc=0x82147b3a0) at ../src/backend/tcop/pquery.c:763 [15:27:45.523] _local_sigjmp_buf = {{_sjb = {9470797, 35251638528, 34918085272, 34918085504, 34918085280, 35251654656, 12127288, 12160552, 35251618687, 35250966784, 4294967984, 0}}} [15:27:45.523] _save_exception_stack = 0x82147b470 [15:27:45.523] _save_context_stack = 0x0 [15:27:45.523] _do_rethrow = false [15:27:45.523] saveTopTransactionResourceOwner = 0x8352dc398 [15:27:45.523] saveTopTransactionContext = 0x835299000 [15:27:45.523] saveActivePortal = 0x0 [15:27:45.523] saveResourceOwner = 0x8352dc398 [15:27:45.523] savePortalContext = 0x0 [15:27:45.523] saveMemoryContext = 0x835299000 [15:27:45.523] result = [15:27:45.523] nprocessed = [15:27:45.523] #16 0x0000000000907272 in exec_simple_query (query_string=query_string@entry=0x8351f1100 "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 [15:27:45.523] cmdtaglen = 5 [15:27:45.523] snapshot_set = [15:27:45.523] per_parsetree_context = 0x0 [15:27:45.523] plantree_list = [15:27:45.523] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:27:45.523] format = 0 [15:27:45.523] parsetree = 0x8425c3f28 [15:27:45.523] commandTag = [15:27:45.523] cmdtagname = [15:27:45.523] querytree_list = [15:27:45.523] portal = 0x835295100 [15:27:45.523] receiver = 0x842628568 [15:27:45.523] parsetree_item__state = {l = 0x8425c57f0, i = 0} [15:27:45.523] msec_str = "\000\000\000\000\b", '\000' , "{\006\306f\000\000\000\000\004X\3766sɷ\256" [15:27:45.523] dest = DestRemote [15:27:45.523] was_logged = [15:27:45.523] oldcontext = 0x835299000 [15:27:45.523] parsetree_list = 0x8425c57f0 [15:27:45.523] use_implicit_block = false [15:27:45.523] parsetree_item = 0x8425c5808 [15:27:45.523] save_log_statement_stats = [15:27:45.523] #17 0x0000000000904fe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [15:27:45.523] query_string = 0x8351f1100 "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"... [15:27:45.523] input_message = {data = 0x8351f1100 "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} [15:27:45.523] firstchar = [15:27:45.523] local_sigjmp_buf = {{_sjb = {9454710, 34918085744, 34918085704, 34918086288, 12169288, 1, 8192, 8388608, 34918040447, 0, 0, 1}}} [15:27:45.523] send_ready_for_query = false [15:27:45.523] idle_in_transaction_timeout_enabled = false [15:27:45.523] idle_session_timeout_enabled = false [15:27:45.523] #18 0x00000000008ff7b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:27:45.523] bsdata = [15:27:45.523] #19 0x00000000008599d7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82147c1b4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82147c0f0) at ../src/backend/postmaster/launch_backend.c:274 [15:27:45.523] pid = [15:27:45.523] #20 0x000000000085dd98 in BackendStartup (client_sock=0x82147c0f0) at ../src/backend/postmaster/postmaster.c:3414 [15:27:45.523] startup_data = {canAcceptConnections = CAC_OK} [15:27:45.523] bn = 0x8351fd038 [15:27:45.523] pid = [15:27:45.523] __error = [15:27:45.523] save_errno = [15:27:45.523] __error = [15:27:45.523] __error = [15:27:45.523] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:27:45.523] 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.\0375\b", '\000' , "P\301G!\b\000\000\000h\005\037)\b\000\000\000\v\000\000\000\000\000\000\000^\217\037)\b", '\000' , "\220\301G!\b\000\000\000\204\227\205\000\000\000\000\000\240\301G!\b", '\000' }, salen = 16}} [15:27:45.523] i = 0 [15:27:45.523] now = [15:27:45.523] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 716749954, events = 8, fd = 0, user_data = 0x82147c0a0}, {pos = 891655640, events = 8, fd = 558350128, user_data = 0x0}, {pos = 0, events = 0, fd = 658803511, user_data = 0x3e5f4f93f30a}, {pos = 715917216, events = 8, fd = 715988344, user_data = 0x82147bbb8}, {pos = 558349360, events = 8, fd = 558349240, user_data = 0x3e5f4f93f30a}, {pos = 715895688, events = 8, fd = 715988344, user_data = 0x82147bbe8}, {pos = 558349408, events = 8, fd = 558349288, user_data = 0x82aaca194}, {pos = 559080456, events = 8, fd = 715956628, user_data = 0x82147bc50}, {pos = 1335075898, events = 15967, fd = 717778992, user_data = 0x1}, {pos = 558349440, events = 8, fd = 1335096074, user_data = 0x82aab3858}, {pos = 715988344, events = 8, fd = 558349400, user_data = 0x82147bcd0}, {pos = 558349400, events = 8, fd = 715951372, user_data = 0x82152e408}, {pos = 715951372, events = 8, fd = 558349504, user_data = 0x3e5f4f93a43a}, {pos = 558349544, events = 8, fd = 558349992, user_data = 0x82147bcd0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2218657853, fd = 559104056, user_data = 0x800000001}, {pos = 559080456, events = 8, fd = 715895688, user_data = 0x821533288}, {pos = 715864152, events = 8, fd = 559080456, user_data = 0x82147bd58}, {pos = 558350104, events = 8, fd = 558349632, user_data = 0x3e5f4f93eca2}, {pos = 2699959, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 559104056, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558350360, user_data = 0x2152e408}, {pos = 558350176, events = 8, fd = 558349776, user_data = 0x1}, {pos = 558350104, events = 8, fd = 32, user_data = 0x82147bdc0}, {pos = 1335093875, events = 15967, fd = 558350048, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821534038}, {pos = 1, events = 8, fd = 559080456, user_data = 0x82aab3858}, {pos = 558350360, events = 8, fd = 558350176, user_data = 0x82147bdd0}, {pos = 0, events = 0, fd = 559050760, user_data = 0x20}, {pos = 558350160, events = 8, fd = 1335069415, user_data = 0x821527008}, {pos = 559051784, events = 8, fd = 559052808, user_data = 0x821527c08}, {pos = 559067144, events = 8, fd = 559068168, user_data = 0x82152b808}, {pos = 559070216, events = 8, fd = 559071240, user_data = 0x82152c408}, {pos = 559073288, events = 8, fd = 559074312, user_data = 0x82152d008}, {pos = 559076360, events = 8, fd = 559077384, user_data = 0x82152dc08}, {pos = 559079432, events = 8, fd = 559080456, user_data = 0x82152e808}, {pos = 559082504, events = 8, fd = 559083528, user_data = 0x82152f408}, {pos = 559085576, events = 8, fd = 559086600, user_data = 0x821530008}, {pos = 559088648, events = 8, fd = 559089672, user_data = 0x821530c08}, {pos = 559095816, events = 8, fd = 559096840, user_data = 0x821532808}, {pos = 559098888, events = 8, fd = 559050760, user_data = 0x2932b7}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821534038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558350360, events = 8, fd = 558349776, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 559104056, user_data = 0x1}, {pos = 559050760, events = 8, fd = 314, user_data = 0x82147c000}, {pos = 1335068143, events = 15967, fd = 2699959, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 559104056, user_data = 0x1}, {pos = 559080456, events = 8, fd = 891162624, user_data = 0x1}, {pos = 891163028, events = 8, fd = 0, user_data = 0x82147bfd0}, {pos = 689931628, events = 8, fd = 1, user_data = 0x8351e1000}, {pos = 558350336, events = 8, fd = 689927938, user_data = 0x82abe5170 }, {pos = 12094376, events = 0, fd = 717115760, user_data = 0x82152e408}, {pos = 558350560, events = 8, fd = 1335067614, user_data = 0x8351ff800}, {pos = 1, events = 8, fd = 1335067230, user_data = 0x821527008}, {pos = 558350344, events = 8, fd = 558350560, user_data = 0x1c38}, {pos = 891236032, events = 8, fd = 1335146896, user_data = 0x0}, {pos = 558302079, events = 8, fd = 7899047, user_data = 0x82147c090}, {pos = 689890320, events = 8, fd = 717778992, user_data = 0x82ac89310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82147c0c0}, {pos = 689933213, events = 8, fd = 891162624, user_data = 0x1797}, {pos = 558350624, events = 8, fd = 689899770, user_data = 0x0}, {pos = 0, events = 0, fd = 658803511, user_data = 0x0}} [15:27:45.523] last_touch_time = 1724253807 [15:27:45.523] last_lockfile_recheck_time = 1724253807 [15:27:45.523] nevents = 1 [15:27:45.523] #22 0x000000000085bbb5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82147c708) at ../src/backend/postmaster/postmaster.c:1346 [15:27:45.523] userDoption = [15:27:45.523] listen_addr_saved = [15:27:45.523] output_config_variable = [15:27:45.523] opt = [15:27:45.523] status = [15:27:45.523] #23 0x00000000007954ac in main (argc=4, argv=0x82147c708) at ../src/backend/main/main.c:197 [15:27:45.523] do_check_root = [15:27:45.537] [15:27:45.537] [15:27:45.537] [15:27:45.605] dumping /tmp/cores/postgres.14231.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:27:45.731] [New LWP 101746] [15:27:45.807] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [15:27:45.807] Program terminated with signal SIGABRT, Aborted. [15:27:45.807] Sent by thr_kill() from pid 14231 and user 1003. [15:27:45.807] #0 0x000000082955641a in thr_kill () from /lib/libc.so.7 [15:27:46.413] [15:27:46.413] Thread 1 (LWP 101746): [15:27:46.413] #0 0x000000082955641a in thr_kill () from /lib/libc.so.7 [15:27:46.413] No symbol table info available. [15:27:46.413] #1 0x00000008294cfe64 in raise () from /lib/libc.so.7 [15:27:46.413] No symbol table info available. [15:27:46.413] #2 0x00000008295806f9 in abort () from /lib/libc.so.7 [15:27:46.413] No symbol table info available. [15:27:46.413] #3 0x0000000000a5dff5 in ExceptionalCondition (conditionName=0x2d0bb3 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:27:46.413] No locals. [15:27:46.413] #4 0x00000000007402bf in ExecFetchSlotHeapTuple (slot=0x820f60660, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [15:27:46.413] No locals. [15:27:46.413] #5 0x0000000000704f77 in ExecIRDeleteTriggers (estate=estate@entry=0x8357b5100, relinfo=relinfo@entry=0x8357b56b0, slot=slot@entry=0x820f60660) at ../src/backend/commands/trigger.c:2841 [15:27:46.413] trigger = [15:27:46.413] oldtuple = [15:27:46.413] should_free = false [15:27:46.413] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83ad43110, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:27:46.413] trigdesc = 0x8357b58c0 [15:27:46.413] newtuple = 0x0 [15:27:46.413] i = 0 [15:27:46.413] #6 0x0000000000765497 in ExecMergeMatched (context=0x820f60708, resultRelInfo=0x8357b56b0, tupleid=0x0, oldtuple=0x820f60660, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [15:27:46.413] result = TM_Ok [15:27:46.413] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:27:46.413] relaction = 0x83aeb3d38 [15:27:46.413] commandType = CMD_DELETE [15:27:46.413] l__state = {l = 0x83aeb42f8, i = 0} [15:27:46.413] mtstate = 0x8357b54a0 [15:27:46.413] newslot = 0x0 [15:27:46.413] rslot = 0x0 [15:27:46.413] estate = 0x8357b5100 [15:27:46.413] mergeActions = [15:27:46.413] econtext = 0x83aeb3368 [15:27:46.413] epqstate = 0x8357b5588 [15:27:46.413] actionStates = 0x83aeb42f8 [15:27:46.413] l = [15:27:46.413] isNull = [15:27:46.413] lmerge_matched = [15:27:46.413] __error = [15:27:46.413] l__state = [15:27:46.413] result = [15:27:46.413] updateCxt = [15:27:46.413] relaction = [15:27:46.413] commandType = [15:27:46.413] __error = [15:27:46.413] resultRelationDesc = [15:27:46.413] lockmode = [15:27:46.413] inputslot = [15:27:46.413] epqslot = [15:27:46.413] was_matched = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] #7 ExecMerge (context=0x820f60708, resultRelInfo=0x8357b56b0, tupleid=0x0, oldtuple=0x820f60660, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [15:27:46.413] matched = [15:27:46.413] rslot = 0x0 [15:27:46.413] #8 ExecModifyTable (pstate=0x8357b54a0) at ../src/backend/executor/nodeModifyTable.c:4133 [15:27:46.413] context = {mtstate = 0x8357b54a0, epqstate = 0x8357b5588, estate = 0x8357b5100, planSlot = 0x83ad571b0, tmfd = {ctid = {ip_blkid = {bi_hi = 11662, bi_lo = 10581}, ip_posid = 8}, xmax = 134, cmax = 0, traversed = 90}, cpUpdateReturningSlot = 0x936130cf6296d243} [15:27:46.413] tuple_ctid = {ip_blkid = {bi_hi = 1840, bi_lo = 8438}, ip_posid = 8} [15:27:46.413] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83ad63118} [15:27:46.413] node = 0x8357b54a0 [15:27:46.413] estate = 0x8357b5100 [15:27:46.413] operation = CMD_MERGE [15:27:46.413] resultRelInfo = 0x8357b56b0 [15:27:46.413] subplanstate = 0x8357b6df0 [15:27:46.413] slot = [15:27:46.413] tupleid = 0x0 [15:27:46.413] oldtuple = 0x820f60660 [15:27:46.413] oldSlot = [15:27:46.413] #9 0x000000000073252b in ExecProcNode (node=0x8357b54a0) at ../src/include/executor/executor.h:278 [15:27:46.413] No locals. [15:27:46.413] #10 ExecutePlan (estate=0x8357b5100, planstate=0x8357b54a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x8355e9710, execute_once=) at ../src/backend/executor/execMain.c:1641 [15:27:46.413] current_tuple_count = 0 [15:27:46.413] slot = [15:27:46.413] #11 standard_ExecutorRun (queryDesc=0x835638c48, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [15:27:46.413] estate = 0x8357b5100 [15:27:46.413] oldcontext = 0x8355e9400 [15:27:46.413] operation = CMD_MERGE [15:27:46.413] dest = 0x8355e9710 [15:27:46.413] sendTuples = true [15:27:46.413] #12 0x0000000838edd961 in pgss_ExecutorRun (queryDesc=0x835638c48, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [15:27:46.413] _local_sigjmp_buf = {{_sjb = {35314850097, 1, 34912733240, 34912733408, 12160552, 34912733248, 1, 35255454792, 34912732031, 7622785, 35257012224, 34359738368}}} [15:27:46.413] _save_exception_stack = 0x820f609f0 [15:27:46.413] _save_context_stack = 0x0 [15:27:46.413] _do_rethrow = false [15:27:46.413] #13 0x000000000090958f in ProcessQuery (plan=0x83ae77340, sourceText=, params=0x0, queryEnv=0x0, dest=0x8355e9710, qc=0x820f609b8) at ../src/backend/tcop/pquery.c:160 [15:27:46.413] queryDesc = 0x835638c48 [15:27:46.413] #14 0x0000000000908b2d in PortalRunMulti (portal=portal@entry=0x835681100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x8355e9710, altdest=0xb4fda0 , qc=qc@entry=0x820f609b8) at ../src/backend/tcop/pquery.c:1287 [15:27:46.413] pstmt = 0x83ae77340 [15:27:46.413] stmtlist_item__state = {l = 0x83ae7bbf8, i = 0} [15:27:46.413] active_snapshot_set = true [15:27:46.413] stmtlist_item = 0x83ae7bc10 [15:27:46.413] #15 0x000000000090863c in FillPortalStore (portal=portal@entry=0x835681100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:27:46.413] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:27:46.413] treceiver = 0x8355e9710 [15:27:46.413] #16 0x00000000009083ab in PortalRun (portal=portal@entry=0x835681100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83ae7bc48, altdest=altdest@entry=0x83ae7bc48, qc=0x820f60af0) at ../src/backend/tcop/pquery.c:763 [15:27:46.413] _local_sigjmp_buf = {{_sjb = {9470797, 35255750912, 34912733672, 34912733904, 34912733680, 35255844864, 12127288, 12160552, 35255747455, 35255070976, 4294967984, 0}}} [15:27:46.413] _save_exception_stack = 0x820f60bc0 [15:27:46.413] _save_context_stack = 0x0 [15:27:46.413] _do_rethrow = false [15:27:46.413] saveTopTransactionResourceOwner = 0x8356cf7d8 [15:27:46.413] saveTopTransactionContext = 0x835698000 [15:27:46.413] saveActivePortal = 0x0 [15:27:46.413] saveResourceOwner = 0x8356cf7d8 [15:27:46.413] savePortalContext = 0x0 [15:27:46.413] saveMemoryContext = 0x835698000 [15:27:46.413] result = [15:27:46.413] nprocessed = [15:27:46.413] #17 0x0000000000907272 in exec_simple_query (query_string=query_string@entry=0x8355db100 "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 [15:27:46.413] cmdtaglen = 5 [15:27:46.413] snapshot_set = [15:27:46.413] per_parsetree_context = 0x0 [15:27:46.413] plantree_list = [15:27:46.413] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:27:46.413] format = 0 [15:27:46.413] parsetree = 0x83ae535a8 [15:27:46.413] commandTag = [15:27:46.413] cmdtagname = [15:27:46.413] querytree_list = [15:27:46.413] portal = 0x835681100 [15:27:46.413] receiver = 0x83ae7bc48 [15:27:46.413] parsetree_item__state = {l = 0x83ae54e70, i = 0} [15:27:46.413] msec_str = "\000\000\000\000\b", '\000' , "\234\006\306f\000\000\000\000$6\304Ss\257", [15:27:46.413] dest = DestRemote [15:27:46.413] was_logged = [15:27:46.413] oldcontext = 0x835698000 [15:27:46.413] parsetree_list = 0x83ae54e70 [15:27:46.413] use_implicit_block = false [15:27:46.413] parsetree_item = 0x83ae54e88 [15:27:46.413] save_log_statement_stats = [15:27:46.413] #18 0x0000000000904fe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [15:27:46.413] query_string = 0x8355db100 "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"... [15:27:46.413] input_message = {data = 0x8355db100 "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} [15:27:46.413] firstchar = [15:27:46.413] local_sigjmp_buf = {{_sjb = {9454710, 34912734144, 34912734104, 34912734688, 12169288, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [15:27:46.413] send_ready_for_query = false [15:27:46.413] idle_in_transaction_timeout_enabled = false [15:27:46.413] idle_session_timeout_enabled = false [15:27:46.413] #19 0x00000000008ff7b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:27:46.413] bsdata = [15:27:46.413] #20 0x00000000008599d7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f61904 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f61840) at ../src/backend/postmaster/launch_backend.c:274 [15:27:46.413] pid = [15:27:46.413] #21 0x000000000085dd98 in BackendStartup (client_sock=0x820f61840) at ../src/backend/postmaster/postmaster.c:3414 [15:27:46.413] startup_data = {canAcceptConnections = CAC_OK} [15:27:46.413] bn = 0x8355e71c8 [15:27:46.413] pid = [15:27:46.413] __error = [15:27:46.413] save_errno = [15:27:46.413] __error = [15:27:46.413] __error = [15:27:46.413] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:27:46.413] 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 = " \274]5\b", '\000' , "\240\030\366 \b\000\000\000h\325\360)\b\000\000\000\v\000\000\000\000\000\000\000^_\361)\b", '\000' , "\340\030\366 \b\000\000\000\204\227\205\000\000\000\000\000\360\030\366 \b", '\000' }, salen = 16}} [15:27:46.413] i = 0 [15:27:46.413] now = [15:27:46.413] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 693087362, events = 8, fd = 0, user_data = 0x820f617f0}, {pos = 895759832, events = 8, fd = 552998528, user_data = 0x0}, {pos = 510354186, events = 7032, fd = 692254624, user_data = 0x829440d78}, {pos = 552997624, events = 8, fd = 552997744, user_data = 0x820f612f8}, {pos = 510354186, events = 7032, fd = 692233096, user_data = 0x829440d78}, {pos = 552997672, events = 8, fd = 552997792, user_data = 0x820f61328}, {pos = 692294036, events = 8, fd = 556000264, user_data = 0x829439194}, {pos = 552997776, events = 8, fd = 510334010, user_data = 0x820f61330}, {pos = 703640592, events = 8, fd = 694116400, user_data = 0x1b781e6b630a}, {pos = 692201560, events = 8, fd = 692325752, user_data = 0x820f61398}, {pos = 552997904, events = 8, fd = 552997784, user_data = 0x829437d0c}, {pos = 556000264, events = 8, fd = 692288780, user_data = 0x820f61400}, {pos = 510334010, events = 7032, fd = 552997928, user_data = 0x820f615f8}, {pos = 552997904, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821244038}, {pos = 1, events = 2472620239, fd = 556000264, user_data = 0x82942a388}, {pos = 556021704, events = 8, fd = 0, user_data = 0x0}, {pos = 552998040, events = 8, fd = 552998504, user_data = 0x820f61480}, {pos = 510352546, events = 7032, fd = 2699959, user_data = 0x6d68b}, {pos = 2090263927, events = 2472620239, fd = 556023864, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820f61768}, {pos = 556000264, events = 3, fd = 552998576, user_data = 0x821243828}, {pos = 656, events = 0, fd = 552998504, user_data = 0x820f61498}, {pos = 552998144, events = 8, fd = 510352155, user_data = 0x820f61630}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 556023864, events = 8, fd = 1, user_data = 0x82123e408}, {pos = 692201560, events = 8, fd = 552998760, user_data = 0x820f616b0}, {pos = 552998160, events = 8, fd = 0, user_data = 0x821237008}, {pos = 33, events = 0, fd = 552998560, user_data = 0x1b781e6afae7}, {pos = 555970568, events = 8, fd = 555971592, user_data = 0x821237808}, {pos = 555973640, events = 8, fd = 555986952, user_data = 0x82123b408}, {pos = 555989000, events = 8, fd = 555990024, user_data = 0x82123c008}, {pos = 555992072, events = 8, fd = 555993096, user_data = 0x82123cc08}, {pos = 555995144, events = 8, fd = 555996168, user_data = 0x82123d808}, {pos = 555998216, events = 8, fd = 555999240, user_data = 0x82123e408}, {pos = 556001288, events = 8, fd = 556002312, user_data = 0x82123f008}, {pos = 556004360, events = 8, fd = 556005384, user_data = 0x82123fc08}, {pos = 556007432, events = 8, fd = 556008456, user_data = 0x821240808}, {pos = 556010504, events = 8, fd = 556015624, user_data = 0x821242408}, {pos = 556017672, events = 8, fd = 556018696, user_data = 0x821245408}, {pos = 674784000, events = 0, fd = 555970568, user_data = 0x2932b7}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821244038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552998760, events = 8, fd = 552998160, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 556023864, user_data = 0x1}, {pos = 555970568, events = 8, fd = 314, user_data = 0x820f61750}, {pos = 510326255, events = 7032, fd = 2699959, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 556023864, user_data = 0x1}, {pos = 556000264, events = 8, fd = 895266816, user_data = 0x1}, {pos = 895267220, events = 8, fd = 0, user_data = 0x820f61720}, {pos = 703681900, events = 8, fd = 1, user_data = 0x8355cb000}, {pos = 552998736, events = 8, fd = 703678210, user_data = 0x829554170 }, {pos = 12094376, events = 0, fd = 693453168, user_data = 0x82123e408}, {pos = 552998960, events = 8, fd = 510325726, user_data = 0x8355e9800}, {pos = 1, events = 8, fd = 510325342, user_data = 0x821237008}, {pos = 552998744, events = 8, fd = 552998960, user_data = 0x1c38}, {pos = 895335456, events = 8, fd = 510405008, user_data = 0x0}, {pos = 552993663, events = 8, fd = 7899047, user_data = 0x820f617e0}, {pos = 703640592, events = 8, fd = 694116400, user_data = 0x8295f8310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f61810}, {pos = 703683485, events = 8, fd = 895266816, user_data = 0x2fb4}, {pos = 552999024, events = 8, fd = 703650042, user_data = 0x0}, {pos = 0, events = 0, fd = 1654051395, user_data = 0x0}} [15:27:46.414] last_touch_time = 1724253839 [15:27:46.414] last_lockfile_recheck_time = 1724253839 [15:27:46.414] nevents = 1 [15:27:46.414] #23 0x000000000085bbb5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f61e50) at ../src/backend/postmaster/postmaster.c:1346 [15:27:46.414] userDoption = [15:27:46.414] listen_addr_saved = [15:27:46.414] output_config_variable = [15:27:46.414] opt = [15:27:46.414] status = [15:27:46.414] #24 0x00000000007954ac in main (argc=4, argv=0x820f61e50) at ../src/backend/main/main.c:197 [15:27:46.414] do_check_root =