This issue is usually seen when user wan't removed properly from Ranger db and some information is still available in user tables. For example in above situation it might be possible that 'user1' is not available in x_user table but its still part of other user tables such as x_portal_user, x_portal_user_role, x_user_module_perm, x_auth_sess etc. Perform below steps to resolve this issue. Verify whether problematic user is available in other tables MariaDB [ranger]> select * from x_user where user_name = 'user1';
MariaDB [ranger]> select id from x_portal_user where login_id = 'user1';
+----+
| id |
+----+
| 44 |
+----+
MariaDB [ranger]> delete from x_portal_user_role where id = 44;
MariaDB [ranger]> delete from x_user_module_perm where user_id = 44;
MariaDB [ranger]> delete from x_auth_sess where user_id = 44;
MariaDB [ranger]> delete from x_portal_user where id = 44; To get all such user's MariaDB [ranger]> select * from x_portal_user_role where id not in (select id from x_user);
MariaDB [ranger]> select * from x_user_module_perm where user_id not in (select id from x_user);
MariaDB [ranger]> select * from x_auth_sess where user_id not in (select id from x_user);
MariaDB [ranger]> select * from x_portal_user where id not in (select id from x_user); Remove users which are not part of x_user table but available in other tables MariaDB [ranger]> delete from x_portal_user_role where id not in (select id from x_user);
MariaDB [ranger]> delete from x_user_module_perm where user_id not in (select id from x_user);
MariaDB [ranger]> delete from x_auth_sess where user_id not in (select id from x_user);
MariaDB [ranger]> delete from x_portal_user where id not in (select id from x_user); Restart usersync process
... View more
