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

upgrade task 2806 improvements (better logs/informations)

    XMLWordPrintable

Details

    • 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.

    Description

      Upgrade task 2806 carries out the conversion of column type from TEXT to VARCHAR. However, when using MySQL as DB one might encounter following error in the logs:

      ERROR [main] [SchemaUpdate] Unsuccessful: create index commit_rev_idx on USER_COMMIT (COMMIT_REVISION)
ERROR [main] [SchemaUpdate] BLOB/TEXT column 'COMMIT_REVISION' used in key specification without a key length

      After next Bamboo restart the indices will re-create correctly.

      It would be cool if, we add something to 3.4.5 so:

      • at the end of upgrade logs there would be a pretty obvious message (about the necessary Bamboo restart)
      • in admin screen there would be proper information if Bamboo detects the non-existence of the index

      see: BAM-10090, BSP-6626 for the details.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. BAM-10090 Indexing problem in table USER_COMMIT because of column COMMIT_REVISION text type

          • Low - Low priority issues
          • Closed

          Activity

            People

              Unassigned Unassigned
              pstefaniak PiotrA
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: