> On Жов. 5, 2016, 5:30 після полудня, Alejandro Fernandez wrote: > > ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql, line 39 > > <https://reviews.apache.org/r/52532/diff/3/?file=1523004#file1523004line39> > > > > Fundamenetally, if we can't create varchar longer than 1000 bytes > > that's a big problem. > > > > What's the root cause? Which environment was this seen on? > > Alejandro Fernandez wrote: > Fundamentally*
This problem was discovered a long time ago. Mysql has limitation for PK,FK,indexes for 1000bytes. So, for example, if you will use two varchar(255) fields in PK and charset for db is UTF8 then you will get limit error. It's default mysql configuration and it's not so easy to change it. We already fixed this issues some time ago. - Vitalyi ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/52532/#review151520 ----------------------------------------------------------- On Жов. 5, 2016, 4:38 після полудня, Vitalyi Brodetskyi wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/52532/ > ----------------------------------------------------------- > > (Updated Жов. 5, 2016, 4:38 після полудня) > > > Review request for Ambari, Alejandro Fernandez, Myroslav Papirkovskyy, Robert > Levas, Sumit Mohanty, and Sid Wagle. > > > Bugs: AMBARI-18532 > https://issues.apache.org/jira/browse/AMBARI-18532 > > > Repository: ambari > > > Description > ------- > > ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes > > > Diffs > ----- > > ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql e8a2569 > > Diff: https://reviews.apache.org/r/52532/diff/ > > > Testing > ------- > > mvn clean test > > > Thanks, > > Vitalyi Brodetskyi > >
