[15:39:29.581] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [15:39:29.928] dumping /tmp/cores/postgres.7698.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:39:30.063] [New LWP 101662] [15:39:30.154] Core was generated by `postgres: postgres regression [local] MERGE'. [15:39:30.154] Program terminated with signal SIGABRT, Aborted. [15:39:30.154] Sent by thr_kill() from pid 7698 and user 1003. [15:39:30.154] #0 0x000000082b38bdca in thr_kill () from /lib/libc.so.7 [15:39:30.673] [15:39:30.673] Thread 1 (LWP 101662): [15:39:30.673] #0 0x000000082b38bdca in thr_kill () from /lib/libc.so.7 [15:39:30.673] No symbol table info available. [15:39:30.673] #1 0x000000082b3046f4 in raise () from /lib/libc.so.7 [15:39:30.673] No symbol table info available. [15:39:30.673] #2 0x000000082b3b5bc9 in abort () from /lib/libc.so.7 [15:39:30.673] No symbol table info available. [15:39:30.673] #3 0x0000000000a43f57 in ExceptionalCondition (conditionName=, fileName=0x36f44c "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:39:30.673] No locals. [15:39:30.673] #4 0x000000000072fc90 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820e7da08, materialize=, shouldFree=shouldFree@entry=0x820e7d8c6) at ../src/backend/executor/execTuples.c:1737 [15:39:30.673] No locals. [15:39:30.673] #5 0x00000000006f61d8 in ExecIRDeleteTriggers (estate=estate@entry=0x836e8a100, relinfo=relinfo@entry=0x836e8a6b0, slot=slot@entry=0x820e7da08) at ../src/backend/commands/trigger.c:2832 [15:39:30.673] trigger = [15:39:30.673] oldtuple = [15:39:30.673] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8435d7670, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:39:30.673] trigdesc = 0x836e8a8c0 [15:39:30.673] newtuple = 0x0 [15:39:30.673] i = 0 [15:39:30.673] should_free = false [15:39:30.673] #6 0x0000000000755375 in ExecMergeMatched (context=0x820e7da40, resultRelInfo=0x836e8a6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2938 [15:39:30.673] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:39:30.673] relaction = 0x8436f2598 [15:39:30.673] commandType = CMD_DELETE [15:39:30.673] result = TM_Ok [15:39:30.673] l__state = {l = 0x8436f2b58, i = 0} [15:39:30.673] mtstate = 0x836e8a4a0 [15:39:30.673] newslot = 0x0 [15:39:30.673] rslot = 0x0 [15:39:30.673] estate = 0x18d1e [15:39:30.673] econtext = 0x8436f1bc8 [15:39:30.673] epqstate = 0x836e8a588 [15:39:30.673] l = [15:39:30.673] isNull = [15:39:30.673] __error = [15:39:30.673] l__state = [15:39:30.673] updateCxt = [15:39:30.673] relaction = [15:39:30.673] commandType = [15:39:30.673] result = [15:39:30.673] __error = [15:39:30.673] resultRelationDesc = [15:39:30.673] lockmode = [15:39:30.673] inputslot = [15:39:30.673] epqslot = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] #7 ExecMerge (context=context@entry=0x820e7da40, resultRelInfo=resultRelInfo@entry=0x836e8a6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820e7da08, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2717 [15:39:30.673] matched = [15:39:30.673] rslot = 0x0 [15:39:30.673] #8 0x0000000000754393 in ExecModifyTable (pstate=0x836e8a4a0) at ../src/backend/executor/nodeModifyTable.c:3981 [15:39:30.673] context = {mtstate = 0x836e8a4a0, epqstate = 0x836e8a588, estate = 0x836e8a100, planSlot = 0x8436f06e8, tmfd = {ctid = {ip_blkid = {bi_hi = 10, bi_lo = 0}, ip_posid = 5}, xmax = 921215232, cmax = 8, traversed = 128}, cpUpdateReturningSlot = 0x0} [15:39:30.673] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [15:39:30.673] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836f66118} [15:39:30.673] node = 0x836e8a4a0 [15:39:30.673] estate = 0x836e8a100 [15:39:30.673] operation = CMD_MERGE [15:39:30.673] resultRelInfo = 0x6 [15:39:30.673] subplanstate = 0x836e8bdf0 [15:39:30.673] tupleid = 0x0 [15:39:30.673] oldtuple = 0x820e7da08 [15:39:30.673] slot = [15:39:30.673] oldSlot = [15:39:30.673] #9 0x0000000000729cdb in ExecProcNodeFirst (node=0x836e8a4a0) at ../src/backend/executor/execProcnode.c:464 [15:39:30.673] No locals. [15:39:30.673] #10 0x000000000072208a in ExecProcNode (node=0x836e8a4a0) at ../src/include/executor/executor.h:274 [15:39:30.673] No locals. [15:39:30.673] #11 ExecutePlan (estate=0x836e8a100, planstate=0x836e8a4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836d98b10, execute_once=false) at ../src/backend/executor/execMain.c:1644 [15:39:30.673] current_tuple_count = [15:39:30.673] slot = [15:39:30.673] #12 standard_ExecutorRun (queryDesc=0x836e2d448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [15:39:30.673] estate = 0x836e8a100 [15:39:30.673] oldcontext = 0x836d98800 [15:39:30.673] operation = CMD_MERGE [15:39:30.673] dest = 0x836d98b10 [15:39:30.673] sendTuples = true [15:39:30.673] #13 0x0000000000721f3f in ExecutorRun (queryDesc=0x18d1e, queryDesc@entry=0x836e2d448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [15:39:30.673] No locals. [15:39:30.673] #14 0x00000000008f3a9f in ProcessQuery (plan=0x84371d958, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820e7dc48) at ../src/backend/tcop/pquery.c:160 [15:39:30.673] queryDesc = 0x836e2d448 [15:39:30.673] #15 0x00000000008f303d in PortalRunMulti (portal=portal@entry=0x836e60100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836d98b10, altdest=0xb33850 , qc=qc@entry=0x820e7dc48) at ../src/backend/tcop/pquery.c:1286 [15:39:30.673] pstmt = 0x84371d958 [15:39:30.673] stmtlist_item__state = {l = 0x8437221c0, i = 0} [15:39:30.673] active_snapshot_set = true [15:39:30.673] stmtlist_item = 0x8437221d8 [15:39:30.673] #16 0x00000000008f2b2c in FillPortalStore (portal=portal@entry=0x836e60100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:39:30.673] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:39:30.673] treceiver = 0x836d98b10 [15:39:30.673] #17 0x00000000008f2880 in PortalRun (portal=portal@entry=0x836e60100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x843722210, altdest=altdest@entry=0x843722210, qc=0x820e7dd80) at ../src/backend/tcop/pquery.c:763 [15:39:30.673] _local_sigjmp_buf = {{_sjb = {9381919, 35280852568, 34911804536, 34911804768, 34911804544, 12040424, 12008208, 35280781568, 7112098687, 35280789760, 3564523, 34359738368}}} [15:39:30.673] _save_exception_stack = 0x820e7de50 [15:39:30.673] _save_context_stack = 0x0 [15:39:30.673] _do_rethrow = false [15:39:30.673] saveTopTransactionResourceOwner = 0x836e71658 [15:39:30.673] saveTopTransactionContext = 0x836d96000 [15:39:30.673] saveActivePortal = 0x0 [15:39:30.673] saveResourceOwner = 0x836e71658 [15:39:30.673] savePortalContext = 0x0 [15:39:30.673] saveMemoryContext = 0x836d96000 [15:39:30.673] result = [15:39:30.673] nprocessed = [15:39:30.673] #18 0x00000000008f178b in exec_simple_query (query_string=query_string@entry=0x836d8a100 "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 [15:39:30.673] cmdtaglen = [15:39:30.673] snapshot_set = [15:39:30.673] per_parsetree_context = 0x0 [15:39:30.673] plantree_list = [15:39:30.673] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:39:30.673] parsetree = 0x8436bf228 [15:39:30.673] commandTag = CMDTAG_MERGE [15:39:30.673] cmdtagname = [15:39:30.673] querytree_list = [15:39:30.673] portal = 0x836e60100 [15:39:30.673] format = 0 [15:39:30.673] receiver = 0x843722210 [15:39:30.673] parsetree_item__state = {l = 0x8436c0af0, i = 0} [15:39:30.673] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [15:39:30.673] dest = DestRemote [15:39:30.673] was_logged = [15:39:30.673] oldcontext = 0x836d96000 [15:39:30.673] parsetree_list = 0x8436c0af0 [15:39:30.673] use_implicit_block = false [15:39:30.673] parsetree_item = 0x8436c0b08 [15:39:30.673] save_log_statement_stats = [15:39:30.673] #19 0x00000000008ef574 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [15:39:30.673] query_string = 0x836d8a100 "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"... [15:39:30.673] input_message = {data = 0x836d8a100 "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} [15:39:30.673] firstchar = [15:39:30.673] local_sigjmp_buf = {{_sjb = {9366080, 34911805008, 34911804968, 34911805568, 12049160, 11995632, 8192, 8388608, 72057628949676927, 0, 0, 34359738369}}} [15:39:30.673] send_ready_for_query = false [15:39:30.673] idle_in_transaction_timeout_enabled = false [15:39:30.673] idle_session_timeout_enabled = false [15:39:30.673] #20 0x00000000008ea2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [15:39:30.673] bsdata = [15:39:30.673] #21 0x0000000000847132 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820e7eb90 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e7ead8) at ../src/backend/postmaster/launch_backend.c:265 [15:39:30.673] pid = [15:39:30.673] #22 0x000000000084b951 in BackendStartup (client_sock=0x820e7ead8) at ../src/backend/postmaster/postmaster.c:3593 [15:39:30.673] startup_data = {canAcceptConnections = CAC_OK} [15:39:30.673] bn = 0x836d96218 [15:39:30.673] pid = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] save_errno = [15:39:30.673] __error = [15:39:30.673] __error = [15:39:30.673] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [15:39:30.673] 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' , "0\353\347 \b\000\000\000\330u\275+\b\000\000\000\v\000\000\000\000\000\000\000\016\366\275+\b", '\000' , "p\353\347 \b\000\000\000\004o\204\000\000\000\000\000\200\353\347 \b", '\000' }, salen = 16}} [15:39:30.673] i = 0 [15:39:30.673] now = [15:39:30.673] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 723995748, events = 8, fd = 552067360, user_data = 0x820e7e2b0}, {pos = 558998536, events = 8, fd = 32, user_data = 0x820e7e2a0}, {pos = -1073546604, events = 9365, fd = 558968840, user_data = 0x821513408}, {pos = 558970888, events = 8, fd = 558971912, user_data = 0x821517008}, {pos = 558986248, events = 8, fd = 558987272, user_data = 0x821517c08}, {pos = 558989320, events = 8, fd = 558990344, user_data = 0x821518808}, {pos = 558992392, events = 8, fd = 558993416, user_data = 0x821519408}, {pos = 558995464, events = 8, fd = 558996488, user_data = 0x82151a008}, {pos = 558998536, events = 8, fd = -1, user_data = 0x82b44c2e0}, {pos = 552067600, events = 8, fd = 725586345, user_data = 0x0}, {pos = 4096, events = 0, fd = 893265221, user_data = 0x82b44c7e8}, {pos = 914398176, events = 8, fd = 160, user_data = 0x0}, {pos = 886874256, events = 8, fd = 552067808, user_data = 0x82b3d792c}, {pos = 4096, events = 0, fd = 724011364, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 559024696, user_data = 0x800000001}, {pos = 558998536, events = 8, fd = 723925208, user_data = 0x820e7e368}, {pos = 552067360, events = 8, fd = 32, user_data = 0x82b274c64}, {pos = 558998536, events = 8, fd = 559024696, user_data = 0x0}, {pos = 2625, events = 0, fd = 552067920, user_data = 0x2495c002f645}, {pos = 724011364, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 559024696, events = 8, fd = 1, user_data = 0x82151a408}, {pos = 920100864, events = 8, fd = 1, user_data = 0x836d7a194}, {pos = 0, events = 0, fd = 552067872, user_data = 0x82bbdec0c}, {pos = 1, events = 0, fd = 920100864, user_data = 0x820e7e350}, {pos = 733863604, events = 8, fd = 725737824, user_data = 0x82b41e160 }, {pos = 724107456, events = 8, fd = 558998536, user_data = 0x820e7e430}, {pos = -1073548244, events = 9365, fd = 886874256, user_data = 0x800000001}, {pos = -1073548626, events = 9365, fd = 12240, user_data = 0x820e7e358}, {pos = 552068144, events = 8, fd = 920807400, user_data = 0x820e7e9a0}, {pos = -1073467760, events = 9365, fd = 558998536, user_data = 0x820e7037f}, {pos = 725394844, events = 8, fd = 558968840, user_data = 0x0}, {pos = 558998536, events = 8, fd = 12240, user_data = 0x82b254000}, {pos = 1964368, events = 0, fd = 725737824, user_data = 0x82b274c64}, {pos = 15616, events = 0, fd = 552069328, user_data = 0x820e7e4a0}, {pos = 724668814, events = 8, fd = 725776440, user_data = 0x820e7e464}, {pos = 920544730, events = 8, fd = 552069328, user_data = 0x820e7e4a0}, {pos = 724760069, events = 8, fd = 552068194, user_data = 0x820e7e8d0}, {pos = 552069328, events = 8, fd = 0, user_data = 0xf6a1654e353e2545}, {pos = 552069328, events = 8, fd = 920544728, user_data = 0x820e7e9a0}, {pos = 725776440, events = 8, fd = 0, user_data = 0x820e7e910}, {pos = 724760333, events = 8, fd = 0, user_data = 0x0}, {pos = 552069696, events = 8, fd = 920544728, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1073519607, events = 9365, fd = 552068600, user_data = 0x82b274c64}, {pos = 2503, events = 0, fd = -1073519607, user_data = 0x820e7e618}, {pos = 723995748, events = 8, fd = 2758, user_data = 0x82b26e120}, {pos = 552068504, events = 8, fd = 558998536, user_data = 0x820e7e618}, {pos = 723968288, events = 8, fd = 552068608, user_data = 0x2495c0031465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b4400f0}, {pos = 723928400, events = 8, fd = 0, user_data = 0x0}, {pos = 725805488, events = 8, fd = -1073519607, user_data = 0x820e7e6a8}, {pos = 723995748, events = 8, fd = 2924, user_data = 0x82b26e3b8}, {pos = 552068648, events = 8, fd = 558998536, user_data = 0x820e7e6a8}, {pos = 723968952, events = 8, fd = 552068752, user_data = 0x2495c0031465}, {pos = 559022136, events = 8, fd = 2671093, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 558998536, events = 8, fd = 723928400, user_data = 0x820e7e968}, {pos = 558998536, events = 8, fd = 552069192, user_data = 0x1e}, {pos = 723932384, events = 8, fd = 552068920, user_data = 0x82151f248}, {pos = 552069368, events = 8, fd = 552068896, user_data = 0x2495c0035da3}, {pos = 559022136, events = 8, fd = 2694563, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 559022136, user_data = 0x1}} [15:39:30.673] last_touch_time = 1711467390 [15:39:30.673] last_lockfile_recheck_time = 1711467390 [15:39:30.673] nevents = 1 [15:39:30.673] #24 0x0000000000849226 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820e7f0d8) at ../src/backend/postmaster/postmaster.c:1372 [15:39:30.673] userDoption = [15:39:30.673] listen_addr_saved = false [15:39:30.673] output_config_variable = [15:39:30.673] opt = [15:39:30.673] status = [15:39:30.673] #25 0x00000000007849e5 in main (argc=8, argv=0x820e7f0d8) at ../src/backend/main/main.c:197 [15:39:30.673] do_check_root = [15:39:30.683] [15:39:30.683] [15:39:30.683] [15:39:30.744] dumping /tmp/cores/postgres.8409.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:39:30.869] [New LWP 101734] [15:39:30.935] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [15:39:30.935] Program terminated with signal SIGABRT, Aborted. [15:39:30.935] Sent by thr_kill() from pid 8409 and user 1003. [15:39:30.935] #0 0x000000082d5ffdca in thr_kill () from /lib/libc.so.7 [15:39:31.453] [15:39:31.453] Thread 1 (LWP 101734): [15:39:31.453] #0 0x000000082d5ffdca in thr_kill () from /lib/libc.so.7 [15:39:31.453] No symbol table info available. [15:39:31.453] #1 0x000000082d5786f4 in raise () from /lib/libc.so.7 [15:39:31.453] No symbol table info available. [15:39:31.453] #2 0x000000082d629bc9 in abort () from /lib/libc.so.7 [15:39:31.453] No symbol table info available. [15:39:31.453] #3 0x0000000000a43f57 in ExceptionalCondition (conditionName=, fileName=0x36f44c "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:39:31.453] No locals. [15:39:31.453] #4 0x000000000072fc90 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821864ad8, materialize=, shouldFree=shouldFree@entry=0x821864996) at ../src/backend/executor/execTuples.c:1737 [15:39:31.453] No locals. [15:39:31.453] #5 0x00000000006f61d8 in ExecIRDeleteTriggers (estate=estate@entry=0x8366f6100, relinfo=relinfo@entry=0x8366f66b0, slot=slot@entry=0x821864ad8) at ../src/backend/commands/trigger.c:2832 [15:39:31.453] trigger = [15:39:31.453] oldtuple = [15:39:31.453] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x843e50470, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:39:31.453] trigdesc = 0x8366f68c0 [15:39:31.453] newtuple = 0x0 [15:39:31.453] i = 0 [15:39:31.453] should_free = false [15:39:31.453] #6 0x0000000000755375 in ExecMergeMatched (context=0x821864b10, resultRelInfo=0x8366f66b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2938 [15:39:31.453] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:39:31.453] relaction = 0x843f48e58 [15:39:31.453] commandType = CMD_DELETE [15:39:31.453] result = TM_Ok [15:39:31.453] l__state = {l = 0x843f49418, i = 0} [15:39:31.453] mtstate = 0x8366f64a0 [15:39:31.453] newslot = 0x0 [15:39:31.453] rslot = 0x0 [15:39:31.453] estate = 0x18d66 [15:39:31.453] econtext = 0x843f48488 [15:39:31.453] epqstate = 0x8366f6588 [15:39:31.453] l = [15:39:31.453] isNull = [15:39:31.453] __error = [15:39:31.453] l__state = [15:39:31.453] updateCxt = [15:39:31.453] relaction = [15:39:31.453] commandType = [15:39:31.453] result = [15:39:31.453] __error = [15:39:31.453] resultRelationDesc = [15:39:31.453] lockmode = [15:39:31.453] inputslot = [15:39:31.453] epqslot = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] #7 ExecMerge (context=context@entry=0x821864b10, resultRelInfo=resultRelInfo@entry=0x8366f66b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x821864ad8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2717 [15:39:31.453] matched = [15:39:31.453] rslot = 0x0 [15:39:31.453] #8 0x0000000000754393 in ExecModifyTable (pstate=0x8366f64a0) at ../src/backend/executor/nodeModifyTable.c:3981 [15:39:31.453] context = {mtstate = 0x8366f64a0, epqstate = 0x8366f6588, estate = 0x8366f6100, planSlot = 0x843f46fa8, tmfd = {ctid = {ip_blkid = {bi_hi = 10, bi_lo = 0}, ip_posid = 5}, xmax = 913268992, cmax = 8, traversed = 80}, cpUpdateReturningSlot = 0x0} [15:39:31.453] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [15:39:31.453] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83670e118} [15:39:31.453] node = 0x8366f64a0 [15:39:31.453] estate = 0x8366f6100 [15:39:31.453] operation = CMD_MERGE [15:39:31.453] resultRelInfo = 0x6 [15:39:31.453] subplanstate = 0x8366f7df0 [15:39:31.453] tupleid = 0x0 [15:39:31.453] oldtuple = 0x821864ad8 [15:39:31.453] slot = [15:39:31.453] oldSlot = [15:39:31.453] #9 0x0000000000729cdb in ExecProcNodeFirst (node=0x8366f64a0) at ../src/backend/executor/execProcnode.c:464 [15:39:31.453] No locals. [15:39:31.453] #10 0x000000000072208a in ExecProcNode (node=0x8366f64a0) at ../src/include/executor/executor.h:274 [15:39:31.453] No locals. [15:39:31.453] #11 ExecutePlan (estate=0x8366f6100, planstate=0x8366f64a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836590b10, execute_once=false) at ../src/backend/executor/execMain.c:1644 [15:39:31.453] current_tuple_count = [15:39:31.453] slot = [15:39:31.453] #12 standard_ExecutorRun (queryDesc=0x836612448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [15:39:31.453] estate = 0x8366f6100 [15:39:31.453] oldcontext = 0x836590800 [15:39:31.453] operation = CMD_MERGE [15:39:31.453] dest = 0x836590b10 [15:39:31.453] sendTuples = true [15:39:31.453] #13 0x0000000000721f3f in ExecutorRun (queryDesc=0x18d66, queryDesc@entry=0x836612448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [15:39:31.453] No locals. [15:39:31.453] #14 0x00000000008f3a9f in ProcessQuery (plan=0x843f74b58, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821864d18) at ../src/backend/tcop/pquery.c:160 [15:39:31.453] queryDesc = 0x836612448 [15:39:31.453] #15 0x00000000008f303d in PortalRunMulti (portal=portal@entry=0x8365f2100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836590b10, altdest=0xb33850 , qc=qc@entry=0x821864d18) at ../src/backend/tcop/pquery.c:1286 [15:39:31.453] pstmt = 0x843f74b58 [15:39:31.453] stmtlist_item__state = {l = 0x843f793c0, i = 0} [15:39:31.453] active_snapshot_set = true [15:39:31.453] stmtlist_item = 0x843f793d8 [15:39:31.453] #16 0x00000000008f2b2c in FillPortalStore (portal=portal@entry=0x8365f2100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:39:31.453] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:39:31.453] treceiver = 0x836590b10 [15:39:31.453] #17 0x00000000008f2880 in PortalRun (portal=portal@entry=0x8365f2100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x843f79410, altdest=altdest@entry=0x843f79410, qc=0x821864e50) at ../src/backend/tcop/pquery.c:763 [15:39:31.453] _local_sigjmp_buf = {{_sjb = {9381919, 35272245656, 34922188104, 34922188336, 34922188112, 12040424, 12008208, 35271942400, 7112098687, 35271950592, 3564523, 34359738368}}} [15:39:31.453] _save_exception_stack = 0x821864f20 [15:39:31.453] _save_context_stack = 0x0 [15:39:31.453] _do_rethrow = false [15:39:31.453] saveTopTransactionResourceOwner = 0x83663c198 [15:39:31.453] saveTopTransactionContext = 0x836565000 [15:39:31.453] saveActivePortal = 0x0 [15:39:31.453] saveResourceOwner = 0x83663c198 [15:39:31.453] savePortalContext = 0x0 [15:39:31.453] saveMemoryContext = 0x836565000 [15:39:31.453] result = [15:39:31.453] nprocessed = [15:39:31.453] #18 0x00000000008f178b in exec_simple_query (query_string=query_string@entry=0x836559100 "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 [15:39:31.453] cmdtaglen = [15:39:31.453] snapshot_set = [15:39:31.453] per_parsetree_context = 0x0 [15:39:31.453] plantree_list = [15:39:31.453] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:39:31.453] parsetree = 0x843f16728 [15:39:31.453] commandTag = CMDTAG_MERGE [15:39:31.453] cmdtagname = [15:39:31.453] querytree_list = [15:39:31.453] portal = 0x8365f2100 [15:39:31.453] format = 0 [15:39:31.453] receiver = 0x843f79410 [15:39:31.453] parsetree_item__state = {l = 0x843f17ff0, i = 0} [15:39:31.453] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [15:39:31.453] dest = DestRemote [15:39:31.453] was_logged = [15:39:31.453] oldcontext = 0x836565000 [15:39:31.453] parsetree_list = 0x843f17ff0 [15:39:31.453] use_implicit_block = false [15:39:31.453] parsetree_item = 0x843f18008 [15:39:31.453] save_log_statement_stats = [15:39:31.453] #19 0x00000000008ef574 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [15:39:31.453] query_string = 0x836559100 "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"... [15:39:31.453] input_message = {data = 0x836559100 "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} [15:39:31.453] firstchar = [15:39:31.453] local_sigjmp_buf = {{_sjb = {9366080, 34922188576, 34922188536, 34922189136, 12049160, 11995632, 8192, 8388608, 72057628960097151, 0, 0, 34359738369}}} [15:39:31.453] send_ready_for_query = false [15:39:31.453] idle_in_transaction_timeout_enabled = false [15:39:31.453] idle_session_timeout_enabled = false [15:39:31.453] #20 0x00000000008ea2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [15:39:31.453] bsdata = [15:39:31.453] #21 0x0000000000847132 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821865c60 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821865ba8) at ../src/backend/postmaster/launch_backend.c:265 [15:39:31.453] pid = [15:39:31.453] #22 0x000000000084b951 in BackendStartup (client_sock=0x821865ba8) at ../src/backend/postmaster/postmaster.c:3593 [15:39:31.453] startup_data = {canAcceptConnections = CAC_OK} [15:39:31.453] bn = 0x8365654e8 [15:39:31.453] pid = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] save_errno = [15:39:31.453] __error = [15:39:31.453] __error = [15:39:31.453] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [15:39:31.453] 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' , "\\\206!\b\000\000\000\330U\262+\b\000\000\000\v\000\000\000\000\000\000\000\016ֲ+\b", '\000' , "@\\\206!\b\000\000\000\004o\204\000\000\000\000\000P\\\206!\b", '\000' }, salen = 16}} [15:39:31.453] i = 0 [15:39:31.453] now = [15:39:31.453] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 760122468, events = 8, fd = 562450928, user_data = 0x821865380}, {pos = 572785672, events = 8, fd = 32, user_data = 0x821865370}, {pos = -2036884844, events = 15730, fd = 572755976, user_data = 0x822239408}, {pos = 572758024, events = 8, fd = 572759048, user_data = 0x82223d008}, {pos = 572773384, events = 8, fd = 572774408, user_data = 0x82223dc08}, {pos = 572776456, events = 8, fd = 572777480, user_data = 0x82223e808}, {pos = 572779528, events = 8, fd = 572780552, user_data = 0x82223f408}, {pos = 572782600, events = 8, fd = 572783624, user_data = 0x822240008}, {pos = 572785672, events = 8, fd = 572805256, user_data = 0x8218654f8}, {pos = 562451232, events = 8, fd = -2036859485, user_data = 0x0}, {pos = 2567910, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 572809272, events = 8, fd = 1, user_data = 0x822240408}, {pos = 760030376, events = 8, fd = 562451960, user_data = 0x822240408}, {pos = 562451216, events = 0, fd = 760138084, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 572811832, user_data = 0x1}, {pos = 572785672, events = 8, fd = 760051928, user_data = 0x821865438}, {pos = 562450928, events = 8, fd = 32, user_data = 0x82d4e8c64}, {pos = 572785672, events = 8, fd = 572811832, user_data = 0x0}, {pos = 2625, events = 0, fd = 562451488, user_data = 0x3d7286979645}, {pos = 760138084, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 572811832, events = 8, fd = 1, user_data = 0x822240408}, {pos = 911511552, events = 8, fd = 1, user_data = 0x836549194}, {pos = 0, events = 0, fd = 562451440, user_data = 0x82bb2cc0c}, {pos = 1, events = 0, fd = 911511552, user_data = 0x821865420}, {pos = 733134516, events = 8, fd = 761864544, user_data = 0x82d692160 }, {pos = 760234176, events = 8, fd = 572785672, user_data = 0x821865500}, {pos = -2036886484, events = 15730, fd = 572784648, user_data = 0x800000001}, {pos = -2036886866, events = 15730, fd = 12240, user_data = 0x821865428}, {pos = 562451712, events = 8, fd = 912308200, user_data = 0x821865a70}, {pos = -2036806000, events = 15730, fd = 572785672, user_data = 0x82186037f}, {pos = 761521330, events = 8, fd = 572755976, user_data = 0x0}, {pos = 572785672, events = 8, fd = 12240, user_data = 0x82d4c8000}, {pos = 1964368, events = 0, fd = 761864544, user_data = 0x82d4e8c64}, {pos = 15616, events = 0, fd = 562452896, user_data = 0x821865570}, {pos = 760795534, events = 8, fd = 761903160, user_data = 0x821865534}, {pos = 911963610, events = 8, fd = 562452896, user_data = 0x821865570}, {pos = 760886789, events = 8, fd = 562451762, user_data = 0x8218659a0}, {pos = 562452896, events = 8, fd = 0, user_data = 0x486d21acd5f149bb}, {pos = 562452896, events = 8, fd = 911963608, user_data = 0x821865a70}, {pos = 761903160, events = 8, fd = 0, user_data = 0x8218659e0}, {pos = 760887053, events = 8, fd = 0, user_data = 0x0}, {pos = 562453264, events = 8, fd = 911963608, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -2036857847, events = 15730, fd = 562452168, user_data = 0x82d4e8c64}, {pos = 2503, events = 0, fd = -2036857847, user_data = 0x8218656e8}, {pos = 760122468, events = 8, fd = 2758, user_data = 0x82d4e2120}, {pos = 562452072, events = 8, fd = 572785672, user_data = 0x8218656e8}, {pos = 760095008, events = 8, fd = 562452176, user_data = 0x3d728697b465}, {pos = 0, events = 0, fd = 0, user_data = 0x82d6b40f0}, {pos = 760055120, events = 8, fd = 0, user_data = 0x0}, {pos = 761932208, events = 8, fd = -2036857847, user_data = 0x821865778}, {pos = 760122468, events = 8, fd = 2924, user_data = 0x82d4e23b8}, {pos = 562452216, events = 8, fd = 572785672, user_data = 0x821865778}, {pos = 760095672, events = 8, fd = 562452320, user_data = 0x3d728697b465}, {pos = 572809272, events = 8, fd = 2671093, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 572785672, events = 8, fd = 760055120, user_data = 0x821865a38}, {pos = 572785672, events = 8, fd = 562452760, user_data = 0x1e}, {pos = 760059104, events = 8, fd = 562452488, user_data = 0x822245248}, {pos = 562452936, events = 8, fd = 562452464, user_data = 0x3d728697fda3}, {pos = 572809272, events = 8, fd = 2694563, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 572809272, user_data = 0x1}} [15:39:31.454] last_touch_time = 1711467391 [15:39:31.454] last_lockfile_recheck_time = 1711467391 [15:39:31.454] nevents = 1 [15:39:31.454] #24 0x0000000000849226 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8218661a8) at ../src/backend/postmaster/postmaster.c:1372 [15:39:31.454] userDoption = [15:39:31.454] listen_addr_saved = false [15:39:31.454] output_config_variable = [15:39:31.454] opt = [15:39:31.454] status = [15:39:31.454] #25 0x00000000007849e5 in main (argc=4, argv=0x8218661a8) at ../src/backend/main/main.c:197 [15:39:31.454] do_check_root = [15:39:31.466] [15:39:31.466] [15:39:31.466] [15:39:31.530] dumping /tmp/cores/postgres.13904.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:39:31.654] [New LWP 101669] [15:39:31.719] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [15:39:31.719] Program terminated with signal SIGABRT, Aborted. [15:39:31.719] Sent by thr_kill() from pid 13904 and user 1003. [15:39:31.719] #0 0x000000082c009dca in thr_kill () from /lib/libc.so.7 [15:39:32.232] [15:39:32.232] Thread 1 (LWP 101669): [15:39:32.232] #0 0x000000082c009dca in thr_kill () from /lib/libc.so.7 [15:39:32.232] No symbol table info available. [15:39:32.232] #1 0x000000082bf826f4 in raise () from /lib/libc.so.7 [15:39:32.232] No symbol table info available. [15:39:32.232] #2 0x000000082c033bc9 in abort () from /lib/libc.so.7 [15:39:32.232] No symbol table info available. [15:39:32.232] #3 0x0000000000a43f57 in ExceptionalCondition (conditionName=, fileName=0x36f44c "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:39:32.232] No locals. [15:39:32.232] #4 0x000000000072fc90 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820e50188, materialize=, shouldFree=shouldFree@entry=0x820e50046) at ../src/backend/executor/execTuples.c:1737 [15:39:32.232] No locals. [15:39:32.232] #5 0x00000000006f61d8 in ExecIRDeleteTriggers (estate=estate@entry=0x836252100, relinfo=relinfo@entry=0x8362526b0, slot=slot@entry=0x820e50188) at ../src/backend/commands/trigger.c:2832 [15:39:32.232] trigger = [15:39:32.232] oldtuple = [15:39:32.232] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83f69c6e8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:39:32.232] trigdesc = 0x8362528c0 [15:39:32.232] newtuple = 0x0 [15:39:32.232] i = 0 [15:39:32.232] should_free = false [15:39:32.232] #6 0x0000000000755375 in ExecMergeMatched (context=0x820e501c0, resultRelInfo=0x8362526b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2938 [15:39:32.232] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:39:32.232] relaction = 0x83dc8a7d8 [15:39:32.232] commandType = CMD_DELETE [15:39:32.232] result = TM_Ok [15:39:32.232] l__state = {l = 0x83dc8ad98, i = 0} [15:39:32.232] mtstate = 0x8362524a0 [15:39:32.232] newslot = 0x0 [15:39:32.232] rslot = 0x0 [15:39:32.232] estate = 0x18d25 [15:39:32.232] econtext = 0x83dc89e08 [15:39:32.232] epqstate = 0x836252588 [15:39:32.232] l = [15:39:32.232] isNull = [15:39:32.232] __error = [15:39:32.232] l__state = [15:39:32.232] updateCxt = [15:39:32.232] relaction = [15:39:32.232] commandType = [15:39:32.232] result = [15:39:32.232] __error = [15:39:32.232] resultRelationDesc = [15:39:32.232] lockmode = [15:39:32.232] inputslot = [15:39:32.232] epqslot = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] #7 ExecMerge (context=context@entry=0x820e501c0, resultRelInfo=resultRelInfo@entry=0x8362526b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820e50188, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2717 [15:39:32.232] matched = [15:39:32.232] rslot = 0x0 [15:39:32.232] #8 0x0000000000754393 in ExecModifyTable (pstate=0x8362524a0) at ../src/backend/executor/nodeModifyTable.c:3981 [15:39:32.232] context = {mtstate = 0x8362524a0, epqstate = 0x836252588, estate = 0x836252100, planSlot = 0x83dc88928, tmfd = {ctid = {ip_blkid = {bi_hi = 544, bi_lo = 8421}, ip_posid = 8}, xmax = 738223838, cmax = 8, traversed = 113}, cpUpdateReturningSlot = 0xa66f56931e382746} [15:39:32.232] tuple_ctid = {ip_blkid = {bi_hi = 16602, bi_lo = 6278}, ip_posid = 32247} [15:39:32.232] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83625e118} [15:39:32.232] node = 0x8362524a0 [15:39:32.232] estate = 0x836252100 [15:39:32.232] operation = CMD_MERGE [15:39:32.232] resultRelInfo = 0x6 [15:39:32.232] subplanstate = 0x836253df0 [15:39:32.232] tupleid = 0x0 [15:39:32.232] oldtuple = 0x820e50188 [15:39:32.232] slot = [15:39:32.232] oldSlot = [15:39:32.232] #9 0x0000000000729cdb in ExecProcNodeFirst (node=0x8362524a0) at ../src/backend/executor/execProcnode.c:464 [15:39:32.232] No locals. [15:39:32.232] #10 0x000000000072208a in ExecProcNode (node=0x8362524a0) at ../src/include/executor/executor.h:274 [15:39:32.232] No locals. [15:39:32.232] #11 ExecutePlan (estate=0x836252100, planstate=0x8362524a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836190f10, execute_once=false) at ../src/backend/executor/execMain.c:1644 [15:39:32.232] current_tuple_count = [15:39:32.232] slot = [15:39:32.232] #12 standard_ExecutorRun (queryDesc=0x83614d448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [15:39:32.232] estate = 0x836252100 [15:39:32.232] oldcontext = 0x836190c00 [15:39:32.232] operation = CMD_MERGE [15:39:32.232] dest = 0x836190f10 [15:39:32.232] sendTuples = true [15:39:32.232] #13 0x0000000838cd3963 in pgss_ExecutorRun (queryDesc=0x83614d448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [15:39:32.232] _local_sigjmp_buf = {{_sjb = {35312711986, 12040424, 34911617768, 34911617936, 35267073096, 34911617776, 1, 1, 35268133759, 35267073096, 12049152, 34359738368}}} [15:39:32.232] _save_exception_stack = 0x820e504b0 [15:39:32.232] _save_context_stack = 0x0 [15:39:32.232] _do_rethrow = false [15:39:32.232] #14 0x0000000000721f38 in ExecutorRun (queryDesc=0x18d25, queryDesc@entry=0x83614d448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [15:39:32.232] No locals. [15:39:32.232] #15 0x00000000008f3a9f in ProcessQuery (plan=0x83dc72e48, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820e50478) at ../src/backend/tcop/pquery.c:160 [15:39:32.232] queryDesc = 0x83614d448 [15:39:32.232] #16 0x00000000008f303d in PortalRunMulti (portal=portal@entry=0x83612f100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836190f10, altdest=0xb33850 , qc=qc@entry=0x820e50478) at ../src/backend/tcop/pquery.c:1286 [15:39:32.232] pstmt = 0x83dc72e48 [15:39:32.232] stmtlist_item__state = {l = 0x83dc776b0, i = 0} [15:39:32.232] active_snapshot_set = true [15:39:32.232] stmtlist_item = 0x83dc776c8 [15:39:32.232] #17 0x00000000008f2b2c in FillPortalStore (portal=portal@entry=0x83612f100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:39:32.232] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:39:32.232] treceiver = 0x836190f10 [15:39:32.232] #18 0x00000000008f2880 in PortalRun (portal=portal@entry=0x83612f100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83dc77700, altdest=altdest@entry=0x83dc77700, qc=0x820e505b0) at ../src/backend/tcop/pquery.c:763 [15:39:32.232] _local_sigjmp_buf = {{_sjb = {9381919, 35267284184, 34911618216, 34911618448, 34911618224, 12040424, 12008208, 35266949376, 7112098687, 35266957568, 3564523, 34359738368}}} [15:39:32.232] _save_exception_stack = 0x820e50680 [15:39:32.232] _save_context_stack = 0x0 [15:39:32.232] _do_rethrow = false [15:39:32.232] saveTopTransactionResourceOwner = 0x836180cd8 [15:39:32.232] saveTopTransactionContext = 0x8360a0000 [15:39:32.232] saveActivePortal = 0x0 [15:39:32.232] saveResourceOwner = 0x836180cd8 [15:39:32.232] savePortalContext = 0x0 [15:39:32.232] saveMemoryContext = 0x8360a0000 [15:39:32.232] result = [15:39:32.232] nprocessed = [15:39:32.232] #19 0x00000000008f178b in exec_simple_query (query_string=query_string@entry=0x836094100 "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 [15:39:32.232] cmdtaglen = [15:39:32.232] snapshot_set = [15:39:32.232] per_parsetree_context = 0x0 [15:39:32.232] plantree_list = [15:39:32.232] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:39:32.232] parsetree = 0x83dc2a768 [15:39:32.232] commandTag = CMDTAG_MERGE [15:39:32.232] cmdtagname = [15:39:32.232] querytree_list = [15:39:32.232] portal = 0x83612f100 [15:39:32.232] format = 0 [15:39:32.232] receiver = 0x83dc77700 [15:39:32.232] parsetree_item__state = {l = 0x83dc2c030, i = 0} [15:39:32.232] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [15:39:32.232] dest = DestRemote [15:39:32.232] was_logged = [15:39:32.232] oldcontext = 0x8360a0000 [15:39:32.232] parsetree_list = 0x83dc2c030 [15:39:32.232] use_implicit_block = false [15:39:32.232] parsetree_item = 0x83dc2c048 [15:39:32.232] save_log_statement_stats = [15:39:32.232] #20 0x00000000008ef574 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [15:39:32.232] query_string = 0x836094100 "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"... [15:39:32.232] input_message = {data = 0x836094100 "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} [15:39:32.232] firstchar = [15:39:32.232] local_sigjmp_buf = {{_sjb = {9366080, 34911618688, 34911618648, 34911619248, 12049160, 11995632, 8192, 8388608, 72057628949545855, 0, 0, 1}}} [15:39:32.232] send_ready_for_query = false [15:39:32.232] idle_in_transaction_timeout_enabled = false [15:39:32.232] idle_session_timeout_enabled = false [15:39:32.232] #21 0x00000000008ea2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [15:39:32.232] bsdata = [15:39:32.232] #22 0x0000000000847132 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820e513c0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e51308) at ../src/backend/postmaster/launch_backend.c:265 [15:39:32.232] pid = [15:39:32.232] #23 0x000000000084b951 in BackendStartup (client_sock=0x820e51308) at ../src/backend/postmaster/postmaster.c:3593 [15:39:32.232] startup_data = {canAcceptConnections = CAC_OK} [15:39:32.232] bn = 0x8360a06c8 [15:39:32.232] pid = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] save_errno = [15:39:32.232] __error = [15:39:32.232] __error = [15:39:32.232] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [15:39:32.232] 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' , "`\023\345 \b\000\000\000\330\345\002*\b\000\000\000\v\000\000\000\000\000\000\000\016f\003*\b", '\000' , "\240\023\345 \b\000\000\000\004o\204\000\000\000\000\000\260\023\345 \b", '\000' }, salen = 16}} [15:39:32.232] i = 0 [15:39:32.232] now = [15:39:32.232] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 551881440, events = 8, fd = 567587848, user_data = 0x21}, {pos = 551881424, events = 8, fd = -1181013356, user_data = 0x821d44008}, {pos = 567559176, events = 8, fd = 567560200, user_data = 0x821d44c08}, {pos = 567574536, events = 8, fd = 567575560, user_data = 0x821d48808}, {pos = 567577608, events = 8, fd = 567578632, user_data = 0x821d49408}, {pos = 567580680, events = 8, fd = 567581704, user_data = 0x821d4a008}, {pos = 567583752, events = 8, fd = 567584776, user_data = 0x821d4ac08}, {pos = 567586824, events = 8, fd = 567587848, user_data = 0x821d50088}, {pos = 551881816, events = 8, fd = 551881328, user_data = 0x32b99b8da3}, {pos = 567587848, events = 8, fd = 2567910, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 567611448, user_data = 0x1}, {pos = 567587848, events = 8, fd = 737002664, user_data = 0x820e50d58}, {pos = 567587848, events = 8, fd = 551881296, user_data = 0x272e30}, {pos = 551881888, events = 8, fd = 737110372, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 567614008, user_data = 0x3200000001}, {pos = 567587848, events = 8, fd = 737024216, user_data = 0x820e50b98}, {pos = 551881024, events = 8, fd = 33, user_data = 0x82bef2c64}, {pos = 567587848, events = 8, fd = 567614008, user_data = 0x0}, {pos = 2625, events = 0, fd = 551881600, user_data = 0x32b99b2645}, {pos = 737110372, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567614008, events = 8, fd = 1, user_data = 0x821d4b408}, {pos = 906510336, events = 8, fd = 1, user_data = 0x836084194}, {pos = 0, events = 0, fd = 551881552, user_data = 0x82a035c0c}, {pos = 1, events = 0, fd = 906510336, user_data = 0x820e50b80}, {pos = 704859828, events = 8, fd = 738836832, user_data = 0x82c09c160 }, {pos = 737206464, events = 8, fd = 567587848, user_data = 0x820e50c60}, {pos = -1181014996, events = 50, fd = 80627796, user_data = 0x1}, {pos = -1181015378, events = 50, fd = 12240, user_data = 0x820e50b88}, {pos = 551881824, events = 8, fd = 907306984, user_data = 0x820e511d0}, {pos = -1180934512, events = 50, fd = 567587848, user_data = 0x820e5037f}, {pos = 738493618, events = 8, fd = 551882128, user_data = 0x3200000000}, {pos = 567587848, events = 8, fd = 12240, user_data = 0x82bed2000}, {pos = 1964368, events = 0, fd = 738836832, user_data = 0x82bef2c64}, {pos = 15616, events = 0, fd = 551883008, user_data = 0x820e50cd0}, {pos = 737767822, events = 8, fd = 738875448, user_data = 0x820e50c94}, {pos = 906962394, events = 8, fd = 551883008, user_data = 0x820e50cd0}, {pos = 737859077, events = 8, fd = 551881874, user_data = 0x820e51100}, {pos = 551883008, events = 8, fd = 0, user_data = 0x52e97df7188640da}, {pos = 551883008, events = 8, fd = 906962392, user_data = 0x820e511d0}, {pos = 738875448, events = 8, fd = 0, user_data = 0x820e51140}, {pos = 737859341, events = 8, fd = 0, user_data = 0x0}, {pos = 551883376, events = 8, fd = 906962392, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1180986359, user_data = 0x820e50e18}, {pos = 737094756, events = 8, fd = 2503, user_data = 0x32b99b9409}, {pos = 551882296, events = 8, fd = 737094756, user_data = 0xac6}, {pos = 737067296, events = 8, fd = 551882168, user_data = 0x821d4b408}, {pos = 551882296, events = 8, fd = 737067296, user_data = 0x820e50e20}, {pos = -1181006747, events = 50, fd = 0, user_data = 0x800000000}, {pos = 551882256, events = 8, fd = 737027408, user_data = 0x0}, {pos = 0, events = 0, fd = 551882224, user_data = 0x32b99b9409}, {pos = 551882440, events = 8, fd = 737094756, user_data = 0xb6c}, {pos = 737067960, events = 8, fd = 551882312, user_data = 0x821d4b408}, {pos = 551882440, events = 8, fd = 737067960, user_data = 0x820e50eb0}, {pos = -1181006747, events = 50, fd = 567611448, user_data = 0x28c1f5}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 567587848, user_data = 0x82bee2550}, {pos = 551883160, events = 8, fd = 567587848, user_data = 0x20e51078}, {pos = 31, events = 0, fd = 0, user_data = 0x820e50f58}, {pos = 567609224, events = 8, fd = 551883048, user_data = 0x820e50f40}, {pos = -1180987997, events = 50, fd = 567611448, user_data = 0x291da3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821d51038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [15:39:32.232] last_touch_time = 1711467413 [15:39:32.232] last_lockfile_recheck_time = 1711467413 [15:39:32.232] nevents = 1 [15:39:32.232] #25 0x0000000000849226 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820e51908) at ../src/backend/postmaster/postmaster.c:1372 [15:39:32.232] userDoption = [15:39:32.232] listen_addr_saved = false [15:39:32.232] output_config_variable = [15:39:32.232] opt = [15:39:32.232] status = [15:39:32.232] #26 0x00000000007849e5 in main (argc=4, argv=0x820e51908) at ../src/backend/main/main.c:197 [15:39:32.232] do_check_root =