Public bug reported:
Hi,
Just trying out some features of pt-online-schema-change, in this case
testing before moving a 15 GB table.
I created a copy of a small table in the traditional fashion, and then
attempted to move the table to an existing directory, with the following
command.
pt-online-schema-change --data-dir="/viewranger/data/mysql_old"
--execute D=camspatial1,t=ms_curation_automated_group_routes -u root -p
XXXXXXXXX;
The resulting output looks promising, as does the logging.
No slaves found. See --recursion-method if host localhost.localdomain has
slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was
not specified.
Operation, tries, wait:
analyze_table, 10, 1
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_foreign_keys, 10, 1
Altering `camspatial1`.`ms_curation_automated_group_routes`...
Creating new table...
Created new table camspatial1._ms_curation_automated_group_routes_new OK.
2018-03-23T16:57:15 Creating triggers...
2018-03-23T16:57:16 Created triggers OK.
2018-03-23T16:57:16 Copying approximately 133481 rows...
2018-03-23T16:57:17 Copied rows OK.
2018-03-23T16:57:17 Analyzing new table...
2018-03-23T16:57:17 Swapping tables...
2018-03-23T16:57:17 Swapped original and new tables OK.
2018-03-23T16:57:17 Dropping old table...
2018-03-23T16:57:17 Dropped old table
`camspatial1`.`_ms_curation_automated_group_routes_old` OK.
2018-03-23T16:57:17 Dropping triggers...
2018-03-23T16:57:17 Dropped triggers OK.
Successfully altered `camspatial1`.`ms_curation_automated_group_routes`.
2018-03-23T16:24:28.760077Z 21302 Query CREATE TABLE
`camspatial1`.`_ms_curation_automated_group_routes_new` (
`groupId` int(10) unsigned NOT NULL,
`routeId` varchar(50) NOT NULL,
PRIMARY KEY (`groupId`,`routeId`),
KEY `Index 1` (`groupId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 DATA DIRECTORY =
'/viewranger/data/mysql_old/'
However, after completion, the table is still in the old location.
Running on 5.7.21-20, with percona-toolkit-3.0.8-1.el6.x86_64 (updated
after first fail from 3.0.7-1)
And my apologies, this DB is running on Centos, but this is where the
Percona support page has taken me.
No rush, don't do anything till Monday.
Thanks,
Mike Shield
** Affects: percona-toolkit (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1758397
Title:
pt-online-schema-change fails to change data-dir
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/percona-toolkit/+bug/1758397/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
