Cloudstack 4.18 HTTP 503 错误 （MySQL 8.0）

[tomorrrow666]

The operating system is Ubuntu 22.04, and the MySQL version is 8.0.41-0ubuntu0.22.04.1.

idrl@management1:~$ sudo tail -F /var/log/cloudstack/management/management-server.log
2025-02-08 10:33:37,238 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: redfish
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-config-system-context.xml]
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-server-system-context.xml]
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-core-system-context.xml]
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-db-system-context.xml]
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-engine-schema-system-checkers-context.xml]
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-config-system-context-inheritable.xml]
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-core-system-context-inheritable.xml]
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-contrail-system-context-inheritable.xml]
2025-02-08 10:33:37,239 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template!

[DaanHoogland]

@tomorrrow666 , there is not question or error in your description. Can you extend it to make clear what your issue is?

[tomorrrow666]

The UI page reports an error.

HTTP ERROR 503 Service Unavailable
URI: | /client/
-- | --
503
Service Unavailable

There are no obvious errors in the logs.

[tomorrrow666]

2月 10 08:59:52 management1.lab.example.org systemd[1]: Stopping CloudStack Management Server...
2月 10 08:59:52 management1.lab.example.org systemd[1]: cloudstack-management.service: Main process exited, code=exited, status=143/n/a
2月 10 08:59:52 management1.lab.example.org systemd[1]: cloudstack-management.service: Failed with result 'exit-code'.
2月 10 08:59:52 management1.lab.example.org systemd[1]: Stopped CloudStack Management Server.
2月 10 08:59:52 management1.lab.example.org systemd[1]: cloudstack-management.service: Consumed 6.822s CPU time.
-- Boot 4c001123273048aeace705e7edf50c2b --
2月 10 09:00:56 management1.lab.example.org systemd[1]: Started CloudStack Management Server.
2月 10 09:00:58 management1.lab.example.org java[1863]: INFO [o.a.c.ServerDaemon] (main:null) (logid:) Server configuration file found: /etc/cloudstack/management/server.properties
2月 10 09:00:58 management1.lab.example.org java[1863]: INFO [o.a.c.ServerDaemon] (main:null) (logid:) Initializing server daemon on null, with http.enable=true, http.port=8080, https.enable=false, https.port=8443, context.path=/client
2月 10 09:00:58 management1.lab.example.org java[1863]: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
2月 10 09:00:58 management1.lab.example.org java[1863]: SLF4J: Defaulting to no-operation (NOP) logger implementation
2月 10 09:00:58 management1.lab.example.org java[1863]: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2月 10 09:01:04 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [bootstrap] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context.xml]
2月 10 09:01:04 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [bootstrap] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [c.c.u.LogUtils] (main:null) (logid:) log4j configuration found at /etc/cloudstack/management/log4j-cloud.xml
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loaded module context [bootstrap] in 387 ms
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bootstrap
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: system
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: core
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: allocator
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-allocator-random
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: planner
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-planner
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-planner
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: explicit-dedication
2月 10 09:01:05 management1.lab.example.org java[1863]: INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-affinity

[weizhouapache]

@tomorrrow666
can you share the full log ?

[tomorrrow666]

idrl@management1:~$ sudo tail -200 /var/log/cloudstack/management/management-server.log
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-compute
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-compute
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kubernetes
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kubernetes-service
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kvm-compute
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-compute
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-compute
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-compute
2025-02-10 14:35:28,091 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-compute
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-fencer
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-investigator
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-compute
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-compute
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: network
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-network
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bigswitch
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cisco-vnmc
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: contrail
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: elb
2025-02-10 14:35:28,092 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: globodns
2025-02-10 14:35:28,093 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: netscaler
2025-02-10 14:35:28,093 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nvp
2025-02-10 14:35:28,093 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: opendaylight
2025-02-10 14:35:28,093 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovs
2025-02-10 14:35:28,093 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: paloalto
2025-02-10 14:35:28,093 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-network
2025-02-10 14:35:28,093 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ssp
2025-02-10 14:35:28,094 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: tungsten
2025-02-10 14:35:28,094 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vcs
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-network
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vxlan
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-backend
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-storage
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-storage
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-storage
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-template-adapter
2025-02-10 14:35:28,095 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-allocator
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-default
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-s3
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-swift
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-cloudbyte
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-datera
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-default
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-linstor
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-scaleio
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-solidfire
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-storpool
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-storage
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: discoverer
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-discoverer
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-discoverer
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-discoverer
2025-02-10 14:35:28,096 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-discoverer
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: secondary-storage-discoverer
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-discoverer
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-discoverer
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-discoverer
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: outofbandmanagement
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ipmitool
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nested-cloudstack
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: redfish
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-config-system-context.xml]
2025-02-10 14:35:28,097 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-server-system-context.xml]
2025-02-10 14:35:28,098 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-core-system-context.xml]
2025-02-10 14:35:28,098 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-db-system-context.xml]
2025-02-10 14:35:28,098 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-engine-schema-system-checkers-context.xml]
2025-02-10 14:35:28,098 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-config-system-context-inheritable.xml]
2025-02-10 14:35:28,098 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-core-system-context-inheritable.xml]
2025-02-10 14:35:28,098 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-contrail-system-context-inheritable.xml]
2025-02-10 14:35:28,098 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
2025-02-10 14:41:08,843 INFO [o.a.c.ServerDaemon] (main:null) (logid:) Server configuration file found: /etc/cloudstack/management/server.properties
2025-02-10 14:41:08,848 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] (main:null) (logid:) Encryption Type: null
2025-02-10 14:41:08,854 INFO [o.a.c.ServerDaemon] (main:null) (logid:) Initializing server daemon on null, with http.enable=true, http.port=8080, https.enable=false, https.port=8443, context.path=/client
2025-02-10 14:41:12,940 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [bootstrap] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context.xml]
2025-02-10 14:41:12,941 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [bootstrap] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
2025-02-10 14:41:13,031 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] (main:null) (logid:) Encryption Type: file
2025-02-10 14:41:13,032 DEBUG [c.c.u.c.CloudStackEncryptor] (main:null) (logid:) Calling to initialize for class com.cloud.utils.crypt.EncryptionSecretKeyChecker
2025-02-10 14:41:13,109 DEBUG [c.c.u.c.CloudStackEncryptor] (main:null) (logid:) Initialized with all possible encryptors
2025-02-10 14:41:13,118 DEBUG [c.c.u.c.CloudStackEncryptor] (main:null) (logid:) CloudStack will encrypt and decrypt values using encryptor : AeadBase64Encryptor for class EncryptionSecretKeyChecker
2025-02-10 14:41:13,162 INFO [c.c.u.LogUtils] (main:null) (logid:) log4j configuration found at /etc/cloudstack/management/log4j-cloud.xml
2025-02-10 14:41:13,167 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loaded module context [bootstrap] in 224 ms
2025-02-10 14:41:13,168 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bootstrap
2025-02-10 14:41:13,168 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: system
2025-02-10 14:41:13,169 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: core
2025-02-10 14:41:13,169 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: allocator
2025-02-10 14:41:13,169 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-allocator-random
2025-02-10 14:41:13,169 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: planner
2025-02-10 14:41:13,169 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-planner
2025-02-10 14:41:13,169 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-planner
2025-02-10 14:41:13,169 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: explicit-dedication
2025-02-10 14:41:13,169 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-affinity
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-anti-affinity
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: implicit-dedication
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: non-strict-host-affinity
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: non-strict-host-anti-affinity
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-planner
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: skip-heurestics
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: user-concentrated-pod
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-allocator
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-dynamic-role-based
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-project-role-based
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-static-role-based
2025-02-10 14:41:13,170 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cloudian
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ldap
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: md5
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: metrics
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: pbkdf2
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: plaintext
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: prometheus
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: quota
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: rate-limit
2025-02-10 14:41:13,171 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: saml2
2025-02-10 14:41:13,172 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-api
2025-02-10 14:41:13,172 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: sha256salted
2025-02-10 14:41:13,172 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: solidfire-intg-test
2025-02-10 14:41:13,172 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: staticpin
2025-02-10 14:41:13,172 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: totp
2025-02-10 14:41:13,172 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-sioc
2025-02-10 14:41:13,172 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-config
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: backend
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: backup
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: dummy-backup
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: networker
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: veeam
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ca
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: root-ca
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: compute
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-compute
2025-02-10 14:41:13,173 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-compute
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kubernetes
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kubernetes-service
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kvm-compute
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-compute
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-compute
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-compute
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-compute
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-fencer
2025-02-10 14:41:13,174 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-investigator
2025-02-10 14:41:13,175 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-compute
2025-02-10 14:41:13,175 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-compute
2025-02-10 14:41:13,176 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: network
2025-02-10 14:41:13,176 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-network
2025-02-10 14:41:13,176 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bigswitch
2025-02-10 14:41:13,176 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cisco-vnmc
2025-02-10 14:41:13,176 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: contrail
2025-02-10 14:41:13,176 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: elb
2025-02-10 14:41:13,177 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: globodns
2025-02-10 14:41:13,177 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: netscaler
2025-02-10 14:41:13,177 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nvp
2025-02-10 14:41:13,177 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: opendaylight
2025-02-10 14:41:13,177 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovs
2025-02-10 14:41:13,177 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: paloalto
2025-02-10 14:41:13,177 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-network
2025-02-10 14:41:13,177 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ssp
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: tungsten
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vcs
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-network
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vxlan
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-backend
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-storage
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-storage
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-storage
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-template-adapter
2025-02-10 14:41:13,178 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-allocator
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-default
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-s3
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-swift
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-cloudbyte
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-datera
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-default
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-linstor
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-scaleio
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-solidfire
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-storpool
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-storage
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: discoverer
2025-02-10 14:41:13,179 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-discoverer
2025-02-10 14:41:13,180 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-discoverer
2025-02-10 14:41:13,180 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-discoverer
2025-02-10 14:41:13,180 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-discoverer
2025-02-10 14:41:13,181 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: secondary-storage-discoverer
2025-02-10 14:41:13,181 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-discoverer
2025-02-10 14:41:13,181 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-discoverer
2025-02-10 14:41:13,181 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-discoverer
2025-02-10 14:41:13,181 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: outofbandmanagement
2025-02-10 14:41:13,181 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ipmitool
2025-02-10 14:41:13,181 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nested-cloudstack
2025-02-10 14:41:13,181 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: redfish
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-config-system-context.xml]
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-server-system-context.xml]
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-core-system-context.xml]
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-db-system-context.xml]
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-engine-schema-system-checkers-context.xml]
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-framework-config-system-context-inheritable.xml]
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-core-system-context-inheritable.xml]
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/system/spring-contrail-system-context-inheritable.xml]
2025-02-10 14:41:13,182 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.18.2.5.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]

[weizhouapache]

@tomorrrow666
can you upload the FULL logs as a file ?

[tomorrrow666]

management-server.log

setupManagement.log

[weizhouapache]

@tomorrrow666
the logs show

2025-02-06 09:01:27,851 INFO  [c.c.c.ClusterManagerImpl] (main:null) (logid:) Cluster node IP : 127.0.1.1
2025-02-06 09:01:27,852 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
	at com.cloud.cluster.ClusterManagerImpl.configure(ClusterManagerImpl.java:1097)

it looks like the cluster.node.IP is set to 127.0.1.1 in /etc/cloudstack/management/db.properties

can you set it to a valid ip address and restart mgmt service ?

[tomorrrow666]

"Modify IP, but the issue is not resolved."

[weizhouapache]

"Modify IP, but the issue is not resolved."

@tomorrrow666
what's the error ?
you can search by keyword "Exception"

[tomorrrow666]

idrl@management1:~$ sudo grep -i -E 'error|exception' /var/log/cloudstack/management/management-server.log
[sudo] idrl 的密码：
2025-02-06 08:09:25,526 ERROR [c.c.u.d.Merovingian2] (main:null) (logid:) Unable to get a new db connection
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:211)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: java.net.ConnectException: 连接被拒绝 (Connection refused)
2025-02-06 08:30:19,518 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE cloud.s3 ( id bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', uuid varchar(40), access_key varchar(20) NOT NULL COMMENT ' The S3 access key', secret_key varchar(40) NOT NULL COMMENT ' The S3 secret key', end_point varchar(1024) COMMENT ' The S3 host', bucket varchar(63) NOT NULL COMMENT ' The S3 host', https tinyint unsigned DEFAULT NULL COMMENT ' Flag indicating whether or not to connect over HTTPS', connection_timeout integer COMMENT ' The amount of time to wait (in milliseconds) when initially establishing a connection before giving up and timing out.', max_error_retry integer COMMENT ' The maximum number of retry attempts for failed retryable requests (ex: 5xx error responses from services).', socket_timeout integer COMMENT ' The amount of time to wait (in milliseconds) for data to be transferred over an established, open connection before the connection times out and is closed.', created datetime COMMENT 'date the s3 first signed on', PRIMARY KEY (id), CONSTRAINT uc_s3__uuid UNIQUE (uuid) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2025-02-06 08:30:21,380 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_host_ref.size volume_host_size, volume_host_ref.created volume_host_created, volume_host_ref.format, volume_host_ref.download_pct, volume_host_ref.download_state, volume_host_ref.error_str, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_host_ref ON volumes.id = volume_host_ref.volume_id and volumes.data_center_id = volume_host_ref.zone_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:22,592 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE cloud.object_datastore_ref ( id bigint unsigned NOT NULL auto_increment, datastore_uuid varchar(255) NOT NULL, datastore_role varchar(255) NOT NULL, object_uuid varchar(255) NOT NULL, object_type varchar(255) NOT NULL, created DATETIME NOT NULL, last_updated DATETIME, job_id varchar(255), download_pct int(10) unsigned, download_state varchar(255), url varchar(255), format varchar(255), checksum varchar(255), error_str varchar(255), local_path varchar(255), install_path varchar(255), size bigint unsigned COMMENT 'the size of the template on the pool', state varchar(255) NOT NULL, update_count bigint unsigned NOT NULL, updated DATETIME, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2025-02-06 08:30:22,704 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE cloud.template_store_ref ( id bigint unsigned NOT NULL auto_increment, store_id bigint unsigned, template_id bigint unsigned NOT NULL, created DATETIME NOT NULL, last_updated DATETIME, job_id varchar(255), download_pct int(10) unsigned, size bigint unsigned, store_role varchar(255), physical_size bigint unsigned DEFAULT 0, download_state varchar(255), error_str varchar(255), local_path varchar(255), install_path varchar(255), url varchar(255), state varchar(255) NOT NULL, destroyed tinyint(1) COMMENT 'indicates whether the template_store entry was destroyed by the user or not', is_copy tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates whether this was copied ', update_count bigint unsigned, ref_cnt bigint unsigned DEFAULT 0, updated datetime, PRIMARY KEY (id), INDEX i_template_store_ref__store_id(store_id), CONSTRAINT fk_template_store_ref__template_id FOREIGN KEY fk_template_store_ref__template_id (template_id) REFERENCES vm_template (id), INDEX i_template_store_ref__template_id(template_id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2025-02-06 08:30:22,795 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE cloud.volume_store_ref ( id bigint unsigned NOT NULL auto_increment, store_id bigint unsigned NOT NULL, volume_id bigint unsigned NOT NULL, zone_id bigint unsigned NOT NULL, created DATETIME NOT NULL, last_updated DATETIME, job_id varchar(255), download_pct int(10) unsigned, size bigint unsigned, physical_size bigint unsigned DEFAULT 0, download_state varchar(255), checksum varchar(255) COMMENT 'checksum for the data disk', error_str varchar(255), local_path varchar(255), install_path varchar(255), url varchar(255), download_url varchar(255), state varchar(255) NOT NULL, destroyed tinyint(1) COMMENT 'indicates whether the volume_host entry was destroyed by the user or not', update_count bigint unsigned, ref_cnt bigint unsigned, updated datetime, PRIMARY KEY (id), CONSTRAINT fk_volume_store_ref__store_id FOREIGN KEY fk_volume_store_ref__store_id (store_id) REFERENCES image_store (id) ON DELETE CASCADE, INDEX i_volume_store_ref__store_id(store_id), CONSTRAINT fk_volume_store_ref__volume_id FOREIGN KEY fk_volume_store_ref__volume_id (volume_id) REFERENCES volumes (id), INDEX i_volume_store_ref__volume_id(volume_id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2025-02-06 08:30:27,533 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, volumes.display_volume, volumes.format, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id OR volumes.iso_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:27,746 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS select vm_template.id, vm_template.uuid, vm_template.unique_name, vm_template.name, vm_template.public, vm_template.featured, vm_template.type, vm_template.hvm, vm_template.bits, vm_template.url, vm_template.format, vm_template.created, vm_template.checksum, vm_template.display_text, vm_template.enable_password, vm_template.dynamically_scalable, vm_template.guest_os_id, guest_os.uuid guest_os_uuid, guest_os.display_name guest_os_name, vm_template.bootable, vm_template.prepopulate, vm_template.cross_zones, vm_template.hypervisor_type, vm_template.extractable, vm_template.template_tag, vm_template.sort_key, vm_template.removed, vm_template.enable_sshkey, source_template.id source_template_id, source_template.uuid source_template_uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, launch_permission.account_id lp_account_id, template_store_ref.store_id, image_store.scope as store_scope, template_store_ref.state, template_store_ref.download_state, template_store_ref.download_pct, template_store_ref.error_str, template_store_ref.size, template_store_ref.destroyed, template_store_ref.created created_on_store, vm_template_details.name detail_name, vm_template_details.value detail_value, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) as temp_zone_pair from cloud.vm_template inner join cloud.guest_os ON guest_os.id = vm_template.guest_os_id inner join cloud.account ON account.id = vm_template.account_id inner join cloud.domain ON domain.id = account.domain_id left join cloud.projects ON projects.project_account_id = account.id left join cloud.vm_template_details ON vm_template_details.template_id = vm_template.id left join cloud.vm_template source_template ON source_template.id = vm_template.source_template_id left join cloud.template_store_ref ON template_store_ref.template_id = vm_template.id and template_store_ref.store_role = 'Image' left join cloud.image_store ON image_store.removed is NULL AND template_store_ref.store_id is not NULL AND image_store.id = template_store_ref.store_id left join cloud.template_zone_ref ON template_zone_ref.template_id = vm_template.id AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null left join cloud.data_center ON (image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = data_center.id) left join cloud.launch_permission ON launch_permission.template_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = vm_template.id and (resource_tags.resource_type = 'Template' or resource_tags.resource_type='ISO')
2025-02-06 08:30:28,797 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key last_sent on table alert exception: Can't DROP 'last_sent'; check that column/key exists
2025-02-06 08:30:28,799 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key i_alert__last_sent on table alert exception: Can't DROP 'i_alert__last_sent'; check that column/key exists
2025-02-06 08:30:28,817 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_nsp_id on table baremetal_dhcp_devices exception: Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,818 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_host_id on table baremetal_dhcp_devices exception: Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,818 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_pod_id on table baremetal_dhcp_devices exception: Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists
2025-02-06 08:30:28,819 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_physical_network_id on table baremetal_dhcp_devices exception: Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that column/key exists
2025-02-06 08:30:28,820 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_nsp_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,821 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_host_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,822 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_pod_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists
2025-02-06 08:30:28,823 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_physical_network_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that column/key exists
2025-02-06 08:30:28,823 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_pxe_devices_nsp_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,824 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_pxe_devices_host_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_pxe_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,825 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_pxe_devices_physical_network_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that column/key exists
2025-02-06 08:30:29,311 INFO [c.c.u.d.Upgrade410to420] (main:null) (logid:) migrateDatafromIsoIdInVolumesTable: ignoring Exception: Unknown column 'iso_id1' in 'field list'
2025-02-06 08:30:32,127 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS select vm_template.id, vm_template.uuid, vm_template.unique_name, vm_template.name, vm_template.public, vm_template.featured, vm_template.type, vm_template.hvm, vm_template.bits, vm_template.url, vm_template.format, vm_template.created, vm_template.checksum, vm_template.display_text, vm_template.enable_password, vm_template.dynamically_scalable, vm_template.state template_state, vm_template.guest_os_id, guest_os.uuid guest_os_uuid, guest_os.display_name guest_os_name, vm_template.bootable, vm_template.prepopulate, vm_template.cross_zones, vm_template.hypervisor_type, vm_template.extractable, vm_template.template_tag, vm_template.sort_key, vm_template.removed, vm_template.enable_sshkey, source_template.id source_template_id, source_template.uuid source_template_uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, launch_permission.account_id lp_account_id, template_store_ref.store_id, image_store.scope as store_scope, template_store_ref.state, template_store_ref.download_state, template_store_ref.download_pct, template_store_ref.error_str, template_store_ref.size, template_store_ref.destroyed, template_store_ref.created created_on_store, vm_template_details.name detail_name, vm_template_details.value detail_value, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) as temp_zone_pair from cloud.vm_template inner join cloud.guest_os ON guest_os.id = vm_template.guest_os_id inner join cloud.account ON account.id = vm_template.account_id inner join cloud.domain ON domain.id = account.domain_id left join cloud.projects ON projects.project_account_id = account.id left join cloud.vm_template_details ON vm_template_details.template_id = vm_template.id left join cloud.vm_template source_template ON source_template.id = vm_template.source_template_id left join cloud.template_store_ref ON template_store_ref.template_id = vm_template.id and template_store_ref.store_role = 'Image' and template_store_ref.destroyed=0 left join cloud.image_store ON image_store.removed is NULL AND template_store_ref.store_id is not NULL AND image_store.id = template_store_ref.store_id left join cloud.template_zone_ref ON template_zone_ref.template_id = vm_template.id AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null left join cloud.data_center ON (image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = data_center.id) left join cloud.launch_permission ON launch_permission.template_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = vm_template.id and (resource_tags.resource_type = 'Template' or resource_tags.resource_type='ISO')
2025-02-06 08:30:32,137 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, volumes.display_volume, volumes.format, volumes.path, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id OR volumes.iso_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:33,968 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, volumes.display_volume, volumes.format, volumes.path, volumes.chain_info, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, disk_offering.cache_mode, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, vm_template.name template_name, vm_template.display_text template_display_text, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.vm_template iso ON iso.id = volumes.iso_id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:40,018 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.provisioning_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, volumes.display_volume, volumes.format, volumes.path, volumes.chain_info, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, disk_offering.cache_mode, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, vm_template.name template_name, vm_template.display_text template_display_text, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.vm_template iso ON iso.id = volumes.iso_id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:40,162 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS select vm_template.id, vm_template.uuid, vm_template.unique_name, vm_template.name, vm_template.public, vm_template.featured, vm_template.type, vm_template.hvm, vm_template.bits, vm_template.url, vm_template.format, vm_template.created, vm_template.checksum, vm_template.display_text, vm_template.enable_password, vm_template.dynamically_scalable, vm_template.state template_state, vm_template.guest_os_id, guest_os.uuid guest_os_uuid, guest_os.display_name guest_os_name, vm_template.bootable, vm_template.prepopulate, vm_template.cross_zones, vm_template.hypervisor_type, vm_template.extractable, vm_template.template_tag, vm_template.sort_key, vm_template.removed, vm_template.enable_sshkey, source_template.id source_template_id, source_template.uuid source_template_uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, launch_permission.account_id lp_account_id, template_store_ref.store_id, image_store.scope as store_scope, template_store_ref.state, template_store_ref.download_state, template_store_ref.download_pct, template_store_ref.error_str, template_store_ref.size, template_store_ref.destroyed, template_store_ref.created created_on_store, vm_template_details.name detail_name, vm_template_details.value detail_value, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) as temp_zone_pair from cloud.vm_template inner join cloud.guest_os ON guest_os.id = vm_template.guest_os_id inner join cloud.account ON account.id = vm_template.account_id inner join cloud.domain ON domain.id = account.domain_id left join cloud.projects ON projects.project_account_id = account.id left join cloud.vm_template_details ON vm_template_details.template_id = vm_template.id left join cloud.vm_template source_template ON source_template.id = vm_template.source_template_id left join cloud.template_store_ref ON template_store_ref.template_id = vm_template.id and template_store_ref.store_role = 'Image' and template_store_ref.destroyed=0 left join cloud.image_store ON image_store.removed is NULL AND template_store_ref.store_id is not NULL AND image_store.id = template_store_ref.store_id left join cloud.template_zone_ref ON template_zone_ref.template_id = vm_template.id AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null left join cloud.data_center ON (image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = data_center.id) left join cloud.launch_permission ON launch_permission.template_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = vm_template.id and (resource_tags.resource_type = 'Template' or resource_tags.resource_type='ISO')
2025-02-06 08:30:43,994 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key i_vm_instance__instance_name on table vm_instance exception: Can't DROP 'i_vm_instance__instance_name'; check that column/key exists
2025-02-06 08:30:44,722 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW template_view AS SELECT vm_template.id AS id, vm_template.uuid AS uuid, vm_template.unique_name AS unique_name, vm_template.name AS name, vm_template.public AS public, vm_template.featured AS featured, vm_template.type AS type, vm_template.hvm AS hvm, vm_template.bits AS bits, vm_template.url AS url, vm_template.format AS format, vm_template.created AS created, vm_template.checksum AS checksum, vm_template.display_text AS display_text, vm_template.enable_password AS enable_password, vm_template.dynamically_scalable AS dynamically_scalable, vm_template.state AS template_state, vm_template.guest_os_id AS guest_os_id, guest_os.uuid AS guest_os_uuid, guest_os.display_name AS guest_os_name, vm_template.bootable AS bootable, vm_template.prepopulate AS prepopulate, vm_template.cross_zones AS cross_zones, vm_template.hypervisor_type AS hypervisor_type, vm_template.extractable AS extractable, vm_template.template_tag AS template_tag, vm_template.sort_key AS sort_key, vm_template.removed AS removed, vm_template.enable_sshkey AS enable_sshkey, source_template.id AS source_template_id, source_template.uuid AS source_template_uuid, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, launch_permission.account_id AS lp_account_id, template_store_ref.store_id AS store_id, image_store.scope AS store_scope, template_store_ref.state AS state, template_store_ref.download_state AS download_state, template_store_ref.download_pct AS download_pct, template_store_ref.error_str AS error_str, template_store_ref.size AS size, template_store_ref.destroyed AS destroyed, template_store_ref.created AS created_on_store, vm_template_details.name AS detail_name, vm_template_details.value AS detail_value, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) AS temp_zone_pair FROM ((((((((((((vm_template JOIN guest_os ON ((guest_os.id = vm_template.guest_os_id))) JOIN account ON ((account.id = vm_template.account_id))) JOIN domain ON ((domain.id = account.domain_id))) LEFT JOIN projects ON ((projects.project_account_id = account.id))) LEFT JOIN vm_template_details ON ((vm_template_details.template_id = vm_template.id))) LEFT JOIN vm_template source_template ON ((source_template.id = vm_template.source_template_id))) LEFT JOIN template_store_ref ON (((template_store_ref.template_id = vm_template.id) AND (template_store_ref.store_role = 'Image') AND (template_store_ref.destroyed = 0)))) LEFT JOIN image_store ON ((ISNULL(image_store.removed) AND (template_store_ref.store_id IS NOT NULL) AND (image_store.id = template_store_ref.store_id)))) LEFT JOIN template_zone_ref ON (((template_zone_ref.template_id = vm_template.id) AND ISNULL(template_store_ref.store_id) AND ISNULL(template_zone_ref.removed)))) LEFT JOIN data_center ON (((image_store.data_center_id = data_center.id) OR (template_zone_ref.zone_id = data_center.id)))) LEFT JOIN launch_permission ON ((launch_permission.template_id = vm_template.id))) LEFT JOIN resource_tags ON (((resource_tags.resource_id = vm_template.id) AND ((resource_tags.resource_type = 'Template') OR (resource_tags.resource_type = 'ISO')))))
2025-02-06 08:30:44,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW volume_view AS SELECT volumes.id AS id, volumes.uuid AS uuid, volumes.name AS name, volumes.device_id AS device_id, volumes.volume_type AS volume_type, volumes.provisioning_type AS provisioning_type, volumes.size AS size, volumes.min_iops AS min_iops, volumes.max_iops AS max_iops, volumes.created AS created, volumes.state AS state, volumes.attached AS attached, volumes.removed AS removed, volumes.pod_id AS pod_id, volumes.display_volume AS display_volume, volumes.format AS format, volumes.path AS path, volumes.chain_info AS chain_info, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, data_center.networktype AS data_center_type, vm_instance.id AS vm_id, vm_instance.uuid AS vm_uuid, vm_instance.name AS vm_name, vm_instance.state AS vm_state, vm_instance.vm_type AS vm_type, user_vm.display_name AS vm_display_name, volume_store_ref.size AS volume_store_size, volume_store_ref.download_pct AS download_pct, volume_store_ref.download_state AS download_state, volume_store_ref.error_str AS error_str, volume_store_ref.created AS created_on_store, disk_offering.id AS disk_offering_id, disk_offering.uuid AS disk_offering_uuid, disk_offering.name AS disk_offering_name, disk_offering.display_text AS disk_offering_display_text, disk_offering.use_local_storage AS use_local_storage, disk_offering.system_use AS system_use, disk_offering.bytes_read_rate AS bytes_read_rate, disk_offering.bytes_write_rate AS bytes_write_rate, disk_offering.iops_read_rate AS iops_read_rate, disk_offering.iops_write_rate AS iops_write_rate, disk_offering.cache_mode AS cache_mode, storage_pool.id AS pool_id, storage_pool.uuid AS pool_uuid, storage_pool.name AS pool_name, cluster.hypervisor_type AS hypervisor_type, vm_template.id AS template_id, vm_template.uuid AS template_uuid, vm_template.extractable AS extractable, vm_template.type AS template_type, vm_template.name AS template_name, vm_template.display_text AS template_display_text, iso.id AS iso_id, iso.uuid AS iso_uuid, iso.name AS iso_name, iso.display_text AS iso_display_text, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, async_job.id AS job_id, async_job.uuid AS job_uuid, async_job.job_status AS job_status, async_job.account_id AS job_account_id FROM ((((((((((((((volumes JOIN account ON ((volumes.account_id = account.id))) JOIN domain ON ((volumes.domain_id = domain.id))) LEFT JOIN projects ON ((projects.project_account_id = account.id))) LEFT JOIN data_center ON ((volumes.data_center_id = data_center.id))) LEFT JOIN vm_instance ON ((volumes.instance_id = vm_instance.id))) LEFT JOIN user_vm ON ((user_vm.id = vm_instance.id))) LEFT JOIN volume_store_ref ON ((volumes.id = volume_store_ref.volume_id))) LEFT JOIN disk_offering ON ((volumes.disk_offering_id = disk_offering.id))) LEFT JOIN storage_pool ON ((volumes.pool_id = storage_pool.id))) LEFT JOIN cluster ON ((storage_pool.cluster_id = cluster.id))) LEFT JOIN vm_template ON ((volumes.template_id = vm_template.id))) LEFT JOIN vm_template iso ON ((iso.id = volumes.iso_id))) LEFT JOIN resource_tags ON (((resource_tags.resource_id = volumes.id) AND (resource_tags.resource_type = 'Volume')))) LEFT JOIN async_job ON (((async_job.instance_id = volumes.id) AND (async_job.instance_type = 'Volume') AND (async_job.job_status = 0))))
2025-02-06 08:30:49,436 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS SELECT volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.provisioning_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.display_volume, volumes.format, volumes.path, volumes.chain_info, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, disk_offering.cache_mode, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.id cluster_id, cluster.name cluster_name, cluster.uuid cluster_uuid, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, vm_template.name template_name, vm_template.display_text template_display_text, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id, host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid, host_pod_ref.name pod_name, resource_tag_account.account_name tag_account_name, resource_tag_domain.uuid tag_domain_uuid, resource_tag_domain.name tag_domain_name from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.host_pod_ref ON storage_pool.pod_id = host_pod_ref.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.vm_template iso ON iso.id = volumes.iso_id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0 left join cloud.account resource_tag_account ON resource_tag_account.id = resource_tags.account_id left join cloud.domain resource_tag_domain ON resource_tag_domain.id = resource_tags.domain_id
2025-02-06 08:30:49,994 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS SELECT vm_template.id AS id, vm_template.uuid AS uuid, vm_template.unique_name AS unique_name, vm_template.name AS name, vm_template.public AS public, vm_template.featured AS featured, vm_template.type AS type, vm_template.hvm AS hvm, vm_template.bits AS bits, vm_template.url AS url, vm_template.format AS format, vm_template.created AS created, vm_template.checksum AS checksum, vm_template.display_text AS display_text, vm_template.enable_password AS enable_password, vm_template.dynamically_scalable AS dynamically_scalable, vm_template.state AS template_state, vm_template.guest_os_id AS guest_os_id, guest_os.uuid AS guest_os_uuid, guest_os.display_name AS guest_os_name, vm_template.bootable AS bootable, vm_template.prepopulate AS prepopulate, vm_template.cross_zones AS cross_zones, vm_template.hypervisor_type AS hypervisor_type, vm_template.extractable AS extractable, vm_template.template_tag AS template_tag, vm_template.sort_key AS sort_key, vm_template.removed AS removed, vm_template.enable_sshkey AS enable_sshkey, parent_template.id AS parent_template_id, parent_template.uuid AS parent_template_uuid, source_template.id AS source_template_id, source_template.uuid AS source_template_uuid, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, launch_permission.account_id AS lp_account_id, template_store_ref.store_id AS store_id, image_store.scope AS store_scope, template_store_ref.state AS state, template_store_ref.download_state AS download_state, template_store_ref.download_pct AS download_pct, template_store_ref.error_str AS error_str, template_store_ref.size AS size, template_store_ref.physical_size AS physical_size, template_store_ref.destroyed AS destroyed, template_store_ref.created AS created_on_store, vm_template_details.name AS detail_name, vm_template_details.value AS detail_value, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) AS temp_zone_pair, vm_template.direct_download AS direct_download FROM (((((((((((((vm_template JOIN guest_os ON ((guest_os.id = vm_template.guest_os_id))) JOIN account ON ((account.id = vm_template.account_id))) JOIN domain ON ((domain.id = account.domain_id))) LEFT JOIN projects ON ((projects.project_account_id = account.id))) LEFT JOIN vm_template_details ON ((vm_template_details.template_id = vm_template.id))) LEFT JOIN vm_template source_template ON ((source_template.id = vm_template.source_template_id))) LEFT JOIN template_store_ref ON (((template_store_ref.template_id = vm_template.id) AND (template_store_ref.store_role = 'Image') AND (template_store_ref.destroyed = 0)))) LEFT JOIN vm_template parent_template ON ((parent_template.id = vm_template.parent_template_id))) LEFT JOIN image_store ON ((ISNULL(image_store.removed) AND (template_store_ref.store_id IS NOT NULL) AND (image_store.id = template_store_ref.store_id)))) LEFT JOIN template_zone_ref ON (((template_zone_ref.template_id = vm_template.id) AND ISNULL(template_store_ref.store_id) AND ISNULL(template_zone_ref.removed)))) LEFT JOIN data_center ON (((image_store.data_center_id = data_center.id) OR (template_zone_ref.zone_id = data_center.id)))) LEFT JOIN launch_permission ON ((launch_permission.template_id = vm_template.id))) LEFT JOIN resource_tags ON (((resource_tags.resource_id = vm_template.id) AND ((resource_tags.resource_type = 'Template') OR (resource_tags.resource_type = 'ISO')))))
2025-02-06 08:30:50,459 ERROR [c.c.u.PropertiesUtil] (main:null) (logid:) Unable to find properties file: commands.properties
2025-02-06 08:30:50,882 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- changed fingerprint type to TEXT, it avoids db exception when creating the certificate issue #3123
2025-02-06 08:30:54,460 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS SELECT vm_template.id AS id, vm_template.uuid AS uuid, vm_template.unique_name AS unique_name, vm_template.name AS name, vm_template.public AS public, vm_template.featured AS featured, vm_template.type AS type, vm_template.hvm AS hvm, vm_template.bits AS bits, vm_template.url AS url, vm_template.format AS format, vm_template.created AS created, vm_template.checksum AS checksum, vm_template.display_text AS display_text, vm_template.enable_password AS enable_password, vm_template.dynamically_scalable AS dynamically_scalable, vm_template.state AS template_state, vm_template.guest_os_id AS guest_os_id, guest_os.uuid AS guest_os_uuid, guest_os.display_name AS guest_os_name, vm_template.bootable AS bootable, vm_template.prepopulate AS prepopulate, vm_template.cross_zones AS cross_zones, vm_template.hypervisor_type AS hypervisor_type, vm_template.extractable AS extractable, vm_template.template_tag AS template_tag, vm_template.sort_key AS sort_key, vm_template.removed AS removed, vm_template.enable_sshkey AS enable_sshkey, parent_template.id AS parent_template_id, parent_template.uuid AS parent_template_uuid, source_template.id AS source_template_id, source_template.uuid AS source_template_uuid, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, launch_permission.account_id AS lp_account_id, template_store_ref.store_id AS store_id, image_store.scope AS store_scope, template_store_ref.state AS state, template_store_ref.download_state AS download_state, template_store_ref.download_pct AS download_pct, template_store_ref.error_str AS error_str, template_store_ref.size AS size, template_store_ref.physical_size AS physical_size, template_store_ref.destroyed AS destroyed, template_store_ref.created AS created_on_store, vm_template_details.name AS detail_name, vm_template_details.value AS detail_value, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) AS temp_zone_pair, vm_template.direct_download AS direct_download, 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_type = 'ISO')))))
2025-02-06 08:30:59,531 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS SELECT volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.provisioning_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.display_volume, volumes.format, volumes.path, volumes.chain_info, volumes.external_uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, service_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, disk_offering.cache_mode, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.id cluster_id, cluster.name cluster_name, cluster.uuid cluster_uuid, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, vm_template.name template_name, vm_template.display_text template_display_text, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id, host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid, host_pod_ref.name pod_name, resource_tag_account.account_name tag_account_name, resource_tag_domain.uuid tag_domain_uuid, resource_tag_domain.name tag_domain_name from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.service_offering ON vm_instance.service_offering_id = service_offering.id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.host_pod_ref ON storage_pool.pod_id = host_pod_ref.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.vm_template iso ON iso.id = volumes.iso_id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0 left join cloud.account resource_tag_account ON resource_tag_account.id = resource_tags.account_id left join cloud.domain resource_tag_domain ON resource_tag_domain.id = resource_tags.domain_id
2025-02-06 08:31:02,690 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS SELECT vm_template.id AS id, vm_template.uuid AS uuid, vm_template.unique_name AS unique_name, vm_template.name AS name, vm_template.public AS public, vm_template.featured AS featured, vm_template.type AS type, vm_template.hvm AS hvm, vm_template.bits AS bits, vm_template.url AS url, vm_template.format AS format, vm_template.created AS created, vm_template.checksum AS checksum, vm_template.display_text AS display_text, vm_template.enable_password AS enable_password, vm_template.dynamically_scalable AS dynamically_scalable, vm_template.state AS template_state, vm_template.guest_os_id AS guest_os_id, guest_os.uuid AS guest_os_uuid, guest_os.display_name AS guest_os_name, vm_template.bootable AS bootable, vm_template.prepopulate AS prepopulate, vm_template.cross_zones AS cross_zones, vm_template.hypervisor_type AS hypervisor_type, vm_template.extractable AS extractable, vm_template.template_tag AS template_tag, vm_template.sort_key AS sort_key, vm_template.removed AS removed, vm_template.enable_sshkey AS enable_sshkey, parent_template.id AS parent_template_id, parent_template.uuid AS parent_template_uuid, source_template.id AS source_template_id, source_template.uuid AS source_template_uuid, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, launch_permission.account_id AS lp_account_id, template_store_ref.store_id AS store_id, image_store.scope AS store_scope, template_store_ref.state AS state, template_store_ref.download_state AS download_state, template_store_ref.download_pct AS download_pct, template_store_ref.error_str AS error_str, template_store_ref.size AS size, template_store_ref.physical_size AS physical_size, template_store_ref.destroyed AS destroyed, template_store_ref.created AS created_on_store, vm_template_details.name AS detail_name, vm_template_details.value AS detail_value, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, CONCAT(vm_template.id, '_', IFNULL(data_center.id, 0)) AS temp_zone_pair, vm_template.direct_download AS direct_download, vm_template.deploy_as_is AS deploy_as_is, user_data.id AS user_data_id, user_data.uuid AS user_data_uuid, user_data.name AS user_data_name, user_data.params AS user_data_params, vm_template.user_data_link_policy AS user_data_policy FROM (((((((((((((vm_template JOIN guest_os ON ((guest_os.id = vm_template.guest_os_id))) JOIN account ON ((account.id = vm_template.account_id))) JOIN domain ON ((domain.id = account.domain_id))) LEFT JOIN projects ON ((projects.project_account_id = account.id))) LEFT JOIN vm_template_details ON ((vm_template_details.template_id = vm_template.id))) LEFT JOIN vm_template source_template ON ((source_template.id = vm_template.source_template_id))) LEFT JOIN template_store_ref ON (((template_store_ref.template_id = vm_template.id) AND (template_store_ref.store_role = 'Image') AND (template_store_ref.destroyed = 0)))) LEFT JOIN vm_template parent_template ON ((parent_template.id = vm_template.parent_template_id))) LEFT JOIN image_store ON ((ISNULL(image_store.removed) AND (template_store_ref.store_id IS NOT NULL) AND (image_store.id = template_store_ref.store_id)))) LEFT JOIN template_zone_ref ON (((template_zone_ref.template_id = vm_template.id) AND ISNULL(template_store_ref.store_id) AND ISNULL(template_zone_ref.removed)))) LEFT JOIN data_center ON (((image_store.data_center_id = data_center.id) OR (template_zone_ref.zone_id = data_center.id)))) LEFT JOIN launch_permission ON ((launch_permission.template_id = vm_template.id))) LEFT JOIN user_data ON ((user_data.id = vm_template.user_data_id)) LEFT JOIN resource_tags ON (((resource_tags.resource_id = vm_template.id) AND ((resource_tags.resource_type = 'Template') OR (resource_tags.resource_type = 'ISO')))))
2025-02-06 08:31:03,361 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE cloud.configuration SET kind = 'Select', options = 'Error,Migration,ForceStop' where name = 'host.maintenance.local.storage.strategy'
2025-02-06 08:31:05,043 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_user_data_id on table cloud.user_vm exception: Can't DROP 'fk_user_data_id'; check that column/key exists
2025-02-06 08:31:05,045 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_user_vm__user_data_id on table cloud.user_vm exception: Can't DROP 'fk_user_vm__user_data_id'; check that column/key exists
2025-02-06 08:31:05,046 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_user_data_id on table cloud.user_vm exception: Can't DROP 'fk_user_data_id'; check that column/key exists
2025-02-06 08:31:05,051 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_user_vm__user_data_id on table cloud.user_vm exception: Can't DROP 'fk_user_vm__user_data_id'; check that column/key exists
2025-02-06 08:31:05,099 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_user_data_id on table cloud.vm_template exception: Can't DROP 'fk_user_data_id'; check that column/key exists
2025-02-06 08:31:05,099 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_vm_template__user_data_id on table cloud.vm_template exception: Can't DROP 'fk_vm_template__user_data_id'; check that column/key exists
2025-02-06 08:31:05,100 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_user_data_id on table cloud.vm_template exception: Can't DROP 'fk_user_data_id'; check that column/key exists
2025-02-06 08:31:05,101 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_vm_template__user_data_id on table cloud.vm_template exception: Can't DROP 'fk_vm_template__user_data_id'; check that column/key exists
2025-02-06 08:31:05,163 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_passphrase_id on table cloud.volumes exception: Can't DROP 'fk_passphrase_id'; check that column/key exists
2025-02-06 08:31:05,164 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_volumes__passphrase_id on table cloud.volumes exception: Can't DROP 'fk_volumes__passphrase_id'; check that column/key exists
2025-02-06 08:31:05,165 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_passphrase_id on table cloud.volumes exception: Can't DROP 'fk_passphrase_id'; check that column/key exists
2025-02-06 08:31:05,166 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_volumes__passphrase_id on table cloud.volumes exception: Can't DROP 'fk_volumes__passphrase_id'; check that column/key exists
2025-02-06 08:31:24,900 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 08:35:07,894 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 08:40:41,589 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 08:53:31,545 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 09:01:27,852 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 09:14:38,024 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 09:15:02,403 ERROR [c.c.u.d.ConnectionConcierge] (ConnectionConcierge-1:ctx-01637801) (logid:1f1e5aa6) Unable to keep the db connection for LockController1
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
2025-02-06 09:17:38,620 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 09:17:44,412 ERROR [c.c.u.d.ConnectionConcierge] (ConnectionConcierge-1:ctx-c47f37a7) (logid:85bc0458) Unable to keep the db connection for LockController1
java.sql.SQLNonTransientConnectionException: Server shutdown in progress
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
2025-02-06 09:17:49,005 ERROR [c.c.u.d.T.Transaction] (ConnectionConcierge-1:ctx-c47f37a7) (logid:85bc0458) Unexpected exception:
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:211)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: java.net.ConnectException: 连接被拒绝 (Connection refused)
2025-02-06 10:39:07,814 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 11:07:49,401 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 11:13:48,987 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration

"Only errors before February 6th"

[weizhouapache]

@tomorrrow666
have you restarted the cloudstack-management service ?
please upload the new logs after restarting

can you set it to a valid address on your server ?
if you are not sure, you can test with 127.0.0.1 which normally works

[tomorrrow666]

idrl@management1:$ sudo systemctl restart cloudstack-management.service
idrl@management1:$ sudo grep -i -E 'error|exception' /var/log/cloudstack/management/management-server.log
2025-02-06 08:09:25,526 ERROR [c.c.u.d.Merovingian2] (main:null) (logid:) Unable to get a new db connection
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:211)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: java.net.ConnectException: 连接被拒绝 (Connection refused)
2025-02-06 08:30:19,518 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE cloud.s3 ( id bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', uuid varchar(40), access_key varchar(20) NOT NULL COMMENT ' The S3 access key', secret_key varchar(40) NOT NULL COMMENT ' The S3 secret key', end_point varchar(1024) COMMENT ' The S3 host', bucket varchar(63) NOT NULL COMMENT ' The S3 host', https tinyint unsigned DEFAULT NULL COMMENT ' Flag indicating whether or not to connect over HTTPS', connection_timeout integer COMMENT ' The amount of time to wait (in milliseconds) when initially establishing a connection before giving up and timing out.', max_error_retry integer COMMENT ' The maximum number of retry attempts for failed retryable requests (ex: 5xx error responses from services).', socket_timeout integer COMMENT ' The amount of time to wait (in milliseconds) for data to be transferred over an established, open connection before the connection times out and is closed.', created datetime COMMENT 'date the s3 first signed on', PRIMARY KEY (id), CONSTRAINT uc_s3__uuid UNIQUE (uuid) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2025-02-06 08:30:21,380 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_host_ref.size volume_host_size, volume_host_ref.created volume_host_created, volume_host_ref.format, volume_host_ref.download_pct, volume_host_ref.download_state, volume_host_ref.error_str, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_host_ref ON volumes.id = volume_host_ref.volume_id and volumes.data_center_id = volume_host_ref.zone_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:22,592 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE cloud.object_datastore_ref ( id bigint unsigned NOT NULL auto_increment, datastore_uuid varchar(255) NOT NULL, datastore_role varchar(255) NOT NULL, object_uuid varchar(255) NOT NULL, object_type varchar(255) NOT NULL, created DATETIME NOT NULL, last_updated DATETIME, job_id varchar(255), download_pct int(10) unsigned, download_state varchar(255), url varchar(255), format varchar(255), checksum varchar(255), error_str varchar(255), local_path varchar(255), install_path varchar(255), size bigint unsigned COMMENT 'the size of the template on the pool', state varchar(255) NOT NULL, update_count bigint unsigned NOT NULL, updated DATETIME, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2025-02-06 08:30:22,704 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE cloud.template_store_ref ( id bigint unsigned NOT NULL auto_increment, store_id bigint unsigned, template_id bigint unsigned NOT NULL, created DATETIME NOT NULL, last_updated DATETIME, job_id varchar(255), download_pct int(10) unsigned, size bigint unsigned, store_role varchar(255), physical_size bigint unsigned DEFAULT 0, download_state varchar(255), error_str varchar(255), local_path varchar(255), install_path varchar(255), url varchar(255), state varchar(255) NOT NULL, destroyed tinyint(1) COMMENT 'indicates whether the template_store entry was destroyed by the user or not', is_copy tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates whether this was copied ', update_count bigint unsigned, ref_cnt bigint unsigned DEFAULT 0, updated datetime, PRIMARY KEY (id), INDEX i_template_store_ref__store_id(store_id), CONSTRAINT fk_template_store_ref__template_id FOREIGN KEY fk_template_store_ref__template_id (template_id) REFERENCES vm_template (id), INDEX i_template_store_ref__template_id(template_id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2025-02-06 08:30:22,795 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE cloud.volume_store_ref ( id bigint unsigned NOT NULL auto_increment, store_id bigint unsigned NOT NULL, volume_id bigint unsigned NOT NULL, zone_id bigint unsigned NOT NULL, created DATETIME NOT NULL, last_updated DATETIME, job_id varchar(255), download_pct int(10) unsigned, size bigint unsigned, physical_size bigint unsigned DEFAULT 0, download_state varchar(255), checksum varchar(255) COMMENT 'checksum for the data disk', error_str varchar(255), local_path varchar(255), install_path varchar(255), url varchar(255), download_url varchar(255), state varchar(255) NOT NULL, destroyed tinyint(1) COMMENT 'indicates whether the volume_host entry was destroyed by the user or not', update_count bigint unsigned, ref_cnt bigint unsigned, updated datetime, PRIMARY KEY (id), CONSTRAINT fk_volume_store_ref__store_id FOREIGN KEY fk_volume_store_ref__store_id (store_id) REFERENCES image_store (id) ON DELETE CASCADE, INDEX i_volume_store_ref__store_id(store_id), CONSTRAINT fk_volume_store_ref__volume_id FOREIGN KEY fk_volume_store_ref__volume_id (volume_id) REFERENCES volumes (id), INDEX i_volume_store_ref__volume_id(volume_id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2025-02-06 08:30:27,533 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, volumes.display_volume, volumes.format, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id OR volumes.iso_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:27,746 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS select vm_template.id, vm_template.uuid, vm_template.unique_name, vm_template.name, vm_template.public, vm_template.featured, vm_template.type, vm_template.hvm, vm_template.bits, vm_template.url, vm_template.format, vm_template.created, vm_template.checksum, vm_template.display_text, vm_template.enable_password, vm_template.dynamically_scalable, vm_template.guest_os_id, guest_os.uuid guest_os_uuid, guest_os.display_name guest_os_name, vm_template.bootable, vm_template.prepopulate, vm_template.cross_zones, vm_template.hypervisor_type, vm_template.extractable, vm_template.template_tag, vm_template.sort_key, vm_template.removed, vm_template.enable_sshkey, source_template.id source_template_id, source_template.uuid source_template_uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, launch_permission.account_id lp_account_id, template_store_ref.store_id, image_store.scope as store_scope, template_store_ref.state, template_store_ref.download_state, template_store_ref.download_pct, template_store_ref.error_str, template_store_ref.size, template_store_ref.destroyed, template_store_ref.created created_on_store, vm_template_details.name detail_name, vm_template_details.value detail_value, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) as temp_zone_pair from cloud.vm_template inner join cloud.guest_os ON guest_os.id = vm_template.guest_os_id inner join cloud.account ON account.id = vm_template.account_id inner join cloud.domain ON domain.id = account.domain_id left join cloud.projects ON projects.project_account_id = account.id left join cloud.vm_template_details ON vm_template_details.template_id = vm_template.id left join cloud.vm_template source_template ON source_template.id = vm_template.source_template_id left join cloud.template_store_ref ON template_store_ref.template_id = vm_template.id and template_store_ref.store_role = 'Image' left join cloud.image_store ON image_store.removed is NULL AND template_store_ref.store_id is not NULL AND image_store.id = template_store_ref.store_id left join cloud.template_zone_ref ON template_zone_ref.template_id = vm_template.id AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null left join cloud.data_center ON (image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = data_center.id) left join cloud.launch_permission ON launch_permission.template_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = vm_template.id and (resource_tags.resource_type = 'Template' or resource_tags.resource_type='ISO')
2025-02-06 08:30:28,797 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key last_sent on table alert exception: Can't DROP 'last_sent'; check that column/key exists
2025-02-06 08:30:28,799 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key i_alert__last_sent on table alert exception: Can't DROP 'i_alert__last_sent'; check that column/key exists
2025-02-06 08:30:28,817 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_nsp_id on table baremetal_dhcp_devices exception: Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,818 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_host_id on table baremetal_dhcp_devices exception: Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,818 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_pod_id on table baremetal_dhcp_devices exception: Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists
2025-02-06 08:30:28,819 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_physical_network_id on table baremetal_dhcp_devices exception: Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that column/key exists
2025-02-06 08:30:28,820 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_nsp_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,821 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_host_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,822 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_pod_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists
2025-02-06 08:30:28,823 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_dhcp_devices_physical_network_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that column/key exists
2025-02-06 08:30:28,823 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_pxe_devices_nsp_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists
2025-02-06 08:30:28,824 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_pxe_devices_host_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_pxe_devices_host_id'; check that column/key exists
2025-02-06 08:30:28,825 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_external_pxe_devices_physical_network_id on table baremetal_pxe_devices exception: Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that column/key exists
2025-02-06 08:30:29,311 INFO [c.c.u.d.Upgrade410to420] (main:null) (logid:) migrateDatafromIsoIdInVolumesTable: ignoring Exception: Unknown column 'iso_id1' in 'field list'
2025-02-06 08:30:32,127 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS select vm_template.id, vm_template.uuid, vm_template.unique_name, vm_template.name, vm_template.public, vm_template.featured, vm_template.type, vm_template.hvm, vm_template.bits, vm_template.url, vm_template.format, vm_template.created, vm_template.checksum, vm_template.display_text, vm_template.enable_password, vm_template.dynamically_scalable, vm_template.state template_state, vm_template.guest_os_id, guest_os.uuid guest_os_uuid, guest_os.display_name guest_os_name, vm_template.bootable, vm_template.prepopulate, vm_template.cross_zones, vm_template.hypervisor_type, vm_template.extractable, vm_template.template_tag, vm_template.sort_key, vm_template.removed, vm_template.enable_sshkey, source_template.id source_template_id, source_template.uuid source_template_uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, launch_permission.account_id lp_account_id, template_store_ref.store_id, image_store.scope as store_scope, template_store_ref.state, template_store_ref.download_state, template_store_ref.download_pct, template_store_ref.error_str, template_store_ref.size, template_store_ref.destroyed, template_store_ref.created created_on_store, vm_template_details.name detail_name, vm_template_details.value detail_value, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) as temp_zone_pair from cloud.vm_template inner join cloud.guest_os ON guest_os.id = vm_template.guest_os_id inner join cloud.account ON account.id = vm_template.account_id inner join cloud.domain ON domain.id = account.domain_id left join cloud.projects ON projects.project_account_id = account.id left join cloud.vm_template_details ON vm_template_details.template_id = vm_template.id left join cloud.vm_template source_template ON source_template.id = vm_template.source_template_id left join cloud.template_store_ref ON template_store_ref.template_id = vm_template.id and template_store_ref.store_role = 'Image' and template_store_ref.destroyed=0 left join cloud.image_store ON image_store.removed is NULL AND template_store_ref.store_id is not NULL AND image_store.id = template_store_ref.store_id left join cloud.template_zone_ref ON template_zone_ref.template_id = vm_template.id AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null left join cloud.data_center ON (image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = data_center.id) left join cloud.launch_permission ON launch_permission.template_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = vm_template.id and (resource_tags.resource_type = 'Template' or resource_tags.resource_type='ISO')
2025-02-06 08:30:32,137 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, volumes.display_volume, volumes.format, volumes.path, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id OR volumes.iso_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:33,968 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, volumes.display_volume, volumes.format, volumes.path, volumes.chain_info, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, disk_offering.cache_mode, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, vm_template.name template_name, vm_template.display_text template_display_text, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.vm_template iso ON iso.id = volumes.iso_id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:40,018 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.provisioning_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, volumes.display_volume, volumes.format, volumes.path, volumes.chain_info, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, disk_offering.cache_mode, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, vm_template.name template_name, vm_template.display_text template_display_text, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.vm_template iso ON iso.id = volumes.iso_id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
2025-02-06 08:30:40,162 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS select vm_template.id, vm_template.uuid, vm_template.unique_name, vm_template.name, vm_template.public, vm_template.featured, vm_template.type, vm_template.hvm, vm_template.bits, vm_template.url, vm_template.format, vm_template.created, vm_template.checksum, vm_template.display_text, vm_template.enable_password, vm_template.dynamically_scalable, vm_template.state template_state, vm_template.guest_os_id, guest_os.uuid guest_os_uuid, guest_os.display_name guest_os_name, vm_template.bootable, vm_template.prepopulate, vm_template.cross_zones, vm_template.hypervisor_type, vm_template.extractable, vm_template.template_tag, vm_template.sort_key, vm_template.removed, vm_template.enable_sshkey, source_template.id source_template_id, source_template.uuid source_template_uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, launch_permission.account_id lp_account_id, template_store_ref.store_id, image_store.scope as store_scope, template_store_ref.state, template_store_ref.download_state, template_store_ref.download_pct, template_store_ref.error_str, template_store_ref.size, template_store_ref.destroyed, template_store_ref.created created_on_store, vm_template_details.name detail_name, vm_template_details.value detail_value, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) as temp_zone_pair from cloud.vm_template inner join cloud.guest_os ON guest_os.id = vm_template.guest_os_id inner join cloud.account ON account.id = vm_template.account_id inner join cloud.domain ON domain.id = account.domain_id left join cloud.projects ON projects.project_account_id = account.id left join cloud.vm_template_details ON vm_template_details.template_id = vm_template.id left join cloud.vm_template source_template ON source_template.id = vm_template.source_template_id left join cloud.template_store_ref ON template_store_ref.template_id = vm_template.id and template_store_ref.store_role = 'Image' and template_store_ref.destroyed=0 left join cloud.image_store ON image_store.removed is NULL AND template_store_ref.store_id is not NULL AND image_store.id = template_store_ref.store_id left join cloud.template_zone_ref ON template_zone_ref.template_id = vm_template.id AND template_store_ref.store_id is NULL AND template_zone_ref.removed is null left join cloud.data_center ON (image_store.data_center_id = data_center.id OR template_zone_ref.zone_id = data_center.id) left join cloud.launch_permission ON launch_permission.template_id = vm_template.id left join cloud.resource_tags ON resource_tags.resource_id = vm_template.id and (resource_tags.resource_type = 'Template' or resource_tags.resource_type='ISO')
2025-02-06 08:30:43,994 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key i_vm_instance__instance_name on table vm_instance exception: Can't DROP 'i_vm_instance__instance_name'; check that column/key exists
2025-02-06 08:30:44,722 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW template_view AS SELECT vm_template.id AS id, vm_template.uuid AS uuid, vm_template.unique_name AS unique_name, vm_template.name AS name, vm_template.public AS public, vm_template.featured AS featured, vm_template.type AS type, vm_template.hvm AS hvm, vm_template.bits AS bits, vm_template.url AS url, vm_template.format AS format, vm_template.created AS created, vm_template.checksum AS checksum, vm_template.display_text AS display_text, vm_template.enable_password AS enable_password, vm_template.dynamically_scalable AS dynamically_scalable, vm_template.state AS template_state, vm_template.guest_os_id AS guest_os_id, guest_os.uuid AS guest_os_uuid, guest_os.display_name AS guest_os_name, vm_template.bootable AS bootable, vm_template.prepopulate AS prepopulate, vm_template.cross_zones AS cross_zones, vm_template.hypervisor_type AS hypervisor_type, vm_template.extractable AS extractable, vm_template.template_tag AS template_tag, vm_template.sort_key AS sort_key, vm_template.removed AS removed, vm_template.enable_sshkey AS enable_sshkey, source_template.id AS source_template_id, source_template.uuid AS source_template_uuid, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, launch_permission.account_id AS lp_account_id, template_store_ref.store_id AS store_id, image_store.scope AS store_scope, template_store_ref.state AS state, template_store_ref.download_state AS download_state, template_store_ref.download_pct AS download_pct, template_store_ref.error_str AS error_str, template_store_ref.size AS size, template_store_ref.destroyed AS destroyed, template_store_ref.created AS created_on_store, vm_template_details.name AS detail_name, vm_template_details.value AS detail_value, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) AS temp_zone_pair FROM ((((((((((((vm_template JOIN guest_os ON ((guest_os.id = vm_template.guest_os_id))) JOIN account ON ((account.id = vm_template.account_id))) JOIN domain ON ((domain.id = account.domain_id))) LEFT JOIN projects ON ((projects.project_account_id = account.id))) LEFT JOIN vm_template_details ON ((vm_template_details.template_id = vm_template.id))) LEFT JOIN vm_template source_template ON ((source_template.id = vm_template.source_template_id))) LEFT JOIN template_store_ref ON (((template_store_ref.template_id = vm_template.id) AND (template_store_ref.store_role = 'Image') AND (template_store_ref.destroyed = 0)))) LEFT JOIN image_store ON ((ISNULL(image_store.removed) AND (template_store_ref.store_id IS NOT NULL) AND (image_store.id = template_store_ref.store_id)))) LEFT JOIN template_zone_ref ON (((template_zone_ref.template_id = vm_template.id) AND ISNULL(template_store_ref.store_id) AND ISNULL(template_zone_ref.removed)))) LEFT JOIN data_center ON (((image_store.data_center_id = data_center.id) OR (template_zone_ref.zone_id = data_center.id)))) LEFT JOIN launch_permission ON ((launch_permission.template_id = vm_template.id))) LEFT JOIN resource_tags ON (((resource_tags.resource_id = vm_template.id) AND ((resource_tags.resource_type = 'Template') OR (resource_tags.resource_type = 'ISO')))))
2025-02-06 08:30:44,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW volume_view AS SELECT volumes.id AS id, volumes.uuid AS uuid, volumes.name AS name, volumes.device_id AS device_id, volumes.volume_type AS volume_type, volumes.provisioning_type AS provisioning_type, volumes.size AS size, volumes.min_iops AS min_iops, volumes.max_iops AS max_iops, volumes.created AS created, volumes.state AS state, volumes.attached AS attached, volumes.removed AS removed, volumes.pod_id AS pod_id, volumes.display_volume AS display_volume, volumes.format AS format, volumes.path AS path, volumes.chain_info AS chain_info, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, data_center.networktype AS data_center_type, vm_instance.id AS vm_id, vm_instance.uuid AS vm_uuid, vm_instance.name AS vm_name, vm_instance.state AS vm_state, vm_instance.vm_type AS vm_type, user_vm.display_name AS vm_display_name, volume_store_ref.size AS volume_store_size, volume_store_ref.download_pct AS download_pct, volume_store_ref.download_state AS download_state, volume_store_ref.error_str AS error_str, volume_store_ref.created AS created_on_store, disk_offering.id AS disk_offering_id, disk_offering.uuid AS disk_offering_uuid, disk_offering.name AS disk_offering_name, disk_offering.display_text AS disk_offering_display_text, disk_offering.use_local_storage AS use_local_storage, disk_offering.system_use AS system_use, disk_offering.bytes_read_rate AS bytes_read_rate, disk_offering.bytes_write_rate AS bytes_write_rate, disk_offering.iops_read_rate AS iops_read_rate, disk_offering.iops_write_rate AS iops_write_rate, disk_offering.cache_mode AS cache_mode, storage_pool.id AS pool_id, storage_pool.uuid AS pool_uuid, storage_pool.name AS pool_name, cluster.hypervisor_type AS hypervisor_type, vm_template.id AS template_id, vm_template.uuid AS template_uuid, vm_template.extractable AS extractable, vm_template.type AS template_type, vm_template.name AS template_name, vm_template.display_text AS template_display_text, iso.id AS iso_id, iso.uuid AS iso_uuid, iso.name AS iso_name, iso.display_text AS iso_display_text, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, async_job.id AS job_id, async_job.uuid AS job_uuid, async_job.job_status AS job_status, async_job.account_id AS job_account_id FROM ((((((((((((((volumes JOIN account ON ((volumes.account_id = account.id))) JOIN domain ON ((volumes.domain_id = domain.id))) LEFT JOIN projects ON ((projects.project_account_id = account.id))) LEFT JOIN data_center ON ((volumes.data_center_id = data_center.id))) LEFT JOIN vm_instance ON ((volumes.instance_id = vm_instance.id))) LEFT JOIN user_vm ON ((user_vm.id = vm_instance.id))) LEFT JOIN volume_store_ref ON ((volumes.id = volume_store_ref.volume_id))) LEFT JOIN disk_offering ON ((volumes.disk_offering_id = disk_offering.id))) LEFT JOIN storage_pool ON ((volumes.pool_id = storage_pool.id))) LEFT JOIN cluster ON ((storage_pool.cluster_id = cluster.id))) LEFT JOIN vm_template ON ((volumes.template_id = vm_template.id))) LEFT JOIN vm_template iso ON ((iso.id = volumes.iso_id))) LEFT JOIN resource_tags ON (((resource_tags.resource_id = volumes.id) AND (resource_tags.resource_type = 'Volume')))) LEFT JOIN async_job ON (((async_job.instance_id = volumes.id) AND (async_job.instance_type = 'Volume') AND (async_job.job_status = 0))))
2025-02-06 08:30:49,436 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS SELECT volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.provisioning_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.display_volume, volumes.format, volumes.path, volumes.chain_info, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, disk_offering.cache_mode, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.id cluster_id, cluster.name cluster_name, cluster.uuid cluster_uuid, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, vm_template.name template_name, vm_template.display_text template_display_text, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id, host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid, host_pod_ref.name pod_name, resource_tag_account.account_name tag_account_name, resource_tag_domain.uuid tag_domain_uuid, resource_tag_domain.name tag_domain_name from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.host_pod_ref ON storage_pool.pod_id = host_pod_ref.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.vm_template iso ON iso.id = volumes.iso_id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0 left join cloud.account resource_tag_account ON resource_tag_account.id = resource_tags.account_id left join cloud.domain resource_tag_domain ON resource_tag_domain.id = resource_tags.domain_id
2025-02-06 08:30:49,994 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS SELECT vm_template.id AS id, vm_template.uuid AS uuid, vm_template.unique_name AS unique_name, vm_template.name AS name, vm_template.public AS public, vm_template.featured AS featured, vm_template.type AS type, vm_template.hvm AS hvm, vm_template.bits AS bits, vm_template.url AS url, vm_template.format AS format, vm_template.created AS created, vm_template.checksum AS checksum, vm_template.display_text AS display_text, vm_template.enable_password AS enable_password, vm_template.dynamically_scalable AS dynamically_scalable, vm_template.state AS template_state, vm_template.guest_os_id AS guest_os_id, guest_os.uuid AS guest_os_uuid, guest_os.display_name AS guest_os_name, vm_template.bootable AS bootable, vm_template.prepopulate AS prepopulate, vm_template.cross_zones AS cross_zones, vm_template.hypervisor_type AS hypervisor_type, vm_template.extractable AS extractable, vm_template.template_tag AS template_tag, vm_template.sort_key AS sort_key, vm_template.removed AS removed, vm_template.enable_sshkey AS enable_sshkey, parent_template.id AS parent_template_id, parent_template.uuid AS parent_template_uuid, source_template.id AS source_template_id, source_template.uuid AS source_template_uuid, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, launch_permission.account_id AS lp_account_id, template_store_ref.store_id AS store_id, image_store.scope AS store_scope, template_store_ref.state AS state, template_store_ref.download_state AS download_state, template_store_ref.download_pct AS download_pct, template_store_ref.error_str AS error_str, template_store_ref.size AS size, template_store_ref.physical_size AS physical_size, template_store_ref.destroyed AS destroyed, template_store_ref.created AS created_on_store, vm_template_details.name AS detail_name, vm_template_details.value AS detail_value, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) AS temp_zone_pair, vm_template.direct_download AS direct_download FROM (((((((((((((vm_template JOIN guest_os ON ((guest_os.id = vm_template.guest_os_id))) JOIN account ON ((account.id = vm_template.account_id))) JOIN domain ON ((domain.id = account.domain_id))) LEFT JOIN projects ON ((projects.project_account_id = account.id))) LEFT JOIN vm_template_details ON ((vm_template_details.template_id = vm_template.id))) LEFT JOIN vm_template source_template ON ((source_template.id = vm_template.source_template_id))) LEFT JOIN template_store_ref ON (((template_store_ref.template_id = vm_template.id) AND (template_store_ref.store_role = 'Image') AND (template_store_ref.destroyed = 0)))) LEFT JOIN vm_template parent_template ON ((parent_template.id = vm_template.parent_template_id))) LEFT JOIN image_store ON ((ISNULL(image_store.removed) AND (template_store_ref.store_id IS NOT NULL) AND (image_store.id = template_store_ref.store_id)))) LEFT JOIN template_zone_ref ON (((template_zone_ref.template_id = vm_template.id) AND ISNULL(template_store_ref.store_id) AND ISNULL(template_zone_ref.removed)))) LEFT JOIN data_center ON (((image_store.data_center_id = data_center.id) OR (template_zone_ref.zone_id = data_center.id)))) LEFT JOIN launch_permission ON ((launch_permission.template_id = vm_template.id))) LEFT JOIN resource_tags ON (((resource_tags.resource_id = vm_template.id) AND ((resource_tags.resource_type = 'Template') OR (resource_tags.resource_type = 'ISO')))))
2025-02-06 08:30:50,459 ERROR [c.c.u.PropertiesUtil] (main:null) (logid:) Unable to find properties file: commands.properties
2025-02-06 08:30:50,882 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- changed fingerprint type to TEXT, it avoids db exception when creating the certificate issue #3123
2025-02-06 08:30:54,460 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS SELECT vm_template.id AS id, vm_template.uuid AS uuid, vm_template.unique_name AS unique_name, vm_template.name AS name, vm_template.public AS public, vm_template.featured AS featured, vm_template.type AS type, vm_template.hvm AS hvm, vm_template.bits AS bits, vm_template.url AS url, vm_template.format AS format, vm_template.created AS created, vm_template.checksum AS checksum, vm_template.display_text AS display_text, vm_template.enable_password AS enable_password, vm_template.dynamically_scalable AS dynamically_scalable, vm_template.state AS template_state, vm_template.guest_os_id AS guest_os_id, guest_os.uuid AS guest_os_uuid, guest_os.display_name AS guest_os_name, vm_template.bootable AS bootable, vm_template.prepopulate AS prepopulate, vm_template.cross_zones AS cross_zones, vm_template.hypervisor_type AS hypervisor_type, vm_template.extractable AS extractable, vm_template.template_tag AS template_tag, vm_template.sort_key AS sort_key, vm_template.removed AS removed, vm_template.enable_sshkey AS enable_sshkey, parent_template.id AS parent_template_id, parent_template.uuid AS parent_template_uuid, source_template.id AS source_template_id, source_template.uuid AS source_template_uuid, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, launch_permission.account_id AS lp_account_id, template_store_ref.store_id AS store_id, image_store.scope AS store_scope, template_store_ref.state AS state, template_store_ref.download_state AS download_state, template_store_ref.download_pct AS download_pct, template_store_ref.error_str AS error_str, template_store_ref.size AS size, template_store_ref.physical_size AS physical_size, template_store_ref.destroyed AS destroyed, template_store_ref.created AS created_on_store, vm_template_details.name AS detail_name, vm_template_details.value AS detail_value, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, CONCAT(vm_template.id, '', IFNULL(data_center.id, 0)) AS temp_zone_pair, vm_template.direct_download AS direct_download, 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_type = 'ISO')))))
2025-02-06 08:30:59,531 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.volume_view AS SELECT volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.provisioning_type, volumes.size, volumes.min_iops, volumes.max_iops, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.display_volume, volumes.format, volumes.path, volumes.chain_info, volumes.external_uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_store_ref.size volume_store_size, volume_store_ref.download_pct, volume_store_ref.download_state, volume_store_ref.error_str, volume_store_ref.created created_on_store, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, service_offering.system_use, disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, disk_offering.iops_read_rate, disk_offering.iops_write_rate, disk_offering.cache_mode, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.id cluster_id, cluster.name cluster_name, cluster.uuid cluster_uuid, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, vm_template.name template_name, vm_template.display_text template_display_text, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id, host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid, host_pod_ref.name pod_name, resource_tag_account.account_name tag_account_name, resource_tag_domain.uuid tag_domain_uuid, resource_tag_domain.name tag_domain_name from cloud.volumes inner join cloud.account ON volumes.account_id = account.id inner join cloud.domain ON volumes.domain_id = domain.id left join cloud.projects ON projects.project_account_id = account.id left join cloud.data_center ON volumes.data_center_id = data_center.id left join cloud.vm_instance ON volumes.instance_id = vm_instance.id left join cloud.user_vm ON user_vm.id = vm_instance.id left join cloud.volume_store_ref ON volumes.id = volume_store_ref.volume_id left join cloud.service_offering ON vm_instance.service_offering_id = service_offering.id left join cloud.disk_offering ON volumes.disk_offering_id = disk_offering.id left join cloud.storage_pool ON volumes.pool_id = storage_pool.id left join cloud.host_pod_ref ON storage_pool.pod_id = host_pod_ref.id left join cloud.cluster ON storage_pool.cluster_id = cluster.id left join cloud.vm_template ON volumes.template_id = vm_template.id left join cloud.vm_template iso ON iso.id = volumes.iso_id left join cloud.resource_tags ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join cloud.async_job ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0 left join cloud.account resource_tag_account ON resource_tag_account.id = resource_tags.account_id left join cloud.domain resource_tag_domain ON resource_tag_domain.id = resource_tags.domain_id
2025-02-06 08:31:02,690 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW cloud.template_view AS SELECT vm_template.id AS id, vm_template.uuid AS uuid, vm_template.unique_name AS unique_name, vm_template.name AS name, vm_template.public AS public, vm_template.featured AS featured, vm_template.type AS type, vm_template.hvm AS hvm, vm_template.bits AS bits, vm_template.url AS url, vm_template.format AS format, vm_template.created AS created, vm_template.checksum AS checksum, vm_template.display_text AS display_text, vm_template.enable_password AS enable_password, vm_template.dynamically_scalable AS dynamically_scalable, vm_template.state AS template_state, vm_template.guest_os_id AS guest_os_id, guest_os.uuid AS guest_os_uuid, guest_os.display_name AS guest_os_name, vm_template.bootable AS bootable, vm_template.prepopulate AS prepopulate, vm_template.cross_zones AS cross_zones, vm_template.hypervisor_type AS hypervisor_type, vm_template.extractable AS extractable, vm_template.template_tag AS template_tag, vm_template.sort_key AS sort_key, vm_template.removed AS removed, vm_template.enable_sshkey AS enable_sshkey, parent_template.id AS parent_template_id, parent_template.uuid AS parent_template_uuid, source_template.id AS source_template_id, source_template.uuid AS source_template_uuid, account.id AS account_id, account.uuid AS account_uuid, account.account_name AS account_name, account.type AS account_type, domain.id AS domain_id, domain.uuid AS domain_uuid, domain.name AS domain_name, domain.path AS domain_path, projects.id AS project_id, projects.uuid AS project_uuid, projects.name AS project_name, data_center.id AS data_center_id, data_center.uuid AS data_center_uuid, data_center.name AS data_center_name, launch_permission.account_id AS lp_account_id, template_store_ref.store_id AS store_id, image_store.scope AS store_scope, template_store_ref.state AS state, template_store_ref.download_state AS download_state, template_store_ref.download_pct AS download_pct, template_store_ref.error_str AS error_str, template_store_ref.size AS size, template_store_ref.physical_size AS physical_size, template_store_ref.destroyed AS destroyed, template_store_ref.created AS created_on_store, vm_template_details.name AS detail_name, vm_template_details.value AS detail_value, resource_tags.id AS tag_id, resource_tags.uuid AS tag_uuid, resource_tags.key AS tag_key, resource_tags.value AS tag_value, resource_tags.domain_id AS tag_domain_id, domain.uuid AS tag_domain_uuid, domain.name AS tag_domain_name, resource_tags.account_id AS tag_account_id, account.account_name AS tag_account_name, resource_tags.resource_id AS tag_resource_id, resource_tags.resource_uuid AS tag_resource_uuid, resource_tags.resource_type AS tag_resource_type, resource_tags.customer AS tag_customer, CONCAT(vm_template.id, '_', IFNULL(data_center.id, 0)) AS temp_zone_pair, vm_template.direct_download AS direct_download, vm_template.deploy_as_is AS deploy_as_is, user_data.id AS user_data_id, user_data.uuid AS user_data_uuid, user_data.name AS user_data_name, user_data.params AS user_data_params, vm_template.user_data_link_policy AS user_data_policy FROM (((((((((((((vm_template JOIN guest_os ON ((guest_os.id = vm_template.guest_os_id))) JOIN account ON ((account.id = vm_template.account_id))) JOIN domain ON ((domain.id = account.domain_id))) LEFT JOIN projects ON ((projects.project_account_id = account.id))) LEFT JOIN vm_template_details ON ((vm_template_details.template_id = vm_template.id))) LEFT JOIN vm_template source_template ON ((source_template.id = vm_template.source_template_id))) LEFT JOIN template_store_ref ON (((template_store_ref.template_id = vm_template.id) AND (template_store_ref.store_role = 'Image') AND (template_store_ref.destroyed = 0)))) LEFT JOIN vm_template parent_template ON ((parent_template.id = vm_template.parent_template_id))) LEFT JOIN image_store ON ((ISNULL(image_store.removed) AND (template_store_ref.store_id IS NOT NULL) AND (image_store.id = template_store_ref.store_id)))) LEFT JOIN template_zone_ref ON (((template_zone_ref.template_id = vm_template.id) AND ISNULL(template_store_ref.store_id) AND ISNULL(template_zone_ref.removed)))) LEFT JOIN data_center ON (((image_store.data_center_id = data_center.id) OR (template_zone_ref.zone_id = data_center.id)))) LEFT JOIN launch_permission ON ((launch_permission.template_id = vm_template.id))) LEFT JOIN user_data ON ((user_data.id = vm_template.user_data_id)) LEFT JOIN resource_tags ON (((resource_tags.resource_id = vm_template.id) AND ((resource_tags.resource_type = 'Template') OR (resource_tags.resource_type = 'ISO')))))
2025-02-06 08:31:03,361 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE cloud.configuration SET kind = 'Select', options = 'Error,Migration,ForceStop' where name = 'host.maintenance.local.storage.strategy'
2025-02-06 08:31:05,043 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_user_data_id on table cloud.user_vm exception: Can't DROP 'fk_user_data_id'; check that column/key exists
2025-02-06 08:31:05,045 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_user_vm__user_data_id on table cloud.user_vm exception: Can't DROP 'fk_user_vm__user_data_id'; check that column/key exists
2025-02-06 08:31:05,046 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_user_data_id on table cloud.user_vm exception: Can't DROP 'fk_user_data_id'; check that column/key exists
2025-02-06 08:31:05,051 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_user_vm__user_data_id on table cloud.user_vm exception: Can't DROP 'fk_user_vm__user_data_id'; check that column/key exists
2025-02-06 08:31:05,099 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_user_data_id on table cloud.vm_template exception: Can't DROP 'fk_user_data_id'; check that column/key exists
2025-02-06 08:31:05,099 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_vm_template__user_data_id on table cloud.vm_template exception: Can't DROP 'fk_vm_template__user_data_id'; check that column/key exists
2025-02-06 08:31:05,100 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_user_data_id on table cloud.vm_template exception: Can't DROP 'fk_user_data_id'; check that column/key exists
2025-02-06 08:31:05,101 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_vm_template__user_data_id on table cloud.vm_template exception: Can't DROP 'fk_vm_template__user_data_id'; check that column/key exists
2025-02-06 08:31:05,163 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_passphrase_id on table cloud.volumes exception: Can't DROP 'fk_passphrase_id'; check that column/key exists
2025-02-06 08:31:05,164 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop foreign key fk_volumes__passphrase_id on table cloud.volumes exception: Can't DROP 'fk_volumes__passphrase_id'; check that column/key exists
2025-02-06 08:31:05,165 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_passphrase_id on table cloud.volumes exception: Can't DROP 'fk_passphrase_id'; check that column/key exists
2025-02-06 08:31:05,166 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null) (logid:) Ignored SQL Exception when trying to drop key fk_volumes__passphrase_id on table cloud.volumes exception: Can't DROP 'fk_volumes__passphrase_id'; check that column/key exists
2025-02-06 08:31:24,900 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 08:35:07,894 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 08:40:41,589 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 08:53:31,545 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 09:01:27,852 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 09:14:38,024 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 09:15:02,403 ERROR [c.c.u.d.ConnectionConcierge] (ConnectionConcierge-1:ctx-01637801) (logid:1f1e5aa6) Unable to keep the db connection for LockController1
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
2025-02-06 09:17:38,620 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 09:17:44,412 ERROR [c.c.u.d.ConnectionConcierge] (ConnectionConcierge-1:ctx-c47f37a7) (logid:85bc0458) Unable to keep the db connection for LockController1
java.sql.SQLNonTransientConnectionException: Server shutdown in progress
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
2025-02-06 09:17:49,005 ERROR [c.c.u.d.T.Transaction] (ConnectionConcierge-1:ctx-c47f37a7) (logid:85bc0458) Unexpected exception:
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:211)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: java.net.ConnectException: 连接被拒绝 (Connection refused)
2025-02-06 10:39:07,814 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 11:07:49,401 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration
2025-02-06 11:13:48,987 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Failed to configure ClusterManagerImpl
javax.naming.ConfigurationException: cluster node IP should be valid local address where the server is running, please check your configuration

sudo vim /etc/cloudstack/management/db.properties
cluster.node.IP=127.0.0.1

HTTP ERROR 503 Service Unavailable
URI: /client/
STATUS: 503
MESSAGE: Service Unavailable
SERVLET: -

"Still not working"