Uploaded image for project: 'OpenShift Bugs'
  1. OpenShift Bugs
  2. OCPBUGS-8826

[DOCS] Clarify which databases are working for Hive metastore

XMLWordPrintable

    • Quality / Stability / Reliability
    • None
    • None
    • None
    • Moderate
    • None
    • All
    • None
    • None
    • None
    • None
    • None
    • If docs needed, set a value
    • None
    • None
    • None
    • None
    • None

      Description of problem:
      Currently the "Using MySQL or PostgreSQL for the Hive Metastore" section from the OpenShift Metering documentation [1] does not outline specific database releases known to work for the Hive metastore.

      As there are two Bugzillas regarding this issue [2], [3], this seems to be well known but customers are not aware and will most likely pick more recent databases causing issues.

      [1] - https://docs.openshift.com/container-platform/latest/metering/configuring_metering/metering-configure-hive-metastore.html#metering-use-mysql-or-postgresql-for-hive_metering-configure-hive-metastore
      [2] - https://bugzilla.redhat.com/show_bug.cgi?id=1838802
      [3] - https://bugzilla.redhat.com/show_bug.cgi?id=1838845

      Version-Release number of selected component (if applicable):
      4.5, 4.6

      How reproducible:
      Try to use recent PostgreSQL or MySQL 8 as database backend for Hive metastore

      Actual results:
      creation of reports fails with the following error message:

      failed to validate ReportQuery dependencies namespace-memory-request: ReportQueryDependencyValidationError: uninitialized
      ReportDataSource dependencies: pod-memory-request-raw, pod-request-memory-bytes

      Expected results:
      Documentation should outline which exact database is currently working

      Additional info:
      KCS regarding "Openshift Metering - Error on creating report"
      https://access.redhat.com/solutions/5619421

              openshift_jira_bot OpenShift Jira Bot
              rhn-support-agogala Arne Gogala
              None
              None
              Peter Ruan Peter Ruan
              None
              Red Hat Employee
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: