[04:20:31.540] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [04:20:31.879] dumping /tmp/cores/postgres.8928.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [04:20:32.005] [New LWP 101275] [04:20:32.089] Core was generated by `postgres: postgres regression [local] MERGE'. [04:20:32.089] Program terminated with signal SIGABRT, Aborted. [04:20:32.089] Sent by thr_kill() from pid 8928 and user 1003. [04:20:32.089] #0 0x000000082cb2f41a in thr_kill () from /lib/libc.so.7 [04:20:32.706] [04:20:32.706] Thread 1 (LWP 101275): [04:20:32.706] #0 0x000000082cb2f41a in thr_kill () from /lib/libc.so.7 [04:20:32.706] No symbol table info available. [04:20:32.706] #1 0x000000082caa8e64 in raise () from /lib/libc.so.7 [04:20:32.706] No symbol table info available. [04:20:32.706] #2 0x000000082cb596f9 in abort () from /lib/libc.so.7 [04:20:32.706] No symbol table info available. [04:20:32.706] #3 0x0000000000a58fe5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [04:20:32.706] No locals. [04:20:32.706] #4 0x000000000073d37f in ExecFetchSlotHeapTuple (slot=0x821b57440, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [04:20:32.706] No locals. [04:20:32.706] #5 0x0000000000702037 in ExecIRDeleteTriggers (estate=estate@entry=0x833f16100, relinfo=relinfo@entry=0x833f166b0, slot=slot@entry=0x821b57440) at ../src/backend/commands/trigger.c:2841 [04:20:32.706] trigger = [04:20:32.706] oldtuple = [04:20:32.706] should_free = false [04:20:32.706] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x841eb8c40, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [04:20:32.706] trigdesc = 0x833f168c0 [04:20:32.706] newtuple = 0x0 [04:20:32.706] i = 0 [04:20:32.706] #6 0x0000000000762557 in ExecMergeMatched (context=0x821b574e8, resultRelInfo=0x833f166b0, tupleid=0x0, oldtuple=0x821b57440, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [04:20:32.706] result = TM_Ok [04:20:32.706] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [04:20:32.706] relaction = 0x841fee838 [04:20:32.706] commandType = CMD_DELETE [04:20:32.706] l__state = {l = 0x841feedf8, i = 0} [04:20:32.706] mtstate = 0x833f164a0 [04:20:32.706] newslot = 0x0 [04:20:32.706] rslot = 0x0 [04:20:32.706] estate = 0x833f16100 [04:20:32.706] mergeActions = [04:20:32.706] econtext = 0x841fede68 [04:20:32.706] epqstate = 0x833f16588 [04:20:32.706] actionStates = 0x841feedf8 [04:20:32.706] l = [04:20:32.706] isNull = [04:20:32.706] lmerge_matched = [04:20:32.706] __error = [04:20:32.706] l__state = [04:20:32.706] result = [04:20:32.706] updateCxt = [04:20:32.706] relaction = [04:20:32.706] commandType = [04:20:32.706] __error = [04:20:32.706] resultRelationDesc = [04:20:32.706] lockmode = [04:20:32.706] inputslot = [04:20:32.706] epqslot = [04:20:32.706] was_matched = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] #7 ExecMerge (context=0x821b574e8, resultRelInfo=0x833f166b0, tupleid=0x0, oldtuple=0x821b57440, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [04:20:32.706] matched = [04:20:32.706] rslot = 0x0 [04:20:32.706] #8 ExecModifyTable (pstate=0x833f164a0) at ../src/backend/executor/nodeModifyTable.c:4133 [04:20:32.706] context = {mtstate = 0x833f164a0, epqstate = 0x833f16588, estate = 0x833f16100, planSlot = 0x841f00bf0, tmfd = {ctid = {ip_blkid = {bi_hi = 38584, bi_lo = 16897}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x833f166b0} [04:20:32.706] tuple_ctid = {ip_blkid = {bi_hi = 12112, bi_lo = 17386}, ip_posid = 8} [04:20:32.706] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x841ed0118} [04:20:32.706] node = 0x833f164a0 [04:20:32.706] estate = 0x833f16100 [04:20:32.706] operation = CMD_MERGE [04:20:32.706] resultRelInfo = 0x833f166b0 [04:20:32.706] subplanstate = 0x833f17df0 [04:20:32.706] slot = [04:20:32.706] tupleid = 0x0 [04:20:32.706] oldtuple = 0x821b57440 [04:20:32.706] oldSlot = [04:20:32.706] #9 0x000000000072f5eb in ExecProcNode (node=0x833f164a0) at ../src/include/executor/executor.h:278 [04:20:32.706] No locals. [04:20:32.706] #10 ExecutePlan (estate=0x833f16100, planstate=0x833f164a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x833d6eb10, execute_once=) at ../src/backend/executor/execMain.c:1641 [04:20:32.706] current_tuple_count = 0 [04:20:32.706] slot = [04:20:32.706] #11 standard_ExecutorRun (queryDesc=0x833db6c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [04:20:32.706] estate = 0x833f16100 [04:20:32.706] oldcontext = 0x833d6e800 [04:20:32.706] operation = CMD_MERGE [04:20:32.706] dest = 0x833d6eb10 [04:20:32.706] sendTuples = true [04:20:32.706] #12 0x00000000009042bf in ProcessQuery (plan=0x842018fa0, sourceText=, params=0x0, queryEnv=0x0, dest=0x833d6eb10, qc=0x821b576e8) at ../src/backend/tcop/pquery.c:160 [04:20:32.706] queryDesc = 0x833db6c48 [04:20:32.706] #13 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x833e35100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x833d6eb10, altdest=0xb4a9c0 , qc=qc@entry=0x821b576e8) at ../src/backend/tcop/pquery.c:1287 [04:20:32.706] pstmt = 0x842018fa0 [04:20:32.706] stmtlist_item__state = {l = 0x84201d858, i = 0} [04:20:32.706] active_snapshot_set = true [04:20:32.706] stmtlist_item = 0x84201d870 [04:20:32.706] #14 0x000000000090336c in FillPortalStore (portal=portal@entry=0x833e35100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [04:20:32.706] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:20:32.706] treceiver = 0x833d6eb10 [04:20:32.706] #15 0x00000000009030db in PortalRun (portal=portal@entry=0x833e35100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x84201d8a8, altdest=altdest@entry=0x84201d8a8, qc=0x821b57820) at ../src/backend/tcop/pquery.c:763 [04:20:32.706] _local_sigjmp_buf = {{_sjb = {9449597, 35230273792, 34925279000, 34925279232, 34925279008, 35230294016, 12105816, 12139128, 35230253951, 35229401344, 4294967984, 0}}} [04:20:32.706] _save_exception_stack = 0x821b578f0 [04:20:32.706] _save_context_stack = 0x0 [04:20:32.706] _do_rethrow = false [04:20:32.706] saveTopTransactionResourceOwner = 0x833e47118 [04:20:32.706] saveTopTransactionContext = 0x833e3a000 [04:20:32.706] saveActivePortal = 0x0 [04:20:32.706] saveResourceOwner = 0x833e47118 [04:20:32.706] savePortalContext = 0x0 [04:20:32.706] saveMemoryContext = 0x833e3a000 [04:20:32.706] result = [04:20:32.706] nprocessed = [04:20:32.706] #16 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x833d60100 "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 [04:20:32.706] cmdtaglen = 5 [04:20:32.706] snapshot_set = [04:20:32.706] per_parsetree_context = 0x0 [04:20:32.706] plantree_list = [04:20:32.706] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:20:32.706] format = 0 [04:20:32.706] parsetree = 0x841fbfea8 [04:20:32.706] commandTag = [04:20:32.706] cmdtagname = [04:20:32.706] querytree_list = [04:20:32.706] portal = 0x833e35100 [04:20:32.706] receiver = 0x84201d8a8 [04:20:32.706] parsetree_item__state = {l = 0x841fc1770, i = 0} [04:20:32.706] msec_str = "\000\000\000\000\b", '\000' , "\026\260\312f\000\000\000\000\223\225Y\v\230\370^\207" [04:20:32.706] dest = DestRemote [04:20:32.706] was_logged = [04:20:32.706] oldcontext = 0x833e3a000 [04:20:32.706] parsetree_list = 0x841fc1770 [04:20:32.706] use_implicit_block = false [04:20:32.706] parsetree_item = 0x841fc1788 [04:20:32.706] save_log_statement_stats = [04:20:32.706] #17 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [04:20:32.706] query_string = 0x833d60100 "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"... [04:20:32.706] input_message = {data = 0x833d60100 "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} [04:20:32.706] firstchar = [04:20:32.706] local_sigjmp_buf = {{_sjb = {9433510, 34925279472, 34925279432, 34925280016, 12147864, 1, 8192, 8388608, 34925249407, 0, 0, 1}}} [04:20:32.706] send_ready_for_query = false [04:20:32.706] idle_in_transaction_timeout_enabled = false [04:20:32.706] idle_session_timeout_enabled = false [04:20:32.706] #18 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:20:32.706] bsdata = [04:20:32.706] #19 0x0000000000854707 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821b58634 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821b58570) at ../src/backend/postmaster/launch_backend.c:274 [04:20:32.706] pid = [04:20:32.706] #20 0x0000000000858ac8 in BackendStartup (client_sock=0x821b58570) at ../src/backend/postmaster/postmaster.c:3414 [04:20:32.706] startup_data = {canAcceptConnections = CAC_OK} [04:20:32.706] bn = 0x833d6c4e8 [04:20:32.706] pid = [04:20:32.706] __error = [04:20:32.706] save_errno = [04:20:32.706] __error = [04:20:32.706] __error = [04:20:32.706] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [04:20:32.706] 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\037\3263\b", '\000' , "Ѕ\265!\b\000\000\000h\245c+\b\000\000\000\v\000\000\000\000\000\000\000^/d+\b", '\000' , "\020\206\265!\b\000\000\000\264D\205\000\000\000\000\000 \206\265!\b", '\000' }, salen = 16}} [04:20:32.706] i = 0 [04:20:32.706] now = [04:20:32.706] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 749550722, events = 8, fd = 0, user_data = 0x821b58520}, {pos = 870061528, events = 8, fd = 565543856, user_data = 0x0}, {pos = 0, events = 0, fd = 1985239482, user_data = 0x31a2ddc130a}, {pos = 748717984, events = 8, fd = 748789112, user_data = 0x821b58038}, {pos = 565543088, events = 8, fd = 565542968, user_data = 0x31a2ddc130a}, {pos = 748696456, events = 8, fd = 748789112, user_data = 0x821b58068}, {pos = 565543136, events = 8, fd = 565543016, user_data = 0x82ca12194}, {pos = 576463880, events = 8, fd = 748757396, user_data = 0x821b580d0}, {pos = 769377338, events = 794, fd = 750579760, user_data = 0x1}, {pos = 565543168, events = 8, fd = 769397514, user_data = 0x82c9fb858}, {pos = 748789112, events = 8, fd = 565543128, user_data = 0x821b58150}, {pos = 565543128, events = 8, fd = 748752140, user_data = 0x8225c2408}, {pos = 748752140, events = 8, fd = 565543232, user_data = 0x31a2ddbc43a}, {pos = 565543272, events = 8, fd = 565543720, user_data = 0x821b58150}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3692863898, fd = 576487480, user_data = 0x800000001}, {pos = 576463880, events = 8, fd = 748696456, user_data = 0x8225c7288}, {pos = 748664920, events = 8, fd = 576463880, user_data = 0x821b581d8}, {pos = 565543832, events = 8, fd = 565543360, user_data = 0x31a2ddc0ca2}, {pos = 2699790, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 576487480, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 565544088, user_data = 0x225c2408}, {pos = 565543904, events = 8, fd = 565543504, user_data = 0x1}, {pos = 565543832, events = 8, fd = 32, user_data = 0x821b58240}, {pos = 769395315, events = 794, fd = 565543776, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8225c8038}, {pos = 1, events = 8, fd = 576463880, user_data = 0x82c9fb858}, {pos = 565544088, events = 8, fd = 565543904, user_data = 0x821b58250}, {pos = 0, events = 0, fd = 576434184, user_data = 0x20}, {pos = 565543888, events = 8, fd = 769370855, user_data = 0x8225bb008}, {pos = 576435208, events = 8, fd = 576436232, user_data = 0x8225bbc08}, {pos = 576450568, events = 8, fd = 576451592, user_data = 0x8225bf808}, {pos = 576453640, events = 8, fd = 576454664, user_data = 0x8225c0408}, {pos = 576456712, events = 8, fd = 576457736, user_data = 0x8225c1008}, {pos = 576459784, events = 8, fd = 576460808, user_data = 0x8225c1c08}, {pos = 576462856, events = 8, fd = 576463880, user_data = 0x8225c2808}, {pos = 576465928, events = 8, fd = 576466952, user_data = 0x8225c3408}, {pos = 576469000, events = 8, fd = 576470024, user_data = 0x8225c4008}, {pos = 576472072, events = 8, fd = 576473096, user_data = 0x8225c4c08}, {pos = 576479240, events = 8, fd = 576480264, user_data = 0x8225c6808}, {pos = 576482312, events = 8, fd = 576434184, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8225c8038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 565544088, events = 8, fd = 565543504, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 576487480, user_data = 0x1}, {pos = 576434184, events = 8, fd = 314, user_data = 0x821b58480}, {pos = 769369583, events = 794, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 576487480, user_data = 0x1}, {pos = 576463880, events = 8, fd = 869597184, user_data = 0x1}, {pos = 869597588, events = 8, fd = 0, user_data = 0x821b58450}, {pos = 727983468, events = 8, fd = 1, user_data = 0x833d50000}, {pos = 565544064, events = 8, fd = 727979778, user_data = 0x82cb2d170 }, {pos = 12072904, events = 0, fd = 749916528, user_data = 0x8225c2408}, {pos = 565544288, events = 8, fd = 769369054, user_data = 0x833d6e800}, {pos = 1, events = 0, fd = 769368670, user_data = 0x8225bb008}, {pos = 565544072, events = 8, fd = 565544288, user_data = 0x1c38}, {pos = 869670656, events = 8, fd = 769448336, user_data = 0x0}, {pos = 565511039, events = 8, fd = 7886951, user_data = 0x821b58510}, {pos = 727942160, events = 8, fd = 750579760, user_data = 0x82cbd1310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821b58540}, {pos = 727985053, events = 8, fd = 869597184, user_data = 0x1b68}, {pos = 565544352, events = 8, fd = 727951610, user_data = 0x0}, {pos = 0, events = 0, fd = 1985239482, user_data = 0x0}} [04:20:32.706] last_touch_time = 1724559371 [04:20:32.706] last_lockfile_recheck_time = 1724559371 [04:20:32.706] nevents = 1 [04:20:32.706] #22 0x00000000008568e5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821b58b88) at ../src/backend/postmaster/postmaster.c:1346 [04:20:32.706] userDoption = [04:20:32.706] listen_addr_saved = [04:20:32.706] output_config_variable = [04:20:32.706] opt = [04:20:32.706] status = [04:20:32.706] #23 0x000000000079256c in main (argc=8, argv=0x821b58b88) at ../src/backend/main/main.c:197 [04:20:32.706] do_check_root = [04:20:32.719] [04:20:32.719] [04:20:32.719] [04:20:32.779] dumping /tmp/cores/postgres.9102.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:20:32.900] [New LWP 100142] [04:20:32.963] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [04:20:32.963] Program terminated with signal SIGABRT, Aborted. [04:20:32.963] Sent by thr_kill() from pid 9102 and user 1003. [04:20:32.963] #0 0x000000082c95541a in thr_kill () from /lib/libc.so.7 [04:20:33.537] [04:20:33.537] Thread 1 (LWP 100142): [04:20:33.537] #0 0x000000082c95541a in thr_kill () from /lib/libc.so.7 [04:20:33.537] No symbol table info available. [04:20:33.537] #1 0x000000082c8cee64 in raise () from /lib/libc.so.7 [04:20:33.537] No symbol table info available. [04:20:33.537] #2 0x000000082c97f6f9 in abort () from /lib/libc.so.7 [04:20:33.537] No symbol table info available. [04:20:33.537] #3 0x0000000000a58fe5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [04:20:33.537] No locals. [04:20:33.537] #4 0x000000000073d37f in ExecFetchSlotHeapTuple (slot=0x8210336e0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [04:20:33.537] No locals. [04:20:33.537] #5 0x0000000000702037 in ExecIRDeleteTriggers (estate=estate@entry=0x836859100, relinfo=relinfo@entry=0x8368596b0, slot=slot@entry=0x8210336e0) at ../src/backend/commands/trigger.c:2841 [04:20:33.537] trigger = [04:20:33.537] oldtuple = [04:20:33.537] should_free = false [04:20:33.537] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8390fe450, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [04:20:33.537] trigdesc = 0x8368598c0 [04:20:33.537] newtuple = 0x0 [04:20:33.537] i = 0 [04:20:33.537] #6 0x0000000000762557 in ExecMergeMatched (context=0x821033788, resultRelInfo=0x8368596b0, tupleid=0x0, oldtuple=0x8210336e0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [04:20:33.537] result = TM_Ok [04:20:33.537] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [04:20:33.537] relaction = 0x83920f638 [04:20:33.537] commandType = CMD_DELETE [04:20:33.537] l__state = {l = 0x83920fbf8, i = 0} [04:20:33.537] mtstate = 0x8368594a0 [04:20:33.537] newslot = 0x0 [04:20:33.537] rslot = 0x0 [04:20:33.537] estate = 0x836859100 [04:20:33.537] mergeActions = [04:20:33.537] econtext = 0x83920ec68 [04:20:33.537] epqstate = 0x836859588 [04:20:33.537] actionStates = 0x83920fbf8 [04:20:33.537] l = [04:20:33.537] isNull = [04:20:33.537] lmerge_matched = [04:20:33.537] __error = [04:20:33.537] l__state = [04:20:33.537] result = [04:20:33.537] updateCxt = [04:20:33.537] relaction = [04:20:33.537] commandType = [04:20:33.537] __error = [04:20:33.537] resultRelationDesc = [04:20:33.537] lockmode = [04:20:33.537] inputslot = [04:20:33.537] epqslot = [04:20:33.537] was_matched = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] #7 ExecMerge (context=0x821033788, resultRelInfo=0x8368596b0, tupleid=0x0, oldtuple=0x8210336e0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [04:20:33.537] matched = [04:20:33.537] rslot = 0x0 [04:20:33.537] #8 ExecModifyTable (pstate=0x8368594a0) at ../src/backend/executor/nodeModifyTable.c:4133 [04:20:33.537] context = {mtstate = 0x8368594a0, epqstate = 0x836859588, estate = 0x836859100, planSlot = 0x8391836f0, tmfd = {ctid = {ip_blkid = {bi_hi = 43832, bi_lo = 14627}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8368596b0} [04:20:33.537] tuple_ctid = {ip_blkid = {bi_hi = 17168, bi_lo = 17576}, ip_posid = 8} [04:20:33.537] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836865118} [04:20:33.537] node = 0x8368594a0 [04:20:33.537] estate = 0x836859100 [04:20:33.537] operation = CMD_MERGE [04:20:33.537] resultRelInfo = 0x8368596b0 [04:20:33.537] subplanstate = 0x83685adf0 [04:20:33.537] slot = [04:20:33.537] tupleid = 0x0 [04:20:33.537] oldtuple = 0x8210336e0 [04:20:33.537] oldSlot = [04:20:33.537] #9 0x000000000072f5eb in ExecProcNode (node=0x8368594a0) at ../src/include/executor/executor.h:278 [04:20:33.537] No locals. [04:20:33.537] #10 ExecutePlan (estate=0x836859100, planstate=0x8368594a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x8366e3b10, execute_once=) at ../src/backend/executor/execMain.c:1641 [04:20:33.537] current_tuple_count = 0 [04:20:33.537] slot = [04:20:33.537] #11 standard_ExecutorRun (queryDesc=0x836707448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [04:20:33.537] estate = 0x836859100 [04:20:33.537] oldcontext = 0x8366e3800 [04:20:33.537] operation = CMD_MERGE [04:20:33.537] dest = 0x8366e3b10 [04:20:33.537] sendTuples = true [04:20:33.537] #12 0x00000000009042bf in ProcessQuery (plan=0x83923a420, sourceText=, params=0x0, queryEnv=0x0, dest=0x8366e3b10, qc=0x821033988) at ../src/backend/tcop/pquery.c:160 [04:20:33.537] queryDesc = 0x836707448 [04:20:33.537] #13 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x83674e100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x8366e3b10, altdest=0xb4a9c0 , qc=qc@entry=0x821033988) at ../src/backend/tcop/pquery.c:1287 [04:20:33.537] pstmt = 0x83923a420 [04:20:33.537] stmtlist_item__state = {l = 0x83923ecd8, i = 0} [04:20:33.537] active_snapshot_set = true [04:20:33.537] stmtlist_item = 0x83923ecf0 [04:20:33.537] #14 0x000000000090336c in FillPortalStore (portal=portal@entry=0x83674e100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [04:20:33.537] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:20:33.537] treceiver = 0x8366e3b10 [04:20:33.537] #15 0x00000000009030db in PortalRun (portal=portal@entry=0x83674e100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83923ed28, altdest=altdest@entry=0x83923ed28, qc=0x821033ac0) at ../src/backend/tcop/pquery.c:763 [04:20:33.537] _local_sigjmp_buf = {{_sjb = {9449597, 35273367808, 34913597880, 34913598112, 34913597888, 35273383936, 12105816, 12139128, 35273376639, 35272696064, 4294967984, 0}}} [04:20:33.537] _save_exception_stack = 0x821033b90 [04:20:33.537] _save_context_stack = 0x0 [04:20:33.537] _do_rethrow = false [04:20:33.537] saveTopTransactionResourceOwner = 0x83679ded8 [04:20:33.537] saveTopTransactionContext = 0x836752000 [04:20:33.537] saveActivePortal = 0x0 [04:20:33.537] saveResourceOwner = 0x83679ded8 [04:20:33.537] savePortalContext = 0x0 [04:20:33.537] saveMemoryContext = 0x836752000 [04:20:33.537] result = [04:20:33.537] nprocessed = [04:20:33.537] #16 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x8366aa100 "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 [04:20:33.537] cmdtaglen = 5 [04:20:33.537] snapshot_set = [04:20:33.537] per_parsetree_context = 0x0 [04:20:33.537] plantree_list = [04:20:33.537] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:20:33.537] format = 0 [04:20:33.537] parsetree = 0x8391e1828 [04:20:33.537] commandTag = [04:20:33.537] cmdtagname = [04:20:33.537] querytree_list = [04:20:33.537] portal = 0x83674e100 [04:20:33.537] receiver = 0x83923ed28 [04:20:33.537] parsetree_item__state = {l = 0x8391e30f0, i = 0} [04:20:33.537] msec_str = "\000\000\000\000\b", '\000' , "\027\260\312f\000\000\000\000\363ՠ\221nx", [04:20:33.537] dest = DestRemote [04:20:33.537] was_logged = [04:20:33.537] oldcontext = 0x836752000 [04:20:33.537] parsetree_list = 0x8391e30f0 [04:20:33.537] use_implicit_block = false [04:20:33.537] parsetree_item = 0x8391e3108 [04:20:33.537] save_log_statement_stats = [04:20:33.537] #17 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [04:20:33.537] query_string = 0x8366aa100 "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"... [04:20:33.537] input_message = {data = 0x8366aa100 "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} [04:20:33.537] firstchar = [04:20:33.537] local_sigjmp_buf = {{_sjb = {9433510, 34913598352, 34913598312, 34913598896, 12147864, 1, 8192, 8388608, 34913583999, 0, 0, 1}}} [04:20:33.537] send_ready_for_query = false [04:20:33.537] idle_in_transaction_timeout_enabled = false [04:20:33.537] idle_session_timeout_enabled = false [04:20:33.537] #18 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:20:33.537] bsdata = [04:20:33.537] #19 0x0000000000854707 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210348d4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821034810) at ../src/backend/postmaster/launch_backend.c:274 [04:20:33.537] pid = [04:20:33.537] #20 0x0000000000858ac8 in BackendStartup (client_sock=0x821034810) at ../src/backend/postmaster/postmaster.c:3414 [04:20:33.537] startup_data = {canAcceptConnections = CAC_OK} [04:20:33.537] bn = 0x8366b6498 [04:20:33.537] pid = [04:20:33.537] __error = [04:20:33.537] save_errno = [04:20:33.537] __error = [04:20:33.537] __error = [04:20:33.537] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [04:20:33.537] 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\276j6\b", '\000' , "pH\003!\b\000\000\000h\245\311*\b\000\000\000\v\000\000\000\000\000\000\000^/\312*\b", '\000' , "\260H\003!\b\000\000\000\264D\205\000\000\000\000\000\300H\003!\b", '\000' }, salen = 16}} [04:20:33.537] i = 0 [04:20:33.537] now = [04:20:33.537] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 913384920, events = 8, fd = 553862736, user_data = 0x0}, {pos = 0, events = 0, fd = 852546570, user_data = 0x325a0cfe30a}, {pos = 746776480, events = 8, fd = 746847608, user_data = 0x8210342d8}, {pos = 553861968, events = 8, fd = 553861848, user_data = 0x325a0cfe30a}, {pos = 746754952, events = 8, fd = 746847608, user_data = 0x821034308}, {pos = 553862016, events = 8, fd = 553861896, user_data = 0x82c838194}, {pos = 567211016, events = 8, fd = 746815892, user_data = 0x821034370}, {pos = -1597008838, events = 805, fd = 748638256, user_data = 0x1}, {pos = 553862048, events = 8, fd = -1596988662, user_data = 0x82c821858}, {pos = 746847608, events = 8, fd = 553862008, user_data = 0x8210343f0}, {pos = 553862008, events = 8, fd = 746810636, user_data = 0x821cef408}, {pos = 746810636, events = 8, fd = 553862112, user_data = 0x325a0cf943a}, {pos = 553862152, events = 8, fd = 553862600, user_data = 0x8210343f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1612454012, fd = 567234616, user_data = 0x800000001}, {pos = 567211016, events = 8, fd = 746754952, user_data = 0x821cf4288}, {pos = 746723416, events = 8, fd = 567211016, user_data = 0x821034478}, {pos = 553862712, events = 8, fd = 553862240, user_data = 0x325a0cfdca2}, {pos = 2699790, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 567234616, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 553862968, user_data = 0x21cef408}, {pos = 553862784, events = 8, fd = 553862384, user_data = 0x1}, {pos = 553862712, events = 8, fd = 32, user_data = 0x8210344e0}, {pos = -1596990861, events = 805, fd = 553862656, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821cf5038}, {pos = 1, events = 8, fd = 567211016, user_data = 0x82c821858}, {pos = 553862968, events = 8, fd = 553862784, user_data = 0x8210344f0}, {pos = 0, events = 0, fd = 567181320, user_data = 0x20}, {pos = 553862768, events = 8, fd = -1597015321, user_data = 0x821ce8008}, {pos = 567182344, events = 8, fd = 567183368, user_data = 0x821ce8c08}, {pos = 567197704, events = 8, fd = 567198728, user_data = 0x821cec808}, {pos = 567200776, events = 8, fd = 567201800, user_data = 0x821ced408}, {pos = 567203848, events = 8, fd = 567204872, user_data = 0x821cee008}, {pos = 567206920, events = 8, fd = 567207944, user_data = 0x821ceec08}, {pos = 567209992, events = 8, fd = 567211016, user_data = 0x821cef808}, {pos = 567213064, events = 8, fd = 567214088, user_data = 0x821cf0408}, {pos = 567216136, events = 8, fd = 567217160, user_data = 0x821cf1008}, {pos = 567219208, events = 8, fd = 567220232, user_data = 0x821cf1c08}, {pos = 567226376, events = 8, fd = 567227400, user_data = 0x821cf3808}, {pos = 567229448, events = 8, fd = 567181320, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821cf5038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553862968, events = 8, fd = 553862384, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 567234616, user_data = 0x1}, {pos = 567181320, events = 8, fd = 314, user_data = 0x821034720}, {pos = -1597016593, events = 805, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 567234616, user_data = 0x1}, {pos = 567211016, events = 8, fd = 912891904, user_data = 0x1}, {pos = 912892308, events = 8, fd = 0, user_data = 0x8210346f0}, {pos = 717890924, events = 8, fd = 1, user_data = 0x83669a000}, {pos = 553862944, events = 8, fd = 717887234, user_data = 0x82c953170 }, {pos = 12072904, events = 0, fd = 747975024, user_data = 0x821cef408}, {pos = 553863168, events = 8, fd = -1597017122, user_data = 0x8366b8800}, {pos = 1, events = 0, fd = -1597017506, user_data = 0x821ce8008}, {pos = 553862952, events = 8, fd = 553863168, user_data = 0x1c38}, {pos = 912965312, events = 8, fd = -1596937840, user_data = 0x0}, {pos = 553845631, events = 8, fd = 7886951, user_data = 0x8210347b0}, {pos = 717849616, events = 8, fd = 748638256, user_data = 0x82c9f7310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8210347e0}, {pos = 717892509, events = 8, fd = 912891904, user_data = 0x1b8a}, {pos = 553863232, events = 8, fd = 717859066, user_data = 0x0}, {pos = 0, events = 0, fd = 852546570, user_data = 0x0}} [04:20:33.537] last_touch_time = 1724559372 [04:20:33.537] last_lockfile_recheck_time = 1724559372 [04:20:33.537] nevents = 1 [04:20:33.537] #22 0x00000000008568e5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821034e28) at ../src/backend/postmaster/postmaster.c:1346 [04:20:33.537] userDoption = [04:20:33.537] listen_addr_saved = [04:20:33.537] output_config_variable = [04:20:33.537] opt = [04:20:33.537] status = [04:20:33.537] #23 0x000000000079256c in main (argc=4, argv=0x821034e28) at ../src/backend/main/main.c:197 [04:20:33.537] do_check_root = [04:20:33.549] [04:20:33.549] [04:20:33.549] [04:20:33.610] dumping /tmp/cores/postgres.15535.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:20:33.731] [New LWP 101768] [04:20:33.792] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [04:20:33.792] Program terminated with signal SIGABRT, Aborted. [04:20:33.792] Sent by thr_kill() from pid 15535 and user 1003. [04:20:33.792] #0 0x000000082ccde41a in thr_kill () from /lib/libc.so.7 [04:20:34.369] [04:20:34.369] Thread 1 (LWP 101768): [04:20:34.369] #0 0x000000082ccde41a in thr_kill () from /lib/libc.so.7 [04:20:34.369] No symbol table info available. [04:20:34.369] #1 0x000000082cc57e64 in raise () from /lib/libc.so.7 [04:20:34.369] No symbol table info available. [04:20:34.369] #2 0x000000082cd086f9 in abort () from /lib/libc.so.7 [04:20:34.369] No symbol table info available. [04:20:34.369] #3 0x0000000000a58fe5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [04:20:34.369] No locals. [04:20:34.369] #4 0x000000000073d37f in ExecFetchSlotHeapTuple (slot=0x8214faaf0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [04:20:34.369] No locals. [04:20:34.369] #5 0x0000000000702037 in ExecIRDeleteTriggers (estate=estate@entry=0x838bbc100, relinfo=relinfo@entry=0x838bbc6b0, slot=slot@entry=0x8214faaf0) at ../src/backend/commands/trigger.c:2841 [04:20:34.369] trigger = [04:20:34.369] oldtuple = [04:20:34.369] should_free = false [04:20:34.369] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83fa7c5a0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [04:20:34.369] trigdesc = 0x838bbc8c0 [04:20:34.369] newtuple = 0x0 [04:20:34.369] i = 0 [04:20:34.369] #6 0x0000000000762557 in ExecMergeMatched (context=0x8214fab98, resultRelInfo=0x838bbc6b0, tupleid=0x0, oldtuple=0x8214faaf0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [04:20:34.369] result = TM_Ok [04:20:34.369] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [04:20:34.369] relaction = 0x83e9959f8 [04:20:34.369] commandType = CMD_DELETE [04:20:34.369] l__state = {l = 0x83e995fb8, i = 0} [04:20:34.369] mtstate = 0x838bbc4a0 [04:20:34.369] newslot = 0x0 [04:20:34.369] rslot = 0x0 [04:20:34.369] estate = 0x838bbc100 [04:20:34.369] mergeActions = [04:20:34.369] econtext = 0x83e995028 [04:20:34.369] epqstate = 0x838bbc588 [04:20:34.369] actionStates = 0x83e995fb8 [04:20:34.369] l = [04:20:34.369] isNull = [04:20:34.369] lmerge_matched = [04:20:34.369] __error = [04:20:34.369] l__state = [04:20:34.369] result = [04:20:34.369] updateCxt = [04:20:34.369] relaction = [04:20:34.369] commandType = [04:20:34.369] __error = [04:20:34.369] resultRelationDesc = [04:20:34.369] lockmode = [04:20:34.369] inputslot = [04:20:34.369] epqslot = [04:20:34.369] was_matched = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] #7 ExecMerge (context=0x8214fab98, resultRelInfo=0x838bbc6b0, tupleid=0x0, oldtuple=0x8214faaf0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [04:20:34.369] matched = [04:20:34.369] rslot = 0x0 [04:20:34.369] #8 ExecModifyTable (pstate=0x838bbc4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [04:20:34.369] context = {mtstate = 0x838bbc4a0, epqstate = 0x838bbc588, estate = 0x838bbc100, planSlot = 0x838bf6bb0, tmfd = {ctid = {ip_blkid = {bi_hi = 44430, bi_lo = 11469}, ip_posid = 8}, xmax = 158, cmax = 0, traversed = 172}, cpUpdateReturningSlot = 0xda9bc3be204340e9} [04:20:34.369] tuple_ctid = {ip_blkid = {bi_hi = 43968, bi_lo = 8527}, ip_posid = 8} [04:20:34.369] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83e89a118} [04:20:34.369] node = 0x838bbc4a0 [04:20:34.369] estate = 0x838bbc100 [04:20:34.369] operation = CMD_MERGE [04:20:34.369] resultRelInfo = 0x838bbc6b0 [04:20:34.369] subplanstate = 0x838bbddf0 [04:20:34.369] slot = [04:20:34.369] tupleid = 0x0 [04:20:34.369] oldtuple = 0x8214faaf0 [04:20:34.369] oldSlot = [04:20:34.369] #9 0x000000000072f5eb in ExecProcNode (node=0x838bbc4a0) at ../src/include/executor/executor.h:278 [04:20:34.369] No locals. [04:20:34.369] #10 ExecutePlan (estate=0x838bbc100, planstate=0x838bbc4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x838b82f10, execute_once=) at ../src/backend/executor/execMain.c:1641 [04:20:34.369] current_tuple_count = 0 [04:20:34.369] slot = [04:20:34.369] #11 standard_ExecutorRun (queryDesc=0x838ae0c48, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [04:20:34.369] estate = 0x838bbc100 [04:20:34.369] oldcontext = 0x838b82c00 [04:20:34.369] operation = CMD_MERGE [04:20:34.369] dest = 0x838b82f10 [04:20:34.369] sendTuples = true [04:20:34.369] #12 0x000000083aca2961 in pgss_ExecutorRun (queryDesc=0x838ae0c48, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [04:20:34.369] _local_sigjmp_buf = {{_sjb = {35346065713, 1, 34918608072, 34918608240, 12139128, 34918608080, 1, 35310668872, 34918564735, 7610689, 35311566848, 34359738368}}} [04:20:34.369] _save_exception_stack = 0x8214fae80 [04:20:34.369] _save_context_stack = 0x0 [04:20:34.369] _do_rethrow = false [04:20:34.369] #13 0x00000000009042bf in ProcessQuery (plan=0x83e9b8000, sourceText=, params=0x0, queryEnv=0x0, dest=0x838b82f10, qc=0x8214fae48) at ../src/backend/tcop/pquery.c:160 [04:20:34.369] queryDesc = 0x838ae0c48 [04:20:34.369] #14 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x838b29100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x838b82f10, altdest=0xb4a9c0 , qc=qc@entry=0x8214fae48) at ../src/backend/tcop/pquery.c:1287 [04:20:34.369] pstmt = 0x83e9b8000 [04:20:34.369] stmtlist_item__state = {l = 0x83e9bc8b8, i = 0} [04:20:34.369] active_snapshot_set = true [04:20:34.369] stmtlist_item = 0x83e9bc8d0 [04:20:34.369] #15 0x000000000090336c in FillPortalStore (portal=portal@entry=0x838b29100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [04:20:34.369] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:20:34.369] treceiver = 0x838b82f10 [04:20:34.369] #16 0x00000000009030db in PortalRun (portal=portal@entry=0x838b29100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83e9bc908, altdest=altdest@entry=0x83e9bc908, qc=0x8214faf80) at ../src/backend/tcop/pquery.c:763 [04:20:34.369] _local_sigjmp_buf = {{_sjb = {9449597, 35310964992, 34918608504, 34918608736, 34918608512, 35311058944, 12105816, 12139128, 35310928767, 35310285056, 4294967984, 0}}} [04:20:34.369] _save_exception_stack = 0x8214fb050 [04:20:34.369] _save_context_stack = 0x0 [04:20:34.369] _do_rethrow = false [04:20:34.369] saveTopTransactionResourceOwner = 0x838b6f118 [04:20:34.369] saveTopTransactionContext = 0x838b40000 [04:20:34.369] saveActivePortal = 0x0 [04:20:34.369] saveResourceOwner = 0x838b6f118 [04:20:34.369] savePortalContext = 0x0 [04:20:34.369] saveMemoryContext = 0x838b40000 [04:20:34.369] result = [04:20:34.369] nprocessed = [04:20:34.369] #17 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x838a83100 "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 [04:20:34.369] cmdtaglen = 5 [04:20:34.369] snapshot_set = [04:20:34.369] per_parsetree_context = 0x0 [04:20:34.369] plantree_list = [04:20:34.369] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:20:34.369] format = 0 [04:20:34.369] parsetree = 0x83e96f5a8 [04:20:34.369] commandTag = [04:20:34.369] cmdtagname = [04:20:34.369] querytree_list = [04:20:34.369] portal = 0x838b29100 [04:20:34.369] receiver = 0x83e9bc908 [04:20:34.369] parsetree_item__state = {l = 0x83e970e70, i = 0} [04:20:34.369] msec_str = "\000\000\000\000\b", '\000' , "<\260\312f\000\000\000\000+\257\351\202\331&SS" [04:20:34.369] dest = DestRemote [04:20:34.369] was_logged = [04:20:34.369] oldcontext = 0x838b40000 [04:20:34.369] parsetree_list = 0x83e970e70 [04:20:34.369] use_implicit_block = false [04:20:34.369] parsetree_item = 0x83e970e88 [04:20:34.369] save_log_statement_stats = [04:20:34.369] #18 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [04:20:34.369] query_string = 0x838a83100 "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"... [04:20:34.369] input_message = {data = 0x838a83100 "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} [04:20:34.369] firstchar = [04:20:34.369] local_sigjmp_buf = {{_sjb = {9433510, 34918608976, 34918608936, 34918609520, 12147864, 1, 8192, 8388608, 895, 0, 0, 1}}} [04:20:34.369] send_ready_for_query = false [04:20:34.369] idle_in_transaction_timeout_enabled = false [04:20:34.369] idle_session_timeout_enabled = false [04:20:34.369] #19 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:20:34.369] bsdata = [04:20:34.369] #20 0x0000000000854707 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8214fbd94 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214fbcd0) at ../src/backend/postmaster/launch_backend.c:274 [04:20:34.369] pid = [04:20:34.369] #21 0x0000000000858ac8 in BackendStartup (client_sock=0x8214fbcd0) at ../src/backend/postmaster/postmaster.c:3414 [04:20:34.369] startup_data = {canAcceptConnections = CAC_OK} [04:20:34.369] bn = 0x838a8f3f8 [04:20:34.369] pid = [04:20:34.369] __error = [04:20:34.369] save_errno = [04:20:34.369] __error = [04:20:34.369] __error = [04:20:34.369] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [04:20:34.369] 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 = " <\2508\b", '\000' , "0\275O!\b\000\000\000h\025\300*\b\000\000\000\v\000\000\000\000\000\000\000^\237\300*\b", '\000' , "p\275O!\b\000\000\000\264D\205\000\000\000\000\000\200\275O!\b", '\000' }, salen = 16}} [04:20:34.369] i = 0 [04:20:34.369] now = [04:20:34.369] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 751316098, events = 8, fd = 0, user_data = 0x8214fbc80}, {pos = 950973912, events = 8, fd = 558873360, user_data = 0x0}, {pos = 972276490, events = 2446, fd = 750483360, user_data = 0x82cbc8d78}, {pos = 558872456, events = 8, fd = 558872576, user_data = 0x8214fb788}, {pos = 972276490, events = 2446, fd = 750461832, user_data = 0x82cbc8d78}, {pos = 558872504, events = 8, fd = 558872624, user_data = 0x8214fb7b8}, {pos = 750522772, events = 8, fd = 564605960, user_data = 0x82cbc1194}, {pos = 558872608, events = 8, fd = 972256314, user_data = 0x8214fb7c0}, {pos = 717222928, events = 8, fd = 752345136, user_data = 0x98e39f3c30a}, {pos = 750430296, events = 8, fd = 750554488, user_data = 0x8214fb828}, {pos = 558872736, events = 8, fd = 558872616, user_data = 0x82cbbfd0c}, {pos = 564605960, events = 8, fd = 750517516, user_data = 0x8214fb890}, {pos = 972256314, events = 2446, fd = 558872760, user_data = 0x8214fba88}, {pos = 558872736, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821a79038}, {pos = 1, events = 3667641278, fd = 564605960, user_data = 0x82cbb2388}, {pos = 564627400, events = 8, fd = 0, user_data = 0x0}, {pos = 558872872, events = 8, fd = 558873336, user_data = 0x8214fb910}, {pos = 972274850, events = 2446, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 3667641278, fd = 564629560, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8214fbbf8}, {pos = 564605960, events = 3, fd = 558873408, user_data = 0x821a78828}, {pos = 656, events = 0, fd = 558873336, user_data = 0x8214fb928}, {pos = 558872976, events = 8, fd = 972274459, user_data = 0x8214fbac0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 564629560, events = 8, fd = 1, user_data = 0x821a73408}, {pos = 750430296, events = 8, fd = 558873592, user_data = 0x8214fbb40}, {pos = 558872992, events = 8, fd = 0, user_data = 0x821a6c008}, {pos = 33, events = 0, fd = 558873392, user_data = 0x98e39f35ae7}, {pos = 564576264, events = 8, fd = 564577288, user_data = 0x821a6c808}, {pos = 564579336, events = 8, fd = 564592648, user_data = 0x821a70408}, {pos = 564594696, events = 8, fd = 564595720, user_data = 0x821a71008}, {pos = 564597768, events = 8, fd = 564598792, user_data = 0x821a71c08}, {pos = 564600840, events = 8, fd = 564601864, user_data = 0x821a72808}, {pos = 564603912, events = 8, fd = 564604936, user_data = 0x821a73408}, {pos = 564606984, events = 8, fd = 564608008, user_data = 0x821a74008}, {pos = 564610056, events = 8, fd = 564611080, user_data = 0x821a74c08}, {pos = 564613128, events = 8, fd = 564614152, user_data = 0x821a75808}, {pos = 564616200, events = 8, fd = 564621320, user_data = 0x821a77408}, {pos = 564623368, events = 8, fd = 564624392, user_data = 0x821a7a408}, {pos = 671859000, events = 0, fd = 564576264, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821a79038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558873592, events = 8, fd = 558872992, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 564629560, user_data = 0x1}, {pos = 564576264, events = 8, fd = 314, user_data = 0x8214fbbe0}, {pos = 972248559, events = 2446, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564629560, user_data = 0x1}, {pos = 564605960, events = 8, fd = 950480896, user_data = 0x1}, {pos = 950481300, events = 8, fd = 0, user_data = 0x8214fbbb0}, {pos = 717264236, events = 8, fd = 1, user_data = 0x838a73000}, {pos = 558873568, events = 8, fd = 717260546, user_data = 0x82ccdc170 }, {pos = 12072904, events = 0, fd = 751681904, user_data = 0x821a73408}, {pos = 558873792, events = 8, fd = 972248030, user_data = 0x838a91800}, {pos = 1, events = 0, fd = 972247646, user_data = 0x821a6c008}, {pos = 558873576, events = 8, fd = 558873792, user_data = 0x1c38}, {pos = 950549536, events = 8, fd = 972327312, user_data = 0x0}, {pos = 558826367, events = 8, fd = 7886951, user_data = 0x8214fbc70}, {pos = 717222928, events = 8, fd = 752345136, user_data = 0x82cd80310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214fbca0}, {pos = 717265821, events = 8, fd = 950480896, user_data = 0x3471}, {pos = 558873856, events = 8, fd = 717232378, user_data = 0x0}, {pos = 0, events = 0, fd = 541278441, user_data = 0x0}} [04:20:34.369] last_touch_time = 1724559406 [04:20:34.369] last_lockfile_recheck_time = 1724559406 [04:20:34.369] nevents = 1 [04:20:34.369] #23 0x00000000008568e5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8214fc2e8) at ../src/backend/postmaster/postmaster.c:1346 [04:20:34.369] userDoption = [04:20:34.369] listen_addr_saved = [04:20:34.369] output_config_variable = [04:20:34.369] opt = [04:20:34.369] status = [04:20:34.369] #24 0x000000000079256c in main (argc=4, argv=0x8214fc2e8) at ../src/backend/main/main.c:197 [04:20:34.369] do_check_root =