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

LP #1680803: pt-mysql-summary may get stuck when Time: NULL in processlist

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Sveta Smirnova last update 18-04-2017 21:33:03

      pt-mysql-summary hangs at the Processlist summary stage when connected to MariaDB 10.2.5:

      sveta@Thinkie:~/src/percona-toolkit$ pt-mysql-summary --socket=/home/sveta/mysql_packages/mariadb-10.2.5-linux-x86_64/mysql-test/var/tmp/mysqld.1.sock --user=root

      1. Percona Toolkit MySQL Summary Report #######################
        System time | 2017-04-07 10:33:54 UTC (local TZ: +03 +0300)
      2. Instances ##################################################
        Port Data Directory Nice OOM Socket
        ===== ========================== ==== === ======
        16000 /home/sveta/mysql_packages/mariadb-10.2.5-linux-x86_64/mysql-test/var/mysqld.1/data 0 0 /home/sveta/mysql_packages/mariadb-10.2.5-linux-x86_64/mysql-test/var/tmp/mysqld.1.sock
        3306 /var/lib/mysql 0 0 /var/run/mysqld/mysqld.sock
        3371 /home/sveta/mysql_packages/Percona-XtraDB-Cluster-5.7.16-rel10-27.19.1.Linux.x86_64.ssl100/data1 0 0 /tmp/pxc1.sock
        3373 /home/sveta/mysql_packages/Percona-XtraDB-Cluster-5.7.16-rel10-27.19.1.Linux.x86_64.ssl100/data3 0 0 /tmp/pxc3.sock
        3374 /home/sveta/mysql_packages/Percona-XtraDB-Cluster-5.7.16-rel10-27.19.1.Linux.x86_64.ssl100/data4 0 0 /tmp/pxc4.sock
        3372 /home/sveta/mysql_packages/Percona-XtraDB-Cluster-5.7.16-rel10-27.19.1.Linux.x86_64.ssl100/data2 0 0 /tmp/pxc2.sock
      3. MySQL Executable ###########################################
        Path to executable | ./bin/mysqld
        Has symbols | Yes
        Path to executable | /home/sveta/mysql_packages/mariadb-10.2.5-linux-x86_64/bin/mysqld
        Has symbols | Yes
        Path to executable | /usr/sbin/mysqld
        Has symbols | Yes
      4. Report On Port 16000 #######################################
        User | root@localhost
        Time | 2017-04-07 13:33:54 (+03)
        Hostname | Thinkie
        Version | 10.2.5-MariaDB-log MariaDB Server
        Built On | Linux x86_64
        Started | 2017-04-07 13:31 (up 0+00:01:56)
        Databases | 5
        Datadir | /home/sveta/mysql_packages/mariadb-10.2.5-linux-x86_64/mysql-test/var/mysqld.1/data/
        Processes | 1 connected, 1 running
        Replication | Is not a slave, has 0 slaves connected
        Pidfile | /home/sveta/mysql_packages/mariadb-10.2.5-linux-x86_64/mysql-test/var/run/mysqld.1.pid (exists)
      5. Processlist ################################################

      Command COUNT Working SUM(Time) MAX(Time)
      ------------------------------ -------- ------- --------- ---------

      ^C2017_04_07_13_50_17 Caught signal, forcing exit

      Tested with versions 2.2.20 and 3.0.2

        Attachments

          Activity

            People

            • Assignee:
              carlos.salguero Carlos Salguero
              Reporter:
              lpjirasync lpjirasync (Inactive)
            • Votes:
              1 Vote for this issue
              Watchers:
              6 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 - 20 minutes
                20m