tomorrrow666 commented on issue #10350:
URL: https://github.com/apache/cloudstack/issues/10350#issuecomment-2650346848
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 t
he 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, resourc
e_tags.key tag_key, resource_tags.value tag_value,
resource_tags.domain_id tag_domain_id, resource_tags.account_id
tag_account_id, resource_tags.resource_id tag_resource_id,
resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`volumes` inner join
`cloud`.`account` ON volumes.account_id = account.id inner join
`cloud`.`domain` ON volumes.domain_id = domain.id left join
`cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`data_center` ON volumes.data_center_id =
data_center.id left join `cloud`.`vm_instance` ON
volumes.instance_id = vm_instance.id
left join `cloud`.`user_vm` ON user_vm.id = vm_instance.id
left join `cloud`.`volume_host_ref` ON volumes.id =
volume_host_ref.volume_id and volumes.data_center_id =
volume_host_ref.zone_id left join `cloud`.`disk_offering`
ON volumes.disk_offering_id = disk_offering.id left join
`cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left
join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id
left join `cloud`.`vm_template` ON volumes.template_id =
vm_template.id left join `cloud`.`resource_tags` ON
resource_tags.resource_id = volumes.id and
resource_tags.resource_type = 'Volume' left join
`cloud`.`async_job` ON async_job.instance_id = volumes.id and
async_job.instance_type = 'Volume' and async_job.job_status = 0
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`(
`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
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_r
ef__store_id` FOREIGN KEY `fk_volume_store_ref__store_id` (`store_id`)
REFERENCES `image_store` (`id`) ON DELETE CASCADE, INDEX
`i_volume_store_ref__store_id`(`store_id`), CONSTRAINT
`fk_volume_store_ref__volume_id` FOREIGN KEY `fk_volume_store_ref__volume_id`
(`volume_id`) REFERENCES `volumes` (`id`), INDEX
`i_volume_store_ref__volume_id`(`volume_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1
DEFAULT CHARSET=utf8
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
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
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_
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
`clou
d`.`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 jo
in `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_temp
late.removed, vm_template.enable_sshkey, source_template.id
source_template_id, source_template.uuid source_template_uuid,
account.id account_id, account.uuid account_uuid,
account.account_name account_name, account.type account_type,
domain.id domain_id, domain.uuid domain_uuid, domain.name
domain_name, domain.path domain_path, projects.id project_id,
projects.uuid project_uuid, projects.name project_name,
data_center.id data_center_id, data_center.uuid data_center_uuid,
data_center.name data_center_name, launch_permission.account_id
lp_account_id, template_store_ref.store_id, image_store.scope
as store_scope, template_store_ref.state,
template_store_ref.download_state, template_store_ref.download_pct,
template_store_ref.error_str, template_store_ref.size,
template_store_ref.de
stroyed, template_store_ref.created created_on_store,
vm_template_details.name detail_name, vm_template_details.value
detail_value, resource_tags.id tag_id, resource_tags.uuid
tag_uuid, resource_tags.key tag_key, resource_tags.value
tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id, resource_tags.resource_id
tag_resource_id, resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, CONCAT(vm_template.id, '_', IFNULL(data_center.id, 0)) as
temp_zone_pair from `cloud`.`vm_template` inner join
`cloud`.`guest_os` ON guest_os.id = vm_template.guest_os_id
inner join `cloud`.`account` ON account.id = vm_template.account_id
inner join `cloud`.`domain` ON domain.id = account.domain_id
lef
t join `cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`vm_template_details` ON
vm_template_details.template_id = vm_template.id left join
`cloud`.`vm_template` source_template ON source_template.id =
vm_template.source_template_id left join
`cloud`.`template_store_ref` ON template_store_ref.template_id = vm_template.id
and template_store_ref.store_role = 'Image' and template_store_ref.destroyed=0
left join `cloud`.`image_store` ON image_store.removed is
NULL AND template_store_ref.store_id is not NULL AND image_store.id =
template_store_ref.store_id left join
`cloud`.`template_zone_ref` ON template_zone_ref.template_id = vm_template.id
AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null
left join `cloud`.`data_center` ON
(image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = da
ta_center.id) left join `cloud`.`launch_permission` ON
launch_permission.template_id = vm_template.id left join
`cloud`.`resource_tags` ON resource_tags.resource_id = vm_template.id
and (resource_tags.resource_type = 'Template' or
resource_tags.resource_type='ISO')
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.nam
e 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 resourc
e_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: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_u
uid, 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 s
torage_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
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
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_temp
late.removed, vm_template.enable_sshkey, source_template.id
source_template_id, source_template.uuid source_template_uuid,
account.id account_id, account.uuid account_uuid,
account.account_name account_name, account.type account_type,
domain.id domain_id, domain.uuid domain_uuid, domain.name
domain_name, domain.path domain_path, projects.id project_id,
projects.uuid project_uuid, projects.name project_name,
data_center.id data_center_id, data_center.uuid data_center_uuid,
data_center.name data_center_name, launch_permission.account_id
lp_account_id, template_store_ref.store_id, image_store.scope
as store_scope, template_store_ref.state,
template_store_ref.download_state, template_store_ref.download_pct,
template_store_ref.error_str, template_store_ref.size,
template_store_ref.de
stroyed, template_store_ref.created created_on_store,
vm_template_details.name detail_name, vm_template_details.value
detail_value, resource_tags.id tag_id, resource_tags.uuid
tag_uuid, resource_tags.key tag_key, resource_tags.value
tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id, resource_tags.resource_id
tag_resource_id, resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, CONCAT(vm_template.id, '_', IFNULL(data_center.id, 0)) as
temp_zone_pair from `cloud`.`vm_template` inner join
`cloud`.`guest_os` ON guest_os.id = vm_template.guest_os_id
inner join `cloud`.`account` ON account.id = vm_template.account_id
inner join `cloud`.`domain` ON domain.id = account.domain_id
lef
t join `cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`vm_template_details` ON
vm_template_details.template_id = vm_template.id left join
`cloud`.`vm_template` source_template ON source_template.id =
vm_template.source_template_id left join
`cloud`.`template_store_ref` ON template_store_ref.template_id = vm_template.id
and template_store_ref.store_role = 'Image' and template_store_ref.destroyed=0
left join `cloud`.`image_store` ON image_store.removed is
NULL AND template_store_ref.store_id is not NULL AND image_store.id =
template_store_ref.store_id left join
`cloud`.`template_zone_ref` ON template_zone_ref.template_id = vm_template.id
AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null
left join `cloud`.`data_center` ON
(image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = da
ta_center.id) left join `cloud`.`launch_permission` ON
launch_permission.template_id = vm_template.id left join
`cloud`.`resource_tags` ON resource_tags.resource_id = vm_template.id
and (resource_tags.resource_type = 'Template' or
resource_tags.resource_type='ISO')
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` A
S `domain_path`, `projects`.`id` AS `project_id`,
`projects`.`uuid` AS `project_uuid`, `projects`.`name` AS
`project_name`, `data_center`.`id` AS `data_center_id`,
`data_center`.`uuid` AS `data_center_uuid`, `data_center`.`name` AS
`data_center_name`, `launch_permission`.`account_id` AS
`lp_account_id`, `template_store_ref`.`store_id` AS `store_id`,
`image_store`.`scope` AS `store_scope`, `template_store_ref`.`state` AS
`state`, `template_store_ref`.`download_state` AS `download_state`,
`template_store_ref`.`download_pct` AS `download_pct`,
`template_store_ref`.`error_str` AS `error_str`,
`template_store_ref`.`size` AS `size`, `template_store_ref`.`destroyed`
AS `destroyed`, `template_store_ref`.`created` AS `created_on_store`,
`vm_template_details`.`name` AS `detail_name`,
`vm_template_details`.`value` AS `detail_value`, `resource_t
ags`.`id` AS `tag_id`, `resource_tags`.`uuid` AS `tag_uuid`,
`resource_tags`.`key` AS `tag_key`, `resource_tags`.`value` AS
`tag_value`, `resource_tags`.`domain_id` AS `tag_domain_id`,
`domain`.`uuid` AS `tag_domain_uuid`, `domain`.`name` AS
`tag_domain_name`, `resource_tags`.`account_id` AS `tag_account_id`,
`account`.`account_name` AS `tag_account_name`,
`resource_tags`.`resource_id` AS `tag_resource_id`,
`resource_tags`.`resource_uuid` AS `tag_resource_uuid`,
`resource_tags`.`resource_type` AS `tag_resource_type`,
`resource_tags`.`customer` AS `tag_customer`,
CONCAT(`vm_template`.`id`, '_',
IFNULL(`data_center`.`id`, 0)) AS `temp_zone_pair` FROM
((((((((((((`vm_template` JOIN `guest_os` ON ((`guest_os`.`id` =
`vm_template`.`guest_os_id`))) JOIN `account` ON ((`account`.`id` =
`vm_template`.`account_id`))) JOIN
`domain` ON ((`domain`.`id` = `account`.`domain_id`))) LEFT JOIN
`projects` ON ((`projects`.`project_account_id` = `account`.`id`)))
LEFT JOIN `vm_template_details` ON ((`vm_template_details`.`template_id` =
`vm_template`.`id`))) LEFT JOIN `vm_template` `source_template` ON
((`source_template`.`id` = `vm_template`.`source_template_id`))) LEFT
JOIN `template_store_ref` ON (((`template_store_ref`.`template_id` =
`vm_template`.`id`) AND (`template_store_ref`.`store_role` =
'Image') AND (`template_store_ref`.`destroyed` = 0)))) LEFT
JOIN `image_store` ON ((ISNULL(`image_store`.`removed`) AND
(`template_store_ref`.`store_id` IS NOT NULL) AND
(`image_store`.`id` = `template_store_ref`.`store_id`)))) LEFT JOIN
`template_zone_ref` ON (((`template_zone_ref`.`template_id` =
`vm_template`.`id`) AND ISNULL(`template_store_ref`.`store_id`)
AND ISNULL(`template_zone_ref`.`remove
d`)))) LEFT JOIN `data_center` ON (((`image_store`.`data_center_id` =
`data_center`.`id`) OR (`template_zone_ref`.`zone_id` =
`data_center`.`id`)))) LEFT JOIN `launch_permission` ON
((`launch_permission`.`template_id` = `vm_template`.`id`))) LEFT JOIN
`resource_tags` ON (((`resource_tags`.`resource_id` = `vm_template`.`id`)
AND ((`resource_tags`.`resource_type` = 'Template') OR
(`resource_tags`.`resource_type` = 'ISO')))))
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`.`acco
unt_name` AS `account_name`, `account`.`type` AS `account_type`,
`domain`.`id` AS `domain_id`, `domain`.`uuid` AS `domain_uuid`,
`domain`.`name` AS `domain_name`, `domain`.`path` AS `domain_path`,
`projects`.`id` AS `project_id`, `projects`.`uuid` AS
`project_uuid`, `projects`.`name` AS `project_name`,
`data_center`.`id` AS `data_center_id`, `data_center`.`uuid` AS
`data_center_uuid`, `data_center`.`name` AS `data_center_name`,
`data_center`.`networktype` AS `data_center_type`, `vm_instance`.`id`
AS `vm_id`, `vm_instance`.`uuid` AS `vm_uuid`,
`vm_instance`.`name` AS `vm_name`, `vm_instance`.`state` AS `vm_state`,
`vm_instance`.`vm_type` AS `vm_type`, `user_vm`.`display_name`
AS `vm_display_name`, `volume_store_ref`.`size` AS `volume_store_size`,
`volume_store_ref`.`download_pct` AS `download_pct`,
`volume_store_ref`.`
download_state` AS `download_state`, `volume_store_ref`.`error_str` AS
`error_str`, `volume_store_ref`.`created` AS `created_on_store`,
`disk_offering`.`id` AS `disk_offering_id`, `disk_offering`.`uuid` AS
`disk_offering_uuid`, `disk_offering`.`name` AS `disk_offering_name`,
`disk_offering`.`display_text` AS `disk_offering_display_text`,
`disk_offering`.`use_local_storage` AS `use_local_storage`,
`disk_offering`.`system_use` AS `system_use`,
`disk_offering`.`bytes_read_rate` AS `bytes_read_rate`,
`disk_offering`.`bytes_write_rate` AS `bytes_write_rate`,
`disk_offering`.`iops_read_rate` AS `iops_read_rate`,
`disk_offering`.`iops_write_rate` AS `iops_write_rate`,
`disk_offering`.`cache_mode` AS `cache_mode`, `storage_pool`.`id` AS
`pool_id`, `storage_pool`.`uuid` AS `pool_uuid`,
`storage_pool`.`name` AS `pool_name`, `cluster`.`hypervisor_type` AS
`hyp
ervisor_type`, `vm_template`.`id` AS `template_id`,
`vm_template`.`uuid` AS `template_uuid`, `vm_template`.`extractable` AS
`extractable`, `vm_template`.`type` AS `template_type`,
`vm_template`.`name` AS `template_name`, `vm_template`.`display_text`
AS `template_display_text`, `iso`.`id` AS `iso_id`,
`iso`.`uuid` AS `iso_uuid`, `iso`.`name` AS `iso_name`,
`iso`.`display_text` AS `iso_display_text`, `resource_tags`.`id` AS
`tag_id`, `resource_tags`.`uuid` AS `tag_uuid`,
`resource_tags`.`key` AS `tag_key`, `resource_tags`.`value` AS
`tag_value`, `resource_tags`.`domain_id` AS `tag_domain_id`,
`domain`.`uuid` AS `tag_domain_uuid`, `domain`.`name` AS
`tag_domain_name`, `resource_tags`.`account_id` AS `tag_account_id`,
`account`.`account_name` AS `tag_account_name`,
`resource_tags`.`resource_id` AS `tag_resource_id`, `reso
urce_tags`.`resource_uuid` AS `tag_resource_uuid`,
`resource_tags`.`resource_type` AS `tag_resource_type`,
`resource_tags`.`customer` AS `tag_customer`, `async_job`.`id` AS
`job_id`, `async_job`.`uuid` AS `job_uuid`,
`async_job`.`job_status` AS `job_status`, `async_job`.`account_id` AS
`job_account_id` FROM ((((((((((((((`volumes` JOIN
`account` ON ((`volumes`.`account_id` = `account`.`id`))) JOIN `domain`
ON ((`volumes`.`domain_id` = `domain`.`id`))) LEFT JOIN `projects` ON
((`projects`.`project_account_id` = `account`.`id`))) LEFT JOIN
`data_center` ON ((`volumes`.`data_center_id` = `data_center`.`id`)))
LEFT JOIN `vm_instance` ON ((`volumes`.`instance_id` = `vm_instance`.`id`)))
LEFT JOIN `user_vm` ON ((`user_vm`.`id` = `vm_instance`.`id`)))
LEFT JOIN `volume_store_ref` ON ((`volumes`.`id` =
`volume_store_ref`.`volume_id`))) LEFT JOIN `disk_offering` ON ((`v
olumes`.`disk_offering_id` = `disk_offering`.`id`))) LEFT JOIN
`storage_pool` ON ((`volumes`.`pool_id` = `storage_pool`.`id`))) LEFT
JOIN `cluster` ON ((`storage_pool`.`cluster_id` = `cluster`.`id`)))
LEFT JOIN `vm_template` ON ((`volumes`.`template_id` = `vm_template`.`id`)))
LEFT JOIN `vm_template` `iso` ON ((`iso`.`id` = `volumes`.`iso_id`)))
LEFT JOIN `resource_tags` ON (((`resource_tags`.`resource_id` =
`volumes`.`id`) AND (`resource_tags`.`resource_type` = 'Volume'))))
LEFT JOIN `async_job` ON (((`async_job`.`instance_id` = `volumes`.`id`)
AND (`async_job`.`instance_type` = 'Volume') AND
(`async_job`.`job_status` = 0))))
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
data_center_uuid, data_center.name data_center_name,
data_center.networktype data_center_type, vm_instance.id vm_id,
vm_instance.uuid vm_uuid, vm_instance.name vm_name,
vm_instance.state vm_state, vm_instance.vm_type,
user_vm.display_name vm_display_name, volume_store_ref.size
volume_store_size, volume_store_ref.download_pct,
volume_store_ref.download_state, volume_store_ref.error_str,
volume_store_ref.created created_on_store, disk_offering.id
disk_offering_id, disk_offering.uuid disk_offering_uuid,
disk_offering.name disk_offering_name, disk_offering.display_text
disk_offering_display_text, disk_offering.use_local_storage,
disk_offering.system_use, disk_offering.bytes_read_rate,
disk_offering.bytes_write_rate, disk_offering.iops_read_rate,
disk_offering.iops_write_rate, disk_offering.cache_m
ode, storage_pool.id pool_id, storage_pool.uuid pool_uuid,
storage_pool.name pool_name, cluster.id cluster_id,
cluster.name cluster_name, cluster.uuid cluster_uuid,
cluster.hypervisor_type, vm_template.id template_id,
vm_template.uuid template_uuid, vm_template.extractable,
vm_template.type template_type, vm_template.name template_name,
vm_template.display_text template_display_text, iso.id iso_id,
iso.uuid iso_uuid, iso.name iso_name, iso.display_text
iso_display_text, resource_tags.id tag_id, resource_tags.uuid
tag_uuid, resource_tags.key tag_key, resource_tags.value
tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id, resource_tags.resource_id
tag_resource_id, resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_
resource_type, resource_tags.customer tag_customer,
async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id job_account_id,
host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid,
host_pod_ref.name pod_name, resource_tag_account.account_name
tag_account_name, resource_tag_domain.uuid tag_domain_uuid,
resource_tag_domain.name tag_domain_name from `cloud`.`volumes`
inner join `cloud`.`account` ON volumes.account_id = account.id
inner join `cloud`.`domain` ON volumes.domain_id =
domain.id left join `cloud`.`projects` ON
projects.project_account_id = account.id left join
`cloud`.`data_center` ON volumes.data_center_id = data_center.id
left join `cloud`.`vm_instance` ON volumes.instance_id = vm_instance.id
left join `cloud`.`user_vm
` ON user_vm.id = vm_instance.id left join
`cloud`.`volume_store_ref` ON volumes.id = volume_store_ref.volume_id
left join `cloud`.`disk_offering` ON volumes.disk_offering_id =
disk_offering.id left join `cloud`.`storage_pool` ON
volumes.pool_id = storage_pool.id left join
`cloud`.`host_pod_ref` ON storage_pool.pod_id = host_pod_ref.id
left join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id
left join `cloud`.`vm_template` ON volumes.template_id =
vm_template.id left join `cloud`.`vm_template` iso ON
iso.id = volumes.iso_id left join `cloud`.`resource_tags`
ON resource_tags.resource_id = volumes.id and
resource_tags.resource_type = 'Volume' left join
`cloud`.`async_job` ON async_job.instance_id = volumes.id and
async_job.instance_type = 'Volume' and async_job.
job_status = 0 left join `cloud`.`account`
resource_tag_account ON resource_tag_account.id = resource_tags.account_id
left join `cloud`.`domain` resource_tag_domain ON
resource_tag_domain.id = resource_tags.domain_id
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 `ac
count_type`, `domain`.`id` AS `domain_id`, `domain`.`uuid`
AS `domain_uuid`, `domain`.`name` AS `domain_name`,
`domain`.`path` AS `domain_path`, `projects`.`id` AS `project_id`,
`projects`.`uuid` AS `project_uuid`, `projects`.`name` AS
`project_name`, `data_center`.`id` AS `data_center_id`,
`data_center`.`uuid` AS `data_center_uuid`, `data_center`.`name` AS
`data_center_name`, `launch_permission`.`account_id` AS
`lp_account_id`, `template_store_ref`.`store_id` AS `store_id`,
`image_store`.`scope` AS `store_scope`, `template_store_ref`.`state`
AS `state`, `template_store_ref`.`download_state` AS `download_state`,
`template_store_ref`.`download_pct` AS `download_pct`,
`template_store_ref`.`error_str` AS `error_str`,
`template_store_ref`.`size` AS `size`,
`template_store_ref`.physical_size AS `physical_size`,
`template_store_ref`.`destroyed` AS `destroyed`,
`template_store_ref`.`created` AS `created_on_store`,
`vm_template_details`.`name` AS `detail_name`,
`vm_template_details`.`value` AS `detail_value`, `resource_tags`.`id`
AS `tag_id`, `resource_tags`.`uuid` AS `tag_uuid`,
`resource_tags`.`key` AS `tag_key`, `resource_tags`.`value` AS
`tag_value`, `resource_tags`.`domain_id` AS `tag_domain_id`,
`domain`.`uuid` AS `tag_domain_uuid`, `domain`.`name` AS
`tag_domain_name`, `resource_tags`.`account_id` AS `tag_account_id`,
`account`.`account_name` AS `tag_account_name`,
`resource_tags`.`resource_id` AS `tag_resource_id`,
`resource_tags`.`resource_uuid` AS `tag_resource_uuid`,
`resource_tags`.`resource_type` AS `tag_resource_type`,
`resource_tags`.`customer` AS `tag_customer`,
CONCAT(`vm_template`.`id`, '_',
IFNULL(`data_center`.`id`, 0)) AS `temp_zone_pair`,
`vm_template`.`direct_download` AS `direct_download` FROM
(((((((((((((`vm_template` JOIN `guest_os` ON ((`guest_os`.`id` =
`vm_template`.`guest_os_id`))) JOIN `account` ON ((`account`.`id` =
`vm_template`.`account_id`))) JOIN `domain` ON ((`domain`.`id` =
`account`.`domain_id`))) LEFT JOIN `projects` ON
((`projects`.`project_account_id` = `account`.`id`))) LEFT JOIN
`vm_template_details` ON ((`vm_template_details`.`template_id` =
`vm_template`.`id`))) LEFT JOIN `vm_template` `source_template` ON
((`source_template`.`id` = `vm_template`.`source_template_id`))) LEFT
JOIN `template_store_ref` ON (((`template_store_ref`.`template_id` =
`vm_template`.`id`) AND (`template_store_ref`.`store_role` =
'Image') AND (`template_store_ref`.`destroyed` = 0))))
LEFT JOIN `vm_template` `parent_template` ON ((`parent_template
`.`id` = `vm_template`.`parent_template_id`))) LEFT JOIN
`image_store` ON ((ISNULL(`image_store`.`removed`) AND
(`template_store_ref`.`store_id` IS NOT NULL) AND
(`image_store`.`id` = `template_store_ref`.`store_id`)))) LEFT JOIN
`template_zone_ref` ON (((`template_zone_ref`.`template_id` =
`vm_template`.`id`) AND ISNULL(`template_store_ref`.`store_id`)
AND ISNULL(`template_zone_ref`.`removed`)))) LEFT JOIN
`data_center` ON (((`image_store`.`data_center_id` = `data_center`.`id`)
OR (`template_zone_ref`.`zone_id` = `data_center`.`id`)))) LEFT
JOIN `launch_permission` ON ((`launch_permission`.`template_id` =
`vm_template`.`id`))) LEFT JOIN `resource_tags` ON
(((`resource_tags`.`resource_id` = `vm_template`.`id`) AND
((`resource_tags`.`resource_type` = 'Template') OR
(`resource_tags`.`resource_type` = 'ISO')))))
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 `ac
count_type`, `domain`.`id` AS `domain_id`, `domain`.`uuid`
AS `domain_uuid`, `domain`.`name` AS `domain_name`,
`domain`.`path` AS `domain_path`, `projects`.`id` AS `project_id`,
`projects`.`uuid` AS `project_uuid`, `projects`.`name` AS
`project_name`, `data_center`.`id` AS `data_center_id`,
`data_center`.`uuid` AS `data_center_uuid`, `data_center`.`name` AS
`data_center_name`, `launch_permission`.`account_id` AS
`lp_account_id`, `template_store_ref`.`store_id` AS `store_id`,
`image_store`.`scope` AS `store_scope`, `template_store_ref`.`state`
AS `state`, `template_store_ref`.`download_state` AS `download_state`,
`template_store_ref`.`download_pct` AS `download_pct`,
`template_store_ref`.`error_str` AS `error_str`,
`template_store_ref`.`size` AS `size`,
`template_store_ref`.physical_size AS `physical_size`,
`template_store_ref`.`destroyed` AS `destroyed`,
`template_store_ref`.`created` AS `created_on_store`,
`vm_template_details`.`name` AS `detail_name`,
`vm_template_details`.`value` AS `detail_value`, `resource_tags`.`id`
AS `tag_id`, `resource_tags`.`uuid` AS `tag_uuid`,
`resource_tags`.`key` AS `tag_key`, `resource_tags`.`value` AS
`tag_value`, `resource_tags`.`domain_id` AS `tag_domain_id`,
`domain`.`uuid` AS `tag_domain_uuid`, `domain`.`name` AS
`tag_domain_name`, `resource_tags`.`account_id` AS `tag_account_id`,
`account`.`account_name` AS `tag_account_name`,
`resource_tags`.`resource_id` AS `tag_resource_id`,
`resource_tags`.`resource_uuid` AS `tag_resource_uuid`,
`resource_tags`.`resource_type` AS `tag_resource_type`,
`resource_tags`.`customer` AS `tag_customer`,
CONCAT(`vm_template`.`id`, '_',
IFNULL(`data_center`.`id`, 0)) AS `temp_zone_pair`,
`vm_template`.`direct_download` AS `direct_download`,
`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
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_t
ype` = '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_cent
er_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_r
ate, 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`.`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
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: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 `ac
count_type`, `domain`.`id` AS `domain_id`, `domain`.`uuid`
AS `domain_uuid`, `domain`.`name` AS `domain_name`,
`domain`.`path` AS `domain_path`, `projects`.`id` AS `project_id`,
`projects`.`uuid` AS `project_uuid`, `projects`.`name` AS
`project_name`, `data_center`.`id` AS `data_center_id`,
`data_center`.`uuid` AS `data_center_uuid`, `data_center`.`name` AS
`data_center_name`, `launch_permission`.`account_id` AS
`lp_account_id`, `template_store_ref`.`store_id` AS `store_id`,
`image_store`.`scope` AS `store_scope`, `template_store_ref`.`state`
AS `state`, `template_store_ref`.`download_state` AS `download_state`,
`template_store_ref`.`download_pct` AS `download_pct`,
`template_store_ref`.`error_str` AS `error_str`,
`template_store_ref`.`size` AS `size`,
`template_store_ref`.physical_size AS `physical_size`,
`template_store_ref`.`destroyed` AS `destroyed`,
`template_store_ref`.`created` AS `created_on_store`,
`vm_template_details`.`name` AS `detail_name`,
`vm_template_details`.`value` AS `detail_value`, `resource_tags`.`id`
AS `tag_id`, `resource_tags`.`uuid` AS `tag_uuid`,
`resource_tags`.`key` AS `tag_key`, `resource_tags`.`value` AS
`tag_value`, `resource_tags`.`domain_id` AS `tag_domain_id`,
`domain`.`uuid` AS `tag_domain_uuid`, `domain`.`name` AS
`tag_domain_name`, `resource_tags`.`account_id` AS `tag_account_id`,
`account`.`account_name` AS `tag_account_name`,
`resource_tags`.`resource_id` AS `tag_resource_id`,
`resource_tags`.`resource_uuid` AS `tag_resource_uuid`,
`resource_tags`.`resource_type` AS `tag_resource_type`,
`resource_tags`.`customer` AS `tag_customer`,
CONCAT(`vm_template`.`id`, '_',
IFNULL(`data_center`.`id`, 0)) AS `temp_zone_pair`,
`vm_template`.`direct_download` AS `direct_download`,
`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_templat
e`.`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"
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
