Bug 1577302 - cloudforms external db template cannot be used with openshift's postgresql pod
Summary: cloudforms external db template cannot be used with openshift's postgresql pod
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: cfme-openshift-app
Version: 5.8.0
Hardware: Unspecified
OS: Unspecified
Target Milestone: GA
: 5.8.4
Assignee: Gregg Tanzillo
QA Contact: Dave Johnson
Red Hat CloudForms Documentation
Depends On:
TreeView+ depends on / blocked
Reported: 2018-05-11 16:20 UTC by Ievgen Zapolskyi
Modified: 2018-08-01 14:15 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Last Closed: 2018-08-01 14:15:50 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
izapolsk: automate_bug+

Attachments (Terms of Use)

Description Ievgen Zapolskyi 2018-05-11 16:20:13 UTC
Description of problem:
When I use postgresql 9.5 pod as external db for testing pod appliance with external db. The database pod gets broken. It doesn't matter whether I use ephemeral or persistent postgresql pod.

There is no such issue in cloudforms 5.9.

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

How reproducible:

Steps to Reproduce:
1. create project and deploy postgresql 9.5 pod. Values can be db=vmdb, user=root, password=smartvm

2. create another project and deploy pod appliances using external db template. 
It should use created above db. NOTE: ip address should be actual pod ip not service ip

3. Take a look at postgresql pod

Actual results:
postgresql pod becomes not ready. created db gets removed and etc.

Expected results:
there shouldn't be any harmful operations over db

Comment 2 Nick Carboni 2018-05-14 13:54:25 UTC
It sounds like this is only an issue in a very specific deployment scenario where a user is hosting their database on a pod which is not our PG pod and configuring the external database template to an internal pod IP. Is that correct?

Is this something we would ever suggest to a customer?

Ievgen, can you confirm that the external database template works properly in 5.8 when configured against a database running on a VM? If this case works I would assume this becomes much lower priority.

Also, can you post logs from the failure (DB and application logs) as well as the specific PG container image you're using for the test?

Comment 3 Ievgen Zapolskyi 2018-05-14 14:07:07 UTC
yes, that's correct. that's why I set initially set medium prio and didn't add blocker tag.

yes when it comes to external database template + vm db, it works right as well.

So, this affects only our test automation for 5.8 and won't probably be noticed by customer.

I'll attach logs in a bit.

Comment 4 Nick Carboni 2018-05-14 14:14:50 UTC
Okay, thanks Ievgen.

Given the content from comment 3 (and that 5.8 in OpenShift is tech-preview) can we tone down the priority and severity and remove the blocker flag?

Comment 5 bascar 2018-05-14 14:23:17 UTC
Agreed, back to medium and removing blocker. If this is something a customer won't hit and only impacts testing, is there any workaround for your testing?

Comment 6 Ievgen Zapolskyi 2018-05-23 07:14:07 UTC
yes, I have workaround for testing. So, it doesn't affect testing much.

Comment 7 Nick Carboni 2018-08-01 14:15:50 UTC
I don't think this is something we're going to take on. There's a workaround for testing and no reason that customers would deploy like this.

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