Details
-
Bug
-
Resolution: Answered
-
Highest
-
None
-
4.3 - EAP
-
JIRA standalon on Win XP using MySQL 5.0.77 win32 and JAVA 1.6.0_11
-
4.03
-
Description
There were several Errors while set up the environment with the MySQL DB.
2011-02-07 14:54:11,738 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create declared indices for entity "GroupAttribute"
2011-02-07 14:54:11,738 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX idx_goup_attr_dir_name_lval ON cwd_group_attributes (directory_id, attribute_name, lower_attribute_value)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
SQL Exception while executing the following:
CREATE UNIQUE INDEX uk_group_attr_name_lval ON cwd_group_attributes (group_id, attribute_name, lower_attribute_value)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
2011-02-07 14:54:12,425 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create declared indices for entity "Membership"
2011-02-07 14:54:12,425 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX idx_mem_dir_parent_child ON cwd_membership (lower_parent_name, lower_child_name, membership_type, directory_id)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
2011-02-07 14:54:13,160 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create declared indices for entity "UserAttribute"
2011-02-07 14:54:13,160 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX idx_user_attr_dir_name_lval ON cwd_user_attributes (directory_id, attribute_name, lower_attribute_value)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
Attachments
Issue Links
- is related to
-
JRASERVER-24124 MySQL Index Creation Fails With Error "specified key was too long"
- Closed