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

Make crlPartitionIndex nullable instead of DEFAULT 0

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: EJBCA 7.1.0
    • Fix Version/s: EJBCA 7.1.0
    • Component/s: None
    • Labels:
      None
    • Provenance:
      Ordered by Customer
    • Issue discovered during:
      Ad Hoc
    • Sprint:
      EJBCA Team Bob - 2019 w10, EJBCA Team Bob - 2019 w13

      Description

      Apparently, MariaDB (and perhaps other DBMs) will rewrite the full table if you add a non-nullable column, even if it has a default value. This is really bad for potentially large tables like CertificateData and CRLData.

      Change the crlPartitionIndex column to be nullable, and handle the weirdness of NULL values in queries and in the Java code.

        Attachments

          Activity

            People

            • Assignee:
              katja_helmes Jekaterina Bunina
              Reporter:
              samuel Samuel Lidén Borell
              Verified by:
              Samuel Lidén Borell
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4 hours Original Estimate - 4 hours
                4h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 6 hours, 1 minute
                6h 1m