[21:35:58.075] src/tools/ci/cores_backtrace.sh linux /tmp/cores [21:35:58.826] dumping /tmp/cores/postgres-6-21887.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:36:00.568] [New LWP 21887] [21:36:00.568] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [21:36:01.342] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [21:36:02.115] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [21:36:03.354] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [21:36:05.740] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [21:36:05.740] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [21:36:07.652] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [21:36:08.889] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [21:36:10.507] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [21:36:11.601] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [21:36:12.369] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [21:36:13.604] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [21:36:15.227] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [21:36:16.641] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [21:36:17.556] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [21:36:19.095] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [21:36:20.495] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [21:36:20.970] [Thread debugging using libthread_db enabled] [21:36:20.970] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [21:36:22.046] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [21:36:23.461] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [21:36:24.543] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [21:36:25.176] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [21:36:25.963] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [21:36:28.307] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [21:36:29.258] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [21:36:30.038] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [21:36:30.976] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [21:36:31.923] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [21:36:33.531] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [21:36:34.617] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [21:36:35.402] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [21:36:36.818] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [21:36:37.438] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [21:36:39.000] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [21:36:39.789] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [21:36:41.045] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [21:36:41.833] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [21:36:42.933] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [21:36:43.869] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [21:36:45.118] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [21:36:45.751] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [21:36:46.700] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [21:36:47.484] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [21:36:48.002] Core was generated by `postgres: postgres regression [local] MERGE '. [21:36:48.002] Program terminated with signal SIGABRT, Aborted. [21:36:48.002] #0 0x00007f674c0ddce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:48.347] [21:36:48.347] Thread 1 (Thread 0x7f6749a74a40 (LWP 21887)): [21:36:48.347] #0 0x00007f674c0ddce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:48.347] No symbol table info available. [21:36:48.347] #1 0x00007f674c0c7537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:48.347] No symbol table info available. [21:36:48.347] #2 0x000055d21892997e in ExceptionalCondition (conditionName=conditionName@entry=0x55d218b7e3f8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x55d218ba2db8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:36:48.347] No locals. [21:36:48.347] #3 0x000055d21827b453 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fff825e75d0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fff825e746f) at ../src/backend/executor/execTuples.c:1737 [21:36:48.347] No locals. [21:36:48.347] #4 0x000055d2181fee36 in ExecIRDeleteTriggers (estate=estate@entry=0x55d21abb4180, relinfo=relinfo@entry=0x55d21abb4730, slot=slot@entry=0x7fff825e75d0) at ../src/backend/commands/trigger.c:2841 [21:36:48.347] trigger = 0x55d21abb4990 [21:36:48.347] oldtuple = [21:36:48.347] trigdesc = 0x55d21abb4940 [21:36:48.347] newtuple = 0x0 [21:36:48.347] should_free = false [21:36:48.347] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f67407b0f18, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:36:48.347] i = 0 [21:36:48.347] #5 0x000055d2182de367 in ExecMergeMatched (context=0x7fff825e75f0, resultRelInfo=resultRelInfo@entry=0x55d21abb4730, tupleid=0x0, oldtuple=0x7fff825e75d0, canSetTag=true, matched=matched@entry=0x7fff825e757f) at ../src/backend/executor/nodeModifyTable.c:3027 [21:36:48.347] relaction = 0x55d21accf958 [21:36:48.347] commandType = CMD_DELETE [21:36:48.347] result = TM_Ok [21:36:48.347] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:36:48.347] l__state = {l = , i = } [21:36:48.347] mtstate = 0x55d21abb4520 [21:36:48.347] mergeActions = 0x55d21abb4840 [21:36:48.347] actionStates = 0x55d21accff18 [21:36:48.347] newslot = 0x0 [21:36:48.347] rslot = 0x0 [21:36:48.347] estate = 0x55d21abb4180 [21:36:48.347] econtext = 0x55d21accef68 [21:36:48.347] isNull = false [21:36:48.347] epqstate = 0x55d21abb4608 [21:36:48.347] l = [21:36:48.347] __func__ = "ExecMergeMatched" [21:36:48.347] lmerge_matched = [21:36:48.347] #6 0x000055d2182df44f in ExecMerge (context=context@entry=0x7fff825e75f0, resultRelInfo=resultRelInfo@entry=0x55d21abb4730, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fff825e75d0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:36:48.347] rslot = 0x0 [21:36:48.347] matched = true [21:36:48.347] #7 0x000055d2182e11a6 in ExecModifyTable (pstate=0x55d21abb4520) at ../src/backend/executor/nodeModifyTable.c:4112 [21:36:48.347] node = 0x55d21abb4520 [21:36:48.347] context = {mtstate = 0x55d21abb4520, epqstate = 0x55d21abb4608, estate = 0x55d21abb4180, planSlot = 0x55d21accd978, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 405110826, cmax = 21970, traversed = 136}, cpUpdateReturningSlot = 0x55d21aca34f0} [21:36:48.347] estate = 0x55d21abb4180 [21:36:48.347] operation = CMD_MERGE [21:36:48.347] resultRelInfo = 0x55d21abb4730 [21:36:48.347] subplanstate = 0x55d21abb4e60 [21:36:48.347] slot = [21:36:48.347] oldSlot = [21:36:48.347] tuple_ctid = {ip_blkid = {bi_hi = 6858, bi_lo = 21970}, ip_posid = 0} [21:36:48.347] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x55d21ac1cde8} [21:36:48.347] oldtuple = 0x7fff825e75d0 [21:36:48.347] tupleid = 0x0 [21:36:48.347] __func__ = "ExecModifyTable" [21:36:48.347] #8 0x000055d21826d61e in ExecProcNodeFirst (node=0x55d21abb4520) at ../src/backend/executor/execProcnode.c:464 [21:36:48.347] No locals. [21:36:48.347] #9 0x000055d218259d19 in ExecProcNode (node=0x55d21abb4520) at ../src/include/executor/executor.h:274 [21:36:48.347] No locals. [21:36:48.347] #10 ExecutePlan (estate=estate@entry=0x55d21abb4180, planstate=0x55d21abb4520, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55d21ac3fa50, execute_once=true) at ../src/backend/executor/execMain.c:1646 [21:36:48.347] slot = [21:36:48.347] current_tuple_count = 0 [21:36:48.347] #11 0x000055d21825a063 in standard_ExecutorRun (queryDesc=0x55d21abfb238, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [21:36:48.347] estate = 0x55d21abb4180 [21:36:48.347] operation = CMD_MERGE [21:36:48.347] dest = 0x55d21ac3fa50 [21:36:48.347] sendTuples = true [21:36:48.347] oldcontext = 0x55d21ac3f740 [21:36:48.347] __func__ = "standard_ExecutorRun" [21:36:48.347] #12 0x000055d21825a1ce in ExecutorRun (queryDesc=queryDesc@entry=0x55d21abfb238, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [21:36:48.347] No locals. [21:36:48.347] #13 0x000055d21867f612 in ProcessQuery (plan=plan@entry=0x55d21aca63f8, sourceText=0x55d21aab11e0 "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=0x55d21ac3fa50, qc=qc@entry=0x7fff825e7810) at ../src/backend/tcop/pquery.c:160 [21:36:48.347] queryDesc = 0x55d21abfb238 [21:36:48.347] #14 0x000055d218681361 in PortalRunMulti (portal=portal@entry=0x55d21ab31f10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55d21ac3fa50, altdest=0x55d218e67380 , qc=qc@entry=0x7fff825e7810) at ../src/backend/tcop/pquery.c:1277 [21:36:48.347] pstmt = 0x55d21aca63f8 [21:36:48.347] stmtlist_item__state = {l = , i = } [21:36:48.347] active_snapshot_set = true [21:36:48.347] stmtlist_item = 0x55d21aca6520 [21:36:48.347] #15 0x000055d218681a07 in FillPortalStore (portal=portal@entry=0x55d21ab31f10, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [21:36:48.347] treceiver = 0x55d21ac3fa50 [21:36:48.347] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:36:48.347] __func__ = "FillPortalStore" [21:36:48.347] #16 0x000055d218682066 in PortalRun (portal=portal@entry=0x55d21ab31f10, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d21aca6558, altdest=altdest@entry=0x55d21aca6558, qc=0x7fff825e79f0) at ../src/backend/tcop/pquery.c:763 [21:36:48.347] _save_exception_stack = 0x7fff825e7aa0 [21:36:48.347] _save_context_stack = 0x0 [21:36:48.347] _local_sigjmp_buf = {{__jmpbuf = {1, -1585485866121293117, 94360880964952, 94360880175152, 94360879439632, 94360880175080, 1585334953912046275, 4781426224518271683}, __mask_was_saved = 0, __saved_mask = {__val = {94360879451192, 94360846933918, 94360879447840, 94360846933918, 1, 140735380617599, 94360880175128, 94360880175080, 94360843866309, 94360846519497, 94360879439632, 94360846933918, 1, 1, 94360844135148, 163}}}} [21:36:48.347] _do_rethrow = [21:36:48.347] result = [21:36:48.347] nprocessed = [21:36:48.347] saveTopTransactionResourceOwner = 0x55d21aaf0bd8 [21:36:48.347] saveTopTransactionContext = 0x55d21aad9af0 [21:36:48.347] saveActivePortal = 0x0 [21:36:48.347] saveResourceOwner = 0x55d21aaf0bd8 [21:36:48.347] savePortalContext = 0x0 [21:36:48.347] saveMemoryContext = 0x55d21aad9af0 [21:36:48.347] __func__ = "PortalRun" [21:36:48.347] #17 0x000055d21867afef in exec_simple_query (query_string=query_string@entry=0x55d21aab11e0 "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 [21:36:48.347] cmdtaglen = 5 [21:36:48.347] snapshot_set = [21:36:48.347] per_parsetree_context = 0x0 [21:36:48.347] plantree_list = 0x55d21aca6508 [21:36:48.347] parsetree = 0x55d21abe57e8 [21:36:48.347] commandTag = [21:36:48.347] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:36:48.347] querytree_list = [21:36:48.347] portal = 0x55d21ab31f10 [21:36:48.347] receiver = 0x55d21aca6558 [21:36:48.347] format = 0 [21:36:48.347] cmdtagname = [21:36:48.347] parsetree_item__state = {l = , i = } [21:36:48.347] dest = DestRemote [21:36:48.347] oldcontext = 0x55d21aad9af0 [21:36:48.347] parsetree_list = 0x55d21abe5818 [21:36:48.347] parsetree_item = 0x55d21abe5830 [21:36:48.347] save_log_statement_stats = false [21:36:48.347] was_logged = false [21:36:48.347] use_implicit_block = false [21:36:48.347] msec_str = "P|^\202\377\177\000\000^-\225\030\322U\000\000\200z^\202\377\177\000\000\026\001\000\000\000\000\000" [21:36:48.347] __func__ = "exec_simple_query" [21:36:48.347] #18 0x000055d21867ddad in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [21:36:48.347] query_string = 0x55d21aab11e0 "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"... [21:36:48.347] firstchar = [21:36:48.347] input_message = {data = 0x55d21aab11e0 "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} [21:36:48.347] local_sigjmp_buf = {{__jmpbuf = {94360856607064, 4781428263747588803, 4, 140735380618320, 140735380618468, 1, 1585334953974960835, 4781426213579920067}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140081634651620, 94360878886544, 15616, 15680, 94360844038506, 94360856607072, 94360878886544, 94360856601144, 140735380618320, 140735380618468, 94360844042574, 140735380618096}}}} [21:36:48.347] send_ready_for_query = false [21:36:48.347] idle_in_transaction_timeout_enabled = false [21:36:48.347] idle_session_timeout_enabled = false [21:36:48.347] __func__ = "PostgresMain" [21:36:48.347] #19 0x000055d21867454f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:36:48.347] bsdata = [21:36:48.347] #20 0x000055d2185188bd in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff825e7bfc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff825e7c50) at ../src/backend/postmaster/launch_backend.c:265 [21:36:48.347] pid = [21:36:48.347] #21 0x000055d21851ebeb in BackendStartup (client_sock=client_sock@entry=0x7fff825e7c50) at ../src/backend/postmaster/postmaster.c:3593 [21:36:48.347] bn = 0x55d21aad9c68 [21:36:48.347] pid = [21:36:48.347] startup_data = {canAcceptConnections = CAC_OK} [21:36:48.347] __func__ = "BackendStartup" [21:36:48.347] #22 0x000055d21851f199 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:36:48.347] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\242Mg\177\000\000-\000\000\000\000\000\000\000\020n\vLg\177\000\000 9\333Lg\177\000\000\b}^\202\377\177\000\000\004}^\202\377\177\000\000\304|^\202\377\177\000\000@ުIg\177\000\000\000\000\000\000\377\177\000\000\020n\vLg\177\000\000\340\217\nLg\177\000\000\352\317'Lg\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\004}^\202\377\177\000", __ss_align = 140081594293824}, salen = 2}} [21:36:48.347] i = 0 [21:36:48.347] now = [21:36:48.347] last_lockfile_recheck_time = 1713735162 [21:36:48.347] last_touch_time = 1713735162 [21:36:48.347] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -2107736704, events = 32767, fd = -2107736688, user_data = 0x0}, {pos = 18, events = 0, fd = 1508362478, user_data = 0x7f674cdb3788}, {pos = 1277677546, events = 32615, fd = -2107736472, user_data = 0x7fff825e7dc0}, {pos = -2107736624, events = 32767, fd = 1302482145, user_data = 0x12}, {pos = 1235723800, events = 32615, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1289434144, user_data = 0xffffffff}, {pos = 1235723800, events = 32615, fd = 1289434144, user_data = 0x14cdb3920}, {pos = 1289435016, events = 32615, fd = 0, user_data = 0x7fff825e7ede}, {pos = -2107736368, events = 32767, fd = -1, user_data = 0x7fff825e7de0}, {pos = 1275761688, events = 32615, fd = 1289435424, user_data = 0x55d21aadeb88}, {pos = 447596168, events = 21970, fd = 447572336, user_data = 0x55d21aadeba8}, {pos = 447605473, events = 21970, fd = 1302500899, user_data = 0x1}, {pos = 1277780216, events = 32615, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x55d21aab2fb0}, {pos = 1302500899, events = 32615, fd = 1, user_data = 0x0}, {pos = 447572336, events = 21970, fd = 1275761688, user_data = 0x7fff825e8220}, {pos = 1302529674, events = 32615, fd = 0, user_data = 0x0}, {pos = -2107735488, events = 32767, fd = 425056000, user_data = 0x2}, {pos = 425056000, events = 21970, fd = 0, user_data = 0x7f674c273be0}, {pos = 255, events = 0, fd = 7, user_data = 0x0}, {pos = 8096, events = 196607, 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 = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 447599384, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = 0, events = 4294967040, fd = -1, user_data = 0x737365726765725f}, {pos = 1481131821, events = 173300044, fd = 762540901, user_data = 0x362020200a0a5459}, {pos = 822763892, events = 926101815, fd = 909194547, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 874520608, events = 10, 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 = 1277622400, user_data = 0x7f674c12251a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = 1276279803, user_data = 0x400}, {pos = 447409968, events = 21970, fd = 1277625472, user_data = 0x11aaaef30}, {pos = 784, events = 0, fd = 414900780, user_data = 0x55d21aadc360}, {pos = 556350720, events = 3740420069, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 447595360, events = 21970, fd = 447595360, user_data = 0x55d21aadc360}, {pos = 1, events = 0, fd = 447595560, user_data = 0x400}, {pos = 0, events = 0, fd = 412633535, user_data = 0x55d21956b910 }, {pos = 412559379, events = 21970, fd = 447595360, user_data = 0x55d21aab10e0}, {pos = 447595360, events = 21970, fd = 15, user_data = 0x4a}, {pos = 412635345, events = 21970, fd = 447595360, user_data = 0x55d21898521a }, {pos = 447409968, events = 21970, fd = 1276279803, user_data = 0x0}, {pos = 405995898, events = 21970, fd = 447583968, user_data = 0x7f674c1241aa}, {pos = -2107735336, events = 1, fd = 0, user_data = 0x7f674c1228f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 19355, user_data = 0x7f674c16cb05 }, {pos = 0, events = 0, fd = 556350720, user_data = 0x0}, {pos = 407995875, events = 21970, fd = 4194304, user_data = 0x55d2189726a7 }, {pos = 447583968, events = 21970, fd = 447418592, user_data = 0x55d21aad96e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55d2189850d1 }, {pos = 447583968, events = 21970, fd = 412635674, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55d21832fd4d }, {pos = 0, events = 0, fd = 406018851, user_data = 0xb}, {pos = 408017725, events = 21970, fd = 0, user_data = 0x0}} [21:36:48.348] nevents = 1 [21:36:48.348] __func__ = "ServerLoop" [21:36:48.348] #23 0x000055d218520bbb in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55d21aaaadf0) at ../src/backend/postmaster/postmaster.c:1372 [21:36:48.348] opt = [21:36:48.348] status = [21:36:48.348] userDoption = [21:36:48.348] listen_addr_saved = false [21:36:48.348] output_config_variable = [21:36:48.348] __func__ = "PostmasterMain" [21:36:48.348] #24 0x000055d2183413b0 in main (argc=8, argv=0x55d21aaaadf0) at ../src/backend/main/main.c:197 [21:36:48.348] do_check_root = [21:36:48.373] -e [21:36:48.373] [21:36:48.373] [21:36:48.940] dumping /tmp/cores/postgres-6-22302.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:36:49.288] [New LWP 22302] [21:36:50.489] [Thread debugging using libthread_db enabled] [21:36:50.489] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [21:36:51.967] Core was generated by `postgres: old_node: postgres regression [local] MERGE '. [21:36:51.967] Program terminated with signal SIGABRT, Aborted. [21:36:51.967] #0 0x00007f420dbface1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:52.310] [21:36:52.310] Thread 1 (Thread 0x7f420b591a40 (LWP 22302)): [21:36:52.310] #0 0x00007f420dbface1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:52.310] No symbol table info available. [21:36:52.310] #1 0x00007f420dbe4537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:52.310] No symbol table info available. [21:36:52.310] #2 0x00005595d80ad97e in ExceptionalCondition (conditionName=conditionName@entry=0x5595d83023f8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x5595d8326db8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:36:52.310] No locals. [21:36:52.310] #3 0x00005595d79ff453 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffc50370b00, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffc5037099f) at ../src/backend/executor/execTuples.c:1737 [21:36:52.310] No locals. [21:36:52.310] #4 0x00005595d7982e36 in ExecIRDeleteTriggers (estate=estate@entry=0x5595da1fa8a0, relinfo=relinfo@entry=0x5595da1fae50, slot=slot@entry=0x7ffc50370b00) at ../src/backend/commands/trigger.c:2841 [21:36:52.310] trigger = 0x5595da1fb0b0 [21:36:52.310] oldtuple = [21:36:52.310] trigdesc = 0x5595da1fb060 [21:36:52.310] newtuple = 0x0 [21:36:52.310] should_free = false [21:36:52.310] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f42025eb858, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:36:52.310] i = 0 [21:36:52.310] #5 0x00005595d7a62367 in ExecMergeMatched (context=0x7ffc50370b20, resultRelInfo=resultRelInfo@entry=0x5595da1fae50, tupleid=0x0, oldtuple=0x7ffc50370b00, canSetTag=true, matched=matched@entry=0x7ffc50370aaf) at ../src/backend/executor/nodeModifyTable.c:3027 [21:36:52.310] relaction = 0x5595da240cd8 [21:36:52.310] commandType = CMD_DELETE [21:36:52.310] result = TM_Ok [21:36:52.310] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:36:52.310] l__state = {l = , i = } [21:36:52.310] mtstate = 0x5595da1fac40 [21:36:52.310] mergeActions = 0x5595da1faf60 [21:36:52.310] actionStates = 0x5595da241298 [21:36:52.310] newslot = 0x0 [21:36:52.310] rslot = 0x0 [21:36:52.310] estate = 0x5595da1fa8a0 [21:36:52.310] econtext = 0x5595da2402e8 [21:36:52.310] isNull = false [21:36:52.310] epqstate = 0x5595da1fad28 [21:36:52.310] l = [21:36:52.310] __func__ = "ExecMergeMatched" [21:36:52.310] lmerge_matched = [21:36:52.310] #6 0x00005595d7a6344f in ExecMerge (context=context@entry=0x7ffc50370b20, resultRelInfo=resultRelInfo@entry=0x5595da1fae50, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffc50370b00, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:36:52.310] rslot = 0x0 [21:36:52.310] matched = true [21:36:52.310] #7 0x00005595d7a651a6 in ExecModifyTable (pstate=0x5595da1fac40) at ../src/backend/executor/nodeModifyTable.c:4112 [21:36:52.310] node = 0x5595da1fac40 [21:36:52.310] context = {mtstate = 0x5595da1fac40, epqstate = 0x5595da1fad28, estate = 0x5595da1fa8a0, planSlot = 0x5595da23ecf8, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 3617439786, cmax = 21909, traversed = 136}, cpUpdateReturningSlot = 0x5595da2e93f0} [21:36:52.310] estate = 0x5595da1fa8a0 [21:36:52.310] operation = CMD_MERGE [21:36:52.310] resultRelInfo = 0x5595da1fae50 [21:36:52.310] subplanstate = 0x5595da1fb580 [21:36:52.310] slot = [21:36:52.310] oldSlot = [21:36:52.310] tuple_ctid = {ip_blkid = {bi_hi = 55854, bi_lo = 21909}, ip_posid = 0} [21:36:52.310] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x5595da263508} [21:36:52.310] oldtuple = 0x7ffc50370b00 [21:36:52.310] tupleid = 0x0 [21:36:52.310] __func__ = "ExecModifyTable" [21:36:52.310] #8 0x00005595d79f161e in ExecProcNodeFirst (node=0x5595da1fac40) at ../src/backend/executor/execProcnode.c:464 [21:36:52.310] No locals. [21:36:52.310] #9 0x00005595d79ddd19 in ExecProcNode (node=0x5595da1fac40) at ../src/include/executor/executor.h:274 [21:36:52.310] No locals. [21:36:52.310] #10 ExecutePlan (estate=estate@entry=0x5595da1fa8a0, planstate=0x5595da1fac40, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x5595da285950, execute_once=true) at ../src/backend/executor/execMain.c:1646 [21:36:52.310] slot = [21:36:52.310] current_tuple_count = 0 [21:36:52.310] #11 0x00005595d79de063 in standard_ExecutorRun (queryDesc=0x5595da319e48, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [21:36:52.310] estate = 0x5595da1fa8a0 [21:36:52.310] operation = CMD_MERGE [21:36:52.310] dest = 0x5595da285950 [21:36:52.310] sendTuples = true [21:36:52.310] oldcontext = 0x5595da285640 [21:36:52.310] __func__ = "standard_ExecutorRun" [21:36:52.310] #12 0x00005595d79de1ce in ExecutorRun (queryDesc=queryDesc@entry=0x5595da319e48, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [21:36:52.310] No locals. [21:36:52.310] #13 0x00005595d7e03612 in ProcessQuery (plan=plan@entry=0x5595da2ec2f8, sourceText=0x5595da0f71d0 "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=0x5595da285950, qc=qc@entry=0x7ffc50370d40) at ../src/backend/tcop/pquery.c:160 [21:36:52.310] queryDesc = 0x5595da319e48 [21:36:52.310] #14 0x00005595d7e05361 in PortalRunMulti (portal=portal@entry=0x5595da17aed0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5595da285950, altdest=0x5595d85eb380 , qc=qc@entry=0x7ffc50370d40) at ../src/backend/tcop/pquery.c:1277 [21:36:52.310] pstmt = 0x5595da2ec2f8 [21:36:52.310] stmtlist_item__state = {l = , i = } [21:36:52.310] active_snapshot_set = true [21:36:52.310] stmtlist_item = 0x5595da2ec420 [21:36:52.310] #15 0x00005595d7e05a07 in FillPortalStore (portal=portal@entry=0x5595da17aed0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [21:36:52.310] treceiver = 0x5595da285950 [21:36:52.310] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:36:52.310] __func__ = "FillPortalStore" [21:36:52.310] #16 0x00005595d7e06066 in PortalRun (portal=portal@entry=0x5595da17aed0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5595da2ec458, altdest=altdest@entry=0x5595da2ec458, qc=0x7ffc50370f20) at ../src/backend/tcop/pquery.c:763 [21:36:52.310] _save_exception_stack = 0x7ffc50370fd0 [21:36:52.310] _save_context_stack = 0x0 [21:36:52.310] _local_sigjmp_buf = {{__jmpbuf = {1, -5727447337709274577, 94102098986072, 94102099162000, 94102097473232, 94102099161928, 5727633780679965231, 1995001440162216495}, __mask_was_saved = 0, __saved_mask = {__val = {94102097484792, 94102066257822, 94102097481440, 94102066257822, 1, 140721654271663, 94102099161976, 94102099161928, 94102063190213, 94102065843401, 94102097473232, 94102066257822, 1, 1, 94102063459052, 163}}}} [21:36:52.310] _do_rethrow = [21:36:52.310] result = [21:36:52.310] nprocessed = [21:36:52.310] saveTopTransactionResourceOwner = 0x5595da138088 [21:36:52.310] saveTopTransactionContext = 0x5595da1d12d0 [21:36:52.310] saveActivePortal = 0x0 [21:36:52.310] saveResourceOwner = 0x5595da138088 [21:36:52.310] savePortalContext = 0x0 [21:36:52.310] saveMemoryContext = 0x5595da1d12d0 [21:36:52.310] __func__ = "PortalRun" [21:36:52.310] #17 0x00005595d7dfefef in exec_simple_query (query_string=query_string@entry=0x5595da0f71d0 "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 [21:36:52.310] cmdtaglen = 5 [21:36:52.310] snapshot_set = [21:36:52.310] per_parsetree_context = 0x0 [21:36:52.310] plantree_list = 0x5595da2ec408 [21:36:52.310] parsetree = 0x5595da317348 [21:36:52.310] commandTag = [21:36:52.310] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:36:52.310] querytree_list = [21:36:52.310] portal = 0x5595da17aed0 [21:36:52.310] receiver = 0x5595da2ec458 [21:36:52.310] format = 0 [21:36:52.310] cmdtagname = [21:36:52.310] parsetree_item__state = {l = , i = } [21:36:52.310] dest = DestRemote [21:36:52.310] oldcontext = 0x5595da1d12d0 [21:36:52.310] parsetree_list = 0x5595da317378 [21:36:52.310] parsetree_item = 0x5595da317390 [21:36:52.310] save_log_statement_stats = false [21:36:52.310] was_logged = true [21:36:52.310] use_implicit_block = false [21:36:52.310] msec_str = "\200\021\067P\374\177\000\000^m\rؕU\000\000\260\017\067P\374\177\000\000\026\001\000\000\000\000\000" [21:36:52.310] __func__ = "exec_simple_query" [21:36:52.310] #18 0x00005595d7e01dad in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [21:36:52.310] query_string = 0x5595da0f71d0 "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"... [21:36:52.310] firstchar = [21:36:52.310] input_message = {data = 0x5595da0f71d0 "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} [21:36:52.310] local_sigjmp_buf = {{__jmpbuf = {94102075930968, 1995012584622062127, 4, 140721654272384, 140721654272532, 1, 5727633780617050671, 1995001442511419951}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 139921675550180, 94102096907936, 14336, 14400, 94102063362410, 94102075930976, 94102096907936, 94102075925048, 140721654272384, 140721654272532, 94102063366478, 140721654272160}}}} [21:36:52.310] send_ready_for_query = false [21:36:52.310] idle_in_transaction_timeout_enabled = false [21:36:52.310] idle_session_timeout_enabled = false [21:36:52.310] __func__ = "PostgresMain" [21:36:52.310] #19 0x00005595d7df854f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:36:52.310] bsdata = [21:36:52.310] #20 0x00005595d7c9c8bd in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc5037112c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc50371180) at ../src/backend/postmaster/launch_backend.c:265 [21:36:52.310] pid = [21:36:52.310] #21 0x00005595d7ca2beb in BackendStartup (client_sock=client_sock@entry=0x7ffc50371180) at ../src/backend/postmaster/postmaster.c:3593 [21:36:52.310] bn = 0x5595da12d4f8 [21:36:52.310] pid = [21:36:52.310] startup_data = {canAcceptConnections = CAC_OK} [21:36:52.310] __func__ = "BackendStartup" [21:36:52.310] #22 0x00005595d7ca3199 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:36:52.310] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\331\rB\177\000\000\001\000\000\000\000\000\000\000\244\023T\017B\177\000\000-\000\000\000\000\000\000\000\020>\275\rB\177\000\000 \t\215\016B\177\000\000H\022\067P\374\177\000\000D\022\067P\374\177\000\000\004\022\067P\374\177\000\000@\256\000\000\001\000\000\000\000\000\000\000\225U\000\000\020>\275\rB\177\000\000\340_\274\rB\177\000\000\352\237\331\rB\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [21:36:52.310] i = 0 [21:36:52.310] now = [21:36:52.310] last_lockfile_recheck_time = 1713735164 [21:36:52.310] last_touch_time = 1713735164 [21:36:52.310] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1345786624, events = 32764, fd = 45, user_data = 0x7ffc503712c0}, {pos = 1345786576, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 244123528, user_data = 0x7f420dd99fea}, {pos = 1345786792, events = 32764, fd = 1345786624, user_data = 0x7ffc50371310}, {pos = 257170657, events = 32578, fd = 18, user_data = 0x7f420b597618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 244122656, events = 32578, fd = -1, user_data = 0x7f420b597618}, {pos = 244122656, events = 32578, fd = 1024, user_data = 0x7f420e8d0788}, {pos = 0, events = 0, fd = 7, user_data = 0x7ffc50371310}, {pos = -1, events = 0, fd = 231230650, user_data = 0x7f420dbc6418}, {pos = 244123936, events = 32578, fd = -636353672, user_data = 0x5595da120208}, {pos = -636346352, events = 21909, fd = -636353640, user_data = 0x5595da1212f1}, {pos = 257189411, events = 32578, fd = 1, user_data = 0x7f420ddb30f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -636514448, user_data = 0x7f420f546623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x5595da122010}, {pos = 230450200, events = 32578, fd = 1345787728, user_data = 0x7f420f54d68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffc50371770}, {pos = -657582336, events = 21909, fd = 2, user_data = 0x5595d8ce1700 }, {pos = 0, events = 0, fd = 7, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x2ffff00001fa0}, {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 = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -636353752, user_data = 0x3ff}, {pos = 4096, 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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x3732303736202020}, {pos = 538976313, events = 538976288, 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 = 7, events = 0, fd = 230968622, user_data = 0x400}, {pos = -636530880, events = 21909, fd = 232313984, user_data = 0x1da0f4f40}, {pos = 784, events = 0, fd = -667737556, user_data = 0x5595da11fee0}, {pos = -957618432, events = 3112994925, fd = 4, user_data = 0x5595da1202f0}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5595da11fee0}, {pos = 1, events = 0, fd = -636354648, user_data = 0x400}, {pos = 0, events = 0, fd = -670004801, user_data = 0x5595d8cef910 }, {pos = -670078957, events = 21909, fd = -636354848, user_data = 0x5595da0f70d0}, {pos = -636354848, events = 21909, fd = 15, user_data = 0x4a}, {pos = -670002991, events = 21909, fd = -636354848, user_data = 0x5595d810921a }, {pos = -636530880, events = 21909, fd = 230968622, user_data = 0x0}, {pos = -676642438, events = 21909, fd = -636360000, user_data = 0x7f420dc411aa}, {pos = 1345787912, events = 1, fd = 0, user_data = 0x7f420dc3f8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 19919, user_data = 0x7f420dc89b05 }, {pos = 0, events = 0, fd = -957618432, user_data = 0x0}, {pos = -674642461, events = 21909, fd = 4194304, user_data = 0x5595d80f66a7 }, {pos = -636360000, events = 21909, fd = -636522288, user_data = 0x5595da11eac0}, {pos = 1, events = 0, fd = 0, user_data = 0x5595d81090d1 }, {pos = -636360000, events = 21909, fd = -670002662, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5595d7ab3d4d }, {pos = 0, events = 0, fd = -676619485, user_data = 0xb}, {pos = -674620611, events = 21909, fd = 0, user_data = 0x0}} [21:36:52.311] nevents = 1 [21:36:52.311] __func__ = "ServerLoop" [21:36:52.311] #23 0x00005595d7ca4bbb in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5595da0f0db0) at ../src/backend/postmaster/postmaster.c:1372 [21:36:52.311] opt = [21:36:52.311] status = [21:36:52.311] userDoption = [21:36:52.311] listen_addr_saved = false [21:36:52.311] output_config_variable = [21:36:52.311] __func__ = "PostmasterMain" [21:36:52.311] #24 0x00005595d7ac53b0 in main (argc=4, argv=0x5595da0f0db0) at ../src/backend/main/main.c:197 [21:36:52.311] do_check_root = [21:36:52.334] -e [21:36:52.334] [21:36:52.334] [21:36:52.900] dumping /tmp/cores/postgres-6-28427.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:36:53.223] [New LWP 28427] [21:36:54.412] [Thread debugging using libthread_db enabled] [21:36:54.412] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [21:36:55.875] Core was generated by `postgres: primary: postgres regression [local] MERGE '. [21:36:55.875] Program terminated with signal SIGABRT, Aborted. [21:36:55.875] #0 0x00007fb170eedce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:56.279] [21:36:56.279] Thread 1 (Thread 0x7fb16e884a40 (LWP 28427)): [21:36:56.279] #0 0x00007fb170eedce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:56.279] No symbol table info available. [21:36:56.279] #1 0x00007fb170ed7537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:56.279] No symbol table info available. [21:36:56.279] #2 0x000056549cf9697e in ExceptionalCondition (conditionName=conditionName@entry=0x56549d1eb3f8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x56549d20fdb8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:36:56.279] No locals. [21:36:56.279] #3 0x000056549c8e8453 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffc9c0cfaf0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffc9c0cf98f) at ../src/backend/executor/execTuples.c:1737 [21:36:56.279] No locals. [21:36:56.279] #4 0x000056549c86be36 in ExecIRDeleteTriggers (estate=estate@entry=0x56549fb59900, relinfo=relinfo@entry=0x56549fb59eb0, slot=slot@entry=0x7ffc9c0cfaf0) at ../src/backend/commands/trigger.c:2841 [21:36:56.279] trigger = 0x56549fb5a110 [21:36:56.279] oldtuple = [21:36:56.279] trigdesc = 0x56549fb5a0c0 [21:36:56.279] newtuple = 0x0 [21:36:56.279] should_free = false [21:36:56.279] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fb16ca65a68, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:36:56.279] i = 0 [21:36:56.279] #5 0x000056549c94b367 in ExecMergeMatched (context=0x7ffc9c0cfb10, resultRelInfo=resultRelInfo@entry=0x56549fb59eb0, tupleid=0x0, oldtuple=0x7ffc9c0cfaf0, canSetTag=true, matched=matched@entry=0x7ffc9c0cfa9f) at ../src/backend/executor/nodeModifyTable.c:3027 [21:36:56.279] relaction = 0x56549fb9e818 [21:36:56.279] commandType = CMD_DELETE [21:36:56.279] result = TM_Ok [21:36:56.279] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:36:56.279] l__state = {l = , i = } [21:36:56.279] mtstate = 0x56549fb59ca0 [21:36:56.279] mergeActions = 0x56549fb59fc0 [21:36:56.279] actionStates = 0x56549fb9edd8 [21:36:56.279] newslot = 0x0 [21:36:56.279] rslot = 0x0 [21:36:56.279] estate = 0x56549fb59900 [21:36:56.279] econtext = 0x56549fb9de28 [21:36:56.279] isNull = false [21:36:56.279] epqstate = 0x56549fb59d88 [21:36:56.279] l = [21:36:56.279] __func__ = "ExecMergeMatched" [21:36:56.279] lmerge_matched = [21:36:56.279] #6 0x000056549c94c44f in ExecMerge (context=context@entry=0x7ffc9c0cfb10, resultRelInfo=resultRelInfo@entry=0x56549fb59eb0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffc9c0cfaf0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:36:56.279] rslot = 0x0 [21:36:56.279] matched = true [21:36:56.279] #7 0x000056549c94e1a6 in ExecModifyTable (pstate=0x56549fb59ca0) at ../src/backend/executor/nodeModifyTable.c:4112 [21:36:56.279] node = 0x56549fb59ca0 [21:36:56.279] context = {mtstate = 0x56549fb59ca0, epqstate = 0x56549fb59d88, estate = 0x56549fb59900, planSlot = 0x56549fb9c838, tmfd = {ctid = {ip_blkid = {bi_hi = 59016, bi_lo = 40889}, ip_posid = 22100}, xmax = 2680095672, cmax = 22100, traversed = 160}, cpUpdateReturningSlot = 0x56549c8ce2dd } [21:36:56.279] estate = 0x56549fb59900 [21:36:56.279] operation = CMD_MERGE [21:36:56.279] resultRelInfo = 0x56549fb59eb0 [21:36:56.279] subplanstate = 0x56549fb5a5e0 [21:36:56.279] slot = [21:36:56.279] oldSlot = [21:36:56.279] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 1}, ip_posid = 0} [21:36:56.279] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x56549fbbda58} [21:36:56.279] oldtuple = 0x7ffc9c0cfaf0 [21:36:56.279] tupleid = 0x0 [21:36:56.279] __func__ = "ExecModifyTable" [21:36:56.279] #8 0x000056549c8da61e in ExecProcNodeFirst (node=0x56549fb59ca0) at ../src/backend/executor/execProcnode.c:464 [21:36:56.279] No locals. [21:36:56.279] #9 0x000056549c8c6d19 in ExecProcNode (node=0x56549fb59ca0) at ../src/include/executor/executor.h:274 [21:36:56.279] No locals. [21:36:56.279] #10 ExecutePlan (estate=estate@entry=0x56549fb59900, planstate=0x56549fb59ca0, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x56549fbdfbc0, execute_once=true) at ../src/backend/executor/execMain.c:1646 [21:36:56.279] slot = [21:36:56.279] current_tuple_count = 0 [21:36:56.279] #11 0x000056549c8c7063 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x56549fb476f8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [21:36:56.279] estate = 0x56549fb59900 [21:36:56.279] operation = CMD_MERGE [21:36:56.279] dest = 0x56549fbdfbc0 [21:36:56.279] sendTuples = true [21:36:56.279] oldcontext = 0x56549fbdf8b0 [21:36:56.279] __func__ = "standard_ExecutorRun" [21:36:56.279] #12 0x00007fb16e6a97fc in pgss_ExecutorRun (queryDesc=0x56549fb476f8, direction=ForwardScanDirection, count=0, execute_once=) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [21:36:56.279] _save_exception_stack = 0x7ffc9c0cfee0 [21:36:56.279] _save_context_stack = 0x0 [21:36:56.279] _local_sigjmp_buf = {{__jmpbuf = {94921456645880, 2436037970882909163, 94921455682064, 94921457269696, 0, 0, 2436037970947920875, 2401948487698273259}, __mask_was_saved = 0, __saved_mask = {__val = {94921456720128, 94921456645880, 0, 94921457268912, 94921411214060, 0, 1, 0, 94921403875468, 94921456645880, 94921423685984, 94921457268912, 140400038425634, 94921456645880, 0, 94921455682064}}}} [21:36:56.279] _do_rethrow = false [21:36:56.279] #13 0x000056549c8c71c1 in ExecutorRun (queryDesc=queryDesc@entry=0x56549fb476f8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:302 [21:36:56.279] No locals. [21:36:56.279] #14 0x000056549ccec612 in ProcessQuery (plan=plan@entry=0x56549fbf35b0, sourceText=0x56549fa5c210 "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=0x56549fbdfbc0, qc=qc@entry=0x7ffc9c0cfe40) at ../src/backend/tcop/pquery.c:160 [21:36:56.279] queryDesc = 0x56549fb476f8 [21:36:56.279] #15 0x000056549ccee361 in PortalRunMulti (portal=portal@entry=0x56549faddf20, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x56549fbdfbc0, altdest=0x56549d4d4380 , qc=qc@entry=0x7ffc9c0cfe40) at ../src/backend/tcop/pquery.c:1277 [21:36:56.279] pstmt = 0x56549fbf35b0 [21:36:56.279] stmtlist_item__state = {l = , i = } [21:36:56.279] active_snapshot_set = true [21:36:56.279] stmtlist_item = 0x56549fbf36d8 [21:36:56.279] #16 0x000056549cceea07 in FillPortalStore (portal=portal@entry=0x56549faddf20, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [21:36:56.279] treceiver = 0x56549fbdfbc0 [21:36:56.279] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:36:56.279] __func__ = "FillPortalStore" [21:36:56.279] #17 0x000056549ccef066 in PortalRun (portal=portal@entry=0x56549faddf20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x56549fbf3710, altdest=altdest@entry=0x56549fbf3710, qc=0x7ffc9c0d0020) at ../src/backend/tcop/pquery.c:763 [21:36:56.279] _save_exception_stack = 0x7ffc9c0d00d0 [21:36:56.279] _save_context_stack = 0x0 [21:36:56.279] _local_sigjmp_buf = {{__jmpbuf = {1, -2434279465256823829, 94921457350416, 94921457763968, 94921456213792, 94921457763896, 2436037970880812011, 8259190656484824043}, __mask_was_saved = 0, __saved_mask = {__val = {94921456225352, 94921414012830, 94921456222000, 94921414012830, 1, 140722926583727, 94921457763944, 94921457763896, 94921410945221, 94921413598409, 94921456213792, 94921414012830, 1, 1, 94921411214060, 163}}}} [21:36:56.279] _do_rethrow = [21:36:56.279] result = [21:36:56.279] nprocessed = [21:36:56.279] saveTopTransactionResourceOwner = 0x56549fa9d3f0 [21:36:56.279] saveTopTransactionContext = 0x56549fa88800 [21:36:56.279] saveActivePortal = 0x0 [21:36:56.279] saveResourceOwner = 0x56549fa9d3f0 [21:36:56.279] savePortalContext = 0x0 [21:36:56.279] saveMemoryContext = 0x56549fa88800 [21:36:56.279] __func__ = "PortalRun" [21:36:56.279] #18 0x000056549cce7fef in exec_simple_query (query_string=query_string@entry=0x56549fa5c210 "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 [21:36:56.279] cmdtaglen = 5 [21:36:56.279] snapshot_set = [21:36:56.279] per_parsetree_context = 0x0 [21:36:56.279] plantree_list = 0x56549fbf36c0 [21:36:56.279] parsetree = 0x56549fc58638 [21:36:56.279] commandTag = [21:36:56.279] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:36:56.279] querytree_list = [21:36:56.279] portal = 0x56549faddf20 [21:36:56.279] receiver = 0x56549fbf3710 [21:36:56.279] format = 0 [21:36:56.279] cmdtagname = [21:36:56.279] parsetree_item__state = {l = , i = } [21:36:56.279] dest = DestRemote [21:36:56.279] oldcontext = 0x56549fa88800 [21:36:56.279] parsetree_list = 0x56549fc58668 [21:36:56.279] parsetree_item = 0x56549fc58680 [21:36:56.279] save_log_statement_stats = false [21:36:56.279] was_logged = true [21:36:56.279] use_implicit_block = false [21:36:56.279] msec_str = "\200\002\r\234\374\177\000\000^\375\373\234TV\000\000\260\000\r\234\374\177\000\000\026\001\000\000\000\000\000" [21:36:56.279] __func__ = "exec_simple_query" [21:36:56.279] #19 0x000056549cceadad in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [21:36:56.279] query_string = 0x56549fa5c210 "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"... [21:36:56.279] firstchar = [21:36:56.279] input_message = {data = 0x56549fa5c210 "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} [21:36:56.279] local_sigjmp_buf = {{__jmpbuf = {94921423685976, 8259189134918603755, 4, 140722926584448, 140722926584596, 1, 2436037981798585323, 8259190654002451435}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94921455656672, 16384, 8248, 94921411119125, 0, 0, 0, 94921423685984, 94921455656672, 94921423680056, 140722926584448, 140722926584596, 1, 94921411122175, 140722926584224}}}} [21:36:56.279] send_ready_for_query = false [21:36:56.279] idle_in_transaction_timeout_enabled = false [21:36:56.279] idle_session_timeout_enabled = false [21:36:56.279] __func__ = "PostgresMain" [21:36:56.279] #20 0x000056549cce154f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:36:56.279] bsdata = [21:36:56.279] #21 0x000056549cb858bd in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc9c0d022c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc9c0d0280) at ../src/backend/postmaster/launch_backend.c:265 [21:36:56.279] pid = [21:36:56.279] #22 0x000056549cb8bbeb in BackendStartup (client_sock=client_sock@entry=0x7ffc9c0d0280) at ../src/backend/postmaster/postmaster.c:3593 [21:36:56.279] bn = 0x56549fa88ba8 [21:36:56.279] pid = [21:36:56.279] startup_data = {canAcceptConnections = CAC_OK} [21:36:56.279] __func__ = "BackendStartup" [21:36:56.279] #23 0x000056549cb8c199 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:36:56.279] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\bq\261\177\000\000\001\000\000\000\000\000\000\000\244C\203r\261\177\000\000-\000\000\000\000\000\000\000\020n\354p\261\177\000\000 9\274q\261\177\000\000H\003\r\234\374\177\000\000D\003\r\234\374\177\000\000\004\003\r\234\374\177\000\000`d\000\000\001\000\000\000\000\000\000\000TV\000\000\020n\354p\261\177\000\000\340\217\353p\261\177\000\000\352\317\bq\261\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [21:36:56.279] i = 0 [21:36:56.279] now = [21:36:56.279] last_lockfile_recheck_time = 1713735189 [21:36:56.279] last_touch_time = 1713735189 [21:36:56.279] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1676868608, events = 32764, fd = 46, user_data = 0x7ffc9c0d03c0}, {pos = -1676868656, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 1908160392, user_data = 0x7fb17108cfea}, {pos = -1676868440, events = 32764, fd = -1676868608, user_data = 0x7ffc9c0d0410}, {pos = 1921207521, events = 32689, fd = 18, user_data = 0x7fb16e88a618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1908159520, events = 32689, fd = -1, user_data = 0x7fb16e88a618}, {pos = 1908159520, events = 32689, fd = 1024, user_data = 0x7fb171bc3788}, {pos = 0, events = 0, fd = 7, user_data = 0x7ffc9c0d0410}, {pos = -1, events = 0, fd = 1895267514, user_data = 0x7fb170eb9418}, {pos = 1908160800, events = 32689, fd = -1616329528, user_data = 0x56549fa8c358}, {pos = -1616348448, events = 22100, fd = -1616329496, user_data = 0x56549fa8c011}, {pos = 1921226275, events = 32689, fd = 1, user_data = 0x7fb1710a60f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -1616519056, user_data = 0x7fb172839623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x56549fa87ae0}, {pos = 1894487064, events = 32689, fd = -1676867504, user_data = 0x7fb17284068a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffc9c0d0870}, {pos = -1648580864, events = 22100, fd = 2, user_data = 0x56549dbca700 }, {pos = 0, events = 0, fd = 7, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x2ffff00001fa0}, {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 = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -1616308024, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x2020200a0a717859}, {pos = 909129782, events = 538982708, 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 = 7, events = 0, fd = 1895005179, user_data = 0x400}, {pos = -1616535680, events = 22100, fd = 1896350848, user_data = 0x19fa59f80}, {pos = 784, events = 0, fd = -1658736084, user_data = 0x56549fa8c030}, {pos = 537101824, events = 3090564618, fd = 4, user_data = 0x56549fa91890}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x56549fa8c030}, {pos = 1, events = 0, fd = -1616330504, user_data = 0x400}, {pos = 0, events = 0, fd = -1661003329, user_data = 0x56549dbd8910 }, {pos = -1661077485, events = 22100, fd = -1616330704, user_data = 0x56549fa5c110}, {pos = -1616330704, events = 22100, fd = 15, user_data = 0x4a}, {pos = -1661001519, events = 22100, fd = -1616330704, user_data = 0x56549cff221a }, {pos = -1616535680, events = 22100, fd = 1895005486, user_data = 0x0}, {pos = -1667640966, events = 22100, fd = -1616356544, user_data = 0x7fb170f341aa}, {pos = -1676867320, events = 1, fd = 0, user_data = 0x7fb170f328f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 26313, user_data = 0x7fb170f7cb05 }, {pos = 0, events = 0, fd = 537101824, user_data = 0x0}, {pos = -1665640989, events = 22100, fd = 4194304, user_data = 0x56549cfdf6a7 }, {pos = -1616356544, events = 22100, fd = -1616527088, user_data = 0x56549fa85b40}, {pos = 1, events = 0, fd = 0, user_data = 0x56549cff20d1 }, {pos = -1616356544, events = 22100, fd = -1661001190, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x56549c99cd4d }, {pos = 0, events = 0, fd = -1667618013, user_data = 0xb}, {pos = -1665619139, events = 22100, fd = 0, user_data = 0x0}} [21:36:56.280] nevents = 1 [21:36:56.280] __func__ = "ServerLoop" [21:36:56.280] #24 0x000056549cb8dbbb in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x56549fa55de0) at ../src/backend/postmaster/postmaster.c:1372 [21:36:56.280] opt = [21:36:56.280] status = [21:36:56.280] userDoption = [21:36:56.280] listen_addr_saved = false [21:36:56.280] output_config_variable = [21:36:56.280] __func__ = "PostmasterMain" [21:36:56.280] #25 0x000056549c9ae3b0 in main (argc=4, argv=0x56549fa55de0) at ../src/backend/main/main.c:197 [21:36:56.280] do_check_root = [21:36:56.302] -e [21:36:56.302] [21:36:56.302] [21:36:56.854] dumping /tmp/cores/postgres-3-32698.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:36:57.207] [New LWP 32698] [21:36:57.207] [New LWP 31361] [21:36:58.394] [Thread debugging using libthread_db enabled] [21:36:58.394] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [21:36:59.875] Core was generated by `postgres: standby2: startup waiting for 000000010000000000000006 '. [21:36:59.875] Program terminated with signal SIGQUIT, Quit. [21:36:59.875] #0 0x00007fe1229b4fc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:59.880] [Current thread is 1 (LWP 32698)] [21:36:59.995] [21:36:59.995] Thread 2 (Thread 0x7fe12034ba40 (LWP 31361)): [21:36:59.995] #0 0x00007fe122a77a61 in clone () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:59.995] No symbol table info available. [21:36:59.995] #1 0x00007fe122a65e5e in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:59.995] No symbol table info available. [21:36:59.995] #2 0x00007fe122a66497 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:59.995] No symbol table info available. [21:36:59.995] #3 0x00007fe122a65cdb in posix_spawn () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:59.995] No symbol table info available. [21:36:59.995] #4 0x00007fe1229c1a69 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [21:36:59.995] No symbol table info available. [21:36:59.995] #5 0x00005585ef2b0389 in RestoreArchivedFile (path=path@entry=0x7fff12bae1d0 "pg_wal/00000", xlogfname=xlogfname@entry=0x7fff12bae620 "00000001", '0' , "6", recovername=recovername@entry=0x5585efdbf9fc "RECOVERYXLOG", expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [21:36:59.995] xlogpath = "pg_wal/RECOVERYXLOG", '\000' , "\066", '\000' , "\b\000\000\000\000\000\000\000\354\301\333\357\205U\000\000\370\340\272\022\377\177\000\000\340\301\333\357\205U\000\000\232Q\301\357\205U\000\000 \346\272\022\377\177\000\000\267\371\333\357\205U\000\000\370\340\272\022\377\177\000\000\265\371\333\357\205U\000\000\030\271\064 \341\177\000\000\366[\301\357\205U", '\000' , "\b", '\000' , "\060", '\000' , "\002", '\000' ... [21:36:59.995] xlogRestoreCmd = 0x5585f0c56618 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/040_standby_failover_slots_sync/data/t_040_standby_failover_slots_sync_publisher_data/archives/00000001", '0' , "6\" \"pg_wal/RECOVERYXLOG\"" [21:36:59.995] lastRestartPointFname = "00000001", '0' , "5\000[\301\357\205U", '\000' , "\001\000\000\024\177\000\000\300ƴ\"\341\177\000\000`Ǵ\"\341\177\000\000\024\177\000\000\002", '\000' , "\020\035\234\"\341\177\000\000\300ٺ\022\377\177", '\000' , "W\021\261\"\341\177\000\000O\021\261\"\341\177\000\000\030f\305\360\205U", '\000' , "@", '\000' ... [21:36:59.995] rc = [21:36:59.995] stat_buf = {st_dev = 94033741423486, st_ino = 335544320, st_nlink = 140604924972384, st_mode = 0, st_uid = 0, st_gid = 0, __pad0 = 0, st_rdev = 7891376500450174464, st_size = 0, st_blksize = 94033758479896, st_blocks = 140733507623872, st_atim = {tv_sec = 140733507623456, tv_nsec = 140733507623584}, st_mtim = {tv_sec = 0, tv_nsec = 94033758479896}, st_ctim = {tv_sec = 140604925699223, tv_nsec = 0}, __glibc_reserved = {94033741435290, 140733507626544, 94033743167801}} [21:36:59.995] restartSegNo = [21:36:59.995] restartRedoPtr = 83886120 [21:36:59.995] restartTli = 1 [21:36:59.995] __func__ = "RestoreArchivedFile" [21:36:59.995] #6 0x00005585ef2bf019 in XLogFileRead (segno=140733507626448, segno@entry=6, emode=emode@entry=13, tli=tli@entry=1, source=source@entry=XLOG_FROM_ARCHIVE, notfoundOk=notfoundOk@entry=true) at ../src/backend/access/transam/xlogrecovery.c:4209 [21:36:59.995] xlogfname = "00000001", '0' , "6\000\001\000\000\000\000\000\000\240\352\272\022\377\177\000\000#\006\060$\341\177\000\000\001", '\000' [21:36:59.995] activitymsg = "waiting for 00000001", '0' , "6\000\177\000\000\232Q\301\357\205U\000\000\360R\347\357\205U\000\000\355R\347\357\205U\000\000\070\351\272\022\377\177\000\000Г\r\360\205U\000" [21:36:59.995] path = "pg_wal/00000\000\000\000\000", '\060' , "\066\000pg_wal/RECOVERYHISTORY\000\000\b\000\000\000\000\000\000\066\000\000\000\000\000\000\000\000nV\301\357\000\000\000\062\000\000\000\000\000\000\000\000\b\000\000\000\000\000\000\000\354\301\333\357\205U\000\000\b\000\000\000\000\000\000\000\331g\333\357\205U\000\000X\345\272\022\377\177\000\000\325g\333\357\205U\000\000\232Q\301\357\205U\000\000\341g\333\357\205U\000\000\331g\333\357\205U\000\000X\345\272\022\377\177\000\000\325g\333\357\205U\000\000\030\271\064 \341\177\000\000\070[\301\357\205U", '\000' ... [21:36:59.995] fd = [21:36:59.995] __func__ = "XLogFileRead" [21:36:59.995] #7 0x00005585ef2bf209 in XLogFileReadAnyTLI (segno=6, emode=emode@entry=13, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4337 [21:36:59.995] hent = [21:36:59.995] tli = 1 [21:36:59.995] cell__state = {l = , i = } [21:36:59.995] path = "\001\000\000\000\000\000\000\000\004\000\000\t", '\000' , "\332c\301\357\205U\000\000\000\000\000\000\000\000\000\000\302\307{\360\205U\000\000@\310{\360\205U\000\000\240\037\000\000\377\377\002\000\030R\347\357\205U\000\000\321\307{\360\205U\000\000@\310{\360\205U\000\000D\350\272\022\377\177\000\000'R\347\357\205U\000\000@\310{\360\205U\000\000\002\000\000\000\000\000\000\000\227k\301\357\205U\000\000F\350\272\022\377\177\000\000D\350\272\022\377\177", '\000' , "\030\000\000\000\060\000\000\000 \350\272\022\377\177\000\000pl\301\357\205U\000\000", '\177' ... [21:36:59.995] cell = [21:36:59.995] fd = [21:36:59.995] tles = 0x5585f0c68dc8 [21:36:59.995] __func__ = "XLogFileReadAnyTLI" [21:36:59.995] #8 0x00005585ef2c0405 in WaitForWALToBecomeAvailable (RecPtr=RecPtr@entry=100683536, randAccess=false, fetching_ckpt=false, tliRecPtr=tliRecPtr@entry=100683512, replayTLI=1, replayLSN=100683512, nonblocking=false) at ../src/backend/access/transam/xlogrecovery.c:3770 [21:36:59.995] oldSource = [21:36:59.995] startWalReceiver = false [21:36:59.995] last_fail_time = 767050414740524 [21:36:59.995] now = [21:36:59.995] streaming_reply_sent = true [21:36:59.995] __func__ = "WaitForWALToBecomeAvailable" [21:36:59.995] #9 0x00005585ef2c0f3a in XLogPageRead (xlogreader=0x5585f0c03f60, targetPagePtr=100679680, reqLen=3856, targetRecPtr=100683512, readBuf=0x5585f0c52de8 "\025\321\006") at ../src/backend/access/transam/xlogrecovery.c:3351 [21:36:59.995] private = 0x5585f0c03f40 [21:36:59.995] emode = 15 [21:36:59.995] targetPageOff = 16384 [21:36:59.995] targetSegNo = 6 [21:36:59.995] r = [21:36:59.995] __func__ = "XLogPageRead" [21:36:59.995] #10 0x00005585ef2c9395 in ReadPageInternal (state=state@entry=0x5585f0c03f60, pageptr=pageptr@entry=100679680, reqLen=reqLen@entry=3856) at ../src/backend/access/transam/xlogreader.c:1060 [21:36:59.995] readLen = [21:36:59.995] targetPageOff = 16384 [21:36:59.995] targetSegNo = 6 [21:36:59.995] hdr = [21:36:59.995] #11 0x00005585ef2caff0 in XLogDecodeNextRecord (state=state@entry=0x5585f0c03f60, nonblocking=nonblocking@entry=false) at ../src/backend/access/transam/xlogreader.c:597 [21:36:59.995] RecPtr = 100683512 [21:36:59.995] record = [21:36:59.995] targetPagePtr = 100679680 [21:36:59.995] randAccess = false [21:36:59.995] len = [21:36:59.995] total_len = [21:36:59.995] targetRecOff = 3832 [21:36:59.995] pageHeaderSize = [21:36:59.995] assembled = false [21:36:59.995] gotheader = [21:36:59.995] readOff = [21:36:59.995] decoded = 0x0 [21:36:59.995] errormsg = 0x5585efe63581 "LOG" [21:36:59.995] #12 0x00005585ef2cbb92 in XLogReadAhead (state=0x5585f0c03f60, nonblocking=nonblocking@entry=false) at ../src/backend/access/transam/xlogreader.c:973 [21:36:59.995] result = [21:36:59.995] #13 0x00005585ef2b64d4 in XLogPrefetcherNextBlock (pgsr_private=94033758145936, lsn=0x5585f0c68768) at ../src/backend/access/transam/xlogprefetcher.c:492 [21:36:59.995] nonblocking = [21:36:59.995] record = [21:36:59.995] prefetcher = 0x5585f0c04d90 [21:36:59.995] reader = 0x5585f0c03f60 [21:36:59.995] replaying_lsn = 100683464 [21:36:59.995] __func__ = "XLogPrefetcherNextBlock" [21:36:59.995] #14 0x00005585ef2ba89d in lrq_prefetch (lrq=) at ../src/backend/access/transam/xlogprefetcher.c:252 [21:36:59.995] No locals. [21:36:59.995] #15 lrq_complete_lsn (lsn=0, lrq=0x5585f0c68698) at ../src/backend/access/transam/xlogprefetcher.c:290 [21:36:59.995] No locals. [21:36:59.995] #16 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x5585f0c04d90, errmsg=errmsg@entry=0x7fff12bb2db8) at ../src/backend/access/transam/xlogprefetcher.c:1037 [21:36:59.995] record = [21:36:59.995] replayed_up_to = 0 [21:36:59.995] #17 0x00005585ef2c1767 in ReadRecord (xlogprefetcher=0x5585f0c04d90, emode=emode@entry=15, fetching_ckpt=fetching_ckpt@entry=false, replayTLI=1) at ../src/backend/access/transam/xlogrecovery.c:3151 [21:36:59.995] errormsg = 0x5585f0c04770 "" [21:36:59.995] record = [21:37:00.014] xlogreader = 0x5585f0c03f60 [21:37:00.014] private = [21:37:00.014] __func__ = "ReadRecord" [21:37:00.014] #18 0x00005585ef2c48fe in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1832 [21:37:00.014] xtime = [21:37:00.014] ru0 = {tv = {tv_sec = 1713735210, tv_usec = 383218}, ru = {ru_utime = {tv_sec = 0, tv_usec = 1940}, ru_stime = {tv_sec = 0, tv_usec = 0}, {ru_maxrss = 16460, __ru_maxrss_word = 16460}, {ru_ixrss = 0, __ru_ixrss_word = 0}, {ru_idrss = 0, __ru_idrss_word = 0}, {ru_isrss = 0, __ru_isrss_word = 0}, {ru_minflt = 408, __ru_minflt_word = 408}, {ru_majflt = 5, __ru_majflt_word = 5}, {ru_nswap = 0, __ru_nswap_word = 0}, {ru_inblock = 0, __ru_inblock_word = 0}, {ru_oublock = 0, __ru_oublock_word = 0}, {ru_msgsnd = 0, __ru_msgsnd_word = 0}, {ru_msgrcv = 0, __ru_msgrcv_word = 0}, {ru_nsignals = 0, __ru_nsignals_word = 0}, {ru_nvcsw = 4, __ru_nvcsw_word = 4}, {ru_nivcsw = 1, __ru_nivcsw_word = 1}}} [21:37:00.014] record = 0x7fe11fc05f70 [21:37:00.014] reachedRecoveryTarget = false [21:37:00.014] replayTLI = 1 [21:37:00.014] __func__ = "PerformWalRecovery" [21:37:00.014] #19 0x00005585ef2ae321 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5806 [21:37:00.014] Insert = [21:37:00.014] checkPoint = {redo = 83886120, ThisTimeLineID = 1, PrevTimeLineID = 1, fullPageWrites = true, nextXid = {value = 751}, nextOid = 24576, nextMulti = 1, nextMultiOffset = 0, oldestXid = 730, oldestXidDB = 1, oldestMulti = 1, oldestMultiDB = 1, time = 1713735210, oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 751} [21:37:00.014] wasShutdown = false [21:37:00.014] didCrash = [21:37:00.014] haveTblspcMap = false [21:37:00.014] haveBackupLabel = true [21:37:00.014] EndOfLog = [21:37:00.014] EndOfLogTLI = [21:37:00.014] newTLI = [21:37:00.014] performedWalRecovery = [21:37:00.014] endOfRecoveryInfo = [21:37:00.014] abortedRecPtr = [21:37:00.014] missingContrecPtr = [21:37:00.014] oldestActiveXID = [21:37:00.014] promoted = false [21:37:00.014] __func__ = "StartupXLOG" [21:37:00.014] #20 0x00005585ef7742a1 in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [21:37:00.014] No locals. [21:37:00.014] #21 0x00005585ef76b8bd in postmaster_child_launch (child_type=child_type@entry=B_STARTUP, startup_data=startup_data@entry=0x0, startup_data_len=startup_data_len@entry=0, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:265 [21:37:00.014] pid = [21:37:00.014] #22 0x00005585ef76d936 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3928 [21:37:00.014] pid = [21:37:00.014] __func__ = "StartChildProcess" [21:37:00.014] #23 0x00005585ef773a00 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5585f0c02e20) at ../src/backend/postmaster/postmaster.c:1364 [21:37:00.014] opt = [21:37:00.014] status = [21:37:00.014] userDoption = [21:37:00.014] listen_addr_saved = false [21:37:00.014] output_config_variable = [21:37:00.014] __func__ = "PostmasterMain" [21:37:00.014] #24 0x00005585ef5943b0 in main (argc=4, argv=0x5585f0c02e20) at ../src/backend/main/main.c:197 [21:37:00.014] do_check_root = [21:37:00.014] [21:37:00.014] Thread 1 (LWP 32698): [21:37:00.014] #0 0x00007fe1229b4fc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [21:37:00.014] No symbol table info available. [21:37:00.014] #1 0x00007fe122a6613a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [21:37:00.014] No symbol table info available. [21:37:00.014] #2 0x00007fe122a77a6f in clone () from /lib/x86_64-linux-gnu/libc.so.6 [21:37:00.014] No symbol table info available.