[
https://issues.apache.org/jira/browse/RANGER-5154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dineshkumar Yadav updated RANGER-5154:
--------------------------------------
Fix Version/s: 2.7.0
> Functionality to delete records from x_auth_sess table via api is not working
> -----------------------------------------------------------------------------
>
> Key: RANGER-5154
> URL: https://issues.apache.org/jira/browse/RANGER-5154
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Affects Versions: 3.0.0
> Reporter: Vishal Bhavsar
> Assignee: Rakesh Gupta
> Priority: Major
> Fix For: 2.7.0
>
>
> Functionality to delete records from x_auth_sess table via api is not working.
>
> Upon hitting below curl command we get error
> {code}
> curl -u admin:Admin123 -H "Accept: application/json" -H "Content-Type:
> application/json" -X DELETE
> 'http://localhost:6080/service/public/v2/api/server/purge/records?type=login_records&retentionDays=5'{code}
> error
> {code}{"statusCode":1,"msgDesc":"Exception [EclipseLink-4002] (Eclipse
> Persistence Services - 2.7.12.v20230209-e5c4074ef3):
> org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception:
> org.postgresql.util.PSQLException: ERROR: relation \"x_trx_log\" does not
> exist\n Position: 8\nError Code: 0\nCall: UPDATE x_trx_log SET SESS_ID = ?
> WHERE (CREATE_TIME < ?)\n\tbind => [2 parameters bound]\nQuery:
> UpdateAllQuery(name=\"XXTrxLog.updateSessIdWithNull\" referenceClass=XXTrxLog
> sql=\"UPDATE x_trx_log SET SESS_ID = ? WHERE (CREATE_TIME < ?)\")"}{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
