[21:33:46.419] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [21:33:46.741] dumping /tmp/cores/postgres.8226.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:33:46.867] [New LWP 101729] [21:33:46.946] Core was generated by `postgres: postgres regression [local] MERGE'. [21:33:46.946] Program terminated with signal SIGABRT, Aborted. [21:33:46.946] Sent by thr_kill() from pid 8226 and user 1003. [21:33:46.946] #0 0x000000082d5c9dca in thr_kill () from /lib/libc.so.7 [21:33:47.549] [21:33:47.549] Thread 1 (LWP 101729): [21:33:47.549] #0 0x000000082d5c9dca in thr_kill () from /lib/libc.so.7 [21:33:47.549] No symbol table info available. [21:33:47.549] #1 0x000000082d5426f4 in raise () from /lib/libc.so.7 [21:33:47.549] No symbol table info available. [21:33:47.549] #2 0x000000082d5f3bc9 in abort () from /lib/libc.so.7 [21:33:47.549] No symbol table info available. [21:33:47.549] #3 0x0000000000a5d707 in ExceptionalCondition (conditionName=, fileName=0x372e58 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:33:47.549] No locals. [21:33:47.549] #4 0x000000000073fe00 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821174ca0, materialize=, shouldFree=shouldFree@entry=0x821174c46) at ../src/backend/executor/execTuples.c:1737 [21:33:47.549] No locals. [21:33:47.549] #5 0x0000000000705fe8 in ExecIRDeleteTriggers (estate=estate@entry=0x836d03100, relinfo=relinfo@entry=0x836d036b0, slot=slot@entry=0x821174ca0) at ../src/backend/commands/trigger.c:2841 [21:33:47.549] trigger = [21:33:47.549] oldtuple = [21:33:47.549] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84331b688, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:33:47.549] trigdesc = 0x836d038c0 [21:33:47.549] newtuple = 0x0 [21:33:47.549] i = 0 [21:33:47.549] should_free = false [21:33:47.549] #6 0x0000000000764efa in ExecMergeMatched (context=0x821174d60, resultRelInfo=0x836d036b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [21:33:47.549] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:33:47.549] relaction = 0x842113e60 [21:33:47.549] commandType = CMD_DELETE [21:33:47.549] result = TM_Ok [21:33:47.549] l__state = {l = 0x842208588, i = 0} [21:33:47.549] mtstate = 0x836d034a0 [21:33:47.549] newslot = 0x0 [21:33:47.549] rslot = 0x0 [21:33:47.549] estate = 0x18d61 [21:33:47.549] mergeActions = [21:33:47.549] econtext = 0x842207628 [21:33:47.549] epqstate = 0x836d03588 [21:33:47.549] actionStates = 0x842208588 [21:33:47.549] l = [21:33:47.549] isNull = [21:33:47.549] lmerge_matched = [21:33:47.549] __error = [21:33:47.549] l__state = [21:33:47.549] updateCxt = [21:33:47.549] relaction = [21:33:47.549] commandType = [21:33:47.549] result = [21:33:47.549] __error = [21:33:47.549] resultRelationDesc = [21:33:47.549] lockmode = [21:33:47.549] inputslot = [21:33:47.549] epqslot = [21:33:47.549] was_matched = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] #7 ExecMerge (context=0x821174d60, resultRelInfo=0x836d036b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:33:47.549] matched = [21:33:47.549] rslot = 0x0 [21:33:47.549] #8 ExecModifyTable (pstate=0x836d034a0) at ../src/backend/executor/nodeModifyTable.c:4112 [21:33:47.549] context = {mtstate = 0x836d034a0, epqstate = 0x836d03588, estate = 0x836d03100, planSlot = 0x842113dd0, tmfd = {ctid = {ip_blkid = {bi_hi = 29120, bi_lo = 16931}, ip_posid = 8}, xmax = 919615152, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x836d03100} [21:33:47.549] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [21:33:47.549] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836d17118} [21:33:47.549] node = 0x836d034a0 [21:33:47.549] estate = 0x836d03100 [21:33:47.549] operation = CMD_MERGE [21:33:47.549] resultRelInfo = 0x836d036b0 [21:33:47.549] subplanstate = 0x836d04df0 [21:33:47.549] slot = [21:33:47.549] tupleid = 0x0 [21:33:47.549] oldtuple = 0x0 [21:33:47.549] oldSlot = [21:33:47.549] #9 0x0000000000739e9b in ExecProcNodeFirst (node=0x836d034a0) at ../src/backend/executor/execProcnode.c:464 [21:33:47.549] No locals. [21:33:47.549] #10 0x000000000073218a in ExecProcNode (node=0x836d034a0) at ../src/include/executor/executor.h:274 [21:33:47.549] No locals. [21:33:47.549] #11 ExecutePlan (estate=0x836d03100, planstate=0x836d034a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836cdc710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [21:33:47.549] current_tuple_count = [21:33:47.549] slot = [21:33:47.549] #12 standard_ExecutorRun (queryDesc=0x836be4448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:33:47.549] estate = 0x836d03100 [21:33:47.549] oldcontext = 0x836cdc400 [21:33:47.549] operation = CMD_MERGE [21:33:47.549] dest = 0x836cdc710 [21:33:47.549] sendTuples = true [21:33:47.549] #13 0x000000000073203f in ExecutorRun (queryDesc=0x18d61, queryDesc@entry=0x836be4448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:33:47.549] No locals. [21:33:47.549] #14 0x000000000090b01f in ProcessQuery (plan=0x8422346a0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821174f78) at ../src/backend/tcop/pquery.c:160 [21:33:47.549] queryDesc = 0x836be4448 [21:33:47.549] #15 0x000000000090a5bd in PortalRunMulti (portal=portal@entry=0x836c17100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836cdc710, altdest=0xb517e0 , qc=qc@entry=0x821174f78) at ../src/backend/tcop/pquery.c:1286 [21:33:47.549] pstmt = 0x8422346a0 [21:33:47.549] stmtlist_item__state = {l = 0x842238f58, i = 0} [21:33:47.549] active_snapshot_set = true [21:33:47.549] stmtlist_item = 0x842238f70 [21:33:47.549] #16 0x000000000090a0ac in FillPortalStore (portal=portal@entry=0x836c17100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:33:47.549] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:33:47.549] treceiver = 0x836cdc710 [21:33:47.549] #17 0x0000000000909e00 in PortalRun (portal=portal@entry=0x836c17100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x842238fa8, altdest=altdest@entry=0x842238fa8, qc=0x8211750b0) at ../src/backend/tcop/pquery.c:763 [21:33:47.549] _local_sigjmp_buf = {{_sjb = {9477535, 35278455768, 34914914216, 34914914448, 34914914224, 12165784, 12133568, 35278385408, 7112098687, 35278393600, 3579033, 34359738368}}} [21:33:47.549] _save_exception_stack = 0x821175180 [21:33:47.549] _save_context_stack = 0x0 [21:33:47.549] _do_rethrow = false [21:33:47.549] saveTopTransactionResourceOwner = 0x836c283d8 [21:33:47.549] saveTopTransactionContext = 0x836b4d000 [21:33:47.549] saveActivePortal = 0x0 [21:33:47.549] saveResourceOwner = 0x836c283d8 [21:33:47.549] savePortalContext = 0x0 [21:33:47.549] saveMemoryContext = 0x836b4d000 [21:33:47.549] result = [21:33:47.549] nprocessed = [21:33:47.549] #18 0x0000000000908d0b in exec_simple_query (query_string=query_string@entry=0x836b41100 "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 [21:33:47.549] cmdtaglen = [21:33:47.549] snapshot_set = [21:33:47.549] per_parsetree_context = 0x0 [21:33:47.549] plantree_list = [21:33:47.549] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:33:47.549] parsetree = 0x8421d5728 [21:33:47.549] commandTag = CMDTAG_MERGE [21:33:47.549] cmdtagname = [21:33:47.549] querytree_list = [21:33:47.549] portal = 0x836c17100 [21:33:47.549] format = 0 [21:33:47.549] receiver = 0x842238fa8 [21:33:47.549] parsetree_item__state = {l = 0x8421d6ff0, i = 0} [21:33:47.549] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:33:47.549] dest = DestRemote [21:33:47.549] was_logged = [21:33:47.549] oldcontext = 0x836b4d000 [21:33:47.549] parsetree_list = 0x8421d6ff0 [21:33:47.549] use_implicit_block = false [21:33:47.549] parsetree_item = 0x8421d7008 [21:33:47.549] save_log_statement_stats = [21:33:47.549] #19 0x0000000000906ae4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:33:47.549] query_string = 0x836b41100 "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"... [21:33:47.549] input_message = {data = 0x836b41100 "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} [21:33:47.549] firstchar = [21:33:47.549] local_sigjmp_buf = {{_sjb = {9461680, 34914914688, 34914914648, 34914915248, 12174520, 12120992, 8192, 8388608, 72057628952822655, 0, 0, 34359738369}}} [21:33:47.549] send_ready_for_query = false [21:33:47.549] idle_in_transaction_timeout_enabled = false [21:33:47.549] idle_session_timeout_enabled = false [21:33:47.549] #20 0x00000000009015b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:33:47.549] bsdata = [21:33:47.549] #21 0x000000000085b512 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821175ec0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821175e08) at ../src/backend/postmaster/launch_backend.c:265 [21:33:47.549] pid = [21:33:47.549] #22 0x000000000085fe71 in BackendStartup (client_sock=0x821175e08) at ../src/backend/postmaster/postmaster.c:3593 [21:33:47.549] startup_data = {canAcceptConnections = CAC_OK} [21:33:47.549] bn = 0x836b4d588 [21:33:47.549] pid = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] save_errno = [21:33:47.549] __error = [21:33:47.549] __error = [21:33:47.549] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:33:47.549] 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' , "`^\027!\b\000\000\000\330\365\355+\b\000\000\000\v\000\000\000\000\000\000\000\016v\356+\b", '\000' , "\240^\027!\b\000\000\000䲅\000\000\000\000\000\260^\027!\b", '\000' }, salen = 16}} [21:33:47.549] i = 0 [21:33:47.549] now = [21:33:47.549] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 759901284, events = 8, fd = 555177040, user_data = 0x8211755e0}, {pos = 563966984, events = 8, fd = 32, user_data = 0x8211755d0}, {pos = -1663677804, events = 13141, fd = 563937288, user_data = 0x8219d0408}, {pos = 563939336, events = 8, fd = 563940360, user_data = 0x8219d4008}, {pos = 563954696, events = 8, fd = 563955720, user_data = 0x8219d4c08}, {pos = 563957768, events = 8, fd = 563958792, user_data = 0x8219d5808}, {pos = 563960840, events = 8, fd = 563961864, user_data = 0x8219d6408}, {pos = 563963912, events = 8, fd = 563964936, user_data = 0x8219d7008}, {pos = 563966984, events = 8, fd = -1, user_data = 0x82d68a2e0}, {pos = 555177280, events = 8, fd = 761491881, user_data = 0x0}, {pos = 4096, events = 0, fd = -474031158, user_data = 0x82d68a7e8}, {pos = 903912416, events = 8, fd = 160, user_data = 0x0}, {pos = 883400848, events = 8, fd = 555177488, user_data = 0x82d61592c}, {pos = 4096, events = 0, fd = 759916900, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 563993144, user_data = 0x800000001}, {pos = 563966984, events = 8, fd = 759830744, user_data = 0x821175698}, {pos = 555177040, events = 8, fd = 32, user_data = 0x82d4b2c64}, {pos = 563966984, events = 8, fd = 563993144, user_data = 0x0}, {pos = 2625, events = 0, fd = 555177600, user_data = 0x33559cd64645}, {pos = 759916900, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 563993144, events = 8, fd = 1, user_data = 0x8219d7408}, {pos = 917704704, events = 8, fd = 1, user_data = 0x836b31194}, {pos = 0, events = 0, fd = 555177552, user_data = 0x82bee6c0c}, {pos = 1, events = 0, fd = 917704704, user_data = 0x821175680}, {pos = 737042100, events = 8, fd = 761643360, user_data = 0x82d65c160 }, {pos = 760012992, events = 8, fd = 563966984, user_data = 0x821175760}, {pos = -1663679444, events = 13141, fd = 883400848, user_data = 0x800000001}, {pos = -1663679826, events = 13141, fd = 12240, user_data = 0x821175688}, {pos = 555177824, events = 8, fd = 918411240, user_data = 0x821175cd0}, {pos = -1663598960, events = 13141, fd = 563966984, user_data = 0x82117037f}, {pos = 761300380, events = 8, fd = 563937288, user_data = 0x0}, {pos = 563966984, events = 8, fd = 12240, user_data = 0x82d492000}, {pos = 1964368, events = 0, fd = 761643360, user_data = 0x82d4b2c64}, {pos = 15616, events = 0, fd = 555179008, user_data = 0x8211757d0}, {pos = 760574350, events = 8, fd = 761681976, user_data = 0x821175794}, {pos = 918148570, events = 8, fd = 555179008, user_data = 0x8211757d0}, {pos = 760665605, events = 8, fd = 555177874, user_data = 0x821175c00}, {pos = 555179008, events = 8, fd = 0, user_data = 0xa63dcd61e3bedbca}, {pos = 555179008, events = 8, fd = 918148568, user_data = 0x821175cd0}, {pos = 761681976, events = 8, fd = 0, user_data = 0x821175c40}, {pos = 760665869, events = 8, fd = 0, user_data = 0x0}, {pos = 555179376, events = 8, fd = 918148568, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1663650807, events = 13141, fd = 555178280, user_data = 0x82d4b2c64}, {pos = 2503, events = 0, fd = -1663650807, user_data = 0x821175948}, {pos = 759901284, events = 8, fd = 2758, user_data = 0x82d4ac120}, {pos = 555178184, events = 8, fd = 563966984, user_data = 0x821175948}, {pos = 759873824, events = 8, fd = 555178288, user_data = 0x33559cd66465}, {pos = 0, events = 0, fd = 0, user_data = 0x82d67e0f0}, {pos = 759833936, events = 8, fd = 0, user_data = 0x0}, {pos = 761711024, events = 8, fd = -1663650807, user_data = 0x8211759d8}, {pos = 759901284, events = 8, fd = 2924, user_data = 0x82d4ac3b8}, {pos = 555178328, events = 8, fd = 563966984, user_data = 0x8211759d8}, {pos = 759874488, events = 8, fd = 555178432, user_data = 0x33559cd66465}, {pos = 563990584, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 563966984, events = 8, fd = 759833936, user_data = 0x821175c98}, {pos = 563966984, events = 8, fd = 555178872, user_data = 0x1e}, {pos = 759837920, events = 8, fd = 555178600, user_data = 0x8219dc288}, {pos = 555179048, events = 8, fd = 555178576, user_data = 0x33559cd6ada3}, {pos = 563990584, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 563990584, user_data = 0x1}} [21:33:47.549] last_touch_time = 1713735055 [21:33:47.549] last_lockfile_recheck_time = 1713735055 [21:33:47.549] nevents = 1 [21:33:47.549] #24 0x000000000085d746 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821176408) at ../src/backend/postmaster/postmaster.c:1372 [21:33:47.549] userDoption = [21:33:47.549] listen_addr_saved = false [21:33:47.549] output_config_variable = [21:33:47.549] opt = [21:33:47.549] status = [21:33:47.549] #25 0x0000000000795405 in main (argc=8, argv=0x821176408) at ../src/backend/main/main.c:197 [21:33:47.549] do_check_root = [21:33:47.559] [21:33:47.559] [21:33:47.559] [21:33:47.618] dumping /tmp/cores/postgres.8980.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:33:47.738] [New LWP 100184] [21:33:47.798] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [21:33:47.798] Program terminated with signal SIGABRT, Aborted. [21:33:47.798] Sent by thr_kill() from pid 8980 and user 1003. [21:33:47.798] #0 0x000000082ae4cdca in thr_kill () from /lib/libc.so.7 [21:33:48.380] [21:33:48.380] Thread 1 (LWP 100184): [21:33:48.380] #0 0x000000082ae4cdca in thr_kill () from /lib/libc.so.7 [21:33:48.380] No symbol table info available. [21:33:48.380] #1 0x000000082adc56f4 in raise () from /lib/libc.so.7 [21:33:48.380] No symbol table info available. [21:33:48.380] #2 0x000000082ae76bc9 in abort () from /lib/libc.so.7 [21:33:48.380] No symbol table info available. [21:33:48.380] #3 0x0000000000a5d707 in ExceptionalCondition (conditionName=, fileName=0x372e58 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:33:48.380] No locals. [21:33:48.380] #4 0x000000000073fe00 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8211b2ef0, materialize=, shouldFree=shouldFree@entry=0x8211b2e96) at ../src/backend/executor/execTuples.c:1737 [21:33:48.380] No locals. [21:33:48.380] #5 0x0000000000705fe8 in ExecIRDeleteTriggers (estate=estate@entry=0x833455100, relinfo=relinfo@entry=0x8334556b0, slot=slot@entry=0x8211b2ef0) at ../src/backend/commands/trigger.c:2841 [21:33:48.380] trigger = [21:33:48.380] oldtuple = [21:33:48.380] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x840bea278, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:33:48.380] trigdesc = 0x8334558c0 [21:33:48.380] newtuple = 0x0 [21:33:48.380] i = 0 [21:33:48.380] should_free = false [21:33:48.380] #6 0x0000000000764efa in ExecMergeMatched (context=0x8211b2fb0, resultRelInfo=0x8334556b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [21:33:48.380] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:33:48.380] relaction = 0x840c84120 [21:33:48.380] commandType = CMD_DELETE [21:33:48.380] result = TM_Ok [21:33:48.380] l__state = {l = 0x840d04b08, i = 0} [21:33:48.380] mtstate = 0x8334554a0 [21:33:48.380] newslot = 0x0 [21:33:48.380] rslot = 0x0 [21:33:48.380] estate = 0x18758 [21:33:48.380] mergeActions = [21:33:48.380] econtext = 0x840d03ba8 [21:33:48.380] epqstate = 0x833455588 [21:33:48.380] actionStates = 0x840d04b08 [21:33:48.380] l = [21:33:48.380] isNull = [21:33:48.380] lmerge_matched = [21:33:48.380] __error = [21:33:48.380] l__state = [21:33:48.380] updateCxt = [21:33:48.380] relaction = [21:33:48.380] commandType = [21:33:48.380] result = [21:33:48.380] __error = [21:33:48.380] resultRelationDesc = [21:33:48.380] lockmode = [21:33:48.380] inputslot = [21:33:48.380] epqslot = [21:33:48.380] was_matched = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] #7 ExecMerge (context=0x8211b2fb0, resultRelInfo=0x8334556b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:33:48.380] matched = [21:33:48.380] rslot = 0x0 [21:33:48.380] #8 ExecModifyTable (pstate=0x8334554a0) at ../src/backend/executor/nodeModifyTable.c:4112 [21:33:48.380] context = {mtstate = 0x8334554a0, epqstate = 0x833455588, estate = 0x833455100, planSlot = 0x840c84090, tmfd = {ctid = {ip_blkid = {bi_hi = 16704, bi_lo = 16595}, ip_posid = 8}, xmax = 860182192, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x833455100} [21:33:48.380] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [21:33:48.380] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x833469118} [21:33:48.380] node = 0x8334554a0 [21:33:48.380] estate = 0x833455100 [21:33:48.380] operation = CMD_MERGE [21:33:48.380] resultRelInfo = 0x8334556b0 [21:33:48.380] subplanstate = 0x833456df0 [21:33:48.380] slot = [21:33:48.380] tupleid = 0x0 [21:33:48.380] oldtuple = 0x0 [21:33:48.380] oldSlot = [21:33:48.380] #9 0x0000000000739e9b in ExecProcNodeFirst (node=0x8334554a0) at ../src/backend/executor/execProcnode.c:464 [21:33:48.380] No locals. [21:33:48.380] #10 0x000000000073218a in ExecProcNode (node=0x8334554a0) at ../src/include/executor/executor.h:274 [21:33:48.380] No locals. [21:33:48.380] #11 ExecutePlan (estate=0x833455100, planstate=0x8334554a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8332ecf10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [21:33:48.380] current_tuple_count = [21:33:48.380] slot = [21:33:48.380] #12 standard_ExecutorRun (queryDesc=0x83336e448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:33:48.380] estate = 0x833455100 [21:33:48.380] oldcontext = 0x8332ecc00 [21:33:48.380] operation = CMD_MERGE [21:33:48.380] dest = 0x8332ecf10 [21:33:48.380] sendTuples = true [21:33:48.380] #13 0x000000000073203f in ExecutorRun (queryDesc=0x18758, queryDesc@entry=0x83336e448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:33:48.380] No locals. [21:33:48.380] #14 0x000000000090b01f in ProcessQuery (plan=0x840d31620, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8211b31c8) at ../src/backend/tcop/pquery.c:160 [21:33:48.380] queryDesc = 0x83336e448 [21:33:48.380] #15 0x000000000090a5bd in PortalRunMulti (portal=portal@entry=0x83334e100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8332ecf10, altdest=0xb517e0 , qc=qc@entry=0x8211b31c8) at ../src/backend/tcop/pquery.c:1286 [21:33:48.380] pstmt = 0x840d31620 [21:33:48.380] stmtlist_item__state = {l = 0x840d35ed8, i = 0} [21:33:48.380] active_snapshot_set = true [21:33:48.380] stmtlist_item = 0x840d35ef0 [21:33:48.380] #16 0x000000000090a0ac in FillPortalStore (portal=portal@entry=0x83334e100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:33:48.380] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:33:48.380] treceiver = 0x8332ecf10 [21:33:48.380] #17 0x0000000000909e00 in PortalRun (portal=portal@entry=0x83334e100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x840d35f28, altdest=altdest@entry=0x840d35f28, qc=0x8211b3300) at ../src/backend/tcop/pquery.c:763 [21:33:48.380] _local_sigjmp_buf = {{_sjb = {9477535, 35219178328, 34915168760, 34915168992, 34915168768, 12165784, 12133568, 35218841856, 7112098687, 35218850048, 3579033, 34359738368}}} [21:33:48.380] _save_exception_stack = 0x8211b33d0 [21:33:48.380] _save_context_stack = 0x0 [21:33:48.380] _do_rethrow = false [21:33:48.380] saveTopTransactionResourceOwner = 0x8333a0358 [21:33:48.380] saveTopTransactionContext = 0x8332c1000 [21:33:48.380] saveActivePortal = 0x0 [21:33:48.380] saveResourceOwner = 0x8333a0358 [21:33:48.380] savePortalContext = 0x0 [21:33:48.380] saveMemoryContext = 0x8332c1000 [21:33:48.380] result = [21:33:48.380] nprocessed = [21:33:48.380] #18 0x0000000000908d0b in exec_simple_query (query_string=query_string@entry=0x8332b5100 "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 [21:33:48.380] cmdtaglen = [21:33:48.380] snapshot_set = [21:33:48.380] per_parsetree_context = 0x0 [21:33:48.380] plantree_list = [21:33:48.380] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:33:48.380] parsetree = 0x840cd1ea8 [21:33:48.380] commandTag = CMDTAG_MERGE [21:33:48.380] cmdtagname = [21:33:48.380] querytree_list = [21:33:48.380] portal = 0x83334e100 [21:33:48.380] format = 0 [21:33:48.380] receiver = 0x840d35f28 [21:33:48.380] parsetree_item__state = {l = 0x840cd3770, i = 0} [21:33:48.380] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:33:48.380] dest = DestRemote [21:33:48.380] was_logged = [21:33:48.380] oldcontext = 0x8332c1000 [21:33:48.380] parsetree_list = 0x840cd3770 [21:33:48.380] use_implicit_block = false [21:33:48.380] parsetree_item = 0x840cd3788 [21:33:48.380] save_log_statement_stats = [21:33:48.380] #19 0x0000000000906ae4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:33:48.380] query_string = 0x8332b5100 "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"... [21:33:48.380] input_message = {data = 0x8332b5100 "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} [21:33:48.380] firstchar = [21:33:48.380] local_sigjmp_buf = {{_sjb = {9461680, 34915169232, 34915169192, 34915169792, 12174520, 12120992, 8192, 8388608, 72057628953084799, 0, 0, 34359738369}}} [21:33:48.380] send_ready_for_query = false [21:33:48.380] idle_in_transaction_timeout_enabled = false [21:33:48.380] idle_session_timeout_enabled = false [21:33:48.380] #20 0x00000000009015b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:33:48.380] bsdata = [21:33:48.380] #21 0x000000000085b512 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8211b4110 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211b4058) at ../src/backend/postmaster/launch_backend.c:265 [21:33:48.380] pid = [21:33:48.380] #22 0x000000000085fe71 in BackendStartup (client_sock=0x8211b4058) at ../src/backend/postmaster/postmaster.c:3593 [21:33:48.380] startup_data = {canAcceptConnections = CAC_OK} [21:33:48.380] bn = 0x8332c1308 [21:33:48.380] pid = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] save_errno = [21:33:48.380] __error = [21:33:48.380] __error = [21:33:48.380] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:33:48.380] 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' , "\260@\033!\b\000\000\000\330\005\267)\b\000\000\000\v\000\000\000\000\000\000\000\016\206\267)\b", '\000' , "\360@\033!\b\000\000\000䲅\000\000\000\000\000\000A\033!\b", '\000' }, salen = 16}} [21:33:48.380] i = 0 [21:33:48.380] now = [21:33:48.380] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 718494820, events = 8, fd = 555431584, user_data = 0x8211b3830}, {pos = 569230344, events = 8, fd = 32, user_data = 0x8211b3820}, {pos = -697708, events = 4623, fd = 569200648, user_data = 0x821ed5408}, {pos = 569202696, events = 8, fd = 569203720, user_data = 0x821ed9008}, {pos = 569218056, events = 8, fd = 569219080, user_data = 0x821ed9c08}, {pos = 569221128, events = 8, fd = 569222152, user_data = 0x821eda808}, {pos = 569224200, events = 8, fd = 569225224, user_data = 0x821edb408}, {pos = 569227272, events = 8, fd = 569228296, user_data = 0x821edc008}, {pos = 569230344, events = 8, fd = 569249992, user_data = 0x8211b39a8}, {pos = 555431888, events = 8, fd = -672349, user_data = 0x0}, {pos = 2571326, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 569253944, events = 8, fd = 1, user_data = 0x821edc408}, {pos = 718402728, events = 8, fd = 555432616, user_data = 0x821edc408}, {pos = 555431872, events = 0, fd = 718510436, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 569256504, user_data = 0x1}, {pos = 569230344, events = 8, fd = 718424280, user_data = 0x8211b38e8}, {pos = 555431584, events = 8, fd = 32, user_data = 0x82ad35c64}, {pos = 569230344, events = 8, fd = 569256504, user_data = 0x0}, {pos = 2625, events = 0, fd = 555432144, user_data = 0x120ffff55645}, {pos = 718510436, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 569256504, events = 8, fd = 1, user_data = 0x821edc408}, {pos = 858411008, events = 8, fd = 1, user_data = 0x8332a5194}, {pos = 0, events = 0, fd = 555432096, user_data = 0x829b77c0c}, {pos = 1, events = 0, fd = 858411008, user_data = 0x8211b38d0}, {pos = 699887284, events = 8, fd = 720236896, user_data = 0x82aedf160 }, {pos = 718606528, events = 8, fd = 569230344, user_data = 0x8211b39b0}, {pos = -699348, events = 4623, fd = 569229320, user_data = 0x800000001}, {pos = -699730, events = 4623, fd = 12240, user_data = 0x8211b38d8}, {pos = 555432368, events = 8, fd = 859207656, user_data = 0x8211b3f20}, {pos = -618864, events = 4623, fd = 569230344, user_data = 0x8211b037f}, {pos = 719893682, events = 8, fd = 569200648, user_data = 0x0}, {pos = 569230344, events = 8, fd = 12240, user_data = 0x82ad15000}, {pos = 1964368, events = 0, fd = 720236896, user_data = 0x82ad35c64}, {pos = 15616, events = 0, fd = 555433552, user_data = 0x8211b3a20}, {pos = 719167886, events = 8, fd = 720275512, user_data = 0x8211b39e4}, {pos = 858863066, events = 8, fd = 555433552, user_data = 0x8211b3a20}, {pos = 719259141, events = 8, fd = 555432418, user_data = 0x8211b3e50}, {pos = 555433552, events = 8, fd = 0, user_data = 0xa75cd4e050d9f539}, {pos = 555433552, events = 8, fd = 858863064, user_data = 0x8211b3f20}, {pos = 720275512, events = 8, fd = 0, user_data = 0x8211b3e90}, {pos = 719259405, events = 8, fd = 0, user_data = 0x0}, {pos = 555433920, events = 8, fd = 858863064, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -670711, events = 4623, fd = 555432824, user_data = 0x82ad35c64}, {pos = 2503, events = 0, fd = -670711, user_data = 0x8211b3b98}, {pos = 718494820, events = 8, fd = 2758, user_data = 0x82ad2f120}, {pos = 555432728, events = 8, fd = 569230344, user_data = 0x8211b3b98}, {pos = 718467360, events = 8, fd = 555432832, user_data = 0x120ffff57465}, {pos = 0, events = 0, fd = 0, user_data = 0x82af010f0}, {pos = 718427472, events = 8, fd = 0, user_data = 0x0}, {pos = 720304560, events = 8, fd = -670711, user_data = 0x8211b3c28}, {pos = 718494820, events = 8, fd = 2924, user_data = 0x82ad2f3b8}, {pos = 555432872, events = 8, fd = 569230344, user_data = 0x8211b3c28}, {pos = 718468024, events = 8, fd = 555432976, user_data = 0x120ffff57465}, {pos = 569253944, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 569230344, events = 8, fd = 718427472, user_data = 0x8211b3ee8}, {pos = 569230344, events = 8, fd = 555433416, user_data = 0x1e}, {pos = 718431456, events = 8, fd = 555433144, user_data = 0x821ee1288}, {pos = 555433592, events = 8, fd = 555433120, user_data = 0x120ffff5bda3}, {pos = 569253944, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 569253944, user_data = 0x1}} [21:33:48.380] last_touch_time = 1713735057 [21:33:48.380] last_lockfile_recheck_time = 1713735057 [21:33:48.380] nevents = 1 [21:33:48.380] #24 0x000000000085d746 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8211b4650) at ../src/backend/postmaster/postmaster.c:1372 [21:33:48.380] userDoption = [21:33:48.380] listen_addr_saved = false [21:33:48.380] output_config_variable = [21:33:48.380] opt = [21:33:48.380] status = [21:33:48.380] #25 0x0000000000795405 in main (argc=4, argv=0x8211b4650) at ../src/backend/main/main.c:197 [21:33:48.380] do_check_root = [21:33:48.390] [21:33:48.390] [21:33:48.390] [21:33:48.455] dumping /tmp/cores/postgres.14529.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:33:48.577] [New LWP 101758] [21:33:48.637] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [21:33:48.637] Program terminated with signal SIGABRT, Aborted. [21:33:48.637] Sent by thr_kill() from pid 14529 and user 1003. [21:33:48.637] #0 0x000000082c9a0dca in thr_kill () from /lib/libc.so.7 [21:33:49.225] [21:33:49.225] Thread 1 (LWP 101758): [21:33:49.225] #0 0x000000082c9a0dca in thr_kill () from /lib/libc.so.7 [21:33:49.225] No symbol table info available. [21:33:49.225] #1 0x000000082c9196f4 in raise () from /lib/libc.so.7 [21:33:49.225] No symbol table info available. [21:33:49.225] #2 0x000000082c9cabc9 in abort () from /lib/libc.so.7 [21:33:49.225] No symbol table info available. [21:33:49.225] #3 0x0000000000a5d707 in ExceptionalCondition (conditionName=, fileName=0x372e58 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:33:49.225] No locals. [21:33:49.225] #4 0x000000000073fe00 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8218b28e0, materialize=, shouldFree=shouldFree@entry=0x8218b2886) at ../src/backend/executor/execTuples.c:1737 [21:33:49.225] No locals. [21:33:49.225] #5 0x0000000000705fe8 in ExecIRDeleteTriggers (estate=estate@entry=0x835ed1100, relinfo=relinfo@entry=0x835ed16b0, slot=slot@entry=0x8218b28e0) at ../src/backend/commands/trigger.c:2841 [21:33:49.225] trigger = [21:33:49.225] oldtuple = [21:33:49.225] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83daca4a8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:33:49.225] trigdesc = 0x835ed18c0 [21:33:49.225] newtuple = 0x0 [21:33:49.225] i = 0 [21:33:49.225] should_free = false [21:33:49.225] #6 0x0000000000764efa in ExecMergeMatched (context=0x8218b29a0, resultRelInfo=0x835ed16b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [21:33:49.225] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:33:49.225] relaction = 0x835ecd720 [21:33:49.225] commandType = CMD_DELETE [21:33:49.225] result = TM_Ok [21:33:49.225] l__state = {l = 0x83d53ae48, i = 0} [21:33:49.225] mtstate = 0x835ed14a0 [21:33:49.225] newslot = 0x0 [21:33:49.225] rslot = 0x0 [21:33:49.225] estate = 0x18d7e [21:33:49.225] mergeActions = [21:33:49.225] econtext = 0x83d539ee8 [21:33:49.225] epqstate = 0x835ed1588 [21:33:49.225] actionStates = 0x83d53ae48 [21:33:49.225] l = [21:33:49.225] isNull = [21:33:49.225] lmerge_matched = [21:33:49.225] __error = [21:33:49.225] l__state = [21:33:49.225] updateCxt = [21:33:49.225] relaction = [21:33:49.225] commandType = [21:33:49.225] result = [21:33:49.225] __error = [21:33:49.225] resultRelationDesc = [21:33:49.225] lockmode = [21:33:49.225] inputslot = [21:33:49.225] epqslot = [21:33:49.225] was_matched = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] #7 ExecMerge (context=0x8218b29a0, resultRelInfo=0x835ed16b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:33:49.225] matched = [21:33:49.225] rslot = 0x0 [21:33:49.225] #8 ExecModifyTable (pstate=0x835ed14a0) at ../src/backend/executor/nodeModifyTable.c:4112 [21:33:49.225] context = {mtstate = 0x835ed14a0, epqstate = 0x835ed1588, estate = 0x835ed1100, planSlot = 0x835ecd690, tmfd = {ctid = {ip_blkid = {bi_hi = 10824, bi_lo = 8587}, ip_posid = 8}, xmax = 749039088, cmax = 8, traversed = 16}, cpUpdateReturningSlot = 0x82c99d6de} [21:33:49.225] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [21:33:49.225] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835edd118} [21:33:49.225] node = 0x835ed14a0 [21:33:49.225] estate = 0x835ed1100 [21:33:49.225] operation = CMD_MERGE [21:33:49.225] resultRelInfo = 0x835ed16b0 [21:33:49.225] subplanstate = 0x835ed2df0 [21:33:49.225] slot = [21:33:49.225] tupleid = 0x0 [21:33:49.225] oldtuple = 0x0 [21:33:49.225] oldSlot = [21:33:49.225] #9 0x0000000000739e9b in ExecProcNodeFirst (node=0x835ed14a0) at ../src/backend/executor/execProcnode.c:464 [21:33:49.225] No locals. [21:33:49.225] #10 0x000000000073218a in ExecProcNode (node=0x835ed14a0) at ../src/include/executor/executor.h:274 [21:33:49.225] No locals. [21:33:49.225] #11 ExecutePlan (estate=0x835ed1100, planstate=0x835ed14a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x835ea4f10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [21:33:49.225] current_tuple_count = [21:33:49.225] slot = [21:33:49.225] #12 standard_ExecutorRun (queryDesc=0x835dce448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:33:49.225] estate = 0x835ed1100 [21:33:49.225] oldcontext = 0x835ea4c00 [21:33:49.225] operation = CMD_MERGE [21:33:49.225] dest = 0x835ea4f10 [21:33:49.225] sendTuples = true [21:33:49.225] #13 0x00000008385bf963 in pgss_ExecutorRun (queryDesc=0x835dce448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [21:33:49.225] _local_sigjmp_buf = {{_sjb = {35305290034, 12165784, 34922506968, 34922507136, 35263407176, 34922506976, 1, 1, 35264463743, 35263407176, 12174512, 34359738368}}} [21:33:49.225] _save_exception_stack = 0x8218b2ca0 [21:33:49.225] _save_context_stack = 0x0 [21:33:49.225] _do_rethrow = false [21:33:49.225] #14 0x0000000000732038 in ExecutorRun (queryDesc=0x18d7e, queryDesc@entry=0x835dce448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [21:33:49.225] No locals. [21:33:49.225] #15 0x000000000090b01f in ProcessQuery (plan=0x83d4f2700, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8218b2c68) at ../src/backend/tcop/pquery.c:160 [21:33:49.225] queryDesc = 0x835dce448 [21:33:49.225] #16 0x000000000090a5bd in PortalRunMulti (portal=portal@entry=0x835db0100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x835ea4f10, altdest=0xb517e0 , qc=qc@entry=0x8218b2c68) at ../src/backend/tcop/pquery.c:1286 [21:33:49.225] pstmt = 0x83d4f2700 [21:33:49.225] stmtlist_item__state = {l = 0x83d4f6fb8, i = 0} [21:33:49.225] active_snapshot_set = true [21:33:49.225] stmtlist_item = 0x83d4f6fd0 [21:33:49.225] #17 0x000000000090a0ac in FillPortalStore (portal=portal@entry=0x835db0100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:33:49.225] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:33:49.225] treceiver = 0x835ea4f10 [21:33:49.225] #18 0x0000000000909e00 in PortalRun (portal=portal@entry=0x835db0100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83d4f7008, altdest=altdest@entry=0x83d4f7008, qc=0x8218b2da0) at ../src/backend/tcop/pquery.c:763 [21:33:49.225] _local_sigjmp_buf = {{_sjb = {9477535, 35263619160, 34922507416, 34922507648, 34922507424, 12165784, 12133568, 35263283456, 7112098687, 35263291648, 3579033, 34359738368}}} [21:33:49.225] _save_exception_stack = 0x8218b2e70 [21:33:49.225] _save_context_stack = 0x0 [21:33:49.225] _do_rethrow = false [21:33:49.225] saveTopTransactionResourceOwner = 0x835e02058 [21:33:49.225] saveTopTransactionContext = 0x835d21000 [21:33:49.225] saveActivePortal = 0x0 [21:33:49.225] saveResourceOwner = 0x835e02058 [21:33:49.225] savePortalContext = 0x0 [21:33:49.225] saveMemoryContext = 0x835d21000 [21:33:49.225] result = [21:33:49.225] nprocessed = [21:33:49.225] #19 0x0000000000908d0b in exec_simple_query (query_string=query_string@entry=0x835d15100 "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 [21:33:49.225] cmdtaglen = [21:33:49.225] snapshot_set = [21:33:49.225] per_parsetree_context = 0x0 [21:33:49.225] plantree_list = [21:33:49.225] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:33:49.225] parsetree = 0x83d4da568 [21:33:49.225] commandTag = CMDTAG_MERGE [21:33:49.225] cmdtagname = [21:33:49.225] querytree_list = [21:33:49.225] portal = 0x835db0100 [21:33:49.225] format = 0 [21:33:49.225] receiver = 0x83d4f7008 [21:33:49.225] parsetree_item__state = {l = 0x83d4dbe30, i = 0} [21:33:49.225] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:33:49.225] dest = DestRemote [21:33:49.225] was_logged = [21:33:49.225] oldcontext = 0x835d21000 [21:33:49.225] parsetree_list = 0x83d4dbe30 [21:33:49.225] use_implicit_block = false [21:33:49.225] parsetree_item = 0x83d4dbe48 [21:33:49.225] save_log_statement_stats = [21:33:49.225] #20 0x0000000000906ae4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:33:49.225] query_string = 0x835d15100 "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"... [21:33:49.225] input_message = {data = 0x835d15100 "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} [21:33:49.225] firstchar = [21:33:49.225] local_sigjmp_buf = {{_sjb = {9461680, 34922507888, 34922507848, 34922508448, 12174520, 12120992, 8192, 8388608, 72057628960424831, 0, 0, 1}}} [21:33:49.225] send_ready_for_query = false [21:33:49.225] idle_in_transaction_timeout_enabled = false [21:33:49.225] idle_session_timeout_enabled = false [21:33:49.225] #21 0x00000000009015b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:33:49.225] bsdata = [21:33:49.225] #22 0x000000000085b512 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8218b3bb0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8218b3af8) at ../src/backend/postmaster/launch_backend.c:265 [21:33:49.225] pid = [21:33:49.225] #23 0x000000000085fe71 in BackendStartup (client_sock=0x8218b3af8) at ../src/backend/postmaster/postmaster.c:3593 [21:33:49.225] startup_data = {canAcceptConnections = CAC_OK} [21:33:49.225] bn = 0x835d21628 [21:33:49.225] pid = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] save_errno = [21:33:49.225] __error = [21:33:49.225] __error = [21:33:49.225] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:33:49.225] 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' , "P;\213!\b\000\000\000\3305Y+\b\000\000\000\v\000\000\000\000\000\000\000\016\266Y+\b", '\000' , "\220;\213!\b\000\000\000䲅\000\000\000\000\000\240;\213!\b", '\000' }, salen = 16}} [21:33:49.225] i = 0 [21:33:49.225] now = [21:33:49.225] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 562770640, events = 8, fd = 575013896, user_data = 0x21}, {pos = 562770624, events = 8, fd = -1666213228, user_data = 0x822459008}, {pos = 574985224, events = 8, fd = 574986248, user_data = 0x822459c08}, {pos = 575000584, events = 8, fd = 575001608, user_data = 0x82245d808}, {pos = 575003656, events = 8, fd = 575004680, user_data = 0x82245e408}, {pos = 575006728, events = 8, fd = 575007752, user_data = 0x82245f008}, {pos = 575009800, events = 8, fd = 575010824, user_data = 0x82245fc08}, {pos = 575012872, events = 8, fd = 575013896, user_data = 0x8224650c8}, {pos = 562771016, events = 8, fd = 562770528, user_data = 0x81a9caffda3}, {pos = 575013896, events = 8, fd = 2571326, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 575037496, user_data = 0x1}, {pos = 575013896, events = 8, fd = 747058344, user_data = 0x8218b3548}, {pos = 575013896, events = 8, fd = 562770496, user_data = 0x273b88}, {pos = 562771088, events = 8, fd = 747166052, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 575040056, user_data = 0x81a00000001}, {pos = 575013896, events = 8, fd = 747079896, user_data = 0x8218b3388}, {pos = 562770224, events = 8, fd = 33, user_data = 0x82c889c64}, {pos = 575013896, events = 8, fd = 575040056, user_data = 0x0}, {pos = 2625, events = 0, fd = 562770800, user_data = 0x81a9caf9645}, {pos = 747166052, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 575040056, events = 8, fd = 1, user_data = 0x822460408}, {pos = 902844416, events = 8, fd = 1, user_data = 0x835d05194}, {pos = 0, events = 0, fd = 562770752, user_data = 0x82b59ac0c}, {pos = 1, events = 0, fd = 902844416, user_data = 0x8218b3370}, {pos = 727293620, events = 8, fd = 748892512, user_data = 0x82ca33160 }, {pos = 747262144, events = 8, fd = 575013896, user_data = 0x8218b3450}, {pos = -1666214868, events = 2074, fd = 80627796, user_data = 0x1}, {pos = -1666215250, events = 2074, fd = 12240, user_data = 0x8218b3378}, {pos = 562771024, events = 8, fd = 903641064, user_data = 0x8218b39c0}, {pos = -1666134384, events = 2074, fd = 575013896, user_data = 0x8218b037f}, {pos = 748549298, events = 8, fd = 562771328, user_data = 0x81a00000000}, {pos = 575013896, events = 8, fd = 12240, user_data = 0x82c869000}, {pos = 1964368, events = 0, fd = 748892512, user_data = 0x82c889c64}, {pos = 15616, events = 0, fd = 562772208, user_data = 0x8218b34c0}, {pos = 747823502, events = 8, fd = 748931128, user_data = 0x8218b3484}, {pos = 903296474, events = 8, fd = 562772208, user_data = 0x8218b34c0}, {pos = 747914757, events = 8, fd = 562771074, user_data = 0x8218b38f0}, {pos = 562772208, events = 8, fd = 0, user_data = 0xe5186642298b23eb}, {pos = 562772208, events = 8, fd = 903296472, user_data = 0x8218b39c0}, {pos = 748931128, events = 8, fd = 0, user_data = 0x8218b3930}, {pos = 747915021, events = 8, fd = 0, user_data = 0x0}, {pos = 562772576, events = 8, fd = 903296472, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1666186231, user_data = 0x8218b3608}, {pos = 747150436, events = 8, fd = 2503, user_data = 0x81a9cb00409}, {pos = 562771496, events = 8, fd = 747150436, user_data = 0xac6}, {pos = 747122976, events = 8, fd = 562771368, user_data = 0x822460408}, {pos = 562771496, events = 8, fd = 747122976, user_data = 0x8218b3610}, {pos = -1666206619, events = 2074, fd = 0, user_data = 0x800000000}, {pos = 562771456, events = 8, fd = 747083088, user_data = 0x0}, {pos = 0, events = 0, fd = 562771424, user_data = 0x81a9cb00409}, {pos = 562771640, events = 8, fd = 747150436, user_data = 0xb6c}, {pos = 747123640, events = 8, fd = 562771512, user_data = 0x822460408}, {pos = 562771640, events = 8, fd = 747123640, user_data = 0x8218b36a0}, {pos = -1666206619, events = 2074, fd = 575037496, user_data = 0x28d146}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 575013896, user_data = 0x82c879550}, {pos = 562772360, events = 8, fd = 575013896, user_data = 0x218b3868}, {pos = 31, events = 0, fd = 0, user_data = 0x8218b3748}, {pos = 575035336, events = 8, fd = 562772248, user_data = 0x8218b3730}, {pos = -1666187869, events = 2074, fd = 575037496, user_data = 0x292dce}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822466038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [21:33:49.225] last_touch_time = 1713735075 [21:33:49.225] last_lockfile_recheck_time = 1713735075 [21:33:49.225] nevents = 1 [21:33:49.225] #25 0x000000000085d746 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8218b40f8) at ../src/backend/postmaster/postmaster.c:1372 [21:33:49.225] userDoption = [21:33:49.225] listen_addr_saved = false [21:33:49.225] output_config_variable = [21:33:49.225] opt = [21:33:49.225] status = [21:33:49.225] #26 0x0000000000795405 in main (argc=4, argv=0x8218b40f8) at ../src/backend/main/main.c:197 [21:33:49.225] do_check_root =