[RTFACT-14279] Missing database convertor fails upgrade to version 5.3.0 Created: 23/May/17  Updated: 19/Dec/17  Resolved: 04/Jun/17

Status: Resolved
Project: Artifactory Binary Repository
Component/s: Database
Affects Version/s: 4.1.3, 4.4.0, 5.3.0
Fix Version/s: 5.3.1

Type: Bug Priority: Blocker
Reporter: Avi Zaig (Inactive) Assignee: Dan Feldman (Inactive)
Resolution: Fixed Votes: 0
Labels: None


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

Generated at Tue Sep 22 17:44:04 UTC 2020 using Jira 8.5.3#805003-sha1:b4933e02eaff29a49114274fe59e1f99d9d963d7.