GitHub user TadiosAbebe added a comment to the discussion: An error getting clusters resources information on GUI ACS 4.22
I just noticed the same issue on my test environment that i have upgraded from 4.20.1 -> 4.22. The same exception is raised whenever i go to the resource section of a zone, pod and cluster. In addition, the home dashboard resource section also doesn't show resource count and utilization. <img width="1208" height="1004" alt="image" src="https://github.com/user-attachments/assets/5061fcfe-eada-49ed-98af-d6d08cc87857"; /> Executing the same query on mysql shell just returns empty set ```sql MariaDB [cloud]> SELECT -> pci, -> type, -> SUM(vmcount) AS total_vm_count -> FROM ( -> SELECT -> MAX(IF(offering.name = 'pciDevice', offering.value, '')) AS pci, -> MAX(IF(offering.name = 'vgpuType', offering.value, '')) AS type, -> COUNT(DISTINCT vm.id) AS vmcount -> FROM service_offering_details offering -> INNER JOIN vm_instance vm -> ON offering.service_offering_id = vm.service_offering_id -> INNER JOIN cloud.host host -> ON vm.host_id = host.id -> WHERE -> vm.state = 'Running' -> AND host.data_center_id = 1 -> GROUP BY vm.service_offering_id -> ) results -> GROUP BY pci, type; Empty set (0.020 sec) ``` GitHub link: https://github.com/apache/cloudstack/discussions/12498#discussioncomment-15585525 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
