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

Connection problems with MySQL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Highest
    • Resolution: Answered
    • 4.3 - EAP
    • None
    • Installation
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: