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

Misconfigured SQL Server causes severe problems in Bamboo

    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

      USE [master]
GO
ALTER DATABASE [bambooM1] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
ALTER DATABASE [bambooM1] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT
ALTER DATABASE [bambooM1] COLLATE Latin1_General_CS_AS
ALTER DATABASE [bambooM1] SET MULTI_USER
GO

      The lack of those settings can cause EXPIRY to cause the Bamboo service to hang, for example.

      Please, check if the collation/isolation in the upgrade task and refuse to start if they are incorrect.

      Attachments

        Issue Links

          was cloned as

          BDEV-8644 Loading...

          Activity

            People

              Unassigned Unassigned
              rsperafico Rafael Sperafico (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: