[16:45:39.550] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [16:45:39.913] dumping /tmp/cores/postgres.6582.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [16:45:40.056] [New LWP 100155] [16:45:40.156] Core was generated by `postgres: postgres regression [local] MERGE'. [16:45:40.156] Program terminated with signal SIGABRT, Aborted. [16:45:40.156] Sent by thr_kill() from pid 6582 and user 1003. [16:45:40.156] #0 0x000000082badadca in thr_kill () from /lib/libc.so.7 [16:45:40.753] [16:45:40.753] Thread 1 (LWP 100155): [16:45:40.753] #0 0x000000082badadca in thr_kill () from /lib/libc.so.7 [16:45:40.753] No symbol table info available. [16:45:40.753] #1 0x000000082ba536f4 in raise () from /lib/libc.so.7 [16:45:40.753] No symbol table info available. [16:45:40.753] #2 0x000000082bb04bc9 in abort () from /lib/libc.so.7 [16:45:40.753] No symbol table info available. [16:45:40.753] #3 0x0000000000a24f17 in ExceptionalCondition (conditionName=, fileName=0x36c85e "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [16:45:40.753] No locals. [16:45:40.753] #4 0x0000000000716380 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82110b9a8, materialize=, shouldFree=shouldFree@entry=0x82110b886) at ../src/backend/executor/execTuples.c:1649 [16:45:40.753] No locals. [16:45:40.753] #5 0x00000000006de008 in ExecIRDeleteTriggers (estate=estate@entry=0x8372e6100, relinfo=relinfo@entry=0x8372e66b0, slot=slot@entry=0x82110b9a8) at ../src/backend/commands/trigger.c:2841 [16:45:40.753] trigger = [16:45:40.753] oldtuple = [16:45:40.753] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8371fcbc0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [16:45:40.753] trigdesc = 0x8372e68c0 [16:45:40.753] newtuple = 0x0 [16:45:40.753] i = 0 [16:45:40.753] should_free = false [16:45:40.753] #6 0x000000000073ba98 in ExecMergeMatched (context=0x82110b9e0, resultRelInfo=0x8372e66b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [16:45:40.753] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [16:45:40.753] commandType = CMD_DELETE [16:45:40.753] result = TM_Ok [16:45:40.753] relaction = [16:45:40.753] l__state = {l = 0x837323a68, i = 0} [16:45:40.753] mtstate = 0x8372e64a0 [16:45:40.753] estate = 0x1873b [16:45:40.753] econtext = 0x837323268 [16:45:40.753] epqstate = 0x8372e6588 [16:45:40.753] l = [16:45:40.753] newslot = [16:45:40.753] isNull = [16:45:40.753] __error = [16:45:40.753] l__state = [16:45:40.753] updateCxt = [16:45:40.753] commandType = [16:45:40.753] result = [16:45:40.753] relaction = [16:45:40.753] __error = [16:45:40.753] resultRelationDesc = [16:45:40.753] lockmode = [16:45:40.753] inputslot = [16:45:40.753] epqslot = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] #7 ExecMerge (context=context@entry=0x82110b9e0, resultRelInfo=resultRelInfo@entry=0x8372e66b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x82110b9a8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [16:45:40.753] matched = [16:45:40.753] #8 0x000000000073ae47 in ExecModifyTable (pstate=0x8372e64a0) at ../src/backend/executor/nodeModifyTable.c:3950 [16:45:40.753] context = {mtstate = 0x8372e64a0, epqstate = 0x8372e6588, estate = 0x8372e6100, planSlot = 0x8373221a8, relaction = 0x8373234a8, tmfd = {ctid = {ip_blkid = {bi_hi = 24832, bi_lo = 14126}, ip_posid = 8}, xmax = 554744352, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [16:45:40.753] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [16:45:40.753] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83432a118} [16:45:40.753] node = 0x8372e64a0 [16:45:40.753] estate = 0x8372e6100 [16:45:40.753] operation = CMD_MERGE [16:45:40.753] resultRelInfo = 0x6 [16:45:40.753] subplanstate = 0x8372e7df0 [16:45:40.753] slot = 0x8373221a8 [16:45:40.753] tupleid = 0x0 [16:45:40.753] oldtuple = 0x82110b9a8 [16:45:40.753] oldSlot = [16:45:40.753] #9 0x00000000007105fb in ExecProcNodeFirst (node=0x8372e64a0) at ../src/backend/executor/execProcnode.c:464 [16:45:40.753] No locals. [16:45:40.753] #10 0x00000000007089ea in ExecProcNode (node=0x8372e64a0) at ../src/include/executor/executor.h:274 [16:45:40.753] No locals. [16:45:40.753] #11 ExecutePlan (estate=0x8372e6100, planstate=0x8372e64a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x8373499a0, execute_once=) at ../src/backend/executor/execMain.c:1638 [16:45:40.753] current_tuple_count = [16:45:40.753] slot = [16:45:40.753] #12 standard_ExecutorRun (queryDesc=0x834230900, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:357 [16:45:40.753] estate = 0x8372e6100 [16:45:40.753] oldcontext = 0x834230800 [16:45:40.753] operation = CMD_MERGE [16:45:40.753] dest = 0x8373499a0 [16:45:40.753] sendTuples = false [16:45:40.753] #13 0x00000000007088af in ExecutorRun (queryDesc=0x1873b, queryDesc@entry=0x834230900, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:301 [16:45:40.753] No locals. [16:45:40.753] #14 0x00000000008d7e0f in ProcessQuery (plan=0x837345b28, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82110bce0) at ../src/backend/tcop/pquery.c:160 [16:45:40.753] queryDesc = 0x834230900 [16:45:40.753] #15 0x00000000008d73ad in PortalRunMulti (portal=portal@entry=0x8342f8100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8373499a0, altdest=altdest@entry=0x8373499a0, qc=0x82110bce0) at ../src/backend/tcop/pquery.c:1286 [16:45:40.753] pstmt = 0x837345b28 [16:45:40.753] stmtlist_item__state = {l = 0x837349950, i = 0} [16:45:40.753] active_snapshot_set = true [16:45:40.753] stmtlist_item = 0x837349968 [16:45:40.753] #16 0x00000000008d6c1b in PortalRun (portal=portal@entry=0x8342f8100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82badadaa , dest@entry=0x8373499a0, altdest=0x0, altdest@entry=0x8373499a0, qc=0x82110bce0) at ../src/backend/tcop/pquery.c:791 [16:45:40.753] _local_sigjmp_buf = {{_sjb = {9268111, 35235340056, 34914483160, 34914483392, 34914483168, 11901592, 11869376, 35235266816, -6347183290305215617, 35235275008, 3553573, 34359738368}}} [16:45:40.753] _save_exception_stack = 0x82110bdb0 [16:45:40.753] _save_context_stack = 0x0 [16:45:40.753] _do_rethrow = false [16:45:40.753] saveTopTransactionResourceOwner = 0x834309f18 [16:45:40.753] saveTopTransactionContext = 0x83422e000 [16:45:40.753] saveActivePortal = 0x0 [16:45:40.753] saveResourceOwner = 0x834309f18 [16:45:40.753] savePortalContext = 0x0 [16:45:40.753] saveMemoryContext = 0x83422e000 [16:45:40.753] result = [16:45:40.753] nprocessed = [16:45:40.753] #17 0x00000000008d5afb in exec_simple_query (query_string=query_string@entry=0x834222100 "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:1273 [16:45:40.753] cmdtaglen = [16:45:40.753] snapshot_set = [16:45:40.753] per_parsetree_context = 0x0 [16:45:40.753] plantree_list = [16:45:40.753] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:45:40.753] parsetree = 0x8372c1fc8 [16:45:40.753] commandTag = CMDTAG_MERGE [16:45:40.753] cmdtagname = [16:45:40.753] querytree_list = [16:45:40.753] portal = 0x8342f8100 [16:45:40.753] format = 0 [16:45:40.753] receiver = 0x8373499a0 [16:45:40.753] parsetree_item__state = {l = 0x8372f29f8, i = 0} [16:45:40.753] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [16:45:40.753] dest = DestRemote [16:45:40.753] was_logged = [16:45:40.753] oldcontext = 0x83422e000 [16:45:40.753] parsetree_list = 0x8372f29f8 [16:45:40.753] use_implicit_block = false [16:45:40.753] parsetree_item = 0x8372f2a10 [16:45:40.753] save_log_statement_stats = [16:45:40.753] #18 0x00000000008d38e4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4668 [16:45:40.753] query_string = 0x834222100 "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"... [16:45:40.753] input_message = {data = 0x834222100 "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 = 241, maxlen = 1024, cursor = 241} [16:45:40.753] firstchar = [16:45:40.753] local_sigjmp_buf = {{_sjb = {9252272, 34914483632, 34914483592, 34914484192, 11910328, 11856816, 8192, 8388608, 72057628952363903, 0, 0, 34359738369}}} [16:45:40.753] send_ready_for_query = false [16:45:40.753] idle_in_transaction_timeout_enabled = false [16:45:40.753] idle_session_timeout_enabled = false [16:45:40.753] #19 0x000000000083264a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [16:45:40.753] No locals. [16:45:40.753] #20 0x00000000008308d0 in BackendStartup (client_sock=0x82110ca08) at ../src/backend/postmaster/postmaster.c:4117 [16:45:40.753] bn = 0x83422e498 [16:45:40.753] cac = CAC_OK [16:45:40.753] pid = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] __error = [16:45:40.753] save_errno = [16:45:40.753] __error = [16:45:40.753] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [16:45:40.753] 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 = "X\374\267+\000\000\000\000\001\000\000\000\000\000\000\000@\336\264", '\000' , " \266\265\000\000\000\000\000\v\000\000\000\000\000\000\000\200\312\020!\b\000\000\000\330\025*+\b\000\000\000@\336\264\000\000\000\000\000\016\226*+\b", '\000' , "\300\312\020!\b\000\000\000Ĺ\202\000\000\000\000"}, salen = 16}} [16:45:40.753] i = 0 [16:45:40.753] now = [16:45:40.753] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 731659364, events = 8, fd = 554745936, user_data = 0x82110c1e0}, {pos = 556323848, events = 8, fd = 32, user_data = 0x82110c1d0}, {pos = -1001031020, events = 8098, fd = 556294152, user_data = 0x821286408}, {pos = 556296200, events = 8, fd = 556297224, user_data = 0x82128a008}, {pos = 556311560, events = 8, fd = 556312584, user_data = 0x82128ac08}, {pos = 556314632, events = 8, fd = 556315656, user_data = 0x82128b808}, {pos = 556317704, events = 8, fd = 556318728, user_data = 0x82128c408}, {pos = 556320776, events = 8, fd = 556321800, user_data = 0x82128d008}, {pos = 556323848, events = 8, fd = -1, user_data = 0x82bb9b2e0}, {pos = 554746176, events = 8, fd = 733249961, user_data = 0x0}, {pos = 4096, events = 0, fd = 1089419986, user_data = 0x82bb9b7e8}, {pos = 872455136, events = 8, fd = 160, user_data = 0x0}, {pos = 835801232, events = 8, fd = 554746384, user_data = 0x82bb2692c}, {pos = 4096, events = 0, fd = 731674980, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 556350008, user_data = 0x800000001}, {pos = 556323848, events = 8, fd = 731588824, user_data = 0x82110c298}, {pos = 554745936, events = 8, fd = 32, user_data = 0x82b9c3c64}, {pos = 556323848, events = 8, fd = 556350008, user_data = 0x0}, {pos = 2625, events = 0, fd = 554746496, user_data = 0x1fa2c4557645}, {pos = 731674980, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 556350008, events = 8, fd = 1, user_data = 0x82128d408}, {pos = 874586112, events = 8, fd = 1, user_data = 0x834212194}, {pos = 0, events = 0, fd = 554746448, user_data = 0x82b2a8c0c}, {pos = 1, events = 0, fd = 874586112, user_data = 0x82110c280}, {pos = 724205236, events = 8, fd = 733401440, user_data = 0x82bb6d160 }, {pos = 731771072, events = 8, fd = 556323848, user_data = 0x82110c360}, {pos = -1001032660, events = 8098, fd = 835801232, user_data = 0x800000001}, {pos = -1001033042, events = 8098, fd = 12240, user_data = 0x82110c288}, {pos = 554746720, events = 8, fd = 875292648, user_data = 0x82110c8d0}, {pos = -1000952176, events = 8098, fd = 556323848, user_data = 0x82110037f}, {pos = 733058460, events = 8, fd = 556294152, user_data = 0x0}, {pos = 556323848, events = 8, fd = 12240, user_data = 0x82b9a3000}, {pos = 1964368, events = 0, fd = 733401440, user_data = 0x82b9c3c64}, {pos = 15616, events = 0, fd = 554747904, user_data = 0x82110c3d0}, {pos = 732332430, events = 8, fd = 733440056, user_data = 0x82110c394}, {pos = 875029978, events = 8, fd = 554747904, user_data = 0x82110c3d0}, {pos = 732423685, events = 8, fd = 554746770, user_data = 0x82110c800}, {pos = 554747904, events = 8, fd = 0, user_data = 0x506fa98540ef3ad2}, {pos = 554747904, events = 8, fd = 875029976, user_data = 0x82110c8d0}, {pos = 733440056, events = 8, fd = 0, user_data = 0x82110c840}, {pos = 732423949, events = 8, fd = 0, user_data = 0x0}, {pos = 554748272, events = 8, fd = 875029976, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1001004023, events = 8098, fd = 554747176, user_data = 0x82b9c3c64}, {pos = 2503, events = 0, fd = -1001004023, user_data = 0x82110c548}, {pos = 731659364, events = 8, fd = 2758, user_data = 0x82b9bd120}, {pos = 554747080, events = 8, fd = 556323848, user_data = 0x82110c548}, {pos = 731631904, events = 8, fd = 554747184, user_data = 0x1fa2c4559465}, {pos = 0, events = 0, fd = 0, user_data = 0x82bb8f0f0}, {pos = 731592016, events = 8, fd = 0, user_data = 0x0}, {pos = 733469104, events = 8, fd = 16, user_data = 0x0}, {pos = 554747320, events = 8, fd = 556343432, user_data = 0x1fa2c455e409}, {pos = 554747384, events = 8, fd = 731659364, user_data = 0xb6c}, {pos = 731632568, events = 8, fd = 554747256, user_data = 0x82128d408}, {pos = 554747384, events = 8, fd = 731632568, user_data = 0x82110c5e0}, {pos = -1001024411, events = 8098, fd = 556347448, user_data = 0x800000001}, {pos = 556323848, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 554747768, user_data = 0x2725d8}, {pos = 554747872, events = 8, fd = 554747872, user_data = 0x82110c798}, {pos = 30, events = 0, fd = 731596000, user_data = 0x82110c688}, {pos = 556343880, events = 8, fd = 554747976, user_data = 0x82110c670}, {pos = -1001005661, events = 8098, fd = 556347448, user_data = 0x2911eb}} [16:45:40.753] last_touch_time = 1710261630 [16:45:40.753] last_lockfile_recheck_time = 1710261630 [16:45:40.753] nevents = 1 [16:45:40.753] #22 0x000000000082dbc6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82110d000) at ../src/backend/postmaster/postmaster.c:1478 [16:45:40.753] userDoption = [16:45:40.753] listen_addr_saved = false [16:45:40.753] output_config_variable = [16:45:40.753] opt = [16:45:40.753] status = [16:45:40.753] #23 0x000000000076b165 in main (argc=8, argv=0x82110d000) at ../src/backend/main/main.c:197 [16:45:40.753] do_check_root = [16:45:40.775] [16:45:40.775] [16:45:40.775] [16:45:40.847] dumping /tmp/cores/postgres.7000.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:45:40.983] [New LWP 100098] [16:45:41.062] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [16:45:41.062] Program terminated with signal SIGABRT, Aborted. [16:45:41.062] Sent by thr_kill() from pid 7000 and user 1003. [16:45:41.062] #0 0x000000082b6fedca in thr_kill () from /lib/libc.so.7 [16:45:41.686] [16:45:41.686] Thread 1 (LWP 100098): [16:45:41.686] #0 0x000000082b6fedca in thr_kill () from /lib/libc.so.7 [16:45:41.686] No symbol table info available. [16:45:41.686] #1 0x000000082b6776f4 in raise () from /lib/libc.so.7 [16:45:41.686] No symbol table info available. [16:45:41.686] #2 0x000000082b728bc9 in abort () from /lib/libc.so.7 [16:45:41.686] No symbol table info available. [16:45:41.686] #3 0x0000000000a24f17 in ExceptionalCondition (conditionName=, fileName=0x36c85e "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [16:45:41.686] No locals. [16:45:41.686] #4 0x0000000000716380 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82167e4d8, materialize=, shouldFree=shouldFree@entry=0x82167e3b6) at ../src/backend/executor/execTuples.c:1649 [16:45:41.686] No locals. [16:45:41.686] #5 0x00000000006de008 in ExecIRDeleteTriggers (estate=estate@entry=0x8406a5100, relinfo=relinfo@entry=0x8406a56b0, slot=slot@entry=0x82167e4d8) at ../src/backend/commands/trigger.c:2841 [16:45:41.686] trigger = [16:45:41.686] oldtuple = [16:45:41.686] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8405daaf0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [16:45:41.686] trigdesc = 0x8406a58c0 [16:45:41.686] newtuple = 0x0 [16:45:41.686] i = 0 [16:45:41.686] should_free = false [16:45:41.686] #6 0x000000000073ba98 in ExecMergeMatched (context=0x82167e510, resultRelInfo=0x8406a56b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [16:45:41.686] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [16:45:41.686] commandType = CMD_DELETE [16:45:41.686] result = TM_Ok [16:45:41.686] relaction = [16:45:41.686] l__state = {l = 0x8406e2528, i = 0} [16:45:41.686] mtstate = 0x8406a54a0 [16:45:41.686] estate = 0x18702 [16:45:41.686] econtext = 0x8406e1d28 [16:45:41.686] epqstate = 0x8406a5588 [16:45:41.686] l = [16:45:41.686] newslot = [16:45:41.686] isNull = [16:45:41.686] __error = [16:45:41.686] l__state = [16:45:41.686] updateCxt = [16:45:41.686] commandType = [16:45:41.686] result = [16:45:41.686] relaction = [16:45:41.686] __error = [16:45:41.686] resultRelationDesc = [16:45:41.686] lockmode = [16:45:41.686] inputslot = [16:45:41.686] epqslot = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] #7 ExecMerge (context=context@entry=0x82167e510, resultRelInfo=resultRelInfo@entry=0x8406a56b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x82167e4d8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [16:45:41.686] matched = [16:45:41.686] #8 0x000000000073ae47 in ExecModifyTable (pstate=0x8406a54a0) at ../src/backend/executor/nodeModifyTable.c:3950 [16:45:41.686] context = {mtstate = 0x8406a54a0, epqstate = 0x8406a5588, estate = 0x8406a5100, planSlot = 0x8406e0c68, relaction = 0x8406e1f68, tmfd = {ctid = {ip_blkid = {bi_hi = 20736, bi_lo = 16490}, ip_posid = 8}, xmax = 560457040, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [16:45:41.686] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [16:45:41.686] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8405fc118} [16:45:41.686] node = 0x8406a54a0 [16:45:41.686] estate = 0x8406a5100 [16:45:41.686] operation = CMD_MERGE [16:45:41.686] resultRelInfo = 0x6 [16:45:41.686] subplanstate = 0x8406a6df0 [16:45:41.686] slot = 0x8406e0c68 [16:45:41.686] tupleid = 0x0 [16:45:41.686] oldtuple = 0x82167e4d8 [16:45:41.686] oldSlot = [16:45:41.686] #9 0x00000000007105fb in ExecProcNodeFirst (node=0x8406a54a0) at ../src/backend/executor/execProcnode.c:464 [16:45:41.686] No locals. [16:45:41.686] #10 0x00000000007089ea in ExecProcNode (node=0x8406a54a0) at ../src/include/executor/executor.h:274 [16:45:41.686] No locals. [16:45:41.686] #11 ExecutePlan (estate=0x8406a5100, planstate=0x8406a54a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x840708c60, execute_once=) at ../src/backend/executor/execMain.c:1638 [16:45:41.686] current_tuple_count = [16:45:41.686] slot = [16:45:41.686] #12 standard_ExecutorRun (queryDesc=0x833cb3900, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:357 [16:45:41.686] estate = 0x8406a5100 [16:45:41.686] oldcontext = 0x833cb3800 [16:45:41.686] operation = CMD_MERGE [16:45:41.686] dest = 0x840708c60 [16:45:41.686] sendTuples = false [16:45:41.686] #13 0x00000000007088af in ExecutorRun (queryDesc=0x18702, queryDesc@entry=0x833cb3900, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:301 [16:45:41.686] No locals. [16:45:41.686] #14 0x00000000008d7e0f in ProcessQuery (plan=0x840704de8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82167e810) at ../src/backend/tcop/pquery.c:160 [16:45:41.686] queryDesc = 0x833cb3900 [16:45:41.686] #15 0x00000000008d73ad in PortalRunMulti (portal=portal@entry=0x833d3e100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x840708c60, altdest=altdest@entry=0x840708c60, qc=0x82167e810) at ../src/backend/tcop/pquery.c:1286 [16:45:41.686] pstmt = 0x840704de8 [16:45:41.686] stmtlist_item__state = {l = 0x840708c10, i = 0} [16:45:41.686] active_snapshot_set = true [16:45:41.686] stmtlist_item = 0x840708c28 [16:45:41.686] #16 0x00000000008d6c1b in PortalRun (portal=portal@entry=0x833d3e100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82b6fedaa , dest@entry=0x840708c60, altdest=0x0, altdest@entry=0x840708c60, qc=0x82167e810) at ../src/backend/tcop/pquery.c:791 [16:45:41.686] _local_sigjmp_buf = {{_sjb = {9268111, 35229576280, 34920195848, 34920196080, 34920195856, 11901592, 11869376, 35229262080, -6347183290299513985, 35229270272, 3553573, 34359738368}}} [16:45:41.686] _save_exception_stack = 0x82167e8e0 [16:45:41.686] _save_context_stack = 0x0 [16:45:41.686] _do_rethrow = false [16:45:41.686] saveTopTransactionResourceOwner = 0x833d8ac58 [16:45:41.686] saveTopTransactionContext = 0x833cb1000 [16:45:41.686] saveActivePortal = 0x0 [16:45:41.686] saveResourceOwner = 0x833d8ac58 [16:45:41.686] savePortalContext = 0x0 [16:45:41.686] saveMemoryContext = 0x833cb1000 [16:45:41.686] result = [16:45:41.686] nprocessed = [16:45:41.686] #17 0x00000000008d5afb in exec_simple_query (query_string=query_string@entry=0x833ca5100 "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:1273 [16:45:41.686] cmdtaglen = [16:45:41.686] snapshot_set = [16:45:41.686] per_parsetree_context = 0x0 [16:45:41.686] plantree_list = [16:45:41.686] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:45:41.686] parsetree = 0x833e6afc8 [16:45:41.686] commandTag = CMDTAG_MERGE [16:45:41.686] cmdtagname = [16:45:41.686] querytree_list = [16:45:41.686] portal = 0x833d3e100 [16:45:41.686] format = 0 [16:45:41.686] receiver = 0x840708c60 [16:45:41.686] parsetree_item__state = {l = 0x8406b1bb8, i = 0} [16:45:41.686] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [16:45:41.686] dest = DestRemote [16:45:41.686] was_logged = [16:45:41.686] oldcontext = 0x833cb1000 [16:45:41.686] parsetree_list = 0x8406b1bb8 [16:45:41.686] use_implicit_block = false [16:45:41.686] parsetree_item = 0x8406b1bd0 [16:45:41.686] save_log_statement_stats = [16:45:41.686] #18 0x00000000008d38e4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4668 [16:45:41.686] query_string = 0x833ca5100 "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"... [16:45:41.686] input_message = {data = 0x833ca5100 "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 = 241, maxlen = 1024, cursor = 241} [16:45:41.686] firstchar = [16:45:41.686] local_sigjmp_buf = {{_sjb = {9252272, 34920196320, 34920196280, 34920196880, 11910328, 11856816, 8192, 8388608, 72057628958065535, 0, 0, 34359738369}}} [16:45:41.686] send_ready_for_query = false [16:45:41.686] idle_in_transaction_timeout_enabled = false [16:45:41.686] idle_session_timeout_enabled = false [16:45:41.686] #19 0x000000000083264a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [16:45:41.686] No locals. [16:45:41.686] #20 0x00000000008308d0 in BackendStartup (client_sock=0x82167f538) at ../src/backend/postmaster/postmaster.c:4117 [16:45:41.686] bn = 0x833cb1498 [16:45:41.686] cac = CAC_OK [16:45:41.686] pid = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] __error = [16:45:41.686] save_errno = [16:45:41.686] __error = [16:45:41.686] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [16:45:41.686] 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 = "X, " \266\265\000\000\000\000\000\v\000\000\000\000\000\000\000\260\365g!\b\000\000\000\330\345\301*\b\000\000\000@\336\264\000\000\000\000\000\016f\302*\b", '\000' , "\360\365g!\b\000\000\000Ĺ\202\000\000\000\000"}, salen = 16}} [16:45:41.686] i = 0 [16:45:41.686] now = [16:45:41.686] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 727612516, events = 8, fd = 560458624, user_data = 0x82167ed10}, {pos = 575407112, events = 8, fd = 32, user_data = 0x82167ed00}, {pos = 98699924, events = 14276, fd = 575377416, user_data = 0x8224b9408}, {pos = 575379464, events = 8, fd = 575380488, user_data = 0x8224bd008}, {pos = 575394824, events = 8, fd = 575395848, user_data = 0x8224bdc08}, {pos = 575397896, events = 8, fd = 575398920, user_data = 0x8224be808}, {pos = 575400968, events = 8, fd = 575401992, user_data = 0x8224bf408}, {pos = 575404040, events = 8, fd = 575405064, user_data = 0x8224c0008}, {pos = 575407112, events = 8, fd = 575426696, user_data = 0x82167ee88}, {pos = 560458928, events = 8, fd = 98725283, user_data = 0x0}, {pos = 2565774, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 575430712, events = 8, fd = 1, user_data = 0x8224c0408}, {pos = 727520424, events = 8, fd = 560459656, user_data = 0x8224c0408}, {pos = 560458912, events = 0, fd = 727628132, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 575433272, user_data = 0x1}, {pos = 575407112, events = 8, fd = 727541976, user_data = 0x82167edc8}, {pos = 560458624, events = 8, fd = 32, user_data = 0x82b5e7c64}, {pos = 575407112, events = 8, fd = 575433272, user_data = 0x0}, {pos = 2625, events = 0, fd = 560459184, user_data = 0x37c405e20645}, {pos = 727628132, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 575433272, events = 8, fd = 1, user_data = 0x8224c0408}, {pos = 868831232, events = 8, fd = 1, user_data = 0x833c95194}, {pos = 0, events = 0, fd = 560459136, user_data = 0x82ac25c0c}, {pos = 1, events = 0, fd = 868831232, user_data = 0x82167edb0}, {pos = 717377204, events = 8, fd = 729354592, user_data = 0x82b791160 }, {pos = 727724224, events = 8, fd = 575407112, user_data = 0x82167ee90}, {pos = 98698284, events = 14276, fd = 575406088, user_data = 0x800000001}, {pos = 98697902, events = 14276, fd = 12240, user_data = 0x82167edb8}, {pos = 560459408, events = 8, fd = 869611496, user_data = 0x82167f400}, {pos = 98778768, events = 14276, fd = 575407112, user_data = 0x82167037f}, {pos = 729011378, events = 8, fd = 575377416, user_data = 0x0}, {pos = 575407112, events = 8, fd = 12240, user_data = 0x82b5c7000}, {pos = 1964368, events = 0, fd = 729354592, user_data = 0x82b5e7c64}, {pos = 15616, events = 0, fd = 560460592, user_data = 0x82167ef00}, {pos = 728285582, events = 8, fd = 729393208, user_data = 0x82167eec4}, {pos = 869283290, events = 8, fd = 560460592, user_data = 0x82167ef00}, {pos = 728376837, events = 8, fd = 560459458, user_data = 0x82167f330}, {pos = 560460592, events = 8, fd = 0, user_data = 0x7dea4759f0143c42}, {pos = 560460592, events = 8, fd = 869283288, user_data = 0x82167f400}, {pos = 729393208, events = 8, fd = 0, user_data = 0x82167f370}, {pos = 728377101, events = 8, fd = 0, user_data = 0x0}, {pos = 560460960, events = 8, fd = 869283288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 98726921, events = 14276, fd = 560459864, user_data = 0x82b5e7c64}, {pos = 2503, events = 0, fd = 98726921, user_data = 0x82167f078}, {pos = 727612516, events = 8, fd = 2758, user_data = 0x82b5e1120}, {pos = 560459768, events = 8, fd = 575407112, user_data = 0x82167f078}, {pos = 727585056, events = 8, fd = 560459872, user_data = 0x37c405e22465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b7b30f0}, {pos = 727545168, events = 8, fd = 0, user_data = 0x0}, {pos = 729422256, events = 8, fd = 16, user_data = 0x0}, {pos = 560460008, events = 8, fd = 575426696, user_data = 0x37c405e27409}, {pos = 560460072, events = 8, fd = 727612516, user_data = 0xb6c}, {pos = 727585720, events = 8, fd = 560459944, user_data = 0x8224c0408}, {pos = 560460072, events = 8, fd = 727585720, user_data = 0x82167f110}, {pos = 98706533, events = 14276, fd = 575430712, user_data = 0x800000001}, {pos = 575407112, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 560460456, user_data = 0x2725d8}, {pos = 560460560, events = 8, fd = 560460560, user_data = 0x82167f2c8}, {pos = 30, events = 0, fd = 727549152, user_data = 0x82167f1b8}, {pos = 575427144, events = 8, fd = 560460664, user_data = 0x82167f1a0}, {pos = 98725283, events = 14276, fd = 575430712, user_data = 0x2911eb}} [16:45:41.686] last_touch_time = 1710261632 [16:45:41.686] last_lockfile_recheck_time = 1710261632 [16:45:41.686] nevents = 1 [16:45:41.686] #22 0x000000000082dbc6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82167fb30) at ../src/backend/postmaster/postmaster.c:1478 [16:45:41.686] userDoption = [16:45:41.686] listen_addr_saved = false [16:45:41.686] output_config_variable = [16:45:41.686] opt = [16:45:41.686] status = [16:45:41.686] #23 0x000000000076b165 in main (argc=4, argv=0x82167fb30) at ../src/backend/main/main.c:197 [16:45:41.686] do_check_root = [16:45:41.700] [16:45:41.700] [16:45:41.700] [16:45:41.767] dumping /tmp/cores/postgres.13663.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:45:41.911] [New LWP 101638] [16:45:41.990] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [16:45:41.990] Program terminated with signal SIGABRT, Aborted. [16:45:41.990] Sent by thr_kill() from pid 13663 and user 1003. [16:45:41.990] #0 0x000000082aa49dca in thr_kill () from /lib/libc.so.7 [16:45:42.603] [16:45:42.603] Thread 1 (LWP 101638): [16:45:42.603] #0 0x000000082aa49dca in thr_kill () from /lib/libc.so.7 [16:45:42.603] No symbol table info available. [16:45:42.603] #1 0x000000082a9c26f4 in raise () from /lib/libc.so.7 [16:45:42.603] No symbol table info available. [16:45:42.603] #2 0x000000082aa73bc9 in abort () from /lib/libc.so.7 [16:45:42.603] No symbol table info available. [16:45:42.603] #3 0x0000000000a24f17 in ExceptionalCondition (conditionName=, fileName=0x36c85e "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [16:45:42.603] No locals. [16:45:42.603] #4 0x0000000000716380 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820e5cab8, materialize=, shouldFree=shouldFree@entry=0x820e5c996) at ../src/backend/executor/execTuples.c:1649 [16:45:42.603] No locals. [16:45:42.603] #5 0x00000000006de008 in ExecIRDeleteTriggers (estate=estate@entry=0x83cb91100, relinfo=relinfo@entry=0x83cb916b0, slot=slot@entry=0x820e5cab8) at ../src/backend/commands/trigger.c:2841 [16:45:42.603] trigger = [16:45:42.603] oldtuple = [16:45:42.603] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83ca20aa0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [16:45:42.603] trigdesc = 0x83cb918c0 [16:45:42.603] newtuple = 0x0 [16:45:42.603] i = 0 [16:45:42.603] should_free = false [16:45:42.603] #6 0x000000000073ba98 in ExecMergeMatched (context=0x820e5caf0, resultRelInfo=0x83cb916b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [16:45:42.603] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [16:45:42.603] commandType = CMD_DELETE [16:45:42.603] result = TM_Ok [16:45:42.603] relaction = [16:45:42.603] l__state = {l = 0x83cb67aa8, i = 0} [16:45:42.603] mtstate = 0x83cb914a0 [16:45:42.603] estate = 0x18d06 [16:45:42.603] econtext = 0x83cb672a8 [16:45:42.603] epqstate = 0x83cb91588 [16:45:42.603] l = [16:45:42.603] newslot = [16:45:42.603] isNull = [16:45:42.603] __error = [16:45:42.603] l__state = [16:45:42.603] updateCxt = [16:45:42.603] commandType = [16:45:42.603] result = [16:45:42.603] relaction = [16:45:42.603] __error = [16:45:42.603] resultRelationDesc = [16:45:42.603] lockmode = [16:45:42.603] inputslot = [16:45:42.603] epqslot = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] #7 ExecMerge (context=context@entry=0x820e5caf0, resultRelInfo=resultRelInfo@entry=0x83cb916b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820e5cab8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [16:45:42.603] matched = [16:45:42.603] #8 0x000000000073ae47 in ExecModifyTable (pstate=0x83cb914a0) at ../src/backend/executor/nodeModifyTable.c:3950 [16:45:42.603] context = {mtstate = 0x83cb914a0, epqstate = 0x83cb91588, estate = 0x83cb91100, planSlot = 0x83cb661e8, relaction = 0x83cb674e8, tmfd = {ctid = {ip_blkid = {bi_hi = 26334, bi_lo = 10916}, ip_posid = 8}, xmax = 177, cmax = 0, traversed = 240}, cpUpdateReturningSlot = 0x32adfe77386ebfa7} [16:45:42.603] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [16:45:42.603] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834f20118} [16:45:42.603] node = 0x83cb914a0 [16:45:42.603] estate = 0x83cb91100 [16:45:42.603] operation = CMD_MERGE [16:45:42.603] resultRelInfo = 0x6 [16:45:42.603] subplanstate = 0x83cb92df0 [16:45:42.603] slot = 0x83cb661e8 [16:45:42.603] tupleid = 0x0 [16:45:42.603] oldtuple = 0x820e5cab8 [16:45:42.603] oldSlot = [16:45:42.603] #9 0x00000000007105fb in ExecProcNodeFirst (node=0x83cb914a0) at ../src/backend/executor/execProcnode.c:464 [16:45:42.603] No locals. [16:45:42.603] #10 0x00000000007089ea in ExecProcNode (node=0x83cb914a0) at ../src/include/executor/executor.h:274 [16:45:42.603] No locals. [16:45:42.603] #11 ExecutePlan (estate=0x83cb91100, planstate=0x83cb914a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x83cb4fb48, execute_once=) at ../src/backend/executor/execMain.c:1638 [16:45:42.603] current_tuple_count = [16:45:42.603] slot = [16:45:42.603] #12 standard_ExecutorRun (queryDesc=0x834e56d00, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:357 [16:45:42.603] estate = 0x83cb91100 [16:45:42.603] oldcontext = 0x834e56c00 [16:45:42.603] operation = CMD_MERGE [16:45:42.603] dest = 0x83cb4fb48 [16:45:42.603] sendTuples = false [16:45:42.603] #13 0x0000000838548963 in pgss_ExecutorRun (queryDesc=0x834e56d00, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [16:45:42.603] _local_sigjmp_buf = {{_sjb = {35304802610, 11901592, 34911669272, 34911669440, 35247189248, 34911669280, 1, 1, 35378496383, 35247189248, 11910320, 34359738368}}} [16:45:42.603] _save_exception_stack = 0x820e5cda0 [16:45:42.603] _save_context_stack = 0x0 [16:45:42.603] _do_rethrow = false [16:45:42.603] #14 0x00000000007088a8 in ExecutorRun (queryDesc=0x18d06, queryDesc@entry=0x834e56d00, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:299 [16:45:42.603] No locals. [16:45:42.603] #15 0x00000000008d7e0f in ProcessQuery (plan=0x83cb4bcd0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820e5cea0) at ../src/backend/tcop/pquery.c:160 [16:45:42.603] queryDesc = 0x834e56d00 [16:45:42.603] #16 0x00000000008d73ad in PortalRunMulti (portal=portal@entry=0x834df5100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83cb4fb48, altdest=altdest@entry=0x83cb4fb48, qc=0x820e5cea0) at ../src/backend/tcop/pquery.c:1286 [16:45:42.603] pstmt = 0x83cb4bcd0 [16:45:42.603] stmtlist_item__state = {l = 0x83cb4faf8, i = 0} [16:45:42.603] active_snapshot_set = true [16:45:42.603] stmtlist_item = 0x83cb4fb10 [16:45:42.603] #17 0x00000000008d6c1b in PortalRun (portal=portal@entry=0x834df5100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82aa49daa , dest@entry=0x83cb4fb48, altdest=0x0, altdest@entry=0x83cb4fb48, qc=0x820e5cea0) at ../src/backend/tcop/pquery.c:791 [16:45:42.603] _local_sigjmp_buf = {{_sjb = {9268111, 35247098176, 34911669656, 34911669888, 34911669664, 11901592, 11869376, 35246788864, -6347183290308033665, 35246797056, 3553573, 34359738368}}} [16:45:42.603] _save_exception_stack = 0x820e5cf70 [16:45:42.603] _save_context_stack = 0x0 [16:45:42.603] _do_rethrow = false [16:45:42.603] saveTopTransactionResourceOwner = 0x834e40940 [16:45:42.603] saveTopTransactionContext = 0x834d66000 [16:45:42.603] saveActivePortal = 0x0 [16:45:42.603] saveResourceOwner = 0x834e40940 [16:45:42.603] savePortalContext = 0x0 [16:45:42.603] saveMemoryContext = 0x834d66000 [16:45:42.603] result = [16:45:42.603] nprocessed = [16:45:42.603] #18 0x00000000008d5afb in exec_simple_query (query_string=query_string@entry=0x834d5a100 "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:1273 [16:45:42.603] cmdtaglen = [16:45:42.603] snapshot_set = [16:45:42.603] per_parsetree_context = 0x0 [16:45:42.603] plantree_list = [16:45:42.603] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:45:42.603] parsetree = 0x834deafc8 [16:45:42.603] commandTag = CMDTAG_MERGE [16:45:42.603] cmdtagname = [16:45:42.603] querytree_list = [16:45:42.603] portal = 0x834df5100 [16:45:42.603] format = 0 [16:45:42.603] receiver = 0x83cb4fb48 [16:45:42.603] parsetree_item__state = {l = 0x83cb087f8, i = 0} [16:45:42.603] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [16:45:42.603] dest = DestRemote [16:45:42.603] was_logged = [16:45:42.603] oldcontext = 0x834d66000 [16:45:42.603] parsetree_list = 0x83cb087f8 [16:45:42.603] use_implicit_block = false [16:45:42.603] parsetree_item = 0x83cb08810 [16:45:42.603] save_log_statement_stats = [16:45:42.603] #19 0x00000000008d38e4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4668 [16:45:42.603] query_string = 0x834d5a100 "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"... [16:45:42.603] input_message = {data = 0x834d5a100 "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 = 241, maxlen = 1024, cursor = 241} [16:45:42.603] firstchar = [16:45:42.603] local_sigjmp_buf = {{_sjb = {9252272, 34911670128, 34911670088, 34911670688, 11910328, 11856816, 8192, 8388608, 72057628949545855, 0, 0, 1}}} [16:45:42.603] send_ready_for_query = false [16:45:42.603] idle_in_transaction_timeout_enabled = false [16:45:42.603] idle_session_timeout_enabled = false [16:45:42.603] #20 0x000000000083264a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [16:45:42.603] No locals. [16:45:42.603] #21 0x00000000008308d0 in BackendStartup (client_sock=0x820e5dbc8) at ../src/backend/postmaster/postmaster.c:4117 [16:45:42.603] bn = 0x834e38588 [16:45:42.603] cac = CAC_OK [16:45:42.603] pid = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] __error = [16:45:42.603] save_errno = [16:45:42.603] __error = [16:45:42.603] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [16:45:42.603] 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 = "X\354\256*\000\000\000\000\001\000\000\000\000\000\000\000@\336\264", '\000' , " \266\265\000\000\000\000\000\v\000\000\000\000\000\000\000@\334\345 \b\000\000\000ص\371)\b\000\000\000@\336\264\000\000\000\000\000\0166\372)\b", '\000' , "\200\334\345 \b\000\000\000Ĺ\202\000\000\000\000"}, salen = 16}} [16:45:42.603] i = 0 [16:45:42.603] now = [16:45:42.603] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 551932832, events = 8, fd = 555557896, user_data = 0x21}, {pos = 551932816, events = 8, fd = -1428333932, user_data = 0x8211cb008}, {pos = 555529224, events = 8, fd = 555530248, user_data = 0x8211cbc08}, {pos = 555544584, events = 8, fd = 555545608, user_data = 0x8211cf808}, {pos = 555547656, events = 8, fd = 555548680, user_data = 0x8211d0408}, {pos = 555550728, events = 8, fd = 555551752, user_data = 0x8211d1008}, {pos = 555553800, events = 8, fd = 555554824, user_data = 0x8211d1c08}, {pos = 555556872, events = 8, fd = 555557896, user_data = 0x8211d7088}, {pos = 551933208, events = 8, fd = 551932720, user_data = 0x2ad5aaddbda3}, {pos = 555557896, events = 8, fd = 2565774, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 555581496, user_data = 0x1}, {pos = 555557896, events = 8, fd = 714196136, user_data = 0x820e5d618}, {pos = 555557896, events = 8, fd = 551932688, user_data = 0x2725d8}, {pos = 551933280, events = 8, fd = 714303844, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 555584056, user_data = 0x2ad500000001}, {pos = 555557896, events = 8, fd = 714217688, user_data = 0x820e5d458}, {pos = 551932416, events = 8, fd = 33, user_data = 0x82a932c64}, {pos = 555557896, events = 8, fd = 555584056, user_data = 0x0}, {pos = 2625, events = 0, fd = 551932992, user_data = 0x2ad5aadd5645}, {pos = 714303844, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 555584056, events = 8, fd = 1, user_data = 0x8211d2408}, {pos = 886349824, events = 8, fd = 1, user_data = 0x834d4a194}, {pos = 0, events = 0, fd = 551932944, user_data = 0x829fa2c0c}, {pos = 1, events = 0, fd = 886349824, user_data = 0x820e5d440}, {pos = 704257716, events = 8, fd = 716030304, user_data = 0x82aadc160 }, {pos = 714399936, events = 8, fd = 555557896, user_data = 0x820e5d520}, {pos = -1428335572, events = 10965, fd = 80627796, user_data = 0x1}, {pos = -1428335954, events = 10965, fd = 12240, user_data = 0x820e5d448}, {pos = 551933216, events = 8, fd = 887146472, user_data = 0x820e5da90}, {pos = -1428255088, events = 10965, fd = 555557896, user_data = 0x820e5037f}, {pos = 715687090, events = 8, fd = 551933520, user_data = 0x2ad500000000}, {pos = 555557896, events = 8, fd = 12240, user_data = 0x82a912000}, {pos = 1964368, events = 0, fd = 716030304, user_data = 0x82a932c64}, {pos = 15616, events = 0, fd = 551934400, user_data = 0x820e5d590}, {pos = 714961294, events = 8, fd = 716068920, user_data = 0x820e5d554}, {pos = 886801882, events = 8, fd = 551934400, user_data = 0x820e5d590}, {pos = 715052549, events = 8, fd = 551933266, user_data = 0x820e5d9c0}, {pos = 551934400, events = 8, fd = 0, user_data = 0x32adfe77386ebfa7}, {pos = 551934400, events = 8, fd = 886801880, user_data = 0x820e5da90}, {pos = 716068920, events = 8, fd = 0, user_data = 0x820e5da00}, {pos = 715052813, events = 8, fd = 0, user_data = 0x0}, {pos = 551934768, events = 8, fd = 886801880, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1428306935, user_data = 0x820e5d6d8}, {pos = 714288228, events = 8, fd = 2503, user_data = 0x2ad5aaddc409}, {pos = 551933688, events = 8, fd = 714288228, user_data = 0xac6}, {pos = 714260768, events = 8, fd = 551933560, user_data = 0x8211d2408}, {pos = 551933688, events = 8, fd = 714260768, user_data = 0x820e5d6e0}, {pos = -1428327323, events = 10965, fd = 0, user_data = 0x800000000}, {pos = 551933648, events = 8, fd = 714220880, user_data = 0x0}, {pos = 0, events = 0, fd = 551933616, user_data = 0x10}, {pos = 0, events = 0, fd = 551933800, user_data = 0x8211d7088}, {pos = -1428306935, events = 10965, fd = 551933864, user_data = 0x82a932c64}, {pos = 2924, events = 0, fd = 714261432, user_data = 0x820e5d728}, {pos = 555557896, events = 8, fd = 551933864, user_data = 0x82a92c3b8}, {pos = 551933840, events = 8, fd = -1428327323, user_data = 0x8211d8038}, {pos = 1, events = 8, fd = 555557896, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x20e5d938}, {pos = 2565592, events = 0, fd = 551934368, user_data = 0x820e5d9a0}, {pos = 551934296, events = 8, fd = 31, user_data = 0x0}, {pos = 551934008, events = 8, fd = 555579272, user_data = 0x820e5da08}, {pos = 551933984, events = 8, fd = -1428308573, user_data = 0x8211d8038}, {pos = 2691563, events = 0, fd = 448139, user_data = 0x87c96e577}} [16:45:42.603] last_touch_time = 1710261695 [16:45:42.603] last_lockfile_recheck_time = 1710261695 [16:45:42.603] nevents = 1 [16:45:42.603] #23 0x000000000082dbc6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820e5e1c0) at ../src/backend/postmaster/postmaster.c:1478 [16:45:42.603] userDoption = [16:45:42.603] listen_addr_saved = false [16:45:42.603] output_config_variable = [16:45:42.603] opt = [16:45:42.603] status = [16:45:42.603] #24 0x000000000076b165 in main (argc=4, argv=0x820e5e1c0) at ../src/backend/main/main.c:197 [16:45:42.603] do_check_root =