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

LP #1206728: pt-deadlock-logger 2.2 requires DSN on command line

    Details

      Description

      **Reported in Launchpad by Mike Siekkinen last update 17-10-2013 06:40:32

      My percona toolkit installation was upgraded from 2.1.9 to 2.2.4 today and pt-deadlock-logger began failing.

      It's failing with the error:

      -----------------------------------------------------------------------------------------------------------------------------------------------
      pt-deadlock-logger logs information about MySQL deadlocks on the given DSN.
      Information is printed to C<STDOUT>, and it can also be saved to a table by
      specifying L<"-dest">. The tool runs for forever unless L<"-run-time"> or
      L<"--iterations"> is specified. For more details, please use the --help option,
      or try 'perldoc /usr/bin/pt-deadlock-logger' for complete documentation.
      Usage: pt-deadlock-logger [OPTIONS] DSN

      Errors in command-line arguments:

      • No DSN was specified.
        -----------------------------------------------------------------------------------------------------------------------------------------------

      Nothing was changed with my configuration or db permissions. The command line call looks like

      /usr/bin/pt-deadlock-logger --config /home/mon/pt-deadlock-logger/pt-deadlock.conf

      -----------------------------------------------------------------------------------------------------------------------------------------------

      1. Start DSN options for connection to server you want to monitor
        h=localhost
        S=/var/lib/mysql/mysql.sock
        u=user
        p=pass
      2. End DSN

      interval=1s # Time interval to poll samples. Since I didn't specify a run-time param this should run forever

      1. This is destination DSN information. I didn't specify a username or
      2. password so it inherits those credentials from the DSN definition at the top
        dest=D=deadlocksdb,t=deadlock,h=dbserver,P=3320
        -----------------------------------------------------------------------------------------------------------------------------------------------

      I reviewed the latest docs and didn't see anyting about a change in the dest param or DSN format.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: