Upgrade Issue. Index column size too large . The maximum size is 767 bytes
Posted by: Chadwick C Hung
Date: May 20, 2020 03:27PM

We have a RDS MYSQL with AWS. After upgrading from 5.7 to 8.0.17 , one of our table has been in error. "Index column size too large . The maximum size is 767 bytes.

I've tried to drop the table, alter, truncate, drop index, all these command responded with the same error above, I'm stuck,

I also tried to set table row_format to Dynamic, set the global collation server to utf8_unicode_ci. Still can't get rid of the problem table.

Please help, Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Upgrade Issue. Index column size too large . The maximum size is 767 bytes
May 20, 2020 03:27PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.