-
Bug
-
Resolution: Obsolete
-
Normal
-
None
-
4.5
-
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