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/b63ae0a3-fc82-4a64-b53d-856d9a38c259n%40googlegroups.com.
