| | 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 | {{{ |
| | 10 | check_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 | {{{ |
| | 20 | mysql -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 | {{{ |
| | 27 | select @@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 | {{{ |
| | 32 | SET 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 | {{{ |
| | 45 | check_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 === |