Specified key was too long; max key length is 767 bytes

XMLWordPrintable

    • Type: Bug
    • Resolution: Done
    • Priority: Low
    • 5.15.0.1
    • Affects Version/s: 5.9.3, 5.10.3, 5.11.1.1
    • Component/s: Deployments
    • None
    • Severity 3 - Minor

      create index dep_ver_commit_rev_idx on DEPLOYMENT_VERSION_COMMIT (COMMIT_REVISION)
      2015-07-14 00:42:46,355 ERROR [localhost-startStop-1] [SchemaUpdate] Unsuccessful: create index dep_ver_commit_rev_idx on DEPLOYMENT_VERSION_COMMIT (COMMIT_REVISION)
      2015-07-14 00:42:46,355 ERROR [localhost-startStop-1] [SchemaUpdate] Specified key was too long; max key length is 767 bytes
      2015-07-14 00:42:46,355 INFO [localhost-startStop-1] [SchemaUpdate] schema update complete

      Workaround

      1. Stop Bamboo
      2. Run the SQL against the Bamboo database
        ALTER TABLE REPOSITORY_CHANGESET MODIFY CHANGESET_ID VARCHAR(255);
        ALTER TABLE USER_COMMIT MODIFY COMMIT_REVISION VARCHAR(255);
        ALTER TABLE DEPLOYMENT_VERSION_COMMIT MODIFY COMMIT_REVISION VARCHAR(255);
        
      3. Start Bamboo

            Assignee:
            Unassigned
            Reporter:
            Lorenzo
            Votes:
            5 Vote for this issue
            Watchers:
            15 Start watching this issue

              Created:
              Updated:
              Resolved: