sureshanaparti commented on issue #11828:
URL: https://github.com/apache/cloudstack/issues/11828#issuecomment-3396481650

   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);`


-- 
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]

Reply via email to