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

Don't execute queries for invalid parameters

Details

    • Improvement
    • Status: Open
    • Medium
    • Resolution: Unresolved
    • None
    • None
    • None
    • Yes
    • Yes

    Description

      https://forums.percona.com/t/multiple-errors-from-pmm-in-the-mariadb-sql-error-log-file/24323/4

      The issue here is that PMM is repeatedly sending queries to the client database that will always result in error. PMM should be much smarter with regard to the client database flavor/version.

      For example, "Unknown system variable ‘slow_query_log_always_write_time" in MariaDB 10.4. PMM should detect that the client is running MariaDB 10.4 and NOT execute that query in the first place. The forums post noted above has other examples of commands/variables that are not supported in MariaDB and thus they are logged as error SQL in MariaDB from PMM.

      Attachments

        Activity

          People

            Unassigned Unassigned
            matthew.boehm@percona.com Matthew Boehm
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Smart Checklist