IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Initial Version and Version 1 of PS1_IPP_Czarlog_20190318


Ignore:
Timestamp:
Mar 18, 2019, 9:44:36 AM (7 years ago)
Author:
tdeboer
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • PS1_IPP_Czarlog_20190318

    v1 v1  
     1== PS1 IPP Czar Logs for the week YYYY.MM.DD - YYYY.MM.DD ==
     2[[PageOutline]]
     3
     4(Up to [wiki:PS1_IPP_CzarLogs PS1 IPP Czar Logs])
     5
     6=== Monday : 2019.03.18 ===
     7
     8 * TdB: In the morning (05:45), I noticed ippb18 was reported as down by nagios. When trying to get more information, I noticed neb-host was reporting too many connections and no machines where showing up in IPP monitor (all greyed out). Following a quick back and forth with Gene I then set all pantasks to stop using:
     9{{{
     10check_system.sh stop
     11}}}
     12  Furthermore, the compute nodes ippc71-75 were showing huge load on ganglia, so we turned off apache on those machines, using:
     13{{{
     14/etc/init.d/apache2 stop
     15}}}
     16  as root on each of the machines.
     17
     18 * Following this, we (John, Roger, Gene, myself) all came in at 09:00 to diagnose and fix the issue. First, we looked at the dump of processlist on ippc75:
     19{{{
     20mysql -h localhost -u root -e "show processlist" > neb.proc.20190318
     21}}}
     22  This showed 64 connections from ippc76, which is not on the list of nebservers (see ~ippitc/ippconfig/nebservers.csh) and also showed soem connections from ippc28.
     23  Looking at the configuration file /etc/apache2/modules.d/apache2-mod_perl-startup.pl showed 256 MaxClients connections set up for the compute nodes. Machine ippc76 has StartServers = 64, so it will start with normally 64 connections, but could go up to 256 total. Combining all machines, this results in a max of 1349 connections, which is a lot.
     24
     25 Looking at the max connections in MYSQL using:
     26{{{
     27select @@max_connections;
     28}}}
     29 shows that the maximum is set to 1024, which is less than 1349, so that could be a reason for the failure.
     30 We are setting that higher now, to avoid this issue:
     31{{{
     32SET GLOBAL max_connections = 2048 (in mysql)
     33}}}
     34
     35 The full reason for the break is not totally clear, but the huge load spikes on the apache servers roughly coincide with ippb18 going down, so that might well be related.
     36
     37 For now, we are setting the apache servers back to on, using:
     38{{{
     39/etc/init.d/apache2 start
     40}}}
     41 as root on each of the machines.
     42
     43 Finally, the pantasks, are set back to run using:
     44{{{
     45check_system.sh run
     46}}}
     47
     48=== Tuesday : 2019.03.19 ===
     49
     50=== Wednesday : 2019.03.20 ===
     51
     52=== Thursday : 2019.03.21 ===
     53
     54=== Friday : 2019.03.22 ===
     55
     56=== Saturday : 2019.03.23 ===
     57
     58=== Sunday : 2019.03.24 ===