[23:45:15.164] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [23:45:15.525] dumping /tmp/cores/postgres.8748.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:45:15.653] [New LWP 101816] [23:45:15.738] Core was generated by `postgres: postgres regression [local] MERGE'. [23:45:15.738] Program terminated with signal SIGABRT, Aborted. [23:45:15.738] Sent by thr_kill() from pid 8748 and user 1003. [23:45:15.738] #0 0x000000082c97b41a in thr_kill () from /lib/libc.so.7 [23:45:16.252] [23:45:16.252] Thread 1 (LWP 101816): [23:45:16.252] #0 0x000000082c97b41a in thr_kill () from /lib/libc.so.7 [23:45:16.252] No symbol table info available. [23:45:16.252] #1 0x000000082c8f4e64 in raise () from /lib/libc.so.7 [23:45:16.252] No symbol table info available. [23:45:16.252] #2 0x000000082c9a56f9 in abort () from /lib/libc.so.7 [23:45:16.252] No symbol table info available. [23:45:16.252] #3 0x0000000000a58cd5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [23:45:16.252] No locals. [23:45:16.252] #4 0x000000000073d2df in ExecFetchSlotHeapTuple (slot=0x821071520, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [23:45:16.252] No locals. [23:45:16.252] #5 0x0000000000701f97 in ExecIRDeleteTriggers (estate=estate@entry=0x845095100, relinfo=relinfo@entry=0x8450956b0, slot=slot@entry=0x821071520) at ../src/backend/commands/trigger.c:2841 [23:45:16.252] trigger = [23:45:16.252] oldtuple = [23:45:16.252] should_free = false [23:45:16.252] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8450d48e0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [23:45:16.252] trigdesc = 0x8450958c0 [23:45:16.252] newtuple = 0x0 [23:45:16.252] i = 0 [23:45:16.252] #6 0x00000000007624b7 in ExecMergeMatched (context=0x8210715c8, resultRelInfo=0x8450956b0, tupleid=0x0, oldtuple=0x821071520, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [23:45:16.252] result = TM_Ok [23:45:16.252] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [23:45:16.252] relaction = 0x84520edf8 [23:45:16.252] commandType = CMD_DELETE [23:45:16.252] l__state = {l = 0x84520f3b8, i = 0} [23:45:16.252] mtstate = 0x8450954a0 [23:45:16.252] newslot = 0x0 [23:45:16.252] rslot = 0x0 [23:45:16.252] estate = 0x845095100 [23:45:16.252] mergeActions = [23:45:16.252] econtext = 0x84520e428 [23:45:16.252] epqstate = 0x845095588 [23:45:16.252] actionStates = 0x84520f3b8 [23:45:16.252] l = [23:45:16.252] isNull = [23:45:16.252] lmerge_matched = [23:45:16.252] __error = [23:45:16.252] l__state = [23:45:16.252] result = [23:45:16.252] updateCxt = [23:45:16.252] relaction = [23:45:16.252] commandType = [23:45:16.252] __error = [23:45:16.252] resultRelationDesc = [23:45:16.252] lockmode = [23:45:16.252] inputslot = [23:45:16.252] epqslot = [23:45:16.252] was_matched = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] #7 ExecMerge (context=0x8210715c8, resultRelInfo=0x8450956b0, tupleid=0x0, oldtuple=0x821071520, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [23:45:16.252] matched = [23:45:16.252] rslot = 0x0 [23:45:16.252] #8 ExecModifyTable (pstate=0x8450954a0) at ../src/backend/executor/nodeModifyTable.c:4133 [23:45:16.252] context = {mtstate = 0x8450954a0, epqstate = 0x845095588, estate = 0x845095100, planSlot = 0x8451a2af0, tmfd = {ctid = {ip_blkid = {bi_hi = 39288, bi_lo = 17699}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8450956b0} [23:45:16.252] tuple_ctid = {ip_blkid = {bi_hi = 34208, bi_lo = 18183}, ip_posid = 8} [23:45:16.252] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8450ea118} [23:45:16.252] node = 0x8450954a0 [23:45:16.252] estate = 0x845095100 [23:45:16.252] operation = CMD_MERGE [23:45:16.252] resultRelInfo = 0x8450956b0 [23:45:16.252] subplanstate = 0x845096df0 [23:45:16.252] slot = [23:45:16.252] tupleid = 0x0 [23:45:16.252] oldtuple = 0x821071520 [23:45:16.252] oldSlot = [23:45:16.252] #9 0x000000000072f54b in ExecProcNode (node=0x8450954a0) at ../src/include/executor/executor.h:278 [23:45:16.252] No locals. [23:45:16.252] #10 ExecutePlan (estate=0x845095100, planstate=0x8450954a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x837c39f10, execute_once=) at ../src/backend/executor/execMain.c:1641 [23:45:16.252] current_tuple_count = 0 [23:45:16.252] slot = [23:45:16.252] #11 standard_ExecutorRun (queryDesc=0x837b88c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [23:45:16.252] estate = 0x845095100 [23:45:16.252] oldcontext = 0x837c39c00 [23:45:16.252] operation = CMD_MERGE [23:45:16.252] dest = 0x837c39f10 [23:45:16.252] sendTuples = true [23:45:16.252] #12 0x00000000009042bf in ProcessQuery (plan=0x845239260, sourceText=, params=0x0, queryEnv=0x0, dest=0x837c39f10, qc=0x8210717c8) at ../src/backend/tcop/pquery.c:160 [23:45:16.252] queryDesc = 0x837b88c48 [23:45:16.252] #13 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x837c07100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x837c39f10, altdest=0xb4a6b0 , qc=qc@entry=0x8210717c8) at ../src/backend/tcop/pquery.c:1287 [23:45:16.252] pstmt = 0x845239260 [23:45:16.252] stmtlist_item__state = {l = 0x84523db18, i = 0} [23:45:16.252] active_snapshot_set = true [23:45:16.252] stmtlist_item = 0x84523db30 [23:45:16.252] #14 0x000000000090336c in FillPortalStore (portal=portal@entry=0x837c07100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [23:45:16.252] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:16.252] treceiver = 0x837c39f10 [23:45:16.252] #15 0x00000000009030db in PortalRun (portal=portal@entry=0x837c07100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x84523db68, altdest=altdest@entry=0x84523db68, qc=0x821071900) at ../src/backend/tcop/pquery.c:763 [23:45:16.252] _local_sigjmp_buf = {{_sjb = {9449597, 35295097088, 34913851384, 34913851616, 34913851392, 35295117312, 12105032, 12138344, 35295069055, 35294224640, 4294967984, 0}}} [23:45:16.252] _save_exception_stack = 0x8210719d0 [23:45:16.252] _save_context_stack = 0x0 [23:45:16.252] _do_rethrow = false [23:45:16.252] saveTopTransactionResourceOwner = 0x837c192d8 [23:45:16.252] saveTopTransactionContext = 0x837c0c000 [23:45:16.252] saveActivePortal = 0x0 [23:45:16.252] saveResourceOwner = 0x837c192d8 [23:45:16.252] savePortalContext = 0x0 [23:45:16.252] saveMemoryContext = 0x837c0c000 [23:45:16.252] result = [23:45:16.252] nprocessed = [23:45:16.252] #16 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x837b32100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [23:45:16.252] cmdtaglen = 5 [23:45:16.252] snapshot_set = [23:45:16.252] per_parsetree_context = 0x0 [23:45:16.252] plantree_list = [23:45:16.252] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:16.252] format = 0 [23:45:16.252] parsetree = 0x8451dc8e8 [23:45:16.252] commandTag = [23:45:16.252] cmdtagname = [23:45:16.252] querytree_list = [23:45:16.252] portal = 0x837c07100 [23:45:16.252] receiver = 0x84523db68 [23:45:16.252] parsetree_item__state = {l = 0x8451de1b0, i = 0} [23:45:16.252] msec_str = "\000\000\000\000\b", '\000' , "\234\022\315f\000\000\000\000'j\364\030Ŝ\267\371" [23:45:16.252] dest = DestRemote [23:45:16.252] was_logged = [23:45:16.252] oldcontext = 0x837c0c000 [23:45:16.252] parsetree_list = 0x8451de1b0 [23:45:16.252] use_implicit_block = false [23:45:16.252] parsetree_item = 0x8451de1c8 [23:45:16.252] save_log_statement_stats = [23:45:16.252] #17 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [23:45:16.252] query_string = 0x837b32100 "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"... [23:45:16.252] input_message = {data = 0x837b32100 "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} [23:45:16.252] firstchar = [23:45:16.252] local_sigjmp_buf = {{_sjb = {9433510, 34913851856, 34913851816, 34913852400, 12147080, 1, 8192, 8388608, 34913846143, 0, 0, 1}}} [23:45:16.252] send_ready_for_query = false [23:45:16.252] idle_in_transaction_timeout_enabled = false [23:45:16.252] idle_session_timeout_enabled = false [23:45:16.252] #18 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:45:16.252] bsdata = [23:45:16.252] #19 0x0000000000854667 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821072714 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821072650) at ../src/backend/postmaster/launch_backend.c:274 [23:45:16.252] pid = [23:45:16.252] #20 0x0000000000858a28 in BackendStartup (client_sock=0x821072650) at ../src/backend/postmaster/postmaster.c:3414 [23:45:16.252] startup_data = {canAcceptConnections = CAC_OK} [23:45:16.252] bn = 0x837b3e218 [23:45:16.252] pid = [23:45:16.252] __error = [23:45:16.252] save_errno = [23:45:16.252] __error = [23:45:16.252] __error = [23:45:16.252] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [23:45:16.252] 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?\2637\b", '\000' , "\260&\a!\b\000\000\000hՑ+\b\000\000\000\v\000\000\000\000\000\000\000^_\222+\b", '\000' , "\360&\a!\b\000\000\000\024D\205\000\000\000\000\000\000'\a!\b", '\000' }, salen = 16}} [23:45:16.252] i = 0 [23:45:16.252] now = [23:45:16.252] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 747764866, events = 8, fd = 0, user_data = 0x821072600}, {pos = 934884824, events = 8, fd = 554116240, user_data = 0x0}, {pos = 0, events = 0, fd = -735600084, user_data = 0x17711dac530a}, {pos = 746932128, events = 8, fd = 747003256, user_data = 0x821072118}, {pos = 554115472, events = 8, fd = 554115352, user_data = 0x17711dac530a}, {pos = 746910600, events = 8, fd = 747003256, user_data = 0x821072148}, {pos = 554115520, events = 8, fd = 554115400, user_data = 0x82c85e194}, {pos = 559027208, events = 8, fd = 746971540, user_data = 0x8210721b0}, {pos = 497812538, events = 6001, fd = 748793904, user_data = 0x1}, {pos = 554115552, events = 8, fd = 497832714, user_data = 0x82c847858}, {pos = 747003256, events = 8, fd = 554115512, user_data = 0x821072230}, {pos = 554115512, events = 8, fd = 746966284, user_data = 0x821521408}, {pos = 746966284, events = 8, fd = 554115616, user_data = 0x17711dac043a}, {pos = 554115656, events = 8, fd = 554116104, user_data = 0x821072230}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 183957677, fd = 559050808, user_data = 0x800000001}, {pos = 559027208, events = 8, fd = 746910600, user_data = 0x821526288}, {pos = 746879064, events = 8, fd = 559027208, user_data = 0x8210722b8}, {pos = 554116216, events = 8, fd = 554115744, user_data = 0x17711dac4ca2}, {pos = 2699790, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 559050808, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554116472, user_data = 0x21521408}, {pos = 554116288, events = 8, fd = 554115888, user_data = 0x1}, {pos = 554116216, events = 8, fd = 32, user_data = 0x821072320}, {pos = 497830515, events = 6001, fd = 554116160, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821527038}, {pos = 1, events = 8, fd = 559027208, user_data = 0x82c847858}, {pos = 554116472, events = 8, fd = 554116288, user_data = 0x821072330}, {pos = 0, events = 0, fd = 558997512, user_data = 0x20}, {pos = 554116272, events = 8, fd = 497806055, user_data = 0x82151a008}, {pos = 558998536, events = 8, fd = 558999560, user_data = 0x82151ac08}, {pos = 559013896, events = 8, fd = 559014920, user_data = 0x82151e808}, {pos = 559016968, events = 8, fd = 559017992, user_data = 0x82151f408}, {pos = 559020040, events = 8, fd = 559021064, user_data = 0x821520008}, {pos = 559023112, events = 8, fd = 559024136, user_data = 0x821520c08}, {pos = 559026184, events = 8, fd = 559027208, user_data = 0x821521808}, {pos = 559029256, events = 8, fd = 559030280, user_data = 0x821522408}, {pos = 559032328, events = 8, fd = 559033352, user_data = 0x821523008}, {pos = 559035400, events = 8, fd = 559036424, user_data = 0x821523c08}, {pos = 559042568, events = 8, fd = 559043592, user_data = 0x821525808}, {pos = 559045640, events = 8, fd = 558997512, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821527038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554116472, events = 8, fd = 554115888, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 559050808, user_data = 0x1}, {pos = 558997512, events = 8, fd = 314, user_data = 0x821072560}, {pos = 497804783, events = 6001, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 559050808, user_data = 0x1}, {pos = 559027208, events = 8, fd = 934420480, user_data = 0x1}, {pos = 934420884, events = 8, fd = 0, user_data = 0x821072530}, {pos = 731010412, events = 8, fd = 1, user_data = 0x837b22000}, {pos = 554116448, events = 8, fd = 731006722, user_data = 0x82c979170 }, {pos = 12072120, events = 0, fd = 748130672, user_data = 0x821521408}, {pos = 554116672, events = 8, fd = 497804254, user_data = 0x837b40800}, {pos = 1, events = 0, fd = 497803870, user_data = 0x82151a008}, {pos = 554116456, events = 8, fd = 554116672, user_data = 0x1c38}, {pos = 934493952, events = 8, fd = 497883536, user_data = 0x0}, {pos = 554107775, events = 8, fd = 7886791, user_data = 0x8210725f0}, {pos = 730969104, events = 8, fd = 748793904, user_data = 0x82ca1d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821072620}, {pos = 731011997, events = 8, fd = 934420480, user_data = 0x1ac2}, {pos = 554116736, events = 8, fd = 730978554, user_data = 0x0}, {pos = 0, events = 0, fd = -735600084, user_data = 0x0}} [23:45:16.252] last_touch_time = 1724715667 [23:45:16.252] last_lockfile_recheck_time = 1724715667 [23:45:16.252] nevents = 1 [23:45:16.252] #22 0x0000000000856845 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821072c68) at ../src/backend/postmaster/postmaster.c:1346 [23:45:16.252] userDoption = [23:45:16.252] listen_addr_saved = [23:45:16.252] output_config_variable = [23:45:16.252] opt = [23:45:16.252] status = [23:45:16.252] #23 0x00000000007924cc in main (argc=8, argv=0x821072c68) at ../src/backend/main/main.c:197 [23:45:16.252] do_check_root = [23:45:16.264] [23:45:16.264] [23:45:16.264] [23:45:16.330] dumping /tmp/cores/postgres.8956.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:45:16.451] [New LWP 101848] [23:45:16.516] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [23:45:16.516] Program terminated with signal SIGABRT, Aborted. [23:45:16.516] Sent by thr_kill() from pid 8956 and user 1003. [23:45:16.516] #0 0x000000082bcdb41a in thr_kill () from /lib/libc.so.7 [23:45:17.002] [23:45:17.002] Thread 1 (LWP 101848): [23:45:17.002] #0 0x000000082bcdb41a in thr_kill () from /lib/libc.so.7 [23:45:17.002] No symbol table info available. [23:45:17.002] #1 0x000000082bc54e64 in raise () from /lib/libc.so.7 [23:45:17.002] No symbol table info available. [23:45:17.002] #2 0x000000082bd056f9 in abort () from /lib/libc.so.7 [23:45:17.002] No symbol table info available. [23:45:17.002] #3 0x0000000000a58cd5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [23:45:17.002] No locals. [23:45:17.002] #4 0x000000000073d2df in ExecFetchSlotHeapTuple (slot=0x8212e9a70, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [23:45:17.002] No locals. [23:45:17.002] #5 0x0000000000701f97 in ExecIRDeleteTriggers (estate=estate@entry=0x8372b5100, relinfo=relinfo@entry=0x8372b56b0, slot=slot@entry=0x8212e9a70) at ../src/backend/commands/trigger.c:2841 [23:45:17.002] trigger = [23:45:17.002] oldtuple = [23:45:17.002] should_free = false [23:45:17.002] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x845359ca0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [23:45:17.002] trigdesc = 0x8372b58c0 [23:45:17.002] newtuple = 0x0 [23:45:17.002] i = 0 [23:45:17.002] #6 0x00000000007624b7 in ExecMergeMatched (context=0x8212e9b18, resultRelInfo=0x8372b56b0, tupleid=0x0, oldtuple=0x8212e9a70, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [23:45:17.002] result = TM_Ok [23:45:17.002] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [23:45:17.002] relaction = 0x84545e778 [23:45:17.002] commandType = CMD_DELETE [23:45:17.002] l__state = {l = 0x84545ed38, i = 0} [23:45:17.002] mtstate = 0x8372b54a0 [23:45:17.002] newslot = 0x0 [23:45:17.002] rslot = 0x0 [23:45:17.002] estate = 0x8372b5100 [23:45:17.002] mergeActions = [23:45:17.002] econtext = 0x84545dda8 [23:45:17.002] epqstate = 0x8372b5588 [23:45:17.002] actionStates = 0x84545ed38 [23:45:17.002] l = [23:45:17.002] isNull = [23:45:17.002] lmerge_matched = [23:45:17.002] __error = [23:45:17.002] l__state = [23:45:17.002] result = [23:45:17.002] updateCxt = [23:45:17.002] relaction = [23:45:17.002] commandType = [23:45:17.002] __error = [23:45:17.002] resultRelationDesc = [23:45:17.002] lockmode = [23:45:17.002] inputslot = [23:45:17.002] epqslot = [23:45:17.002] was_matched = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] #7 ExecMerge (context=0x8212e9b18, resultRelInfo=0x8372b56b0, tupleid=0x0, oldtuple=0x8212e9a70, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [23:45:17.002] matched = [23:45:17.002] rslot = 0x0 [23:45:17.002] #8 ExecModifyTable (pstate=0x8372b54a0) at ../src/backend/executor/nodeModifyTable.c:4133 [23:45:17.002] context = {mtstate = 0x8372b54a0, epqstate = 0x8372b5588, estate = 0x8372b5100, planSlot = 0x8453fa1b0, tmfd = {ctid = {ip_blkid = {bi_hi = 47288, bi_lo = 17736}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8372b56b0} [23:45:17.002] tuple_ctid = {ip_blkid = {bi_hi = 42256, bi_lo = 18130}, ip_posid = 8} [23:45:17.002] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8372c9118} [23:45:17.002] node = 0x8372b54a0 [23:45:17.002] estate = 0x8372b5100 [23:45:17.002] operation = CMD_MERGE [23:45:17.002] resultRelInfo = 0x8372b56b0 [23:45:17.002] subplanstate = 0x8372b6df0 [23:45:17.002] slot = [23:45:17.002] tupleid = 0x0 [23:45:17.002] oldtuple = 0x8212e9a70 [23:45:17.002] oldSlot = [23:45:17.002] #9 0x000000000072f54b in ExecProcNode (node=0x8372b54a0) at ../src/include/executor/executor.h:278 [23:45:17.002] No locals. [23:45:17.002] #10 ExecutePlan (estate=0x8372b5100, planstate=0x8372b54a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x837165310, execute_once=) at ../src/backend/executor/execMain.c:1641 [23:45:17.002] current_tuple_count = 0 [23:45:17.002] slot = [23:45:17.002] #11 standard_ExecutorRun (queryDesc=0x83716d448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [23:45:17.002] estate = 0x8372b5100 [23:45:17.002] oldcontext = 0x837165000 [23:45:17.002] operation = CMD_MERGE [23:45:17.002] dest = 0x837165310 [23:45:17.002] sendTuples = true [23:45:17.002] #12 0x00000000009042bf in ProcessQuery (plan=0x84548b1a0, sourceText=, params=0x0, queryEnv=0x0, dest=0x837165310, qc=0x8212e9d18) at ../src/backend/tcop/pquery.c:160 [23:45:17.002] queryDesc = 0x83716d448 [23:45:17.002] #13 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x8371b4100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x837165310, altdest=0xb4a6b0 , qc=qc@entry=0x8212e9d18) at ../src/backend/tcop/pquery.c:1287 [23:45:17.002] pstmt = 0x84548b1a0 [23:45:17.002] stmtlist_item__state = {l = 0x84548fa58, i = 0} [23:45:17.002] active_snapshot_set = true [23:45:17.002] stmtlist_item = 0x84548fa70 [23:45:17.002] #14 0x000000000090336c in FillPortalStore (portal=portal@entry=0x8371b4100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [23:45:17.002] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:17.002] treceiver = 0x837165310 [23:45:17.002] #15 0x00000000009030db in PortalRun (portal=portal@entry=0x8371b4100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x84548faa8, altdest=altdest@entry=0x84548faa8, qc=0x8212e9e50) at ../src/backend/tcop/pquery.c:763 [23:45:17.002] _local_sigjmp_buf = {{_sjb = {9449597, 35284271360, 34916441416, 34916441648, 34916441424, 35284287488, 12105032, 12138344, 35284255615, 35283599616, 4294967984, 0}}} [23:45:17.002] _save_exception_stack = 0x8212e9f20 [23:45:17.002] _save_context_stack = 0x0 [23:45:17.002] _do_rethrow = false [23:45:17.002] saveTopTransactionResourceOwner = 0x837203cd8 [23:45:17.002] saveTopTransactionContext = 0x8371b8000 [23:45:17.002] saveActivePortal = 0x0 [23:45:17.002] saveResourceOwner = 0x837203cd8 [23:45:17.002] savePortalContext = 0x0 [23:45:17.002] saveMemoryContext = 0x8371b8000 [23:45:17.002] result = [23:45:17.002] nprocessed = [23:45:17.002] #16 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x837110100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [23:45:17.002] cmdtaglen = 5 [23:45:17.002] snapshot_set = [23:45:17.002] per_parsetree_context = 0x0 [23:45:17.002] plantree_list = [23:45:17.002] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:17.002] format = 0 [23:45:17.002] parsetree = 0x84542c268 [23:45:17.002] commandTag = [23:45:17.002] cmdtagname = [23:45:17.002] querytree_list = [23:45:17.002] portal = 0x8371b4100 [23:45:17.002] receiver = 0x84548faa8 [23:45:17.002] parsetree_item__state = {l = 0x84542db30, i = 0} [23:45:17.002] msec_str = "\000\000\000\000\b", '\000' , "\236\022\315f\000\000\000\000\363\312\337Tqm}6" [23:45:17.002] dest = DestRemote [23:45:17.002] was_logged = [23:45:17.002] oldcontext = 0x8371b8000 [23:45:17.002] parsetree_list = 0x84542db30 [23:45:17.002] use_implicit_block = false [23:45:17.002] parsetree_item = 0x84542db48 [23:45:17.002] save_log_statement_stats = [23:45:17.002] #17 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [23:45:17.002] query_string = 0x837110100 "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"... [23:45:17.002] input_message = {data = 0x837110100 "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} [23:45:17.002] firstchar = [23:45:17.002] local_sigjmp_buf = {{_sjb = {9433510, 34916441888, 34916441848, 34916442432, 12147080, 1, 8192, 8388608, 34916402047, 0, 0, 1}}} [23:45:17.002] send_ready_for_query = false [23:45:17.002] idle_in_transaction_timeout_enabled = false [23:45:17.002] idle_session_timeout_enabled = false [23:45:17.002] #18 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:45:17.002] bsdata = [23:45:17.002] #19 0x0000000000854667 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8212eac64 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212eaba0) at ../src/backend/postmaster/launch_backend.c:274 [23:45:17.002] pid = [23:45:17.002] #20 0x0000000000858a28 in BackendStartup (client_sock=0x8212eaba0) at ../src/backend/postmaster/postmaster.c:3414 [23:45:17.002] startup_data = {canAcceptConnections = CAC_OK} [23:45:17.002] bn = 0x83711dfb8 [23:45:17.002] pid = [23:45:17.002] __error = [23:45:17.002] save_errno = [23:45:17.002] __error = [23:45:17.002] __error = [23:45:17.002] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [23:45:17.002] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\300\036\0217\b", '\000' , "\254.!\b\000\000\000hu\312*\b\000\000\000\v\000\000\000\000\000\000\000^\377\312*\b", '\000' , "@\254.!\b\000\000\000\024D\205\000\000\000\000\000P\254.!\b", '\000' }, salen = 16}} [23:45:17.002] i = 0 [23:45:17.002] now = [23:45:17.002] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 734526594, events = 8, fd = 0, user_data = 0x8212eab50}, {pos = 924288472, events = 8, fd = 556706272, user_data = 0x0}, {pos = 0, events = 0, fd = 1127280954, user_data = 0x17acbc81730a}, {pos = 733693856, events = 8, fd = 733764984, user_data = 0x8212ea668}, {pos = 556705504, events = 8, fd = 556705384, user_data = 0x17acbc81730a}, {pos = 733672328, events = 8, fd = 733764984, user_data = 0x8212ea698}, {pos = 556705552, events = 8, fd = 556705432, user_data = 0x82bbbe194}, {pos = 570000392, events = 8, fd = 733733268, user_data = 0x8212ea700}, {pos = -1132387270, events = 6060, fd = 735555632, user_data = 0x1}, {pos = 556705584, events = 8, fd = -1132367094, user_data = 0x82bba7858}, {pos = 733764984, events = 8, fd = 556705544, user_data = 0x8212ea780}, {pos = 556705544, events = 8, fd = 733728012, user_data = 0x821f98408}, {pos = 733728012, events = 8, fd = 556705648, user_data = 0x17acbc81243a}, {pos = 556705688, events = 8, fd = 556706136, user_data = 0x8212ea780}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1907836967, fd = 570023992, user_data = 0x800000001}, {pos = 570000392, events = 8, fd = 733672328, user_data = 0x821f9d288}, {pos = 733640792, events = 8, fd = 570000392, user_data = 0x8212ea808}, {pos = 556706248, events = 8, fd = 556705776, user_data = 0x17acbc816ca2}, {pos = 2699790, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 570023992, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556706504, user_data = 0x21f98408}, {pos = 556706320, events = 8, fd = 556705920, user_data = 0x1}, {pos = 556706248, events = 8, fd = 32, user_data = 0x8212ea870}, {pos = -1132369293, events = 6060, fd = 556706192, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821f9e038}, {pos = 1, events = 8, fd = 570000392, user_data = 0x82bba7858}, {pos = 556706504, events = 8, fd = 556706320, user_data = 0x8212ea880}, {pos = 0, events = 0, fd = 569970696, user_data = 0x20}, {pos = 556706304, events = 8, fd = -1132393753, user_data = 0x821f91008}, {pos = 569971720, events = 8, fd = 569972744, user_data = 0x821f91c08}, {pos = 569987080, events = 8, fd = 569988104, user_data = 0x821f95808}, {pos = 569990152, events = 8, fd = 569991176, user_data = 0x821f96408}, {pos = 569993224, events = 8, fd = 569994248, user_data = 0x821f97008}, {pos = 569996296, events = 8, fd = 569997320, user_data = 0x821f97c08}, {pos = 569999368, events = 8, fd = 570000392, user_data = 0x821f98808}, {pos = 570002440, events = 8, fd = 570003464, user_data = 0x821f99408}, {pos = 570005512, events = 8, fd = 570006536, user_data = 0x821f9a008}, {pos = 570008584, events = 8, fd = 570009608, user_data = 0x821f9ac08}, {pos = 570015752, events = 8, fd = 570016776, user_data = 0x821f9c808}, {pos = 570018824, events = 8, fd = 569970696, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821f9e038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556706504, events = 8, fd = 556705920, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 570023992, user_data = 0x1}, {pos = 569970696, events = 8, fd = 314, user_data = 0x8212eaab0}, {pos = -1132395025, events = 6060, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 570023992, user_data = 0x1}, {pos = 570000392, events = 8, fd = 923795456, user_data = 0x1}, {pos = 923795860, events = 8, fd = 0, user_data = 0x8212eaa80}, {pos = 717944172, events = 8, fd = 1, user_data = 0x837100000}, {pos = 556706480, events = 8, fd = 717940482, user_data = 0x82bcd9170 }, {pos = 12072120, events = 0, fd = 734892400, user_data = 0x821f98408}, {pos = 556706704, events = 8, fd = -1132395554, user_data = 0x83711e800}, {pos = 1, events = 0, fd = -1132395938, user_data = 0x821f91008}, {pos = 556706488, events = 8, fd = 556706704, user_data = 0x1c38}, {pos = 923868864, events = 8, fd = -1132316272, user_data = 0x0}, {pos = 556663679, events = 8, fd = 7886791, user_data = 0x8212eab40}, {pos = 717902864, events = 8, fd = 735555632, user_data = 0x82bd7d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8212eab70}, {pos = 717945757, events = 8, fd = 923795456, user_data = 0x1ae2}, {pos = 556706768, events = 8, fd = 717912314, user_data = 0x0}, {pos = 0, events = 0, fd = 1127280954, user_data = 0x0}} [23:45:17.002] last_touch_time = 1724715667 [23:45:17.002] last_lockfile_recheck_time = 1724715667 [23:45:17.002] nevents = 1 [23:45:17.002] #22 0x0000000000856845 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212eb1b8) at ../src/backend/postmaster/postmaster.c:1346 [23:45:17.002] userDoption = [23:45:17.002] listen_addr_saved = [23:45:17.002] output_config_variable = [23:45:17.002] opt = [23:45:17.002] status = [23:45:17.002] #23 0x00000000007924cc in main (argc=4, argv=0x8212eb1b8) at ../src/backend/main/main.c:197 [23:45:17.002] do_check_root = [23:45:17.014] [23:45:17.014] [23:45:17.014] [23:45:17.076] dumping /tmp/cores/postgres.15090.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:45:17.195] [New LWP 101852] [23:45:17.259] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [23:45:17.259] Program terminated with signal SIGABRT, Aborted. [23:45:17.259] Sent by thr_kill() from pid 15090 and user 1003. [23:45:17.259] #0 0x000000082cfd841a in thr_kill () from /lib/libc.so.7 [23:45:17.755] [23:45:17.755] Thread 1 (LWP 101852): [23:45:17.755] #0 0x000000082cfd841a in thr_kill () from /lib/libc.so.7 [23:45:17.755] No symbol table info available. [23:45:17.755] #1 0x000000082cf51e64 in raise () from /lib/libc.so.7 [23:45:17.755] No symbol table info available. [23:45:17.755] #2 0x000000082d0026f9 in abort () from /lib/libc.so.7 [23:45:17.755] No symbol table info available. [23:45:17.755] #3 0x0000000000a58cd5 in ExceptionalCondition (conditionName=0x2d0abb "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [23:45:17.755] No locals. [23:45:17.755] #4 0x000000000073d2df in ExecFetchSlotHeapTuple (slot=0x8212c4af0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [23:45:17.755] No locals. [23:45:17.755] #5 0x0000000000701f97 in ExecIRDeleteTriggers (estate=estate@entry=0x834b5b100, relinfo=relinfo@entry=0x834b5b6b0, slot=slot@entry=0x8212c4af0) at ../src/backend/commands/trigger.c:2841 [23:45:17.755] trigger = [23:45:17.755] oldtuple = [23:45:17.755] should_free = false [23:45:17.755] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83b2a9de0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [23:45:17.755] trigdesc = 0x834b5b8c0 [23:45:17.755] newtuple = 0x0 [23:45:17.755] i = 0 [23:45:17.755] #6 0x00000000007624b7 in ExecMergeMatched (context=0x8212c4b98, resultRelInfo=0x834b5b6b0, tupleid=0x0, oldtuple=0x8212c4af0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [23:45:17.755] result = TM_Ok [23:45:17.755] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [23:45:17.755] relaction = 0x83b3699f8 [23:45:17.755] commandType = CMD_DELETE [23:45:17.755] l__state = {l = 0x83b369fb8, i = 0} [23:45:17.755] mtstate = 0x834b5b4a0 [23:45:17.755] newslot = 0x0 [23:45:17.755] rslot = 0x0 [23:45:17.755] estate = 0x834b5b100 [23:45:17.755] mergeActions = [23:45:17.755] econtext = 0x83b369028 [23:45:17.755] epqstate = 0x834b5b588 [23:45:17.755] actionStates = 0x83b369fb8 [23:45:17.755] l = [23:45:17.755] isNull = [23:45:17.755] lmerge_matched = [23:45:17.755] __error = [23:45:17.755] l__state = [23:45:17.755] result = [23:45:17.755] updateCxt = [23:45:17.755] relaction = [23:45:17.755] commandType = [23:45:17.755] __error = [23:45:17.755] resultRelationDesc = [23:45:17.755] lockmode = [23:45:17.755] inputslot = [23:45:17.755] epqslot = [23:45:17.755] was_matched = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] #7 ExecMerge (context=0x8212c4b98, resultRelInfo=0x834b5b6b0, tupleid=0x0, oldtuple=0x8212c4af0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [23:45:17.755] matched = [23:45:17.755] rslot = 0x0 [23:45:17.755] #8 ExecModifyTable (pstate=0x834b5b4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [23:45:17.755] context = {mtstate = 0x834b5b4a0, epqstate = 0x834b5b588, estate = 0x834b5b100, planSlot = 0x834af9330, tmfd = {ctid = {ip_blkid = {bi_hi = 19854, bi_lo = 11517}, ip_posid = 8}, xmax = 148, cmax = 0, traversed = 120}, cpUpdateReturningSlot = 0xd1fc99c6874fa178} [23:45:17.755] tuple_ctid = {ip_blkid = {bi_hi = 19392, bi_lo = 8492}, ip_posid = 8} [23:45:17.755] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83b2e3118} [23:45:17.755] node = 0x834b5b4a0 [23:45:17.755] estate = 0x834b5b100 [23:45:17.755] operation = CMD_MERGE [23:45:17.755] resultRelInfo = 0x834b5b6b0 [23:45:17.755] subplanstate = 0x834b5cdf0 [23:45:17.755] slot = [23:45:17.755] tupleid = 0x0 [23:45:17.755] oldtuple = 0x8212c4af0 [23:45:17.755] oldSlot = [23:45:17.755] #9 0x000000000072f54b in ExecProcNode (node=0x834b5b4a0) at ../src/include/executor/executor.h:278 [23:45:17.755] No locals. [23:45:17.755] #10 ExecutePlan (estate=0x834b5b100, planstate=0x834b5b4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x83498fb10, execute_once=) at ../src/backend/executor/execMain.c:1641 [23:45:17.755] current_tuple_count = 0 [23:45:17.755] slot = [23:45:17.755] #11 standard_ExecutorRun (queryDesc=0x8349dec48, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [23:45:17.755] estate = 0x834b5b100 [23:45:17.755] oldcontext = 0x83498f800 [23:45:17.755] operation = CMD_MERGE [23:45:17.755] dest = 0x83498fb10 [23:45:17.755] sendTuples = true [23:45:17.755] #12 0x0000000838fc5961 in pgss_ExecutorRun (queryDesc=0x8349dec48, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [23:45:17.755] _local_sigjmp_buf = {{_sjb = {35315800369, 1, 34916289736, 34916289904, 12138344, 34916289744, 1, 35242503240, 34916270975, 7610529, 35244060672, 34359738368}}} [23:45:17.755] _save_exception_stack = 0x8212c4e80 [23:45:17.755] _save_context_stack = 0x0 [23:45:17.755] _do_rethrow = false [23:45:17.755] #13 0x00000000009042bf in ProcessQuery (plan=0x83b404600, sourceText=, params=0x0, queryEnv=0x0, dest=0x83498fb10, qc=0x8212c4e48) at ../src/backend/tcop/pquery.c:160 [23:45:17.755] queryDesc = 0x8349dec48 [23:45:17.755] #14 0x000000000090385d in PortalRunMulti (portal=portal@entry=0x834a27100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x83498fb10, altdest=0xb4a6b0 , qc=qc@entry=0x8212c4e48) at ../src/backend/tcop/pquery.c:1287 [23:45:17.755] pstmt = 0x83b404600 [23:45:17.755] stmtlist_item__state = {l = 0x83b408eb8, i = 0} [23:45:17.755] active_snapshot_set = true [23:45:17.755] stmtlist_item = 0x83b408ed0 [23:45:17.755] #15 0x000000000090336c in FillPortalStore (portal=portal@entry=0x834a27100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [23:45:17.755] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:17.755] treceiver = 0x83498fb10 [23:45:17.755] #16 0x00000000009030db in PortalRun (portal=portal@entry=0x834a27100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83b408f08, altdest=altdest@entry=0x83b408f08, qc=0x8212c4f80) at ../src/backend/tcop/pquery.c:763 [23:45:17.755] _local_sigjmp_buf = {{_sjb = {9449597, 35242799360, 34916290168, 34916290400, 34916290176, 35242893312, 12105032, 12138344, 35242771327, 35242119424, 4294967984, 0}}} [23:45:17.755] _save_exception_stack = 0x8212c5050 [23:45:17.755] _save_context_stack = 0x0 [23:45:17.755] _do_rethrow = false [23:45:17.755] saveTopTransactionResourceOwner = 0x834a75618 [23:45:17.755] saveTopTransactionContext = 0x834a3e000 [23:45:17.755] saveActivePortal = 0x0 [23:45:17.755] saveResourceOwner = 0x834a75618 [23:45:17.755] savePortalContext = 0x0 [23:45:17.755] saveMemoryContext = 0x834a3e000 [23:45:17.755] result = [23:45:17.755] nprocessed = [23:45:17.755] #17 0x0000000000901fa2 in exec_simple_query (query_string=query_string@entry=0x834981100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [23:45:17.755] cmdtaglen = 5 [23:45:17.755] snapshot_set = [23:45:17.755] per_parsetree_context = 0x0 [23:45:17.755] plantree_list = [23:45:17.755] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:17.755] format = 0 [23:45:17.755] parsetree = 0x83b3bb4a8 [23:45:17.755] commandTag = [23:45:17.755] cmdtagname = [23:45:17.755] querytree_list = [23:45:17.755] portal = 0x834a27100 [23:45:17.755] receiver = 0x83b408f08 [23:45:17.755] parsetree_item__state = {l = 0x83b3bcd70, i = 0} [23:45:17.755] msec_str = "\000\000\000\000\b", '\000' , "\275\022\315f\000\000\000\000Sv\035\367\334", [23:45:17.755] dest = DestRemote [23:45:17.755] was_logged = [23:45:17.755] oldcontext = 0x834a3e000 [23:45:17.755] parsetree_list = 0x83b3bcd70 [23:45:17.755] use_implicit_block = false [23:45:17.755] parsetree_item = 0x83b3bcd88 [23:45:17.755] save_log_statement_stats = [23:45:17.755] #18 0x00000000008ffd10 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [23:45:17.755] query_string = 0x834981100 "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"... [23:45:17.755] input_message = {data = 0x834981100 "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} [23:45:17.755] firstchar = [23:45:17.755] local_sigjmp_buf = {{_sjb = {9433510, 34916290640, 34916290600, 34916291184, 12147080, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [23:45:17.755] send_ready_for_query = false [23:45:17.755] idle_in_transaction_timeout_enabled = false [23:45:17.755] idle_session_timeout_enabled = false [23:45:17.755] #19 0x00000000008fa4e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:45:17.755] bsdata = [23:45:17.755] #20 0x0000000000854667 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8212c5d94 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212c5cd0) at ../src/backend/postmaster/launch_backend.c:274 [23:45:17.755] pid = [23:45:17.755] #21 0x0000000000858a28 in BackendStartup (client_sock=0x8212c5cd0) at ../src/backend/postmaster/postmaster.c:3414 [23:45:17.755] startup_data = {canAcceptConnections = CAC_OK} [23:45:17.755] bn = 0x83498d1c8 [23:45:17.755] pid = [23:45:17.755] __error = [23:45:17.755] save_errno = [23:45:17.755] __error = [23:45:17.755] __error = [23:45:17.755] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [23:45:17.755] 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 = " \034\2304\b", '\000' , "0],!\b\000\000\000h%g+\b\000\000\000\v\000\000\000\000\000\000\000^\257g+\b", '\000' , "p],!\b\000\000\000\024D\205\000\000\000\000\000\200],!\b", '\000' }, salen = 16}} [23:45:17.755] i = 0 [23:45:17.755] now = [23:45:17.755] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 754437250, events = 8, fd = 0, user_data = 0x8212c5c80}, {pos = 882808280, events = 8, fd = 556555024, user_data = 0x0}, {pos = -1866898678, events = 5338, fd = 753604512, user_data = 0x82cec2d78}, {pos = 556554120, events = 8, fd = 556554240, user_data = 0x8212c5788}, {pos = -1866898678, events = 5338, fd = 753582984, user_data = 0x82cec2d78}, {pos = 556554168, events = 8, fd = 556554288, user_data = 0x8212c57b8}, {pos = 753643924, events = 8, fd = 566752264, user_data = 0x82cebb194}, {pos = 556554272, events = 8, fd = -1866918854, user_data = 0x8212c57c0}, {pos = 728171536, events = 8, fd = 755466288, user_data = 0x14da90b9630a}, {pos = 753551448, events = 8, fd = 753675640, user_data = 0x8212c5828}, {pos = 556554400, events = 8, fd = 556554280, user_data = 0x82ceb9d0c}, {pos = 566752264, events = 8, fd = 753638668, user_data = 0x8212c5890}, {pos = -1866918854, events = 5338, fd = 556554424, user_data = 0x8212c5a88}, {pos = 556554400, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821c85038}, {pos = 1, events = 3522992582, fd = 566752264, user_data = 0x82ceac388}, {pos = 566773704, events = 8, fd = 0, user_data = 0x0}, {pos = 556554536, events = 8, fd = 556555000, user_data = 0x8212c5910}, {pos = -1866900318, events = 5338, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 3522992582, fd = 566775864, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8212c5bf8}, {pos = 566752264, events = 3, fd = 556555072, user_data = 0x821c84828}, {pos = 656, events = 0, fd = 556555000, user_data = 0x8212c5928}, {pos = 556554640, events = 8, fd = -1866900709, user_data = 0x8212c5ac0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 566775864, events = 8, fd = 1, user_data = 0x821c7f408}, {pos = 753551448, events = 8, fd = 556555256, user_data = 0x8212c5b40}, {pos = 556554656, events = 8, fd = 0, user_data = 0x821c78008}, {pos = 33, events = 0, fd = 556555056, user_data = 0x14da90b8fae7}, {pos = 566722568, events = 8, fd = 566723592, user_data = 0x821c78808}, {pos = 566725640, events = 8, fd = 566738952, user_data = 0x821c7c408}, {pos = 566741000, events = 8, fd = 566742024, user_data = 0x821c7d008}, {pos = 566744072, events = 8, fd = 566745096, user_data = 0x821c7dc08}, {pos = 566747144, events = 8, fd = 566748168, user_data = 0x821c7e808}, {pos = 566750216, events = 8, fd = 566751240, user_data = 0x821c7f408}, {pos = 566753288, events = 8, fd = 566754312, user_data = 0x821c80008}, {pos = 566756360, events = 8, fd = 566757384, user_data = 0x821c80c08}, {pos = 566759432, events = 8, fd = 566760456, user_data = 0x821c81808}, {pos = 566762504, events = 8, fd = 566767624, user_data = 0x821c83408}, {pos = 566769672, events = 8, fd = 566770696, user_data = 0x821c86408}, {pos = 487843000, events = 0, fd = 566722568, user_data = 0x29320e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821c85038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556555256, events = 8, fd = 556554656, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 566775864, user_data = 0x1}, {pos = 566722568, events = 8, fd = 314, user_data = 0x8212c5be0}, {pos = -1866926609, events = 5338, fd = 2699790, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 566775864, user_data = 0x1}, {pos = 566752264, events = 8, fd = 882315264, user_data = 0x1}, {pos = 882315668, events = 8, fd = 0, user_data = 0x8212c5bb0}, {pos = 728212844, events = 8, fd = 1, user_data = 0x834971000}, {pos = 556555232, events = 8, fd = 728209154, user_data = 0x82cfd6170 }, {pos = 12072120, events = 0, fd = 754803056, user_data = 0x821c7f408}, {pos = 556555456, events = 8, fd = -1866927138, user_data = 0x83498f800}, {pos = 1, events = 0, fd = -1866927522, user_data = 0x821c78008}, {pos = 556555240, events = 8, fd = 556555456, user_data = 0x1c38}, {pos = 882383904, events = 8, fd = -1866847856, user_data = 0x0}, {pos = 556532607, events = 8, fd = 7886791, user_data = 0x8212c5c70}, {pos = 728171536, events = 8, fd = 755466288, user_data = 0x82d07a310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8212c5ca0}, {pos = 728214429, events = 8, fd = 882315264, user_data = 0x3338}, {pos = 556555520, events = 8, fd = 728180986, user_data = 0x0}, {pos = 0, events = 0, fd = -2024824456, user_data = 0x0}} [23:45:17.755] last_touch_time = 1724715697 [23:45:17.755] last_lockfile_recheck_time = 1724715697 [23:45:17.755] nevents = 1 [23:45:17.755] #23 0x0000000000856845 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212c62e0) at ../src/backend/postmaster/postmaster.c:1346 [23:45:17.755] userDoption = [23:45:17.755] listen_addr_saved = [23:45:17.755] output_config_variable = [23:45:17.755] opt = [23:45:17.755] status = [23:45:17.755] #24 0x00000000007924cc in main (argc=4, argv=0x8212c62e0) at ../src/backend/main/main.c:197 [23:45:17.755] do_check_root =