Marcus Christie created AIRAVATA-2309: -----------------------------------------
Summary: 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)