Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-10090

Indexing problem in table USER_COMMIT because of column COMMIT_REVISION text type

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • 3.4 M2
    • 3.3.2
    • None
    • None

      This error happens because the column COMMIT_REVISION in the table USER_COMMIT is set to TEXT, 

      2011-10-24 12:06:05,071 ERROR [main] [SchemaUpdate] Unsuccessful: create index commit_rev_idx on USER_COMMIT (COMMIT_REVISION)
2011-10-24 12:06:05,071 ERROR [main] [SchemaUpdate] BLOB/TEXT column 'COMMIT_REVISION' used in key specification without a key length

      There is a limitation on indexing TEXT type fields. As this post states, we can have VARCHAR type with maximum 65,532 bytes after MySQL 5.0.3.

      We should change the column type from TEXT to VARCHAR.

            [BAM-10090] Indexing problem in table USER_COMMIT because of column COMMIT_REVISION text type

            No work has yet been logged on this issue.

              Unassigned Unassigned
              akhachatryan ArmenA
              Affected customers:
              2 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 5m
                  5m
                  Remaining:
                  Remaining Estimate - 5m
                  5m
                  Logged:
                  Time Spent - Not Specified
                  Not Specified