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

EJBCA startup does full table analysis on Oracle causing timeout issue during startup

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: EJBCA 6.7.0
    • Fix Version/s: EJBCA 6.15.2, EJBCA 7.0.1
    • Component/s: None
    • Labels:
      None
    • Environment:
      Database: Oracle 18c
      EJBCA 6.15.0
      WildFly 10
      Oracle JDBC 6 or 8
    • Provenance:
      Internal Delivery
    • Issue discovered during:
      Customer
    • Sprint:
      EJBCA Team Alice - 2019 w6

      Description

      Problem: Timeout issue during EJBCA startup
      Cause: The timeout problem is probably related to a big amount of certificate data in database. The customer has over 10 milions records in certificatedata table.

      From the customer's analysis of queries we know that during running the application the following queries are used:

      Analyze table CertificateData compute statistics
      Analyze table CERTIFICATEDATA compute statistics

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              tomas Tomas Gustavsson
              Reporter:
              rubinaa Rubina Akram
              Verified by:
              Johan Eklund
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 30 minutes
                  30m
                  Remaining:
                  Time Spent - 20 minutes Remaining Estimate - 10 minutes
                  10m
                  Logged:
                  Time Spent - 20 minutes Remaining Estimate - 10 minutes
                  20m