(ranger) branch master updated: RANGER-5154: Functionality to delete records from x_auth_sess table via api is not working

[dineshkumar]

This is an automated email from the ASF dual-hosted git repository.

dineshkumar pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/ranger.git


The following commit(s) were added to refs/heads/master by this push:
     new dbaad69de RANGER-5154: Functionality to delete records from 
x_auth_sess table via api is not working
dbaad69de is described below

commit dbaad69de10ff7b21b5bd3fc08c4b65b4aa25dff
Author: Rakesh Gupta <rakesh.gupta.dev...@gmail.com>
AuthorDate: Thu Mar 13 12:27:16 2025 +0530

    RANGER-5154: Functionality to delete records from x_auth_sess table via api 
is not working
    
    Signed-off-by: Dineshkumar Yadav <dineshkumar.ya...@outlook.com>
---
 .../src/main/java/org/apache/ranger/db/XXAuthSessionDao.java        | 6 +++---
 security-admin/src/main/resources/META-INF/jpa_named_queries.xml    | 4 ++--
 2 files changed, 5 insertions(+), 5 deletions(-)

diff --git 
a/security-admin/src/main/java/org/apache/ranger/db/XXAuthSessionDao.java 
b/security-admin/src/main/java/org/apache/ranger/db/XXAuthSessionDao.java
index 658614e01..3deb41e52 100644
--- a/security-admin/src/main/java/org/apache/ranger/db/XXAuthSessionDao.java
+++ b/security-admin/src/main/java/org/apache/ranger/db/XXAuthSessionDao.java
@@ -101,9 +101,9 @@ public long deleteOlderThan(int olderThanInDays) {
         long ret = 
getEntityManager().createNamedQuery("XXAuthSession.deleteOlderThan").setParameter("olderThan",
 since).executeUpdate();
         LOG.info("Deleted {} x_auth_sess records", ret);
 
-        LOG.info("Updating x_trx_log.sess_id with null which are older than {} 
days, that is, older than {}", olderThanInDays, since);
-        long updated = 
getEntityManager().createNamedQuery("XXTrxLog.updateSessIdWithNull").setParameter("olderThan",
 since).executeUpdate();
-        LOG.info("Updated {} x_trx_log records", updated);
+        LOG.info("Updating x_trx_log_v2.sess_id with null which are older than 
{} days, that is, older than {}", olderThanInDays, since);
+        long updated = 
getEntityManager().createNamedQuery("XXTrxLogV2.updateSessIdWithNull").setParameter("olderThan",
 since).executeUpdate();
+        LOG.info("Updated {} x_trx_log_v2 records", updated);
         return ret;
     }
 }
diff --git a/security-admin/src/main/resources/META-INF/jpa_named_queries.xml 
b/security-admin/src/main/resources/META-INF/jpa_named_queries.xml
index 05ba59f28..3559877d5 100755
--- a/security-admin/src/main/resources/META-INF/jpa_named_queries.xml
+++ b/security-admin/src/main/resources/META-INF/jpa_named_queries.xml
@@ -1624,8 +1624,8 @@
        <named-query name="XXTrxLog.deleteOlderThan">
                <query>delete from XXTrxLog obj where obj.createTime &lt; 
:olderThan</query>
        </named-query>
-       <named-query name="XXTrxLog.updateSessIdWithNull">
-               <query>UPDATE XXTrxLog obj SET obj.sessionId = null WHERE 
obj.createTime &lt; :olderThan</query>
+       <named-query name="XXTrxLogV2.updateSessIdWithNull">
+               <query>UPDATE XXTrxLogV2 obj SET obj.sessionId = null WHERE 
obj.createTime &lt; :olderThan</query>
        </named-query>
 
        <named-query name="XXAuthSession.getAuthSessionByUserId">