[08:06:46.196] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [08:06:46.552] dumping /tmp/cores/postgres.7981.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:06:46.686] [New LWP 101672] [08:06:46.771] Core was generated by `postgres: postgres regression [local] MERGE'. [08:06:46.771] Program terminated with signal SIGABRT, Aborted. [08:06:46.771] Sent by thr_kill() from pid 7981 and user 1003. [08:06:46.771] #0 0x000000082bcdddca in thr_kill () from /lib/libc.so.7 [08:06:47.378] [08:06:47.378] Thread 1 (LWP 101672): [08:06:47.378] #0 0x000000082bcdddca in thr_kill () from /lib/libc.so.7 [08:06:47.378] No symbol table info available. [08:06:47.378] #1 0x000000082bc566f4 in raise () from /lib/libc.so.7 [08:06:47.378] No symbol table info available. [08:06:47.378] #2 0x000000082bd07bc9 in abort () from /lib/libc.so.7 [08:06:47.378] No symbol table info available. [08:06:47.378] #3 0x0000000000a5d8f7 in ExceptionalCondition (conditionName=, fileName=0x372e95 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:06:47.378] No locals. [08:06:47.378] #4 0x000000000073fe50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821396b20, materialize=, shouldFree=shouldFree@entry=0x821396ac6) at ../src/backend/executor/execTuples.c:1737 [08:06:47.378] No locals. [08:06:47.378] #5 0x0000000000706038 in ExecIRDeleteTriggers (estate=estate@entry=0x834cd7100, relinfo=relinfo@entry=0x834cd76b0, slot=slot@entry=0x821396b20) at ../src/backend/commands/trigger.c:2841 [08:06:47.378] trigger = [08:06:47.378] oldtuple = [08:06:47.378] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x836ae4fe0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:06:47.378] trigdesc = 0x834cd78c0 [08:06:47.378] newtuple = 0x0 [08:06:47.378] i = 0 [08:06:47.378] should_free = false [08:06:47.378] #6 0x0000000000764f4a in ExecMergeMatched (context=0x821396be0, resultRelInfo=0x834cd76b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [08:06:47.378] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:06:47.378] relaction = 0x836b94a20 [08:06:47.378] commandType = CMD_DELETE [08:06:47.378] result = TM_Ok [08:06:47.378] l__state = {l = 0x836c08048, i = 0} [08:06:47.378] mtstate = 0x834cd74a0 [08:06:47.378] newslot = 0x0 [08:06:47.378] rslot = 0x0 [08:06:47.378] estate = 0x18d28 [08:06:47.378] mergeActions = [08:06:47.378] econtext = 0x836c070e8 [08:06:47.378] epqstate = 0x834cd7588 [08:06:47.378] actionStates = 0x836c08048 [08:06:47.378] l = [08:06:47.378] isNull = [08:06:47.378] lmerge_matched = [08:06:47.378] __error = [08:06:47.378] l__state = [08:06:47.378] updateCxt = [08:06:47.378] relaction = [08:06:47.378] commandType = [08:06:47.378] result = [08:06:47.378] __error = [08:06:47.378] resultRelationDesc = [08:06:47.378] lockmode = [08:06:47.378] inputslot = [08:06:47.378] epqslot = [08:06:47.378] was_matched = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] #7 ExecMerge (context=0x821396be0, resultRelInfo=0x834cd76b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [08:06:47.378] matched = [08:06:47.378] rslot = 0x0 [08:06:47.378] #8 ExecModifyTable (pstate=0x834cd74a0) at ../src/backend/executor/nodeModifyTable.c:4112 [08:06:47.378] context = {mtstate = 0x834cd74a0, epqstate = 0x834cd7588, estate = 0x834cd7100, planSlot = 0x836b94990, tmfd = {ctid = {ip_blkid = {bi_hi = 29696, bi_lo = 14019}, ip_posid = 8}, xmax = 885880496, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x834cd7100} [08:06:47.378] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [08:06:47.378] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834ceb118} [08:06:47.378] node = 0x834cd74a0 [08:06:47.378] estate = 0x834cd7100 [08:06:47.378] operation = CMD_MERGE [08:06:47.378] resultRelInfo = 0x834cd76b0 [08:06:47.378] subplanstate = 0x834cd8df0 [08:06:47.378] slot = [08:06:47.378] tupleid = 0x0 [08:06:47.378] oldtuple = 0x0 [08:06:47.378] oldSlot = [08:06:47.378] #9 0x0000000000739eeb in ExecProcNodeFirst (node=0x834cd74a0) at ../src/backend/executor/execProcnode.c:464 [08:06:47.378] No locals. [08:06:47.378] #10 0x00000000007321da in ExecProcNode (node=0x834cd74a0) at ../src/include/executor/executor.h:274 [08:06:47.378] No locals. [08:06:47.378] #11 ExecutePlan (estate=0x834cd7100, planstate=0x834cd74a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x834cb8310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:06:47.378] current_tuple_count = [08:06:47.378] slot = [08:06:47.378] #12 standard_ExecutorRun (queryDesc=0x834bb8448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:06:47.378] estate = 0x834cd7100 [08:06:47.378] oldcontext = 0x834cb8000 [08:06:47.378] operation = CMD_MERGE [08:06:47.378] dest = 0x834cb8310 [08:06:47.378] sendTuples = true [08:06:47.378] #13 0x000000000073208f in ExecutorRun (queryDesc=0x18d28, queryDesc@entry=0x834bb8448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [08:06:47.378] No locals. [08:06:47.378] #14 0x000000000090b0ef in ProcessQuery (plan=0x836c348e0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821396df8) at ../src/backend/tcop/pquery.c:160 [08:06:47.378] queryDesc = 0x834bb8448 [08:06:47.378] #15 0x000000000090a68d in PortalRunMulti (portal=portal@entry=0x834beb100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x834cb8310, altdest=0xb519d0 , qc=qc@entry=0x821396df8) at ../src/backend/tcop/pquery.c:1286 [08:06:47.378] pstmt = 0x836c348e0 [08:06:47.378] stmtlist_item__state = {l = 0x836c39198, i = 0} [08:06:47.378] active_snapshot_set = true [08:06:47.378] stmtlist_item = 0x836c391b0 [08:06:47.378] #16 0x000000000090a17c in FillPortalStore (portal=portal@entry=0x834beb100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:06:47.378] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:06:47.378] treceiver = 0x834cb8310 [08:06:47.378] #17 0x0000000000909ed0 in PortalRun (portal=portal@entry=0x834beb100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x836c391e8, altdest=altdest@entry=0x836c391e8, qc=0x821396f30) at ../src/backend/tcop/pquery.c:763 [08:06:47.378] _local_sigjmp_buf = {{_sjb = {9477743, 35244722520, 34917150248, 34917150480, 34917150256, 12166280, 12134064, 35244650752, 7112098687, 35244658944, 3579123, 34359738368}}} [08:06:47.378] _save_exception_stack = 0x821397000 [08:06:47.378] _save_context_stack = 0x0 [08:06:47.378] _do_rethrow = false [08:06:47.378] saveTopTransactionResourceOwner = 0x834bfc958 [08:06:47.378] saveTopTransactionContext = 0x834b21000 [08:06:47.378] saveActivePortal = 0x0 [08:06:47.378] saveResourceOwner = 0x834bfc958 [08:06:47.378] savePortalContext = 0x0 [08:06:47.378] saveMemoryContext = 0x834b21000 [08:06:47.378] result = [08:06:47.378] nprocessed = [08:06:47.378] #18 0x0000000000908ddb in exec_simple_query (query_string=query_string@entry=0x834b15100 "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 [08:06:47.378] cmdtaglen = [08:06:47.378] snapshot_set = [08:06:47.378] per_parsetree_context = 0x0 [08:06:47.378] plantree_list = [08:06:47.378] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:06:47.378] parsetree = 0x836bd54a8 [08:06:47.378] commandTag = CMDTAG_MERGE [08:06:47.378] cmdtagname = [08:06:47.378] querytree_list = [08:06:47.378] portal = 0x834beb100 [08:06:47.378] format = 0 [08:06:47.378] receiver = 0x836c391e8 [08:06:47.378] parsetree_item__state = {l = 0x836bd6d70, i = 0} [08:06:47.378] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:06:47.378] dest = DestRemote [08:06:47.378] was_logged = [08:06:47.378] oldcontext = 0x834b21000 [08:06:47.378] parsetree_list = 0x836bd6d70 [08:06:47.378] use_implicit_block = false [08:06:47.378] parsetree_item = 0x836bd6d88 [08:06:47.378] save_log_statement_stats = [08:06:47.378] #19 0x0000000000906bb4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:06:47.378] query_string = 0x834b15100 "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"... [08:06:47.378] input_message = {data = 0x834b15100 "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} [08:06:47.378] firstchar = [08:06:47.378] local_sigjmp_buf = {{_sjb = {9461888, 34917150720, 34917150680, 34917151280, 12175016, 12121488, 8192, 8388608, 72057628955050879, 0, 0, 34359738369}}} [08:06:47.378] send_ready_for_query = false [08:06:47.378] idle_in_transaction_timeout_enabled = false [08:06:47.378] idle_session_timeout_enabled = false [08:06:47.378] #20 0x0000000000901689 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [08:06:47.378] bsdata = [08:06:47.378] #21 0x000000000085b4e2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821397d40 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821397c88) at ../src/backend/postmaster/launch_backend.c:265 [08:06:47.378] pid = [08:06:47.378] #22 0x000000000085fe41 in BackendStartup (client_sock=0x821397c88) at ../src/backend/postmaster/postmaster.c:3593 [08:06:47.378] startup_data = {canAcceptConnections = CAC_OK} [08:06:47.378] bn = 0x834b21218 [08:06:47.378] pid = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] save_errno = [08:06:47.378] __error = [08:06:47.378] __error = [08:06:47.378] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:06:47.378] 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' , "\340|9!\b\000\000\000\330UG+\b\000\000\000\v\000\000\000\000\000\000\000\016\326G+\b", '\000' , " }9!\b\000\000\000\264\262\205\000\000\000\000\0000}9!\b", '\000' }, salen = 16}} [08:06:47.378] i = 0 [08:06:47.378] now = [08:06:47.378] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 733768804, events = 8, fd = 557413072, user_data = 0x821397460}, {pos = 560124936, events = 8, fd = 32, user_data = 0x821397450}, {pos = -1451554156, events = 6153, fd = 560095240, user_data = 0x821626408}, {pos = 560097288, events = 8, fd = 560098312, user_data = 0x82162a008}, {pos = 560112648, events = 8, fd = 560113672, user_data = 0x82162ac08}, {pos = 560115720, events = 8, fd = 560116744, user_data = 0x82162b808}, {pos = 560118792, events = 8, fd = 560119816, user_data = 0x82162c408}, {pos = 560121864, events = 8, fd = 560122888, user_data = 0x82162d008}, {pos = 560124936, events = 8, fd = -1, user_data = 0x82bd9e2e0}, {pos = 557413312, events = 8, fd = 735359401, user_data = 0x0}, {pos = 4096, events = 0, fd = -260566418, user_data = 0x82bd9e7e8}, {pos = 876649440, events = 8, fd = 160, user_data = 0x0}, {pos = 866848912, events = 8, fd = 557413520, user_data = 0x82bd2992c}, {pos = 4096, events = 0, fd = 733784420, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 560151096, user_data = 0x800000001}, {pos = 560124936, events = 8, fd = 733698264, user_data = 0x821397518}, {pos = 557413072, events = 8, fd = 32, user_data = 0x82bbc6c64}, {pos = 560124936, events = 8, fd = 560151096, user_data = 0x0}, {pos = 2625, events = 0, fd = 557413632, user_data = 0x1809a97b0645}, {pos = 733784420, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 560151096, events = 8, fd = 1, user_data = 0x82162d408}, {pos = 883970048, events = 8, fd = 1, user_data = 0x834b05194}, {pos = 0, events = 0, fd = 557413584, user_data = 0x82b47cc0c}, {pos = 1, events = 0, fd = 883970048, user_data = 0x821397500}, {pos = 726122164, events = 8, fd = 735510880, user_data = 0x82bd70160 }, {pos = 733880512, events = 8, fd = 560124936, user_data = 0x8213975e0}, {pos = -1451555796, events = 6153, fd = 866848912, user_data = 0x800000001}, {pos = -1451556178, events = 6153, fd = 12240, user_data = 0x821397508}, {pos = 557413856, events = 8, fd = 884676584, user_data = 0x821397b50}, {pos = -1451475312, events = 6153, fd = 560124936, user_data = 0x82139037f}, {pos = 735167900, events = 8, fd = 560095240, user_data = 0x0}, {pos = 560124936, events = 8, fd = 12240, user_data = 0x82bba6000}, {pos = 1964368, events = 0, fd = 735510880, user_data = 0x82bbc6c64}, {pos = 15616, events = 0, fd = 557415040, user_data = 0x821397650}, {pos = 734441870, events = 8, fd = 735549496, user_data = 0x821397614}, {pos = 884413914, events = 8, fd = 557415040, user_data = 0x821397650}, {pos = 734533125, events = 8, fd = 557413906, user_data = 0x821397a80}, {pos = 557415040, events = 8, fd = 0, user_data = 0xea35fc0cf078126e}, {pos = 557415040, events = 8, fd = 884413912, user_data = 0x821397b50}, {pos = 735549496, events = 8, fd = 0, user_data = 0x821397ac0}, {pos = 734533389, events = 8, fd = 0, user_data = 0x0}, {pos = 557415408, events = 8, fd = 884413912, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1451527159, events = 6153, fd = 557414312, user_data = 0x82bbc6c64}, {pos = 2503, events = 0, fd = -1451527159, user_data = 0x8213977c8}, {pos = 733768804, events = 8, fd = 2758, user_data = 0x82bbc0120}, {pos = 557414216, events = 8, fd = 560124936, user_data = 0x8213977c8}, {pos = 733741344, events = 8, fd = 557414320, user_data = 0x1809a97b2465}, {pos = 0, events = 0, fd = 0, user_data = 0x82bd920f0}, {pos = 733701456, events = 8, fd = 0, user_data = 0x0}, {pos = 735578544, events = 8, fd = -1451527159, user_data = 0x821397858}, {pos = 733768804, events = 8, fd = 2924, user_data = 0x82bbc03b8}, {pos = 557414360, events = 8, fd = 560124936, user_data = 0x821397858}, {pos = 733742008, events = 8, fd = 557414464, user_data = 0x1809a97b2465}, {pos = 560148536, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 560124936, events = 8, fd = 733701456, user_data = 0x821397b18}, {pos = 560124936, events = 8, fd = 557414904, user_data = 0x1e}, {pos = 733705440, events = 8, fd = 557414632, user_data = 0x821632288}, {pos = 557415080, events = 8, fd = 557414608, user_data = 0x1809a97b6da3}, {pos = 560148536, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 560148536, user_data = 0x1}} [08:06:47.378] last_touch_time = 1714377832 [08:06:47.378] last_lockfile_recheck_time = 1714377832 [08:06:47.378] nevents = 1 [08:06:47.378] #24 0x000000000085d716 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821398280) at ../src/backend/postmaster/postmaster.c:1372 [08:06:47.378] userDoption = [08:06:47.378] listen_addr_saved = false [08:06:47.378] output_config_variable = [08:06:47.378] opt = [08:06:47.378] status = [08:06:47.378] #25 0x00000000007953d5 in main (argc=8, argv=0x821398280) at ../src/backend/main/main.c:197 [08:06:47.378] do_check_root = [08:06:47.390] [08:06:47.390] [08:06:47.390] [08:06:47.456] dumping /tmp/cores/postgres.8750.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:06:47.587] [New LWP 100112] [08:06:47.651] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [08:06:47.651] Program terminated with signal SIGABRT, Aborted. [08:06:47.651] Sent by thr_kill() from pid 8750 and user 1003. [08:06:47.651] #0 0x000000082ac47dca in thr_kill () from /lib/libc.so.7 [08:06:48.228] [08:06:48.228] Thread 1 (LWP 100112): [08:06:48.228] #0 0x000000082ac47dca in thr_kill () from /lib/libc.so.7 [08:06:48.228] No symbol table info available. [08:06:48.228] #1 0x000000082abc06f4 in raise () from /lib/libc.so.7 [08:06:48.228] No symbol table info available. [08:06:48.228] #2 0x000000082ac71bc9 in abort () from /lib/libc.so.7 [08:06:48.228] No symbol table info available. [08:06:48.228] #3 0x0000000000a5d8f7 in ExceptionalCondition (conditionName=, fileName=0x372e95 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:06:48.228] No locals. [08:06:48.228] #4 0x000000000073fe50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82141cf90, materialize=, shouldFree=shouldFree@entry=0x82141cf36) at ../src/backend/executor/execTuples.c:1737 [08:06:48.228] No locals. [08:06:48.228] #5 0x0000000000706038 in ExecIRDeleteTriggers (estate=estate@entry=0x834837100, relinfo=relinfo@entry=0x8348376b0, slot=slot@entry=0x82141cf90) at ../src/backend/commands/trigger.c:2841 [08:06:48.228] trigger = [08:06:48.228] oldtuple = [08:06:48.228] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x841027f98, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:06:48.228] trigdesc = 0x8348378c0 [08:06:48.228] newtuple = 0x0 [08:06:48.228] i = 0 [08:06:48.228] should_free = false [08:06:48.228] #6 0x0000000000764f4a in ExecMergeMatched (context=0x82141d050, resultRelInfo=0x8348376b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [08:06:48.228] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:06:48.228] relaction = 0x8410df120 [08:06:48.228] commandType = CMD_DELETE [08:06:48.228] result = TM_Ok [08:06:48.228] l__state = {l = 0x84114c008, i = 0} [08:06:48.228] mtstate = 0x8348374a0 [08:06:48.228] newslot = 0x0 [08:06:48.228] rslot = 0x0 [08:06:48.228] estate = 0x18710 [08:06:48.228] mergeActions = [08:06:48.228] econtext = 0x84114b0a8 [08:06:48.228] epqstate = 0x834837588 [08:06:48.228] actionStates = 0x84114c008 [08:06:48.228] l = [08:06:48.228] isNull = [08:06:48.228] lmerge_matched = [08:06:48.228] __error = [08:06:48.228] l__state = [08:06:48.228] updateCxt = [08:06:48.228] relaction = [08:06:48.228] commandType = [08:06:48.228] result = [08:06:48.228] __error = [08:06:48.228] resultRelationDesc = [08:06:48.228] lockmode = [08:06:48.228] inputslot = [08:06:48.228] epqslot = [08:06:48.228] was_matched = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] #7 ExecMerge (context=0x82141d050, resultRelInfo=0x8348376b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [08:06:48.228] matched = [08:06:48.228] rslot = 0x0 [08:06:48.228] #8 ExecModifyTable (pstate=0x8348374a0) at ../src/backend/executor/nodeModifyTable.c:4112 [08:06:48.228] context = {mtstate = 0x8348374a0, epqstate = 0x834837588, estate = 0x834837100, planSlot = 0x8410df090, tmfd = {ctid = {ip_blkid = {bi_hi = 46608, bi_lo = 16663}, ip_posid = 8}, xmax = 881030832, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x834837100} [08:06:48.228] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [08:06:48.228] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83484b118} [08:06:48.228] node = 0x8348374a0 [08:06:48.228] estate = 0x834837100 [08:06:48.228] operation = CMD_MERGE [08:06:48.228] resultRelInfo = 0x8348376b0 [08:06:48.228] subplanstate = 0x834838df0 [08:06:48.228] slot = [08:06:48.228] tupleid = 0x0 [08:06:48.228] oldtuple = 0x0 [08:06:48.228] oldSlot = [08:06:48.228] #9 0x0000000000739eeb in ExecProcNodeFirst (node=0x8348374a0) at ../src/backend/executor/execProcnode.c:464 [08:06:48.228] No locals. [08:06:48.228] #10 0x00000000007321da in ExecProcNode (node=0x8348374a0) at ../src/include/executor/executor.h:274 [08:06:48.228] No locals. [08:06:48.228] #11 ExecutePlan (estate=0x834837100, planstate=0x8348374a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8346cfb10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:06:48.228] current_tuple_count = [08:06:48.228] slot = [08:06:48.228] #12 standard_ExecutorRun (queryDesc=0x834751448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:06:48.228] estate = 0x834837100 [08:06:48.228] oldcontext = 0x8346cf800 [08:06:48.228] operation = CMD_MERGE [08:06:48.228] dest = 0x8346cfb10 [08:06:48.228] sendTuples = true [08:06:48.228] #13 0x000000000073208f in ExecutorRun (queryDesc=0x18710, queryDesc@entry=0x834751448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [08:06:48.228] No locals. [08:06:48.228] #14 0x000000000090b0ef in ProcessQuery (plan=0x841178af0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82141d268) at ../src/backend/tcop/pquery.c:160 [08:06:48.228] queryDesc = 0x834751448 [08:06:48.228] #15 0x000000000090a68d in PortalRunMulti (portal=portal@entry=0x834731100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8346cfb10, altdest=0xb519d0 , qc=qc@entry=0x82141d268) at ../src/backend/tcop/pquery.c:1286 [08:06:48.228] pstmt = 0x841178af0 [08:06:48.228] stmtlist_item__state = {l = 0x84117d3a8, i = 0} [08:06:48.228] active_snapshot_set = true [08:06:48.228] stmtlist_item = 0x84117d3c0 [08:06:48.228] #16 0x000000000090a17c in FillPortalStore (portal=portal@entry=0x834731100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:06:48.228] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:06:48.228] treceiver = 0x8346cfb10 [08:06:48.228] #17 0x0000000000909ed0 in PortalRun (portal=portal@entry=0x834731100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x84117d3f8, altdest=altdest@entry=0x84117d3f8, qc=0x82141d3a0) at ../src/backend/tcop/pquery.c:763 [08:06:48.228] _local_sigjmp_buf = {{_sjb = {9477743, 35239999896, 34917700248, 34917700480, 34917700256, 12166280, 12134064, 35239694592, 7112098687, 35239702784, 3579123, 34359738368}}} [08:06:48.228] _save_exception_stack = 0x82141d470 [08:06:48.228] _save_context_stack = 0x0 [08:06:48.228] _do_rethrow = false [08:06:48.228] saveTopTransactionResourceOwner = 0x83477b998 [08:06:48.228] saveTopTransactionContext = 0x8346a4000 [08:06:48.228] saveActivePortal = 0x0 [08:06:48.228] saveResourceOwner = 0x83477b998 [08:06:48.228] savePortalContext = 0x0 [08:06:48.228] saveMemoryContext = 0x8346a4000 [08:06:48.228] result = [08:06:48.228] nprocessed = [08:06:48.228] #18 0x0000000000908ddb in exec_simple_query (query_string=query_string@entry=0x834698100 "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 [08:06:48.228] cmdtaglen = [08:06:48.228] snapshot_set = [08:06:48.228] per_parsetree_context = 0x0 [08:06:48.228] plantree_list = [08:06:48.228] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:06:48.228] parsetree = 0x8411199e8 [08:06:48.228] commandTag = CMDTAG_MERGE [08:06:48.228] cmdtagname = [08:06:48.228] querytree_list = [08:06:48.228] portal = 0x834731100 [08:06:48.228] format = 0 [08:06:48.228] receiver = 0x84117d3f8 [08:06:48.228] parsetree_item__state = {l = 0x84111b2b0, i = 0} [08:06:48.228] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:06:48.228] dest = DestRemote [08:06:48.228] was_logged = [08:06:48.228] oldcontext = 0x8346a4000 [08:06:48.228] parsetree_list = 0x84111b2b0 [08:06:48.228] use_implicit_block = false [08:06:48.228] parsetree_item = 0x84111b2c8 [08:06:48.228] save_log_statement_stats = [08:06:48.228] #19 0x0000000000906bb4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:06:48.228] query_string = 0x834698100 "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"... [08:06:48.228] input_message = {data = 0x834698100 "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} [08:06:48.228] firstchar = [08:06:48.228] local_sigjmp_buf = {{_sjb = {9461888, 34917700720, 34917700680, 34917701280, 12175016, 12121488, 8192, 8388608, 72057628955575167, 0, 0, 34359738369}}} [08:06:48.228] send_ready_for_query = false [08:06:48.228] idle_in_transaction_timeout_enabled = false [08:06:48.228] idle_session_timeout_enabled = false [08:06:48.228] #20 0x0000000000901689 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [08:06:48.228] bsdata = [08:06:48.228] #21 0x000000000085b4e2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82141e1b0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82141e0f8) at ../src/backend/postmaster/launch_backend.c:265 [08:06:48.228] pid = [08:06:48.228] #22 0x000000000085fe41 in BackendStartup (client_sock=0x82141e0f8) at ../src/backend/postmaster/postmaster.c:3593 [08:06:48.228] startup_data = {canAcceptConnections = CAC_OK} [08:06:48.228] bn = 0x8346a42b8 [08:06:48.228] pid = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] save_errno = [08:06:48.228] __error = [08:06:48.228] __error = [08:06:48.228] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:06:48.228] 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\341A!\b\000\000\000\330E2+\b\000\000\000\v\000\000\000\000\000\000\000\016\3062+\b", '\000' , "\220\341A!\b\000\000\000\264\262\205\000\000\000\000\000\240\341A!\b", '\000' }, salen = 16}} [08:06:48.228] i = 0 [08:06:48.228] now = [08:06:48.228] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 716377188, events = 8, fd = 557963072, user_data = 0x82141d8d0}, {pos = 569287688, events = 8, fd = 32, user_data = 0x82141d8c0}, {pos = 1931672212, events = 5255, fd = 569257992, user_data = 0x821ee3408}, {pos = 569260040, events = 8, fd = 569261064, user_data = 0x821ee7008}, {pos = 569275400, events = 8, fd = 569276424, user_data = 0x821ee7c08}, {pos = 569278472, events = 8, fd = 569279496, user_data = 0x821ee8808}, {pos = 569281544, events = 8, fd = 569282568, user_data = 0x821ee9408}, {pos = 569284616, events = 8, fd = 569285640, user_data = 0x821eea008}, {pos = 569287688, events = 8, fd = 569307336, user_data = 0x82141da48}, {pos = 557963376, events = 8, fd = 1931697571, user_data = 0x0}, {pos = 2571326, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 569311288, events = 8, fd = 1, user_data = 0x821eea408}, {pos = 716285096, events = 8, fd = 557964104, user_data = 0x821eea408}, {pos = 557963360, events = 0, fd = 716392804, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 569313848, user_data = 0x1}, {pos = 569287688, events = 8, fd = 716306648, user_data = 0x82141d988}, {pos = 557963072, events = 8, fd = 32, user_data = 0x82ab30c64}, {pos = 569287688, events = 8, fd = 569313848, user_data = 0x0}, {pos = 2625, events = 0, fd = 557963632, user_data = 0x14877322f645}, {pos = 716392804, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 569313848, events = 8, fd = 1, user_data = 0x821eea408}, {pos = 879263744, events = 8, fd = 1, user_data = 0x834688194}, {pos = 0, events = 0, fd = 557963584, user_data = 0x82b32bc0c}, {pos = 1, events = 0, fd = 879263744, user_data = 0x82141d970}, {pos = 724741812, events = 8, fd = 718119264, user_data = 0x82acda160 }, {pos = 716488896, events = 8, fd = 569287688, user_data = 0x82141da50}, {pos = 1931670572, events = 5255, fd = 569286664, user_data = 0x800000001}, {pos = 1931670190, events = 5255, fd = 12240, user_data = 0x82141d978}, {pos = 557963856, events = 8, fd = 880060392, user_data = 0x82141dfc0}, {pos = 1931751056, events = 5255, fd = 569287688, user_data = 0x82141037f}, {pos = 717776050, events = 8, fd = 569257992, user_data = 0x0}, {pos = 569287688, events = 8, fd = 12240, user_data = 0x82ab10000}, {pos = 1964368, events = 0, fd = 718119264, user_data = 0x82ab30c64}, {pos = 15616, events = 0, fd = 557965040, user_data = 0x82141dac0}, {pos = 717050254, events = 8, fd = 718157880, user_data = 0x82141da84}, {pos = 879715802, events = 8, fd = 557965040, user_data = 0x82141dac0}, {pos = 717141509, events = 8, fd = 557963906, user_data = 0x82141def0}, {pos = 557965040, events = 8, fd = 0, user_data = 0x3c3db8254ae3f18}, {pos = 557965040, events = 8, fd = 879715800, user_data = 0x82141dfc0}, {pos = 718157880, events = 8, fd = 0, user_data = 0x82141df30}, {pos = 717141773, events = 8, fd = 0, user_data = 0x0}, {pos = 557965408, events = 8, fd = 879715800, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1931699209, events = 5255, fd = 557964312, user_data = 0x82ab30c64}, {pos = 2503, events = 0, fd = 1931699209, user_data = 0x82141dc38}, {pos = 716377188, events = 8, fd = 2758, user_data = 0x82ab2a120}, {pos = 557964216, events = 8, fd = 569287688, user_data = 0x82141dc38}, {pos = 716349728, events = 8, fd = 557964320, user_data = 0x148773231465}, {pos = 0, events = 0, fd = 0, user_data = 0x82acfc0f0}, {pos = 716309840, events = 8, fd = 0, user_data = 0x0}, {pos = 718186928, events = 8, fd = 1931699209, user_data = 0x82141dcc8}, {pos = 716377188, events = 8, fd = 2924, user_data = 0x82ab2a3b8}, {pos = 557964360, events = 8, fd = 569287688, user_data = 0x82141dcc8}, {pos = 716350392, events = 8, fd = 557964464, user_data = 0x148773231465}, {pos = 569311288, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 569287688, events = 8, fd = 716309840, user_data = 0x82141df88}, {pos = 569287688, events = 8, fd = 557964904, user_data = 0x1e}, {pos = 716313824, events = 8, fd = 557964632, user_data = 0x821eef288}, {pos = 557965080, events = 8, fd = 557964608, user_data = 0x148773235da3}, {pos = 569311288, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 569311288, user_data = 0x1}} [08:06:48.228] last_touch_time = 1714377834 [08:06:48.228] last_lockfile_recheck_time = 1714377834 [08:06:48.228] nevents = 1 [08:06:48.228] #24 0x000000000085d716 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82141e6f8) at ../src/backend/postmaster/postmaster.c:1372 [08:06:48.228] userDoption = [08:06:48.228] listen_addr_saved = false [08:06:48.228] output_config_variable = [08:06:48.228] opt = [08:06:48.228] status = [08:06:48.228] #25 0x00000000007953d5 in main (argc=4, argv=0x82141e6f8) at ../src/backend/main/main.c:197 [08:06:48.228] do_check_root = [08:06:48.239] [08:06:48.239] [08:06:48.239] [08:06:48.303] dumping /tmp/cores/postgres.13940.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:06:48.429] [New LWP 101721] [08:06:48.491] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [08:06:48.491] Program terminated with signal SIGABRT, Aborted. [08:06:48.491] Sent by thr_kill() from pid 13940 and user 1003. [08:06:48.491] #0 0x000000082ad6fdca in thr_kill () from /lib/libc.so.7 [08:06:49.076] [08:06:49.076] Thread 1 (LWP 101721): [08:06:49.076] #0 0x000000082ad6fdca in thr_kill () from /lib/libc.so.7 [08:06:49.076] No symbol table info available. [08:06:49.076] #1 0x000000082ace86f4 in raise () from /lib/libc.so.7 [08:06:49.076] No symbol table info available. [08:06:49.076] #2 0x000000082ad99bc9 in abort () from /lib/libc.so.7 [08:06:49.076] No symbol table info available. [08:06:49.076] #3 0x0000000000a5d8f7 in ExceptionalCondition (conditionName=, fileName=0x372e95 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:06:49.076] No locals. [08:06:49.076] #4 0x000000000073fe50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820f1b980, materialize=, shouldFree=shouldFree@entry=0x820f1b926) at ../src/backend/executor/execTuples.c:1737 [08:06:49.076] No locals. [08:06:49.076] #5 0x0000000000706038 in ExecIRDeleteTriggers (estate=estate@entry=0x838339100, relinfo=relinfo@entry=0x8383396b0, slot=slot@entry=0x820f1b980) at ../src/backend/commands/trigger.c:2841 [08:06:49.076] trigger = [08:06:49.076] oldtuple = [08:06:49.076] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83c74d820, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:06:49.076] trigdesc = 0x8383398c0 [08:06:49.076] newtuple = 0x0 [08:06:49.076] i = 0 [08:06:49.076] should_free = false [08:06:49.076] #6 0x0000000000764f4a in ExecMergeMatched (context=0x820f1ba40, resultRelInfo=0x8383396b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [08:06:49.076] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:06:49.076] relaction = 0x8382efbe0 [08:06:49.076] commandType = CMD_DELETE [08:06:49.076] result = TM_Ok [08:06:49.076] l__state = {l = 0x83be8a448, i = 0} [08:06:49.076] mtstate = 0x8383394a0 [08:06:49.076] newslot = 0x0 [08:06:49.076] rslot = 0x0 [08:06:49.076] estate = 0x18d59 [08:06:49.076] mergeActions = [08:06:49.076] econtext = 0x83be894e8 [08:06:49.076] epqstate = 0x838339588 [08:06:49.076] actionStates = 0x83be8a448 [08:06:49.076] l = [08:06:49.076] isNull = [08:06:49.076] lmerge_matched = [08:06:49.076] __error = [08:06:49.076] l__state = [08:06:49.076] updateCxt = [08:06:49.076] relaction = [08:06:49.076] commandType = [08:06:49.076] result = [08:06:49.076] __error = [08:06:49.076] resultRelationDesc = [08:06:49.076] lockmode = [08:06:49.076] inputslot = [08:06:49.076] epqslot = [08:06:49.076] was_matched = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] #7 ExecMerge (context=0x820f1ba40, resultRelInfo=0x8383396b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [08:06:49.076] matched = [08:06:49.076] rslot = 0x0 [08:06:49.076] #8 ExecModifyTable (pstate=0x8383394a0) at ../src/backend/executor/nodeModifyTable.c:4112 [08:06:49.076] context = {mtstate = 0x8383394a0, epqstate = 0x838339588, estate = 0x838339100, planSlot = 0x8382efb50, tmfd = {ctid = {ip_blkid = {bi_hi = 47848, bi_lo = 8433}, ip_posid = 8}, xmax = 719478256, cmax = 8, traversed = 176}, cpUpdateReturningSlot = 0x82ad6c6de} [08:06:49.076] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [08:06:49.076] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x838345118} [08:06:49.076] node = 0x8383394a0 [08:06:49.076] estate = 0x838339100 [08:06:49.076] operation = CMD_MERGE [08:06:49.076] resultRelInfo = 0x8383396b0 [08:06:49.076] subplanstate = 0x83833adf0 [08:06:49.076] slot = [08:06:49.076] tupleid = 0x0 [08:06:49.076] oldtuple = 0x0 [08:06:49.076] oldSlot = [08:06:49.076] #9 0x0000000000739eeb in ExecProcNodeFirst (node=0x8383394a0) at ../src/backend/executor/execProcnode.c:464 [08:06:49.076] No locals. [08:06:49.076] #10 0x00000000007321da in ExecProcNode (node=0x8383394a0) at ../src/include/executor/executor.h:274 [08:06:49.076] No locals. [08:06:49.076] #11 ExecutePlan (estate=0x838339100, planstate=0x8383394a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83830cb10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:06:49.076] current_tuple_count = [08:06:49.076] slot = [08:06:49.076] #12 standard_ExecutorRun (queryDesc=0x838236448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:06:49.076] estate = 0x838339100 [08:06:49.076] oldcontext = 0x83830c800 [08:06:49.076] operation = CMD_MERGE [08:06:49.076] dest = 0x83830cb10 [08:06:49.076] sendTuples = true [08:06:49.076] #13 0x0000000838b94963 in pgss_ExecutorRun (queryDesc=0x838236448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [08:06:49.076] _local_sigjmp_buf = {{_sjb = {35311405362, 12166280, 34912451448, 34912451616, 35301581896, 34912451456, 1, 1, 35302605695, 35301581896, 12175008, 34359738368}}} [08:06:49.076] _save_exception_stack = 0x820f1bd40 [08:06:49.076] _save_context_stack = 0x0 [08:06:49.076] _do_rethrow = false [08:06:49.076] #14 0x0000000000732088 in ExecutorRun (queryDesc=0x18d59, queryDesc@entry=0x838236448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [08:06:49.076] No locals. [08:06:49.076] #15 0x000000000090b0ef in ProcessQuery (plan=0x83be72980, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820f1bd08) at ../src/backend/tcop/pquery.c:160 [08:06:49.076] queryDesc = 0x838236448 [08:06:49.076] #16 0x000000000090a68d in PortalRunMulti (portal=portal@entry=0x838218100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83830cb10, altdest=0xb519d0 , qc=qc@entry=0x820f1bd08) at ../src/backend/tcop/pquery.c:1286 [08:06:49.076] pstmt = 0x83be72980 [08:06:49.076] stmtlist_item__state = {l = 0x83be77238, i = 0} [08:06:49.076] active_snapshot_set = true [08:06:49.076] stmtlist_item = 0x83be77250 [08:06:49.076] #17 0x000000000090a17c in FillPortalStore (portal=portal@entry=0x838218100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:06:49.076] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:06:49.076] treceiver = 0x83830cb10 [08:06:49.076] #18 0x0000000000909ed0 in PortalRun (portal=portal@entry=0x838218100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83be77288, altdest=altdest@entry=0x83be77288, qc=0x820f1be40) at ../src/backend/tcop/pquery.c:763 [08:06:49.076] _local_sigjmp_buf = {{_sjb = {9477743, 35301793496, 34912451896, 34912452128, 34912451904, 12166280, 12134064, 35301458176, 7112098687, 35301466368, 3579123, 34359738368}}} [08:06:49.076] _save_exception_stack = 0x820f1bf10 [08:06:49.076] _save_context_stack = 0x0 [08:06:49.076] _do_rethrow = false [08:06:49.076] saveTopTransactionResourceOwner = 0x838269ed8 [08:06:49.076] saveTopTransactionContext = 0x838189000 [08:06:49.076] saveActivePortal = 0x0 [08:06:49.076] saveResourceOwner = 0x838269ed8 [08:06:49.076] savePortalContext = 0x0 [08:06:49.076] saveMemoryContext = 0x838189000 [08:06:49.076] result = [08:06:49.076] nprocessed = [08:06:49.076] #19 0x0000000000908ddb in exec_simple_query (query_string=query_string@entry=0x83817d100 "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 [08:06:49.076] cmdtaglen = [08:06:49.076] snapshot_set = [08:06:49.076] per_parsetree_context = 0x0 [08:06:49.076] plantree_list = [08:06:49.076] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:06:49.076] parsetree = 0x83be292e8 [08:06:49.076] commandTag = CMDTAG_MERGE [08:06:49.076] cmdtagname = [08:06:49.076] querytree_list = [08:06:49.076] portal = 0x838218100 [08:06:49.076] format = 0 [08:06:49.076] receiver = 0x83be77288 [08:06:49.076] parsetree_item__state = {l = 0x83be2abb0, i = 0} [08:06:49.076] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:06:49.076] dest = DestRemote [08:06:49.076] was_logged = [08:06:49.076] oldcontext = 0x838189000 [08:06:49.076] parsetree_list = 0x83be2abb0 [08:06:49.076] use_implicit_block = false [08:06:49.076] parsetree_item = 0x83be2abc8 [08:06:49.076] save_log_statement_stats = [08:06:49.076] #20 0x0000000000906bb4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:06:49.076] query_string = 0x83817d100 "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"... [08:06:49.076] input_message = {data = 0x83817d100 "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} [08:06:49.076] firstchar = [08:06:49.076] local_sigjmp_buf = {{_sjb = {9461888, 34912452368, 34912452328, 34912452928, 12175016, 12121488, 8192, 8388608, 72057628950332287, 0, 0, 1}}} [08:06:49.076] send_ready_for_query = false [08:06:49.076] idle_in_transaction_timeout_enabled = false [08:06:49.076] idle_session_timeout_enabled = false [08:06:49.076] #21 0x0000000000901689 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [08:06:49.076] bsdata = [08:06:49.076] #22 0x000000000085b4e2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f1cc50 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f1cb98) at ../src/backend/postmaster/launch_backend.c:265 [08:06:49.076] pid = [08:06:49.076] #23 0x000000000085fe41 in BackendStartup (client_sock=0x820f1cb98) at ../src/backend/postmaster/postmaster.c:3593 [08:06:49.076] startup_data = {canAcceptConnections = CAC_OK} [08:06:49.076] bn = 0x838189178 [08:06:49.076] pid = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] save_errno = [08:06:49.076] __error = [08:06:49.076] __error = [08:06:49.076] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:06:49.076] 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' , "\360\313\361 \b\000\000\000\330Ť+\b\000\000\000\v\000\000\000\000\000\000\000\016F\245+\b", '\000' , "0\314\361 \b\000\000\000\264\262\205\000\000\000\000\000@\314\361 \b", '\000' }, salen = 16}} [08:06:49.076] i = 0 [08:06:49.076] now = [08:06:49.076] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 552715120, events = 8, fd = 565617672, user_data = 0x21}, {pos = 552715104, events = 8, fd = 113814164, user_data = 0x821b63008}, {pos = 565589000, events = 8, fd = 565590024, user_data = 0x821b63c08}, {pos = 565604360, events = 8, fd = 565605384, user_data = 0x821b67808}, {pos = 565607432, events = 8, fd = 565608456, user_data = 0x821b68408}, {pos = 565610504, events = 8, fd = 565611528, user_data = 0x821b69008}, {pos = 565613576, events = 8, fd = 565614600, user_data = 0x821b69c08}, {pos = 565616648, events = 8, fd = 565617672, user_data = 0x821b6f0c8}, {pos = 552715496, events = 8, fd = 552715008, user_data = 0x289306c90da3}, {pos = 565617672, events = 8, fd = 2571326, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 565641272, user_data = 0x1}, {pos = 565617672, events = 8, fd = 717497512, user_data = 0x820f1c5e8}, {pos = 565617672, events = 8, fd = 552714976, user_data = 0x273b88}, {pos = 552715568, events = 8, fd = 717605220, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 565643832, user_data = 0x289300000001}, {pos = 565617672, events = 8, fd = 717519064, user_data = 0x820f1c428}, {pos = 552714704, events = 8, fd = 33, user_data = 0x82ac58c64}, {pos = 565617672, events = 8, fd = 565643832, user_data = 0x0}, {pos = 2625, events = 0, fd = 552715280, user_data = 0x289306c8a645}, {pos = 717605220, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 565643832, events = 8, fd = 1, user_data = 0x821b6a408}, {pos = 941019136, events = 8, fd = 1, user_data = 0x83816d194}, {pos = 0, events = 0, fd = 552715232, user_data = 0x82ba53c0c}, {pos = 1, events = 0, fd = 941019136, user_data = 0x820f1c410}, {pos = 732245684, events = 8, fd = 719331680, user_data = 0x82ae02160 }, {pos = 717701312, events = 8, fd = 565617672, user_data = 0x820f1c4f0}, {pos = 113812524, events = 10387, fd = 80627796, user_data = 0x1}, {pos = 113812142, events = 10387, fd = 12240, user_data = 0x820f1c418}, {pos = 552715504, events = 8, fd = 941815784, user_data = 0x820f1ca60}, {pos = 113893008, events = 10387, fd = 565617672, user_data = 0x820f1037f}, {pos = 718988466, events = 8, fd = 552715808, user_data = 0x289300000000}, {pos = 565617672, events = 8, fd = 12240, user_data = 0x82ac38000}, {pos = 1964368, events = 0, fd = 719331680, user_data = 0x82ac58c64}, {pos = 15616, events = 0, fd = 552716688, user_data = 0x820f1c560}, {pos = 718262670, events = 8, fd = 719370296, user_data = 0x820f1c524}, {pos = 941471194, events = 8, fd = 552716688, user_data = 0x820f1c560}, {pos = 718353925, events = 8, fd = 552715554, user_data = 0x820f1c990}, {pos = 552716688, events = 8, fd = 0, user_data = 0x83d5d05f39548283}, {pos = 552716688, events = 8, fd = 941471192, user_data = 0x820f1ca60}, {pos = 719370296, events = 8, fd = 0, user_data = 0x820f1c9d0}, {pos = 718354189, events = 8, fd = 0, user_data = 0x0}, {pos = 552717056, events = 8, fd = 941471192, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 113841161, user_data = 0x820f1c6a8}, {pos = 717589604, events = 8, fd = 2503, user_data = 0x289306c91409}, {pos = 552715976, events = 8, fd = 717589604, user_data = 0xac6}, {pos = 717562144, events = 8, fd = 552715848, user_data = 0x821b6a408}, {pos = 552715976, events = 8, fd = 717562144, user_data = 0x820f1c6b0}, {pos = 113820773, events = 10387, fd = 0, user_data = 0x800000000}, {pos = 552715936, events = 8, fd = 717522256, user_data = 0x0}, {pos = 0, events = 0, fd = 552715904, user_data = 0x289306c91409}, {pos = 552716120, events = 8, fd = 717589604, user_data = 0xb6c}, {pos = 717562808, events = 8, fd = 552715992, user_data = 0x821b6a408}, {pos = 552716120, events = 8, fd = 717562808, user_data = 0x820f1c740}, {pos = 113820773, events = 10387, fd = 565641272, user_data = 0x28d146}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 565617672, user_data = 0x82ac48550}, {pos = 552716840, events = 8, fd = 565617672, user_data = 0x20f1c908}, {pos = 31, events = 0, fd = 0, user_data = 0x820f1c7e8}, {pos = 565639112, events = 8, fd = 552716728, user_data = 0x820f1c7d0}, {pos = 113839523, events = 10387, fd = 565641272, user_data = 0x292dce}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821b70038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [08:06:49.076] last_touch_time = 1714377853 [08:06:49.076] last_lockfile_recheck_time = 1714377853 [08:06:49.076] nevents = 1 [08:06:49.076] #25 0x000000000085d716 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f1d198) at ../src/backend/postmaster/postmaster.c:1372 [08:06:49.076] userDoption = [08:06:49.076] listen_addr_saved = false [08:06:49.076] output_config_variable = [08:06:49.076] opt = [08:06:49.076] status = [08:06:49.076] #26 0x00000000007953d5 in main (argc=4, argv=0x820f1d198) at ../src/backend/main/main.c:197 [08:06:49.076] do_check_root =