GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Help with pt-online-schema-change

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help with pt-online-schema-change

    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

  • #2
    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.

    Comment

    Working...
    X