Cloudstack 4.18 HTTP 503 错误（MySQL 8.0） #10384

tomorrrow666 · 2025-02-08T02:45:49Z

tomorrrow666
Feb 8, 2025

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]

2025-02-08T02:45:52Z

boring-cyborg[bot]
bot Feb 8, 2025

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

0 replies

DaanHoogland · 2025-02-09T09:06:26Z

DaanHoogland
Feb 9, 2025
Collaborator

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

0 replies

tomorrrow666 · 2025-02-10T00:36:30Z

tomorrrow666
Feb 10, 2025
Author

The UI page reports an error.

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

There are no obvious errors in the logs.

0 replies

tomorrrow666 · 2025-02-10T01:07:01Z

tomorrrow666
Feb 10, 2025
Author

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

0 replies

weizhouapache · 2025-02-10T07:28:28Z

weizhouapache
Feb 10, 2025
Collaborator

@tomorrrow666
can you share the full log ?

0 replies

tomorrrow666 · 2025-02-10T07:34:58Z

tomorrrow666
Feb 10, 2025
Author

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

0 replies

weizhouapache · 2025-02-10T07:39:03Z

weizhouapache
Feb 10, 2025
Collaborator

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

0 replies

tomorrrow666 · 2025-02-10T07:58:52Z

tomorrrow666
Feb 10, 2025
Author

management-server.log

setupManagement.log

0 replies

weizhouapache · 2025-02-10T12:06:50Z

weizhouapache
Feb 10, 2025
Collaborator

@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 ?

0 replies

tomorrrow666 · 2025-02-11T04:36:55Z

tomorrrow666
Feb 11, 2025
Author

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

0 replies

weizhouapache · 2025-02-11T08:17:16Z

weizhouapache
Feb 11, 2025
Collaborator

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

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

0 replies

tomorrrow666 · 2025-02-11T09:00:01Z

tomorrrow666
Feb 11, 2025
Author

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"

0 replies

weizhouapache · 2025-02-11T09:17:20Z

weizhouapache
Feb 11, 2025
Collaborator

@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

0 replies

tomorrrow666 · 2025-02-11T10:10:12Z

tomorrrow666
Feb 11, 2025
Author

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"

0 replies

weizhouapache · 2025-02-11T11:15:05Z

weizhouapache
Feb 11, 2025
Collaborator

@tomorrrow666
any new logs on 2025-02-11 ?

0 replies

tomorrrow666 · 2025-02-12T00:09:25Z

tomorrrow666
Feb 12, 2025
Author

management-server.log

the latest log

0 replies

weizhouapache · 2025-02-12T07:43:15Z

weizhouapache
Feb 12, 2025
Collaborator

it looks like db.properties file cannot be loaded.

@tomorrrow666
if this is a fresh installation, I suggest you set up the database again.
you can specify the management server ip with -i

  -i MSHOSTIP, --mshost=MSHOSTIP
                        Cluster management server host IP. A string, by
                        default it will try to detect a local IP

0 replies

tomorrrow666 · 2025-02-13T06:39:07Z

tomorrrow666
Feb 13, 2025
Author

"Error adding host agent"
Could not add host at [http://192.168.1.20] with zone [1], pod [1] and cluster [1] due to: [ can't setup agent, due to com.cloud.utils.exception.CloudRuntimeException: Failed to setup keystore on the KVM host: 192.168.1.20 - Failed to setup keystore on the KVM host: 192.168.1.20].

0 replies

weizhouapache · 2025-02-13T08:10:08Z

weizhouapache
Feb 13, 2025
Collaborator

"Error adding host agent" Could not add host at [http://192.168.1.20] with zone [1], pod [1] and cluster [1] due to: [ can't setup agent, due to com.cloud.utils.exception.CloudRuntimeException: Failed to setup keystore on the KVM host: 192.168.1.20 - Failed to setup keystore on the KVM host: 192.168.1.20].

@tomorrrow666
is the management server Up now ?

0 replies

tomorrrow666 · 2025-02-13T08:16:28Z

tomorrrow666
Feb 13, 2025
Author

"Not started, reinstalled the management service using an alternative method."
"Error adding host"

0 replies

weizhouapache · 2025-02-13T12:32:12Z

weizhouapache
Feb 13, 2025
Collaborator

@tomorrrow666
have you setup cloud bridges ?

0 replies

DaanHoogland · 2025-02-13T12:33:11Z

DaanHoogland
Feb 13, 2025
Collaborator

@tomorrrow666 as 4.18 is out of support, could you try with 4.19 or 4.20?

0 replies

weizhouapache · 2025-02-13T12:33:26Z

weizhouapache
Feb 13, 2025
Collaborator

"Not started, reinstalled the management service using an alternative method."

what did you mean ? alternative method ?
@tomorrrow666

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Cloudstack 4.18 HTTP 503 错误（MySQL 8.0） #10384

{{title}}

Replies: 23 comments

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Cloudstack 4.18 HTTP 503 错误 （MySQL 8.0） #10384

tomorrrow666 Feb 8, 2025

Replies: 23 comments

boring-cyborg[bot] bot Feb 8, 2025

DaanHoogland Feb 9, 2025 Collaborator

tomorrrow666 Feb 10, 2025 Author

tomorrrow666 Feb 10, 2025 Author

weizhouapache Feb 10, 2025 Collaborator

tomorrrow666 Feb 10, 2025 Author

weizhouapache Feb 10, 2025 Collaborator

tomorrrow666 Feb 10, 2025 Author

weizhouapache Feb 10, 2025 Collaborator

tomorrrow666 Feb 11, 2025 Author

weizhouapache Feb 11, 2025 Collaborator

tomorrrow666 Feb 11, 2025 Author

weizhouapache Feb 11, 2025 Collaborator

tomorrrow666 Feb 11, 2025 Author

weizhouapache Feb 11, 2025 Collaborator

tomorrrow666 Feb 12, 2025 Author

weizhouapache Feb 12, 2025 Collaborator

tomorrrow666 Feb 13, 2025 Author

weizhouapache Feb 13, 2025 Collaborator

tomorrrow666 Feb 13, 2025 Author

weizhouapache Feb 13, 2025 Collaborator

DaanHoogland Feb 13, 2025 Collaborator

weizhouapache Feb 13, 2025 Collaborator

Cloudstack 4.18 HTTP 503 错误（MySQL 8.0） #10384

tomorrrow666
Feb 8, 2025

boring-cyborg[bot]
bot Feb 8, 2025

DaanHoogland
Feb 9, 2025
Collaborator

tomorrrow666
Feb 10, 2025
Author

tomorrrow666
Feb 10, 2025
Author

weizhouapache
Feb 10, 2025
Collaborator

tomorrrow666
Feb 10, 2025
Author

weizhouapache
Feb 10, 2025
Collaborator

tomorrrow666
Feb 10, 2025
Author

weizhouapache
Feb 10, 2025
Collaborator

tomorrrow666
Feb 11, 2025
Author

weizhouapache
Feb 11, 2025
Collaborator

tomorrrow666
Feb 11, 2025
Author

weizhouapache
Feb 11, 2025
Collaborator

tomorrrow666
Feb 11, 2025
Author

weizhouapache
Feb 11, 2025
Collaborator

tomorrrow666
Feb 12, 2025
Author

weizhouapache
Feb 12, 2025
Collaborator

tomorrrow666
Feb 13, 2025
Author

weizhouapache
Feb 13, 2025
Collaborator

tomorrrow666
Feb 13, 2025
Author

weizhouapache
Feb 13, 2025
Collaborator

DaanHoogland
Feb 13, 2025
Collaborator

weizhouapache
Feb 13, 2025
Collaborator