GitHub user sureshanaparti added a comment to the discussion: Cloudstack 
assigns Volume to wrong host

Hi @HeinzM There is no connection with the host_ip entries for the PowerFlex 
volumes. Are the PowerFlex storage pools (i.e. primary storages with cluster 
scope) added in each CloudStack cluster belongs to same or different PowerFlex 
storage cluster?

_pool_id_ column in cloud.volumes table maps to the current storage pool of the 
volume, and storage host details are in cloud.storage_pool table. Can you query 
with the following sql:

`SELECT vol.name, vol.pool_id, vol.last_pool_id, vol.instance_id, 
vol.device_id, vol.size, vol.path, pool.name AS pool_name, pool.cluster_id AS 
pool_cluster_id, pool.host_address AS pool_host_address, pool.path AS pool_path 
FROM cloud.volumes vol JOIN cloud.storage_pool pool ON vol.pool_id = pool.id 
WHERE vol.instance_id IN (329, 330, 331);`

GitHub link: 
https://github.com/apache/cloudstack/discussions/11837#discussioncomment-14674969

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to