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
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.14and4.11both on centos8 and centos7 both with a few different versions of mariadb, mysql and java.Can't seem to get the right combinationsame result every time.