Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Info schema table statistics reporting metrics were already collected #373

Open
matejzero opened this issue Mar 25, 2019 · 0 comments
Open

Comments

@matejzero
Copy link

Host operating system: output of uname -a

Linux 3.10.0-957.10.1.el7.x86_64 #1 SMP Mon Mar 18 15:06:45 UTC 2019 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

mysqld_exporter, version 0.11.0 (branch: HEAD, revision: 5d7179615695a61ecc3b5bf90a2a7c76a9592cdd)
  build user:       root@3d3ff666b0e4
  build date:       20180629-15:00:35
  go version:       go1.10.3

MySQL server version

MariaDB 5.5.60

mysqld_exporter command line flags

/usr/local/sbin/mysqld_exporter --config.my-cnf=/home/mysqld-exporter/.my.cnf --collect.binlog_size --collect.engine_innodb_status --collect.info_schema.processlist --collect.info_schema.query_response_time --collect.info_schema.clientstats --collect.info_schema.tablestats --collect.info_schema.userstats --collect.slave_status --collect.slave_hosts

What did you do that produced an error?

Start the exporter on an already running mysql server

What did you expect to see?

Metrics being reported like on other mysql servers

What did you see instead?

Exporter return error 500 and a list of errors for which he already gathered metrics.

Example:

* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_read_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:4.552223e+06 >  was collected before with the same name and label values
* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_changed_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:802314 >  was collected before with the same name and label values
* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_changed_x_indexes_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:3.209256e+06 >  was collected before with the same name and label values
* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_read_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:1.050838e+06 >  was collected before with the same name and label values
* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_changed_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:87637 >  was collected before with the same name and label values
* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_changed_x_indexes_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:350548 >  was collected before with the same name and label values
* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_read_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:1.00216155e+08 >  was collected before with the same name and label values
* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_changed_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:2.03521e+06 >  was collected before with the same name and label values
* [from Gatherer #2] collected metric mysql_info_schema_table_statistics_rows_changed_x_indexes_total label:<name:"schema" value:"db_prod" > label:<name:"table" value:"db_backup_ids_temp" > counter:<value:8.14084e+06 >  was collected before with the same name and label values
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant