[AMBARI-25458] DB Purge takes lot of time/hung

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.7.5
• Component/s: ambari-server
• Assignee: Unassigned
• Reporter: amarnath reddy pappu
• Created: 15/Jan/20 23:45
• Updated: 29/Jan/21 16:50

Description

 

During the DB Purge - alert_history table clean up is not doing with batch - Ambari gets hung or takes lot of time.

 

2020-01-15 22:36:39,384  INFO [main] AlertsDAO:1537 - Deleting AlertCurrent entity batch with history ids: 533910 - 534898
2020-01-15 22:36:39,392  INFO [main] AlertsDAO:1537 - Deleting AlertCurrent entity batch with history ids: 534900 - 536020
2020-01-15 22:36:39,398  INFO [main] AlertsDAO:1537 - Deleting AlertCurrent entity batch with history ids: 536022 - 537203
2020-01-15 22:36:39,404  INFO [main] AlertsDAO:1537 - Deleting AlertCurrent entity batch with history ids: 537092 - 537633
2020-01-15 22:36:39,411  INFO [main] AlertsDAO:1570 - Starting: Delete/update entries older than [ 1531180800000 ] for entity [class org.apache.ambari.server.orm.entities.AlertHistoryEntity]
2020-01-15 22:43:48,235  INFO [main] AlertsDAO:1581 - Completed: Delete/update entries older than [ 1531180800000 ] for entity: [class org.apache.ambari.server.orm.entities.AlertHistoryEntity]. Number of entities deleted: [19480]
2020-01-15 22:43:48,259  INFO [main] CleanupServiceImpl:80 - Running the purge process for DAO: [org.apache.ambari.server.orm.dao.RequestDAO$$EnhancerByGuice$$f11e85aa@677349fb] with cleanup policy: [org.apache.ambari.server.cleanup.TimeBasedCleanupPolicy@4466cf5d]
2020-01-15 22:43:48,283  INFO [main] RequestDAO:314 - Deleting ExecutionCommand entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,284  INFO [main] RequestDAO:314 - Deleting TopologyLogicalTask entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,284  INFO [main] RequestDAO:314 - Deleting TopologyHostTask entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,284  INFO [main] RequestDAO:314 - Deleting TopologyHostRequest entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,284  INFO [main] RequestDAO:314 - Deleting HostRoleCommand entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,285  INFO [main] RequestDAO:349 - Deleting RoleSuccessCriteria entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,285  INFO [main] RequestDAO:349 - Deleting Stage entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,285  INFO [main] RequestDAO:314 - Deleting RequestResourceFilter entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,285  INFO [main] RequestDAO:314 - Deleting RequestOperationLevel entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,285  INFO [main] RequestDAO:314 - Deleting Request entities before date Tue Jul 10 00:00:00 UTC 2018
2020-01-15 22:43:48,288  INFO [main] CleanupDriver:100 - DB-PURGE - completed. Number of affected records [22276]

During the DB Purge - alert_history table clean up is not doing with batch - Ambari gets hung or takes lot of time.