harikrishna-patnala commented on issue #6013: URL: https://github.com/apache/cloudstack/issues/6013#issuecomment-1046715236
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. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
