Files
doc-exports/docs/mrs/umn/ALM-29008.html
Yang, Tong 5914b67d13 MRS UMN Doc 20240802 version
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>
2024-09-28 19:04:58 +00:00

92 lines
9.8 KiB
HTML

<a name="ALM-29008"></a><a name="ALM-29008"></a>
<h1 class="topictitle1">ALM-29008 Number of ODBC Connections to Impalad Exceeds the Threshold</h1>
<div id="body0000001282448558"><div class="section" id="ALM-29008__section8280367"><h4 class="sectiontitle">Alarm Description</h4><p id="ALM-29008__p1268811311458">The system checks the number of client connections to the Impalad node every 30 seconds. This alarm is generated when the number of client connections exceeds the customized threshold (60 by default).</p>
<p id="ALM-29008__p2335053105020">This alarm is automatically cleared when the number of client connections is less than the threshold.</p>
</div>
<div class="section" id="ALM-29008__section7414445"><h4 class="sectiontitle">Alarm Attributes</h4>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="ALM-29008__table45079949" frame="border" border="1" rules="all"><thead align="left"><tr id="ALM-29008__row5683496"><th align="left" class="cellrowborder" valign="top" width="33.3033303330333%" id="mcps1.3.2.2.1.4.1.1"><p id="ALM-29008__p57710042">Alarm ID</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="33.36333633363336%" id="mcps1.3.2.2.1.4.1.2"><p id="ALM-29008__p44001849">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-29008__p7380012">Auto Cleared</p>
</th>
</tr>
</thead>
<tbody><tr id="ALM-29008__row60910108"><td class="cellrowborder" valign="top" width="33.3033303330333%" headers="mcps1.3.2.2.1.4.1.1 "><p id="ALM-29008__p16488194717492">29008</p>
</td>
<td class="cellrowborder" valign="top" width="33.36333633363336%" headers="mcps1.3.2.2.1.4.1.2 "><p id="ALM-29008__p588994817496">Major</p>
</td>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="mcps1.3.2.2.1.4.1.3 "><p id="ALM-29008__p34071398">Yes</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="section" id="ALM-29008__section66730009"><h4 class="sectiontitle">Alarm Parameters</h4>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="ALM-29008__table8319831" frame="border" border="1" rules="all"><thead align="left"><tr id="ALM-29008__row40868022"><th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.3.2.1.4.1.1"><p id="ALM-29008__p981243023416">Type</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.3.2.1.4.1.2"><p id="ALM-29008__p21975462">Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="60%" id="mcps1.3.3.2.1.4.1.3"><p id="ALM-29008__p35182007">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="ALM-29008__row594512751512"><td class="cellrowborder" rowspan="4" valign="top" width="20%" headers="mcps1.3.3.2.1.4.1.1 "><p id="ALM-29008__p660023953412">Location Information</p>
</td>
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.3.2.1.4.1.2 "><p id="ALM-29008__p8838358184914">Source</p>
</td>
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.3.2.1.4.1.3 "><p id="ALM-29008__p837170125015">Specifies the cluster for which the alarm was generated.</p>
</td>
</tr>
<tr id="ALM-29008__row31170320"><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.1.4.1.1 "><p id="ALM-29008__p39123317">ServiceName</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.3.2.1.4.1.2 "><p id="ALM-29008__p172628810500">Specifies the service for which the alarm was generated.</p>
</td>
</tr>
<tr id="ALM-29008__row883552454311"><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.1.4.1.1 "><p id="ALM-29008__p1583622417439">RoleName</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.3.2.1.4.1.2 "><p id="ALM-29008__p783622419433">Specifies the role for which the alarm was generated.</p>
</td>
</tr>
<tr id="ALM-29008__row164912316433"><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.1.4.1.1 "><p id="ALM-29008__p154923174310">HostName</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.3.2.1.4.1.2 "><p id="ALM-29008__p1349163115432">Specifies the host for which the alarm was generated.</p>
</td>
</tr>
<tr id="ALM-29008__row1305193818439"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.3.2.1.4.1.1 "><p id="ALM-29008__p15812530183414">Additional Information</p>
</td>
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.3.2.1.4.1.2 "><p id="ALM-29008__p1130583818431">Trigger Condition</p>
</td>
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.3.2.1.4.1.3 "><p id="ALM-29008__p33051338164316">Specifies the threshold for triggering the alarm.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="section" id="ALM-29008__section63699172"><h4 class="sectiontitle">Impact on the System</h4><p id="ALM-29008__p485055019508">New client connections may be blocked or even fail.</p>
</div>
<div class="section" id="ALM-29008__section36421639"><h4 class="sectiontitle">Possible Causes</h4><p id="ALM-29008__p9402509505">The number of client connections maintained by the Impalad service is too large or the threshold is too small.</p>
</div>
<div class="section" id="ALM-29008__section20662238181315"><h4 class="sectiontitle">Handling Procedure</h4><ol id="ALM-29008__ol398575283918"><li id="ALM-29008__li1898555216394"><span>On FusionInsight Manager, choose <strong id="ALM-29008__b121256143357">O&amp;M </strong>&gt; <strong id="ALM-29008__b16125121473512">Alarm</strong> &gt; <strong id="ALM-29008__b16125141412354">Thresholds</strong> &gt; <strong id="ALM-29008__b6125101443510">Impala</strong> &gt; <strong id="ALM-29008__b412515147355">Connections</strong> &gt; <strong id="ALM-29008__b12125101410353">Number of ODBC Connections to Impalad Process (Impalad)</strong> to check the threshold.</span></li><li id="ALM-29008__li1232161715409"><span>Check the number of ODBC applications connected to Impalad and stop idle applications. Check whether the alarm is automatically cleared.</span><p><ul id="ALM-29008__ul1437394518402"><li id="ALM-29008__li9373184519406">If yes, no further action is required.</li><li id="ALM-29008__li5327195094015">If no, go to <a href="#ALM-29008__li1507754134111">3</a> to change the number of concurrent connections supported by Impalad.</li></ul>
</p></li><li id="ALM-29008__li1507754134111"><a name="ALM-29008__li1507754134111"></a><a name="li1507754134111"></a><span>On FusionInsight Manager, choose <strong id="ALM-29008__b1618423443519">Cluster</strong> &gt; <strong id="ALM-29008__b17184193412354">Impala</strong> &gt; <strong id="ALM-29008__b21848340351">Configurations</strong> &gt; <strong id="ALM-29008__b1718415344354">All Configurations</strong> &gt; <strong id="ALM-29008__b1918516346351">Impalad</strong> &gt; <strong id="ALM-29008__b7185173413359">Customization</strong>. Add the custom parameter <strong id="ALM-29008__b3185334173516">--fe_service_threads</strong>. The default value of this parameter is <strong id="ALM-29008__b11185934143518">64</strong>. Change the value as required and click <strong id="ALM-29008__b918563414350">Save</strong>.</span></li><li id="ALM-29008__li128051144134613"><span>After the query tasks on all clients are complete, click the <strong id="ALM-29008__b154063993614">Instances</strong> tab. Select all Impalad instances, and restart them.</span><p><div class="note" id="ALM-29008__note220918329390"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="ALM-29008__en-us_topic_0294848303_p0481144124012">The service will become unavailable when all instances are restarted. If a single instance is restarted, the tasks that are being executed on that instance will fail and the service will become available.</p>
</div></div>
</p></li><li id="ALM-29008__li313119456566"><span>After the restart is complete, check whether the alarm is cleared.</span><p><ul id="ALM-29008__ul554711711577"><li id="ALM-29008__li105478719578">If yes, no further action is required.</li><li id="ALM-29008__li165471275576">If yes, go to <a href="#ALM-29008__li17918612154249">6</a>.</li></ul>
</p></li></ol>
<p class="tableheading" id="ALM-29008__p3847019615437"><strong id="ALM-29008__b1184566123718">Collect fault information.</strong></p>
<ol start="6" id="ALM-29008__ol18403783154311"><li id="ALM-29008__li17918612154249"><a name="ALM-29008__li17918612154249"></a><a name="li17918612154249"></a><span>On FusionInsight Manager, choose <strong id="ALM-29008__b92041888374">O&amp;M</strong>. In the navigation pane on the left, choose <strong id="ALM-29008__b10204158143719">Log</strong> &gt; <strong id="ALM-29008__b1520416853712">Download</strong>.</span></li><li id="ALM-29008__li27049781154249"><span>Expand the <strong id="ALM-29008__b145588914370">Service</strong> drop-down list, and select <strong id="ALM-29008__b14558199173717">Impala</strong> for the target cluster.</span></li><li id="ALM-29008__li42121445154249"><span>Click the edit icon in the upper right corner, and set <strong id="ALM-29008__b18417611143713">Start Date</strong> and <strong id="ALM-29008__b1341791133710">End Date</strong> for log collection to 1 hour ahead of and after the alarm generation time, respectively. Then, click <strong id="ALM-29008__b12417111113713">Download</strong>.</span></li><li id="ALM-29008__li56393916154249"><span>Contact <span id="ALM-29008__text876211216374">O&amp;M personnel</span> and provide the collected logs.</span></li></ol>
</div>
<div class="section" id="ALM-29008__section169311343318"><h4 class="sectiontitle">Alarm Clearance</h4><p id="ALM-29008__p55781648135011">This alarm is automatically cleared after the fault is rectified.</p>
</div>
<div class="section" id="ALM-29008__section53362350"><h4 class="sectiontitle">Related Information</h4><p id="ALM-29008__p7522741">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>