Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-9814

Upgrading fails due to "'DF_cwd_application_address_remote_address_mask' is not a constraint."

      Summary

      The database upgrade of Bitbucket Server fails.

      Environment

      • MSSQL Server as database

      Steps to Reproduce

      1. Upgrade Bitbucket Server

      Expected Results

      The upgrade is successful and the application starts.

      Actual Results

      The below exception is thrown in the atlassian-bitbucket.log file:

      WARN  [spring-startup]  o.s.w.c.s.XmlWebApplicationContext Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'crowdAliasDao': Unsatisfied dependency expressed through method 'setSessionFactory' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/r2_2/m01.xml::STASHDEV-3270-2a::bturner:
           
      Reason: liquibase.exception.DatabaseException: 'DF_cwd_application_address_remote_address_mask' is not a constraint. [Failed SQL: ALTER TABLE [dbo].[cwd_application_address] DROP CONSTRAINT [DF_cwd_application_address_remote_address_mask]]
      

      Workaround

      Rollback to a previous version of Bitbucket Server.

        1. after.png
          after.png
          420 kB
        2. before.png
          before.png
          265 kB

            [BSERV-9814] Upgrading fails due to "'DF_cwd_application_address_remote_address_mask' is not a constraint."

            Owen made changes -
            Workflow Original: Stash Workflow - Restricted [ 2302210 ] New: JAC Bug Workflow v3 [ 3137320 ]
            Owen made changes -
            Symptom Severity Original: Major [ 14431 ] New: Severity 2 - Major [ 15831 ]
            Hendrik (Inactive) made changes -
            Fix Version/s New: 5.2.0 [ 71978 ]
            Fix Version/s New: 5.0.5 [ 72634 ]
            Fix Version/s New: 5.1.3 [ 72635 ]
            Hendrik (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Quality Review [ 10029 ] New: Closed [ 6 ]
            Hendrik (Inactive) made changes -
            Status Original: To be reviewed [ 10026 ] New: Quality Review [ 10029 ]
            Hendrik (Inactive) made changes -
            Link New: This issue is related to BSERV-3540 [ BSERV-3540 ]
            Hendrik (Inactive) made changes -
            Remote Link New: This issue links to "Page (Extranet)" [ 301815 ]
            Ben Humphreys made changes -
            Remote Link New: This issue links to "Bitbucket Server › 5.0.X DAO › bugfix-BSERV-9814-fix-mssql-default-schema (server-syd-bamboo)" [ 301733 ]
            Hendrik (Inactive) made changes -
            Status Original: In Progress [ 3 ] New: To be reviewed [ 10026 ]
            Hendrik (Inactive) made changes -
            Status Original: Open [ 1 ] New: In Progress [ 3 ]

              hschnepel Hendrik (Inactive)
              ccurti Caterina Curti
              Affected customers:
              1 This affects my team
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: