From: Ilya <ilyamaschenko@gmail.com>
Date: Thu, 9 Mar 2017 07:31:38 +0000 (+0900)
Subject: mysql_plugin: remove slave query if query returned no data
X-Git-Tag: ab-debian_0.20170316.01-0ab1~1^2~6^2~4
X-Git-Url: https://arthur.barton.de/cgi-bin/gitweb.cgi?p=netdata.git;a=commitdiff_plain;h=9b08c45ee44e2e1e485b1e33dbabae15ea3504e9

mysql_plugin: remove slave query if query returned no data
---

diff --git a/python.d/mysql.chart.py b/python.d/mysql.chart.py
index f755511a..abf6bf71 100644
--- a/python.d/mysql.chart.py
+++ b/python.d/mysql.chart.py
@@ -425,12 +425,14 @@ class Service(MySQLService):
             if 'Threads_created' in to_netdata and 'Connections' in to_netdata:
                 to_netdata['Thread_cache_misses'] = round(int(to_netdata['Threads_created']) / float(to_netdata['Connections']) * 10000)
 
-        if 'slave_status' in raw_data and raw_data['slave_status'][0]:
-            slave_raw_data = dict(zip([e[0] for e in raw_data['slave_status'][1]], raw_data['slave_status'][0][0]))
-
-            for key, function in SLAVE_STATS:
-                if key in slave_raw_data:
-                    to_netdata[key] = function(slave_raw_data[key])
+        if 'slave_status' in raw_data:
+            if raw_data['slave_status'][0]:
+                slave_raw_data = dict(zip([e[0] for e in raw_data['slave_status'][1]], raw_data['slave_status'][0][0]))
+                for key, function in SLAVE_STATS:
+                    if key in slave_raw_data:
+                       to_netdata[key] = function(slave_raw_data[key])
+            else:
+                self.queries.pop('slave_status')
 
         return to_netdata or None