[17:41:40.281] src/tools/ci/cores_backtrace.sh linux /tmp/cores [17:41:40.983] dumping /tmp/cores/postgres-6-18037.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [17:41:42.647] [New LWP 18037] [17:41:42.647] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [17:41:43.411] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [17:41:44.172] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [17:41:45.396] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [17:41:47.761] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [17:41:47.761] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [17:41:49.625] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [17:41:50.836] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [17:41:52.401] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [17:41:53.460] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [17:41:54.222] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [17:41:55.442] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [17:41:57.052] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [17:41:58.457] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [17:41:59.385] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [17:42:00.930] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [17:42:02.329] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [17:42:02.802] [Thread debugging using libthread_db enabled] [17:42:02.802] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [17:42:03.867] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [17:42:05.252] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [17:42:06.316] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [17:42:06.940] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [17:42:07.708] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [17:42:10.018] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [17:42:10.963] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [17:42:11.746] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [17:42:12.676] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [17:42:13.602] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [17:42:15.210] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [17:42:16.302] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [17:42:17.083] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [17:42:18.466] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [17:42:19.090] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [17:42:20.645] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [17:42:21.409] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [17:42:22.643] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [17:42:23.413] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [17:42:24.487] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [17:42:25.409] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [17:42:26.641] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [17:42:27.260] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [17:42:28.176] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [17:42:28.941] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [17:42:29.434] Core was generated by `postgres: postgres regression [local] MERGE '. [17:42:29.434] Program terminated with signal SIGABRT, Aborted. [17:42:29.434] #0 0x00007fc6311fbce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:29.671] [17:42:29.671] Thread 1 (Thread 0x7fc62eb92a40 (LWP 18037)): [17:42:29.671] #0 0x00007fc6311fbce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:29.671] No symbol table info available. [17:42:29.671] #1 0x00007fc6311e5537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:29.671] No symbol table info available. [17:42:29.671] #2 0x000055f658ff28c9 in ExceptionalCondition (conditionName=conditionName@entry=0x55f65923b4a8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x55f65925fa98 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [17:42:29.671] No locals. [17:42:29.671] #3 0x000055f6589596a8 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fff8f2b5fa0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fff8f2b5e3f) at ../src/backend/executor/execTuples.c:1728 [17:42:29.671] No locals. [17:42:29.671] #4 0x000055f6588dca65 in ExecIRDeleteTriggers (estate=estate@entry=0x55f65bbb18f0, relinfo=relinfo@entry=0x55f65bbb1ea0, slot=slot@entry=0x7fff8f2b5fa0) at ../src/backend/commands/trigger.c:2841 [17:42:29.671] trigger = 0x55f65bbb2100 [17:42:29.671] oldtuple = [17:42:29.671] trigdesc = 0x55f65bbb20b0 [17:42:29.671] newtuple = 0x0 [17:42:29.671] should_free = false [17:42:29.671] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fc6258d3eb8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [17:42:29.671] i = 0 [17:42:29.671] #5 0x000055f6589bc4da in ExecMergeMatched (context=0x7fff8f2b5fc0, resultRelInfo=resultRelInfo@entry=0x55f65bbb1ea0, tupleid=0x0, oldtuple=0x7fff8f2b5fa0, canSetTag=true, matched=matched@entry=0x7fff8f2b5f4f) at ../src/backend/executor/nodeModifyTable.c:2991 [17:42:29.671] relaction = 0x55f65bb9ad98 [17:42:29.671] commandType = CMD_DELETE [17:42:29.671] result = TM_Ok [17:42:29.671] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [17:42:29.671] l__state = {l = , i = } [17:42:29.671] mtstate = 0x55f65bbb1c90 [17:42:29.671] newslot = 0x0 [17:42:29.671] rslot = 0x0 [17:42:29.671] estate = 0x55f65bbb18f0 [17:42:29.671] econtext = 0x55f65bbff188 [17:42:29.671] isNull = false [17:42:29.671] epqstate = 0x55f65bbb1d78 [17:42:29.671] l = [17:42:29.671] lmerge_matched = [17:42:29.671] __func__ = "ExecMergeMatched" [17:42:29.671] #6 0x000055f6589bd38e in ExecMerge (context=context@entry=0x7fff8f2b5fc0, resultRelInfo=resultRelInfo@entry=0x55f65bbb1ea0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fff8f2b5fa0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2772 [17:42:29.671] rslot = 0x0 [17:42:29.671] matched = true [17:42:29.671] #7 0x000055f6589becde in ExecModifyTable (pstate=0x55f65bbb1c90) at ../src/backend/executor/nodeModifyTable.c:4028 [17:42:29.671] node = 0x55f65bbb1c90 [17:42:29.671] context = {mtstate = 0x55f65bbb1c90, epqstate = 0x55f65bbb1d78, estate = 0x55f65bbb18f0, planSlot = 0x55f65bbfdb98, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 1486054469, cmax = 22006, traversed = 184}, cpUpdateReturningSlot = 0x55f65bc06c70} [17:42:29.671] estate = 0x55f65bbb18f0 [17:42:29.671] operation = CMD_MERGE [17:42:29.671] resultRelInfo = 0x55f65bbb1ea0 [17:42:29.671] subplanstate = 0x55f65bbb25d0 [17:42:29.671] slot = [17:42:29.671] oldSlot = [17:42:29.671] tuple_ctid = {ip_blkid = {bi_hi = 23488, bi_lo = 22006}, ip_posid = 0} [17:42:29.671] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x55f65bbc9988} [17:42:29.671] oldtuple = 0x7fff8f2b5fa0 [17:42:29.671] tupleid = 0x0 [17:42:29.671] __func__ = "ExecModifyTable" [17:42:29.671] #8 0x000055f65894b873 in ExecProcNodeFirst (node=0x55f65bbb1c90) at ../src/backend/executor/execProcnode.c:464 [17:42:29.671] No locals. [17:42:29.671] #9 0x000055f658938134 in ExecProcNode (node=0x55f65bbb1c90) at ../src/include/executor/executor.h:274 [17:42:29.671] No locals. [17:42:29.671] #10 ExecutePlan (estate=estate@entry=0x55f65bbb18f0, planstate=0x55f65bbb1c90, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55f65bbe9ae0, execute_once=true) at ../src/backend/executor/execMain.c:1644 [17:42:29.671] slot = [17:42:29.671] current_tuple_count = 0 [17:42:29.671] #11 0x000055f65893847e in standard_ExecutorRun (queryDesc=0x55f65bbe65a8, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [17:42:29.671] estate = 0x55f65bbb18f0 [17:42:29.671] operation = CMD_MERGE [17:42:29.671] dest = 0x55f65bbe9ae0 [17:42:29.671] sendTuples = true [17:42:29.671] oldcontext = 0x55f65bbe97d0 [17:42:29.671] __func__ = "standard_ExecutorRun" [17:42:29.671] #12 0x000055f6589385e9 in ExecutorRun (queryDesc=queryDesc@entry=0x55f65bbe65a8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [17:42:29.671] No locals. [17:42:29.671] #13 0x000055f658d4c838 in ProcessQuery (plan=plan@entry=0x55f65bc09b28, sourceText=0x55f65ba5f290 "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=0x55f65bbe9ae0, qc=qc@entry=0x7fff8f2b61e0) at ../src/backend/tcop/pquery.c:160 [17:42:29.671] queryDesc = 0x55f65bbe65a8 [17:42:29.671] #14 0x000055f658d4e581 in PortalRunMulti (portal=portal@entry=0x55f65badffc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55f65bbe9ae0, altdest=0x55f65951b6c0 , qc=qc@entry=0x7fff8f2b61e0) at ../src/backend/tcop/pquery.c:1277 [17:42:29.671] pstmt = 0x55f65bc09b28 [17:42:29.671] stmtlist_item__state = {l = , i = } [17:42:29.671] active_snapshot_set = true [17:42:29.671] stmtlist_item = 0x55f65bc09c50 [17:42:29.671] #15 0x000055f658d4ec27 in FillPortalStore (portal=portal@entry=0x55f65badffc0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [17:42:29.671] treceiver = 0x55f65bbe9ae0 [17:42:29.671] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:42:29.671] __func__ = "FillPortalStore" [17:42:29.671] #16 0x000055f658d4f286 in PortalRun (portal=portal@entry=0x55f65badffc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55f65bc09c88, altdest=altdest@entry=0x55f65bc09c88, qc=0x7fff8f2b63c0) at ../src/backend/tcop/pquery.c:763 [17:42:29.671] _save_exception_stack = 0x7fff8f2b6470 [17:42:29.671] _save_context_stack = 0x0 [17:42:29.671] _local_sigjmp_buf = {{__jmpbuf = {1, -8995675709941859432, 94516589665416, 94516589860336, 94516588445632, 94516589860264, 8995921343294618520, 2937544546530638744}, __mask_was_saved = 0, __saved_mask = {__val = {94516588457192, 94516546558206, 94516588453840, 94516546558206, 1, 140735595373391, 94516589860312, 94516589860264, 94516543545353, 94516546145225, 94516588445632, 94516546558206, 1, 1, 94516543806021, 163}}}} [17:42:29.671] _do_rethrow = [17:42:29.671] result = [17:42:29.671] nprocessed = [17:42:29.671] saveTopTransactionResourceOwner = 0x55f65ba9ec88 [17:42:29.671] saveTopTransactionContext = 0x55f65ba87ba0 [17:42:29.671] saveActivePortal = 0x0 [17:42:29.671] saveResourceOwner = 0x55f65ba9ec88 [17:42:29.671] savePortalContext = 0x0 [17:42:29.671] saveMemoryContext = 0x55f65ba87ba0 [17:42:29.671] __func__ = "PortalRun" [17:42:29.671] #17 0x000055f658d4821b in exec_simple_query (query_string=query_string@entry=0x55f65ba5f290 "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 [17:42:29.671] cmdtaglen = 5 [17:42:29.671] snapshot_set = [17:42:29.671] per_parsetree_context = 0x0 [17:42:29.671] plantree_list = 0x55f65bc09c38 [17:42:29.671] parsetree = 0x55f65bc395a8 [17:42:29.671] commandTag = [17:42:29.671] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:42:29.671] querytree_list = [17:42:29.671] portal = 0x55f65badffc0 [17:42:29.671] receiver = 0x55f65bc09c88 [17:42:29.671] format = 0 [17:42:29.671] cmdtagname = [17:42:29.671] parsetree_item__state = {l = , i = } [17:42:29.671] dest = DestRemote [17:42:29.671] oldcontext = 0x55f65ba87ba0 [17:42:29.671] parsetree_list = 0x55f65bc395d8 [17:42:29.671] parsetree_item = 0x55f65bc395f0 [17:42:29.671] save_log_statement_stats = false [17:42:29.671] was_logged = false [17:42:29.671] use_implicit_block = false [17:42:29.671] msec_str = " f+\217\377\177\000\000\242\274\001Y\366U\000\000Pd+\217\377\177\000\000\026\001\000\000\000\000\000" [17:42:29.671] __func__ = "exec_simple_query" [17:42:29.671] #18 0x000055f658d4afd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [17:42:29.671] query_string = 0x55f65ba5f290 "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"... [17:42:29.671] firstchar = [17:42:29.671] input_message = {data = 0x55f65ba5f290 "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} [17:42:29.671] local_sigjmp_buf = {{__jmpbuf = {94516556102040, 2937546638736898968, 4, 140735595374112, 140735595374260, 1, 8995921343089097624, 2937544544451181464}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140489204731364, 94516587892512, 15616, 15680, 94516543717411, 94516556102048, 94516587892512, 94516556096120, 140735595374112, 140735595374260, 94516543721479, 140735595373888}}}} [17:42:29.671] send_ready_for_query = false [17:42:29.671] idle_in_transaction_timeout_enabled = false [17:42:29.671] idle_session_timeout_enabled = false [17:42:29.671] __func__ = "PostgresMain" [17:42:29.671] #19 0x000055f658d4178a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [17:42:29.671] bsdata = [17:42:29.671] #20 0x000055f658bebff7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff8f2b65cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff8f2b6620) at ../src/backend/postmaster/launch_backend.c:265 [17:42:29.671] pid = [17:42:29.671] #21 0x000055f658bf2177 in BackendStartup (client_sock=client_sock@entry=0x7fff8f2b6620) at ../src/backend/postmaster/postmaster.c:3593 [17:42:29.671] bn = 0x55f65ba87db8 [17:42:29.671] pid = [17:42:29.671] startup_data = {canAcceptConnections = CAC_OK} [17:42:29.671] __func__ = "BackendStartup" [17:42:29.671] #22 0x000055f658bf2725 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [17:42:29.671] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\035\061\306\177\000\000 \031\355\061\306\177\000\000\310f+\217\377\177\000\000\304f+\217\377\177\000\000\000\000\000\000\377\177\000\000@\276\274.\306\177\000\000\000\000\000\000\377\177\000\000\020N\035\061\306\177\000\000\340o\034\061\306\177\000\000\352\257\071\061\306\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\304f+\217\377\177\000\000@\276\274.\306\177\000\000\220g+\217\377\177\000", __ss_align = 140489206104864}, salen = 2}} [17:42:29.671] i = 0 [17:42:29.671] now = [17:42:29.671] last_lockfile_recheck_time = 1711301943 [17:42:29.671] last_touch_time = 1711301943 [17:42:29.671] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = 837621640, events = 32710, fd = 825864170, user_data = 0x7fff8f2b6828}, {pos = -1892980864, events = 32767, fd = -1892980848, user_data = 0x7fc632b42ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = 783910424, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fc631ed1420}, {pos = -1, events = 0, fd = 783910424, user_data = 0x7fc631ed1420}, {pos = 837622048, events = 1, fd = 837621640, user_data = 0x0}, {pos = -1892980864, events = 32767, fd = 1024, user_data = 0xffffffff}, {pos = -1892980576, events = 32767, fd = 823948312, user_data = 0x7fc631ed1920}, {pos = 1537788984, events = 22006, fd = 1537779512, user_data = 0x55f65ba84a20}, {pos = 1537789016, events = 22006, fd = 1537788817, user_data = 0x7fc632b47623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 825966840, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = 1537609824, events = 22006, fd = 850687523, user_data = 0x1}, {pos = 0, events = 0, fd = 1537755680, user_data = 0x7fc6311c7418}, {pos = -1892979728, events = 32767, fd = 850716298, user_data = 0x0}, {pos = 0, events = 0, fd = -1892979696, user_data = 0x55f659bf9760 }, {pos = 2, events = 0, fd = 1505728352, user_data = 0x0}, {pos = 824475046, events = 32710, fd = 1537813504, user_data = 0x7fc631391be0}, {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 = 1179612973, user_data = 0x36464f772d737365}, {pos = 168455749, events = 908075040, fd = 822763892, user_data = 0x30340a3334393130}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 538976266, user_data = 0x2020202020203230}, {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 = 0x55f65ba5cfc0}, {pos = 1537593280, events = 22006, fd = 825809024, user_data = 0x7fc63124051a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = 824466427, user_data = 0x400}, {pos = 1537593280, events = 22006, fd = 825812096, user_data = 0x15ba5cfc0}, {pos = 784, events = 0, fd = 1495707276, 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 = 0x55f65903b40c }, {pos = 1537778704, events = 22006, fd = 1537778704, user_data = 0x55f65ba8a410}, {pos = 1, events = 0, fd = 1537778904, user_data = 0x400}, {pos = 0, events = 0, fd = 1493481927, user_data = 0x55f659c07950 }, {pos = 1493415603, events = 22006, fd = 1537778704, user_data = 0x55f65ba5f190}, {pos = 1537778704, events = 22006, fd = 15, user_data = 0x4a}, {pos = 1493483695, events = 22006, fd = 1537778704, user_data = 0x55f65904c1f1 }, {pos = 1537593280, events = 22006, fd = 824466427, user_data = 0x0}, {pos = 1486936787, events = 22006, fd = 1537767312, user_data = 0x7fc6312421aa}, {pos = -1892979544, events = 1, fd = 0, user_data = 0x7fc6312408f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 15693, user_data = 0x7fc63128ab05 }, {pos = 0, events = 0, fd = 1383489792, user_data = 0x0}, {pos = 1488895261, events = 22006, fd = 4194304, user_data = 0x55f65903b547 }, {pos = 1537767312, events = 22006, fd = 1537601936, user_data = 0x55f65ba87790}, {pos = 1, events = 0, fd = 0, user_data = 0x55f65904c0af }, {pos = 1537767312, events = 22006, fd = 1493484017, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55f658a0d6a6 }, {pos = 0, events = 0, fd = 1486959740, user_data = 0xb}, {pos = 1488916681, events = 22006, fd = 0, user_data = 0x0}} [17:42:29.672] nevents = 1 [17:42:29.672] __func__ = "ServerLoop" [17:42:29.672] #23 0x000055f658bf4147 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55f65ba58e80) at ../src/backend/postmaster/postmaster.c:1372 [17:42:29.672] opt = [17:42:29.672] status = [17:42:29.672] userDoption = [17:42:29.672] listen_addr_saved = false [17:42:29.672] output_config_variable = [17:42:29.672] __func__ = "PostmasterMain" [17:42:29.672] #24 0x000055f658a1e4d6 in main (argc=8, argv=0x55f65ba58e80) at ../src/backend/main/main.c:197 [17:42:29.672] do_check_root = [17:42:29.689] -e [17:42:29.689] [17:42:29.689] [17:42:30.227] dumping /tmp/cores/postgres-6-18683.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:42:30.536] [New LWP 18683] [17:42:31.672] [Thread debugging using libthread_db enabled] [17:42:31.672] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [17:42:33.085] Core was generated by `postgres: old_node: postgres regression [local] MERGE '. [17:42:33.085] Program terminated with signal SIGABRT, Aborted. [17:42:33.085] #0 0x00007f1760ccbce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:33.278] [17:42:33.278] Thread 1 (Thread 0x7f175e662a40 (LWP 18683)): [17:42:33.278] #0 0x00007f1760ccbce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:33.278] No symbol table info available. [17:42:33.278] #1 0x00007f1760cb5537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:33.278] No symbol table info available. [17:42:33.278] #2 0x000055d811f8f8c9 in ExceptionalCondition (conditionName=conditionName@entry=0x55d8121d84a8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x55d8121fca98 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [17:42:33.278] No locals. [17:42:33.278] #3 0x000055d8118f66a8 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffdc1b9e6c0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffdc1b9e55f) at ../src/backend/executor/execTuples.c:1728 [17:42:33.278] No locals. [17:42:33.278] #4 0x000055d811879a65 in ExecIRDeleteTriggers (estate=estate@entry=0x55d8144b6520, relinfo=relinfo@entry=0x55d8144b6ad0, slot=slot@entry=0x7ffdc1b9e6c0) at ../src/backend/commands/trigger.c:2841 [17:42:33.278] trigger = 0x55d8144b6d30 [17:42:33.278] oldtuple = [17:42:33.278] trigdesc = 0x55d8144b6ce0 [17:42:33.278] newtuple = 0x0 [17:42:33.278] should_free = false [17:42:33.278] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f1755768338, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [17:42:33.278] i = 0 [17:42:33.278] #5 0x000055d8119594da in ExecMergeMatched (context=0x7ffdc1b9e6e0, resultRelInfo=resultRelInfo@entry=0x55d8144b6ad0, tupleid=0x0, oldtuple=0x7ffdc1b9e6c0, canSetTag=true, matched=matched@entry=0x7ffdc1b9e66f) at ../src/backend/executor/nodeModifyTable.c:2991 [17:42:33.278] relaction = 0x55d8144a0208 [17:42:33.278] commandType = CMD_DELETE [17:42:33.278] result = TM_Ok [17:42:33.278] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [17:42:33.278] l__state = {l = , i = } [17:42:33.278] mtstate = 0x55d8144b68c0 [17:42:33.278] newslot = 0x0 [17:42:33.278] rslot = 0x0 [17:42:33.278] estate = 0x55d8144b6520 [17:42:33.278] econtext = 0x55d814498ed8 [17:42:33.278] isNull = false [17:42:33.278] epqstate = 0x55d8144b69a8 [17:42:33.278] l = [17:42:33.278] lmerge_matched = [17:42:33.278] __func__ = "ExecMergeMatched" [17:42:33.278] #6 0x000055d81195a38e in ExecMerge (context=context@entry=0x7ffdc1b9e6e0, resultRelInfo=resultRelInfo@entry=0x55d8144b6ad0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffdc1b9e6c0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2772 [17:42:33.278] rslot = 0x0 [17:42:33.278] matched = true [17:42:33.278] #7 0x000055d81195bcde in ExecModifyTable (pstate=0x55d8144b68c0) at ../src/backend/executor/nodeModifyTable.c:4028 [17:42:33.278] node = 0x55d8144b68c0 [17:42:33.278] context = {mtstate = 0x55d8144b68c0, epqstate = 0x55d8144b69a8, estate = 0x55d8144b6520, planSlot = 0x55d8144978e8, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 294466629, cmax = 21976, traversed = 24}, cpUpdateReturningSlot = 0x55d8145180d0} [17:42:33.278] estate = 0x55d8144b6520 [17:42:33.278] operation = CMD_MERGE [17:42:33.278] resultRelInfo = 0x55d8144b6ad0 [17:42:33.278] subplanstate = 0x55d8144b7200 [17:42:33.278] slot = [17:42:33.278] oldSlot = [17:42:33.278] tuple_ctid = {ip_blkid = {bi_hi = 5201, bi_lo = 21976}, ip_posid = 0} [17:42:33.278] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x55d8144d50d8} [17:42:33.278] oldtuple = 0x7ffdc1b9e6c0 [17:42:33.278] tupleid = 0x0 [17:42:33.278] __func__ = "ExecModifyTable" [17:42:33.278] #8 0x000055d8118e8873 in ExecProcNodeFirst (node=0x55d8144b68c0) at ../src/backend/executor/execProcnode.c:464 [17:42:33.278] No locals. [17:42:33.278] #9 0x000055d8118d5134 in ExecProcNode (node=0x55d8144b68c0) at ../src/include/executor/executor.h:274 [17:42:33.278] No locals. [17:42:33.278] #10 ExecutePlan (estate=estate@entry=0x55d8144b6520, planstate=0x55d8144b68c0, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55d814500490, execute_once=true) at ../src/backend/executor/execMain.c:1644 [17:42:33.278] slot = [17:42:33.278] current_tuple_count = 0 [17:42:33.278] #11 0x000055d8118d547e in standard_ExecutorRun (queryDesc=0x55d8144a7288, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [17:42:33.278] estate = 0x55d8144b6520 [17:42:33.278] operation = CMD_MERGE [17:42:33.278] dest = 0x55d814500490 [17:42:33.278] sendTuples = true [17:42:33.278] oldcontext = 0x55d814500180 [17:42:33.278] __func__ = "standard_ExecutorRun" [17:42:33.278] #12 0x000055d8118d55e9 in ExecutorRun (queryDesc=queryDesc@entry=0x55d8144a7288, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [17:42:33.278] No locals. [17:42:33.278] #13 0x000055d811ce9838 in ProcessQuery (plan=plan@entry=0x55d81451af88, sourceText=0x55d814364280 "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=0x55d814500490, qc=qc@entry=0x7ffdc1b9e900) at ../src/backend/tcop/pquery.c:160 [17:42:33.278] queryDesc = 0x55d8144a7288 [17:42:33.278] #14 0x000055d811ceb581 in PortalRunMulti (portal=portal@entry=0x55d8143e7f80, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55d814500490, altdest=0x55d8124b86c0 , qc=qc@entry=0x7ffdc1b9e900) at ../src/backend/tcop/pquery.c:1277 [17:42:33.278] pstmt = 0x55d81451af88 [17:42:33.278] stmtlist_item__state = {l = , i = } [17:42:33.278] active_snapshot_set = true [17:42:33.278] stmtlist_item = 0x55d81451b0b0 [17:42:33.278] #15 0x000055d811cebc27 in FillPortalStore (portal=portal@entry=0x55d8143e7f80, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [17:42:33.278] treceiver = 0x55d814500490 [17:42:33.278] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:42:33.278] __func__ = "FillPortalStore" [17:42:33.278] #16 0x000055d811cec286 in PortalRun (portal=portal@entry=0x55d8143e7f80, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d81451b0e8, altdest=altdest@entry=0x55d81451b0e8, qc=0x7ffdc1b9eae0) at ../src/backend/tcop/pquery.c:763 [17:42:33.278] _save_exception_stack = 0x7ffdc1b9eb90 [17:42:33.278] _save_context_stack = 0x0 [17:42:33.278] _local_sigjmp_buf = {{__jmpbuf = {1, 6531474989170409340, 94386542194920, 94386542353616, 94386540937088, 94386542353544, -6530229808700735620, -1075139334395412612}, __mask_was_saved = 0, __saved_mask = {__val = {94386540948648, 94386505951486, 94386540945296, 94386505951486, 1, 140727853640303, 94386542353592, 94386542353544, 94386502938633, 94386505538505, 94386540937088, 94386505951486, 1, 1, 94386503199301, 163}}}} [17:42:33.278] _do_rethrow = [17:42:33.278] result = [17:42:33.278] nprocessed = [17:42:33.278] saveTopTransactionResourceOwner = 0x55d8143a5138 [17:42:33.278] saveTopTransactionContext = 0x55d81443e380 [17:42:33.278] saveActivePortal = 0x0 [17:42:33.278] saveResourceOwner = 0x55d8143a5138 [17:42:33.278] savePortalContext = 0x0 [17:42:33.278] saveMemoryContext = 0x55d81443e380 [17:42:33.278] __func__ = "PortalRun" [17:42:33.278] #17 0x000055d811ce521b in exec_simple_query (query_string=query_string@entry=0x55d814364280 "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 [17:42:33.278] cmdtaglen = 5 [17:42:33.278] snapshot_set = [17:42:33.278] per_parsetree_context = 0x0 [17:42:33.278] plantree_list = 0x55d81451b098 [17:42:33.278] parsetree = 0x55d814541c88 [17:42:33.278] commandTag = [17:42:33.278] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:42:33.278] querytree_list = [17:42:33.278] portal = 0x55d8143e7f80 [17:42:33.278] receiver = 0x55d81451b0e8 [17:42:33.278] format = 0 [17:42:33.278] cmdtagname = [17:42:33.278] parsetree_item__state = {l = , i = } [17:42:33.278] dest = DestRemote [17:42:33.278] oldcontext = 0x55d81443e380 [17:42:33.278] parsetree_list = 0x55d814541cb8 [17:42:33.278] parsetree_item = 0x55d814541cd0 [17:42:33.278] save_log_statement_stats = false [17:42:33.278] was_logged = true [17:42:33.278] use_implicit_block = false [17:42:33.278] msec_str = "@\355\271\301\375\177\000\000\242\214\373\021\330U\000\000p\353\271\301\375\177\000\000\026\001\000\000\000\000\000" [17:42:33.278] __func__ = "exec_simple_query" [17:42:33.278] #18 0x000055d811ce7fd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [17:42:33.278] query_string = 0x55d814364280 "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"... [17:42:33.278] firstchar = [17:42:33.278] input_message = {data = 0x55d814364280 "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} [17:42:33.278] local_sigjmp_buf = {{__jmpbuf = {94386515495320, -1075145826535620740, 4, 140727853641024, 140727853641172, 1, -6530229808772038788, -1075139332044374148}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 139738385321444, 94386540371760, 14336, 14400, 94386503110691, 94386515495328, 94386540371760, 94386515489400, 140727853641024, 140727853641172, 94386503114759, 140727853640800}}}} [17:42:33.278] send_ready_for_query = false [17:42:33.278] idle_in_transaction_timeout_enabled = false [17:42:33.278] idle_session_timeout_enabled = false [17:42:33.278] __func__ = "PostgresMain" [17:42:33.278] #19 0x000055d811cde78a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [17:42:33.278] bsdata = [17:42:33.278] #20 0x000055d811b88ff7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffdc1b9ecec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdc1b9ed40) at ../src/backend/postmaster/launch_backend.c:265 [17:42:33.278] pid = [17:42:33.278] #21 0x000055d811b8f177 in BackendStartup (client_sock=client_sock@entry=0x7ffdc1b9ed40) at ../src/backend/postmaster/postmaster.c:3593 [17:42:33.278] bn = 0x55d81439a698 [17:42:33.278] pid = [17:42:33.278] startup_data = {canAcceptConnections = CAC_OK} [17:42:33.278] __func__ = "BackendStartup" [17:42:33.278] #22 0x000055d811b8f725 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [17:42:33.278] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\346`\027\177\000\000\001\000\000\000\000\000\000\000\244#ab\027\177\000\000-\000\000\000\000\000\000\000\020N\312`\027\177\000\000 \031\232a\027\177\000\000\b\356\271\301\375\177\000\000\004\356\271\301\375\177\000\000\304\355\271\301\375\177\000\000@\276\000\000\001\000\000\000\000\000\000\000\330U\000\000\020N\312`\027\177\000\000\340o\311`\027\177\000\000\352\257\346`\027\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [17:42:33.278] i = 0 [17:42:33.278] now = [17:42:33.278] last_lockfile_recheck_time = 1711301944 [17:42:33.278] last_touch_time = 1711301944 [17:42:33.278] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1044779328, events = 32765, fd = 45, user_data = 0x7ffdc1b9ee80}, {pos = -1044779376, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 1637488520, user_data = 0x7f1760e6afea}, {pos = -1044779160, events = 32765, fd = -1044779328, user_data = 0x7ffdc1b9eed0}, {pos = 1650535649, events = 32535, fd = 18, user_data = 0x7f175e668618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1637487648, events = 32535, fd = -1, user_data = 0x7f175e668618}, {pos = 1637487648, events = 32535, fd = 1024, user_data = 0x7f17619a1788}, {pos = 0, events = 0, fd = 7, user_data = 0x7ffdc1b9eed0}, {pos = -1, events = 0, fd = 1624595642, user_data = 0x7f1760c97418}, {pos = 1637488928, events = 32535, fd = 339268648, user_data = 0x55d81438d2b8}, {pos = 339275968, events = 21976, fd = 339268680, user_data = 0x55d81438e3a1}, {pos = 1650554403, events = 32535, fd = 1, user_data = 0x7f1760e840f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = 339107872, user_data = 0x7f1762617623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x55d81438f0c0}, {pos = 1623815192, events = 32535, fd = -1044778224, user_data = 0x7f176261e68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffdc1b9f330}, {pos = 314140512, events = 21976, fd = 2, user_data = 0x55d812b96760 }, {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 = 339268568, 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 = 807411744, events = 808465457, fd = 538976266, user_data = 0x0}, {pos = 0, events = 0, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x3030343736202020}, {pos = 538976309, 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 = 1624333614, user_data = 0x400}, {pos = 339091408, events = 21976, fd = 1625678976, user_data = 0x114361fd0}, {pos = 784, events = 0, fd = 304119436, user_data = 0x55d81438cf90}, {pos = -1009770496, events = 277810566, fd = 4, user_data = 0x55d81438d3a0}, {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 = 0x55d81438cf90}, {pos = 1, events = 0, fd = 339267672, user_data = 0x400}, {pos = 0, events = 0, fd = 301894087, user_data = 0x55d812ba4950 }, {pos = 301827763, events = 21976, fd = 339267472, user_data = 0x55d814364180}, {pos = 339267472, events = 21976, fd = 15, user_data = 0x4a}, {pos = 301895855, events = 21976, fd = 339267472, user_data = 0x55d811fe91f1 }, {pos = 339091408, events = 21976, fd = 1624333614, user_data = 0x0}, {pos = 295348947, events = 21976, fd = 339262320, user_data = 0x7f1760d121aa}, {pos = -1044778040, events = 1, fd = 0, user_data = 0x7f1760d108f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 16237, user_data = 0x7f1760d5ab05 }, {pos = 0, events = 0, fd = -1009770496, user_data = 0x0}, {pos = 297307421, events = 21976, fd = 4194304, user_data = 0x55d811fd8547 }, {pos = 339262320, events = 21976, fd = 339100032, user_data = 0x55d81438bb70}, {pos = 1, events = 0, fd = 0, user_data = 0x55d811fe90af }, {pos = 339262320, events = 21976, fd = 301896177, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55d8119aa6a6 }, {pos = 0, events = 0, fd = 295371900, user_data = 0xb}, {pos = 297328841, events = 21976, fd = 0, user_data = 0x0}} [17:42:33.279] nevents = 1 [17:42:33.279] __func__ = "ServerLoop" [17:42:33.279] #23 0x000055d811b91147 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55d81435de40) at ../src/backend/postmaster/postmaster.c:1372 [17:42:33.279] opt = [17:42:33.279] status = [17:42:33.279] userDoption = [17:42:33.279] listen_addr_saved = false [17:42:33.279] output_config_variable = [17:42:33.279] __func__ = "PostmasterMain" [17:42:33.279] #24 0x000055d8119bb4d6 in main (argc=4, argv=0x55d81435de40) at ../src/backend/main/main.c:197 [17:42:33.279] do_check_root = [17:42:33.297] -e [17:42:33.297] [17:42:33.297] [17:42:33.831] dumping /tmp/cores/postgres-6-24849.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:42:34.140] [New LWP 24849] [17:42:35.272] [Thread debugging using libthread_db enabled] [17:42:35.272] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [17:42:36.695] Core was generated by `postgres: primary: postgres regression [local] MERGE '. [17:42:36.695] Program terminated with signal SIGABRT, Aborted. [17:42:36.695] #0 0x00007ff10ee82ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:36.903] [17:42:36.903] Thread 1 (Thread 0x7ff10c819a40 (LWP 24849)): [17:42:36.903] #0 0x00007ff10ee82ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:36.903] No symbol table info available. [17:42:36.903] #1 0x00007ff10ee6c537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:36.903] No symbol table info available. [17:42:36.903] #2 0x000055a239ece8c9 in ExceptionalCondition (conditionName=conditionName@entry=0x55a23a1174a8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x55a23a13ba98 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [17:42:36.903] No locals. [17:42:36.903] #3 0x000055a2398356a8 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fffcf535a80, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fffcf53591f) at ../src/backend/executor/execTuples.c:1728 [17:42:36.903] No locals. [17:42:36.903] #4 0x000055a2397b8a65 in ExecIRDeleteTriggers (estate=estate@entry=0x55a23b9c5070, relinfo=relinfo@entry=0x55a23b9c5620, slot=slot@entry=0x7fffcf535a80) at ../src/backend/commands/trigger.c:2841 [17:42:36.903] trigger = 0x55a23b9c5880 [17:42:36.903] oldtuple = [17:42:36.903] trigdesc = 0x55a23b9c5830 [17:42:36.903] newtuple = 0x0 [17:42:36.903] should_free = false [17:42:36.903] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7ff10a9bc4e8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [17:42:36.903] i = 0 [17:42:36.903] #5 0x000055a2398984da in ExecMergeMatched (context=0x7fffcf535aa0, resultRelInfo=resultRelInfo@entry=0x55a23b9c5620, tupleid=0x0, oldtuple=0x7fffcf535a80, canSetTag=true, matched=matched@entry=0x7fffcf535a2f) at ../src/backend/executor/nodeModifyTable.c:2991 [17:42:36.903] relaction = 0x55a23b9b3db8 [17:42:36.903] commandType = CMD_DELETE [17:42:36.903] result = TM_Ok [17:42:36.903] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [17:42:36.903] l__state = {l = , i = } [17:42:36.903] mtstate = 0x55a23b9c5410 [17:42:36.903] newslot = 0x0 [17:42:36.903] rslot = 0x0 [17:42:36.903] estate = 0x55a23b9c5070 [17:42:36.903] econtext = 0x55a23b9b6b08 [17:42:36.903] isNull = false [17:42:36.903] epqstate = 0x55a23b9c54f8 [17:42:36.903] l = [17:42:36.903] lmerge_matched = [17:42:36.903] __func__ = "ExecMergeMatched" [17:42:36.903] #6 0x000055a23989938e in ExecMerge (context=context@entry=0x7fffcf535aa0, resultRelInfo=resultRelInfo@entry=0x55a23b9c5620, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fffcf535a80, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2772 [17:42:36.903] rslot = 0x0 [17:42:36.903] matched = true [17:42:36.903] #7 0x000055a23989acde in ExecModifyTable (pstate=0x55a23b9c5410) at ../src/backend/executor/nodeModifyTable.c:4028 [17:42:36.903] node = 0x55a23b9c5410 [17:42:36.903] context = {mtstate = 0x55a23b9c5410, epqstate = 0x55a23b9c54f8, estate = 0x55a23b9c5070, planSlot = 0x55a23b9b5518, tmfd = {ctid = {ip_blkid = {bi_hi = 29576, bi_lo = 15259}, ip_posid = 21922}, xmax = 1000480376, cmax = 21922, traversed = 16}, cpUpdateReturningSlot = 0x55a23981b69c } [17:42:36.903] estate = 0x55a23b9c5070 [17:42:36.903] operation = CMD_MERGE [17:42:36.903] resultRelInfo = 0x55a23b9c5620 [17:42:36.903] subplanstate = 0x55a23b9c5d50 [17:42:36.903] slot = [17:42:36.903] oldSlot = [17:42:36.903] tuple_ctid = {ip_blkid = {bi_hi = 15259, bi_lo = 21922}, ip_posid = 0} [17:42:36.903] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x55a23b9dd108} [17:42:36.903] oldtuple = 0x7fffcf535a80 [17:42:36.903] tupleid = 0x0 [17:42:36.903] __func__ = "ExecModifyTable" [17:42:36.903] #8 0x000055a239827873 in ExecProcNodeFirst (node=0x55a23b9c5410) at ../src/backend/executor/execProcnode.c:464 [17:42:36.903] No locals. [17:42:36.903] #9 0x000055a239814134 in ExecProcNode (node=0x55a23b9c5410) at ../src/include/executor/executor.h:274 [17:42:36.903] No locals. [17:42:36.903] #10 ExecutePlan (estate=estate@entry=0x55a23b9c5070, planstate=0x55a23b9c5410, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55a23ba002a0, execute_once=true) at ../src/backend/executor/execMain.c:1644 [17:42:36.903] slot = [17:42:36.903] current_tuple_count = 0 [17:42:36.903] #11 0x000055a23981447e in standard_ExecutorRun (queryDesc=queryDesc@entry=0x55a23b9c4268, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [17:42:36.903] estate = 0x55a23b9c5070 [17:42:36.903] operation = CMD_MERGE [17:42:36.903] dest = 0x55a23ba002a0 [17:42:36.903] sendTuples = true [17:42:36.903] oldcontext = 0x55a23b9fff90 [17:42:36.903] __func__ = "standard_ExecutorRun" [17:42:36.903] #12 0x00007ff10c63e7fc in pgss_ExecutorRun (queryDesc=0x55a23b9c4268, direction=ForwardScanDirection, count=0, execute_once=) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [17:42:36.903] _save_exception_stack = 0x7fffcf535e70 [17:42:36.903] _save_context_stack = 0x0 [17:42:36.903] _local_sigjmp_buf = {{__jmpbuf = {94155273159272, -269057097897517660, 94155271799488, 94155273405088, 0, 0, -269057097954140764, -263007992742847068}, __mask_was_saved = 0, __saved_mask = {__val = {94155273162864, 94155273159272, 0, 94155273404304, 94155245263429, 0, 1, 0, 94155238019803, 94155273159272, 94155257559456, 94155273404304, 140673271727138, 94155273159272, 0, 94155271799488}}}} [17:42:36.903] _do_rethrow = false [17:42:36.903] #13 0x000055a2398145dc in ExecutorRun (queryDesc=queryDesc@entry=0x55a23b9c4268, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:302 [17:42:36.903] No locals. [17:42:36.903] #14 0x000055a239c28838 in ProcessQuery (plan=plan@entry=0x55a23ba25020, sourceText=0x55a23b8782c0 "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=0x55a23ba002a0, qc=qc@entry=0x7fffcf535dd0) at ../src/backend/tcop/pquery.c:160 [17:42:36.903] queryDesc = 0x55a23b9c4268 [17:42:36.903] #15 0x000055a239c2a581 in PortalRunMulti (portal=portal@entry=0x55a23b8f9fd0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55a23ba002a0, altdest=0x55a23a3f76c0 , qc=qc@entry=0x7fffcf535dd0) at ../src/backend/tcop/pquery.c:1277 [17:42:36.903] pstmt = 0x55a23ba25020 [17:42:36.903] stmtlist_item__state = {l = , i = } [17:42:36.903] active_snapshot_set = true [17:42:36.903] stmtlist_item = 0x55a23ba25148 [17:42:36.903] #16 0x000055a239c2ac27 in FillPortalStore (portal=portal@entry=0x55a23b8f9fd0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [17:42:36.903] treceiver = 0x55a23ba002a0 [17:42:36.903] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:42:36.903] __func__ = "FillPortalStore" [17:42:36.903] #17 0x000055a239c2b286 in PortalRun (portal=portal@entry=0x55a23b8f9fd0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55a23ba25180, altdest=altdest@entry=0x55a23ba25180, qc=0x7fffcf535fb0) at ../src/backend/tcop/pquery.c:763 [17:42:36.903] _save_exception_stack = 0x7fffcf536060 [17:42:36.903] _save_context_stack = 0x0 [17:42:36.903] _local_sigjmp_buf = {{__jmpbuf = {1, 268953016942812580, 94155273556352, 94155273042832, 94155272331216, 94155273042760, -269057098021249628, -6269027322927293020}, __mask_was_saved = 0, __saved_mask = {__val = {94155272342776, 94155248015614, 94155272339424, 94155248015614, 1, 140736671735615, 94155273042808, 94155273042760, 94155245002761, 94155247602633, 94155272331216, 94155248015614, 1, 1, 94155245263429, 163}}}} [17:42:36.903] _do_rethrow = [17:42:36.903] result = [17:42:36.903] nprocessed = [17:42:36.903] saveTopTransactionResourceOwner = 0x55a23b8b94a0 [17:42:36.903] saveTopTransactionContext = 0x55a23b8a48b0 [17:42:36.903] saveActivePortal = 0x0 [17:42:36.903] saveResourceOwner = 0x55a23b8b94a0 [17:42:36.903] savePortalContext = 0x0 [17:42:36.903] saveMemoryContext = 0x55a23b8a48b0 [17:42:36.903] __func__ = "PortalRun" [17:42:36.903] #18 0x000055a239c2421b in exec_simple_query (query_string=query_string@entry=0x55a23b8782c0 "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 [17:42:36.903] cmdtaglen = 5 [17:42:36.903] snapshot_set = [17:42:36.903] per_parsetree_context = 0x0 [17:42:36.903] plantree_list = 0x55a23ba25130 [17:42:36.903] parsetree = 0x55a23b9a7b48 [17:42:36.903] commandTag = [17:42:36.903] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:42:36.903] querytree_list = [17:42:36.903] portal = 0x55a23b8f9fd0 [17:42:36.903] receiver = 0x55a23ba25180 [17:42:36.903] format = 0 [17:42:36.903] cmdtagname = [17:42:36.903] parsetree_item__state = {l = , i = } [17:42:36.903] dest = DestRemote [17:42:36.903] oldcontext = 0x55a23b8a48b0 [17:42:36.903] parsetree_list = 0x55a23b9a7b78 [17:42:36.903] parsetree_item = 0x55a23b9a7b90 [17:42:36.903] save_log_statement_stats = false [17:42:36.903] was_logged = true [17:42:36.903] use_implicit_block = false [17:42:36.903] msec_str = "\020bS\317\377\177\000\000\242|\357\071\242U\000\000@`S\317\377\177\000\000\026\001\000\000\000\000\000" [17:42:36.903] __func__ = "exec_simple_query" [17:42:36.903] #19 0x000055a239c26fd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [17:42:36.903] query_string = 0x55a23b8782c0 "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"... [17:42:36.903] firstchar = [17:42:36.903] input_message = {data = 0x55a23b8782c0 "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} [17:42:36.903] local_sigjmp_buf = {{__jmpbuf = {94155257559448, -6269021657098789468, 4, 140736671736336, 140736671736484, 1, -269057097547293276, -6269027324875940444}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94155271774064, 16384, 8248, 94155245176526, 0, 0, 0, 94155257559456, 94155271774064, 94155257553528, 140736671736336, 140736671736484, 1, 94155245179576, 140736671736112}}}} [17:42:36.903] send_ready_for_query = false [17:42:36.903] idle_in_transaction_timeout_enabled = false [17:42:36.903] idle_session_timeout_enabled = false [17:42:36.903] __func__ = "PostgresMain" [17:42:36.903] #20 0x000055a239c1d78a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [17:42:36.903] bsdata = [17:42:36.903] #21 0x000055a239ac7ff7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffcf5361bc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffcf536210) at ../src/backend/postmaster/launch_backend.c:265 [17:42:36.903] pid = [17:42:36.903] #22 0x000055a239ace177 in BackendStartup (client_sock=client_sock@entry=0x7fffcf536210) at ../src/backend/postmaster/postmaster.c:3593 [17:42:36.903] bn = 0x55a23b8a4b18 [17:42:36.903] pid = [17:42:36.903] startup_data = {canAcceptConnections = CAC_OK} [17:42:36.903] __func__ = "BackendStartup" [17:42:36.903] #23 0x000055a239ace725 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [17:42:36.903] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "|\020\361\177\000\000-\000\000\000\000\000\000\000\020\276\345\016\361\177\000\000 \211\265\017\361\177\000\000\310bS\317\377\177\000\000\304bS\317\377\177\000\000\204bS\317\377\177\000\000\020%\212;\242U\000\000\000\000\000\000\377\177\000\000\020\276\345\016\361\177\000\000\340\337\344\016\361\177\000\000\352\037\002\017\361\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\304bS\317\377\177\000", __ss_align = 94155271972112}, salen = 2}} [17:42:36.903] i = 0 [17:42:36.903] now = [17:42:36.903] last_lockfile_recheck_time = 1711301963 [17:42:36.903] last_touch_time = 1711301963 [17:42:36.903] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -816618688, events = 32767, fd = -816618672, user_data = 0x0}, {pos = 18, events = 0, fd = 1508362478, user_data = 0x7ff10fb58788}, {pos = 251797482, events = 32753, fd = -816618456, user_data = 0x7fffcf536380}, {pos = -816618608, events = 32767, fd = 276602081, user_data = 0x12}, {pos = 209843736, events = 32753, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 263554080, user_data = 0xffffffff}, {pos = 209843736, events = 32753, fd = 263554080, user_data = 0x10fb58920}, {pos = 263554952, events = 32753, fd = 0, user_data = 0x7fffcf53649e}, {pos = -816618352, events = 32767, fd = -1, user_data = 0x7fffcf5363a0}, {pos = 249881624, events = 32753, fd = 263555360, user_data = 0x55a23b8a8578}, {pos = 998933512, events = 21922, fd = 998914960, user_data = 0x55a23b8a8598}, {pos = 998932673, events = 21922, fd = 276620835, user_data = 0x1}, {pos = 251900152, events = 32753, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x55a23b87a120}, {pos = 276620835, events = 32753, fd = 1, user_data = 0x0}, {pos = 998914960, events = 21922, fd = 249881624, user_data = 0x7fffcf5367e0}, {pos = 276649610, events = 32753, fd = 0, user_data = 0x0}, {pos = -816617472, events = 32767, fd = 984438624, user_data = 0x2}, {pos = 984438624, events = 21922, fd = 0, user_data = 0x7ff10f018be0}, {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 = 998955384, 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 = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {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 = 0x0}, {pos = 0, events = 0, fd = 251742336, user_data = 0x7ff10eec751a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = 250399739, user_data = 0x400}, {pos = 998727696, events = 21922, fd = 251745408, user_data = 0x13b876010}, {pos = 784, events = 0, fd = 974417548, user_data = 0x55a23b8a80e0}, {pos = -345272576, events = 644789695, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 998932704, events = 21922, fd = 998932704, user_data = 0x55a23b8a80e0}, {pos = 1, events = 0, fd = 998932904, user_data = 0x400}, {pos = 0, events = 0, fd = 972192199, user_data = 0x55a23aae3950 }, {pos = 972125875, events = 21922, fd = 998932704, user_data = 0x55a23b8781c0}, {pos = 998932704, events = 21922, fd = 15, user_data = 0x4a}, {pos = 972193967, events = 21922, fd = 998932704, user_data = 0x55a239f281f1 }, {pos = 998727696, events = 21922, fd = 250400046, user_data = 0x0}, {pos = 965647059, events = 21922, fd = 998906864, user_data = 0x7ff10eec91aa}, {pos = -816617320, events = 1, fd = 0, user_data = 0x7ff10eec78f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 22836, user_data = 0x7ff10ef11b05 }, {pos = 0, events = 0, fd = -345272576, user_data = 0x0}, {pos = 967605533, events = 21922, fd = 4194304, user_data = 0x55a239f17547 }, {pos = 998906864, events = 21922, fd = 998736320, user_data = 0x55a23b8a1bf0}, {pos = 1, events = 0, fd = 0, user_data = 0x55a239f280af }, {pos = 998906864, events = 21922, fd = 972194289, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55a2398e96a6 }, {pos = 0, events = 0, fd = 965670012, user_data = 0xb}, {pos = 967626953, events = 21922, fd = 0, user_data = 0x0}} [17:42:36.903] nevents = 1 [17:42:36.903] __func__ = "ServerLoop" [17:42:36.903] #24 0x000055a239ad0147 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a23b871e70) at ../src/backend/postmaster/postmaster.c:1372 [17:42:36.904] opt = [17:42:36.904] status = [17:42:36.904] userDoption = [17:42:36.904] listen_addr_saved = false [17:42:36.904] output_config_variable = [17:42:36.904] __func__ = "PostmasterMain" [17:42:36.904] #25 0x000055a2398fa4d6 in main (argc=4, argv=0x55a23b871e70) at ../src/backend/main/main.c:197 [17:42:36.904] do_check_root = [17:42:36.922] -e [17:42:36.922] [17:42:36.922] [17:42:37.462] dumping /tmp/cores/postgres-3-28688.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:42:37.771] [New LWP 28688] [17:42:37.771] [New LWP 27261] [17:42:38.909] [Thread debugging using libthread_db enabled] [17:42:38.909] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [17:42:40.335] Core was generated by `postgres: standby2: startup recovering 000000010000000000000006 '. [17:42:40.335] Program terminated with signal SIGQUIT, Quit. [17:42:40.335] #0 0x00007f937d4c2fc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.341] [Current thread is 1 (LWP 28688)] [17:42:40.439] [17:42:40.439] Thread 2 (Thread 0x7f937ae59a40 (LWP 27261)): [17:42:40.439] #0 0x00007f937d585a61 in clone () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.439] No symbol table info available. [17:42:40.439] #1 0x00007f937d573e5e in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.439] No symbol table info available. [17:42:40.439] #2 0x00007f937d574497 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.439] No symbol table info available. [17:42:40.439] #3 0x00007f937d573cdb in posix_spawn () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.439] No symbol table info available. [17:42:40.439] #4 0x00007f937d4cfa69 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.439] No symbol table info available. [17:42:40.439] #5 0x0000561a81add7c2 in RestoreArchivedFile (path=path@entry=0x7ffd86ae7220 "", xlogfname=xlogfname@entry=0x7ffd86ae71e0 "00000002.history", recovername=recovername@entry=0x561a825c6b30 "RECOVERYHISTORY", expectedSize=expectedSize@entry=0, cleanupEnabled=cleanupEnabled@entry=false) at ../src/backend/access/transam/xlogarchive.c:177 [17:42:40.439] xlogpath = "pg_wal/RECOVERYHISTORY\000\000\b\000\000\000\000\000\000\066\000\000\000\000\000\000\000\000\345aB\202\000\000\000\062\000\000\000\000\000\000\000\000\b\000\000\000\000\000\000\000\374\062\\\202\032V\000\000\b\000\000\000\000\000\000\000y\330[\202\032V\000\000\bq\256\206\375\177\000\000u\330[\202\032V\000\000\021]B\202\032V\000\000\201\330[\202\032V\000\000y\330[\202\032V\000\000\bq\256\206\375\177\000\000u\330[\202\032V\000\000\030\231\345z\223\177\000\000\257fB\202\032V", '\000' , "\b", '\000' , "\060", '\000' , "\002\000\000\000\000\000\000\000"... [17:42:40.439] xlogRestoreCmd = 0x561a844ca6c8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/040_standby_failover_slots_sync/data/t_040_standby_failover_slots_sync_publisher_data/archives/00000002.history\" \"pg_wal/RECOVERYHISTORY\"" [17:42:40.439] lastRestartPointFname = '0' , "\000j\\\202\032V\000\000\250l\256\206\375\177\000\000\343j\\\202\032V\000\000\030\231\345z\223\177\000\000mgB\202\032V", '\000' , "\b", '\000' , "\060", '\000' , "\002", '\000' ... [17:42:40.439] rc = [17:42:40.439] stat_buf = {st_dev = 140271398787352, st_ino = 208343820141, st_nlink = 0, st_mode = 0, st_uid = 0, st_gid = 0, __pad0 = 0, st_rdev = 48, st_size = 5922071200885860208, st_blksize = 6366210006019162949, st_blocks = 4673356, st_atim = {tv_sec = 0, tv_nsec = 0}, st_mtim = {tv_sec = 3891110078048108544, tv_nsec = 0}, st_ctim = {tv_sec = 0, tv_nsec = 0}, __glibc_reserved = {8, 94671856218876, 140726863031464}} [17:42:40.439] restartSegNo = [17:42:40.439] restartRedoPtr = 94671854526949 [17:42:40.439] restartTli = 0 [17:42:40.439] __func__ = "RestoreArchivedFile" [17:42:40.439] #6 0x0000561a81ab3bd0 in existsTimeLineHistory (probeTLI=probeTLI@entry=2) at ../src/backend/access/transam/timeline.c:235 [17:42:40.439] path = '\000' , "\001\000\000\000\000\000\000\000\301Ʈ\201\032V\000\000\001\000\000\000\000\000\000\000\a\000\000\000\r\000\000\000Pv\256\206\375\177\000\000\000v\256\206\375\177\000\000\001\000\000\000\000\000\000\000\004\000\000\t", '\000' , "\002(\372\202\032V\000\000\200(\372\202\032V\000\000\324s\256\206\375\177\000\000\370\254g\202\032V\000\000\240\037\000\000\377\377\002\000\200(\372\202\032V\000\000\364s\256\206\375\177\000\000\a\255g\202\032V\000\000\200(\372\202\032V\000\000\002\000\000\000\000\000\000\000\016wB\202\032V\000\000\366s\256\206\375\177\000\000\364s\256\206\375\177", '\000' ... [17:42:40.439] histfname = "00000002.history", '\000' [17:42:40.439] fd = [17:42:40.439] __func__ = "existsTimeLineHistory" [17:42:40.439] #7 0x0000561a81ab3cbb in findNewestTimeLine (startTLI=startTLI@entry=1) at ../src/backend/access/transam/timeline.c:277 [17:42:40.439] newestTLI = 1 [17:42:40.439] probeTLI = 2 [17:42:40.439] #8 0x0000561a81ae878d in rescanLatestTimeLine (replayTLI=replayTLI@entry=1, replayLSN=replayLSN@entry=100683536) at ../src/backend/access/transam/xlogrecovery.c:4113 [17:42:40.439] newExpectedTLEs = [17:42:40.439] found = [17:42:40.439] cell = [17:42:40.439] newtarget = [17:42:40.439] oldtarget = 1 [17:42:40.439] currentTle = 0x0 [17:42:40.439] __func__ = "rescanLatestTimeLine" [17:42:40.439] #9 0x0000561a81aed93d in WaitForWALToBecomeAvailable (RecPtr=RecPtr@entry=100683560, randAccess=false, fetching_ckpt=false, tliRecPtr=tliRecPtr@entry=100683536, replayTLI=1, replayLSN=100683536, nonblocking=false) at ../src/backend/access/transam/xlogrecovery.c:3674 [17:42:40.439] oldSource = XLOG_FROM_STREAM [17:42:40.439] startWalReceiver = false [17:42:40.439] last_fail_time = 764617179547815 [17:42:40.439] now = [17:42:40.439] streaming_reply_sent = true [17:42:40.439] __func__ = "WaitForWALToBecomeAvailable" [17:42:40.439] #10 0x0000561a81aee373 in XLogPageRead (xlogreader=0x561a84477ff0, targetPagePtr=100679680, reqLen=3880, targetRecPtr=100683536, readBuf=0x561a844c6e98 "\024\321\006") at ../src/backend/access/transam/xlogrecovery.c:3351 [17:42:40.439] private = 0x561a84477fd0 [17:42:40.439] emode = 15 [17:42:40.439] targetPageOff = 16384 [17:42:40.439] targetSegNo = 6 [17:42:40.439] r = [17:42:40.439] __func__ = "XLogPageRead" [17:42:40.439] #11 0x0000561a81af67ce in ReadPageInternal (state=state@entry=0x561a84477ff0, pageptr=pageptr@entry=100679680, reqLen=reqLen@entry=3880) at ../src/backend/access/transam/xlogreader.c:1060 [17:42:40.439] readLen = [17:42:40.439] targetPageOff = 16384 [17:42:40.439] targetSegNo = 6 [17:42:40.439] hdr = [17:42:40.439] #12 0x0000561a81af8429 in XLogDecodeNextRecord (state=state@entry=0x561a84477ff0, nonblocking=nonblocking@entry=false) at ../src/backend/access/transam/xlogreader.c:597 [17:42:40.439] RecPtr = 100683536 [17:42:40.439] record = [17:42:40.439] targetPagePtr = 100679680 [17:42:40.439] randAccess = false [17:42:40.439] len = [17:42:40.439] total_len = [17:42:40.439] targetRecOff = 3856 [17:42:40.439] pageHeaderSize = [17:42:40.439] assembled = false [17:42:40.439] gotheader = [17:42:40.439] readOff = [17:42:40.439] decoded = 0x0 [17:42:40.439] errormsg = 0x561a82669101 "LOG" [17:42:40.439] #13 0x0000561a81af8fcb in XLogReadAhead (state=0x561a84477ff0, nonblocking=nonblocking@entry=false) at ../src/backend/access/transam/xlogreader.c:973 [17:42:40.439] result = [17:42:40.439] #14 0x0000561a81ae390d in XLogPrefetcherNextBlock (pgsr_private=94671888420384, lsn=0x561a844dc818) at ../src/backend/access/transam/xlogprefetcher.c:492 [17:42:40.439] nonblocking = [17:42:40.439] record = [17:42:40.439] prefetcher = 0x561a84478e20 [17:42:40.439] reader = 0x561a84477ff0 [17:42:40.439] replaying_lsn = 100683488 [17:42:40.439] __func__ = "XLogPrefetcherNextBlock" [17:42:40.439] #15 0x0000561a81ae7cd6 in lrq_prefetch (lrq=) at ../src/backend/access/transam/xlogprefetcher.c:252 [17:42:40.439] No locals. [17:42:40.439] #16 lrq_complete_lsn (lsn=0, lrq=0x561a844dc748) at ../src/backend/access/transam/xlogprefetcher.c:290 [17:42:40.439] No locals. [17:42:40.439] #17 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x561a84478e20, errmsg=errmsg@entry=0x7ffd86aeb968) at ../src/backend/access/transam/xlogprefetcher.c:1037 [17:42:40.439] record = [17:42:40.439] replayed_up_to = 0 [17:42:40.439] #18 0x0000561a81aeeba0 in ReadRecord (xlogprefetcher=0x561a84478e20, emode=emode@entry=15, fetching_ckpt=fetching_ckpt@entry=false, replayTLI=1) at ../src/backend/access/transam/xlogrecovery.c:3151 [17:42:40.439] errormsg = 0x561a84478800 "" [17:42:40.439] record = [17:42:40.439] xlogreader = 0x561a84477ff0 [17:42:40.439] private = [17:42:40.439] __func__ = "ReadRecord" [17:42:40.439] #19 0x0000561a81af1d37 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1832 [17:42:40.439] xtime = [17:42:40.439] ru0 = {tv = {tv_sec = 1711301975, tv_usec = 432645}, ru = {ru_utime = {tv_sec = 0, tv_usec = 1455}, ru_stime = {tv_sec = 0, tv_usec = 0}, {ru_maxrss = 16324, __ru_maxrss_word = 16324}, {ru_ixrss = 0, __ru_ixrss_word = 0}, {ru_idrss = 0, __ru_idrss_word = 0}, {ru_isrss = 0, __ru_isrss_word = 0}, {ru_minflt = 404, __ru_minflt_word = 404}, {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 = 3, __ru_nvcsw_word = 3}, {ru_nivcsw = 1, __ru_nivcsw_word = 1}}} [17:42:40.439] record = 0x7f937a713f70 [17:42:40.439] reachedRecoveryTarget = false [17:42:40.457] replayTLI = 1 [17:42:40.457] __func__ = "PerformWalRecovery" [17:42:40.457] #20 0x0000561a81adb9e4 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5723 [17:42:40.457] Insert = [17:42:40.457] checkPoint = {redo = 83886120, ThisTimeLineID = 1, PrevTimeLineID = 1, fullPageWrites = true, nextXid = {value = 749}, nextOid = 24576, nextMulti = 1, nextMultiOffset = 0, oldestXid = 730, oldestXidDB = 1, oldestMulti = 1, oldestMultiDB = 1, time = 1711301975, oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 749} [17:42:40.457] wasShutdown = false [17:42:40.457] didCrash = [17:42:40.457] haveTblspcMap = false [17:42:40.457] haveBackupLabel = true [17:42:40.457] EndOfLog = [17:42:40.457] EndOfLogTLI = [17:42:40.457] newTLI = [17:42:40.457] performedWalRecovery = [17:42:40.457] endOfRecoveryInfo = [17:42:40.457] abortedRecPtr = [17:42:40.457] missingContrecPtr = [17:42:40.457] oldestActiveXID = [17:42:40.457] promoted = false [17:42:40.457] __func__ = "StartupXLOG" [17:42:40.457] #21 0x0000561a81f9182d in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [17:42:40.457] No locals. [17:42:40.457] #22 0x0000561a81f88ff7 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 [17:42:40.457] pid = [17:42:40.457] #23 0x0000561a81f8aec2 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3928 [17:42:40.457] pid = [17:42:40.457] __func__ = "StartChildProcess" [17:42:40.457] #24 0x0000561a81f90f8c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x561a84476eb0) at ../src/backend/postmaster/postmaster.c:1364 [17:42:40.457] opt = [17:42:40.457] status = [17:42:40.457] userDoption = [17:42:40.457] listen_addr_saved = false [17:42:40.457] output_config_variable = [17:42:40.457] __func__ = "PostmasterMain" [17:42:40.457] #25 0x0000561a81dbb4d6 in main (argc=4, argv=0x561a84476eb0) at ../src/backend/main/main.c:197 [17:42:40.457] do_check_root = [17:42:40.457] [17:42:40.457] Thread 1 (LWP 28688): [17:42:40.457] #0 0x00007f937d4c2fc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.457] No symbol table info available. [17:42:40.457] #1 0x00007f937d57413a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.457] No symbol table info available. [17:42:40.457] #2 0x00007f937d585a6f in clone () from /lib/x86_64-linux-gnu/libc.so.6 [17:42:40.457] No symbol table info available.