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

            Owen made changes -
            Workflow Original: Stash Workflow - Restricted [ 1581922 ] New: JAC Bug Workflow v3 [ 3135214 ]
            Brent P made changes -
            Remote Link New: This issue links to "Page (Extranet)" [ 231684 ]
            Christian made changes -
            Link New: This issue is related to BSERVDEV-12449 [ BSERVDEV-12449 ]
            Bryan Turner (Inactive) made changes -
            Assignee New: Bryan Turner [ bturner ]
            Bryan Turner (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: To be reviewed [ 10026 ] New: Closed [ 6 ]
            Jeff Thomas made changes -
            Remote Link New: This issue links to "Page (Extranet)" [ 187822 ]
            Jeff Thomas made changes -
            Regular Expression New: sta_drift_request ADD attempts INT NOT NULL: ERROR: column "attempts" contains null values
            Bryan Turner (Inactive) made changes -
            Status Original: In Progress [ 3 ] New: To be reviewed [ 10026 ]
            Bryan Turner (Inactive) made changes -
            Status Original: Open [ 1 ] New: In Progress [ 3 ]
            Bryan Turner (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: Open [ 1 ]

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

                Created:
                Updated:
                Resolved: