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

Query Analytics produced errors on large truncated queries

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: 1.5.3
    • Fix Version/s: 1.8.1
    • Component/s: QAN Agent, QAN API
    • Labels:
      None

      Description

      Query is truncated with .. based on arbitrary length. QAN doesn't deal with it well and not only can you not see the whole query, but underneath, it throws these errors:

       cmd 'Explain' for subsystem 'mysql' failed: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '..' at line 210 

       

      TODO: 
      display message like : 'Cannot explain truncated query. This query was truncated to maximum size of  10240  bytes.' instead of  Error 

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  manjot.singh Manjot Singh (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

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