# /usr/bin/perl 5.018002 # Linux Slave6vm 3.16.0-30-generic #40~14.04.1-Ubuntu SMP Thu Jan 15 17:43:14 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux # Arguments: _[--recursion-method=dsn=h=10.0.2.148,D=percona,t=dsns]_ _[--nocheck-replication-filters]_ _[--check-interval=2]_ _[--max-lag=60]_ _[--critical-load]_ _[Threads_running=10]_ _[--alter]_ _[modify ExtraText1 varchar(256)]_ _[h=10.0.2.148,D=ATData,t=Retest,u=root,p=password]_ _[--execute]_ # OptionParser:290 5311 Option rule: --dry-run and --execute are mutually exclusive. # OptionParser:290 5311 Option rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:299 5311 =item --alter # OptionParser:326 5311 Short help: The schema modification, without the ALTER TABLE keywords # OptionParser:299 5311 =item --alter-foreign-keys-method # OptionParser:326 5311 Short help: How to modify foreign keys so they reference the new table # OptionParser:299 5311 =item --ask-pass # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: Prompt for a password when connecting to MySQL # OptionParser:299 5311 =item --charset # OptionParser:326 5311 Short help: Default character set # OptionParser:299 5311 =item --[no]check-alter # OptionParser:326 5311 Short help: Parses the --alter specified and tries to warn of possible unintended behavior # OptionParser:299 5311 =item --check-interval # OptionParser:326 5311 Short help: Sleep time between checks for --max-lag # OptionParser:299 5311 =item --[no]check-plan # OptionParser:326 5311 Short help: Check query execution plans for safety # OptionParser:299 5311 =item --[no]check-replication-filters # OptionParser:326 5311 Short help: Abort if any replication filter is set on any server # OptionParser:299 5311 =item --check-slave-lag # OptionParser:326 5311 Short help: Pause the data copy until this replica's lag is less than --max-lag # OptionParser:299 5311 =item --chunk-index # OptionParser:326 5311 Short help: Prefer this index for chunking tables # OptionParser:299 5311 =item --chunk-index-columns # OptionParser:326 5311 Short help: Use only this many left-most columns of a --chunk-index # OptionParser:299 5311 =item --chunk-size # OptionParser:326 5311 Short help: Number of rows to select for each chunk copied # OptionParser:299 5311 =item --chunk-size-limit # OptionParser:326 5311 Short help: Do not copy chunks this much larger than the desired chunk size # OptionParser:299 5311 =item --chunk-time # OptionParser:326 5311 Short help: Adjust the chunk size dynamically so each data-copy query takes this long to execute # OptionParser:299 5311 =item --config # OptionParser:326 5311 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:299 5311 =item --critical-load # OptionParser:326 5311 Short help: Examine SHOW GLOBAL STATUS after every chunk, and abort if the load is too high # OptionParser:299 5311 =item --database # OptionParser:326 5311 Short help: Connect to this database # OptionParser:299 5311 =item --default-engine # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: Remove ENGINE from the new table # OptionParser:299 5311 =item --defaults-file # OptionParser:326 5311 Short help: Only read mysql options from the given file # OptionParser:299 5311 =item --[no]drop-new-table # OptionParser:326 5311 Short help: Drop the new table if copying the original table fails # OptionParser:299 5311 =item --[no]drop-old-table # OptionParser:326 5311 Short help: Drop the original table after renaming it # OptionParser:299 5311 =item --[no]drop-triggers # OptionParser:326 5311 Short help: Drop triggers on the old table. --no-drop-triggers forces --no-drop-old-table # OptionParser:299 5311 =item --dry-run # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: Create and alter the new table, but do not create triggers, copy data, or replace the original table # OptionParser:299 5311 =item --execute # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: Indicate that you have read the documentation and want to alter the table # OptionParser:299 5311 =item --force # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: This options bypasses confirmation in case of using alter-foreign-keys-method = none , which might break foreign key constraints # OptionParser:299 5311 =item --help # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: Show help and exit # OptionParser:299 5311 =item --host # OptionParser:326 5311 Short help: Connect to host # OptionParser:299 5311 =item --max-lag # OptionParser:326 5311 Short help: Pause the data copy until all replicas' lag is less than this value # OptionParser:299 5311 =item --max-load # OptionParser:326 5311 Short help: Examine SHOW GLOBAL STATUS after every chunk, and pause if any status variables are higher than their thresholds # OptionParser:299 5311 =item --new-table-name # OptionParser:326 5311 Short help: New table name before it is swapped. %T is replaced with the original table name # OptionParser:299 5311 =item --password # OptionParser:326 5311 Short help: Password to use when connecting # OptionParser:299 5311 =item --pid # OptionParser:326 5311 Short help: Create the given PID file # OptionParser:299 5311 =item --plugin # OptionParser:326 5311 Short help: Perl module file that defines a pt_online_schema_change_plugin class # OptionParser:299 5311 =item --port # OptionParser:326 5311 Short help: Port number to use for connection # OptionParser:299 5311 =item --print # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: Print SQL statements to STDOUT # OptionParser:299 5311 =item --progress # OptionParser:326 5311 Short help: Print progress reports to STDERR while copying rows # OptionParser:299 5311 =item --quiet # OptionParser:326 5311 Short help: Do not print messages to STDOUT (disables --progress) # OptionParser:299 5311 =item --recurse # OptionParser:326 5311 Short help: Number of levels to recurse in the hierarchy when discovering replicas # OptionParser:299 5311 =item --recursion-method # OptionParser:326 5311 Short help: Preferred recursion method for discovering replicas # OptionParser:299 5311 =item --set-vars # OptionParser:326 5311 Short help: Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:299 5311 =item --socket # OptionParser:326 5311 Short help: Socket file to use for connection # OptionParser:299 5311 =item --statistics # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: Print statistics about internal counters # OptionParser:299 5311 =item --[no]swap-tables # OptionParser:326 5311 Short help: Swap the original table and the new, altered table # OptionParser:299 5311 =item --tries # OptionParser:326 5311 Short help: How many times to try critical operations # OptionParser:299 5311 =item --user # OptionParser:326 5311 Short help: User for login if not current user # OptionParser:299 5311 =item --version # OptionParser:318 5311 Option has no attributes # OptionParser:326 5311 Short help: Show version and exit # OptionParser:299 5311 =item --[no]version-check # OptionParser:326 5311 Short help: Check for the latest version of Percona Toolkit, MySQL, and other programs # OptionParser:365 5311 Parsing opt spec: group => default spec => alter=s desc => The schema modification, without the ALTER TABLE keywords # OptionParser:403 5311 alter type: s # OptionParser:365 5311 Parsing opt spec: group => default spec => alter-foreign-keys-method=s desc => How to modify foreign keys so they reference the new table # OptionParser:403 5311 alter-foreign-keys-method type: s # OptionParser:365 5311 Parsing opt spec: group => default desc => Prompt for a password when connecting to MySQL spec => ask-pass # OptionParser:403 5311 ask-pass type: undef # OptionParser:365 5311 Parsing opt spec: spec => charset|A=s desc => Default character set group => default # OptionParser:403 5311 charset type: s # OptionParser:365 5311 Parsing opt spec: spec => check-alter! desc => Parses the --alter specified and tries to warn of possible unintended behavior (default yes) group => default # OptionParser:403 5311 check-alter type: undef # OptionParser:410 5311 check-alter default: yes # OptionParser:365 5311 Parsing opt spec: group => default desc => Sleep time between checks for --max-lag (default 1) spec => check-interval=m # OptionParser:403 5311 check-interval type: m # OptionParser:410 5311 check-interval default: 1 # OptionParser:365 5311 Parsing opt spec: group => default desc => Check query execution plans for safety (default yes) spec => check-plan! # OptionParser:403 5311 check-plan type: undef # OptionParser:410 5311 check-plan default: yes # OptionParser:365 5311 Parsing opt spec: spec => check-replication-filters! desc => Abort if any replication filter is set on any server (default yes) group => default # OptionParser:403 5311 check-replication-filters type: undef # OptionParser:410 5311 check-replication-filters default: yes # OptionParser:365 5311 Parsing opt spec: group => default spec => check-slave-lag=s desc => Pause the data copy until this replica's lag is less than --max-lag # OptionParser:403 5311 check-slave-lag type: s # OptionParser:365 5311 Parsing opt spec: desc => Prefer this index for chunking tables spec => chunk-index=s group => default # OptionParser:403 5311 chunk-index type: s # OptionParser:365 5311 Parsing opt spec: spec => chunk-index-columns=i desc => Use only this many left-most columns of a --chunk-index group => default # OptionParser:403 5311 chunk-index-columns type: i # OptionParser:365 5311 Parsing opt spec: desc => Number of rows to select for each chunk copied (default 1000) spec => chunk-size=z group => default # OptionParser:403 5311 chunk-size type: z # OptionParser:410 5311 chunk-size default: 1000 # OptionParser:365 5311 Parsing opt spec: group => default desc => Do not copy chunks this much larger than the desired chunk size (default 4.0) spec => chunk-size-limit=f # OptionParser:403 5311 chunk-size-limit type: f # OptionParser:410 5311 chunk-size-limit default: 4.0 # OptionParser:365 5311 Parsing opt spec: spec => chunk-time=f desc => Adjust the chunk size dynamically so each data-copy query takes this long to execute (default 0.5) group => default # OptionParser:403 5311 chunk-time type: f # OptionParser:410 5311 chunk-time default: 0.5 # OptionParser:365 5311 Parsing opt spec: group => default desc => Read this comma-separated list of config files; if specified, this must be the first option on the command line spec => config=A # OptionParser:403 5311 config type: A # OptionParser:365 5311 Parsing opt spec: group => default spec => critical-load=A desc => Examine SHOW GLOBAL STATUS after every chunk, and abort if the load is too high (default Threads_running=50) # OptionParser:403 5311 critical-load type: A # OptionParser:410 5311 critical-load default: Threads_running=50 # OptionParser:365 5311 Parsing opt spec: spec => database|D=s desc => Connect to this database group => default # OptionParser:403 5311 database type: s # OptionParser:365 5311 Parsing opt spec: spec => default-engine desc => Remove ENGINE from the new table group => default # OptionParser:403 5311 default-engine type: undef # OptionParser:365 5311 Parsing opt spec: desc => Only read mysql options from the given file spec => defaults-file|F=s group => default # OptionParser:403 5311 defaults-file type: s # OptionParser:365 5311 Parsing opt spec: desc => Drop the new table if copying the original table fails (default yes) spec => drop-new-table! group => default # OptionParser:403 5311 drop-new-table type: undef # OptionParser:410 5311 drop-new-table default: yes # OptionParser:365 5311 Parsing opt spec: group => default spec => drop-old-table! desc => Drop the original table after renaming it (default yes) # OptionParser:403 5311 drop-old-table type: undef # OptionParser:410 5311 drop-old-table default: yes # OptionParser:365 5311 Parsing opt spec: group => default desc => Drop triggers on the old table. --no-drop-triggers forces --no-drop-old-table (default yes) spec => drop-triggers! # OptionParser:403 5311 drop-triggers type: undef # OptionParser:410 5311 drop-triggers default: yes # OptionParser:365 5311 Parsing opt spec: group => default desc => Create and alter the new table, but do not create triggers, copy data, or replace the original table spec => dry-run # OptionParser:403 5311 dry-run type: undef # OptionParser:365 5311 Parsing opt spec: spec => execute desc => Indicate that you have read the documentation and want to alter the table group => default # OptionParser:403 5311 execute type: undef # OptionParser:365 5311 Parsing opt spec: group => default desc => This options bypasses confirmation in case of using alter-foreign-keys-method = none , which might break foreign key constraints spec => force # OptionParser:403 5311 force type: undef # OptionParser:365 5311 Parsing opt spec: group => default spec => help desc => Show help and exit # OptionParser:403 5311 help type: undef # OptionParser:365 5311 Parsing opt spec: group => default spec => host|h=s desc => Connect to host # OptionParser:403 5311 host type: s # OptionParser:365 5311 Parsing opt spec: group => default desc => Pause the data copy until all replicas' lag is less than this value (default 1s) spec => max-lag=m # OptionParser:403 5311 max-lag type: m # OptionParser:410 5311 max-lag default: 1s # OptionParser:365 5311 Parsing opt spec: group => default spec => max-load=A desc => Examine SHOW GLOBAL STATUS after every chunk, and pause if any status variables are higher than their thresholds (default Threads_running=25) # OptionParser:403 5311 max-load type: A # OptionParser:410 5311 max-load default: Threads_running=25 # OptionParser:365 5311 Parsing opt spec: group => default spec => new-table-name=s desc => New table name before it is swapped. %T is replaced with the original table name (default %T_new) # OptionParser:403 5311 new-table-name type: s # OptionParser:410 5311 new-table-name default: %T_new # OptionParser:365 5311 Parsing opt spec: group => default desc => Password to use when connecting spec => password|p=s # OptionParser:403 5311 password type: s # OptionParser:365 5311 Parsing opt spec: group => default desc => Create the given PID file spec => pid=s # OptionParser:403 5311 pid type: s # OptionParser:365 5311 Parsing opt spec: desc => Perl module file that defines a pt_online_schema_change_plugin class spec => plugin=s group => default # OptionParser:403 5311 plugin type: s # OptionParser:365 5311 Parsing opt spec: spec => port|P=i desc => Port number to use for connection group => default # OptionParser:403 5311 port type: i # OptionParser:365 5311 Parsing opt spec: group => default desc => Print SQL statements to STDOUT spec => print # OptionParser:403 5311 print type: undef # OptionParser:365 5311 Parsing opt spec: group => default desc => Print progress reports to STDERR while copying rows (default time,30) spec => progress=a # OptionParser:403 5311 progress type: a # OptionParser:410 5311 progress default: time,30 # OptionParser:365 5311 Parsing opt spec: group => default spec => quiet|q desc => Do not print messages to STDOUT (disables --progress) # OptionParser:403 5311 quiet type: undef # OptionParser:419 5311 Deferring check of disables rule for HASH(0x215f858) disables --progress) # OptionParser:365 5311 Parsing opt spec: desc => Number of levels to recurse in the hierarchy when discovering replicas spec => recurse=i group => default # OptionParser:403 5311 recurse type: i # OptionParser:365 5311 Parsing opt spec: group => default spec => recursion-method=a desc => Preferred recursion method for discovering replicas (default processlist,hosts) # OptionParser:403 5311 recursion-method type: a # OptionParser:410 5311 recursion-method default: processlist,hosts # OptionParser:365 5311 Parsing opt spec: group => default spec => set-vars=A desc => Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:403 5311 set-vars type: A # OptionParser:365 5311 Parsing opt spec: desc => Socket file to use for connection spec => socket|S=s group => default # OptionParser:403 5311 socket type: s # OptionParser:365 5311 Parsing opt spec: desc => Print statistics about internal counters spec => statistics group => default # OptionParser:403 5311 statistics type: undef # OptionParser:365 5311 Parsing opt spec: group => default desc => Swap the original table and the new, altered table (default yes) spec => swap-tables! # OptionParser:403 5311 swap-tables type: undef # OptionParser:410 5311 swap-tables default: yes # OptionParser:365 5311 Parsing opt spec: spec => tries=a desc => How many times to try critical operations group => default # OptionParser:403 5311 tries type: a # OptionParser:365 5311 Parsing opt spec: group => default desc => User for login if not current user spec => user|u=s # OptionParser:403 5311 user type: s # OptionParser:365 5311 Parsing opt spec: group => default spec => version desc => Show version and exit # OptionParser:403 5311 version type: undef # OptionParser:365 5311 Parsing opt spec: spec => version-check! desc => Check for the latest version of Percona Toolkit, MySQL, and other programs (default yes) group => default # OptionParser:403 5311 version-check type: undef # OptionParser:410 5311 version-check default: yes # OptionParser:425 5311 Parsing rule: --dry-run and --execute are mutually exclusive. # OptionParser:481 5311 Participants for --dry-run and --execute are mutually exclusive. : dry-run execute # OptionParser:433 5311 dry-run execute are mutually exclusive # OptionParser:425 5311 Parsing rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:481 5311 Participants for This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. : # OptionParser:457 5311 Strict mode disabled by rule # OptionParser:481 5311 Participants for disables --progress) : progress # OptionParser:467 5311 Option quiet disables progress # OptionParser:209 5311 Parsing DSN OPTIONS # OptionParser:299 5311 =item * A # OptionParser:326 5311 Short help: Default character set # OptionParser:299 5311 =item * D # OptionParser:326 5311 Short help: Database for the old and new table # OptionParser:299 5311 =item * F # OptionParser:326 5311 Short help: Only read default options from the given file # OptionParser:299 5311 =item * h # OptionParser:326 5311 Short help: Connect to host # OptionParser:299 5311 =item * p # OptionParser:326 5311 Short help: Password to use when connecting # OptionParser:299 5311 =item * P # OptionParser:326 5311 Short help: Port number to use for connection # OptionParser:299 5311 =item * S # OptionParser:326 5311 Short help: Socket file to use for connection # OptionParser:299 5311 =item * t # OptionParser:326 5311 Short help: Table to alter # OptionParser:299 5311 =item * u # OptionParser:326 5311 Short help: User for login if not current user # DSNParser:2070 5311 DSN option: desc=Default character set, dsn=charset, copy=1, key=A # DSNParser:2070 5311 DSN option: key=D, desc=Database for the old and new table, copy=1, dsn=database # DSNParser:2070 5311 DSN option: key=F, copy=1, dsn=mysql_read_default_file, desc=Only read default options from the given file # DSNParser:2070 5311 DSN option: desc=Connect to host, copy=1, dsn=host, key=h # DSNParser:2070 5311 DSN option: key=p, desc=Password to use when connecting, copy=1, dsn=password # DSNParser:2070 5311 DSN option: key=P, desc=Port number to use for connection, copy=1, dsn=port # DSNParser:2070 5311 DSN option: dsn=mysql_socket, copy=1, desc=Socket file to use for connection, key=S # DSNParser:2070 5311 DSN option: dsn=table, copy=, desc=Table to alter, key=t # DSNParser:2070 5311 DSN option: copy=1, dsn=user, desc=User for login if not current user, key=u # OptionParser:253 5311 pt-online-schema-change 2.2.13 # OptionParser:575 5311 Cannot open /etc/percona-toolkit/percona-toolkit.conf: No such file or directory # # OptionParser:575 5311 Cannot open /etc/percona-toolkit/pt-online-schema-change.conf: No such file or directory # # OptionParser:575 5311 Cannot open /root/.percona-toolkit.conf: No such file or directory # # OptionParser:575 5311 Cannot open /root/.pt-online-schema-change.conf: No such file or directory # # OptionParser:543 5311 Got option recursion-method = dsn=h=10.0.2.148,D=percona,t=dsns # OptionParser:543 5311 Got option check-replication-filters = 0 # OptionParser:543 5311 Got option check-interval = 2 # OptionParser:543 5311 Got option max-lag = 60 # OptionParser:543 5311 Got option critical-load = Threads_running=10 # OptionParser:543 5311 Got option alter = modify ExtraText1 varchar(256) # OptionParser:543 5311 Got option execute = 1 # OptionParser:763 5311 Nothing to validate for option database type s value undef # OptionParser:763 5311 Nothing to validate for option chunk-index-columns type i value undef # OptionParser:763 5311 Nothing to validate for option alter type s value modify ExtraText1 varchar(256) # OptionParser:763 5311 Nothing to validate for option password type s value undef # OptionParser:763 5311 Nothing to validate for option port type i value undef # OptionParser:763 5311 Nothing to validate for option plugin type s value undef # OptionParser:763 5311 Nothing to validate for option pid type s value undef # OptionParser:763 5311 Nothing to validate for option new-table-name type s value %T_new # OptionParser:763 5311 Nothing to validate for option socket type s value undef # OptionParser:714 5311 Parsing option check-interval as a time value # OptionParser:719 5311 No suffix given; using s for check-interval (value: 2 ) # OptionParser:728 5311 Setting option check-interval to 2 # OptionParser:763 5311 Nothing to validate for option charset type s value undef # OptionParser:763 5311 Nothing to validate for option host type s value undef # OptionParser:714 5311 Parsing option max-lag as a time value # OptionParser:719 5311 No suffix given; using s for max-lag (value: 60 ) # OptionParser:728 5311 Setting option max-lag to 60 # OptionParser:763 5311 Nothing to validate for option user type s value undef # OptionParser:763 5311 Nothing to validate for option check-slave-lag type s value undef # OptionParser:763 5311 Nothing to validate for option chunk-size-limit type f value 4.0 # OptionParser:753 5311 Parsing option chunk-size as a size value # OptionParser:763 5311 Nothing to validate for option chunk-time type f value 0.5 # OptionParser:763 5311 Nothing to validate for option defaults-file type s value undef # OptionParser:763 5311 Nothing to validate for option alter-foreign-keys-method type s value undef # OptionParser:763 5311 Nothing to validate for option recurse type i value undef # OptionParser:763 5311 Nothing to validate for option chunk-index type s value undef # OptionParser:763 5311 Nothing to validate for option tries type a value undef # OptionParser:1157 5311 --set-vars: $VAR1 = { # innodb_lock_wait_timeout => { # default => 1, # val => '1' # }, # lock_wait_timeout => { # default => 1, # val => '60' # }, # wait_timeout => { # default => 1, # val => '10000' # } # }; # # DSNParser:2086 5311 Setting set-vars property # DSNParser:2158 5311 DSN string made from options: # DSNParser:2095 5311 No DSN to parse # DSNParser:2098 5311 Parsing h=10.0.2.148,D=ATData,t=Retest,u=root,p=password # DSNParser:2117 5311 Finding value for F # DSNParser:2127 5311 Copying value for F from defaults # DSNParser:2117 5311 Finding value for P # DSNParser:2127 5311 Copying value for P from defaults # DSNParser:2117 5311 Finding value for h # DSNParser:2117 5311 Finding value for A # DSNParser:2127 5311 Copying value for A from defaults # DSNParser:2117 5311 Finding value for u # DSNParser:2117 5311 Finding value for D # DSNParser:2117 5311 Finding value for p # DSNParser:2117 5311 Finding value for S # DSNParser:2127 5311 Copying value for S from defaults # DSNParser:2117 5311 Finding value for t # pt_online_schema_change:9599 5311 --tries: $VAR1 = { # copy_rows => { # tries => 10, # wait => '0.25' # }, # create_triggers => { # tries => 10, # wait => 1 # }, # drop_triggers => { # tries => 10, # wait => 1 # }, # swap_tables => { # tries => 10, # wait => 1 # }, # update_foreign_keys => { # tries => 10, # wait => 1 # } # }; # # OptionParser:837 5311 Getting description and usage from SYNOPSIS in /usr/local/bin/pt-online-schema-change # OptionParser:1090 5311 Parsing SYNOPSIS in /usr/local/bin/pt-online-schema-change # OptionParser:1103 5311 Raw SYNOPSIS text: Usage: pt-online-schema-change [OPTIONS] DSN # # pt-online-schema-change alters a table's structure without blocking reads or # writes. Specify the database and table in the DSN. Do not use this tool before # reading its documentation and checking your backups carefully. # # # OptionParser:841 5311 Description: pt-online-schema-change alters a table's structure without blocking reads or writes. Specify the database and table in the DSN. Do not use this tool before reading its documentation and checking your backups carefully. # Usage: pt-online-schema-change [OPTIONS] DSN # DSNParser:2158 5311 DSN string made from options: # DSNParser:2095 5311 No DSN to parse # DSNParser:2211 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client root password PrintError=>0, AutoCommit=>1, ShowErrorStatement=>1, mysql_enable_utf8=>0, RaiseError=>1 # DSNParser:2288 5311 DBI::db=HASH(0x23ab070) SELECT @@SQL_MODE # DSNParser:2419 5311 DBI::db=HASH(0x23ab070) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:2419 5311 DBI::db=HASH(0x23ab070) SET SESSION lock_wait_timeout=60 # DSNParser:2419 5311 DBI::db=HASH(0x23ab070) SET SESSION wait_timeout=10000 # DSNParser:2319 5311 DBI::db=HASH(0x23ab070) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2328 5311 DBH info: DBI::db=HASH(0x23ab070) $VAR1 = { # '@@hostname' => 'ASE1TestVM', # 'CONNECTION_ID()' => '10', # 'DATABASE()' => 'ATData', # 'VERSION()' => '5.6.19-0ubuntu0.14.04.1-log' # }; # Connection info: 10.0.2.148 via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # 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.025 $DBI::VERSION: 1.63 # Cxn:3808 5311 DBI::db=HASH(0x23ab070) Setting dbh # Cxn:3813 5311 DBI::db=HASH(0x23ab070) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3815 5311 DBI::db=HASH(0x23ab070) hostname: ASE1TestVM 148 # Cxn:3796 5311 DBI::db=HASH(0x23ab070) Connected dbh to ASE1TestVM h=10.0.2.148 # DSNParser:2158 5311 DSN string made from options: # DSNParser:2095 5311 No DSN to parse # DSNParser:2211 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client root password PrintError=>0, mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1 # DSNParser:2288 5311 DBI::db=HASH(0x23aa338) SELECT @@SQL_MODE # DSNParser:2419 5311 DBI::db=HASH(0x23aa338) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:2419 5311 DBI::db=HASH(0x23aa338) SET SESSION lock_wait_timeout=60 # DSNParser:2419 5311 DBI::db=HASH(0x23aa338) SET SESSION wait_timeout=10000 # DSNParser:2319 5311 DBI::db=HASH(0x23aa338) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2328 5311 DBH info: DBI::db=HASH(0x23aa338) $VAR1 = { # '@@hostname' => 'ASE1TestVM', # 'CONNECTION_ID()' => '11', # 'DATABASE()' => 'ATData', # 'VERSION()' => '5.6.19-0ubuntu0.14.04.1-log' # }; # Connection info: 10.0.2.148 via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # 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.025 $DBI::VERSION: 1.63 # Cxn:3808 5311 DBI::db=HASH(0x23aa338) Setting dbh # Cxn:3813 5311 DBI::db=HASH(0x23aa338) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3815 5311 DBI::db=HASH(0x23aa338) hostname: ASE1TestVM 148 # Cxn:3796 5311 DBI::db=HASH(0x23aa338) Connected dbh to ASE1TestVM h=10.0.2.148 # Percona::XtraDB::Cluster:7621 5311 ASE1TestVM SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:7623 5311 $VAR1 = undef; # # VersionParser:1950 5311 VersionParser got a dbh, trying to get the version # VersionParser:1998 5311 InnoDB support: DEFAULT # VersionParser:2010 5311 InnoDB version: 5.6.19 # MasterSlave:4642 5311 DSN table DSN: h=10.0.2.148,D=percona,t=dsns # DSNParser:2098 5311 Parsing h=10.0.2.148,D=percona,t=dsns # DSNParser:2117 5311 Finding value for F # DSNParser:2127 5311 Copying value for F from defaults # DSNParser:2117 5311 Finding value for P # DSNParser:2127 5311 Copying value for P from defaults # DSNParser:2117 5311 Finding value for h # DSNParser:2117 5311 Finding value for A # DSNParser:2127 5311 Copying value for A from defaults # DSNParser:2117 5311 Finding value for u # DSNParser:2127 5311 Copying value for u from defaults # DSNParser:2117 5311 Finding value for D # DSNParser:2117 5311 Finding value for p # DSNParser:2127 5311 Copying value for p from defaults # DSNParser:2117 5311 Finding value for S # DSNParser:2127 5311 Copying value for S from defaults # DSNParser:2117 5311 Finding value for t # DSNParser:2158 5311 DSN string made from options: # DSNParser:2095 5311 No DSN to parse # DSNParser:2211 5311 DBI:mysql:percona;host=10.0.2.148;mysql_read_default_group=client # DSNParser:2260 5311 DBI:mysql:percona;host=10.0.2.148;mysql_read_default_group=client root password PrintError=>0, AutoCommit=>1, ShowErrorStatement=>1, mysql_enable_utf8=>0, RaiseError=>1 # DSNParser:2288 5311 DBI::db=HASH(0x243e460) SELECT @@SQL_MODE # DSNParser:2419 5311 DBI::db=HASH(0x243e460) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:2419 5311 DBI::db=HASH(0x243e460) SET SESSION lock_wait_timeout=60 # DSNParser:2419 5311 DBI::db=HASH(0x243e460) SET SESSION wait_timeout=10000 # DSNParser:2319 5311 DBI::db=HASH(0x243e460) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2328 5311 DBH info: DBI::db=HASH(0x243e460) $VAR1 = { # '@@hostname' => 'ASE1TestVM', # 'CONNECTION_ID()' => '12', # 'DATABASE()' => 'percona', # 'VERSION()' => '5.6.19-0ubuntu0.14.04.1-log' # }; # Connection info: 10.0.2.148 via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # 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.025 $DBI::VERSION: 1.63 # Cxn:3808 5311 DBI::db=HASH(0x243e460) Setting dbh # Cxn:3813 5311 DBI::db=HASH(0x243e460) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3815 5311 DBI::db=HASH(0x243e460) hostname: ASE1TestVM 148 # Cxn:3796 5311 DBI::db=HASH(0x243e460) Connected dbh to ASE1TestVM h=10.0.2.148 # Cxn:3804 5311 DBI::db=HASH(0x243e460) Already set dbh # Cxn:3796 5311 DBI::db=HASH(0x243e460) Connected dbh to ASE1TestVM h=10.0.2.148 # MasterSlave:4663 5311 SELECT dsn FROM `percona`.`dsns` ORDER BY id # MasterSlave:4668 5311 DSN from DSN table: h=10.0.2.199 # DSNParser:2158 5311 DSN string made from options: # DSNParser:2095 5311 No DSN to parse # DSNParser:2098 5311 Parsing h=10.0.2.199 # DSNParser:2117 5311 Finding value for F # DSNParser:2127 5311 Copying value for F from defaults # DSNParser:2117 5311 Finding value for P # DSNParser:2127 5311 Copying value for P from defaults # DSNParser:2117 5311 Finding value for h # DSNParser:2117 5311 Finding value for A # DSNParser:2127 5311 Copying value for A from defaults # DSNParser:2117 5311 Finding value for u # DSNParser:2123 5311 Copying value for u from previous DSN # DSNParser:2117 5311 Finding value for D # DSNParser:2123 5311 Copying value for D from previous DSN # DSNParser:2117 5311 Finding value for p # DSNParser:2123 5311 Copying value for p from previous DSN # DSNParser:2117 5311 Finding value for S # DSNParser:2127 5311 Copying value for S from defaults # DSNParser:2117 5311 Finding value for t # DSNParser:2127 5311 Copying value for t from defaults # DSNParser:2211 5311 DBI:mysql:ATData;host=10.0.2.199;mysql_read_default_group=client # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.199;mysql_read_default_group=client root password PrintError=>0, ShowErrorStatement=>1, mysql_enable_utf8=>0, AutoCommit=>1, RaiseError=>1 # DSNParser:2288 5311 DBI::db=HASH(0x243eef8) SELECT @@SQL_MODE # DSNParser:2419 5311 DBI::db=HASH(0x243eef8) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:2419 5311 DBI::db=HASH(0x243eef8) SET SESSION lock_wait_timeout=60 # DSNParser:2419 5311 DBI::db=HASH(0x243eef8) SET SESSION wait_timeout=10000 # DSNParser:2319 5311 DBI::db=HASH(0x243eef8) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2328 5311 DBH info: DBI::db=HASH(0x243eef8) $VAR1 = { # '@@hostname' => 'ASE2TestVM', # 'CONNECTION_ID()' => '16', # 'DATABASE()' => 'ATData', # 'VERSION()' => '5.6.19-0ubuntu0.14.04.1-log' # }; # Connection info: 10.0.2.199 via TCP/IP Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # 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.025 $DBI::VERSION: 1.63 # Cxn:3808 5311 DBI::db=HASH(0x243eef8) Setting dbh # Cxn:3813 5311 DBI::db=HASH(0x243eef8) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3815 5311 DBI::db=HASH(0x243eef8) hostname: ASE2TestVM 199 # Cxn:3796 5311 DBI::db=HASH(0x243eef8) Connected dbh to ASE2TestVM h=10.0.2.199 # Cxn:3922 5311 Destroying cxn # Cxn:3931 5311 DBI::db=HASH(0x243e460) Disconnecting dbh on ASE1TestVM h=10.0.2.148 # pt_online_schema_change:8249 5311 1 slaves found Found 1 slaves: ASE2TestVM # pt_online_schema_change:8274 5311 Will check slave lag on all slaves Will check slave lag on: ASE2TestVM # MySQLStatusWaiter:4843 5311 Parsing spec for max thresholds # MySQLStatusWaiter:4985 5311 Checking and setting values # pt_online_schema_change:8379 5311 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:5001 5311 Wait if Threads_running >= 25 # MySQLStatusWaiter:4853 5311 Parsing spec for critical thresholds # MySQLStatusWaiter:4985 5311 Checking and setting values # pt_online_schema_change:8379 5311 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:5001 5311 Wait if Threads_running >= 10 # VersionCheck:7077 5311 FindBin::Bin: /usr/local/bin # VersionCheck:7237 5311 SELECT CONCAT(@@hostname, @@port) # VersionCheck:7258 5311 MySQL instance: c3cad3ca2036d98e2fec1773f2ffb879 ASE1TestVM3306 $VAR1 = { # A => undef, # D => 'ATData', # F => undef, # P => undef, # S => undef, # h => '10.0.2.148', # p => 'password', # t => 'Retest', # u => 'root' # }; # # VersionCheck:7237 5311 SELECT CONCAT(@@hostname, @@port) # VersionCheck:7258 5311 MySQL instance: 48ac51a9b7096e2ad7fd58d7477c3e98 ASE2TestVM3306 $VAR1 = { # A => undef, # D => 'ATData', # F => undef, # P => undef, # S => undef, # h => '10.0.2.199', # p => 'password', # t => undef, # u => 'root' # }; # # VersionCheck:7057 5311 Version check file percona-version-check in /tmp # VersionCheck:7172 5311 Version check file /tmp/percona-version-check contents: 0,1436978517 # 14bd02a1a18bb8ab37cfe3c39a0f608c,1436811880 # 48ac51a9b7096e2ad7fd58d7477c3e98,1436978612 # 5e898cdd217c3fdc1491a88d14ef6465,1436811809 # 644a0421cbbe82e6377c48a2a1c135fe,1436811880 # c3cad3ca2036d98e2fec1773f2ffb879,1436978517 # da3804fa308ab02b7e4b8c416c8af520,1436811880 # VersionCheck:7180 5311 Intsance c3cad3ca2036d98e2fec1773f2ffb879 last checked 1436978517 now 1436983062 diff 4545 hours until next check 22.74 # VersionCheck:7180 5311 Intsance 48ac51a9b7096e2ad7fd58d7477c3e98 last checked 1436978612 now 1436983062 diff 4450 hours until next check 22.76 # VersionCheck:7180 5311 Intsance 0 last checked 1436978517 now 1436983062 diff 4545 hours until next check 22.74 # VersionCheck:7100 5311 0 instances to check # TableParser:3290 5311 Checking `ATData`.`Retest` # TableParser:3294 5311 SHOW TABLES FROM `ATData` LIKE 'Retest' # TableParser:3308 5311 Table ATData Retest exists # pt_online_schema_change:10007 5311 SHOW TRIGGERS FROM `ATData` LIKE 'Retest' # TableParser:3119 5311 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:3124 5311 DBI::db=HASH(0x23ab070) USE `ATData` # TableParser:3128 5311 SHOW CREATE TABLE `ATData`.`Retest` # TableParser:3138 5311 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:3316 5311 Storage engine: InnoDB # TableParser:3170 5311 Table cols: `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` # TableParser:3316 5311 Storage engine: InnoDB # TableParser:3332 5311 Parsed key: PRIMARY KEY (`rindex`), # TableParser:3352 5311 PRIMARY key cols: `rindex` # TableParser:3374 5311 This key is the clustered key # TableParser:3332 5311 Parsed key: KEY `bo` (`bo`), # TableParser:3352 5311 bo key cols: `bo` # TableParser:3332 5311 Parsed key: KEY `sourcereel` (`sourcereel`), # TableParser:3352 5311 sourcereel key cols: `sourcereel` # TableParser:3332 5311 Parsed key: KEY `newreel` (`newreel`), # TableParser:3352 5311 newreel key cols: `newreel` # TableParser:3332 5311 Parsed key: KEY `tindex` (`tindex`), # TableParser:3352 5311 tindex key cols: `tindex` # TableParser:3332 5311 Parsed key: KEY `eepromimage` (`eepromimage`), # TableParser:3352 5311 eepromimage key cols: `eepromimage` # TableParser:3332 5311 Parsed key: KEY `dtime` (`dtime`), # TableParser:3352 5311 dtime key cols: `dtime` # TableParser:3332 5311 Parsed key: KEY `reprocess` (`reprocess`), # TableParser:3352 5311 reprocess key cols: `reprocess` # TableParser:3332 5311 Parsed key: KEY `serialnumber` (`serialnumber`), # TableParser:3352 5311 serialnumber key cols: `serialnumber` # TableParser:3332 5311 Parsed key: KEY `specindex` (`specindex`) # TableParser:3352 5311 specindex key cols: `specindex` # NibbleIterator:5598 5311 EXPLAIN SELECT * FROM `ATData`.`Retest` WHERE 1=1 # NibbleIterator:5600 5311 $VAR1 = { # extra => undef, # id => '1', # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => '5406492', # select_type => 'SIMPLE', # table => 'Retest', # type => 'ALL' # }; # # NibbleIterator:5475 5311 One nibble: no # NibbleIterator:5530 5311 Auto-selecting best index # TableParser:3231 5311 Indexes sorted best-first: PRIMARY, bo, dtime, eepromimage, newreel, reprocess, serialnumber, sourcereel, specindex, tindex # NibbleIterator:5563 5311 Best index: PRIMARY Operation, tries, wait: copy_rows, 10, 0.25 create_triggers, 10, 1 drop_triggers, 10, 1 swap_tables, 10, 1 update_foreign_keys, 10, 1 # pt_online_schema_change:10054 5311 Finding child tables # pt_online_schema_change:10060 5311 SELECT table_schema, table_name FROM information_schema.key_column_usage WHERE referenced_table_schema='ATData' AND referenced_table_name='Retest' # pt_online_schema_change:10063 5311 No child tables found Altering `ATData`.`Retest`... # CleanupTask:6170 5311 Created cleanup task CODE(0x243ec88) # pt_online_schema_change:9737 5311 Renamed columns (old => new): $VAR1 = {}; # # Percona::XtraDB::Cluster:7621 5311 ASE1TestVM SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:7623 5311 $VAR1 = undef; # # TableParser:3119 5311 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:3124 5311 DBI::db=HASH(0x23ab070) USE `ATData` # TableParser:3128 5311 SHOW CREATE TABLE `ATData`.`Retest` # TableParser:3138 5311 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ Creating new table... # pt_online_schema_change:9866 5311 CREATE TABLE `ATData`.`_Retest_new` ( # `Rindex` int(11) NOT NULL AUTO_INCREMENT, # `tindex` int(11) DEFAULT NULL, # `SourceReel` int(11) DEFAULT NULL, # `SourcePocket` int(11) DEFAULT NULL, # `NewReel` int(11) DEFAULT NULL, # `NewPocket` int(11) DEFAULT NULL, # `BoardID` varchar(20) DEFAULT NULL, # `DUTLocation` smallint(6) DEFAULT NULL, # `RunNumber` varchar(20) DEFAULT NULL, # `BO` int(11) DEFAULT NULL, # `Reprocess` int(11) DEFAULT NULL COMMENT 'Indication of whether part is reprocessed', # `SpecIndex` int(11) DEFAULT NULL, # `Bin` int(11) DEFAULT NULL, # `Passed` tinyint(1) DEFAULT NULL, # `LV_eeprom_pass` tinyint(1) DEFAULT NULL, # `LV_eeprom_Vdd` float DEFAULT NULL, # `Row` tinyint(8) DEFAULT NULL, # `Col` tinyint(8) DEFAULT NULL, # `dtime` datetime DEFAULT NULL, # `Current` float DEFAULT NULL, # `AltCurrent` float DEFAULT NULL COMMENT 'Alternate Current Measurement (depends on chip settings)', # `DisableCurrent` float DEFAULT NULL, # `BoardCurrent` float DEFAULT NULL, # `OffX_Org` float DEFAULT NULL, # `OffY_Org` float DEFAULT NULL, # `OffZ_Org` float DEFAULT NULL, # `SenseX` float DEFAULT NULL, # `SenseY` float DEFAULT NULL, # `SenseZ` float DEFAULT NULL, # `OffsetX` float DEFAULT NULL, # `OffsetY` float DEFAULT NULL, # `OffsetZ` float DEFAULT NULL, # `Sxx` float DEFAULT NULL, # `Sxy` float DEFAULT NULL, # `Sxz` float DEFAULT NULL, # `Syx` float DEFAULT NULL, # `Syy` float DEFAULT NULL, # `Syz` float DEFAULT NULL, # `Szx` float DEFAULT NULL, # `Szy` float DEFAULT NULL, # `Szz` float DEFAULT NULL, # `OffX` float DEFAULT NULL, # `OffY` float DEFAULT NULL, # `OffZ` float DEFAULT NULL, # `CommunicationsCheckValue` float DEFAULT NULL COMMENT 'Diagnostic Code for Communications Check', # `SocketCheckX` float DEFAULT NULL COMMENT 'Measurement for Socketing Check', # `SocketCheckY` float DEFAULT NULL COMMENT 'Measurement for Socketing Check', # `SocketCheckZ` float DEFAULT NULL COMMENT 'Measurement for Socketing Check', # `StabilityX` float unsigned DEFAULT NULL COMMENT 'Output Stability Measurement. Typically Std (volts or counts) of filtered measurements', # `StabilityY` float unsigned DEFAULT NULL COMMENT 'Output Stability Measurement. Typically Std (volts or counts) of filtered measurements', # `StabilityZ` float unsigned DEFAULT NULL COMMENT 'Output Stability Measurement. Typically Std (volts or counts) of filtered measurements', # `BandGapTrimCode` smallint(5) unsigned DEFAULT NULL COMMENT 'Trim Code for Band Gap', # `BandGapTrimVoltage` float DEFAULT NULL, # `BandGapLowVoltage` float unsigned DEFAULT NULL COMMENT 'BandGap Voltage Measured at Low Vdd', # `BandGapHighVoltage` float unsigned DEFAULT NULL COMMENT 'BandGap Voltage Measured at High Vdd', # `RegulatorTrimVoltage` float DEFAULT NULL, # `Vt` float DEFAULT NULL COMMENT 'Voltage Measurement of Vt', # `Vmid` float DEFAULT NULL COMMENT 'Voltage Measurement of mid', # `FGX` smallint(6) DEFAULT NULL, # `FGY` smallint(6) DEFAULT NULL, # `FGZ` smallint(6) DEFAULT NULL, # `FOX` smallint(6) DEFAULT NULL, # `FOY` smallint(6) DEFAULT NULL, # `FOZ` smallint(6) DEFAULT NULL, # `TemperatureOutputTrimCode` float DEFAULT NULL COMMENT 'Trim Code for Temperature Output', # `TemperatureOutput` float DEFAULT NULL COMMENT 'Temperature Output', # `TCompX` smallint(6) DEFAULT NULL, # `TCompY` smallint(6) DEFAULT NULL, # `TCompZ` smallint(6) DEFAULT NULL, # `Temperature_hot` float DEFAULT NULL COMMENT 'Hot socket Temperature', # `Temperature_ambient` float DEFAULT NULL COMMENT 'Tipper socket Temperature', # `Temperature_cold` float DEFAULT NULL COMMENT 'Cold socket Temperature', # `OffX_Org_Cold` float DEFAULT NULL COMMENT '1G Z offset in cold socket', # `OffY_Org_Cold` float DEFAULT NULL COMMENT '1G Z offset in cold socket', # `OffZ_Org_Cold` float DEFAULT NULL COMMENT '1G Z offset in cold socket', # `OffX_Org_Hot` float DEFAULT NULL COMMENT '1G Z offset in hot socket', # `OffY_Org_Hot` float DEFAULT NULL COMMENT '1G Z offset in hot socket', # `OffZ_Org_Hot` float DEFAULT NULL COMMENT '1G Z offset in hot socket', # `RCompX` smallint(6) DEFAULT NULL, # `RCompY` smallint(6) DEFAULT NULL, # `RCompZ` smallint(6) DEFAULT NULL, # `FF_Int` smallint(6) DEFAULT NULL, # `FF_delay` smallint(6) DEFAULT NULL, # `MOT_Int` smallint(6) DEFAULT NULL, # `MOT_delay` smallint(6) DEFAULT NULL, # `Polarity` tinyint(1) DEFAULT NULL, # `SelfTestTrimCodeX` smallint(5) unsigned DEFAULT NULL COMMENT 'Trim Code for Self Test', # `SelfTestTrimCodeY` smallint(5) unsigned DEFAULT NULL COMMENT 'Trim Code for Self Test', # `SelfTestTrimCodeZ` smallint(5) unsigned DEFAULT NULL COMMENT 'Trim Code for Self Test', # `SelfTestX` float DEFAULT NULL, # `SelfTestY` float DEFAULT NULL, # `SelfTestZ` float DEFAULT NULL, # `NegSelfTestX` float DEFAULT NULL COMMENT 'Delta Between SelfTest On and SelfTest Off for Negative Polarity SelfTest', # `NegSelfTestY` float DEFAULT NULL COMMENT 'Delta Between SelfTest On and SelfTest Off for Negative Polarity SelfTest', # `NegSelfTestZ` float DEFAULT NULL COMMENT 'Delta Between SelfTest On and SelfTest Off for Negative Polarity SelfTest', # `OffsetRatioErrorX` float DEFAULT NULL, # `OffsetRatioErrorY` float DEFAULT NULL, # `OffsetRatioErrorZ` float DEFAULT NULL, # `SenseRatioHighX` float DEFAULT NULL, # `SenseRatioHighY` float DEFAULT NULL, # `SenseRatioHighZ` float DEFAULT NULL, # `SenseRatioLowX` float DEFAULT NULL, # `SenseRatioLowY` float DEFAULT NULL, # `SenseRatioLowZ` float DEFAULT NULL, # `OffsetRatioHighX` float DEFAULT NULL, # `OffsetRatioHighY` float DEFAULT NULL, # `OffsetRatioHighZ` float DEFAULT NULL, # `OffsetRatioLowX` float DEFAULT NULL, # `OffsetRatioLowY` float DEFAULT NULL, # `OffsetRatioLowZ` float DEFAULT NULL, # `HPFOutputX` float DEFAULT NULL, # `HPFOutputY` float DEFAULT NULL, # `HPFOutputZ` float DEFAULT NULL, # `Seltest` tinyint(8) DEFAULT NULL, # `IntSpd` tinyint(16) DEFAULT NULL, # `VCO` tinyint(16) DEFAULT NULL, # `Clock_Period` float DEFAULT NULL, # `InitialVCOFreq` float unsigned DEFAULT NULL COMMENT 'Frequency of VCO with Trim Code set to InitialVCOCode', # `WDTTrimCode` smallint(5) DEFAULT NULL COMMENT 'Watch Dog Timer Trim Code', # `WDTFreq` float DEFAULT NULL COMMENT 'Watch Dog Timer Trimmed Frequency', # `Mode` tinyint(8) DEFAULT NULL, # `Parity` tinyint(1) DEFAULT NULL, # `Extra1` float unsigned DEFAULT NULL COMMENT 'Extra Field for Misc Information', # `Extra2` float unsigned DEFAULT NULL COMMENT 'Extra Field for Misc Information', # `Extra3` float unsigned DEFAULT NULL COMMENT 'Extra Field for Misc Information', # `Extra4` float unsigned DEFAULT NULL COMMENT 'Extra Field for Misc Information', # `ExtraText1` varchar(72) DEFAULT NULL COMMENT 'Extra Field for Misc Information', # `ExtraText2` varchar(72) DEFAULT NULL COMMENT 'Extra Field for Misc Information', # `ExtraText3` varchar(72) DEFAULT NULL COMMENT 'Extra Field for Misc Information', # `ExtraText4` varchar(72) DEFAULT NULL COMMENT 'Extra Field for Misc Information', # `UniqueModuleID` varchar(15) DEFAULT NULL, # `EEPROMImage` varchar(256) DEFAULT NULL, # `SerialNumber` bigint(10) DEFAULT NULL COMMENT 'Official Serial Number handed out by MySQL function GetSerialNumber', # `SDFNPartIndex` int(10) unsigned NOT NULL COMMENT 'Cross-reference to PartIndex in ATTherm', # PRIMARY KEY (`Rindex`), # KEY `BO` (`BO`), # KEY `SourceReel` (`SourceReel`), # KEY `NewReel` (`NewReel`), # KEY `tindex` (`tindex`), # KEY `EEPROMImage` (`EEPROMImage`), # KEY `dtime` (`dtime`), # KEY `Reprocess` (`Reprocess`), # KEY `SerialNumber` (`SerialNumber`), # KEY `SpecIndex` (`SpecIndex`) # ) ENGINE=InnoDB AUTO_INCREMENT=34166780 DEFAULT CHARSET=latin1 Created new table ATData._Retest_new OK. # TableParser:3290 5311 Checking `ATData`.`_Retest_new` # TableParser:3294 5311 SHOW TABLES FROM `ATData` LIKE '\_Retest\_new' # TableParser:3308 5311 Table ATData _Retest_new exists Altering new table... # pt_online_schema_change:8819 5311 ALTER TABLE `ATData`.`_Retest_new` modify ExtraText1 varchar(256) Altered `ATData`.`_Retest_new` OK. # TableParser:3119 5311 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:3124 5311 DBI::db=HASH(0x23ab070) USE `ATData` # TableParser:3128 5311 SHOW CREATE TABLE `ATData`.`_Retest_new` # TableParser:3138 5311 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:3316 5311 Storage engine: InnoDB # TableParser:3170 5311 Table cols: `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` # TableParser:3316 5311 Storage engine: InnoDB # TableParser:3332 5311 Parsed key: PRIMARY KEY (`rindex`), # TableParser:3352 5311 PRIMARY key cols: `rindex` # TableParser:3374 5311 This key is the clustered key # TableParser:3332 5311 Parsed key: KEY `bo` (`bo`), # TableParser:3352 5311 bo key cols: `bo` # TableParser:3332 5311 Parsed key: KEY `sourcereel` (`sourcereel`), # TableParser:3352 5311 sourcereel key cols: `sourcereel` # TableParser:3332 5311 Parsed key: KEY `newreel` (`newreel`), # TableParser:3352 5311 newreel key cols: `newreel` # TableParser:3332 5311 Parsed key: KEY `tindex` (`tindex`), # TableParser:3352 5311 tindex key cols: `tindex` # TableParser:3332 5311 Parsed key: KEY `eepromimage` (`eepromimage`), # TableParser:3352 5311 eepromimage key cols: `eepromimage` # TableParser:3332 5311 Parsed key: KEY `dtime` (`dtime`), # TableParser:3352 5311 dtime key cols: `dtime` # TableParser:3332 5311 Parsed key: KEY `reprocess` (`reprocess`), # TableParser:3352 5311 reprocess key cols: `reprocess` # TableParser:3332 5311 Parsed key: KEY `serialnumber` (`serialnumber`), # TableParser:3352 5311 serialnumber key cols: `serialnumber` # TableParser:3332 5311 Parsed key: KEY `specindex` (`specindex`) # TableParser:3352 5311 specindex key cols: `specindex` # pt_online_schema_change:8853 5311 Common columns $VAR1 = [ # { # new => 'rindex', # old => 'rindex' # }, # { # new => 'tindex', # old => 'tindex' # }, # { # new => 'sourcereel', # old => 'sourcereel' # }, # { # new => 'sourcepocket', # old => 'sourcepocket' # }, # { # new => 'newreel', # old => 'newreel' # }, # { # new => 'newpocket', # old => 'newpocket' # }, # { # new => 'boardid', # old => 'boardid' # }, # { # new => 'dutlocation', # old => 'dutlocation' # }, # { # new => 'runnumber', # old => 'runnumber' # }, # { # new => 'bo', # old => 'bo' # }, # { # new => 'reprocess', # old => 'reprocess' # }, # { # new => 'specindex', # old => 'specindex' # }, # { # new => 'bin', # old => 'bin' # }, # { # new => 'passed', # old => 'passed' # }, # { # new => 'lv_eeprom_pass', # old => 'lv_eeprom_pass' # }, # { # new => 'lv_eeprom_vdd', # old => 'lv_eeprom_vdd' # }, # { # new => 'row', # old => 'row' # }, # { # new => 'col', # old => 'col' # }, # { # new => 'dtime', # old => 'dtime' # }, # { # new => 'current', # old => 'current' # }, # { # new => 'altcurrent', # old => 'altcurrent' # }, # { # new => 'disablecurrent', # old => 'disablecurrent' # }, # { # new => 'boardcurrent', # old => 'boardcurrent' # }, # { # new => 'offx_org', # old => 'offx_org' # }, # { # new => 'offy_org', # old => 'offy_org' # }, # { # new => 'offz_org', # old => 'offz_org' # }, # { # new => 'sensex', # old => 'sensex' # }, # { # new => 'sensey', # old => 'sensey' # }, # { # new => 'sensez', # old => 'sensez' # }, # { # new => 'offsetx', # old => 'offsetx' # }, # { # new => 'offsety', # old => 'offsety' # }, # { # new => 'offsetz', # old => 'offsetz' # }, # { # new => 'sxx', # old => 'sxx' # }, # { # new => 'sxy', # old => 'sxy' # }, # { # new => 'sxz', # old => 'sxz' # }, # { # new => 'syx', # old => 'syx' # }, # { # new => 'syy', # old => 'syy' # }, # { # new => 'syz', # old => 'syz' # }, # { # new => 'szx', # old => 'szx' # }, # { # new => 'szy', # old => 'szy' # }, # { # new => 'szz', # old => 'szz' # }, # { # new => 'offx', # old => 'offx' # }, # { # new => 'offy', # old => 'offy' # }, # { # new => 'offz', # old => 'offz' # }, # { # new => 'communicationscheckvalue', # old => 'communicationscheckvalue' # }, # { # new => 'socketcheckx', # old => 'socketcheckx' # }, # { # new => 'socketchecky', # old => 'socketchecky' # }, # { # new => 'socketcheckz', # old => 'socketcheckz' # }, # { # new => 'stabilityx', # old => 'stabilityx' # }, # { # new => 'stabilityy', # old => 'stabilityy' # }, # { # new => 'stabilityz', # old => 'stabilityz' # }, # { # new => 'bandgaptrimcode', # old => 'bandgaptrimcode' # }, # { # new => 'bandgaptrimvoltage', # old => 'bandgaptrimvoltage' # }, # { # new => 'bandgaplowvoltage', # old => 'bandgaplowvoltage' # }, # { # new => 'bandgaphighvoltage', # old => 'bandgaphighvoltage' # }, # { # new => 'regulatortrimvoltage', # old => 'regulatortrimvoltage' # }, # { # new => 'vt', # old => 'vt' # }, # { # new => 'vmid', # old => 'vmid' # }, # { # new => 'fgx', # old => 'fgx' # }, # { # new => 'fgy', # old => 'fgy' # }, # { # new => 'fgz', # old => 'fgz' # }, # { # new => 'fox', # old => 'fox' # }, # { # new => 'foy', # old => 'foy' # }, # { # new => 'foz', # old => 'foz' # }, # { # new => 'temperatureoutputtrimcode', # old => 'temperatureoutputtrimcode' # }, # { # new => 'temperatureoutput', # old => 'temperatureoutput' # }, # { # new => 'tcompx', # old => 'tcompx' # }, # { # new => 'tcompy', # old => 'tcompy' # }, # { # new => 'tcompz', # old => 'tcompz' # }, # { # new => 'temperature_hot', # old => 'temperature_hot' # }, # { # new => 'temperature_ambient', # old => 'temperature_ambient' # }, # { # new => 'temperature_cold', # old => 'temperature_cold' # }, # { # new => 'offx_org_cold', # old => 'offx_org_cold' # }, # { # new => 'offy_org_cold', # old => 'offy_org_cold' # }, # { # new => 'offz_org_cold', # old => 'offz_org_cold' # }, # { # new => 'offx_org_hot', # old => 'offx_org_hot' # }, # { # new => 'offy_org_hot', # old => 'offy_org_hot' # }, # { # new => 'offz_org_hot', # old => 'offz_org_hot' # }, # { # new => 'rcompx', # old => 'rcompx' # }, # { # new => 'rcompy', # old => 'rcompy' # }, # { # new => 'rcompz', # old => 'rcompz' # }, # { # new => 'ff_int', # old => 'ff_int' # }, # { # new => 'ff_delay', # old => 'ff_delay' # }, # { # new => 'mot_int', # old => 'mot_int' # }, # { # new => 'mot_delay', # old => 'mot_delay' # }, # { # new => 'polarity', # old => 'polarity' # }, # { # new => 'selftesttrimcodex', # old => 'selftesttrimcodex' # }, # { # new => 'selftesttrimcodey', # old => 'selftesttrimcodey' # }, # { # new => 'selftesttrimcodez', # old => 'selftesttrimcodez' # }, # { # new => 'selftestx', # old => 'selftestx' # }, # { # new => 'selftesty', # old => 'selftesty' # }, # { # new => 'selftestz', # old => 'selftestz' # }, # { # new => 'negselftestx', # old => 'negselftestx' # }, # { # new => 'negselftesty', # old => 'negselftesty' # }, # { # new => 'negselftestz', # old => 'negselftestz' # }, # { # new => 'offsetratioerrorx', # old => 'offsetratioerrorx' # }, # { # new => 'offsetratioerrory', # old => 'offsetratioerrory' # }, # { # new => 'offsetratioerrorz', # old => 'offsetratioerrorz' # }, # { # new => 'senseratiohighx', # old => 'senseratiohighx' # }, # { # new => 'senseratiohighy', # old => 'senseratiohighy' # }, # { # new => 'senseratiohighz', # old => 'senseratiohighz' # }, # { # new => 'senseratiolowx', # old => 'senseratiolowx' # }, # { # new => 'senseratiolowy', # old => 'senseratiolowy' # }, # { # new => 'senseratiolowz', # old => 'senseratiolowz' # }, # { # new => 'offsetratiohighx', # old => 'offsetratiohighx' # }, # { # new => 'offsetratiohighy', # old => 'offsetratiohighy' # }, # { # new => 'offsetratiohighz', # old => 'offsetratiohighz' # }, # { # new => 'offsetratiolowx', # old => 'offsetratiolowx' # }, # { # new => 'offsetratiolowy', # old => 'offsetratiolowy' # }, # { # new => 'offsetratiolowz', # old => 'offsetratiolowz' # }, # { # new => 'hpfoutputx', # old => 'hpfoutputx' # }, # { # new => 'hpfoutputy', # old => 'hpfoutputy' # }, # { # new => 'hpfoutputz', # old => 'hpfoutputz' # }, # { # new => 'seltest', # old => 'seltest' # }, # { # new => 'intspd', # old => 'intspd' # }, # { # new => 'vco', # old => 'vco' # }, # { # new => 'clock_period', # old => 'clock_period' # }, # { # new => 'initialvcofreq', # old => 'initialvcofreq' # }, # { # new => 'wdttrimcode', # old => 'wdttrimcode' # }, # { # new => 'wdtfreq', # old => 'wdtfreq' # }, # { # new => 'mode', # old => 'mode' # }, # { # new => 'parity', # old => 'parity' # }, # { # new => 'extra1', # old => 'extra1' # }, # { # new => 'extra2', # old => 'extra2' # }, # { # new => 'extra3', # old => 'extra3' # }, # { # new => 'extra4', # old => 'extra4' # }, # { # new => 'extratext1', # old => 'extratext1' # }, # { # new => 'extratext2', # old => 'extratext2' # }, # { # new => 'extratext3', # old => 'extratext3' # }, # { # new => 'extratext4', # old => 'extratext4' # }, # { # new => 'uniquemoduleid', # old => 'uniquemoduleid' # }, # { # new => 'eepromimage', # old => 'eepromimage' # }, # { # new => 'serialnumber', # old => 'serialnumber' # }, # { # new => 'sdfnpartindex', # old => 'sdfnpartindex' # } # ]; # # TableParser:3231 5311 Indexes sorted best-first: PRIMARY, bo, dtime, eepromimage, newreel, reprocess, serialnumber, sourcereel, specindex, tindex # pt_online_schema_change:8862 5311 Delete trigger new index: $VAR1 = 'PRIMARY'; # # pt_online_schema_change:8867 5311 New table delete index: PRIMARY # TableParser:3231 5311 Indexes sorted best-first: PRIMARY, bo, dtime, eepromimage, newreel, reprocess, serialnumber, sourcereel, specindex, tindex # pt_online_schema_change:8874 5311 Delete trigger orig index: $VAR1 = 'PRIMARY'; # # pt_online_schema_change:8879 5311 Orig table delete index: PRIMARY # pt_online_schema_change:8921 5311 Index for delete trigger: table `ATData`.`_Retest_new` index PRIMARY columns rindex 2015-07-15T12:57:43 Creating triggers... # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10359 5311 CREATE TRIGGER `pt_osc_ATData_Retest_del` AFTER DELETE ON `ATData`.`Retest` FOR EACH ROW DELETE IGNORE FROM `ATData`.`_Retest_new` WHERE `ATData`.`_Retest_new`.`rindex` <=> OLD.`rindex` # Retry:3683 5311 Try code succeeded # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10359 5311 CREATE TRIGGER `pt_osc_ATData_Retest_upd` AFTER UPDATE ON `ATData`.`Retest` FOR EACH ROW REPLACE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) VALUES (NEW.`rindex`, NEW.`tindex`, NEW.`sourcereel`, NEW.`sourcepocket`, NEW.`newreel`, NEW.`newpocket`, NEW.`boardid`, NEW.`dutlocation`, NEW.`runnumber`, NEW.`bo`, NEW.`reprocess`, NEW.`specindex`, NEW.`bin`, NEW.`passed`, NEW.`lv_eeprom_pass`, NEW.`lv_eeprom_vdd`, NEW.`row`, NEW.`col`, NEW.`dtime`, NEW.`current`, NEW.`altcurrent`, NEW.`disablecurrent`, NEW.`boardcurrent`, NEW.`offx_org`, NEW.`offy_org`, NEW.`offz_org`, NEW.`sensex`, NEW.`sensey`, NEW.`sensez`, NEW.`offsetx`, NEW.`offsety`, NEW.`offsetz`, NEW.`sxx`, NEW.`sxy`, NEW.`sxz`, NEW.`syx`, NEW.`syy`, NEW.`syz`, NEW.`szx`, NEW.`szy`, NEW.`szz`, NEW.`offx`, NEW.`offy`, NEW.`offz`, NEW.`communicationscheckvalue`, NEW.`socketcheckx`, NEW.`socketchecky`, NEW.`socketcheckz`, NEW.`stabilityx`, NEW.`stabilityy`, NEW.`stabilityz`, NEW.`bandgaptrimcode`, NEW.`bandgaptrimvoltage`, NEW.`bandgaplowvoltage`, NEW.`bandgaphighvoltage`, NEW.`regulatortrimvoltage`, NEW.`vt`, NEW.`vmid`, NEW.`fgx`, NEW.`fgy`, NEW.`fgz`, NEW.`fox`, NEW.`foy`, NEW.`foz`, NEW.`temperatureoutputtrimcode`, NEW.`temperatureoutput`, NEW.`tcompx`, NEW.`tcompy`, NEW.`tcompz`, NEW.`temperature_hot`, NEW.`temperature_ambient`, NEW.`temperature_cold`, NEW.`offx_org_cold`, NEW.`offy_org_cold`, NEW.`offz_org_cold`, NEW.`offx_org_hot`, NEW.`offy_org_hot`, NEW.`offz_org_hot`, NEW.`rcompx`, NEW.`rcompy`, NEW.`rcompz`, NEW.`ff_int`, NEW.`ff_delay`, NEW.`mot_int`, NEW.`mot_delay`, NEW.`polarity`, NEW.`selftesttrimcodex`, NEW.`selftesttrimcodey`, NEW.`selftesttrimcodez`, NEW.`selftestx`, NEW.`selftesty`, NEW.`selftestz`, NEW.`negselftestx`, NEW.`negselftesty`, NEW.`negselftestz`, NEW.`offsetratioerrorx`, NEW.`offsetratioerrory`, NEW.`offsetratioerrorz`, NEW.`senseratiohighx`, NEW.`senseratiohighy`, NEW.`senseratiohighz`, NEW.`senseratiolowx`, NEW.`senseratiolowy`, NEW.`senseratiolowz`, NEW.`offsetratiohighx`, NEW.`offsetratiohighy`, NEW.`offsetratiohighz`, NEW.`offsetratiolowx`, NEW.`offsetratiolowy`, NEW.`offsetratiolowz`, NEW.`hpfoutputx`, NEW.`hpfoutputy`, NEW.`hpfoutputz`, NEW.`seltest`, NEW.`intspd`, NEW.`vco`, NEW.`clock_period`, NEW.`initialvcofreq`, NEW.`wdttrimcode`, NEW.`wdtfreq`, NEW.`mode`, NEW.`parity`, NEW.`extra1`, NEW.`extra2`, NEW.`extra3`, NEW.`extra4`, NEW.`extratext1`, NEW.`extratext2`, NEW.`extratext3`, NEW.`extratext4`, NEW.`uniquemoduleid`, NEW.`eepromimage`, NEW.`serialnumber`, NEW.`sdfnpartindex`) # Retry:3683 5311 Try code succeeded # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10359 5311 CREATE TRIGGER `pt_osc_ATData_Retest_ins` AFTER INSERT ON `ATData`.`Retest` FOR EACH ROW REPLACE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) VALUES (NEW.`rindex`, NEW.`tindex`, NEW.`sourcereel`, NEW.`sourcepocket`, NEW.`newreel`, NEW.`newpocket`, NEW.`boardid`, NEW.`dutlocation`, NEW.`runnumber`, NEW.`bo`, NEW.`reprocess`, NEW.`specindex`, NEW.`bin`, NEW.`passed`, NEW.`lv_eeprom_pass`, NEW.`lv_eeprom_vdd`, NEW.`row`, NEW.`col`, NEW.`dtime`, NEW.`current`, NEW.`altcurrent`, NEW.`disablecurrent`, NEW.`boardcurrent`, NEW.`offx_org`, NEW.`offy_org`, NEW.`offz_org`, NEW.`sensex`, NEW.`sensey`, NEW.`sensez`, NEW.`offsetx`, NEW.`offsety`, NEW.`offsetz`, NEW.`sxx`, NEW.`sxy`, NEW.`sxz`, NEW.`syx`, NEW.`syy`, NEW.`syz`, NEW.`szx`, NEW.`szy`, NEW.`szz`, NEW.`offx`, NEW.`offy`, NEW.`offz`, NEW.`communicationscheckvalue`, NEW.`socketcheckx`, NEW.`socketchecky`, NEW.`socketcheckz`, NEW.`stabilityx`, NEW.`stabilityy`, NEW.`stabilityz`, NEW.`bandgaptrimcode`, NEW.`bandgaptrimvoltage`, NEW.`bandgaplowvoltage`, NEW.`bandgaphighvoltage`, NEW.`regulatortrimvoltage`, NEW.`vt`, NEW.`vmid`, NEW.`fgx`, NEW.`fgy`, NEW.`fgz`, NEW.`fox`, NEW.`foy`, NEW.`foz`, NEW.`temperatureoutputtrimcode`, NEW.`temperatureoutput`, NEW.`tcompx`, NEW.`tcompy`, NEW.`tcompz`, NEW.`temperature_hot`, NEW.`temperature_ambient`, NEW.`temperature_cold`, NEW.`offx_org_cold`, NEW.`offy_org_cold`, NEW.`offz_org_cold`, NEW.`offx_org_hot`, NEW.`offy_org_hot`, NEW.`offz_org_hot`, NEW.`rcompx`, NEW.`rcompy`, NEW.`rcompz`, NEW.`ff_int`, NEW.`ff_delay`, NEW.`mot_int`, NEW.`mot_delay`, NEW.`polarity`, NEW.`selftesttrimcodex`, NEW.`selftesttrimcodey`, NEW.`selftesttrimcodez`, NEW.`selftestx`, NEW.`selftesty`, NEW.`selftestz`, NEW.`negselftestx`, NEW.`negselftesty`, NEW.`negselftestz`, NEW.`offsetratioerrorx`, NEW.`offsetratioerrory`, NEW.`offsetratioerrorz`, NEW.`senseratiohighx`, NEW.`senseratiohighy`, NEW.`senseratiohighz`, NEW.`senseratiolowx`, NEW.`senseratiolowy`, NEW.`senseratiolowz`, NEW.`offsetratiohighx`, NEW.`offsetratiohighy`, NEW.`offsetratiohighz`, NEW.`offsetratiolowx`, NEW.`offsetratiolowy`, NEW.`offsetratiolowz`, NEW.`hpfoutputx`, NEW.`hpfoutputy`, NEW.`hpfoutputz`, NEW.`seltest`, NEW.`intspd`, NEW.`vco`, NEW.`clock_period`, NEW.`initialvcofreq`, NEW.`wdttrimcode`, NEW.`wdtfreq`, NEW.`mode`, NEW.`parity`, NEW.`extra1`, NEW.`extra2`, NEW.`extra3`, NEW.`extra4`, NEW.`extratext1`, NEW.`extratext2`, NEW.`extratext3`, NEW.`extratext4`, NEW.`uniquemoduleid`, NEW.`eepromimage`, NEW.`serialnumber`, NEW.`sdfnpartindex`) # Retry:3683 5311 Try code succeeded 2015-07-15T12:57:43 Created triggers OK. # NibbleIterator:5598 5311 EXPLAIN SELECT * FROM `ATData`.`Retest` WHERE 1=1 # NibbleIterator:5600 5311 $VAR1 = { # extra => undef, # id => '1', # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => '5406492', # select_type => 'SIMPLE', # table => 'Retest', # type => 'ALL' # }; # # NibbleIterator:5475 5311 One nibble: no # NibbleIterator:5530 5311 Auto-selecting best index # TableParser:3231 5311 Indexes sorted best-first: PRIMARY, bo, dtime, eepromimage, newreel, reprocess, serialnumber, sourcereel, specindex, tindex # NibbleIterator:5563 5311 Best index: PRIMARY # TableNibbler:2843 5311 Will ascend index PRIMARY # TableNibbler:2855 5311 Will ascend columns rindex # TableNibbler:2866 5311 Will ascend, in ordinal position: 0 # NibbleIterator:5180 5311 Ascend params: $VAR1 = { # boundaries => { # '<' => '((`rindex` < ?))', # '<=' => '((`rindex` <= ?))', # '>' => '((`rindex` > ?))', # '>=' => '((`rindex` >= ?))' # }, # cols => [ # 'rindex', # 'tindex', # 'sourcereel', # 'sourcepocket', # 'newreel', # 'newpocket', # 'boardid', # 'dutlocation', # 'runnumber', # 'bo', # 'reprocess', # 'specindex', # 'bin', # 'passed', # 'lv_eeprom_pass', # 'lv_eeprom_vdd', # 'row', # 'col', # 'dtime', # 'current', # 'altcurrent', # 'disablecurrent', # 'boardcurrent', # 'offx_org', # 'offy_org', # 'offz_org', # 'sensex', # 'sensey', # 'sensez', # 'offsetx', # 'offsety', # 'offsetz', # 'sxx', # 'sxy', # 'sxz', # 'syx', # 'syy', # 'syz', # 'szx', # 'szy', # 'szz', # 'offx', # 'offy', # 'offz', # 'communicationscheckvalue', # 'socketcheckx', # 'socketchecky', # 'socketcheckz', # 'stabilityx', # 'stabilityy', # 'stabilityz', # 'bandgaptrimcode', # 'bandgaptrimvoltage', # 'bandgaplowvoltage', # 'bandgaphighvoltage', # 'regulatortrimvoltage', # 'vt', # 'vmid', # 'fgx', # 'fgy', # 'fgz', # 'fox', # 'foy', # 'foz', # 'temperatureoutputtrimcode', # 'temperatureoutput', # 'tcompx', # 'tcompy', # 'tcompz', # 'temperature_hot', # 'temperature_ambient', # 'temperature_cold', # 'offx_org_cold', # 'offy_org_cold', # 'offz_org_cold', # 'offx_org_hot', # 'offy_org_hot', # 'offz_org_hot', # 'rcompx', # 'rcompy', # 'rcompz', # 'ff_int', # 'ff_delay', # 'mot_int', # 'mot_delay', # 'polarity', # 'selftesttrimcodex', # 'selftesttrimcodey', # 'selftesttrimcodez', # 'selftestx', # 'selftesty', # 'selftestz', # 'negselftestx', # 'negselftesty', # 'negselftestz', # 'offsetratioerrorx', # 'offsetratioerrory', # 'offsetratioerrorz', # 'senseratiohighx', # 'senseratiohighy', # 'senseratiohighz', # 'senseratiolowx', # 'senseratiolowy', # 'senseratiolowz', # 'offsetratiohighx', # 'offsetratiohighy', # 'offsetratiohighz', # 'offsetratiolowx', # 'offsetratiolowy', # 'offsetratiolowz', # 'hpfoutputx', # 'hpfoutputy', # 'hpfoutputz', # 'seltest', # 'intspd', # 'vco', # 'clock_period', # 'initialvcofreq', # 'wdttrimcode', # 'wdtfreq', # 'mode', # 'parity', # 'extra1', # 'extra2', # 'extra3', # 'extra4', # 'extratext1', # 'extratext2', # 'extratext3', # 'extratext4', # 'uniquemoduleid', # 'eepromimage', # 'serialnumber', # 'sdfnpartindex' # ], # index => 'PRIMARY', # scols => [ # 'rindex' # ], # slice => [ # 0 # ], # where => '((`rindex` > ?))' # }; # # NibbleIterator:5193 5311 First lower boundary statement: SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) ORDER BY `rindex` LIMIT 1 /*first lower boundary*/ # NibbleIterator:5218 5311 Last upper boundary statement: SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) ORDER BY `rindex` DESC LIMIT 1 /*last upper boundary*/ # NibbleIterator:5229 5311 Upper boundary statement: SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ # NibbleIterator:5242 5311 Nibble statement: INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ # NibbleIterator:5255 5311 Explain nibble statement: EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/ # NibbleIterator:5258 5311 Initial chunk size (LIMIT): 999 # NibbleIterator:5610 5311 Preparing statement handles # NibbleIterator:5639 5311 First lower boundary: $VAR1 = [ # '27853759' # ]; # # NibbleIterator:5655 5311 Next lower boundary: $VAR1 = [ # '27853759' # ]; # 2015-07-15T12:57:43 Copying approximately 5406492 rows... # IndexLength:6305 5311 SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX (`PRIMARY`) WHERE `rindex` IS NOT NULL ORDER BY `rindex` LIMIT 1 /*key_len*/ # IndexLength:6272 5311 EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ * FROM `ATData`.`Retest` FORCE INDEX (`PRIMARY`) WHERE `rindex` >= ? /*key_len*/ params: 27853759 # IndexLength:6276 5311 Range scan: $VAR1 = { # extra => 'Using where', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '2703246', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # NibbleIterator:5310 5311 init callback returned 1 # pt_online_schema_change:10648 5311 EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27853759 999 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where; Using index', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '2703246', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # NibbleIterator:5710 5311 next_boundaries callback returned 1 # NibbleIterator:5719 5311 SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27853759 999 # NibbleIterator:5722 5311 Next boundary: $VAR1 = [ # [ # '27854758' # ], # [ # '27854759' # ] # ]; # # NibbleIterator:5328 5311 Nibble: INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ params: 27853759, 27854758 # pt_online_schema_change:10648 5311 EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/ params: 27853759 27854758 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '2054', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # Quoter:2739 5311 Serializing $VAR1 = [ # '27853759' # ]; # # Quoter:2755 5311 Serialized: < 27853759 > # Quoter:2739 5311 Serializing $VAR1 = [ # '27854758' # ]; # # Quoter:2755 5311 Serialized: < 27854758 > # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10566 5311 INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ lower boundary: 27853759 upper boundary: 27854758 # pt_online_schema_change:10585 5311 SHOW WARNINGS # Retry:3683 5311 Try code succeeded # pt_online_schema_change:9191 5311 Nibble time: 0.111500978469849 # NibbleIterator:5336 5311 0 rows in nibble 1 # NibbleIterator:5348 5311 No rows in nibble or nibble skipped # pt_online_schema_change:9214 5311 Average copy rate (rows/s): 8968 # WeightedAvgRate:5054 5311 Master op time: 1000 n / 0.111500978469849 s # WeightedAvgRate:5066 5311 Initial avg rate: 8968.53116199705 n/s # WeightedAvgRate:5070 5311 Adjust n to 4484 # NibbleIterator:5432 5311 Set new chunk size (LIMIT): 4484 # ReplicaLagWaiter:4765 5311 Checking slave lag # MasterSlave:4288 5311 DBI::db=HASH(0x243eef8) SHOW SLAVE STATUS # ReplicaLagWaiter:4768 5311 ASE2TestVM slave lag: 0 # ReplicaLagWaiter:4801 5311 All slaves caught up # MySQLStatusWaiter:4943 5311 Checking status variables # pt_online_schema_change:8379 5311 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:4946 5311 Threads_running = 2 # MySQLStatusWaiter:4973 5311 All var vals are low enough # pt_online_schema_change:10648 5311 EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27854759 4483 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where; Using index', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '2703246', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # NibbleIterator:5710 5311 next_boundaries callback returned 1 # NibbleIterator:5719 5311 SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27854759 4483 # NibbleIterator:5722 5311 Next boundary: $VAR1 = [ # [ # '27859242' # ], # [ # '27859243' # ] # ]; # # NibbleIterator:5328 5311 Nibble: INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ params: 27854759, 27859242 # pt_online_schema_change:10648 5311 EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/ params: 27854759 27859242 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '9342', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # Quoter:2739 5311 Serializing $VAR1 = [ # '27854759' # ]; # # Quoter:2755 5311 Serialized: < 27854759 > # Quoter:2739 5311 Serializing $VAR1 = [ # '27859242' # ]; # # Quoter:2755 5311 Serialized: < 27859242 > # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10566 5311 INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ lower boundary: 27854759 upper boundary: 27859242 # pt_online_schema_change:10585 5311 SHOW WARNINGS # Retry:3683 5311 Try code succeeded # pt_online_schema_change:9191 5311 Nibble time: 0.34001898765564 # NibbleIterator:5336 5311 0 rows in nibble 2 # NibbleIterator:5348 5311 No rows in nibble or nibble skipped # pt_online_schema_change:9214 5311 Average copy rate (rows/s): 12145 # WeightedAvgRate:5054 5311 Master op time: 4484 n / 0.34001898765564 s # WeightedAvgRate:5060 5311 Weighted avg rate: 12354.6918780642 n/s # WeightedAvgRate:5070 5311 Adjust n to 6177 # NibbleIterator:5432 5311 Set new chunk size (LIMIT): 6177 # ReplicaLagWaiter:4765 5311 Checking slave lag # MasterSlave:4288 5311 DBI::db=HASH(0x243eef8) SHOW SLAVE STATUS # ReplicaLagWaiter:4768 5311 ASE2TestVM slave lag: 1 # ReplicaLagWaiter:4801 5311 All slaves caught up # MySQLStatusWaiter:4943 5311 Checking status variables # pt_online_schema_change:8379 5311 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:4946 5311 Threads_running = 2 # MySQLStatusWaiter:4973 5311 All var vals are low enough # pt_online_schema_change:10648 5311 EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27859243 6176 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where; Using index', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '2703246', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # NibbleIterator:5710 5311 next_boundaries callback returned 1 # NibbleIterator:5719 5311 SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27859243 6176 # NibbleIterator:5722 5311 Next boundary: $VAR1 = [ # [ # '27865419' # ], # [ # '27865420' # ] # ]; # # NibbleIterator:5328 5311 Nibble: INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ params: 27859243, 27865419 # pt_online_schema_change:10648 5311 EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/ params: 27859243 27865419 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '13310', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # Quoter:2739 5311 Serializing $VAR1 = [ # '27859243' # ]; # # Quoter:2755 5311 Serialized: < 27859243 > # Quoter:2739 5311 Serializing $VAR1 = [ # '27865419' # ]; # # Quoter:2755 5311 Serialized: < 27865419 > # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10566 5311 INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ lower boundary: 27859243 upper boundary: 27865419 # pt_online_schema_change:10585 5311 SHOW WARNINGS # Retry:3683 5311 Try code succeeded # pt_online_schema_change:9191 5311 Nibble time: 0.429141998291016 # NibbleIterator:5336 5311 0 rows in nibble 3 # NibbleIterator:5348 5311 No rows in nibble or nibble skipped # pt_online_schema_change:9214 5311 Average copy rate (rows/s): 13241 # WeightedAvgRate:5054 5311 Master op time: 6177 n / 0.429141998291016 s # WeightedAvgRate:5060 5311 Weighted avg rate: 13526.3500633824 n/s # WeightedAvgRate:5070 5311 Adjust n to 6763 # NibbleIterator:5432 5311 Set new chunk size (LIMIT): 6763 # ReplicaLagWaiter:4765 5311 Checking slave lag # MasterSlave:4288 5311 DBI::db=HASH(0x243eef8) SHOW SLAVE STATUS # ReplicaLagWaiter:4768 5311 ASE2TestVM slave lag: 1 # ReplicaLagWaiter:4801 5311 All slaves caught up # MySQLStatusWaiter:4943 5311 Checking status variables # pt_online_schema_change:8379 5311 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:4946 5311 Threads_running = 2 # MySQLStatusWaiter:4973 5311 All var vals are low enough # pt_online_schema_change:10648 5311 EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27865420 6762 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where; Using index', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '2703246', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # NibbleIterator:5710 5311 next_boundaries callback returned 1 # NibbleIterator:5719 5311 SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27865420 6762 # NibbleIterator:5722 5311 Next boundary: $VAR1 = [ # [ # '27872182' # ], # [ # '27872183' # ] # ]; # # NibbleIterator:5328 5311 Nibble: INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ params: 27865420, 27872182 # pt_online_schema_change:10648 5311 EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/ params: 27865420 27872182 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '11984', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # Quoter:2739 5311 Serializing $VAR1 = [ # '27865420' # ]; # # Quoter:2755 5311 Serialized: < 27865420 > # Quoter:2739 5311 Serializing $VAR1 = [ # '27872182' # ]; # # Quoter:2755 5311 Serialized: < 27872182 > # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10566 5311 INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ lower boundary: 27865420 upper boundary: 27872182 # pt_online_schema_change:10585 5311 SHOW WARNINGS # Retry:3683 5311 Try code succeeded # pt_online_schema_change:9191 5311 Nibble time: 1.08514094352722 # NibbleIterator:5336 5311 0 rows in nibble 4 # NibbleIterator:5348 5311 No rows in nibble or nibble skipped # pt_online_schema_change:9214 5311 Average copy rate (rows/s): 9372 # WeightedAvgRate:5054 5311 Master op time: 6763 n / 1.08514094352722 s # WeightedAvgRate:5060 5311 Weighted avg rate: 8715.67248175301 n/s # WeightedAvgRate:5070 5311 Adjust n to 4357 # NibbleIterator:5432 5311 Set new chunk size (LIMIT): 4357 # ReplicaLagWaiter:4765 5311 Checking slave lag # MasterSlave:4288 5311 DBI::db=HASH(0x243eef8) SHOW SLAVE STATUS # ReplicaLagWaiter:4768 5311 ASE2TestVM slave lag: 1 # ReplicaLagWaiter:4801 5311 All slaves caught up # MySQLStatusWaiter:4943 5311 Checking status variables # pt_online_schema_change:8379 5311 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:4946 5311 Threads_running = 2 # MySQLStatusWaiter:4973 5311 All var vals are low enough # pt_online_schema_change:10648 5311 EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27872183 4356 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where; Using index', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '2703246', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # NibbleIterator:5710 5311 next_boundaries callback returned 1 # NibbleIterator:5719 5311 SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27872183 4356 # NibbleIterator:5722 5311 Next boundary: $VAR1 = [ # [ # '27876539' # ], # [ # '27876540' # ] # ]; # # NibbleIterator:5328 5311 Nibble: INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ params: 27872183, 27876539 # pt_online_schema_change:10648 5311 EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/ params: 27872183 27876539 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '9158', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # Quoter:2739 5311 Serializing $VAR1 = [ # '27872183' # ]; # # Quoter:2755 5311 Serialized: < 27872183 > # Quoter:2739 5311 Serializing $VAR1 = [ # '27876539' # ]; # # Quoter:2755 5311 Serialized: < 27876539 > # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10566 5311 INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ lower boundary: 27872183 upper boundary: 27876539 # pt_online_schema_change:10585 5311 SHOW WARNINGS # Retry:3683 5311 Try code succeeded # pt_online_schema_change:9191 5311 Nibble time: 0.305732011795044 # NibbleIterator:5336 5311 0 rows in nibble 5 # NibbleIterator:5348 5311 No rows in nibble or nibble skipped # pt_online_schema_change:9214 5311 Average copy rate (rows/s): 10028 # WeightedAvgRate:5054 5311 Master op time: 4357 n / 0.305732011795044 s # WeightedAvgRate:5060 5311 Weighted avg rate: 9814.80490438433 n/s # WeightedAvgRate:5070 5311 Adjust n to 4907 # NibbleIterator:5432 5311 Set new chunk size (LIMIT): 4907 # ReplicaLagWaiter:4765 5311 Checking slave lag # MasterSlave:4288 5311 DBI::db=HASH(0x243eef8) SHOW SLAVE STATUS # ReplicaLagWaiter:4768 5311 ASE2TestVM slave lag: 2 # ReplicaLagWaiter:4801 5311 All slaves caught up # MySQLStatusWaiter:4943 5311 Checking status variables # pt_online_schema_change:8379 5311 SHOW GLOBAL STATUS LIKE ? Threads_running # MySQLStatusWaiter:4946 5311 Threads_running = 2 # MySQLStatusWaiter:4973 5311 All var vals are low enough # pt_online_schema_change:10648 5311 EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27876540 4906 # pt_online_schema_change:10657 5311 EXPLAIN plan: $VAR1 = { # extra => 'Using where; Using index', # id => '1', # key => 'PRIMARY', # key_len => '4', # possible_keys => 'PRIMARY', # ref => undef, # rows => '2703246', # select_type => 'SIMPLE', # table => 'Retest', # type => 'range' # }; # # NibbleIterator:5710 5311 next_boundaries callback returned 1 # NibbleIterator:5719 5311 SELECT /*!40001 SQL_NO_CACHE */ `rindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) ORDER BY `rindex` LIMIT ?, 2 /*next chunk boundary*/ params: 27876540 4906 # NibbleIterator:5722 5311 Next boundary: $VAR1 = [ # [ # '27881446' # ], # [ # '27881447' # ] # ]; # # NibbleIterator:5328 5311 Nibble: INSERT LOW_PRIORITY IGNORE INTO `ATData`.`_Retest_new` (`rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex`) SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5311 copy nibble*/ params: 27876540, 27881446 # pt_online_schema_change:10648 5311 EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/ params: 27876540 27881446 # CleanupTask:6178 5311 Calling cleanup task CODE(0x243ec88) # pt_online_schema_change:8946 5311 Clean up triggers # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10408 5311 DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_del`; # Retry:3672 5311 Try code failed: DBD::mysql::db do failed: MySQL server has gone away [for Statement "DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_del`;"] at /usr/local/bin/pt-online-schema-change line 10409. # # pt_online_schema_change:10467 5311 Retry fail: DBD::mysql::db do failed: MySQL server has gone away [for Statement "DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_del`;"] at /usr/local/bin/pt-online-schema-change line 10409. # # DSNParser:2211 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client root password RaiseError=>1, ShowErrorStatement=>1, mysql_enable_utf8=>0, AutoCommit=>1, PrintError=>0 # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client root password RaiseError=>1, ShowErrorStatement=>1, mysql_enable_utf8=>0, AutoCommit=>1, PrintError=>0 2015-07-15T12:57:46 Error dropping trigger: DBI connect('ATData;host=10.0.2.148;mysql_read_default_group=client','root',...) failed: Can't connect to MySQL server on '10.0.2.148' (111) at /usr/local/bin/pt-online-schema-change line 2262. # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10408 5311 DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_upd`; # Retry:3672 5311 Try code failed: DBD::mysql::db do failed: MySQL server has gone away [for Statement "DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_upd`;"] at /usr/local/bin/pt-online-schema-change line 10409. # # pt_online_schema_change:10467 5311 Retry fail: DBD::mysql::db do failed: MySQL server has gone away [for Statement "DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_upd`;"] at /usr/local/bin/pt-online-schema-change line 10409. # # DSNParser:2211 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client root password PrintError=>0, mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1 # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client root password PrintError=>0, mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1 2015-07-15T12:57:46 Error dropping trigger: DBI connect('ATData;host=10.0.2.148;mysql_read_default_group=client','root',...) failed: Can't connect to MySQL server on '10.0.2.148' (111) at /usr/local/bin/pt-online-schema-change line 2262. # Retry:3666 5311 Try 1 of 10 # pt_online_schema_change:10408 5311 DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_ins`; # Retry:3672 5311 Try code failed: DBD::mysql::db do failed: MySQL server has gone away [for Statement "DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_ins`;"] at /usr/local/bin/pt-online-schema-change line 10409. # # pt_online_schema_change:10467 5311 Retry fail: DBD::mysql::db do failed: MySQL server has gone away [for Statement "DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_ins`;"] at /usr/local/bin/pt-online-schema-change line 10409. # # DSNParser:2211 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client root password PrintError=>0, mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1 # DSNParser:2260 5311 DBI:mysql:ATData;host=10.0.2.148;mysql_read_default_group=client root password PrintError=>0, mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1 2015-07-15T12:57:46 Error dropping trigger: DBI connect('ATData;host=10.0.2.148;mysql_read_default_group=client','root',...) failed: Can't connect to MySQL server on '10.0.2.148' (111) at /usr/local/bin/pt-online-schema-change line 2262. 2015-07-15T12:57:46 To try dropping the triggers again, execute: DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_del`; DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_upd`; DROP TRIGGER IF EXISTS `ATData`.`pt_osc_ATData_Retest_ins`; # pt_online_schema_change:8710 5311 Clean up new table # TableParser:3290 5311 Checking `ATData`.`_Retest_new` # TableParser:3294 5311 SHOW TABLES FROM `ATData` LIKE '\_Retest\_new' # TableParser:3300 5311 DBD::mysql::db selectrow_arrayref failed: MySQL server has gone away [for Statement "SHOW TABLES FROM `ATData` LIKE '\_Retest\_new'"] at /usr/local/bin/pt-online-schema-change line 3297. # # pt_online_schema_change:8716 5311 New table exists: no # pt_online_schema_change:8587 5311 Clean up done, report if orig table was altered 2015-07-15T12:57:46 Dropping triggers... `ATData`.`Retest` was not altered. 2015-07-15T12:57:46 Error copying rows from `ATData`.`Retest` to `ATData`.`_Retest_new`: Error executing EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/: DBD::mysql::st execute failed: Lost connection to MySQL server during query [for Statement "EXPLAIN SELECT `rindex`, `tindex`, `sourcereel`, `sourcepocket`, `newreel`, `newpocket`, `boardid`, `dutlocation`, `runnumber`, `bo`, `reprocess`, `specindex`, `bin`, `passed`, `lv_eeprom_pass`, `lv_eeprom_vdd`, `row`, `col`, `dtime`, `current`, `altcurrent`, `disablecurrent`, `boardcurrent`, `offx_org`, `offy_org`, `offz_org`, `sensex`, `sensey`, `sensez`, `offsetx`, `offsety`, `offsetz`, `sxx`, `sxy`, `sxz`, `syx`, `syy`, `syz`, `szx`, `szy`, `szz`, `offx`, `offy`, `offz`, `communicationscheckvalue`, `socketcheckx`, `socketchecky`, `socketcheckz`, `stabilityx`, `stabilityy`, `stabilityz`, `bandgaptrimcode`, `bandgaptrimvoltage`, `bandgaplowvoltage`, `bandgaphighvoltage`, `regulatortrimvoltage`, `vt`, `vmid`, `fgx`, `fgy`, `fgz`, `fox`, `foy`, `foz`, `temperatureoutputtrimcode`, `temperatureoutput`, `tcompx`, `tcompy`, `tcompz`, `temperature_hot`, `temperature_ambient`, `temperature_cold`, `offx_org_cold`, `offy_org_cold`, `offz_org_cold`, `offx_org_hot`, `offy_org_hot`, `offz_org_hot`, `rcompx`, `rcompy`, `rcompz`, `ff_int`, `ff_delay`, `mot_int`, `mot_delay`, `polarity`, `selftesttrimcodex`, `selftesttrimcodey`, `selftesttrimcodez`, `selftestx`, `selftesty`, `selftestz`, `negselftestx`, `negselftesty`, `negselftestz`, `offsetratioerrorx`, `offsetratioerrory`, `offsetratioerrorz`, `senseratiohighx`, `senseratiohighy`, `senseratiohighz`, `senseratiolowx`, `senseratiolowy`, `senseratiolowz`, `offsetratiohighx`, `offsetratiohighy`, `offsetratiohighz`, `offsetratiolowx`, `offsetratiolowy`, `offsetratiolowz`, `hpfoutputx`, `hpfoutputy`, `hpfoutputz`, `seltest`, `intspd`, `vco`, `clock_period`, `initialvcofreq`, `wdttrimcode`, `wdtfreq`, `mode`, `parity`, `extra1`, `extra2`, `extra3`, `extra4`, `extratext1`, `extratext2`, `extratext3`, `extratext4`, `uniquemoduleid`, `eepromimage`, `serialnumber`, `sdfnpartindex` FROM `ATData`.`Retest` FORCE INDEX(`PRIMARY`) WHERE ((`rindex` >= ?)) AND ((`rindex` <= ?)) LOCK IN SHARE MODE /*explain pt-online-schema-change 5311 copy nibble*/" with ParamValues: 0='27876540', 1='27881446'] at /usr/local/bin/pt-online-schema-change line 10649. # NibbleIterator:5769 5311 Finish explain_ub_sth # NibbleIterator:5769 5311 Finish explain_first_lb_sth # NibbleIterator:5769 5311 Finish ub_sth # NibbleIterator:5769 5311 Finish nibble_sth # NibbleIterator:5769 5311 Finish explain_nibble_sth # Cxn:3922 5311 Destroying cxn # Cxn:3931 5311 DBI::db=HASH(0x243eef8) Disconnecting dbh on ASE2TestVM h=10.0.2.199 # Cxn:3922 5311 Destroying cxn # Cxn:3931 5311 DBI::db=HASH(0x23aa338) Disconnecting dbh on ASE1TestVM h=10.0.2.148 # Cxn:3922 5311 Destroying cxn # Cxn:3931 5311 DBI::db=HASH(0x23ab070) Disconnecting dbh on ASE1TestVM h=10.0.2.148