def test__get_server_pid():
"""
Test the logic looping through the processes searching for `mysqld`
"""
mysql_check = MySql(common.CHECK_NAME, {}, {})
mysql_check._get_pid_file_variable = mock.MagicMock(return_value=None)
mysql_check.log = mock.MagicMock()
dummy_proc = subprocess.Popen(["python"])
p_iter = psutil.process_iter
def process_iter():
"""
Wrap `psutil.process_iter` with a func killing a running process
while iterating to reproduce a bug in the pid detection.
We don't use psutil directly here because at the time this will be
invoked, `psutil.process_iter` will be mocked. Instead we assign it to
`p_iter` which is then part of the closure (see line above).
"""
for p in p_iter():
if dummy_proc.pid == p.pid:
dummy_proc.terminate()
dummy_proc.wait()
# continue as the original `process_iter` function
yield p
with mock.patch('stackstate_checks.mysql.mysql.psutil.process_iter',
process_iter):
with mock.patch('stackstate_checks.mysql.mysql.PROC_NAME',
'this_shouldnt_exist'):
# the pid should be none but without errors
assert mysql_check._get_server_pid(None) is None
assert mysql_check.log.exception.call_count == 0
def test_topology(topology, instance_basic):
mysql_check = MySql(common.CHECK_NAME, {}, {})
mysql_check.check(instance_basic)
topology.assert_snapshot(mysql_check.check_id, TopologyInstance("mysql", "mysql://mysql"),
components=[{"id": mysql_check._get_topology_hostname(common.HOST, common.PORT),
"type": "mysql", "data": {}}])
def test_complex_config_replica(aggregator, instance_complex):
mysql_check = MySql(common.CHECK_NAME, {}, {})
config = copy.deepcopy(instance_complex)
config['port'] = common.SLAVE_PORT
mysql_check.check(config)
# self.assertMetricTag('mysql.replication.seconds_behind_master', 'channel:default')
# Test service check
aggregator.assert_service_check('mysql.can_connect', status=MySql.OK,
tags=tags.SC_TAGS_REPLICA, count=1)
# Travis MySQL not running replication - FIX in flavored test.
aggregator.assert_service_check('mysql.replication.slave_running', status=MySql.OK,
tags=tags.SC_TAGS_REPLICA, at_least=1)
testable_metrics = (variables.STATUS_VARS + variables.VARIABLES_VARS +
variables.INNODB_VARS + variables.BINLOG_VARS +
variables.SYSTEM_METRICS + variables.SCHEMA_VARS +
variables.SYNTHETIC_VARS)
# Test metrics
for mname in testable_metrics:
# These two are currently not guaranteed outside of a Linux
# environment.
if mname == 'mysql.performance.user_time' and not Platform.is_linux():
continue
if mname == 'mysql.performance.kernel_time' and not Platform.is_linux():
continue
if mname == 'mysql.performance.cpu_time' and Platform.is_windows():
continue
if mname == 'mysql.performance.query_run_time.avg':
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS+['schema:testdb'], count=1)
elif mname == 'mysql.info.schema.size':
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS+['schema:testdb'], count=1)
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS+['schema:information_schema'], count=1)
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS+['schema:performance_schema'], count=1)
else:
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS, at_least=0)
# test custom query metrics
aggregator.assert_metric('alice.age', value=25)
aggregator.assert_metric('bob.age', value=20)
# test optional metrics
optional_metrics = (variables.OPTIONAL_REPLICATION_METRICS +
variables.OPTIONAL_INNODB_VARS +
variables.OPTIONAL_STATUS_VARS +
variables.OPTIONAL_STATUS_VARS_5_6_6)
_test_optional_metrics(aggregator, optional_metrics, 1)
# Raises when coverage < 100%
aggregator.assert_all_metrics_covered()
def test_topology_hostname():
mysql_check = MySql(common.CHECK_NAME, {}, {})
assert mysql_check._get_topology_hostname(
"localhost", common.PORT) == "stubbed.hostname"
assert mysql_check._get_topology_hostname("myhost",
0) == "stubbed.hostname"
assert mysql_check._get_topology_hostname("myhost",
common.PORT) == "myhost"
def test_connection_failure(aggregator, instance_error):
"""
Service check reports connection failure
"""
mysql_check = MySql(common.CHECK_NAME, {}, {}, instances=[instance_error])
with pytest.raises(Exception):
mysql_check.check(instance_error)
aggregator.assert_service_check('mysql.can_connect', status=MySql.CRITICAL,
tags=tags.SC_FAILURE_TAGS, count=1)
aggregator.assert_all_metrics_covered()
def test_minimal_config(aggregator, instance_basic):
mysql_check = MySql(common.CHECK_NAME, {}, {})
mysql_check.check(instance_basic)
# Test service check
aggregator.assert_service_check('mysql.can_connect', status=MySql.OK,
tags=tags.SC_TAGS_MIN, count=1)
# Test metrics
testable_metrics = (variables.STATUS_VARS + variables.VARIABLES_VARS + variables.INNODB_VARS +
variables.BINLOG_VARS + variables.SYSTEM_METRICS + variables.SYNTHETIC_VARS)
for mname in testable_metrics:
aggregator.assert_metric(mname, at_least=0)
def test_complex_config(aggregator, instance_complex):
mysql_check = MySql(common.CHECK_NAME, {}, {},
instances=[instance_complex])
mysql_check.check(instance_complex)
# Test service check
aggregator.assert_service_check('mysql.can_connect',
status=MySql.OK,
tags=tags.SC_TAGS,
count=1)
aggregator.assert_service_check('mysql.replication.slave_running',
status=MySql.OK,
tags=tags.SC_TAGS,
at_least=1)
ver = map(lambda x: int(x),
mysql_check.mysql_version[mysql_check._get_host_key()])
ver = tuple(ver)
testable_metrics = (variables.STATUS_VARS + variables.VARIABLES_VARS +
variables.INNODB_VARS + variables.BINLOG_VARS +
variables.SYSTEM_METRICS + variables.SCHEMA_VARS +
variables.SYNTHETIC_VARS)
if ver >= (5, 6, 0) and environ.get('MYSQL_FLAVOR') != 'mariadb':
testable_metrics.extend(variables.PERFORMANCE_VARS)
# Test metrics
for mname in testable_metrics:
# These two are currently not guaranteed outside of a Linux
# environment.
if mname == 'mysql.performance.user_time' and not Platform.is_linux():
continue
if mname == 'mysql.performance.kernel_time' and not Platform.is_linux(
):
continue
if mname == 'mysql.performance.cpu_time' and Platform.is_windows():
continue
if mname == 'mysql.performance.query_run_time.avg':
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS + ['schema:testdb'],
count=1)
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS + ['schema:mysql'],
count=1)
elif mname == 'mysql.info.schema.size':
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS + ['schema:testdb'],
count=1)
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS +
['schema:information_schema'],
count=1)
aggregator.assert_metric(mname,
tags=tags.METRIC_TAGS +
['schema:performance_schema'],
count=1)
else:
aggregator.assert_metric(mname, tags=tags.METRIC_TAGS, at_least=0)
# TODO: test this if it is implemented
# Assert service metadata
# version_metadata = mysql_check.service_metadata['version']
# assert len(version_metadata) == 1
# test custom query metrics
aggregator.assert_metric('alice.age', value=25)
aggregator.assert_metric('bob.age', value=20)
# test optional metrics
optional_metrics = (variables.OPTIONAL_REPLICATION_METRICS +
variables.OPTIONAL_INNODB_VARS +
variables.OPTIONAL_STATUS_VARS +
variables.OPTIONAL_STATUS_VARS_5_6_6)
_test_optional_metrics(aggregator, optional_metrics, 1)
# Raises when coverage < 100%
aggregator.assert_all_metrics_covered()