Announcement

Announcement Module
Collapse
No announcement yet.

pt-table-checksum: Use of uninitialized value $host in concatenation (.) or string

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum: Use of uninitialized value $host in concatenation (.) or string

    Hi there,

    I am trying to learn Percona Toolkit and I stuck with an error when running "pt-table-checksum" command. I already have a 3 node cluster (1 garbd + 2 percona "real" nodes) and I get an error while trying to run the following command:

    Code:
    root@draco01:~# pt-table-checksum --recursion-method=cluster --replicate-check-only
    Use of uninitialized value $host in concatenation (.) or string at /usr/bin/pt-table-checksum line 3765.
    I ran the same with debugging to try to get some clue with no luck:

    Code:
    root@draco01:~# PTDEBUG=1 pt-table-checksum --recursion-method=cluster --replicate-check-only
    # /usr/bin/perl 5.014002
    # Linux draco01 3.2.0-4-amd64 #1 SMP Debian 3.2.51-1 x86_64 GNU/Linux
    # Arguments: _[--recursion-method=cluster]_ _[--replicate-check-only]_
    (...)
    #  $DBD::mysql::VERSION: 4.021 $DBI::VERSION: 1.622
    # Cxn:3578 1152 DBI::db=HASH(0x24e8530) Setting dbh
    # Cxn:3583 1152 DBI::db=HASH(0x24e8530) SELECT @@server_id /*!50038 , @@hostname*/
    # Cxn:3585 1152 DBI::db=HASH(0x24e8530) hostname: draco01 0
    # VersionParser:4139 1152 VersionParser got a dbh, trying to get the version
    # VersionParser:4187 1152 InnoDB support: DEFAULT
    # VersionParser:4199 1152 InnoDB version: 5.5.34-rel32.0
    # pt_table_checksum:9094 1152 DBI::db=HASH(0x24e8530) SELECT @@binlog_format
    # pt_table_checksum:9096 1152 Original binlog_format: ROW
    # pt_table_checksum:9100 1152 DBI::db=HASH(0x24e8530) /*!50108 SET @@binlog_format := 'STATEMENT'*/
    # pt_table_checksum:9127 1152 DBI::db=HASH(0x24e8530) SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
    # Cxn:3566 1152 DBI::db=HASH(0x24e8530) Connected dbh to draco01 h=localhost
    # Percona::XtraDB::Cluster:3720 1152 draco01 SHOW VARIABLES LIKE 'wsrep_on'
    # Percona::XtraDB::Cluster:3722 1152 $VAR1 = [
    #   'wsrep_on',
    #   'ON'
    # ];
    #
    # Percona::XtraDB::Cluster:3711 1152 draco01 SHOW VARIABLES LIKE 'wsrep_cluster_name'
    # VersionParser:4139 1152 VersionParser got a dbh, trying to get the version
    # VersionParser:4187 1152 InnoDB support: DEFAULT
    # VersionParser:4199 1152 InnoDB version: 5.5.34-rel32.0
    # pt_table_checksum:9256 1152 Cxn=HASH(0x24def80) DBI::db=HASH(0x24e8530) SELECT @@server_id
    # Percona::XtraDB::Cluster:3754 1152 SHOW STATUS LIKE 'wsrep\_incoming\_addresses'
    # Percona::XtraDB::Cluster:3756 1152 Cluster nodes found:  192.168.10.210:3306,,192.168.10.211:3306
    # DSNParser:1405 1152 Parsing h=192.168.10.210,P=3306
    (...)
    # DSNParser:1518 1152 DBI:mysql:;host=192.168.10.210;port=3306;mysql_read_default_group=client
    # DSNParser:1567 1152 DBI:mysql:;host=192.168.10.210;port=3306;mysql_read_default_group=client   undef   undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0
    # DSNParser:1595 1152 DBI::db=HASH(0x24f00a8) SELECT @@SQL_MODE
    # DSNParser:1726 1152 DBI::db=HASH(0x24f00a8) SET SESSION innodb_lock_wait_timeout=1
    # DSNParser:1726 1152 DBI::db=HASH(0x24f00a8) SET SESSION wait_timeout=10000
    # DSNParser:1626 1152 DBI::db=HASH(0x24f00a8) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/
    # DSNParser:1635 1152 DBH info:  DBI::db=HASH(0x24f00a8) $VAR1 = {
    #   '@@hostname' => 'draco01',
    #   'CONNECTION_ID()' => '154',
    #   'DATABASE()' => undef,
    #   'VERSION()' => '5.5.34-31.1-log'
    # };
    (...)
    #  $DBD::mysql::VERSION: 4.021 $DBI::VERSION: 1.622
    # Percona::XtraDB::Cluster:3779 1152 Connected to P=3306,h=192.168.10.210
    (...)
    # DSNParser:1518 1152 DBI:mysql:;host=192.168.10.210;port=3306;mysql_read_default_group=client
    # DSNParser:1567 1152 DBI:mysql:;host=192.168.10.210;port=3306;mysql_read_default_group=client   undef   undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0
    # DSNParser:1595 1152 DBI::db=HASH(0x24ef970) SELECT @@SQL_MODE
    # DSNParser:1726 1152 DBI::db=HASH(0x24ef970) SET SESSION innodb_lock_wait_timeout=1
    # DSNParser:1726 1152 DBI::db=HASH(0x24ef970) SET SESSION wait_timeout=10000
    # DSNParser:1626 1152 DBI::db=HASH(0x24ef970) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/
    # DSNParser:1635 1152 DBH info:  DBI::db=HASH(0x24ef970) $VAR1 = {
    #   '@@hostname' => 'draco01',
    #   'CONNECTION_ID()' => '155',
    #   'DATABASE()' => undef,
    #   'VERSION()' => '5.5.34-31.1-log'
    # };
    (...)
    #  $DBD::mysql::VERSION: 4.021 $DBI::VERSION: 1.622
    # Cxn:3578 1152 DBI::db=HASH(0x24ef970) Setting dbh
    # Cxn:3583 1152 DBI::db=HASH(0x24ef970) SELECT @@server_id /*!50038 , @@hostname*/
    # Cxn:3585 1152 DBI::db=HASH(0x24ef970) hostname: draco01 0
    # Cxn:3566 1152 DBI::db=HASH(0x24ef970) Connected dbh to draco01 h=192.168.10.210,P=3306
    # Percona::XtraDB::Cluster:3720 1152 draco01 SHOW VARIABLES LIKE 'wsrep_on'
    # Percona::XtraDB::Cluster:3722 1152 $VAR1 = [
    #   'wsrep_on',
    #   'ON'
    # ];
    #
    # Percona::XtraDB::Cluster:3711 1152 draco01 SHOW VARIABLES LIKE 'wsrep_cluster_name'
    Use of uninitialized value $host in concatenation (.) or string at /usr/bin/pt-table-checksum line 3765.
    # Cxn:3656 1152 Destroying cxn
    # Cxn:3665 1152 DBI::db=HASH(0x24ef970) Disconnecting dbh on draco01 h=192.168.10.210,P=3306
    # Cxn:3656 1152 Destroying cxn
    # Cxn:3665 1152 DBI::db=HASH(0x24e8530) Disconnecting dbh on draco01 h=localhost

    I did check that cluster nodes get listed in order for the "--recursion-method=cluster" to work:

    Code:
    mysql> SHOW STATUS LIKE 'wsrep\_incoming\_addresses';
    +--------------------------+------------------------------------------+
    | Variable_name            | Value                                    |
    +--------------------------+------------------------------------------+
    | wsrep_incoming_addresses | 192.168.10.210:3306,,192.168.10.211:3306 |
    +--------------------------+------------------------------------------+
    1 row in set (0.00 sec)
    I don't know if I am missing something. Any help is appreciated.

    PS. Had to cut some output (...) due to forum restrictions.

    Kind regards.
Working...
X