pt-mysql-summary does not work with MariaDB 10.2.5

General

Escalation

General

Escalation

Description

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
# Percona Toolkit MySQL Summary Report #######################
              System time | 2017-04-07 10:33:54 UTC (local TZ: +03 +0300)
# 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
# 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
# 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)
# 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

Environment

None

Smart Checklist

Activity

Show:

Celian COSTES November 24, 2017 at 8:49 PM

Last syslog with pt-mysql-summary :

Nov 24 21:44:12 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,49457,0,CONNECT,,,0
Nov 24 21:44:12 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,49457,434517,QUERY,,'select @@version_comment limit 1',0
Nov 24 21:44:12 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,49457,434518,QUERY,,'SHOW /*!50000 GLOBAL*/ STATUS',0
Nov 24 21:44:12 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,49457,0,DISCONNECT,,,0

Celian COSTES November 24, 2017 at 8:38 PM

sorry, for syslog is pmm-client's logs

Celian COSTES November 24, 2017 at 8:09 PM

with:

Nov 24 21:08:27 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47350,0,DISCONNECT,,,0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,0,CONNECT,,,0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416705,QUERY,,'SELECT @@max_allowed_packet',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416706,QUERY,,'SET time_zone=\'+00:00\'',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416707,QUERY,,'SELECT @@version',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416708,QUERY,,'SHOW ENGINES',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416709,QUERY,,'SHOW ALL SLAVES STATUS',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416710,QUERY,,'SELECT COALESCE(command,\'\'),COALESCE(state,\'\'),count(*),sum(time) FROM information_schema.processlist WHERE ID != connection_id() AND TIME >= 0 GROUP BY command,state ORDER BY null',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416711,READ,performance_schema,events_waits_summary_global_by_event_name,
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416711,QUERY,performance_schema,'SELECT EVENT_NAME, COUNT_STAR, SUM_TIMER_WAIT FROM performance_schema.events_waits_summary_global_by_event_name',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416712,READ,performance_schema,file_summary_by_event_name,
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416712,QUERY,performance_schema,'SELECT EVENT_NAME, COUNT_READ, SUM_TIMER_READ, SUM_NUMBER_OF_BYTES_READ, COUNT_WRITE, SUM_TIMER_WRITE, SUM_NUMBER_OF_BYTES_WRITE, COUNT_MISC, SUM_TIMER_MISC FROM performance_schema.file_summary_by_event_name',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,416713,QUERY,performance_schema,'SELECT @@query_response_time_stats',0
Nov 24 21:08:28 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47351,0,DISCONNECT,,,0

Celian COSTES November 24, 2017 at 8:07 PM

Message in loop in the syslog :

Nov 24 21:04:53 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47080,0,DISCONNECT,,,0
Nov 24 21:04:54 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,cmon,10.80.3.70,10,414510,QUERY,information_schema,'SHOW GLOBAL STATUS',0
Nov 24 21:04:54 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47081,0,CONNECT,,,0
Nov 24 21:04:54 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47081,414511,QUERY,,'SELECT @@max_allowed_packet',0
Nov 24 21:04:54 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47081,414512,QUERY,,'SET time_zone=\'+00:00\'',0
Nov 24 21:04:54 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47081,414513,QUERY,,'SELECT @@version',0
Nov 24 21:04:54 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47081,414514,QUERY,,'SHOW GLOBAL STATUS',0
Nov 24 21:04:54 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47081,414515,QUERY,,'SELECT name, subsystem, type, comment, count FROM information_schema.innodb_metrics WHERE status = \'enabled\'',0
Nov 24 21:04:54 TEST-VALID-DATA-01 mysql-server_auditing: TEST-VALID-DATA-01,pmm,localhost,47081,0,DISCONNECT,,,0

Celian COSTES November 24, 2017 at 7:57 PM

You're in luck. I still not

root@TEST-VALID-DATA-01:/data/mysql# pt-mysql-summary --version
pt-mysql-summary 3.0.5

MariaDB [(none)]> show variables like '%version%';
+-------------------------+------------------------------------------+
| Variable_name           |                                    Value |
+-------------------------+------------------------------------------+
| innodb_version          |                                   5.7.20 |
| protocol_version        |                                       10 |
| slave_type_conversions  |                                          |
| version                 | 10.2.10-MariaDB-10.2.10+maria~xenial-log |
| version_comment         |          mariadb.org binary distribution |
| version_compile_machine |                                   x86_64 |
| version_compile_os      |                         debian-linux-gnu |
| version_malloc_library  |                                   system |
| version_ssl_library     |                OpenSSL 1.0.2g 1 Mar 2016 |
| wsrep_patch_version     |                              wsrep_25.20 |
+-------------------------+------------------------------------------+

// code placeholder
root@TEST-VALID-DATA-01:/data/mysql# pt-mysql-summary --host localhost --user pmm --password pmm
# Percona Toolkit MySQL Summary Report #######################
System time | 2017-11-24 19:55:48 UTC (local TZ: CET +0100)
# Instances ##################################################
Port Data Directory Nice OOM Socket
===== ========================== ==== === ======
0 0
# MySQL Executable ###########################################
Path to executable | /usr/sbin/mysqld
Has symbols |
# Slave Hosts ################################################
No slaves found
# Report On Port 3306 ########################################
User | pmm@localhost
Time | 2017-11-24 20:55:46 (CET)
Hostname | TEST-VALID-DATA-01
Version | 10.2.10-MariaDB-10.2.10+maria~xenial-log mariadb.org binary distribution
Built On | debian-linux-gnu x86_64
Started | 2017-11-24 10:47 (up 0+10:08:25)
Databases | 115
Datadir | /data/mysql/
Processes | 5 connected, 1 running
Replication | Is not a slave, has 0 slaves connected
Pidfile | /var/run/mysqld/mysqld.pid (exists)
# Processlist ################################################

Command COUNT(*) Working SUM(Time) MAX(Time)
------------------------------ -------- ------- --------- ---------
^C2017_11_24_20_55_54 Caught signal, forcing exit
root@TEST-VALID-DATA-01:/data/mysql#

Details
Assignee
Unassigned
Reporter
Carlos Salguero(Deactivated)
Priority
Medium
Affects versions
3.0.2
Reviewer
Sveta Smirnova

Smart Checklist

Created April 7, 2017 at 3:18 PM

Updated March 4, 2024 at 5:33 PM

pt-mysql-summary does not work with MariaDB 10.2.5

Description

Environment

Smart Checklist

Activity

Celian COSTES November 24, 2017 at 8:49 PM

Celian COSTES November 24, 2017 at 8:38 PM

Celian COSTES November 24, 2017 at 8:09 PM

Celian COSTES November 24, 2017 at 8:07 PM

Celian COSTES November 24, 2017 at 7:57 PM

Details
Assignee
Unassigned
Reporter
Carlos Salguero(Deactivated)
Priority
Medium
Affects versions
3.0.2
Reviewer
Sveta Smirnova

Details

Assignee

Reporter

Priority

Affects versions

Reviewer

Smart Checklist

Smart Checklist

Flag notifications

Something's gone wrong

Something's gone wrong

pt-mysql-summary does not work with MariaDB 10.2.5

Description

Environment

Smart Checklist

Activity

Celian COSTES November 24, 2017 at 8:49 PM

Celian COSTES November 24, 2017 at 8:38 PM

Celian COSTES November 24, 2017 at 8:09 PM

Celian COSTES November 24, 2017 at 8:07 PM

Celian COSTES November 24, 2017 at 7:57 PM

DetailsAssigneeUnassignedUnassignedReporterCarlos SalgueroCarlos Salguero(Deactivated)PriorityMediumAffects versions3.0.2ReviewerSveta SmirnovaSveta Smirnova

Details

Assignee

Reporter

Priority

Affects versions

Reviewer

Smart ChecklistOpen Smart Checklist

Smart Checklist

Flag notifications

Something's gone wrong

Something's gone wrong

Details
Assignee
Unassigned
Reporter
Carlos Salguero(Deactivated)
Priority
Medium
Affects versions
3.0.2
Reviewer
Sveta Smirnova

Smart Checklist