Bug 1909740 - [DOCS] Clarify which databases are working for Hive metastore
Summary: [DOCS] Clarify which databases are working for Hive metastore
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: OpenShift Container Platform
Classification: Red Hat
Component: Metering Operator
Version: 4.5
Hardware: All
OS: Unspecified
medium
medium
Target Milestone: ---
: ---
Assignee: Nobody
QA Contact: Peter Ruan
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-12-21 14:27 UTC by Arne Gogala
Modified: 2023-03-09 01:00 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2023-03-09 01:00:30 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1838802 0 high CLOSED mysql8 connector from operatorhub does not work with metering operator 2024-03-25 15:57:58 UTC
Red Hat Bugzilla 1838845 0 high CLOSED Metering operator can't connect to postgres DB from Operator Hub 2024-03-25 15:58:03 UTC
Red Hat Knowledge Base (Solution) 5619421 0 None None None 2020-12-21 14:28:09 UTC

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


Note You need to log in before you can comment on or make changes to this bug.