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/d831470c-0685-4acf-8a11-467a1d3cae0fn%40googlegroups.com.
