Интернет |
Unknown graph at /usr/local/etc/munin/plugins/mysql_ line 1042
Добрый вечер.
Подскажите пожалуйста как решить эту проблему.
Та же проблема.
Система FreeBSD12
mysql 5.6
munin-common-2.0.49
munin-node-2.0.49_2
Остальные графики нормально рисуются.
Ошибка
Лог мунина.
Кусок кода /usr/local/etc/munin/plugins/mysql_
Жирным я выделил строку 1010 и 1042
Подскажите пожалуйста как решить эту проблему.
Та же проблема.
Система FreeBSD12
mysql 5.6
munin-common-2.0.49
munin-node-2.0.49_2
Остальные графики нормально рисуются.
Ошибка
Код:
munin-run mysql_
Unknown graph at /usr/local/etc/munin/plugins/mysql_ line 1042.
Код:
root@BASE:/usr/local/etc/munin/plugins # munin-run -d mysql_
# Processing plugin configuration from /usr/local/etc/munin/plugin-conf.d/plugins.conf
# Setting /rgid/ruid/ to /842/0/
# Setting /egid/euid/ to /842 842/0/
# Setting up environment
# Environment mysqladmin = /usr/local/bin/mysqladmin
# Environment PATH = /usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
# Environment mysqlopts = -u munin -pмой пароль
# Environment mysqlpassword = мой пароль
# Environment mysqluser = munin
# Environment mysqlconnection = DBI:mysql:mysql;host=localhost;port=3306
# Environment mysqlshow = /usr/local/bin/mysqlshow
# About to run '/usr/local/etc/munin/plugins/mysql_'
Unknown graph at /usr/local/etc/munin/plugins/mysql_ line 1042.
root@BASE:/usr/local/etc/munin/plugins #
Код:
2019/10/19-18:02:11 [12527] Error output from mysql_:
2019/10/19-18:02:11 [12527] Unknown graph at /usr/local/etc/munin/plugins/mysql_ line 1010.
2019/10/19-18:02:11 [12527] Service 'mysql_' exited with status 255/0.
2019/10/19-18:02:12 [12527] Error output from mysql_:
2019/10/19-18:02:12 [12527] Unknown graph at /usr/local/etc/munin/plugins/mysql_ line 1042.
2019/10/19-18:02:12 [12527] Service 'mysql_' exited with status 255/0.
Жирным я выделил строку 1010 и 1042
Код:
sub config {
my $graph_name = shift;
# In MySQL 5.1 (and probably erlier versions as well) status
# variables are unique when looking at the last 19 characters.
#
# SELECT RIGHT(variable_name, 19), COUNT(*)
# FROM information_schema.global_status
# GROUP BY RIGHT(variable_name, 19)
# HAVING COUNT(*) > 1;
#
# Empty set (0.06 sec)
#
# There is one duplicate when looking at server variables
#
# SELECT RIGHT(variable_name, 19), COUNT(*)
# FROM information_schema.global_variables
# GROUP BY RIGHT(variable_name, 19)
# HAVING COUNT(*) > 1;
#
# +--------------------------+----------+
# | RIGHT(variable_name, 19) | COUNT(*) |
# +--------------------------+----------+
# | OW_PRIORITY_UPDATES | 2 |
# +--------------------------+----------+
# 1 row in set (0.05 sec)
#
# show global variables like '%OW_PRIORITY_UPDATES';
#
# +--------------------------+-------+
# | Variable_name | Value |
# +--------------------------+-------+
# | low_priority_updates | OFF |
# | sql_low_priority_updates | OFF |
# +--------------------------+-------+
# 2 rows in set (0.00 sec)
#
# Not a problem since we don't graph these
update_data();
die 'Unknown graph ' . ($graph_name ? $graph_name : '')
unless $graphs{$graph_name}; строка 1010
my $graph = $graphs{$graph_name};
my %conf = (%{$defaults{global_attrs}}, %{$graph->{config}{global_attrs}});
while (my ($k, $v) = each %conf) {
print "graph_$k $v\n";
}
print "graph_category mysql2\n";
for my $ds (@{$graph->{data_sources}}) {
my %ds_spec = (
%{$defaults{data_source_attrs}},
%{$graph->{config}{data_source_attrs}},
%$ds,
);
while (my ($k, $v) = each %ds_spec) {
# 'name' is only used internally in this script, not understood by munin.
printf("%s.%s %s\n", clean_fieldname($ds->{name}), $k, $v) unless ($k eq 'name');
}
print_thresholds(clean_fieldname($ds->{name}));
}
return 0;
}
sub show {
my $graph_name = shift;
update_data();
die 'Unknown graph ' . ($graph_name ? $graph_name : '')
unless $graphs{$graph_name}; Строка 1042
my $graph = $graphs{$graph_name};
die "Can't show data for '$graph_name' because InnoDB is disabled."
if $graph_name =~ /innodb_/ && $data->{_innodb_disabled};
for my $ds (@{$graph->{data_sources}}) {
my $value = exists $ds->{value}
? $ds->{value}($data)
: $data->{$ds->{name}};
printf "%s.value %s\n", clean_fieldname($ds->{name}), defined($value) ? $value : 'U';
}
return 0;
}
Цитата:
root@BASE:/usr/local/etc/munin/plugins # ls -al | awk '{print $9,$10,$11}' cpu -> /usr/local/share/munin/plugins/cpu if_igb0 -> /usr/local/share/munin/plugins/if_igb0 if_igb1 -> /usr/local/share/munin/plugins/if_igb1 iostat -> /usr/local/share/munin/plugins/iostat memory -> /usr/local/share/munin/plugins/memory mysql_ -> /usr/local/share/munin/plugins/mysql_ mysql_bytes -> /usr/local/share/munin/plugins/mysql_bytes mysql_connections -> /usr/local/share/munin/plugins/mysql_connections mysql_connections_per_user -> /usr/local/share/munin/plugins/mysql_connections_per_user mysql_keys -> /usr/local/share/munin/plugins/mysql_keys mysql_qcache -> /usr/local/share/munin/plugins/mysql_qcache mysql_qcache_hits -> /usr/local/share/munin/plugins/mysql_qcache_hits mysql_qcache_mem -> /usr/local/share/munin/plugins/mysql_qcache_mem mysql_threads -> /usr/local/share/munin/plugins/mysql_threads vmstat -> /usr/local/share/munin/plugins/vmstat |