Re: BUG #19078: Segfaults in tts_minimal_store_tuple() following pg_upgrade

Поиск
Список
Период
Сортировка
От Yuri Zamyatin
Тема Re: BUG #19078: Segfaults in tts_minimal_store_tuple() following pg_upgrade
Дата
Msg-id 3b5kvjfavnciubmv7zefmzknlraehlfxufs724nqof7f7x5doh@4qiaendsrrmk
обсуждение исходный текст
Ответ на Re: BUG #19078: Segfaults in tts_minimal_store_tuple() following pg_upgrade  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: BUG #19078: Segfaults in tts_minimal_store_tuple() following pg_upgrade
Список 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
thetables 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::textlike '%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=<optimizedout>,
 
>     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@entry=0x55601c213448, n_total_subplans=<optimized out>,
part_prune_index=<optimizedout>, relids=<optimized out>,
 
>     initially_valid_subplans=initially_valid_subplans@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@entry=0x55601b8531f8, estate=estate@entry=0x55601c1fb0d8,
eflags=eflags@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@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@entry=0x55601b725a68, estate=estate@entry=0x55601c1fb0d8,
eflags=<optimizedout>, eflags@entry=0)
 
>     at ./build/../src/backend/executor/nodeNestloop.c:301
>         nlstate = 0x55601c1fbd80
>         __func__ = "ExecInitNestLoop"
> #6  0x0000555fe85598f1 in ExecInitNode (node=node@entry=0x55601b725a68, estate=estate@entry=0x55601c1fb0d8,
eflags=eflags@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@entry=0x55601b745d68) at ./build/../src/backend/executor/execMain.c:2930
>         parentestate = <optimized out>
>         recheckestate = <optimized out>
> #9  0x0000555fe85549ab in EvalPlanQual (epqstate=0x55601b745d68, relation=relation@entry=0x7f14d1722d68, rti=1,
inputslot=inputslot@entry=0x55601be51480)
>     at ./build/../src/backend/executor/execMain.c:2650
>         slot = <optimized out>
>         testslot = <optimized out>
> #10 0x0000555fe858001d in ExecUpdate (context=context@entry=0x7ffe304157d0,
resultRelInfo=resultRelInfo@entry=0x55601b745e88,tupleid=tupleid@entry=0x7ffe304157aa,
 
>     oldtuple=oldtuple@entry=0x0, oldSlot=<optimized out>, oldSlot@entry=0x55601be50c70,
slot=slot@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=<optimizedout>, 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@entry=0x55601b73b2d0, into=into@entry=0x0,
es=es@entry=0x55601b0218e0,
>     queryString=queryString@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.idand\n\t(\n\t\t(state_id=7 an"..., params=params@entry=0x0,
queryEnv=queryEnv@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.idand\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.idand\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@entry=0x55601afc2718, pstmt=0x55601b6b4370,
isTopLevel=isTopLevel@entry=true,
>     setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55601b01f6a0, qc=qc@entry=0x7ffe30415db0) at
./build/../src/backend/tcop/pquery.c:1153
> No locals.
> #22 0x0000555fe872d5ef in FillPortalStore (portal=portal@entry=0x55601afc2718, isTopLevel=isTopLevel@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@entry=0x55601afc2718, count=count@entry=9223372036854775807,
isTopLevel=isTopLevel@entry=true,
>     dest=dest@entry=0x55601b0ad0b0, altdest=altdest@entry=0x55601b0ad0b0, qc=qc@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.idand\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.idand\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.idand\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@entry=0x7ffe304164c0,
>     startup_data_len=startup_data_len@entry=24, client_sock=client_sock@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@\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@entry=5, argv=argv@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>




В списке pgsql-bugs по дате отправления: