[ https://issues.apache.org/jira/browse/EAGLE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Wu resolved EAGLE-273. ------------------------------ Resolution: Fixed waiting for merging PR #221 > Issue with creating MySql tables , only 14 were created out of 24, reason > being varchar(30000) for multiple columns lead to exceeding the maximum row > size of 65,535 bytes. > ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: EAGLE-273 > URL: https://issues.apache.org/jira/browse/EAGLE-273 > Project: Eagle > Issue Type: Bug > Affects Versions: v0.3.0 > Reporter: Hao Chen > Assignee: Michael Wu > Fix For: v0.4.0 > > > h2. Problem > Issue with creating MySql tables , only 14 were created out of 24, reason > being varchar(30000) for multiple columns lead to exceeding the maximum row > size of 65,535 bytes. I can look into this and fix it. Workaround is to > create the tables manually after changing the DDL. > h2. Root Cause & Problem > The problem is cause the limitation of maximum row size in mysql innodb > engine, so need to keep the column size relatively small, but it will cause > it can't store large field, it's a little tricky, so may have following > possible solutions: > * Solution One: Fix mysql innodb size to resolve the limitation. > * Solution Two: Keep the field relatively small to avoid exceeding maximum > row size and make sure creating table successfully, and modify field size > according to actual usage (Which is the approach we take for this problem) -- This message was sent by Atlassian JIRA (v6.3.4#6332)