[RANGER-3385] Duplicate SQL prefix should not be allowed

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0, 2.2.0
• Component/s: Ranger
• Assignee: Kishor Gollapalliwar
• Reporter: Kishor Gollapalliwar
• Created: 29/Aug/21 10:07
• Updated: 06/Sep/21 07:31
• Resolved: 31/Aug/21 08:39

Description

Duplicate SQL prefix is allowed. Currently we need a manual human intervention to find and correct. Use case in details as follows.

Use-Case:

1. Say user1 & user2 working on a fix in Ranger and they both need DB changes.
2. Assume user1 needs to update table1 and user2 needs to update table2.
3. Both Checked latest DB patch prefix (say it is 056-). And used prefix 057- for their SQL files

If both commits ends up merging. The setup script will apply ONLY one of the both SQL files (prefixed 057-) randomly.

Reproduce Steps:

1. cd <ranger-repo>/security-admin/db/mysql/patches
2. Update prefix of last 2 patches such that both contains same prefix
3. mvn clean compile package install -U #build ranger
4. setup ranger

To avoid this, we need to fail maven build itself if there are duplicate prefix.

Issue Links

• is cloned by: RANGER-3398 Duplicate JAVA patch suffix should not be allowed