Not able to delete service offering from UI or API

[yadvr]

I was not able to delete a service offering, upon calling the deleteServiceOffering API, it would transition the offering to Inactive state -> same as with enable/disable UI button. I don't know if this has been like this historically or there was some behaviour change in recent releases. I could mark them as removed in the DB, then they won't show up in the offering UI.

ISSUE TYPE

• Bug Report

COMPONENT NAME

API, Service offerings

CLOUDSTACK VERSION

4.19.1

CONFIGURATION

OS / ENVIRONMENT

SUMMARY

STEPS TO REPRODUCE

EXPECTED RESULTS

ACTUAL RESULTS

[weizhouapache]

this looks related to #8821

cc @vishesh92

[harikrishna-patnala]

@rohityadavcloud I don't find any API which marks the service offering's removed column. deleteServiceOffering API and updateServiceOffering (using state parameter) API are updating the column "State" with Active and Inactive values.

This was the behaviour even before also.

With the PR #8821 we have now new filter for Active and Inactive offerings which can also lists all types of offerings

Created two offerings and then deleted both the offerings from UI. Following are the screenshots for Active and Inactive offerings

Active offerings

Inactive offerings

After enabled one of the offerings, it came back to Active list

Please check and let me know if anything else I'm missing here, otherwise we can close the ticket.

[DaanHoogland]

@rohityadavcloud can you expand on this? #8821 claims to fix this in 4.19.1, but you reported this in this version.

[li-liwen]

Hi, I am using CloudStack 4.20. I encountered the same issue. According to the author of #8821, the delete command in the API will no longer actually delete the offering. Instead, it will set the state to inactive. (#8817 (comment))

So is there a way to actually delete the service offering? (I guess making SQL operations would work, but I don't think it's appropriate for administrators to touch the SQL databse directly.)

[DaanHoogland]

@li-liwen If I read the changes in #8821 correctly it only changes the behaviour of the update<Disk/Service>Offering commands. So you should still be able to call the deleteServiceOffering API, for instance using cmk.
cc @vishesh92 ??