[
https://issues.apache.org/jira/browse/EAGLE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Wu reassigned EAGLE-273:
--------------------------------
Assignee: Michael Wu (was: Hao Chen)
> 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)
