Before upgrading to code base of this patch(RANGER-2203) please take the backup of your current ranger database first. After taking the backup please delete ‘DB_PATCHES’ and ‘JAVA_PATCHES’ entry from x_db_version_h table of current ranger db.
To delete the entries please login to ranger db and execute the following sql command:
- select max(id) db_patch_id from x_db_version_h where version='DB_PATCHES';
- delete from x_db_version_h where id=<db_patch_id>
Here db_patch_id is the max row id of the 'DB_PATCHES' entry in x_db_version_h table for current ranger version.
- select max(id) java_patch_id from x_db_version_h where version='JAVA_PATCHES';
- delete from x_db_version_h where id=<java_patch_id>
Here java_patch_id is the max row id of the 'JAVA_PATCHES' entry in x_db_version_h table for current ranger version.