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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Low
    • 5.15.0.1
    • 5.9.3, 5.10.3, 5.11.1.1
    • Deployments
    • None

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: