Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1900

Pt-query-digest not hiding parameter properly sometimes when parameter=binary

    XMLWordPrintable

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 3.2.1
    • 3.4.0
    • None
    • None
    • Yes
    • 1

    Description

      I have attached a couple examples that when parsed with pt-query-digest will generate the following output:

       

      buggy output:

      {"classes":[{"attribute":"fingerprint","checksum":"C613002B5E02F1674B687C7FAF61088D",... where contact_id = 'Ì<?>\\\\¬^f<?>?<?>ä³Ël\\\\½\\ order by created_at desc,...

      non buggy:

      {"classes":

      [{"attribute":"fingerprint","checksum":"4770E236056DD53DC214129CD221A0B4"... where contact_id = ? order by created_at desc,...

      It can be seen that on bugged version "contact_id" has a value, whereas on non bugged , parameter shown is "?".

       

      Command used for parsing file is:

      pt-query-digest --limit=0% --output json-anon --filter=" \$event->{Bytes} = length(\$event->{arg}) and \$event->{hostname}=\"foo\"" buggy_example.txt > sample.out

       

       

      Attachments

        Activity

          People

            carlos.salguero Carlos Salguero (Inactive)
            carlos.tutte Carlos Tutte
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist