inmanturbo opened a new issue #4509:
URL: https://github.com/apache/cloudstack/issues/4509
how do get a management install up and running. Docs lead to dependency
hell. I would love to update them, but I would need to know how to install
successfully first. Can someone please tell me how to install, any version on
any distro? One which has a clear and clean dependency path.
So far I've tried `4.14` and `4.11` both on centos8 and centos7 both with a
few different versions of mariadb, mysql and java. Can't seem to get he right
combination same result every time.
> [root@united-panda ~]# grep -i -E 'error|exception'
/var/log/cloudstack/management/management-server.log
```
2020-12-01 00:21:44,355 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`s3` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT
COMMENT 'id', `uuid` varchar(40), `access_key` varchar(20) NOT NULL COMMENT
' The S3 access key', `secret_key` varchar(40) NOT NULL COMMENT ' The S3
secret key', `end_point` varchar(1024) COMMENT ' The S3 host', `bucket`
varchar(63) NOT NULL COMMENT ' The S3 host', `https` tinyint unsigned DEFAULT
NULL COMMENT ' Flag indicating whether or not to connect over HTTPS',
`connection_timeout` integer COMMENT ' The amount of time to wait (in
milliseconds) when initially establishing a connection before giving up and
timing out.', `max_error_retry` integer COMMENT ' The maximum number of
retry attempts for failed retryable requests (ex: 5xx error responses from
services).', `socket_timeout` integer COMMENT ' The amount of time to wait
(in milliseconds) for data to be transfered over an established, open
connection before th
e connection times out and is closed.', `created` datetime COMMENT 'date the
s3 first signed on', PRIMARY KEY (`id`), CONSTRAINT `uc_s3__uuid` UNIQUE
(`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-12-01 00:21:44,658 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS select volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.size, volumes.created,
volumes.state, volumes.attached, volumes.removed,
volumes.pod_id, account.id account_id, account.uuid
account_uuid, account.account_name account_name, account.type
account_type, domain.id domain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,
projects.id project_id, projects.uuid project_uuid,
projects.name project_name, data_center.id data_center_id,
data_center.uuid data_center_uuid, data_center.name data_center_name,
vm_instance.id vm_id, vm_instance.uuid vm_uuid,
vm_instance.name vm_name,
vm_instance.state vm_state, vm_instance.vm_type,
user_vm.display_name vm_display_name, volume_host_ref.size
volume_host_size, volume_host_ref.created volume_host_created,
volume_host_ref.format, volume_host_ref.download_pct,
volume_host_ref.download_state, volume_host_ref.error_str,
disk_offering.id disk_offering_id, disk_offering.uuid
disk_offering_uuid, disk_offering.name disk_offering_name,
disk_offering.display_text disk_offering_display_text,
disk_offering.use_local_storage, disk_offering.system_use,
storage_pool.id pool_id, storage_pool.uuid pool_uuid,
storage_pool.name pool_name, cluster.hypervisor_type,
vm_template.id template_id, vm_template.uuid template_uuid,
vm_template.extractable, vm_template.type template_type,
resource_tags.id tag_id, resource_tags.uuid tag_uuid, resourc
e_tags.key tag_key, resource_tags.value tag_value,
resource_tags.domain_id tag_domain_id, resource_tags.account_id
tag_account_id, resource_tags.resource_id tag_resource_id,
resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`volumes` inner join
`cloud`.`account` ON volumes.account_id = account.id inner join
`cloud`.`domain` ON volumes.domain_id = domain.id left join
`cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`data_center` ON volumes.data_center_id =
data_center.id left join `cloud`.`vm_instance` ON
volumes.instance_id = vm_instance.id
left join `cloud`.`user_vm` ON user_vm.id = vm_instance.id
left join `cloud`.`volume_host_ref` ON volumes.id =
volume_host_ref.volume_id and volumes.data_center_id =
volume_host_ref.zone_id left join `cloud`.`disk_offering`
ON volumes.disk_offering_id = disk_offering.id left join
`cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left
join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id
left join `cloud`.`vm_template` ON volumes.template_id =
vm_template.id left join `cloud`.`resource_tags` ON
resource_tags.resource_id = volumes.id and
resource_tags.resource_type = 'Volume' left join
`cloud`.`async_job` ON async_job.instance_id = volumes.id and
async_job.instance_type = 'Volume' and async_job.job_status = 0
2020-12-01 00:21:44,808 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`object_datastore_ref` ( `id` bigint unsigned NOT NULL
auto_increment, `datastore_uuid` varchar(255) NOT NULL, `datastore_role`
varchar(255) NOT NULL, `object_uuid` varchar(255) NOT NULL, `object_type`
varchar(255) NOT NULL, `created` DATETIME NOT NULL, `last_updated`
DATETIME, `job_id` varchar(255), `download_pct` int(10) unsigned,
`download_state` varchar(255), `url` varchar(255), `format` varchar(255),
`checksum` varchar(255), `error_str` varchar(255), `local_path`
varchar(255), `install_path` varchar(255), `size` bigint unsigned COMMENT
'the size of the template on the pool', `state` varchar(255) NOT NULL,
`update_count` bigint unsigned NOT NULL, `updated` DATETIME, PRIMARY KEY
(`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2020-12-01 00:21:44,825 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`template_store_ref` ( `id` bigint unsigned NOT NULL
auto_increment, `store_id` bigint unsigned, `template_id` bigint unsigned
NOT NULL, `created` DATETIME NOT NULL, `last_updated` DATETIME, `job_id`
varchar(255), `download_pct` int(10) unsigned, `size` bigint unsigned,
`store_role` varchar(255), `physical_size` bigint unsigned DEFAULT 0,
`download_state` varchar(255), `error_str` varchar(255), `local_path`
varchar(255), `install_path` varchar(255), `url` varchar(255), `state`
varchar(255) NOT NULL, `destroyed` tinyint(1) COMMENT 'indicates whether the
template_store entry was destroyed by the user or not', `is_copy` tinyint(1)
NOT NULL DEFAULT 0 COMMENT 'indicates whether this was copied ',
`update_count` bigint unsigned, `ref_cnt` bigint unsigned DEFAULT 0,
`updated` datetime, PRIMARY KEY (`id`), INDEX
`i_template_store_ref__store_id`(
`store_id`), CONSTRAINT `fk_template_store_ref__template_id` FOREIGN KEY
`fk_template_store_ref__template_id` (`template_id`) REFERENCES `vm_template`
(`id`), INDEX `i_template_store_ref__template_id`(`template_id`) )
ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2020-12-01 00:21:44,845 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`volume_store_ref` ( `id` bigint unsigned NOT NULL
auto_increment, `store_id` bigint unsigned NOT NULL, `volume_id` bigint
unsigned NOT NULL, `zone_id` bigint unsigned NOT NULL, `created` DATETIME
NOT NULL, `last_updated` DATETIME, `job_id` varchar(255), `download_pct`
int(10) unsigned, `size` bigint unsigned, `physical_size` bigint unsigned
DEFAULT 0, `download_state` varchar(255), `checksum` varchar(255) COMMENT
'checksum for the data disk', `error_str` varchar(255), `local_path`
varchar(255), `install_path` varchar(255), `url` varchar(255),
`download_url` varchar(255), `state` varchar(255) NOT NULL, `destroyed`
tinyint(1) COMMENT 'indicates whether the volume_host entry was destroyed by
the user or not', `update_count` bigint unsigned, `ref_cnt` bigint
unsigned, `updated` datetime, PRIMARY KEY (`id`), CONSTRAINT
`fk_volume_store_r
ef__store_id` FOREIGN KEY `fk_volume_store_ref__store_id` (`store_id`)
REFERENCES `image_store` (`id`) ON DELETE CASCADE, INDEX
`i_volume_store_ref__store_id`(`store_id`), CONSTRAINT
`fk_volume_store_ref__volume_id` FOREIGN KEY `fk_volume_store_ref__volume_id`
(`volume_id`) REFERENCES `volumes` (`id`), INDEX
`i_volume_store_ref__volume_id`(`volume_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1
DEFAULT CHARSET=utf8
2020-12-01 00:21:45,625 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS select volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.size, volumes.min_iops,
volumes.max_iops, volumes.created, volumes.state,
volumes.attached, volumes.removed, volumes.pod_id,
volumes.display_volume, volumes.format, account.id account_id,
account.uuid account_uuid, account.account_name account_name,
account.type account_type, domain.id domain_id,
domain.uuid domain_uuid, domain.name domain_name, domain.path
domain_path, projects.id project_id, projects.uuid
project_uuid, projects.name project_name, data_center.id
data_center_id, data_center.uuid data_center_uuid,
data_center.name data_center_name, data_
center.networktype data_center_type, vm_instance.id vm_id,
vm_instance.uuid vm_uuid, vm_instance.name vm_name,
vm_instance.state vm_state, vm_instance.vm_type,
user_vm.display_name vm_display_name, volume_store_ref.size
volume_store_size, volume_store_ref.download_pct,
volume_store_ref.download_state, volume_store_ref.error_str,
volume_store_ref.created created_on_store, disk_offering.id
disk_offering_id, disk_offering.uuid disk_offering_uuid,
disk_offering.name disk_offering_name, disk_offering.display_text
disk_offering_display_text, disk_offering.use_local_storage,
disk_offering.system_use, disk_offering.bytes_read_rate,
disk_offering.bytes_write_rate, disk_offering.iops_read_rate,
disk_offering.iops_write_rate, storage_pool.id pool_id,
storage_pool.uuid pool_uuid, storage_pool.name pool_nam
e, cluster.hypervisor_type, vm_template.id template_id,
vm_template.uuid template_uuid, vm_template.extractable,
vm_template.type template_type, resource_tags.id tag_id,
resource_tags.uuid tag_uuid, resource_tags.key tag_key,
resource_tags.value tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id,
resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid
tag_resource_uuid, resource_tags.resource_type tag_resource_type,
resource_tags.customer tag_customer, async_job.id job_id,
async_job.uuid job_uuid, async_job.job_status job_status,
async_job.account_id job_account_id from `cloud`.`volumes`
inner join `cloud`.`account` ON volumes.account_id = account.id
inner join `cloud`.`domain` ON volumes.domain_id = domain.id
left jo
in `cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`data_center` ON volumes.data_center_id =
data_center.id left join `cloud`.`vm_instance` ON
volumes.instance_id = vm_instance.id left join
`cloud`.`user_vm` ON user_vm.id = vm_instance.id left join
`cloud`.`volume_store_ref` ON volumes.id = volume_store_ref.volume_id
left join `cloud`.`disk_offering` ON volumes.disk_offering_id =
disk_offering.id left join `cloud`.`storage_pool` ON
volumes.pool_id = storage_pool.id left join
`cloud`.`cluster` ON storage_pool.cluster_id = cluster.id left join
`cloud`.`vm_template` ON volumes.template_id = vm_template.id OR
volumes.iso_id = vm_template.id left join
`cloud`.`resource_tags` ON resource_tags.resource_id = volumes.id
and resource_tags.resource_type = 'Volume'
left join `cloud`.`async_job` ON async_job.instance_id =
volumes.id and async_job.instance_type = 'Volume' and
async_job.job_status = 0
2020-12-01 00:21:45,676 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`template_view` AS select vm_template.id,
vm_template.uuid, vm_template.unique_name, vm_template.name,
vm_template.public, vm_template.featured,
vm_template.type, vm_template.hvm, vm_template.bits,
vm_template.url, vm_template.format, vm_template.created,
vm_template.checksum, vm_template.display_text,
vm_template.enable_password, vm_template.dynamically_scalable,
vm_template.guest_os_id, guest_os.uuid guest_os_uuid,
guest_os.display_name guest_os_name, vm_template.bootable,
vm_template.prepopulate, vm_template.cross_zones,
vm_template.hypervisor_type, vm_template.extractable,
vm_template.template_tag, vm_template.sort_key,
vm_template.removed, vm_template.enable_
sshkey, source_template.id source_template_id,
source_template.uuid source_template_uuid, account.id account_id,
account.uuid account_uuid, account.account_name account_name,
account.type account_type, domain.id domain_id, domain.uuid
domain_uuid, domain.name domain_name, domain.path domain_path,
projects.id project_id, projects.uuid project_uuid,
projects.name project_name, data_center.id data_center_id,
data_center.uuid data_center_uuid, data_center.name
data_center_name, launch_permission.account_id lp_account_id,
template_store_ref.store_id, image_store.scope as store_scope,
template_store_ref.state, template_store_ref.download_state,
template_store_ref.download_pct, template_store_ref.error_str,
template_store_ref.size, template_store_ref.destroyed,
template_store_ref.cre
ated created_on_store, vm_template_details.name detail_name,
vm_template_details.value detail_value, resource_tags.id tag_id,
resource_tags.uuid tag_uuid, resource_tags.key tag_key,
resource_tags.value tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id,
resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid
tag_resource_uuid, resource_tags.resource_type tag_resource_type,
resource_tags.customer tag_customer, CONCAT(vm_template.id, '_',
IFNULL(data_center.id, 0)) as temp_zone_pair from
`cloud`.`vm_template` inner join `cloud`.`guest_os` ON
guest_os.id = vm_template.guest_os_id inner join
`cloud`.`account` ON account.id = vm_template.account_id inner join
`cloud`.`domain` ON domain.id = account.domain_id left join
`cloud`.`projects` ON
projects.project_account_id = account.id left join
`cloud`.`vm_template_details` ON vm_template_details.template_id =
vm_template.id left join `cloud`.`vm_template`
source_template ON source_template.id = vm_template.source_template_id
left join `cloud`.`template_store_ref` ON
template_store_ref.template_id = vm_template.id and
template_store_ref.store_role = 'Image' left join
`cloud`.`image_store` ON image_store.removed is NULL AND
template_store_ref.store_id is not NULL AND image_store.id =
template_store_ref.store_id left join
`cloud`.`template_zone_ref` ON template_zone_ref.template_id = vm_template.id
AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null
left join `cloud`.`data_center` ON
(image_store.data_center_id = data_center.id OR template_zone_ref.zone_id =
data_center.id) left join `cloud`.`
launch_permission` ON launch_permission.template_id = vm_template.id
left join `cloud`.`resource_tags` ON resource_tags.resource_id =
vm_template.id and (resource_tags.resource_type = 'Template' or
resource_tags.resource_type='ISO')
2020-12-01 00:21:45,942 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key last_sent on table alert
exception: Can't DROP 'last_sent'; check that column/key exists
2020-12-01 00:21:45,942 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key i_alert__last_sent on
table alert exception: Can't DROP 'i_alert__last_sent'; check that column/key
exists
2020-12-01 00:21:45,952 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_nsp_id on table baremetal_dhcp_devices exception:
Error on rename of './cloud/baremetal_dhcp_devices' to './cloud/#sql2-37d1-16'
(errno: 152)
2020-12-01 00:21:45,957 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_host_id on table baremetal_dhcp_devices exception:
Error on rename of './cloud/baremetal_dhcp_devices' to './cloud/#sql2-37d1-16'
(errno: 152)
2020-12-01 00:21:45,962 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_pod_id on table baremetal_dhcp_devices exception:
Error on rename of './cloud/baremetal_dhcp_devices' to './cloud/#sql2-37d1-16'
(errno: 152)
2020-12-01 00:21:45,967 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_physical_network_id on table baremetal_dhcp_devices
exception: Error on rename of './cloud/baremetal_dhcp_devices' to
'./cloud/#sql2-37d1-16' (errno: 152)
2020-12-01 00:21:45,972 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_nsp_id on table baremetal_pxe_devices exception: Error
on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-37d1-16' (errno:
152)
2020-12-01 00:21:45,978 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_host_id on table baremetal_pxe_devices exception:
Error on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-37d1-16'
(errno: 152)
2020-12-01 00:21:45,983 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_pod_id on table baremetal_pxe_devices exception: Error
on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-37d1-16' (errno:
152)
2020-12-01 00:21:45,989 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_physical_network_id on table baremetal_pxe_devices
exception: Error on rename of './cloud/baremetal_pxe_devices' to
'./cloud/#sql2-37d1-16' (errno: 152)
2020-12-01 00:21:45,995 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_pxe_devices_nsp_id on table baremetal_pxe_devices exception: Error
on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-37d1-16' (errno:
152)
2020-12-01 00:21:46,002 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_pxe_devices_host_id on table baremetal_pxe_devices exception: Error
on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-37d1-16' (errno:
152)
2020-12-01 00:21:46,009 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_external_pxe_devices_physical_network_id on table baremetal_pxe_devices
exception: Error on rename of './cloud/baremetal_pxe_devices' to
'./cloud/#sql2-37d1-16' (errno: 152)
2020-12-01 00:21:46,154 ERROR [c.c.u.d.Upgrade410to420] (main:null) (logid:)
migrateDatafromIsoIdInVolumesTable:Exception:Unknown column 'iso_id1' in 'field
list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
'iso_id1' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
2020-12-01 00:21:46,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`template_view` AS select vm_template.id,
vm_template.uuid, vm_template.unique_name, vm_template.name,
vm_template.public, vm_template.featured,
vm_template.type, vm_template.hvm, vm_template.bits,
vm_template.url, vm_template.format, vm_template.created,
vm_template.checksum, vm_template.display_text,
vm_template.enable_password, vm_template.dynamically_scalable,
vm_template.state template_state, vm_template.guest_os_id,
guest_os.uuid guest_os_uuid, guest_os.display_name guest_os_name,
vm_template.bootable, vm_template.prepopulate,
vm_template.cross_zones, vm_template.hypervisor_type,
vm_template.extractable, vm_template.template_tag,
vm_template.sort_key, vm_temp
late.removed, vm_template.enable_sshkey, source_template.id
source_template_id, source_template.uuid source_template_uuid,
account.id account_id, account.uuid account_uuid,
account.account_name account_name, account.type account_type,
domain.id domain_id, domain.uuid domain_uuid, domain.name
domain_name, domain.path domain_path, projects.id project_id,
projects.uuid project_uuid, projects.name project_name,
data_center.id data_center_id, data_center.uuid data_center_uuid,
data_center.name data_center_name, launch_permission.account_id
lp_account_id, template_store_ref.store_id, image_store.scope
as store_scope, template_store_ref.state,
template_store_ref.download_state, template_store_ref.download_pct,
template_store_ref.error_str, template_store_ref.size,
template_store_ref.de
stroyed, template_store_ref.created created_on_store,
vm_template_details.name detail_name, vm_template_details.value
detail_value, resource_tags.id tag_id, resource_tags.uuid
tag_uuid, resource_tags.key tag_key, resource_tags.value
tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id, resource_tags.resource_id
tag_resource_id, resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, CONCAT(vm_template.id, '_', IFNULL(data_center.id, 0)) as
temp_zone_pair from `cloud`.`vm_template` inner join
`cloud`.`guest_os` ON guest_os.id = vm_template.guest_os_id
inner join `cloud`.`account` ON account.id = vm_template.account_id
inner join `cloud`.`domain` ON domain.id = account.domain_id
lef
t join `cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`vm_template_details` ON
vm_template_details.template_id = vm_template.id left join
`cloud`.`vm_template` source_template ON source_template.id =
vm_template.source_template_id left join
`cloud`.`template_store_ref` ON template_store_ref.template_id = vm_template.id
and template_store_ref.store_role = 'Image' and template_store_ref.destroyed=0
left join `cloud`.`image_store` ON image_store.removed is
NULL AND template_store_ref.store_id is not NULL AND image_store.id =
template_store_ref.store_id left join
`cloud`.`template_zone_ref` ON template_zone_ref.template_id = vm_template.id
AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null
left join `cloud`.`data_center` ON
(image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = da
ta_center.id) left join `cloud`.`launch_permission` ON
launch_permission.template_id = vm_template.id left join
`cloud`.`resource_tags` ON resource_tags.resource_id = vm_template.id
and (resource_tags.resource_type = 'Template' or
resource_tags.resource_type='ISO')
2020-12-01 00:21:46,708 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS select volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.size, volumes.min_iops,
volumes.max_iops, volumes.created, volumes.state,
volumes.attached, volumes.removed, volumes.pod_id,
volumes.display_volume, volumes.format, volumes.path,
account.id account_id, account.uuid account_uuid,
account.account_name account_name, account.type account_type,
domain.id domain_id, domain.uuid domain_uuid, domain.name
domain_name, domain.path domain_path, projects.id project_id,
projects.uuid project_uuid, projects.name project_name,
data_center.id data_center_id, data_center.uuid data_center_uuid,
data_center.name data_cent
er_name, data_center.networktype data_center_type,
vm_instance.id vm_id, vm_instance.uuid vm_uuid,
vm_instance.name vm_name, vm_instance.state vm_state,
vm_instance.vm_type, user_vm.display_name vm_display_name,
volume_store_ref.size volume_store_size, volume_store_ref.download_pct,
volume_store_ref.download_state, volume_store_ref.error_str,
volume_store_ref.created created_on_store, disk_offering.id
disk_offering_id, disk_offering.uuid disk_offering_uuid,
disk_offering.name disk_offering_name, disk_offering.display_text
disk_offering_display_text, disk_offering.use_local_storage,
disk_offering.system_use, disk_offering.bytes_read_rate,
disk_offering.bytes_write_rate, disk_offering.iops_read_rate,
disk_offering.iops_write_rate, storage_pool.id pool_id,
storage_pool.uuid pool_uuid, storage_poo
l.name pool_name, cluster.hypervisor_type, vm_template.id
template_id, vm_template.uuid template_uuid,
vm_template.extractable, vm_template.type template_type,
resource_tags.id tag_id, resource_tags.uuid tag_uuid,
resource_tags.key tag_key, resource_tags.value tag_value,
resource_tags.domain_id tag_domain_id, resource_tags.account_id
tag_account_id, resource_tags.resource_id tag_resource_id,
resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`volumes` inner join
`cloud`.`account` ON volumes.account_id = account.id inner join
`cloud`.`domain` ON volumes.domain_id = domain.id
left join `cloud`.`projects` ON projects.project_account_id =
account.id left join `cloud`.`data_center` ON
volumes.data_center_id = data_center.id left join
`cloud`.`vm_instance` ON volumes.instance_id = vm_instance.id left
join `cloud`.`user_vm` ON user_vm.id = vm_instance.id left
join `cloud`.`volume_store_ref` ON volumes.id =
volume_store_ref.volume_id left join
`cloud`.`disk_offering` ON volumes.disk_offering_id = disk_offering.id
left join `cloud`.`storage_pool` ON volumes.pool_id =
storage_pool.id left join `cloud`.`cluster` ON
storage_pool.cluster_id = cluster.id left join
`cloud`.`vm_template` ON volumes.template_id = vm_template.id OR volumes.iso_id
= vm_template.id left join `cloud`.`resource_tags` ON
resource_tags.resource_id = volumes.id and resource_tags.resource_t
ype = 'Volume' left join `cloud`.`async_job` ON
async_job.instance_id = volumes.id and async_job.instance_type =
'Volume' and async_job.job_status = 0
2020-12-01 00:21:47,008 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS select volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.size, volumes.min_iops,
volumes.max_iops, volumes.created, volumes.state,
volumes.attached, volumes.removed, volumes.pod_id,
volumes.display_volume, volumes.format, volumes.path,
volumes.chain_info, account.id account_id, account.uuid
account_uuid, account.account_name account_name, account.type
account_type, domain.id domain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,
projects.id project_id, projects.uuid project_uuid,
projects.name project_name, data_center.id data_center_id,
data_center.uuid data_center_uuid
, data_center.name data_center_name, data_center.networktype
data_center_type, vm_instance.id vm_id, vm_instance.uuid
vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state,
vm_instance.vm_type, user_vm.display_name vm_display_name,
volume_store_ref.size volume_store_size,
volume_store_ref.download_pct, volume_store_ref.download_state,
volume_store_ref.error_str, volume_store_ref.created created_on_store,
disk_offering.id disk_offering_id, disk_offering.uuid
disk_offering_uuid, disk_offering.name disk_offering_name,
disk_offering.display_text disk_offering_display_text,
disk_offering.use_local_storage, disk_offering.system_use,
disk_offering.bytes_read_rate, disk_offering.bytes_write_rate,
disk_offering.iops_read_rate, disk_offering.iops_write_rate,
disk_offering.cache_mode, storage
_pool.id pool_id, storage_pool.uuid pool_uuid,
storage_pool.name pool_name, cluster.hypervisor_type,
vm_template.id template_id, vm_template.uuid template_uuid,
vm_template.extractable, vm_template.type template_type,
vm_template.name template_name, vm_template.display_text
template_display_text, iso.id iso_id, iso.uuid iso_uuid,
iso.name iso_name, iso.display_text iso_display_text,
resource_tags.id tag_id, resource_tags.uuid tag_uuid,
resource_tags.key tag_key, resource_tags.value tag_value,
resource_tags.domain_id tag_domain_id, resource_tags.account_id
tag_account_id, resource_tags.resource_id tag_resource_id,
resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`volumes` inner join
`cloud`.`account` ON volumes.account_id = account.id inner join
`cloud`.`domain` ON volumes.domain_id = domain.id left join
`cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`data_center` ON volumes.data_center_id =
data_center.id left join `cloud`.`vm_instance` ON
volumes.instance_id = vm_instance.id left join
`cloud`.`user_vm` ON user_vm.id = vm_instance.id left join
`cloud`.`volume_store_ref` ON volumes.id = volume_store_ref.volume_id
left join `cloud`.`disk_offering` ON volumes.disk_offering_id =
disk_offering.id left join `cloud`.`storage_pool` ON
volumes.pool_id = storage_pool.id left join
`cloud`.`cluster` ON storage_po
ol.cluster_id = cluster.id left join `cloud`.`vm_template`
ON volumes.template_id = vm_template.id left join
`cloud`.`vm_template` iso ON iso.id = volumes.iso_id left join
`cloud`.`resource_tags` ON resource_tags.resource_id = volumes.id
and resource_tags.resource_type = 'Volume' left join
`cloud`.`async_job` ON async_job.instance_id = volumes.id and
async_job.instance_type = 'Volume' and async_job.job_status = 0
2020-12-01 00:21:48,020 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS select volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.provisioning_type, volumes.size,
volumes.min_iops, volumes.max_iops, volumes.created,
volumes.state, volumes.attached, volumes.removed,
volumes.pod_id, volumes.display_volume, volumes.format,
volumes.path, volumes.chain_info, account.id account_id,
account.uuid account_uuid, account.account_name account_name,
account.type account_type, domain.id domain_id, domain.uuid
domain_uuid, domain.name domain_name, domain.path domain_path,
projects.id project_id, projects.uuid project_uuid,
projects.name project_name, data_center.id data_center_id,
data_center.uuid data_center_uuid, data_center.name
data_center_name, data_center.networktype data_center_type,
vm_instance.id vm_id, vm_instance.uuid vm_uuid,
vm_instance.name vm_name, vm_instance.state vm_state,
vm_instance.vm_type, user_vm.display_name vm_display_name,
volume_store_ref.size volume_store_size, volume_store_ref.download_pct,
volume_store_ref.download_state, volume_store_ref.error_str,
volume_store_ref.created created_on_store, disk_offering.id
disk_offering_id, disk_offering.uuid disk_offering_uuid,
disk_offering.name disk_offering_name, disk_offering.display_text
disk_offering_display_text, disk_offering.use_local_storage,
disk_offering.system_use, disk_offering.bytes_read_rate,
disk_offering.bytes_write_rate, disk_offering.iops_read_rate,
disk_offering.iops_write_rate,
disk_offering.cache_mode, storage_pool.id pool_id,
storage_pool.uuid pool_uuid, storage_pool.name pool_name,
cluster.hypervisor_type, vm_template.id template_id,
vm_template.uuid template_uuid, vm_template.extractable,
vm_template.type template_type, vm_template.name template_name,
vm_template.display_text template_display_text, iso.id iso_id,
iso.uuid iso_uuid, iso.name iso_name, iso.display_text
iso_display_text, resource_tags.id tag_id, resource_tags.uuid
tag_uuid, resource_tags.key tag_key, resource_tags.value
tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id, resource_tags.resource_id
tag_resource_id, resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, async_job
.id job_id, async_job.uuid job_uuid, async_job.job_status
job_status, async_job.account_id job_account_id from
`cloud`.`volumes` inner join `cloud`.`account` ON
volumes.account_id = account.id inner join `cloud`.`domain`
ON volumes.domain_id = domain.id left join
`cloud`.`projects` ON projects.project_account_id = account.id left
join `cloud`.`data_center` ON volumes.data_center_id = data_center.id
left join `cloud`.`vm_instance` ON volumes.instance_id =
vm_instance.id left join `cloud`.`user_vm` ON user_vm.id =
vm_instance.id left join `cloud`.`volume_store_ref` ON
volumes.id = volume_store_ref.volume_id left join
`cloud`.`disk_offering` ON volumes.disk_offering_id = disk_offering.id
left join `cloud`.`storage_pool` ON volumes.pool_id =
storage_pool.id left
join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id
left join `cloud`.`vm_template` ON volumes.template_id =
vm_template.id left join `cloud`.`vm_template` iso ON
iso.id = volumes.iso_id left join `cloud`.`resource_tags`
ON resource_tags.resource_id = volumes.id and
resource_tags.resource_type = 'Volume' left join
`cloud`.`async_job` ON async_job.instance_id = volumes.id and
async_job.instance_type = 'Volume' and async_job.job_status = 0
2020-12-01 00:21:48,049 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`template_view` AS select vm_template.id,
vm_template.uuid, vm_template.unique_name, vm_template.name,
vm_template.public, vm_template.featured,
vm_template.type, vm_template.hvm, vm_template.bits,
vm_template.url, vm_template.format, vm_template.created,
vm_template.checksum, vm_template.display_text,
vm_template.enable_password, vm_template.dynamically_scalable,
vm_template.state template_state, vm_template.guest_os_id,
guest_os.uuid guest_os_uuid, guest_os.display_name guest_os_name,
vm_template.bootable, vm_template.prepopulate,
vm_template.cross_zones, vm_template.hypervisor_type,
vm_template.extractable, vm_template.template_tag,
vm_template.sort_key, vm_temp
late.removed, vm_template.enable_sshkey, source_template.id
source_template_id, source_template.uuid source_template_uuid,
account.id account_id, account.uuid account_uuid,
account.account_name account_name, account.type account_type,
domain.id domain_id, domain.uuid domain_uuid, domain.name
domain_name, domain.path domain_path, projects.id project_id,
projects.uuid project_uuid, projects.name project_name,
data_center.id data_center_id, data_center.uuid data_center_uuid,
data_center.name data_center_name, launch_permission.account_id
lp_account_id, template_store_ref.store_id, image_store.scope
as store_scope, template_store_ref.state,
template_store_ref.download_state, template_store_ref.download_pct,
template_store_ref.error_str, template_store_ref.size,
template_store_ref.de
stroyed, template_store_ref.created created_on_store,
vm_template_details.name detail_name, vm_template_details.value
detail_value, resource_tags.id tag_id, resource_tags.uuid
tag_uuid, resource_tags.key tag_key, resource_tags.value
tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id, resource_tags.resource_id
tag_resource_id, resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, CONCAT(vm_template.id, '_', IFNULL(data_center.id, 0)) as
temp_zone_pair from `cloud`.`vm_template` inner join
`cloud`.`guest_os` ON guest_os.id = vm_template.guest_os_id
inner join `cloud`.`account` ON account.id = vm_template.account_id
inner join `cloud`.`domain` ON domain.id = account.domain_id
lef
t join `cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`vm_template_details` ON
vm_template_details.template_id = vm_template.id left join
`cloud`.`vm_template` source_template ON source_template.id =
vm_template.source_template_id left join
`cloud`.`template_store_ref` ON template_store_ref.template_id = vm_template.id
and template_store_ref.store_role = 'Image' and template_store_ref.destroyed=0
left join `cloud`.`image_store` ON image_store.removed is
NULL AND template_store_ref.store_id is not NULL AND image_store.id =
template_store_ref.store_id left join
`cloud`.`template_zone_ref` ON template_zone_ref.template_id = vm_template.id
AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null
left join `cloud`.`data_center` ON
(image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = da
ta_center.id) left join `cloud`.`launch_permission` ON
launch_permission.template_id = vm_template.id left join
`cloud`.`resource_tags` ON resource_tags.resource_id = vm_template.id
and (resource_tags.resource_type = 'Template' or
resource_tags.resource_type='ISO')
2020-12-01 00:21:50,871 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key
i_vm_instance__instance_name on table vm_instance exception: Can't DROP
'i_vm_instance__instance_name'; check that column/key exists
2020-12-01 00:21:51,120 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `template_view` AS SELECT `vm_template`.`id` AS `id`,
`vm_template`.`uuid` AS `uuid`, `vm_template`.`unique_name` AS
`unique_name`, `vm_template`.`name` AS `name`,
`vm_template`.`public` AS `public`, `vm_template`.`featured` AS
`featured`, `vm_template`.`type` AS `type`, `vm_template`.`hvm`
AS `hvm`, `vm_template`.`bits` AS `bits`, `vm_template`.`url`
AS `url`, `vm_template`.`format` AS `format`,
`vm_template`.`created` AS `created`, `vm_template`.`checksum` AS
`checksum`, `vm_template`.`display_text` AS `display_text`,
`vm_template`.`enable_password` AS `enable_password`,
`vm_template`.`dynamically_scalable` AS `dynamically_scalable`,
`vm_template`.`state` AS `template_state`, `vm_template`.`guest_os_id`
AS `guest_os_id`, `guest_os`.`uuid`
AS `guest_os_uuid`, `guest_os`.`display_name` AS `guest_os_name`,
`vm_template`.`bootable` AS `bootable`, `vm_template`.`prepopulate`
AS `prepopulate`, `vm_template`.`cross_zones` AS `cross_zones`,
`vm_template`.`hypervisor_type` AS `hypervisor_type`,
`vm_template`.`extractable` AS `extractable`,
`vm_template`.`template_tag` AS `template_tag`,
`vm_template`.`sort_key` AS `sort_key`, `vm_template`.`removed` AS
`removed`, `vm_template`.`enable_sshkey` AS `enable_sshkey`,
`source_template`.`id` AS `source_template_id`,
`source_template`.`uuid` AS `source_template_uuid`, `account`.`id` AS
`account_id`, `account`.`uuid` AS `account_uuid`,
`account`.`account_name` AS `account_name`, `account`.`type` AS
`account_type`, `domain`.`id` AS `domain_id`, `domain`.`uuid`
AS `domain_uuid`, `domain`.`name` AS `domain_name`,
`domain`.`path` A
S `domain_path`, `projects`.`id` AS `project_id`,
`projects`.`uuid` AS `project_uuid`, `projects`.`name` AS
`project_name`, `data_center`.`id` AS `data_center_id`,
`data_center`.`uuid` AS `data_center_uuid`, `data_center`.`name` AS
`data_center_name`, `launch_permission`.`account_id` AS
`lp_account_id`, `template_store_ref`.`store_id` AS `store_id`,
`image_store`.`scope` AS `store_scope`, `template_store_ref`.`state` AS
`state`, `template_store_ref`.`download_state` AS `download_state`,
`template_store_ref`.`download_pct` AS `download_pct`,
`template_store_ref`.`error_str` AS `error_str`,
`template_store_ref`.`size` AS `size`, `template_store_ref`.`destroyed`
AS `destroyed`, `template_store_ref`.`created` AS `created_on_store`,
`vm_template_details`.`name` AS `detail_name`,
`vm_template_details`.`value` AS `detail_value`, `resource_t
ags`.`id` AS `tag_id`, `resource_tags`.`uuid` AS `tag_uuid`,
`resource_tags`.`key` AS `tag_key`, `resource_tags`.`value` AS
`tag_value`, `resource_tags`.`domain_id` AS `tag_domain_id`,
`domain`.`uuid` AS `tag_domain_uuid`, `domain`.`name` AS
`tag_domain_name`, `resource_tags`.`account_id` AS `tag_account_id`,
`account`.`account_name` AS `tag_account_name`,
`resource_tags`.`resource_id` AS `tag_resource_id`,
`resource_tags`.`resource_uuid` AS `tag_resource_uuid`,
`resource_tags`.`resource_type` AS `tag_resource_type`,
`resource_tags`.`customer` AS `tag_customer`,
CONCAT(`vm_template`.`id`, '_',
IFNULL(`data_center`.`id`, 0)) AS `temp_zone_pair` FROM
((((((((((((`vm_template` JOIN `guest_os` ON ((`guest_os`.`id` =
`vm_template`.`guest_os_id`))) JOIN `account` ON ((`account`.`id` =
`vm_template`.`account_id`))) JOIN
`domain` ON ((`domain`.`id` = `account`.`domain_id`))) LEFT JOIN
`projects` ON ((`projects`.`project_account_id` = `account`.`id`)))
LEFT JOIN `vm_template_details` ON ((`vm_template_details`.`template_id` =
`vm_template`.`id`))) LEFT JOIN `vm_template` `source_template` ON
((`source_template`.`id` = `vm_template`.`source_template_id`))) LEFT
JOIN `template_store_ref` ON (((`template_store_ref`.`template_id` =
`vm_template`.`id`) AND (`template_store_ref`.`store_role` =
'Image') AND (`template_store_ref`.`destroyed` = 0)))) LEFT
JOIN `image_store` ON ((ISNULL(`image_store`.`removed`) AND
(`template_store_ref`.`store_id` IS NOT NULL) AND
(`image_store`.`id` = `template_store_ref`.`store_id`)))) LEFT JOIN
`template_zone_ref` ON (((`template_zone_ref`.`template_id` =
`vm_template`.`id`) AND ISNULL(`template_store_ref`.`store_id`)
AND ISNULL(`template_zone_ref`.`remove
d`)))) LEFT JOIN `data_center` ON (((`image_store`.`data_center_id` =
`data_center`.`id`) OR (`template_zone_ref`.`zone_id` =
`data_center`.`id`)))) LEFT JOIN `launch_permission` ON
((`launch_permission`.`template_id` = `vm_template`.`id`))) LEFT JOIN
`resource_tags` ON (((`resource_tags`.`resource_id` = `vm_template`.`id`)
AND ((`resource_tags`.`resource_type` = 'Template') OR
(`resource_tags`.`resource_type` = 'ISO')))))
2020-12-01 00:21:51,126 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `volume_view` AS SELECT `volumes`.`id` AS `id`,
`volumes`.`uuid` AS `uuid`, `volumes`.`name` AS `name`,
`volumes`.`device_id` AS `device_id`, `volumes`.`volume_type` AS
`volume_type`, `volumes`.`provisioning_type` AS `provisioning_type`,
`volumes`.`size` AS `size`, `volumes`.`min_iops` AS `min_iops`,
`volumes`.`max_iops` AS `max_iops`, `volumes`.`created` AS
`created`, `volumes`.`state` AS `state`, `volumes`.`attached`
AS `attached`, `volumes`.`removed` AS `removed`,
`volumes`.`pod_id` AS `pod_id`, `volumes`.`display_volume` AS
`display_volume`, `volumes`.`format` AS `format`,
`volumes`.`path` AS `path`, `volumes`.`chain_info` AS `chain_info`,
`account`.`id` AS `account_id`, `account`.`uuid` AS `account_uuid`,
`account`.`acco
unt_name` AS `account_name`, `account`.`type` AS `account_type`,
`domain`.`id` AS `domain_id`, `domain`.`uuid` AS `domain_uuid`,
`domain`.`name` AS `domain_name`, `domain`.`path` AS `domain_path`,
`projects`.`id` AS `project_id`, `projects`.`uuid` AS
`project_uuid`, `projects`.`name` AS `project_name`,
`data_center`.`id` AS `data_center_id`, `data_center`.`uuid` AS
`data_center_uuid`, `data_center`.`name` AS `data_center_name`,
`data_center`.`networktype` AS `data_center_type`, `vm_instance`.`id`
AS `vm_id`, `vm_instance`.`uuid` AS `vm_uuid`,
`vm_instance`.`name` AS `vm_name`, `vm_instance`.`state` AS `vm_state`,
`vm_instance`.`vm_type` AS `vm_type`, `user_vm`.`display_name`
AS `vm_display_name`, `volume_store_ref`.`size` AS `volume_store_size`,
`volume_store_ref`.`download_pct` AS `download_pct`,
`volume_store_ref`.`
download_state` AS `download_state`, `volume_store_ref`.`error_str` AS
`error_str`, `volume_store_ref`.`created` AS `created_on_store`,
`disk_offering`.`id` AS `disk_offering_id`, `disk_offering`.`uuid` AS
`disk_offering_uuid`, `disk_offering`.`name` AS `disk_offering_name`,
`disk_offering`.`display_text` AS `disk_offering_display_text`,
`disk_offering`.`use_local_storage` AS `use_local_storage`,
`disk_offering`.`system_use` AS `system_use`,
`disk_offering`.`bytes_read_rate` AS `bytes_read_rate`,
`disk_offering`.`bytes_write_rate` AS `bytes_write_rate`,
`disk_offering`.`iops_read_rate` AS `iops_read_rate`,
`disk_offering`.`iops_write_rate` AS `iops_write_rate`,
`disk_offering`.`cache_mode` AS `cache_mode`, `storage_pool`.`id` AS
`pool_id`, `storage_pool`.`uuid` AS `pool_uuid`,
`storage_pool`.`name` AS `pool_name`, `cluster`.`hypervisor_type` AS
`hyp
ervisor_type`, `vm_template`.`id` AS `template_id`,
`vm_template`.`uuid` AS `template_uuid`, `vm_template`.`extractable` AS
`extractable`, `vm_template`.`type` AS `template_type`,
`vm_template`.`name` AS `template_name`, `vm_template`.`display_text`
AS `template_display_text`, `iso`.`id` AS `iso_id`,
`iso`.`uuid` AS `iso_uuid`, `iso`.`name` AS `iso_name`,
`iso`.`display_text` AS `iso_display_text`, `resource_tags`.`id` AS
`tag_id`, `resource_tags`.`uuid` AS `tag_uuid`,
`resource_tags`.`key` AS `tag_key`, `resource_tags`.`value` AS
`tag_value`, `resource_tags`.`domain_id` AS `tag_domain_id`,
`domain`.`uuid` AS `tag_domain_uuid`, `domain`.`name` AS
`tag_domain_name`, `resource_tags`.`account_id` AS `tag_account_id`,
`account`.`account_name` AS `tag_account_name`,
`resource_tags`.`resource_id` AS `tag_resource_id`, `reso
urce_tags`.`resource_uuid` AS `tag_resource_uuid`,
`resource_tags`.`resource_type` AS `tag_resource_type`,
`resource_tags`.`customer` AS `tag_customer`, `async_job`.`id` AS
`job_id`, `async_job`.`uuid` AS `job_uuid`,
`async_job`.`job_status` AS `job_status`, `async_job`.`account_id` AS
`job_account_id` FROM ((((((((((((((`volumes` JOIN
`account` ON ((`volumes`.`account_id` = `account`.`id`))) JOIN `domain`
ON ((`volumes`.`domain_id` = `domain`.`id`))) LEFT JOIN `projects` ON
((`projects`.`project_account_id` = `account`.`id`))) LEFT JOIN
`data_center` ON ((`volumes`.`data_center_id` = `data_center`.`id`)))
LEFT JOIN `vm_instance` ON ((`volumes`.`instance_id` = `vm_instance`.`id`)))
LEFT JOIN `user_vm` ON ((`user_vm`.`id` = `vm_instance`.`id`)))
LEFT JOIN `volume_store_ref` ON ((`volumes`.`id` =
`volume_store_ref`.`volume_id`))) LEFT JOIN `disk_offering` ON ((`v
olumes`.`disk_offering_id` = `disk_offering`.`id`))) LEFT JOIN
`storage_pool` ON ((`volumes`.`pool_id` = `storage_pool`.`id`))) LEFT
JOIN `cluster` ON ((`storage_pool`.`cluster_id` = `cluster`.`id`)))
LEFT JOIN `vm_template` ON ((`volumes`.`template_id` = `vm_template`.`id`)))
LEFT JOIN `vm_template` `iso` ON ((`iso`.`id` = `volumes`.`iso_id`)))
LEFT JOIN `resource_tags` ON (((`resource_tags`.`resource_id` =
`volumes`.`id`) AND (`resource_tags`.`resource_type` = 'Volume'))))
LEFT JOIN `async_job` ON (((`async_job`.`instance_id` = `volumes`.`id`)
AND (`async_job`.`instance_type` = 'Volume') AND
(`async_job`.`job_status` = 0))))
2020-12-01 00:21:52,169 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS SELECT volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.provisioning_type, volumes.size,
volumes.min_iops, volumes.max_iops, volumes.created,
volumes.state, volumes.attached, volumes.removed,
volumes.display_volume, volumes.format, volumes.path,
volumes.chain_info, account.id account_id, account.uuid
account_uuid, account.account_name account_name, account.type
account_type, domain.id domain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,
projects.id project_id, projects.uuid project_uuid,
projects.name project_name, data_center.id data_center_id,
data_center.uuid
data_center_uuid, data_center.name data_center_name,
data_center.networktype data_center_type, vm_instance.id vm_id,
vm_instance.uuid vm_uuid, vm_instance.name vm_name,
vm_instance.state vm_state, vm_instance.vm_type,
user_vm.display_name vm_display_name, volume_store_ref.size
volume_store_size, volume_store_ref.download_pct,
volume_store_ref.download_state, volume_store_ref.error_str,
volume_store_ref.created created_on_store, disk_offering.id
disk_offering_id, disk_offering.uuid disk_offering_uuid,
disk_offering.name disk_offering_name, disk_offering.display_text
disk_offering_display_text, disk_offering.use_local_storage,
disk_offering.system_use, disk_offering.bytes_read_rate,
disk_offering.bytes_write_rate, disk_offering.iops_read_rate,
disk_offering.iops_write_rate, disk_offering.cache_m
ode, storage_pool.id pool_id, storage_pool.uuid pool_uuid,
storage_pool.name pool_name, cluster.id cluster_id,
cluster.name cluster_name, cluster.uuid cluster_uuid,
cluster.hypervisor_type, vm_template.id template_id,
vm_template.uuid template_uuid, vm_template.extractable,
vm_template.type template_type, vm_template.name template_name,
vm_template.display_text template_display_text, iso.id iso_id,
iso.uuid iso_uuid, iso.name iso_name, iso.display_text
iso_display_text, resource_tags.id tag_id, resource_tags.uuid
tag_uuid, resource_tags.key tag_key, resource_tags.value
tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id, resource_tags.resource_id
tag_resource_id, resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_
resource_type, resource_tags.customer tag_customer,
async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id job_account_id,
host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid,
host_pod_ref.name pod_name, resource_tag_account.account_name
tag_account_name, resource_tag_domain.uuid tag_domain_uuid,
resource_tag_domain.name tag_domain_name from `cloud`.`volumes`
inner join `cloud`.`account` ON volumes.account_id = account.id
inner join `cloud`.`domain` ON volumes.domain_id =
domain.id left join `cloud`.`projects` ON
projects.project_account_id = account.id left join
`cloud`.`data_center` ON volumes.data_center_id = data_center.id
left join `cloud`.`vm_instance` ON volumes.instance_id = vm_instance.id
left join `cloud`.`user_vm
` ON user_vm.id = vm_instance.id left join
`cloud`.`volume_store_ref` ON volumes.id = volume_store_ref.volume_id
left join `cloud`.`disk_offering` ON volumes.disk_offering_id =
disk_offering.id left join `cloud`.`storage_pool` ON
volumes.pool_id = storage_pool.id left join
`cloud`.`host_pod_ref` ON storage_pool.pod_id = host_pod_ref.id
left join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id
left join `cloud`.`vm_template` ON volumes.template_id =
vm_template.id left join `cloud`.`vm_template` iso ON
iso.id = volumes.iso_id left join `cloud`.`resource_tags`
ON resource_tags.resource_id = volumes.id and
resource_tags.resource_type = 'Volume' left join
`cloud`.`async_job` ON async_job.instance_id = volumes.id and
async_job.instance_type = 'Volume' and async_job.
job_status = 0 left join `cloud`.`account`
resource_tag_account ON resource_tag_account.id = resource_tags.account_id
left join `cloud`.`domain` resource_tag_domain ON
resource_tag_domain.id = resource_tags.domain_id
2020-12-01 00:21:52,227 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`template_view` AS SELECT `vm_template`.`id`
AS `id`, `vm_template`.`uuid` AS `uuid`,
`vm_template`.`unique_name` AS `unique_name`, `vm_template`.`name` AS
`name`, `vm_template`.`public` AS `public`,
`vm_template`.`featured` AS `featured`, `vm_template`.`type` AS
`type`, `vm_template`.`hvm` AS `hvm`, `vm_template`.`bits` AS
`bits`, `vm_template`.`url` AS `url`, `vm_template`.`format`
AS `format`, `vm_template`.`created` AS `created`,
`vm_template`.`checksum` AS `checksum`, `vm_template`.`display_text`
AS `display_text`, `vm_template`.`enable_password` AS
`enable_password`, `vm_template`.`dynamically_scalable` AS
`dynamically_scalable`, `vm_template`.`state` AS `template_state`,
`vm_template`.`guest_os_id` AS `guest_os_id`,
`guest_os`.`uuid` AS `guest_os_uuid`,
`guest_os`.`display_name` AS `guest_os_name`, `vm_template`.`bootable`
AS `bootable`, `vm_template`.`prepopulate` AS `prepopulate`,
`vm_template`.`cross_zones` AS `cross_zones`,
`vm_template`.`hypervisor_type` AS `hypervisor_type`,
`vm_template`.`extractable` AS `extractable`,
`vm_template`.`template_tag` AS `template_tag`,
`vm_template`.`sort_key` AS `sort_key`, `vm_template`.`removed` AS
`removed`, `vm_template`.`enable_sshkey` AS `enable_sshkey`,
`parent_template`.`id` AS `parent_template_id`,
`parent_template`.`uuid` AS `parent_template_uuid`,
`source_template`.`id` AS `source_template_id`,
`source_template`.`uuid` AS `source_template_uuid`, `account`.`id` AS
`account_id`, `account`.`uuid` AS `account_uuid`,
`account`.`account_name` AS `account_name`, `account`.`type` AS `ac
count_type`, `domain`.`id` AS `domain_id`, `domain`.`uuid`
AS `domain_uuid`, `domain`.`name` AS `domain_name`,
`domain`.`path` AS `domain_path`, `projects`.`id` AS `project_id`,
`projects`.`uuid` AS `project_uuid`, `projects`.`name` AS
`project_name`, `data_center`.`id` AS `data_center_id`,
`data_center`.`uuid` AS `data_center_uuid`, `data_center`.`name` AS
`data_center_name`, `launch_permission`.`account_id` AS
`lp_account_id`, `template_store_ref`.`store_id` AS `store_id`,
`image_store`.`scope` AS `store_scope`, `template_store_ref`.`state`
AS `state`, `template_store_ref`.`download_state` AS `download_state`,
`template_store_ref`.`download_pct` AS `download_pct`,
`template_store_ref`.`error_str` AS `error_str`,
`template_store_ref`.`size` AS `size`,
`template_store_ref`.physical_size AS `physical_size`,
`template_store_ref`.`destroyed` AS `destroyed`,
`template_store_ref`.`created` AS `created_on_store`,
`vm_template_details`.`name` AS `detail_name`,
`vm_template_details`.`value` AS `detail_value`, `resource_tags`.`id`
AS `tag_id`, `resource_tags`.`uuid` AS `tag_uuid`,
`resource_tags`.`key` AS `tag_key`, `resource_tags`.`value` AS
`tag_value`, `resource_tags`.`domain_id` AS `tag_domain_id`,
`domain`.`uuid` AS `tag_domain_uuid`, `domain`.`name` AS
`tag_domain_name`, `resource_tags`.`account_id` AS `tag_account_id`,
`account`.`account_name` AS `tag_account_name`,
`resource_tags`.`resource_id` AS `tag_resource_id`,
`resource_tags`.`resource_uuid` AS `tag_resource_uuid`,
`resource_tags`.`resource_type` AS `tag_resource_type`,
`resource_tags`.`customer` AS `tag_customer`,
CONCAT(`vm_template`.`id`, '_',
IFNULL(`data_center`.`id`, 0)) AS `temp_zone_pair`,
`vm_template`.`direct_download` AS `direct_download` FROM
(((((((((((((`vm_template` JOIN `guest_os` ON ((`guest_os`.`id` =
`vm_template`.`guest_os_id`))) JOIN `account` ON ((`account`.`id` =
`vm_template`.`account_id`))) JOIN `domain` ON ((`domain`.`id` =
`account`.`domain_id`))) LEFT JOIN `projects` ON
((`projects`.`project_account_id` = `account`.`id`))) LEFT JOIN
`vm_template_details` ON ((`vm_template_details`.`template_id` =
`vm_template`.`id`))) LEFT JOIN `vm_template` `source_template` ON
((`source_template`.`id` = `vm_template`.`source_template_id`))) LEFT
JOIN `template_store_ref` ON (((`template_store_ref`.`template_id` =
`vm_template`.`id`) AND (`template_store_ref`.`store_role` =
'Image') AND (`template_store_ref`.`destroyed` = 0))))
LEFT JOIN `vm_template` `parent_template` ON ((`parent_template
`.`id` = `vm_template`.`parent_template_id`))) LEFT JOIN
`image_store` ON ((ISNULL(`image_store`.`removed`) AND
(`template_store_ref`.`store_id` IS NOT NULL) AND
(`image_store`.`id` = `template_store_ref`.`store_id`)))) LEFT JOIN
`template_zone_ref` ON (((`template_zone_ref`.`template_id` =
`vm_template`.`id`) AND ISNULL(`template_store_ref`.`store_id`)
AND ISNULL(`template_zone_ref`.`removed`)))) LEFT JOIN
`data_center` ON (((`image_store`.`data_center_id` = `data_center`.`id`)
OR (`template_zone_ref`.`zone_id` = `data_center`.`id`)))) LEFT
JOIN `launch_permission` ON ((`launch_permission`.`template_id` =
`vm_template`.`id`))) LEFT JOIN `resource_tags` ON
(((`resource_tags`.`resource_id` = `vm_template`.`id`) AND
((`resource_tags`.`resource_type` = 'Template') OR
(`resource_tags`.`resource_type` = 'ISO')))))
2020-12-01 00:21:52,301 ERROR [c.c.u.PropertiesUtil] (main:null) (logid:)
Unable to find properties file: commands.properties
2020-12-01 00:22:00,989 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
(logid:) mount: /var/cloudstack/management/systemvm_mnt: mount failed: Unknown
error -1
2020-12-01 00:22:00,989 INFO [c.c.s.ConfigurationServerImpl] (main:null)
(logid:) Injected public and private keys into systemvm iso with result :
mount: /var/cloudstack/management/systemvm_mnt: mount failed: Unknown error -1
2020-12-01 00:22:00,989 WARN [c.c.s.ConfigurationServerImpl] (main:null)
(logid:) Failed to inject generated public key into systemvm iso mount:
/var/cloudstack/management/systemvm_mnt: mount failed: Unknown error -1
2020-12-01 00:22:00,990 WARN [o.a.c.s.m.c.ResourceApplicationContext]
(main:null) (logid:) Exception encountered during context initialization -
cancelling refresh attempt:
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Failed to inject generated
public key into systemvm iso mount: /var/cloudstack/management/systemvm_mnt:
mount failed: Unknown error -1
org.springframework.context.ApplicationContextException: Failed to start
bean 'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Failed to inject generated
public key into systemvm iso mount: /var/cloudstack/management/systemvm_mnt:
mount failed: Unknown error -1
Caused by: com.cloud.utils.exception.CloudRuntimeException: Failed to inject
generated public key into systemvm iso mount:
/var/cloudstack/management/systemvm_mnt: mount failed: Unknown error -1
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
