Re: [prometheus-users] Re: Prometheus mysqld_exporter failing with errors.

2022-01-14 Thread Sai Krishna
Is it possible to ignore from Prometheus exporter config. On Fri, Jan 14, 2022, 6:56 PM Brian Candler wrote: > You can see you have both "validate_password.check_user_name" and > "validate_password_check_user_name". That's the problem. > > Metric names cannot have dots, so "validate_password.ch

Re: [prometheus-users] Re: Prometheus mysqld_exporter failing with errors.

2022-01-14 Thread Brian Candler
You can see you have both "validate_password.check_user_name" and "validate_password_check_user_name". That's the problem. Metric names cannot have dots, so "validate_password.check_user_name" is exposed as "validate_password_check_user_name", and duplicates the real "validate_password_check_

Re: [prometheus-users] Re: Prometheus mysqld_exporter failing with errors.

2022-01-14 Thread Sai Krishna
Its weird that all other exporters with same versions working fine. On Friday, 14 January 2022 at 15:29:06 UTC+5:30 Sai Krishna wrote: > > SHOW GLOBAL VARIABLES LIKE 'validate_password%'; > +--++ > | Variable_name| Value | > +-

Re: [prometheus-users] Re: Prometheus mysqld_exporter failing with errors.

2022-01-14 Thread Sai Krishna
SHOW GLOBAL VARIABLES LIKE 'validate_password%'; +--++ | Variable_name| Value | +--++ | validate_password.check_user_name| ON | | validate_password.dictionary_file||

Re: [prometheus-users] Re: Prometheus mysqld_exporter failing with errors.

2022-01-13 Thread Sai Krishna
Thanks Matt and Brain, I'm seeing this in MySQL 8.0.21 and 8.0.25. Out of 100 servers, only 4 servers giving this error. An error has occurred while serving metrics: *6 error(s) occurred: * [from Gatherer #2] collected metric "mysql_global_variables_validate_password_check_user_name" { gauge

Re: [prometheus-users] Re: Prometheus mysqld_exporter failing with errors.

2022-01-13 Thread Matthias Rampke
This may be caused by the mysqld exporter invalidly conflating multiple variables. Can you please share what your MySQL version is, and what you get from SHOW GLOBAL VARIABLES LIKE 'validate_password%'; >From a quick read, it seems that there is both a plugin, using configuration variables like

[prometheus-users] Re: Prometheus mysqld_exporter failing with errors.

2022-01-13 Thread Brian Candler
It says that your scrape job is seeing the same metric multiple times with the same labels. Scrape your exporter directly with curl, and I'm guessing you'll see *mysql_global_variables_validate_password_check_user_name 1* *...* *mysql_global_variables_validate_password_check_user_name 1* or *m