Uploaded image for project: 'Ranger'
  1. Ranger
  2. RANGER-706

Optimize audit db upgrade patches to minimize timeout issues

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.5.1
    • 0.5.1
    • admin, audit
    • None

    Description

      Ranger upgrade times out while updating the DB schema from 0.4 to 0.5 (bunch of new tables, alter tables to add new columns, etc).
      This can happen, for example, while adding 3 columns to the audit table - as adding a column to an exiting table could be an expensive/time consuming task in MySQL (it involves: 1 - create temp table with new columns 2 - copy old table contents to new table 3 - drop the old table 4 - rename the new table to old table name). And patch script audit/015-auditlogaggregation.sql executes 3 ALTER TABLE statements, to add 3 columns to xa_access_audit table.

      This issue is likely to be hit in deployments that have large number of records in audit table. To be able to address this scenario, we should:

      • Optimize Audit db upgrade patches to minimize timeout issues

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            gautamborad Gautam Borad
            gautamborad Gautam Borad
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment