Is it possible to ignore from Prometheus exporter config. On Fri, Jan 14, 2022, 6:56 PM Brian Candler <[email protected]> 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.check_user_name" is > exposed as "validate_password_check_user_name", and duplicates the real > "validate_password_check_user_name" > > On Friday, 14 January 2022 at 09:59:06 UTC [email protected] wrote: > >> >> SHOW GLOBAL VARIABLES LIKE 'validate_password%'; >> +--------------------------------------+--------+ >> | Variable_name | Value | >> +--------------------------------------+--------+ >> | validate_password.check_user_name | ON | >> | validate_password.dictionary_file | | >> | validate_password.length | 8 | >> | validate_password.mixed_case_count | 1 | >> | validate_password.number_count | 1 | >> | validate_password.policy | MEDIUM | >> | validate_password.special_char_count | 1 | >> | validate_password_check_user_name | ON | >> | validate_password_dictionary_file | | >> | validate_password_length | 8 | >> | validate_password_mixed_case_count | 1 | >> | validate_password_number_count | 1 | >> | validate_password_policy | MEDIUM | >> | validate_password_special_char_count | 1 | >> +--------------------------------------+--------+ >> >> >> >> On Friday, 14 January 2022 at 13:05:42 UTC+5:30 Sai Krishna wrote: >> >>> >>> 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:<value:1 >>> > } was collected before with the same name and label values * [from >>> Gatherer #2] collected metric >>> "mysql_global_variables_validate_password_length" { gauge:<value:8 > } was >>> collected before with the same name and label values * [from Gatherer #2] >>> collected metric >>> "mysql_global_variables_validate_password_mixed_case_count" { >>> gauge:<value:1 > } was collected before with the same name and label values >>> * [from Gatherer #2] collected metric >>> "mysql_global_variables_validate_password_number_count" { gauge:<value:1 > >>> } was collected before with the same name and label values * [from Gatherer >>> #2] collected metric >>> "mysql_global_variables_validate_password_special_char_count" { >>> gauge:<value:1 > } was collected before with the same name and label values >>> * [from Gatherer #2] collected metric >>> "mysql_global_status_validate_password_dictionary_file_words_count" { >>> untyped:<value:0 > } was collected before with the same name and label >>> values* >>> >>> >>> >>> >>> On Friday, 14 January 2022 at 02:22:04 UTC+5:30 [email protected] >>> wrote: >>> >>>> 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/50a86f38-6af9-4dc3-b38e-56197656e439n%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/50a86f38-6af9-4dc3-b38e-56197656e439n%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/CAAG-GetfUJZM0x2UCD_zE0upa794cmd44BM67hP57JoSt%2BEDjw%40mail.gmail.com.
