Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-7607

Optimize ejbca-db-cli speed when verifying audit log

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: EJBCA 6.15.1
    • Fix Version/s: EJBCA 7.0.1
    • Component/s: None
    • Labels:
      None
    • Provenance:
      Internal Delivery
    • Issue discovered during:
      Customer
    • Sprint:
      EJBCA Team Alice - 2019 w6

      Description

      There are two issues with the "ejbca-db-cli.jar verify" command, here and ECA-7609

      1. See ECA-7609.
      2. The verify is extremely slow on a large dataset. If you had million records in the table, it could take days. Improving DB query in "IntegrityProtectedAuditReader.java” fixes this. This speeds up verify considerably.

       

        Attachments

          Issue Links

          is cloned by

          Improvement - An improvement or enhancement to an existing feature or task. ECA-7609 Clear hibernate cache in ejbca-db-cli to avoid high memory usage

          • Major - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              tomas Tomas Gustavsson
              Reporter:
              tomas Tomas Gustavsson
              Verified by:
              Johan Eklund
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4 hours
                  4h
                  Remaining:
                  Time Spent - 2 hours Remaining Estimate - 2 hours
                  2h
                  Logged:
                  Time Spent - 2 hours Remaining Estimate - 2 hours
                  2h