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

Misconfigured SQL Server causes severe problems in Bamboo

XMLWordPrintable

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

      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.

          Form Name

            [BAM-15843] Misconfigured SQL Server causes severe problems in Bamboo

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

                Created:
                Updated:
                Resolved: