Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2019-10-02 12:12:59,403 INFO [o.e.j.s.AbstractConnector] (Thread-1:null) (logid:) Stopped ServerConnector@51e2adc7{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
- 2019-10-02 12:12:59,404 INFO [o.e.j.s.session] (Thread-1:null) (logid:) Stopped scavenging
- 2019-10-02 12:12:59,404 INFO [o.e.j.s.h.ContextHandler] (Thread-1:null) (logid:) Stopped o.e.j.s.h.MovedContextHandler@6e2c9341{/,null,UNAVAILABLE}
- 2019-10-02 12:12:59,406 INFO [o.e.j.s.h.ContextHandler] (Thread-1:null) (logid:) Stopped o.e.j.w.WebAppContext@646be2c3{/client,null,UNAVAILABLE}{/usr/share/cloudstack-management/webapp}
- 2019-10-02 12:13:00,415 INFO [o.a.c.ServerDaemon] (main:null) (logid:) Server configuration file found: /etc/cloudstack/management/server.properties
- 2019-10-02 12:13:00,420 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
- 2019-10-02 12:13:00,430 INFO [o.e.j.u.log] (main:null) (logid:) Logging initialized @679ms to org.eclipse.jetty.util.log.Slf4jLog
- 2019-10-02 12:13:00,579 INFO [o.e.j.s.Server] (main:null) (logid:) jetty-9.4.z-SNAPSHOT, build timestamp: 2017-11-21T22:27:37+01:00, git hash: 82b8fb23f757335bb3329d540ce37a2a2615f0a8
- 2019-10-02 12:13:00,646 INFO [o.e.j.s.AbstractNCSARequestLog] (main:null) (logid:) Opened /var/log/cloudstack/management/access.log
- 2019-10-02 12:13:00,758 INFO [o.e.j.w.StandardDescriptorProcessor] (main:null) (logid:) NO JSP Support for /client, did not find org.eclipse.jetty.jsp.JettyJspServlet
- 2019-10-02 12:13:00,787 INFO [o.e.j.s.session] (main:null) (logid:) DefaultSessionIdManager workerName=node0
- 2019-10-02 12:13:00,787 INFO [o.e.j.s.session] (main:null) (logid:) No SessionScavenger set, using defaults
- 2019-10-02 12:13:00,788 INFO [o.e.j.s.session] (main:null) (logid:) Scavenging every 660000ms
- 2019-10-02 12:13:10,540 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]
- 2019-10-02 12:13:10,541 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]
- 2019-10-02 12:13:10,651 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] (main:null) (logid:) Encryption Type: file
- 2019-10-02 12:13:10,674 INFO [c.c.u.LogUtils] (main:null) (logid:) log4j configuration found at /etc/cloudstack/management/log4j-cloud.xml
- 2019-10-02 12:13:10,686 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loaded module context [bootstrap] in 146 ms
- 2019-10-02 12:13:10,687 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bootstrap
- 2019-10-02 12:13:10,687 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: system
- 2019-10-02 12:13:10,687 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: core
- 2019-10-02 12:13:10,687 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: allocator
- 2019-10-02 12:13:10,687 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-allocator-random
- 2019-10-02 12:13:10,687 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: planner
- 2019-10-02 12:13:10,687 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-planner
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-planner
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: explicit-dedication
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-affinity
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-anti-affinity
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: implicit-dedication
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-planner
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: skip-heurestics
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: user-concentrated-pod
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-allocator
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-dynamic-role-based
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-static-role-based
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cloudian
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ldap
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: md5
- 2019-10-02 12:13:10,688 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: metrics
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: pbkdf2
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: plaintext
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: prometheus
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: quota
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: rate-limit
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: saml2
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-api
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: sha256salted
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: solidfire-intg-test
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-sioc
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-config
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: backend
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ca
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: root-ca
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: compute
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-compute
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-compute
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kvm-compute
- 2019-10-02 12:13:10,689 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-compute
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-compute
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-compute
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-compute
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-fencer
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-investigator
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-compute
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-compute
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: network
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-network
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bigswitch
- 2019-10-02 12:13:10,690 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cisco-vnmc
- 2019-10-02 12:13:10,692 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: contrail
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: elb
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: f5
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: globodns
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: netscaler
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nvp
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: opendaylight
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovs
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: paloalto
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-network
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: srx
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ssp
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vcs
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-network
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vxlan
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-backend
- 2019-10-02 12:13:10,693 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-storage
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-storage
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-storage
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-template-adapter
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-allocator
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-default
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-s3
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-swift
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-cloudbyte
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-datera
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-default
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-solidfire
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-storage
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: discoverer
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-discoverer
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-discoverer
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-discoverer
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-discoverer
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: secondary-storage-discoverer
- 2019-10-02 12:13:10,694 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-discoverer
- 2019-10-02 12:13:10,695 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-discoverer
- 2019-10-02 12:13:10,695 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-discoverer
- 2019-10-02 12:13:10,695 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: outofbandmanagement
- 2019-10-02 12:13:10,695 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ipmitool
- 2019-10-02 12:13:10,695 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nested-cloudstack
- 2019-10-02 12:13:10,695 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]
- 2019-10-02 12:13:10,695 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]
- 2019-10-02 12:13:10,695 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]
- 2019-10-02 12:13:10,696 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]
- 2019-10-02 12:13:10,696 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]
- 2019-10-02 12:13:10,696 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]
- 2019-10-02 12:13:10,696 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]
- 2019-10-02 12:13:10,696 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]
- 2019-10-02 12:13:10,696 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]
- 2019-10-02 12:13:11,246 INFO [c.c.u.d.T.Transaction] (main:null) (logid:) Is Data Base High Availiability enabled? Ans : false
- 2019-10-02 12:13:11,276 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) Successfully loaded DB driver com.mysql.jdbc.Driver
- 2019-10-02 12:13:11,290 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) DB driver com.mysql.jdbc.Driver was already loaded.
- 2019-10-02 12:13:11,290 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) DB driver com.mysql.jdbc.Driver was already loaded.
- 2019-10-02 12:13:11,487 DEBUG [c.c.u.d.ConnectionConcierge] (main:null) (logid:) Registering a database connection for LockMaster1
- 2019-10-02 12:13:11,487 INFO [c.c.u.d.Merovingian2] (main:null) (logid:) Cleaning up locks for 279278805451094
- 2019-10-02 12:13:11,488 INFO [c.c.u.d.Merovingian2] (main:null) (logid:) Released 0 locks for 279278805451094
- 2019-10-02 12:13:11,646 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Running system integrity checker com.cloud.upgrade.DatabaseUpgradeChecker@2d140a7
- 2019-10-02 12:13:11,647 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Grabbing lock to check for database upgrade.
- 2019-10-02 12:13:11,676 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
- 2019-10-02 12:13:11,691 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) DB version = 4.12.0.0 Code Version = 4.13.0.0
- 2019-10-02 12:13:11,691 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Database upgrade must be performed from 4.12.0.0 to 4.13.0.0
- 2019-10-02 12:13:11,699 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Running upgrade Upgrade41200to41300 to upgrade from 4.12.0.0-4.13.0.0 to 4.13.0.0
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Licensed to the Apache Software Foundation (ASF) under one
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- or more contributor license agreements. See the NOTICE file
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- distributed with this work for additional information
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- regarding copyright ownership. The ASF licenses this file
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- to you under the Apache License, Version 2.0 (the
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "License"); you may not use this file except in compliance
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- with the License. You may obtain a copy of the License at
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- http://www.apache.org/licenses/LICENSE-2.0
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Unless required by applicable law or agreed to in writing,
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- software distributed under the License is distributed on an
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- KIND, either express or implied. See the License for the
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- specific language governing permissions and limitations
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- under the License.
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Schema upgrade from 4.12.0.0 to 4.13.0.0
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add XenServer 7.1.2, 7.6 and 8.0 hypervisor capabilities
- 2019-10-02 12:13:11,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, hypervisor_version, max_guests_limit, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported) values (UUID(), 'XenServer', '7.6.0', 1000, 253, 64, 1)
- 2019-10-02 12:13:11,705 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, hypervisor_version, max_guests_limit, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported) values (UUID(), 'XenServer', '8.0.0', 1000, 253, 64, 1)
- 2019-10-02 12:13:11,706 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, hypervisor_version, max_guests_limit, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported) values (UUID(), 'XenServer', '7.1.1', 1000, 253, 64, 1)
- 2019-10-02 12:13:11,706 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, hypervisor_version, max_guests_limit, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported) values (UUID(), 'XenServer', '7.1.2', 1000, 253, 64, 1)
- 2019-10-02 12:13:11,706 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add VMware 6.7 hypervisor capabilities
- 2019-10-02 12:13:11,706 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7', '1024', '0', '59', '64', '1', '1')
- 2019-10-02 12:13:11,707 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7.1', '1024', '0', '59', '64', '1', '1')
- 2019-10-02 12:13:11,707 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7.2', '1024', '0', '59', '64', '1', '1')
- 2019-10-02 12:13:11,707 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7.3', '1024', '0', '59', '64', '1', '1')
- 2019-10-02 12:13:11,708 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Update VMware 6.x hypervisor capabilities
- 2019-10-02 12:13:11,708 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`hypervisor_capabilities` SET max_guests_limit='1024', max_data_volumes_limit='59', max_hosts_per_cluster='64' WHERE (hypervisor_type='VMware' AND hypervisor_version='6.0' )
- 2019-10-02 12:13:11,708 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`hypervisor_capabilities` SET max_guests_limit='1024', max_data_volumes_limit='59', max_hosts_per_cluster='64' WHERE (hypervisor_type='VMware' AND hypervisor_version='6.5' )
- 2019-10-02 12:13:11,708 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add new OS versions
- 2019-10-02 12:13:11,708 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('277', UUID(), '1', 'Ubuntu 17.04', now(), '0')
- 2019-10-02 12:13:11,709 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('278', UUID(), '1', 'Ubuntu 17.10', now(), '0')
- 2019-10-02 12:13:11,709 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('279', UUID(), '1', 'Ubuntu 18.04 LTS', now(), '0')
- 2019-10-02 12:13:11,710 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('280', UUID(), '1', 'Ubuntu 18.10', now(), '0')
- 2019-10-02 12:13:11,710 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('281', UUID(), '1', 'Ubuntu 19.04', now(), '0')
- 2019-10-02 12:13:11,710 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('282', UUID(), '1', 'Red Hat Enterprise Linux 7.3', now(), '0')
- 2019-10-02 12:13:11,711 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('283', UUID(), '1', 'Red Hat Enterprise Linux 7.4', now(), '0')
- 2019-10-02 12:13:11,711 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('284', UUID(), '1', 'Red Hat Enterprise Linux 7.5', now(), '0')
- 2019-10-02 12:13:11,711 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('285', UUID(), '1', 'Red Hat Enterprise Linux 7.6', now(), '0')
- 2019-10-02 12:13:11,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('286', UUID(), '1', 'Red Hat Enterprise Linux 8.0', now(), '0')
- 2019-10-02 12:13:11,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('289', UUID(), '2', 'Debian GNU/Linux 9 (32-bit)', now(), '0')
- 2019-10-02 12:13:11,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('290', UUID(), '2', 'Debian GNU/Linux 9 (64-bit)', now(), '0')
- 2019-10-02 12:13:11,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('291', UUID(), '5', 'SUSE Linux Enterprise Server 15 (64-bit)', now(), '0')
- 2019-10-02 12:13:11,713 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('292', UUID(), '2', 'Debian GNU/Linux 10 (32-bit)', now(), '0')
- 2019-10-02 12:13:11,713 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('293', UUID(), '2', 'Debian GNU/Linux 10 (64-bit)', now(), '0')
- 2019-10-02 12:13:11,713 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('294', UUID(), '2', 'Linux 4.x Kernel (32-bit)', now(), '0')
- 2019-10-02 12:13:11,713 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('295', UUID(), '2', 'Linux 4.x Kernel (64-bit)', now(), '0')
- 2019-10-02 12:13:11,714 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('296', UUID(), '3', 'Oracle Linux 8', now(), '0')
- 2019-10-02 12:13:11,714 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('297', UUID(), '1', 'CentOS 8', now(), '0')
- 2019-10-02 12:13:11,714 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('298', UUID(), '9', 'FreeBSD 11 (32-bit)', now(), '0')
- 2019-10-02 12:13:11,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('299', UUID(), '9', 'FreeBSD 11 (64-bit)', now(), '0')
- 2019-10-02 12:13:11,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('300', UUID(), '9', 'FreeBSD 12 (32-bit)', now(), '0')
- 2019-10-02 12:13:11,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('301', UUID(), '9', 'FreeBSD 12 (64-bit)', now(), '0')
- 2019-10-02 12:13:11,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('302', UUID(), '1', 'CentOS 6.8', now(), '0')
- 2019-10-02 12:13:11,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('303', UUID(), '1', 'CentOS 6.9', now(), '0')
- 2019-10-02 12:13:11,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, is_user_defined) VALUES ('304', UUID(), '1', 'CentOS 6.10', now(), '0')
- 2019-10-02 12:13:11,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add New and missing VMware 6.5 Guest OSes
- 2019-10-02 12:13:11,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6Guest', 235, now(), 0)
- 2019-10-02 12:13:11,717 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6_64Guest', 236, now(), 0)
- 2019-10-02 12:13:11,717 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6Guest', 147, now(), 0)
- 2019-10-02 12:13:11,717 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6_64Guest', 148, now(), 0)
- 2019-10-02 12:13:11,718 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6Guest', 213, now(), 0)
- 2019-10-02 12:13:11,718 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6_64Guest', 214, now(), 0)
- 2019-10-02 12:13:11,718 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6Guest', 215, now(), 0)
- 2019-10-02 12:13:11,719 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6_64Guest', 216, now(), 0)
- 2019-10-02 12:13:11,723 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6Guest', 217, now(), 0)
- 2019-10-02 12:13:11,723 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6_64Guest', 218, now(), 0)
- 2019-10-02 12:13:11,723 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6Guest', 219, now(), 0)
- 2019-10-02 12:13:11,723 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6_64Guest', 220, now(), 0)
- 2019-10-02 12:13:11,724 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6Guest', 250, now(), 0)
- 2019-10-02 12:13:11,724 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux6_64Guest', 251, now(), 0)
- 2019-10-02 12:13:11,724 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux7_64Guest', 247, now(), 0)
- 2019-10-02 12:13:11,724 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'ubuntuGuest', 255, now(), 0)
- 2019-10-02 12:13:11,725 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'ubuntu64Guest', 256, now(), 0)
- 2019-10-02 12:13:11,725 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'ubuntu64Guest', 277, now(), 0)
- 2019-10-02 12:13:11,726 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'ubuntu64Guest', 278, now(), 0)
- 2019-10-02 12:13:11,726 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'ubuntu64Guest', 279, now(), 0)
- 2019-10-02 12:13:11,726 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'ubuntu64Guest', 280, now(), 0)
- 2019-10-02 12:13:11,726 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'rhel7_64Guest', 282, now(), 0)
- 2019-10-02 12:13:11,727 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'rhel7_64Guest', 283, now(), 0)
- 2019-10-02 12:13:11,727 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'rhel7_64Guest', 284, now(), 0)
- 2019-10-02 12:13:11,727 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'rhel7_64Guest', 285, now(), 0)
- 2019-10-02 12:13:11,727 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'windows9Server64Guest', 276, now(), 0)
- 2019-10-02 12:13:11,727 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'debian9Guest', 289, now(), 0)
- 2019-10-02 12:13:11,728 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'debian9_64Guest', 290, now(), 0)
- 2019-10-02 12:13:11,730 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'debian10Guest', 282, now(), 0)
- 2019-10-02 12:13:11,730 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'debian10_64Guest', 293, now(), 0)
- 2019-10-02 12:13:11,731 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'sles15_64Guest', 291, now(), 0)
- 2019-10-02 12:13:11,731 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'centos6_64Guest', 302, now(), 0)
- 2019-10-02 12:13:11,731 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'centos6_64Guest', 303, now(), 0)
- 2019-10-02 12:13:11,731 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'centos6_64Guest', 304, now(), 0)
- 2019-10-02 12:13:11,732 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'rhel8_64Guest', 286, now(), 0)
- 2019-10-02 12:13:11,732 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'ubuntu64Guest', 281, now(), 0)
- 2019-10-02 12:13:11,732 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'other4xLinuxGuest', 294, now(), 0)
- 2019-10-02 12:13:11,732 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'other4xLinux64Guest', 295, now(), 0)
- 2019-10-02 12:13:11,732 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'oracleLinux8_64Guest', 296, now(), 0)
- 2019-10-02 12:13:11,733 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'centos8_64Guest', 297, now(), 0)
- 2019-10-02 12:13:11,733 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'freebsd11Guest', 298, now(), 0)
- 2019-10-02 12:13:11,733 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'freebsd11_64Guest', 299, now(), 0)
- 2019-10-02 12:13:11,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'freebsd12Guest', 300, now(), 0)
- 2019-10-02 12:13:11,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'VMware', '6.5', 'freebsd12_64Guest', 301, now(), 0)
- 2019-10-02 12:13:11,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Copy VMware 6.5 Guest OSes to VMware 6.7
- 2019-10-02 12:13:11,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'VMware', '6.7', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='VMware' AND hypervisor_version='6.5'
- 2019-10-02 12:13:13,490 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'VMware', '6.7.1', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='VMware' AND hypervisor_version='6.7'
- 2019-10-02 12:13:15,369 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'VMware', '6.7.2', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='VMware' AND hypervisor_version='6.7.1'
- 2019-10-02 12:13:18,411 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'VMware', '6.7.3', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='VMware' AND hypervisor_version='6.7.2'
- 2019-10-02 12:13:29,548 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Copy XenServer 7.1.0 to XenServer 7.1.1
- 2019-10-02 12:13:29,548 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'Xenserver', '7.1.1', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='Xenserver' AND hypervisor_version='7.1.0'
- 2019-10-02 12:13:31,387 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Copy XenServer 7.1.1 to XenServer 7.1.2
- 2019-10-02 12:13:31,388 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'Xenserver', '7.1.2', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='Xenserver' AND hypervisor_version='7.1.1'
- 2019-10-02 12:13:33,378 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add New XenServer 7.1.2 Guest OSes
- 2019-10-02 12:13:33,378 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.1.2', 'Debian Stretch 9.0', 289, now(), 0)
- 2019-10-02 12:13:33,378 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.1.2', 'Debian Stretch 9.0', 290, now(), 0)
- 2019-10-02 12:13:33,378 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.1.2', 'Ubuntu Bionic Beaver 18.04', 279, now(), 0)
- 2019-10-02 12:13:33,379 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.1.2', 'Windows Server 2019 (64-bit)', 276, now(), 0)
- 2019-10-02 12:13:33,379 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.1.2', 'CentOS 6 (64-bit', 303, now(), 0)
- 2019-10-02 12:13:33,379 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.1.2', 'CentOS 7', 283, now(), 0)
- 2019-10-02 12:13:33,379 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.1.2', 'CentOS 7', 284, now(), 0)
- 2019-10-02 12:13:33,379 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Copy XenServer 7.5 hypervisor guest OS mappings to XenServer 7.6
- 2019-10-02 12:13:33,379 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'Xenserver', '7.6.0', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='Xenserver' AND hypervisor_version='7.5.0'
- 2019-10-02 12:13:35,320 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add New XenServer 7.6 Guest OSes
- 2019-10-02 12:13:35,320 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.6.0', 'Debian Jessie 8.0', 269, now(), 0)
- 2019-10-02 12:13:35,320 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.6.0', 'Debian Jessie 8.0', 270, now(), 0)
- 2019-10-02 12:13:35,321 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.6.0', 'Debian Stretch 9.0', 289, now(), 0)
- 2019-10-02 12:13:35,321 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.6.0', 'Debian Stretch 9.0', 290, now(), 0)
- 2019-10-02 12:13:35,321 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.6.0', 'Ubuntu Xenial Xerus 16.04', 255, now(), 0)
- 2019-10-02 12:13:35,321 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.6.0', 'Ubuntu Xenial Xerus 16.04', 256, now(), 0)
- 2019-10-02 12:13:35,321 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '7.6.0', 'Ubuntu Bionic Beaver 18.04', 279, now(), 0)
- 2019-10-02 12:13:35,322 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Copy XenServer 7.6 hypervisor guest OS mappings to XenServer8.0
- 2019-10-02 12:13:35,322 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) SELECT UUID(),'Xenserver', '8.0.0', guest_os_name, guest_os_id, utc_timestamp(), 0 FROM `cloud`.`guest_os_hypervisor` WHERE hypervisor_type='Xenserver' AND hypervisor_version='7.6.0'
- 2019-10-02 12:13:37,254 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add New XenServer 8.0 Guest OSes
- 2019-10-02 12:13:37,255 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'Xenserver', '8.0.0', 'Windows Server 2019 (64-bit)', 276, now(), 0)
- 2019-10-02 12:13:37,255 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add Missing KVM Guest OSes
- 2019-10-02 12:13:37,255 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'CentOS 6.6', 262, now(), 0)
- 2019-10-02 12:13:37,255 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'CentOS 6.7', 263, now(), 0)
- 2019-10-02 12:13:37,255 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'CentOS 6.7', 264, now(), 0)
- 2019-10-02 12:13:37,255 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'CentOS 6.8', 302, now(), 0)
- 2019-10-02 12:13:37,256 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'CentOS 6.9', 303, now(), 0)
- 2019-10-02 12:13:37,256 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'CentOS 6.10', 304, now(), 0)
- 2019-10-02 12:13:37,256 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Red Hat Enterprise Linux 7.2', 269, now(), 0)
- 2019-10-02 12:13:37,256 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Red Hat Enterprise Linux 7.3', 282, now(), 0)
- 2019-10-02 12:13:37,256 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Red Hat Enterprise Linux 7.4', 283, now(), 0)
- 2019-10-02 12:13:37,257 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Red Hat Enterprise Linux 7.5', 284, now(), 0)
- 2019-10-02 12:13:37,257 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Red Hat Enterprise Linux 7.6', 285, now(), 0)
- 2019-10-02 12:13:37,257 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Red Hat Enterprise Linux 8', 286, now(), 0)
- 2019-10-02 12:13:37,257 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Ubuntu 17.04', 277, now(), 0)
- 2019-10-02 12:13:37,257 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Ubuntu 17.10', 278, now(), 0)
- 2019-10-02 12:13:37,258 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Ubuntu 18.04 LTS', 279, now(), 0)
- 2019-10-02 12:13:37,258 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Ubuntu 18.10', 280, now(), 0)
- 2019-10-02 12:13:37,258 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Ubuntu 19.04', 281, now(), 0)
- 2019-10-02 12:13:37,258 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- DPDK client and server mode support
- 2019-10-02 12:13:37,258 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`service_offering_details` CHANGE COLUMN `value` `value` TEXT NOT NULL
- 2019-10-02 12:13:37,263 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vpc_offerings` ADD COLUMN `sort_key` int(32) NOT NULL default 0 COMMENT 'sort key used for customising sort method'
- 2019-10-02 12:13:37,269 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add `sort_key` column to data_center
- 2019-10-02 12:13:37,269 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`data_center` ADD COLUMN `sort_key` INT(32) NOT NULL DEFAULT 0
- 2019-10-02 12:13:37,274 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Move domain_id to disk offering details and drop the domain_id column
- 2019-10-02 12:13:37,274 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`disk_offering_details` (offering_id, name, value, display) SELECT id, 'domainid', domain_id, 0 FROM `cloud`.`disk_offering` WHERE domain_id IS NOT NULL AND type='Disk'
- 2019-10-02 12:13:37,275 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`service_offering_details` (service_offering_id, name, value, display) SELECT id, 'domainid', domain_id, 0 FROM `cloud`.`disk_offering` WHERE domain_id IS NOT NULL AND type='Service'
- 2019-10-02 12:13:37,276 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`disk_offering` DROP COLUMN `domain_id`
- 2019-10-02 12:13:37,281 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`service_offering_details` DROP FOREIGN KEY `fk_service_offering_details__service_offering_id`, DROP KEY `uk_service_offering_id_name`
- 2019-10-02 12:13:37,286 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`service_offering_details` ADD CONSTRAINT `fk_service_offering_details__service_offering_id` FOREIGN KEY (`service_offering_id`) REFERENCES `service_offering`(`id`) ON DELETE CASCADE
- 2019-10-02 12:13:37,292 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Disk offering with multi-domains and multi-zones
- 2019-10-02 12:13:37,292 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`disk_offering_view`
- 2019-10-02 12:13:37,292 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`disk_offering_view` AS SELECT `disk_offering`.`id` AS `id`, `disk_offering`.`uuid` AS `uuid`, `disk_offering`.`name` AS `name`, `disk_offering`.`display_text` AS `display_text`, `disk_offering`.`provisioning_type` AS `provisioning_type`, `disk_offering`.`disk_size` AS `disk_size`, `disk_offering`.`min_iops` AS `min_iops`, `disk_offering`.`max_iops` AS `max_iops`, `disk_offering`.`created` AS `created`, `disk_offering`.`tags` AS `tags`, `disk_offering`.`customized` AS `customized`, `disk_offering`.`customized_iops` AS `customized_iops`, `disk_offering`.`removed` AS `removed`, `disk_offering`.`use_local_storage` AS `use_local_storage`, `disk_offering`.`system_use` AS `system_use`, `disk_offering`.`hv_ss_reserve` AS `hv_ss_reserve`, `disk_offering`.`bytes_read_rate` AS `bytes_read_rate`, `disk_offering`.`bytes_read_rate_max` AS `bytes_read_rate_max`, `disk_offering`.`bytes_read_rate_max_length` AS `bytes_read_rate_max_length`, `disk_offering`.`bytes_write_rate` AS `bytes_write_rate`, `disk_offering`.`bytes_write_rate_max` AS `bytes_write_rate_max`, `disk_offering`.`bytes_write_rate_max_length` AS `bytes_write_rate_max_length`, `disk_offering`.`iops_read_rate` AS `iops_read_rate`, `disk_offering`.`iops_read_rate_max` AS `iops_read_rate_max`, `disk_offering`.`iops_read_rate_max_length` AS `iops_read_rate_max_length`, `disk_offering`.`iops_write_rate` AS `iops_write_rate`, `disk_offering`.`iops_write_rate_max` AS `iops_write_rate_max`, `disk_offering`.`iops_write_rate_max_length` AS `iops_write_rate_max_length`, `disk_offering`.`cache_mode` AS `cache_mode`, `disk_offering`.`sort_key` AS `sort_key`, `disk_offering`.`type` AS `type`, `disk_offering`.`display_offering` AS `display_offering`, `disk_offering`.`state` AS `state`, GROUP_CONCAT(DISTINCT(domain.id)) AS domain_id, GROUP_CONCAT(DISTINCT(domain.uuid)) AS domain_uuid, GROUP_CONCAT(DISTINCT(domain.name)) AS domain_name, GROUP_CONCAT(DISTINCT(domain.path)) AS domain_path, GROUP_CONCAT(DISTINCT(zone.id)) AS zone_id, GROUP_CONCAT(DISTINCT(zone.uuid)) AS zone_uuid, GROUP_CONCAT(DISTINCT(zone.name)) AS zone_name FROM `cloud`.`disk_offering` LEFT JOIN `cloud`.`disk_offering_details` AS `domain_details` ON `domain_details`.`offering_id` = `disk_offering`.`id` AND `domain_details`.`name`='domainid' LEFT JOIN `cloud`.`domain` AS `domain` ON FIND_IN_SET(`domain`.`id`, `domain_details`.`value`) LEFT JOIN `cloud`.`disk_offering_details` AS `zone_details` ON `zone_details`.`offering_id` = `disk_offering`.`id` AND `zone_details`.`name`='zoneid' LEFT JOIN `cloud`.`data_center` AS `zone` ON FIND_IN_SET(`zone`.`id`, `zone_details`.`value`) WHERE `disk_offering`.`state`='Active' GROUP BY `disk_offering`.`id`
- 2019-10-02 12:13:37,294 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Service offering with multi-domains and multi-zones
- 2019-10-02 12:13:37,294 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`service_offering_view`
- 2019-10-02 12:13:37,294 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`service_offering_view` AS SELECT `service_offering`.`id` AS `id`, `disk_offering`.`uuid` AS `uuid`, `disk_offering`.`name` AS `name`, `disk_offering`.`display_text` AS `display_text`, `disk_offering`.`provisioning_type` AS `provisioning_type`, `disk_offering`.`created` AS `created`, `disk_offering`.`tags` AS `tags`, `disk_offering`.`removed` AS `removed`, `disk_offering`.`use_local_storage` AS `use_local_storage`, `disk_offering`.`system_use` AS `system_use`, `disk_offering`.`customized_iops` AS `customized_iops`, `disk_offering`.`min_iops` AS `min_iops`, `disk_offering`.`max_iops` AS `max_iops`, `disk_offering`.`hv_ss_reserve` AS `hv_ss_reserve`, `disk_offering`.`bytes_read_rate` AS `bytes_read_rate`, `disk_offering`.`bytes_read_rate_max` AS `bytes_read_rate_max`, `disk_offering`.`bytes_read_rate_max_length` AS `bytes_read_rate_max_length`, `disk_offering`.`bytes_write_rate` AS `bytes_write_rate`, `disk_offering`.`bytes_write_rate_max` AS `bytes_write_rate_max`, `disk_offering`.`bytes_write_rate_max_length` AS `bytes_write_rate_max_length`, `disk_offering`.`iops_read_rate` AS `iops_read_rate`, `disk_offering`.`iops_read_rate_max` AS `iops_read_rate_max`, `disk_offering`.`iops_read_rate_max_length` AS `iops_read_rate_max_length`, `disk_offering`.`iops_write_rate` AS `iops_write_rate`, `disk_offering`.`iops_write_rate_max` AS `iops_write_rate_max`, `disk_offering`.`iops_write_rate_max_length` AS `iops_write_rate_max_length`, `disk_offering`.`cache_mode` AS `cache_mode`, `service_offering`.`cpu` AS `cpu`, `service_offering`.`speed` AS `speed`, `service_offering`.`ram_size` AS `ram_size`, `service_offering`.`nw_rate` AS `nw_rate`, `service_offering`.`mc_rate` AS `mc_rate`, `service_offering`.`ha_enabled` AS `ha_enabled`, `service_offering`.`limit_cpu_use` AS `limit_cpu_use`, `service_offering`.`host_tag` AS `host_tag`, `service_offering`.`default_use` AS `default_use`, `service_offering`.`vm_type` AS `vm_type`, `service_offering`.`sort_key` AS `sort_key`, `service_offering`.`is_volatile` AS `is_volatile`, `service_offering`.`deployment_planner` AS `deployment_planner`, GROUP_CONCAT(DISTINCT(domain.id)) AS domain_id, GROUP_CONCAT(DISTINCT(domain.uuid)) AS domain_uuid, GROUP_CONCAT(DISTINCT(domain.name)) AS domain_name, GROUP_CONCAT(DISTINCT(domain.path)) AS domain_path, GROUP_CONCAT(DISTINCT(zone.id)) AS zone_id, GROUP_CONCAT(DISTINCT(zone.uuid)) AS zone_uuid, GROUP_CONCAT(DISTINCT(zone.name)) AS zone_name FROM `cloud`.`service_offering` INNER JOIN `cloud`.`disk_offering_view` AS `disk_offering` ON service_offering.id = disk_offering.id LEFT JOIN `cloud`.`service_offering_details` AS `domain_details` ON `domain_details`.`service_offering_id` = `disk_offering`.`id` AND `domain_details`.`name`='domainid' LEFT JOIN `cloud`.`domain` AS `domain` ON FIND_IN_SET(`domain`.`id`, `domain_details`.`value`) LEFT JOIN `cloud`.`service_offering_details` AS `zone_details` ON `zone_details`.`service_offering_id` = `disk_offering`.`id` AND `zone_details`.`name`='zoneid' LEFT JOIN `cloud`.`data_center` AS `zone` ON FIND_IN_SET(`zone`.`id`, `zone_details`.`value`) WHERE `disk_offering`.`state`='Active' GROUP BY `service_offering`.`id`
- 2019-10-02 12:13:37,296 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add display column for network offering details table
- 2019-10-02 12:13:37,296 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`network_offering_details` ADD COLUMN `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the detail can be displayed to the end user'
- 2019-10-02 12:13:37,301 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Network offering with multi-domains and multi-zones
- 2019-10-02 12:13:37,301 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`network_offering_view`
- 2019-10-02 12:13:37,301 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`network_offering_view` AS SELECT `network_offerings`.`id` AS `id`, `network_offerings`.`uuid` AS `uuid`, `network_offerings`.`name` AS `name`, `network_offerings`.`unique_name` AS `unique_name`, `network_offerings`.`display_text` AS `display_text`, `network_offerings`.`nw_rate` AS `nw_rate`, `network_offerings`.`mc_rate` AS `mc_rate`, `network_offerings`.`traffic_type` AS `traffic_type`, `network_offerings`.`tags` AS `tags`, `network_offerings`.`system_only` AS `system_only`, `network_offerings`.`specify_vlan` AS `specify_vlan`, `network_offerings`.`service_offering_id` AS `service_offering_id`, `network_offerings`.`conserve_mode` AS `conserve_mode`, `network_offerings`.`created` AS `created`, `network_offerings`.`removed` AS `removed`, `network_offerings`.`default` AS `default`, `network_offerings`.`availability` AS `availability`, `network_offerings`.`dedicated_lb_service` AS `dedicated_lb_service`, `network_offerings`.`shared_source_nat_service` AS `shared_source_nat_service`, `network_offerings`.`sort_key` AS `sort_key`, `network_offerings`.`redundant_router_service` AS `redundant_router_service`, `network_offerings`.`state` AS `state`, `network_offerings`.`guest_type` AS `guest_type`, `network_offerings`.`elastic_ip_service` AS `elastic_ip_service`, `network_offerings`.`eip_associate_public_ip` AS `eip_associate_public_ip`, `network_offerings`.`elastic_lb_service` AS `elastic_lb_service`, `network_offerings`.`specify_ip_ranges` AS `specify_ip_ranges`, `network_offerings`.`inline` AS `inline`, `network_offerings`.`is_persistent` AS `is_persistent`, `network_offerings`.`internal_lb` AS `internal_lb`, `network_offerings`.`public_lb` AS `public_lb`, `network_offerings`.`egress_default_policy` AS `egress_default_policy`, `network_offerings`.`concurrent_connections` AS `concurrent_connections`, `network_offerings`.`keep_alive_enabled` AS `keep_alive_enabled`, `network_offerings`.`supports_streched_l2` AS `supports_streched_l2`, `network_offerings`.`supports_public_access` AS `supports_public_access`, `network_offerings`.`for_vpc` AS `for_vpc`, `network_offerings`.`service_package_id` AS `service_package_id`, GROUP_CONCAT(DISTINCT(domain.id)) AS domain_id, GROUP_CONCAT(DISTINCT(domain.uuid)) AS domain_uuid, GROUP_CONCAT(DISTINCT(domain.name)) AS domain_name, GROUP_CONCAT(DISTINCT(domain.path)) AS domain_path, GROUP_CONCAT(DISTINCT(zone.id)) AS zone_id, GROUP_CONCAT(DISTINCT(zone.uuid)) AS zone_uuid, GROUP_CONCAT(DISTINCT(zone.name)) AS zone_name FROM `cloud`.`network_offerings` LEFT JOIN `cloud`.`network_offering_details` AS `domain_details` ON `domain_details`.`network_offering_id` = `network_offerings`.`id` AND `domain_details`.`name`='domainid' LEFT JOIN `cloud`.`domain` AS `domain` ON FIND_IN_SET(`domain`.`id`, `domain_details`.`value`) LEFT JOIN `cloud`.`network_offering_details` AS `zone_details` ON `zone_details`.`network_offering_id` = `network_offerings`.`id` AND `zone_details`.`name`='zoneid' LEFT JOIN `cloud`.`data_center` AS `zone` ON FIND_IN_SET(`zone`.`id`, `zone_details`.`value`) GROUP BY `network_offerings`.`id`
- 2019-10-02 12:13:37,303 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Create VPC offering details table
- 2019-10-02 12:13:37,303 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `vpc_offering_details` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `offering_id` bigint(20) unsigned NOT NULL COMMENT 'vpc offering id', `name` varchar(255) NOT NULL, `value` varchar(1024) NOT NULL, `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the detail can be displayed to the end user', PRIMARY KEY (`id`), KEY `fk_vpc_offering_details__vpc_offering_id` (`offering_id`), CONSTRAINT `fk_vpc_offering_details__vpc_offering_id` FOREIGN KEY (`offering_id`) REFERENCES `vpc_offerings` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- 2019-10-02 12:13:37,304 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- VPC offering with multi-domains and multi-zones
- 2019-10-02 12:13:37,305 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`vpc_offering_view`
- 2019-10-02 12:13:37,305 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`vpc_offering_view` AS SELECT `vpc_offerings`.`id` AS `id`, `vpc_offerings`.`uuid` AS `uuid`, `vpc_offerings`.`name` AS `name`, `vpc_offerings`.`unique_name` AS `unique_name`, `vpc_offerings`.`display_text` AS `display_text`, `vpc_offerings`.`state` AS `state`, `vpc_offerings`.`default` AS `default`, `vpc_offerings`.`created` AS `created`, `vpc_offerings`.`removed` AS `removed`, `vpc_offerings`.`service_offering_id` AS `service_offering_id`, `vpc_offerings`.`supports_distributed_router` AS `supports_distributed_router`, `vpc_offerings`.`supports_region_level_vpc` AS `supports_region_level_vpc`, `vpc_offerings`.`redundant_router_service` AS `redundant_router_service`, `vpc_offerings`.`sort_key` AS `sort_key`, GROUP_CONCAT(DISTINCT(domain.id)) AS domain_id, GROUP_CONCAT(DISTINCT(domain.uuid)) AS domain_uuid, GROUP_CONCAT(DISTINCT(domain.name)) AS domain_name, GROUP_CONCAT(DISTINCT(domain.path)) AS domain_path, GROUP_CONCAT(DISTINCT(zone.id)) AS zone_id, GROUP_CONCAT(DISTINCT(zone.uuid)) AS zone_uuid, GROUP_CONCAT(DISTINCT(zone.name)) AS zone_name FROM `cloud`.`vpc_offerings` LEFT JOIN `cloud`.`vpc_offering_details` AS `domain_details` ON `domain_details`.`offering_id` = `vpc_offerings`.`id` AND `domain_details`.`name`='domainid' LEFT JOIN `cloud`.`domain` AS `domain` ON FIND_IN_SET(`domain`.`id`, `domain_details`.`value`) LEFT JOIN `cloud`.`vpc_offering_details` AS `zone_details` ON `zone_details`.`offering_id` = `vpc_offerings`.`id` AND `zone_details`.`name`='zoneid' LEFT JOIN `cloud`.`data_center` AS `zone` ON FIND_IN_SET(`zone`.`id`, `zone_details`.`value`) GROUP BY `vpc_offerings`.`id`
- 2019-10-02 12:13:37,306 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Recreate data_center_view
- 2019-10-02 12:13:37,306 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`data_center_view`
- 2019-10-02 12:13:37,307 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, data_center.sort_key, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, dedicated_resources.affinity_group_id, dedicated_resources.account_id, affinity_group.uuid affinity_group_uuid from `cloud`.`data_center` left join `cloud`.`domain` ON data_center.domain_id = domain.id left join `cloud`.`dedicated_resources` ON data_center.id = dedicated_resources.data_center_id left join `cloud`.`affinity_group` ON dedicated_resources.affinity_group_id = affinity_group.id
- 2019-10-02 12:13:37,308 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Remove key/value tags from project_view
- 2019-10-02 12:13:37,308 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`project_view`
- 2019-10-02 12:13:37,308 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, projects.project_account_id, account.account_name owner, pacct.account_id, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path 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`.`project_account` pacct ON projects.id = pacct.project_id
- 2019-10-02 12:13:37,309 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- KVM: Add background task to upload certificates for direct download
- 2019-10-02 12:13:37,309 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`direct_download_certificate` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(40) NOT NULL, `alias` varchar(255) NOT NULL, `certificate` text NOT NULL, `hypervisor_type` varchar(45) NOT NULL, `zone_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `i_direct_download_certificate_alias` (`alias`), KEY `fk_direct_download_certificate__zone_id` (`zone_id`), CONSTRAINT `fk_direct_download_certificate__zone_id` FOREIGN KEY (`zone_id`) REFERENCES `data_center` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- 2019-10-02 12:13:37,311 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`direct_download_certificate_host_map` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `certificate_id` bigint(20) unsigned NOT NULL, `host_id` bigint(20) unsigned NOT NULL, `revoked` int(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `fk_direct_download_certificate_host_map__host_id` (`host_id`), KEY `fk_direct_download_certificate_host_map__certificate_id` (`certificate_id`), CONSTRAINT `fk_direct_download_certificate_host_map__host_id` FOREIGN KEY (`host_id`) REFERENCES `host` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_direct_download_certificate_host_map__certificate_id` FOREIGN KEY (`certificate_id`) REFERENCES `direct_download_certificate` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- 2019-10-02 12:13:37,314 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- [Vmware] Allow configuring appliances on the VM instance wizard when OVF properties are available
- 2019-10-02 12:13:37,314 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`template_ovf_properties` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `template_id` bigint(20) unsigned NOT NULL, `key` VARCHAR(100) NOT NULL, `type` VARCHAR(45) DEFAULT NULL, `value` VARCHAR(100) DEFAULT NULL, `password` TINYINT(1) NOT NULL DEFAULT '0', `qualifiers` TEXT DEFAULT NULL, `user_configurable` TINYINT(1) NOT NULL DEFAULT '0', `label` TEXT DEFAULT NULL, `description` TEXT DEFAULT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_template_ovf_properties__template_id` FOREIGN KEY (`template_id`) REFERENCES `vm_template`(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- 2019-10-02 12:13:37,315 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Add VM snapshot ID on usage helper tables
- 2019-10-02 12:13:37,316 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud_usage`.`usage_vmsnapshot` ADD COLUMN `vm_snapshot_id` BIGINT(20) NULL DEFAULT NULL AFTER `processed`
- 2019-10-02 12:13:37,319 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud_usage`.`usage_snapshot_on_primary` ADD COLUMN `vm_snapshot_id` BIGINT(20) NULL DEFAULT NULL AFTER `deleted`
- 2019-10-02 12:13:37,323 DEBUG [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) Updating System Vm template IDs
- 2019-10-02 12:13:37,325 DEBUG [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) Updating XenServer System Vms
- 2019-10-02 12:13:37,327 WARN [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) 4.13.0.0XenServer SystemVm template not found. XenServer hypervisor is not used, so not failing upgrade
- 2019-10-02 12:13:37,328 DEBUG [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) Updating Hyperv System Vms
- 2019-10-02 12:13:37,329 WARN [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) 4.13.0.0Hyperv SystemVm template not found. Hyperv hypervisor is not used, so not failing upgrade
- 2019-10-02 12:13:37,330 DEBUG [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) Updating Ovm3 System Vms
- 2019-10-02 12:13:37,330 WARN [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) 4.13.0.0Ovm3 SystemVm template not found. Ovm3 hypervisor is not used, so not failing upgrade
- 2019-10-02 12:13:37,331 DEBUG [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) Updating VMware System Vms
- 2019-10-02 12:13:37,331 WARN [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) 4.13.0.0VMware SystemVm template not found. VMware hypervisor is not used, so not failing upgrade
- 2019-10-02 12:13:37,332 DEBUG [c.c.u.d.Upgrade41200to41300] (main:null) (logid:) Updating KVM System Vms
- 2019-10-02 12:13:37,333 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to upgrade the database
- com.cloud.utils.exception.CloudRuntimeException: 4.13.0.0KVM SystemVm template not found. Cannot upgrade system Vms
- at com.cloud.upgrade.dao.Upgrade41200to41300.updateSystemVmTemplates(Upgrade41200to41300.java:210)
- at com.cloud.upgrade.dao.Upgrade41200to41300.performDataMigration(Upgrade41200to41300.java:67)
- at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:256)
- 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)
- 2019-10-02 12:13:37,334 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:) Rolling back the transaction: Time = 25635 Name = Upgrade; called by -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-TransactionLegacy.close:657-DatabaseUpgradeChecker.upgrade:267-DatabaseUpgradeChecker.check:336-CloudStackExtendedLifeCycle.checkIntegrity:65-CloudStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:183-DefaultLifecycleProcessor.access$200:52-DefaultLifecycleProcessor$LifecycleGroup.start:358-DefaultLifecycleProcessor.startBeans:159-DefaultLifecycleProcessor.onRefresh:123
- 2019-10-02 12:13:37,336 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
- 2019-10-02 12:13:37,337 WARN [o.e.j.w.WebAppContext] (main:null) (logid:) Failed startup of context o.e.j.w.WebAppContext@646be2c3{/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: 4.13.0.0KVM SystemVm template not found. Cannot upgrade system Vms
- at com.cloud.upgrade.dao.Upgrade41200to41300.updateSystemVmTemplates(Upgrade41200to41300.java:210)
- at com.cloud.upgrade.dao.Upgrade41200to41300.performDataMigration(Upgrade41200to41300.java:67)
- at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:256)
- ... 49 more
- 2019-10-02 12:13:37,339 INFO [o.e.j.s.h.ContextHandler] (main:null) (logid:) Started o.e.j.s.h.MovedContextHandler@6e2c9341{/,null,AVAILABLE}
- 2019-10-02 12:13:37,361 INFO [o.e.j.s.AbstractConnector] (main:null) (logid:) Started ServerConnector@51e2adc7{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
- 2019-10-02 12:13:37,362 INFO [o.e.j.s.Server] (main:null) (logid:) Started @37613ms
Advertisement
Add Comment
Please, Sign In to add comment