[00:44:38.595] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [00:44:38.923] dumping /tmp/cores/postgres.9045.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:44:39.052] [New LWP 101861] [00:44:39.135] Core was generated by `postgres: postgres regression [local] MERGE'. [00:44:39.135] Program terminated with signal SIGABRT, Aborted. [00:44:39.135] Sent by thr_kill() from pid 9045 and user 1003. [00:44:39.135] #0 0x000000082c6bb41a in thr_kill () from /lib/libc.so.7 [00:44:39.710] [00:44:39.710] Thread 1 (LWP 101861): [00:44:39.710] #0 0x000000082c6bb41a in thr_kill () from /lib/libc.so.7 [00:44:39.710] No symbol table info available. [00:44:39.710] #1 0x000000082c634e64 in raise () from /lib/libc.so.7 [00:44:39.710] No symbol table info available. [00:44:39.710] #2 0x000000082c6e56f9 in abort () from /lib/libc.so.7 [00:44:39.710] No symbol table info available. [00:44:39.710] #3 0x0000000000a5bae5 in ExceptionalCondition (conditionName=0x2d0a60 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [00:44:39.710] No locals. [00:44:39.710] #4 0x000000000073e89f in ExecFetchSlotHeapTuple (slot=0x820ca8ad0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [00:44:39.710] No locals. [00:44:39.710] #5 0x0000000000703cf7 in ExecIRDeleteTriggers (estate=estate@entry=0x844a51100, relinfo=relinfo@entry=0x844a516b0, slot=slot@entry=0x820ca8ad0) at ../src/backend/commands/trigger.c:2841 [00:44:39.710] trigger = [00:44:39.710] oldtuple = [00:44:39.710] should_free = false [00:44:39.710] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x844a905d0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [00:44:39.710] trigdesc = 0x844a518c0 [00:44:39.710] newtuple = 0x0 [00:44:39.710] i = 0 [00:44:39.710] #6 0x0000000000763ac7 in ExecMergeMatched (context=0x820ca8b78, resultRelInfo=0x844a516b0, tupleid=0x0, oldtuple=0x820ca8ad0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3040 [00:44:39.710] result = TM_Ok [00:44:39.710] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [00:44:39.710] relaction = 0x844ad17e0 [00:44:39.710] commandType = CMD_DELETE [00:44:39.710] l__state = {l = 0x844ba09c8, i = 0} [00:44:39.710] mtstate = 0x844a514a0 [00:44:39.710] newslot = 0x0 [00:44:39.710] rslot = 0x0 [00:44:39.710] estate = 0x844a51100 [00:44:39.710] mergeActions = [00:44:39.710] econtext = 0x844b9fa68 [00:44:39.710] epqstate = 0x844a51588 [00:44:39.710] actionStates = 0x844ba09c8 [00:44:39.710] l = [00:44:39.710] isNull = [00:44:39.710] lmerge_matched = [00:44:39.710] __error = [00:44:39.710] l__state = [00:44:39.710] result = [00:44:39.710] updateCxt = [00:44:39.710] relaction = [00:44:39.710] commandType = [00:44:39.710] __error = [00:44:39.710] resultRelationDesc = [00:44:39.710] lockmode = [00:44:39.710] inputslot = [00:44:39.710] epqslot = [00:44:39.710] was_matched = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] #7 ExecMerge (context=0x820ca8b78, resultRelInfo=0x844a516b0, tupleid=0x0, oldtuple=0x820ca8ad0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2801 [00:44:39.710] matched = [00:44:39.710] rslot = 0x0 [00:44:39.710] #8 ExecModifyTable (pstate=0x844a514a0) at ../src/backend/executor/nodeModifyTable.c:4130 [00:44:39.710] context = {mtstate = 0x844a514a0, epqstate = 0x844a51588, estate = 0x844a51100, planSlot = 0x844ad1750, tmfd = {ctid = {ip_blkid = {bi_hi = 57272, bi_lo = 17596}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x844a516b0} [00:44:39.710] tuple_ctid = {ip_blkid = {bi_hi = 44432, bi_lo = 18751}, ip_posid = 8} [00:44:39.710] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x844aa6118} [00:44:39.710] node = 0x844a514a0 [00:44:39.710] estate = 0x844a51100 [00:44:39.710] operation = CMD_MERGE [00:44:39.710] resultRelInfo = 0x844a516b0 [00:44:39.710] subplanstate = 0x844a52df0 [00:44:39.710] slot = [00:44:39.710] tupleid = 0x0 [00:44:39.710] oldtuple = 0x820ca8ad0 [00:44:39.710] oldSlot = [00:44:39.710] #9 0x0000000000730cab in ExecProcNode (node=0x844a514a0) at ../src/include/executor/executor.h:274 [00:44:39.710] No locals. [00:44:39.710] #10 ExecutePlan (estate=0x844a51100, planstate=0x844a514a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x837aa7710, execute_once=) at ../src/backend/executor/execMain.c:1646 [00:44:39.710] current_tuple_count = 0 [00:44:39.710] slot = [00:44:39.710] #11 standard_ExecutorRun (queryDesc=0x837959c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:363 [00:44:39.710] estate = 0x844a51100 [00:44:39.710] oldcontext = 0x837aa7400 [00:44:39.710] operation = CMD_MERGE [00:44:39.710] dest = 0x837aa7710 [00:44:39.710] sendTuples = true [00:44:39.710] #12 0x000000000090707f in ProcessQuery (plan=0x844bcd8a0, sourceText=, params=0x0, queryEnv=0x0, dest=0x837aa7710, qc=0x820ca8d78) at ../src/backend/tcop/pquery.c:160 [00:44:39.710] queryDesc = 0x837959c48 [00:44:39.710] #13 0x000000000090661d in PortalRunMulti (portal=portal@entry=0x8379d8100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x837aa7710, altdest=0xb4cbe0 , qc=qc@entry=0x820ca8d78) at ../src/backend/tcop/pquery.c:1287 [00:44:39.710] pstmt = 0x844bcd8a0 [00:44:39.710] stmtlist_item__state = {l = 0x844bd2158, i = 0} [00:44:39.710] active_snapshot_set = true [00:44:39.710] stmtlist_item = 0x844bd2170 [00:44:39.710] #14 0x000000000090612c in FillPortalStore (portal=portal@entry=0x8379d8100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [00:44:39.710] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:44:39.710] treceiver = 0x837aa7710 [00:44:39.710] #15 0x0000000000905e9b in PortalRun (portal=portal@entry=0x8379d8100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x844bd21a8, altdest=altdest@entry=0x844bd21a8, qc=0x820ca8eb0) at ../src/backend/tcop/pquery.c:763 [00:44:39.710] _local_sigjmp_buf = {{_sjb = {9461309, 35292807424, 34909883816, 34909884048, 34909883824, 35292827648, 12114472, 12147736, 35292775295, 35291934976, 4294967984, 0}}} [00:44:39.710] _save_exception_stack = 0x820ca8f80 [00:44:39.710] _save_context_stack = 0x0 [00:44:39.710] _do_rethrow = false [00:44:39.710] saveTopTransactionResourceOwner = 0x8379ead58 [00:44:39.710] saveTopTransactionContext = 0x8379dd000 [00:44:39.710] saveActivePortal = 0x0 [00:44:39.710] saveResourceOwner = 0x8379ead58 [00:44:39.710] savePortalContext = 0x0 [00:44:39.710] saveMemoryContext = 0x8379dd000 [00:44:39.710] result = [00:44:39.710] nprocessed = [00:44:39.710] #16 0x0000000000904d62 in exec_simple_query (query_string=query_string@entry=0x837903100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [00:44:39.710] cmdtaglen = 5 [00:44:39.710] snapshot_set = [00:44:39.710] per_parsetree_context = 0x0 [00:44:39.710] plantree_list = [00:44:39.710] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:44:39.710] format = 0 [00:44:39.710] parsetree = 0x844b6dd68 [00:44:39.710] commandTag = [00:44:39.710] cmdtagname = [00:44:39.710] querytree_list = [00:44:39.710] portal = 0x8379d8100 [00:44:39.710] receiver = 0x844bd21a8 [00:44:39.710] parsetree_item__state = {l = 0x844b6f630, i = 0} [00:44:39.710] msec_str = "\000\000\000\000\b", '\000' , "\347B\301f\000\000\000\000ͱ\257\f\0307g\v" [00:44:39.710] dest = DestRemote [00:44:39.710] was_logged = [00:44:39.710] oldcontext = 0x8379dd000 [00:44:39.710] parsetree_list = 0x844b6f630 [00:44:39.710] use_implicit_block = false [00:44:39.710] parsetree_item = 0x844b6f648 [00:44:39.710] save_log_statement_stats = [00:44:39.710] #17 0x0000000000902ad0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [00:44:39.710] query_string = 0x837903100 "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"... [00:44:39.710] input_message = {data = 0x837903100 "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} [00:44:39.710] firstchar = [00:44:39.710] local_sigjmp_buf = {{_sjb = {9445222, 34909884288, 34909884248, 34909884832, 12156472, 1, 8192, 8388608, 34909848447, 0, 0, 1}}} [00:44:39.710] send_ready_for_query = false [00:44:39.710] idle_in_transaction_timeout_enabled = false [00:44:39.710] idle_session_timeout_enabled = false [00:44:39.710] #18 0x00000000008fd2a9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:44:39.710] bsdata = [00:44:39.710] #19 0x0000000000857fd7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820ca9cc4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820ca9c08) at ../src/backend/postmaster/launch_backend.c:274 [00:44:39.710] pid = [00:44:39.710] #20 0x000000000085c398 in BackendStartup (client_sock=0x820ca9c08) at ../src/backend/postmaster/postmaster.c:3414 [00:44:39.710] startup_data = {canAcceptConnections = CAC_OK} [00:44:39.710] bn = 0x83790f498 [00:44:39.710] pid = [00:44:39.710] __error = [00:44:39.710] save_errno = [00:44:39.710] __error = [00:44:39.710] __error = [00:44:39.710] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [00:44:39.710] 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 = "\v\000\000\000\000\000\000\000\000O\2207\b", '\000' , "p\234\312 \b\000\000\000he\370+\b\000\000\000\v\000\000\000\000\000\000\000^\357\370+\b", '\000' , "\260\234\312 \b\000\000\000\204}\205\000\000\000\000\000\300\234\312 \b\000\000\000\000\000\000\000\000\000\000"}, salen = 16}} [00:44:39.710] i = 0 [00:44:39.710] now = [00:44:39.710] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1139354227, events = 15569, fd = 550146656, user_data = 0x82c5a9ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821451a38}, {pos = 1, events = 8, fd = 558150664, user_data = 0x82c58a168}, {pos = 550147304, events = 8, fd = 550147120, user_data = 0x820ca92a0}, {pos = 1, events = 0, fd = 558150664, user_data = 0x20}, {pos = 550147104, events = 8, fd = 1139329562, user_data = 0x821444008}, {pos = 558121992, events = 8, fd = 558123016, user_data = 0x821444c08}, {pos = 558137352, events = 8, fd = 558138376, user_data = 0x821448808}, {pos = 558140424, events = 8, fd = 558141448, user_data = 0x821449408}, {pos = 558143496, events = 8, fd = 558144520, user_data = 0x82144a008}, {pos = 558146568, events = 8, fd = 558147592, user_data = 0x82144ac08}, {pos = 558149640, events = 8, fd = 558150664, user_data = 0x0}, {pos = 746032032, events = 8, fd = 746033320, user_data = 0x836800980}, {pos = 550147104, events = 8, fd = 745556604, user_data = 0x1000}, {pos = 745576198, events = 8, fd = 914398176, user_data = 0xa0}, {pos = 550147104, events = 8, fd = 745555870, user_data = 0x820ca9410}, {pos = 0, events = 0, fd = 558150664, user_data = 0x82c5a9ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821451a38}, {pos = 1, events = 8, fd = 558150664, user_data = 0x82c58a168}, {pos = 550147304, events = 8, fd = 550146720, user_data = 0x1200000020}, {pos = 0, events = 0, fd = 558176824, user_data = 0x1}, {pos = 558150664, events = 8, fd = 839, user_data = 0x820ca94d0}, {pos = 1139328495, events = 15569, fd = 744135363, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 558176824, user_data = 0x1}, {pos = 558150664, events = 8, fd = 932130816, user_data = 0x1}, {pos = 932131220, events = 8, fd = 0, user_data = 0x820ca94a0}, {pos = 737731948, events = 8, fd = 1, user_data = 0x8378f3000}, {pos = 550147280, events = 8, fd = 737728258, user_data = 0x82c74a950 }, {pos = 745931128, events = 8, fd = 745843024, user_data = 0x82144b408}, {pos = 550147504, events = 8, fd = 1139327966, user_data = 0x834df1090}, {pos = 1, events = 0, fd = 1139327582, user_data = 0x82144b408}, {pos = 550147288, events = 8, fd = 550147504, user_data = 0x2fe8}, {pos = 0, events = 0, fd = 1139407248, user_data = 0x820ca9b20}, {pos = 115213183, events = 0, fd = -25761258, user_data = 0xb04e149c30e29cf7}, {pos = 0, events = 8, fd = 558150664, user_data = 0x2fe8}, {pos = 743985152, events = 8, fd = 1945976, user_data = 0x82c74a950 }, {pos = 744119672, events = 8, fd = 15691, user_data = 0x82c76e6a0 <__stack_chk_guard>}, {pos = 550147616, events = 8, fd = 744790293, user_data = 0x82c753e38}, {pos = 550147552, events = 8, fd = 550148688, user_data = 0x0}, {pos = 550147616, events = 8, fd = 744880993, user_data = 0x1}, {pos = 550148688, events = 8, fd = 550148688, user_data = 0x100000000000000}, {pos = 820157687, events = 2957907100, fd = 745989792, user_data = 0x8379645d8}, {pos = 0, events = 0, fd = 745881144, user_data = 0x820ca9b20}, {pos = 550148752, events = 8, fd = 744881282, user_data = 0x0}, {pos = 550149056, events = 8, fd = 932595160, user_data = 0x820ca9a50}, {pos = 0, events = 0, fd = 0, user_data = 0xb04e149c30e29cf7}, {pos = 1139356426, events = 15569, fd = 744048544, user_data = 0x82c5a5d78}, {pos = 550147800, events = 8, fd = 550147920, user_data = 0x820ca96d8}, {pos = 1139356426, events = 15569, fd = 744027016, user_data = 0x82c5a5d78}, {pos = 550147848, events = 8, fd = 550147968, user_data = 0x820ca9708}, {pos = 744087956, events = 8, fd = 558150664, user_data = 0x82c59e194}, {pos = 550147952, events = 8, fd = 1139336250, user_data = 0x82c75b030 <__thr_jtable>}, {pos = 1, events = 0, fd = 550148000, user_data = 0x3cd143e9330a}, {pos = 743995480, events = 8, fd = 744119672, user_data = 0x820ca9778}, {pos = 550148080, events = 8, fd = 550147960, user_data = 0x82c59cd0c}, {pos = 558150664, events = 8, fd = 744082700, user_data = 0x820ca97e0}, {pos = 1139336250, events = 15569, fd = 550148104, user_data = 0x820ca99c8}, {pos = 550148080, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821451038}, {pos = 1, events = 8, fd = 558150664, user_data = 0x82c58f388}, {pos = 558170760, events = 8, fd = 743995480, user_data = 0x82144b408}, {pos = 550148216, events = 8, fd = 550148664, user_data = 0x820ca9860}, {pos = 1139354786, events = 15569, fd = 2699682, user_data = 0x6d68b}} [00:44:39.711] last_touch_time = 1723941597 [00:44:39.711] last_lockfile_recheck_time = 1723941597 [00:44:39.711] nevents = 1 [00:44:39.711] #22 0x000000000085a1b5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820caa220) at ../src/backend/postmaster/postmaster.c:1346 [00:44:39.711] userDoption = [00:44:39.711] listen_addr_saved = [00:44:39.711] output_config_variable = [00:44:39.711] opt = [00:44:39.711] status = [00:44:39.711] #23 0x0000000000793afc in main (argc=8, argv=0x820caa220) at ../src/backend/main/main.c:197 [00:44:39.711] do_check_root = [00:44:39.723] [00:44:39.723] [00:44:39.723] [00:44:39.790] dumping /tmp/cores/postgres.9315.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:44:39.912] [New LWP 101838] [00:44:39.980] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [00:44:39.980] Program terminated with signal SIGABRT, Aborted. [00:44:39.980] Sent by thr_kill() from pid 9315 and user 1003. [00:44:39.980] #0 0x000000082b11941a in thr_kill () from /lib/libc.so.7 [00:44:40.572] [00:44:40.572] Thread 1 (LWP 101838): [00:44:40.572] #0 0x000000082b11941a in thr_kill () from /lib/libc.so.7 [00:44:40.572] No symbol table info available. [00:44:40.572] #1 0x000000082b092e64 in raise () from /lib/libc.so.7 [00:44:40.572] No symbol table info available. [00:44:40.572] #2 0x000000082b1436f9 in abort () from /lib/libc.so.7 [00:44:40.572] No symbol table info available. [00:44:40.572] #3 0x0000000000a5bae5 in ExceptionalCondition (conditionName=0x2d0a60 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [00:44:40.572] No locals. [00:44:40.572] #4 0x000000000073e89f in ExecFetchSlotHeapTuple (slot=0x820e846f0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [00:44:40.572] No locals. [00:44:40.572] #5 0x0000000000703cf7 in ExecIRDeleteTriggers (estate=estate@entry=0x834f3e100, relinfo=relinfo@entry=0x834f3e6b0, slot=slot@entry=0x820e846f0) at ../src/backend/commands/trigger.c:2841 [00:44:40.572] trigger = [00:44:40.572] oldtuple = [00:44:40.572] should_free = false [00:44:40.572] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x843e4d768, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [00:44:40.572] trigdesc = 0x834f3e8c0 [00:44:40.572] newtuple = 0x0 [00:44:40.572] i = 0 [00:44:40.572] #6 0x0000000000763ac7 in ExecMergeMatched (context=0x820e84798, resultRelInfo=0x834f3e6b0, tupleid=0x0, oldtuple=0x820e846f0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3040 [00:44:40.572] result = TM_Ok [00:44:40.572] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [00:44:40.572] relaction = 0x841508320 [00:44:40.572] commandType = CMD_DELETE [00:44:40.572] l__state = {l = 0x84157c488, i = 0} [00:44:40.572] mtstate = 0x834f3e4a0 [00:44:40.572] newslot = 0x0 [00:44:40.572] rslot = 0x0 [00:44:40.572] estate = 0x834f3e100 [00:44:40.572] mergeActions = [00:44:40.572] econtext = 0x84157b528 [00:44:40.572] epqstate = 0x834f3e588 [00:44:40.572] actionStates = 0x84157c488 [00:44:40.572] l = [00:44:40.572] isNull = [00:44:40.572] lmerge_matched = [00:44:40.572] __error = [00:44:40.572] l__state = [00:44:40.572] result = [00:44:40.572] updateCxt = [00:44:40.572] relaction = [00:44:40.572] commandType = [00:44:40.572] __error = [00:44:40.572] resultRelationDesc = [00:44:40.572] lockmode = [00:44:40.572] inputslot = [00:44:40.572] epqslot = [00:44:40.572] was_matched = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] #7 ExecMerge (context=0x820e84798, resultRelInfo=0x834f3e6b0, tupleid=0x0, oldtuple=0x820e846f0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2801 [00:44:40.572] matched = [00:44:40.572] rslot = 0x0 [00:44:40.572] #8 ExecModifyTable (pstate=0x834f3e4a0) at ../src/backend/executor/nodeModifyTable.c:4130 [00:44:40.572] context = {mtstate = 0x834f3e4a0, epqstate = 0x834f3e588, estate = 0x834f3e100, planSlot = 0x841508290, tmfd = {ctid = {ip_blkid = {bi_hi = 35448, bi_lo = 16730}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x834f3e6b0} [00:44:40.572] tuple_ctid = {ip_blkid = {bi_hi = 59440, bi_lo = 17381}, ip_posid = 8} [00:44:40.572] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834f52118} [00:44:40.572] node = 0x834f3e4a0 [00:44:40.572] estate = 0x834f3e100 [00:44:40.572] operation = CMD_MERGE [00:44:40.572] resultRelInfo = 0x834f3e6b0 [00:44:40.572] subplanstate = 0x834f3fdf0 [00:44:40.572] slot = [00:44:40.572] tupleid = 0x0 [00:44:40.572] oldtuple = 0x820e846f0 [00:44:40.572] oldSlot = [00:44:40.572] #9 0x0000000000730cab in ExecProcNode (node=0x834f3e4a0) at ../src/include/executor/executor.h:274 [00:44:40.572] No locals. [00:44:40.572] #10 ExecutePlan (estate=0x834f3e100, planstate=0x834f3e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x834f3b710, execute_once=) at ../src/backend/executor/execMain.c:1646 [00:44:40.572] current_tuple_count = 0 [00:44:40.572] slot = [00:44:40.572] #11 standard_ExecutorRun (queryDesc=0x834df6448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:363 [00:44:40.572] estate = 0x834f3e100 [00:44:40.572] oldcontext = 0x834f3b400 [00:44:40.572] operation = CMD_MERGE [00:44:40.572] dest = 0x834f3b710 [00:44:40.572] sendTuples = true [00:44:40.572] #12 0x000000000090707f in ProcessQuery (plan=0x8415a8360, sourceText=, params=0x0, queryEnv=0x0, dest=0x834f3b710, qc=0x820e84998) at ../src/backend/tcop/pquery.c:160 [00:44:40.572] queryDesc = 0x834df6448 [00:44:40.572] #13 0x000000000090661d in PortalRunMulti (portal=portal@entry=0x834e3d100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x834f3b710, altdest=0xb4cbe0 , qc=qc@entry=0x820e84998) at ../src/backend/tcop/pquery.c:1287 [00:44:40.572] pstmt = 0x8415a8360 [00:44:40.572] stmtlist_item__state = {l = 0x8415acc18, i = 0} [00:44:40.572] active_snapshot_set = true [00:44:40.572] stmtlist_item = 0x8415acc30 [00:44:40.572] #14 0x000000000090612c in FillPortalStore (portal=portal@entry=0x834e3d100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [00:44:40.572] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:44:40.572] treceiver = 0x834f3b710 [00:44:40.572] #15 0x0000000000905e9b in PortalRun (portal=portal@entry=0x834e3d100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8415acc68, altdest=altdest@entry=0x8415acc68, qc=0x820e84ad0) at ../src/backend/tcop/pquery.c:763 [00:44:40.572] _local_sigjmp_buf = {{_sjb = {9461309, 35247083776, 34911832520, 34911832752, 34911832528, 35247099904, 12114472, 12147736, 35247031167, 35246412032, 4294967984, 0}}} [00:44:40.572] _save_exception_stack = 0x820e84ba0 [00:44:40.572] _save_context_stack = 0x0 [00:44:40.572] _do_rethrow = false [00:44:40.572] saveTopTransactionResourceOwner = 0x834e8c0d8 [00:44:40.572] saveTopTransactionContext = 0x834e41000 [00:44:40.572] saveActivePortal = 0x0 [00:44:40.572] saveResourceOwner = 0x834e8c0d8 [00:44:40.572] savePortalContext = 0x0 [00:44:40.572] saveMemoryContext = 0x834e41000 [00:44:40.572] result = [00:44:40.572] nprocessed = [00:44:40.572] #16 0x0000000000904d62 in exec_simple_query (query_string=query_string@entry=0x834d99100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [00:44:40.572] cmdtaglen = 5 [00:44:40.572] snapshot_set = [00:44:40.572] per_parsetree_context = 0x0 [00:44:40.572] plantree_list = [00:44:40.572] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:44:40.572] format = 0 [00:44:40.572] parsetree = 0x841549368 [00:44:40.572] commandTag = [00:44:40.572] cmdtagname = [00:44:40.572] querytree_list = [00:44:40.572] portal = 0x834e3d100 [00:44:40.572] receiver = 0x8415acc68 [00:44:40.572] parsetree_item__state = {l = 0x84154ac30, i = 0} [00:44:40.572] msec_str = "\000\000\000\000\b", '\000' , "\350B\301f\000\000\000\000\3556-0\224\r\247", [00:44:40.572] dest = DestRemote [00:44:40.572] was_logged = [00:44:40.572] oldcontext = 0x834e41000 [00:44:40.572] parsetree_list = 0x84154ac30 [00:44:40.572] use_implicit_block = false [00:44:40.572] parsetree_item = 0x84154ac48 [00:44:40.572] save_log_statement_stats = [00:44:40.572] #17 0x0000000000902ad0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [00:44:40.572] query_string = 0x834d99100 "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"... [00:44:40.572] input_message = {data = 0x834d99100 "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} [00:44:40.572] firstchar = [00:44:40.572] local_sigjmp_buf = {{_sjb = {9445222, 34911832992, 34911832952, 34911833536, 12156472, 1, 8192, 8388608, 34911814527, 0, 0, 1}}} [00:44:40.572] send_ready_for_query = false [00:44:40.572] idle_in_transaction_timeout_enabled = false [00:44:40.572] idle_session_timeout_enabled = false [00:44:40.572] #18 0x00000000008fd2a9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:44:40.572] bsdata = [00:44:40.572] #19 0x0000000000857fd7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820e858e4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e85828) at ../src/backend/postmaster/launch_backend.c:274 [00:44:40.572] pid = [00:44:40.572] #20 0x000000000085c398 in BackendStartup (client_sock=0x820e85828) at ../src/backend/postmaster/postmaster.c:3414 [00:44:40.572] startup_data = {canAcceptConnections = CAC_OK} [00:44:40.572] bn = 0x834da6fb8 [00:44:40.572] pid = [00:44:40.572] __error = [00:44:40.572] save_errno = [00:44:40.572] __error = [00:44:40.572] __error = [00:44:40.572] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [00:44:40.572] 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 = "\v\000\000\000\000\000\000\000\300\256\3314\b", '\000' , "\220X\350 \b\000\000\000hu\372*\b\000\000\000\v\000\000\000\000\000\000\000^\377\372*\b", '\000' , "\320X\350 \b\000\000\000\204}\205\000\000\000\000\000\340X\350 \b\000\000\000\000\000\000\000\000\000\000"}, salen = 16}} [00:44:40.572] i = 0 [00:44:40.572] now = [00:44:40.572] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 1173432947, events = 15028, fd = 552095360, user_data = 0x82b007ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821cd2a38}, {pos = 1, events = 8, fd = 567067656, user_data = 0x82afe8168}, {pos = 552096008, events = 8, fd = 552095824, user_data = 0x820e84ec0}, {pos = 1, events = 0, fd = 567067656, user_data = 0x20}, {pos = 552095808, events = 8, fd = 1173408282, user_data = 0x821cc5008}, {pos = 567038984, events = 8, fd = 567040008, user_data = 0x821cc5c08}, {pos = 567054344, events = 8, fd = 567055368, user_data = 0x821cc9808}, {pos = 567057416, events = 8, fd = 567058440, user_data = 0x821cca408}, {pos = 567060488, events = 8, fd = 567061512, user_data = 0x821ccb008}, {pos = 567063560, events = 8, fd = 567064584, user_data = 0x821ccbc08}, {pos = 567066632, events = 8, fd = 567067656, user_data = 0x8fe76ea16}, {pos = 567091256, events = 8, fd = 1, user_data = 0x821ccc408}, {pos = 721343608, events = 8, fd = 552096392, user_data = 0x2afc49}, {pos = 552096208, events = 8, fd = 552095808, user_data = 0x1}, {pos = 552096136, events = 8, fd = 32, user_data = 0x820e85030}, {pos = 1173432947, events = 15028, fd = 567067656, user_data = 0x82b007ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821cd2a38}, {pos = 1, events = 0, fd = 567067656, user_data = 0x82afe8168}, {pos = 552096008, events = 8, fd = 552095424, user_data = 0x1200000020}, {pos = 0, events = 0, fd = 567093816, user_data = 0x1}, {pos = 567067656, events = 8, fd = 839, user_data = 0x820e850f0}, {pos = 1173407215, events = 15028, fd = 721451715, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 567093816, user_data = 0x1}, {pos = 567067656, events = 8, fd = 886607872, user_data = 0x1}, {pos = 886608276, events = 8, fd = 0, user_data = 0x820e850c0}, {pos = 721089900, events = 8, fd = 1, user_data = 0x834d89000}, {pos = 552095984, events = 8, fd = 721086210, user_data = 0x82b1a8950 }, {pos = 723247480, events = 8, fd = 723159376, user_data = 0x821ccc408}, {pos = 552096208, events = 8, fd = 1173406686, user_data = 0x821cca008}, {pos = 1, events = 8, fd = 1173406302, user_data = 0x821ccc408}, {pos = 552095992, events = 8, fd = 552096208, user_data = 0x2fe8}, {pos = 0, events = 0, fd = 1173485968, user_data = 0x820e85740}, {pos = 115213183, events = 0, fd = -25761258, user_data = 0xb99444ebbcb329d7}, {pos = 0, events = 8, fd = 567067656, user_data = 0x2fe8}, {pos = 721301504, events = 8, fd = 1945976, user_data = 0x82b1a8950 }, {pos = 721436024, events = 8, fd = 15691, user_data = 0x82b1cc6a0 <__stack_chk_guard>}, {pos = 552096320, events = 8, fd = 722106645, user_data = 0x82b1b1e38}, {pos = 552096256, events = 8, fd = 552097392, user_data = 0x0}, {pos = 552096320, events = 8, fd = 722197345, user_data = 0x1}, {pos = 552097392, events = 8, fd = 552097392, user_data = 0x100000000000000}, {pos = -1129109033, events = 3113501931, fd = 723306144, user_data = 0x834e015d8}, {pos = 0, events = 0, fd = 723197496, user_data = 0x820e85740}, {pos = 552097456, events = 8, fd = 722197634, user_data = 0x0}, {pos = 552097760, events = 8, fd = 887100888, user_data = 0x820e85670}, {pos = 0, events = 0, fd = 0, user_data = 0xb99444ebbcb329d7}, {pos = 1173435146, events = 15028, fd = 721364896, user_data = 0x82b003d78}, {pos = 552096504, events = 8, fd = 552096624, user_data = 0x820e852f8}, {pos = 1173435146, events = 15028, fd = 721343368, user_data = 0x82b003d78}, {pos = 552096552, events = 8, fd = 552096672, user_data = 0x820e85328}, {pos = 721404308, events = 8, fd = 567067656, user_data = 0x82affc194}, {pos = 552096656, events = 8, fd = 1173414970, user_data = 0x82b1b9030 <__thr_jtable>}, {pos = 1, events = 0, fd = 552096704, user_data = 0x3ab445f1330a}, {pos = 721311832, events = 8, fd = 721436024, user_data = 0x820e85398}, {pos = 552096784, events = 8, fd = 552096664, user_data = 0x82affad0c}, {pos = 567067656, events = 8, fd = 721399052, user_data = 0x820e85400}, {pos = 1173414970, events = 15028, fd = 552096808, user_data = 0x820e855e8}, {pos = 552096784, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821cd2038}, {pos = 1, events = 8, fd = 567067656, user_data = 0x82afed388}, {pos = 567087752, events = 8, fd = 721311832, user_data = 0x821ccc408}, {pos = 552096920, events = 8, fd = 552097368, user_data = 0x820e85480}, {pos = 1173433506, events = 15028, fd = 2699682, user_data = 0x6d68b}} [00:44:40.572] last_touch_time = 1723941597 [00:44:40.572] last_lockfile_recheck_time = 1723941597 [00:44:40.572] nevents = 1 [00:44:40.572] #22 0x000000000085a1b5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820e85e48) at ../src/backend/postmaster/postmaster.c:1346 [00:44:40.572] userDoption = [00:44:40.572] listen_addr_saved = [00:44:40.572] output_config_variable = [00:44:40.572] opt = [00:44:40.572] status = [00:44:40.572] #23 0x0000000000793afc in main (argc=4, argv=0x820e85e48) at ../src/backend/main/main.c:197 [00:44:40.572] do_check_root = [00:44:40.584] [00:44:40.584] [00:44:40.584] [00:44:40.649] dumping /tmp/cores/postgres.15608.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:44:40.772] [New LWP 101866] [00:44:40.839] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [00:44:40.839] Program terminated with signal SIGABRT, Aborted. [00:44:40.839] Sent by thr_kill() from pid 15608 and user 1003. [00:44:40.839] #0 0x000000082b9f041a in thr_kill () from /lib/libc.so.7 [00:44:41.423] [00:44:41.423] Thread 1 (LWP 101866): [00:44:41.423] #0 0x000000082b9f041a in thr_kill () from /lib/libc.so.7 [00:44:41.423] No symbol table info available. [00:44:41.423] #1 0x000000082b969e64 in raise () from /lib/libc.so.7 [00:44:41.423] No symbol table info available. [00:44:41.423] #2 0x000000082ba1a6f9 in abort () from /lib/libc.so.7 [00:44:41.423] No symbol table info available. [00:44:41.423] #3 0x0000000000a5bae5 in ExceptionalCondition (conditionName=0x2d0a60 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [00:44:41.423] No locals. [00:44:41.423] #4 0x000000000073e89f in ExecFetchSlotHeapTuple (slot=0x8215651f0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [00:44:41.423] No locals. [00:44:41.423] #5 0x0000000000703cf7 in ExecIRDeleteTriggers (estate=estate@entry=0x835015100, relinfo=relinfo@entry=0x8350156b0, slot=slot@entry=0x8215651f0) at ../src/backend/commands/trigger.c:2841 [00:44:41.423] trigger = [00:44:41.423] oldtuple = [00:44:41.423] should_free = false [00:44:41.423] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x838614130, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [00:44:41.423] trigdesc = 0x8350158c0 [00:44:41.423] newtuple = 0x0 [00:44:41.423] i = 0 [00:44:41.423] #6 0x0000000000763ac7 in ExecMergeMatched (context=0x821565298, resultRelInfo=0x8350156b0, tupleid=0x0, oldtuple=0x8215651f0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3040 [00:44:41.423] result = TM_Ok [00:44:41.423] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [00:44:41.423] relaction = 0x834f40fe0 [00:44:41.423] commandType = CMD_DELETE [00:44:41.423] l__state = {l = 0x838786508, i = 0} [00:44:41.423] mtstate = 0x8350154a0 [00:44:41.423] newslot = 0x0 [00:44:41.423] rslot = 0x0 [00:44:41.423] estate = 0x835015100 [00:44:41.423] mergeActions = [00:44:41.423] econtext = 0x8387855a8 [00:44:41.423] epqstate = 0x835015588 [00:44:41.423] actionStates = 0x838786508 [00:44:41.423] l = [00:44:41.423] isNull = [00:44:41.423] lmerge_matched = [00:44:41.423] __error = [00:44:41.423] l__state = [00:44:41.423] result = [00:44:41.423] updateCxt = [00:44:41.423] relaction = [00:44:41.423] commandType = [00:44:41.423] __error = [00:44:41.423] resultRelationDesc = [00:44:41.423] lockmode = [00:44:41.423] inputslot = [00:44:41.423] epqslot = [00:44:41.423] was_matched = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] #7 ExecMerge (context=0x821565298, resultRelInfo=0x8350156b0, tupleid=0x0, oldtuple=0x8215651f0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2801 [00:44:41.423] matched = [00:44:41.423] rslot = 0x0 [00:44:41.423] #8 ExecModifyTable (pstate=0x8350154a0) at ../src/backend/executor/nodeModifyTable.c:4130 [00:44:41.423] context = {mtstate = 0x8350154a0, epqstate = 0x835015588, estate = 0x835015100, planSlot = 0x834f40f50, tmfd = {ctid = {ip_blkid = {bi_hi = 52622, bi_lo = 11166}, ip_posid = 8}, xmax = 160, cmax = 0, traversed = 148}, cpUpdateReturningSlot = 0xcff2ee497369b77e} [00:44:41.423] tuple_ctid = {ip_blkid = {bi_hi = 21184, bi_lo = 8534}, ip_posid = 8} [00:44:41.423] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x838635118} [00:44:41.423] node = 0x8350154a0 [00:44:41.423] estate = 0x835015100 [00:44:41.423] operation = CMD_MERGE [00:44:41.423] resultRelInfo = 0x8350156b0 [00:44:41.423] subplanstate = 0x835016df0 [00:44:41.423] slot = [00:44:41.423] tupleid = 0x0 [00:44:41.423] oldtuple = 0x8215651f0 [00:44:41.423] oldSlot = [00:44:41.423] #9 0x0000000000730cab in ExecProcNode (node=0x8350154a0) at ../src/include/executor/executor.h:274 [00:44:41.423] No locals. [00:44:41.423] #10 ExecutePlan (estate=0x835015100, planstate=0x8350154a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x834e49b10, execute_once=) at ../src/backend/executor/execMain.c:1646 [00:44:41.423] current_tuple_count = 0 [00:44:41.423] slot = [00:44:41.423] #11 standard_ExecutorRun (queryDesc=0x834e98c48, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:363 [00:44:41.423] estate = 0x835015100 [00:44:41.423] oldcontext = 0x834e49800 [00:44:41.423] operation = CMD_MERGE [00:44:41.423] dest = 0x834e49b10 [00:44:41.423] sendTuples = true [00:44:41.423] #12 0x000000083930b961 in pgss_ExecutorRun (queryDesc=0x834e98c48, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [00:44:41.423] _local_sigjmp_buf = {{_sjb = {35319232817, 1, 34919044040, 34919044208, 12147736, 34919044048, 1, 35247459400, 34919023487, 7616097, 35249016832, 34359738368}}} [00:44:41.423] _save_exception_stack = 0x821565580 [00:44:41.423] _save_context_stack = 0x0 [00:44:41.423] _do_rethrow = false [00:44:41.423] #13 0x000000000090707f in ProcessQuery (plan=0x83873d080, sourceText=, params=0x0, queryEnv=0x0, dest=0x834e49b10, qc=0x821565548) at ../src/backend/tcop/pquery.c:160 [00:44:41.423] queryDesc = 0x834e98c48 [00:44:41.423] #14 0x000000000090661d in PortalRunMulti (portal=portal@entry=0x834ee1100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x834e49b10, altdest=0xb4cbe0 , qc=qc@entry=0x821565548) at ../src/backend/tcop/pquery.c:1287 [00:44:41.423] pstmt = 0x83873d080 [00:44:41.423] stmtlist_item__state = {l = 0x838741938, i = 0} [00:44:41.423] active_snapshot_set = true [00:44:41.423] stmtlist_item = 0x838741950 [00:44:41.423] #15 0x000000000090612c in FillPortalStore (portal=portal@entry=0x834ee1100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [00:44:41.423] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:44:41.423] treceiver = 0x834e49b10 [00:44:41.423] #16 0x0000000000905e9b in PortalRun (portal=portal@entry=0x834ee1100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x838741988, altdest=altdest@entry=0x838741988, qc=0x821565680) at ../src/backend/tcop/pquery.c:763 [00:44:41.423] _local_sigjmp_buf = {{_sjb = {9461309, 35247755520, 34919044472, 34919044704, 34919044480, 35247849472, 12114472, 12147736, 35247752063, 35247075584, 4294967984, 0}}} [00:44:41.423] _save_exception_stack = 0x821565750 [00:44:41.423] _save_context_stack = 0x0 [00:44:41.423] _do_rethrow = false [00:44:41.423] saveTopTransactionResourceOwner = 0x834f27258 [00:44:41.423] saveTopTransactionContext = 0x834ef8000 [00:44:41.423] saveActivePortal = 0x0 [00:44:41.423] saveResourceOwner = 0x834f27258 [00:44:41.423] savePortalContext = 0x0 [00:44:41.423] saveMemoryContext = 0x834ef8000 [00:44:41.423] result = [00:44:41.423] nprocessed = [00:44:41.423] #17 0x0000000000904d62 in exec_simple_query (query_string=query_string@entry=0x834e3b100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [00:44:41.423] cmdtaglen = 5 [00:44:41.423] snapshot_set = [00:44:41.423] per_parsetree_context = 0x0 [00:44:41.423] plantree_list = [00:44:41.423] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:44:41.423] format = 0 [00:44:41.423] parsetree = 0x838725368 [00:44:41.423] commandTag = [00:44:41.423] cmdtagname = [00:44:41.423] querytree_list = [00:44:41.423] portal = 0x834ee1100 [00:44:41.423] receiver = 0x838741988 [00:44:41.423] parsetree_item__state = {l = 0x838726c30, i = 0} [00:44:41.423] msec_str = "\000\000\000\000\b", '\000' , "\tC\301f\000\000\000\000\215u\026&\275ꌻ" [00:44:41.423] dest = DestRemote [00:44:41.423] was_logged = [00:44:41.423] oldcontext = 0x834ef8000 [00:44:41.423] parsetree_list = 0x838726c30 [00:44:41.423] use_implicit_block = false [00:44:41.423] parsetree_item = 0x838726c48 [00:44:41.423] save_log_statement_stats = [00:44:41.423] #18 0x0000000000902ad0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [00:44:41.423] query_string = 0x834e3b100 "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"... [00:44:41.423] input_message = {data = 0x834e3b100 "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} [00:44:41.423] firstchar = [00:44:41.423] local_sigjmp_buf = {{_sjb = {9445222, 34919044944, 34919044904, 34919045488, 12156472, 1, 8192, 8388608, 895, 0, 0, 1}}} [00:44:41.423] send_ready_for_query = false [00:44:41.423] idle_in_transaction_timeout_enabled = false [00:44:41.423] idle_session_timeout_enabled = false [00:44:41.423] #19 0x00000000008fd2a9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:44:41.423] bsdata = [00:44:41.423] #20 0x0000000000857fd7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821566494 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215663d8) at ../src/backend/postmaster/launch_backend.c:274 [00:44:41.423] pid = [00:44:41.423] #21 0x000000000085c398 in BackendStartup (client_sock=0x8215663d8) at ../src/backend/postmaster/postmaster.c:3414 [00:44:41.423] startup_data = {canAcceptConnections = CAC_OK} [00:44:41.423] bn = 0x834e47358 [00:44:41.423] pid = [00:44:41.423] __error = [00:44:41.423] save_errno = [00:44:41.423] __error = [00:44:41.423] __error = [00:44:41.423] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [00:44:41.423] 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 = "\v\000\000\000\000\000\000\000 \274\3434\b", '\000' , "@dV!\b\000\000\000h5\262*\b\000\000\000\v\000\000\000\000\000\000\000^\277\262*\b", '\000' , "\200dV!\b\000\000\000\204}\205\000\000\000\000\000\220dV!\b\000\000\000\000\000\000\000\000\000\000"}, salen = 16}} [00:44:41.423] i = 0 [00:44:41.423] now = [00:44:41.423] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 128686702, user_data = 0x0}, {pos = 568343096, events = 8, fd = 1, user_data = 0x821dfd408}, {pos = 730591592, events = 8, fd = 559307960, user_data = 0x821565c00}, {pos = 559307360, events = 8, fd = 1, user_data = 0x821dfd408}, {pos = 33, events = 0, fd = 559307760, user_data = 0x3b8472f9fa1a}, {pos = 568287240, events = 8, fd = 568288264, user_data = 0x821df6808}, {pos = 568290312, events = 8, fd = 568303624, user_data = 0x821dfa408}, {pos = 568305672, events = 8, fd = 568306696, user_data = 0x821dfb008}, {pos = 568308744, events = 8, fd = 568309768, user_data = 0x821dfbc08}, {pos = 568311816, events = 8, fd = 568312840, user_data = 0x821dfc808}, {pos = 568314888, events = 8, fd = 568315912, user_data = 0x821dfd408}, {pos = -25761258, events = 0, fd = 568340536, user_data = 0x800000001}, {pos = 568316936, events = 8, fd = 730612856, user_data = 0x821565e38}, {pos = 15, events = 0, fd = 559308160, user_data = 0x821565be0}, {pos = 1, events = 0, fd = 559308088, user_data = 0x21}, {pos = 559307728, events = 8, fd = 1929009779, user_data = 0x821565bb0}, {pos = 2572086, events = 0, fd = 568316936, user_data = 0x82b8deac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821e03a38}, {pos = 1, events = 8, fd = 568316936, user_data = 0x82b8bf168}, {pos = 559307960, events = 8, fd = 559307360, user_data = 0x1200000021}, {pos = 0, events = 0, fd = 568343096, user_data = 0x1}, {pos = 568316936, events = 8, fd = 839, user_data = 0x821565ca0}, {pos = 1928984047, events = 15236, fd = 730720963, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 568343096, user_data = 0x1}, {pos = 568316936, events = 8, fd = 887271424, user_data = 0x1}, {pos = 887271828, events = 8, fd = 0, user_data = 0x821565c70}, {pos = 716354924, events = 8, fd = 1, user_data = 0x834e2b000}, {pos = 559307936, events = 8, fd = 716351234, user_data = 0x82ba7f950 }, {pos = 732516728, events = 8, fd = 732428624, user_data = 0x821dfd408}, {pos = 559308160, events = 8, fd = 1928983518, user_data = 0x821565f48}, {pos = 1, events = 8, fd = 1928983134, user_data = 0x821dfd408}, {pos = 559307944, events = 8, fd = 559308160, user_data = 0x2fe8}, {pos = 0, events = 0, fd = 1929062800, user_data = 0x8215662f0}, {pos = 115213183, events = 0, fd = -25761258, user_data = 0xcff2ee497369b77e}, {pos = 0, events = 8, fd = 568316936, user_data = 0x2fe8}, {pos = 730570752, events = 8, fd = 1945976, user_data = 0x82ba7f950 }, {pos = 730705272, events = 8, fd = 15691, user_data = 0x82baa36a0 <__stack_chk_guard>}, {pos = 559308272, events = 8, fd = 731375893, user_data = 0x82ba88e38}, {pos = 559308208, events = 8, fd = 559309344, user_data = 0x0}, {pos = 559308272, events = 8, fd = 731466593, user_data = 0x1}, {pos = 559309344, events = 8, fd = 559309344, user_data = 0x100000000000000}, {pos = 1936308094, events = 3488804425, fd = 732575392, user_data = 0x834ea35d8}, {pos = 0, events = 0, fd = 732466744, user_data = 0x8215662f0}, {pos = 559309408, events = 8, fd = 731466882, user_data = 0x0}, {pos = 559309712, events = 8, fd = 887764440, user_data = 0x821566220}, {pos = 0, events = 0, fd = 1929011978, user_data = 0x82b8c97a0}, {pos = 730705272, events = 8, fd = 559308440, user_data = 0x821565f10}, {pos = 559308440, events = 8, fd = 1929011978, user_data = 0x82b8c4388}, {pos = 730705272, events = 8, fd = 559308488, user_data = 0x821565f40}, {pos = 559308488, events = 8, fd = 730673556, user_data = 0x821dfd408}, {pos = 730673556, events = 8, fd = 559308592, user_data = 0x3b8472fa143a}, {pos = 559308496, events = 8, fd = 716313616, user_data = 0x82ba90030 <__thr_jtable>}, {pos = 1929011978, events = 15236, fd = 730581080, user_data = 0x82b8dad78}, {pos = 559308600, events = 8, fd = 559308720, user_data = 0x821565f38}, {pos = 730668300, events = 8, fd = 568316936, user_data = 0x82b8d1d0c}, {pos = 559308704, events = 8, fd = 1928991802, user_data = 0x821565fc8}, {pos = 559309208, events = 8, fd = 559308720, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x526629ce}, {pos = 568340536, events = 8, fd = 1, user_data = 0x821dfd408}, {pos = 730612616, events = 8, fd = 568338376, user_data = 0x0}, {pos = 0, events = 0, fd = 559308856, user_data = 0x821566208}, {pos = 559308832, events = 8, fd = 1929010338, user_data = 0x2931a2}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e03038}} [00:44:41.423] last_touch_time = 1723941629 [00:44:41.423] last_lockfile_recheck_time = 1723941629 [00:44:41.423] nevents = 1 [00:44:41.423] #23 0x000000000085a1b5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8215669f8) at ../src/backend/postmaster/postmaster.c:1346 [00:44:41.423] userDoption = [00:44:41.423] listen_addr_saved = [00:44:41.423] output_config_variable = [00:44:41.423] opt = [00:44:41.423] status = [00:44:41.423] #24 0x0000000000793afc in main (argc=4, argv=0x8215669f8) at ../src/backend/main/main.c:197 [00:44:41.423] do_check_root =