Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-23666

Connection problems with MySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Highest
    • Resolution: Answered
    • Affects Version/s: 4.3 - EAP
    • Fix Version/s: None
    • Component/s: Installation
    • Labels:
    • Environment:

      JIRA standalon on Win XP using MySQL 5.0.77 win32 and JAVA 1.6.0_11

      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

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              0d947d8e6d6c Ludwig
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: