Repository navigation
regular user has no access to offferings for creating a new volume #6013
Description
ISSUE TYPE
- Bug Report
COMPONENT NAME
UI, Storage, Orchestration
CLOUDSTACK VERSION
CONFIGURATION
OS / ENVIRONMENT
SUMMARY
STEPS TO REPRODUCE
login as a regular user,
go to storage -> volumes
click "Create Volume"
EXPECTED RESULTS
have a choice of offerings, like admin gets
ACTUAL RESULTS
no offerings, hance no possibility to create volumes
Activity
weizhouapache commentedon Feb 21, 2022
hmm
this looks like a blocker issue
api does not work either
weizhouapache commentedon Feb 21, 2022
@DaanHoogland
this seems to be another regression of #5008
DaanHoogland commentedon Feb 21, 2022
I can confirm it works in 4.16.1 RC
harikrishna-patnala commentedon Feb 21, 2022
DB query on diskoffering view failed.
com.cloud.utils.exception.CloudRuntimeException: Caught: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT disk_offering_view.id, disk_offering_view.uuid, disk_offering_view.name, disk_offering_view.display_text, disk_offering_view.provisioning_type, disk_offering_view.disk_size, disk_offering_view.tags, disk_offering_view.use_local_storage, disk_offering_view.customized, disk_offering_view.customized_iops, disk_offering_view.min_iops, disk_offering_view.max_iops, disk_offering_view.hv_ss_reserve, disk_offering_view.sort_key, disk_offering_view.bytes_read_rate, disk_offering_view.bytes_read_rate_max, disk_offering_view.bytes_read_rate_max_length, disk_offering_view.bytes_write_rate, disk_offering_view.bytes_write_rate_max, disk_offering_view.bytes_write_rate_max_length, disk_offering_view.iops_read_rate, disk_offering_view.iops_read_rate_max, disk_offering_view.iops_read_rate_max_length, disk_offering_view.iops_write_rate, disk_offering_view.iops_write_rate_max, disk_offering_view.iops_write_rate_max_length, disk_offering_view.cache_mode, disk_offering_view.compute_only, disk_offering_view.created, disk_offering_view.removed, disk_offering_view.domain_id, disk_offering_view.domain_uuid, disk_offering_view.domain_name, disk_offering_view.domain_path, disk_offering_view.zone_id, disk_offering_view.zone_uuid, disk_offering_view.zone_name, disk_offering_view.display_offering, disk_offering_view.state, disk_offering_view.vsphere_storage_policy, disk_offering_view.disk_size_strictness FROM disk_offering_view WHERE disk_offering_view.compute_only = 0 AND AND ( FIND_IN_SET(** NOT SPECIFIED **, disk_offering_view.zone_id ) OR disk_offering_view.zone_id IS NULL ) AND (disk_offering_view.domain_id IS NULL ) AND disk_offering_view.removed IS NULL ORDER BY disk_offering_view.sort_key ASC , disk_offering_view.id ASC LIMIT 0, 500
Looking for the root cause.
harikrishna-patnala commentedon Feb 21, 2022
Created a PR to fix the issue #6015, please review