Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.
Bug 1510422 - CFME Deployment Should fail more obviously if PostgreSQL is incompatible
Summary: CFME Deployment Should fail more obviously if PostgreSQL is incompatible
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: OpenShift Container Platform
Classification: Red Hat
Component: Installer
Version: 3.7.0
Hardware: Unspecified
OS: Unspecified
low
low
Target Milestone: ---
: ---
Assignee: Tim Bielawa
QA Contact: Gaoyun Pei
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-11-07 11:52 UTC by Gaoyun Pei
Modified: 2019-01-31 15:56 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-01-31 15:56:32 UTC


Attachments (Terms of Use)

Description Gaoyun Pei 2017-11-07 11:52:03 UTC
Description of problem:
CFME will fail to deploy if the PostgreSQL database is too old. 
The manageiq-0 pod logs will show this error message if that is detected:

> The version of PostgreSQL being connected to is incompatible with ManageIQ (9.4+ required)

We should check for this output and display a helpful *obvious* error message to the user if their postgresql version is too old.



Version-Release number of the following components:
openshift-ansible-3.7.0-0.196.0.git.0.27cd7ec.el7.noarch

How reproducible:
100%

Steps to Reproduce:
1. With the following options added into ansible inventory file in addition, run cfme deployment playbook.

openshift_management_install_beta=true
openshift_management_app_template=miq-template-ext-db
openshift_management_storage_class=nfs
openshift_management_template_parameters={'DATABASE_USER': 'postgres', 'DATABASE_PASSWORD': 'x', 'DATABASE_IP': '10.x', 'DATABASE_PORT': '5432', 'DATABASE_NAME': 'cfme'}

#ansible-playbook -i host /usr/share/ansible/openshift-ansible/playbooks/byo/openshift-management/config.yml


Actual results:
TASK [openshift_management : Wait for the app to come up. May take several minutes, 30s check intervals, 10m max] ***********************************************************
FAILED - RETRYING: Wait for the app to come up. May take several minutes, 30s check intervals, 10m max (20 retries left).
...
FAILED - RETRYING: Wait for the app to come up. May take several minutes, 30s check intervals, 10m max (1 retries left).
fatal: [openshift-137.lab.sjc.redhat.com]: FAILED! => {"attempts": 20, "changed": true, "cmd": ["oc", "logs", "manageiq-0", "-n", "openshift-management"], "delta": "0:00:00.353840", "end": "2017-11-07 06:45:26.414185", "failed": true, "rc": 0, "start": "2017-11-07 06:45:26.060345", "stderr": "", "stderr_lines": [], "stdout": "== Checking 172.30.246.100:11211 status ==\n172.30.246.100:11211 - accepting connections\n== Checking 172.30.203.196:5432 status ==\n172.30.203.196:5432 - accepting connections\n== Writing encryption key ==\n== Restoring PV data symlinks ==\n/var/www/miq/vmdb/GUID does not exist on PV, skipping\n{\"@timestamp\":\"2017-11-07T11:45:18.721118 \",\"hostname\":\"manageiq-0\",\"pid\":28,\"tid\":\"2ac9056d713c\",\"level\":\"info\",\"message\":\"MIQ(Vmdb::Loggers.apply_config) Log level for evm.log has been changed to [INFO]\"}\n{\"@timestamp\":\"2017-11-07T11:45:18.721628 
...
 \",\"hostname\":\"manageiq-0\",\"pid\":28,\"tid\":\"2ac9056d713c\",\"level\":\"info\",\"message\":\"MIQ(Vmdb::Initializer.init) - Program Name: bin/rake, PID: 28, ENV['EVMSERVER']: \"}", "Deployment status is new_deployment", "== Starting New Deployment ==", "== Initializing Appliance ==", "/var/www/miq/vmdb /var/www/miq/vmdb"]}
	to retry, use: --limit @/usr/share/ansible/openshift-ansible/playbooks/byo/openshift-management/config.retry


[root@host-192-168-2-148 ~]# oc get pod
NAME                READY     STATUS             RESTARTS   AGE
httpd-1-xt98c       1/1       Running            0          8m
manageiq-0          0/1       CrashLoopBackOff   4          9m
memcached-1-rhfq9   1/1       Running            0          8m



Expected results:
Playbook could give a helpful error message if the postgresql version is incompatible


Additional info:
Detailed miq pod log could be found in the attachment of https://bugzilla.redhat.com/show_bug.cgi?id=1505804

Comment 1 Scott Dodson 2019-01-31 15:56:32 UTC
There appear to be no active cases related to this bug. As such we're closing this bug in order to focus on bugs that are still tied to active customer cases. Please re-open this bug if you feel it was closed in error or a new active case is attached.


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