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 validate_password_check_user_name, and (as of MySQL 8), a component, using variables like validate_password.check_user_name. The exporter might normalize both to the same metric name, causing the issue. If that is the case, the SHOW GLOBAL VARIABLES will reveal it. Remove the duplicate (plugin) configuration as per the documentation [1] /MR [1] https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html On Thu, Jan 13, 2022, 21:36 Brian Candler <[email protected]> wrote: > 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 > > *mysql_global_variables_validate_password_check_user_name{foo="abc"} 1* > *...* > *mysql_global_variables_validate_password_check_user_name{foo="abc"} 1* > > Either that, or your scrape job is scraping the same exporter multiple > times. > > On Thursday, 13 January 2022 at 20:18:06 UTC [email protected] wrote: > >> Hello everyone, >> >> Would appreciate any quick assistance in below error. I have upgraded my >> exporter from 0.12.0 to 0.13.0 but this did not help. Did someone fixed >> this before? >> >> >> >> *6 error(s) occurred:* [from Gatherer #2] collected metric >> "mysql_global_variables_validate_password_check_user_name" { gauge:<value:1 >> > } was collected before with the same name and label values* >> >> >> - Sai >> > -- > You received this message because you are subscribed to the Google Groups > "Prometheus Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/prometheus-users/dc4c8d69-bc6e-4a3f-95bc-0b0d950048bcn%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/dc4c8d69-bc6e-4a3f-95bc-0b0d950048bcn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAMV%3D_gbB1XFEWBmhN5_zc%2BPHa69XExFsQ5V-fmhpAVQUmLN_oA%40mail.gmail.com.
