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

qan_mysql_perfschema_agent fails querying events_statements_summary_by_digest due to data types conversion

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.0.1
    • Component/s: PMM Agent, QAN Agent
    • Labels:
      None

      Description

      The qan-mysql-perfschema-agent fails with error messages like:

      Sep 27 11:31:00 mtrac28316 pmm-agent: #033[31mERRO#033[0m[2019-09-27T11:31:00.010+02:00] failed to query events_statements_summary_by_digest: sql: Scan error on column index 4, name "SUM_TIMER_WAIT": converting driver.Value type []uint8 ("12961551634723847000") to a int64: value out of range  #033[31magentID#033[0m=/agent_id/3abf5b2e-1e28-4dd7-bbe0-5a0863c2ef2a #033[31mcomponent#033[0m=agent-builtin #033[31mtype#033[0m=qan_mysql_perfschema_agent 

      due to the data types mapping done in the 'eventsStatementsSummaryByDigestView' of file 'agents/mysql/perfschema/models_reform.go' as it tries to map bigint(20) unsigned types into int64 types.

      This is because, at least in MySQL Server version: 5.7.15-log MySQL Community Server (GPL), most of the performance_schema.events_statements_summary_by_digest columns are of type 'bigint(20) unsigned' and the mentioned view tries to map them to 'int64' types. 

      I'm using pmm-admin version

      ProjectName: pmm-admin
      Version: 2.0.0
      PMMVersion: 2.0.0
      Timestamp: 2019-09-18 16:28:16 (UTC)
      FullCommit: ff98b6c4531ca9c923544e09aa02520005559c6a
      

      in CentOS Linux release 7.6.1810 (Core)

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  margaash David Collados
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 40 minutes
                    40m