[EAGLE-273] 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.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v0.3.0
• Fix Version/s: v0.4.0
• Assignee: Michael Wu
• Reporter: Hao Chen
• Created: 20/Apr/16 00:53
• Updated: 07/Jun/16 07:36
• Resolved: 07/Jun/16 07:36

Description

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.

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)

Issue Links

• Blocked: EAGLE-292 Updated hbase policy failed: Data too long for column 'policyDef' when using mysql storage
• is related to: EAGLE-270 JDBC: Create table fail for some of the tables
• links to: GitHub Pull Request #158