kenneth0595 commented on issue #7358:
URL: https://github.com/apache/cloudstack/issues/7358#issuecomment-1480341753
@kiwiflyer
[root@Cloud-Host01 ~]# grep -i -E 'error|exception'
/var/log/cloudstack/management/management-server.log
2023-03-22 12:32:20,130 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
2023-03-22 12:32:21,031 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
2023-03-22 12:32:21,502 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
2023-03-22 12:32:21,553 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
2023-03-22 12:32:21,583 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
2023-03-22 12:32:23,049 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS select volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.size, volumes.min_iops,
volumes.max_iops, volumes.created, volumes.state,
volumes.attached, volumes.removed, volumes.pod_id,
volumes.display_volume, volumes.format, account.id account_id,
account.uuid account_uuid, account.account_name account_name,
account.type account_type, domain.id domain_id,
domain.uuid domain_uuid, domain.name domain_name, domain.path
domain_path, projects.id project_id, projects.uuid
project_uuid, projects.name project_name, data_center.id
data_center_id, data_center.uuid data_center_uuid,
data_center.name data_center_name, data_
center.networktype data_center_type, vm_instance.id vm_id,
vm_instance.uuid vm_uuid, vm_instance.name vm_name,
vm_instance.state vm_state, vm_instance.vm_type,
user_vm.display_name vm_display_name, volume_store_ref.size
volume_store_size, volume_store_ref.download_pct,
volume_store_ref.download_state, volume_store_ref.error_str,
volume_store_ref.created created_on_store, disk_offering.id
disk_offering_id, disk_offering.uuid disk_offering_uuid,
disk_offering.name disk_offering_name, disk_offering.display_text
disk_offering_display_text, disk_offering.use_local_storage,
disk_offering.system_use, disk_offering.bytes_read_rate,
disk_offering.bytes_write_rate, disk_offering.iops_read_rate,
disk_offering.iops_write_rate, storage_pool.id pool_id,
storage_pool.uuid pool_uuid, storage_pool.name pool_nam
e, cluster.hypervisor_type, vm_template.id template_id,
vm_template.uuid template_uuid, vm_template.extractable,
vm_template.type template_type, resource_tags.id tag_id,
resource_tags.uuid tag_uuid, resource_tags.key tag_key,
resource_tags.value tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id,
resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid
tag_resource_uuid, resource_tags.resource_type tag_resource_type,
resource_tags.customer tag_customer, async_job.id job_id,
async_job.uuid job_uuid, async_job.job_status job_status,
async_job.account_id job_account_id from `cloud`.`volumes`
inner join `cloud`.`account` ON volumes.account_id = account.id
inner join `cloud`.`domain` ON volumes.domain_id = domain.id
left jo
in `cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`data_center` ON volumes.data_center_id =
data_center.id left join `cloud`.`vm_instance` ON
volumes.instance_id = vm_instance.id left join
`cloud`.`user_vm` ON user_vm.id = vm_instance.id left join
`cloud`.`volume_store_ref` ON volumes.id = volume_store_ref.volume_id
left join `cloud`.`disk_offering` ON volumes.disk_offering_id =
disk_offering.id left join `cloud`.`storage_pool` ON
volumes.pool_id = storage_pool.id left join
`cloud`.`cluster` ON storage_pool.cluster_id = cluster.id left join
`cloud`.`vm_template` ON volumes.template_id = vm_template.id OR
volumes.iso_id = vm_template.id left join
`cloud`.`resource_tags` ON resource_tags.resource_id = volumes.id
and resource_tags.resource_type = 'Volume'
left join `cloud`.`async_job` ON async_job.instance_id =
volumes.id and async_job.instance_type = 'Volume' and
async_job.job_status = 0
2023-03-22 12:32:23,109 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`template_view` AS select vm_template.id,
vm_template.uuid, vm_template.unique_name, vm_template.name,
vm_template.public, vm_template.featured,
vm_template.type, vm_template.hvm, vm_template.bits,
vm_template.url, vm_template.format, vm_template.created,
vm_template.checksum, vm_template.display_text,
vm_template.enable_password, vm_template.dynamically_scalable,
vm_template.guest_os_id, guest_os.uuid guest_os_uuid,
guest_os.display_name guest_os_name, vm_template.bootable,
vm_template.prepopulate, vm_template.cross_zones,
vm_template.hypervisor_type, vm_template.extractable,
vm_template.template_tag, vm_template.sort_key,
vm_template.removed, vm_template.enable_
sshkey, source_template.id source_template_id,
source_template.uuid source_template_uuid, account.id account_id,
account.uuid account_uuid, account.account_name account_name,
account.type account_type, domain.id domain_id, domain.uuid
domain_uuid, domain.name domain_name, domain.path domain_path,
projects.id project_id, projects.uuid project_uuid,
projects.name project_name, data_center.id data_center_id,
data_center.uuid data_center_uuid, data_center.name
data_center_name, launch_permission.account_id lp_account_id,
template_store_ref.store_id, image_store.scope as store_scope,
template_store_ref.state, template_store_ref.download_state,
template_store_ref.download_pct, template_store_ref.error_str,
template_store_ref.size, template_store_ref.destroyed,
template_store_ref.cre
ated created_on_store, vm_template_details.name detail_name,
vm_template_details.value detail_value, resource_tags.id tag_id,
resource_tags.uuid tag_uuid, resource_tags.key tag_key,
resource_tags.value tag_value, resource_tags.domain_id tag_domain_id,
resource_tags.account_id tag_account_id,
resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid
tag_resource_uuid, resource_tags.resource_type tag_resource_type,
resource_tags.customer tag_customer, CONCAT(vm_template.id, '_',
IFNULL(data_center.id, 0)) as temp_zone_pair from
`cloud`.`vm_template` inner join `cloud`.`guest_os` ON
guest_os.id = vm_template.guest_os_id inner join
`cloud`.`account` ON account.id = vm_template.account_id inner join
`cloud`.`domain` ON domain.id = account.domain_id left join
`cloud`.`projects` ON
projects.project_account_id = account.id left join
`cloud`.`vm_template_details` ON vm_template_details.template_id =
vm_template.id left join `cloud`.`vm_template`
source_template ON source_template.id = vm_template.source_template_id
left join `cloud`.`template_store_ref` ON
template_store_ref.template_id = vm_template.id and
template_store_ref.store_role = 'Image' left join
`cloud`.`image_store` ON image_store.removed is NULL AND
template_store_ref.store_id is not NULL AND image_store.id =
template_store_ref.store_id left join
`cloud`.`template_zone_ref` ON template_zone_ref.template_id = vm_template.id
AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null
left join `cloud`.`data_center` ON
(image_store.data_center_id = data_center.id OR template_zone_ref.zone_id =
data_center.id) left join `cloud`.`
launch_permission` ON launch_permission.template_id = vm_template.id
left join `cloud`.`resource_tags` ON resource_tags.resource_id =
vm_template.id and (resource_tags.resource_type = 'Template' or
resource_tags.resource_type='ISO')
2023-03-22 12:32:23,627 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
2023-03-22 12:32:23,627 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
2023-03-22 12:32:23,639 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
2023-03-22 12:32:23,640 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
2023-03-22 12:32:23,641 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
2023-03-22 12:32:23,643 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
2023-03-22 12:32:23,644 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
2023-03-22 12:32:23,645 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
2023-03-22 12:32:23,648 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
2023-03-22 12:32:23,651 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
2023-03-22 12:32:23,652 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
2023-03-22 12:32:23,654 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
2023-03-22 12:32:23,655 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
2023-03-22 12:32:23,876 INFO [c.c.u.d.Upgrade410to420] (main:null) (logid:)
migrateDatafromIsoIdInVolumesTable: ignoring Exception: Unknown column
'iso_id1' in 'field list'
2023-03-22 12:32:24,903 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')
2023-03-22 12:32:24,906 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS select volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.size, volumes.min_iops,
volumes.max_iops, volumes.created, volumes.state,
volumes.attached, volumes.removed, volumes.pod_id,
volumes.display_volume, volumes.format, volumes.path,
account.id account_id, account.uuid account_uuid,
account.account_name account_name, account.type account_type,
domain.id domain_id, domain.uuid domain_uuid, domain.name
domain_name, domain.path domain_path, projects.id project_id,
projects.uuid project_uuid, projects.name project_name,
data_center.id data_center_id, data_center.uuid data_center_uuid,
data_center.name data_cent
er_name, data_center.networktype data_center_type,
vm_instance.id vm_id, vm_instance.uuid vm_uuid,
vm_instance.name vm_name, vm_instance.state vm_state,
vm_instance.vm_type, user_vm.display_name vm_display_name,
volume_store_ref.size volume_store_size, volume_store_ref.download_pct,
volume_store_ref.download_state, volume_store_ref.error_str,
volume_store_ref.created created_on_store, disk_offering.id
disk_offering_id, disk_offering.uuid disk_offering_uuid,
disk_offering.name disk_offering_name, disk_offering.display_text
disk_offering_display_text, disk_offering.use_local_storage,
disk_offering.system_use, disk_offering.bytes_read_rate,
disk_offering.bytes_write_rate, disk_offering.iops_read_rate,
disk_offering.iops_write_rate, storage_pool.id pool_id,
storage_pool.uuid pool_uuid, storage_poo
l.name pool_name, cluster.hypervisor_type, vm_template.id
template_id, vm_template.uuid template_uuid,
vm_template.extractable, vm_template.type template_type,
resource_tags.id tag_id, resource_tags.uuid tag_uuid,
resource_tags.key tag_key, resource_tags.value tag_value,
resource_tags.domain_id tag_domain_id, resource_tags.account_id
tag_account_id, resource_tags.resource_id tag_resource_id,
resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`volumes` inner join
`cloud`.`account` ON volumes.account_id = account.id inner join
`cloud`.`domain` ON volumes.domain_id = domain.id
left join `cloud`.`projects` ON projects.project_account_id =
account.id left join `cloud`.`data_center` ON
volumes.data_center_id = data_center.id left join
`cloud`.`vm_instance` ON volumes.instance_id = vm_instance.id left
join `cloud`.`user_vm` ON user_vm.id = vm_instance.id left
join `cloud`.`volume_store_ref` ON volumes.id =
volume_store_ref.volume_id left join
`cloud`.`disk_offering` ON volumes.disk_offering_id = disk_offering.id
left join `cloud`.`storage_pool` ON volumes.pool_id =
storage_pool.id left join `cloud`.`cluster` ON
storage_pool.cluster_id = cluster.id left join
`cloud`.`vm_template` ON volumes.template_id = vm_template.id OR volumes.iso_id
= vm_template.id left join `cloud`.`resource_tags` ON
resource_tags.resource_id = volumes.id and resource_tags.resource_t
ype = 'Volume' left join `cloud`.`async_job` ON
async_job.instance_id = volumes.id and async_job.instance_type =
'Volume' and async_job.job_status = 0
2023-03-22 12:32:25,490 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`volume_view` AS select volumes.id,
volumes.uuid, volumes.name, volumes.device_id,
volumes.volume_type, volumes.size, volumes.min_iops,
volumes.max_iops, volumes.created, volumes.state,
volumes.attached, volumes.removed, volumes.pod_id,
volumes.display_volume, volumes.format, volumes.path,
volumes.chain_info, account.id account_id, account.uuid
account_uuid, account.account_name account_name, account.type
account_type, domain.id domain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,
projects.id project_id, projects.uuid project_uuid,
projects.name project_name, data_center.id data_center_id,
data_center.uuid data_center_uuid,
data_center.name data_center_name, data_center.networktype
data_center_type, vm_instance.id vm_id, vm_instance.uuid
vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state,
vm_instance.vm_type, user_vm.display_name vm_display_name,
volume_store_ref.size volume_store_size,
volume_store_ref.download_pct, volume_store_ref.download_state,
volume_store_ref.error_str, volume_store_ref.created created_on_store,
disk_offering.id disk_offering_id, disk_offering.uuid
disk_offering_uuid, disk_offering.name disk_offering_name,
disk_offering.display_text disk_offering_display_text,
disk_offering.use_local_storage, disk_offering.system_use,
disk_offering.bytes_read_rate, disk_offering.bytes_write_rate,
disk_offering.iops_read_rate, disk_offering.iops_write_rate,
disk_offering.cache_mode, storage_
pool.id pool_id, storage_pool.uuid pool_uuid,
storage_pool.name pool_name, cluster.hypervisor_type,
vm_template.id template_id, vm_template.uuid template_uuid,
vm_template.extractable, vm_template.type template_type,
vm_template.name template_name, vm_template.display_text
template_display_text, iso.id iso_id, iso.uuid iso_uuid,
iso.name iso_name, iso.display_text iso_display_text,
resource_tags.id tag_id, resource_tags.uuid tag_uuid,
resource_tags.key tag_key, resource_tags.value tag_value,
resource_tags.domain_id tag_domain_id, resource_tags.account_id
tag_account_id, resource_tags.resource_id tag_resource_id,
resource_tags.resource_uuid tag_resource_uuid,
resource_tags.resource_type tag_resource_type, resource_tags.customer
tag_customer, async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`volumes` inner join
`cloud`.`account` ON volumes.account_id = account.id inner join
`cloud`.`domain` ON volumes.domain_id = domain.id left join
`cloud`.`projects` ON projects.project_account_id = account.id
left join `cloud`.`data_center` ON volumes.data_center_id =
data_center.id left join `cloud`.`vm_instance` ON
volumes.instance_id = vm_instance.id left join
`cloud`.`user_vm` ON user_vm.id = vm_instance.id left join
`cloud`.`volume_store_ref` ON volumes.id = volume_store_ref.volume_id
left join `cloud`.`disk_offering` ON volumes.disk_offering_id =
disk_offering.id left join `cloud`.`storage_pool` ON
volumes.pool_id = storage_pool.id left join
`cloud`.`cluster` ON storage_poo
l.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
2023-03-22 12:32:27,551 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
2023-03-22 12:32:27,607 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')
2023-03-22 12:32:30,396 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
2023-03-22 12:32:30,733 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')))))
2023-03-22 12:32:30,736 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))))
2023-03-22 12:32:31,954 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
2023-03-22 12:32:32,147 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')))))
2023-03-22 12:32:32,301 ERROR [c.c.u.PropertiesUtil] (main:null) (logid:)
Unable to find properties file: commands.properties
2023-03-22 12:32:32,447 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
changed fingerprint type to TEXT, it avoids db exception when creating the
certificate issue #3123
2023-03-22 12:32:33,368 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')))))
2023-03-22 12:32:34,847 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
2023-03-22 12:32:35,820 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template',
'user_data', 'id')
2023-03-22 12:32:35,820 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key
in table '#sql-3755_b'
2023-03-22 12:32:35,821 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to execute upgrade script
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate
key in table '#sql-3755_b'
2023-03-22 12:32:35,824 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
script
Caused by: java.sql.SQLIntegrityConstraintViolationException: Can't write;
duplicate key in table '#sql-3755_b'
2023-03-22 12:54:31,236 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: ALTER TABLE `cloud`.`networks` ADD COLUMN `public_mtu` bigint
unsigned comment "MTU for VR public interface"
2023-03-22 12:54:31,237 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-22 12:54:31,238 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to execute upgrade script
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-22 12:54:31,241 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
script
Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name
'public_mtu'
2023-03-22 12:59:09,842 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: ALTER TABLE `cloud`.`networks` ADD COLUMN `public_mtu` bigint
unsigned comment "MTU for VR public interface"
2023-03-22 12:59:09,842 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-22 12:59:09,843 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to execute upgrade script
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-22 12:59:09,846 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
script
Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name
'public_mtu'
2023-03-22 13:35:43,354 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: ALTER TABLE `cloud`.`networks` ADD COLUMN `public_mtu` bigint
unsigned comment "MTU for VR public interface"
2023-03-22 13:35:43,354 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-22 13:35:43,355 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to execute upgrade script
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-22 13:35:43,358 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
script
Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name
'public_mtu'
2023-03-22 14:29:42,394 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: ALTER TABLE `cloud`.`networks` ADD COLUMN `public_mtu` bigint
unsigned comment "MTU for VR public interface"
2023-03-22 14:29:42,395 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-22 14:29:42,396 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to execute upgrade script
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-22 14:29:42,399 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
script
Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name
'public_mtu'
2023-03-23 07:20:40,100 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: ALTER TABLE `cloud`.`networks` ADD COLUMN `public_mtu` bigint
unsigned comment "MTU for VR public interface"
2023-03-23 07:20:40,101 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-23 07:20:40,102 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to execute upgrade script
java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
2023-03-23 07:20:40,105 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
script
Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name
'public_mtu'
# Access log
45.128.232.112 - - [22/Mar/2023:04:11:22 +0000] "GET / HTTP/1.1" 301 0 "-"
"Linux Gnu (cow)" 47
205.210.31.31 - - [22/Mar/2023:04:23:47 +0000] "GET / HTTP/1.0" 301 0 "-"
"Expanse, a Palo Alto Networks company, searches across the global IPv4 space
multiple times per day to identify customers' presences on the Internet. If
you would like to be excluded from our scans, please send IP addresses/domains
to: [email protected]" 3
43.158.217.52 - - [22/Mar/2023:04:25:22 +0000] "GET / HTTP/1.1" 301 0 "-"
"'Mozilla/5.0" 2
192.168.219.252 - - [22/Mar/2023:04:26:07 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.44" 19
192.168.219.252 - - [22/Mar/2023:04:26:07 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36 Edg/111.0.1661.44" 3
192.168.219.252 - - [22/Mar/2023:04:26:21 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.44" 3
192.168.219.252 - - [22/Mar/2023:04:26:21 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36 Edg/111.0.1661.44" 2
192.168.219.252 - - [22/Mar/2023:04:27:57 +0000] "GET
/client/api/?command=listIdps&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 4
192.168.219.252 - - [22/Mar/2023:04:28:13 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:28:13 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 3
192.168.219.252 - - [22/Mar/2023:04:28:45 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:28:45 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:28:55 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:28:55 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:29:23 +0000] "GET
/client/api/?command=listIdps&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:29:34 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 4
192.168.219.252 - - [22/Mar/2023:04:29:34 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:30:36 +0000] "GET
/client/api/?command=listIdps&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:30:54 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:30:54 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:31:07 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:31:07 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:32:04 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 3
192.168.219.252 - - [22/Mar/2023:04:32:04 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 3
192.168.219.252 - - [22/Mar/2023:04:32:10 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 3
192.168.219.252 - - [22/Mar/2023:04:32:10 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 3
192.168.219.252 - - [22/Mar/2023:04:32:16 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:32:16 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:32:33 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:32:33 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:32:39 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:32:39 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:32:45 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:32:45 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:33:02 +0000] "POST /client/api/
HTTP/1.1" 503 73 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT
10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:33:02 +0000] "GET
/client/api/?command=logout&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:50:23 +0000] "GET
/client/api/?command=listIdps&response=json HTTP/1.1" 503 73
"http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 59
192.168.219.252 - - [22/Mar/2023:04:51:00 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/111.0.0.0 Safari/537.36" 3
192.168.219.252 - - [22/Mar/2023:04:51:00 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:51:00 +0000] "GET /favicon.ico HTTP/1.1"
301 0 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows NT 10.0;
Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:51:00 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:51:06 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:51:07 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:51:07 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:51:17 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 3
192.168.219.252 - - [22/Mar/2023:04:51:24 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:51:24 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
211.226.15.92 - - [22/Mar/2023:04:51:48 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
211.226.15.92 - - [22/Mar/2023:04:51:48 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
211.226.15.92 - - [22/Mar/2023:04:51:49 +0000] "GET /favicon.ico HTTP/1.1"
301 0 "http://www.kitrocloud.com/client/"; "Mozilla/5.0 (Macintosh; Intel Mac OS
X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
211.226.15.92 - - [22/Mar/2023:04:51:49 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://www.kitrocloud.com/client/"; "Mozilla/5.0 (Macintosh;
Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
211.226.15.92 - - [22/Mar/2023:04:52:03 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 3
211.226.15.92 - - [22/Mar/2023:04:52:03 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://www.kitrocloud.com/client/"; "Mozilla/5.0 (Macintosh;
Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
211.226.15.92 - - [22/Mar/2023:04:57:34 +0000] "GET / HTTP/1.1" 301 0 "-"
"curl/7.86.0" 1
127.0.0.1 - - [22/Mar/2023:04:58:26 +0000] "GET / HTTP/1.1" 301 0 "-"
"curl/7.29.0" 1
192.168.219.253 - - [22/Mar/2023:04:58:48 +0000] "GET / HTTP/1.1" 301 0 "-"
"curl/7.29.0" 2
192.168.219.252 - - [22/Mar/2023:04:58:59 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:58:59 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:59:42 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:59:42 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:59:43 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:04:59:43 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:59:44 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:04:59:44 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:00:23 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:00:23 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:00:30 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:00:30 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.254 - - [22/Mar/2023:05:04:40 +0000] "GET / HTTP/1.1" 301 0 "-"
"curl/7.29.0" 2
192.168.219.254 - - [22/Mar/2023:05:04:49 +0000] "GET /client HTTP/1.1" 302
0 "-" "curl/7.29.0" 3
192.168.219.252 - - [22/Mar/2023:05:05:08 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:05:08 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:05:52 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:05:52 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:06:04 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:06:04 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:07:24 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:07:24 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:07:29 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 0
192.168.219.252 - - [22/Mar/2023:05:07:29 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 0
193.164.194.23 - - [22/Mar/2023:05:07:40 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/51.0.2704.103 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:10:02 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:10:02 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:11:01 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 3
192.168.219.252 - - [22/Mar/2023:05:11:01 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:11:03 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:11:03 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:11:04 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:11:04 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:11:05 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:11:05 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:11:06 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:11:06 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:11:07 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:11:07 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
46.101.78.241 - - [22/Mar/2023:05:14:37 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/108.0.0.0 Safari/537.36" 1
46.101.78.241 - - [22/Mar/2023:05:14:37 +0000] "GET /client/ HTTP/1.1" 503
394 "http://220.74.34.204/"; "Mozilla/5.0 (Windows NT 10.0; Win64; x64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36" 2
46.101.78.241 - - [22/Mar/2023:05:14:38 +0000] "GET /client/get_targets
HTTP/1.1" 503 405 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36" 1
46.101.78.241 - - [22/Mar/2023:05:14:38 +0000] "GET /upl.php HTTP/1.1" 301 0
"-" "Mozilla/5.0" 1
46.101.78.241 - - [22/Mar/2023:05:14:49 +0000] "GET /geoip/ HTTP/1.1" 301 0
"-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/108.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:15:39 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:15:39 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:15:41 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:15:41 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:15:42 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:15:42 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:15:43 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:15:43 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:15:43 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:15:43 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
192.168.219.252 - - [22/Mar/2023:05:15:45 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:15:45 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 1
211.226.15.92 - - [22/Mar/2023:05:16:03 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
211.226.15.92 - - [22/Mar/2023:05:16:03 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://www.kitrocloud.com/client/"; "Mozilla/5.0 (Macintosh;
Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
211.226.15.92 - - [22/Mar/2023:05:19:50 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
211.226.15.92 - - [22/Mar/2023:05:19:50 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://www.kitrocloud.com/client/"; "Mozilla/5.0 (Macintosh;
Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 3
211.226.15.92 - - [22/Mar/2023:05:21:11 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 2
211.226.15.92 - - [22/Mar/2023:05:21:11 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://www.kitrocloud.com/client/"; "Mozilla/5.0 (Macintosh;
Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
211.226.15.92 - - [22/Mar/2023:05:21:13 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 1
211.226.15.92 - - [22/Mar/2023:05:21:13 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://www.kitrocloud.com/client/"; "Mozilla/5.0 (Macintosh;
Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36" 2
192.168.219.252 - - [22/Mar/2023:05:21:30 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.44" 2
192.168.219.252 - - [22/Mar/2023:05:21:30 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36 Edg/111.0.1661.44" 1
192.168.219.252 - - [22/Mar/2023:05:21:36 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.44" 1
192.168.219.252 - - [22/Mar/2023:05:21:36 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36 Edg/111.0.1661.44" 1
192.168.219.252 - - [22/Mar/2023:05:21:51 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.44" 3
192.168.219.252 - - [22/Mar/2023:05:21:52 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36 Edg/111.0.1661.44" 1
192.168.219.252 - - [22/Mar/2023:05:22:07 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.44" 2
192.168.219.252 - - [22/Mar/2023:05:22:07 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0 (Windows
NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0
Safari/537.36 Edg/111.0.1661.44" 2
179.43.177.242 - - [22/Mar/2023:05:44:16 +0000] "GET / HTTP/1.1" 301 0 "-"
"Hello World" 40
34.122.208.38 - - [22/Mar/2023:06:48:29 +0000] "CONNECT www.google.com:443
HTTP/1.1" 301 0 "-" "Go-http-client/1.1" 3
149.129.50.37 - - [22/Mar/2023:06:52:37 +0000] "GET
http://www.1ucn.com/proxychecker/index.php HTTP/1.1" 301 0 "-" "Mozilla/1.22
(compatible; MSIE 5.01; PalmOS 3.0) EudoraWeb 2" 2
149.129.50.37 - - [22/Mar/2023:06:52:37 +0000] "GET
http://www.1ucn.com/client/proxychecker/index.php HTTP/1.1" 503 416 "-"
"Mozilla/1.22 (compatible; MSIE 5.01; PalmOS 3.0) EudoraWeb 2" 21
182.43.148.98 - - [22/Mar/2023:07:14:54 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15
(KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1" 3
182.43.148.98 - - [22/Mar/2023:07:14:55 +0000] "GET /client/ HTTP/1.1" 503
394 "http://220.74.34.204"; "Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac
OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148
Safari/604.1" 1
179.43.177.242 - - [22/Mar/2023:07:16:50 +0000] "GET / HTTP/1.1" 301 0 "-"
"Hello World" 2
192.241.223.20 - - [22/Mar/2023:08:00:59 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 zgrab/0.x" 3
117.199.144.224 - - [22/Mar/2023:08:58:22 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/51.0.2704.103 Safari/537.36" 2
117.199.144.224 - - [22/Mar/2023:08:58:24 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/52.0.2743.116 Safari/537.36" 1
43.230.156.235 - - [22/Mar/2023:09:06:39 +0000] "GET / HTTP/1.1" 301 0 "-"
"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/51.0.2704.103 Safari/537.36" 1
10.254.1.134 - - [22/Mar/2023:22:26:24 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 51
10.254.1.134 - - [22/Mar/2023:22:26:24 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0
(Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/111.0.0.0 Safari/537.36" 3
10.254.1.134 - - [22/Mar/2023:22:26:29 +0000] "GET /client/ HTTP/1.1" 503
394 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" 3
10.254.1.134 - - [22/Mar/2023:22:26:29 +0000] "GET /client/favicon.ico
HTTP/1.1" 503 405 "http://192.168.219.253:8080/client/"; "Mozilla/5.0
(Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/111.0.0.0 Safari/537.36" 2
--
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]
