GitHub user tomorrrow666 added a comment to the discussion: Cloudstack 4.18
HTTP 503 错误 （MySQL 8.0）
idrl@management1:~$ sudo systemctl restart cloudstack-management.service
idrl@management1:~$ sudo grep -i -E 'error|exception'
/var/log/cloudstack/management/management-server.log
2025-02-06 08:09:25,526 ERROR [c.c.u.d.Merovingian2] (main:null) (logid:)
Unable to get a new db connection
java.sql.SQLNonTransientConnectionException: Could not create connection to
database server. Attempted reconnect 3 times. Giving up.
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at
com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:211)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications
link failure
Caused by: java.net.ConnectException: 连接被拒绝 (Connection refused)
2025-02-06 08:30:19,518 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 transferred 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
2025-02-06 08:30:21,380 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_t
ags.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
2025-02-06 08:30:22,592 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
2025-02-06 08:30:22,704 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`(`st
ore_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
2025-02-06 08:30:22,795 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
2025-02-06 08:30:27,533 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 poo
l_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
le
ft 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 = 'Vol
ume' left join `cloud`.`async_job` ON
async_job.instance_id = volumes.id and async_job.instance_type =
'Volume' and async_job.job_status = 0
2025-02-06 08:30:27,746 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_ssh
key, 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_re
f.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')
2025-02-06 08:30:28,797 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
2025-02-06 08:30:28,799 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
2025-02-06 08:30:28,817 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:
Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,818 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:
Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,818 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:
Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists
2025-02-06 08:30:28,819 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: Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check
that column/key exists
2025-02-06 08:30:28,820 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: Can't
DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,821 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:
Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,822 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: Can't
DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists
2025-02-06 08:30:28,823 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: Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check
that column/key exists
2025-02-06 08:30:28,823 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: Can't
DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,824 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: Can't
DROP 'fk_external_pxe_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,825 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: Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that
column/key exists
2025-02-06 08:30:29,311 INFO [c.c.u.d.Upgrade410to420] (main:null) (logid:)
migrateDatafromIsoIdInVolumesTable: ignoring Exception: Unknown column
'iso_id1' in 'field list'
2025-02-06 08:30:32,127 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_templat
e.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.destr
oyed, 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 j
oin `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')
2025-02-06 08:30:32,137 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 d
ata_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_t
ags.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
2025-02-06 08:30:33,968 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, s
torage_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 stor
age_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
2025-02-06 08:30:40,018 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 joi
n `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
2025-02-06 08:30:40,162 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_templat
e.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.destr
oyed, 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 j
oin `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')
2025-02-06 08:30:43,994 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
2025-02-06 08:30:44,722 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 `do
main` 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')))))
2025-02-06 08:30:44,734 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`.`dow
nload_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
`hyperv
isor_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`, `resourc
e_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 ((`volu
mes`.`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))))
2025-02-06 08:30:49,436 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 da
ta_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_res
ource_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` O
N 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
2025-02-06 08:30:49,994 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 `accou
nt_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`, `t
emplate_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')))))
2025-02-06 08:30:50,459 ERROR [c.c.u.PropertiesUtil] (main:null) (logid:)
Unable to find properties file: commands.properties
2025-02-06 08:30:50,882 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
changed fingerprint type to TEXT, it avoids db exception when creating the
certificate issue #3123
2025-02-06 08:30:54,460 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 `accou
nt_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`, `t
emplate_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`,
`vm_template`.`deploy_as_is` AS `deploy_as_is` 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 JOI
N `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')))))
2025-02-06 08:30:59,531 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, volumes.external_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, 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,
service_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, r
esource_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 lef
t 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`.`service_offering` ON vm_instance.service_offering_id =
service_offering.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 joi
n `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
2025-02-06 08:31:02,690 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 `accou
nt_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`, `t
emplate_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`,
`vm_template`.`deploy_as_is` AS `deploy_as_is`, `user_data`.`id` AS
`user_data_id`, `user_data`.`uuid` AS `user_data_uuid`,
`user_data`.`name` AS `user_data_name`, `user_data`.`params` AS
`user_data_params`, `vm_template`.`user_data_link_policy` AS
`user_data_policy` 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 `user_data` ON ((`user_data`.`id` = `vm_template`.`user_data_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')))))
2025-02-06 08:31:03,361 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`configuration` SET `kind` = 'Select', `options` =
'Error,Migration,ForceStop' where `name` =
'host.maintenance.local.storage.strategy'
2025-02-06 08:31:05,043 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key fk_user_data_id
on table cloud.user_vm exception: Can't DROP 'fk_user_data_id'; check that
column/key exists
2025-02-06 08:31:05,045 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_user_vm__user_data_id on table cloud.user_vm exception: Can't DROP
'fk_user_vm__user_data_id'; check that column/key exists
2025-02-06 08:31:05,046 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key fk_user_data_id on table
cloud.user_vm exception: Can't DROP 'fk_user_data_id'; check that column/key
exists
2025-02-06 08:31:05,051 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key fk_user_vm__user_data_id
on table cloud.user_vm exception: Can't DROP 'fk_user_vm__user_data_id'; check
that column/key exists
2025-02-06 08:31:05,099 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key fk_user_data_id
on table cloud.vm_template exception: Can't DROP 'fk_user_data_id'; check that
column/key exists
2025-02-06 08:31:05,099 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_vm_template__user_data_id on table cloud.vm_template exception: Can't DROP
'fk_vm_template__user_data_id'; check that column/key exists
2025-02-06 08:31:05,100 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key fk_user_data_id on table
cloud.vm_template exception: Can't DROP 'fk_user_data_id'; check that
column/key exists
2025-02-06 08:31:05,101 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key
fk_vm_template__user_data_id on table cloud.vm_template exception: Can't DROP
'fk_vm_template__user_data_id'; check that column/key exists
2025-02-06 08:31:05,163 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key fk_passphrase_id
on table cloud.volumes exception: Can't DROP 'fk_passphrase_id'; check that
column/key exists
2025-02-06 08:31:05,164 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop foreign key
fk_volumes__passphrase_id on table cloud.volumes exception: Can't DROP
'fk_volumes__passphrase_id'; check that column/key exists
2025-02-06 08:31:05,165 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key fk_passphrase_id on
table cloud.volumes exception: Can't DROP 'fk_passphrase_id'; check that
column/key exists
2025-02-06 08:31:05,166 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
(logid:) Ignored SQL Exception when trying to drop key
fk_volumes__passphrase_id on table cloud.volumes exception: Can't DROP
'fk_volumes__passphrase_id'; check that column/key exists
2025-02-06 08:31:24,900 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 08:35:07,894 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 08:40:41,589 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 08:53:31,545 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 09:01:27,852 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 09:14:38,024 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 09:15:02,403 ERROR [c.c.u.d.ConnectionConcierge]
(ConnectionConcierge-1:ctx-01637801) (logid:1f1e5aa6) Unable to keep the db
connection for LockController1
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link
failure
at
com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications
link failure
Caused by: java.io.EOFException: Can not read response from server. Expected to
read 4 bytes, read 0 bytes before connection was unexpectedly lost.
2025-02-06 09:17:38,620 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 09:17:44,412 ERROR [c.c.u.d.ConnectionConcierge]
(ConnectionConcierge-1:ctx-c47f37a7) (logid:85bc0458) Unable to keep the db
connection for LockController1
java.sql.SQLNonTransientConnectionException: Server shutdown in progress
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
2025-02-06 09:17:49,005 ERROR [c.c.u.d.T.Transaction]
(ConnectionConcierge-1:ctx-c47f37a7) (logid:85bc0458) Unexpected exception:
java.sql.SQLNonTransientConnectionException: Could not create connection to
database server. Attempted reconnect 3 times. Giving up.
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at
com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:211)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications
link failure
Caused by: java.net.ConnectException: 连接被拒绝 (Connection refused)
2025-02-06 10:39:07,814 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 11:07:49,401 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
2025-02-06 11:13:48,987 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local
address where the server is running, please check your configuration
sudo vim /etc/cloudstack/management/db.properties
cluster.node.IP=127.0.0.1
~~~~
~~~~
HTTP ERROR 503 Service Unavailable
URI: /client/
STATUS: 503
MESSAGE: Service Unavailable
SERVLET: -
"Still not working"
GitHub link:
https://github.com/apache/cloudstack/discussions/10384#discussioncomment-12187271
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
