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

Incorrect SQL upgrading to 4.8.0

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Highest Highest
    • 4.8.1
    • 4.8.0
    • Maintenance - Upgrade
    • None

      Upgrading to 4.8.0 can fail with the following error:

      2016-07-19 18:09:23,409 ERROR [spring-startup]  liquibase Change Set liquibase/r4_8/upgrade.xml::BSERVDEV-12993-1::cszmajda failed.  Error: Error executing SQL ALTER TABLE public.sta_drift_request ADD attempts INT NOT NULL: ERROR: column "attempts" contains null values
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE public.sta_drift_request ADD attempts INT NOT NULL: ERROR: column "attempts" contains null values

      A default value is not being correctly applied by the script. This will be fixed in 4.8.1. For instances which encounter this, the workaround is to delete all rows from the sta_drift_request table. Deleting those rows should have no user-visible impact on the system.

          Form Name

            [BSERV-8970] Incorrect SQL upgrading to 4.8.0

            No work has yet been logged on this issue.

              bturner Bryan Turner (Inactive)
              bturner Bryan Turner (Inactive)
              Affected customers:
              1 This affects my team
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: