forked from docs/doc-exports
Yang, Tong
3b1f73dece
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Yang, Tong <yangtong2@huawei.com> Co-committed-by: Yang, Tong <yangtong2@huawei.com>
100 lines
16 KiB
HTML
100 lines
16 KiB
HTML
<a name="ALM-27005"></a><a name="ALM-27005"></a>
|
|
|
|
<h1 class="topictitle1">ALM-27005 Database Connections Usage Exceeds the Threshold</h1>
|
|
<div id="body1534902016092"><div class="section" id="ALM-27005__section17292535350"><h4 class="sectiontitle">Description</h4><p id="ALM-27005__p388117536352">The system checks the usage of the number of database connections of the nodes where DBServer instances are located every 30 seconds and compares the usage with the threshold. If the usage exceeds the threshold for five consecutive times (this number is configurable, and 5 is the default value), the system generates this alarm. The default usage threshold is 90%, and you can configure it based on site requirements.</p>
|
|
<p id="ALM-27005__p9881853153515">The trigger count is configurable. This alarm is cleared in the following scenarios:</p>
|
|
<ul id="ALM-27005__ul1488185317359"><li id="ALM-27005__li6882205317353">The trigger count is 1, and the usage of the number of database connections is less than or equal to the threshold.</li><li id="ALM-27005__li1688275393517">The trigger count is greater than 1, and the usage of the number of database connections is less than or equal to 90% of the threshold.</li></ul>
|
|
</div>
|
|
<div class="section" id="ALM-27005__section13735195313520"><h4 class="sectiontitle">Attribute</h4>
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="ALM-27005__table573717535359" frame="border" border="1" rules="all"><thead align="left"><tr id="ALM-27005__row1188265363512"><th align="left" class="cellrowborder" valign="top" width="33.33333333333333%" id="mcps1.3.2.2.1.4.1.1"><p id="ALM-27005__p08821553173512">Alarm ID</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="33.33333333333333%" id="mcps1.3.2.2.1.4.1.2"><p id="ALM-27005__p148821453143516">Alarm Severity</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="33.33333333333333%" id="mcps1.3.2.2.1.4.1.3"><p id="ALM-27005__p10882175315351">Automatically Cleared</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="ALM-27005__row8882145312359"><td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.1.4.1.1 "><p id="ALM-27005__p1788245314357">27005</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.1.4.1.2 "><p id="ALM-27005__p9882165383515">Major</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.1.4.1.3 "><p id="ALM-27005__p888210532356">Yes</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="ALM-27005__section1974815373510"><h4 class="sectiontitle">Parameters</h4>
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="ALM-27005__table1274875313358" frame="border" border="1" rules="all"><thead align="left"><tr id="ALM-27005__row188211533353"><th align="left" class="cellrowborder" valign="top" width="50%" id="mcps1.3.3.2.1.3.1.1"><p id="ALM-27005__p4882145363513">Name</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="50%" id="mcps1.3.3.2.1.3.1.2"><p id="ALM-27005__p588211532353">Meaning</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="ALM-27005__row12261756616"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.1 "><p id="ALM-27005__p192431315431">Source</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.2 "><p id="ALM-27005__p692551319435">Specifies the cluster for which the alarm is generated.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="ALM-27005__row48831753183517"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.1 "><p id="ALM-27005__p18883155383513">ServiceName</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.2 "><p id="ALM-27005__p58836539354">Specifies the service for which the alarm is generated.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="ALM-27005__row14883115373515"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.1 "><p id="ALM-27005__p988375313512">RoleName</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.2 "><p id="ALM-27005__p1088315333515">Specifies the role for which the alarm is generated.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="ALM-27005__row198839534356"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.1 "><p id="ALM-27005__p1188317531356">HostName</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.2 "><p id="ALM-27005__p1688312534357">Specifies the host for which the alarm is generated.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="ALM-27005__row1188335311355"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.1 "><p id="ALM-27005__p178837533350">Trigger Condition</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.3.2.1.3.1.2 "><p id="ALM-27005__p158832053193512">Specifies the threshold triggering the alarm. If the current indicator value exceeds this threshold, the alarm is generated.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="ALM-27005__section1975455319357"><h4 class="sectiontitle">Impact on the System</h4><p id="ALM-27005__p4883145373514">Upper-layer services may fail to connect to the DBService database, affecting services.</p>
|
|
</div>
|
|
<div class="section" id="ALM-27005__section17545539358"><h4 class="sectiontitle">Possible Causes</h4><ul id="ALM-27005__ul138834539351"><li id="ALM-27005__li11883115315357">Too many database connections are used.</li><li id="ALM-27005__li488325311356">The maximum number of database connections is improperly configured.</li><li id="ALM-27005__li4883653203513">The alarm threshold or alarm trigger count is improperly configured.</li></ul>
|
|
</div>
|
|
<div class="section" id="ALM-27005__section975618537357"><h4 class="sectiontitle">Procedure</h4><p id="ALM-27005__p1488395311358"><strong id="ALM-27005__b158835533358">Checking whether too many data connections are used</strong></p>
|
|
</div>
|
|
<ol id="ALM-27005__ol3450144875915"><li id="ALM-27005__li184504483595"><span>On FusionInsight Manager, click DBService in the service list on the left navigation pane. The DBService monitoring page is displayed.</span></li><li id="ALM-27005__li474815305919"><span>Observe the number of connections used by the database user, as shown in <a href="#ALM-27005__fig821715142011">Figure 1</a>. Based on the service scenario, reduce the number of database user connections.</span><p><div class="fignone" id="ALM-27005__fig821715142011"><a name="ALM-27005__fig821715142011"></a><a name="fig821715142011"></a><span class="figcap"><b>Figure 1 </b>Number of connections used by database users</span><br><span><img id="ALM-27005__image89351691514" src="en-us_image_0269417469.png"></span></div>
|
|
</p></li><li id="ALM-27005__li123269582013"><span>Wait for 2 minutes and check whether the alarm is automatically cleared.</span><p><ul id="ALM-27005__ul13468648002"><li id="ALM-27005__li846816481902">If it is, no further action is required.</li><li id="ALM-27005__li087683914318">If it is not, go to <a href="#ALM-27005__li96747179515">4</a>.</li></ul>
|
|
</p></li></ol>
|
|
<p id="ALM-27005__p9465121618583"><strong id="ALM-27005__b4885185373511">Checking whether the maximum number of database connections is properly configured</strong></p>
|
|
<ol start="4" id="ALM-27005__ol8674131713514"><li id="ALM-27005__li96747179515"><a name="ALM-27005__li96747179515"></a><a name="li96747179515"></a><span>Log in to FusionInsight Manager, choose <strong id="ALM-27005__b17674717458">Cluster</strong> > <em id="ALM-27005__i175981233194118">Name of the desired cluster</em> ><strong id="ALM-27005__b169689642620"> Services</strong> > <strong id="ALM-27005__b1467431713519">DBService</strong> > <strong id="ALM-27005__b1267417176518">Configurations</strong>. On the displayed page, select the <strong id="ALM-27005__b126741171258">All</strong> <strong id="ALM-27005__b12817439132618">Configurations</strong><strong id="ALM-27005__b158171390268"> </strong>tab, and increase the maximum number of database connections based on service requirements, as shown in <a href="#ALM-27005__fig1567417179514">Figure 2</a>. Click <strong id="ALM-27005__b146740171559">Save</strong>. In the displayed <strong id="ALM-27005__b156740172517">Save configuration</strong> dialog box, click <strong id="ALM-27005__b19674217859">OK</strong>.</span><p><div class="fignone" id="ALM-27005__fig1567417179514"><a name="ALM-27005__fig1567417179514"></a><a name="fig1567417179514"></a><span class="figcap"><b>Figure 2 </b>Setting the maximum number of database connections</span><br><span><img id="ALM-27005__image99315279412" src="en-us_image_0000001086795516.png"></span></div>
|
|
</p></li></ol><ol start="5" id="ALM-27005__ol3317614089"><li id="ALM-27005__li03173142814"><span>After the maximum number of database connections is changed, restart DBService (do not restart the upper-layer services).</span><p><p id="ALM-27005__p736512812919">Procedure: Log in to FusionInsight Manager and choose <strong id="ALM-27005__b1365481599">Cluster</strong> > <em id="ALM-27005__i10510256194018">Name of the desired cluster</em> > <strong id="ALM-27005__b113379449320">Services</strong> > <strong id="ALM-27005__b15365681298">DBService</strong>. On the displayed page, choose <strong id="ALM-27005__b1236519812920">More</strong> > <strong id="ALM-27005__b2365138999">Restart</strong> <strong id="ALM-27005__b2093123164618">Service</strong>. Enter the password of the current login user and click <strong id="ALM-27005__b166816112818">OK</strong>. Do not select <strong id="ALM-27005__b1136510813917">Restart upper-layer services.</strong>, click <strong id="ALM-27005__b03651789912">OK</strong>.</p>
|
|
</p></li></ol><ol start="6" id="ALM-27005__ol71156277911"><li id="ALM-27005__li11115202717918"><span>After the service is restarted, wait for 2 minutes and check whether the alarm is cleared.</span><p><ul id="ALM-27005__ul71152027691"><li id="ALM-27005__li11156271199">If it is, no further action is required.</li><li id="ALM-27005__li111155274911">If it is not, go to <a href="#ALM-27005__li66961681117">7</a>.</li></ul>
|
|
</p></li></ol>
|
|
<p id="ALM-27005__p131617420555"><strong id="ALM-27005__b716115414557">Checking whether the alarm threshold or trigger count is properly configured</strong></p>
|
|
<ol start="7" id="ALM-27005__ol142293021019"><li id="ALM-27005__li66961681117"><a name="ALM-27005__li66961681117"></a><a name="li66961681117"></a><span>Log in to FusionInsight Manager and change the alarm threshold and alarm trigger count based on the actual database connection usage.</span><p><p id="ALM-27005__p136161019101116">Choose <strong id="ALM-27005__b17511034113818">O&M</strong>> <strong id="ALM-27005__b15646119396">Alarm</strong> > <strong id="ALM-27005__b1546420544812">Thresholds</strong> > <em id="ALM-27005__i1588293015214">Name of the desired cluster > </em><strong id="ALM-27005__b388503092117">DBService > Database > Database Connections Usage (DBServer)</strong>. In the <strong id="ALM-27005__b830319134119">Database Connections Usage (DBServer)</strong> area, click the pencil icon next to <strong id="ALM-27005__b1030311311112">Trigger Count</strong>. In the displayed dialog box, change the trigger count, as shown in <a href="#ALM-27005__fig14885145323516">Figure 3</a>.</p>
|
|
<div class="note" id="ALM-27005__note123995422117"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="ALM-27005__p123991842191118"><strong id="ALM-27005__b11399342181118">Trigger Count</strong>: If the usage of the number of database connections exceeds the threshold consecutively for more than the value of this parameter, an alarm is generated.</p>
|
|
</div></div>
|
|
<div class="fignone" id="ALM-27005__fig14885145323516"><a name="ALM-27005__fig14885145323516"></a><a name="fig14885145323516"></a><span class="figcap"><b>Figure 3 </b>Setting alarm trigger count</span><br><span><img id="ALM-27005__image1387164284214" src="en-us_image_0000001133372255.png"></span></div>
|
|
<p id="ALM-27005__p19726646191219">Based on the actual database connection usage, choose <strong id="ALM-27005__b63851738134415">O&M</strong> ><strong id="ALM-27005__b19868741204414">Alarm</strong> > <strong id="ALM-27005__b541841418278">Thresholds</strong> > <em id="ALM-27005__i210461913275">Name of the desired cluster</em> > <strong id="ALM-27005__b1830747143319">DBService > Database > Database Connections Usage (DBServer)</strong>. In the <strong id="ALM-27005__b15117185315115">Database Connections Usage (DBServer)</strong> area, click <strong id="ALM-27005__b111717533114">Modify</strong> in the <strong id="ALM-27005__b161171153181115">Operation</strong> column. In the <strong id="ALM-27005__b1211784544812">Modify Rule</strong> dialog box, modify the required parameters and click <strong id="ALM-27005__b121171253111112">OK</strong> as shown in <a href="#ALM-27005__fig19690175212407">Figure 4</a>.</p>
|
|
<div class="fignone" id="ALM-27005__fig19690175212407"><a name="ALM-27005__fig19690175212407"></a><a name="fig19690175212407"></a><span class="figcap"><b>Figure 4 </b>Set alarm threshold</span><br><span><img id="ALM-27005__image1430111245262" src="en-us_image_0000001390936180.png"></span></div>
|
|
</p></li></ol><ol start="8" id="ALM-27005__ol12885115317352"><li id="ALM-27005__li4885195317355"><span>Wait for 2 minutes and check whether the alarm is automatically cleared.</span><p><ul id="ALM-27005__ul2885125318357"><li id="ALM-27005__li28851653173517">If it is, no further action is required.</li><li id="ALM-27005__li152581415121411">If it is not, go to <a href="#ALM-27005__li195612031415">9</a>.</li></ul>
|
|
</p></li></ol>
|
|
<p id="ALM-27005__p155622031416"><strong id="ALM-27005__b148851553163514">Collect fault information</strong></p>
|
|
<ol start="9" id="ALM-27005__ol25682061415"><li id="ALM-27005__li195612031415"><a name="ALM-27005__li195612031415"></a><a name="li195612031415"></a><span>On FusionInsight Manager, choose <strong id="ALM-27005__b932215397496">O&M</strong> > <strong id="ALM-27005__b05662061413">Log</strong> > <strong id="ALM-27005__b1872915425492">Download</strong>.</span></li><li id="ALM-27005__li4562200145"><span>Select <strong id="ALM-27005__b155618202142">DBService</strong> in the required cluster from the <strong id="ALM-27005__b1456152031414">Service</strong>.</span></li><li id="ALM-27005__li65619209145"><span>Specify the host for collecting logs by setting the <strong id="ALM-27005__b115619201146">Host</strong> parameter that is optional. By default, all hosts are selected.</span></li><li id="ALM-27005__li1145664103113"><span>Click <span><img id="ALM-27005__image1945644173117" src="en-us_image_0269417473.png"></span> in the upper right corner, and set <strong id="ALM-27005__b6456941173117">Start Date</strong> and <strong id="ALM-27005__b11456154113318">End Date</strong> for log collection to 10 minutes ahead of and after the alarm generation time, respectively. Then, click <strong id="ALM-27005__b13456164113319">Download</strong>.</span></li><li id="ALM-27005__li16561820191417"><span>Contact the <span id="ALM-27005__text4614151421417">O&M personnel</span> and send the collected fault logs.</span></li></ol>
|
|
<div class="section" id="ALM-27005__section1529716184534"><h4 class="sectiontitle">Alarm Clearing</h4><p id="ALM-27005__p4677152685316">After the fault is rectified, the system automatically clears this alarm.</p>
|
|
</div>
|
|
<div class="section" id="ALM-27005__section147771053193515"><h4 class="sectiontitle">Related Information</h4><p id="ALM-27005__p198871353113510">None</p>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="mrs_01_1298.html">Alarm Reference (Applicable to MRS 3.x)</a></div>
|
|
</div>
|
|
</div>
|
|
|