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.

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

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3015463 ] New: JAC Suggestion Workflow 3 [ 3594863 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2702079 ] New: JAC Suggestion Workflow [ 3015463 ]
            Owen made changes -
            Issue Type Original: Improvement [ 4 ] New: Suggestion [ 10000 ]
            Owen made changes -
            Workflow Original: Bamboo Workflow 2016 v1 [ 1420461 ] New: Confluence Workflow - Public Facing v4 [ 2702079 ]
            Marcin Oles made changes -
            Resolution Original: Fixed [ 1 ] New: Done [ 17 ]
            Status Original: In Progress [ 3 ] New: Resolved [ 5 ]
            Marcin Oles made changes -
            Fix Version/s New: 5.13.0.1 [ 62187 ]
            Status Original: Open [ 1 ] New: In Progress [ 3 ]
            Marek Went (Inactive) made changes -
            Workflow Original: Bamboo Workflow 2014 v2 [ 850361 ] New: Bamboo Workflow 2016 v1 [ 1420461 ]
            Przemek Bruski made changes -
            Summary Original: Misconfigured SQL Server causes sever problems in Bamboo New: Misconfigured SQL Server causes severe problems in Bamboo
            Przemek Bruski made changes -
            Issue Type Original: Bug [ 1 ] New: Improvement [ 4 ]
            Sten Pittet (Inactive) made changes -
            Remote Link New: This issue links to "BDEV-8644 (Atlassian JIRA Extranet - Special Projects)" [ 100655 ]

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

                Created:
                Updated:
                Resolved: