Hi Andrija,
You were spot on about the mysql-connector-python issue. A critical bug was
raised on 8.0.19 2 days ago concerning the issue.
Following your instructions, I went back to 8.0.18 and
cloudstack-setup-management completes as expected however a new issue has
popped up. It seems there is an issue when CSMS attempts to upgrade the
database. I am hoping you can pinpoint what the issue is and provide a
recommendation.
020-01-17 14:35:36,858 INFO [o.e.j.s.h.ContextHandler] (Thread-1:null)
(logid:) Stopped
o.e.j.w.WebAppContext@6e38921c{/client,null,UNAVAILABLE}{/usr/share/cloudstack-management/webapp}
2020-01-17 14:35:38,419 INFO [o.a.c.ServerDaemon] (main:null) (logid:) Server
configuration file found: /etc/cloudstack/management/server.properties
2020-01-17 14:35:38,430 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
2020-01-17 14:35:38,443 INFO [o.e.j.u.log] (main:null) (logid:) Logging
initialized @1005ms to org.eclipse.jetty.util.log.Slf4jLog
2020-01-17 14:35:38,684 INFO [o.e.j.s.Server] (main:null) (logid:)
jetty-9.4.z-SNAPSHOT, build timestamp: 2017-11-21T16:27:37-05:00, git hash:
82b8fb23f757335bb3329d540ce37a2a2615f0a8
2020-01-17 14:35:38,715 INFO [o.e.j.s.AbstractNCSARequestLog] (main:null)
(logid:) Opened /var/log/cloudstack/management/access.log
2020-01-17 14:35:38,812 INFO [o.e.j.w.StandardDescriptorProcessor] (main:null)
(logid:) NO JSP Support for /client, did not find
org.eclipse.jetty.jsp.JettyJspServlet
2020-01-17 14:35:38,841 INFO [o.e.j.s.session] (main:null) (logid:)
DefaultSessionIdManager workerName=node0
2020-01-17 14:35:38,841 INFO [o.e.j.s.session] (main:null) (logid:) No
SessionScavenger set, using defaults
2020-01-17 14:35:38,843 INFO [o.e.j.s.session] (main:null) (logid:) Scavenging
every 600000ms
2020-01-17 14:35:54,716 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.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context.xml]
2020-01-17 14:35:54,716 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.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
2020-01-17 14:35:54,959 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] (main:null)
(logid:) Encryption Type: file
2020-01-17 14:35:55,013 INFO [c.c.u.LogUtils] (main:null) (logid:) log4j
configuration found at /etc/cloudstack/management/log4j-cloud.xml
2020-01-17 14:35:55,046 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Loaded module context [bootstrap] in 331 ms
2020-01-17 14:35:55,047 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: bootstrap
2020-01-17 14:35:55,047 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: system
2020-01-17 14:35:55,047 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: core
2020-01-17 14:35:55,048 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: allocator
2020-01-17 14:35:55,048 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: host-allocator-random
2020-01-17 14:35:55,048 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: planner
2020-01-17 14:35:55,048 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: api-planner
2020-01-17 14:35:55,048 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: baremetal-planner
2020-01-17 14:35:55,048 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: explicit-dedication
2020-01-17 14:35:55,049 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: host-affinity
2020-01-17 14:35:55,049 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: host-anti-affinity
2020-01-17 14:35:55,049 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: implicit-dedication
2020-01-17 14:35:55,049 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-planner
2020-01-17 14:35:55,049 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: skip-heurestics
2020-01-17 14:35:55,049 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: user-concentrated-pod
2020-01-17 14:35:55,050 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-allocator
2020-01-17 14:35:55,050 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: api
2020-01-17 14:35:55,050 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: acl-dynamic-role-based
2020-01-17 14:35:55,050 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: acl-static-role-based
2020-01-17 14:35:55,050 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: cloudian
2020-01-17 14:35:55,050 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ldap
2020-01-17 14:35:55,051 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: md5
2020-01-17 14:35:55,051 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: metrics
2020-01-17 14:35:55,051 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: pbkdf2
2020-01-17 14:35:55,051 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: plaintext
2020-01-17 14:35:55,051 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: prometheus
2020-01-17 14:35:55,051 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: quota
2020-01-17 14:35:55,051 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: rate-limit
2020-01-17 14:35:55,052 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: saml2
2020-01-17 14:35:55,052 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-api
2020-01-17 14:35:55,052 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: sha256salted
2020-01-17 14:35:55,052 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: solidfire-intg-test
2020-01-17 14:35:55,052 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: vmware-sioc
2020-01-17 14:35:55,052 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: api-config
2020-01-17 14:35:55,052 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: backend
2020-01-17 14:35:55,053 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ca
2020-01-17 14:35:55,053 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: root-ca
2020-01-17 14:35:55,053 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: compute
2020-01-17 14:35:55,053 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: baremetal-compute
2020-01-17 14:35:55,053 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: hyperv-compute
2020-01-17 14:35:55,053 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: kvm-compute
2020-01-17 14:35:55,053 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ovm-compute
2020-01-17 14:35:55,054 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ovm3-compute
2020-01-17 14:35:55,054 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-alert-adapter-compute
2020-01-17 14:35:55,054 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-compute
2020-01-17 14:35:55,054 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-fencer
2020-01-17 14:35:55,054 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-investigator
2020-01-17 14:35:55,054 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: vmware-compute
2020-01-17 14:35:55,055 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: xenserver-compute
2020-01-17 14:35:55,055 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: network
2020-01-17 14:35:55,055 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: baremetal-network
2020-01-17 14:35:55,055 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: bigswitch
2020-01-17 14:35:55,055 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: cisco-vnmc
2020-01-17 14:35:55,055 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: contrail
2020-01-17 14:35:55,056 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: elb
2020-01-17 14:35:55,056 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: f5
2020-01-17 14:35:55,056 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: globodns
2020-01-17 14:35:55,056 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: netscaler
2020-01-17 14:35:55,056 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: nvp
2020-01-17 14:35:55,056 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: opendaylight
2020-01-17 14:35:55,056 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ovs
2020-01-17 14:35:55,057 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: paloalto
2020-01-17 14:35:55,057 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-network
2020-01-17 14:35:55,057 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: srx
2020-01-17 14:35:55,057 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ssp
2020-01-17 14:35:55,057 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: vcs
2020-01-17 14:35:55,057 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: vmware-network
2020-01-17 14:35:55,057 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: vxlan
2020-01-17 14:35:55,058 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-alert-adapter-backend
2020-01-17 14:35:55,058 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage
2020-01-17 14:35:55,058 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: baremetal-storage
2020-01-17 14:35:55,058 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-alert-adapter-storage
2020-01-17 14:35:55,058 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-storage
2020-01-17 14:35:55,059 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-template-adapter
2020-01-17 14:35:55,059 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage-allocator
2020-01-17 14:35:55,059 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage-image-default
2020-01-17 14:35:55,059 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage-image-s3
2020-01-17 14:35:55,059 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage-image-swift
2020-01-17 14:35:55,059 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage-volume-cloudbyte
2020-01-17 14:35:55,059 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage-volume-datera
2020-01-17 14:35:55,059 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage-volume-default
2020-01-17 14:35:55,060 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: storage-volume-solidfire
2020-01-17 14:35:55,060 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: vmware-storage
2020-01-17 14:35:55,060 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: discoverer
2020-01-17 14:35:55,060 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: baremetal-discoverer
2020-01-17 14:35:55,060 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: hyperv-discoverer
2020-01-17 14:35:55,060 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ovm-discoverer
2020-01-17 14:35:55,060 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ovm3-discoverer
2020-01-17 14:35:55,061 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: secondary-storage-discoverer
2020-01-17 14:35:55,061 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: server-discoverer
2020-01-17 14:35:55,061 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: vmware-discoverer
2020-01-17 14:35:55,061 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: xenserver-discoverer
2020-01-17 14:35:55,061 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: outofbandmanagement
2020-01-17 14:35:55,061 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: ipmitool
2020-01-17 14:35:55,061 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:null) (logid:) Module Hierarchy: nested-cloudstack
2020-01-17 14:35:55,062 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.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-config-system-context.xml]
2020-01-17 14:35:55,063 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.13.0.0.jar!/META-INF/cloudstack/system/spring-server-system-context.xml]
2020-01-17 14:35:55,063 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.13.0.0.jar!/META-INF/cloudstack/system/spring-core-system-context.xml]
2020-01-17 14:35:55,063 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.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-db-system-context.xml]
2020-01-17 14:35:55,063 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.13.0.0.jar!/META-INF/cloudstack/system/spring-engine-schema-system-checkers-context.xml]
2020-01-17 14:35:55,063 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.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-config-system-context-inheritable.xml]
2020-01-17 14:35:55,063 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.13.0.0.jar!/META-INF/cloudstack/system/spring-core-system-context-inheritable.xml]
2020-01-17 14:35:55,063 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.13.0.0.jar!/META-INF/cloudstack/system/spring-contrail-system-context-inheritable.xml]
2020-01-17 14:35:55,063 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.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
2020-01-17 14:35:56,329 INFO [c.c.u.d.T.Transaction] (main:null) (logid:) Is
Data Base High Availiability enabled? Ans : false
2020-01-17 14:35:56,408 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:)
Successfully loaded DB driver com.mysql.jdbc.Driver
2020-01-17 14:35:56,435 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) DB
driver com.mysql.jdbc.Driver was already loaded.
2020-01-17 14:35:56,437 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) DB
driver com.mysql.jdbc.Driver was already loaded.
2020-01-17 14:35:57,172 DEBUG [c.c.u.d.ConnectionConcierge] (main:null)
(logid:) Registering a database connection for LockMaster1
2020-01-17 14:35:57,172 INFO [c.c.u.d.Merovingian2] (main:null) (logid:)
Cleaning up locks for 144345337593
2020-01-17 14:35:57,177 INFO [c.c.u.d.Merovingian2] (main:null) (logid:)
Released 0 locks for 144345337593
2020-01-17 14:35:57,643 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:null) (logid:) Running system integrity checker
com.cloud.upgrade.DatabaseUpgradeChecker@6ce90bc5
2020-01-17 14:35:57,644 INFO [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Grabbing lock to check for database upgrade.
2020-01-17 14:35:57,749 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) (logid:)
Checking to see if the database is at a version before it was the version table
is created
2020-01-17 14:35:57,806 INFO [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) DB version = 4.0.0 Code Version = 4.13.0.0
2020-01-17 14:35:57,807 INFO [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Database upgrade must be performed from 4.0.0 to 4.13.0.0
2020-01-17 14:35:57,816 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Running upgrade Upgrade40to41 to upgrade from 4.0.0-4.1.0 to 4.1.0
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
Licensed to the Apache Software Foundation (ASF) under one
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- or
more contributor license agreements. See the NOTICE file
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
distributed with this work for additional information
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
regarding copyright ownership. The ASF licenses this file
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- to
you under the Apache License, Version 2.0 (the
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
"License"); you may not use this file except in compliance
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
with the License. You may obtain a copy of the License at
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
http://www.apache.org/licenses/LICENSE-2.0
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
Unless required by applicable law or agreed to in writing,
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
software distributed under the License is distributed on an
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
KIND, either express or implied. See the License for the
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
specific language governing permissions and limitations
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
under the License.
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
Schema upgrade from 4.0.0 to 4.1.0;
2020-01-17 14:35:57,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
2020-01-17 14:35:57,822 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) use
cloud
2020-01-17 14:35:57,823 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) SET
foreign_key_checks = 0
2020-01-17 14:35:57,824 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_template add size bigint unsigned
2020-01-17 14:35:57,859 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_template add state varchar(255)
2020-01-17 14:35:57,894 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_template add update_count bigint unsigned
2020-01-17 14:35:57,930 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_template add updated datetime
2020-01-17 14:35:57,965 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table storage_pool add storage_provider_id bigint unsigned
2020-01-17 14:35:57,977 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table storage_pool add scope varchar(255)
2020-01-17 14:35:57,989 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table storage_pool modify id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL
2020-01-17 14:35:58,003 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table template_spool_ref add state varchar(255)
2020-01-17 14:35:58,013 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table template_spool_ref add update_count bigint unsigned
2020-01-17 14:35:58,023 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table volumes add disk_type varchar(255)
2020-01-17 14:35:58,040 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table volumes drop foreign key `fk_volumes__account_id`
2020-01-17 14:35:58,044 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_instance add column disk_offering_id bigint unsigned
2020-01-17 14:35:58,064 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_instance add column cpu int(10) unsigned
2020-01-17 14:35:58,084 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_instance add column ram bigint unsigned
2020-01-17 14:35:58,103 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_instance add column owner varchar(255)
2020-01-17 14:35:58,125 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_instance add column speed int(10) unsigned
2020-01-17 14:35:58,150 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_instance add column host_name varchar(255)
2020-01-17 14:35:58,176 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_instance add column display_name varchar(255)
2020-01-17 14:35:58,203 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table vm_instance add column `desired_state` varchar(32) NULL
2020-01-17 14:35:58,232 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table data_center add column owner varchar(255)
2020-01-17 14:35:58,252 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table data_center add column created datetime COMMENT 'date created'
2020-01-17 14:35:58,271 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table data_center add column lastUpdated datetime COMMENT 'last updated'
2020-01-17 14:35:58,290 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table data_center add column engine_state varchar(32) NOT NULL DEFAULT
'Disabled' COMMENT 'the engine state of the zone'
2020-01-17 14:35:58,309 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table host_pod_ref add column owner varchar(255)
2020-01-17 14:35:58,326 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table host_pod_ref add column created datetime COMMENT 'date created'
2020-01-17 14:35:58,344 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table host_pod_ref add column lastUpdated datetime COMMENT 'last updated'
2020-01-17 14:35:58,363 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table host_pod_ref add column engine_state varchar(32) NOT NULL DEFAULT
'Disabled' COMMENT 'the engine state of the zone'
2020-01-17 14:35:58,381 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table host add column owner varchar(255)
2020-01-17 14:35:58,402 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table host add column lastUpdated datetime COMMENT 'last updated'
2020-01-17 14:35:58,424 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table host add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled'
COMMENT 'the engine state of the zone'
2020-01-17 14:35:58,445 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table cluster add column owner varchar(255)
2020-01-17 14:35:58,464 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table cluster add column created datetime COMMENT 'date created'
2020-01-17 14:35:58,485 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table cluster add column lastUpdated datetime COMMENT 'last updated'
2020-01-17 14:35:58,504 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter
table cluster add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled'
COMMENT 'the engine state of the zone'
2020-01-17 14:35:58,522 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`vm_compute_tags` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm
id', `compute_tag` varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY
KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:58,529 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`vm_root_disk_tags` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm
id', `root_disk_tag` varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY
KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:58,536 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`vm_network_map` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm
id', `network_id` bigint unsigned NOT NULL COMMENT 'network id', PRIMARY
KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:58,542 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`vm_reservation` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) NOT NULL COMMENT 'reservation
id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `data_center_id`
bigint unsigned NOT NULL COMMENT 'zone id', `pod_id` bigint unsigned NOT NULL
COMMENT 'pod id', `cluster_id` bigint unsigned NOT NULL COMMENT 'cluster id',
`host_id` bigint unsigned NOT NULL COMMENT 'host id', `created` datetime
COMMENT 'date created', `removed` datetime COMMENT 'date removed if not
null', CONSTRAINT `uc_vm_reservation__uuid` UNIQUE (`uuid`), PRIMARY
KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:58,549 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`volume_reservation` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `vm_reservation_id` bigint unsigned NOT NULL
COMMENT 'id of the vm reservation', `vm_id` bigint unsigned NOT NULL COMMENT
'vm id', `volume_id` bigint unsigned NOT NULL COMMENT 'volume id',
`pool_id` bigint unsigned NOT NULL COMMENT 'pool assigned to the volume',
CONSTRAINT `fk_vm_pool_reservation__vm_reservation_id` FOREIGN KEY
(`vm_reservation_id`) REFERENCES `vm_reservation`(`id`) ON DELETE CASCADE,
PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:58,556 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 transfered 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
2020-01-17 14:35:58,564 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`template_s3_ref` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `s3_id` bigint unsigned NOT NULL COMMENT '
Associated S3 instance id', `template_id` bigint unsigned NOT NULL COMMENT '
Associated template id', `created` DATETIME NOT NULL COMMENT ' The creation
timestamp', `size` bigint unsigned COMMENT ' The size of the object',
`physical_size` bigint unsigned DEFAULT 0 COMMENT ' The physical size of the
object', PRIMARY KEY (`id`), CONSTRAINT `uc_template_s3_ref__template_id`
UNIQUE (`template_id`), CONSTRAINT `fk_template_s3_ref__s3_id` FOREIGN KEY
`fk_template_s3_ref__s3_id` (`s3_id`) REFERENCES `s3` (`id`) ON DELETE CASCADE,
CONSTRAINT `fk_template_s3_ref__template_id` FOREIGN KEY
`fk_template_s3_ref__template_id` (`template_id`) REFERENCES `vm_template`
(`id`), INDEX `i_template_s3_ref__s3_id`(`s3_id`), INDEX
`i_template_s3_ref__template_id`(`template_id`) ) ENGINE=InnoDB DEFAULT
CHARSET=utf8
2020-01-17 14:35:58,573 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 's3.enable', 'false', 'enable s3')
2020-01-17 14:35:58,575 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'NetworkManager', 'router.check.poolsize' , '10', 'Numbers of threads using to
check redundant router status.')
2020-01-17 14:35:58,576 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`snapshots` ADD COLUMN `s3_id` bigint unsigned COMMENT 'S3 to
which this snapshot will be stored'
2020-01-17 14:35:58,596 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`snapshots` ADD CONSTRAINT `fk_snapshots__s3_id` FOREIGN KEY
`fk_snapshots__s3_id` (`s3_id`) REFERENCES `s3` (`id`)
2020-01-17 14:35:58,603 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`network_offerings` ADD COLUMN `inline` int(1) unsigned NOT NULL
DEFAULT 0 COMMENT 'Is this network offering LB provider is in inline mode'
2020-01-17 14:35:58,618 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`external_load_balancer_devices` DROP COLUMN `is_inline`
2020-01-17 14:35:58,632 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES
('Network','DEFAULT','NetworkManager','network.dhcp.nondefaultnetwork.setgateway.guestos','Windows','The
guest OS\'s name start with this fields would result in DHCP server response
gateway information even when the network it\'s on is not default network.
Names are separated by comma.')
2020-01-17 14:35:58,634 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`sync_queue` ADD `queue_size` SMALLINT NOT NULL DEFAULT '0'
COMMENT 'number of items being processed by the queue'
2020-01-17 14:35:58,648 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`sync_queue` ADD `queue_size_limit` SMALLINT NOT NULL DEFAULT '1'
COMMENT 'max number of items the queue can process concurrently'
2020-01-17 14:35:58,662 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`sync_queue` DROP INDEX `i_sync_queue__queue_proc_time`
2020-01-17 14:35:58,666 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`sync_queue` DROP COLUMN `queue_proc_time`
2020-01-17 14:35:58,680 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`sync_queue` DROP COLUMN `queue_proc_msid`
2020-01-17 14:35:58,692 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`sync_queue_item` ADD `queue_proc_time` DATETIME COMMENT 'when
processing started for the item' AFTER `queue_proc_number`
2020-01-17 14:35:58,706 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`sync_queue_item` ADD INDEX
`i_sync_queue__queue_proc_time`(`queue_proc_time`)
2020-01-17 14:35:58,711 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`inline_load_balancer_nic_map` DROP FOREIGN KEY
fk_inline_load_balancer_nic_map__load_balancer_id
2020-01-17 14:35:58,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`inline_load_balancer_nic_map` DROP COLUMN load_balancer_id
2020-01-17 14:35:58,726 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE upload ADD uuid VARCHAR(40)
2020-01-17 14:35:58,739 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE async_job modify job_cmd VARCHAR(255)
2020-01-17 14:35:58,760 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`network_offerings` ADD COLUMN `is_persistent` int(1) unsigned
NOT NULL DEFAULT 0 COMMENT 'true if the network offering provides an ability to
create persistent networks'
2020-01-17 14:35:58,775 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
populate uuid column with db id if uuid is null
2020-01-17 14:35:58,775 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`account` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,776 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`alert` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,778 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`async_job` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`cluster` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,782 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`data_center` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,783 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`dc_storage_network_ip_range` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,785 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`disk_offering` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,787 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`domain` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,788 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`event` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,790 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`external_firewall_devices` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,792 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`external_load_balancer_devices` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,793 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`external_nicira_nvp_devices` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,795 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`firewall_rules` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,797 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`guest_os` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,798 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`guest_os_category` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,800 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`host` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,801 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`host_pod_ref` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,802 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`hypervisor_capabilities` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,805 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`instance_group` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,806 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`load_balancer_stickiness_policies` set uuid=id WHERE uuid is
NULL
2020-01-17 14:35:58,808 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`network_external_firewall_device_map` set uuid=id WHERE uuid is
NULL
2020-01-17 14:35:58,809 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`network_external_lb_device_map` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,811 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`network_offerings` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,813 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`networks` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,815 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`nics` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,817 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`physical_network` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,818 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`physical_network_service_providers` set uuid=id WHERE uuid is
NULL
2020-01-17 14:35:58,820 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`physical_network_traffic_types` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,822 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`port_profile` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,823 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`project_invitations` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,825 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`projects` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,827 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`resource_tags` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,829 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`s2s_customer_gateway` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,830 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`s2s_vpn_connection` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,832 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`s2s_vpn_gateway` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,834 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`security_group` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,837 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`security_group_rule` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,839 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`snapshot_schedule` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,841 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`snapshots` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,842 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`snapshot_policy` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,844 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`static_routes` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`storage_pool` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,847 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`swift` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,849 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`upload` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,851 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`user` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,853 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`user_ip_address` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,855 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
UPDATE `cloud`.`user_vm_temp` set uuid=id WHERE uuid is NULL;
2020-01-17 14:35:58,855 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`virtual_router_providers` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,857 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`virtual_supervisor_module` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,859 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`vlan` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,861 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`vm_instance` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,862 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`vm_template` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,864 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`vpc` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,865 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`vpc_gateways` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,867 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`vpc_offerings` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,868 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`vpn_users` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,870 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`volumes` set uuid=id WHERE uuid is NULL
2020-01-17 14:35:58,871 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`configuration` set value = '/var/cloudstack/mnt' where name =
'mount.parent'
2020-01-17 14:35:58,873 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
UPDATE `cloud`.`autoscale_vmgroups` set uuid=id WHERE uuid is NULL;
2020-01-17 14:35:58,873 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
UPDATE `cloud`.`autoscale_vmprofiles` set uuid=id WHERE uuid is NULL;
2020-01-17 14:35:58,873 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
UPDATE `cloud`.`autoscale_policies` set uuid=id WHERE uuid is NULL;
2020-01-17 14:35:58,873 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
UPDATE `cloud`.`counter` set uuid=id WHERE uuid is NULL;
2020-01-17 14:35:58,873 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
UPDATE `cloud`.`conditions` set uuid=id WHERE uuid is NULL;
2020-01-17 14:35:58,873 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'detail.batch.query.size', '2000', 'Default entity detail
batch query size for listing')
2020-01-17 14:35:58,875 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'api.throttling.enabled', 'false', 'Enable/Disable Api
rate limit')
2020-01-17 14:35:58,876 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'api.throttling.interval', '1', 'Time interval (in
seconds) to reset API count')
2020-01-17 14:35:58,878 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'api.throttling.max', '25', 'Max allowed number of APIs
within fixed interval')
2020-01-17 14:35:58,879 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'api.throttling.cachesize', '50000', 'Account based API
count cache size')
2020-01-17 14:35:58,881 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'direct.agent.pool.size', '500', 'Default size for
DirectAgentPool')
2020-01-17 14:35:58,882 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`op_dc_vnet_alloc` DROP INDEX
i_op_dc_vnet_alloc__vnet__data_center_id
2020-01-17 14:35:58,889 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`op_dc_vnet_alloc` ADD CONSTRAINT UNIQUE
`i_op_dc_vnet_alloc__vnet__data_center_id`(`vnet`, `physical_network_id`,
`data_center_id`)
2020-01-17 14:35:58,896 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`op_dc_vnet_alloc` DROP INDEX
i_op_dc_vnet_alloc__vnet__data_center_id__account_id
2020-01-17 14:35:58,902 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`region` ( `id` int unsigned NOT NULL UNIQUE, `name`
varchar(255) NOT NULL UNIQUE, `end_point` varchar(255) NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:58,910 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT INTO `cloud`.`region` values
('1','Local','http://localhost:8080/client/')
2020-01-17 14:35:58,912 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`nicira_nvp_router_map` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `logicalrouter_uuid` varchar(255) NOT NULL
UNIQUE COMMENT 'nicira uuid of logical router', `network_id` bigint unsigned
NOT NULL UNIQUE COMMENT 'cloudstack id of the network', PRIMARY KEY (`id`),
CONSTRAINT `fk_nicira_nvp_router_map__network_id` FOREIGN KEY (`network_id`)
REFERENCES `networks`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT
CHARSET=utf8
2020-01-17 14:35:58,922 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`external_bigswitch_vns_devices` ( `id` bigint unsigned
NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255) UNIQUE,
`physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical
network in to which bigswitch vns device is added', `provider_name`
varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this
bigswitch vns device', `device_name` varchar(255) NOT NULL COMMENT 'name of
the bigswitch vns device', `host_id` bigint unsigned NOT NULL COMMENT 'host
id coresponding to the external bigswitch vns device', PRIMARY KEY (`id`),
CONSTRAINT `fk_external_bigswitch_vns_devices__host_id` FOREIGN KEY (`host_id`)
REFERENCES `host`(`id`) ON DELETE CASCADE, CONSTRAINT
`fk_external_bigswitch_vns_devices__physical_network_id` FOREIGN KEY
(`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE )
ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:58,933 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`counter` ( `id` bigint unsigned NOT NULL UNIQUE
AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `source` varchar(255) NOT
NULL COMMENT 'source e.g. netscaler, snmp', `name` varchar(255) NOT NULL
COMMENT 'Counter name', `value` varchar(255) NOT NULL COMMENT 'Value in case
of source=snmp', `removed` datetime COMMENT 'date removed if not null',
`created` datetime NOT NULL COMMENT 'date created', PRIMARY KEY (`id`),
CONSTRAINT `uc_counter__uuid` UNIQUE (`uuid`), INDEX
`i_counter__removed`(`removed`), INDEX `i_counter__source`(`source`) )
ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:58,942 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`conditions` ( `id` bigint unsigned NOT NULL UNIQUE
AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `counter_id` bigint
unsigned NOT NULL COMMENT 'Counter Id', `threshold` bigint unsigned NOT NULL
COMMENT 'threshold value for the given counter', `relational_operator`
char(2) COMMENT 'relational operator to be used upon the counter and
condition', `domain_id` bigint unsigned NOT NULL COMMENT 'domain the
Condition belongs to', `account_id` bigint unsigned NOT NULL COMMENT 'owner
of this Condition', `removed` datetime COMMENT 'date removed if not null',
`created` datetime NOT NULL COMMENT 'date created', PRIMARY KEY (`id`),
CONSTRAINT `fk_conditions__counter_id` FOREIGN KEY
`fk_condition__counter_id`(`counter_id`) REFERENCES `counter`(`id`),
CONSTRAINT `fk_conditions__account_id` FOREIGN KEY `fk_condition__account_id`
(`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT
`fk_conditions__domain_id` FOREIGN KEY `fk_condition__domain_id` (`domain_id`)
REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_conditions__uuid`
UNIQUE (`uuid`), INDEX `i_conditions__removed`(`removed`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8
2020-01-17 14:35:58,954 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`autoscale_vmprofiles` ( `id` bigint unsigned NOT NULL
auto_increment, `uuid` varchar(40), `zone_id` bigint unsigned NOT NULL,
`domain_id` bigint unsigned NOT NULL, `account_id` bigint unsigned NOT NULL,
`autoscale_user_id` bigint unsigned NOT NULL, `service_offering_id` bigint
unsigned NOT NULL, `template_id` bigint unsigned NOT NULL,
`other_deploy_params` varchar(1024) COMMENT 'other deployment parameters that
is in addition to zoneid,serviceofferingid,domainid',
`destroy_vm_grace_period` int unsigned COMMENT 'the time allowed for existing
connections to get closed before a vm is destroyed', `counter_params`
varchar(1024) COMMENT 'the parameters for the counter to be used to get metric
information from VMs', `created` datetime NOT NULL COMMENT 'date created',
`removed` datetime COMMENT 'date removed if not null', PRIMARY KEY (`id`),
CONSTRAINT `fk_autoscale_vmprofiles__domain_id` FOREIGN KEY
`fk_autoscale_vmprofiles__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON
DELETE CASCADE, CONSTRAINT `fk_autoscale_vmprofiles__account_id` FOREIGN KEY
`fk_autoscale_vmprofiles__account_id` (`account_id`) REFERENCES `account`(`id`)
ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmprofiles__autoscale_user_id`
FOREIGN KEY `fk_autoscale_vmprofiles__autoscale_user_id` (`autoscale_user_id`)
REFERENCES `user`(`id`) ON DELETE CASCADE, CONSTRAINT
`uc_autoscale_vmprofiles__uuid` UNIQUE (`uuid`), INDEX
`i_autoscale_vmprofiles__removed`(`removed`) ) ENGINE=InnoDB DEFAULT
CHARSET=utf8
2020-01-17 14:35:58,966 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`autoscale_policies` ( `id` bigint unsigned NOT NULL
auto_increment, `uuid` varchar(40), `domain_id` bigint unsigned NOT NULL,
`account_id` bigint unsigned NOT NULL, `duration` int unsigned NOT NULL,
`quiet_time` int unsigned NOT NULL, `last_quiet_time` datetime DEFAULT NULL,
`action` varchar(15), `created` datetime NOT NULL COMMENT 'date created',
`removed` datetime COMMENT 'date removed if not null', PRIMARY KEY (`id`),
CONSTRAINT `fk_autoscale_policies__domain_id` FOREIGN KEY
`fk_autoscale_policies__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON
DELETE CASCADE, CONSTRAINT `fk_autoscale_policies__account_id` FOREIGN KEY
`fk_autoscale_policies__account_id` (`account_id`) REFERENCES `account`(`id`)
ON DELETE CASCADE, CONSTRAINT `uc_autoscale_policies__uuid` UNIQUE (`uuid`),
INDEX `i_autoscale_policies__removed`(`removed`) ) ENGINE=InnoDB DEFAULT
CHARSET=utf8
2020-01-17 14:35:58,977 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`autoscale_vmgroups` ( `id` bigint unsigned NOT NULL
auto_increment, `uuid` varchar(40), `zone_id` bigint unsigned NOT NULL,
`domain_id` bigint unsigned NOT NULL, `account_id` bigint unsigned NOT NULL,
`load_balancer_id` bigint unsigned NOT NULL, `min_members` int unsigned
DEFAULT 1, `max_members` int unsigned NOT NULL, `member_port` int unsigned
NOT NULL, `interval` int unsigned NOT NULL, `profile_id` bigint unsigned
NOT NULL, `state` varchar(255) NOT NULL COMMENT 'enabled or disabled, a
vmgroup is disabled to stop autoscaling activity', `created` datetime NOT
NULL COMMENT 'date created', `removed` datetime COMMENT 'date removed if not
null', PRIMARY KEY (`id`), CONSTRAINT
`fk_autoscale_vmgroup__autoscale_vmprofile_id` FOREIGN KEY(`profile_id`)
REFERENCES `autoscale_vmprofiles`(`id`), CONSTRAINT
`fk_autoscale_vmgroup__load_balancer_id` FOREIGN KEY(`load_balancer_id`)
REFERENCES `load_balancing_rules`(`id`) ON DELETE CASCADE, CONSTRAINT
`fk_autoscale_vmgroups__domain_id` FOREIGN KEY
`fk_autoscale_vmgroups__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON
DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroups__account_id` FOREIGN KEY
`fk_autoscale_vmgroups__account_id` (`account_id`) REFERENCES `account`(`id`)
ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroups__zone_id` FOREIGN KEY
`fk_autoscale_vmgroups__zone_id`(`zone_id`) REFERENCES `data_center`(`id`),
CONSTRAINT `uc_autoscale_vmgroups__uuid` UNIQUE (`uuid`), INDEX
`i_autoscale_vmgroups__removed`(`removed`), INDEX
`i_autoscale_vmgroups__load_balancer_id`(`load_balancer_id`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8
2020-01-17 14:35:58,991 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`autoscale_policy_condition_map` ( `id` bigint unsigned
NOT NULL auto_increment, `policy_id` bigint unsigned NOT NULL,
`condition_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT
`fk_autoscale_policy_condition_map__policy_id` FOREIGN KEY
`fk_autoscale_policy_condition_map__policy_id` (`policy_id`) REFERENCES
`autoscale_policies` (`id`) ON DELETE CASCADE, CONSTRAINT
`fk_autoscale_policy_condition_map__condition_id` FOREIGN KEY
`fk_autoscale_policy_condition_map__condition_id` (`condition_id`) REFERENCES
`conditions` (`id`), INDEX
`i_autoscale_policy_condition_map__policy_id`(`policy_id`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8
2020-01-17 14:35:59,000 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`autoscale_vmgroup_policy_map` ( `id` bigint unsigned
NOT NULL auto_increment, `vmgroup_id` bigint unsigned NOT NULL, `policy_id`
bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT
`fk_autoscale_vmgroup_policy_map__vmgroup_id` FOREIGN KEY
`fk_autoscale_vmgroup_policy_map__vmgroup_id` (`vmgroup_id`) REFERENCES
`autoscale_vmgroups` (`id`) ON DELETE CASCADE, CONSTRAINT
`fk_autoscale_vmgroup_policy_map__policy_id` FOREIGN KEY
`fk_autoscale_vmgroup_policy_map__policy_id` (`policy_id`) REFERENCES
`autoscale_policies` (`id`), INDEX
`i_autoscale_vmgroup_policy_map__vmgroup_id`(`vmgroup_id`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8
2020-01-17 14:35:59,011 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`autoscale_vmgroup_vm_map` ( `id` bigint unsigned NOT
NULL auto_increment, `vmgroup_id` bigint unsigned NOT NULL, `instance_id`
bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT
`fk_autoscale_vmgroup_vm_map__vmgroup_id` FOREIGN KEY
`fk_autoscale_vmgroup_vm_map__vmgroup_id` (`vmgroup_id`) REFERENCES
`autoscale_vmgroups` (`id`) ON DELETE CASCADE, CONSTRAINT
`fk_autoscale_vmgroup_vm_map__instance_id` FOREIGN KEY
`fk_autoscale_vmgroup_vm_map__instance_id` (`instance_id`) REFERENCES
`vm_instance` (`id`), INDEX
`i_autoscale_vmgroup_vm_map__vmgroup_id`(`vmgroup_id`) ) ENGINE=InnoDB DEFAULT
CHARSET=utf8
2020-01-17 14:35:59,020 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES
(1, UUID(), 'snmp','Linux User CPU - percentage', '1.3.6.1.4.1.2021.11.9.0',
now())
2020-01-17 14:35:59,022 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES
(2, UUID(), 'snmp','Linux System CPU - percentage', '1.3.6.1.4.1.2021.11.10.0',
now())
2020-01-17 14:35:59,023 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES
(3, UUID(), 'snmp','Linux CPU Idle - percentage', '1.3.6.1.4.1.2021.11.11.0',
now())
2020-01-17 14:35:59,024 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES
(100, UUID(), 'netscaler','Response Time - microseconds', 'RESPTIME', now())
2020-01-17 14:35:59,026 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES
(4, UUID(), 'cpu','Linux User CPU - percentage - native',
'1.3.6.1.4.1.2021.11.9.1', now())
2020-01-17 14:35:59,027 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES
(5, UUID(), 'memory','Linux User RAM - percentage - native',
'1.3.6.1.4.1.2021.11.10.1', now())
2020-01-17 14:35:59,028 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`user_ipv6_address` ( `id` bigint unsigned NOT NULL
UNIQUE auto_increment, `uuid` varchar(40), `account_id` bigint unsigned
NULL, `domain_id` bigint unsigned NULL, `ip_address` char(50) NOT NULL,
`data_center_id` bigint unsigned NOT NULL COMMENT 'zone that it belongs to',
`vlan_id` bigint unsigned NOT NULL, `state` char(32) NOT NULL default 'Free'
COMMENT 'state of the ip address', `mac_address` varchar(40) NOT NULL COMMENT
'mac address of this ip', `source_network_id` bigint unsigned NOT NULL
COMMENT 'network id ip belongs to', `network_id` bigint unsigned COMMENT
'network this public ip address is associated with', `physical_network_id`
bigint unsigned NOT NULL COMMENT 'physical network id that this configuration
is based on', `created` datetime NULL COMMENT 'Date this ip was allocated to
someone', PRIMARY KEY (`id`), UNIQUE (`ip_address`, `source_network_id`),
CONSTRAINT `fk_user_ipv6_address__source_network_id` FOREIGN KEY
(`source_network_id`) REFERENCES `networks`(`id`), CONSTRAINT
`fk_user_ipv6_address__network_id` FOREIGN KEY (`network_id`) REFERENCES
`networks`(`id`), CONSTRAINT `fk_user_ipv6_address__account_id` FOREIGN KEY
(`account_id`) REFERENCES `account`(`id`), CONSTRAINT
`fk_user_ipv6_address__vlan_id` FOREIGN KEY (`vlan_id`) REFERENCES `vlan`(`id`)
ON DELETE CASCADE, CONSTRAINT `fk_user_ipv6_address__data_center_id` FOREIGN
KEY (`data_center_id`) REFERENCES `data_center`(`id`) ON DELETE CASCADE,
CONSTRAINT `uc_user_ipv6_address__uuid` UNIQUE (`uuid`), CONSTRAINT
`fk_user_ipv6_address__physical_network_id` FOREIGN KEY (`physical_network_id`)
REFERENCES `physical_network`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT
CHARSET=utf8
2020-01-17 14:35:59,044 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`networks` ADD COLUMN `ip6_gateway` varchar(50) COMMENT 'IPv6
gateway for this network'
2020-01-17 14:35:59,063 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`networks` ADD COLUMN `ip6_cidr` varchar(50) COMMENT 'IPv6 cidr
for this network'
2020-01-17 14:35:59,087 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`nics` ADD COLUMN `ip6_gateway` varchar(50) COMMENT 'gateway for
ip6 address'
2020-01-17 14:35:59,105 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`nics` ADD COLUMN `ip6_cidr` varchar(50) COMMENT 'cidr for ip6
address'
2020-01-17 14:35:59,120 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`vlan` ADD COLUMN `ip6_gateway` varchar(255)
2020-01-17 14:35:59,134 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`vlan` ADD COLUMN `ip6_cidr` varchar(255)
2020-01-17 14:35:59,147 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`vlan` ADD COLUMN `ip6_range` varchar(255)
2020-01-17 14:35:59,160 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`data_center` ADD COLUMN `ip6_dns1` varchar(255)
2020-01-17 14:35:59,179 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER
TABLE `cloud`.`data_center` ADD COLUMN `ip6_dns2` varchar(255)
2020-01-17 14:35:59,198 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`networks` INNER JOIN `cloud`.`vlan` ON networks.id =
vlan.network_id SET networks.gateway = vlan.vlan_gateway, networks.ip6_gateway
= vlan.ip6_gateway, networks.ip6_cidr = vlan.ip6_cidr WHERE
networks.data_center_id = vlan.data_center_id AND networks.physical_network_id
= vlan.physical_network_id
2020-01-17 14:35:59,200 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- DB
views for list api
2020-01-17 14:35:59,200 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`user_vm_view`
2020-01-17 14:35:59,203 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`user_vm_view` AS select vm_instance.id id,
vm_instance.name name, user_vm.display_name display_name,
user_vm.user_data user_data, 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, instance_group.id instance_group_id,
instance_group.uuid instance_group_uuid, instance_group.name
instance_group_name, vm_instance.uuid uuid,
vm_instance.last_host_id last_host_id, vm_instance.vm_type type,
vm_instance.vnc_password vnc_password, vm_instance.limit_cpu_use
limit_cpu_use, vm_instance.created created, vm_instance.state
state, vm_instance.removed removed, vm_instance.ha_enabled
ha_enabled, vm_instance.hypervisor_type hypervisor_type,
vm_instance.instance_name instance_name, vm_instance.guest_os_id
guest_os_id, guest_os.uuid guest_os_uuid, vm_instance.pod_id
pod_id, host_pod_ref.uuid pod_uuid,
vm_instance.private_ip_address private_ip_address,
vm_instance.private_mac_address private_mac_address,
vm_instance.vm_type vm_type, data_center.id data_center_id,
data_center.uuid data_center_uuid, data_center.name data_center_name,
data_center.is_security_group_enabled security_group_enabled,
host.id host_id, host.uuid host_uuid, host.name host_name,
vm_template.id template_id, vm_template.uuid template_uuid,
vm_template.name template_name, vm_template.display_text
template_display_text, vm_template.enable_password password_enabled,
iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name,
iso.display_text iso_display_text, service_offering.id
service_offering_id, disk_offering.uuid service_offering_uuid,
service_offering.cpu cpu, service_offering.speed speed,
service_offering.ram_size ram_size, disk_offering.name
service_offering_name, storage_pool.id pool_id,
storage_pool.uuid pool_uuid, storage_pool.pool_type pool_type,
volumes.id volume_id, volumes.uuid volume_uuid,
volumes.device_id volume_device_id, volumes.volume_type volume_type,
security_group.id security_group_id, security_group.uuid
security_group_uuid, security_group.name security_group_name,
security_group.description security_group_description, nics.id nic_id,
nics.uuid nic_uuid, nics.network_id network_id,
nics.ip4_address ip_address, nics.ip6_address ip6_address,
nics.ip6_gateway ip6_gateway, nics.ip6_cidr ip6_cidr,
nics.default_nic is_default_nic, nics.gateway gateway,
nics.netmask netmask, nics.mac_address mac_address,
nics.broadcast_uri broadcast_uri, nics.isolation_uri isolation_uri,
vpc.id vpc_id, vpc.uuid vpc_uuid, networks.uuid
network_uuid, networks.name network_name, networks.traffic_type
traffic_type, networks.guest_type guest_type,
user_ip_address.id public_ip_id, user_ip_address.uuid public_ip_uuid,
user_ip_address.public_ip_address public_ip_address,
ssh_keypairs.keypair_name keypair_name, 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`.`user_vm`
inner join `cloud`.`vm_instance` ON vm_instance.id = user_vm.id
and vm_instance.removed is NULL inner join
`cloud`.`account` ON vm_instance.account_id = account.id inner join
`cloud`.`domain` ON vm_instance.domain_id = domain.id left
join `cloud`.`guest_os` ON vm_instance.guest_os_id = guest_os.id
left join `cloud`.`host_pod_ref` ON vm_instance.pod_id =
host_pod_ref.id left join `cloud`.`projects` ON
projects.project_account_id = account.id left join
`cloud`.`instance_group_vm_map` ON vm_instance.id =
instance_group_vm_map.instance_id left join
`cloud`.`instance_group` ON instance_group_vm_map.group_id = instance_group.id
left join `cloud`.`data_center` ON
vm_instance.data_center_id = data_center.id left join
`cloud`.`host` ON vm_instance.host_id = host.id left join
`cloud`.`vm_template` ON vm_instance.vm_template_id = vm_template.id
left join `cloud`.`vm_template` iso ON iso.id = user_vm.iso_id
left join `cloud`.`service_offering` ON
vm_instance.service_offering_id = service_offering.id left join
`cloud`.`disk_offering` ON vm_instance.service_offering_id =
disk_offering.id left join `cloud`.`volumes` ON
vm_instance.id = volumes.instance_id left join
`cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left
join `cloud`.`security_group_vm_map` ON vm_instance.id =
security_group_vm_map.instance_id left join
`cloud`.`security_group` ON security_group_vm_map.security_group_id =
security_group.id left join `cloud`.`nics` ON
vm_instance.id = nics.instance_id left join
`cloud`.`networks` ON nics.network_id = networks.id left join
`cloud`.`vpc` ON networks.vpc_id = vpc.id left join
`cloud`.`user_ip_address` ON user_ip_address.vm_id = vm_instance.id
left join `cloud`.`user_vm_details` ON user_vm_details.vm_id =
vm_instance.id and user_vm_details.name = 'SSH.PublicKey'
left join `cloud`.`ssh_keypairs` ON ssh_keypairs.public_key =
user_vm_details.value left join `cloud`.`resource_tags` ON
resource_tags.resource_id = vm_instance.id and
resource_tags.resource_type = 'UserVm' left join
`cloud`.`async_job` ON async_job.instance_id = vm_instance.id and
async_job.instance_type = 'VirtualMachine' and async_job.job_status
= 0
2020-01-17 14:35:59,213 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`domain_router_view`
2020-01-17 14:35:59,215 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`domain_router_view` AS select vm_instance.id
id, vm_instance.name name, 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, vm_instance.uuid uuid,
vm_instance.created created, vm_instance.state state,
vm_instance.removed removed, vm_instance.pod_id pod_id,
vm_instance.instance_name instance_name, host_pod_ref.uuid pod_uuid,
data_center.id data_center_id, data_center.uuid data_center_uuid,
data_center.name data_center_name, data_center.networktype
data_center_type, data_center.dns1 dns1, data_center.dns2 dns2,
data_center.ip6_dns1 ip6_dns1, data_center.ip6_dns2 ip6_dns2,
host.id host_id, host.uuid host_uuid, host.name
host_name, vm_template.id template_id, vm_template.uuid
template_uuid, service_offering.id service_offering_id,
disk_offering.uuid service_offering_uuid, disk_offering.name
service_offering_name, nics.id nic_id, nics.uuid nic_uuid,
nics.network_id network_id, nics.ip4_address ip_address,
nics.ip6_address ip6_address, nics.ip6_gateway ip6_gateway,
nics.ip6_cidr ip6_cidr, nics.default_nic is_default_nic,
nics.gateway gateway, nics.netmask netmask, nics.mac_address
mac_address, nics.broadcast_uri broadcast_uri,
nics.isolation_uri isolation_uri, vpc.id vpc_id, vpc.uuid
vpc_uuid, networks.uuid network_uuid, networks.name
network_name, networks.network_domain network_domain,
networks.traffic_type traffic_type, networks.guest_type guest_type,
async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id job_account_id,
domain_router.template_version template_version,
domain_router.scripts_version scripts_version,
domain_router.is_redundant_router is_redundant_router,
domain_router.redundant_state redundant_state,
domain_router.stop_pending stop_pending, domain_router.role role
from `cloud`.`domain_router` inner join
`cloud`.`vm_instance` ON vm_instance.id = domain_router.id inner
join `cloud`.`account` ON vm_instance.account_id = account.id
inner join `cloud`.`domain` ON vm_instance.domain_id = domain.id
left join `cloud`.`host_pod_ref` ON vm_instance.pod_id =
host_pod_ref.id left join `cloud`.`projects` ON
projects.project_account_id = account.id left join
`cloud`.`data_center` ON vm_instance.data_center_id = data_center.id
left join `cloud`.`host` ON vm_instance.host_id = host.id
left join `cloud`.`vm_template` ON vm_instance.vm_template_id =
vm_template.id left join `cloud`.`service_offering` ON
vm_instance.service_offering_id = service_offering.id left join
`cloud`.`disk_offering` ON vm_instance.service_offering_id =
disk_offering.id left join `cloud`.`volumes` ON
vm_instance.id = volumes.instance_id left join
`cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left
join `cloud`.`nics` ON vm_instance.id = nics.instance_id
left join `cloud`.`networks` ON nics.network_id = networks.id
left join `cloud`.`vpc` ON domain_router.vpc_id = vpc.id
left join `cloud`.`async_job` ON async_job.instance_id = vm_instance.id
and async_job.instance_type = 'DomainRouter' and
async_job.job_status = 0
2020-01-17 14:35:59,220 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`security_group_view`
2020-01-17 14:35:59,222 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`security_group_view` AS select
security_group.id id, security_group.name name,
security_group.description description, security_group.uuid 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,
security_group_rule.id rule_id, security_group_rule.uuid rule_uuid,
security_group_rule.type rule_type, security_group_rule.start_port
rule_start_port, security_group_rule.end_port rule_end_port,
security_group_rule.protocol rule_protocol,
security_group_rule.allowed_network_id rule_allowed_network_id,
security_group_rule.allowed_ip_cidr rule_allowed_ip_cidr,
security_group_rule.create_status rule_create_status, 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`.`security_group`
left join `cloud`.`security_group_rule` ON security_group.id
= security_group_rule.security_group_id inner join
`cloud`.`account` ON security_group.account_id = account.id inner
join `cloud`.`domain` ON security_group.domain_id = domain.id
left join `cloud`.`projects` ON projects.project_account_id =
security_group.account_id left join `cloud`.`resource_tags`
ON resource_tags.resource_id = security_group.id and
resource_tags.resource_type = 'SecurityGroup' left join
`cloud`.`async_job` ON async_job.instance_id = security_group.id
and async_job.instance_type = 'SecurityGroup' and
async_job.job_status = 0
2020-01-17 14:35:59,226 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`resource_tag_view`
2020-01-17 14:35:59,227 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`resource_tag_view` AS select
resource_tags.id, resource_tags.uuid, resource_tags.key,
resource_tags.value, resource_tags.resource_id,
resource_tags.resource_uuid, resource_tags.resource_type,
resource_tags.customer, 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 from `cloud`.`resource_tags`
inner join `cloud`.`account` ON resource_tags.account_id = account.id
inner join `cloud`.`domain` ON resource_tags.domain_id =
domain.id left join `cloud`.`projects` ON
projects.project_account_id = resource_tags.account_id
2020-01-17 14:35:59,230 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`event_view`
2020-01-17 14:35:59,232 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`event_view` AS select event.id,
event.uuid, event.type, event.state, event.description,
event.created, event.level, event.parameters,
event.start_id, eve.uuid start_uuid, event.user_id,
user.username user_name, 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 from `cloud`.`event` inner
join `cloud`.`account` ON event.account_id = account.id
inner join `cloud`.`domain` ON event.domain_id = domain.id
inner join `cloud`.`user` ON event.user_id = user.id left
join `cloud`.`projects` ON projects.project_account_id =
event.account_id left join `cloud`.`event` eve ON
event.start_id = eve.id
2020-01-17 14:35:59,235 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`instance_group_view`
2020-01-17 14:35:59,237 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`instance_group_view` AS select
instance_group.id, instance_group.uuid, instance_group.name,
instance_group.removed, instance_group.created, 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 from
`cloud`.`instance_group` inner join `cloud`.`account` ON
instance_group.account_id = account.id inner join
`cloud`.`domain` ON account.domain_id = domain.id left join
`cloud`.`projects` ON projects.project_account_id = instance_group.account_id
2020-01-17 14:35:59,239 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`user_view`
2020-01-17 14:35:59,241 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`user_view` AS select user.id,
user.uuid, user.username, user.password,
user.firstname, user.lastname, user.email, user.state,
user.api_key, user.secret_key, user.created,
user.removed, user.timezone, user.registration_token,
user.is_registered, user.incorrect_login_attempts, 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, 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`.`user` inner join
`cloud`.`account` ON user.account_id = account.id inner join
`cloud`.`domain` ON account.domain_id = domain.id left join
`cloud`.`async_job` ON async_job.instance_id = user.id and
async_job.instance_type = 'User' and async_job.job_status = 0
2020-01-17 14:35:59,244 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`project_view`
2020-01-17 14:35:59,246 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`project_view` AS select projects.id,
projects.uuid, projects.name, projects.display_text,
projects.state, projects.removed, projects.created,
account.account_name owner, pacct.account_id, domain.id
domain_id, domain.uuid domain_uuid, domain.name domain_name,
domain.path domain_path, 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 from `cloud`.`projects`
inner join `cloud`.`domain` ON projects.domain_id = domain.id
inner join `cloud`.`project_account` ON projects.id =
project_account.project_id and project_account.account_role =
'Admin' inner join `cloud`.`account` ON account.id =
project_account.account_id left join
`cloud`.`resource_tags` ON resource_tags.resource_id = projects.id
and resource_tags.resource_type = 'Project' left join
`cloud`.`project_account` pacct ON projects.id = pacct.project_id
2020-01-17 14:35:59,250 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`project_account_view`
2020-01-17 14:35:59,252 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`project_account_view` AS select
project_account.id, account.id account_id, account.uuid
account_uuid, account.account_name, account.type account_type,
project_account.account_role, projects.id project_id,
projects.uuid project_uuid, projects.name project_name,
domain.id domain_id, domain.uuid domain_uuid, domain.name
domain_name, domain.path domain_path from
`cloud`.`project_account` inner join `cloud`.`account` ON
project_account.account_id = account.id inner join
`cloud`.`domain` ON account.domain_id = domain.id inner join
`cloud`.`projects` ON projects.id = project_account.project_id
2020-01-17 14:35:59,255 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`project_invitation_view`
2020-01-17 14:35:59,256 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`project_invitation_view` AS select
project_invitations.id, project_invitations.uuid,
project_invitations.email, project_invitations.created,
project_invitations.state, projects.id project_id,
projects.uuid project_uuid, projects.name project_name,
account.id account_id, account.uuid account_uuid,
account.account_name, account.type account_type, domain.id
domain_id, domain.uuid domain_uuid, domain.name domain_name,
domain.path domain_path from `cloud`.`project_invitations`
left join `cloud`.`account` ON project_invitations.account_id =
account.id left join `cloud`.`domain` ON
project_invitations.domain_id = domain.id left join
`cloud`.`projects` ON projects.id = project_invitations.project_id
2020-01-17 14:35:59,259 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`host_view`
2020-01-17 14:35:59,261 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`host_view` AS select host.id,
host.uuid, host.name, host.status, host.disconnected,
host.type, host.private_ip_address, host.version,
host.hypervisor_type, host.hypervisor_version,
host.capabilities, host.last_ping, host.created,
host.removed, host.resource_state, host.mgmt_server_id,
host.cpus, host.speed, host.ram, cluster.id cluster_id,
cluster.uuid cluster_uuid, cluster.name cluster_name,
cluster.cluster_type, data_center.id data_center_id,
data_center.uuid data_center_uuid, data_center.name data_center_name,
host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid,
host_pod_ref.name pod_name, host_tags.tag, guest_os_category.id
guest_os_category_id, guest_os_category.uuid guest_os_category_uuid,
guest_os_category.name guest_os_category_name,
mem_caps.used_capacity memory_used_capacity, mem_caps.reserved_capacity
memory_reserved_capacity, cpu_caps.used_capacity cpu_used_capacity,
cpu_caps.reserved_capacity cpu_reserved_capacity, 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`.`host` left join `cloud`.`cluster` ON
host.cluster_id = cluster.id left join
`cloud`.`data_center` ON host.data_center_id = data_center.id left
join `cloud`.`host_pod_ref` ON host.pod_id = host_pod_ref.id
left join `cloud`.`host_details` ON host.id = host_details.host_id
and host_details.name = 'guest.os.category.id' left join
`cloud`.`guest_os_category` ON guest_os_category.id = CONVERT(
host_details.value , UNSIGNED) left join
`cloud`.`host_tags` ON host_tags.host_id = host.id left join
`cloud`.`op_host_capacity` mem_caps ON host.id = mem_caps.host_id
and mem_caps.capacity_type = 0 left join
`cloud`.`op_host_capacity` cpu_caps ON host.id = cpu_caps.host_id
and cpu_caps.capacity_type = 1 left join
`cloud`.`async_job` ON async_job.instance_id = host.id and
async_job.instance_type = 'Host' and async_job.job_status = 0
2020-01-17 14:35:59,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`volume_view`
2020-01-17 14:35:59,267 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
2020-01-17 14:35:59,272 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`account_netstats_view`
2020-01-17 14:35:59,274 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`account_netstats_view` AS SELECT account_id,
sum(net_bytes_received) + sum(current_bytes_received) as bytesReceived,
sum(net_bytes_sent) + sum(current_bytes_sent) as bytesSent FROM
`cloud`.`user_statistics` group by account_id
2020-01-17 14:35:59,277 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`account_vmstats_view`
2020-01-17 14:35:59,278 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`account_vmstats_view` AS SELECT account_id,
state, count(*) as vmcount from `cloud`.`vm_instance` group by
account_id , state
2020-01-17 14:35:59,280 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`free_ip_view`
2020-01-17 14:35:59,282 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`free_ip_view` AS select
count(user_ip_address.id) free_ip from `cloud`.`user_ip_address`
inner join `cloud`.`vlan` ON vlan.id =
user_ip_address.vlan_db_id and vlan.vlan_type = 'VirtualNetwork'
where state = 'Free'
2020-01-17 14:35:59,284 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`account_view`
2020-01-17 14:35:59,285 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`account_view` AS select account.id,
account.uuid, account.account_name, account.type,
account.state, account.removed, account.cleanup_needed,
account.network_domain, domain.id domain_id, domain.uuid
domain_uuid, domain.name domain_name, domain.path domain_path,
data_center.id data_center_id, data_center.uuid
data_center_uuid, data_center.name data_center_name,
account_netstats_view.bytesReceived, account_netstats_view.bytesSent,
vmlimit.max vmLimit, vmcount.count vmTotal,
runningvm.vmcount runningVms, stoppedvm.vmcount stoppedVms,
iplimit.max ipLimit, ipcount.count ipTotal,
free_ip_view.free_ip ipFree, volumelimit.max volumeLimit,
volumecount.count volumeTotal, snapshotlimit.max snapshotLimit,
snapshotcount.count snapshotTotal, templatelimit.max templateLimit,
templatecount.count templateTotal, vpclimit.max vpcLimit,
vpccount.count vpcTotal, projectlimit.max projectLimit,
projectcount.count projectTotal, networklimit.max networkLimit,
networkcount.count networkTotal, 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`.`free_ip_view`,
`cloud`.`account` inner join `cloud`.`domain` ON
account.domain_id = domain.id left join
`cloud`.`data_center` ON account.default_zone_id = data_center.id
left join `cloud`.`account_netstats_view` ON account.id =
account_netstats_view.account_id left join
`cloud`.`resource_limit` vmlimit ON account.id = vmlimit.account_id
and vmlimit.type = 'user_vm' left join
`cloud`.`resource_count` vmcount ON account.id = vmcount.account_id
and vmcount.type = 'user_vm' left join
`cloud`.`account_vmstats_view` runningvm ON account.id = runningvm.account_id
and runningvm.state = 'Running' left join
`cloud`.`account_vmstats_view` stoppedvm ON account.id = stoppedvm.account_id
and stoppedvm.state = 'Stopped' left join
`cloud`.`resource_limit` iplimit ON account.id = iplimit.account_id
and iplimit.type = 'public_ip' left join
`cloud`.`resource_count` ipcount ON account.id = ipcount.account_id
and ipcount.type = 'public_ip' left join
`cloud`.`resource_limit` volumelimit ON account.id = volumelimit.account_id
and volumelimit.type = 'volume' left join
`cloud`.`resource_count` volumecount ON account.id = volumecount.account_id
and volumecount.type = 'volume' left join
`cloud`.`resource_limit` snapshotlimit ON account.id = snapshotlimit.account_id
and snapshotlimit.type = 'snapshot' left join
`cloud`.`resource_count` snapshotcount ON account.id = snapshotcount.account_id
and snapshotcount.type = 'snapshot' left join
`cloud`.`resource_limit` templatelimit ON account.id = templatelimit.account_id
and templatelimit.type = 'template' left join
`cloud`.`resource_count` templatecount ON account.id = templatecount.account_id
and templatecount.type = 'template' left join
`cloud`.`resource_limit` vpclimit ON account.id = vpclimit.account_id
and vpclimit.type = 'vpc' left join
`cloud`.`resource_count` vpccount ON account.id = vpccount.account_id
and vpccount.type = 'vpc' left join
`cloud`.`resource_limit` projectlimit ON account.id = projectlimit.account_id
and projectlimit.type = 'project' left join
`cloud`.`resource_count` projectcount ON account.id = projectcount.account_id
and projectcount.type = 'project' left join
`cloud`.`resource_limit` networklimit ON account.id = networklimit.account_id
and networklimit.type = 'network' left join
`cloud`.`resource_count` networkcount ON account.id = networkcount.account_id
and networkcount.type = 'network' left join
`cloud`.`async_job` ON async_job.instance_id = account.id and
async_job.instance_type = 'Account' and async_job.job_status = 0
2020-01-17 14:35:59,292 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`async_job_view`
2020-01-17 14:35:59,294 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`async_job_view` AS select 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, user.id user_id, user.uuid user_uuid,
async_job.id, async_job.uuid, async_job.job_cmd,
async_job.job_status, async_job.job_process_status,
async_job.job_result_code, async_job.job_result,
async_job.created, async_job.removed, async_job.instance_type,
async_job.instance_id, CASE WHEN
async_job.instance_type = 'Volume' THEN volumes.uuid WHEN
async_job.instance_type = 'Template' or
async_job.instance_type = 'Iso' THEN
vm_template.uuid WHEN async_job.instance_type =
'VirtualMachine' or async_job.instance_type =
'ConsoleProxy' or async_job.instance_type = 'SystemVm'
or async_job.instance_type = 'DomainRouter' THEN
vm_instance.uuid WHEN async_job.instance_type =
'Snapshot' THEN snapshots.uuid WHEN async_job.instance_type =
'Host' THEN host.uuid WHEN async_job.instance_type = 'StoragePool'
THEN storage_pool.uuid WHEN async_job.instance_type = 'IpAddress'
THEN user_ip_address.uuid WHEN async_job.instance_type =
'SecurityGroup' THEN security_group.uuid WHEN
async_job.instance_type = 'PhysicalNetwork' THEN physical_network.uuid
WHEN async_job.instance_type = 'TrafficType' THEN
physical_network_traffic_types.uuid WHEN async_job.instance_type =
'PhysicalNetworkServiceProvider' THEN physical_network_service_providers.uuid
WHEN async_job.instance_type = 'FirewallRule' THEN
firewall_rules.uuid WHEN async_job.instance_type = 'Account' THEN
acct.uuid WHEN async_job.instance_type = 'User' THEN us.uuid
WHEN async_job.instance_type = 'StaticRoute' THEN static_routes.uuid
WHEN async_job.instance_type = 'PrivateGateway' THEN vpc_gateways.uuid
WHEN async_job.instance_type = 'Counter' THEN counter.uuid
WHEN async_job.instance_type = 'Condition' THEN conditions.uuid
WHEN async_job.instance_type = 'AutoScalePolicy' THEN autoscale_policies.uuid
WHEN async_job.instance_type = 'AutoScaleVmProfile' THEN
autoscale_vmprofiles.uuid WHEN async_job.instance_type =
'AutoScaleVmGroup' THEN autoscale_vmgroups.uuid ELSE null
END instance_uuid from `cloud`.`async_job` left join
`cloud`.`account` ON async_job.account_id = account.id left
join `cloud`.`domain` ON domain.id = account.domain_id left
join `cloud`.`user` ON async_job.user_id = user.id left
join `cloud`.`volumes` ON async_job.instance_id = volumes.id
left join `cloud`.`vm_template` ON async_job.instance_id =
vm_template.id left join `cloud`.`vm_instance` ON
async_job.instance_id = vm_instance.id left join
`cloud`.`snapshots` ON async_job.instance_id = snapshots.id left
join `cloud`.`host` ON async_job.instance_id = host.id left
join `cloud`.`storage_pool` ON async_job.instance_id = storage_pool.id
left join `cloud`.`user_ip_address` ON async_job.instance_id
= user_ip_address.id left join `cloud`.`security_group` ON
async_job.instance_id = security_group.id left join
`cloud`.`physical_network` ON async_job.instance_id = physical_network.id
left join `cloud`.`physical_network_traffic_types` ON
async_job.instance_id = physical_network_traffic_types.id left join
`cloud`.`physical_network_service_providers` ON async_job.instance_id =
physical_network_service_providers.id left join
`cloud`.`firewall_rules` ON async_job.instance_id = firewall_rules.id
left join `cloud`.`account` acct ON async_job.instance_id = acct.id
left join `cloud`.`user` us ON async_job.instance_id = us.id
left join `cloud`.`static_routes` ON async_job.instance_id =
static_routes.id left join `cloud`.`vpc_gateways` ON
async_job.instance_id = vpc_gateways.id left join
`cloud`.`counter` ON async_job.instance_id = counter.id left join
`cloud`.`conditions` ON async_job.instance_id = conditions.id
left join `cloud`.`autoscale_policies` ON async_job.instance_id =
autoscale_policies.id left join
`cloud`.`autoscale_vmprofiles` ON async_job.instance_id =
autoscale_vmprofiles.id left join
`cloud`.`autoscale_vmgroups` ON async_job.instance_id = autoscale_vmgroups.id
2020-01-17 14:35:59,301 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`storage_pool_view`
2020-01-17 14:35:59,302 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`storage_pool_view` AS select storage_pool.id,
storage_pool.uuid, storage_pool.name,
storage_pool.status, storage_pool.path, storage_pool.pool_type,
storage_pool.host_address, storage_pool.created,
storage_pool.removed, storage_pool.capacity_bytes,
storage_pool.scope, cluster.id cluster_id, cluster.uuid
cluster_uuid, cluster.name cluster_name, cluster.cluster_type,
data_center.id data_center_id, data_center.uuid
data_center_uuid, data_center.name data_center_name,
host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid,
host_pod_ref.name pod_name, storage_pool_details.name tag,
op_host_capacity.used_capacity disk_used_capacity,
op_host_capacity.reserved_capacity disk_reserved_capacity, 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`.`storage_pool` left join `cloud`.`cluster` ON
storage_pool.cluster_id = cluster.id left join
`cloud`.`data_center` ON storage_pool.data_center_id = data_center.id
left join `cloud`.`host_pod_ref` ON storage_pool.pod_id =
host_pod_ref.id left join `cloud`.`storage_pool_details` ON
storage_pool_details.pool_id = storage_pool.id and
storage_pool_details.value = 'true' left join
`cloud`.`op_host_capacity` ON storage_pool.id = op_host_capacity.host_id
and op_host_capacity.capacity_type = 3 left join
`cloud`.`async_job` ON async_job.instance_id = storage_pool.id and
async_job.instance_type = 'StoragePool' and async_job.job_status =
0
2020-01-17 14:35:59,306 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`disk_offering_view`
2020-01-17 14:35:59,307 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`disk_offering_view` AS select
disk_offering.id, disk_offering.uuid, disk_offering.name,
disk_offering.display_text, disk_offering.disk_size,
disk_offering.created, disk_offering.tags,
disk_offering.customized, disk_offering.removed,
disk_offering.use_local_storage, disk_offering.system_use,
disk_offering.sort_key, disk_offering.type, domain.id
domain_id, domain.uuid domain_uuid, domain.name domain_name,
domain.path domain_path from `cloud`.`disk_offering`
left join `cloud`.`domain` ON disk_offering.domain_id = domain.id
2020-01-17 14:35:59,310 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`service_offering_view`
2020-01-17 14:35:59,311 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`service_offering_view` AS select
service_offering.id, disk_offering.uuid, disk_offering.name,
disk_offering.display_text, disk_offering.created,
disk_offering.tags, disk_offering.removed,
disk_offering.use_local_storage, disk_offering.system_use,
service_offering.cpu, service_offering.speed,
service_offering.ram_size, service_offering.nw_rate,
service_offering.mc_rate, service_offering.ha_enabled,
service_offering.limit_cpu_use, service_offering.host_tag,
service_offering.default_use, service_offering.vm_type,
service_offering.sort_key, domain.id domain_id, domain.uuid
domain_uuid, domain.name domain_name, domain.path domain_path
from `cloud`.`service_offering` inner join
`cloud`.`disk_offering` ON service_offering.id = disk_offering.id
left join `cloud`.`domain` ON disk_offering.domain_id = domain.id
2020-01-17 14:35:59,314 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
VIEW IF EXISTS `cloud`.`data_center_view`
2020-01-17 14:35:59,316 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE VIEW `cloud`.`data_center_view` AS select data_center.id,
data_center.uuid, data_center.name,
data_center.is_security_group_enabled,
data_center.is_local_storage_enabled, data_center.description,
data_center.dns1, data_center.dns2, data_center.ip6_dns1,
data_center.ip6_dns2, data_center.internal_dns1,
data_center.internal_dns2, data_center.guest_network_cidr,
data_center.domain, data_center.networktype,
data_center.allocation_state, data_center.zone_token,
data_center.dhcp_provider, data_center.removed, domain.id
domain_id, domain.uuid domain_uuid, domain.name domain_name,
domain.path domain_path from `cloud`.`data_center`
left join `cloud`.`domain` ON data_center.domain_id = domain.id
2020-01-17 14:35:59,319 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`baremetal_dhcp_devices` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `nsp_id` bigint
unsigned DEFAULT NULL COMMENT 'Network Service Provider ID', `pod_id` bigint
unsigned DEFAULT NULL COMMENT 'Pod id where this dhcp server in',
`device_type` varchar(255) DEFAULT NULL COMMENT 'type of the external device',
`physical_network_id` bigint unsigned DEFAULT NULL COMMENT 'id of the physical
network in to which external dhcp device is added', `host_id` bigint unsigned
DEFAULT NULL COMMENT 'host id coresponding to the external dhcp device',
PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:59,326 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`baremetal_pxe_devices` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `nsp_id` bigint
unsigned DEFAULT NULL COMMENT 'Network Service Provider ID', `pod_id` bigint
unsigned DEFAULT NULL COMMENT 'Pod id where this pxe server in, for pxe per
zone this field is null', `device_type` varchar(255) DEFAULT NULL COMMENT
'type of the pxe device', `physical_network_id` bigint unsigned DEFAULT NULL
COMMENT 'id of the physical network in to which external pxe device is added',
`host_id` bigint unsigned DEFAULT NULL COMMENT 'host id coresponding to the
external pxe device', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT
CHARSET=utf8
2020-01-17 14:35:59,333 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`ucs_blade` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `ucs_manager_id`
bigint unsigned NOT NULL, `host_id` bigint unsigned DEFAULT NULL, `dn`
varchar(512) NOT NULL, `profile_dn` varchar(512) DEFAULT NULL, PRIMARY KEY
(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:59,340 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`ucs_manager` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `zone_id` bigint
unsigned NOT NULL, `name` varchar(128) DEFAULT NULL, `url` varchar(255) NOT
NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:59,347 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) SET
foreign_key_checks = 1
2020-01-17 14:35:59,347 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`configuration` SET value='KVM,XenServer,VMware,Ovm' WHERE
name='hypervisor.list'
2020-01-17 14:35:59,348 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'concurrent.snapshots.threshold.perhost' , NULL, 'Limit
number of snapshots that can be handled concurrently; default is NULL -
unlimited.')
2020-01-17 14:35:59,349 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network', 'DEFAULT',
'management-server', 'network.ipv6.search.retry.max' , 10000, 'The maximum
number of retrying times to search for an available IPv6 address in the table')
2020-01-17 14:35:59,351 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Usage', 'DEFAULT',
'management-server', 'traffic.sentinel.exclude.zones' , '', 'Traffic going into
specified list of zones is not metered')
2020-01-17 14:35:59,352 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Usage', 'DEFAULT',
'management-server', 'traffic.sentinel.include.zones' , 'EXTERNAL', 'Traffic
going into specified list of zones is metered. For metering all traffic leave
this parameter empty')
2020-01-17 14:35:59,353 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name)
VALUES (163, UUID(), 10, 'Ubuntu 12.04 (32-bit)')
2020-01-17 14:35:59,354 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name)
VALUES (164, UUID(), 10, 'Ubuntu 12.04 (64-bit)')
2020-01-17 14:35:59,355 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP
TABLE IF EXISTS `cloud`.`netscaler_pod_ref`
2020-01-17 14:35:59,360 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CREATE TABLE `cloud`.`netscaler_pod_ref` ( `id` bigint unsigned NOT NULL
auto_increment COMMENT 'id', `external_load_balancer_device_id` bigint
unsigned NOT NULL COMMENT 'id of external load balancer device', `pod_id`
bigint unsigned NOT NULL COMMENT 'pod id', PRIMARY KEY (`id`), CONSTRAINT
`fk_ns_pod_ref__pod_id` FOREIGN KEY (`pod_id`) REFERENCES
`cloud`.`host_pod_ref`(`id`) ON DELETE CASCADE, CONSTRAINT
`fk_ns_pod_ref__device_id` FOREIGN KEY (`external_load_balancer_device_id`)
REFERENCES `external_load_balancer_devices`(`id`) ON DELETE CASCADE )
ENGINE=InnoDB DEFAULT CHARSET=utf8
2020-01-17 14:35:59,367 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
'management-server', 'eip.use.multiple.netscalers' , 'false', 'Should be set to
true, if there will be multiple NetScaler devices providing EIP service in a
zone')
2020-01-17 14:35:59,368 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`configuration` set category='Advanced' where category='Advanced
'
2020-01-17 14:35:59,369 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
UPDATE `cloud`.`configuration` set category='Hidden' where category='Hidden '
2020-01-17 14:35:59,373 DEBUG [c.c.u.d.Upgrade40to41] (main:null) (logid:)
Updating region table with Id: 1
2020-01-17 14:35:59,375 DEBUG [c.c.u.d.Upgrade40to41] (main:null) (logid:)
Updating firewall Ingress rule traffic type:
com.mysql.cj.jdbc.ClientPreparedStatement: update `cloud`.`firewall_rules` set
traffic_type='Ingress' where purpose='Firewall' and ip_address_id is not null
and traffic_type is null
2020-01-17 14:35:59,411 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:)
Rolling back the transaction: Time = 1594 Name = Upgrade; called by
-TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-TransactionLegacy.close:657-TransactionContextInterceptor.invoke:36-ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.invoke:92-ReflectiveMethodInvocation.proceed:185-JdkDynamicAopProxy.invoke:212-$Proxy30.persist:-1-DatabaseUpgradeChecker.upgrade:259-DatabaseUpgradeChecker.check:336-CloudStackExtendedLifeCycle.checkIntegrity:65
2020-01-17 14:35:59,415 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Problem with getting the ec
attribute
at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1454)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at
com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy30.persist(Unknown Source)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:259)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55)
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:183)
at
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52)
at
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358)
at
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159)
at
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
at
org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
at
org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532)
at
org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344)
at
org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785)
at
org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261)
at
org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at org.eclipse.jetty.server.Server.start(Server.java:418)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at org.eclipse.jetty.server.Server.doStart(Server.java:385)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:186)
at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:103)
Caused by: java.lang.IllegalArgumentException: Can not set long field
com.cloud.upgrade.dao.VersionVO.id to java.math.BigInteger
at
sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
at
sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
at
sun.reflect.UnsafeLongFieldAccessorImpl.set(UnsafeLongFieldAccessorImpl.java:102)
... 65 more
2020-01-17 14:35:59,422 WARN [o.a.c.s.m.c.ResourceApplicationContext]
(main:null) (logid:) Exception encountered during context initialization -
cancelling refresh attempt:
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
2020-01-17 14:35:59,424 WARN [o.e.j.w.WebAppContext] (main:null) (logid:)
Failed startup of context
o.e.j.w.WebAppContext@6e38921c{/client,file:///usr/share/cloudstack-management/webapp/,UNAVAILABLE}{/usr/share/cloudstack-management/webapp}
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:186)
at
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52)
at
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358)
at
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159)
at
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
at
org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
at
org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532)
at
org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344)
at
org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785)
at
org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261)
at
org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at org.eclipse.jetty.server.Server.start(Server.java:418)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at org.eclipse.jetty.server.Server.doStart(Server.java:385)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:186)
at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:103)
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade
the database
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:265)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
... 47 more
Caused by: com.cloud.utils.exception.CloudRuntimeException: Problem with
getting the ec attribute
at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1454)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
... 61 more
Caused by: java.lang.IllegalArgumentException: Can not set long field
com.cloud.upgrade.dao.VersionVO.id to java.math.BigInteger
at
sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
at
sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
at
sun.reflect.UnsafeLongFieldAccessorImpl.set(UnsafeLongFieldAccessorImpl.java:102)
... 65 more
2020-01-17 14:35:59,431 INFO [o.e.j.s.h.ContextHandler] (main:null) (logid:)
Started o.e.j.s.h.MovedContextHandler@6e2c9341{/,null,AVAILABLE}
2020-01-17 14:35:59,492 INFO [o.e.j.s.AbstractConnector] (main:null) (logid:)
Started ServerConnector@51e2adc7{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
2020-01-17 14:35:59,493 INFO [o.e.j.s.Server] (main:null) (logid:) Started
@22056msOn 2020/01/17
Thanks again for you time.
Robert
12:11:47, Andrija Panic <[email protected]> wrote:
> Damn... are you the same persons which sent the same email with the same
> error an hour ago?
> If not... then read below
>
> Seems that the latest mysql-connector got screwed up,,,
>
> 1. Remove it, remove the MySQL repo (if you have been following the quick
> installation guide - then you are using that repo)
> 2. Install EPEL repo, install "mysql-connector-python" (older, much older
> version...)
> OR
> 1. Remove the current mysql-connector-python package
> 2. Install the older version from here: yum localinstall
> http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/mysql-connector-python-8.0.18-1.el7.x86_64.rpm
>
> Best
>
> On Fri, 17 Jan 2020 at 12:38, Robert Ward <[email protected]> wrote:
>
> > Hello all,
> >
> > I have run into a problem with the CS MGNT setup. When I run
> > cloudstack-setup-management command I get back:
> > Traceback (most recent call last):
> > File "/usr/bin/cloudstack-setup-management", line 24, in <module>
> > from cloudutils.serviceConfigServer import cloudManagementConfig
> > File
> > "/usr/lib64/python2.7/site-packages/cloudutils/serviceConfigServer.py",
> > line 17, in <module>
> > from db import Database
> > File "/usr/lib64/python2.7/site-packages/cloudutils/db.py", line 20, in
> > <module>
> > import mysql.connector
> > File "/usr/lib64/python2.7/site-packages/mysql/connector/__init__.py",
> > line 41, in <module>
> > import dns.resolver
> > ImportError: No module named dns.resolver
> >
> > I have installed the Management server in the past without any issue and
> > this just started happening recently.
> >
> > FYI, my core setup:
> > Centos 7.7
> > MySQL 5.7
> > CS 4.13
> >
> > I have used both the CS and SB repos and I get the same result.
> >
> > Any help with solving this is most appreciated.
> >
> >
>
> --
>
> Andrija Panić
>
