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.



Hi Dave,
Can you please show the exact command you used ? and what is the version of pt-osc ?

$ ./pt-online-schema-change --version

It’s PXC ? Look likes there is some limitation on how long table name can be.