Last modified: 2014-08-25 17:11:11 UTC
I'm getting this error for the past ~30 minutes: Could not connect to database: Host '10.68.17.174' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
It is node: tools-webgrid-04 which is currently blocked by tools-db. All other nodes seem to be ok atm. A db-admin has to issue the FLUSH HOSTS command: But prior to that, maybe assess the culprit-app. As an /emergency/ workaround, you could repeatedly restart your webservice until it's no longer on tools-webgrid-04. https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Overview#Sun_Grid_Engine_.28SGE.29
For the past few weeks, web services have continually died. Big Brother does restart it. However, on which webgrid node things restart on can be random. Long story short, a good part of the day I'm on tools-webgrid-04, thus dead in the water.
flush hosts done.