[22:27:53.388] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [22:27:53.735] dumping /tmp/cores/postgres.7871.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:53.879] [New LWP 101713] [22:27:53.973] Core was generated by `postgres: postgres regression [local] MERGE'. [22:27:53.973] Program terminated with signal SIGABRT, Aborted. [22:27:53.973] Sent by thr_kill() from pid 7871 and user 1003. [22:27:53.973] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:54.583] [22:27:54.583] Thread 1 (LWP 101713): [22:27:54.583] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:54.583] No symbol table info available. [22:27:54.583] #1 0x000000082c949e64 in raise () from /lib/libc.so.7 [22:27:54.583] No symbol table info available. [22:27:54.583] #2 0x000000082c9fa6f9 in abort () from /lib/libc.so.7 [22:27:54.583] No symbol table info available. [22:27:54.583] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x2d1ba0 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [22:27:54.583] No locals. [22:27:54.583] #4 0x0000000000772ebf in ExecFetchSlotHeapTuple (slot=0x8214a6388, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [22:27:54.583] No locals. [22:27:54.583] #5 0x0000000000737847 in ExecIRDeleteTriggers (estate=estate@entry=0x83834f100, relinfo=relinfo@entry=0x83834f6b0, slot=slot@entry=0x8214a6388) at ../src/backend/commands/trigger.c:2842 [22:27:54.583] trigger = [22:27:54.583] oldtuple = [22:27:54.583] should_free = false [22:27:54.583] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84437f3b0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [22:27:54.583] trigdesc = 0x83834f8c0 [22:27:54.583] newtuple = 0x0 [22:27:54.583] i = 0 [22:27:54.583] #6 0x0000000000798184 in ExecMergeMatched (context=0x8214a6418, resultRelInfo=0x83834f6b0, tupleid=0x0, oldtuple=0x8214a6388, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [22:27:54.583] result = TM_Ok [22:27:54.583] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [22:27:54.583] relaction = 0x844451b60 [22:27:54.583] commandType = CMD_DELETE [22:27:54.583] l__state = {l = 0x8445365b8, i = 0} [22:27:54.583] lockedtid = [22:27:54.583] mtstate = 0x83834f4a0 [22:27:54.583] newslot = 0x0 [22:27:54.583] rslot = 0x0 [22:27:54.583] estate = 0x83834f100 [22:27:54.583] mergeActions = [22:27:54.583] econtext = 0x844535658 [22:27:54.583] epqstate = 0x83834f588 [22:27:54.583] actionStates = 0x8445365b8 [22:27:54.583] l = [22:27:54.583] isNull = [22:27:54.583] lmerge_matched = [22:27:54.583] __error = [22:27:54.583] l__state = [22:27:54.583] result = [22:27:54.583] updateCxt = [22:27:54.583] relaction = [22:27:54.583] commandType = [22:27:54.583] __error = [22:27:54.583] resultRelationDesc = [22:27:54.583] lockmode = [22:27:54.583] inputslot = [22:27:54.583] epqslot = [22:27:54.583] was_matched = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] #7 ExecMerge (context=0x8214a6418, resultRelInfo=0x83834f6b0, tupleid=0x0, oldtuple=0x8214a6388, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [22:27:54.583] matched = true [22:27:54.583] rslot = 0x0 [22:27:54.583] #8 ExecModifyTable (pstate=0x83834f4a0) at ../src/backend/executor/nodeModifyTable.c:4197 [22:27:54.583] context = {mtstate = 0x83834f4a0, epqstate = 0x83834f588, estate = 0x83834f100, planSlot = 0x844533a58, tmfd = {ctid = {ip_blkid = {bi_hi = 54384, bi_lo = 17486}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x83834f6b0} [22:27:54.583] tuple_ctid = {ip_blkid = {bi_hi = 63160, bi_lo = 14388}, ip_posid = 8} [22:27:54.583] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8383d1118} [22:27:54.583] node = 0x83834f4a0 [22:27:54.583] estate = 0x83834f100 [22:27:54.583] operation = CMD_MERGE [22:27:54.583] resultRelInfo = 0x83834f6b0 [22:27:54.583] subplanstate = 0x838350db0 [22:27:54.583] slot = [22:27:54.583] tupleid = 0x0 [22:27:54.583] oldtuple = 0x8214a6388 [22:27:54.583] tuplock = [22:27:54.583] oldSlot = [22:27:54.583] #9 0x000000000076501b in ExecProcNode (node=0x83834f4a0) at ../src/include/executor/executor.h:278 [22:27:54.583] No locals. [22:27:54.583] #10 ExecutePlan (estate=0x83834f100, planstate=0x83834f4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x83839cb10, execute_once=) at ../src/backend/executor/execMain.c:1659 [22:27:54.583] current_tuple_count = 0 [22:27:54.583] slot = [22:27:54.583] #11 standard_ExecutorRun (queryDesc=0x844338448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [22:27:54.583] estate = 0x83834f100 [22:27:54.583] oldcontext = 0x83839c800 [22:27:54.583] operation = CMD_MERGE [22:27:54.583] dest = 0x83839cb10 [22:27:54.583] sendTuples = true [22:27:54.583] #12 0x000000000093bb9f in ProcessQuery (plan=0x8444ecd58, sourceText=, params=0x0, queryEnv=0x0, dest=0x83839cb10, qc=0x8214a6618) at ../src/backend/tcop/pquery.c:160 [22:27:54.583] queryDesc = 0x844338448 [22:27:54.583] #13 0x000000000093b13d in PortalRunMulti (portal=portal@entry=0x8382ca100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x83839cb10, altdest=0xb83330 , qc=qc@entry=0x8214a6618) at ../src/backend/tcop/pquery.c:1287 [22:27:54.583] pstmt = 0x8444ecd58 [22:27:54.583] stmtlist_item__state = {l = 0x8444f1610, i = 0} [22:27:54.583] active_snapshot_set = true [22:27:54.583] stmtlist_item = 0x8444f1628 [22:27:54.583] #14 0x000000000093ac4c in FillPortalStore (portal=portal@entry=0x8382ca100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [22:27:54.583] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:54.583] treceiver = 0x83839cb10 [22:27:54.583] #15 0x000000000093a9bb in PortalRun (portal=portal@entry=0x8382ca100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8444f1660, altdest=altdest@entry=0x8444f1660, qc=0x8214a6750) at ../src/backend/tcop/pquery.c:763 [22:27:54.583] _local_sigjmp_buf = {{_sjb = {9677149, 35302187264, 34918262344, 34918262576, 34918262352, 35302207488, 12342440, 12375768, 35302146943, 35301314816, 4294967984, 0}}} [22:27:54.583] _save_exception_stack = 0x8214a6820 [22:27:54.583] _save_context_stack = 0x0 [22:27:54.583] _do_rethrow = false [22:27:54.583] saveTopTransactionResourceOwner = 0x8382dc998 [22:27:54.583] saveTopTransactionContext = 0x8382cf000 [22:27:54.583] saveActivePortal = 0x0 [22:27:54.583] saveResourceOwner = 0x8382dc998 [22:27:54.583] savePortalContext = 0x0 [22:27:54.583] saveMemoryContext = 0x8382cf000 [22:27:54.583] result = [22:27:54.583] nprocessed = [22:27:54.583] #16 0x0000000000939882 in exec_simple_query (query_string=query_string@entry=0x8381f5100 "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 [22:27:54.583] cmdtaglen = 5 [22:27:54.583] snapshot_set = [22:27:54.583] per_parsetree_context = 0x0 [22:27:54.583] plantree_list = [22:27:54.583] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:54.583] format = 0 [22:27:54.583] parsetree = 0x8444a38a8 [22:27:54.583] commandTag = [22:27:54.583] cmdtagname = [22:27:54.583] querytree_list = [22:27:54.583] portal = 0x8382ca100 [22:27:54.583] receiver = 0x8444f1660 [22:27:54.583] parsetree_item__state = {l = 0x8444a5170, i = 0} [22:27:54.583] msec_str = "\000\000\000\000\b", '\000' , "\357\201\370f\000\000\000\000\357@XF\b\236", [22:27:54.583] dest = DestRemote [22:27:54.583] was_logged = [22:27:54.583] oldcontext = 0x8382cf000 [22:27:54.583] parsetree_list = 0x8444a5170 [22:27:54.583] use_implicit_block = false [22:27:54.583] parsetree_item = 0x8444a5188 [22:27:54.583] save_log_statement_stats = [22:27:54.583] #17 0x00000000009374f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [22:27:54.583] query_string = 0x8381f5100 "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"... [22:27:54.583] input_message = {data = 0x8381f5100 "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} [22:27:54.583] firstchar = [22:27:54.583] local_sigjmp_buf = {{_sjb = {9660838, 34918262816, 34918262776, 34918263360, 12384504, 1, 8192, 8388608, 34918237055, 0, 0, 1}}} [22:27:54.583] send_ready_for_query = false [22:27:54.583] idle_in_transaction_timeout_enabled = false [22:27:54.583] idle_session_timeout_enabled = false [22:27:54.583] #18 0x0000000000931cd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:27:54.583] bsdata = [22:27:54.583] #19 0x000000000088b867 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8214a7564 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214a74a0) at ../src/backend/postmaster/launch_backend.c:274 [22:27:54.583] pid = [22:27:54.583] #20 0x000000000088fc38 in BackendStartup (client_sock=0x8214a74a0) at ../src/backend/postmaster/postmaster.c:3420 [22:27:54.583] startup_data = {canAcceptConnections = CAC_OK} [22:27:54.583] bn = 0x838201128 [22:27:54.583] pid = [22:27:54.583] __error = [22:27:54.583] save_errno = [22:27:54.583] __error = [22:27:54.583] __error = [22:27:54.583] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [22:27:54.583] 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 = "\000o\0378\b", '\000' , "uJ!\b\000\000\000h5\323+\b\000\000\000\v\000\000\000\000\000\000\000^\277\323+\b", '\000' , "@uJ!\b\000\000\000\024\266\210\000\000\000\000\000PuJ!\b", '\000' }, salen = 16}} [22:27:54.583] i = 0 [22:27:54.583] now = [22:27:54.583] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 748113026, events = 8, fd = 0, user_data = 0x8214a7450}, {pos = 941975000, events = 8, fd = 558527200, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x29f4a112e30a}, {pos = 747280288, events = 8, fd = 747351416, user_data = 0x8214a6f68}, {pos = 558526432, events = 8, fd = 558526312, user_data = 0x29f4a112e30a}, {pos = 747258760, events = 8, fd = 747351416, user_data = 0x8214a6f98}, {pos = 558526480, events = 8, fd = 558526360, user_data = 0x82c8b3194}, {pos = 560817160, events = 8, fd = 747319700, user_data = 0x8214a7000}, {pos = -1592617926, events = 10740, fd = 749142064, user_data = 0x1}, {pos = 558526512, events = 8, fd = -1592597750, user_data = 0x82c89c858}, {pos = 747351416, events = 8, fd = 558526472, user_data = 0x8214a7080}, {pos = 558526472, events = 8, fd = 747314444, user_data = 0x8216d6408}, {pos = 747314444, events = 8, fd = 558526576, user_data = 0x29f4a112943a}, {pos = 558526616, events = 8, fd = 558527064, user_data = 0x8214a7080}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1201659047, fd = 560840760, user_data = 0x800000001}, {pos = 560817160, events = 8, fd = 747258760, user_data = 0x8216db288}, {pos = 747227224, events = 8, fd = 560817160, user_data = 0x8214a7108}, {pos = 558527176, events = 8, fd = 558526704, user_data = 0x29f4a112dca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560840760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558527432, user_data = 0x216d6408}, {pos = 558527248, events = 8, fd = 558526848, user_data = 0x1}, {pos = 558527176, events = 8, fd = 32, user_data = 0x8214a7170}, {pos = -1592599949, events = 10740, fd = 558527120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216dc038}, {pos = 1, events = 8, fd = 560817160, user_data = 0x82c89c858}, {pos = 558527432, events = 8, fd = 558527248, user_data = 0x8214a7180}, {pos = 0, events = 0, fd = 560787464, user_data = 0x20}, {pos = 558527232, events = 8, fd = -1592624409, user_data = 0x8216cf008}, {pos = 560788488, events = 8, fd = 560789512, user_data = 0x8216cfc08}, {pos = 560803848, events = 8, fd = 560804872, user_data = 0x8216d3808}, {pos = 560806920, events = 8, fd = 560807944, user_data = 0x8216d4408}, {pos = 560809992, events = 8, fd = 560811016, user_data = 0x8216d5008}, {pos = 560813064, events = 8, fd = 560814088, user_data = 0x8216d5c08}, {pos = 560816136, events = 8, fd = 560817160, user_data = 0x8216d6808}, {pos = 560819208, events = 8, fd = 560820232, user_data = 0x8216d7408}, {pos = 560822280, events = 8, fd = 560823304, user_data = 0x8216d8008}, {pos = 560825352, events = 8, fd = 560826376, user_data = 0x8216d8c08}, {pos = 560832520, events = 8, fd = 560833544, user_data = 0x8216da808}, {pos = 560835592, events = 8, fd = 560787464, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558527432, events = 8, fd = 558526848, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560787464, events = 8, fd = 313, user_data = 0x8214a73b0}, {pos = -1592625681, events = 10740, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560817160, events = 8, fd = 941510656, user_data = 0x1}, {pos = 941511060, events = 8, fd = 0, user_data = 0x8214a7380}, {pos = 735294828, events = 8, fd = 1, user_data = 0x8381e5000}, {pos = 558527408, events = 8, fd = 735291138, user_data = 0x82c9ce170 }, {pos = 12305440, events = 0, fd = 748478832, user_data = 0x8216d6408}, {pos = 558527632, events = 8, fd = -1592626210, user_data = 0x838203800}, {pos = 1, events = 0, fd = -1592626594, user_data = 0x8216cf008}, {pos = 558527416, events = 8, fd = 558527632, user_data = 0x1c20}, {pos = 941584128, events = 8, fd = -1592546928, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8107639, user_data = 0x8214a7440}, {pos = 735253520, events = 8, fd = 749142064, user_data = 0x82ca72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214a7470}, {pos = 735296413, events = 8, fd = 941510656, user_data = 0x1740}, {pos = 558527696, events = 8, fd = 735262970, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x0}} [22:27:54.583] last_touch_time = 1727562212 [22:27:54.583] last_lockfile_recheck_time = 1727562212 [22:27:54.583] nevents = 1 [22:27:54.583] #22 0x000000000088da55 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214a7ab8) at ../src/backend/postmaster/postmaster.c:1351 [22:27:54.583] userDoption = [22:27:54.583] listen_addr_saved = [22:27:54.583] output_config_variable = [22:27:54.583] opt = [22:27:54.583] status = [22:27:54.583] #23 0x00000000007c835c in main (argc=8, argv=0x8214a7ab8) at ../src/backend/main/main.c:197 [22:27:54.583] do_check_root = [22:27:54.595] [22:27:54.595] [22:27:54.595] [22:27:54.664] dumping /tmp/cores/postgres.8109.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:27:54.791] [New LWP 101690] [22:27:54.862] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [22:27:54.862] Program terminated with signal SIGABRT, Aborted. [22:27:54.862] Sent by thr_kill() from pid 8109 and user 1003. [22:27:54.862] #0 0x000000082b60a41a in thr_kill () from /lib/libc.so.7 [22:27:55.442] [22:27:55.442] Thread 1 (LWP 101690): [22:27:55.442] #0 0x000000082b60a41a in thr_kill () from /lib/libc.so.7 [22:27:55.442] No symbol table info available. [22:27:55.442] #1 0x000000082b583e64 in raise () from /lib/libc.so.7 [22:27:55.442] No symbol table info available. [22:27:55.442] #2 0x000000082b6346f9 in abort () from /lib/libc.so.7 [22:27:55.442] No symbol table info available. [22:27:55.442] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x2d1ba0 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [22:27:55.442] No locals. [22:27:55.442] #4 0x0000000000772ebf in ExecFetchSlotHeapTuple (slot=0x8215d9d08, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [22:27:55.442] No locals. [22:27:55.442] #5 0x0000000000737847 in ExecIRDeleteTriggers (estate=estate@entry=0x837099100, relinfo=relinfo@entry=0x8370996b0, slot=slot@entry=0x8215d9d08) at ../src/backend/commands/trigger.c:2842 [22:27:55.442] trigger = [22:27:55.442] oldtuple = [22:27:55.442] should_free = false [22:27:55.442] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x843dd2c38, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [22:27:55.442] trigdesc = 0x8370998c0 [22:27:55.442] newtuple = 0x0 [22:27:55.442] i = 0 [22:27:55.442] #6 0x0000000000798184 in ExecMergeMatched (context=0x8215d9d98, resultRelInfo=0x8370996b0, tupleid=0x0, oldtuple=0x8215d9d08, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [22:27:55.442] result = TM_Ok [22:27:55.442] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [22:27:55.442] relaction = 0x843eb37e0 [22:27:55.442] commandType = CMD_DELETE [22:27:55.442] l__state = {l = 0x843f708b8, i = 0} [22:27:55.442] lockedtid = [22:27:55.442] mtstate = 0x8370994a0 [22:27:55.442] newslot = 0x0 [22:27:55.442] rslot = 0x0 [22:27:55.442] estate = 0x837099100 [22:27:55.442] mergeActions = [22:27:55.442] econtext = 0x843f6f958 [22:27:55.442] epqstate = 0x837099588 [22:27:55.442] actionStates = 0x843f708b8 [22:27:55.442] l = [22:27:55.442] isNull = [22:27:55.442] lmerge_matched = [22:27:55.442] __error = [22:27:55.442] l__state = [22:27:55.442] result = [22:27:55.442] updateCxt = [22:27:55.442] relaction = [22:27:55.442] commandType = [22:27:55.442] __error = [22:27:55.442] resultRelationDesc = [22:27:55.442] lockmode = [22:27:55.442] inputslot = [22:27:55.442] epqslot = [22:27:55.442] was_matched = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] #7 ExecMerge (context=0x8215d9d98, resultRelInfo=0x8370996b0, tupleid=0x0, oldtuple=0x8215d9d08, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [22:27:55.442] matched = true [22:27:55.442] rslot = 0x0 [22:27:55.442] #8 ExecModifyTable (pstate=0x8370994a0) at ../src/backend/executor/nodeModifyTable.c:4197 [22:27:55.442] context = {mtstate = 0x8370994a0, epqstate = 0x837099588, estate = 0x837099100, planSlot = 0x843f6dd58, tmfd = {ctid = {ip_blkid = {bi_hi = 38064, bi_lo = 17394}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8370996b0} [22:27:55.442] tuple_ctid = {ip_blkid = {bi_hi = 38584, bi_lo = 14089}, ip_posid = 8} [22:27:55.442] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83707e118} [22:27:55.442] node = 0x8370994a0 [22:27:55.442] estate = 0x837099100 [22:27:55.442] operation = CMD_MERGE [22:27:55.442] resultRelInfo = 0x8370996b0 [22:27:55.442] subplanstate = 0x83709adb0 [22:27:55.442] slot = [22:27:55.442] tupleid = 0x0 [22:27:55.442] oldtuple = 0x8215d9d08 [22:27:55.442] tuplock = [22:27:55.442] oldSlot = [22:27:55.442] #9 0x000000000076501b in ExecProcNode (node=0x8370994a0) at ../src/include/executor/executor.h:278 [22:27:55.442] No locals. [22:27:55.442] #10 ExecutePlan (estate=0x837099100, planstate=0x8370994a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x836f16b10, execute_once=) at ../src/backend/executor/execMain.c:1659 [22:27:55.442] current_tuple_count = 0 [22:27:55.442] slot = [22:27:55.442] #11 standard_ExecutorRun (queryDesc=0x836fe9c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [22:27:55.442] estate = 0x837099100 [22:27:55.442] oldcontext = 0x836f16800 [22:27:55.442] operation = CMD_MERGE [22:27:55.442] dest = 0x836f16b10 [22:27:55.442] sendTuples = true [22:27:55.442] #12 0x000000000093bb9f in ProcessQuery (plan=0x843f28d98, sourceText=, params=0x0, queryEnv=0x0, dest=0x836f16b10, qc=0x8215d9f98) at ../src/backend/tcop/pquery.c:160 [22:27:55.442] queryDesc = 0x836fe9c48 [22:27:55.442] #13 0x000000000093b13d in PortalRunMulti (portal=portal@entry=0x836f80100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x836f16b10, altdest=0xb83330 , qc=qc@entry=0x8215d9f98) at ../src/backend/tcop/pquery.c:1287 [22:27:55.442] pstmt = 0x843f28d98 [22:27:55.442] stmtlist_item__state = {l = 0x843f2d650, i = 0} [22:27:55.442] active_snapshot_set = true [22:27:55.442] stmtlist_item = 0x843f2d668 [22:27:55.442] #14 0x000000000093ac4c in FillPortalStore (portal=portal@entry=0x836f80100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [22:27:55.442] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:55.442] treceiver = 0x836f16b10 [22:27:55.442] #15 0x000000000093a9bb in PortalRun (portal=portal@entry=0x836f80100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x843f2d6a0, altdest=altdest@entry=0x843f2d6a0, qc=0x8215da0d0) at ../src/backend/tcop/pquery.c:763 [22:27:55.442] _local_sigjmp_buf = {{_sjb = {9677149, 35281961216, 34919522248, 34919522480, 34919522256, 35281977344, 12342440, 12375768, 35281961855, 35281289472, 4294967984, 0}}} [22:27:55.442] _save_exception_stack = 0x8215da1a0 [22:27:55.442] _save_context_stack = 0x0 [22:27:55.442] _do_rethrow = false [22:27:55.442] saveTopTransactionResourceOwner = 0x836fc8058 [22:27:55.442] saveTopTransactionContext = 0x836f84000 [22:27:55.442] saveActivePortal = 0x0 [22:27:55.442] saveResourceOwner = 0x836fc8058 [22:27:55.442] savePortalContext = 0x0 [22:27:55.442] saveMemoryContext = 0x836f84000 [22:27:55.442] result = [22:27:55.442] nprocessed = [22:27:55.442] #16 0x0000000000939882 in exec_simple_query (query_string=query_string@entry=0x836edc100 "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 [22:27:55.442] cmdtaglen = 5 [22:27:55.442] snapshot_set = [22:27:55.442] per_parsetree_context = 0x0 [22:27:55.442] plantree_list = [22:27:55.442] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:55.442] format = 0 [22:27:55.442] parsetree = 0x843ee9a28 [22:27:55.442] commandTag = [22:27:55.442] cmdtagname = [22:27:55.442] querytree_list = [22:27:55.442] portal = 0x836f80100 [22:27:55.442] receiver = 0x843f2d6a0 [22:27:55.442] parsetree_item__state = {l = 0x843eeb2f0, i = 0} [22:27:55.442] msec_str = "\000\000\000\000\b", '\000' , "\361\201\370f\000\000\000\000\373]\200,t\324\303#" [22:27:55.442] dest = DestRemote [22:27:55.442] was_logged = [22:27:55.442] oldcontext = 0x836f84000 [22:27:55.442] parsetree_list = 0x843eeb2f0 [22:27:55.442] use_implicit_block = false [22:27:55.442] parsetree_item = 0x843eeb308 [22:27:55.442] save_log_statement_stats = [22:27:55.442] #17 0x00000000009374f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [22:27:55.442] query_string = 0x836edc100 "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"... [22:27:55.442] input_message = {data = 0x836edc100 "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} [22:27:55.442] firstchar = [22:27:55.442] local_sigjmp_buf = {{_sjb = {9660838, 34919522720, 34919522680, 34919523264, 12384504, 1, 8192, 8388608, 34919482239, 0, 0, 1}}} [22:27:55.442] send_ready_for_query = false [22:27:55.442] idle_in_transaction_timeout_enabled = false [22:27:55.442] idle_session_timeout_enabled = false [22:27:55.442] #18 0x0000000000931cd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:27:55.442] bsdata = [22:27:55.442] #19 0x000000000088b867 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8215daee4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215dae20) at ../src/backend/postmaster/launch_backend.c:274 [22:27:55.442] pid = [22:27:55.442] #20 0x000000000088fc38 in BackendStartup (client_sock=0x8215dae20) at ../src/backend/postmaster/postmaster.c:3420 [22:27:55.442] startup_data = {canAcceptConnections = CAC_OK} [22:27:55.442] bn = 0x836ee8448 [22:27:55.442] pid = [22:27:55.442] __error = [22:27:55.442] save_errno = [22:27:55.442] __error = [22:27:55.442] __error = [22:27:55.442] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [22:27:55.442] 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\336\3556\b", '\000' , "\200\256]!\b\000\000\000h\225q*\b\000\000\000\v\000\000\000\000\000\000\000^\037r*\b", '\000' , "\300\256]!\b\000\000\000\024\266\210\000\000\000\000\000Ю]!\b", '\000' }, salen = 16}} [22:27:55.442] i = 0 [22:27:55.442] now = [22:27:55.442] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 727379074, events = 8, fd = 0, user_data = 0x8215dadd0}, {pos = 921978328, events = 8, fd = 559787104, user_data = 0x0}, {pos = 0, events = 0, fd = -2061915258, user_data = 0xcf104b8930a}, {pos = 726546336, events = 8, fd = 726617464, user_data = 0x8215da8e8}, {pos = 559786336, events = 8, fd = 559786216, user_data = 0xcf104b8930a}, {pos = 726524808, events = 8, fd = 726617464, user_data = 0x8215da918}, {pos = 559786384, events = 8, fd = 559786264, user_data = 0x82b4ed194}, {pos = 565277704, events = 8, fd = 726585748, user_data = 0x8215da980}, {pos = 79184954, events = 3313, fd = 728408112, user_data = 0x1}, {pos = 559786416, events = 8, fd = 79205130, user_data = 0x82b4d6858}, {pos = 726617464, events = 8, fd = 559786376, user_data = 0x8215daa00}, {pos = 559786376, events = 8, fd = 726580492, user_data = 0x821b17408}, {pos = 726580492, events = 8, fd = 559786480, user_data = 0xcf104b8443a}, {pos = 559786520, events = 8, fd = 559786968, user_data = 0x8215daa00}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1661838428, fd = 565301304, user_data = 0x800000001}, {pos = 565277704, events = 8, fd = 726524808, user_data = 0x821b1c288}, {pos = 726493272, events = 8, fd = 565277704, user_data = 0x8215daa88}, {pos = 559787080, events = 8, fd = 559786608, user_data = 0xcf104b88ca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 565301304, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 559787336, user_data = 0x21b17408}, {pos = 559787152, events = 8, fd = 559786752, user_data = 0x1}, {pos = 559787080, events = 8, fd = 32, user_data = 0x8215daaf0}, {pos = 79202931, events = 3313, fd = 559787024, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821b1d038}, {pos = 1, events = 8, fd = 565277704, user_data = 0x82b4d6858}, {pos = 559787336, events = 8, fd = 559787152, user_data = 0x8215dab00}, {pos = 0, events = 0, fd = 565248008, user_data = 0x20}, {pos = 559787136, events = 8, fd = 79178471, user_data = 0x821b10008}, {pos = 565249032, events = 8, fd = 565250056, user_data = 0x821b10c08}, {pos = 565264392, events = 8, fd = 565265416, user_data = 0x821b14808}, {pos = 565267464, events = 8, fd = 565268488, user_data = 0x821b15408}, {pos = 565270536, events = 8, fd = 565271560, user_data = 0x821b16008}, {pos = 565273608, events = 8, fd = 565274632, user_data = 0x821b16c08}, {pos = 565276680, events = 8, fd = 565277704, user_data = 0x821b17808}, {pos = 565279752, events = 8, fd = 565280776, user_data = 0x821b18408}, {pos = 565282824, events = 8, fd = 565283848, user_data = 0x821b19008}, {pos = 565285896, events = 8, fd = 565286920, user_data = 0x821b19c08}, {pos = 565293064, events = 8, fd = 565294088, user_data = 0x821b1b808}, {pos = 565296136, events = 8, fd = 565248008, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821b1d038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 559787336, events = 8, fd = 559786752, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 565301304, user_data = 0x1}, {pos = 565248008, events = 8, fd = 313, user_data = 0x8215dad30}, {pos = 79177199, events = 3313, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565301304, user_data = 0x1}, {pos = 565277704, events = 8, fd = 921485312, user_data = 0x1}, {pos = 921485716, events = 8, fd = 0, user_data = 0x8215dad00}, {pos = 712119660, events = 8, fd = 1, user_data = 0x836ecc000}, {pos = 559787312, events = 8, fd = 712115970, user_data = 0x82b608170 }, {pos = 12305440, events = 0, fd = 727744880, user_data = 0x821b17408}, {pos = 559787536, events = 8, fd = 79176670, user_data = 0x836eea800}, {pos = 1, events = 0, fd = 79176286, user_data = 0x821b10008}, {pos = 559787320, events = 8, fd = 559787536, user_data = 0x1c20}, {pos = 921558720, events = 8, fd = 79255952, user_data = 0x0}, {pos = 559743871, events = 8, fd = 8107639, user_data = 0x8215dadc0}, {pos = 712078352, events = 8, fd = 728408112, user_data = 0x82b6ac310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8215dadf0}, {pos = 712121245, events = 8, fd = 921485312, user_data = 0x177e}, {pos = 559787600, events = 8, fd = 712087802, user_data = 0x0}, {pos = 0, events = 0, fd = -2061915258, user_data = 0x0}} [22:27:55.442] last_touch_time = 1727562212 [22:27:55.442] last_lockfile_recheck_time = 1727562212 [22:27:55.442] nevents = 1 [22:27:55.442] #22 0x000000000088da55 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8215db430) at ../src/backend/postmaster/postmaster.c:1351 [22:27:55.442] userDoption = [22:27:55.442] listen_addr_saved = [22:27:55.442] output_config_variable = [22:27:55.442] opt = [22:27:55.442] status = [22:27:55.442] #23 0x00000000007c835c in main (argc=4, argv=0x8215db430) at ../src/backend/main/main.c:197 [22:27:55.442] do_check_root = [22:27:55.454] [22:27:55.454] [22:27:55.454] [22:27:55.514] dumping /tmp/cores/postgres.8413.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:55.641] [New LWP 101743] [22:27:55.709] Core was generated by `postgres: autovacuum worker regression'. [22:27:55.709] Program terminated with signal SIGABRT, Aborted. [22:27:55.709] Sent by thr_kill() from pid 8413 and user 1003. [22:27:55.709] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:55.863] [22:27:55.863] Thread 1 (LWP 101743): [22:27:55.863] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:55.863] No symbol table info available. [22:27:55.863] #1 0x000000082c949e64 in raise () from /lib/libc.so.7 [22:27:55.863] No symbol table info available. [22:27:55.863] #2 0x000000082c9fa6f9 in abort () from /lib/libc.so.7 [22:27:55.863] No symbol table info available. [22:27:55.863] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x3566b5 "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [22:27:55.863] No locals. [22:27:55.863] #4 0x0000000000696efa in index_drop (indexId=21353, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [22:27:55.863] heaprelid = {relId = 10972895, dbId = 0} [22:27:55.863] indexrelid = {relId = 558523360, dbId = 8} [22:27:55.863] heapId = 21352 [22:27:55.863] lockmode = [22:27:55.863] userHeapRelation = 0x8383414e8 [22:27:55.863] userIndexRelation = 0x83834d2b0 [22:27:55.863] heaplocktag = [22:27:55.863] indexRelation = [22:27:55.863] tuple = [22:27:55.863] hasexprs = [22:27:55.863] #5 0x000000000068e5ce in doDeletion (object=object@entry=0x8383775b0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [22:27:55.863] concurrent = [22:27:55.863] concurrent_lock_mode = [22:27:55.863] relKind = 105 'i' [22:27:55.863] #6 0x000000000068ca90 in deleteOneObject (object=0x8383775b0, depRel=0x8214a66a0, flags=21) at ../src/backend/catalog/dependency.c:1274 [22:27:55.863] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 943153152, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 20845, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35302685968}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 943161280, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 144 '\220', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x8214a6680}, sk_argument = 6866065}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 558524304, 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 = 0x8214a6790, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35536543736}} [22:27:55.863] nkeys = [22:27:55.863] scan = [22:27:55.863] tup = [22:27:55.863] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x8462492a8, depRel=depRel@entry=0x8214a66a0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [22:27:55.863] thisobj = 0x8383775b0 [22:27:55.863] thisextra = [22:27:55.863] i = 0 [22:27:55.863] #8 0x000000000068b725 in performDeletion (object=object@entry=0x8214a6790, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [22:27:55.863] depRel = 0x83833d788 [22:27:55.863] targetObjects = 0x8462492a8 [22:27:55.863] #9 0x00000000008869d6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [22:27:55.863] object = {classId = 1259, objectId = 20845, objectSubId = 0} [22:27:55.863] relid = 20845 [22:27:55.863] classForm = [22:27:55.863] cell__state = {l = 0x83837ff98, i = } [22:27:55.863] 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} [22:27:55.863] cell = 0x8383c97f8 [22:27:55.863] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x975020 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 116} [22:27:55.863] table_oids = [22:27:55.863] orphan_oids = [22:27:55.863] did_vacuum = false [22:27:55.863] found_concurrent_worker = false [22:27:55.863] effective_multixact_freeze_max_age = 400000000 [22:27:55.863] tuple = [22:27:55.863] classRel = 0x838339ae8 [22:27:55.863] pg_class_desc = 0x838376100 [22:27:55.863] table_toast_map = 0x83837a100 [22:27:55.863] relScan = [22:27:55.863] bstrategy = [22:27:55.863] i = [22:27:55.863] dbForm = [22:27:55.863] #10 0x00000000008861c9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [22:27:55.863] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000@jJ!\b\000\000\000PiJ!\b\000\000\000\"\231\220\000\000\000\000\000GB\254\v\247ܟG(\005\274\000\000\000\000" [22:27:55.863] local_sigjmp_buf = {{_sjb = {8937139, 1, 34918263176, 34918263376, 12221876, 3, 34918263184, 0, 895, -2147815357, -1, 1}}} [22:27:55.863] dbid = 16384 [22:27:55.863] #11 0x000000000088b867 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 [22:27:55.863] pid = [22:27:55.863] #12 0x000000000088f8cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [22:27:55.863] pid = [22:27:55.863] __error = [22:27:55.863] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [22:27:55.863] bn = 0x8382014e8 [22:27:55.863] __error = [22:27:55.863] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [22:27:55.863] __error = [22:27:55.863] __error = [22:27:55.863] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [22:27:55.863] i = 0 [22:27:55.863] now = [22:27:55.863] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 748113026, events = 8, fd = 0, user_data = 0x8214a7450}, {pos = 941975000, events = 8, fd = 558527200, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x29f4a112e30a}, {pos = 747280288, events = 8, fd = 747351416, user_data = 0x8214a6f68}, {pos = 558526432, events = 8, fd = 558526312, user_data = 0x29f4a112e30a}, {pos = 747258760, events = 8, fd = 747351416, user_data = 0x8214a6f98}, {pos = 558526480, events = 8, fd = 558526360, user_data = 0x82c8b3194}, {pos = 560817160, events = 8, fd = 747319700, user_data = 0x8214a7000}, {pos = -1592617926, events = 10740, fd = 749142064, user_data = 0x1}, {pos = 558526512, events = 8, fd = -1592597750, user_data = 0x82c89c858}, {pos = 747351416, events = 8, fd = 558526472, user_data = 0x8214a7080}, {pos = 558526472, events = 8, fd = 747314444, user_data = 0x8216d6408}, {pos = 747314444, events = 8, fd = 558526576, user_data = 0x29f4a112943a}, {pos = 558526616, events = 8, fd = 558527064, user_data = 0x8214a7080}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1201659047, fd = 560840760, user_data = 0x800000001}, {pos = 560817160, events = 8, fd = 747258760, user_data = 0x8216db288}, {pos = 747227224, events = 8, fd = 560817160, user_data = 0x8214a7108}, {pos = 558527176, events = 8, fd = 558526704, user_data = 0x29f4a112dca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560840760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558527432, user_data = 0x216d6408}, {pos = 558527248, events = 8, fd = 558526848, user_data = 0x1}, {pos = 558527176, events = 8, fd = 32, user_data = 0x8214a7170}, {pos = -1592599949, events = 10740, fd = 558527120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216dc038}, {pos = 1, events = 8, fd = 560817160, user_data = 0x82c89c858}, {pos = 558527432, events = 8, fd = 558527248, user_data = 0x8214a7180}, {pos = 0, events = 0, fd = 560787464, user_data = 0x20}, {pos = 558527232, events = 8, fd = -1592624409, user_data = 0x8216cf008}, {pos = 560788488, events = 8, fd = 560789512, user_data = 0x8216cfc08}, {pos = 560803848, events = 8, fd = 560804872, user_data = 0x8216d3808}, {pos = 560806920, events = 8, fd = 560807944, user_data = 0x8216d4408}, {pos = 560809992, events = 8, fd = 560811016, user_data = 0x8216d5008}, {pos = 560813064, events = 8, fd = 560814088, user_data = 0x8216d5c08}, {pos = 560816136, events = 8, fd = 560817160, user_data = 0x8216d6808}, {pos = 560819208, events = 8, fd = 560820232, user_data = 0x8216d7408}, {pos = 560822280, events = 8, fd = 560823304, user_data = 0x8216d8008}, {pos = 560825352, events = 8, fd = 560826376, user_data = 0x8216d8c08}, {pos = 560832520, events = 8, fd = 560833544, user_data = 0x8216da808}, {pos = 560835592, events = 8, fd = 560787464, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558527432, events = 8, fd = 558526848, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560787464, events = 8, fd = 313, user_data = 0x8214a73b0}, {pos = -1592625681, events = 10740, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560817160, events = 8, fd = 941510656, user_data = 0x1}, {pos = 941511060, events = 8, fd = 0, user_data = 0x8214a7380}, {pos = 735294828, events = 8, fd = 1, user_data = 0x8381e5000}, {pos = 558527408, events = 8, fd = 735291138, user_data = 0x82c9ce170 }, {pos = 12305440, events = 0, fd = 748478832, user_data = 0x8216d6408}, {pos = 558527632, events = 8, fd = -1592626210, user_data = 0x838203800}, {pos = 1, events = 0, fd = -1592626594, user_data = 0x8216cf008}, {pos = 558527416, events = 8, fd = 558527632, user_data = 0x1c20}, {pos = 941584128, events = 8, fd = -1592546928, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8107639, user_data = 0x8214a7440}, {pos = 735253520, events = 8, fd = 749142064, user_data = 0x82ca72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214a7470}, {pos = 735296413, events = 8, fd = 941510656, user_data = 0x1740}, {pos = 558527696, events = 8, fd = 735262970, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x0}} [22:27:55.863] last_touch_time = 1727562212 [22:27:55.863] last_lockfile_recheck_time = 1727562212 [22:27:55.863] nevents = 1 [22:27:55.863] #16 0x000000000088da55 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214a7ab8) at ../src/backend/postmaster/postmaster.c:1351 [22:27:55.863] userDoption = [22:27:55.863] listen_addr_saved = [22:27:55.863] output_config_variable = [22:27:55.863] opt = [22:27:55.863] status = [22:27:55.863] #17 0x00000000007c835c in main (argc=8, argv=0x8214a7ab8) at ../src/backend/main/main.c:197 [22:27:55.863] do_check_root = [22:27:55.874] [22:27:55.874] [22:27:55.874] [22:27:55.934] dumping /tmp/cores/postgres.8665.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:56.057] [New LWP 101655] [22:27:56.125] Core was generated by `postgres: autovacuum worker regression'. [22:27:56.125] Program terminated with signal SIGABRT, Aborted. [22:27:56.125] Sent by thr_kill() from pid 8665 and user 1003. [22:27:56.125] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:56.286] [22:27:56.286] Thread 1 (LWP 101655): [22:27:56.286] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:56.286] No symbol table info available. [22:27:56.286] #1 0x000000082c949e64 in raise () from /lib/libc.so.7 [22:27:56.286] No symbol table info available. [22:27:56.286] #2 0x000000082c9fa6f9 in abort () from /lib/libc.so.7 [22:27:56.286] No symbol table info available. [22:27:56.286] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x3566b5 "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [22:27:56.286] No locals. [22:27:56.286] #4 0x0000000000696efa in index_drop (indexId=25052, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [22:27:56.286] heaprelid = {relId = 10972895, dbId = 0} [22:27:56.286] indexrelid = {relId = 558523360, dbId = 8} [22:27:56.286] heapId = 25047 [22:27:56.286] lockmode = [22:27:56.286] userHeapRelation = 0x838341328 [22:27:56.286] userIndexRelation = 0x838348e30 [22:27:56.286] heaplocktag = [22:27:56.286] indexRelation = [22:27:56.286] tuple = [22:27:56.286] hasexprs = [22:27:56.286] #5 0x000000000068e5ce in doDeletion (object=object@entry=0x83839e768, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [22:27:56.286] concurrent = [22:27:56.286] concurrent_lock_mode = [22:27:56.286] relKind = 105 'i' [22:27:56.286] #6 0x000000000068ca90 in deleteOneObject (object=0x83839e768, depRel=0x8214a66a0, flags=21) at ../src/backend/catalog/dependency.c:1274 [22:27:56.286] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 943153152, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 25047, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35302685520}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 943161280, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 144 '\220', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x8214a6680}, sk_argument = 6866065}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 558524304, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x8214a6790, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35303211800}} [22:27:56.286] nkeys = [22:27:56.286] scan = [22:27:56.286] tup = [22:27:56.286] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x8383c35c8, depRel=depRel@entry=0x8214a66a0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [22:27:56.286] thisobj = 0x83839e768 [22:27:56.286] thisextra = [22:27:56.286] i = 0 [22:27:56.286] #8 0x000000000068b725 in performDeletion (object=object@entry=0x8214a6790, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [22:27:56.286] depRel = 0x83833d2a8 [22:27:56.286] targetObjects = 0x8383c35c8 [22:27:56.286] #9 0x00000000008869d6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [22:27:56.286] object = {classId = 1259, objectId = 25047, objectSubId = 0} [22:27:56.286] relid = 25047 [22:27:56.286] classForm = [22:27:56.286] cell__state = {l = 0x83837ff98, i = } [22:27:56.286] 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} [22:27:56.286] cell = 0x83839c580 [22:27:56.286] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x975020 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 116} [22:27:56.286] table_oids = [22:27:56.286] orphan_oids = [22:27:56.286] did_vacuum = false [22:27:56.286] found_concurrent_worker = false [22:27:56.286] effective_multixact_freeze_max_age = 400000000 [22:27:56.286] tuple = [22:27:56.286] classRel = 0x838339928 [22:27:56.286] pg_class_desc = 0x838376100 [22:27:56.286] table_toast_map = 0x83837a100 [22:27:56.286] relScan = [22:27:56.286] bstrategy = [22:27:56.286] i = [22:27:56.286] dbForm = [22:27:56.286] #10 0x00000000008861c9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [22:27:56.286] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000@jJ!\b\000\000\000PiJ!\b\000\000\000\"\231\220\000\000\000\000\000GB\254\v\247ܟG(\005\274\000\000\000\000" [22:27:56.286] local_sigjmp_buf = {{_sjb = {8937139, 1, 34918263176, 34918263376, 12221876, 3, 34918263184, 0, 895, -2147815357, -1, 1}}} [22:27:56.286] dbid = 16384 [22:27:56.286] #11 0x000000000088b867 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 [22:27:56.286] pid = [22:27:56.286] #12 0x000000000088f8cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [22:27:56.286] pid = [22:27:56.286] __error = [22:27:56.286] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [22:27:56.286] bn = 0x8382014e8 [22:27:56.286] __error = [22:27:56.286] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [22:27:56.286] __error = [22:27:56.286] __error = [22:27:56.286] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [22:27:56.286] i = 0 [22:27:56.286] now = [22:27:56.286] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 748113026, events = 8, fd = 0, user_data = 0x8214a7450}, {pos = 941975000, events = 8, fd = 558527200, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x29f4a112e30a}, {pos = 747280288, events = 8, fd = 747351416, user_data = 0x8214a6f68}, {pos = 558526432, events = 8, fd = 558526312, user_data = 0x29f4a112e30a}, {pos = 747258760, events = 8, fd = 747351416, user_data = 0x8214a6f98}, {pos = 558526480, events = 8, fd = 558526360, user_data = 0x82c8b3194}, {pos = 560817160, events = 8, fd = 747319700, user_data = 0x8214a7000}, {pos = -1592617926, events = 10740, fd = 749142064, user_data = 0x1}, {pos = 558526512, events = 8, fd = -1592597750, user_data = 0x82c89c858}, {pos = 747351416, events = 8, fd = 558526472, user_data = 0x8214a7080}, {pos = 558526472, events = 8, fd = 747314444, user_data = 0x8216d6408}, {pos = 747314444, events = 8, fd = 558526576, user_data = 0x29f4a112943a}, {pos = 558526616, events = 8, fd = 558527064, user_data = 0x8214a7080}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1201659047, fd = 560840760, user_data = 0x800000001}, {pos = 560817160, events = 8, fd = 747258760, user_data = 0x8216db288}, {pos = 747227224, events = 8, fd = 560817160, user_data = 0x8214a7108}, {pos = 558527176, events = 8, fd = 558526704, user_data = 0x29f4a112dca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560840760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558527432, user_data = 0x216d6408}, {pos = 558527248, events = 8, fd = 558526848, user_data = 0x1}, {pos = 558527176, events = 8, fd = 32, user_data = 0x8214a7170}, {pos = -1592599949, events = 10740, fd = 558527120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216dc038}, {pos = 1, events = 8, fd = 560817160, user_data = 0x82c89c858}, {pos = 558527432, events = 8, fd = 558527248, user_data = 0x8214a7180}, {pos = 0, events = 0, fd = 560787464, user_data = 0x20}, {pos = 558527232, events = 8, fd = -1592624409, user_data = 0x8216cf008}, {pos = 560788488, events = 8, fd = 560789512, user_data = 0x8216cfc08}, {pos = 560803848, events = 8, fd = 560804872, user_data = 0x8216d3808}, {pos = 560806920, events = 8, fd = 560807944, user_data = 0x8216d4408}, {pos = 560809992, events = 8, fd = 560811016, user_data = 0x8216d5008}, {pos = 560813064, events = 8, fd = 560814088, user_data = 0x8216d5c08}, {pos = 560816136, events = 8, fd = 560817160, user_data = 0x8216d6808}, {pos = 560819208, events = 8, fd = 560820232, user_data = 0x8216d7408}, {pos = 560822280, events = 8, fd = 560823304, user_data = 0x8216d8008}, {pos = 560825352, events = 8, fd = 560826376, user_data = 0x8216d8c08}, {pos = 560832520, events = 8, fd = 560833544, user_data = 0x8216da808}, {pos = 560835592, events = 8, fd = 560787464, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558527432, events = 8, fd = 558526848, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560787464, events = 8, fd = 313, user_data = 0x8214a73b0}, {pos = -1592625681, events = 10740, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560817160, events = 8, fd = 941510656, user_data = 0x1}, {pos = 941511060, events = 8, fd = 0, user_data = 0x8214a7380}, {pos = 735294828, events = 8, fd = 1, user_data = 0x8381e5000}, {pos = 558527408, events = 8, fd = 735291138, user_data = 0x82c9ce170 }, {pos = 12305440, events = 0, fd = 748478832, user_data = 0x8216d6408}, {pos = 558527632, events = 8, fd = -1592626210, user_data = 0x838203800}, {pos = 1, events = 0, fd = -1592626594, user_data = 0x8216cf008}, {pos = 558527416, events = 8, fd = 558527632, user_data = 0x1c20}, {pos = 941584128, events = 8, fd = -1592546928, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8107639, user_data = 0x8214a7440}, {pos = 735253520, events = 8, fd = 749142064, user_data = 0x82ca72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214a7470}, {pos = 735296413, events = 8, fd = 941510656, user_data = 0x1740}, {pos = 558527696, events = 8, fd = 735262970, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x0}} [22:27:56.286] last_touch_time = 1727562212 [22:27:56.286] last_lockfile_recheck_time = 1727562212 [22:27:56.286] nevents = 1 [22:27:56.286] #16 0x000000000088da55 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214a7ab8) at ../src/backend/postmaster/postmaster.c:1351 [22:27:56.286] userDoption = [22:27:56.286] listen_addr_saved = [22:27:56.286] output_config_variable = [22:27:56.286] opt = [22:27:56.286] status = [22:27:56.286] #17 0x00000000007c835c in main (argc=8, argv=0x8214a7ab8) at ../src/backend/main/main.c:197 [22:27:56.286] do_check_root = [22:27:56.296] [22:27:56.296] [22:27:56.296] [22:27:56.360] dumping /tmp/cores/postgres.9234.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:56.488] [New LWP 100608] [22:27:56.555] Core was generated by `postgres: autovacuum worker regression'. [22:27:56.555] Program terminated with signal SIGABRT, Aborted. [22:27:56.555] Sent by thr_kill() from pid 9234 and user 1003. [22:27:56.555] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:56.713] [22:27:56.713] Thread 1 (LWP 100608): [22:27:56.713] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:56.713] No symbol table info available. [22:27:56.713] #1 0x000000082c949e64 in raise () from /lib/libc.so.7 [22:27:56.713] No symbol table info available. [22:27:56.713] #2 0x000000082c9fa6f9 in abort () from /lib/libc.so.7 [22:27:56.713] No symbol table info available. [22:27:56.713] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x3566b5 "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [22:27:56.713] No locals. [22:27:56.713] #4 0x0000000000696efa in index_drop (indexId=25052, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [22:27:56.713] heaprelid = {relId = 10972895, dbId = 0} [22:27:56.713] indexrelid = {relId = 558523360, dbId = 8} [22:27:56.713] heapId = 25047 [22:27:56.713] lockmode = [22:27:56.713] userHeapRelation = 0x838340ce8 [22:27:56.713] userIndexRelation = 0x838347460 [22:27:56.713] heaplocktag = [22:27:56.713] indexRelation = [22:27:56.713] tuple = [22:27:56.713] hasexprs = [22:27:56.713] #5 0x000000000068e5ce in doDeletion (object=object@entry=0x8383775b0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [22:27:56.713] concurrent = [22:27:56.713] concurrent_lock_mode = [22:27:56.713] relKind = 105 'i' [22:27:56.713] #6 0x000000000068ca90 in deleteOneObject (object=0x8383775b0, depRel=0x8214a66a0, flags=21) at ../src/backend/catalog/dependency.c:1274 [22:27:56.713] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 943153152, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 25047, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35302683920}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 943314552, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 144 '\220', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x8214a6680}, sk_argument = 6866065}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 558524304, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x8214a6790, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35542624840}} [22:27:56.713] nkeys = [22:27:56.713] scan = [22:27:56.713] tup = [22:27:56.713] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x83837ffc8, depRel=depRel@entry=0x8214a66a0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [22:27:56.713] thisobj = 0x8383775b0 [22:27:56.713] thisextra = [22:27:56.713] i = 0 [22:27:56.713] #8 0x000000000068b725 in performDeletion (object=object@entry=0x8214a6790, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [22:27:56.713] depRel = 0x83833cf88 [22:27:56.713] targetObjects = 0x83837ffc8 [22:27:56.713] #9 0x00000000008869d6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [22:27:56.713] object = {classId = 1259, objectId = 25047, objectSubId = 0} [22:27:56.713] relid = 25047 [22:27:56.713] classForm = [22:27:56.713] cell__state = {l = 0x838377fc0, i = } [22:27:56.713] 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} [22:27:56.713] cell = 0x83839d038 [22:27:56.713] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x975020 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 116} [22:27:56.713] table_oids = [22:27:56.713] orphan_oids = [22:27:56.713] did_vacuum = false [22:27:56.713] found_concurrent_worker = false [22:27:56.713] effective_multixact_freeze_max_age = 400000000 [22:27:56.713] tuple = [22:27:56.713] classRel = 0x8383392e8 [22:27:56.713] pg_class_desc = 0x838376100 [22:27:56.713] table_toast_map = 0x83837a100 [22:27:56.713] relScan = [22:27:56.713] bstrategy = [22:27:56.713] i = [22:27:56.713] dbForm = [22:27:56.713] #10 0x00000000008861c9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [22:27:56.713] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000@jJ!\b\000\000\000PiJ!\b\000\000\000\"\231\220\000\000\000\000\000GB\254\v\247ܟG(\005\274\000\000\000\000" [22:27:56.713] local_sigjmp_buf = {{_sjb = {8937139, 1, 34918263176, 34918263376, 12221876, 3, 34918263184, 0, 895, -2147815357, -1, 1}}} [22:27:56.713] dbid = 16384 [22:27:56.713] #11 0x000000000088b867 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 [22:27:56.713] pid = [22:27:56.713] #12 0x000000000088f8cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [22:27:56.713] pid = [22:27:56.713] __error = [22:27:56.713] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [22:27:56.713] bn = 0x8382015d8 [22:27:56.713] __error = [22:27:56.713] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [22:27:56.713] __error = [22:27:56.713] __error = [22:27:56.713] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [22:27:56.713] i = 0 [22:27:56.713] now = [22:27:56.713] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 941975000, events = 8, fd = 558527200, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x29f4a112e30a}, {pos = 747280288, events = 8, fd = 747351416, user_data = 0x8214a6f68}, {pos = 558526432, events = 8, fd = 558526312, user_data = 0x29f4a112e30a}, {pos = 747258760, events = 8, fd = 747351416, user_data = 0x8214a6f98}, {pos = 558526480, events = 8, fd = 558526360, user_data = 0x82c8b3194}, {pos = 560817160, events = 8, fd = 747319700, user_data = 0x8214a7000}, {pos = -1592617926, events = 10740, fd = 749142064, user_data = 0x1}, {pos = 558526512, events = 8, fd = -1592597750, user_data = 0x82c89c858}, {pos = 747351416, events = 8, fd = 558526472, user_data = 0x8214a7080}, {pos = 558526472, events = 8, fd = 747314444, user_data = 0x8216d6408}, {pos = 747314444, events = 8, fd = 558526576, user_data = 0x29f4a112943a}, {pos = 558526616, events = 8, fd = 558527064, user_data = 0x8214a7080}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1201659047, fd = 560840760, user_data = 0x800000001}, {pos = 560817160, events = 8, fd = 747258760, user_data = 0x8216db288}, {pos = 747227224, events = 8, fd = 560817160, user_data = 0x8214a7108}, {pos = 558527176, events = 8, fd = 558526704, user_data = 0x29f4a112dca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560840760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558527432, user_data = 0x216d6408}, {pos = 558527248, events = 8, fd = 558526848, user_data = 0x1}, {pos = 558527176, events = 8, fd = 32, user_data = 0x8214a7170}, {pos = -1592599949, events = 10740, fd = 558527120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216dc038}, {pos = 1, events = 8, fd = 560817160, user_data = 0x82c89c858}, {pos = 558527432, events = 8, fd = 558527248, user_data = 0x8214a7180}, {pos = 0, events = 0, fd = 560787464, user_data = 0x20}, {pos = 558527232, events = 8, fd = -1592624409, user_data = 0x8216cf008}, {pos = 560788488, events = 8, fd = 560789512, user_data = 0x8216cfc08}, {pos = 560803848, events = 8, fd = 560804872, user_data = 0x8216d3808}, {pos = 560806920, events = 8, fd = 560807944, user_data = 0x8216d4408}, {pos = 560809992, events = 8, fd = 560811016, user_data = 0x8216d5008}, {pos = 560813064, events = 8, fd = 560814088, user_data = 0x8216d5c08}, {pos = 560816136, events = 8, fd = 560817160, user_data = 0x8216d6808}, {pos = 560819208, events = 8, fd = 560820232, user_data = 0x8216d7408}, {pos = 560822280, events = 8, fd = 560823304, user_data = 0x8216d8008}, {pos = 560825352, events = 8, fd = 560826376, user_data = 0x8216d8c08}, {pos = 560832520, events = 8, fd = 560833544, user_data = 0x8216da808}, {pos = 560835592, events = 8, fd = 560787464, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558527432, events = 8, fd = 558526848, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560787464, events = 8, fd = 313, user_data = 0x8214a73b0}, {pos = -1592625681, events = 10740, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560817160, events = 8, fd = 941510656, user_data = 0x1}, {pos = 941511060, events = 8, fd = 0, user_data = 0x8214a7380}, {pos = 735294828, events = 8, fd = 1, user_data = 0x8381e5000}, {pos = 558527408, events = 8, fd = 735291138, user_data = 0x82c9ce170 }, {pos = 12305440, events = 0, fd = 748478832, user_data = 0x8216d6408}, {pos = 558527632, events = 8, fd = -1592626210, user_data = 0x838203800}, {pos = 1, events = 0, fd = -1592626594, user_data = 0x8216cf008}, {pos = 558527416, events = 8, fd = 558527632, user_data = 0x1c20}, {pos = 941584128, events = 8, fd = -1592546928, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8107639, user_data = 0x8214a7440}, {pos = 735253520, events = 8, fd = 749142064, user_data = 0x82ca72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214a7470}, {pos = 735296413, events = 8, fd = 941510656, user_data = 0x1740}, {pos = 558527696, events = 8, fd = 735262970, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x0}} [22:27:56.713] last_touch_time = 1727562212 [22:27:56.713] last_lockfile_recheck_time = 1727562212 [22:27:56.713] nevents = 1 [22:27:56.713] #16 0x000000000088da55 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214a7ab8) at ../src/backend/postmaster/postmaster.c:1351 [22:27:56.713] userDoption = [22:27:56.713] listen_addr_saved = [22:27:56.713] output_config_variable = [22:27:56.713] opt = [22:27:56.713] status = [22:27:56.713] #17 0x00000000007c835c in main (argc=8, argv=0x8214a7ab8) at ../src/backend/main/main.c:197 [22:27:56.713] do_check_root = [22:27:56.725] [22:27:56.725] [22:27:56.725] [22:27:56.790] dumping /tmp/cores/postgres.9753.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:56.915] [New LWP 100116] [22:27:56.982] Core was generated by `postgres: autovacuum worker regression'. [22:27:56.982] Program terminated with signal SIGABRT, Aborted. [22:27:56.982] Sent by thr_kill() from pid 9753 and user 1003. [22:27:56.982] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:57.138] [22:27:57.138] Thread 1 (LWP 100116): [22:27:57.138] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:57.138] No symbol table info available. [22:27:57.138] #1 0x000000082c949e64 in raise () from /lib/libc.so.7 [22:27:57.138] No symbol table info available. [22:27:57.138] #2 0x000000082c9fa6f9 in abort () from /lib/libc.so.7 [22:27:57.138] No symbol table info available. [22:27:57.138] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x3566b5 "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [22:27:57.138] No locals. [22:27:57.138] #4 0x0000000000696efa in index_drop (indexId=25052, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [22:27:57.138] heaprelid = {relId = 10972895, dbId = 0} [22:27:57.138] indexrelid = {relId = 558523360, dbId = 8} [22:27:57.138] heapId = 25047 [22:27:57.138] lockmode = [22:27:57.138] userHeapRelation = 0x84458df90 [22:27:57.138] userIndexRelation = 0x84458fae0 [22:27:57.138] heaplocktag = [22:27:57.138] indexRelation = [22:27:57.138] tuple = [22:27:57.138] hasexprs = [22:27:57.138] #5 0x000000000068e5ce in doDeletion (object=object@entry=0x83836f520, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [22:27:57.138] concurrent = [22:27:57.138] concurrent_lock_mode = [22:27:57.138] relKind = 105 'i' [22:27:57.138] #6 0x000000000068ca90 in deleteOneObject (object=0x83836f520, depRel=0x8214a66a0, flags=21) at ../src/backend/catalog/dependency.c:1274 [22:27:57.138] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 943120384, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 25047, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35506404304}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 943304768, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 144 '\220', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x8214a6680}, sk_argument = 6866065}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 558524304, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x8214a6790, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35303051464}} [22:27:57.138] nkeys = [22:27:57.138] scan = [22:27:57.138] tup = [22:27:57.138] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x83839c858, depRel=depRel@entry=0x8214a66a0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [22:27:57.138] thisobj = 0x83836f520 [22:27:57.138] thisextra = [22:27:57.138] i = 0 [22:27:57.138] #8 0x000000000068b725 in performDeletion (object=object@entry=0x8214a6790, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [22:27:57.138] depRel = 0x84458db40 [22:27:57.138] targetObjects = 0x83839c858 [22:27:57.138] #9 0x00000000008869d6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [22:27:57.138] object = {classId = 1259, objectId = 25047, objectSubId = 0} [22:27:57.138] relid = 25047 [22:27:57.138] classForm = [22:27:57.138] cell__state = {l = 0x838377f98, i = } [22:27:57.138] 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} [22:27:57.138] cell = 0x83839aa78 [22:27:57.138] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x975020 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x83836e000, fn_expr = 0x0}, sk_argument = 116} [22:27:57.138] table_oids = [22:27:57.138] orphan_oids = [22:27:57.138] did_vacuum = false [22:27:57.138] found_concurrent_worker = false [22:27:57.138] effective_multixact_freeze_max_age = 400000000 [22:27:57.138] tuple = [22:27:57.138] classRel = 0x838332e18 [22:27:57.138] pg_class_desc = 0x83836e100 [22:27:57.138] table_toast_map = 0x838372100 [22:27:57.138] relScan = [22:27:57.138] bstrategy = [22:27:57.138] i = [22:27:57.138] dbForm = [22:27:57.138] #10 0x00000000008861c9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [22:27:57.138] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000@jJ!\b\000\000\000PiJ!\b\000\000\000\"\231\220\000\000\000\000\000GB\254\v\247ܟG(\005\274\000\000\000\000" [22:27:57.138] local_sigjmp_buf = {{_sjb = {8937139, 1, 34918263176, 34918263376, 12221876, 3, 34918263184, 0, 895, -2147815357, -1, 1}}} [22:27:57.138] dbid = 16384 [22:27:57.138] #11 0x000000000088b867 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 [22:27:57.138] pid = [22:27:57.138] #12 0x000000000088f8cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [22:27:57.138] pid = [22:27:57.138] __error = [22:27:57.138] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [22:27:57.138] bn = 0x8382015d8 [22:27:57.138] __error = [22:27:57.138] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [22:27:57.138] __error = [22:27:57.138] __error = [22:27:57.138] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [22:27:57.138] i = 0 [22:27:57.138] now = [22:27:57.138] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 941975000, events = 8, fd = 558527200, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x29f4a112e30a}, {pos = 747280288, events = 8, fd = 747351416, user_data = 0x8214a6f68}, {pos = 558526432, events = 8, fd = 558526312, user_data = 0x29f4a112e30a}, {pos = 747258760, events = 8, fd = 747351416, user_data = 0x8214a6f98}, {pos = 558526480, events = 8, fd = 558526360, user_data = 0x82c8b3194}, {pos = 560817160, events = 8, fd = 747319700, user_data = 0x8214a7000}, {pos = -1592617926, events = 10740, fd = 749142064, user_data = 0x1}, {pos = 558526512, events = 8, fd = -1592597750, user_data = 0x82c89c858}, {pos = 747351416, events = 8, fd = 558526472, user_data = 0x8214a7080}, {pos = 558526472, events = 8, fd = 747314444, user_data = 0x8216d6408}, {pos = 747314444, events = 8, fd = 558526576, user_data = 0x29f4a112943a}, {pos = 558526616, events = 8, fd = 558527064, user_data = 0x8214a7080}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1201659047, fd = 560840760, user_data = 0x800000001}, {pos = 560817160, events = 8, fd = 747258760, user_data = 0x8216db288}, {pos = 747227224, events = 8, fd = 560817160, user_data = 0x8214a7108}, {pos = 558527176, events = 8, fd = 558526704, user_data = 0x29f4a112dca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560840760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558527432, user_data = 0x216d6408}, {pos = 558527248, events = 8, fd = 558526848, user_data = 0x1}, {pos = 558527176, events = 8, fd = 32, user_data = 0x8214a7170}, {pos = -1592599949, events = 10740, fd = 558527120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216dc038}, {pos = 1, events = 8, fd = 560817160, user_data = 0x82c89c858}, {pos = 558527432, events = 8, fd = 558527248, user_data = 0x8214a7180}, {pos = 0, events = 0, fd = 560787464, user_data = 0x20}, {pos = 558527232, events = 8, fd = -1592624409, user_data = 0x8216cf008}, {pos = 560788488, events = 8, fd = 560789512, user_data = 0x8216cfc08}, {pos = 560803848, events = 8, fd = 560804872, user_data = 0x8216d3808}, {pos = 560806920, events = 8, fd = 560807944, user_data = 0x8216d4408}, {pos = 560809992, events = 8, fd = 560811016, user_data = 0x8216d5008}, {pos = 560813064, events = 8, fd = 560814088, user_data = 0x8216d5c08}, {pos = 560816136, events = 8, fd = 560817160, user_data = 0x8216d6808}, {pos = 560819208, events = 8, fd = 560820232, user_data = 0x8216d7408}, {pos = 560822280, events = 8, fd = 560823304, user_data = 0x8216d8008}, {pos = 560825352, events = 8, fd = 560826376, user_data = 0x8216d8c08}, {pos = 560832520, events = 8, fd = 560833544, user_data = 0x8216da808}, {pos = 560835592, events = 8, fd = 560787464, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558527432, events = 8, fd = 558526848, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560787464, events = 8, fd = 313, user_data = 0x8214a73b0}, {pos = -1592625681, events = 10740, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560817160, events = 8, fd = 941510656, user_data = 0x1}, {pos = 941511060, events = 8, fd = 0, user_data = 0x8214a7380}, {pos = 735294828, events = 8, fd = 1, user_data = 0x8381e5000}, {pos = 558527408, events = 8, fd = 735291138, user_data = 0x82c9ce170 }, {pos = 12305440, events = 0, fd = 748478832, user_data = 0x8216d6408}, {pos = 558527632, events = 8, fd = -1592626210, user_data = 0x838203800}, {pos = 1, events = 0, fd = -1592626594, user_data = 0x8216cf008}, {pos = 558527416, events = 8, fd = 558527632, user_data = 0x1c20}, {pos = 941584128, events = 8, fd = -1592546928, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8107639, user_data = 0x8214a7440}, {pos = 735253520, events = 8, fd = 749142064, user_data = 0x82ca72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214a7470}, {pos = 735296413, events = 8, fd = 941510656, user_data = 0x1740}, {pos = 558527696, events = 8, fd = 735262970, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x0}} [22:27:57.138] last_touch_time = 1727562212 [22:27:57.138] last_lockfile_recheck_time = 1727562212 [22:27:57.138] nevents = 1 [22:27:57.138] #16 0x000000000088da55 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214a7ab8) at ../src/backend/postmaster/postmaster.c:1351 [22:27:57.138] userDoption = [22:27:57.138] listen_addr_saved = [22:27:57.138] output_config_variable = [22:27:57.138] opt = [22:27:57.138] status = [22:27:57.138] #17 0x00000000007c835c in main (argc=8, argv=0x8214a7ab8) at ../src/backend/main/main.c:197 [22:27:57.138] do_check_root = [22:27:57.149] [22:27:57.149] [22:27:57.149] [22:27:57.216] dumping /tmp/cores/postgres.10183.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:57.342] [New LWP 100106] [22:27:57.411] Core was generated by `postgres: autovacuum worker regression'. [22:27:57.411] Program terminated with signal SIGABRT, Aborted. [22:27:57.411] Sent by thr_kill() from pid 10183 and user 1003. [22:27:57.411] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:57.564] [22:27:57.564] Thread 1 (LWP 100106): [22:27:57.564] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:57.564] No symbol table info available. [22:27:57.564] #1 0x000000082c949e64 in raise () from /lib/libc.so.7 [22:27:57.564] No symbol table info available. [22:27:57.564] #2 0x000000082c9fa6f9 in abort () from /lib/libc.so.7 [22:27:57.564] No symbol table info available. [22:27:57.564] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x3566b5 "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [22:27:57.564] No locals. [22:27:57.564] #4 0x0000000000696efa in index_drop (indexId=21353, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [22:27:57.564] heaprelid = {relId = 10972895, dbId = 0} [22:27:57.564] indexrelid = {relId = 558523360, dbId = 8} [22:27:57.564] heapId = 21352 [22:27:57.564] lockmode = [22:27:57.564] userHeapRelation = 0x838340e28 [22:27:57.564] userIndexRelation = 0x838347e10 [22:27:57.564] heaplocktag = [22:27:57.564] indexRelation = [22:27:57.564] tuple = [22:27:57.564] hasexprs = [22:27:57.564] #5 0x000000000068e5ce in doDeletion (object=object@entry=0x8383775b0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [22:27:57.564] concurrent = [22:27:57.564] concurrent_lock_mode = [22:27:57.564] relKind = 105 'i' [22:27:57.564] #6 0x000000000068ca90 in deleteOneObject (object=0x8383775b0, depRel=0x8214a66a0, flags=21) at ../src/backend/catalog/dependency.c:1274 [22:27:57.564] key = {{sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 943153152, sk_collation = 8, sk_func = {fn_addr = 0x0, fn_oid = 20845, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000000000000, fn_mcxt = 0x800000008, fn_expr = 0xa3000000000}, sk_argument = 35302684240}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 943161280, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 2608, fn_nargs = -12374, fn_strict = 9, fn_retset = 11, fn_stats = 144 '\220', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x8214a6680}, sk_argument = 6866065}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 558524304, 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 = 0x8214a6790, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35303214536}} [22:27:57.564] nkeys = [22:27:57.564] scan = [22:27:57.564] tup = [22:27:57.564] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x8383a08d8, depRel=depRel@entry=0x8214a66a0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [22:27:57.564] thisobj = 0x8383775b0 [22:27:57.564] thisextra = [22:27:57.564] i = 0 [22:27:57.564] #8 0x000000000068b725 in performDeletion (object=object@entry=0x8214a6790, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [22:27:57.564] depRel = 0x83833d0c8 [22:27:57.564] targetObjects = 0x8383a08d8 [22:27:57.564] #9 0x00000000008869d6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [22:27:57.564] object = {classId = 1259, objectId = 20845, objectSubId = 0} [22:27:57.564] relid = 20845 [22:27:57.564] classForm = [22:27:57.564] cell__state = {l = 0x83837ff98, i = } [22:27:57.564] 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} [22:27:57.564] cell = 0x8383c23c8 [22:27:57.564] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x975020 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 116} [22:27:57.564] table_oids = [22:27:57.564] orphan_oids = [22:27:57.564] did_vacuum = false [22:27:57.564] found_concurrent_worker = false [22:27:57.564] effective_multixact_freeze_max_age = 400000000 [22:27:57.564] tuple = [22:27:57.564] classRel = 0x838339428 [22:27:57.564] pg_class_desc = 0x838376100 [22:27:57.564] table_toast_map = 0x83837a100 [22:27:57.564] relScan = [22:27:57.564] bstrategy = [22:27:57.564] i = [22:27:57.564] dbForm = [22:27:57.564] #10 0x00000000008861c9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [22:27:57.564] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000@jJ!\b\000\000\000PiJ!\b\000\000\000\"\231\220\000\000\000\000\000GB\254\v\247ܟG(\005\274\000\000\000\000" [22:27:57.564] local_sigjmp_buf = {{_sjb = {8937139, 1, 34918263176, 34918263376, 12221876, 3, 34918263184, 0, 895, -2147815357, -1, 1}}} [22:27:57.564] dbid = 16384 [22:27:57.564] #11 0x000000000088b867 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 [22:27:57.564] pid = [22:27:57.564] #12 0x000000000088f8cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [22:27:57.564] pid = [22:27:57.564] __error = [22:27:57.564] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [22:27:57.564] bn = 0x838201128 [22:27:57.564] __error = [22:27:57.564] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [22:27:57.564] __error = [22:27:57.564] __error = [22:27:57.564] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [22:27:57.564] i = 0 [22:27:57.564] now = [22:27:57.564] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 941975000, events = 8, fd = 558527200, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x29f4a112e30a}, {pos = 747280288, events = 8, fd = 747351416, user_data = 0x8214a6f68}, {pos = 558526432, events = 8, fd = 558526312, user_data = 0x29f4a112e30a}, {pos = 747258760, events = 8, fd = 747351416, user_data = 0x8214a6f98}, {pos = 558526480, events = 8, fd = 558526360, user_data = 0x82c8b3194}, {pos = 560817160, events = 8, fd = 747319700, user_data = 0x8214a7000}, {pos = -1592617926, events = 10740, fd = 749142064, user_data = 0x1}, {pos = 558526512, events = 8, fd = -1592597750, user_data = 0x82c89c858}, {pos = 747351416, events = 8, fd = 558526472, user_data = 0x8214a7080}, {pos = 558526472, events = 8, fd = 747314444, user_data = 0x8216d6408}, {pos = 747314444, events = 8, fd = 558526576, user_data = 0x29f4a112943a}, {pos = 558526616, events = 8, fd = 558527064, user_data = 0x8214a7080}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1201659047, fd = 560840760, user_data = 0x800000001}, {pos = 560817160, events = 8, fd = 747258760, user_data = 0x8216db288}, {pos = 747227224, events = 8, fd = 560817160, user_data = 0x8214a7108}, {pos = 558527176, events = 8, fd = 558526704, user_data = 0x29f4a112dca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560840760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558527432, user_data = 0x216d6408}, {pos = 558527248, events = 8, fd = 558526848, user_data = 0x1}, {pos = 558527176, events = 8, fd = 32, user_data = 0x8214a7170}, {pos = -1592599949, events = 10740, fd = 558527120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216dc038}, {pos = 1, events = 8, fd = 560817160, user_data = 0x82c89c858}, {pos = 558527432, events = 8, fd = 558527248, user_data = 0x8214a7180}, {pos = 0, events = 0, fd = 560787464, user_data = 0x20}, {pos = 558527232, events = 8, fd = -1592624409, user_data = 0x8216cf008}, {pos = 560788488, events = 8, fd = 560789512, user_data = 0x8216cfc08}, {pos = 560803848, events = 8, fd = 560804872, user_data = 0x8216d3808}, {pos = 560806920, events = 8, fd = 560807944, user_data = 0x8216d4408}, {pos = 560809992, events = 8, fd = 560811016, user_data = 0x8216d5008}, {pos = 560813064, events = 8, fd = 560814088, user_data = 0x8216d5c08}, {pos = 560816136, events = 8, fd = 560817160, user_data = 0x8216d6808}, {pos = 560819208, events = 8, fd = 560820232, user_data = 0x8216d7408}, {pos = 560822280, events = 8, fd = 560823304, user_data = 0x8216d8008}, {pos = 560825352, events = 8, fd = 560826376, user_data = 0x8216d8c08}, {pos = 560832520, events = 8, fd = 560833544, user_data = 0x8216da808}, {pos = 560835592, events = 8, fd = 560787464, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558527432, events = 8, fd = 558526848, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560787464, events = 8, fd = 313, user_data = 0x8214a73b0}, {pos = -1592625681, events = 10740, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560817160, events = 8, fd = 941510656, user_data = 0x1}, {pos = 941511060, events = 8, fd = 0, user_data = 0x8214a7380}, {pos = 735294828, events = 8, fd = 1, user_data = 0x8381e5000}, {pos = 558527408, events = 8, fd = 735291138, user_data = 0x82c9ce170 }, {pos = 12305440, events = 0, fd = 748478832, user_data = 0x8216d6408}, {pos = 558527632, events = 8, fd = -1592626210, user_data = 0x838203800}, {pos = 1, events = 0, fd = -1592626594, user_data = 0x8216cf008}, {pos = 558527416, events = 8, fd = 558527632, user_data = 0x1c20}, {pos = 941584128, events = 8, fd = -1592546928, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8107639, user_data = 0x8214a7440}, {pos = 735253520, events = 8, fd = 749142064, user_data = 0x82ca72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214a7470}, {pos = 735296413, events = 8, fd = 941510656, user_data = 0x1740}, {pos = 558527696, events = 8, fd = 735262970, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x0}} [22:27:57.565] last_touch_time = 1727562212 [22:27:57.565] last_lockfile_recheck_time = 1727562212 [22:27:57.565] nevents = 1 [22:27:57.565] #16 0x000000000088da55 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214a7ab8) at ../src/backend/postmaster/postmaster.c:1351 [22:27:57.565] userDoption = [22:27:57.565] listen_addr_saved = [22:27:57.565] output_config_variable = [22:27:57.565] opt = [22:27:57.565] status = [22:27:57.565] #17 0x00000000007c835c in main (argc=8, argv=0x8214a7ab8) at ../src/backend/main/main.c:197 [22:27:57.565] do_check_root = [22:27:57.575] [22:27:57.575] [22:27:57.575] [22:27:57.639] dumping /tmp/cores/postgres.10445.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:57.770] [New LWP 100169] [22:27:57.838] Core was generated by `postgres: autovacuum worker regression'. [22:27:57.838] Program terminated with signal SIGABRT, Aborted. [22:27:57.838] Sent by thr_kill() from pid 10445 and user 1003. [22:27:57.838] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:57.988] [22:27:57.988] Thread 1 (LWP 100169): [22:27:57.988] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:57.988] No symbol table info available. [22:27:57.988] #1 0x000000082c949e64 in raise () from /lib/libc.so.7 [22:27:57.988] No symbol table info available. [22:27:57.988] #2 0x000000082c9fa6f9 in abort () from /lib/libc.so.7 [22:27:57.988] No symbol table info available. [22:27:57.988] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x3566b5 "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [22:27:57.988] No locals. [22:27:57.988] #4 0x0000000000696efa in index_drop (indexId=59413, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [22:27:57.988] heaprelid = {relId = 10972895, dbId = 0} [22:27:57.988] indexrelid = {relId = 558523360, dbId = 8} [22:27:57.988] heapId = 59403 [22:27:57.988] lockmode = [22:27:57.988] userHeapRelation = 0x8383455d0 [22:27:57.988] userIndexRelation = 0x83834c920 [22:27:57.988] heaplocktag = [22:27:57.988] indexRelation = [22:27:57.988] tuple = [22:27:57.988] hasexprs = [22:27:57.988] #5 0x000000000068e5ce in doDeletion (object=object@entry=0x8383775ec, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [22:27:57.988] concurrent = [22:27:57.988] concurrent_lock_mode = [22:27:57.988] relKind = 105 'i' [22:27:57.988] #6 0x000000000068ca90 in deleteOneObject (object=0x8383775ec, depRel=0x8214a66a0, flags=21) at ../src/backend/catalog/dependency.c:1274 [22:27:57.988] key = {{sk_flags = 0, sk_attno = 1, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x9fa370 , fn_oid = 184, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 2606}, {sk_flags = 0, sk_attno = 2, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x9fa370 , fn_oid = 184, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 59419}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 558524304, 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 = 0x8214a6790, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35532482088}} [22:27:57.988] nkeys = [22:27:57.988] scan = [22:27:57.988] tup = [22:27:57.988] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x83839c6f8, depRel=depRel@entry=0x8214a66a0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [22:27:57.988] thisobj = 0x8383775ec [22:27:57.988] thisextra = [22:27:57.988] i = 5 [22:27:57.988] #8 0x000000000068b725 in performDeletion (object=object@entry=0x8214a6790, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [22:27:57.988] depRel = 0x83833d748 [22:27:57.988] targetObjects = 0x83839c6f8 [22:27:57.988] #9 0x00000000008869d6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [22:27:57.988] object = {classId = 1259, objectId = 59403, objectSubId = 0} [22:27:57.988] relid = 59403 [22:27:57.988] classForm = [22:27:57.988] cell__state = {l = 0x838377fc0, i = } [22:27:57.988] 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} [22:27:57.988] cell = 0x83839dc48 [22:27:57.988] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x975020 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 116} [22:27:57.988] table_oids = [22:27:57.988] orphan_oids = [22:27:57.988] did_vacuum = false [22:27:57.988] found_concurrent_worker = false [22:27:57.988] effective_multixact_freeze_max_age = 400000000 [22:27:57.988] tuple = [22:27:57.988] classRel = 0x838339aa8 [22:27:57.988] pg_class_desc = 0x838376100 [22:27:57.988] table_toast_map = 0x83837a100 [22:27:57.988] relScan = [22:27:57.988] bstrategy = [22:27:57.988] i = [22:27:57.988] dbForm = [22:27:57.988] #10 0x00000000008861c9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [22:27:57.988] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000@jJ!\b\000\000\000PiJ!\b\000\000\000\"\231\220\000\000\000\000\000GB\254\v\247ܟG(\005\274\000\000\000\000" [22:27:57.988] local_sigjmp_buf = {{_sjb = {8937139, 1, 34918263176, 34918263376, 12221876, 3, 34918263184, 0, 895, -2147815357, -1, 1}}} [22:27:57.988] dbid = 16384 [22:27:57.988] #11 0x000000000088b867 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 [22:27:57.988] pid = [22:27:57.988] #12 0x000000000088f8cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [22:27:57.988] pid = [22:27:57.988] __error = [22:27:57.988] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [22:27:57.988] bn = 0x8382012b8 [22:27:57.988] __error = [22:27:57.988] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [22:27:57.988] __error = [22:27:57.988] __error = [22:27:57.988] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [22:27:57.988] i = 0 [22:27:57.988] now = [22:27:57.988] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 941975000, events = 8, fd = 558527200, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x29f4a112e30a}, {pos = 747280288, events = 8, fd = 747351416, user_data = 0x8214a6f68}, {pos = 558526432, events = 8, fd = 558526312, user_data = 0x29f4a112e30a}, {pos = 747258760, events = 8, fd = 747351416, user_data = 0x8214a6f98}, {pos = 558526480, events = 8, fd = 558526360, user_data = 0x82c8b3194}, {pos = 560817160, events = 8, fd = 747319700, user_data = 0x8214a7000}, {pos = -1592617926, events = 10740, fd = 749142064, user_data = 0x1}, {pos = 558526512, events = 8, fd = -1592597750, user_data = 0x82c89c858}, {pos = 747351416, events = 8, fd = 558526472, user_data = 0x8214a7080}, {pos = 558526472, events = 8, fd = 747314444, user_data = 0x8216d6408}, {pos = 747314444, events = 8, fd = 558526576, user_data = 0x29f4a112943a}, {pos = 558526616, events = 8, fd = 558527064, user_data = 0x8214a7080}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1201659047, fd = 560840760, user_data = 0x800000001}, {pos = 560817160, events = 8, fd = 747258760, user_data = 0x8216db288}, {pos = 747227224, events = 8, fd = 560817160, user_data = 0x8214a7108}, {pos = 558527176, events = 8, fd = 558526704, user_data = 0x29f4a112dca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560840760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558527432, user_data = 0x216d6408}, {pos = 558527248, events = 8, fd = 558526848, user_data = 0x1}, {pos = 558527176, events = 8, fd = 32, user_data = 0x8214a7170}, {pos = -1592599949, events = 10740, fd = 558527120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216dc038}, {pos = 1, events = 8, fd = 560817160, user_data = 0x82c89c858}, {pos = 558527432, events = 8, fd = 558527248, user_data = 0x8214a7180}, {pos = 0, events = 0, fd = 560787464, user_data = 0x20}, {pos = 558527232, events = 8, fd = -1592624409, user_data = 0x8216cf008}, {pos = 560788488, events = 8, fd = 560789512, user_data = 0x8216cfc08}, {pos = 560803848, events = 8, fd = 560804872, user_data = 0x8216d3808}, {pos = 560806920, events = 8, fd = 560807944, user_data = 0x8216d4408}, {pos = 560809992, events = 8, fd = 560811016, user_data = 0x8216d5008}, {pos = 560813064, events = 8, fd = 560814088, user_data = 0x8216d5c08}, {pos = 560816136, events = 8, fd = 560817160, user_data = 0x8216d6808}, {pos = 560819208, events = 8, fd = 560820232, user_data = 0x8216d7408}, {pos = 560822280, events = 8, fd = 560823304, user_data = 0x8216d8008}, {pos = 560825352, events = 8, fd = 560826376, user_data = 0x8216d8c08}, {pos = 560832520, events = 8, fd = 560833544, user_data = 0x8216da808}, {pos = 560835592, events = 8, fd = 560787464, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558527432, events = 8, fd = 558526848, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560787464, events = 8, fd = 313, user_data = 0x8214a73b0}, {pos = -1592625681, events = 10740, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560817160, events = 8, fd = 941510656, user_data = 0x1}, {pos = 941511060, events = 8, fd = 0, user_data = 0x8214a7380}, {pos = 735294828, events = 8, fd = 1, user_data = 0x8381e5000}, {pos = 558527408, events = 8, fd = 735291138, user_data = 0x82c9ce170 }, {pos = 12305440, events = 0, fd = 748478832, user_data = 0x8216d6408}, {pos = 558527632, events = 8, fd = -1592626210, user_data = 0x838203800}, {pos = 1, events = 0, fd = -1592626594, user_data = 0x8216cf008}, {pos = 558527416, events = 8, fd = 558527632, user_data = 0x1c20}, {pos = 941584128, events = 8, fd = -1592546928, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8107639, user_data = 0x8214a7440}, {pos = 735253520, events = 8, fd = 749142064, user_data = 0x82ca72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214a7470}, {pos = 735296413, events = 8, fd = 941510656, user_data = 0x1740}, {pos = 558527696, events = 8, fd = 735262970, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x0}} [22:27:57.989] last_touch_time = 1727562212 [22:27:57.989] last_lockfile_recheck_time = 1727562212 [22:27:57.989] nevents = 1 [22:27:57.989] #16 0x000000000088da55 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214a7ab8) at ../src/backend/postmaster/postmaster.c:1351 [22:27:57.989] userDoption = [22:27:57.989] listen_addr_saved = [22:27:57.989] output_config_variable = [22:27:57.989] opt = [22:27:57.989] status = [22:27:57.989] #17 0x00000000007c835c in main (argc=8, argv=0x8214a7ab8) at ../src/backend/main/main.c:197 [22:27:57.989] do_check_root = [22:27:57.999] [22:27:57.999] [22:27:57.999] [22:27:58.064] dumping /tmp/cores/postgres.10653.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:58.190] [New LWP 101636] [22:27:58.260] Core was generated by `postgres: autovacuum worker regression'. [22:27:58.260] Program terminated with signal SIGABRT, Aborted. [22:27:58.260] Sent by thr_kill() from pid 10653 and user 1003. [22:27:58.260] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:58.413] [22:27:58.413] Thread 1 (LWP 101636): [22:27:58.413] #0 0x000000082c9d041a in thr_kill () from /lib/libc.so.7 [22:27:58.413] No symbol table info available. [22:27:58.413] #1 0x000000082c949e64 in raise () from /lib/libc.so.7 [22:27:58.413] No symbol table info available. [22:27:58.413] #2 0x000000082c9fa6f9 in abort () from /lib/libc.so.7 [22:27:58.413] No symbol table info available. [22:27:58.413] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x3566b5 "HaveRegisteredOrActiveSnapshot()", fileName=, lineNumber=lineNumber@entry=2345) at ../src/backend/utils/error/assert.c:66 [22:27:58.413] No locals. [22:27:58.413] #4 0x0000000000696efa in index_drop (indexId=59413, concurrent=false, concurrent_lock_mode=) at ../src/backend/catalog/index.c:2345 [22:27:58.413] heaprelid = {relId = 10972895, dbId = 0} [22:27:58.413] indexrelid = {relId = 558523360, dbId = 8} [22:27:58.413] heapId = 59403 [22:27:58.413] lockmode = [22:27:58.413] userHeapRelation = 0x838345ae0 [22:27:58.413] userIndexRelation = 0x83834ce30 [22:27:58.413] heaplocktag = [22:27:58.413] indexRelation = [22:27:58.413] tuple = [22:27:58.413] hasexprs = [22:27:58.413] #5 0x000000000068e5ce in doDeletion (object=object@entry=0x8383775ec, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:1367 [22:27:58.413] concurrent = [22:27:58.413] concurrent_lock_mode = [22:27:58.413] relKind = 105 'i' [22:27:58.413] #6 0x000000000068ca90 in deleteOneObject (object=0x8383775ec, depRel=0x8214a66a0, flags=21) at ../src/backend/catalog/dependency.c:1274 [22:27:58.413] key = {{sk_flags = 0, sk_attno = 1, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x9fa370 , fn_oid = 184, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 2606}, {sk_flags = 0, sk_attno = 2, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x9fa370 , fn_oid = 184, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 59419}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 558524304, 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 = 0x8214a6790, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 35538700856}} [22:27:58.413] nkeys = [22:27:58.413] scan = [22:27:58.413] tup = [22:27:58.413] #7 deleteObjectsInList (targetObjects=targetObjects@entry=0x846457ce8, depRel=depRel@entry=0x8214a66a0, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:229 [22:27:58.413] thisobj = 0x8383775ec [22:27:58.413] thisextra = [22:27:58.413] i = 5 [22:27:58.413] #8 0x000000000068b725 in performDeletion (object=object@entry=0x8214a6790, behavior=behavior@entry=DROP_CASCADE, flags=flags@entry=21) at ../src/backend/catalog/dependency.c:314 [22:27:58.413] depRel = 0x83833db48 [22:27:58.413] targetObjects = 0x846457ce8 [22:27:58.413] #9 0x00000000008869d6 in do_autovacuum () at ../src/backend/postmaster/autovacuum.c:2214 [22:27:58.413] object = {classId = 1259, objectId = 59403, objectSubId = 0} [22:27:58.413] relid = 59403 [22:27:58.413] classForm = [22:27:58.413] cell__state = {l = 0x83837ff98, i = } [22:27:58.413] 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} [22:27:58.413] cell = 0x83839f3e8 [22:27:58.413] key = {sk_flags = 0, sk_attno = 17, sk_strategy = 3, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x975020 , fn_oid = 61, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x838376000, fn_expr = 0x0}, sk_argument = 116} [22:27:58.413] table_oids = [22:27:58.413] orphan_oids = [22:27:58.413] did_vacuum = false [22:27:58.413] found_concurrent_worker = false [22:27:58.413] effective_multixact_freeze_max_age = 400000000 [22:27:58.413] tuple = [22:27:58.413] classRel = 0x838339ea8 [22:27:58.413] pg_class_desc = 0x838376100 [22:27:58.413] table_toast_map = 0x83837a100 [22:27:58.413] relScan = [22:27:58.413] bstrategy = [22:27:58.413] i = [22:27:58.413] dbForm = [22:27:58.413] #10 0x00000000008861c9 in AutoVacWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/autovacuum.c:1570 [22:27:58.413] dbname = "regression\000\000\000\000\000\000\030\000\000\0000\000\000\000@jJ!\b\000\000\000PiJ!\b\000\000\000\"\231\220\000\000\000\000\000GB\254\v\247ܟG(\005\274\000\000\000\000" [22:27:58.413] local_sigjmp_buf = {{_sjb = {8937139, 1, 34918263176, 34918263376, 12221876, 3, 34918263184, 0, 895, -2147815357, -1, 1}}} [22:27:58.413] dbid = 16384 [22:27:58.413] #11 0x000000000088b867 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 [22:27:58.413] pid = [22:27:58.413] #12 0x000000000088f8cf in StartChildProcess (type=B_AUTOVAC_WORKER) at ../src/backend/postmaster/postmaster.c:3736 [22:27:58.413] pid = [22:27:58.413] __error = [22:27:58.413] #13 StartAutovacuumWorker () at ../src/backend/postmaster/postmaster.c:3790 [22:27:58.413] bn = 0x838201088 [22:27:58.413] __error = [22:27:58.413] #14 process_pm_pmsignal () at ../src/backend/postmaster/postmaster.c:3628 [22:27:58.413] __error = [22:27:58.413] __error = [22:27:58.413] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1646 [22:27:58.413] i = 0 [22:27:58.413] now = [22:27:58.413] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 941975000, events = 8, fd = 558527200, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x29f4a112e30a}, {pos = 747280288, events = 8, fd = 747351416, user_data = 0x8214a6f68}, {pos = 558526432, events = 8, fd = 558526312, user_data = 0x29f4a112e30a}, {pos = 747258760, events = 8, fd = 747351416, user_data = 0x8214a6f98}, {pos = 558526480, events = 8, fd = 558526360, user_data = 0x82c8b3194}, {pos = 560817160, events = 8, fd = 747319700, user_data = 0x8214a7000}, {pos = -1592617926, events = 10740, fd = 749142064, user_data = 0x1}, {pos = 558526512, events = 8, fd = -1592597750, user_data = 0x82c89c858}, {pos = 747351416, events = 8, fd = 558526472, user_data = 0x8214a7080}, {pos = 558526472, events = 8, fd = 747314444, user_data = 0x8216d6408}, {pos = 747314444, events = 8, fd = 558526576, user_data = 0x29f4a112943a}, {pos = 558526616, events = 8, fd = 558527064, user_data = 0x8214a7080}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1201659047, fd = 560840760, user_data = 0x800000001}, {pos = 560817160, events = 8, fd = 747258760, user_data = 0x8216db288}, {pos = 747227224, events = 8, fd = 560817160, user_data = 0x8214a7108}, {pos = 558527176, events = 8, fd = 558526704, user_data = 0x29f4a112dca2}, {pos = 2701795, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560840760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558527432, user_data = 0x216d6408}, {pos = 558527248, events = 8, fd = 558526848, user_data = 0x1}, {pos = 558527176, events = 8, fd = 32, user_data = 0x8214a7170}, {pos = -1592599949, events = 10740, fd = 558527120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216dc038}, {pos = 1, events = 8, fd = 560817160, user_data = 0x82c89c858}, {pos = 558527432, events = 8, fd = 558527248, user_data = 0x8214a7180}, {pos = 0, events = 0, fd = 560787464, user_data = 0x20}, {pos = 558527232, events = 8, fd = -1592624409, user_data = 0x8216cf008}, {pos = 560788488, events = 8, fd = 560789512, user_data = 0x8216cfc08}, {pos = 560803848, events = 8, fd = 560804872, user_data = 0x8216d3808}, {pos = 560806920, events = 8, fd = 560807944, user_data = 0x8216d4408}, {pos = 560809992, events = 8, fd = 560811016, user_data = 0x8216d5008}, {pos = 560813064, events = 8, fd = 560814088, user_data = 0x8216d5c08}, {pos = 560816136, events = 8, fd = 560817160, user_data = 0x8216d6808}, {pos = 560819208, events = 8, fd = 560820232, user_data = 0x8216d7408}, {pos = 560822280, events = 8, fd = 560823304, user_data = 0x8216d8008}, {pos = 560825352, events = 8, fd = 560826376, user_data = 0x8216d8c08}, {pos = 560832520, events = 8, fd = 560833544, user_data = 0x8216da808}, {pos = 560835592, events = 8, fd = 560787464, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558527432, events = 8, fd = 558526848, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560787464, events = 8, fd = 313, user_data = 0x8214a73b0}, {pos = -1592625681, events = 10740, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560840760, user_data = 0x1}, {pos = 560817160, events = 8, fd = 941510656, user_data = 0x1}, {pos = 941511060, events = 8, fd = 0, user_data = 0x8214a7380}, {pos = 735294828, events = 8, fd = 1, user_data = 0x8381e5000}, {pos = 558527408, events = 8, fd = 735291138, user_data = 0x82c9ce170 }, {pos = 12305440, events = 0, fd = 748478832, user_data = 0x8216d6408}, {pos = 558527632, events = 8, fd = -1592626210, user_data = 0x838203800}, {pos = 1, events = 0, fd = -1592626594, user_data = 0x8216cf008}, {pos = 558527416, events = 8, fd = 558527632, user_data = 0x1c20}, {pos = 941584128, events = 8, fd = -1592546928, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8107639, user_data = 0x8214a7440}, {pos = 735253520, events = 8, fd = 749142064, user_data = 0x82ca72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214a7470}, {pos = 735296413, events = 8, fd = 941510656, user_data = 0x1740}, {pos = 558527696, events = 8, fd = 735262970, user_data = 0x0}, {pos = 0, events = 0, fd = 195838535, user_data = 0x0}} [22:27:58.414] last_touch_time = 1727562212 [22:27:58.414] last_lockfile_recheck_time = 1727562212 [22:27:58.414] nevents = 1 [22:27:58.414] #16 0x000000000088da55 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214a7ab8) at ../src/backend/postmaster/postmaster.c:1351 [22:27:58.414] userDoption = [22:27:58.414] listen_addr_saved = [22:27:58.414] output_config_variable = [22:27:58.414] opt = [22:27:58.414] status = [22:27:58.414] #17 0x00000000007c835c in main (argc=8, argv=0x8214a7ab8) at ../src/backend/main/main.c:197 [22:27:58.414] do_check_root = [22:27:58.424] [22:27:58.424] [22:27:58.424] [22:27:58.490] dumping /tmp/cores/postgres.13915.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:27:58.614] [New LWP 101662] [22:27:58.687] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [22:27:58.687] Program terminated with signal SIGABRT, Aborted. [22:27:58.687] Sent by thr_kill() from pid 13915 and user 1003. [22:27:58.687] #0 0x000000082c6b341a in thr_kill () from /lib/libc.so.7 [22:27:59.281] [22:27:59.281] Thread 1 (LWP 101662): [22:27:59.281] #0 0x000000082c6b341a in thr_kill () from /lib/libc.so.7 [22:27:59.281] No symbol table info available. [22:27:59.281] #1 0x000000082c62ce64 in raise () from /lib/libc.so.7 [22:27:59.281] No symbol table info available. [22:27:59.281] #2 0x000000082c6dd6f9 in abort () from /lib/libc.so.7 [22:27:59.281] No symbol table info available. [22:27:59.281] #3 0x0000000000a91285 in ExceptionalCondition (conditionName=0x2d1ba0 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [22:27:59.281] No locals. [22:27:59.281] #4 0x0000000000772ebf in ExecFetchSlotHeapTuple (slot=0x8212df028, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [22:27:59.281] No locals. [22:27:59.281] #5 0x0000000000737847 in ExecIRDeleteTriggers (estate=estate@entry=0x83713d100, relinfo=relinfo@entry=0x83713d6b0, slot=slot@entry=0x8212df028) at ../src/backend/commands/trigger.c:2842 [22:27:59.281] trigger = [22:27:59.281] oldtuple = [22:27:59.281] should_free = false [22:27:59.281] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83c2c2010, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [22:27:59.281] trigdesc = 0x83713d8c0 [22:27:59.281] newtuple = 0x0 [22:27:59.281] i = 0 [22:27:59.281] #6 0x0000000000798184 in ExecMergeMatched (context=0x8212df0b8, resultRelInfo=0x83713d6b0, tupleid=0x0, oldtuple=0x8212df028, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [22:27:59.281] result = TM_Ok [22:27:59.281] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [22:27:59.281] relaction = 0x83c307620 [22:27:59.281] commandType = CMD_DELETE [22:27:59.281] l__state = {l = 0x83c47f178, i = 0} [22:27:59.281] lockedtid = [22:27:59.281] mtstate = 0x83713d4a0 [22:27:59.281] newslot = 0x0 [22:27:59.281] rslot = 0x0 [22:27:59.281] estate = 0x83713d100 [22:27:59.281] mergeActions = [22:27:59.281] econtext = 0x83c47e218 [22:27:59.281] epqstate = 0x83713d588 [22:27:59.281] actionStates = 0x83c47f178 [22:27:59.281] l = [22:27:59.281] isNull = [22:27:59.281] lmerge_matched = [22:27:59.281] __error = [22:27:59.281] l__state = [22:27:59.281] result = [22:27:59.281] updateCxt = [22:27:59.281] relaction = [22:27:59.281] commandType = [22:27:59.281] __error = [22:27:59.281] resultRelationDesc = [22:27:59.281] lockmode = [22:27:59.281] inputslot = [22:27:59.281] epqslot = [22:27:59.281] was_matched = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] #7 ExecMerge (context=0x8212df0b8, resultRelInfo=0x83713d6b0, tupleid=0x0, oldtuple=0x8212df028, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [22:27:59.281] matched = true [22:27:59.281] rslot = 0x0 [22:27:59.281] #8 ExecModifyTable (pstate=0x83713d4a0) at ../src/backend/executor/nodeModifyTable.c:4197 [22:27:59.281] context = {mtstate = 0x83713d4a0, epqstate = 0x83713d588, estate = 0x83713d100, planSlot = 0x83c47c618, tmfd = {ctid = {ip_blkid = {bi_hi = 64910, bi_lo = 11370}, ip_posid = 8}, xmax = 129, cmax = 0, traversed = 158}, cpUpdateReturningSlot = 0xecca0bcd34a7be76} [22:27:59.281] tuple_ctid = {ip_blkid = {bi_hi = 11772, bi_lo = 0}, ip_posid = 0} [22:27:59.281] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8371d1118} [22:27:59.281] node = 0x83713d4a0 [22:27:59.281] estate = 0x83713d100 [22:27:59.281] operation = CMD_MERGE [22:27:59.281] resultRelInfo = 0x83713d6b0 [22:27:59.281] subplanstate = 0x83713edb0 [22:27:59.281] slot = [22:27:59.281] tupleid = 0x0 [22:27:59.281] oldtuple = 0x8212df028 [22:27:59.281] tuplock = [22:27:59.281] oldSlot = [22:27:59.281] #9 0x000000000076501b in ExecProcNode (node=0x83713d4a0) at ../src/include/executor/executor.h:278 [22:27:59.281] No locals. [22:27:59.281] #10 ExecutePlan (estate=0x83713d100, planstate=0x83713d4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x83700db10, execute_once=) at ../src/backend/executor/execMain.c:1659 [22:27:59.281] current_tuple_count = 0 [22:27:59.281] slot = [22:27:59.281] #11 standard_ExecutorRun (queryDesc=0x8371d3448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:364 [22:27:59.281] estate = 0x83713d100 [22:27:59.281] oldcontext = 0x83700d800 [22:27:59.281] operation = CMD_MERGE [22:27:59.281] dest = 0x83700db10 [22:27:59.281] sendTuples = true [22:27:59.281] #12 0x0000000838efa961 in pgss_ExecutorRun (queryDesc=0x8371d3448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1024 [22:27:59.281] _local_sigjmp_buf = {{_sjb = {35314968881, 1, 34916397544, 34916397712, 12375768, 34916397552, 1, 35284399176, 34916336511, 7830657, 35283783680, 34359738368}}} [22:27:59.281] _save_exception_stack = 0x8212df3a0 [22:27:59.281] _save_context_stack = 0x0 [22:27:59.281] _do_rethrow = false [22:27:59.281] #13 0x000000000093bb9f in ProcessQuery (plan=0x83c434740, sourceText=, params=0x0, queryEnv=0x0, dest=0x83700db10, qc=0x8212df368) at ../src/backend/tcop/pquery.c:160 [22:27:59.281] queryDesc = 0x8371d3448 [22:27:59.281] #14 0x000000000093b13d in PortalRunMulti (portal=portal@entry=0x8370a5100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x83700db10, altdest=0xb83330 , qc=qc@entry=0x8212df368) at ../src/backend/tcop/pquery.c:1287 [22:27:59.281] pstmt = 0x83c434740 [22:27:59.281] stmtlist_item__state = {l = 0x83c438ff8, i = 0} [22:27:59.281] active_snapshot_set = true [22:27:59.281] stmtlist_item = 0x83c439010 [22:27:59.281] #15 0x000000000093ac4c in FillPortalStore (portal=portal@entry=0x8370a5100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [22:27:59.281] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:59.281] treceiver = 0x83700db10 [22:27:59.281] #16 0x000000000093a9bb in PortalRun (portal=portal@entry=0x8370a5100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83c439048, altdest=altdest@entry=0x83c439048, qc=0x8212df4a0) at ../src/backend/tcop/pquery.c:763 [22:27:59.281] _local_sigjmp_buf = {{_sjb = {9677149, 35283161344, 34916397976, 34916398208, 34916397984, 35283255296, 12342440, 12375768, 35283141503, 35282481408, 4294967984, 0}}} [22:27:59.281] _save_exception_stack = 0x8212df570 [22:27:59.281] _save_context_stack = 0x0 [22:27:59.281] _do_rethrow = false [22:27:59.281] saveTopTransactionResourceOwner = 0x8370f34d8 [22:27:59.281] saveTopTransactionContext = 0x8370bc000 [22:27:59.281] saveActivePortal = 0x0 [22:27:59.281] saveResourceOwner = 0x8370f34d8 [22:27:59.281] savePortalContext = 0x0 [22:27:59.281] saveMemoryContext = 0x8370bc000 [22:27:59.281] result = [22:27:59.281] nprocessed = [22:27:59.281] #17 0x0000000000939882 in exec_simple_query (query_string=query_string@entry=0x836fff100 "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 [22:27:59.281] cmdtaglen = 5 [22:27:59.281] snapshot_set = [22:27:59.281] per_parsetree_context = 0x0 [22:27:59.281] plantree_list = [22:27:59.281] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:59.281] format = 0 [22:27:59.281] parsetree = 0x83c3f1aa8 [22:27:59.281] commandTag = [22:27:59.281] cmdtagname = [22:27:59.281] querytree_list = [22:27:59.281] portal = 0x8370a5100 [22:27:59.281] receiver = 0x83c439048 [22:27:59.281] parsetree_item__state = {l = 0x83c3f3370, i = 0} [22:27:59.281] msec_str = "\000\000\000\000\b", '\000' , "\020\202\370f\000\000\000\000\347\373\344^\263\t\v*" [22:27:59.281] dest = DestRemote [22:27:59.281] was_logged = [22:27:59.281] oldcontext = 0x8370bc000 [22:27:59.281] parsetree_list = 0x83c3f3370 [22:27:59.281] use_implicit_block = false [22:27:59.281] parsetree_item = 0x83c3f3388 [22:27:59.281] save_log_statement_stats = [22:27:59.281] #18 0x00000000009374f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [22:27:59.281] query_string = 0x836fff100 "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"... [22:27:59.281] input_message = {data = 0x836fff100 "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} [22:27:59.281] firstchar = [22:27:59.281] local_sigjmp_buf = {{_sjb = {9660838, 34916398448, 34916398408, 34916398992, 12384504, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [22:27:59.281] send_ready_for_query = false [22:27:59.281] idle_in_transaction_timeout_enabled = false [22:27:59.281] idle_session_timeout_enabled = false [22:27:59.281] #19 0x0000000000931cd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:27:59.281] bsdata = [22:27:59.281] #20 0x000000000088b867 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8212e02b4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212e01f0) at ../src/backend/postmaster/launch_backend.c:274 [22:27:59.281] pid = [22:27:59.281] #21 0x000000000088fc38 in BackendStartup (client_sock=0x8212e01f0) at ../src/backend/postmaster/postmaster.c:3420 [22:27:59.281] startup_data = {canAcceptConnections = CAC_OK} [22:27:59.281] bn = 0x83700b3a8 [22:27:59.281] pid = [22:27:59.281] __error = [22:27:59.281] save_errno = [22:27:59.281] __error = [22:27:59.281] __error = [22:27:59.281] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [22:27:59.281] 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 = " \374\3776\b", '\000' , "P\002.!\b\000\000\000h\205U*\b\000\000\000\v\000\000\000\000\000\000\000^\017V*\b", '\000' , "\220\002.!\b\000\000\000\024\266\210\000\000\000\000\000\240\002.!\b", '\000' }, salen = 16}} [22:27:59.281] i = 0 [22:27:59.281] now = [22:27:59.281] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 744848514, events = 8, fd = 0, user_data = 0x8212e01a0}, {pos = 923170264, events = 8, fd = 556662832, user_data = 0x0}, {pos = 1172337418, events = 9131, fd = 744015776, user_data = 0x82c59dd78}, {pos = 556661928, events = 8, fd = 556662048, user_data = 0x8212dfca8}, {pos = 1172337418, events = 9131, fd = 743994248, user_data = 0x82c59dd78}, {pos = 556661976, events = 8, fd = 556662096, user_data = 0x8212dfcd8}, {pos = 744055188, events = 8, fd = 564122632, user_data = 0x82c596194}, {pos = 556662080, events = 8, fd = 1172317242, user_data = 0x8212dfce0}, {pos = 710239248, events = 8, fd = 745877552, user_data = 0x23ab45e0730a}, {pos = 743962712, events = 8, fd = 744086904, user_data = 0x8212dfd48}, {pos = 556662208, events = 8, fd = 556662088, user_data = 0x82c594d0c}, {pos = 564122632, events = 8, fd = 744049932, user_data = 0x8212dfdb0}, {pos = 1172317242, events = 9131, fd = 556662232, user_data = 0x8212dffa8}, {pos = 556662208, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821a03038}, {pos = 1, events = 3972664269, fd = 564122632, user_data = 0x82c587388}, {pos = 564144072, events = 8, fd = 0, user_data = 0x0}, {pos = 556662344, events = 8, fd = 556662808, user_data = 0x8212dfe30}, {pos = 1172335778, events = 9131, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 3972664269, fd = 564146232, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8212e0118}, {pos = 564122632, events = 3, fd = 556662880, user_data = 0x821a02828}, {pos = 656, events = 0, fd = 556662808, user_data = 0x8212dfe48}, {pos = 556662448, events = 8, fd = 1172335387, user_data = 0x8212dffe0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 564146232, events = 8, fd = 1, user_data = 0x8219fd408}, {pos = 743962712, events = 8, fd = 556663064, user_data = 0x8212e0060}, {pos = 556662464, events = 8, fd = 0, user_data = 0x8219f6008}, {pos = 33, events = 0, fd = 556662864, user_data = 0x23ab45e00ae7}, {pos = 564092936, events = 8, fd = 564093960, user_data = 0x8219f6808}, {pos = 564096008, events = 8, fd = 564109320, user_data = 0x8219fa408}, {pos = 564111368, events = 8, fd = 564112392, user_data = 0x8219fb008}, {pos = 564114440, events = 8, fd = 564115464, user_data = 0x8219fbc08}, {pos = 564117512, events = 8, fd = 564118536, user_data = 0x8219fc808}, {pos = 564120584, events = 8, fd = 564121608, user_data = 0x8219fd408}, {pos = 564123656, events = 8, fd = 564124680, user_data = 0x8219fe008}, {pos = 564126728, events = 8, fd = 564127752, user_data = 0x8219fec08}, {pos = 564129800, events = 8, fd = 564130824, user_data = 0x8219ff808}, {pos = 564132872, events = 8, fd = 564137992, user_data = 0x821a01408}, {pos = 564140040, events = 8, fd = 564141064, user_data = 0x821a04408}, {pos = 793004000, events = 0, fd = 564092936, user_data = 0x2939e3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821a03038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556663064, events = 8, fd = 556662464, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 564146232, user_data = 0x1}, {pos = 564092936, events = 8, fd = 313, user_data = 0x8212e0100}, {pos = 1172309487, events = 9131, fd = 2701795, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564146232, user_data = 0x1}, {pos = 564122632, events = 8, fd = 922677248, user_data = 0x1}, {pos = 922677652, events = 8, fd = 0, user_data = 0x8212e00d0}, {pos = 710280556, events = 8, fd = 1, user_data = 0x836fef000}, {pos = 556663040, events = 8, fd = 710276866, user_data = 0x82c6b1170 }, {pos = 12305440, events = 0, fd = 745214320, user_data = 0x8219fd408}, {pos = 556663264, events = 8, fd = 1172308958, user_data = 0x83700d800}, {pos = 1, events = 0, fd = 1172308574, user_data = 0x8219f6008}, {pos = 556663048, events = 8, fd = 556663264, user_data = 0x1c20}, {pos = 922745888, events = 8, fd = 1172388240, user_data = 0x0}, {pos = 556663679, events = 8, fd = 8107639, user_data = 0x8212e0190}, {pos = 710239248, events = 8, fd = 745877552, user_data = 0x82c755310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8212e01c0}, {pos = 710282141, events = 8, fd = 922677248, user_data = 0x2ef3}, {pos = 556663328, events = 8, fd = 710248698, user_data = 0x0}, {pos = 0, events = 0, fd = 883408502, user_data = 0x0}} [22:27:59.281] last_touch_time = 1727562243 [22:27:59.281] last_lockfile_recheck_time = 1727562243 [22:27:59.281] nevents = 1 [22:27:59.281] #23 0x000000000088da55 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212e0800) at ../src/backend/postmaster/postmaster.c:1351 [22:27:59.281] userDoption = [22:27:59.281] listen_addr_saved = [22:27:59.281] output_config_variable = [22:27:59.281] opt = [22:27:59.281] status = [22:27:59.281] #24 0x00000000007c835c in main (argc=4, argv=0x8212e0800) at ../src/backend/main/main.c:197 [22:27:59.281] do_check_root =