[
https://issues.apache.org/jira/browse/SENTRY-2461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lars Francke updated SENTRY-2461:
---------------------------------
Affects Version/s: 2.0.0
> Should use DataNucleus Bulk Deletes instead of Delete by Query for purging
> tables
> ---------------------------------------------------------------------------------
>
> Key: SENTRY-2461
> URL: https://issues.apache.org/jira/browse/SENTRY-2461
> Project: Sentry
> Issue Type: Improvement
> Components: Core
> Affects Versions: 2.0.0
> Reporter: Lars Francke
> Priority: Major
>
> Sentry purges a bunch of tables (e.g. the `SENTRY_HMS_NOTIFICATION_ID`) but
> it uses the `deletePersistentAll` method from DataNucleus which first runs a
> SELECT query and materializes all these objects in memory before deleting
> them.
> In our case we accumulated a few million (for reasons as of yet unknown) rows
> in the table and Sentry would always run into OOM errors before it could
> purge the data.
> Instead of the Delete by Query functionality we should use the Bulk Delete
> feature and run a "DELETE" command directly.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
