pt-online-schema-change error copying rows: Undefined subroutine &pt_online_schema_change::get
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Daniel Nichter |
Bug Description
pt-online-
percona-toolkit 2.2.2
Server version: 5.5.31-30.3-log Percona Server (GPL), Release 30.3
Undefined subroutine &pt_online_
Column changed from text to -> VARCHAR(512)
Operation, tries, wait:
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_
Altering `database_
Creating new table...
Created new table database_
Altering new table...
Altered `database_
Creating triggers...
Created triggers OK.
Copying approximately 2538984 rows...
Dropping triggers...
Dropped triggers OK.
Dropping new table...
Dropped new table OK.
`database_
(in cleanup) Error copying rows from `database_
I ultimately resolved this by stopping slave executing command again waited till I got slave_lag message then when I restarted slave it continued successfully ... have tried since unable to reproduce. But there is at least an error in the logic for that handles the error.
PTDEBUG output attached
Related branches
- Daniel Nichter: Approve
-
Diff: 86 lines (+49/-13)2 files modifiedbin/pt-online-schema-change (+5/-13)
t/pt-online-schema-change/bugs.t (+44/-0)
Changed in percona-toolkit: | |
importance: | Undecided → Medium |
Changed in percona-toolkit: | |
importance: | Medium → High |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Thanks, we'll look into it.