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

Query Abstract adds wrong schema when schema is not detected

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 1.8.1, 1.14.1
    • Fix Version/s: None
    • Component/s: PMM Client, QAN Agent
    • Labels:

      Description

      Similar to PMM-1928.

      When QAN fails to detect the schema, the Query Abstract show wrong schema. In this case the Tables section for the query shows ``.`_object_state` and the CREATE section below shows: " SHOW CREATE TABLE _object_state: Error 1046: No database selected".

      The fingerprint in this case is:

      "SELECT `os` . * FROM `_object_state` `os` JOIN `_object_state` `pos` ON `os` . `from_object_state_id` = `pos` . `object_state_id` WHERE `os` . `object_id` = ? AND `pos` . `state_id` = ? ORDER BY `os` . `object_state_id` DESC LIMIT ?"

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  fredricj Fredric
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated: