[20:48:06.653] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [20:48:06.971] dumping /tmp/cores/postgres.8261.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:48:07.093] [New LWP 101672] [20:48:07.171] Core was generated by `postgres: postgres regression [local] MERGE'. [20:48:07.171] Program terminated with signal SIGABRT, Aborted. [20:48:07.171] Sent by thr_kill() from pid 8261 and user 1003. [20:48:07.171] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:07.720] [20:48:07.720] Thread 1 (LWP 101672): [20:48:07.720] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:07.720] No symbol table info available. [20:48:07.720] #1 0x000000082d393e64 in raise () from /lib/libc.so.7 [20:48:07.720] No symbol table info available. [20:48:07.720] #2 0x000000082d4446f9 in abort () from /lib/libc.so.7 [20:48:07.720] No symbol table info available. [20:48:07.720] #3 0x0000000000a911b5 in ExceptionalCondition (conditionName=0x2d1bc8 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [20:48:07.720] No locals. [20:48:07.720] #4 0x0000000000772d9f in ExecFetchSlotHeapTuple (slot=0x821a43e68, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [20:48:07.720] No locals. [20:48:07.720] #5 0x0000000000737747 in ExecIRDeleteTriggers (estate=estate@entry=0x836ad6100, relinfo=relinfo@entry=0x836ad66b0, slot=slot@entry=0x821a43e68) at ../src/backend/commands/trigger.c:2842 [20:48:07.720] trigger = [20:48:07.720] oldtuple = [20:48:07.720] should_free = false [20:48:07.720] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x847510740, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [20:48:07.720] trigdesc = 0x836ad68c0 [20:48:07.720] newtuple = 0x0 [20:48:07.720] i = 0 [20:48:07.720] #6 0x0000000000798064 in ExecMergeMatched (context=0x821a43ef8, resultRelInfo=0x836ad66b0, tupleid=0x0, oldtuple=0x821a43e68, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [20:48:07.720] result = TM_Ok [20:48:07.720] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [20:48:07.720] relaction = 0x83901eea0 [20:48:07.720] commandType = CMD_DELETE [20:48:07.720] l__state = {l = 0x8390efd78, i = 0} [20:48:07.720] lockedtid = [20:48:07.720] mtstate = 0x836ad64a0 [20:48:07.720] newslot = 0x0 [20:48:07.720] rslot = 0x0 [20:48:07.720] estate = 0x836ad6100 [20:48:07.720] mergeActions = [20:48:07.720] econtext = 0x8390eee18 [20:48:07.720] epqstate = 0x836ad6588 [20:48:07.720] actionStates = 0x8390efd78 [20:48:07.720] l = [20:48:07.720] isNull = [20:48:07.720] lmerge_matched = [20:48:07.720] __error = [20:48:07.720] l__state = [20:48:07.720] result = [20:48:07.720] updateCxt = [20:48:07.720] relaction = [20:48:07.720] commandType = [20:48:07.720] __error = [20:48:07.720] resultRelationDesc = [20:48:07.720] lockmode = [20:48:07.720] inputslot = [20:48:07.720] epqslot = [20:48:07.720] was_matched = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] #7 ExecMerge (context=0x821a43ef8, resultRelInfo=0x836ad66b0, tupleid=0x0, oldtuple=0x821a43e68, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [20:48:07.720] matched = true [20:48:07.720] rslot = 0x0 [20:48:07.720] #8 ExecModifyTable (pstate=0x836ad64a0) at ../src/backend/executor/nodeModifyTable.c:4197 [20:48:07.720] context = {mtstate = 0x836ad64a0, epqstate = 0x836ad6588, estate = 0x836ad6100, planSlot = 0x8390ed218, tmfd = {ctid = {ip_blkid = {bi_hi = 46896, bi_lo = 18227}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x836ad66b0} [20:48:07.720] tuple_ctid = {ip_blkid = {bi_hi = 26296, bi_lo = 13997}, ip_posid = 8} [20:48:07.720] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836b58118} [20:48:07.720] node = 0x836ad64a0 [20:48:07.720] estate = 0x836ad6100 [20:48:07.720] operation = CMD_MERGE [20:48:07.720] resultRelInfo = 0x836ad66b0 [20:48:07.720] subplanstate = 0x836ad7db0 [20:48:07.720] slot = [20:48:07.720] tupleid = 0x0 [20:48:07.720] oldtuple = 0x821a43e68 [20:48:07.720] tuplock = [20:48:07.720] oldSlot = [20:48:07.720] #9 0x0000000000764efb in ExecProcNode (node=0x836ad64a0) at ../src/include/executor/executor.h:278 [20:48:07.720] No locals. [20:48:07.720] #10 ExecutePlan (estate=0x836ad6100, planstate=0x836ad64a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x836b23b10, execute_once=) at ../src/backend/executor/execMain.c:1659 [20:48:07.720] current_tuple_count = 0 [20:48:07.720] slot = [20:48:07.720] #11 standard_ExecutorRun (queryDesc=0x838ef3448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [20:48:07.720] estate = 0x836ad6100 [20:48:07.720] oldcontext = 0x836b23800 [20:48:07.720] operation = CMD_MERGE [20:48:07.720] dest = 0x836b23b10 [20:48:07.720] sendTuples = true [20:48:07.720] #12 0x000000000093ba9f in ProcessQuery (plan=0x84733b018, sourceText=, params=0x0, queryEnv=0x0, dest=0x836b23b10, qc=0x821a440f8) at ../src/backend/tcop/pquery.c:160 [20:48:07.720] queryDesc = 0x838ef3448 [20:48:07.720] #13 0x000000000093b03d in PortalRunMulti (portal=portal@entry=0x836a51100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x836b23b10, altdest=0xb833f0 , qc=qc@entry=0x821a440f8) at ../src/backend/tcop/pquery.c:1287 [20:48:07.720] pstmt = 0x84733b018 [20:48:07.720] stmtlist_item__state = {l = 0x84733f8d0, i = 0} [20:48:07.720] active_snapshot_set = true [20:48:07.720] stmtlist_item = 0x84733f8e8 [20:48:07.720] #14 0x000000000093ab4c in FillPortalStore (portal=portal@entry=0x836a51100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [20:48:07.720] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:07.720] treceiver = 0x836b23b10 [20:48:07.720] #15 0x000000000093a8bb in PortalRun (portal=portal@entry=0x836a51100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x84733f920, altdest=altdest@entry=0x84733f920, qc=0x821a44230) at ../src/backend/tcop/pquery.c:763 [20:48:07.720] _local_sigjmp_buf = {{_sjb = {9676893, 35276525824, 34924151080, 34924151312, 34924151088, 35276546048, 12342648, 12375992, 35276522367, 35275653376, 4294967984, 0}}} [20:48:07.720] _save_exception_stack = 0x821a44300 [20:48:07.720] _save_context_stack = 0x0 [20:48:07.720] _do_rethrow = false [20:48:07.720] saveTopTransactionResourceOwner = 0x836a63fd8 [20:48:07.720] saveTopTransactionContext = 0x836a56000 [20:48:07.720] saveActivePortal = 0x0 [20:48:07.720] saveResourceOwner = 0x836a63fd8 [20:48:07.720] savePortalContext = 0x0 [20:48:07.720] saveMemoryContext = 0x836a56000 [20:48:07.720] result = [20:48:07.720] nprocessed = [20:48:07.720] #16 0x0000000000939782 in exec_simple_query (query_string=query_string@entry=0x83697c100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [20:48:07.720] cmdtaglen = 5 [20:48:07.720] snapshot_set = [20:48:07.720] per_parsetree_context = 0x0 [20:48:07.720] plantree_list = [20:48:07.720] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:07.720] format = 0 [20:48:07.720] parsetree = 0x83905d1a8 [20:48:07.720] commandTag = [20:48:07.720] cmdtagname = [20:48:07.720] querytree_list = [20:48:07.720] portal = 0x836a51100 [20:48:07.720] receiver = 0x84733f920 [20:48:07.720] parsetree_item__state = {l = 0x83905ea70, i = 0} [20:48:07.720] msec_str = "\000\000\000\000\b", '\000' , "\231\r\373f\000\000\000\000;]\302\340\034I\272", [20:48:07.720] dest = DestRemote [20:48:07.720] was_logged = [20:48:07.720] oldcontext = 0x836a56000 [20:48:07.720] parsetree_list = 0x83905ea70 [20:48:07.720] use_implicit_block = false [20:48:07.720] parsetree_item = 0x83905ea88 [20:48:07.720] save_log_statement_stats = [20:48:07.720] #17 0x00000000009373f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [20:48:07.720] query_string = 0x83697c100 "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"... [20:48:07.720] input_message = {data = 0x83697c100 "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} [20:48:07.720] firstchar = [20:48:07.720] local_sigjmp_buf = {{_sjb = {9660582, 34924151552, 34924151512, 34924152096, 12384728, 1, 8192, 8388608, 34924135295, 0, 0, 1}}} [20:48:07.720] send_ready_for_query = false [20:48:07.720] idle_in_transaction_timeout_enabled = false [20:48:07.720] idle_session_timeout_enabled = false [20:48:07.720] #18 0x0000000000931bd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:48:07.720] bsdata = [20:48:07.720] #19 0x000000000088b767 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a45044 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a44f80) at ../src/backend/postmaster/launch_backend.c:274 [20:48:07.720] pid = [20:48:07.720] #20 0x000000000088fb38 in BackendStartup (client_sock=0x821a44f80) at ../src/backend/postmaster/postmaster.c:3420 [20:48:07.720] startup_data = {canAcceptConnections = CAC_OK} [20:48:07.720] bn = 0x836988128 [20:48:07.720] pid = [20:48:07.720] __error = [20:48:07.720] save_errno = [20:48:07.720] __error = [20:48:07.720] __error = [20:48:07.720] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [20:48:07.720] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000ߗ6\b", '\000' , "\340O\244!\b\000\000\000hE\236,\b\000\000\000\v\000\000\000\000\000\000\000^Ϟ,\b", '\000' , " P\244!\b\000\000\000\024\265\210\000\000\000\000\0000P\244!\b", '\000' }, salen = 16}} [20:48:07.720] i = 0 [20:48:07.720] now = [20:48:07.720] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 758901890, events = 8, fd = 0, user_data = 0x821a44f30}, {pos = 916313560, events = 8, fd = 564415936, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x3f88966a230a}, {pos = 758069152, events = 8, fd = 758140280, user_data = 0x821a44a48}, {pos = 564415168, events = 8, fd = 564415048, user_data = 0x3f88966a230a}, {pos = 758047624, events = 8, fd = 758140280, user_data = 0x821a44a78}, {pos = 564415216, events = 8, fd = 564415096, user_data = 0x82d2fd194}, {pos = 578491400, events = 8, fd = 758108564, user_data = 0x821a44ae0}, {pos = -1771449286, events = 16264, fd = 759930928, user_data = 0x1}, {pos = 564415248, events = 8, fd = -1771429110, user_data = 0x82d2e6858}, {pos = 758140280, events = 8, fd = 564415208, user_data = 0x821a44b60}, {pos = 564415208, events = 8, fd = 758103308, user_data = 0x8227b1408}, {pos = 758103308, events = 8, fd = 564415312, user_data = 0x3f889669d43a}, {pos = 564415352, events = 8, fd = 564415800, user_data = 0x821a44b60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 848445030, fd = 578515000, user_data = 0x800000001}, {pos = 578491400, events = 8, fd = 758047624, user_data = 0x8227b6288}, {pos = 758016088, events = 8, fd = 578491400, user_data = 0x821a44be8}, {pos = 564415912, events = 8, fd = 564415440, user_data = 0x3f88966a1ca2}, {pos = 2701839, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 578515000, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564416168, user_data = 0x227b1408}, {pos = 564415984, events = 8, fd = 564415584, user_data = 0x1}, {pos = 564415912, events = 8, fd = 32, user_data = 0x821a44c50}, {pos = -1771431309, events = 16264, fd = 564415856, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8227b7038}, {pos = 1, events = 8, fd = 578491400, user_data = 0x82d2e6858}, {pos = 564416168, events = 8, fd = 564415984, user_data = 0x821a44c60}, {pos = 0, events = 0, fd = 578461704, user_data = 0x20}, {pos = 564415968, events = 8, fd = -1771455769, user_data = 0x8227aa008}, {pos = 578462728, events = 8, fd = 578463752, user_data = 0x8227aac08}, {pos = 578478088, events = 8, fd = 578479112, user_data = 0x8227ae808}, {pos = 578481160, events = 8, fd = 578482184, user_data = 0x8227af408}, {pos = 578484232, events = 8, fd = 578485256, user_data = 0x8227b0008}, {pos = 578487304, events = 8, fd = 578488328, user_data = 0x8227b0c08}, {pos = 578490376, events = 8, fd = 578491400, user_data = 0x8227b1808}, {pos = 578493448, events = 8, fd = 578494472, user_data = 0x8227b2408}, {pos = 578496520, events = 8, fd = 578497544, user_data = 0x8227b3008}, {pos = 578499592, events = 8, fd = 578500616, user_data = 0x8227b3c08}, {pos = 578506760, events = 8, fd = 578507784, user_data = 0x8227b5808}, {pos = 578509832, events = 8, fd = 578461704, user_data = 0x293a0f}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8227b7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564416168, events = 8, fd = 564415584, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578461704, events = 8, fd = 313, user_data = 0x821a44e90}, {pos = -1771457041, events = 16264, fd = 2701839, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578491400, events = 8, fd = 915849216, user_data = 0x1}, {pos = 915849620, events = 8, fd = 0, user_data = 0x821a44e60}, {pos = 748602732, events = 8, fd = 1, user_data = 0x83696c000}, {pos = 564416144, events = 8, fd = 748599042, user_data = 0x82d418170 }, {pos = 12305648, events = 0, fd = 759267696, user_data = 0x8227b1408}, {pos = 564416368, events = 8, fd = -1771457570, user_data = 0x83698a800}, {pos = 1, events = 0, fd = -1771457954, user_data = 0x8227aa008}, {pos = 564416152, events = 8, fd = 564416368, user_data = 0x1c20}, {pos = 915922688, events = 8, fd = -1771378288, user_data = 0x0}, {pos = 564396927, events = 8, fd = 8107351, user_data = 0x821a44f20}, {pos = 748561424, events = 8, fd = 759930928, user_data = 0x82d4bc310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a44f50}, {pos = 748604317, events = 8, fd = 915849216, user_data = 0x18b8}, {pos = 564416432, events = 8, fd = 748570874, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x0}} [20:48:07.720] last_touch_time = 1727729040 [20:48:07.720] last_lockfile_recheck_time = 1727729040 [20:48:07.720] nevents = 1 [20:48:07.720] #22 0x000000000088d955 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a45598) at ../src/backend/postmaster/postmaster.c:1351 [20:48:07.720] userDoption = [20:48:07.720] listen_addr_saved = [20:48:07.720] output_config_variable = [20:48:07.720] opt = [20:48:07.720] status = [20:48:07.720] #23 0x00000000007c823c in main (argc=8, argv=0x821a45598) at ../src/backend/main/main.c:197 [20:48:07.720] do_check_root = [20:48:07.730] [20:48:07.730] [20:48:07.730] [20:48:07.790] dumping /tmp/cores/postgres.8582.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:48:07.906] [New LWP 101729] [20:48:07.965] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [20:48:07.965] Program terminated with signal SIGABRT, Aborted. [20:48:07.965] Sent by thr_kill() from pid 8582 and user 1003. [20:48:07.965] #0 0x000000082c02041a in thr_kill () from /lib/libc.so.7 [20:48:08.490] [20:48:08.490] Thread 1 (LWP 101729): [20:48:08.490] #0 0x000000082c02041a in thr_kill () from /lib/libc.so.7 [20:48:08.490] No symbol table info available. [20:48:08.490] #1 0x000000082bf99e64 in raise () from /lib/libc.so.7 [20:48:08.490] No symbol table info available. [20:48:08.490] #2 0x000000082c04a6f9 in abort () from /lib/libc.so.7 [20:48:08.490] No symbol table info available. [20:48:08.490] #3 0x0000000000a911b5 in ExceptionalCondition (conditionName=0x2d1bc8 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [20:48:08.490] No locals. [20:48:08.490] #4 0x0000000000772d9f in ExecFetchSlotHeapTuple (slot=0x82120f848, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [20:48:08.490] No locals. [20:48:08.490] #5 0x0000000000737747 in ExecIRDeleteTriggers (estate=estate@entry=0x838456100, relinfo=relinfo@entry=0x8384566b0, slot=slot@entry=0x82120f848) at ../src/backend/commands/trigger.c:2842 [20:48:08.490] trigger = [20:48:08.490] oldtuple = [20:48:08.490] should_free = false [20:48:08.490] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x847e81998, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [20:48:08.490] trigdesc = 0x8384568c0 [20:48:08.490] newtuple = 0x0 [20:48:08.490] i = 0 [20:48:08.490] #6 0x0000000000798064 in ExecMergeMatched (context=0x82120f8d8, resultRelInfo=0x8384566b0, tupleid=0x0, oldtuple=0x82120f848, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [20:48:08.490] result = TM_Ok [20:48:08.490] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [20:48:08.490] relaction = 0x843f2bf60 [20:48:08.490] commandType = CMD_DELETE [20:48:08.490] l__state = {l = 0x843ffe9f8, i = 0} [20:48:08.490] lockedtid = [20:48:08.490] mtstate = 0x8384564a0 [20:48:08.490] newslot = 0x0 [20:48:08.490] rslot = 0x0 [20:48:08.490] estate = 0x838456100 [20:48:08.490] mergeActions = [20:48:08.490] econtext = 0x843ffda98 [20:48:08.490] epqstate = 0x838456588 [20:48:08.490] actionStates = 0x843ffe9f8 [20:48:08.490] l = [20:48:08.490] isNull = [20:48:08.490] lmerge_matched = [20:48:08.490] __error = [20:48:08.490] l__state = [20:48:08.490] result = [20:48:08.490] updateCxt = [20:48:08.490] relaction = [20:48:08.490] commandType = [20:48:08.490] __error = [20:48:08.490] resultRelationDesc = [20:48:08.490] lockmode = [20:48:08.490] inputslot = [20:48:08.490] epqslot = [20:48:08.490] was_matched = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] #7 ExecMerge (context=0x82120f8d8, resultRelInfo=0x8384566b0, tupleid=0x0, oldtuple=0x82120f848, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [20:48:08.490] matched = true [20:48:08.490] rslot = 0x0 [20:48:08.490] #8 ExecModifyTable (pstate=0x8384564a0) at ../src/backend/executor/nodeModifyTable.c:4197 [20:48:08.490] context = {mtstate = 0x8384564a0, epqstate = 0x838456588, estate = 0x838456100, planSlot = 0x843ffbe98, tmfd = {ctid = {ip_blkid = {bi_hi = 24496, bi_lo = 17403}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8384566b0} [20:48:08.490] tuple_ctid = {ip_blkid = {bi_hi = 26296, bi_lo = 14405}, ip_posid = 8} [20:48:08.490] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8382db118} [20:48:08.490] node = 0x8384564a0 [20:48:08.490] estate = 0x838456100 [20:48:08.490] operation = CMD_MERGE [20:48:08.490] resultRelInfo = 0x8384566b0 [20:48:08.490] subplanstate = 0x838457db0 [20:48:08.490] slot = [20:48:08.490] tupleid = 0x0 [20:48:08.490] oldtuple = 0x82120f848 [20:48:08.490] tuplock = [20:48:08.490] oldSlot = [20:48:08.490] #9 0x0000000000764efb in ExecProcNode (node=0x8384564a0) at ../src/include/executor/executor.h:278 [20:48:08.490] No locals. [20:48:08.490] #10 ExecutePlan (estate=0x838456100, planstate=0x8384564a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x8382c4b10, execute_once=) at ../src/backend/executor/execMain.c:1659 [20:48:08.490] current_tuple_count = 0 [20:48:08.490] slot = [20:48:08.490] #11 standard_ExecutorRun (queryDesc=0x83839dc48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [20:48:08.490] estate = 0x838456100 [20:48:08.490] oldcontext = 0x8382c4800 [20:48:08.490] operation = CMD_MERGE [20:48:08.490] dest = 0x8382c4b10 [20:48:08.490] sendTuples = true [20:48:08.490] #12 0x000000000093ba9f in ProcessQuery (plan=0x843fb5898, sourceText=, params=0x0, queryEnv=0x0, dest=0x8382c4b10, qc=0x82120fad8) at ../src/backend/tcop/pquery.c:160 [20:48:08.490] queryDesc = 0x83839dc48 [20:48:08.490] #13 0x000000000093b03d in PortalRunMulti (portal=portal@entry=0x83832f100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x8382c4b10, altdest=0xb833f0 , qc=qc@entry=0x82120fad8) at ../src/backend/tcop/pquery.c:1287 [20:48:08.490] pstmt = 0x843fb5898 [20:48:08.490] stmtlist_item__state = {l = 0x843fba150, i = 0} [20:48:08.490] active_snapshot_set = true [20:48:08.490] stmtlist_item = 0x843fba168 [20:48:08.490] #14 0x000000000093ab4c in FillPortalStore (portal=portal@entry=0x83832f100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [20:48:08.490] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:08.490] treceiver = 0x8382c4b10 [20:48:08.490] #15 0x000000000093a8bb in PortalRun (portal=portal@entry=0x83832f100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x843fba1a0, altdest=altdest@entry=0x843fba1a0, qc=0x82120fc10) at ../src/backend/tcop/pquery.c:763 [20:48:08.490] _local_sigjmp_buf = {{_sjb = {9676893, 35302600960, 34915547912, 34915548144, 34915547920, 35302617088, 12342648, 12375992, 35302605695, 35301929216, 4294967984, 0}}} [20:48:08.490] _save_exception_stack = 0x82120fce0 [20:48:08.490] _save_context_stack = 0x0 [20:48:08.490] _do_rethrow = false [20:48:08.490] saveTopTransactionResourceOwner = 0x83837ee98 [20:48:08.490] saveTopTransactionContext = 0x838333000 [20:48:08.490] saveActivePortal = 0x0 [20:48:08.490] saveResourceOwner = 0x83837ee98 [20:48:08.490] savePortalContext = 0x0 [20:48:08.490] saveMemoryContext = 0x838333000 [20:48:08.490] result = [20:48:08.490] nprocessed = [20:48:08.490] #16 0x0000000000939782 in exec_simple_query (query_string=query_string@entry=0x83828b100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [20:48:08.490] cmdtaglen = 5 [20:48:08.490] snapshot_set = [20:48:08.490] per_parsetree_context = 0x0 [20:48:08.490] plantree_list = [20:48:08.490] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:08.490] format = 0 [20:48:08.490] parsetree = 0x843f6a768 [20:48:08.490] commandTag = [20:48:08.490] cmdtagname = [20:48:08.490] querytree_list = [20:48:08.490] portal = 0x83832f100 [20:48:08.490] receiver = 0x843fba1a0 [20:48:08.490] parsetree_item__state = {l = 0x843f6c030, i = 0} [20:48:08.490] msec_str = "\000\000\000\000\b", '\000' , "\233\r\373f\000\000\000\000s\327\367\235~\a\212", [20:48:08.490] dest = DestRemote [20:48:08.490] was_logged = [20:48:08.490] oldcontext = 0x838333000 [20:48:08.490] parsetree_list = 0x843f6c030 [20:48:08.490] use_implicit_block = false [20:48:08.490] parsetree_item = 0x843f6c048 [20:48:08.490] save_log_statement_stats = [20:48:08.490] #17 0x00000000009373f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [20:48:08.490] query_string = 0x83828b100 "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"... [20:48:08.490] input_message = {data = 0x83828b100 "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} [20:48:08.490] firstchar = [20:48:08.490] local_sigjmp_buf = {{_sjb = {9660582, 34915548384, 34915548344, 34915548928, 12384728, 1, 8192, 8388608, 34915484543, 0, 0, 1}}} [20:48:08.490] send_ready_for_query = false [20:48:08.490] idle_in_transaction_timeout_enabled = false [20:48:08.490] idle_session_timeout_enabled = false [20:48:08.490] #18 0x0000000000931bd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:48:08.490] bsdata = [20:48:08.490] #19 0x000000000088b767 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821210a24 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821210960) at ../src/backend/postmaster/launch_backend.c:274 [20:48:08.490] pid = [20:48:08.490] #20 0x000000000088fb38 in BackendStartup (client_sock=0x821210960) at ../src/backend/postmaster/postmaster.c:3420 [20:48:08.490] startup_data = {canAcceptConnections = CAC_OK} [20:48:08.490] bn = 0x838297268 [20:48:08.490] pid = [20:48:08.490] __error = [20:48:08.490] save_errno = [20:48:08.490] __error = [20:48:08.490] __error = [20:48:08.490] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [20:48:08.490] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\300\316(8\b", '\000' , "\300\t!!\b\000\000\000h\025\363,\b\000\000\000\v\000\000\000\000\000\000\000^\237\363,\b", '\000' , "\n!!\b\000\000\000\024\265\210\000\000\000\000\000\020\n!!\b", '\000' }, salen = 16}} [20:48:08.490] i = 0 [20:48:08.490] now = [20:48:08.490] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 737954946, events = 8, fd = 0, user_data = 0x821210910}, {pos = 942618072, events = 8, fd = 555812768, user_data = 0x0}, {pos = 0, events = 0, fd = 807160162, user_data = 0x3990b3b6e30a}, {pos = 737122208, events = 8, fd = 737193336, user_data = 0x821210428}, {pos = 555812000, events = 8, fd = 555811880, user_data = 0x3990b3b6e30a}, {pos = 737100680, events = 8, fd = 737193336, user_data = 0x821210458}, {pos = 555812048, events = 8, fd = 555811928, user_data = 0x82bf03194}, {pos = 571950088, events = 8, fd = 737161620, user_data = 0x8212104c0}, {pos = -1279880134, events = 14736, fd = 738983984, user_data = 0x1}, {pos = 555812080, events = 8, fd = -1279859958, user_data = 0x82beec858}, {pos = 737193336, events = 8, fd = 555812040, user_data = 0x821210540}, {pos = 555812040, events = 8, fd = 737156364, user_data = 0x822174408}, {pos = 737156364, events = 8, fd = 555812144, user_data = 0x3990b3b6943a}, {pos = 555812184, events = 8, fd = 555812632, user_data = 0x821210540}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 198768864, fd = 571973688, user_data = 0x800000001}, {pos = 571950088, events = 8, fd = 737100680, user_data = 0x822179288}, {pos = 737069144, events = 8, fd = 571950088, user_data = 0x8212105c8}, {pos = 555812744, events = 8, fd = 555812272, user_data = 0x3990b3b6dca2}, {pos = 2701839, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 571973688, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 555813000, user_data = 0x22174408}, {pos = 555812816, events = 8, fd = 555812416, user_data = 0x1}, {pos = 555812744, events = 8, fd = 32, user_data = 0x821210630}, {pos = -1279862157, events = 14736, fd = 555812688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82217a038}, {pos = 1, events = 8, fd = 571950088, user_data = 0x82beec858}, {pos = 555813000, events = 8, fd = 555812816, user_data = 0x821210640}, {pos = 0, events = 0, fd = 571920392, user_data = 0x20}, {pos = 555812800, events = 8, fd = -1279886617, user_data = 0x82216d008}, {pos = 571921416, events = 8, fd = 571922440, user_data = 0x82216dc08}, {pos = 571936776, events = 8, fd = 571937800, user_data = 0x822171808}, {pos = 571939848, events = 8, fd = 571940872, user_data = 0x822172408}, {pos = 571942920, events = 8, fd = 571943944, user_data = 0x822173008}, {pos = 571945992, events = 8, fd = 571947016, user_data = 0x822173c08}, {pos = 571949064, events = 8, fd = 571950088, user_data = 0x822174808}, {pos = 571952136, events = 8, fd = 571953160, user_data = 0x822175408}, {pos = 571955208, events = 8, fd = 571956232, user_data = 0x822176008}, {pos = 571958280, events = 8, fd = 571959304, user_data = 0x822176c08}, {pos = 571965448, events = 8, fd = 571966472, user_data = 0x822178808}, {pos = 571968520, events = 8, fd = 571920392, user_data = 0x293a0f}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82217a038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555813000, events = 8, fd = 555812416, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 571973688, user_data = 0x1}, {pos = 571920392, events = 8, fd = 313, user_data = 0x821210870}, {pos = -1279887889, events = 14736, fd = 2701839, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 571973688, user_data = 0x1}, {pos = 571950088, events = 8, fd = 942125056, user_data = 0x1}, {pos = 942125460, events = 8, fd = 0, user_data = 0x821210840}, {pos = 754161004, events = 8, fd = 1, user_data = 0x83827b000}, {pos = 555812976, events = 8, fd = 754157314, user_data = 0x82c01e170 }, {pos = 12305648, events = 0, fd = 738320752, user_data = 0x822174408}, {pos = 555813200, events = 8, fd = -1279888418, user_data = 0x838299800}, {pos = 1, events = 0, fd = -1279888802, user_data = 0x82216d008}, {pos = 555812984, events = 8, fd = 555813200, user_data = 0x1c20}, {pos = 942198464, events = 8, fd = -1279809136, user_data = 0x0}, {pos = 555811711, events = 8, fd = 8107351, user_data = 0x821210900}, {pos = 754119696, events = 8, fd = 738983984, user_data = 0x82c0c2310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821210930}, {pos = 754162589, events = 8, fd = 942125056, user_data = 0x1929}, {pos = 555813264, events = 8, fd = 754129146, user_data = 0x0}, {pos = 0, events = 0, fd = 807160162, user_data = 0x0}} [20:48:08.490] last_touch_time = 1727729040 [20:48:08.490] last_lockfile_recheck_time = 1727729040 [20:48:08.490] nevents = 1 [20:48:08.490] #22 0x000000000088d955 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821210f78) at ../src/backend/postmaster/postmaster.c:1351 [20:48:08.490] userDoption = [20:48:08.490] listen_addr_saved = [20:48:08.490] output_config_variable = [20:48:08.490] opt = [20:48:08.490] status = [20:48:08.490] #23 0x00000000007c823c in main (argc=4, argv=0x821210f78) at ../src/backend/main/main.c:197 [20:48:08.490] do_check_root = [20:48:08.501] [20:48:08.501] [20:48:08.501] [20:48:08.560] dumping /tmp/cores/postgres.8977.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:48:08.678] [New LWP 100164] [20:48:08.734] Core was generated by `postgres: autovacuum worker regression'. [20:48:08.734] Program terminated with signal SIGABRT, Aborted. [20:48:08.734] Sent by thr_kill() from pid 8977 and user 1003. [20:48:08.734] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:08.881] [20:48:08.881] Thread 1 (LWP 100164): [20:48:08.881] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:08.881] No symbol table info available. [20:48:08.881] #1 0x000000082d393e64 in raise () from /lib/libc.so.7 [20:48:08.881] No symbol table info available. [20:48:08.881] #2 0x000000082d4446f9 in abort () from /lib/libc.so.7 [20:48:08.881] No symbol table info available. [20:48:08.881] #3 0x0000000000a911b5 in ExceptionalCondition (conditionName=0x35669e "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [20:48:08.881] No locals. [20:48:08.881] #4 0x0000000000696f2a in index_drop (indexId=21242, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [20:48:08.881] heaprelid = {relId = 10972687, dbId = 0} [20:48:08.881] indexrelid = {relId = 564412096, dbId = 8} [20:48:08.881] heapId = 21241 [20:48:08.881] lockmode = [20:48:08.881] userHeapRelation = 0x839929810 [20:48:08.881] userIndexRelation = 0x83992b460 [20:48:08.881] heaplocktag = [20:48:08.881] indexRelation = [20:48:08.881] tuple = [20:48:08.881] hasexprs = [20:48:08.881] #5 0x000000000068e5fe in doDeletion (object=object@entry=0x836af6520, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [20:48:08.881] concurrent = [20:48:08.881] concurrent_lock_mode = [20:48:08.881] relKind = 105 'i' [20:48:08.881] #6 0x000000000068cac0 in deleteOneObject (object=0x836af6520, depRel=0x821a44180, flags=21) at ../src/backend/catalog/dependency.c:1274 [20:48:08.881] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 917458944, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 20987, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35325637712}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 917466736, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 112 'p', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x821a44160}, sk_argument = 6866113}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 564413040, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 4 '\004', fn_extra = 0x821a44270, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35277350984}} [20:48:08.881] nkeys = [20:48:08.881] scan = [20:48:08.881] tup = [20:48:08.881] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x836b24cc8, depRel=depRel@entry=0x821a44180, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [20:48:08.881] thisobj = 0x836af6520 [20:48:08.881] thisextra = [20:48:08.881] i = 0 [20:48:08.881] #8 0x000000000068b755 in performDeletion (object=object@entry=0x821a44270, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [20:48:08.881] depRel = 0x8399293c0 [20:48:08.881] targetObjects = 0x836b24cc8 [20:48:08.881] #9 0x00000000008868b6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [20:48:08.881] object = {classId = 1259, objectId = 20987, objectSubId = 0} [20:48:08.881] relid = 20987 [20:48:08.881] classForm = [20:48:08.881] cell__state = {l = 0x836afef98, i = } [20:48:08.881] ctl = {num_partitions = 0, ssize = 0, dsize = 0, max_dsize = 0, keysize = 4, entrysize = 96, hash = 0x0, match = 0x0, keycopy = 0x0, alloc = 0x0, hcxt = 0x0, hctl = 0x0} [20:48:08.881] cell = 0x836b22c38 [20:48:08.881] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x974f40 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x836af5000, fn_expr = 0x0}, sk_argument = 116} [20:48:08.881] table_oids = [20:48:08.881] orphan_oids = [20:48:08.881] did_vacuum = false [20:48:08.881] found_concurrent_worker = false [20:48:08.881] effective_multixact_freeze_max_age = 400000000 [20:48:08.881] tuple = [20:48:08.881] classRel = 0x836aba118 [20:48:08.881] pg_class_desc = 0x836af5100 [20:48:08.881] table_toast_map = 0x836af9100 [20:48:08.881] relScan = [20:48:08.881] bstrategy = [20:48:08.881] i = [20:48:08.881] dbForm = [20:48:08.881] #10 0x00000000008860a9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [20:48:08.881] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000 E\244!\b\000\000\0000D\244!\b\000\000\000\"\230\220\000\000\000\000\000'\006\035Uf>\2222\370\005\274\000\000\000\000" [20:48:08.881] local_sigjmp_buf = {{_sjb = {8936851, 1, 34924151912, 34924152112, 12222084, 3, 34924151920, 0, 895, -2147815357, -1, 1}}} [20:48:08.881] dbid = 16384 [20:48:08.881] #11 0x000000000088b767 in postmaster_child_launch (child_type=child_type@entry=B_AUTOVAC_WORKER, 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:274 [20:48:08.881] pid = [20:48:08.881] #12 0x000000000088f7cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [20:48:08.881] pid = [20:48:08.881] __error = [20:48:08.881] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [20:48:08.881] bn = 0x8369883f8 [20:48:08.881] __error = [20:48:08.881] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [20:48:08.881] __error = [20:48:08.881] __error = [20:48:08.881] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [20:48:08.881] i = 0 [20:48:08.881] now = [20:48:08.881] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 758901890, events = 8, fd = 0, user_data = 0x821a44f30}, {pos = 916313560, events = 8, fd = 564415936, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x3f88966a230a}, {pos = 758069152, events = 8, fd = 758140280, user_data = 0x821a44a48}, {pos = 564415168, events = 8, fd = 564415048, user_data = 0x3f88966a230a}, {pos = 758047624, events = 8, fd = 758140280, user_data = 0x821a44a78}, {pos = 564415216, events = 8, fd = 564415096, user_data = 0x82d2fd194}, {pos = 578491400, events = 8, fd = 758108564, user_data = 0x821a44ae0}, {pos = -1771449286, events = 16264, fd = 759930928, user_data = 0x1}, {pos = 564415248, events = 8, fd = -1771429110, user_data = 0x82d2e6858}, {pos = 758140280, events = 8, fd = 564415208, user_data = 0x821a44b60}, {pos = 564415208, events = 8, fd = 758103308, user_data = 0x8227b1408}, {pos = 758103308, events = 8, fd = 564415312, user_data = 0x3f889669d43a}, {pos = 564415352, events = 8, fd = 564415800, user_data = 0x821a44b60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 848445030, fd = 578515000, user_data = 0x800000001}, {pos = 578491400, events = 8, fd = 758047624, user_data = 0x8227b6288}, {pos = 758016088, events = 8, fd = 578491400, user_data = 0x821a44be8}, {pos = 564415912, events = 8, fd = 564415440, user_data = 0x3f88966a1ca2}, {pos = 2701839, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 578515000, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564416168, user_data = 0x227b1408}, {pos = 564415984, events = 8, fd = 564415584, user_data = 0x1}, {pos = 564415912, events = 8, fd = 32, user_data = 0x821a44c50}, {pos = -1771431309, events = 16264, fd = 564415856, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8227b7038}, {pos = 1, events = 8, fd = 578491400, user_data = 0x82d2e6858}, {pos = 564416168, events = 8, fd = 564415984, user_data = 0x821a44c60}, {pos = 0, events = 0, fd = 578461704, user_data = 0x20}, {pos = 564415968, events = 8, fd = -1771455769, user_data = 0x8227aa008}, {pos = 578462728, events = 8, fd = 578463752, user_data = 0x8227aac08}, {pos = 578478088, events = 8, fd = 578479112, user_data = 0x8227ae808}, {pos = 578481160, events = 8, fd = 578482184, user_data = 0x8227af408}, {pos = 578484232, events = 8, fd = 578485256, user_data = 0x8227b0008}, {pos = 578487304, events = 8, fd = 578488328, user_data = 0x8227b0c08}, {pos = 578490376, events = 8, fd = 578491400, user_data = 0x8227b1808}, {pos = 578493448, events = 8, fd = 578494472, user_data = 0x8227b2408}, {pos = 578496520, events = 8, fd = 578497544, user_data = 0x8227b3008}, {pos = 578499592, events = 8, fd = 578500616, user_data = 0x8227b3c08}, {pos = 578506760, events = 8, fd = 578507784, user_data = 0x8227b5808}, {pos = 578509832, events = 8, fd = 578461704, user_data = 0x293a0f}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8227b7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564416168, events = 8, fd = 564415584, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578461704, events = 8, fd = 313, user_data = 0x821a44e90}, {pos = -1771457041, events = 16264, fd = 2701839, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578491400, events = 8, fd = 915849216, user_data = 0x1}, {pos = 915849620, events = 8, fd = 0, user_data = 0x821a44e60}, {pos = 748602732, events = 8, fd = 1, user_data = 0x83696c000}, {pos = 564416144, events = 8, fd = 748599042, user_data = 0x82d418170 }, {pos = 12305648, events = 0, fd = 759267696, user_data = 0x8227b1408}, {pos = 564416368, events = 8, fd = -1771457570, user_data = 0x83698a800}, {pos = 1, events = 0, fd = -1771457954, user_data = 0x8227aa008}, {pos = 564416152, events = 8, fd = 564416368, user_data = 0x1c20}, {pos = 915922688, events = 8, fd = -1771378288, user_data = 0x0}, {pos = 564396927, events = 8, fd = 8107351, user_data = 0x821a44f20}, {pos = 748561424, events = 8, fd = 759930928, user_data = 0x82d4bc310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a44f50}, {pos = 748604317, events = 8, fd = 915849216, user_data = 0x18b8}, {pos = 564416432, events = 8, fd = 748570874, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x0}} [20:48:08.881] last_touch_time = 1727729040 [20:48:08.881] last_lockfile_recheck_time = 1727729040 [20:48:08.881] nevents = 1 [20:48:08.881] #16 0x000000000088d955 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a45598) at ../src/backend/postmaster/postmaster.c:1351 [20:48:08.881] userDoption = [20:48:08.881] listen_addr_saved = [20:48:08.881] output_config_variable = [20:48:08.881] opt = [20:48:08.881] status = [20:48:08.881] #17 0x00000000007c823c in main (argc=8, argv=0x821a45598) at ../src/backend/main/main.c:197 [20:48:08.881] do_check_root = [20:48:08.891] [20:48:08.891] [20:48:08.891] [20:48:08.946] dumping /tmp/cores/postgres.9712.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:48:09.061] [New LWP 101679] [20:48:09.118] Core was generated by `postgres: autovacuum worker regression'. [20:48:09.118] Program terminated with signal SIGABRT, Aborted. [20:48:09.118] Sent by thr_kill() from pid 9712 and user 1003. [20:48:09.118] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:09.266] [20:48:09.266] Thread 1 (LWP 101679): [20:48:09.266] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:09.266] No symbol table info available. [20:48:09.266] #1 0x000000082d393e64 in raise () from /lib/libc.so.7 [20:48:09.266] No symbol table info available. [20:48:09.266] #2 0x000000082d4446f9 in abort () from /lib/libc.so.7 [20:48:09.266] No symbol table info available. [20:48:09.266] #3 0x0000000000a911b5 in ExceptionalCondition (conditionName=0x35669e "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [20:48:09.266] No locals. [20:48:09.266] #4 0x0000000000696f2a in index_drop (indexId=21242, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [20:48:09.266] heaprelid = {relId = 10972687, dbId = 0} [20:48:09.266] indexrelid = {relId = 564412096, dbId = 8} [20:48:09.266] heapId = 21241 [20:48:09.266] lockmode = [20:48:09.266] userHeapRelation = 0x839a77b10 [20:48:09.266] userIndexRelation = 0x839a79650 [20:48:09.266] heaplocktag = [20:48:09.266] indexRelation = [20:48:09.266] tuple = [20:48:09.266] hasexprs = [20:48:09.266] #5 0x000000000068e5fe in doDeletion (object=object@entry=0x836af6520, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [20:48:09.266] concurrent = [20:48:09.266] concurrent_lock_mode = [20:48:09.266] relKind = 105 'i' [20:48:09.266] #6 0x000000000068cac0 in deleteOneObject (object=0x836af6520, depRel=0x821a44180, flags=21) at ../src/backend/catalog/dependency.c:1274 [20:48:09.266] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 917458944, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 20987, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35327006544}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 917643192, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 112 'p', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x821a44160}, sk_argument = 6866113}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 564413040, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 4 '\004', fn_extra = 0x821a44270, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35277397592}} [20:48:09.266] nkeys = [20:48:09.266] scan = [20:48:09.266] tup = [20:48:09.266] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x836b255e8, depRel=depRel@entry=0x821a44180, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [20:48:09.266] thisobj = 0x836af6520 [20:48:09.266] thisextra = [20:48:09.266] i = 0 [20:48:09.266] #8 0x000000000068b755 in performDeletion (object=object@entry=0x821a44270, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [20:48:09.266] depRel = 0x839a776c0 [20:48:09.266] targetObjects = 0x836b255e8 [20:48:09.266] #9 0x00000000008868b6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [20:48:09.266] object = {classId = 1259, objectId = 20987, objectSubId = 0} [20:48:09.266] relid = 20987 [20:48:09.266] classForm = [20:48:09.266] cell__state = {l = 0x836afef98, i = } [20:48:09.266] ctl = {num_partitions = 0, ssize = 0, dsize = 0, max_dsize = 0, keysize = 4, entrysize = 96, hash = 0x0, match = 0x0, keycopy = 0x0, alloc = 0x0, hcxt = 0x0, hctl = 0x0} [20:48:09.266] cell = 0x836b21d88 [20:48:09.266] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x974f40 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x836af5000, fn_expr = 0x0}, sk_argument = 116} [20:48:09.266] table_oids = [20:48:09.266] orphan_oids = [20:48:09.266] did_vacuum = false [20:48:09.266] found_concurrent_worker = false [20:48:09.266] effective_multixact_freeze_max_age = 400000000 [20:48:09.266] tuple = [20:48:09.266] classRel = 0x836ab98d8 [20:48:09.266] pg_class_desc = 0x836af5100 [20:48:09.266] table_toast_map = 0x836af9100 [20:48:09.266] relScan = [20:48:09.266] bstrategy = [20:48:09.266] i = [20:48:09.266] dbForm = [20:48:09.266] #10 0x00000000008860a9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [20:48:09.266] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000 E\244!\b\000\000\0000D\244!\b\000\000\000\"\230\220\000\000\000\000\000'\006\035Uf>\2222\370\005\274\000\000\000\000" [20:48:09.266] local_sigjmp_buf = {{_sjb = {8936851, 1, 34924151912, 34924152112, 12222084, 3, 34924151920, 0, 895, -2147815357, -1, 1}}} [20:48:09.266] dbid = 16384 [20:48:09.266] #11 0x000000000088b767 in postmaster_child_launch (child_type=child_type@entry=B_AUTOVAC_WORKER, 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:274 [20:48:09.266] pid = [20:48:09.266] #12 0x000000000088f7cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [20:48:09.266] pid = [20:48:09.266] __error = [20:48:09.266] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [20:48:09.266] bn = 0x836988448 [20:48:09.266] __error = [20:48:09.266] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [20:48:09.266] __error = [20:48:09.266] __error = [20:48:09.266] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [20:48:09.266] i = 0 [20:48:09.266] now = [20:48:09.266] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 758901890, events = 8, fd = 0, user_data = 0x821a44f30}, {pos = 916313560, events = 8, fd = 564415936, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x3f88966a230a}, {pos = 758069152, events = 8, fd = 758140280, user_data = 0x821a44a48}, {pos = 564415168, events = 8, fd = 564415048, user_data = 0x3f88966a230a}, {pos = 758047624, events = 8, fd = 758140280, user_data = 0x821a44a78}, {pos = 564415216, events = 8, fd = 564415096, user_data = 0x82d2fd194}, {pos = 578491400, events = 8, fd = 758108564, user_data = 0x821a44ae0}, {pos = -1771449286, events = 16264, fd = 759930928, user_data = 0x1}, {pos = 564415248, events = 8, fd = -1771429110, user_data = 0x82d2e6858}, {pos = 758140280, events = 8, fd = 564415208, user_data = 0x821a44b60}, {pos = 564415208, events = 8, fd = 758103308, user_data = 0x8227b1408}, {pos = 758103308, events = 8, fd = 564415312, user_data = 0x3f889669d43a}, {pos = 564415352, events = 8, fd = 564415800, user_data = 0x821a44b60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 848445030, fd = 578515000, user_data = 0x800000001}, {pos = 578491400, events = 8, fd = 758047624, user_data = 0x8227b6288}, {pos = 758016088, events = 8, fd = 578491400, user_data = 0x821a44be8}, {pos = 564415912, events = 8, fd = 564415440, user_data = 0x3f88966a1ca2}, {pos = 2701839, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 578515000, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564416168, user_data = 0x227b1408}, {pos = 564415984, events = 8, fd = 564415584, user_data = 0x1}, {pos = 564415912, events = 8, fd = 32, user_data = 0x821a44c50}, {pos = -1771431309, events = 16264, fd = 564415856, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8227b7038}, {pos = 1, events = 8, fd = 578491400, user_data = 0x82d2e6858}, {pos = 564416168, events = 8, fd = 564415984, user_data = 0x821a44c60}, {pos = 0, events = 0, fd = 578461704, user_data = 0x20}, {pos = 564415968, events = 8, fd = -1771455769, user_data = 0x8227aa008}, {pos = 578462728, events = 8, fd = 578463752, user_data = 0x8227aac08}, {pos = 578478088, events = 8, fd = 578479112, user_data = 0x8227ae808}, {pos = 578481160, events = 8, fd = 578482184, user_data = 0x8227af408}, {pos = 578484232, events = 8, fd = 578485256, user_data = 0x8227b0008}, {pos = 578487304, events = 8, fd = 578488328, user_data = 0x8227b0c08}, {pos = 578490376, events = 8, fd = 578491400, user_data = 0x8227b1808}, {pos = 578493448, events = 8, fd = 578494472, user_data = 0x8227b2408}, {pos = 578496520, events = 8, fd = 578497544, user_data = 0x8227b3008}, {pos = 578499592, events = 8, fd = 578500616, user_data = 0x8227b3c08}, {pos = 578506760, events = 8, fd = 578507784, user_data = 0x8227b5808}, {pos = 578509832, events = 8, fd = 578461704, user_data = 0x293a0f}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8227b7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564416168, events = 8, fd = 564415584, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578461704, events = 8, fd = 313, user_data = 0x821a44e90}, {pos = -1771457041, events = 16264, fd = 2701839, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578491400, events = 8, fd = 915849216, user_data = 0x1}, {pos = 915849620, events = 8, fd = 0, user_data = 0x821a44e60}, {pos = 748602732, events = 8, fd = 1, user_data = 0x83696c000}, {pos = 564416144, events = 8, fd = 748599042, user_data = 0x82d418170 }, {pos = 12305648, events = 0, fd = 759267696, user_data = 0x8227b1408}, {pos = 564416368, events = 8, fd = -1771457570, user_data = 0x83698a800}, {pos = 1, events = 0, fd = -1771457954, user_data = 0x8227aa008}, {pos = 564416152, events = 8, fd = 564416368, user_data = 0x1c20}, {pos = 915922688, events = 8, fd = -1771378288, user_data = 0x0}, {pos = 564396927, events = 8, fd = 8107351, user_data = 0x821a44f20}, {pos = 748561424, events = 8, fd = 759930928, user_data = 0x82d4bc310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a44f50}, {pos = 748604317, events = 8, fd = 915849216, user_data = 0x18b8}, {pos = 564416432, events = 8, fd = 748570874, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x0}} [20:48:09.266] last_touch_time = 1727729040 [20:48:09.266] last_lockfile_recheck_time = 1727729040 [20:48:09.266] nevents = 1 [20:48:09.266] #16 0x000000000088d955 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a45598) at ../src/backend/postmaster/postmaster.c:1351 [20:48:09.266] userDoption = [20:48:09.266] listen_addr_saved = [20:48:09.266] output_config_variable = [20:48:09.266] opt = [20:48:09.266] status = [20:48:09.266] #17 0x00000000007c823c in main (argc=8, argv=0x821a45598) at ../src/backend/main/main.c:197 [20:48:09.266] do_check_root = [20:48:09.276] [20:48:09.276] [20:48:09.276] [20:48:09.332] dumping /tmp/cores/postgres.10162.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:48:09.448] [New LWP 101763] [20:48:09.505] Core was generated by `postgres: autovacuum worker regression'. [20:48:09.505] Program terminated with signal SIGABRT, Aborted. [20:48:09.505] Sent by thr_kill() from pid 10162 and user 1003. [20:48:09.505] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:09.653] [20:48:09.653] Thread 1 (LWP 101763): [20:48:09.653] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:09.653] No symbol table info available. [20:48:09.653] #1 0x000000082d393e64 in raise () from /lib/libc.so.7 [20:48:09.653] No symbol table info available. [20:48:09.653] #2 0x000000082d4446f9 in abort () from /lib/libc.so.7 [20:48:09.653] No symbol table info available. [20:48:09.653] #3 0x0000000000a911b5 in ExceptionalCondition (conditionName=0x35669e "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [20:48:09.653] No locals. [20:48:09.653] #4 0x0000000000696f2a in index_drop (indexId=21242, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [20:48:09.653] heaprelid = {relId = 10972687, dbId = 0} [20:48:09.653] indexrelid = {relId = 564412096, dbId = 8} [20:48:09.653] heapId = 21241 [20:48:09.653] lockmode = [20:48:09.653] userHeapRelation = 0x836ac7b68 [20:48:09.653] userIndexRelation = 0x836ace600 [20:48:09.653] heaplocktag = [20:48:09.653] indexRelation = [20:48:09.653] tuple = [20:48:09.653] hasexprs = [20:48:09.653] #5 0x000000000068e5fe in doDeletion (object=object@entry=0x836afe5b0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [20:48:09.653] concurrent = [20:48:09.653] concurrent_lock_mode = [20:48:09.653] relKind = 105 'i' [20:48:09.653] #6 0x000000000068cac0 in deleteOneObject (object=0x836afe5b0, depRel=0x821a44180, flags=21) at ../src/backend/catalog/dependency.c:1274 [20:48:09.653] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 917491712, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 20987, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35277022096}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 917532552, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 112 'p', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x821a44160}, sk_argument = 6866113}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 564413040, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 4 '\004', fn_extra = 0x821a44270, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35277403112}} [20:48:09.653] nkeys = [20:48:09.653] scan = [20:48:09.653] tup = [20:48:09.653] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x836b06fd8, depRel=depRel@entry=0x821a44180, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [20:48:09.653] thisobj = 0x836afe5b0 [20:48:09.653] thisextra = [20:48:09.653] i = 0 [20:48:09.653] #8 0x000000000068b755 in performDeletion (object=object@entry=0x821a44270, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [20:48:09.653] depRel = 0x836ac3e08 [20:48:09.653] targetObjects = 0x836b06fd8 [20:48:09.653] #9 0x00000000008868b6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [20:48:09.653] object = {classId = 1259, objectId = 20987, objectSubId = 0} [20:48:09.653] relid = 20987 [20:48:09.653] classForm = [20:48:09.653] cell__state = {l = 0x836afedf0, i = } [20:48:09.653] ctl = {num_partitions = 0, ssize = 0, dsize = 0, max_dsize = 0, keysize = 4, entrysize = 96, hash = 0x0, match = 0x0, keycopy = 0x0, alloc = 0x0, hcxt = 0x0, hctl = 0x0} [20:48:09.653] cell = 0x836b256b8 [20:48:09.653] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x974f40 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x836afd000, fn_expr = 0x0}, sk_argument = 116} [20:48:09.653] table_oids = [20:48:09.653] orphan_oids = [20:48:09.653] did_vacuum = false [20:48:09.653] found_concurrent_worker = false [20:48:09.653] effective_multixact_freeze_max_age = 400000000 [20:48:09.653] tuple = [20:48:09.653] classRel = 0x836ac0168 [20:48:09.653] pg_class_desc = 0x836afd100 [20:48:09.653] table_toast_map = 0x836b01100 [20:48:09.653] relScan = [20:48:09.653] bstrategy = [20:48:09.653] i = [20:48:09.653] dbForm = [20:48:09.653] #10 0x00000000008860a9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [20:48:09.653] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000 E\244!\b\000\000\0000D\244!\b\000\000\000\"\230\220\000\000\000\000\000'\006\035Uf>\2222\370\005\274\000\000\000\000" [20:48:09.653] local_sigjmp_buf = {{_sjb = {8936851, 1, 34924151912, 34924152112, 12222084, 3, 34924151920, 0, 895, -2147815357, -1, 1}}} [20:48:09.653] dbid = 16384 [20:48:09.653] #11 0x000000000088b767 in postmaster_child_launch (child_type=child_type@entry=B_AUTOVAC_WORKER, 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:274 [20:48:09.653] pid = [20:48:09.653] #12 0x000000000088f7cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [20:48:09.653] pid = [20:48:09.653] __error = [20:48:09.653] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [20:48:09.653] bn = 0x8369883f8 [20:48:09.653] __error = [20:48:09.653] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [20:48:09.653] __error = [20:48:09.653] __error = [20:48:09.653] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [20:48:09.653] i = 0 [20:48:09.653] now = [20:48:09.653] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 916313560, events = 8, fd = 564415936, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x3f88966a230a}, {pos = 758069152, events = 8, fd = 758140280, user_data = 0x821a44a48}, {pos = 564415168, events = 8, fd = 564415048, user_data = 0x3f88966a230a}, {pos = 758047624, events = 8, fd = 758140280, user_data = 0x821a44a78}, {pos = 564415216, events = 8, fd = 564415096, user_data = 0x82d2fd194}, {pos = 578491400, events = 8, fd = 758108564, user_data = 0x821a44ae0}, {pos = -1771449286, events = 16264, fd = 759930928, user_data = 0x1}, {pos = 564415248, events = 8, fd = -1771429110, user_data = 0x82d2e6858}, {pos = 758140280, events = 8, fd = 564415208, user_data = 0x821a44b60}, {pos = 564415208, events = 8, fd = 758103308, user_data = 0x8227b1408}, {pos = 758103308, events = 8, fd = 564415312, user_data = 0x3f889669d43a}, {pos = 564415352, events = 8, fd = 564415800, user_data = 0x821a44b60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 848445030, fd = 578515000, user_data = 0x800000001}, {pos = 578491400, events = 8, fd = 758047624, user_data = 0x8227b6288}, {pos = 758016088, events = 8, fd = 578491400, user_data = 0x821a44be8}, {pos = 564415912, events = 8, fd = 564415440, user_data = 0x3f88966a1ca2}, {pos = 2701839, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 578515000, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564416168, user_data = 0x227b1408}, {pos = 564415984, events = 8, fd = 564415584, user_data = 0x1}, {pos = 564415912, events = 8, fd = 32, user_data = 0x821a44c50}, {pos = -1771431309, events = 16264, fd = 564415856, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8227b7038}, {pos = 1, events = 8, fd = 578491400, user_data = 0x82d2e6858}, {pos = 564416168, events = 8, fd = 564415984, user_data = 0x821a44c60}, {pos = 0, events = 0, fd = 578461704, user_data = 0x20}, {pos = 564415968, events = 8, fd = -1771455769, user_data = 0x8227aa008}, {pos = 578462728, events = 8, fd = 578463752, user_data = 0x8227aac08}, {pos = 578478088, events = 8, fd = 578479112, user_data = 0x8227ae808}, {pos = 578481160, events = 8, fd = 578482184, user_data = 0x8227af408}, {pos = 578484232, events = 8, fd = 578485256, user_data = 0x8227b0008}, {pos = 578487304, events = 8, fd = 578488328, user_data = 0x8227b0c08}, {pos = 578490376, events = 8, fd = 578491400, user_data = 0x8227b1808}, {pos = 578493448, events = 8, fd = 578494472, user_data = 0x8227b2408}, {pos = 578496520, events = 8, fd = 578497544, user_data = 0x8227b3008}, {pos = 578499592, events = 8, fd = 578500616, user_data = 0x8227b3c08}, {pos = 578506760, events = 8, fd = 578507784, user_data = 0x8227b5808}, {pos = 578509832, events = 8, fd = 578461704, user_data = 0x293a0f}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8227b7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564416168, events = 8, fd = 564415584, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578461704, events = 8, fd = 313, user_data = 0x821a44e90}, {pos = -1771457041, events = 16264, fd = 2701839, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578491400, events = 8, fd = 915849216, user_data = 0x1}, {pos = 915849620, events = 8, fd = 0, user_data = 0x821a44e60}, {pos = 748602732, events = 8, fd = 1, user_data = 0x83696c000}, {pos = 564416144, events = 8, fd = 748599042, user_data = 0x82d418170 }, {pos = 12305648, events = 0, fd = 759267696, user_data = 0x8227b1408}, {pos = 564416368, events = 8, fd = -1771457570, user_data = 0x83698a800}, {pos = 1, events = 0, fd = -1771457954, user_data = 0x8227aa008}, {pos = 564416152, events = 8, fd = 564416368, user_data = 0x1c20}, {pos = 915922688, events = 8, fd = -1771378288, user_data = 0x0}, {pos = 564396927, events = 8, fd = 8107351, user_data = 0x821a44f20}, {pos = 748561424, events = 8, fd = 759930928, user_data = 0x82d4bc310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a44f50}, {pos = 748604317, events = 8, fd = 915849216, user_data = 0x18b8}, {pos = 564416432, events = 8, fd = 748570874, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x0}} [20:48:09.653] last_touch_time = 1727729040 [20:48:09.653] last_lockfile_recheck_time = 1727729040 [20:48:09.653] nevents = 1 [20:48:09.653] #16 0x000000000088d955 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a45598) at ../src/backend/postmaster/postmaster.c:1351 [20:48:09.653] userDoption = [20:48:09.653] listen_addr_saved = [20:48:09.653] output_config_variable = [20:48:09.653] opt = [20:48:09.653] status = [20:48:09.653] #17 0x00000000007c823c in main (argc=8, argv=0x821a45598) at ../src/backend/main/main.c:197 [20:48:09.653] do_check_root = [20:48:09.662] [20:48:09.662] [20:48:09.662] [20:48:09.718] dumping /tmp/cores/postgres.10667.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:48:09.835] [New LWP 101786] [20:48:09.891] Core was generated by `postgres: autovacuum worker regression'. [20:48:09.891] Program terminated with signal SIGABRT, Aborted. [20:48:09.891] Sent by thr_kill() from pid 10667 and user 1003. [20:48:09.891] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:10.037] [20:48:10.037] Thread 1 (LWP 101786): [20:48:10.037] #0 0x000000082d41a41a in thr_kill () from /lib/libc.so.7 [20:48:10.037] No symbol table info available. [20:48:10.037] #1 0x000000082d393e64 in raise () from /lib/libc.so.7 [20:48:10.037] No symbol table info available. [20:48:10.037] #2 0x000000082d4446f9 in abort () from /lib/libc.so.7 [20:48:10.037] No symbol table info available. [20:48:10.037] #3 0x0000000000a911b5 in ExceptionalCondition (conditionName=0x35669e "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [20:48:10.037] No locals. [20:48:10.037] #4 0x0000000000696f2a in index_drop (indexId=21242, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [20:48:10.037] heaprelid = {relId = 10972687, dbId = 0} [20:48:10.037] indexrelid = {relId = 564412096, dbId = 8} [20:48:10.037] heapId = 21241 [20:48:10.037] lockmode = [20:48:10.037] userHeapRelation = 0x836ac7b68 [20:48:10.037] userIndexRelation = 0x836ace600 [20:48:10.037] heaplocktag = [20:48:10.037] indexRelation = [20:48:10.037] tuple = [20:48:10.037] hasexprs = [20:48:10.037] #5 0x000000000068e5fe in doDeletion (object=object@entry=0x836afe5b0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [20:48:10.037] concurrent = [20:48:10.037] concurrent_lock_mode = [20:48:10.037] relKind = 105 'i' [20:48:10.037] #6 0x000000000068cac0 in deleteOneObject (object=0x836afe5b0, depRel=0x821a44180, flags=21) at ../src/backend/catalog/dependency.c:1274 [20:48:10.037] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 917491712, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 20987, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35277022096}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 917654072, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 112 'p', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x821a44160}, sk_argument = 6866113}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 564413040, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 4 '\004', fn_extra = 0x821a44270, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35277401272}} [20:48:10.037] nkeys = [20:48:10.037] scan = [20:48:10.037] tup = [20:48:10.037] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x839988078, depRel=depRel@entry=0x821a44180, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [20:48:10.037] thisobj = 0x836afe5b0 [20:48:10.037] thisextra = [20:48:10.037] i = 0 [20:48:10.037] #8 0x000000000068b755 in performDeletion (object=object@entry=0x821a44270, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [20:48:10.037] depRel = 0x836ac3e08 [20:48:10.037] targetObjects = 0x839988078 [20:48:10.037] #9 0x00000000008868b6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [20:48:10.037] object = {classId = 1259, objectId = 20987, objectSubId = 0} [20:48:10.037] relid = 20987 [20:48:10.037] classForm = [20:48:10.037] cell__state = {l = 0x836afedf0, i = } [20:48:10.037] ctl = {num_partitions = 0, ssize = 0, dsize = 0, max_dsize = 0, keysize = 4, entrysize = 96, hash = 0x0, match = 0x0, keycopy = 0x0, alloc = 0x0, hcxt = 0x0, hctl = 0x0} [20:48:10.037] cell = 0x836b24918 [20:48:10.037] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x974f40 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x836afd000, fn_expr = 0x0}, sk_argument = 116} [20:48:10.037] table_oids = [20:48:10.037] orphan_oids = [20:48:10.037] did_vacuum = false [20:48:10.037] found_concurrent_worker = false [20:48:10.037] effective_multixact_freeze_max_age = 400000000 [20:48:10.037] tuple = [20:48:10.037] classRel = 0x836ac0168 [20:48:10.037] pg_class_desc = 0x836afd100 [20:48:10.037] table_toast_map = 0x836b01100 [20:48:10.037] relScan = [20:48:10.037] bstrategy = [20:48:10.037] i = [20:48:10.037] dbForm = [20:48:10.037] #10 0x00000000008860a9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [20:48:10.037] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000 E\244!\b\000\000\0000D\244!\b\000\000\000\"\230\220\000\000\000\000\000'\006\035Uf>\2222\370\005\274\000\000\000\000" [20:48:10.037] local_sigjmp_buf = {{_sjb = {8936851, 1, 34924151912, 34924152112, 12222084, 3, 34924151920, 0, 895, -2147815357, -1, 1}}} [20:48:10.037] dbid = 16384 [20:48:10.037] #11 0x000000000088b767 in postmaster_child_launch (child_type=child_type@entry=B_AUTOVAC_WORKER, 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:274 [20:48:10.037] pid = [20:48:10.037] #12 0x000000000088f7cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [20:48:10.037] pid = [20:48:10.037] __error = [20:48:10.037] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [20:48:10.037] bn = 0x8369882b8 [20:48:10.037] __error = [20:48:10.037] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [20:48:10.037] __error = [20:48:10.037] __error = [20:48:10.037] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [20:48:10.037] i = 0 [20:48:10.037] now = [20:48:10.037] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 916313560, events = 8, fd = 564415936, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x3f88966a230a}, {pos = 758069152, events = 8, fd = 758140280, user_data = 0x821a44a48}, {pos = 564415168, events = 8, fd = 564415048, user_data = 0x3f88966a230a}, {pos = 758047624, events = 8, fd = 758140280, user_data = 0x821a44a78}, {pos = 564415216, events = 8, fd = 564415096, user_data = 0x82d2fd194}, {pos = 578491400, events = 8, fd = 758108564, user_data = 0x821a44ae0}, {pos = -1771449286, events = 16264, fd = 759930928, user_data = 0x1}, {pos = 564415248, events = 8, fd = -1771429110, user_data = 0x82d2e6858}, {pos = 758140280, events = 8, fd = 564415208, user_data = 0x821a44b60}, {pos = 564415208, events = 8, fd = 758103308, user_data = 0x8227b1408}, {pos = 758103308, events = 8, fd = 564415312, user_data = 0x3f889669d43a}, {pos = 564415352, events = 8, fd = 564415800, user_data = 0x821a44b60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 848445030, fd = 578515000, user_data = 0x800000001}, {pos = 578491400, events = 8, fd = 758047624, user_data = 0x8227b6288}, {pos = 758016088, events = 8, fd = 578491400, user_data = 0x821a44be8}, {pos = 564415912, events = 8, fd = 564415440, user_data = 0x3f88966a1ca2}, {pos = 2701839, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 578515000, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564416168, user_data = 0x227b1408}, {pos = 564415984, events = 8, fd = 564415584, user_data = 0x1}, {pos = 564415912, events = 8, fd = 32, user_data = 0x821a44c50}, {pos = -1771431309, events = 16264, fd = 564415856, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8227b7038}, {pos = 1, events = 8, fd = 578491400, user_data = 0x82d2e6858}, {pos = 564416168, events = 8, fd = 564415984, user_data = 0x821a44c60}, {pos = 0, events = 0, fd = 578461704, user_data = 0x20}, {pos = 564415968, events = 8, fd = -1771455769, user_data = 0x8227aa008}, {pos = 578462728, events = 8, fd = 578463752, user_data = 0x8227aac08}, {pos = 578478088, events = 8, fd = 578479112, user_data = 0x8227ae808}, {pos = 578481160, events = 8, fd = 578482184, user_data = 0x8227af408}, {pos = 578484232, events = 8, fd = 578485256, user_data = 0x8227b0008}, {pos = 578487304, events = 8, fd = 578488328, user_data = 0x8227b0c08}, {pos = 578490376, events = 8, fd = 578491400, user_data = 0x8227b1808}, {pos = 578493448, events = 8, fd = 578494472, user_data = 0x8227b2408}, {pos = 578496520, events = 8, fd = 578497544, user_data = 0x8227b3008}, {pos = 578499592, events = 8, fd = 578500616, user_data = 0x8227b3c08}, {pos = 578506760, events = 8, fd = 578507784, user_data = 0x8227b5808}, {pos = 578509832, events = 8, fd = 578461704, user_data = 0x293a0f}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8227b7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564416168, events = 8, fd = 564415584, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578461704, events = 8, fd = 313, user_data = 0x821a44e90}, {pos = -1771457041, events = 16264, fd = 2701839, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 578515000, user_data = 0x1}, {pos = 578491400, events = 8, fd = 915849216, user_data = 0x1}, {pos = 915849620, events = 8, fd = 0, user_data = 0x821a44e60}, {pos = 748602732, events = 8, fd = 1, user_data = 0x83696c000}, {pos = 564416144, events = 8, fd = 748599042, user_data = 0x82d418170 }, {pos = 12305648, events = 0, fd = 759267696, user_data = 0x8227b1408}, {pos = 564416368, events = 8, fd = -1771457570, user_data = 0x83698a800}, {pos = 1, events = 0, fd = -1771457954, user_data = 0x8227aa008}, {pos = 564416152, events = 8, fd = 564416368, user_data = 0x1c20}, {pos = 915922688, events = 8, fd = -1771378288, user_data = 0x0}, {pos = 564396927, events = 8, fd = 8107351, user_data = 0x821a44f20}, {pos = 748561424, events = 8, fd = 759930928, user_data = 0x82d4bc310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a44f50}, {pos = 748604317, events = 8, fd = 915849216, user_data = 0x18b8}, {pos = 564416432, events = 8, fd = 748570874, user_data = 0x0}, {pos = 0, events = 0, fd = 1427965479, user_data = 0x0}} [20:48:10.038] last_touch_time = 1727729040 [20:48:10.038] last_lockfile_recheck_time = 1727729040 [20:48:10.038] nevents = 1 [20:48:10.038] #16 0x000000000088d955 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a45598) at ../src/backend/postmaster/postmaster.c:1351 [20:48:10.038] userDoption = [20:48:10.038] listen_addr_saved = [20:48:10.038] output_config_variable = [20:48:10.038] opt = [20:48:10.038] status = [20:48:10.038] #17 0x00000000007c823c in main (argc=8, argv=0x821a45598) at ../src/backend/main/main.c:197 [20:48:10.038] do_check_root = [20:48:10.047] [20:48:10.047] [20:48:10.047] [20:48:10.101] dumping /tmp/cores/postgres.12127.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:48:10.217] [New LWP 100942] [20:48:10.274] Core was generated by `postgres: standby: startup waiting for 000000010000000000000005'. [20:48:10.274] Program terminated with signal SIGQUIT, Quit. [20:48:10.274] Sent by thr_kill() from pid 12127 and user 1003. [20:48:10.274] #0 0x000000082b01e8fa in _sigprocmask () from /lib/libc.so.7 [20:48:10.297] [20:48:10.297] Thread 1 (LWP 100942): [20:48:10.297] #0 0x000000082b01e8fa in _sigprocmask () from /lib/libc.so.7 [20:48:10.297] No symbol table info available. [20:48:10.297] #1 0x000000082b057f91 in _system () from /lib/libc.so.7 [20:48:10.297] No symbol table info available. [20:48:10.297] #2 0x000000082ac989d3 in ?? () from /lib/libthr.so.3 [20:48:10.297] No symbol table info available. [20:48:10.297] #3 0x0000000000669845 in RestoreArchivedFile (path=path@entry=0x8219681d0 "pg_wal/0\244\0177", xlogfname=xlogfname@entry=0x821968620 "00000001", '0' , "5", recovername=, expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [20:48:10.297] xlogpath = "pg_wal/RECOVERYXLOG\000RY", '\000' , "0000001", '0' , "\0004\0009\000\000\000\000\000\000\000\000\000\344\000\000\000\000\000\000\020\n\000\000\000\000\000\000\315 5\b\000\000\000@#{6\b\000\000\000X\"{6\b\000\000\000P\"{6\b\000\000\000P\035{6\b\000\000\000\000\340\344\000\000\000\000\000\000 96\b\000\000\000\335\031\n\000\000\000\000\000 }\226!\b\000\000\000 }\226!\b", '\000' , "\350~\226!\b\000\000\000h}\226!\b\000\000\000\b\000\000\0000\000\000\000"... [20:48:10.297] lastRestartPointFname = "00000001", '0' , "2\000\235f\000\000\000\000\000pg_wal/00000001", '0' , "2", '\000' , "\305\000\256\000\000\000\000\000\300y\226!\b\000\000\0000\000\000\000\000\000\000\000\210\200\226!\b", '\000' , "py\226!\b\000\000\000\023\004\256", '\000' , "\305\000\256\000\000\000\000\000\210\200\226!\b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' ... [20:48:10.297] stat_buf = {st_dev = 34923251152, st_ino = 34923251232, st_nlink = 12221024, st_mode = 1, st_padding0 = 0, st_uid = 0, st_gid = 563511744, st_padding1 = 8, st_rdev = 35080738279, st_atim = {tv_sec = 35268261119, tv_nsec = 12383216}, st_mtim = {tv_sec = 892350512, tv_nsec = 5}, st_ctim = {tv_sec = -72340172838076673, tv_nsec = -9187201950435737472}, st_birthtim = {tv_sec = 206158430224, tv_nsec = 34923251200}, st_size = 34923250224, st_blocks = 11454851, st_blksize = 717815875, st_flags = 8, st_gen = 34991905915, st_spare = {3326173, 35268210688, 4294967292, 9259542123273814144, 34923249968, 0, 11, 35077566960, 206158430240, 34923250128}} [20:48:10.297] restartRedoPtr = 33563712 [20:48:10.297] restartTli = 1 [20:48:10.297] restartSegNo = [20:48:10.297] xlogRestoreCmd = 0x836376838 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/020_archive_status/data/t_020_archive_status_primary_data/archives/00000001", '0' , "5\" \"pg_wal/RECOVERYXLOG\"" [20:48:10.297] rc = [20:48:10.297] #4 0x000000000067502e in XLogFileRead (segno=segno@entry=5, tli=tli@entry=1, source=source@entry=XLOG_FROM_ARCHIVE, notfoundOk=true) at ../src/backend/access/transam/xlogrecovery.c:4221 [20:48:10.297] xlogfname = "00000001", '0' , "5\000\206\226!\b\000\000\000p\206\226!\b\000\000\000\365\231\001+\b\000\000\000\327,\000\000\000\000\000\000\357\001\000\000\000\000\000" [20:48:10.297] activitymsg = "waiting for 00000001", '0' , "5\000\000\000\000\240\006\r+\b\000\000\000@\206\226!\b\000\000\000\257\232\001+\b\000\000\000\251\r\373f\000\000\000\000״AUp\"\265", [20:48:10.297] path = "pg_wal/0\244\0177\000\000\000\000\000\030\000\000\0000\000\000\000@\202\226!\b\000\000\000 \201\226!\b\000\000\000\t\213\253\000\000\000\000\000\360\000\000\000\000\000\000\000d\000\000\000\000\000\000\000\000\360&6\b", '\000' , "\340\327\274\000\000\000\000\000\320\371\274\000\000\000\000\000@\206\226!\b\000\000\000y3\251\000\000\000\000\000\b0A\"\b\000\000\000 \000\000\000\000\000\000\000\340\203\226!\b\000\000\000\347\252\370\377\273-\000\000\b0A\"\b\000\000\000\b4A\"\b\000\000\000\b8A\"\b\000\000\000\b [20:48:10.297] #5 0x0000000000670d0c in XLogFileReadAnyTLI (segno=5, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4349 [20:48:10.297] hent = [20:48:10.297] tli = 1 [20:48:10.297] cell__state = {l = 0x8363884d8, i = 0} [20:48:10.297] path = "pg_wal/00000001", '0' , "5", '\000' , "\001\335\031\364\274\270m\274+\220\240\2463\b\000\000\0009\000\000\000\000\000\000\000\000\000\n\000\000\000\000\000@\000\b\000\000\000\000\000\240\006\r+\b\000\000\000\220\207\226!\b\000\000\000\353\234\005+\b", '\000' , "\002\000\000\000\000\000\000\000\002\000\000\000\001\000\000\000\000\000\000\000\230\000\000\000\000\000\000\002\000\000\000\000\005\000\000\000\000\000\000\000\230\000\000\002", '\000' , "\335\031\364\274\270m\274+\000\320&6\b\000\000\000@\000\b\000\000\000\000\000"... [20:48:10.297] tles = 0x8363884d8 [20:48:10.297] cell = [20:48:10.297] fd = [20:48:10.297] cell__state = [20:48:10.297] hent = [20:48:10.297] tli = [20:48:10.297] beginseg = [20:48:10.297] __error = [20:48:10.297] __error = [20:48:10.297] #6 WaitForWALToBecomeAvailable (RecPtr=83886104, tliRecPtr=83886080, replayTLI=1, replayLSN=83886080, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3783 [20:48:10.297] startWalReceiver = [20:48:10.297] streaming_reply_sent = false [20:48:10.297] now = [20:48:10.297] startWalReceiver = [20:48:10.297] oldSource = [20:48:10.297] wait_time = [20:48:10.297] __error = [20:48:10.297] __error = [20:48:10.297] __error = [20:48:10.297] havedata = [20:48:10.297] ptr = [20:48:10.297] tli = [20:48:10.297] __error = [20:48:10.297] latestChunkStart = [20:48:10.297] __error = [20:48:10.297] #7 XLogPageRead (xlogreader=0x83626e130, targetPagePtr=83886080, reqLen=24, targetRecPtr=83886080, readBuf=0x836372ef8 "\027\321\002") at ../src/backend/access/transam/xlogrecovery.c:3364 [20:48:10.297] private = 0x83626e110 [20:48:10.297] emode = 15 [20:48:10.297] targetSegNo = 5 [20:48:10.297] targetPageOff = 0 [20:48:10.297] r = [20:48:10.297] #8 0x0000000000677d12 in ReadPageInternal (state=state@entry=0x83626e130, pageptr=83886080, reqLen=24) at ../src/backend/access/transam/xlogreader.c:1060 [20:48:10.297] targetSegNo = 5 [20:48:10.297] targetPageOff = 0 [20:48:10.297] readLen = [20:48:10.297] hdr = [20:48:10.297] err = [20:48:10.297] #9 0x0000000000676b82 in XLogDecodeNextRecord (state=0x83626e130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:597 [20:48:10.297] errormsg = 0xbce248 "" [20:48:10.297] randAccess = [20:48:10.297] decoded = 0x0 [20:48:10.297] RecPtr = 83886080 [20:48:10.297] assembled = false [20:48:10.297] targetPagePtr = 34923247552 [20:48:10.297] readOff = [20:48:10.297] record = [20:48:10.297] gotheader = [20:48:10.297] targetRecOff = 0 [20:48:10.297] pageHeaderSize = [20:48:10.297] len = [20:48:10.297] total_len = [20:48:10.297] buffer = [20:48:10.297] gotlen = [20:48:10.297] pageHeader = [20:48:10.297] contdata = [20:48:10.297] save_copy = [20:48:10.297] #10 XLogReadAhead (state=0x83626e130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:973 [20:48:10.297] result = [20:48:10.297] #11 0x000000000066e268 in XLogPrefetcherNextBlock (pgsr_private=35269332744, lsn=0x836387ea8) at ../src/backend/access/transam/xlogprefetcher.c:490 [20:48:10.297] nonblocking = false [20:48:10.297] record = 0x0 [20:48:10.297] prefetcher = 0x836374f08 [20:48:10.297] reader = 0x83626e130 [20:48:10.297] replaying_lsn = 67109152 [20:48:10.297] #12 0x000000000066ded2 in lrq_prefetch (lrq=0x836387da8) at ../src/backend/access/transam/xlogprefetcher.c:252 [20:48:10.297] No locals. [20:48:10.297] #13 lrq_complete_lsn (lrq=0x836387da8, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [20:48:10.297] No locals. [20:48:10.297] #14 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x836374f08, errmsg=errmsg@entry=0x82196cd60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [20:48:10.297] replayed_up_to = [20:48:10.297] record = [20:48:10.297] #15 0x00000000006719fa in ReadRecord (xlogprefetcher=0x836374f08, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=1) at ../src/backend/access/transam/xlogrecovery.c:3164 [20:48:10.297] errormsg = 0x0 [20:48:10.297] xlogreader = 0x83626e130 [20:48:10.297] private = [20:48:10.297] record = [20:48:10.297] #16 0x00000000006722d9 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1843 [20:48:10.297] ru0 = {tv = {tv_sec = 1727729062, tv_usec = 881139}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 575}, ru_maxrss = 0, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 144, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 0, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 3, ru_nivcsw = 1}} [20:48:10.297] xtime = [20:48:10.297] reachedRecoveryTarget = false [20:48:10.297] replayTLI = 1 [20:48:10.297] record = [20:48:10.297] #17 0x0000000000662b93 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5841 [20:48:10.297] wasShutdown = false [20:48:10.297] haveTblspcMap = false [20:48:10.297] haveBackupLabel = false [20:48:10.297] promoted = false [20:48:10.297] didCrash = [20:48:10.297] checkPoint = {redo = 33554472, ThisTimeLineID = 1, PrevTimeLineID = , fullPageWrites = true, wal_level = , nextXid = {value = }, nextOid = , nextMulti = , nextMultiOffset = , oldestXid = , oldestXidDB = 1, oldestMulti = , oldestMultiDB = , time = , oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 740} [20:48:10.297] oldestActiveXID = [20:48:10.297] performedWalRecovery = [20:48:10.297] endOfRecoveryInfo = [20:48:10.297] EndOfLog = [20:48:10.297] EndOfLogTLI = [20:48:10.297] abortedRecPtr = [20:48:10.297] missingContrecPtr = [20:48:10.297] newTLI = [20:48:10.297] Insert = [20:48:10.297] #18 0x0000000000891a0b in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [20:48:10.297] No locals. [20:48:10.297] #19 0x000000000088b767 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:274 [20:48:10.297] pid = [20:48:10.297] #20 0x000000000088dcd4 in StartChildProcess (type=B_AUTOVAC_WORKER, type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3736 [20:48:10.297] pid = [20:48:10.297] __error = [20:48:10.297] #21 0x000000000088d915 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821971ec8) at ../src/backend/postmaster/postmaster.c:1343 [20:48:10.297] userDoption = [20:48:10.297] listen_addr_saved = [20:48:10.297] output_config_variable = [20:48:10.297] opt = [20:48:10.297] status = [20:48:10.297] #22 0x00000000007c823c in main (argc=4, argv=0x821971ec8) at ../src/backend/main/main.c:197 [20:48:10.297] do_check_root = [20:48:10.306] [20:48:10.306] [20:48:10.306] [20:48:10.364] dumping /tmp/cores/postgres.13908.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:48:10.481] [New LWP 101671] [20:48:10.543] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [20:48:10.543] Program terminated with signal SIGABRT, Aborted. [20:48:10.543] Sent by thr_kill() from pid 13908 and user 1003. [20:48:10.543] #0 0x000000082c2ba41a in thr_kill () from /lib/libc.so.7 [20:48:11.078] [20:48:11.078] Thread 1 (LWP 101671): [20:48:11.078] #0 0x000000082c2ba41a in thr_kill () from /lib/libc.so.7 [20:48:11.078] No symbol table info available. [20:48:11.078] #1 0x000000082c233e64 in raise () from /lib/libc.so.7 [20:48:11.078] No symbol table info available. [20:48:11.078] #2 0x000000082c2e46f9 in abort () from /lib/libc.so.7 [20:48:11.078] No symbol table info available. [20:48:11.078] #3 0x0000000000a911b5 in ExceptionalCondition (conditionName=0x2d1bc8 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [20:48:11.078] No locals. [20:48:11.078] #4 0x0000000000772d9f in ExecFetchSlotHeapTuple (slot=0x821b92818, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [20:48:11.078] No locals. [20:48:11.078] #5 0x0000000000737747 in ExecIRDeleteTriggers (estate=estate@entry=0x836b79100, relinfo=relinfo@entry=0x836b796b0, slot=slot@entry=0x821b92818) at ../src/backend/commands/trigger.c:2842 [20:48:11.078] trigger = [20:48:11.078] oldtuple = [20:48:11.078] should_free = false [20:48:11.078] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83c493630, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [20:48:11.078] trigdesc = 0x836b798c0 [20:48:11.078] newtuple = 0x0 [20:48:11.078] i = 0 [20:48:11.078] #6 0x0000000000798064 in ExecMergeMatched (context=0x821b928a8, resultRelInfo=0x836b796b0, tupleid=0x0, oldtuple=0x821b92818, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [20:48:11.078] result = TM_Ok [20:48:11.078] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [20:48:11.078] relaction = 0x83c4d7b60 [20:48:11.078] commandType = CMD_DELETE [20:48:11.078] l__state = {l = 0x83c64e778, i = 0} [20:48:11.078] lockedtid = [20:48:11.078] mtstate = 0x836b794a0 [20:48:11.078] newslot = 0x0 [20:48:11.078] rslot = 0x0 [20:48:11.078] estate = 0x836b79100 [20:48:11.078] mergeActions = [20:48:11.078] econtext = 0x83c64d818 [20:48:11.078] epqstate = 0x836b79588 [20:48:11.078] actionStates = 0x83c64e778 [20:48:11.078] l = [20:48:11.078] isNull = [20:48:11.078] lmerge_matched = [20:48:11.078] __error = [20:48:11.078] l__state = [20:48:11.078] result = [20:48:11.078] updateCxt = [20:48:11.078] relaction = [20:48:11.078] commandType = [20:48:11.078] __error = [20:48:11.078] resultRelationDesc = [20:48:11.078] lockmode = [20:48:11.078] inputslot = [20:48:11.078] epqslot = [20:48:11.078] was_matched = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] #7 ExecMerge (context=0x821b928a8, resultRelInfo=0x836b796b0, tupleid=0x0, oldtuple=0x821b92818, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [20:48:11.078] matched = true [20:48:11.078] rslot = 0x0 [20:48:11.078] #8 ExecModifyTable (pstate=0x836b794a0) at ../src/backend/executor/nodeModifyTable.c:4197 [20:48:11.078] context = {mtstate = 0x836b794a0, epqstate = 0x836b79588, estate = 0x836b79100, planSlot = 0x83c64bc18, tmfd = {ctid = {ip_blkid = {bi_hi = 28046, bi_lo = 11307}, ip_posid = 8}, xmax = 129, cmax = 0, traversed = 116}, cpUpdateReturningSlot = 0xeb8bbcc05df2e60b} [20:48:11.078] tuple_ctid = {ip_blkid = {bi_hi = 11489, bi_lo = 0}, ip_posid = 0} [20:48:11.078] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836c0d118} [20:48:11.078] node = 0x836b794a0 [20:48:11.078] estate = 0x836b79100 [20:48:11.078] operation = CMD_MERGE [20:48:11.078] resultRelInfo = 0x836b796b0 [20:48:11.078] subplanstate = 0x836b7adb0 [20:48:11.078] slot = [20:48:11.078] tupleid = 0x0 [20:48:11.078] oldtuple = 0x821b92818 [20:48:11.078] tuplock = [20:48:11.078] oldSlot = [20:48:11.078] #9 0x0000000000764efb in ExecProcNode (node=0x836b794a0) at ../src/include/executor/executor.h:278 [20:48:11.078] No locals. [20:48:11.078] #10 ExecutePlan (estate=0x836b79100, planstate=0x836b794a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x836bf0f10, execute_once=) at ../src/backend/executor/execMain.c:1659 [20:48:11.078] current_tuple_count = 0 [20:48:11.078] slot = [20:48:11.078] #11 standard_ExecutorRun (queryDesc=0x836c0f448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:364 [20:48:11.078] estate = 0x836b79100 [20:48:11.078] oldcontext = 0x836bf0c00 [20:48:11.078] operation = CMD_MERGE [20:48:11.078] dest = 0x836bf0f10 [20:48:11.078] sendTuples = true [20:48:11.078] #12 0x0000000839209961 in pgss_ExecutorRun (queryDesc=0x836c0f448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1024 [20:48:11.078] _local_sigjmp_buf = {{_sjb = {35318176049, 1, 34925521368, 34925521536, 12375992, 34925521376, 1, 35278353480, 34925511551, 7830369, 35277737984, 34359738368}}} [20:48:11.078] _save_exception_stack = 0x821b92b90 [20:48:11.078] _save_context_stack = 0x0 [20:48:11.078] _do_rethrow = false [20:48:11.078] #13 0x000000000093ba9f in ProcessQuery (plan=0x83c5f90c0, sourceText=, params=0x0, queryEnv=0x0, dest=0x836bf0f10, qc=0x821b92b58) at ../src/backend/tcop/pquery.c:160 [20:48:11.078] queryDesc = 0x836c0f448 [20:48:11.078] #14 0x000000000093b03d in PortalRunMulti (portal=portal@entry=0x836ae1100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x836bf0f10, altdest=0xb833f0 , qc=qc@entry=0x821b92b58) at ../src/backend/tcop/pquery.c:1287 [20:48:11.078] pstmt = 0x83c5f90c0 [20:48:11.078] stmtlist_item__state = {l = 0x83c5fd978, i = 0} [20:48:11.078] active_snapshot_set = true [20:48:11.078] stmtlist_item = 0x83c5fd990 [20:48:11.078] #15 0x000000000093ab4c in FillPortalStore (portal=portal@entry=0x836ae1100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [20:48:11.078] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:11.078] treceiver = 0x836bf0f10 [20:48:11.078] #16 0x000000000093a8bb in PortalRun (portal=portal@entry=0x836ae1100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83c5fd9c8, altdest=altdest@entry=0x83c5fd9c8, qc=0x821b92c90) at ../src/backend/tcop/pquery.c:763 [20:48:11.078] _local_sigjmp_buf = {{_sjb = {9676893, 35277115648, 34925521800, 34925522032, 34925521808, 35277209600, 12342648, 12375992, 35277112191, 35276435712, 4294967984, 0}}} [20:48:11.078] _save_exception_stack = 0x821b92d60 [20:48:11.078] _save_context_stack = 0x0 [20:48:11.078] _do_rethrow = false [20:48:11.078] saveTopTransactionResourceOwner = 0x836b2fe18 [20:48:11.078] saveTopTransactionContext = 0x836af8000 [20:48:11.078] saveActivePortal = 0x0 [20:48:11.078] saveResourceOwner = 0x836b2fe18 [20:48:11.078] savePortalContext = 0x0 [20:48:11.078] saveMemoryContext = 0x836af8000 [20:48:11.078] result = [20:48:11.078] nprocessed = [20:48:11.078] #17 0x0000000000939782 in exec_simple_query (query_string=query_string@entry=0x836a3b100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [20:48:11.078] cmdtaglen = 5 [20:48:11.078] snapshot_set = [20:48:11.078] per_parsetree_context = 0x0 [20:48:11.078] plantree_list = [20:48:11.078] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:11.078] format = 0 [20:48:11.078] parsetree = 0x83c5c15a8 [20:48:11.078] commandTag = [20:48:11.078] cmdtagname = [20:48:11.078] querytree_list = [20:48:11.078] portal = 0x836ae1100 [20:48:11.078] receiver = 0x83c5fd9c8 [20:48:11.078] parsetree_item__state = {l = 0x83c5c2e70, i = 0} [20:48:11.078] msec_str = "\000\000\000\000\b", '\000' , "\264\r\373f\000\000\000\000\331\343zq\034\f\332\b" [20:48:11.078] dest = DestRemote [20:48:11.078] was_logged = [20:48:11.078] oldcontext = 0x836af8000 [20:48:11.078] parsetree_list = 0x83c5c2e70 [20:48:11.078] use_implicit_block = false [20:48:11.078] parsetree_item = 0x83c5c2e88 [20:48:11.078] save_log_statement_stats = [20:48:11.078] #18 0x00000000009373f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [20:48:11.078] query_string = 0x836a3b100 "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"... [20:48:11.078] input_message = {data = 0x836a3b100 "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} [20:48:11.078] firstchar = [20:48:11.078] local_sigjmp_buf = {{_sjb = {9660582, 34925522272, 34925522232, 34925522816, 12384728, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [20:48:11.078] send_ready_for_query = false [20:48:11.078] idle_in_transaction_timeout_enabled = false [20:48:11.078] idle_session_timeout_enabled = false [20:48:11.078] #19 0x0000000000931bd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:48:11.078] bsdata = [20:48:11.078] #20 0x000000000088b767 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821b93aa4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821b939e0) at ../src/backend/postmaster/launch_backend.c:274 [20:48:11.078] pid = [20:48:11.078] #21 0x000000000088fb38 in BackendStartup (client_sock=0x821b939e0) at ../src/backend/postmaster/postmaster.c:3420 [20:48:11.078] startup_data = {canAcceptConnections = CAC_OK} [20:48:11.078] bn = 0x836a474e8 [20:48:11.078] pid = [20:48:11.078] __error = [20:48:11.078] save_errno = [20:48:11.078] __error = [20:48:11.078] __error = [20:48:11.078] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [20:48:11.078] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = " \274\2436\b", '\000' , "@:\271!\b\000\000\000hՉ+\b\000\000\000\v\000\000\000\000\000\000\000^_\212+\b", '\000' , "\200:\271!\b\000\000\000\024\265\210\000\000\000\000\000\220:\271!\b", '\000' }, salen = 16}} [20:48:11.078] i = 0 [20:48:11.078] now = [20:48:11.078] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 740682882, events = 8, fd = 0, user_data = 0x821b93990}, {pos = 917124568, events = 8, fd = 565786656, user_data = 0x0}, {pos = -1119481078, events = 8814, fd = 739850144, user_data = 0x82c1a4d78}, {pos = 565785752, events = 8, fd = 565785872, user_data = 0x821b93498}, {pos = -1119481078, events = 8814, fd = 739828616, user_data = 0x82c1a4d78}, {pos = 565785800, events = 8, fd = 565785920, user_data = 0x821b934c8}, {pos = 739889556, events = 8, fd = 580760584, user_data = 0x82c19d194}, {pos = 565785904, events = 8, fd = -1119501254, user_data = 0x821b934d0}, {pos = 730444816, events = 8, fd = 741711920, user_data = 0x226ebd46130a}, {pos = 739797080, events = 8, fd = 739921272, user_data = 0x821b93538}, {pos = 565786032, events = 8, fd = 565785912, user_data = 0x82c19bd0c}, {pos = 580760584, events = 8, fd = 739884300, user_data = 0x821b935a0}, {pos = -1119501254, events = 8814, fd = 565786056, user_data = 0x821b93798}, {pos = 565786032, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8229e1038}, {pos = 1, events = 3951803584, fd = 580760584, user_data = 0x82c18e388}, {pos = 580782024, events = 8, fd = 0, user_data = 0x0}, {pos = 565786168, events = 8, fd = 565786632, user_data = 0x821b93620}, {pos = -1119482718, events = 8814, fd = 2701839, user_data = 0x6d68b}, {pos = 2090263927, events = 3951803584, fd = 580784184, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821b93908}, {pos = 580760584, events = 3, fd = 565786704, user_data = 0x8229e0828}, {pos = 656, events = 0, fd = 565786632, user_data = 0x821b93638}, {pos = 565786272, events = 8, fd = -1119483109, user_data = 0x821b937d0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 580784184, events = 8, fd = 1, user_data = 0x8229db408}, {pos = 739797080, events = 8, fd = 565786888, user_data = 0x821b93850}, {pos = 565786288, events = 8, fd = 0, user_data = 0x8229d4008}, {pos = 33, events = 0, fd = 565786688, user_data = 0x226ebd45aae7}, {pos = 580730888, events = 8, fd = 580731912, user_data = 0x8229d4808}, {pos = 580733960, events = 8, fd = 580747272, user_data = 0x8229d8408}, {pos = 580749320, events = 8, fd = 580750344, user_data = 0x8229d9008}, {pos = 580752392, events = 8, fd = 580753416, user_data = 0x8229d9c08}, {pos = 580755464, events = 8, fd = 580756488, user_data = 0x8229da808}, {pos = 580758536, events = 8, fd = 580759560, user_data = 0x8229db408}, {pos = 580761608, events = 8, fd = 580762632, user_data = 0x8229dc008}, {pos = 580764680, events = 8, fd = 580765704, user_data = 0x8229dcc08}, {pos = 580767752, events = 8, fd = 580768776, user_data = 0x8229dd808}, {pos = 580770824, events = 8, fd = 580775944, user_data = 0x8229df408}, {pos = 580777992, events = 8, fd = 580779016, user_data = 0x8229e2408}, {pos = 812195000, events = 0, fd = 580730888, user_data = 0x293a0f}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8229e1038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 565786888, events = 8, fd = 565786288, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 580784184, user_data = 0x1}, {pos = 580730888, events = 8, fd = 313, user_data = 0x821b938f0}, {pos = -1119509009, events = 8814, fd = 2701839, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 580784184, user_data = 0x1}, {pos = 580760584, events = 8, fd = 916631552, user_data = 0x1}, {pos = 916631956, events = 8, fd = 0, user_data = 0x821b938c0}, {pos = 730486124, events = 8, fd = 1, user_data = 0x836a2b000}, {pos = 565786864, events = 8, fd = 730482434, user_data = 0x82c2b8170 }, {pos = 12305648, events = 0, fd = 741048688, user_data = 0x8229db408}, {pos = 565787088, events = 8, fd = -1119509538, user_data = 0x836a49800}, {pos = 1, events = 0, fd = -1119509922, user_data = 0x8229d4008}, {pos = 565786872, events = 8, fd = 565787088, user_data = 0x1c20}, {pos = 916700192, events = 8, fd = -1119430256, user_data = 0x0}, {pos = 565773183, events = 8, fd = 8107351, user_data = 0x821b93980}, {pos = 730444816, events = 8, fd = 741711920, user_data = 0x82c35c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821b939b0}, {pos = 730487709, events = 8, fd = 916631552, user_data = 0x30a6}, {pos = 565787152, events = 8, fd = 730454266, user_data = 0x0}, {pos = 0, events = 0, fd = 1576199691, user_data = 0x0}} [20:48:11.078] last_touch_time = 1727729067 [20:48:11.078] last_lockfile_recheck_time = 1727729067 [20:48:11.078] nevents = 1 [20:48:11.078] #23 0x000000000088d955 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821b93ff8) at ../src/backend/postmaster/postmaster.c:1351 [20:48:11.078] userDoption = [20:48:11.078] listen_addr_saved = [20:48:11.078] output_config_variable = [20:48:11.078] opt = [20:48:11.078] status = [20:48:11.078] #24 0x00000000007c823c in main (argc=4, argv=0x821b93ff8) at ../src/backend/main/main.c:197 [20:48:11.078] do_check_root =