I get this:
Error copying rows from `thedb`.`thetable` to
`thedb`.`_thetable_new`: Use of uninitialized value in numeric lt
(<) at ./pt-online-schema-change line 6519.
And code in 6519 is the following:
# Ensure that MySQL is still using the entire index.
# https://bugs.launchpad.net/percona-toolkit/+bug/1010232
if ( !$nibble_iter->one_nibble()
&& $tbl->{key_len}
&& ($expl->{key_len} || 0) < $tbl->{key_len} ) {
if ( !$tbl->{warned}->{key_len}++
&& $o->get('quiet') < 2 ) {
die "Error copying rows at chunk " . $nibble_iter->nibble_number()
. " of $tbl->{db}.$tbl->{tbl} because MySQL used "
. "only " . ($expl->{key_len} || 0) . " bytes "
. "of the " . ($expl->{key} || '?') . " index instead of "
. $tbl->{key_len} . ". See the --[no]check-plan documentation "
. "for more information.\n";
}
}
Seems code related to this bug fix has it's own bug?
./pt-online- schema- change --execute foreign- keys-method= rebuild_ constraints --password=root
--alter-
--user=root --lock-wait-time=50 --alter="ADD COLUMN
lacolumna TINYINT NOT NULL DEFAULT 1"
D=thedb,t=thetable
I get this: .`_thetable_ new`: Use of uninitialized value in numeric lt schema- change line 6519.
Error copying rows from `thedb`.`thetable` to
`thedb`
(<) at ./pt-online-
And code in 6519 is the following:
# Ensure that MySQL is still using the entire index. /bugs.launchpad .net/percona- toolkit/ +bug/1010232 iter->one_ nibble( ) {warned} ->{key_ len}++ iter->nibble_ number( ) db}.$tbl- >{tbl} because MySQL used "
# https:/
if ( !$nibble_
&& $tbl->{key_len}
&& ($expl->{key_len} || 0) < $tbl->{key_len} ) {
if ( !$tbl->
&& $o->get('quiet') < 2 ) {
die "Error copying rows at chunk " . $nibble_
. " of $tbl->{
. "only " . ($expl->{key_len} || 0) . " bytes "
. "of the " . ($expl->{key} || '?') . " index instead of "
. $tbl->{key_len} . ". See the --[no]check-plan documentation "
. "for more information.\n";
}
}
Brian confirmed 'quiet' has no default set.