[
https://issues.apache.org/jira/browse/AIRAVATA-2309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15843378#comment-15843378
]
ASF subversion and git services commented on AIRAVATA-2309:
-----------------------------------------------------------
Commit e2b2f8621dfe61bbdf4c65eda902ed49ea8abf26 in airavata's branch
refs/heads/develop from scnakandala
[ https://git-wip-us.apache.org/repos/asf?p=airavata.git;h=e2b2f86 ]
fixing AIRAVATA-2309 : SHARING table: MySQL complains "Specified key was too
long; max key length is 3072 bytes"
> SHARING table: MySQL complains "Specified key was too long; max key length is
> 3072 bytes"
> -----------------------------------------------------------------------------------------
>
> Key: AIRAVATA-2309
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2309
> Project: Airavata
> Issue Type: Bug
> Reporter: Marcus Christie
> Assignee: Supun Chathuranga Nakandala
>
> Error occurs while trying to create the SHARING table:
> {code:sql}
> CREATE TABLE SHARING (
> PERMISSION_TYPE_ID VARCHAR(255) NOT NULL,
> ENTITY_ID VARCHAR(255) NOT NULL,
> GROUP_ID VARCHAR(255) NOT NULL,
> SHARING_TYPE VARCHAR(255) NOT NULL,
> INHERITED_PARENT_ID VARCHAR(255),
> CREATED_TIME BIGINT NOT NULL,
> UPDATED_TIME BIGINT NOT NULL,
> PRIMARY KEY (PERMISSION_TYPE_ID, ENTITY_ID, GROUP_ID, INHERITED_PARENT_ID),
> FOREIGN KEY (PERMISSION_TYPE_ID) REFERENCES
> PERMISSION_TYPE(PERMISSION_TYPE_ID) ON DELETE CASCADE ON UPDATE CASCADE,
> FOREIGN KEY (INHERITED_PARENT_ID) REFERENCES ENTITY(ENTITY_ID) ON DELETE
> CASCADE ON UPDATE CASCADE,
> FOREIGN KEY (GROUP_ID) REFERENCES USER_GROUP(GROUP_ID) ON DELETE CASCADE ON
> UPDATE CASCADE
> );
> {code}
> This key is fine in the dev database on gw62. I think the reason it fails
> for me is that my databases have a default encoding of UTF-8. On gw62 the
> encoding is latin1_swedish_ci.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
