Description of problem: ----------------------- I ran into this issue while verifying https://bugzilla.redhat.com/show_bug.cgi?id=1656169 I created a service bundle (bz-bundle) of 2 service items(vsphere service item,vsphere65-service-bundle that creates a VM and an Ansible job, nan-ansible-job2-bundle ) I then provisioned that service bundle.When I attempted to retire the service bundle, it failed with this error message: [----] E, [2018-12-06T18:05:47.858091 #23693:5f89da0] ERROR -- : <AEMethod update_service_retirement_status> Service Retirement Error: Server [EVM] Service [bz-bundle] Step [CheckServiceRetired] Status [Error Checking Service retirement] I'd like to add that the VM that got created through the vsphere service item did get retired.(See attached screen shot). However, the result of the following query doesn't reflect that and the DB doesn't correctly show the retirement status of child services. I'm reporting this BZ so that this issue(DB should correctly show the retirement status of child services) is fixed . vmdb_production=# select id, name, retirement_state, ancestry from services order by id; id | name | retirement_state | ancestry ----+--------------------------+------------------+---------- 1 | nan-job1 | retired | 2 | bz-bundle | error | 3 | vsphere65-service-bundle | | 2 4 | nan-ansible-job2-bundle | | 2 Version-Release number of selected component (if applicable): ------------------------------------------------------------ 5.9.6.5 How reproducible: ---------------- Always Steps to Reproduce: ------------------- 1. 2. 3. Actual results: --------------- DB doesn't correctly show the retirement status of child services after a parent service is retired. Expected results: ---------------- DB should correctly show the retirement status of child services after a parent service is retired. Additional info: ----------------
Hi Nandini, Can you provide a reproducer environment? Thanks, Tina
Hi Nandini, Can you reproduce the issue? Thanks, Tina
Hi John, We're waiting on QA to reproduce this issue. Thanks, Tina
I just reproduced the issue again on the same appliance from comment #6. vmdb_production=# select id, name, retirement_state, ancestry from services order by id; id | name | retirement_state | ancestry ----+--------------+------------------+---------- 1 | bundle | retiring | 2 | bz-catalog-1 | | 1 3 | bz-catalog-2 | | 1 I created a service bundle (bz-bundle) of 2 vsphere service items(bz-catalog-1 and bz-catalog-2 , each of these services creates a VM ). I then attempted to retire the service bundle.The UI shows that the 2 VMs that were created from the child services have been retired. At the moment, the DB query shows that the 'bundle' service is retiring. The retirement state will eventually change from 'retiring' to 'error'. Expected Results: 1)The 'retirement_state' field returned by the above query should show 'retired' for the parent service . 2)The 'retirement_state' field returned by the above query should show 'retired' for the child services as well .
Hi Nandini, Thanks for setting up the reproducer environment. The fix for this issue was committed on December 18th. (https://github.com/ManageIQ/manageiq/commit/dd72793edf2f7301a9db8559250f19eec35f99dc) The reproducer environment was built on 12/17/18.(5.9.7.0.20181217174909_1f8a1d7) Can you retest on a later 5.9.7 appliance? Thanks, Tina
I tested on version 5.9.7.2.20190109154935_c0d03d6 and this worked. Service bundle_2vmwares retired successfully and the 2 vm's attached were retired also. Billy
Reproducer: 10.16.5.104
I re-tested on a 5.9.7.2 appliance and the fix[0] resolved this issue. vmdb_production=# select id, name, retirement_state, ancestry from services order by id; id | name | retirement_state | ancestry ----+------------+------------------+---------- 3 | cat-bundle | retired | 4 | cat-item | retired | 3 5 | cat-item2 | retired | 3 [0]https://github.com/ManageIQ/manageiq/commit/dd72793edf2f7301a9db8559250f19eec35f99dc) John/Satoe, Could this BZ be moved to POST->ON_QA so that I can mark this BZ as VERIFIED.
Verified in 5.9.7.2