88 lines
3.5 KiB
Python
88 lines
3.5 KiB
Python
# -*- coding:utf-8 -*-
|
|
# Copyright (c) 2020 Huawei Technologies Co.,Ltd.
|
|
#
|
|
# openGauss is licensed under Mulan PSL v2.
|
|
# You can use this software according to the terms
|
|
# and conditions of the Mulan PSL v2.
|
|
# You may obtain a copy of Mulan PSL v2 at:
|
|
#
|
|
# http://license.coscl.org.cn/MulanPSL2
|
|
#
|
|
# THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS,
|
|
# WITHOUT WARRANTIES OF ANY KIND,
|
|
# EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
|
|
# MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
|
|
# See the Mulan PSL v2 for more details.
|
|
# ----------------------------------------------------------------------------
|
|
import subprocess
|
|
from gspylib.inspection.common import SharedFuncs
|
|
from gspylib.inspection.common.CheckItem import BaseItem
|
|
from gspylib.inspection.common.CheckResult import ResultStatus
|
|
from gspylib.common.ErrorCode import ErrorCode
|
|
|
|
g_value = 0
|
|
|
|
|
|
class CheckMaxDatanode(BaseItem):
|
|
def __init__(self):
|
|
super(CheckMaxDatanode, self).__init__(self.__class__.__name__)
|
|
self.nodeCount = None
|
|
self.dnCount = None
|
|
|
|
def preCheck(self):
|
|
# check current node contains cn instances if not raise exception
|
|
super(CheckMaxDatanode, self).preCheck()
|
|
# check the threshold was set correctly
|
|
if (not self.threshold.__contains__('nodeCount')):
|
|
raise Exception(ErrorCode.GAUSS_530["GAUSS_53013"]
|
|
% "threshold nodeCount")
|
|
if (not self.threshold.__contains__('dnCount')):
|
|
raise Exception(ErrorCode.GAUSS_530["GAUSS_53013"]
|
|
% "threshold dnCount")
|
|
|
|
self.nodeCount = self.threshold['nodeCount']
|
|
self.dnCount = self.threshold['dnCount']
|
|
|
|
def doCheck(self):
|
|
global g_value
|
|
dataNum = int(self.nodeCount) * int(self.dnCount)
|
|
sqlcmd = "SELECT setting FROM pg_settings WHERE " \
|
|
"name='comm_max_datanode';"
|
|
self.result.raw = sqlcmd
|
|
comm_max_datanode = SharedFuncs.runSqlCmd(sqlcmd, self.user, "",
|
|
self.port, self.tmpPath,
|
|
"postgres", self.mpprcFile)
|
|
|
|
if comm_max_datanode.isdigit() and dataNum > int(comm_max_datanode):
|
|
if (dataNum < 256):
|
|
g_value = 256
|
|
elif (dataNum < 512):
|
|
g_value = 512
|
|
elif (dataNum < 1024):
|
|
g_value = 1024
|
|
else:
|
|
g_value = 2048
|
|
self.result.rst = ResultStatus.WARNING
|
|
self.result.val = "Invalid value for GUC parameter " \
|
|
"comm_max_datanode: %s. Expect value: %s" % (
|
|
comm_max_datanode, g_value)
|
|
else:
|
|
self.result.rst = ResultStatus.OK
|
|
self.result.val = "dataNum: %s, comm_max_datanode: %s" % (
|
|
dataNum, comm_max_datanode)
|
|
|
|
self.result.raw = sqlcmd
|
|
|
|
def doSet(self):
|
|
cmd = " gs_guc set -N all -I all -c " \
|
|
"'comm_max_datanode=%d'; " % g_value
|
|
cmd += " gs_guc set -N all -I all -c " \
|
|
"'comm_max_datanode=%d' " % g_value
|
|
(status, output) = subprocess.getstatusoutput(cmd)
|
|
if (status != 0):
|
|
self.result.val += "Falied to set comm_max_datanode.\n Error : " \
|
|
"%s. " % output
|
|
self.result.val += "The cmd is %s " % cmd
|
|
else:
|
|
self.result.val += "Set comm_max_datanode successfully."
|