online schema change - Incorrect information in file

[Ran Margaliot]

Hello,

im trying to run pt-online-schema-change with the following command:

pt-online-schema-change --password '*****' --progress time,5 --execute
--chunk-size 10000 --lock-wait-time=300 --check-interval 2 --alter
"ADD COLUMN twitter_id BIGINT(20) DEFAULT NULL, ADD INDEX
twitter_id_index (user_id, twitter_id),DROP INDEX
member_rating_index,DROP INDEX persona_index ,ADD INDEX
persona_id_index (user_id, persona_id);" h=127.1,t=members,D=my_db

when i run the command i get the following output:
Creating new table...
Created new table communit_pablo.__members_new OK.
Altering new table...

and then it get stuck, looking at the mysql error log and i fount the
following lines:

120416 5:45:38 [ERROR] /usr/sbin/mysqld: Incorrect information in
file: './my_db/_members_new.frm'

any ideas?

[Baron Schwartz]

No, I haven't seen this problem before.

> --
> You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to percona-discuss...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.
>

--
Chief Performance Architect at Percona <http://www.percona.com/>
+1 (888) 401-3401 x507
Calendar: <https://tungle.me/percona_baron>
Percona Live MySQL Conference & Expo <http://www.percona.com/live>