Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-14279

Missing database convertor fails upgrade to version 5.3.0

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: 1 - Blocker
    • Resolution: Done
    • Affects Version/s: 4.1.3, 4.4.0, 5.3.0
    • Fix Version/s: 5.3.1
    • Component/s: Database
    • Labels:
      None
    • Severity:
      Critical

      Description

      This goes to all upgrades of versions below 4.4.1 to 5.3.0 only.

      Artifactory will fail to restart with the following error:

      Caused by: java.sql.SQLException: Column '19' not found.
      

      As a result of a missing column in the table 'users':

      In order to fix it, need to run the following query on the database
      ALTER TABLE users ADD COLUMN credentials_expired SMALLINT;
      to add this column

        Attachments

          Activity

            People

            Assignee:
            danf Dan Feldman (Inactive)
            Reporter:
            aviz Avi Zaig (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Sync Status

                Connection: RTFACT Sync
                RTMID-14279 -
                SYNCHRONIZED
                • Last Sync Date: