[14:43:11.785] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [14:43:12.195] dumping /tmp/cores/postgres.8221.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [14:43:12.340] [New LWP 101744] [14:43:12.433] Core was generated by `postgres: postgres regression [local] MERGE'. [14:43:12.433] Program terminated with signal SIGABRT, Aborted. [14:43:12.433] Sent by thr_kill() from pid 8221 and user 1003. [14:43:12.433] #0 0x000000082b871dca in thr_kill () from /lib/libc.so.7 [14:43:13.075] [14:43:13.075] Thread 1 (LWP 101744): [14:43:13.075] #0 0x000000082b871dca in thr_kill () from /lib/libc.so.7 [14:43:13.075] No symbol table info available. [14:43:13.075] #1 0x000000082b7ea6f4 in raise () from /lib/libc.so.7 [14:43:13.075] No symbol table info available. [14:43:13.075] #2 0x000000082b89bbc9 in abort () from /lib/libc.so.7 [14:43:13.075] No symbol table info available. [14:43:13.075] #3 0x0000000000a5cf47 in ExceptionalCondition (conditionName=, fileName=0x372d41 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [14:43:13.075] No locals. [14:43:13.075] #4 0x000000000073f8b0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821034c10, materialize=, shouldFree=shouldFree@entry=0x821034bb6) at ../src/backend/executor/execTuples.c:1737 [14:43:13.075] No locals. [14:43:13.075] #5 0x0000000000705aa8 in ExecIRDeleteTriggers (estate=estate@entry=0x8343d7100, relinfo=relinfo@entry=0x8343d76b0, slot=slot@entry=0x821034c10) at ../src/backend/commands/trigger.c:2841 [14:43:13.075] trigger = [14:43:13.075] oldtuple = [14:43:13.075] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x835f1a518, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [14:43:13.075] trigdesc = 0x8343d78c0 [14:43:13.075] newtuple = 0x0 [14:43:13.075] i = 0 [14:43:13.075] should_free = false [14:43:13.075] #6 0x00000000007649aa in ExecMergeMatched (context=0x821034cd0, resultRelInfo=0x8343d76b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [14:43:13.075] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [14:43:13.075] relaction = 0x835f82be0 [14:43:13.075] commandType = CMD_DELETE [14:43:13.075] result = TM_Ok [14:43:13.075] l__state = {l = 0x836061888, i = 0} [14:43:13.075] mtstate = 0x8343d74a0 [14:43:13.075] newslot = 0x0 [14:43:13.075] rslot = 0x0 [14:43:13.075] estate = 0x18d70 [14:43:13.075] mergeActions = [14:43:13.075] econtext = 0x836060928 [14:43:13.075] epqstate = 0x8343d7588 [14:43:13.075] actionStates = 0x836061888 [14:43:13.075] l = [14:43:13.075] isNull = [14:43:13.075] lmerge_matched = [14:43:13.075] __error = [14:43:13.075] l__state = [14:43:13.075] updateCxt = [14:43:13.075] relaction = [14:43:13.075] commandType = [14:43:13.075] result = [14:43:13.075] __error = [14:43:13.075] resultRelationDesc = [14:43:13.075] lockmode = [14:43:13.075] inputslot = [14:43:13.075] epqslot = [14:43:13.075] was_matched = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] #7 ExecMerge (context=0x821034cd0, resultRelInfo=0x8343d76b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [14:43:13.075] matched = [14:43:13.075] rslot = 0x0 [14:43:13.075] #8 ExecModifyTable (pstate=0x8343d74a0) at ../src/backend/executor/nodeModifyTable.c:4112 [14:43:13.075] context = {mtstate = 0x8343d74a0, epqstate = 0x8343d7588, estate = 0x8343d7100, planSlot = 0x835f82b50, tmfd = {ctid = {ip_blkid = {bi_hi = 59264, bi_lo = 13832}, ip_posid = 8}, xmax = 876443312, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x8343d7100} [14:43:13.075] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [14:43:13.075] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835f50118} [14:43:13.075] node = 0x8343d74a0 [14:43:13.075] estate = 0x8343d7100 [14:43:13.075] operation = CMD_MERGE [14:43:13.075] resultRelInfo = 0x8343d76b0 [14:43:13.075] subplanstate = 0x8343d8df0 [14:43:13.075] slot = [14:43:13.075] tupleid = 0x0 [14:43:13.075] oldtuple = 0x0 [14:43:13.075] oldSlot = [14:43:13.075] #9 0x000000000073994b in ExecProcNodeFirst (node=0x8343d74a0) at ../src/backend/executor/execProcnode.c:464 [14:43:13.075] No locals. [14:43:13.075] #10 0x0000000000731c3a in ExecProcNode (node=0x8343d74a0) at ../src/include/executor/executor.h:274 [14:43:13.075] No locals. [14:43:13.075] #11 ExecutePlan (estate=0x8343d7100, planstate=0x8343d74a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8343b5b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [14:43:13.075] current_tuple_count = [14:43:13.075] slot = [14:43:13.075] #12 standard_ExecutorRun (queryDesc=0x8342b9448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [14:43:13.075] estate = 0x8343d7100 [14:43:13.075] oldcontext = 0x8343b5800 [14:43:13.075] operation = CMD_MERGE [14:43:13.075] dest = 0x8343b5b10 [14:43:13.075] sendTuples = true [14:43:13.075] #13 0x0000000000731aef in ExecutorRun (queryDesc=0x18d70, queryDesc@entry=0x8342b9448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [14:43:13.075] No locals. [14:43:13.075] #14 0x000000000090a91f in ProcessQuery (plan=0x83608bc60, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821034ee8) at ../src/backend/tcop/pquery.c:160 [14:43:13.075] queryDesc = 0x8342b9448 [14:43:13.075] #15 0x0000000000909ebd in PortalRunMulti (portal=portal@entry=0x8342ec100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8343b5b10, altdest=0xb50ff0 , qc=qc@entry=0x821034ee8) at ../src/backend/tcop/pquery.c:1286 [14:43:13.075] pstmt = 0x83608bc60 [14:43:13.075] stmtlist_item__state = {l = 0x836090518, i = 0} [14:43:13.075] active_snapshot_set = true [14:43:13.075] stmtlist_item = 0x836090530 [14:43:13.075] #16 0x00000000009099ac in FillPortalStore (portal=portal@entry=0x8342ec100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [14:43:13.075] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:43:13.075] treceiver = 0x8343b5b10 [14:43:13.075] #17 0x0000000000909700 in PortalRun (portal=portal@entry=0x8342ec100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x836090568, altdest=altdest@entry=0x836090568, qc=0x821035020) at ../src/backend/tcop/pquery.c:763 [14:43:13.075] _local_sigjmp_buf = {{_sjb = {9475743, 35235267416, 34913603352, 34913603584, 34913603360, 12163752, 12131536, 35235217664, 7112098687, 35235225856, 3578801, 34359738368}}} [14:43:13.075] _save_exception_stack = 0x8210350f0 [14:43:13.075] _save_context_stack = 0x0 [14:43:13.075] _do_rethrow = false [14:43:13.075] saveTopTransactionResourceOwner = 0x8342f8358 [14:43:13.075] saveTopTransactionContext = 0x834222000 [14:43:13.075] saveActivePortal = 0x0 [14:43:13.075] saveResourceOwner = 0x8342f8358 [14:43:13.075] savePortalContext = 0x0 [14:43:13.075] saveMemoryContext = 0x834222000 [14:43:13.075] result = [14:43:13.075] nprocessed = [14:43:13.075] #18 0x000000000090860b in exec_simple_query (query_string=query_string@entry=0x834216100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [14:43:13.075] cmdtaglen = [14:43:13.075] snapshot_set = [14:43:13.075] per_parsetree_context = 0x0 [14:43:13.075] plantree_list = [14:43:13.075] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:43:13.075] parsetree = 0x83602e3e8 [14:43:13.075] commandTag = CMDTAG_MERGE [14:43:13.075] cmdtagname = [14:43:13.075] querytree_list = [14:43:13.075] portal = 0x8342ec100 [14:43:13.075] format = 0 [14:43:13.075] receiver = 0x836090568 [14:43:13.075] parsetree_item__state = {l = 0x83602fcb0, i = 0} [14:43:13.075] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [14:43:13.075] dest = DestRemote [14:43:13.075] was_logged = [14:43:13.075] oldcontext = 0x834222000 [14:43:13.075] parsetree_list = 0x83602fcb0 [14:43:13.075] use_implicit_block = false [14:43:13.075] parsetree_item = 0x83602fcc8 [14:43:13.075] save_log_statement_stats = [14:43:13.075] #19 0x00000000009063e4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [14:43:13.075] query_string = 0x834216100 "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"... [14:43:13.075] input_message = {data = 0x834216100 "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} [14:43:13.075] firstchar = [14:43:13.075] local_sigjmp_buf = {{_sjb = {9459888, 34913603824, 34913603784, 34913604384, 12172488, 12118960, 8192, 8388608, 72057628951511935, 0, 0, 34359738369}}} [14:43:13.075] send_ready_for_query = false [14:43:13.075] idle_in_transaction_timeout_enabled = false [14:43:13.075] idle_session_timeout_enabled = false [14:43:13.075] #20 0x0000000000900eb9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [14:43:13.075] bsdata = [14:43:13.075] #21 0x000000000085ad92 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821035e30 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821035d78) at ../src/backend/postmaster/launch_backend.c:265 [14:43:13.075] pid = [14:43:13.075] #22 0x000000000085f6f1 in BackendStartup (client_sock=0x821035d78) at ../src/backend/postmaster/postmaster.c:3593 [14:43:13.075] startup_data = {canAcceptConnections = CAC_OK} [14:43:13.075] bn = 0x834222308 [14:43:13.075] pid = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] save_errno = [14:43:13.075] __error = [14:43:13.075] __error = [14:43:13.075] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [14:43:13.075] 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' , "\320]\003!\b\000\000\000\3305g)\b\000\000\000\v\000\000\000\000\000\000\000\016\266g)\b", '\000' , "\020^\003!\b\000\000\000d\253\205\000\000\000\000\000 ^\003!\b", '\000' }, salen = 16}} [14:43:13.075] i = 0 [14:43:13.075] now = [14:43:13.075] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 729132132, events = 8, fd = 553866176, user_data = 0x821035550}, {pos = 563508232, events = 8, fd = 32, user_data = 0x821035540}, {pos = -337073516, events = 1742, fd = 563478536, user_data = 0x821960408}, {pos = 563480584, events = 8, fd = 563481608, user_data = 0x821964008}, {pos = 563495944, events = 8, fd = 563496968, user_data = 0x821964c08}, {pos = 563499016, events = 8, fd = 563500040, user_data = 0x821965808}, {pos = 563502088, events = 8, fd = 563503112, user_data = 0x821966408}, {pos = 563505160, events = 8, fd = 563506184, user_data = 0x821967008}, {pos = 563508232, events = 8, fd = -1, user_data = 0x82b9322e0}, {pos = 553866416, events = 8, fd = 730722729, user_data = 0x0}, {pos = 4096, events = 0, fd = -1425892593, user_data = 0x82b9327e8}, {pos = 868260832, events = 8, fd = 160, user_data = 0x0}, {pos = 838246544, events = 8, fd = 553866624, user_data = 0x82b8bd92c}, {pos = 4096, events = 0, fd = 729147748, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 563534392, user_data = 0x800000001}, {pos = 563508232, events = 8, fd = 729061592, user_data = 0x821035608}, {pos = 553866176, events = 8, fd = 32, user_data = 0x82b75ac64}, {pos = 563508232, events = 8, fd = 563534392, user_data = 0x0}, {pos = 2625, events = 0, fd = 553866736, user_data = 0x6ceebe8a645}, {pos = 729147748, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 563534392, events = 8, fd = 1, user_data = 0x821967408}, {pos = 874536960, events = 8, fd = 1, user_data = 0x834206194}, {pos = 0, events = 0, fd = 553866688, user_data = 0x82967ac0c}, {pos = 1, events = 0, fd = 874536960, user_data = 0x8210355f0}, {pos = 694656692, events = 8, fd = 730874208, user_data = 0x82b904160 }, {pos = 729243840, events = 8, fd = 563508232, user_data = 0x8210356d0}, {pos = -337075156, events = 1742, fd = 838246544, user_data = 0x800000001}, {pos = -337075538, events = 1742, fd = 12240, user_data = 0x8210355f8}, {pos = 553866960, events = 8, fd = 875243496, user_data = 0x821035c40}, {pos = -336994672, events = 1742, fd = 563508232, user_data = 0x82103037f}, {pos = 730531228, events = 8, fd = 563478536, user_data = 0x0}, {pos = 563508232, events = 8, fd = 12240, user_data = 0x82b73a000}, {pos = 1964368, events = 0, fd = 730874208, user_data = 0x82b75ac64}, {pos = 15616, events = 0, fd = 553868144, user_data = 0x821035740}, {pos = 729805198, events = 8, fd = 730912824, user_data = 0x821035704}, {pos = 874980826, events = 8, fd = 553868144, user_data = 0x821035740}, {pos = 729896453, events = 8, fd = 553867010, user_data = 0x821035b70}, {pos = 553868144, events = 8, fd = 0, user_data = 0x9548da9ab029b0f}, {pos = 553868144, events = 8, fd = 874980824, user_data = 0x821035c40}, {pos = 730912824, events = 8, fd = 0, user_data = 0x821035bb0}, {pos = 729896717, events = 8, fd = 0, user_data = 0x0}, {pos = 553868512, events = 8, fd = 874980824, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -337046519, events = 1742, fd = 553867416, user_data = 0x82b75ac64}, {pos = 2503, events = 0, fd = -337046519, user_data = 0x8210358b8}, {pos = 729132132, events = 8, fd = 2758, user_data = 0x82b754120}, {pos = 553867320, events = 8, fd = 563508232, user_data = 0x8210358b8}, {pos = 729104672, events = 8, fd = 553867424, user_data = 0x6ceebe8c465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b9260f0}, {pos = 729064784, events = 8, fd = 0, user_data = 0x0}, {pos = 730941872, events = 8, fd = -337046519, user_data = 0x821035948}, {pos = 729132132, events = 8, fd = 2924, user_data = 0x82b7543b8}, {pos = 553867464, events = 8, fd = 563508232, user_data = 0x821035948}, {pos = 729105336, events = 8, fd = 553867568, user_data = 0x6ceebe8c465}, {pos = 563531832, events = 8, fd = 2675086, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 563508232, events = 8, fd = 729064784, user_data = 0x821035c08}, {pos = 563508232, events = 8, fd = 553868008, user_data = 0x1e}, {pos = 729068768, events = 8, fd = 553867736, user_data = 0x82196c248}, {pos = 553868184, events = 8, fd = 553867712, user_data = 0x6ceebe90da3}, {pos = 563531832, events = 8, fd = 2698774, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 563531832, user_data = 0x1}} [14:43:13.076] last_touch_time = 1713278410 [14:43:13.076] last_lockfile_recheck_time = 1713278410 [14:43:13.076] nevents = 1 [14:43:13.076] #24 0x000000000085cfc6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821036370) at ../src/backend/postmaster/postmaster.c:1372 [14:43:13.076] userDoption = [14:43:13.076] listen_addr_saved = false [14:43:13.076] output_config_variable = [14:43:13.076] opt = [14:43:13.076] status = [14:43:13.076] #25 0x0000000000794eb5 in main (argc=8, argv=0x821036370) at ../src/backend/main/main.c:197 [14:43:13.076] do_check_root = [14:43:13.089] [14:43:13.089] [14:43:13.089] [14:43:13.155] dumping /tmp/cores/postgres.8946.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [14:43:13.284] [New LWP 101717] [14:43:13.351] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [14:43:13.351] Program terminated with signal SIGABRT, Aborted. [14:43:13.351] Sent by thr_kill() from pid 8946 and user 1003. [14:43:13.351] #0 0x000000082ca32dca in thr_kill () from /lib/libc.so.7 [14:43:13.967] [14:43:13.967] Thread 1 (LWP 101717): [14:43:13.967] #0 0x000000082ca32dca in thr_kill () from /lib/libc.so.7 [14:43:13.967] No symbol table info available. [14:43:13.967] #1 0x000000082c9ab6f4 in raise () from /lib/libc.so.7 [14:43:13.967] No symbol table info available. [14:43:13.967] #2 0x000000082ca5cbc9 in abort () from /lib/libc.so.7 [14:43:13.967] No symbol table info available. [14:43:13.967] #3 0x0000000000a5cf47 in ExceptionalCondition (conditionName=, fileName=0x372d41 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [14:43:13.967] No locals. [14:43:13.967] #4 0x000000000073f8b0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8215eabe0, materialize=, shouldFree=shouldFree@entry=0x8215eab86) at ../src/backend/executor/execTuples.c:1737 [14:43:13.967] No locals. [14:43:13.967] #5 0x0000000000705aa8 in ExecIRDeleteTriggers (estate=estate@entry=0x8365c5100, relinfo=relinfo@entry=0x8365c56b0, slot=slot@entry=0x8215eabe0) at ../src/backend/commands/trigger.c:2841 [14:43:13.967] trigger = [14:43:13.967] oldtuple = [14:43:13.967] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x842582d60, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [14:43:13.967] trigdesc = 0x8365c58c0 [14:43:13.967] newtuple = 0x0 [14:43:13.967] i = 0 [14:43:13.967] should_free = false [14:43:13.967] #6 0x00000000007649aa in ExecMergeMatched (context=0x8215eaca0, resultRelInfo=0x8365c56b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [14:43:13.967] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [14:43:13.967] relaction = 0x84260a1a0 [14:43:13.967] commandType = CMD_DELETE [14:43:13.967] result = TM_Ok [14:43:13.967] l__state = {l = 0x8426902c8, i = 0} [14:43:13.967] mtstate = 0x8365c54a0 [14:43:13.967] newslot = 0x0 [14:43:13.967] rslot = 0x0 [14:43:13.967] estate = 0x18d55 [14:43:13.967] mergeActions = [14:43:13.967] econtext = 0x84268f368 [14:43:13.967] epqstate = 0x8365c5588 [14:43:13.967] actionStates = 0x8426902c8 [14:43:13.967] l = [14:43:13.967] isNull = [14:43:13.967] lmerge_matched = [14:43:13.967] __error = [14:43:13.967] l__state = [14:43:13.967] updateCxt = [14:43:13.967] relaction = [14:43:13.967] commandType = [14:43:13.967] result = [14:43:13.967] __error = [14:43:13.967] resultRelationDesc = [14:43:13.967] lockmode = [14:43:13.967] inputslot = [14:43:13.967] epqslot = [14:43:13.967] was_matched = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] #7 ExecMerge (context=0x8215eaca0, resultRelInfo=0x8365c56b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [14:43:13.967] matched = [14:43:13.967] rslot = 0x0 [14:43:13.967] #8 ExecModifyTable (pstate=0x8365c54a0) at ../src/backend/executor/nodeModifyTable.c:4112 [14:43:13.967] context = {mtstate = 0x8365c54a0, epqstate = 0x8365c5588, estate = 0x8365c5100, planSlot = 0x84260a110, tmfd = {ctid = {ip_blkid = {bi_hi = 62400, bi_lo = 17003}, ip_posid = 8}, xmax = 912021168, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x8365c5100} [14:43:13.967] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [14:43:13.967] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8365d9118} [14:43:13.967] node = 0x8365c54a0 [14:43:13.967] estate = 0x8365c5100 [14:43:13.967] operation = CMD_MERGE [14:43:13.967] resultRelInfo = 0x8365c56b0 [14:43:13.967] subplanstate = 0x8365c6df0 [14:43:13.967] slot = [14:43:13.967] tupleid = 0x0 [14:43:13.967] oldtuple = 0x0 [14:43:13.967] oldSlot = [14:43:13.967] #9 0x000000000073994b in ExecProcNodeFirst (node=0x8365c54a0) at ../src/backend/executor/execProcnode.c:464 [14:43:13.967] No locals. [14:43:13.967] #10 0x0000000000731c3a in ExecProcNode (node=0x8365c54a0) at ../src/include/executor/executor.h:274 [14:43:13.967] No locals. [14:43:13.967] #11 ExecutePlan (estate=0x8365c5100, planstate=0x8365c54a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836478f10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [14:43:13.967] current_tuple_count = [14:43:13.967] slot = [14:43:13.967] #12 standard_ExecutorRun (queryDesc=0x8364de448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [14:43:13.967] estate = 0x8365c5100 [14:43:13.967] oldcontext = 0x836478c00 [14:43:13.967] operation = CMD_MERGE [14:43:13.967] dest = 0x836478f10 [14:43:13.967] sendTuples = true [14:43:13.967] #13 0x0000000000731aef in ExecutorRun (queryDesc=0x18d55, queryDesc@entry=0x8364de448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [14:43:13.967] No locals. [14:43:13.967] #14 0x000000000090a91f in ProcessQuery (plan=0x8426bc8a0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8215eaeb8) at ../src/backend/tcop/pquery.c:160 [14:43:13.967] queryDesc = 0x8364de448 [14:43:13.967] #15 0x0000000000909ebd in PortalRunMulti (portal=portal@entry=0x8364be100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836478f10, altdest=0xb50ff0 , qc=qc@entry=0x8215eaeb8) at ../src/backend/tcop/pquery.c:1286 [14:43:13.967] pstmt = 0x8426bc8a0 [14:43:13.967] stmtlist_item__state = {l = 0x8426c1158, i = 0} [14:43:13.967] active_snapshot_set = true [14:43:13.967] stmtlist_item = 0x8426c1170 [14:43:13.967] #16 0x00000000009099ac in FillPortalStore (portal=portal@entry=0x8364be100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [14:43:13.967] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:43:13.967] treceiver = 0x836478f10 [14:43:13.967] #17 0x0000000000909700 in PortalRun (portal=portal@entry=0x8364be100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8426c11a8, altdest=altdest@entry=0x8426c11a8, qc=0x8215eaff0) at ../src/backend/tcop/pquery.c:763 [14:43:13.967] _local_sigjmp_buf = {{_sjb = {9475743, 35271019864, 34919591656, 34919591888, 34919591664, 12163752, 12131536, 35270680832, 7112098687, 35270689024, 3578801, 34359738368}}} [14:43:13.967] _save_exception_stack = 0x8215eb0c0 [14:43:13.967] _save_context_stack = 0x0 [14:43:13.967] _do_rethrow = false [14:43:13.967] saveTopTransactionResourceOwner = 0x836510d58 [14:43:13.967] saveTopTransactionContext = 0x836431000 [14:43:13.967] saveActivePortal = 0x0 [14:43:13.967] saveResourceOwner = 0x836510d58 [14:43:13.967] savePortalContext = 0x0 [14:43:13.967] saveMemoryContext = 0x836431000 [14:43:13.967] result = [14:43:13.967] nprocessed = [14:43:13.967] #18 0x000000000090860b in exec_simple_query (query_string=query_string@entry=0x836425100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [14:43:13.967] cmdtaglen = [14:43:13.967] snapshot_set = [14:43:13.967] per_parsetree_context = 0x0 [14:43:13.967] plantree_list = [14:43:13.967] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:43:13.967] parsetree = 0x84265d428 [14:43:13.967] commandTag = CMDTAG_MERGE [14:43:13.967] cmdtagname = [14:43:13.967] querytree_list = [14:43:13.967] portal = 0x8364be100 [14:43:13.967] format = 0 [14:43:13.967] receiver = 0x8426c11a8 [14:43:13.967] parsetree_item__state = {l = 0x84265ecf0, i = 0} [14:43:13.967] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [14:43:13.967] dest = DestRemote [14:43:13.967] was_logged = [14:43:13.967] oldcontext = 0x836431000 [14:43:13.967] parsetree_list = 0x84265ecf0 [14:43:13.967] use_implicit_block = false [14:43:13.967] parsetree_item = 0x84265ed08 [14:43:13.967] save_log_statement_stats = [14:43:13.967] #19 0x00000000009063e4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [14:43:13.967] query_string = 0x836425100 "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"... [14:43:13.967] input_message = {data = 0x836425100 "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} [14:43:13.967] firstchar = [14:43:13.967] local_sigjmp_buf = {{_sjb = {9459888, 34919592128, 34919592088, 34919592688, 12172488, 12118960, 8192, 8388608, 72057628957475711, 0, 0, 34359738369}}} [14:43:13.967] send_ready_for_query = false [14:43:13.967] idle_in_transaction_timeout_enabled = false [14:43:13.967] idle_session_timeout_enabled = false [14:43:13.967] #20 0x0000000000900eb9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [14:43:13.967] bsdata = [14:43:13.967] #21 0x000000000085ad92 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8215ebe00 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215ebd48) at ../src/backend/postmaster/launch_backend.c:265 [14:43:13.967] pid = [14:43:13.967] #22 0x000000000085f6f1 in BackendStartup (client_sock=0x8215ebd48) at ../src/backend/postmaster/postmaster.c:3593 [14:43:13.967] startup_data = {canAcceptConnections = CAC_OK} [14:43:13.967] bn = 0x8364313a8 [14:43:13.967] pid = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] save_errno = [14:43:13.967] __error = [14:43:13.967] __error = [14:43:13.967] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [14:43:13.967] 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 = '\000' , "\240\275^!\b\000\000\000ؕ4+\b\000\000\000\v\000\000\000\000\000\000\000\016\0265+\b", '\000' , "\340\275^!\b\000\000\000d\253\205\000\000\000\000\000\360\275^!\b", '\000' }, salen = 16}} [14:43:13.967] i = 0 [14:43:13.967] now = [14:43:13.967] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 747748452, events = 8, fd = 559854480, user_data = 0x8215eb520}, {pos = 562099208, events = 8, fd = 32, user_data = 0x8215eb510}, {pos = -1331619180, events = 1330, fd = 562069512, user_data = 0x821808408}, {pos = 562071560, events = 8, fd = 562072584, user_data = 0x82180c008}, {pos = 562086920, events = 8, fd = 562087944, user_data = 0x82180cc08}, {pos = 562089992, events = 8, fd = 562091016, user_data = 0x82180d808}, {pos = 562093064, events = 8, fd = 562094088, user_data = 0x82180e408}, {pos = 562096136, events = 8, fd = 562097160, user_data = 0x82180f008}, {pos = 562099208, events = 8, fd = 562118792, user_data = 0x8215eb698}, {pos = 559854784, events = 8, fd = -1331593821, user_data = 0x0}, {pos = 2571398, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 562122808, events = 8, fd = 1, user_data = 0x82180f408}, {pos = 747656360, events = 8, fd = 559855512, user_data = 0x82180f408}, {pos = 559854768, events = 0, fd = 747764068, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 562125368, user_data = 0x1}, {pos = 562099208, events = 8, fd = 747677912, user_data = 0x8215eb5d8}, {pos = 559854480, events = 8, fd = 32, user_data = 0x82c91bc64}, {pos = 562099208, events = 8, fd = 562125368, user_data = 0x0}, {pos = 2625, events = 0, fd = 559855040, user_data = 0x532b0a11645}, {pos = 747764068, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 562125368, events = 8, fd = 1, user_data = 0x82180f408}, {pos = 910249984, events = 8, fd = 1, user_data = 0x836415194}, {pos = 0, events = 0, fd = 559854992, user_data = 0x82b350c0c}, {pos = 1, events = 0, fd = 910249984, user_data = 0x8215eb5c0}, {pos = 724893364, events = 8, fd = 749490528, user_data = 0x82cac5160 }, {pos = 747860160, events = 8, fd = 562099208, user_data = 0x8215eb6a0}, {pos = -1331620820, events = 1330, fd = 562098184, user_data = 0x800000001}, {pos = -1331621202, events = 1330, fd = 12240, user_data = 0x8215eb5c8}, {pos = 559855264, events = 8, fd = 911046632, user_data = 0x8215ebc10}, {pos = -1331540336, events = 1330, fd = 562099208, user_data = 0x8215e037f}, {pos = 749147314, events = 8, fd = 562069512, user_data = 0x0}, {pos = 562099208, events = 8, fd = 12240, user_data = 0x82c8fb000}, {pos = 1964368, events = 0, fd = 749490528, user_data = 0x82c91bc64}, {pos = 15616, events = 0, fd = 559856448, user_data = 0x8215eb710}, {pos = 748421518, events = 8, fd = 749529144, user_data = 0x8215eb6d4}, {pos = 910702042, events = 8, fd = 559856448, user_data = 0x8215eb710}, {pos = 748512773, events = 8, fd = 559855314, user_data = 0x8215ebb40}, {pos = 559856448, events = 8, fd = 0, user_data = 0x80adeed7e872727b}, {pos = 559856448, events = 8, fd = 910702040, user_data = 0x8215ebc10}, {pos = 749529144, events = 8, fd = 0, user_data = 0x8215ebb80}, {pos = 748513037, events = 8, fd = 0, user_data = 0x0}, {pos = 559856816, events = 8, fd = 910702040, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1331592183, events = 1330, fd = 559855720, user_data = 0x82c91bc64}, {pos = 2503, events = 0, fd = -1331592183, user_data = 0x8215eb888}, {pos = 747748452, events = 8, fd = 2758, user_data = 0x82c915120}, {pos = 559855624, events = 8, fd = 562099208, user_data = 0x8215eb888}, {pos = 747720992, events = 8, fd = 559855728, user_data = 0x532b0a13465}, {pos = 0, events = 0, fd = 0, user_data = 0x82cae70f0}, {pos = 747681104, events = 8, fd = 0, user_data = 0x0}, {pos = 749558192, events = 8, fd = -1331592183, user_data = 0x8215eb918}, {pos = 747748452, events = 8, fd = 2924, user_data = 0x82c9153b8}, {pos = 559855768, events = 8, fd = 562099208, user_data = 0x8215eb918}, {pos = 747721656, events = 8, fd = 559855872, user_data = 0x532b0a13465}, {pos = 562122808, events = 8, fd = 2675086, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562099208, events = 8, fd = 747681104, user_data = 0x8215ebbd8}, {pos = 562099208, events = 8, fd = 559856312, user_data = 0x1e}, {pos = 747685088, events = 8, fd = 559856040, user_data = 0x821814248}, {pos = 559856488, events = 8, fd = 559856016, user_data = 0x532b0a17da3}, {pos = 562122808, events = 8, fd = 2698774, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 562122808, user_data = 0x1}} [14:43:13.967] last_touch_time = 1713278412 [14:43:13.967] last_lockfile_recheck_time = 1713278412 [14:43:13.967] nevents = 1 [14:43:13.967] #24 0x000000000085cfc6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8215ec340) at ../src/backend/postmaster/postmaster.c:1372 [14:43:13.967] userDoption = [14:43:13.967] listen_addr_saved = false [14:43:13.967] output_config_variable = [14:43:13.967] opt = [14:43:13.967] status = [14:43:13.967] #25 0x0000000000794eb5 in main (argc=4, argv=0x8215ec340) at ../src/backend/main/main.c:197 [14:43:13.967] do_check_root = [14:43:13.979] [14:43:13.979] [14:43:13.979] [14:43:14.041] dumping /tmp/cores/postgres.14462.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [14:43:14.172] [New LWP 101774] [14:43:14.243] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [14:43:14.243] Program terminated with signal SIGABRT, Aborted. [14:43:14.243] Sent by thr_kill() from pid 14462 and user 1003. [14:43:14.243] #0 0x000000082c9b0dca in thr_kill () from /lib/libc.so.7 [14:43:14.897] [14:43:14.897] Thread 1 (LWP 101774): [14:43:14.897] #0 0x000000082c9b0dca in thr_kill () from /lib/libc.so.7 [14:43:14.897] No symbol table info available. [14:43:14.897] #1 0x000000082c9296f4 in raise () from /lib/libc.so.7 [14:43:14.897] No symbol table info available. [14:43:14.897] #2 0x000000082c9dabc9 in abort () from /lib/libc.so.7 [14:43:14.897] No symbol table info available. [14:43:14.897] #3 0x0000000000a5cf47 in ExceptionalCondition (conditionName=, fileName=0x372d41 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [14:43:14.897] No locals. [14:43:14.897] #4 0x000000000073f8b0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8217cd290, materialize=, shouldFree=shouldFree@entry=0x8217cd236) at ../src/backend/executor/execTuples.c:1737 [14:43:14.897] No locals. [14:43:14.897] #5 0x0000000000705aa8 in ExecIRDeleteTriggers (estate=estate@entry=0x8361b0100, relinfo=relinfo@entry=0x8361b06b0, slot=slot@entry=0x8217cd290) at ../src/backend/commands/trigger.c:2841 [14:43:14.897] trigger = [14:43:14.897] oldtuple = [14:43:14.897] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83b37f170, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [14:43:14.897] trigdesc = 0x8361b08c0 [14:43:14.897] newtuple = 0x0 [14:43:14.897] i = 0 [14:43:14.897] should_free = false [14:43:14.897] #6 0x00000000007649aa in ExecMergeMatched (context=0x8217cd350, resultRelInfo=0x8361b06b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [14:43:14.897] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [14:43:14.897] relaction = 0x836166ce0 [14:43:14.897] commandType = CMD_DELETE [14:43:14.897] result = TM_Ok [14:43:14.897] l__state = {l = 0x83b4c9048, i = 0} [14:43:14.897] mtstate = 0x8361b04a0 [14:43:14.897] newslot = 0x0 [14:43:14.897] rslot = 0x0 [14:43:14.897] estate = 0x18d8e [14:43:14.897] mergeActions = [14:43:14.897] econtext = 0x83b4c80e8 [14:43:14.897] epqstate = 0x8361b0588 [14:43:14.897] actionStates = 0x83b4c9048 [14:43:14.897] l = [14:43:14.897] isNull = [14:43:14.897] lmerge_matched = [14:43:14.897] __error = [14:43:14.897] l__state = [14:43:14.897] updateCxt = [14:43:14.897] relaction = [14:43:14.897] commandType = [14:43:14.897] result = [14:43:14.897] __error = [14:43:14.897] resultRelationDesc = [14:43:14.897] lockmode = [14:43:14.897] inputslot = [14:43:14.897] epqslot = [14:43:14.897] was_matched = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] #7 ExecMerge (context=0x8217cd350, resultRelInfo=0x8361b06b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [14:43:14.897] matched = [14:43:14.897] rslot = 0x0 [14:43:14.897] #8 ExecModifyTable (pstate=0x8361b04a0) at ../src/backend/executor/nodeModifyTable.c:4112 [14:43:14.897] context = {mtstate = 0x8361b04a0, epqstate = 0x8361b0588, estate = 0x8361b0100, planSlot = 0x836166c50, tmfd = {ctid = {ip_blkid = {bi_hi = 54264, bi_lo = 8572}, ip_posid = 8}, xmax = 749104624, cmax = 8, traversed = 192}, cpUpdateReturningSlot = 0x82c9ad6de} [14:43:14.897] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [14:43:14.897] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8361bc118} [14:43:14.897] node = 0x8361b04a0 [14:43:14.897] estate = 0x8361b0100 [14:43:14.897] operation = CMD_MERGE [14:43:14.897] resultRelInfo = 0x8361b06b0 [14:43:14.897] subplanstate = 0x8361b1df0 [14:43:14.897] slot = [14:43:14.897] tupleid = 0x0 [14:43:14.897] oldtuple = 0x0 [14:43:14.897] oldSlot = [14:43:14.897] #9 0x000000000073994b in ExecProcNodeFirst (node=0x8361b04a0) at ../src/backend/executor/execProcnode.c:464 [14:43:14.897] No locals. [14:43:14.897] #10 0x0000000000731c3a in ExecProcNode (node=0x8361b04a0) at ../src/include/executor/executor.h:274 [14:43:14.897] No locals. [14:43:14.897] #11 ExecutePlan (estate=0x8361b0100, planstate=0x8361b04a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836002710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [14:43:14.897] current_tuple_count = [14:43:14.897] slot = [14:43:14.897] #12 standard_ExecutorRun (queryDesc=0x8360ad448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [14:43:14.897] estate = 0x8361b0100 [14:43:14.897] oldcontext = 0x836002400 [14:43:14.897] operation = CMD_MERGE [14:43:14.897] dest = 0x836002710 [14:43:14.897] sendTuples = true [14:43:14.897] #13 0x00000008375b5963 in pgss_ExecutorRun (queryDesc=0x8360ad448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [14:43:14.897] _local_sigjmp_buf = {{_sjb = {35288471858, 12163752, 34921567368, 34921567536, 35266417736, 34921567376, 1, 1, 35267478399, 35266417736, 12172480, 34359738368}}} [14:43:14.897] _save_exception_stack = 0x8217cd650 [14:43:14.897] _save_context_stack = 0x0 [14:43:14.897] _do_rethrow = false [14:43:14.897] #14 0x0000000000731ae8 in ExecutorRun (queryDesc=0x18d8e, queryDesc@entry=0x8360ad448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [14:43:14.897] No locals. [14:43:14.897] #15 0x000000000090a91f in ProcessQuery (plan=0x83b4b1cc0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8217cd618) at ../src/backend/tcop/pquery.c:160 [14:43:14.897] queryDesc = 0x8360ad448 [14:43:14.897] #16 0x0000000000909ebd in PortalRunMulti (portal=portal@entry=0x83608f100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836002710, altdest=0xb50ff0 , qc=qc@entry=0x8217cd618) at ../src/backend/tcop/pquery.c:1286 [14:43:14.897] pstmt = 0x83b4b1cc0 [14:43:14.897] stmtlist_item__state = {l = 0x83b4b6578, i = 0} [14:43:14.897] active_snapshot_set = true [14:43:14.897] stmtlist_item = 0x83b4b6590 [14:43:14.897] #17 0x00000000009099ac in FillPortalStore (portal=portal@entry=0x83608f100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [14:43:14.897] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:43:14.897] treceiver = 0x836002710 [14:43:14.897] #18 0x0000000000909700 in PortalRun (portal=portal@entry=0x83608f100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83b4b65c8, altdest=altdest@entry=0x83b4b65c8, qc=0x8217cd750) at ../src/backend/tcop/pquery.c:763 [14:43:14.897] _local_sigjmp_buf = {{_sjb = {9475743, 35266625944, 34921567816, 34921568048, 34921567824, 12163752, 12131536, 35266294016, 7112098687, 35266302208, 3578801, 34359738368}}} [14:43:14.897] _save_exception_stack = 0x8217cd820 [14:43:14.897] _save_context_stack = 0x0 [14:43:14.897] _do_rethrow = false [14:43:14.897] saveTopTransactionResourceOwner = 0x8360e0198 [14:43:14.897] saveTopTransactionContext = 0x836000000 [14:43:14.897] saveActivePortal = 0x0 [14:43:14.897] saveResourceOwner = 0x8360e0198 [14:43:14.897] savePortalContext = 0x0 [14:43:14.897] saveMemoryContext = 0x836000000 [14:43:14.897] result = [14:43:14.897] nprocessed = [14:43:14.897] #19 0x000000000090860b in exec_simple_query (query_string=query_string@entry=0x835ff4100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [14:43:14.897] cmdtaglen = [14:43:14.897] snapshot_set = [14:43:14.897] per_parsetree_context = 0x0 [14:43:14.897] plantree_list = [14:43:14.897] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:43:14.897] parsetree = 0x83b467da8 [14:43:14.897] commandTag = CMDTAG_MERGE [14:43:14.897] cmdtagname = [14:43:14.897] querytree_list = [14:43:14.897] portal = 0x83608f100 [14:43:14.897] format = 0 [14:43:14.897] receiver = 0x83b4b65c8 [14:43:14.897] parsetree_item__state = {l = 0x83b469670, i = 0} [14:43:14.897] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [14:43:14.897] dest = DestRemote [14:43:14.897] was_logged = [14:43:14.897] oldcontext = 0x836000000 [14:43:14.897] parsetree_list = 0x83b469670 [14:43:14.897] use_implicit_block = false [14:43:14.897] parsetree_item = 0x83b469688 [14:43:14.897] save_log_statement_stats = [14:43:14.897] #20 0x00000000009063e4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [14:43:14.897] query_string = 0x835ff4100 "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"... [14:43:14.897] input_message = {data = 0x835ff4100 "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} [14:43:14.897] firstchar = [14:43:14.897] local_sigjmp_buf = {{_sjb = {9459888, 34921568288, 34921568248, 34921568848, 12172488, 12118960, 8192, 8388608, 72057628959441791, 0, 0, 1}}} [14:43:14.897] send_ready_for_query = false [14:43:14.897] idle_in_transaction_timeout_enabled = false [14:43:14.897] idle_session_timeout_enabled = false [14:43:14.897] #21 0x0000000000900eb9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [14:43:14.897] bsdata = [14:43:14.897] #22 0x000000000085ad92 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8217ce560 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8217ce4a8) at ../src/backend/postmaster/launch_backend.c:265 [14:43:14.897] pid = [14:43:14.897] #23 0x000000000085f6f1 in BackendStartup (client_sock=0x8217ce4a8) at ../src/backend/postmaster/postmaster.c:3593 [14:43:14.897] startup_data = {canAcceptConnections = CAC_OK} [14:43:14.897] bn = 0x836000678 [14:43:14.897] pid = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] save_errno = [14:43:14.897] __error = [14:43:14.897] __error = [14:43:14.897] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [14:43:14.897] 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 = '\000' , "\345|!\b\000\000\000\330\305m*\b\000\000\000\v\000\000\000\000\000\000\000\016Fn*\b", '\000' , "@\345|!\b\000\000\000d\253\205\000\000\000\000\000P\345|!\b", '\000' }, salen = 16}} [14:43:14.897] i = 0 [14:43:14.897] now = [14:43:14.897] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 561831040, events = 8, fd = 570418184, user_data = 0x21}, {pos = 561831024, events = 8, fd = -853808492, user_data = 0x821ff7008}, {pos = 570389512, events = 8, fd = 570390536, user_data = 0x821ff7c08}, {pos = 570404872, events = 8, fd = 570405896, user_data = 0x821ffb808}, {pos = 570407944, events = 8, fd = 570408968, user_data = 0x821ffc408}, {pos = 570411016, events = 8, fd = 570412040, user_data = 0x821ffd008}, {pos = 570414088, events = 8, fd = 570415112, user_data = 0x821ffdc08}, {pos = 570417160, events = 8, fd = 570418184, user_data = 0x822003088}, {pos = 561831416, events = 8, fd = 561830928, user_data = 0x2ff2cd1c4da3}, {pos = 570418184, events = 8, fd = 2571398, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 570441784, user_data = 0x1}, {pos = 570418184, events = 8, fd = 747123880, user_data = 0x8217cdef8}, {pos = 570418184, events = 8, fd = 561830896, user_data = 0x273bd0}, {pos = 561831488, events = 8, fd = 747231588, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 570444344, user_data = 0x2ff200000001}, {pos = 570418184, events = 8, fd = 747145432, user_data = 0x8217cdd38}, {pos = 561830624, events = 8, fd = 33, user_data = 0x82c899c64}, {pos = 570418184, events = 8, fd = 570444344, user_data = 0x0}, {pos = 2625, events = 0, fd = 561831200, user_data = 0x2ff2cd1be645}, {pos = 747231588, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 570444344, events = 8, fd = 1, user_data = 0x821ffe408}, {pos = 905854976, events = 8, fd = 1, user_data = 0x835fe4194}, {pos = 0, events = 0, fd = 561831152, user_data = 0x82a6e3c0c}, {pos = 1, events = 0, fd = 905854976, user_data = 0x8217cdd20}, {pos = 711863988, events = 8, fd = 748958048, user_data = 0x82ca43160 }, {pos = 747327680, events = 8, fd = 570418184, user_data = 0x8217cde00}, {pos = -853810132, events = 12274, fd = 80627796, user_data = 0x1}, {pos = -853810514, events = 12274, fd = 12240, user_data = 0x8217cdd28}, {pos = 561831424, events = 8, fd = 906651624, user_data = 0x8217ce370}, {pos = -853729648, events = 12274, fd = 570418184, user_data = 0x8217c037f}, {pos = 748614834, events = 8, fd = 561831728, user_data = 0x2ff200000000}, {pos = 570418184, events = 8, fd = 12240, user_data = 0x82c879000}, {pos = 1964368, events = 0, fd = 748958048, user_data = 0x82c899c64}, {pos = 15616, events = 0, fd = 561832608, user_data = 0x8217cde70}, {pos = 747889038, events = 8, fd = 748996664, user_data = 0x8217cde34}, {pos = 906307034, events = 8, fd = 561832608, user_data = 0x8217cde70}, {pos = 747980293, events = 8, fd = 561831474, user_data = 0x8217ce2a0}, {pos = 561832608, events = 8, fd = 0, user_data = 0x3a7804848d6726e7}, {pos = 561832608, events = 8, fd = 906307032, user_data = 0x8217ce370}, {pos = 748996664, events = 8, fd = 0, user_data = 0x8217ce2e0}, {pos = 747980557, events = 8, fd = 0, user_data = 0x0}, {pos = 561832976, events = 8, fd = 906307032, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -853781495, user_data = 0x8217cdfb8}, {pos = 747215972, events = 8, fd = 2503, user_data = 0x2ff2cd1c5409}, {pos = 561831896, events = 8, fd = 747215972, user_data = 0xac6}, {pos = 747188512, events = 8, fd = 561831768, user_data = 0x821ffe408}, {pos = 561831896, events = 8, fd = 747188512, user_data = 0x8217cdfc0}, {pos = -853801883, events = 12274, fd = 0, user_data = 0x800000000}, {pos = 561831856, events = 8, fd = 747148624, user_data = 0x0}, {pos = 0, events = 0, fd = 561831824, user_data = 0x2ff2cd1c5409}, {pos = 561832040, events = 8, fd = 747215972, user_data = 0xb6c}, {pos = 747189176, events = 8, fd = 561831912, user_data = 0x821ffe408}, {pos = 561832040, events = 8, fd = 747189176, user_data = 0x8217ce050}, {pos = -853801883, events = 12274, fd = 570441784, user_data = 0x28d18e}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 570418184, user_data = 0x82c889550}, {pos = 561832760, events = 8, fd = 570418184, user_data = 0x217ce218}, {pos = 31, events = 0, fd = 0, user_data = 0x8217ce0f8}, {pos = 570439560, events = 8, fd = 561832648, user_data = 0x8217ce0e0}, {pos = -853783133, events = 12274, fd = 570441784, user_data = 0x292e16}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822004038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [14:43:14.897] last_touch_time = 1713278432 [14:43:14.897] last_lockfile_recheck_time = 1713278432 [14:43:14.897] nevents = 1 [14:43:14.897] #25 0x000000000085cfc6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8217ceaa0) at ../src/backend/postmaster/postmaster.c:1372 [14:43:14.897] userDoption = [14:43:14.897] listen_addr_saved = false [14:43:14.897] output_config_variable = [14:43:14.897] opt = [14:43:14.897] status = [14:43:14.897] #26 0x0000000000794eb5 in main (argc=4, argv=0x8217ceaa0) at ../src/backend/main/main.c:197 [14:43:14.897] do_check_root =