Skip to main content

🧠 AWS RDS Cluster engine is outside standard support - prod.logic.yaml🟢

Uses​

Test Results 🟢​

Generated at: 2026-10-30T18:09:55.007913286Z Open

ResultIdCondition IndexCondition TextRuntime Error
🟢standard-enrolled✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢standard-start-boundary✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢standard-end-boundary✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢extended-start-boundary✔️ 1300✔️ otherwise✔️ null
🟢extended-current✔️ 1300✔️ otherwise✔️ null
🟢extended-end-boundary✔️ 1300✔️ otherwise✔️ null
🟢final-support-expired✔️ 1199✔️ extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()✔️ null
🟢reordered-phases✔️ 1300✔️ otherwise✔️ null
🟢standard-enrollment-disabled✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢extended-enrollment-disabled✔️ 1300✔️ otherwise✔️ null
🟢standard-only-supported✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢standard-only-expired✔️ 1099✔️ extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0)✔️ null
🟢future-standard-start✔️ 699✔️ extract('caDateTimeFrom__clusterEngineStandardStart').afterToday()✔️ null
🟢missing-calendar✔️ 399✔️ extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))✔️ null
🟢empty-calendar✔️ 399✔️ extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))✔️ null
🟢malformed-json✔️ 303✔️ extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()✔️ Expected property name or '}' in JSON at position 1 (line 1 column 2)
🟢wrong-root-type✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢duplicate-standard✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢duplicate-extended✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢unknown-phase✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢missing-date✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢invalid-date✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢invalid-extended-date-during-standard✔️ 516✔️ extract('caJsonFrom__clusterEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \'open-source-rds-extended-support\'] | [0].LifecycleSupportEndDate').checkIso8601()✔️ null
🟢inverted-standard-range✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢overlapping-extended-range✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢unexpected-intraday-end✔️ 899✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays'))✔️ null
🟢missing-engine✔️ 201✔️ CA10__engine__c.isEmpty()✔️ null
🟢missing-version✔️ 301✔️ CA10__engineVersion__c.isEmpty()✔️ null
🟢missing-status✔️ 101✔️ CA10__status__c.isEmpty()✔️ null
🟢deleting✔️ 199✔️ extract('CA10__status__c') == 'deleting'✔️ null
🟢stopped-still-assessed✔️ 1300✔️ otherwise✔️ null
🟢neptune-excluded✔️ 299✔️ not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))✔️ null
🟢documentdb-excluded✔️ 299✔️ not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))✔️ null
🟢disappeared✔️ 99✔️ isDisappeared(CA10__disappearanceTime__c)✔️ null
🟢valid-leap-day-standard-end✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢gap-before-extended-support✔️ 1299✔️ extract('caDateTimeFrom__clusterEngineExtendedStart').afterToday()✔️ null
🟢aurora-mysql-standard✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢intraday-extended-end-retains-standard-eos✔️ 799✔️ extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays'))✔️ null
🟢unexpected-engine-enum✔️ 299✔️ not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))✔️ null
🟢new-aurora-postgresql-18-calendar-unavailable✔️ 399✔️ extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))✔️ null
🟢empty-array-with-whitespace✔️ 399✔️ extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))✔️ null
🟢missing-version-and-empty-array✔️ 301✔️ CA10__engineVersion__c.isEmpty()✔️ null
🟢missing-version-and-missing-calendar✔️ 301✔️ CA10__engineVersion__c.isEmpty()✔️ null
🟢unexpected-status✔️ 1300✔️ otherwise✔️ null
🟢upgrading-current-version-still-expired✔️ 1300✔️ otherwise✔️ null
🟢backing-up-current-version-still-expired✔️ 1300✔️ otherwise✔️ null
🟢creating-missing-version✔️ 301✔️ CA10__engineVersion__c.isEmpty()✔️ null
🟢mariadb-is-not-a-cluster-engine✔️ 299✔️ not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))✔️ null
🟢commercial-instance-engine-on-cluster✔️ 299✔️ not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))✔️ null
🟢legacy-aurora-excluded✔️ 299✔️ not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))✔️ null
🟢multi-az-mysql-standard-final-day✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢multi-az-mysql-extended-first-day✔️ 1300✔️ otherwise✔️ null
🟢multi-az-mysql-final-support-expired✔️ 1199✔️ extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()✔️ null
🟢aurora-postgresql-16.8-standard✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢aurora-postgresql-16.11-standard✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢multi-az-postgresql-standard✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢recoverable-cluster-still-assessed✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢serverless-cluster-still-assessed✔️ 1300✔️ otherwise✔️ null
🟢auto-minor-upgrade-does-not-resolve-major-eos✔️ 1300✔️ otherwise✔️ null
🟢aurora-mysql-2-extended-before-charging-starts✔️ 1300✔️ otherwise✔️ null
🟢aurora-mysql-2-extended-last-day✔️ 1300✔️ otherwise✔️ null
🟢aurora-mysql-2-final-support-expired✔️ 1199✔️ extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()✔️ null
🟢calendar-json-null-is-invalid-enrichment✔️ 499✔️ not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))✔️ null
🟢rebooting-multi-az-cluster-still-assessed✔️ 1300✔️ otherwise✔️ null
🟢future-aurora-postgresql-version-standard✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢future-postgres-version-standard✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢future-aurora-mysql-version-standard✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢future-mysql-version-standard✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null
🟢future-version-still-fails-after-standard-support-ends✔️ 1099✔️ extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0)✔️ null
🟢unlisted-status-with-standard-support✔️ 999✔️ not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())✔️ null

Generation Bundle​

FileMD5
Open/ce/ca/aws/rds/cluster-engine-support/policy.yaml6545D348131173DADA9164FCAD7E58B1
Open/ce/ca/aws/rds/cluster-engine-support/prod.logic.yaml66635B9727C934C6A950A2D8BE3C4024
Open/ce/ca/aws/rds/cluster-engine-support/test-data.json84CB8F78404B5B2D27C7933E88B87756
Open/types/CA10__CaAwsDbCluster__c/cluster-engine-support.extracts.yamlB375733DD23A2C39CD3713C93EE6AFDC
Open/types/CA10__CaAwsDbCluster__c/object.extracts.yaml06106363DB027F40632D1ACB814D99C8

Available Commands​

repo-manager policies generate FULL /ce/ca/aws/rds/cluster-engine-support/prod.logic.yaml
repo-manager policies generate DEBUG /ce/ca/aws/rds/cluster-engine-support/prod.logic.yaml
repo-manager policies generate CAPTURE_TEST_DATA /ce/ca/aws/rds/cluster-engine-support/prod.logic.yaml
repo-manager policies generate TESTS /ce/ca/aws/rds/cluster-engine-support/prod.logic.yaml
# Execute tests
repo-manager policies test /ce/ca/aws/rds/cluster-engine-support/prod.logic.yaml

Content​

Open File

---
inputType: CA10__CaAwsDbCluster__c
testData:
  - file: test-data.json
importExtracts:
  - file: /types/CA10__CaAwsDbCluster__c/object.extracts.yaml
  - file: /types/CA10__CaAwsDbCluster__c/cluster-engine-support.extracts.yaml
conditions:
  - status: INAPPLICABLE
    currentStateMessage: The DB cluster is being deleted.
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__status__c
        right:
          TEXT: deleting
  - status: INAPPLICABLE
    currentStateMessage: This policy does not assess support for this cluster's database engine.
    check:
      NOT:
        arg:
          CONTAINS:
            arg:
              SET:
                itemType: TEXT
                items:
                  - aurora-mysql
                  - aurora-postgresql
                  - mysql
                  - postgres
            search:
              EXTRACT: CA10__engine__c
  - status: INAPPLICABLE
    currentStateMessage: Support dates are unavailable for this cluster's engine major version.
    check:
      AND:
        args:
          - NOT_EMPTY:
              arg:
                EXTRACT: CA10__engineVersion__c
          - OR:
              args:
                - IS_EMPTY:
                    arg:
                      EXTRACT: CA10A2__engineLifecycleSupportInfo__c
                - EXTRACT: caJsonQueryBoolean__clusterEngineCalendarEmpty
  - status: UNDETERMINED
    currentStateMessage: The engine support information is incomplete or inconsistent, so support status cannot be assessed.
    check:
      NOT:
        arg:
          EXTRACT: caJsonQueryBoolean__clusterEngineCalendarValid
  # Parse every published date before making a support claim, including future Extended Support dates.
  - status: UNDETERMINED
    currentStateMessage: A required engine support date is missing or invalid.
    check:
      NOT:
        arg:
          AND:
            args:
              - NOT_EMPTY:
                  arg:
                    EXTRACT: caDateTimeFrom__clusterEngineStandardStart
              - NOT_EMPTY:
                  arg:
                    EXTRACT: caDateTimeFrom__clusterEngineStandardEnd
              - OR:
                  args:
                    - IS_EQUAL:
                        left:
                          EXTRACT: caJsonQueryNumber__clusterEngineExtendedPhaseCount
                        right:
                          NUMBER: 0
                    - AND:
                        args:
                          - NOT_EMPTY:
                              arg:
                                EXTRACT: caDateTimeFrom__clusterEngineExtendedStart
                          - NOT_EMPTY:
                              arg:
                                EXTRACT: caDateTimeFrom__clusterEngineExtendedEnd
  - status: UNDETERMINED
    currentStateMessage: The reported standard support period for this engine version has not started.
    check:
      IS_AFTER_TODAY:
        arg:
          EXTRACT: caDateTimeFrom__clusterEngineStandardStart
  - status: INCOMPLIANT
    currentStateMessage: AWS standard support has ended for this engine version, but its Extended Support status could not be confirmed.
    remediationMessage: Plan a tested engine upgrade and verify any temporary Extended Support coverage with AWS.
    check:
      AND:
        args:
          - IS_BEFORE_TODAY:
              arg:
                EXTRACT: caDateTimeFrom__clusterEngineStandardEnd
          - NOT:
              arg:
                EXTRACT: caJsonQueryBoolean__clusterEngineCalendarWholeDays
  - status: UNDETERMINED
    currentStateMessage: Standard support for this engine version cannot be confirmed from the reported dates.
    check:
      NOT:
        arg:
          EXTRACT: caJsonQueryBoolean__clusterEngineCalendarWholeDays
  - status: COMPLIANT
    currentStateMessage: The cluster's engine major version is within AWS standard support.
    check:
      NOT:
        arg:
          IS_BEFORE_TODAY:
            arg:
              EXTRACT: caDateTimeFrom__clusterEngineStandardEnd
  - status: INCOMPLIANT
    currentStateMessage: AWS standard support has ended for this engine version, and no Extended Support period is listed.
    remediationMessage: Test and upgrade the cluster to an engine major version within AWS standard support.
    check:
      IS_EQUAL:
        left:
          EXTRACT: caJsonQueryNumber__clusterEngineExtendedPhaseCount
        right:
          NUMBER: 0
  - status: INCOMPLIANT
    currentStateMessage: The cluster's engine major version is past the end of AWS support, including Extended Support.
    remediationMessage: Prioritize a tested engine upgrade and confirm the cluster's current version and support status with AWS.
    check:
      IS_BEFORE_TODAY:
        arg:
          EXTRACT: caDateTimeFrom__clusterEngineExtendedEnd
  - status: INCOMPLIANT
    currentStateMessage: AWS standard support has ended for this engine version, and its listed Extended Support period has not started.
    remediationMessage: Test and upgrade to an engine major version within AWS standard support, and confirm support coverage with AWS.
    check:
      IS_AFTER_TODAY:
        arg:
          EXTRACT: caDateTimeFrom__clusterEngineExtendedStart
otherwise:
  status: INCOMPLIANT
  currentStateMessage: The cluster's engine major version is outside AWS standard support but within the published RDS Extended Support period.
  remediationMessage: Plan a tested engine upgrade or approve a temporary exception after verifying Extended Support enrollment and costs.