Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-147

Table names are too long for MySQL with UTF-8

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Fixed
    • 2.0
    • Database
    • None
    • SuSE Linux v10
      Caucho Resin v3
      MySQL v4.1 - UTF8 Database

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      I found the following in the logs:

      create table `REMOTEGROUPMEMBERS` (`REMOTEGROUPDIRECTORYID` bigint not null, `REMOTEGROUPNAME` varchar(255) not null, `REMOTEPRINCIPALDIRECTORYID` bigint not null, `REMOTEPRINCIPALNAME` varchar(255) not null, primary key (`REMOTEGROUPDIRECTORYID`, `REMOTEGROUPNAME`, `REMOTEPRINCIPALDIRECTORYID`, `REMOTEPRINCIPALNAME`))

      This never gets created - when I run it manually I get:

      Error 1071 - Specified key was too long; max key length is 1000 bytes

      I can't find a setting to change the max key length to work around this while a fix is found. Another work around would be useful as I cannot continue investigating using Crowd at this point.

            [CWD-147] Table names are too long for MySQL with UTF-8

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3551157 ] New: JAC Suggestion Workflow 3 [ 3631004 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Monique Khairuliana (Inactive) made changes -
            Parent Original: CWD-1507 [ 84930 ]
            Affects Version/s Original: 0.4.2 [ 12623 ]
            Workflow Original: JAC Sub-task Workflow [ 3389504 ] New: JAC Suggestion Workflow [ 3551157 ]
            Issue Type Original: Sub-task [ 6 ] New: Suggestion [ 10000 ]
            Priority Original: Highest [ 1 ]
            Status Original: Closed [ 6 ] New: RESOLVED [ 5 ]
            set-jac-bot made changes -
            Link New: This issue is detailed by CWD-1507 [ CWD-1507 ]
            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 - restricted [ 1510729 ] New: JAC Sub-task Workflow [ 3389504 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 [ 1391106 ] New: Simplified Crowd Development Workflow v2 - restricted [ 1510729 ]
            Owen made changes -
            Workflow Original: Crowd Development Workflow v2 [ 272276 ] New: Simplified Crowd Development Workflow v2 [ 1391106 ]
            jawong.adm made changes -
            Workflow Original: JIRA Bug Workflow v2 [ 176688 ] New: Crowd Development Workflow v2 [ 272276 ]
            Justin Koke made changes -
            Workflow Original: jira [ 76080 ] New: JIRA Bug Workflow v2 [ 176688 ]
            Justin Koke made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Open [ 1 ] New: Resolved [ 5 ]
            Justin Koke made changes -
            Link New: This issue is incorporated by CWD-1507 [ CWD-1507 ]

              justen.stepka@atlassian.com Justen Stepka [Atlassian]
              dhardiker Dan Hardiker
              Votes:
              8 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: