[07:58:40.048] src/tools/ci/cores_backtrace.sh linux /tmp/cores [07:58:40.758] dumping /tmp/cores/postgres-6-24913.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:58:42.418] [New LWP 24913] [07:58:42.418] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [07:58:43.179] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [07:58:43.944] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [07:58:45.163] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [07:58:47.534] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [07:58:47.534] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [07:58:49.402] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [07:58:50.609] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [07:58:52.185] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [07:58:53.245] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [07:58:54.009] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [07:58:55.236] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [07:58:56.851] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [07:58:58.255] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [07:58:59.166] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [07:59:00.698] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [07:59:02.090] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [07:59:02.561] [Thread debugging using libthread_db enabled] [07:59:02.561] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:59:03.622] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [07:59:05.013] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [07:59:06.075] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [07:59:06.693] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [07:59:07.458] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [07:59:09.741] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [07:59:10.651] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [07:59:11.428] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [07:59:12.337] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [07:59:13.249] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [07:59:14.830] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [07:59:15.893] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [07:59:16.656] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [07:59:18.035] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [07:59:18.651] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [07:59:20.180] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [07:59:20.942] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [07:59:22.165] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [07:59:22.931] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [07:59:23.994] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [07:59:24.913] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [07:59:26.137] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [07:59:26.756] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [07:59:27.672] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [07:59:28.435] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [07:59:28.932] Core was generated by `postgres: old_node: postgres regression [local] MERGE '. [07:59:28.932] Program terminated with signal SIGABRT, Aborted. [07:59:28.932] #0 0x00007f0720e6ece1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:29.163] [07:59:29.163] Thread 1 (Thread 0x7f071e805a40 (LWP 24913)): [07:59:29.163] #0 0x00007f0720e6ece1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:29.163] No symbol table info available. [07:59:29.163] #1 0x00007f0720e58537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:29.163] No symbol table info available. [07:59:29.163] #2 0x000055eba2e9df61 in ExceptionalCondition (conditionName=conditionName@entry=0x55eba30f44f8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x55eba31190f8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [07:59:29.163] No locals. [07:59:29.163] #3 0x000055eba27eead6 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffe29be6c20, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffe29be6abf) at ../src/backend/executor/execTuples.c:1737 [07:59:29.163] No locals. [07:59:29.163] #4 0x000055eba2771303 in ExecIRDeleteTriggers (estate=estate@entry=0x55eba3d0c8a0, relinfo=relinfo@entry=0x55eba3d0ce50, slot=slot@entry=0x7ffe29be6c20) at ../src/backend/commands/trigger.c:2832 [07:59:29.163] trigger = 0x55eba3d0d0b0 [07:59:29.163] oldtuple = [07:59:29.163] trigdesc = 0x55eba3d0d060 [07:59:29.163] newtuple = 0x0 [07:59:29.163] should_free = false [07:59:29.163] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f071585fdd8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:59:29.163] i = 0 [07:59:29.163] #5 0x000055eba2851695 in ExecMergeMatched (context=0x7ffe29be6c40, resultRelInfo=resultRelInfo@entry=0x55eba3d0ce50, tupleid=0x0, oldtuple=0x7ffe29be6c20, canSetTag=true, matched=matched@entry=0x7ffe29be6bcf) at ../src/backend/executor/nodeModifyTable.c:2976 [07:59:29.163] relaction = 0x55eba3d4f4f8 [07:59:29.163] commandType = CMD_DELETE [07:59:29.163] result = TM_Ok [07:59:29.163] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:59:29.163] l__state = {l = , i = } [07:59:29.163] mtstate = 0x55eba3d0cc40 [07:59:29.163] mergeActions = 0x55eba3d0cf60 [07:59:29.163] actionStates = 0x55eba3d4fab8 [07:59:29.163] newslot = 0x0 [07:59:29.163] rslot = 0x0 [07:59:29.163] estate = 0x55eba3d0c8a0 [07:59:29.163] econtext = 0x55eba3d4eb08 [07:59:29.163] isNull = false [07:59:29.163] epqstate = 0x55eba3d0cd28 [07:59:29.163] l = [07:59:29.163] __func__ = "ExecMergeMatched" [07:59:29.163] lmerge_matched = [07:59:29.163] #6 0x000055eba285277d in ExecMerge (context=context@entry=0x7ffe29be6c40, resultRelInfo=resultRelInfo@entry=0x55eba3d0ce50, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffe29be6c20, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [07:59:29.163] rslot = 0x0 [07:59:29.163] matched = true [07:59:29.163] #7 0x000055eba28544d4 in ExecModifyTable (pstate=0x55eba3d0cc40) at ../src/backend/executor/nodeModifyTable.c:4067 [07:59:29.163] node = 0x55eba3d0cc40 [07:59:29.163] context = {mtstate = 0x55eba3d0cc40, epqstate = 0x55eba3d0cd28, estate = 0x55eba3d0c8a0, planSlot = 0x55eba3d4d518, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 2726081965, cmax = 21995, traversed = 8}, cpUpdateReturningSlot = 0x55eba3dab070} [07:59:29.163] estate = 0x55eba3d0c8a0 [07:59:29.163] operation = CMD_MERGE [07:59:29.163] resultRelInfo = 0x55eba3d0ce50 [07:59:29.163] subplanstate = 0x55eba3d0d580 [07:59:29.163] slot = [07:59:29.163] oldSlot = [07:59:29.163] tuple_ctid = {ip_blkid = {bi_hi = 41946, bi_lo = 21995}, ip_posid = 0} [07:59:29.163] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x55eba3d75508} [07:59:29.163] oldtuple = 0x7ffe29be6c20 [07:59:29.163] tupleid = 0x0 [07:59:29.163] __func__ = "ExecModifyTable" [07:59:29.163] #8 0x000055eba27e0ba1 in ExecProcNodeFirst (node=0x55eba3d0cc40) at ../src/backend/executor/execProcnode.c:464 [07:59:29.163] No locals. [07:59:29.163] #9 0x000055eba27cd29c in ExecProcNode (node=0x55eba3d0cc40) at ../src/include/executor/executor.h:274 [07:59:29.163] No locals. [07:59:29.163] #10 ExecutePlan (estate=estate@entry=0x55eba3d0c8a0, planstate=0x55eba3d0cc40, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55eba3d98170, execute_once=true) at ../src/backend/executor/execMain.c:1646 [07:59:29.163] slot = [07:59:29.163] current_tuple_count = 0 [07:59:29.163] #11 0x000055eba27cd5e6 in standard_ExecutorRun (queryDesc=0x55eba3d50ea8, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [07:59:29.163] estate = 0x55eba3d0c8a0 [07:59:29.163] operation = CMD_MERGE [07:59:29.163] dest = 0x55eba3d98170 [07:59:29.163] sendTuples = true [07:59:29.163] oldcontext = 0x55eba3d97e60 [07:59:29.163] __func__ = "standard_ExecutorRun" [07:59:29.163] #12 0x000055eba27cd751 in ExecutorRun (queryDesc=queryDesc@entry=0x55eba3d50ea8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [07:59:29.163] No locals. [07:59:29.163] #13 0x000055eba2bf3b50 in ProcessQuery (plan=plan@entry=0x55eba3dadf78, sourceText=0x55eba3c091d0 "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"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x55eba3d98170, qc=qc@entry=0x7ffe29be6e60) at ../src/backend/tcop/pquery.c:160 [07:59:29.163] queryDesc = 0x55eba3d50ea8 [07:59:29.163] #14 0x000055eba2bf589f in PortalRunMulti (portal=portal@entry=0x55eba3c8ced0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55eba3d98170, altdest=0x55eba33e1320 , qc=qc@entry=0x7ffe29be6e60) at ../src/backend/tcop/pquery.c:1277 [07:59:29.163] pstmt = 0x55eba3dadf78 [07:59:29.163] stmtlist_item__state = {l = , i = } [07:59:29.163] active_snapshot_set = true [07:59:29.163] stmtlist_item = 0x55eba3dae0a0 [07:59:29.163] #15 0x000055eba2bf5f45 in FillPortalStore (portal=portal@entry=0x55eba3c8ced0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [07:59:29.163] treceiver = 0x55eba3d98170 [07:59:29.163] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:29.163] __func__ = "FillPortalStore" [07:59:29.163] #16 0x000055eba2bf65a4 in PortalRun (portal=portal@entry=0x55eba3c8ced0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55eba3dae0d8, altdest=altdest@entry=0x55eba3dae0d8, qc=0x7ffe29be7040) at ../src/backend/tcop/pquery.c:763 [07:59:29.163] _save_exception_stack = 0x7ffe29be70f0 [07:59:29.163] _save_context_stack = 0x0 [07:59:29.163] _local_sigjmp_buf = {{__jmpbuf = {1, -4803385902055745213, 94470554706136, 94470554271552, 94470553521872, 94470554271480, 4803830642141370691, 1621775830445922627}, __mask_was_saved = 0, __saved_mask = {__val = {94470553533432, 94470542102502, 94470553530080, 94470542102502, 1, 140729598767055, 94470554271528, 94470554271480, 94470539024040, 94470541684777, 94470553521872, 94470542102502, 1, 1, 94470539292841, 163}}}} [07:59:29.163] _do_rethrow = [07:59:29.163] result = [07:59:29.163] nprocessed = [07:59:29.163] saveTopTransactionResourceOwner = 0x55eba3c4a088 [07:59:29.163] saveTopTransactionContext = 0x55eba3ce32d0 [07:59:29.163] saveActivePortal = 0x0 [07:59:29.163] saveResourceOwner = 0x55eba3c4a088 [07:59:29.163] savePortalContext = 0x0 [07:59:29.163] saveMemoryContext = 0x55eba3ce32d0 [07:59:29.163] __func__ = "PortalRun" [07:59:29.163] #17 0x000055eba2bef52d in exec_simple_query (query_string=query_string@entry=0x55eba3c091d0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [07:59:29.163] cmdtaglen = 5 [07:59:29.163] snapshot_set = [07:59:29.163] per_parsetree_context = 0x0 [07:59:29.163] plantree_list = 0x55eba3dae088 [07:59:29.163] parsetree = 0x55eba3d43ef8 [07:59:29.163] commandTag = [07:59:29.163] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:29.163] querytree_list = [07:59:29.163] portal = 0x55eba3c8ced0 [07:59:29.163] receiver = 0x55eba3dae0d8 [07:59:29.163] format = 0 [07:59:29.163] cmdtagname = [07:59:29.163] parsetree_item__state = {l = , i = } [07:59:29.163] dest = DestRemote [07:59:29.163] oldcontext = 0x55eba3ce32d0 [07:59:29.163] parsetree_list = 0x55eba3d43f28 [07:59:29.163] parsetree_item = 0x55eba3d43f40 [07:59:29.163] save_log_statement_stats = false [07:59:29.163] was_logged = true [07:59:29.163] use_implicit_block = false [07:59:29.163] msec_str = "\240r\276)\376\177\000\000As\354\242\353U\000\000\320p\276)\376\177\000\000\026\001\000\000\000\000\000" [07:59:29.163] __func__ = "exec_simple_query" [07:59:29.163] #18 0x000055eba2bf22eb in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [07:59:29.163] query_string = 0x55eba3c091d0 "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"... [07:59:29.163] firstchar = [07:59:29.163] input_message = {data = 0x55eba3c091d0 "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} [07:59:29.163] local_sigjmp_buf = {{__jmpbuf = {94470551796152, 1621778157518002499, 4, 140729598767776, 140729598767924, 1, 4803830641801632067, 1621775830646593859}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 139668593819108, 94470552956576, 14336, 14400, 94470539196237, 94470551796160, 94470552956576, 94470551790232, 140729598767776, 140729598767924, 94470539200305, 140729598767552}}}} [07:59:29.163] send_ready_for_query = false [07:59:29.163] idle_in_transaction_timeout_enabled = false [07:59:29.163] idle_session_timeout_enabled = false [07:59:29.163] __func__ = "PostgresMain" [07:59:29.163] #19 0x000055eba2be8a8d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [07:59:29.163] bsdata = [07:59:29.163] #20 0x000055eba2a8cd88 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe29be724c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe29be72a0) at ../src/backend/postmaster/launch_backend.c:265 [07:59:29.163] pid = [07:59:29.163] #21 0x000055eba2a930bb in BackendStartup (client_sock=client_sock@entry=0x7ffe29be72a0) at ../src/backend/postmaster/postmaster.c:3593 [07:59:29.163] bn = 0x55eba3c3f4a8 [07:59:29.163] pid = [07:59:29.163] startup_data = {canAcceptConnections = CAC_OK} [07:59:29.163] __func__ = "BackendStartup" [07:59:29.163] #22 0x000055eba2a93669 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [07:59:29.163] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\344 \a\177\000\000 I\264!\a\177\000\000Hs\276)\376\177\000\000Ds\276)\376\177\000\000\000\000\000\000\376\177\000\000@\356\203\036\a\177\000\000\000\000\000\000\376\177\000\000\020~\344 \a\177\000\000\340\237\343 \a\177\000\000\352\337\000!\a\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000Ds\276)\376\177\000\000@\356\203\036\a\177\000\000\020t\276)\376\177\000", __ss_align = 139668595192608}, salen = 2}} [07:59:29.163] i = 0 [07:59:29.163] now = [07:59:29.163] last_lockfile_recheck_time = 1712562957 [07:59:29.163] last_touch_time = 1712562957 [07:59:29.163] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = 565462920, events = 32519, fd = 553705450, user_data = 0x7ffe29be74a8}, {pos = 700347392, events = 32766, fd = 700347408, user_data = 0x7f07227b5ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = 511751704, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f0721b44420}, {pos = -1, events = 0, fd = 511751704, user_data = 0x7f0721b44420}, {pos = 565463328, events = 1, fd = 565462920, user_data = 0x0}, {pos = 700347392, events = 32766, fd = 1024, user_data = 0xffffffff}, {pos = 700347680, events = 32766, fd = 551789592, user_data = 0x7f0721b44920}, {pos = -1547492488, events = 21995, fd = -1547492856, user_data = 0x55eba3c34010}, {pos = -1547492456, events = 21995, fd = -1547488527, user_data = 0x7f07227ba623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 553808120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = -1547653264, events = 21995, fd = 578528803, user_data = 0x1}, {pos = 0, events = 0, fd = -1547485168, user_data = 0x7f0720e3a418}, {pos = 700348528, events = 32766, fd = 578557578, user_data = 0x0}, {pos = 0, events = 0, fd = 700348560, user_data = 0x55eba3ad9760 }, {pos = 2, events = 0, fd = -1548904608, user_data = 0x0}, {pos = 552316492, events = 32519, fd = -1547448320, user_data = 0x7f0721004be0}, {pos = 255, events = 0, fd = 8096, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0xffff0000ffffff00}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55eba3c06f40}, {pos = -1547669696, events = 21995, fd = 553650304, user_data = 0x7f0720eb351a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = 552308014, user_data = 0x400}, {pos = -1547669696, events = 21995, fd = 553653376, user_data = 0x1a3c06f40}, {pos = 784, events = 0, fd = -1559083732, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55eba2ee6b4f }, {pos = -1547493664, events = 21995, fd = -1547493664, user_data = 0x55eba3c31ee0}, {pos = 1, events = 0, fd = -1547493464, user_data = 0x400}, {pos = 0, events = 0, fd = -1561358468, user_data = 0x55eba3ae7970 }, {pos = -1561432586, events = 21995, fd = -1547493664, user_data = 0x55eba3c090d0}, {pos = -1547493664, events = 21995, fd = 15, user_data = 0x4a}, {pos = -1561356658, events = 21995, fd = -1547493664, user_data = 0x55eba2ef97d7 }, {pos = -1547669696, events = 21995, fd = 552308014, user_data = 0x0}, {pos = -1568000746, events = 21995, fd = -1547498816, user_data = 0x7f0720eb51aa}, {pos = 700348712, events = 1, fd = 0, user_data = 0x7f0720eb38f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 22341, user_data = 0x7f0720efdb05 }, {pos = 0, events = 0, fd = -351201536, user_data = 0x0}, {pos = -1565996370, events = 21995, fd = 4194304, user_data = 0x55eba2ee6c8a }, {pos = -1547498816, events = 21995, fd = -1547661104, user_data = 0x55eba3c30ac0}, {pos = 1, events = 0, fd = 0, user_data = 0x55eba2ef968e }, {pos = -1547498816, events = 21995, fd = -1561356329, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55eba28a30e9 }, {pos = 0, events = 0, fd = -1567977793, user_data = 0xb}, {pos = -1565974515, events = 21995, fd = 0, user_data = 0x0}} [07:59:29.165] nevents = 1 [07:59:29.165] __func__ = "ServerLoop" [07:59:29.165] #23 0x000055eba2a9508b in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55eba3c02db0) at ../src/backend/postmaster/postmaster.c:1372 [07:59:29.165] opt = [07:59:29.165] status = [07:59:29.165] userDoption = [07:59:29.165] listen_addr_saved = false [07:59:29.165] output_config_variable = [07:59:29.165] __func__ = "PostmasterMain" [07:59:29.165] #24 0x000055eba28b474c in main (argc=4, argv=0x55eba3c02db0) at ../src/backend/main/main.c:197 [07:59:29.165] do_check_root = [07:59:29.182] -e [07:59:29.182] [07:59:29.182] [07:59:29.714] dumping /tmp/cores/postgres-6-24081.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:59:30.036] [New LWP 24081] [07:59:31.171] [Thread debugging using libthread_db enabled] [07:59:31.171] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:59:32.583] Core was generated by `postgres: postgres regression [local] MERGE '. [07:59:32.583] Program terminated with signal SIGABRT, Aborted. [07:59:32.583] #0 0x00007ff1b8e9fce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:32.780] [07:59:32.780] Thread 1 (Thread 0x7ff1b6836a40 (LWP 24081)): [07:59:32.780] #0 0x00007ff1b8e9fce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:32.780] No symbol table info available. [07:59:32.780] #1 0x00007ff1b8e89537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:32.780] No symbol table info available. [07:59:32.780] #2 0x00005638910e1f61 in ExceptionalCondition (conditionName=conditionName@entry=0x5638913384f8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x56389135d0f8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [07:59:32.780] No locals. [07:59:32.780] #3 0x0000563890a32ad6 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fffc7f08660, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fffc7f084ff) at ../src/backend/executor/execTuples.c:1737 [07:59:32.780] No locals. [07:59:32.780] #4 0x00005638909b5303 in ExecIRDeleteTriggers (estate=estate@entry=0x56389344f180, relinfo=relinfo@entry=0x56389344f730, slot=slot@entry=0x7fffc7f08660) at ../src/backend/commands/trigger.c:2832 [07:59:32.780] trigger = 0x56389344f990 [07:59:32.780] oldtuple = [07:59:32.780] trigdesc = 0x56389344f940 [07:59:32.780] newtuple = 0x0 [07:59:32.780] should_free = false [07:59:32.780] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7ff1ad5714d8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:59:32.780] i = 0 [07:59:32.780] #5 0x0000563890a95695 in ExecMergeMatched (context=0x7fffc7f08680, resultRelInfo=resultRelInfo@entry=0x56389344f730, tupleid=0x0, oldtuple=0x7fffc7f08660, canSetTag=true, matched=matched@entry=0x7fffc7f0860f) at ../src/backend/executor/nodeModifyTable.c:2976 [07:59:32.780] relaction = 0x563893485d78 [07:59:32.780] commandType = CMD_DELETE [07:59:32.780] result = TM_Ok [07:59:32.780] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:59:32.780] l__state = {l = , i = } [07:59:32.780] mtstate = 0x56389344f520 [07:59:32.780] mergeActions = 0x56389344f840 [07:59:32.780] actionStates = 0x563893486338 [07:59:32.780] newslot = 0x0 [07:59:32.780] rslot = 0x0 [07:59:32.780] estate = 0x56389344f180 [07:59:32.780] econtext = 0x563893485388 [07:59:32.780] isNull = false [07:59:32.780] epqstate = 0x56389344f608 [07:59:32.780] l = [07:59:32.780] __func__ = "ExecMergeMatched" [07:59:32.780] lmerge_matched = [07:59:32.780] #6 0x0000563890a9677d in ExecMerge (context=context@entry=0x7fffc7f08680, resultRelInfo=resultRelInfo@entry=0x56389344f730, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fffc7f08660, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [07:59:32.780] rslot = 0x0 [07:59:32.780] matched = true [07:59:32.780] #7 0x0000563890a984d4 in ExecModifyTable (pstate=0x56389344f520) at ../src/backend/executor/nodeModifyTable.c:4067 [07:59:32.780] node = 0x56389344f520 [07:59:32.780] context = {mtstate = 0x56389344f520, epqstate = 0x56389344f608, estate = 0x56389344f180, planSlot = 0x563893483d98, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 2426467757, cmax = 22072, traversed = 120}, cpUpdateReturningSlot = 0x5638934ed5e0} [07:59:32.780] estate = 0x56389344f180 [07:59:32.780] operation = CMD_MERGE [07:59:32.780] resultRelInfo = 0x56389344f730 [07:59:32.780] subplanstate = 0x56389344fe60 [07:59:32.780] slot = [07:59:32.780] oldSlot = [07:59:32.780] tuple_ctid = {ip_blkid = {bi_hi = 37710, bi_lo = 22072}, ip_posid = 0} [07:59:32.780] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x5638934b12c8} [07:59:32.780] oldtuple = 0x7fffc7f08660 [07:59:32.780] tupleid = 0x0 [07:59:32.780] __func__ = "ExecModifyTable" [07:59:32.780] #8 0x0000563890a24ba1 in ExecProcNodeFirst (node=0x56389344f520) at ../src/backend/executor/execProcnode.c:464 [07:59:32.780] No locals. [07:59:32.780] #9 0x0000563890a1129c in ExecProcNode (node=0x56389344f520) at ../src/include/executor/executor.h:274 [07:59:32.780] No locals. [07:59:32.780] #10 ExecutePlan (estate=estate@entry=0x56389344f180, planstate=0x56389344f520, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x5638934d5080, execute_once=true) at ../src/backend/executor/execMain.c:1646 [07:59:32.780] slot = [07:59:32.780] current_tuple_count = 0 [07:59:32.780] #11 0x0000563890a115e6 in standard_ExecutorRun (queryDesc=0x5638934d8ca8, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [07:59:32.780] estate = 0x56389344f180 [07:59:32.780] operation = CMD_MERGE [07:59:32.780] dest = 0x5638934d5080 [07:59:32.780] sendTuples = true [07:59:32.780] oldcontext = 0x5638934d4d70 [07:59:32.780] __func__ = "standard_ExecutorRun" [07:59:32.780] #12 0x0000563890a11751 in ExecutorRun (queryDesc=queryDesc@entry=0x5638934d8ca8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [07:59:32.780] No locals. [07:59:32.780] #13 0x0000563890e37b50 in ProcessQuery (plan=plan@entry=0x5638934f04e8, sourceText=0x56389334c1e0 "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"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x5638934d5080, qc=qc@entry=0x7fffc7f088a0) at ../src/backend/tcop/pquery.c:160 [07:59:32.780] queryDesc = 0x5638934d8ca8 [07:59:32.780] #14 0x0000563890e3989f in PortalRunMulti (portal=portal@entry=0x5638933ccf10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5638934d5080, altdest=0x563891625320 , qc=qc@entry=0x7fffc7f088a0) at ../src/backend/tcop/pquery.c:1277 [07:59:32.780] pstmt = 0x5638934f04e8 [07:59:32.780] stmtlist_item__state = {l = , i = } [07:59:32.780] active_snapshot_set = true [07:59:32.780] stmtlist_item = 0x5638934f0610 [07:59:32.780] #15 0x0000563890e39f45 in FillPortalStore (portal=portal@entry=0x5638933ccf10, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [07:59:32.780] treceiver = 0x5638934d5080 [07:59:32.780] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:32.780] __func__ = "FillPortalStore" [07:59:32.780] #16 0x0000563890e3a5a4 in PortalRun (portal=portal@entry=0x5638933ccf10, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5638934f0648, altdest=altdest@entry=0x5638934f0648, qc=0x7fffc7f08a80) at ../src/backend/tcop/pquery.c:763 [07:59:32.780] _save_exception_stack = 0x7fffc7f08b30 [07:59:32.780] _save_context_stack = 0x0 [07:59:32.780] _local_sigjmp_buf = {{__jmpbuf = {1, -8112442308571952630, 94800989587016, 94800989095968, 94800988393232, 94800989095896, 8112495112272480778, 2529881100300978698}, __mask_was_saved = 0, __saved_mask = {__val = {94800988404792, 94800954970086, 94800988401440, 94800954970086, 1, 140736547817999, 94800989095944, 94800989095896, 94800951891624, 94800954552361, 94800988393232, 94800954970086, 1, 1, 94800952160425, 163}}}} [07:59:32.780] _do_rethrow = [07:59:32.780] result = [07:59:32.780] nprocessed = [07:59:32.780] saveTopTransactionResourceOwner = 0x56389338bbd8 [07:59:32.780] saveTopTransactionContext = 0x563893374af0 [07:59:32.780] saveActivePortal = 0x0 [07:59:32.780] saveResourceOwner = 0x56389338bbd8 [07:59:32.780] savePortalContext = 0x0 [07:59:32.780] saveMemoryContext = 0x563893374af0 [07:59:32.780] __func__ = "PortalRun" [07:59:32.780] #17 0x0000563890e3352d in exec_simple_query (query_string=query_string@entry=0x56389334c1e0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [07:59:32.780] cmdtaglen = 5 [07:59:32.780] snapshot_set = [07:59:32.780] per_parsetree_context = 0x0 [07:59:32.780] plantree_list = 0x5638934f05f8 [07:59:32.780] parsetree = 0x5638934787d8 [07:59:32.780] commandTag = [07:59:32.780] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:32.780] querytree_list = [07:59:32.780] portal = 0x5638933ccf10 [07:59:32.780] receiver = 0x5638934f0648 [07:59:32.780] format = 0 [07:59:32.780] cmdtagname = [07:59:32.780] parsetree_item__state = {l = , i = } [07:59:32.780] dest = DestRemote [07:59:32.780] oldcontext = 0x563893374af0 [07:59:32.780] parsetree_list = 0x563893478808 [07:59:32.780] parsetree_item = 0x563893478820 [07:59:32.780] save_log_statement_stats = false [07:59:32.780] was_logged = false [07:59:32.780] use_implicit_block = false [07:59:32.780] msec_str = "\340\214\360\307\377\177\000\000A\263\020\221\070V\000\000\020\213\360\307\377\177\000\000\026\001\000\000\000\000\000" [07:59:32.780] __func__ = "exec_simple_query" [07:59:32.780] #18 0x0000563890e362eb in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [07:59:32.780] query_string = 0x56389334c1e0 "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"... [07:59:32.780] firstchar = [07:59:32.780] input_message = {data = 0x56389334c1e0 "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} [07:59:32.780] local_sigjmp_buf = {{__jmpbuf = {94800964663736, 2529882894788725258, 4, 140736547818720, 140736547818868, 1, 8112495112343783946, 2529881100635867658}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140676166503908, 94800987840144, 15616, 15680, 94800952063821, 94800964663744, 94800987840144, 94800964657816, 140736547818720, 140736547818868, 94800952067889, 140736547818496}}}} [07:59:32.780] send_ready_for_query = false [07:59:32.780] idle_in_transaction_timeout_enabled = false [07:59:32.780] idle_session_timeout_enabled = false [07:59:32.780] __func__ = "PostgresMain" [07:59:32.780] #19 0x0000563890e2ca8d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [07:59:32.780] bsdata = [07:59:32.780] #20 0x0000563890cd0d88 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffc7f08c8c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffc7f08ce0) at ../src/backend/postmaster/launch_backend.c:265 [07:59:32.780] pid = [07:59:32.780] #21 0x0000563890cd70bb in BackendStartup (client_sock=client_sock@entry=0x7fffc7f08ce0) at ../src/backend/postmaster/postmaster.c:3593 [07:59:32.780] bn = 0x563893374da8 [07:59:32.780] pid = [07:59:32.780] startup_data = {canAcceptConnections = CAC_OK} [07:59:32.780] __func__ = "BackendStartup" [07:59:32.780] #22 0x0000563890cd7669 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [07:59:32.780] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\347\270\361\177\000\000 Y\267\271\361\177\000\000\210\215\360\307\377\177\000\000\204\215\360\307\377\177\000\000\000\000\000\000\377\177\000\000@\376\206\266\361\177\000\000\000\000\000\000\377\177\000\000\020\216\347\270\361\177\000\000\340\257\346\270\361\177\000\000\352\357\003\271\361\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\204\215\360\307\377\177\000\000@\376\206\266\361\177\000\000P\216\360\307\377\177\000", __ss_align = 140676167877408}, salen = 2}} [07:59:32.780] i = 0 [07:59:32.780] now = [07:59:32.780] last_lockfile_recheck_time = 1712562955 [07:59:32.780] last_touch_time = 1712562955 [07:59:32.780] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = -1179166840, events = 32753, fd = -1190924310, user_data = 0x7fffc7f08ee8}, {pos = -940536256, events = 32767, fd = -940536240, user_data = 0x7ff1ba7e6ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -1232878056, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7ff1b9b75420}, {pos = -1, events = 0, fd = -1232878056, user_data = 0x7ff1b9b75420}, {pos = -1179166432, events = 1, fd = -1179166840, user_data = 0x0}, {pos = -940536256, events = 32767, fd = 1024, user_data = 0xffffffff}, {pos = -940535968, events = 32767, fd = -1192840168, user_data = 0x7ff1b9b75920}, {pos = -1825072248, events = 22072, fd = -1825081720, user_data = 0x563893371970}, {pos = -1825072216, events = 22072, fd = -1825072415, user_data = 0x7ff1ba7eb623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = -1190821640, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = -1825251408, events = 22072, fd = -1166100957, user_data = 0x1}, {pos = 0, events = 0, fd = -1825105552, user_data = 0x7ff1b8e6b418}, {pos = -940535120, events = 32767, fd = -1166072182, user_data = 0x0}, {pos = 0, events = 0, fd = -940535088, user_data = 0x563891d1d760 }, {pos = 2, events = 0, fd = -1848518816, user_data = 0x0}, {pos = -1192313434, events = 32753, fd = -1825047728, user_data = 0x7ff1b9035be0}, {pos = 255, events = 0, fd = 8096, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x0}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1734701663, events = 1936942450, fd = 1362180141, user_data = 0x6a5131382d737365}, {pos = 168450130, events = 908075040, fd = 822763892, user_data = 0x30340a3535393236}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 538976266, user_data = 0x2020202020203739}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x563893349f30}, {pos = -1825267920, events = 22072, fd = -1190979456, user_data = 0x7ff1b8ee451a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -1192322053, user_data = 0x400}, {pos = -1825267920, events = 22072, fd = -1190976384, user_data = 0x193349f30}, {pos = 784, events = 0, fd = -1858697940, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x56389112ab4f }, {pos = -1825082528, events = 22072, fd = -1825082528, user_data = 0x563893377360}, {pos = 1, events = 0, fd = -1825082328, user_data = 0x400}, {pos = 0, events = 0, fd = -1860972676, user_data = 0x563891d2b970 }, {pos = -1861046794, events = 22072, fd = -1825082528, user_data = 0x56389334c0e0}, {pos = -1825082528, events = 22072, fd = 15, user_data = 0x4a}, {pos = -1860970866, events = 22072, fd = -1825082528, user_data = 0x56389113d7d7 }, {pos = -1825267920, events = 22072, fd = -1192322053, user_data = 0x0}, {pos = -1867614954, events = 22072, fd = -1825093920, user_data = 0x7ff1b8ee61aa}, {pos = -940534936, events = 1, fd = 0, user_data = 0x7ff1b8ee48f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 21739, user_data = 0x7ff1b8f2eb05 }, {pos = 0, events = 0, fd = 1536910848, user_data = 0x0}, {pos = -1865610578, events = 22072, fd = 4194304, user_data = 0x56389112ac8a }, {pos = -1825093920, events = 22072, fd = -1825259296, user_data = 0x5638933746e0}, {pos = 1, events = 0, fd = 0, user_data = 0x56389113d68e }, {pos = -1825093920, events = 22072, fd = -1860970537, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x563890ae70e9 }, {pos = 0, events = 0, fd = -1867592001, user_data = 0xb}, {pos = -1865588723, events = 22072, fd = 0, user_data = 0x0}} [07:59:32.782] nevents = 1 [07:59:32.782] __func__ = "ServerLoop" [07:59:32.782] #23 0x0000563890cd908b in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x563893345df0) at ../src/backend/postmaster/postmaster.c:1372 [07:59:32.782] opt = [07:59:32.782] status = [07:59:32.782] userDoption = [07:59:32.782] listen_addr_saved = false [07:59:32.782] output_config_variable = [07:59:32.782] __func__ = "PostmasterMain" [07:59:32.782] #24 0x0000563890af874c in main (argc=8, argv=0x563893345df0) at ../src/backend/main/main.c:197 [07:59:32.782] do_check_root = [07:59:32.800] -e [07:59:32.800] [07:59:32.800] [07:59:33.333] dumping /tmp/cores/postgres-6-31195.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:59:33.649] [New LWP 31195] [07:59:34.787] [Thread debugging using libthread_db enabled] [07:59:34.787] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:59:36.202] Core was generated by `postgres: primary: postgres regression [local] MERGE '. [07:59:36.202] Program terminated with signal SIGABRT, Aborted. [07:59:36.202] #0 0x00007fd3c9c97ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:36.408] [07:59:36.408] Thread 1 (Thread 0x7fd3c762ea40 (LWP 31195)): [07:59:36.408] #0 0x00007fd3c9c97ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:36.408] No symbol table info available. [07:59:36.408] #1 0x00007fd3c9c81537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:59:36.408] No symbol table info available. [07:59:36.408] #2 0x0000557101aadf61 in ExceptionalCondition (conditionName=conditionName@entry=0x557101d044f8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x557101d290f8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [07:59:36.408] No locals. [07:59:36.408] #3 0x00005571013fead6 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffef48998a0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffef489973f) at ../src/backend/executor/execTuples.c:1737 [07:59:36.408] No locals. [07:59:36.408] #4 0x0000557101381303 in ExecIRDeleteTriggers (estate=estate@entry=0x55710334fe10, relinfo=relinfo@entry=0x5571033503c0, slot=slot@entry=0x7ffef48998a0) at ../src/backend/commands/trigger.c:2832 [07:59:36.408] trigger = 0x557103350620 [07:59:36.408] oldtuple = [07:59:36.408] trigdesc = 0x5571033505d0 [07:59:36.408] newtuple = 0x0 [07:59:36.408] should_free = false [07:59:36.408] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fd3c580bd40, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:59:36.408] i = 0 [07:59:36.408] #5 0x0000557101461695 in ExecMergeMatched (context=0x7ffef48998c0, resultRelInfo=resultRelInfo@entry=0x5571033503c0, tupleid=0x0, oldtuple=0x7ffef48998a0, canSetTag=true, matched=matched@entry=0x7ffef489984f) at ../src/backend/executor/nodeModifyTable.c:2976 [07:59:36.408] relaction = 0x55710346d608 [07:59:36.408] commandType = CMD_DELETE [07:59:36.408] result = TM_Ok [07:59:36.408] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:59:36.408] l__state = {l = , i = } [07:59:36.408] mtstate = 0x5571033501b0 [07:59:36.408] mergeActions = 0x5571033504d0 [07:59:36.408] actionStates = 0x55710346dbc8 [07:59:36.408] newslot = 0x0 [07:59:36.408] rslot = 0x0 [07:59:36.408] estate = 0x55710334fe10 [07:59:36.408] econtext = 0x55710346cc18 [07:59:36.408] isNull = false [07:59:36.408] epqstate = 0x557103350298 [07:59:36.408] l = [07:59:36.408] __func__ = "ExecMergeMatched" [07:59:36.408] lmerge_matched = [07:59:36.408] #6 0x000055710146277d in ExecMerge (context=context@entry=0x7ffef48998c0, resultRelInfo=resultRelInfo@entry=0x5571033503c0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffef48998a0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [07:59:36.408] rslot = 0x0 [07:59:36.408] matched = true [07:59:36.408] #7 0x00005571014644d4 in ExecModifyTable (pstate=0x5571033501b0) at ../src/backend/executor/nodeModifyTable.c:4067 [07:59:36.408] node = 0x5571033501b0 [07:59:36.408] context = {mtstate = 0x5571033501b0, epqstate = 0x557103350298, estate = 0x55710334fe10, planSlot = 0x55710346b628, tmfd = {ctid = {ip_blkid = {bi_hi = 54392, bi_lo = 838}, ip_posid = 21873}, xmax = 54541640, cmax = 21873, traversed = 176}, cpUpdateReturningSlot = 0x5571013e4860 } [07:59:36.408] estate = 0x55710334fe10 [07:59:36.408] operation = CMD_MERGE [07:59:36.408] resultRelInfo = 0x5571033503c0 [07:59:36.408] subplanstate = 0x557103350af0 [07:59:36.408] slot = [07:59:36.408] oldSlot = [07:59:36.408] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 1}, ip_posid = 0} [07:59:36.408] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x5571033b6a78} [07:59:36.408] oldtuple = 0x7ffef48998a0 [07:59:36.408] tupleid = 0x0 [07:59:36.408] __func__ = "ExecModifyTable" [07:59:36.408] #8 0x00005571013f0ba1 in ExecProcNodeFirst (node=0x5571033501b0) at ../src/backend/executor/execProcnode.c:464 [07:59:36.408] No locals. [07:59:36.408] #9 0x00005571013dd29c in ExecProcNode (node=0x5571033501b0) at ../src/include/executor/executor.h:274 [07:59:36.408] No locals. [07:59:36.408] #10 ExecutePlan (estate=estate@entry=0x55710334fe10, planstate=0x5571033501b0, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55710331a2b0, execute_once=true) at ../src/backend/executor/execMain.c:1646 [07:59:36.408] slot = [07:59:36.408] current_tuple_count = 0 [07:59:36.408] #11 0x00005571013dd5e6 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x557103390f68, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [07:59:36.408] estate = 0x55710334fe10 [07:59:36.408] operation = CMD_MERGE [07:59:36.408] dest = 0x55710331a2b0 [07:59:36.408] sendTuples = true [07:59:36.408] oldcontext = 0x557103319fa0 [07:59:36.408] __func__ = "standard_ExecutorRun" [07:59:36.408] #12 0x00007fd3c74537fc in pgss_ExecutorRun (queryDesc=0x557103390f68, direction=ForwardScanDirection, count=0, execute_once=) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [07:59:36.408] _save_exception_stack = 0x7ffef4899c90 [07:59:36.408] _save_context_stack = 0x0 [07:59:36.408] _local_sigjmp_buf = {{__jmpbuf = {93943873736552, 4954701863147501771, 93943872434704, 93943873249968, 0, 0, 4954701863191541963, 4942916708162828491}, __mask_was_saved = 0, __saved_mask = {__val = {93943873469968, 93943873736552, 0, 93943873249184, 93943848022185, 0, 1, 0, 93943840679695, 93943873736552, 93943860525504, 93943873249184, 140547558036514, 93943873736552, 0, 93943872434704}}}} [07:59:36.408] _do_rethrow = false [07:59:36.408] #13 0x00005571013dd744 in ExecutorRun (queryDesc=queryDesc@entry=0x557103390f68, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:302 [07:59:36.408] No locals. [07:59:36.408] #14 0x0000557101803b50 in ProcessQuery (plan=plan@entry=0x557103406f40, sourceText=0x557103253210 "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"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x55710331a2b0, qc=qc@entry=0x7ffef4899bf0) at ../src/backend/tcop/pquery.c:160 [07:59:36.408] queryDesc = 0x557103390f68 [07:59:36.408] #15 0x000055710180589f in PortalRunMulti (portal=portal@entry=0x5571032d4f20, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55710331a2b0, altdest=0x557101ff1320 , qc=qc@entry=0x7ffef4899bf0) at ../src/backend/tcop/pquery.c:1277 [07:59:36.408] pstmt = 0x557103406f40 [07:59:36.408] stmtlist_item__state = {l = , i = } [07:59:36.408] active_snapshot_set = true [07:59:36.408] stmtlist_item = 0x557103407068 [07:59:36.408] #16 0x0000557101805f45 in FillPortalStore (portal=portal@entry=0x5571032d4f20, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [07:59:36.408] treceiver = 0x55710331a2b0 [07:59:36.408] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:36.408] __func__ = "FillPortalStore" [07:59:36.408] #17 0x00005571018065a4 in PortalRun (portal=portal@entry=0x5571032d4f20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5571034070a0, altdest=altdest@entry=0x5571034070a0, qc=0x7ffef4899dd0) at ../src/backend/tcop/pquery.c:763 [07:59:36.408] _save_exception_stack = 0x7ffef4899e80 [07:59:36.408] _save_context_stack = 0x0 [07:59:36.408] _local_sigjmp_buf = {{__jmpbuf = {1, -4954159680298452789, 93943874220192, 93943873675184, 93943872966432, 93943873675112, 4954701863124433099, 1287265350511851723}, __mask_was_saved = 0, __saved_mask = {__val = {93943872977992, 93943850831846, 93943872974640, 93943850831846, 1, 140733001080159, 93943873675160, 93943873675112, 93943847753384, 93943850414121, 93943872966432, 93943850831846, 1, 1, 93943848022185, 163}}}} [07:59:36.408] _do_rethrow = [07:59:36.408] result = [07:59:36.408] nprocessed = [07:59:36.408] saveTopTransactionResourceOwner = 0x5571032943f0 [07:59:36.408] saveTopTransactionContext = 0x55710327f800 [07:59:36.408] saveActivePortal = 0x0 [07:59:36.408] saveResourceOwner = 0x5571032943f0 [07:59:36.408] savePortalContext = 0x0 [07:59:36.408] saveMemoryContext = 0x55710327f800 [07:59:36.408] __func__ = "PortalRun" [07:59:36.408] #18 0x00005571017ff52d in exec_simple_query (query_string=query_string@entry=0x557103253210 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [07:59:36.408] cmdtaglen = 5 [07:59:36.408] snapshot_set = [07:59:36.408] per_parsetree_context = 0x0 [07:59:36.408] plantree_list = 0x557103407050 [07:59:36.408] parsetree = 0x557103381f68 [07:59:36.408] commandTag = [07:59:36.408] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:36.408] querytree_list = [07:59:36.408] portal = 0x5571032d4f20 [07:59:36.408] receiver = 0x5571034070a0 [07:59:36.408] format = 0 [07:59:36.408] cmdtagname = [07:59:36.408] parsetree_item__state = {l = , i = } [07:59:36.408] dest = DestRemote [07:59:36.408] oldcontext = 0x55710327f800 [07:59:36.408] parsetree_list = 0x557103381f98 [07:59:36.408] parsetree_item = 0x557103381fb0 [07:59:36.408] save_log_statement_stats = false [07:59:36.408] was_logged = true [07:59:36.408] use_implicit_block = false [07:59:36.408] msec_str = "0\240\211\364\376\177\000\000As\255\001qU\000\000`\236\211\364\376\177\000\000\026\001\000\000\000\000\000" [07:59:36.408] __func__ = "exec_simple_query" [07:59:36.408] #19 0x00005571018022eb in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [07:59:36.408] query_string = 0x557103253210 "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"... [07:59:36.408] firstchar = [07:59:36.408] input_message = {data = 0x557103253210 "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} [07:59:36.408] local_sigjmp_buf = {{__jmpbuf = {93943860525496, 1287271767458412747, 4, 140733001080880, 140733001081028, 1, 4954701863061518539, 1287265353934010571}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93943872409312, 16384, 8248, 93943847927288, 0, 0, 0, 93943860525504, 93943872409312, 93943860519576, 140733001080880, 140733001081028, 1, 93943847930338, 140733001080656}}}} [07:59:36.408] send_ready_for_query = false [07:59:36.408] idle_in_transaction_timeout_enabled = false [07:59:36.408] idle_session_timeout_enabled = false [07:59:36.408] __func__ = "PostgresMain" [07:59:36.408] #20 0x00005571017f8a8d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [07:59:36.408] bsdata = [07:59:36.408] #21 0x000055710169cd88 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffef4899fdc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffef489a030) at ../src/backend/postmaster/launch_backend.c:265 [07:59:36.408] pid = [07:59:36.408] #22 0x00005571016a30bb in BackendStartup (client_sock=client_sock@entry=0x7ffef489a030) at ../src/backend/postmaster/postmaster.c:3593 [07:59:36.408] bn = 0x55710327fd88 [07:59:36.408] pid = [07:59:36.408] startup_data = {canAcceptConnections = CAC_OK} [07:59:36.408] __func__ = "BackendStartup" [07:59:36.408] #23 0x00005571016a3669 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [07:59:36.408] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000\210\v\306\311\323\177\000\000 C\343\311\323\177\000\000\001\000\000\000\000\000\000\000\244\343]\313\323\177\000\000-\000\000\000\000\000\000\000\020\016\307\311\323\177\000\000 ٖ\312\323\177\000\000\b\241\211\364\376\177\000\000\004\241\211\364\376\177\000\000\220\341'\003qU", '\000' , "\020\016\307\311\323\177\000\000\340/\306\311\323\177\000", __ss_align = 140547601952746}, salen = 2}} [07:59:36.408] i = 0 [07:59:36.408] now = [07:59:36.408] last_lockfile_recheck_time = 1712562977 [07:59:36.408] last_touch_time = 1712562977 [07:59:36.408] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -192306736, events = 32766, fd = -907853024, user_data = 0x7ffef489a1c0}, {pos = 46, events = 0, fd = -882900608, user_data = 0xf489a190}, {pos = 0, events = 0, fd = -882900608, user_data = 0x59e7c8ee}, {pos = -896084088, events = 32723, fd = -907841558, user_data = 0x7ffef489a268}, {pos = -192306752, events = 32766, fd = -192306736, user_data = 0x7fd3cb5dece1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -949795304, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fd3ca96d420}, {pos = -192306800, events = 32766, fd = -949795304, user_data = 0x7fd3ca96d420}, {pos = 33622184, events = 1, fd = -896084088, user_data = 0x0}, {pos = 52947680, events = 21873, fd = 52966632, user_data = 0xffffffff}, {pos = -883018205, events = 32723, fd = -909757416, user_data = 0x7fd3ca96d920}, {pos = 52966600, events = 21873, fd = -909710856, user_data = 0x7ffef489a5b0}, {pos = -882989430, events = 32723, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = -907738888, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = 52777072, events = 21873, fd = -883018205, user_data = 0x1}, {pos = 0, events = 0, fd = 52965384, user_data = 0x7fd3c9c63418}, {pos = -192305664, events = 32766, fd = -882989430, user_data = 0x0}, {pos = 0, events = 0, fd = -192305632, user_data = 0x5571026e9760 }, {pos = 2, events = 0, fd = 40802144, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 8096, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x2020206c6c612020}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 52988104, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 52760448, user_data = 0x557103250f80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3730332f0a202020}, {pos = 895110154, events = 1160786802, fd = 0, user_data = 0x0}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 958406688, user_data = 0xa}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x400}, {pos = 52760448, events = 21873, fd = -907893632, user_data = 0x103250f80}, {pos = 784, events = 0, fd = 30623020, user_data = 0x557103283030}, {pos = -1697330944, events = 2598450277, fd = 4, user_data = 0x557103288890}, {pos = 52965424, events = 21873, fd = 52965624, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 52965624, user_data = 0x400}, {pos = 0, events = 0, fd = 28348284, user_data = 0x5571026f7970 }, {pos = 28274166, events = 21873, fd = 52965424, user_data = 0x557103253110}, {pos = 52965424, events = 21873, fd = 15, user_data = 0x4a}, {pos = 28350094, events = 21873, fd = 52965424, user_data = 0x557101b097d7 }, {pos = 52760448, events = 21873, fd = -909238994, user_data = 0x0}, {pos = 21706006, events = 21873, fd = 52939584, user_data = 0x7fd3c9cde1aa}, {pos = -192305480, events = 1, fd = 0, user_data = 0x7fd3c9cdc8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 28874, user_data = 0x7fd3c9d26b05 }, {pos = 0, events = 0, fd = -1697330944, user_data = 0x0}, {pos = 23710382, events = 21873, fd = 4194304, user_data = 0x557101af6c8a }, {pos = 52939584, events = 21873, fd = 52769040, user_data = 0x55710327cb40}, {pos = 1, events = 0, fd = 0, user_data = 0x557101b0968e }, {pos = 52939584, events = 21873, fd = 28350423, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5571014b30e9 }, {pos = 0, events = 0, fd = 21728959, user_data = 0xb}, {pos = 23732237, events = 21873, fd = 0, user_data = 0x0}} [07:59:36.408] nevents = 1 [07:59:36.408] __func__ = "ServerLoop" [07:59:36.408] #24 0x00005571016a508b in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55710324cde0) at ../src/backend/postmaster/postmaster.c:1372 [07:59:36.409] opt = [07:59:36.409] status = [07:59:36.409] userDoption = [07:59:36.409] listen_addr_saved = false [07:59:36.409] output_config_variable = [07:59:36.409] __func__ = "PostmasterMain" [07:59:36.409] #25 0x00005571014c474c in main (argc=4, argv=0x55710324cde0) at ../src/backend/main/main.c:197 [07:59:36.409] do_check_root =