Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-4665

Errors in pmm-agent.log for MySQL instance

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Reopened
    • Affects Version/s: 2.0.0-beta7, 2.0.1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Sprint:
      Platform Sprint 27

      Description

      STR

      1. Install latest PMM2 (201909101921)
      2. Install pmm2-client from testing repository
      3. Add MySQL 5.7 (with enabled slow log)server to monitoring
      4. Open pmm-agent.log

      Given result: There are a lot of errors like:

       -11T00:12:16+03:00" level=error msg="Error scraping for collect.engine_tokudb_status: Error 1286: Unknown storage engine 'TOKUDB'" source="exporter.go:116"  agentID=/agent_id/46d9e943-20ed-43a1-b9c6-a5a0
      -11T00:12:16+03:00" level=error msg="Error scraping for collect.heartbeat: Error 1146: Table 'heartbeat.heartbeat' doesn't exist" source="exporter.go:116
       Server version: 5.7.25-0ubuntu0.16.04.2-log (Ubuntu)
      mysql> show engines;
      +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
      | Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
      +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
      | CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
      | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
      | InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
      | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
      | PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
      | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
      | ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
      | MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
      | FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
      +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
      9 rows in set (0.00 sec)
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                nailya.kutlubaeva Nailya Kutlubaeva
                Votes:
                0 Vote for this issue
                Watchers:
                15 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: