From: | Yuri Zamyatin <yuri(at)yrz(dot)am> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #19078: Segfaults in tts_minimal_store_tuple() following pg_upgrade |
Date: | 2025-10-10 01:34:47 |
Message-ID: | 3b5kvjfavnciubmv7zefmzknlraehlfxufs724nqof7f7x5doh@4qiaendsrrmk |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi. I was able to reproduce the crash with the simpler (non hash-agg) plan from the previous message.
Basically I launched it in multiple infinite loops that do BEGIN - UPDATE - ROLLBACK. Other clients could also modify the tables during this time.
We've seen this query crash on multiple physical hosts.
Original query:
> update Tcv_scenes cs
> set
> state_id=2,
> stitching_server_id=null,
> stitching_server_pid=null
> from
> tcv_scene_datas cd -- Partition key: RANGE (cv_scene_id)
> where
> cd.cv_scene_id=cs.id and
> (
> (cs.state_id=7 and cs.date_cr<now()-interval '24 hours' and cs.date_state_mo>now()-interval '15 minutes' and cd.stitcher_result::text like '%download%') or
> (cs.state_id=3 and cs.date_state_mo<now()-interval '5 minutes')
> )
> returning cs.id
GDB Stack Trace:
> #0 0x0000555fe8678300 in PartitionDirectoryLookup (pdir=0x0, rel=0x7f14d172b288) at ./build/../src/backend/partitioning/partdesc.c:462
> pde = <optimized out>
> relid = 21856
> found = 27
> #1 0x0000555fe8558b51 in InitExecPartitionPruneContexts (prunestate=<optimized out>, parent_plan=0x55601c213448, initially_valid_subplans=<optimized out>,
> n_total_subplans=<optimized out>) at ./build/../src/backend/executor/execPartition.c:2413
> partkey = 0x55601b0244c0
> partdesc = <optimized out>
> pprune = <optimized out>
> nparts = 239
> k = <optimized out>
> prunedata = 0x55601b7ea748
> j = <optimized out>
> estate = <optimized out>
> new_subplan_indexes = <optimized out>
> new_other_subplans = <optimized out>
> i = 0
> newidx = <optimized out>
> fix_subplan_map = <optimized out>
> estate = <optimized out>
> new_subplan_indexes = <optimized out>
> new_other_subplans = <error reading variable new_other_subplans (Cannot access memory at address 0x0)>
> i = <optimized out>
> newidx = <optimized out>
> fix_subplan_map = <optimized out>
> prunedata = <error reading variable prunedata (Cannot access memory at address 0x0)>
> j = <optimized out>
> pprune = <optimized out>
> nparts = <optimized out>
> k = <optimized out>
> partkey = <optimized out>
> partdesc = <optimized out>
> oldidx = <optimized out>
> subidx = <optimized out>
> subprune = <optimized out>
> #2 ExecInitPartitionExecPruning (planstate=planstate(at)entry=0x55601c213448, n_total_subplans=<optimized out>, part_prune_index=<optimized out>, relids=<optimized out>,
> initially_valid_subplans=initially_valid_subplans(at)entry=0x7ffe30415500) at ./build/../src/backend/executor/execPartition.c:1934
> prunestate = <optimized out>
> estate = <optimized out>
> pruneinfo = <optimized out>
> __func__ = "ExecInitPartitionExecPruning"
> #3 0x0000555fe856b030 in ExecInitAppend (node=node(at)entry=0x55601b8531f8, estate=estate(at)entry=0x55601c1fb0d8, eflags=eflags(at)entry=0)
> at ./build/../src/backend/executor/nodeAppend.c:147
> prunestate = <optimized out>
> appendstate = 0x55601c213448
> appendplanstates = <optimized out>
> appendops = <optimized out>
> validsubplans = 0x55601c213650
> asyncplans = <optimized out>
> nplans = <optimized out>
> nasyncplans = <optimized out>
> firstvalid = <optimized out>
> i = <optimized out>
> j = <optimized out>
> #4 0x0000555fe8559ad5 in ExecInitNode (node=0x55601b8531f8, estate=estate(at)entry=0x55601c1fb0d8, eflags=0) at ./build/../src/backend/executor/execProcnode.c:182
> result = <optimized out>
> subps = <optimized out>
> l = <optimized out>
> __func__ = "ExecInitNode"
> #5 0x0000555fe8584383 in ExecInitNestLoop (node=node(at)entry=0x55601b725a68, estate=estate(at)entry=0x55601c1fb0d8, eflags=<optimized out>, eflags(at)entry=0)
> at ./build/../src/backend/executor/nodeNestloop.c:301
> nlstate = 0x55601c1fbd80
> __func__ = "ExecInitNestLoop"
> #6 0x0000555fe85598f1 in ExecInitNode (node=node(at)entry=0x55601b725a68, estate=estate(at)entry=0x55601c1fb0d8, eflags=eflags(at)entry=0)
> at ./build/../src/backend/executor/execProcnode.c:298
> result = <optimized out>
> subps = <optimized out>
> l = <optimized out>
> __func__ = "ExecInitNode"
> #7 0x0000555fe855480f in EvalPlanQualStart (epqstate=0x55601b745d68, planTree=0x55601b725a68) at ./build/../src/backend/executor/execMain.c:3152
> parentestate = <optimized out>
> oldcontext = 0x55601b7e99b0
> rtsize = <optimized out>
> rcestate = 0x55601c1fb0d8
> l = <optimized out>
> parentestate = <optimized out>
> rtsize = <optimized out>
> rcestate = <optimized out>
> oldcontext = <optimized out>
> l = <optimized out>
> i = <optimized out>
> l__state = <optimized out>
> subplan = <optimized out>
> subplanstate = <optimized out>
> l__state = <optimized out>
> earm = <optimized out>
> l__state = <optimized out>
> rtindex = <optimized out>
> #8 EvalPlanQualBegin (epqstate=epqstate(at)entry=0x55601b745d68) at ./build/../src/backend/executor/execMain.c:2930
> parentestate = <optimized out>
> recheckestate = <optimized out>
> #9 0x0000555fe85549ab in EvalPlanQual (epqstate=0x55601b745d68, relation=relation(at)entry=0x7f14d1722d68, rti=1, inputslot=inputslot(at)entry=0x55601be51480)
> at ./build/../src/backend/executor/execMain.c:2650
> slot = <optimized out>
> testslot = <optimized out>
> #10 0x0000555fe858001d in ExecUpdate (context=context(at)entry=0x7ffe304157d0, resultRelInfo=resultRelInfo(at)entry=0x55601b745e88, tupleid=tupleid(at)entry=0x7ffe304157aa,
> oldtuple=oldtuple(at)entry=0x0, oldSlot=<optimized out>, oldSlot(at)entry=0x55601be50c70, slot=slot(at)entry=0x55601be51078, canSetTag=true)
> at ./build/../src/backend/executor/nodeModifyTable.c:2606
> inputslot = 0x55601be51480
> epqslot = <optimized out>
> lockedtid = {ip_blkid = {bi_hi = 30, bi_lo = 53843}, ip_posid = 40}
> estate = 0x55601b7e9aa8
> resultRelationDesc = <optimized out>
> updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleNoKeyExclusive}
> result = <optimized out>
> __func__ = "ExecUpdate"
> #11 0x0000555fe8581fff in ExecModifyTable (pstate=0x55601b745c80) at ./build/../src/backend/executor/nodeModifyTable.c:4510
> node = 0x55601b745c80
> context = {mtstate = 0x55601b745c80, epqstate = 0x55601b745d68, estate = 0x55601b7e9aa8, planSlot = 0x55601be4bef0, tmfd = {ctid = {ip_blkid = {bi_hi = 30,
> bi_lo = 53844}, ip_posid = 13}, xmax = 2949858589, cmax = 4294967295, traversed = true}, cpDeletedSlot = 0x0, cpUpdateReturningSlot = 0x0}
> estate = 0x55601b7e9aa8
> operation = CMD_UPDATE
> resultRelInfo = 0x55601b745e88
> subplanstate = <optimized out>
> slot = 0x55601be51078
> oldSlot = 0x55601be50c70
> tuple_ctid = {ip_blkid = {bi_hi = 30, bi_lo = 53844}, ip_posid = 13}
> oldtupdata = {t_len = 2675325712, t_self = {ip_blkid = {bi_hi = 32475, bi_lo = 0}, ip_posid = 32265}, t_tableOid = 0, t_data = 0xf0}
> oldtuple = 0x0
> tupleid = <optimized out>
> tuplock = false
> __func__ = "ExecModifyTable"
> #12 0x0000555fe855954d in ExecProcNodeInstr (node=0x55601b745c80) at ./build/../src/backend/executor/execProcnode.c:485
> result = <optimized out>
> #13 0x0000555fe855191b in ExecProcNode (node=0x55601b745c80) at ./build/../src/include/executor/executor.h:315
> No locals.
> #14 ExecutePlan (queryDesc=0x55601b737af0, operation=CMD_UPDATE, sendTuples=true, numberTuples=0, direction=<optimized out>, dest=0x555fe8bd2ec0 <donothingDR>)
> at ./build/../src/backend/executor/execMain.c:1697
> estate = 0x55601b7e9aa8
> use_parallel_mode = <optimized out>
> slot = <optimized out>
> planstate = 0x55601b745c80
> current_tuple_count = 0
> estate = <optimized out>
> planstate = <optimized out>
> use_parallel_mode = <optimized out>
> slot = <optimized out>
> current_tuple_count = <optimized out>
> #15 standard_ExecutorRun (queryDesc=0x55601b737af0, direction=<optimized out>, count=0) at ./build/../src/backend/executor/execMain.c:366
> estate = 0x55601b7e9aa8
> operation = CMD_UPDATE
> dest = 0x555fe8bd2ec0 <donothingDR>
> sendTuples = <optimized out>
> oldcontext = 0x55601b01f490
> #16 0x0000555fe84e2e1c in ExplainOnePlan (plannedstmt=plannedstmt(at)entry=0x55601b73b2d0, into=into(at)entry=0x0, es=es(at)entry=0x55601b0218e0,
> queryString=queryString(at)entry=0x55601aed5198 "explain(buffers,verbose,analyze)update Tcv_scenes cs\nset\n\tstate_id=2,\n\tstitching_server_id=null,\n\tstitching_server_pid=null\nfrom\n\ttcv_scene_datas cd\nwhere\n\tcd.cv_scene_id=cs.id and\n\t(\n\t\t(state_id=7 an"..., params=params(at)entry=0x0, queryEnv=queryEnv(at)entry=0x0,
> planduration=0x7ffe30415aa8, bufusage=0x7ffe30415b50, mem_counters=0x0) at ./build/../src/backend/commands/explain.c:579
> dir = <optimized out>
> dest = 0x555fe8bd2ec0 <donothingDR>
> queryDesc = 0x55601b737af0
> starttime = <optimized out>
> totaltime = 0
> eflags = <optimized out>
> instrument_option = <optimized out>
> serializeMetrics = {bytesSent = 0, timeSpent = {ticks = 0}, bufferUsage = {shared_blks_hit = <optimized out>, shared_blks_read = <optimized out>,
> shared_blks_dirtied = <optimized out>, shared_blks_written = <optimized out>, local_blks_hit = <optimized out>, local_blks_read = <optimized out>,
> local_blks_dirtied = <optimized out>, local_blks_written = <optimized out>, temp_blks_read = <optimized out>, temp_blks_written = <optimized out>,
> shared_blk_read_time = {ticks = <optimized out>}, shared_blk_write_time = {ticks = <optimized out>}, local_blk_read_time = {ticks = <optimized out>},
> local_blk_write_time = {ticks = <optimized out>}, temp_blk_read_time = {ticks = <optimized out>}, temp_blk_write_time = {ticks = <optimized out>}}}
> #17 0x0000555fe84e34c4 in standard_ExplainOneQuery (query=<optimized out>, cursorOptions=<optimized out>, into=0x0, es=0x55601b0218e0,
> queryString=0x55601aed5198 "explain(buffers,verbose,analyze)update Tcv_scenes cs\nset\n\tstate_id=2,\n\tstitching_server_id=null,\n\tstitching_server_pid=null\nfrom\n\ttcv_scene_datas cd\nwhere\n\tcd.cv_scene_id=cs.id and\n\t(\n\t\t(state_id=7 an"..., params=0x0, queryEnv=0x0) at ./build/../src/backend/commands/explain.c:372
> plan = 0x55601b73b2d0
> planstart = <optimized out>
> planduration = {ticks = 4659506}
> bufusage_start = {shared_blks_hit = 18745, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 0, local_blks_read = 0,
> local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {
> ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}}
> bufusage = {shared_blks_hit = 16, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 0, local_blks_read = 0,
> local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {
> ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}}
> mem_counters = {nblocks = 93871265236088, freechunks = 93871265236088, totalspace = 139727390028424, freespace = 230455663}
> planner_ctx = 0x0
> saved_ctx = 0x0
> #18 0x0000555fe84e3641 in ExplainOneQuery (query=<optimized out>, cursorOptions=<optimized out>, into=<optimized out>, es=<optimized out>, pstate=<optimized out>,
> params=<optimized out>) at ./build/../src/backend/commands/explain.c:309
> No locals.
> #19 0x0000555fe84e3733 in ExplainQuery (pstate=0x55601b01f728, stmt=0x55601b6b42d8, params=0x0, dest=0x55601b01f6a0) at ./build/../src/backend/commands/explain.c:223
> l__state = {l = <optimized out>, i = 0}
> l = 0x55601b197008
> es = 0x55601b0218e0
> tstate = <optimized out>
> jstate = <optimized out>
> query = <optimized out>
> rewritten = 0x55601b196ff0
> #20 0x0000555fe872f083 in standard_ProcessUtility (pstmt=0x55601b6b4370,
> queryString=0x55601aed5198 "explain(buffers,verbose,analyze)update Tcv_scenes cs\nset\n\tstate_id=2,\n\tstitching_server_id=null,\n\tstitching_server_pid=null\nfrom\n\ttcv_scene_datas cd\nwhere\n\tcd.cv_scene_id=cs.id and\n\t(\n\t\t(state_id=7 an"..., readOnlyTree=<optimized out>, context=PROCESS_UTILITY_TOPLEVEL, params=0x0,
> queryEnv=0x0, dest=0x55601b01f6a0, qc=0x7ffe30415db0) at ./build/../src/backend/tcop/utility.c:866
> parsetree = 0x55601b6b42d8
> isTopLevel = <optimized out>
> isAtomicContext = true
> pstate = 0x55601b01f728
> readonly_flags = <optimized out>
> __func__ = "standard_ProcessUtility"
> #21 0x0000555fe872d231 in PortalRunUtility (portal=portal(at)entry=0x55601afc2718, pstmt=0x55601b6b4370, isTopLevel=isTopLevel(at)entry=true,
> setHoldSnapshot=setHoldSnapshot(at)entry=true, dest=dest(at)entry=0x55601b01f6a0, qc=qc(at)entry=0x7ffe30415db0) at ./build/../src/backend/tcop/pquery.c:1153
> No locals.
> #22 0x0000555fe872d5ef in FillPortalStore (portal=portal(at)entry=0x55601afc2718, isTopLevel=isTopLevel(at)entry=true) at ./build/../src/backend/tcop/pquery.c:1026
> treceiver = 0x55601b01f6a0
> qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0}
> __func__ = "FillPortalStore"
> #23 0x0000555fe872d96f in PortalRun (portal=portal(at)entry=0x55601afc2718, count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=true,
> dest=dest(at)entry=0x55601b0ad0b0, altdest=altdest(at)entry=0x55601b0ad0b0, qc=qc(at)entry=0x7ffe30415fc0) at ./build/../src/backend/tcop/pquery.c:760
> _save_exception_stack = 0x7ffe304162a0
> _save_context_stack = 0x0
> _local_sigjmp_buf = {{__jmpbuf = {93871257954072, -100083352534358458, 93871265235712, 140729708011456, 93871258914992, 93871265235752, -100083352490318266,
> -6061881521657190842}, __mask_was_saved = 0, __saved_mask = {__val = {0, 140728898420737, 93869327402605, 93871257965608, 93870412007286,
> 140729708011280, 93871257954072, 93870412007286, 1, 93871258914920, 93871265235752, 140729708011344, 93870411676182, 140729708011344, 2,
> 140729708011344}}}}
> _do_rethrow = <optimized out>
> result = <optimized out>
> nprocessed = <optimized out>
> saveTopTransactionResourceOwner = 0x55601af27370
> saveTopTransactionContext = 0x55601afd83e0
> saveActivePortal = 0x0
> saveResourceOwner = 0x55601af27370
> savePortalContext = 0x0
> saveMemoryContext = 0x55601afd83e0
> __func__ = "PortalRun"
> #24 0x0000555fe8729668 in exec_simple_query (
> query_string=0x55601aed5198 "explain(buffers,verbose,analyze)update Tcv_scenes cs\nset\n\tstate_id=2,\n\tstitching_server_id=null,\n\tstitching_server_pid=null\nfrom\n\ttcv_scene_datas cd\nwhere\n\tcd.cv_scene_id=cs.id and\n\t(\n\t\t(state_id=7 an"...) at ./build/../src/backend/tcop/postgres.c:1273
> cmdtaglen = 7
> snapshot_set = <optimized out>
> per_parsetree_context = 0x0
> plantree_list = <optimized out>
> parsetree = 0x55601b6b4300
> commandTag = <optimized out>
> qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0}
> querytree_list = <optimized out>
> portal = 0x55601afc2718
> receiver = 0x55601b0ad0b0
> format = 0
> cmdtagname = <optimized out>
> parsetree_item__state = {l = 0x55601b6b4328, i = 0}
> dest = DestRemote
> oldcontext = 0x55601afd83e0
> parsetree_list = 0x55601b6b4328
> parsetree_item = 0x55601b6b4340
> save_log_statement_stats = false
> was_logged = false
> use_implicit_block = false
> msec_str = "\340\031\301\350_U\000\000Q\000\000\000\000\000\000\000\000bA0\376\177\000\000\004\000\000\000\000\000\000"
> __func__ = "exec_simple_query"
> #25 0x0000555fe872b56d in PostgresMain (dbname=<optimized out>, username=<optimized out>) at ./build/../src/backend/tcop/postgres.c:4766
> query_string = 0x55601aed5198 "explain(buffers,verbose,analyze)update Tcv_scenes cs\nset\n\tstate_id=2,\n\tstitching_server_id=null,\n\tstitching_server_pid=null\nfrom\n\ttcv_scene_datas cd\nwhere\n\tcd.cv_scene_id=cs.id and\n\t(\n\t\t(state_id=7 an"...
> firstchar = <optimized out>
> input_message = {
> data = 0x55601aed5198 "explain(buffers,verbose,analyze)update Tcv_scenes cs\nset\n\tstate_id=2,\n\tstitching_server_id=null,\n\tstitching_server_pid=null\nfrom\n\ttcv_scene_datas cd\nwhere\n\tcd.cv_scene_id=cs.id and\n\t(\n\t\t(state_id=7 an"..., len = 431, maxlen = 1024, cursor = 431}
> local_sigjmp_buf = {{__jmpbuf = {140729708012000, -100083351217347002, 2753760000, 4, 0, 1, -100083351357856186, -6061881523619469754}, __mask_was_saved = 1,
> __saved_mask = {__val = {4194304, 135168, 5232754935419077376, 16, 260416, 18446744073709551312, 260400, 0, 16274, 139727397133088, 139727395799228,
> 93870411867664, 139727390638096, 0, 18446744073709551312, 93871256618032}}}}
> send_ready_for_query = false
> idle_in_transaction_timeout_enabled = false
> idle_session_timeout_enabled = false
> __func__ = "PostgresMain"
> #26 0x0000555fe8725a33 in BackendMain (startup_data=<optimized out>, startup_data_len=<optimized out>) at ./build/../src/backend/tcop/backend_startup.c:124
> bsdata = <optimized out>
> #27 0x0000555fe8683cfd in postmaster_child_launch (child_type=B_BACKEND, child_slot=316, startup_data=startup_data(at)entry=0x7ffe304164c0,
> startup_data_len=startup_data_len(at)entry=24, client_sock=client_sock(at)entry=0x7ffe304164e0) at ./build/../src/backend/postmaster/launch_backend.c:290
> pid = <optimized out>
> #28 0x0000555fe8687802 in BackendStartup (client_sock=0x7ffe304164e0) at ./build/../src/backend/postmaster/postmaster.c:3587
> bn = 0x7f14d1b05b50
> pid = <optimized out>
> startup_data = {canAcceptConnections = CAC_OK, socket_created = 813354333582584, fork_started = 813354333582603}
> cac = <optimized out>
> bn = <optimized out>
> pid = <optimized out>
> startup_data = <optimized out>
> cac = <optimized out>
> __func__ = "BackendStartup"
> __errno_location = <optimized out>
> save_errno = <optimized out>
> __errno_location = <optimized out>
> __errno_location = <optimized out>
> #29 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1702
> s = {sock = 10, raddr = {addr = {ss_family = 2,
> __ss_padding = "\305\370\274|$\247\000\000\000\000\000\000\000\000K\323\352\032`U\000\000\000\000\000\000\000\000\000\000PeA0\376\177\000\000 eA0\376\177\000\000\000\004\000\000\000\000\000\000(at)\323\352\032`U\000\000\213y\210\350_U", '\000' <repeats 18 times>, "peA0\376\177\000\000x\344\217\350_U\000\000\000\000\000\000\000\000\000\000\255\226\311\321\024\177\000", __ss_align = 1}, salen = 16}}
> i = 0
> now = <optimized out>
> last_lockfile_recheck_time = 1760039078
> last_touch_time = 1760036170
> events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 8, user_data = 0x0}, {
> pos = 658, events = 21855, fd = 451405112, user_data = 0x400000000aa}, {pos = 0, events = 21856, fd = 451597131, user_data = 0x0}, {pos = -1303149824,
> events = 1218345699, fd = 451413120, user_data = 0x555fe8c28f60 <errordata>}, {pos = 809592352, events = 32766, fd = -393725350, user_data = 0xf}, {
> pos = 0, events = 0, fd = 809592432, user_data = 0x0}, {pos = 809592432, events = 32766, fd = 451930800, user_data = 0x555fe88eca37}, {pos = -389995904,
> events = 21855, fd = 0, user_data = 0x555fe88ce239 <pg_freeaddrinfo_all+73>}, {pos = 8, events = 0, fd = 809592672, user_data = 0x7ffe30416fa0}, {
> pos = -396723022, events = 21855, fd = 451936489, user_data = 0x15381af000f2}, {pos = 451767480, events = 21856, fd = 809592672,
> user_data = 0x7ffe304166bc}, {pos = 1, events = 1, fd = 451936565, user_data = 0x1e8afb0b4}, {pos = 451930800, events = 21856, fd = -393223028,
> user_data = 0x100000001}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f0032333435}, {pos = -393347968,
> events = 21855, fd = 451936712, user_data = 0x55601af001d2}, {pos = 451936739, events = 21856, fd = 15729133, user_data = 0x556000000000}, {pos = 0,
> events = 0, fd = 0, user_data = 0x556000000000}, {pos = 0, events = 21760, fd = -771537064, user_data = 0x6e75722f7261762f}, {pos = 1936683055,
> events = 1701996404, fd = 795636083, user_data = 0x3334352e4c515347}, {pos = -393281486, events = 21855, fd = -393262758, user_data = 0x7ffe30416dd0}, {
> pos = -393347879, events = 21855, fd = 0, user_data = 0x0}, {pos = 809594368, events = 32766, fd = -393348049, user_data = 0x7ffe30416e10}, {pos = 9305135,
> events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -771537064, user_data = 0x0}, {pos = -775242182, events = 32532, fd = 0,
> user_data = 0xff0}, {pos = 0, events = 538976256, fd = -771537064, user_data = 0x5420706100000000}, {pos = -773907776, events = 32532, fd = 255,
> user_data = 0xfffffffffffffed0}, {pos = 0, events = 0, fd = 399, user_data = 0x55601ae7b2b0}, {pos = -775242182, events = 32532, fd = 665957,
> user_data = 0xdf20}, {pos = 0, events = 0, fd = 10, user_data = 0x0}, {pos = -773907776, events = 32532, fd = 255, user_data = 0xfffffffffffffed0}, {
> pos = -773914672, events = 32532, fd = 8, user_data = 0x7f14d1deffd0 <_IO_file_jumps>}, {pos = -775238318, events = 32532, fd = 2996,
> user_data = 0x55601ae7b2b0}, {pos = 4096, events = 0, fd = 809593520, user_data = 0x7f14d1deffd0 <_IO_file_jumps>}, {pos = -775389748, events = 32532,
> fd = 26, user_data = 0x1397}, {pos = 1, events = 0, fd = 33152, user_data = 0x70}, {pos = 0, events = 0, fd = 1, user_data = 0x100000000}, {pos = 2,
> events = 17, fd = 0, user_data = 0x3}, {pos = 0, events = 1, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0,
> events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55601ae7b2b0}, {pos = 8,
> events = 0, fd = -773907776, user_data = 0x802}, {pos = -304, events = 4294967295, fd = 5, user_data = 0x555fe88e5dd6}, {pos = -393256156, events = 21855,
> fd = -775238318, user_data = 0x7ffe30416a50}, {pos = -393342935, events = 21855, fd = 32768, user_data = 0x9}, {pos = 809593680, events = 32766,
> fd = -775001723, user_data = 0x7f0000000000}, {pos = 9, events = 0, fd = 809593648, user_data = 0x7f14d1ca90cd}, {pos = 2429, events = 0, fd = 32832,
> user_data = 0x55601af00ad0}, {pos = 32832, events = 0, fd = 451971856, user_data = 0x7f14d1caa4f8}, {pos = 9, events = 0, fd = 451939024,
> user_data = 0xfffffffffffffe98}, {pos = 0, events = 0, fd = 2050, user_data = 0x7f14d1cad3c0 <free+384>}, {pos = 544854009, events = 0, fd = 1759619142,
> user_data = 0x2079cff9}, {pos = 0, events = 0, fd = 0, user_data = 0x9}, {pos = 809593648, events = 32766, fd = 809593680, user_data = 0x55601af00ae0}, {
> pos = -393323050, events = 21855, fd = -393256156, user_data = 0x7f14d1ce678d <closedir+13>}, {pos = 451459056, events = 21856, fd = -395355527,
> user_data = 0x55601af00ae0}, {pos = -393322945, events = 21855, fd = 809594800, user_data = 0x555fe86f90c8 <RemovePgTempFiles+312>}, {pos = 451541152,
> events = 21856, fd = 0, user_data = 0x7367702f65736162}, {pos = 1952410737, events = 1207988333, fd = 771766842, user_data = 0x7f14d1cabe3a}}
> nevents = <optimized out>
> __func__ = "ServerLoop"
> #30 0x0000555fe8689110 in PostmasterMain (argc=argc(at)entry=5, argv=argv(at)entry=0x55601ae7c310) at ./build/../src/backend/postmaster/postmaster.c:1400
> opt = <optimized out>
> status = <optimized out>
> userDoption = <optimized out>
> listen_addr_saved = true
> output_config_variable = <optimized out>
> __func__ = "PostmasterMain"
> #31 0x0000555fe837f880 in main (argc=5, argv=0x55601ae7c310) at ./build/../src/backend/main/main.c:227
> do_check_root = <optimized out>
> dispatch_option = <optimized out>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2025-10-10 01:44:04 | Re: Potential deadlock in pgaio_io_wait() |
Previous Message | Zane Duffield | 2025-10-09 23:43:04 | Date/Time parsing of ISO 8601 timestamps with commas |