XING-sami.ahlroos@utest-1.backup.fra1:~ $ PTDEBUG=1 pt-upgrade h=utest-1.backup.fra1,D=crc h=utest-2.backup.fra1,D=crc test1.txt pt-upgrade_out.txt # /usr/bin/perl 5.010001 # Linux utest-1 2.6.32-5-amd64 #1 SMP Mon Feb 25 00:26:11 UTC 2013 x86_64 GNU/Linux # Arguments: _[h=utest-1.backup.fra1,D=crc]_ _[h=utest-2.backup.fra1,D=crc]_ _[test1.txt]_ _[pt-upgrade_out.txt]_ # OptionParser:1469 384 Option rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:1478 384 =item --ask-pass # OptionParser:1497 384 Option has no attributes # OptionParser:1505 384 Short help: Prompt for a password when connecting to MySQL # OptionParser:1478 384 =item --charset # OptionParser:1505 384 Short help: Default character set # OptionParser:1478 384 =item --config # OptionParser:1505 384 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:1478 384 =item --[no]continue-on-error # OptionParser:1505 384 Short help: Continue parsing even if there is an error # OptionParser:1478 384 =item --[no]create-upgrade-table # OptionParser:1505 384 Short help: Create the --upgrade-table database and table # OptionParser:1478 384 =item --daemonize # OptionParser:1497 384 Option has no attributes # OptionParser:1505 384 Short help: Fork to the background and detach from the shell # OptionParser:1478 384 =item --database # OptionParser:1505 384 Short help: Default database when connecting to MySQL # OptionParser:1478 384 =item --defaults-file # OptionParser:1505 384 Short help: Only read MySQL options from the given file # OptionParser:1478 384 =item --[no]disable-query-cache # OptionParser:1505 384 Short help: SET SESSION query_cache_type = OFF to disable the query cache # OptionParser:1478 384 =item --dry-run # OptionParser:1497 384 Option has no attributes # OptionParser:1505 384 Short help: Run but do not execute or compare queries # OptionParser:1478 384 =item --filter # OptionParser:1505 384 Short help: Allow events for which this Perl code returns true # OptionParser:1478 384 =item --help # OptionParser:1497 384 Option has no attributes # OptionParser:1505 384 Short help: Show help and exit # OptionParser:1478 384 =item --host # OptionParser:1505 384 Short help: MySQL hostname or IP # OptionParser:1478 384 =item --ignore-warnings # OptionParser:1505 384 Short help: Ignore these MySQL warning codes when comparing warnings # OptionParser:1478 384 =item --log # OptionParser:1505 384 Short help: Print STDOUT and STDERR to this file when daemonized # OptionParser:1478 384 =item --max-class-size # OptionParser:1505 384 Short help: Max number of unique queries in each query class # OptionParser:1478 384 =item --max-examples # OptionParser:1505 384 Short help: Max number of examples to list for each QUERY DIFFERENCES # OptionParser:1478 384 =item --password # OptionParser:1505 384 Short help: MySQL password for the --user # OptionParser:1478 384 =item --pid # OptionParser:1505 384 Short help: Create the given PID file # OptionParser:1478 384 =item --port # OptionParser:1505 384 Short help: MySQL port number # OptionParser:1478 384 =item --progress # OptionParser:1505 384 Short help: Print progress reports to STDERR # OptionParser:1478 384 =item --[no]read-only # OptionParser:1505 384 Short help: Execute only SELECT and SET statements # OptionParser:1478 384 =item --report # OptionParser:1505 384 Short help: Print these sections of the REPORT # OptionParser:1478 384 =item --run-time # OptionParser:1505 384 Short help: How long to run before exiting # OptionParser:1478 384 =item --save-results # OptionParser:1505 384 Short help: Save reference results to this directory # OptionParser:1478 384 =item --set-vars # OptionParser:1505 384 Short help: Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:1478 384 =item --socket # OptionParser:1505 384 Short help: Socket file to use for connection # OptionParser:1478 384 =item --type # OptionParser:1505 384 Short help: Type of log files # OptionParser:1478 384 =item --upgrade-table # OptionParser:1505 384 Short help: Use this table to clear warnings # OptionParser:1478 384 =item --user # OptionParser:1505 384 Short help: MySQL user if not the current system user # OptionParser:1478 384 =item --version # OptionParser:1497 384 Option has no attributes # OptionParser:1505 384 Short help: Show version and exit # OptionParser:1478 384 =item --[no]version-check # OptionParser:1505 384 Short help: Check for the latest version of Percona Toolkit, MySQL, and other programs # OptionParser:1478 384 =item --watch-server # OptionParser:1505 384 Short help: Parse only events for this IP:port for --type tcpdump # OptionParser:1544 384 Parsing opt spec: group => default spec => ask-pass desc => Prompt for a password when connecting to MySQL # OptionParser:1582 384 ask-pass type: undef # OptionParser:1544 384 Parsing opt spec: group => default spec => charset|A=s desc => Default character set # OptionParser:1582 384 charset type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => config=A desc => Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:1582 384 config type: A # OptionParser:1544 384 Parsing opt spec: group => default spec => continue-on-error! desc => Continue parsing even if there is an error (default yes) # OptionParser:1582 384 continue-on-error type: undef # OptionParser:1589 384 continue-on-error default: yes # OptionParser:1544 384 Parsing opt spec: group => default spec => create-upgrade-table! desc => Create the --upgrade-table database and table (default yes) # OptionParser:1582 384 create-upgrade-table type: undef # OptionParser:1589 384 create-upgrade-table default: yes # OptionParser:1544 384 Parsing opt spec: group => default spec => daemonize desc => Fork to the background and detach from the shell # OptionParser:1582 384 daemonize type: undef # OptionParser:1544 384 Parsing opt spec: group => default spec => database|D=s desc => Default database when connecting to MySQL # OptionParser:1582 384 database type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => defaults-file|F=s desc => Only read MySQL options from the given file # OptionParser:1582 384 defaults-file type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => disable-query-cache! desc => SET SESSION query_cache_type = OFF to disable the query cache (default yes) # OptionParser:1582 384 disable-query-cache type: undef # OptionParser:1589 384 disable-query-cache default: yes # OptionParser:1544 384 Parsing opt spec: group => default spec => dry-run desc => Run but do not execute or compare queries # OptionParser:1582 384 dry-run type: undef # OptionParser:1544 384 Parsing opt spec: group => default spec => filter=s desc => Allow events for which this Perl code returns true # OptionParser:1582 384 filter type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => help desc => Show help and exit # OptionParser:1582 384 help type: undef # OptionParser:1544 384 Parsing opt spec: group => default spec => host|h=s desc => MySQL hostname or IP # OptionParser:1582 384 host type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => ignore-warnings=H desc => Ignore these MySQL warning codes when comparing warnings # OptionParser:1582 384 ignore-warnings type: H # OptionParser:1544 384 Parsing opt spec: group => default spec => log=s desc => Print STDOUT and STDERR to this file when daemonized # OptionParser:1582 384 log type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => max-class-size=i desc => Max number of unique queries in each query class (default 1000) # OptionParser:1582 384 max-class-size type: i # OptionParser:1589 384 max-class-size default: 1000 # OptionParser:1544 384 Parsing opt spec: group => default spec => max-examples=i desc => Max number of examples to list for each QUERY DIFFERENCES (default 3) # OptionParser:1582 384 max-examples type: i # OptionParser:1589 384 max-examples default: 3 # OptionParser:1544 384 Parsing opt spec: group => default spec => password|p=s desc => MySQL password for the --user # OptionParser:1582 384 password type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => pid=s desc => Create the given PID file # OptionParser:1582 384 pid type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => port|P=i desc => MySQL port number # OptionParser:1582 384 port type: i # OptionParser:1544 384 Parsing opt spec: group => default spec => progress=a desc => Print progress reports to STDERR (default time,30) # OptionParser:1582 384 progress type: a # OptionParser:1589 384 progress default: time,30 # OptionParser:1544 384 Parsing opt spec: group => default spec => read-only! desc => Execute only SELECT and SET statements (default yes) # OptionParser:1582 384 read-only type: undef # OptionParser:1589 384 read-only default: yes # OptionParser:1544 384 Parsing opt spec: group => default spec => report=H desc => Print these sections of the REPORT (default hosts, logs, queries, stats) # OptionParser:1582 384 report type: H # OptionParser:1589 384 report default: hosts, logs, queries, stats # OptionParser:1544 384 Parsing opt spec: group => default spec => run-time=m desc => How long to run before exiting # OptionParser:1582 384 run-time type: m # OptionParser:1544 384 Parsing opt spec: group => default spec => save-results=s desc => Save reference results to this directory # OptionParser:1582 384 save-results type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => set-vars=A desc => Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:1582 384 set-vars type: A # OptionParser:1544 384 Parsing opt spec: group => default spec => socket|S=s desc => Socket file to use for connection # OptionParser:1582 384 socket type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => type=s desc => Type of log files (default slowlog) # OptionParser:1582 384 type type: s # OptionParser:1589 384 type default: slowlog # OptionParser:1544 384 Parsing opt spec: group => default spec => upgrade-table=s desc => Use this table to clear warnings (default percona_schema.pt_upgrade) # OptionParser:1582 384 upgrade-table type: s # OptionParser:1589 384 upgrade-table default: percona_schema.pt_upgrade # OptionParser:1544 384 Parsing opt spec: group => default spec => user|u=s desc => MySQL user if not the current system user # OptionParser:1582 384 user type: s # OptionParser:1544 384 Parsing opt spec: group => default spec => version desc => Show version and exit # OptionParser:1582 384 version type: undef # OptionParser:1544 384 Parsing opt spec: group => default spec => version-check! desc => Check for the latest version of Percona Toolkit, MySQL, and other programs (default yes) # OptionParser:1582 384 version-check type: undef # OptionParser:1589 384 version-check default: yes # OptionParser:1544 384 Parsing opt spec: group => default spec => watch-server=s desc => Parse only events for this IP:port for --type tcpdump # OptionParser:1582 384 watch-server type: s # OptionParser:1604 384 Parsing rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:1660 384 Participants for This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. : # OptionParser:1636 384 Strict mode disabled by rule # OptionParser:1388 384 Parsing DSN OPTIONS # OptionParser:1478 384 =item * A # OptionParser:1505 384 Short help: Default character set # OptionParser:1478 384 =item * D # OptionParser:1505 384 Short help: Default database # OptionParser:1478 384 =item * F # OptionParser:1505 384 Short help: Only read default options from the given file # OptionParser:1478 384 =item * h # OptionParser:1505 384 Short help: Connect to host # OptionParser:1478 384 =item * L # OptionParser:1505 384 Short help: Explicitly enable LOAD DATA LOCAL INFILE # OptionParser:1478 384 =item * p # OptionParser:1505 384 Short help: Password to use when connecting # OptionParser:1478 384 =item * P # OptionParser:1505 384 Short help: Port number to use for connection # OptionParser:1478 384 =item * S # OptionParser:1505 384 Short help: Socket file to use for connection # OptionParser:1478 384 =item * u # OptionParser:1505 384 Short help: User for login if not current user # DSNParser:756 384 DSN option: copy=1, dsn=charset, desc=Default character set, key=A # DSNParser:756 384 DSN option: copy=1, dsn=database, desc=Default database, key=D # DSNParser:756 384 DSN option: copy=1, dsn=mysql_read_default_file, desc=Only read default options from the given file, key=F # DSNParser:756 384 DSN option: copy=1, dsn=host, desc=Connect to host, key=h # DSNParser:756 384 DSN option: copy=1, dsn=undef, desc=Explicitly enable LOAD DATA LOCAL INFILE, key=L # DSNParser:756 384 DSN option: copy=1, dsn=password, desc=Password to use when connecting, key=p # DSNParser:756 384 DSN option: copy=1, dsn=port, desc=Port number to use for connection, key=P # DSNParser:756 384 DSN option: copy=1, dsn=mysql_socket, desc=Socket file to use for connection, key=S # DSNParser:756 384 DSN option: copy=1, dsn=user, desc=User for login if not current user, key=u # OptionParser:1432 384 pt-upgrade 2.2.1 # OptionParser:1744 384 Cannot open /etc/percona-toolkit/percona-toolkit.conf: No such file or directory # # OptionParser:1744 384 Cannot open /etc/percona-toolkit/pt-upgrade.conf: No such file or directory # # OptionParser:1744 384 Cannot open /home/local/XING/sami.ahlroos/.percona-toolkit.conf: No such file or directory # # OptionParser:1744 384 Cannot open /home/local/XING/sami.ahlroos/.pt-upgrade.conf: No such file or directory # # OptionParser:1932 384 Nothing to validate for option password type s value undef # OptionParser:1932 384 Nothing to validate for option pid type s value undef # OptionParser:1932 384 Nothing to validate for option user type s value undef # OptionParser:1932 384 Nothing to validate for option max-class-size type i value 1000 # OptionParser:1932 384 Nothing to validate for option charset type s value undef # OptionParser:1932 384 Nothing to validate for option port type i value undef # OptionParser:1932 384 Nothing to validate for option socket type s value undef # OptionParser:1932 384 Nothing to validate for option upgrade-table type s value percona_schema.pt_upgrade # OptionParser:1932 384 Nothing to validate for option type type s value slowlog # OptionParser:1932 384 Nothing to validate for option save-results type s value undef # OptionParser:1932 384 Nothing to validate for option run-time type m value undef # OptionParser:1932 384 Nothing to validate for option log type s value undef # OptionParser:1932 384 Nothing to validate for option filter type s value undef # OptionParser:1932 384 Nothing to validate for option host type s value undef # OptionParser:1932 384 Nothing to validate for option defaults-file type s value undef # OptionParser:1932 384 Nothing to validate for option database type s value undef # OptionParser:1932 384 Nothing to validate for option watch-server type s value undef # OptionParser:1932 384 Nothing to validate for option max-examples type i value 3 # OptionParser:2326 384 --set-vars: $VAR1 = { # wait_timeout => { # default => 1, # val => '10000' # } # }; # # DSNParser:772 384 Setting set-vars property # pt_upgrade:9145 384 h=utest-1.backup.fra1,D=crc is a DSN # pt_upgrade:9145 384 h=utest-2.backup.fra1,D=crc is a DSN # pt_upgrade:9137 384 test1.txt is a file # pt_upgrade:9137 384 pt-upgrade_out.txt is a file # OptionParser:2006 384 Getting description and usage from SYNOPSIS in /usr/bin/pt-upgrade # OptionParser:2259 384 Parsing SYNOPSIS in /usr/bin/pt-upgrade # OptionParser:2272 384 Raw SYNOPSIS text: Usage: pt-upgrade [OPTIONS] LOGS|RESULTS DSN [DSN] # # pt-upgrade executes queries in the given MySQL C on each C, # compares the results, and reports any significant differences. The tool can # also save the results for later analyses. C can be slow, general, # binary, tcpdump, and "raw". # # # OptionParser:2010 384 Description: pt-upgrade executes queries in the given MySQL C on each C, compares the results, and reports any significant differences. The tool can also save the results for later analyses. C can be slow, general, binary, tcpdump, and "raw". # Usage: pt-upgrade [OPTIONS] LOGS|RESULTS DSN [DSN] # DSNParser:844 384 DSN string made from options: # DSNParser:781 384 No DSN to parse # DSNParser:784 384 Parsing h=utest-1.backup.fra1,D=crc # DSNParser:803 384 Finding value for S # DSNParser:813 384 Copying value for S from defaults # DSNParser:803 384 Finding value for F # DSNParser:813 384 Copying value for F from defaults # DSNParser:803 384 Finding value for A # DSNParser:813 384 Copying value for A from defaults # DSNParser:803 384 Finding value for P # DSNParser:813 384 Copying value for P from defaults # DSNParser:803 384 Finding value for u # DSNParser:813 384 Copying value for u from defaults # DSNParser:803 384 Finding value for p # DSNParser:813 384 Copying value for p from defaults # DSNParser:803 384 Finding value for h # DSNParser:803 384 Finding value for D # DSNParser:803 384 Finding value for L # DSNParser:813 384 Copying value for L from defaults # DSNParser:897 384 DBI:mysql:crc;host=utest-1.backup.fra1;mysql_read_default_group=client # DSNParser:946 384 DBI:mysql:crc;host=utest-1.backup.fra1;mysql_read_default_group=client undef undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0 # DSNParser:974 384 DBI::db=HASH(0x3600920) SELECT @@SQL_MODE # DSNParser:1105 384 DBI::db=HASH(0x3600920) SET SESSION wait_timeout=10000 # DSNParser:1005 384 DBI::db=HASH(0x3600920) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/ # DSNParser:1014 384 DBH info: DBI::db=HASH(0x3600920) $VAR1 = { # '@@hostname' => 'utest-1', # 'CONNECTION_ID()' => '220', # 'DATABASE()' => 'crc', # 'VERSION()' => '5.0.87-b20-log' # }; # Connection info: utest-1.backup.fra1 via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'utf8', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'utf8', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/mysql/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.016 $DBI::VERSION: 1.612 # Cxn:2449 384 DBI::db=HASH(0x3600920) Setting dbh # Cxn:2454 384 DBI::db=HASH(0x3600920) SELECT @@hostname, @@server_id # Cxn:2456 384 DBI::db=HASH(0x3600920) hostname: utest-1 67765515 # pt_upgrade:10012 384 SELECT @@query_cache_type # pt_upgrade:10014 384 ON # pt_upgrade:10019 384 SET SESSION query_cache_type = OFF # Cxn:2437 384 DBI::db=HASH(0x3600920) Connected dbh to utest-1 h=utest-1.backup.fra1 # DSNParser:844 384 DSN string made from options: # DSNParser:781 384 No DSN to parse # DSNParser:784 384 Parsing h=utest-2.backup.fra1,D=crc # DSNParser:803 384 Finding value for S # DSNParser:813 384 Copying value for S from defaults # DSNParser:803 384 Finding value for F # DSNParser:813 384 Copying value for F from defaults # DSNParser:803 384 Finding value for A # DSNParser:813 384 Copying value for A from defaults # DSNParser:803 384 Finding value for P # DSNParser:813 384 Copying value for P from defaults # DSNParser:803 384 Finding value for u # DSNParser:813 384 Copying value for u from defaults # DSNParser:803 384 Finding value for p # DSNParser:813 384 Copying value for p from defaults # DSNParser:803 384 Finding value for h # DSNParser:803 384 Finding value for D # DSNParser:803 384 Finding value for L # DSNParser:813 384 Copying value for L from defaults # DSNParser:897 384 DBI:mysql:crc;host=utest-2.backup.fra1;mysql_read_default_group=client # DSNParser:946 384 DBI:mysql:crc;host=utest-2.backup.fra1;mysql_read_default_group=client undef undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0 # DSNParser:974 384 DBI::db=HASH(0x35ffba0) SELECT @@SQL_MODE # DSNParser:1105 384 DBI::db=HASH(0x35ffba0) SET SESSION wait_timeout=10000 # DSNParser:1005 384 DBI::db=HASH(0x35ffba0) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/ # DSNParser:1014 384 DBH info: DBI::db=HASH(0x35ffba0) $VAR1 = { # '@@hostname' => 'utest-2', # 'CONNECTION_ID()' => '338', # 'DATABASE()' => 'crc', # 'VERSION()' => '5.5.30-30.2-log' # }; # Connection info: utest-2.backup.fra1 via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'utf8', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'utf8', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/mysql/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.016 $DBI::VERSION: 1.612 # Cxn:2449 384 DBI::db=HASH(0x35ffba0) Setting dbh # Cxn:2454 384 DBI::db=HASH(0x35ffba0) SELECT @@hostname, @@server_id # Cxn:2456 384 DBI::db=HASH(0x35ffba0) hostname: utest-2 67765516 # pt_upgrade:10012 384 SELECT @@query_cache_type # pt_upgrade:10014 384 ON # pt_upgrade:10019 384 SET SESSION query_cache_type = OFF # Cxn:2437 384 DBI::db=HASH(0x35ffba0) Connected dbh to utest-2 h=utest-2.backup.fra1 # VersionCheck:3936 384 FindBin::Bin: /usr/bin # VersionCheck:4095 384 SELECT CONCAT(@@hostname, @@port) # VersionCheck:4098 384 DBD::mysql::db selectrow_array failed: Unknown system variable 'port' [for Statement "SELECT CONCAT(@@hostname, @@port)"] at /usr/bin/pt-upgrade line 4096. # # VersionCheck:4100 384 SELECT @@hostname # VersionCheck:4108 384 SHOW VARIABLES LIKE 'port' # VersionCheck:4110 384 port: 3306 # VersionCheck:4116 384 MySQL instance: b3b7082b63900eaf1ea05fd42dd3a2ab utest-13306 $VAR1 = { # A => undef, # D => 'crc', # F => undef, # L => undef, # P => undef, # S => undef, # h => 'utest-1.backup.fra1', # p => undef, # u => undef # }; # # VersionCheck:4095 384 SELECT CONCAT(@@hostname, @@port) # VersionCheck:4116 384 MySQL instance: 342c86a4980e66d07aad1dccab256796 utest-23306 $VAR1 = { # A => undef, # D => 'crc', # F => undef, # L => undef, # P => undef, # S => undef, # h => 'utest-2.backup.fra1', # p => undef, # u => undef # }; # # VersionCheck:3916 384 Version check file percona-version-check in /tmp # VersionCheck:4030 384 Version check file /tmp/percona-version-check contents: 0,1365689151 # 342c86a4980e66d07aad1dccab256796,1365689151 # b3b7082b63900eaf1ea05fd42dd3a2ab,1365689151 # VersionCheck:4038 384 Intsance b3b7082b63900eaf1ea05fd42dd3a2ab last checked 1365689151 now 1365778012 diff 88861 hours until next check -0.68 # VersionCheck:4045 384 Time to check $VAR1 = { # dbh => bless( {}, 'DBI::db' ), # dsn => { # A => undef, # D => 'crc', # F => undef, # L => undef, # P => undef, # S => undef, # h => 'utest-1.backup.fra1', # p => undef, # u => undef # }, # id => 'b3b7082b63900eaf1ea05fd42dd3a2ab', # name => 'utest-13306' # }; # # VersionCheck:4038 384 Intsance 342c86a4980e66d07aad1dccab256796 last checked 1365689151 now 1365778012 diff 88861 hours until next check -0.68 # VersionCheck:4045 384 Time to check $VAR1 = { # dbh => bless( {}, 'DBI::db' ), # dsn => { # A => undef, # D => 'crc', # F => undef, # L => undef, # P => undef, # S => undef, # h => 'utest-2.backup.fra1', # p => undef, # u => undef # }, # id => '342c86a4980e66d07aad1dccab256796', # name => 'utest-23306' # }; # # VersionCheck:4038 384 Intsance 0 last checked 1365689151 now 1365778012 diff 88861 hours until next check -0.68 # VersionCheck:4045 384 Time to check $VAR1 = { # id => 0, # name => 'system' # }; # # VersionCheck:3959 384 3 instances to check # VersionCheck:3968 384 Using https # VersionCheck:4134 384 Server response: $VAR1 = { # content => 'OS;os_version # MySQL;mysql_variable;version_comment,version # Perl;perl_version # DBD::mysql;perl_module_version # Percona::Toolkit;perl_module_version', # headers => { # 'cache-control' => 'no-cache', # connection => 'close', # 'content-length' => '144', # 'content-type' => 'text/plain; charset=UTF-8', # date => 'Fri, 12 Apr 2013 14:46:52 GMT', # server => 'Apache/2.2.22 (Ubuntu)', # 'set-cookie' => 'PHPSESSID=12ofptr0t6qgnffc2fuf3b0016; path=/', # vary => 'Accept-Encoding', # 'x-powered-by' => 'PHP/5.3.10-1ubuntu3.5' # }, # protocol => 'HTTP/1.0', # reason => 'OK', # status => '200', # success => 1 # }; # # VersionCheck:4235 384 Items: $VAR1 = { # DBD::mysql => { # item => 'DBD::mysql', # type => 'perl_module_version', # vars => [] # }, # MySQL => { # item => 'MySQL', # type => 'mysql_variable', # vars => [ # 'version_comment', # 'version' # ] # }, # OS => { # item => 'OS', # type => 'os_version', # vars => [] # }, # Percona::Toolkit => { # item => 'Percona::Toolkit', # type => 'perl_module_version', # vars => [] # }, # Perl => { # item => 'Perl', # type => 'perl_version', # vars => [] # } # }; # # VersionCheck:4380 384 Perl version for $Percona::Toolkit::VERSION = 2.2.1 # VersionCheck:4380 384 Perl version for $DBD::mysql::VERSION = 4.016 # VersionCheck:4369 384 Perl version 5.10.1 # VersionCheck:4295 384 platform: Linux # VersionCheck:4300 384 lsb_release: /usr/bin/lsb_release # VersionCheck:4359 384 OS version = Debian GNU/Linux 6.0.7 (squeeze) # VersionCheck:4411 384 SHOW VARIABLES # VersionCheck:4418 384 MySQL version for MySQL = (Debian) on utest-13306 # VersionCheck:4418 384 MySQL version for MySQL = 5.0.87-b20-log on utest-13306 # VersionCheck:4411 384 SHOW VARIABLES # VersionCheck:4418 384 MySQL version for MySQL = Percona Server (GPL), Release 30.2 on utest-23306 # VersionCheck:4418 384 MySQL version for MySQL = 5.5.30-30.2-log on utest-23306 # VersionCheck:4165 384 Client response: $VAR1 = { # content => 'ea573a79ea2f4be4a99fbdfd0d27fe35;DBD::mysql;4.016 # 342c86a4980e66d07aad1dccab256796;MySQL;Percona Server (GPL), Release 30.2 5.5.30-30.2-log # b3b7082b63900eaf1ea05fd42dd3a2ab;MySQL;(Debian) 5.0.87-b20-log # ea573a79ea2f4be4a99fbdfd0d27fe35;OS;Debian GNU/Linux 6.0.7 (squeeze) # ea573a79ea2f4be4a99fbdfd0d27fe35;Percona::Toolkit;2.2.1 # ea573a79ea2f4be4a99fbdfd0d27fe35;Perl;5.10.1 # ', # headers => { # 'X-Percona-Toolkit-Tool' => 'pt-upgrade' # } # }; # # VersionCheck:4168 384 Server suggestions: $VAR1 = { # content => '', # headers => { # 'cache-control' => 'no-cache', # connection => 'close', # 'content-length' => '0', # 'content-type' => 'text/plain; charset=UTF-8', # date => 'Fri, 12 Apr 2013 14:46:53 GMT', # server => 'Apache/2.2.22 (Ubuntu)', # 'set-cookie' => 'PHPSESSID=0u2i896n47t5hdd6j7i6vio394; path=/', # vary => 'Accept-Encoding', # 'x-powered-by' => 'PHP/5.3.10-1ubuntu3.5' # }, # protocol => 'HTTP/1.0', # reason => 'OK', # status => '200', # success => 1 # }; # # VersionCheck:3916 384 Version check file percona-version-check in /tmp # VersionCheck:4059 384 Updating last check time: 1365778013 # VersionCheck:4002 384 Error updating version check file: Cannot write to /tmp/percona-version-check: Permission denied at /usr/bin/pt-upgrade line 4078. # # pt_upgrade:9477 384 Checking --upgrade-table percona_schema.pt_upgrade # pt_upgrade:9488 384 SHOW DATABASES LIKE 'percona_schema' # pt_upgrade:9503 384 CREATE DATABASE IF NOT EXISTS `percona_schema` /* pt-upgrade */ # pt_upgrade:9582 384 Checking `percona_schema`.`pt_upgrade` # pt_upgrade:9586 384 SHOW TABLES FROM `percona_schema` LIKE 'pt\_upgrade' # pt_upgrade:9600 384 Table percona_schema pt_upgrade exists # pt_upgrade:9530 384 --upgrade-table table exists: yes # pt_upgrade:9542 384 Creating --upgrade-table table percona_schema.pt_upgrade # pt_upgrade:9546 384 DBI::db=HASH(0x3600920) CREATE TABLE IF NOT EXISTS percona_schema.pt_upgrade ( # id INT NOT NULL PRIMARY KEY # ) # pt_upgrade:9477 384 Checking --upgrade-table percona_schema.pt_upgrade # pt_upgrade:9488 384 SHOW DATABASES LIKE 'percona_schema' # pt_upgrade:9503 384 CREATE DATABASE IF NOT EXISTS `percona_schema` /* pt-upgrade */ # pt_upgrade:9582 384 Checking `percona_schema`.`pt_upgrade` # pt_upgrade:9586 384 SHOW TABLES FROM `percona_schema` LIKE 'pt\_upgrade' # pt_upgrade:9600 384 Table percona_schema pt_upgrade exists # pt_upgrade:9530 384 --upgrade-table table exists: yes # pt_upgrade:9542 384 Creating --upgrade-table table percona_schema.pt_upgrade # pt_upgrade:9546 384 DBI::db=HASH(0x35ffba0) CREATE TABLE IF NOT EXISTS percona_schema.pt_upgrade ( # id INT NOT NULL PRIMARY KEY # ) #----------------------------------------------------------------------- # Logs #----------------------------------------------------------------------- File: test1.txt Size: 193 File: pt-upgrade_out.txt Size: 1584 # VersionParser:4967 384 VersionParser got a dbh, trying to get the version # VersionParser:5015 384 InnoDB support: DEFAULT # VersionParser:5027 384 InnoDB version: BUILTIN # VersionParser:4967 384 VersionParser got a dbh, trying to get the version # VersionParser:5015 384 InnoDB support: DEFAULT # VersionParser:5027 384 InnoDB version: 5.5.30-rel30.2 #----------------------------------------------------------------------- # Hosts #----------------------------------------------------------------------- host1: DSN: h=utest-1.backup.fra1 hostname: utest-1 MySQL: (Debian) 5.0.87 host2: DSN: h=utest-2.backup.fra1 hostname: utest-2 MySQL: Percona Server (GPL), Release 30.2 5.5.30 # FileIterator:5094 384 Final filenames: test1.txt pt-upgrade_out.txt # Runtime:8836 384 Current time: 1365778013.45108 # FileIterator:5098 384 Filename: test1.txt # QueryIterator:5287 384 Reading test1.txt # SlowLogParser:6516 384 # Time: 130411 13:21:17 # SlowLogParser:6521 384 Got ts 130411 13:21:17 # SlowLogParser:6516 384 # Thread_id: 4294967296 # SlowLogParser:6551 384 Got some line with properties # SlowLogParser:6516 384 # Query_time: 0.000137 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 # SlowLogParser:6551 384 Got some line with properties # SlowLogParser:6516 384 SELECT `test1`.* FROM `test1` WHERE `test1`.`id` = 852800 LIMIT 1 # SlowLogParser:6604 384 Got the query/arg line # SlowLogParser:6616 384 Properties of event: $VAR1 = [ # 'cmd', # 'Query', # 'pos_in_log', # 0, # 'ts', # '130411 13:21:17', # 'Thread_id', # '4294967296', # 'Query_time', # '0.000137', # 'Lock_time', # '0.000000', # 'Rows_sent', # '0', # 'Rows_examined', # '0', # 'arg', # 'SELECT `test1`.* FROM `test1` WHERE `test1`.`id` = 852800 LIMIT 1', # 'bytes', # 67 # ]; # # EventExecutor:5487 384 Result on utest-1 $VAR1 = { # error => undef, # query_time => '0.000226', # sth => bless( {}, 'DBI::st' ), # warnings => {} # }; # # EventExecutor:5487 384 Result on utest-2 $VAR1 = { # error => undef, # query_time => '0.000318', # sth => bless( {}, 'DBI::st' ), # warnings => {} # }; # # pt_upgrade:10039 384 Diff query times 0.000226 0.000318 # pt_upgrade:10072 384 Diff warnings # pt_upgrade:10104 384 Diff rows # pt_upgrade:10146 384 Row diff: $VAR1 = [ # undef, # '852800' # ]; # $VAR1 = [ # undef, # '852800' # ]; # # pt_upgrade:9988 384 Query diffs # UpgradeResults:5687 384 New query class: 5E449981E650B75A select `test?`.* from `test?` where `test?`.`id` = ? limit ? # Runtime:8836 384 Current time: 1365778013.45568 # QueryIterator:5362 384 Done reading test1.txt # pt_upgrade:9701 384 Done parsing events # Runtime:8836 384 Current time: 1365778013.45591 # UpgradeResults:5787 384 Reporting class 5E449981E650B75A select `test?`.* from `test?` where `test?`.`id` = ? limit ? # UpgradeResults:5858 384 Unique queries: 1 # UpgradeResults:5868 384 Reasons: it has diffs, but hasn't been reported yet ######################################################################## # Query class 5E449981E650B75A ######################################################################## Reporting class because it has diffs, but hasn't been reported yet. Total queries 1 Unique queries 1 Discarded queries 0 select `test?`.* from `test?` where `test?`.`id` = ? limit ? ## ## Row diffs: 1 ## -- 1. @ row 1 < NULL,852800 > NULL,852800 SELECT `test1`.* FROM `test1` WHERE `test1`.`id` = 852800 LIMIT 1 # pt_upgrade:9407 384 Stats: $VAR1 = { # failed_queries => 0, # not_select => 0, # queries_filtered => 0, # queries_no_diffs => 0, # queries_read => 1, # queries_with_diffs => 1, # queries_with_errors => 0 # }; # #----------------------------------------------------------------------- # Stats #----------------------------------------------------------------------- failed_queries 0 not_select 0 queries_filtered 0 queries_no_diffs 0 queries_read 1 queries_with_diffs 1 queries_with_errors 0 # Cxn:2501 384 Destroying cxn # Cxn:2510 384 DBI::db=HASH(0x35ffba0) Disconnecting dbh on utest-2 h=utest-2.backup.fra1 # Cxn:2501 384 Destroying cxn # Cxn:2510 384 DBI::db=HASH(0x3600920) Disconnecting dbh on utest-1 h=utest-1.backup.fra1