[jira] [Commented] (OOZIE-809) MySQL TEXT columns should be MEDIUMTEXT

["Alejandro Abdelnur (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OOZIE-809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13276843#comment-13276843 ] 

Alejandro Abdelnur commented on OOZIE-809:
------------------------------------------

As mentioned in the review, the code in the patch is dead code.

Still, I've seen this as an issue in some deployments where config size goes beyond 64k (we are storing XML, so lot of padding there).

We should look at how to configure OpenJPA to use MEDIUMTEXT for @Lob fields for MySQL (and the corresponding large text container types for Oracle, Derby, Postgres).
                
> MySQL TEXT columns should be MEDIUMTEXT
> ---------------------------------------
>
>                 Key: OOZIE-809
>                 URL: https://issues.apache.org/jira/browse/OOZIE-809
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Shwetha G S
>            Assignee: Shwetha G S
>
> When working with large number of inputs and outputs, there is data truncation error in the following fields - COORD_ACTIONS.action_xml, COORD_ACTIONS.missing_dependencies, COORD_ACTIONS.run_conf, WF_JOBS.conf.
> In general, all TEXT fields should be changed to MEDIUMTEXT in MySQL

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira