Bug 1909740

Summary:	[DOCS] Clarify which databases are working for Hive metastore
Product:	OpenShift Container Platform	Reporter:	Arne Gogala <agogala>
Component:	Metering Operator	Assignee:	Nobody <nobody>
Status:	CLOSED DEFERRED	QA Contact:	Peter Ruan <pruan>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	4.5	CC:	aos-bugs
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2023-03-09 01:00:30 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Arne Gogala 2020-12-21 14:27:05 UTC

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

Comment 4 Shiftzilla 2023-03-09 01:00:30 UTC

OpenShift has moved to Jira for its defect tracking! This bug can now be found in the OCPBUGS project in Jira.

https://issues.redhat.com/browse/OCPBUGS-8826