We recently upgrade or Cloudstack from 4.1.0 to 4.2.1. hypervisor not
upgraded and using xenserver 6.0.2
Since then, we are unable to storage xenmotion Instance from a Primary
Storage to another. The pool is using local and shared storage and all kind
of storage xenmotion fail.
moving Instances end up with following error message in cloudstack webui:
Failed to migration: com.cloud.exception.StorageUnavailableException:
Resource [StoragePool:233] is unreachable: migrate volume failed:
com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
com.mysql.jdbc.JDBC4PreparedStatement@308d011c: SELECT volume_store_ref.id,
volume_store_ref.store_id, volume_store_ref.volume_id,
volume_store_ref.zone_id, volume_store_ref.created,
volume_store_ref.last_updated, volume_store_ref.download_pct,
volume_store_ref.size, volume_store_ref.physical_size,
volume_store_ref.download_state, volume_store_ref.checksum,
volume_store_ref.local_path, volume_store_ref.error_str,
volume_store_ref.job_id, volume_store_ref.install_path,
volume_store_ref.url, volume_store_ref.download_url,
volume_store_ref.download_url_created, volume_store_ref.destroyed,
volume_store_ref.update_count, volume_store_ref.updated,
volume_store_ref.state, volume_store_ref.ref_cnt FROM volume_store_ref
WHERE volume_store_ref.store_id = 60 AND volume_store_ref.volume_id = 1664
AND volume_store_ref.destroyed = 0 ORDER BY RAND() LIMIT 1
if I look in the database the Query provide the following output:
mysql> SELECT volume_store_ref.id, volume_store_ref.store_id,
volume_store_ref.volume_id, volume_store_ref.zone_id,
volume_store_ref.created, volume_store_ref.last_updated,
volume_store_ref.download_pct, volume_store_ref.size,
volume_store_ref.physical_size, volume_store_ref.download_state,
volume_store_ref.checksum, volume_store_ref.local_path,
volume_store_ref.error_str, volume_store_ref.job_id,
volume_store_ref.install_path, volume_store_ref.url,
volume_store_ref.download_url, volume_store_ref.download_url_created,
volume_store_ref.destroyed, volume_store_ref.update_count,
volume_store_ref.updated, volume_store_ref.state, volume_store_ref.ref_cnt
FROM volume_store_ref WHERE volume_store_ref.store_id = 60 AND
volume_store_ref.volume_id = 1664 AND volume_store_ref.destroyed = 0 ORDER
BY RAND() LIMIT 1 ;
+----+----------+-----------+---------+---------------------+--------------+--------------+------+---------------+----------------+----------+------------+-----------+--------+-----------------+------+--------------+----------------------+-----------+--------------+---------------------+----------+---------+
| id | store_id | volume_id | zone_id | created | last_updated
| download_pct | size | physical_size | download_state | checksum |
local_path | error_str | job_id | install_path | url | download_url |
download_url_created | destroyed | update_count | updated |
state | ref_cnt |
+----+----------+-----------+---------+---------------------+--------------+--------------+------+---------------+----------------+----------+------------+-----------+--------+-----------------+------+--------------+----------------------+-----------+--------------+---------------------+----------+---------+
| 23 | 60 | 1664 | 0 | 2014-01-21 18:08:25 | NULL
| 0 | 0 | 0 | NULL | NULL | NULL
| NULL | NULL | volumes/11/1664 | NULL | NULL | NULL
| 0 | 1 | 2014-01-21 18:08:25 | Creating |
0 |
+----+----------+-----------+---------+---------------------+--------------+--------------+------+---------------+----------------+----------+------------+-----------+--------+-----------------+------+--------------+----------------------+-----------+--------------+---------------------+----------+---------+
1 row in set (0.00 sec)
Is this a bug from 4.2.1 ?
Pierre-Luc Dion
Architecte de Solution Cloud | Cloud Solutions Architect
514-447-3456, 1101
- - -
*CloudOps*420 rue Guy
Montréal QC H3J 1S6
www.cloudops.com
@CloudOps_
