Not the answer you need?
Register and ask your own question!

Help with pt-online-schema-change

dgollinerdgolliner EntrantInactive User Role Beginner
I've been using the percona-toolkit for quite sometime and really enjoy it. I am making schema changes using the pt-online-schema-change and came across an error that I cant seem to find a work around for.

Error creating triggers: DBD::mysql::db do failed: Identifier name 'pt_osc_clarity_production_total_inquiry_clusters_payday_tradelines_del' is too long at /usr/bin/pt-online-schema-change line 7571.

Is there anyway to get around this without having to rename my table? This is a prod environment.

Any help would be greatly appreciated.

Thanks,

Dave

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    Hi Dave,
    Can you please show the exact command you used ? and what is the version of pt-osc ?

    <code>
    $ ./pt-online-schema-change --version
    </code>

    It's PXC ? Look likes there is some limitation on how long table name can be.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.