[11:13:31.584] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [11:13:32.027] dumping /tmp/cores/postgres.7710.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [11:13:32.181] [New LWP 101733] [11:13:32.278] Core was generated by `postgres: postgres regression [local] MERGE'. [11:13:32.278] Program terminated with signal SIGABRT, Aborted. [11:13:32.278] Sent by thr_kill() from pid 7710 and user 1003. [11:13:32.278] #0 0x000000082ae67dca in thr_kill () from /lib/libc.so.7 [11:13:32.914] [11:13:32.914] Thread 1 (LWP 101733): [11:13:32.914] #0 0x000000082ae67dca in thr_kill () from /lib/libc.so.7 [11:13:32.914] No symbol table info available. [11:13:32.914] #1 0x000000082ade06f4 in raise () from /lib/libc.so.7 [11:13:32.914] No symbol table info available. [11:13:32.914] #2 0x000000082ae91bc9 in abort () from /lib/libc.so.7 [11:13:32.914] No symbol table info available. [11:13:32.914] #3 0x0000000000a50e17 in ExceptionalCondition (conditionName=, fileName=0x3715d8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [11:13:32.914] No locals. [11:13:32.914] #4 0x0000000000738800 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82153f150, materialize=, shouldFree=shouldFree@entry=0x82153f116) at ../src/backend/executor/execTuples.c:1737 [11:13:32.914] No locals. [11:13:32.914] #5 0x00000000006fe588 in ExecIRDeleteTriggers (estate=estate@entry=0x838703100, relinfo=relinfo@entry=0x8387036b0, slot=slot@entry=0x82153f150) at ../src/backend/commands/trigger.c:2832 [11:13:32.914] trigger = [11:13:32.914] oldtuple = [11:13:32.914] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8442cebc0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [11:13:32.914] trigdesc = 0x8387038c0 [11:13:32.914] newtuple = 0x0 [11:13:32.914] i = 0 [11:13:32.914] should_free = false [11:13:32.914] #6 0x000000000075da27 in ExecMergeMatched (context=0x82153f1f0, resultRelInfo=0x8387036b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [11:13:32.914] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [11:13:32.914] relaction = 0x8443fa118 [11:13:32.914] commandType = CMD_DELETE [11:13:32.914] result = TM_Ok [11:13:32.914] l__state = {l = 0x8443fa6d8, i = 0} [11:13:32.914] mtstate = 0x8387034a0 [11:13:32.914] newslot = 0x0 [11:13:32.914] rslot = 0x0 [11:13:32.914] estate = 0x18d65 [11:13:32.914] mergeActions = [11:13:32.914] econtext = 0x8443f9748 [11:13:32.914] epqstate = 0x838703588 [11:13:32.914] actionStates = 0x8443fa6d8 [11:13:32.914] l = [11:13:32.914] isNull = [11:13:32.914] lmerge_matched = [11:13:32.914] __error = [11:13:32.914] l__state = [11:13:32.914] updateCxt = [11:13:32.914] relaction = [11:13:32.914] commandType = [11:13:32.914] result = [11:13:32.914] __error = [11:13:32.914] resultRelationDesc = [11:13:32.914] lockmode = [11:13:32.914] inputslot = [11:13:32.914] epqslot = [11:13:32.914] was_matched = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] #7 ExecMerge (context=0x82153f1f0, resultRelInfo=0x8387036b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [11:13:32.914] matched = [11:13:32.914] rslot = 0x0 [11:13:32.914] #8 ExecModifyTable (pstate=0x8387034a0) at ../src/backend/executor/nodeModifyTable.c:4067 [11:13:32.914] context = {mtstate = 0x8387034a0, epqstate = 0x838703588, estate = 0x838703100, planSlot = 0x8443f8268, tmfd = {ctid = {ip_blkid = {bi_hi = 62000, bi_lo = 8531}, ip_posid = 8}, xmax = 1145020328, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x844424a78} [11:13:32.914] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [11:13:32.914] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83872b118} [11:13:32.914] node = 0x8387034a0 [11:13:32.914] estate = 0x838703100 [11:13:32.914] operation = CMD_MERGE [11:13:32.914] resultRelInfo = 0x8387036b0 [11:13:32.914] subplanstate = 0x838704df0 [11:13:32.914] slot = [11:13:32.914] tupleid = 0x0 [11:13:32.914] oldtuple = 0x0 [11:13:32.914] oldSlot = [11:13:32.914] #9 0x000000000073283b in ExecProcNodeFirst (node=0x8387034a0) at ../src/backend/executor/execProcnode.c:464 [11:13:32.914] No locals. [11:13:32.914] #10 0x000000000072ab2a in ExecProcNode (node=0x8387034a0) at ../src/include/executor/executor.h:274 [11:13:32.914] No locals. [11:13:32.914] #11 ExecutePlan (estate=0x838703100, planstate=0x8387034a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83864af10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [11:13:32.914] current_tuple_count = [11:13:32.914] slot = [11:13:32.914] #12 standard_ExecutorRun (queryDesc=0x8385f5448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [11:13:32.914] estate = 0x838703100 [11:13:32.914] oldcontext = 0x83864ac00 [11:13:32.914] operation = CMD_MERGE [11:13:32.914] dest = 0x83864af10 [11:13:32.914] sendTuples = true [11:13:32.914] #13 0x000000000072a9df in ExecutorRun (queryDesc=0x18d65, queryDesc@entry=0x8385f5448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [11:13:32.914] No locals. [11:13:32.914] #14 0x00000000008ffa6f in ProcessQuery (plan=0x844424360, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82153f428) at ../src/backend/tcop/pquery.c:160 [11:13:32.914] queryDesc = 0x8385f5448 [11:13:32.914] #15 0x00000000008ff00d in PortalRunMulti (portal=portal@entry=0x838628100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83864af10, altdest=0xb42a10 , qc=qc@entry=0x82153f428) at ../src/backend/tcop/pquery.c:1286 [11:13:32.914] pstmt = 0x844424360 [11:13:32.914] stmtlist_item__state = {l = 0x844428c18, i = 0} [11:13:32.914] active_snapshot_set = true [11:13:32.914] stmtlist_item = 0x844428c30 [11:13:32.914] #16 0x00000000008feafc in FillPortalStore (portal=portal@entry=0x838628100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [11:13:32.914] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:13:32.914] treceiver = 0x83864af10 [11:13:32.914] #17 0x00000000008fe850 in PortalRun (portal=portal@entry=0x838628100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x844428c68, altdest=altdest@entry=0x844428c68, qc=0x82153f560) at ../src/backend/tcop/pquery.c:763 [11:13:32.914] _local_sigjmp_buf = {{_sjb = {9431023, 35305768216, 34918888536, 34918888768, 34918888544, 12104008, 12071792, 35305718016, 7112098687, 35305726208, 3573041, 34359738368}}} [11:13:32.914] _save_exception_stack = 0x82153f630 [11:13:32.914] _save_context_stack = 0x0 [11:13:32.914] _do_rethrow = false [11:13:32.914] saveTopTransactionResourceOwner = 0x838634518 [11:13:32.914] saveTopTransactionContext = 0x83855e000 [11:13:32.914] saveActivePortal = 0x0 [11:13:32.914] saveResourceOwner = 0x838634518 [11:13:32.914] savePortalContext = 0x0 [11:13:32.914] saveMemoryContext = 0x83855e000 [11:13:32.914] result = [11:13:32.914] nprocessed = [11:13:32.914] #18 0x00000000008fd75b in exec_simple_query (query_string=query_string@entry=0x838552100 "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 [11:13:32.914] cmdtaglen = [11:13:32.914] snapshot_set = [11:13:32.914] per_parsetree_context = 0x0 [11:13:32.914] plantree_list = [11:13:32.914] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:13:32.914] parsetree = 0x8443c6e68 [11:13:32.914] commandTag = CMDTAG_MERGE [11:13:32.914] cmdtagname = [11:13:32.914] querytree_list = [11:13:32.914] portal = 0x838628100 [11:13:32.914] format = 0 [11:13:32.914] receiver = 0x844428c68 [11:13:32.914] parsetree_item__state = {l = 0x8443c8730, i = 0} [11:13:32.914] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [11:13:32.914] dest = DestRemote [11:13:32.914] was_logged = [11:13:32.914] oldcontext = 0x83855e000 [11:13:32.914] parsetree_list = 0x8443c8730 [11:13:32.914] use_implicit_block = false [11:13:32.914] parsetree_item = 0x8443c8748 [11:13:32.914] save_log_statement_stats = [11:13:32.914] #19 0x00000000008fb544 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [11:13:32.914] query_string = 0x838552100 "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"... [11:13:32.914] input_message = {data = 0x838552100 "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} [11:13:32.914] firstchar = [11:13:32.914] local_sigjmp_buf = {{_sjb = {9415184, 34918889008, 34918888968, 34918889568, 12112744, 12059216, 8192, 8388608, 72057628956754815, 0, 0, 34359738369}}} [11:13:32.914] send_ready_for_query = false [11:13:32.914] idle_in_transaction_timeout_enabled = false [11:13:32.914] idle_session_timeout_enabled = false [11:13:32.914] #20 0x00000000008f6299 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [11:13:32.914] bsdata = [11:13:32.914] #21 0x0000000000850542 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821540370 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215402b8) at ../src/backend/postmaster/launch_backend.c:265 [11:13:32.914] pid = [11:13:32.914] #22 0x0000000000854ea1 in BackendStartup (client_sock=0x8215402b8) at ../src/backend/postmaster/postmaster.c:3593 [11:13:32.914] startup_data = {canAcceptConnections = CAC_OK} [11:13:32.914] bn = 0x83855e1c8 [11:13:32.914] pid = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] save_errno = [11:13:32.914] __error = [11:13:32.914] __error = [11:13:32.914] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [11:13:32.914] 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' , "\020\003T!\b\000\000\000\330\365\255*\b\000\000\000\v\000\000\000\000\000\000\000\016v\256*\b", '\000' , "P\003T!\b\000\000\000\024\003\205\000\000\000\000\000`\003T!\b", '\000' }, salen = 16}} [11:13:32.914] i = 0 [11:13:32.914] now = [11:13:32.914] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 718605412, events = 8, fd = 559151360, user_data = 0x82153fa90}, {pos = 575558664, events = 8, fd = 32, user_data = 0x82153fa80}, {pos = 2132957844, events = 1363, fd = 575528968, user_data = 0x8224de408}, {pos = 575531016, events = 8, fd = 575532040, user_data = 0x8224e2008}, {pos = 575546376, events = 8, fd = 575547400, user_data = 0x8224e2c08}, {pos = 575549448, events = 8, fd = 575550472, user_data = 0x8224e3808}, {pos = 575552520, events = 8, fd = 575553544, user_data = 0x8224e4408}, {pos = 575555592, events = 8, fd = 575556616, user_data = 0x8224e5008}, {pos = 575558664, events = 8, fd = -1, user_data = 0x82af282e0}, {pos = 559151600, events = 8, fd = 720196009, user_data = 0x0}, {pos = 4096, events = 0, fd = -72583904, user_data = 0x82af287e8}, {pos = 926981088, events = 8, fd = 160, user_data = 0x0}, {pos = 905662608, events = 8, fd = 559151808, user_data = 0x82aeb392c}, {pos = 4096, events = 0, fd = 718621028, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 575584824, user_data = 0x800000001}, {pos = 575558664, events = 8, fd = 718534872, user_data = 0x82153fb48}, {pos = 559151360, events = 8, fd = 32, user_data = 0x82ad50c64}, {pos = 575558664, events = 8, fd = 575584824, user_data = 0x0}, {pos = 2625, events = 0, fd = 559151920, user_data = 0x5537f225645}, {pos = 718621028, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 575584824, events = 8, fd = 1, user_data = 0x8224e5408}, {pos = 945037312, events = 8, fd = 1, user_data = 0x838542194}, {pos = 0, events = 0, fd = 559151872, user_data = 0x82aae6c0c}, {pos = 1, events = 0, fd = 945037312, user_data = 0x82153fb30}, {pos = 716070580, events = 8, fd = 720347488, user_data = 0x82aefa160 }, {pos = 718717120, events = 8, fd = 575558664, user_data = 0x82153fc10}, {pos = 2132956204, events = 1363, fd = 905662608, user_data = 0x800000001}, {pos = 2132955822, events = 1363, fd = 12240, user_data = 0x82153fb38}, {pos = 559152144, events = 8, fd = 945743848, user_data = 0x821540180}, {pos = 2133036688, events = 1363, fd = 575558664, user_data = 0x82153037f}, {pos = 720004508, events = 8, fd = 575528968, user_data = 0x0}, {pos = 575558664, events = 8, fd = 12240, user_data = 0x82ad30000}, {pos = 1964368, events = 0, fd = 720347488, user_data = 0x82ad50c64}, {pos = 15616, events = 0, fd = 559153328, user_data = 0x82153fc80}, {pos = 719278478, events = 8, fd = 720386104, user_data = 0x82153fc44}, {pos = 945481178, events = 8, fd = 559153328, user_data = 0x82153fc80}, {pos = 719369733, events = 8, fd = 559152194, user_data = 0x8215400b0}, {pos = 559153328, events = 8, fd = 0, user_data = 0x99076591fbac7520}, {pos = 559153328, events = 8, fd = 945481176, user_data = 0x821540180}, {pos = 720386104, events = 8, fd = 0, user_data = 0x8215400f0}, {pos = 719369997, events = 8, fd = 0, user_data = 0x0}, {pos = 559153696, events = 8, fd = 945481176, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2132984841, events = 1363, fd = 559152600, user_data = 0x82ad50c64}, {pos = 2503, events = 0, fd = 2132984841, user_data = 0x82153fdf8}, {pos = 718605412, events = 8, fd = 2758, user_data = 0x82ad4a120}, {pos = 559152504, events = 8, fd = 575558664, user_data = 0x82153fdf8}, {pos = 718577952, events = 8, fd = 559152608, user_data = 0x5537f227465}, {pos = 0, events = 0, fd = 0, user_data = 0x82af1c0f0}, {pos = 718538064, events = 8, fd = 0, user_data = 0x0}, {pos = 720415152, events = 8, fd = 2132984841, user_data = 0x82153fe88}, {pos = 718605412, events = 8, fd = 2924, user_data = 0x82ad4a3b8}, {pos = 559152648, events = 8, fd = 575558664, user_data = 0x82153fe88}, {pos = 718578616, events = 8, fd = 559152752, user_data = 0x5537f227465}, {pos = 575582264, events = 8, fd = 2675057, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 575558664, events = 8, fd = 718538064, user_data = 0x821540148}, {pos = 575558664, events = 8, fd = 559153192, user_data = 0x1e}, {pos = 718542048, events = 8, fd = 559152920, user_data = 0x8224ea248}, {pos = 559153368, events = 8, fd = 559152896, user_data = 0x5537f22bda3}, {pos = 575582264, events = 8, fd = 2698542, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 575582264, user_data = 0x1}} [11:13:32.914] last_touch_time = 1712229034 [11:13:32.914] last_lockfile_recheck_time = 1712229034 [11:13:32.914] nevents = 1 [11:13:32.914] #24 0x0000000000852776 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8215408b8) at ../src/backend/postmaster/postmaster.c:1372 [11:13:32.914] userDoption = [11:13:32.914] listen_addr_saved = false [11:13:32.914] output_config_variable = [11:13:32.914] opt = [11:13:32.914] status = [11:13:32.914] #25 0x000000000078d855 in main (argc=8, argv=0x8215408b8) at ../src/backend/main/main.c:197 [11:13:32.914] do_check_root = [11:13:32.932] [11:13:32.932] [11:13:32.932] [11:13:33.007] dumping /tmp/cores/postgres.8639.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:13:33.170] [New LWP 100131] [11:13:33.249] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [11:13:33.249] Program terminated with signal SIGABRT, Aborted. [11:13:33.249] Sent by thr_kill() from pid 8639 and user 1003. [11:13:33.249] #0 0x000000082cd09dca in thr_kill () from /lib/libc.so.7 [11:13:33.946] [11:13:33.946] Thread 1 (LWP 100131): [11:13:33.946] #0 0x000000082cd09dca in thr_kill () from /lib/libc.so.7 [11:13:33.946] No symbol table info available. [11:13:33.946] #1 0x000000082cc826f4 in raise () from /lib/libc.so.7 [11:13:33.946] No symbol table info available. [11:13:33.946] #2 0x000000082cd33bc9 in abort () from /lib/libc.so.7 [11:13:33.946] No symbol table info available. [11:13:33.946] #3 0x0000000000a50e17 in ExceptionalCondition (conditionName=, fileName=0x3715d8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [11:13:33.946] No locals. [11:13:33.946] #4 0x0000000000738800 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821591f90, materialize=, shouldFree=shouldFree@entry=0x821591f56) at ../src/backend/executor/execTuples.c:1737 [11:13:33.946] No locals. [11:13:33.946] #5 0x00000000006fe588 in ExecIRDeleteTriggers (estate=estate@entry=0x833fde100, relinfo=relinfo@entry=0x833fde6b0, slot=slot@entry=0x821591f90) at ../src/backend/commands/trigger.c:2832 [11:13:33.946] trigger = [11:13:33.946] oldtuple = [11:13:33.946] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8401f7960, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [11:13:33.946] trigdesc = 0x833fde8c0 [11:13:33.946] newtuple = 0x0 [11:13:33.946] i = 0 [11:13:33.946] should_free = false [11:13:33.946] #6 0x000000000075da27 in ExecMergeMatched (context=0x821592030, resultRelInfo=0x833fde6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [11:13:33.946] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [11:13:33.946] relaction = 0x8402ef918 [11:13:33.946] commandType = CMD_DELETE [11:13:33.946] result = TM_Ok [11:13:33.946] l__state = {l = 0x8402efed8, i = 0} [11:13:33.946] mtstate = 0x833fde4a0 [11:13:33.946] newslot = 0x0 [11:13:33.946] rslot = 0x0 [11:13:33.946] estate = 0x18723 [11:13:33.946] mergeActions = [11:13:33.946] econtext = 0x8402eef48 [11:13:33.946] epqstate = 0x833fde588 [11:13:33.946] actionStates = 0x8402efed8 [11:13:33.946] l = [11:13:33.946] isNull = [11:13:33.946] lmerge_matched = [11:13:33.946] __error = [11:13:33.946] l__state = [11:13:33.946] updateCxt = [11:13:33.946] relaction = [11:13:33.946] commandType = [11:13:33.946] result = [11:13:33.946] __error = [11:13:33.946] resultRelationDesc = [11:13:33.946] lockmode = [11:13:33.946] inputslot = [11:13:33.946] epqslot = [11:13:33.946] was_matched = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] #7 ExecMerge (context=0x821592030, resultRelInfo=0x833fde6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [11:13:33.946] matched = [11:13:33.946] rslot = 0x0 [11:13:33.946] #8 ExecModifyTable (pstate=0x833fde4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [11:13:33.946] context = {mtstate = 0x833fde4a0, epqstate = 0x833fde588, estate = 0x833fde100, planSlot = 0x8402eda68, tmfd = {ctid = {ip_blkid = {bi_hi = 8304, bi_lo = 8537}, ip_posid = 8}, xmax = 1076819880, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x840323f78} [11:13:33.946] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [11:13:33.946] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x833fe8118} [11:13:33.946] node = 0x833fde4a0 [11:13:33.946] estate = 0x833fde100 [11:13:33.946] operation = CMD_MERGE [11:13:33.946] resultRelInfo = 0x833fde6b0 [11:13:33.946] subplanstate = 0x833fdfdf0 [11:13:33.946] slot = [11:13:33.946] tupleid = 0x0 [11:13:33.946] oldtuple = 0x0 [11:13:33.946] oldSlot = [11:13:33.946] #9 0x000000000073283b in ExecProcNodeFirst (node=0x833fde4a0) at ../src/backend/executor/execProcnode.c:464 [11:13:33.946] No locals. [11:13:33.946] #10 0x000000000072ab2a in ExecProcNode (node=0x833fde4a0) at ../src/include/executor/executor.h:274 [11:13:33.946] No locals. [11:13:33.946] #11 ExecutePlan (estate=0x833fde100, planstate=0x833fde4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x833e1a710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [11:13:33.946] current_tuple_count = [11:13:33.946] slot = [11:13:33.946] #12 standard_ExecutorRun (queryDesc=0x833ec5448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [11:13:33.946] estate = 0x833fde100 [11:13:33.946] oldcontext = 0x833e1a400 [11:13:33.946] operation = CMD_MERGE [11:13:33.946] dest = 0x833e1a710 [11:13:33.946] sendTuples = true [11:13:33.946] #13 0x000000000072a9df in ExecutorRun (queryDesc=0x18723, queryDesc@entry=0x833ec5448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [11:13:33.946] No locals. [11:13:33.946] #14 0x00000000008ffa6f in ProcessQuery (plan=0x840323860, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821592268) at ../src/backend/tcop/pquery.c:160 [11:13:33.946] queryDesc = 0x833ec5448 [11:13:33.946] #15 0x00000000008ff00d in PortalRunMulti (portal=portal@entry=0x833ea5100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x833e1a710, altdest=0xb42a10 , qc=qc@entry=0x821592268) at ../src/backend/tcop/pquery.c:1286 [11:13:33.946] pstmt = 0x840323860 [11:13:33.946] stmtlist_item__state = {l = 0x840328118, i = 0} [11:13:33.946] active_snapshot_set = true [11:13:33.946] stmtlist_item = 0x840328130 [11:13:33.946] #16 0x00000000008feafc in FillPortalStore (portal=portal@entry=0x833ea5100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [11:13:33.946] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:13:33.946] treceiver = 0x833e1a710 [11:13:33.946] #17 0x00000000008fe850 in PortalRun (portal=portal@entry=0x833ea5100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x840328168, altdest=altdest@entry=0x840328168, qc=0x8215923a0) at ../src/backend/tcop/pquery.c:763 [11:13:33.946] _local_sigjmp_buf = {{_sjb = {9431023, 35231071064, 34919228056, 34919228288, 34919228064, 12104008, 12071792, 35230732544, 7112098687, 35230740736, 3573041, 34359738368}}} [11:13:33.946] _save_exception_stack = 0x821592470 [11:13:33.946] _save_context_stack = 0x0 [11:13:33.946] _do_rethrow = false [11:13:33.946] saveTopTransactionResourceOwner = 0x833ef7b58 [11:13:33.946] saveTopTransactionContext = 0x833e18000 [11:13:33.946] saveActivePortal = 0x0 [11:13:33.946] saveResourceOwner = 0x833ef7b58 [11:13:33.946] savePortalContext = 0x0 [11:13:33.946] saveMemoryContext = 0x833e18000 [11:13:33.946] result = [11:13:33.946] nprocessed = [11:13:33.946] #18 0x00000000008fd75b in exec_simple_query (query_string=query_string@entry=0x833e0c100 "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 [11:13:33.946] cmdtaglen = [11:13:33.946] snapshot_set = [11:13:33.946] per_parsetree_context = 0x0 [11:13:33.946] plantree_list = [11:13:33.946] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:13:33.946] parsetree = 0x8402bdb28 [11:13:33.946] commandTag = CMDTAG_MERGE [11:13:33.946] cmdtagname = [11:13:33.946] querytree_list = [11:13:33.946] portal = 0x833ea5100 [11:13:33.946] format = 0 [11:13:33.946] receiver = 0x840328168 [11:13:33.946] parsetree_item__state = {l = 0x8402bf3f0, i = 0} [11:13:33.946] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [11:13:33.946] dest = DestRemote [11:13:33.946] was_logged = [11:13:33.946] oldcontext = 0x833e18000 [11:13:33.946] parsetree_list = 0x8402bf3f0 [11:13:33.946] use_implicit_block = false [11:13:33.946] parsetree_item = 0x8402bf408 [11:13:33.946] save_log_statement_stats = [11:13:33.946] #19 0x00000000008fb544 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [11:13:33.946] query_string = 0x833e0c100 "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"... [11:13:33.946] input_message = {data = 0x833e0c100 "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} [11:13:33.946] firstchar = [11:13:33.946] local_sigjmp_buf = {{_sjb = {9415184, 34919228528, 34919228488, 34919229088, 12112744, 12059216, 8192, 8388608, 72057628957148031, 0, 0, 34359738369}}} [11:13:33.946] send_ready_for_query = false [11:13:33.946] idle_in_transaction_timeout_enabled = false [11:13:33.946] idle_session_timeout_enabled = false [11:13:33.946] #20 0x00000000008f6299 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [11:13:33.946] bsdata = [11:13:33.946] #21 0x0000000000850542 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8215931b0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215930f8) at ../src/backend/postmaster/launch_backend.c:265 [11:13:33.946] pid = [11:13:33.946] #22 0x0000000000854ea1 in BackendStartup (client_sock=0x8215930f8) at ../src/backend/postmaster/postmaster.c:3593 [11:13:33.946] startup_data = {canAcceptConnections = CAC_OK} [11:13:33.946] bn = 0x833e18538 [11:13:33.946] pid = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] save_errno = [11:13:33.946] __error = [11:13:33.946] __error = [11:13:33.946] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [11:13:33.946] 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' , "P1Y!\b\000\000\000\330u\337*\b\000\000\000\v\000\000\000\000\000\000\000\016\366\337*\b", '\000' , "\2201Y!\b\000\000\000\024\003\205\000\000\000\000\000\2401Y!\b", '\000' }, salen = 16}} [11:13:33.946] i = 0 [11:13:33.946] now = [11:13:33.946] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 750726244, events = 8, fd = 559490880, user_data = 0x8215928d0}, {pos = 567653384, events = 8, fd = 32, user_data = 0x8215928c0}, {pos = 1992198804, events = 9476, fd = 567623688, user_data = 0x821d54408}, {pos = 567625736, events = 8, fd = 567626760, user_data = 0x821d58008}, {pos = 567641096, events = 8, fd = 567642120, user_data = 0x821d58c08}, {pos = 567644168, events = 8, fd = 567645192, user_data = 0x821d59808}, {pos = 567647240, events = 8, fd = 567648264, user_data = 0x821d5a408}, {pos = 567650312, events = 8, fd = 567651336, user_data = 0x821d5b008}, {pos = 567653384, events = 8, fd = 567672968, user_data = 0x821592a48}, {pos = 559491184, events = 8, fd = 1992224163, user_data = 0x0}, {pos = 2571378, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 567676984, events = 8, fd = 1, user_data = 0x821d5b408}, {pos = 750634152, events = 8, fd = 559491912, user_data = 0x821d5b408}, {pos = 559491168, events = 0, fd = 750741860, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 567679544, user_data = 0x1}, {pos = 567653384, events = 8, fd = 750655704, user_data = 0x821592988}, {pos = 559490880, events = 8, fd = 32, user_data = 0x82cbf2c64}, {pos = 567653384, events = 8, fd = 567679544, user_data = 0x0}, {pos = 2625, events = 0, fd = 559491440, user_data = 0x250476be8645}, {pos = 750741860, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567679544, events = 8, fd = 1, user_data = 0x821d5b408}, {pos = 870301696, events = 8, fd = 1, user_data = 0x833dfc194}, {pos = 0, events = 0, fd = 559491392, user_data = 0x82adfec0c}, {pos = 1, events = 0, fd = 870301696, user_data = 0x821592970}, {pos = 719314612, events = 8, fd = 752468320, user_data = 0x82cd9c160 }, {pos = 750837952, events = 8, fd = 567653384, user_data = 0x821592a50}, {pos = 1992197164, events = 9476, fd = 567652360, user_data = 0x800000001}, {pos = 1992196782, events = 9476, fd = 12240, user_data = 0x821592978}, {pos = 559491664, events = 8, fd = 871098344, user_data = 0x821592fc0}, {pos = 1992277648, events = 9476, fd = 567653384, user_data = 0x82159037f}, {pos = 752125106, events = 8, fd = 567623688, user_data = 0x0}, {pos = 567653384, events = 8, fd = 12240, user_data = 0x82cbd2000}, {pos = 1964368, events = 0, fd = 752468320, user_data = 0x82cbf2c64}, {pos = 15616, events = 0, fd = 559492848, user_data = 0x821592ac0}, {pos = 751399310, events = 8, fd = 752506936, user_data = 0x821592a84}, {pos = 870753754, events = 8, fd = 559492848, user_data = 0x821592ac0}, {pos = 751490565, events = 8, fd = 559491714, user_data = 0x821592ef0}, {pos = 559492848, events = 8, fd = 0, user_data = 0x54fd276047137b6a}, {pos = 559492848, events = 8, fd = 870753752, user_data = 0x821592fc0}, {pos = 752506936, events = 8, fd = 0, user_data = 0x821592f30}, {pos = 751490829, events = 8, fd = 0, user_data = 0x0}, {pos = 559493216, events = 8, fd = 870753752, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1992225801, events = 9476, fd = 559492120, user_data = 0x82cbf2c64}, {pos = 2503, events = 0, fd = 1992225801, user_data = 0x821592c38}, {pos = 750726244, events = 8, fd = 2758, user_data = 0x82cbec120}, {pos = 559492024, events = 8, fd = 567653384, user_data = 0x821592c38}, {pos = 750698784, events = 8, fd = 559492128, user_data = 0x250476bea465}, {pos = 0, events = 0, fd = 0, user_data = 0x82cdbe0f0}, {pos = 750658896, events = 8, fd = 0, user_data = 0x0}, {pos = 752535984, events = 8, fd = 1992225801, user_data = 0x821592cc8}, {pos = 750726244, events = 8, fd = 2924, user_data = 0x82cbec3b8}, {pos = 559492168, events = 8, fd = 567653384, user_data = 0x821592cc8}, {pos = 750699448, events = 8, fd = 559492272, user_data = 0x250476bea465}, {pos = 567676984, events = 8, fd = 2675057, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567653384, events = 8, fd = 750658896, user_data = 0x821592f88}, {pos = 567653384, events = 8, fd = 559492712, user_data = 0x1e}, {pos = 750662880, events = 8, fd = 559492440, user_data = 0x821d60248}, {pos = 559492888, events = 8, fd = 559492416, user_data = 0x250476beeda3}, {pos = 567676984, events = 8, fd = 2698542, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567676984, user_data = 0x1}} [11:13:33.946] last_touch_time = 1712229036 [11:13:33.946] last_lockfile_recheck_time = 1712229036 [11:13:33.946] nevents = 1 [11:13:33.946] #24 0x0000000000852776 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8215936f0) at ../src/backend/postmaster/postmaster.c:1372 [11:13:33.946] userDoption = [11:13:33.946] listen_addr_saved = false [11:13:33.946] output_config_variable = [11:13:33.946] opt = [11:13:33.946] status = [11:13:33.946] #25 0x000000000078d855 in main (argc=4, argv=0x8215936f0) at ../src/backend/main/main.c:197 [11:13:33.946] do_check_root = [11:13:33.962] [11:13:33.962] [11:13:33.962] [11:13:34.039] dumping /tmp/cores/postgres.14018.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:13:34.187] [New LWP 101660] [11:13:34.267] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [11:13:34.267] Program terminated with signal SIGABRT, Aborted. [11:13:34.267] Sent by thr_kill() from pid 14018 and user 1003. [11:13:34.267] #0 0x000000082ed96dca in thr_kill () from /lib/libc.so.7 [11:13:34.930] [11:13:34.930] Thread 1 (LWP 101660): [11:13:34.930] #0 0x000000082ed96dca in thr_kill () from /lib/libc.so.7 [11:13:34.930] No symbol table info available. [11:13:34.930] #1 0x000000082ed0f6f4 in raise () from /lib/libc.so.7 [11:13:34.930] No symbol table info available. [11:13:34.930] #2 0x000000082edc0bc9 in abort () from /lib/libc.so.7 [11:13:34.930] No symbol table info available. [11:13:34.930] #3 0x0000000000a50e17 in ExceptionalCondition (conditionName=, fileName=0x3715d8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [11:13:34.930] No locals. [11:13:34.930] #4 0x0000000000738800 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821b1e510, materialize=, shouldFree=shouldFree@entry=0x821b1e4d6) at ../src/backend/executor/execTuples.c:1737 [11:13:34.930] No locals. [11:13:34.930] #5 0x00000000006fe588 in ExecIRDeleteTriggers (estate=estate@entry=0x83925d100, relinfo=relinfo@entry=0x83925d6b0, slot=slot@entry=0x821b1e510) at ../src/backend/commands/trigger.c:2832 [11:13:34.930] trigger = [11:13:34.930] oldtuple = [11:13:34.930] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83d7fc470, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [11:13:34.930] trigdesc = 0x83925d8c0 [11:13:34.930] newtuple = 0x0 [11:13:34.930] i = 0 [11:13:34.930] should_free = false [11:13:34.930] #6 0x000000000075da27 in ExecMergeMatched (context=0x821b1e5b0, resultRelInfo=0x83925d6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [11:13:34.930] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [11:13:34.930] relaction = 0x83d946718 [11:13:34.930] commandType = CMD_DELETE [11:13:34.930] result = TM_Ok [11:13:34.930] l__state = {l = 0x83d946cd8, i = 0} [11:13:34.930] mtstate = 0x83925d4a0 [11:13:34.930] newslot = 0x0 [11:13:34.930] rslot = 0x0 [11:13:34.930] estate = 0x18d1c [11:13:34.930] mergeActions = [11:13:34.930] econtext = 0x83d945d48 [11:13:34.930] epqstate = 0x83925d588 [11:13:34.930] actionStates = 0x83d946cd8 [11:13:34.930] l = [11:13:34.930] isNull = [11:13:34.930] lmerge_matched = [11:13:34.930] __error = [11:13:34.930] l__state = [11:13:34.930] updateCxt = [11:13:34.930] relaction = [11:13:34.930] commandType = [11:13:34.930] result = [11:13:34.930] __error = [11:13:34.930] resultRelationDesc = [11:13:34.930] lockmode = [11:13:34.930] inputslot = [11:13:34.930] epqslot = [11:13:34.930] was_matched = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] #7 ExecMerge (context=0x821b1e5b0, resultRelInfo=0x83925d6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [11:13:34.930] matched = [11:13:34.930] rslot = 0x0 [11:13:34.930] #8 ExecModifyTable (pstate=0x83925d4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [11:13:34.930] context = {mtstate = 0x83925d4a0, epqstate = 0x83925d588, estate = 0x83925d100, planSlot = 0x83d944868, tmfd = {ctid = {ip_blkid = {bi_hi = 26118, bi_lo = 41085}, ip_posid = 14249}, xmax = 4, cmax = 0, traversed = 96}, cpUpdateReturningSlot = 0x821b1e710} [11:13:34.930] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [11:13:34.930] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x839281118} [11:13:34.930] node = 0x83925d4a0 [11:13:34.930] estate = 0x83925d100 [11:13:34.930] operation = CMD_MERGE [11:13:34.930] resultRelInfo = 0x83925d6b0 [11:13:34.930] subplanstate = 0x83925edf0 [11:13:34.930] slot = [11:13:34.930] tupleid = 0x0 [11:13:34.930] oldtuple = 0x0 [11:13:34.930] oldSlot = [11:13:34.930] #9 0x000000000073283b in ExecProcNodeFirst (node=0x83925d4a0) at ../src/backend/executor/execProcnode.c:464 [11:13:34.930] No locals. [11:13:34.930] #10 0x000000000072ab2a in ExecProcNode (node=0x83925d4a0) at ../src/include/executor/executor.h:274 [11:13:34.930] No locals. [11:13:34.930] #11 ExecutePlan (estate=0x83925d100, planstate=0x83925d4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x839244310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [11:13:34.930] current_tuple_count = [11:13:34.930] slot = [11:13:34.930] #12 standard_ExecutorRun (queryDesc=0x839173448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [11:13:34.930] estate = 0x83925d100 [11:13:34.930] oldcontext = 0x839244000 [11:13:34.930] operation = CMD_MERGE [11:13:34.930] dest = 0x839244310 [11:13:34.930] sendTuples = true [11:13:34.930] #13 0x000000083b10c963 in pgss_ExecutorRun (queryDesc=0x839173448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [11:13:34.930] _local_sigjmp_buf = {{_sjb = {35350694194, 12104008, 34925045512, 34925045680, 35317560392, 34925045520, 1, 1, 35318465407, 35317560392, 12112736, 34359738368}}} [11:13:34.930] _save_exception_stack = 0x821b1e8d0 [11:13:34.930] _save_context_stack = 0x0 [11:13:34.930] _do_rethrow = false [11:13:34.930] #14 0x000000000072a9d8 in ExecutorRun (queryDesc=0x18d1c, queryDesc@entry=0x839173448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [11:13:34.930] No locals. [11:13:34.930] #15 0x00000000008ffa6f in ProcessQuery (plan=0x83d9097c0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821b1e898) at ../src/backend/tcop/pquery.c:160 [11:13:34.930] queryDesc = 0x839173448 [11:13:34.930] #16 0x00000000008ff00d in PortalRunMulti (portal=portal@entry=0x839155100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x839244310, altdest=0xb42a10 , qc=qc@entry=0x821b1e898) at ../src/backend/tcop/pquery.c:1286 [11:13:34.930] pstmt = 0x83d9097c0 [11:13:34.930] stmtlist_item__state = {l = 0x83d90e078, i = 0} [11:13:34.930] active_snapshot_set = true [11:13:34.930] stmtlist_item = 0x83d90e090 [11:13:34.930] #17 0x00000000008feafc in FillPortalStore (portal=portal@entry=0x839155100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [11:13:34.930] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:13:34.930] treceiver = 0x839244310 [11:13:34.930] #18 0x00000000008fe850 in PortalRun (portal=portal@entry=0x839155100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83d90e0c8, altdest=altdest@entry=0x83d90e0c8, qc=0x821b1e9d0) at ../src/backend/tcop/pquery.c:763 [11:13:34.930] _local_sigjmp_buf = {{_sjb = {9431023, 35317736600, 34925045960, 34925046192, 34925045968, 12104008, 12071792, 35317436672, 7112098687, 35317444864, 3573041, 34359738368}}} [11:13:34.930] _save_exception_stack = 0x821b1eaa0 [11:13:34.930] _save_context_stack = 0x0 [11:13:34.930] _do_rethrow = false [11:13:34.930] saveTopTransactionResourceOwner = 0x83919e498 [11:13:34.930] saveTopTransactionContext = 0x8390c6000 [11:13:34.930] saveActivePortal = 0x0 [11:13:34.930] saveResourceOwner = 0x83919e498 [11:13:34.930] savePortalContext = 0x0 [11:13:34.930] saveMemoryContext = 0x8390c6000 [11:13:34.930] result = [11:13:34.930] nprocessed = [11:13:34.930] #19 0x00000000008fd75b in exec_simple_query (query_string=query_string@entry=0x8390ba100 "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 [11:13:34.930] cmdtaglen = [11:13:34.930] snapshot_set = [11:13:34.930] per_parsetree_context = 0x0 [11:13:34.930] plantree_list = [11:13:34.930] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:13:34.930] parsetree = 0x83d8e52e8 [11:13:34.930] commandTag = CMDTAG_MERGE [11:13:34.930] cmdtagname = [11:13:34.930] querytree_list = [11:13:34.930] portal = 0x839155100 [11:13:34.930] format = 0 [11:13:34.930] receiver = 0x83d90e0c8 [11:13:34.930] parsetree_item__state = {l = 0x83d8e6bb0, i = 0} [11:13:34.930] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [11:13:34.930] dest = DestRemote [11:13:34.930] was_logged = [11:13:34.930] oldcontext = 0x8390c6000 [11:13:34.930] parsetree_list = 0x83d8e6bb0 [11:13:34.930] use_implicit_block = false [11:13:34.930] parsetree_item = 0x83d8e6bc8 [11:13:34.930] save_log_statement_stats = [11:13:34.930] #20 0x00000000008fb544 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [11:13:34.930] query_string = 0x8390ba100 "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"... [11:13:34.930] input_message = {data = 0x8390ba100 "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} [11:13:34.930] firstchar = [11:13:34.930] local_sigjmp_buf = {{_sjb = {9415184, 34925046432, 34925046392, 34925046992, 12112744, 12059216, 8192, 8388608, 72057628962915199, 0, 0, 1}}} [11:13:34.930] send_ready_for_query = false [11:13:34.930] idle_in_transaction_timeout_enabled = false [11:13:34.930] idle_session_timeout_enabled = false [11:13:34.930] #21 0x00000000008f6299 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [11:13:34.930] bsdata = [11:13:34.930] #22 0x0000000000850542 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821b1f7e0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821b1f728) at ../src/backend/postmaster/launch_backend.c:265 [11:13:34.930] pid = [11:13:34.930] #23 0x0000000000854ea1 in BackendStartup (client_sock=0x821b1f728) at ../src/backend/postmaster/postmaster.c:3593 [11:13:34.930] startup_data = {canAcceptConnections = CAC_OK} [11:13:34.930] bn = 0x8390c63a8 [11:13:34.930] pid = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] save_errno = [11:13:34.930] __error = [11:13:34.930] __error = [11:13:34.930] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [11:13:34.930] 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' , "\200\367\261!\b\000\000\000\330U\341,\b\000\000\000\v\000\000\000\000\000\000\000\016\326\341,\b", '\000' , "\300\367\261!\b\000\000\000\024\003\205\000\000\000\000\000\320\367\261!\b", '\000' }, salen = 16}} [11:13:34.930] i = 0 [11:13:34.930] now = [11:13:34.930] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 565309184, events = 8, fd = 576807944, user_data = 0x21}, {pos = 565309168, events = 8, fd = 1528867476, user_data = 0x82260f008}, {pos = 576779272, events = 8, fd = 576780296, user_data = 0x82260fc08}, {pos = 576794632, events = 8, fd = 576795656, user_data = 0x822613808}, {pos = 576797704, events = 8, fd = 576798728, user_data = 0x822614408}, {pos = 576800776, events = 8, fd = 576801800, user_data = 0x822615008}, {pos = 576803848, events = 8, fd = 576804872, user_data = 0x822615c08}, {pos = 576806920, events = 8, fd = 576807944, user_data = 0x82261b088}, {pos = 565309560, events = 8, fd = 565309072, user_data = 0x32b15b210da3}, {pos = 576807944, events = 8, fd = 2571378, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 576831544, user_data = 0x1}, {pos = 576807944, events = 8, fd = 784766120, user_data = 0x821b1f178}, {pos = 576807944, events = 8, fd = 565309040, user_data = 0x273bbc}, {pos = 565309632, events = 8, fd = 784873828, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 576834104, user_data = 0x32b100000001}, {pos = 576807944, events = 8, fd = 784787672, user_data = 0x821b1efb8}, {pos = 565308768, events = 8, fd = 33, user_data = 0x82ec7fc64}, {pos = 576807944, events = 8, fd = 576834104, user_data = 0x0}, {pos = 2625, events = 0, fd = 565309344, user_data = 0x32b15b20a645}, {pos = 784873828, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 576834104, events = 8, fd = 1, user_data = 0x822616408}, {pos = 956997632, events = 8, fd = 1, user_data = 0x8390aa194}, {pos = 0, events = 0, fd = 565309296, user_data = 0x82ce1cc0c}, {pos = 1, events = 0, fd = 956997632, user_data = 0x821b1efa0}, {pos = 752991924, events = 8, fd = 786600288, user_data = 0x82ee29160 }, {pos = 784969920, events = 8, fd = 576807944, user_data = 0x821b1f080}, {pos = 1528865836, events = 12977, fd = 80627796, user_data = 0x1}, {pos = 1528865454, events = 12977, fd = 12240, user_data = 0x821b1efa8}, {pos = 565309568, events = 8, fd = 957794280, user_data = 0x821b1f5f0}, {pos = 1528946320, events = 12977, fd = 576807944, user_data = 0x821b1037f}, {pos = 786257074, events = 8, fd = 565309872, user_data = 0x32b100000000}, {pos = 576807944, events = 8, fd = 12240, user_data = 0x82ec5f000}, {pos = 1964368, events = 0, fd = 786600288, user_data = 0x82ec7fc64}, {pos = 15616, events = 0, fd = 565310752, user_data = 0x821b1f0f0}, {pos = 785531278, events = 8, fd = 786638904, user_data = 0x821b1f0b4}, {pos = 957449690, events = 8, fd = 565310752, user_data = 0x821b1f0f0}, {pos = 785622533, events = 8, fd = 565309618, user_data = 0x821b1f520}, {pos = 565310752, events = 8, fd = 0, user_data = 0xf0c437a9a07d6606}, {pos = 565310752, events = 8, fd = 957449688, user_data = 0x821b1f5f0}, {pos = 786638904, events = 8, fd = 0, user_data = 0x821b1f560}, {pos = 785622797, events = 8, fd = 0, user_data = 0x0}, {pos = 565311120, events = 8, fd = 957449688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1528894473, user_data = 0x821b1f238}, {pos = 784858212, events = 8, fd = 2503, user_data = 0x32b15b211409}, {pos = 565310040, events = 8, fd = 784858212, user_data = 0xac6}, {pos = 784830752, events = 8, fd = 565309912, user_data = 0x822616408}, {pos = 565310040, events = 8, fd = 784830752, user_data = 0x821b1f240}, {pos = 1528874085, events = 12977, fd = 0, user_data = 0x800000000}, {pos = 565310000, events = 8, fd = 784790864, user_data = 0x0}, {pos = 0, events = 0, fd = 565309968, user_data = 0x32b15b211409}, {pos = 565310184, events = 8, fd = 784858212, user_data = 0xb6c}, {pos = 784831416, events = 8, fd = 565310056, user_data = 0x822616408}, {pos = 565310184, events = 8, fd = 784831416, user_data = 0x821b1f2d0}, {pos = 1528874085, events = 12977, fd = 576831544, user_data = 0x28d171}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 576807944, user_data = 0x82ec6f550}, {pos = 565310904, events = 8, fd = 576807944, user_data = 0x21b1f498}, {pos = 31, events = 0, fd = 0, user_data = 0x821b1f378}, {pos = 576829320, events = 8, fd = 565310792, user_data = 0x821b1f360}, {pos = 1528892835, events = 12977, fd = 576831544, user_data = 0x292d2e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82261c038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [11:13:34.930] last_touch_time = 1712229057 [11:13:34.930] last_lockfile_recheck_time = 1712229057 [11:13:34.930] nevents = 1 [11:13:34.930] #25 0x0000000000852776 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821b1fd20) at ../src/backend/postmaster/postmaster.c:1372 [11:13:34.930] userDoption = [11:13:34.930] listen_addr_saved = false [11:13:34.930] output_config_variable = [11:13:34.930] opt = [11:13:34.930] status = [11:13:34.930] #26 0x000000000078d855 in main (argc=4, argv=0x821b1fd20) at ../src/backend/main/main.c:197 [11:13:34.930] do_check_root =