Trouble installing in LXC container

[inmanturbo]

How do I 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 the 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 the 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,         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_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_ref__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_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_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.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             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_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.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             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' 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 = 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: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_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_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_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: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_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,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_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.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             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' 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 = 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: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` 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`.`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`     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`.`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: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`.`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` 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 `hypervisor_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`,         `resource_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 ((`volumes`.`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_mode,         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 `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`,          `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

[DaanHoogland]

@inmanturbo both versions are very common on centos7 and should work (almost) out of the box. My first thought is, did you preseed the systemvm template?
if you need any help, subscribe to and ask on users@cloudstack.apache.org

[inmanturbo]

@DaanHoogland

Thank you very much for your kind and quick response. We have been using other solutions for a growing service and our research indicates Apache Cloudstack will help solve a lot of the issues we have had with them, so I'm very keen to try it.

I was in a rush and ran several times through the quick installation guide without checking the full installation documentation. The common irony is that beginner error costed me a good bit of time.

I didn't catch a mention in the quick guide of preseeding the systemvm, however I do see the instructions for doing so in the regular installation guide. I will give that a try in the next cycle.

Thanks again.

[inmanturbo]

Ah yes, I have been running the script here

http://docs.cloudstack.apache.org/en/latest/quickinstallationguide/qig.html#system-template-setup

with this output:

/usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt: line 168: which: command not found
--2020-12-02 20:16:39--  http://download.cloudstack.org/systemvm/4.14/systemvmtemplate-4.14.0-kvm.qcow2.bz2
Resolving download.cloudstack.org (download.cloudstack.org)... 2a00:f10:121:400:403:9cff:fe00:37f, 185.27.174.49
Connecting to download.cloudstack.org (download.cloudstack.org)|2a00:f10:121:400:403:9cff:fe00:37f|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 328521792 (313M) [application/x-bzip2]
Saving to: '/usr/share/cloudstack-common/scripts/storage/secondary/1dd8ef05-81f2-40d5-a3c2-02da036a3341.qcow2'

100%[===========================================================================================================================================================================>] 328,521,792 10.4MB/s   in 50s    

2020-12-02 20:17:30 (6.29 MB/s) - '/usr/share/cloudstack-common/scripts/storage/secondary/1dd8ef05-81f2-40d5-a3c2-02da036a3341.qcow2' saved [328521792/328521792]

/usr/share/cloudstack-common/scripts/storage/secondary/createtmplt.sh: line 57: file: command not found
File /usr/share/cloudstack-common/scripts/storage/secondary/1dd8ef05-81f2-40d5-a3c2-02da036a3341.qcow2 does not appear to be compressed
/usr/share/cloudstack-common/scripts/storage/secondary/createtmplt.sh: line 76: file: command not found
/usr/share/cloudstack-common/scripts/storage/secondary/createtmplt.sh: line 43: file: command not found
Moving to /export/secondary/template/tmpl/1/3///1dd8ef05-81f2-40d5-a3c2-02da036a3341.qcow2...could take a while
Successfully installed system VM template  and template.properties to /export/secondary/template/tmpl/1/3/

[weizhouapache]

Ah yes, I have been running the script here

http://docs.cloudstack.apache.org/en/latest/quickinstallationguide/qig.html#system-template-setup

with this output:

/usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt: line 168: which: command not found
--2020-12-02 20:16:39--  http://download.cloudstack.org/systemvm/4.14/systemvmtemplate-4.14.0-kvm.qcow2.bz2
Resolving download.cloudstack.org (download.cloudstack.org)... 2a00:f10:121:400:403:9cff:fe00:37f, 185.27.174.49
Connecting to download.cloudstack.org (download.cloudstack.org)|2a00:f10:121:400:403:9cff:fe00:37f|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 328521792 (313M) [application/x-bzip2]
Saving to: '/usr/share/cloudstack-common/scripts/storage/secondary/1dd8ef05-81f2-40d5-a3c2-02da036a3341.qcow2'

100%[===========================================================================================================================================================================>] 328,521,792 10.4MB/s   in 50s    

2020-12-02 20:17:30 (6.29 MB/s) - '/usr/share/cloudstack-common/scripts/storage/secondary/1dd8ef05-81f2-40d5-a3c2-02da036a3341.qcow2' saved [328521792/328521792]

/usr/share/cloudstack-common/scripts/storage/secondary/createtmplt.sh: line 57: file: command not found
File /usr/share/cloudstack-common/scripts/storage/secondary/1dd8ef05-81f2-40d5-a3c2-02da036a3341.qcow2 does not appear to be compressed
/usr/share/cloudstack-common/scripts/storage/secondary/createtmplt.sh: line 76: file: command not found
/usr/share/cloudstack-common/scripts/storage/secondary/createtmplt.sh: line 43: file: command not found
Moving to /export/secondary/template/tmpl/1/3///1dd8ef05-81f2-40d5-a3c2-02da036a3341.qcow2...could take a while
Successfully installed system VM template  and template.properties to /export/secondary/template/tmpl/1/3/

@inmanturbo this is because qemu-img is not found.
the dependency has been added in #3371
if you use older versions, please install qemu-utils (ubuntu) or qemu-img (centos) on management server.

[inmanturbo]

@weizhouapache Yes thank you I realized that when I went through the script. I was actually missing /usr/bin/file (!) as well.

Anyway @DaanHoogland as well thank you both this is just a thanks and an update, my issue is resolved. I was trying to install in lxc container for simplicity in lab environment. Putting it on bare metal solved everything. Idk what cause the issue in lxc (aside form the minimal image being so sparse) -- I was using security.privileged=true as well as security.nesting=true -- but nonetheless all guides lead to success for me on metal. Debian works as well. Perhaps the template script is attempting to mount a loop device? I'd have to look a little more closely. Might be a good idea to change the title and leave this here for others attempting a similar scenario.

[weizhouapache]

@weizhouapache Yes thank you I realized that when I went through the script. I was actually missing /usr/bin/file (!) as well.

Anyway @DaanHoogland as well thank you both this is just a thanks and an update, my issue is resolved. I was trying to install in lxc container for simplicity in lab environment. Putting it on bare metal solved everything. Idk what cause the issue in lxc (aside form the minimal image being so sparse) -- I was using security.privileged=true as well as security.nesting=true -- but nonetheless all guides lead to success for me on metal. Debian works as well. Perhaps the template script is attempting to mount a loop device? I'd have to look a little more closely. Might be a good idea to change the title and leave this here for others attempting a similar scenario.

@inmanturbo yes, you need to allow mounting of ISO in lxc.
if you use Ubuntu or debian, I can give your some suggestion on lxc settings.

[DaanHoogland]

@inmanturbo I'll close this. If closed you can still add comments to it. If you find that documentation needs improving, add a PR or an issue at https://github.com/apache/cloudstack-documentation