Description
The table x_auth_session may contain records for a user in thousands. For users which are frequently used, this count is usually 10k to 15k, in some cases it can be higher.
For such a user, when delete API
/xusers/secure/users/id/{user_id}
is called, deletion of records from x_auth_sess can take minutes, since rows will be locked for deletion and following exception is noticed in logs:
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
During testing for deletion of a user with about 30k records in x_auth_session, it took about 6.4 minutes.
To optimize this, we can implement RANGER-3681 for deletion of records from x_auth_sess.
Attachments
Issue Links
- relates to
-
RANGER-4896 foreign key references to user table should be removed from login records table
-
- Open
-