Hi,
While performing some benchmarks on REL_11_STABLE (at 444455c2d9), I've
repeatedly hit an apparent infinite loop on TPC-H query 4. I don't know
what exactly are the triggering conditions, but the symptoms are these:
1) A parallel worker" process is consuming 100% CPU, with per for
reporting profile like this:
34.66% postgres [.] get_segment_by_index
29.44% postgres [.] get_best_segment
29.22% postgres [.] unlink_segment.isra.2
6.66% postgres [.] fls
0.02% [unknown] [k] 0xffffffffb10014b0
So all the time seems to be spent within get_best_segment.
2) The backtrace looks like this (full backtrace attached):
#0 0x0000561a748c4f89 in get_segment_by_index
#1 0x0000561a748c5653 in get_best_segment
#2 0x0000561a748c67a9 in dsa_allocate_extended
#3 0x0000561a7466ddb4 in ExecParallelHashTupleAlloc
#4 0x0000561a7466e00a in ExecParallelHashTableInsertCurrentBatch
#5 0x0000561a7466fe00 in ExecParallelHashJoinNewBatch
#6 ExecHashJoinImpl
#7 ExecParallelHashJoin
#8 ExecProcNode
...
3) The infinite loop seems to be pretty obvious - after setting
breakpoint on get_segment_by_index we get this:
Breakpoint 1, get_segment_by_index (area=0x560c03626e58, index=3) ...
(gdb) c
Continuing.
Breakpoint 1, get_segment_by_index (area=0x560c03626e58, index=3) ...
(gdb) c
Continuing.
Breakpoint 1, get_segment_by_index (area=0x560c03626e58, index=3) ...
(gdb) c
Continuing.
That is, we call the function with the same index over and over.
Why is that? Well:
(gdb) print *area->segment_maps[3].header
$1 = {magic = 216163851, usable_pages = 512, size = 2105344, prev = 3,
next = 3, bin = 0, freed = false}
So, we loop forever.
I don't know what exactly are the triggering conditions here. I've only
ever observed the issue on TPC-H with scale 16GB, partitioned lineitem
table and work_mem set to 8MB and query #4. And it seems I can reproduce
it pretty reliably.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=2786961.30..2786977.38 rows=1 width=24)
-> Finalize GroupAggregate (cost=2786961.30..2787041.72 rows=5 width=24)
Group Key: orders.o_orderpriority
-> Gather Merge (cost=2786961.30..2787041.52 rows=30 width=24)
Workers Planned: 6
-> Partial GroupAggregate (cost=2785961.20..2786037.78 rows=5 width=24)
Group Key: orders.o_orderpriority
-> Sort (cost=2785961.20..2785986.71 rows=10204 width=16)
Sort Key: orders.o_orderpriority
-> Parallel Hash Semi Join (cost=2287128.17..2785281.77 rows=10204 width=16)
Hash Cond: (orders.o_orderkey = lineitem_1997_03.l_orderkey)
-> Parallel Seq Scan on orders (cost=0.00..478035.10 rows=149709 width=20)
Filter: ((o_orderdate >= '1993-06-01'::date) AND (o_orderdate < '1993-09-01 00:00:00'::timestamp without time zone))
-> Parallel Hash (cost=2212136.03..2212136.03 rows=4570891 width=4)
-> Parallel Append (cost=0.00..2212136.03 rows=4570891 width=4)
-> Parallel Seq Scan on lineitem_1997_03 (cost=0.00..28247.60 rows=133296 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_05 (cost=0.00..28239.48 rows=133239 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_03 (cost=0.00..28234.29 rows=133208 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_03 (cost=0.00..28232.52 rows=133214 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_12 (cost=0.00..28228.67 rows=133191 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_05 (cost=0.00..28227.92 rows=133198 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_07 (cost=0.00..28223.68 rows=133165 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_01 (cost=0.00..28221.08 rows=133149 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_10 (cost=0.00..28215.69 rows=133138 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_08 (cost=0.00..28208.01 rows=133094 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_07 (cost=0.00..28201.06 rows=133068 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_01 (cost=0.00..28199.42 rows=133051 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_08 (cost=0.00..28198.89 rows=133037 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_08 (cost=0.00..28195.98 rows=133039 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_12 (cost=0.00..28195.76 rows=133034 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_08 (cost=0.00..28193.47 rows=133026 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_08 (cost=0.00..28193.09 rows=133016 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_01 (cost=0.00..28187.39 rows=132997 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_07 (cost=0.00..28179.71 rows=132952 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_07 (cost=0.00..28177.90 rows=132957 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_08 (cost=0.00..28176.21 rows=132939 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_07 (cost=0.00..28173.37 rows=132943 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_05 (cost=0.00..28173.21 rows=132939 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_10 (cost=0.00..28173.21 rows=132939 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_10 (cost=0.00..28173.08 rows=132935 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_10 (cost=0.00..28171.46 rows=132919 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_01 (cost=0.00..28168.52 rows=132894 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_10 (cost=0.00..28167.94 rows=132905 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_12 (cost=0.00..28166.50 rows=132894 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_01 (cost=0.00..28151.17 rows=132831 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_05 (cost=0.00..28150.97 rows=132826 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_05 (cost=0.00..28149.86 rows=132823 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_03 (cost=0.00..28149.69 rows=132818 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_03 (cost=0.00..28149.31 rows=132835 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_03 (cost=0.00..28148.78 rows=132821 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_05 (cost=0.00..28147.49 rows=132813 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_07 (cost=0.00..28146.85 rows=132796 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_12 (cost=0.00..28146.18 rows=132805 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_07 (cost=0.00..28145.33 rows=132809 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_01 (cost=0.00..28145.01 rows=132800 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_05 (cost=0.00..28142.34 rows=132783 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_12 (cost=0.00..28127.02 rows=132720 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_12 (cost=0.00..28116.86 rows=132663 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_10 (cost=0.00..28107.16 rows=132618 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_04 (cost=0.00..27343.12 rows=129016 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_09 (cost=0.00..27341.79 rows=129008 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_04 (cost=0.00..27327.82 rows=128955 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_04 (cost=0.00..27317.58 rows=128895 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_11 (cost=0.00..27317.05 rows=128881 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_11 (cost=0.00..27315.06 rows=128882 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_09 (cost=0.00..27310.53 rows=128867 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_06 (cost=0.00..27308.90 rows=128851 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_09 (cost=0.00..27308.34 rows=128836 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_09 (cost=0.00..27305.88 rows=128850 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_06 (cost=0.00..27302.65 rows=128817 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_06 (cost=0.00..27301.10 rows=128803 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_09 (cost=0.00..27295.75 rows=128794 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_09 (cost=0.00..27291.96 rows=128772 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_06 (cost=0.00..27289.69 rows=128765 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_11 (cost=0.00..27280.56 rows=128708 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_04 (cost=0.00..27271.01 rows=128667 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_11 (cost=0.00..27255.59 rows=128602 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_06 (cost=0.00..27254.25 rows=128593 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_06 (cost=0.00..27252.50 rows=128574 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_04 (cost=0.00..27247.56 rows=128548 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_06 (cost=0.00..27237.40 rows=128517 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_04 (cost=0.00..27226.10 rows=128456 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_11 (cost=0.00..27222.30 rows=128435 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_11 (cost=0.00..27213.19 rows=128405 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1996_02 (cost=0.00..26339.62 rows=124283 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1997_02 (cost=0.00..25510.27 rows=120354 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1993_02 (cost=0.00..25503.68 rows=120338 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1995_02 (cost=0.00..25470.81 rows=120182 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1994_02 (cost=0.00..25435.96 rows=120025 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_02 (cost=0.00..25408.64 rows=119884 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_08 (cost=0.00..25144.09 rows=118643 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_04 (cost=0.00..23734.94 rows=111998 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_03 (cost=0.00..17481.08 rows=82482 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_09 (cost=0.00..17478.56 rows=82468 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_10 (cost=0.00..11511.79 rows=66715 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_02 (cost=0.00..10309.36 rows=59743 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1992_01 (cost=0.00..4010.35 rows=30116 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_11 (cost=0.00..3926.15 rows=22751 width=4)
Filter: (l_commitdate < l_receiptdate)
-> Parallel Seq Scan on lineitem_1998_12 (cost=0.00..9.49 rows=66 width=4)
Filter: (l_commitdate < l_receiptdate)
(183 rows)
#0 0x0000560c01ffe642 in get_segment_by_index (area=0x560c03626e58, index=3)
at dsa.c:1716
__func__ = "get_segment_by_index"
#1 0x0000560c01ffee4d in get_best_segment (area=0x560c03626e58, npages=8) at
dsa.c:2002
next = 0x560c03626ee0
new_bin = 0
segment_map = 0x560c03626ee0
next_segment_index = 3
contiguous_pages = 0
threshold = 128
segment_index = 3
bin = 8
#2 0x0000560c01ffc889 in dsa_allocate_extended (area=0x560c03626e58,
size=32768, flags=0) at dsa.c:700
npages = 8
first_page = 140725227103296
span_pointer = 16492677255560
pool = 0x7fcb1ba76010
size_class = 28672
start_pointer = 1974272
segment_map = 0x100560c01e3ff9f
result = 2377900603788492800
__func__ = "dsa_allocate_extended"
#3 0x0000560c01c9efd6 in ExecParallelHashTupleAlloc (hashtable=0x7fcb1ba06078,
size=40, shared=0x7ffd252c2510) at nodeHash.c:2837
pstate = 0x7fcb1ba74e20
chunk_shared = 140510291828680
chunk = 0x7fcb1a07a000
chunk_size = 32768
result = 0x20000040000
curbatch = 33
#4 0x0000560c01c9d53b in ExecParallelHashTableInsertCurrentBatch
(hashtable=0x7fcb1ba06078, slot=0x7fcb1ba040b8, hashvalue=3364144574) at
nodeHash.c:1747
tuple = 0x560c03768918
hashTuple = 0x7fcb1ba040b8
shared = 3298536890312
batchno = 33
bucketno = 50622
#5 0x0000560c01ca1a00 in ExecParallelHashJoinNewBatch (hjstate=0x560c03631cb8)
at nodeHashjoin.c:1153
inner_tuples = 0x560c0373dc98
batch_barrier = 0x7fcb1ad52498
hashvalue = 3364144574
tuple = 0x560c03768918
slot = 0x7fcb1ba040b8
hashtable = 0x7fcb1ba06078
start_batchno = 33
batchno = 33
__func__ = "ExecParallelHashJoinNewBatch"
#6 0x0000560c01ca0a0c in ExecHashJoinImpl (pstate=0x560c03631cb8,
parallel=true) at nodeHashjoin.c:534
node = 0x560c03631cb8
outerNode = 0x560c03631750
hashNode = 0x560c03632cf8
joinqual = 0x0
otherqual = 0x0
econtext = 0x560c03631ec8
hashtable = 0x7fcb1ba06078
outerTupleSlot = 0x0
hashvalue = 623650368
batchno = 32765
parallel_state = 0x7fcb1ba74e20
__func__ = "ExecHashJoinImpl"
#7 0x0000560c01ca0ae9 in ExecParallelHashJoin (pstate=0x560c03631cb8) at
nodeHashjoin.c:581
No locals.
#8 0x0000560c01cb36a1 in ExecProcNode (node=0x560c03631cb8) at
../../../src/include/executor/executor.h:237
No locals.
#9 0x0000560c01cb37db in ExecSort (pstate=0x560c03631890) at nodeSort.c:107
plannode = 0x560c035a5c60
outerNode = 0x560c03631cb8
tupDesc = 0x7fcb1ba04168
node = 0x560c03631890
estate = 0x560c03630f90
dir = ForwardScanDirection
tuplesortstate = 0x560c037185c0
slot = 0x7fcb1ba04278
#10 0x0000560c01c84b23 in ExecProcNodeFirst (node=0x560c03631890) at
execProcnode.c:445
No locals.
#11 0x0000560c01c8fd46 in ExecProcNode (node=0x560c03631890) at
../../../src/include/executor/executor.h:237
No locals.
#12 0x0000560c01c901a9 in fetch_input_tuple (aggstate=0x560c036319a0) at
nodeAgg.c:406
slot = 0x560c036316c0
#13 0x0000560c01c92431 in agg_retrieve_direct (aggstate=0x560c036319a0) at
nodeAgg.c:1736
node = 0x560c035a59d0
econtext = 0x560c03631c08
tmpcontext = 0x560c03631630
peragg = 0x7fcb1ba06878
pergroups = 0x7fcb1ba084d0
outerslot = 0x7ffd252c27e0
firstSlot = 0x7fcb1ba05e68
result = 0x0
hasGroupingSets = false
numGroupingSets = 1
currentSet = 32765
nextSetSize = 0
numReset = 1
i = 1
#14 0x0000560c01c92087 in ExecAgg (pstate=0x560c036319a0) at nodeAgg.c:1551
node = 0x560c036319a0
result = 0x0
#15 0x0000560c01c84b23 in ExecProcNodeFirst (node=0x560c036319a0) at
execProcnode.c:445
No locals.
#16 0x0000560c01c7a117 in ExecProcNode (node=0x560c036319a0) at
../../../src/include/executor/executor.h:237
No locals.
#17 0x0000560c01c7c73f in ExecutePlan (estate=0x560c03630f90,
planstate=0x560c036319a0, use_parallel_mode=false, operation=CMD_SELECT,
sendTuples=true, numberTuples=0, direction=ForwardScanDirection,
dest=0x560c035a5870, execute_once=true) at execMain.c:1721
slot = 0x7ffd252c28a0
current_tuple_count = 0
#18 0x0000560c01c7a612 in standard_ExecutorRun (queryDesc=0x560c03624cf8,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:362
estate = 0x560c03630f90
operation = CMD_SELECT
dest = 0x560c035a5870
sendTuples = true
oldcontext = 0x560c035a5260
__func__ = "standard_ExecutorRun"
#19 0x0000560c01c7a4a9 in ExecutorRun (queryDesc=0x560c03624cf8,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:305
No locals.
#20 0x0000560c01c815bb in ParallelQueryMain (seg=0x560c0353b578,
toc=0x7fcb1ba72000) at execParallel.c:1322
fpes = 0x7fcb1baf4d00
buffer_usage = 0x7fcb1bb0cd40
receiver = 0x560c035a5870
queryDesc = 0x560c03624cf8
instrumentation = 0x0
instrument_options = 0
area_space = 0x7fcb1ba74f20
area = 0x560c03626e58
pwcxt = {seg = 0x560c0353b578, toc = 0x7fcb1ba72000}
#21 0x0000560c01ad5395 in ParallelWorkerMain (main_arg=304158916) at
parallel.c:1398
seg = 0x560c0353b578
toc = 0x7fcb1ba72000
fps = 0x7fcb1bb0d460
error_queue_space = 0x7fcb1baf4d40 ""
mq = 0x7fcb1bb00d40
mqh = 0x560c03542f60
libraryspace = 0x7fcb1bb0d440 ""
entrypointstate = 0x7fcb1baf4d20 "postgres"
library_name = 0x7fcb1baf4d20 "postgres"
function_name = 0x7fcb1baf4d29 "ParallelQueryMain"
entrypt = 0x560c01c813ce <ParallelQueryMain>
gucspace = 0x7fcb1bb0ce40 "\304\005"
combocidspace = 0x7fcb1bb0ce20 ""
tsnapspace = 0x7fcb1bb0cde0 "\367\005"
asnapspace = 0x7fcb1bb0cda0 "\367\005"
tstatespace = 0x7fcb1bb0cd60 "\001"
reindexspace = 0x7fcb1bb0cd40 ""
msgbuf = {data = 0x0, len = 8, maxlen = 1024, cursor = 75}
session_dsm_handle_space = 0x7fcb1bb0cd80 "(\024}\f"
__func__ = "ParallelWorkerMain"
#22 0x0000560c01da7921 in StartBackgroundWorker () at bgworker.c:834
local_sigjmp_buf = {{__jmpbuf = {0, 4685308575649678302,
94609573359424, 140725227107728, 0, 0, 4685308575620318174,
1362275939243967454}, __mask_was_saved = 1, __saved_mask = {__val =
{18446744066192964103, 94609595390144, 94609595245520, 140725227105120,
94609573132398, 140725227105088, 94609595245520, 1024,
94609595245736, 94609595245520, 94609595245520, 94609578233056, 94609595224272,
140725227105152, 94609573163167, 0}}}}
worker = 0x560c0350d9e0
entrypt = 0x560c01ad4de6 <ParallelWorkerMain>
__func__ = "StartBackgroundWorker"
#23 0x0000560c01dbb63d in do_start_bgworker (rw=0x560c03533780) at
postmaster.c:5698
worker_pid = 0
__func__ = "do_start_bgworker"
#24 0x0000560c01dbb9e8 in maybe_start_bgworkers () at postmaster.c:5911
rw = 0x560c03533780
num_launched = 2
now = 0
iter = {cur = 0x560c035339c0, next = 0x560c03533c10, prev =
0x560c03536bc0}
#25 0x0000560c01dba927 in sigusr1_handler (postgres_signal_arg=10) at
postmaster.c:5091
save_errno = 4
__func__ = "sigusr1_handler"
#26 <signal handler called>
No locals.
#27 0x00007fcb5ee44a8e in __GI___select (nfds=6, readfds=0x7ffd252c3310,
writefds=0x0, exceptfds=0x0, timeout=0x7ffd252c3280) at
../sysdeps/unix/sysv/linux/select.c:41
resultvar = 18446744073709551612
sc_ret = <optimized out>
#28 0x0000560c01db61e0 in ServerLoop () at postmaster.c:1670
timeout = {tv_sec = 59, tv_usec = 969436}
rmask = {fds_bits = {56, 0 <repeats 15 times>}}
selres = 1
now = 1537135503
readmask = {fds_bits = {56, 0 <repeats 15 times>}}
nSockets = 6
last_lockfile_recheck_time = 1537135457
last_touch_time = 1537135157
__func__ = "ServerLoop"
#29 0x0000560c01db5b0a in PostmasterMain (argc=3, argv=0x560c0350d020) at
postmaster.c:1379
opt = -1
status = 0
userDoption = 0x560c0352eea0 "/mnt/raid/data"
listen_addr_saved = true
i = 64
output_config_variable = 0x0
__func__ = "PostmasterMain"
#30 0x0000560c01ce10f3 in main (argc=3, argv=0x560c0350d020) at main.c:228
do_check_root = true
