Uploaded image for project: 'Ambari'
  1. Ambari
  2. AMBARI-25458

DB Purge takes lot of time/hung

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.7.5
    • Fix Version/s: None
    • Component/s: ambari-server
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              apappu@hortonworks.com amarnath reddy pappu
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: