· 5 years ago · Feb 12, 2020, 12:58 PM
1# cat /var/log/cloudstack/management/management-server.l
22020-02-12 12:14:21,710 INFO [o.a.c.ServerDaemon] (main:null) (logid:) Server configuration file found: /etc/cloudstack/management/server.properties
32020-02-12 12:14:21,722 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
42020-02-12 12:14:21,744 INFO [o.e.j.u.log] (main:null) (logid:) Logging initialized @867ms to org.eclipse.jetty.util.log.Slf4jLog
52020-02-12 12:14:22,040 INFO [o.e.j.s.Server] (main:null) (logid:) jetty-9.4.z-SNAPSHOT, build timestamp: 2017-11-21T21:27:37Z, git hash: 82b8fb23f757335bb3329d540ce37a2a2615f0a8
62020-02-12 12:14:22,083 INFO [o.e.j.s.AbstractNCSARequestLog] (main:null) (logid:) Opened /var/log/cloudstack/management/access.log
72020-02-12 12:14:22,248 INFO [o.e.j.w.StandardDescriptorProcessor] (main:null) (logid:) NO JSP Support for /client, did not find org.eclipse.jetty.jsp.JettyJspServlet
82020-02-12 12:14:22,293 INFO [o.e.j.s.session] (main:null) (logid:) DefaultSessionIdManager workerName=node0
92020-02-12 12:14:22,293 INFO [o.e.j.s.session] (main:null) (logid:) No SessionScavenger set, using defaults
102020-02-12 12:14:22,305 INFO [o.e.j.s.session] (main:null) (logid:) Scavenging every 660000ms
112020-02-12 12:14:38,135 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]
122020-02-12 12:14:38,136 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]
132020-02-12 12:14:38,542 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] (main:null) (logid:) Encryption Type: file
142020-02-12 12:14:38,635 INFO [c.c.u.LogUtils] (main:null) (logid:) log4j configuration found at /etc/cloudstack/management/log4j-cloud.xml
152020-02-12 12:14:38,670 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loaded module context [bootstrap] in 535 ms
162020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bootstrap
172020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: system
182020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: core
192020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: allocator
202020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-allocator-random
212020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: planner
222020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-planner
232020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-planner
242020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: explicit-dedication
252020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-affinity
262020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-anti-affinity
272020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: implicit-dedication
282020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-planner
292020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: skip-heurestics
302020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: user-concentrated-pod
312020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-allocator
322020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api
332020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-dynamic-role-based
342020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-static-role-based
352020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cloudian
362020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ldap
372020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: md5
382020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: metrics
392020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: pbkdf2
402020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: plaintext
412020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: prometheus
422020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: quota
432020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: rate-limit
442020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: saml2
452020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-api
462020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: sha256salted
472020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: solidfire-intg-test
482020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-sioc
492020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-config
502020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: backend
512020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ca
522020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: root-ca
532020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: compute
542020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-compute
552020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-compute
562020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kvm-compute
572020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-compute
582020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-compute
592020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-compute
602020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-compute
612020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-fencer
622020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-investigator
632020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-compute
642020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-compute
652020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: network
662020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-network
672020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bigswitch
682020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cisco-vnmc
692020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: contrail
702020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: elb
712020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: f5
722020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: globodns
732020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: netscaler
742020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nvp
752020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: opendaylight
762020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovs
772020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: paloalto
782020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-network
792020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: srx
802020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ssp
812020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vcs
822020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-network
832020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vxlan
842020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-backend
852020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage
862020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-storage
872020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-storage
882020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-storage
892020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-template-adapter
902020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-allocator
912020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-default
922020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-s3
932020-02-12 12:14:38,680 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-swift
942020-02-12 12:14:38,680 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-cloudbyte
952020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-datera
962020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-default
972020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-solidfire
982020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-storage
992020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: discoverer
1002020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-discoverer
1012020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-discoverer
1022020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-discoverer
1032020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-discoverer
1042020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: secondary-storage-discoverer
1052020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-discoverer
1062020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-discoverer
1072020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-discoverer
1082020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: outofbandmanagement
1092020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ipmitool
1102020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nested-cloudstack
1112020-02-12 12:14:38,724 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]
1122020-02-12 12:14:38,725 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]
1132020-02-12 12:14:38,725 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]
1142020-02-12 12:14:38,725 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]
1152020-02-12 12:14:38,725 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]
1162020-02-12 12:14:38,725 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]
1172020-02-12 12:14:38,725 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]
1182020-02-12 12:14:38,725 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]
1192020-02-12 12:14:38,725 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]
1202020-02-12 12:14:40,616 INFO [c.c.u.d.T.Transaction] (main:null) (logid:) Is Data Base High Availiability enabled? Ans : false
1212020-02-12 12:14:40,744 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) Successfully loaded DB driver com.mysql.jdbc.Driver
1222020-02-12 12:14:40,770 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) DB driver com.mysql.jdbc.Driver was already loaded.
1232020-02-12 12:14:40,771 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) DB driver com.mysql.jdbc.Driver was already loaded.
1242020-02-12 12:14:41,238 DEBUG [c.c.u.d.ConnectionConcierge] (main:null) (logid:) Registering a database connection for LockMaster1
1252020-02-12 12:14:41,239 INFO [c.c.u.d.Merovingian2] (main:null) (logid:) Cleaning up locks for 90520732983863
1262020-02-12 12:14:41,242 INFO [c.c.u.d.Merovingian2] (main:null) (logid:) Released 0 locks for 90520732983863
1272020-02-12 12:14:41,763 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Running system integrity checker com.cloud.upgrade.DatabaseUpgradeChecker@1813f3e9
1282020-02-12 12:14:41,764 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Grabbing lock to check for database upgrade.
1292020-02-12 12:14:41,841 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
1302020-02-12 12:14:41,880 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) DB version = 4.0.0 Code Version = 4.13.0.0
1312020-02-12 12:14:41,881 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Database upgrade must be performed from 4.0.0 to 4.13.0.0
1322020-02-12 12:14:41,903 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Running upgrade Upgrade40to41 to upgrade from 4.0.0-4.1.0 to 4.1.0
1332020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Licensed to the Apache Software Foundation (ASF) under one
1342020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- or more contributor license agreements. See the NOTICE file
1352020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- distributed with this work for additional information
1362020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- regarding copyright ownership. The ASF licenses this file
1372020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- to you under the Apache License, Version 2.0 (the
1382020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "License"); you may not use this file except in compliance
1392020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- with the License. You may obtain a copy of the License at
1402020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
1412020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- http://www.apache.org/licenses/LICENSE-2.0
1422020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
1432020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Unless required by applicable law or agreed to in writing,
1442020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- software distributed under the License is distributed on an
1452020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
1462020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- KIND, either express or implied. See the License for the
1472020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- specific language governing permissions and limitations
1482020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- under the License.
1492020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
1502020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Schema upgrade from 4.0.0 to 4.1.0;
1512020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
1522020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) use cloud
1532020-02-12 12:14:41,938 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) SET foreign_key_checks = 0
1542020-02-12 12:14:41,947 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_template add size bigint unsigned
1552020-02-12 12:14:42,607 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_template add state varchar(255)
1562020-02-12 12:14:42,895 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_template add update_count bigint unsigned
1572020-02-12 12:14:43,162 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_template add updated datetime
1582020-02-12 12:14:43,424 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table storage_pool add storage_provider_id bigint unsigned
1592020-02-12 12:14:43,634 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table storage_pool add scope varchar(255)
1602020-02-12 12:14:43,847 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table storage_pool modify id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL
1612020-02-12 12:14:44,151 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table template_spool_ref add state varchar(255)
1622020-02-12 12:14:44,326 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table template_spool_ref add update_count bigint unsigned
1632020-02-12 12:14:44,485 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table volumes add disk_type varchar(255)
1642020-02-12 12:14:44,764 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table volumes drop foreign key `fk_volumes__account_id`
1652020-02-12 12:14:44,797 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column disk_offering_id bigint unsigned
1662020-02-12 12:14:45,122 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column cpu int(10) unsigned
1672020-02-12 12:14:45,440 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column ram bigint unsigned
1682020-02-12 12:14:45,769 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column owner varchar(255)
1692020-02-12 12:14:46,121 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column speed int(10) unsigned
1702020-02-12 12:14:46,451 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column host_name varchar(255)
1712020-02-12 12:14:46,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column display_name varchar(255)
1722020-02-12 12:14:47,110 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column `desired_state` varchar(32) NULL
1732020-02-12 12:14:47,460 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table data_center add column owner varchar(255)
1742020-02-12 12:14:47,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table data_center add column created datetime COMMENT 'date created'
1752020-02-12 12:14:47,937 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table data_center add column lastUpdated datetime COMMENT 'last updated'
1762020-02-12 12:14:48,174 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table data_center add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
1772020-02-12 12:14:48,398 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host_pod_ref add column owner varchar(255)
1782020-02-12 12:14:48,631 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host_pod_ref add column created datetime COMMENT 'date created'
1792020-02-12 12:14:48,853 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host_pod_ref add column lastUpdated datetime COMMENT 'last updated'
1802020-02-12 12:14:49,077 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host_pod_ref add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
1812020-02-12 12:14:49,313 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host add column owner varchar(255)
1822020-02-12 12:14:49,572 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host add column lastUpdated datetime COMMENT 'last updated'
1832020-02-12 12:14:49,836 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
1842020-02-12 12:14:50,084 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table cluster add column owner varchar(255)
1852020-02-12 12:14:50,324 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table cluster add column created datetime COMMENT 'date created'
1862020-02-12 12:14:50,567 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table cluster add column lastUpdated datetime COMMENT 'last updated'
1872020-02-12 12:14:50,815 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table cluster add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
1882020-02-12 12:14:51,057 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`vm_compute_tags` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `compute_tag` varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1892020-02-12 12:14:51,162 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`vm_root_disk_tags` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `root_disk_tag` varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1902020-02-12 12:14:51,240 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`vm_network_map` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `network_id` bigint unsigned NOT NULL COMMENT 'network id', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1912020-02-12 12:14:51,334 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`vm_reservation` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) NOT NULL COMMENT 'reservation id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `data_center_id` bigint unsigned NOT NULL COMMENT 'zone id', `pod_id` bigint unsigned NOT NULL COMMENT 'pod id', `cluster_id` bigint unsigned NOT NULL COMMENT 'cluster id', `host_id` bigint unsigned NOT NULL COMMENT 'host id', `created` datetime COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', CONSTRAINT `uc_vm_reservation__uuid` UNIQUE (`uuid`), PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1922020-02-12 12:14:51,445 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`volume_reservation` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_reservation_id` bigint unsigned NOT NULL COMMENT 'id of the vm reservation', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `volume_id` bigint unsigned NOT NULL COMMENT 'volume id', `pool_id` bigint unsigned NOT NULL COMMENT 'pool assigned to the volume', CONSTRAINT `fk_vm_pool_reservation__vm_reservation_id` FOREIGN KEY (`vm_reservation_id`) REFERENCES `vm_reservation`(`id`) ON DELETE CASCADE, PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1932020-02-12 12:14:51,554 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`s3` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `access_key` varchar(20) NOT NULL COMMENT ' The S3 access key', `secret_key` varchar(40) NOT NULL COMMENT ' The S3 secret key', `end_point` varchar(1024) COMMENT ' The S3 host', `bucket` varchar(63) NOT NULL COMMENT ' The S3 host', `https` tinyint unsigned DEFAULT NULL COMMENT ' Flag indicating whether or not to connect over HTTPS', `connection_timeout` integer COMMENT ' The amount of time to wait (in milliseconds) when initially establishing a connection before giving up and timing out.', `max_error_retry` integer COMMENT ' The maximum number of retry attempts for failed retryable requests (ex: 5xx error responses from services).', `socket_timeout` integer COMMENT ' The amount of time to wait (in milliseconds) for data to be transfered over an established, open connection before the connection times out and is closed.', `created` datetime COMMENT 'date the s3 first signed on', PRIMARY KEY (`id`), CONSTRAINT `uc_s3__uuid` UNIQUE (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1942020-02-12 12:14:51,660 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`template_s3_ref` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `s3_id` bigint unsigned NOT NULL COMMENT ' Associated S3 instance id', `template_id` bigint unsigned NOT NULL COMMENT ' Associated template id', `created` DATETIME NOT NULL COMMENT ' The creation timestamp', `size` bigint unsigned COMMENT ' The size of the object', `physical_size` bigint unsigned DEFAULT 0 COMMENT ' The physical size of the object', PRIMARY KEY (`id`), CONSTRAINT `uc_template_s3_ref__template_id` UNIQUE (`template_id`), CONSTRAINT `fk_template_s3_ref__s3_id` FOREIGN KEY `fk_template_s3_ref__s3_id` (`s3_id`) REFERENCES `s3` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_template_s3_ref__template_id` FOREIGN KEY `fk_template_s3_ref__template_id` (`template_id`) REFERENCES `vm_template` (`id`), INDEX `i_template_s3_ref__s3_id`(`s3_id`), INDEX `i_template_s3_ref__template_id`(`template_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1952020-02-12 12:14:51,784 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 's3.enable', 'false', 'enable s3')
1962020-02-12 12:14:51,785 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'NetworkManager', 'router.check.poolsize' , '10', 'Numbers of threads using to check redundant router status.')
1972020-02-12 12:14:51,787 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`snapshots` ADD COLUMN `s3_id` bigint unsigned COMMENT 'S3 to which this snapshot will be stored'
1982020-02-12 12:14:52,038 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`snapshots` ADD CONSTRAINT `fk_snapshots__s3_id` FOREIGN KEY `fk_snapshots__s3_id` (`s3_id`) REFERENCES `s3` (`id`)
1992020-02-12 12:14:52,117 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`network_offerings` ADD COLUMN `inline` int(1) unsigned NOT NULL DEFAULT 0 COMMENT 'Is this network offering LB provider is in inline mode'
2002020-02-12 12:14:52,330 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`external_load_balancer_devices` DROP COLUMN `is_inline`
2012020-02-12 12:14:52,528 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network','DEFAULT','NetworkManager','network.dhcp.nondefaultnetwork.setgateway.guestos','Windows','The guest OS\'s name start with this fields would result in DHCP server response gateway information even when the network it\'s on is not default network. Names are separated by comma.')
2022020-02-12 12:14:52,531 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` ADD `queue_size` SMALLINT NOT NULL DEFAULT '0' COMMENT 'number of items being processed by the queue'
2032020-02-12 12:14:52,722 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` ADD `queue_size_limit` SMALLINT NOT NULL DEFAULT '1' COMMENT 'max number of items the queue can process concurrently'
2042020-02-12 12:14:52,924 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` DROP INDEX `i_sync_queue__queue_proc_time`
2052020-02-12 12:14:52,981 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` DROP COLUMN `queue_proc_time`
2062020-02-12 12:14:53,174 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` DROP COLUMN `queue_proc_msid`
2072020-02-12 12:14:53,354 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue_item` ADD `queue_proc_time` DATETIME COMMENT 'when processing started for the item' AFTER `queue_proc_number`
2082020-02-12 12:14:53,556 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue_item` ADD INDEX `i_sync_queue__queue_proc_time`(`queue_proc_time`)
2092020-02-12 12:14:53,636 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`inline_load_balancer_nic_map` DROP FOREIGN KEY fk_inline_load_balancer_nic_map__load_balancer_id
2102020-02-12 12:14:53,667 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`inline_load_balancer_nic_map` DROP COLUMN load_balancer_id
2112020-02-12 12:14:53,835 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE upload ADD uuid VARCHAR(40)
2122020-02-12 12:14:54,009 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE async_job modify job_cmd VARCHAR(255)
2132020-02-12 12:14:54,354 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`network_offerings` ADD COLUMN `is_persistent` int(1) unsigned NOT NULL DEFAULT 0 COMMENT 'true if the network offering provides an ability to create persistent networks'
2142020-02-12 12:14:54,603 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- populate uuid column with db id if uuid is null
2152020-02-12 12:14:54,604 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`account` set uuid=id WHERE uuid is NULL
2162020-02-12 12:14:54,608 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`alert` set uuid=id WHERE uuid is NULL
2172020-02-12 12:14:54,613 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`async_job` set uuid=id WHERE uuid is NULL
2182020-02-12 12:14:54,620 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`cluster` set uuid=id WHERE uuid is NULL
2192020-02-12 12:14:54,621 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`data_center` set uuid=id WHERE uuid is NULL
2202020-02-12 12:14:54,623 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`dc_storage_network_ip_range` set uuid=id WHERE uuid is NULL
2212020-02-12 12:14:54,625 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`disk_offering` set uuid=id WHERE uuid is NULL
2222020-02-12 12:14:54,627 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`domain` set uuid=id WHERE uuid is NULL
2232020-02-12 12:14:54,629 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`event` set uuid=id WHERE uuid is NULL
2242020-02-12 12:14:54,632 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`external_firewall_devices` set uuid=id WHERE uuid is NULL
2252020-02-12 12:14:54,635 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`external_load_balancer_devices` set uuid=id WHERE uuid is NULL
2262020-02-12 12:14:54,637 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`external_nicira_nvp_devices` set uuid=id WHERE uuid is NULL
2272020-02-12 12:14:54,638 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`firewall_rules` set uuid=id WHERE uuid is NULL
2282020-02-12 12:14:54,639 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`guest_os` set uuid=id WHERE uuid is NULL
2292020-02-12 12:14:54,640 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`guest_os_category` set uuid=id WHERE uuid is NULL
2302020-02-12 12:14:54,642 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`host` set uuid=id WHERE uuid is NULL
2312020-02-12 12:14:54,643 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`host_pod_ref` set uuid=id WHERE uuid is NULL
2322020-02-12 12:14:54,644 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`hypervisor_capabilities` set uuid=id WHERE uuid is NULL
2332020-02-12 12:14:54,645 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`instance_group` set uuid=id WHERE uuid is NULL
2342020-02-12 12:14:54,665 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`load_balancer_stickiness_policies` set uuid=id WHERE uuid is NULL
2352020-02-12 12:14:54,666 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`network_external_firewall_device_map` set uuid=id WHERE uuid is NULL
2362020-02-12 12:14:54,668 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`network_external_lb_device_map` set uuid=id WHERE uuid is NULL
2372020-02-12 12:14:54,670 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`network_offerings` set uuid=id WHERE uuid is NULL
2382020-02-12 12:14:54,672 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`networks` set uuid=id WHERE uuid is NULL
2392020-02-12 12:14:54,674 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`nics` set uuid=id WHERE uuid is NULL
2402020-02-12 12:14:54,675 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`physical_network` set uuid=id WHERE uuid is NULL
2412020-02-12 12:14:54,676 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`physical_network_service_providers` set uuid=id WHERE uuid is NULL
2422020-02-12 12:14:54,677 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`physical_network_traffic_types` set uuid=id WHERE uuid is NULL
2432020-02-12 12:14:54,678 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`port_profile` set uuid=id WHERE uuid is NULL
2442020-02-12 12:14:54,680 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`project_invitations` set uuid=id WHERE uuid is NULL
2452020-02-12 12:14:54,681 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`projects` set uuid=id WHERE uuid is NULL
2462020-02-12 12:14:54,682 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`resource_tags` set uuid=id WHERE uuid is NULL
2472020-02-12 12:14:54,683 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`s2s_customer_gateway` set uuid=id WHERE uuid is NULL
2482020-02-12 12:14:54,685 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`s2s_vpn_connection` set uuid=id WHERE uuid is NULL
2492020-02-12 12:14:54,686 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`s2s_vpn_gateway` set uuid=id WHERE uuid is NULL
2502020-02-12 12:14:54,688 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`security_group` set uuid=id WHERE uuid is NULL
2512020-02-12 12:14:54,689 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`security_group_rule` set uuid=id WHERE uuid is NULL
2522020-02-12 12:14:54,692 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`snapshot_schedule` set uuid=id WHERE uuid is NULL
2532020-02-12 12:14:54,694 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`snapshots` set uuid=id WHERE uuid is NULL
2542020-02-12 12:14:54,696 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`snapshot_policy` set uuid=id WHERE uuid is NULL
2552020-02-12 12:14:54,697 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`static_routes` set uuid=id WHERE uuid is NULL
2562020-02-12 12:14:54,701 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`storage_pool` set uuid=id WHERE uuid is NULL
2572020-02-12 12:14:54,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`swift` set uuid=id WHERE uuid is NULL
2582020-02-12 12:14:54,705 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`upload` set uuid=id WHERE uuid is NULL
2592020-02-12 12:14:54,708 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`user` set uuid=id WHERE uuid is NULL
2602020-02-12 12:14:54,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`user_ip_address` set uuid=id WHERE uuid is NULL
2612020-02-12 12:14:54,713 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`user_vm_temp` set uuid=id WHERE uuid is NULL;
2622020-02-12 12:14:54,713 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`virtual_router_providers` set uuid=id WHERE uuid is NULL
2632020-02-12 12:14:54,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`virtual_supervisor_module` set uuid=id WHERE uuid is NULL
2642020-02-12 12:14:54,718 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vlan` set uuid=id WHERE uuid is NULL
2652020-02-12 12:14:54,721 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vm_instance` set uuid=id WHERE uuid is NULL
2662020-02-12 12:14:54,722 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vm_template` set uuid=id WHERE uuid is NULL
2672020-02-12 12:14:54,723 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vpc` set uuid=id WHERE uuid is NULL
2682020-02-12 12:14:54,724 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vpc_gateways` set uuid=id WHERE uuid is NULL
2692020-02-12 12:14:54,726 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vpc_offerings` set uuid=id WHERE uuid is NULL
2702020-02-12 12:14:54,728 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vpn_users` set uuid=id WHERE uuid is NULL
2712020-02-12 12:14:54,730 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`volumes` set uuid=id WHERE uuid is NULL
2722020-02-12 12:14:54,731 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`configuration` set value = '/var/cloudstack/mnt' where name = 'mount.parent'
2732020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`autoscale_vmgroups` set uuid=id WHERE uuid is NULL;
2742020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`autoscale_vmprofiles` set uuid=id WHERE uuid is NULL;
2752020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`autoscale_policies` set uuid=id WHERE uuid is NULL;
2762020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`counter` set uuid=id WHERE uuid is NULL;
2772020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`conditions` set uuid=id WHERE uuid is NULL;
2782020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'detail.batch.query.size', '2000', 'Default entity detail batch query size for listing')
2792020-02-12 12:14:54,735 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'api.throttling.enabled', 'false', 'Enable/Disable Api rate limit')
2802020-02-12 12:14:54,739 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'api.throttling.interval', '1', 'Time interval (in seconds) to reset API count')
2812020-02-12 12:14:54,741 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'api.throttling.max', '25', 'Max allowed number of APIs within fixed interval')
2822020-02-12 12:14:54,743 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'api.throttling.cachesize', '50000', 'Account based API count cache size')
2832020-02-12 12:14:54,744 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'direct.agent.pool.size', '500', 'Default size for DirectAgentPool')
2842020-02-12 12:14:54,745 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`op_dc_vnet_alloc` DROP INDEX i_op_dc_vnet_alloc__vnet__data_center_id
2852020-02-12 12:14:54,796 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`op_dc_vnet_alloc` ADD CONSTRAINT UNIQUE `i_op_dc_vnet_alloc__vnet__data_center_id`(`vnet`, `physical_network_id`, `data_center_id`)
2862020-02-12 12:14:54,863 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`op_dc_vnet_alloc` DROP INDEX i_op_dc_vnet_alloc__vnet__data_center_id__account_id
2872020-02-12 12:14:54,916 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`region` ( `id` int unsigned NOT NULL UNIQUE, `name` varchar(255) NOT NULL UNIQUE, `end_point` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2882020-02-12 12:14:55,032 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`region` values ('1','Local','http://localhost:8080/client/')
2892020-02-12 12:14:55,037 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`nicira_nvp_router_map` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `logicalrouter_uuid` varchar(255) NOT NULL UNIQUE COMMENT 'nicira uuid of logical router', `network_id` bigint unsigned NOT NULL UNIQUE COMMENT 'cloudstack id of the network', PRIMARY KEY (`id`), CONSTRAINT `fk_nicira_nvp_router_map__network_id` FOREIGN KEY (`network_id`) REFERENCES `networks`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2902020-02-12 12:14:55,162 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`external_bigswitch_vns_devices` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255) UNIQUE, `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical network in to which bigswitch vns device is added', `provider_name` varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this bigswitch vns device', `device_name` varchar(255) NOT NULL COMMENT 'name of the bigswitch vns device', `host_id` bigint unsigned NOT NULL COMMENT 'host id coresponding to the external bigswitch vns device', PRIMARY KEY (`id`), CONSTRAINT `fk_external_bigswitch_vns_devices__host_id` FOREIGN KEY (`host_id`) REFERENCES `host`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_external_bigswitch_vns_devices__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2912020-02-12 12:14:55,294 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`counter` ( `id` bigint unsigned NOT NULL UNIQUE AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `source` varchar(255) NOT NULL COMMENT 'source e.g. netscaler, snmp', `name` varchar(255) NOT NULL COMMENT 'Counter name', `value` varchar(255) NOT NULL COMMENT 'Value in case of source=snmp', `removed` datetime COMMENT 'date removed if not null', `created` datetime NOT NULL COMMENT 'date created', PRIMARY KEY (`id`), CONSTRAINT `uc_counter__uuid` UNIQUE (`uuid`), INDEX `i_counter__removed`(`removed`), INDEX `i_counter__source`(`source`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2922020-02-12 12:14:55,440 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`conditions` ( `id` bigint unsigned NOT NULL UNIQUE AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `counter_id` bigint unsigned NOT NULL COMMENT 'Counter Id', `threshold` bigint unsigned NOT NULL COMMENT 'threshold value for the given counter', `relational_operator` char(2) COMMENT 'relational operator to be used upon the counter and condition', `domain_id` bigint unsigned NOT NULL COMMENT 'domain the Condition belongs to', `account_id` bigint unsigned NOT NULL COMMENT 'owner of this Condition', `removed` datetime COMMENT 'date removed if not null', `created` datetime NOT NULL COMMENT 'date created', PRIMARY KEY (`id`), CONSTRAINT `fk_conditions__counter_id` FOREIGN KEY `fk_condition__counter_id`(`counter_id`) REFERENCES `counter`(`id`), CONSTRAINT `fk_conditions__account_id` FOREIGN KEY `fk_condition__account_id` (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_conditions__domain_id` FOREIGN KEY `fk_condition__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_conditions__uuid` UNIQUE (`uuid`), INDEX `i_conditions__removed`(`removed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2932020-02-12 12:14:55,606 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_vmprofiles` ( `id` bigint unsigned NOT NULL auto_increment, `uuid` varchar(40), `zone_id` bigint unsigned NOT NULL, `domain_id` bigint unsigned NOT NULL, `account_id` bigint unsigned NOT NULL, `autoscale_user_id` bigint unsigned NOT NULL, `service_offering_id` bigint unsigned NOT NULL, `template_id` bigint unsigned NOT NULL, `other_deploy_params` varchar(1024) COMMENT 'other deployment parameters that is in addition to zoneid,serviceofferingid,domainid', `destroy_vm_grace_period` int unsigned COMMENT 'the time allowed for existing connections to get closed before a vm is destroyed', `counter_params` varchar(1024) COMMENT 'the parameters for the counter to be used to get metric information from VMs', `created` datetime NOT NULL COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_vmprofiles__domain_id` FOREIGN KEY `fk_autoscale_vmprofiles__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmprofiles__account_id` FOREIGN KEY `fk_autoscale_vmprofiles__account_id` (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmprofiles__autoscale_user_id` FOREIGN KEY `fk_autoscale_vmprofiles__autoscale_user_id` (`autoscale_user_id`) REFERENCES `user`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_autoscale_vmprofiles__uuid` UNIQUE (`uuid`), INDEX `i_autoscale_vmprofiles__removed`(`removed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2942020-02-12 12:14:55,771 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_policies` ( `id` bigint unsigned NOT NULL auto_increment, `uuid` varchar(40), `domain_id` bigint unsigned NOT NULL, `account_id` bigint unsigned NOT NULL, `duration` int unsigned NOT NULL, `quiet_time` int unsigned NOT NULL, `last_quiet_time` datetime DEFAULT NULL, `action` varchar(15), `created` datetime NOT NULL COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_policies__domain_id` FOREIGN KEY `fk_autoscale_policies__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_policies__account_id` FOREIGN KEY `fk_autoscale_policies__account_id` (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_autoscale_policies__uuid` UNIQUE (`uuid`), INDEX `i_autoscale_policies__removed`(`removed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2952020-02-12 12:14:55,922 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_vmgroups` ( `id` bigint unsigned NOT NULL auto_increment, `uuid` varchar(40), `zone_id` bigint unsigned NOT NULL, `domain_id` bigint unsigned NOT NULL, `account_id` bigint unsigned NOT NULL, `load_balancer_id` bigint unsigned NOT NULL, `min_members` int unsigned DEFAULT 1, `max_members` int unsigned NOT NULL, `member_port` int unsigned NOT NULL, `interval` int unsigned NOT NULL, `profile_id` bigint unsigned NOT NULL, `state` varchar(255) NOT NULL COMMENT 'enabled or disabled, a vmgroup is disabled to stop autoscaling activity', `created` datetime NOT NULL COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_vmgroup__autoscale_vmprofile_id` FOREIGN KEY(`profile_id`) REFERENCES `autoscale_vmprofiles`(`id`), CONSTRAINT `fk_autoscale_vmgroup__load_balancer_id` FOREIGN KEY(`load_balancer_id`) REFERENCES `load_balancing_rules`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroups__domain_id` FOREIGN KEY `fk_autoscale_vmgroups__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroups__account_id` FOREIGN KEY `fk_autoscale_vmgroups__account_id` (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroups__zone_id` FOREIGN KEY `fk_autoscale_vmgroups__zone_id`(`zone_id`) REFERENCES `data_center`(`id`), CONSTRAINT `uc_autoscale_vmgroups__uuid` UNIQUE (`uuid`), INDEX `i_autoscale_vmgroups__removed`(`removed`), INDEX `i_autoscale_vmgroups__load_balancer_id`(`load_balancer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2962020-02-12 12:14:56,105 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_policy_condition_map` ( `id` bigint unsigned NOT NULL auto_increment, `policy_id` bigint unsigned NOT NULL, `condition_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_policy_condition_map__policy_id` FOREIGN KEY `fk_autoscale_policy_condition_map__policy_id` (`policy_id`) REFERENCES `autoscale_policies` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_policy_condition_map__condition_id` FOREIGN KEY `fk_autoscale_policy_condition_map__condition_id` (`condition_id`) REFERENCES `conditions` (`id`), INDEX `i_autoscale_policy_condition_map__policy_id`(`policy_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2972020-02-12 12:14:56,223 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_vmgroup_policy_map` ( `id` bigint unsigned NOT NULL auto_increment, `vmgroup_id` bigint unsigned NOT NULL, `policy_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_vmgroup_policy_map__vmgroup_id` FOREIGN KEY `fk_autoscale_vmgroup_policy_map__vmgroup_id` (`vmgroup_id`) REFERENCES `autoscale_vmgroups` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroup_policy_map__policy_id` FOREIGN KEY `fk_autoscale_vmgroup_policy_map__policy_id` (`policy_id`) REFERENCES `autoscale_policies` (`id`), INDEX `i_autoscale_vmgroup_policy_map__vmgroup_id`(`vmgroup_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2982020-02-12 12:14:56,352 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_vmgroup_vm_map` ( `id` bigint unsigned NOT NULL auto_increment, `vmgroup_id` bigint unsigned NOT NULL, `instance_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_vmgroup_vm_map__vmgroup_id` FOREIGN KEY `fk_autoscale_vmgroup_vm_map__vmgroup_id` (`vmgroup_id`) REFERENCES `autoscale_vmgroups` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroup_vm_map__instance_id` FOREIGN KEY `fk_autoscale_vmgroup_vm_map__instance_id` (`instance_id`) REFERENCES `vm_instance` (`id`), INDEX `i_autoscale_vmgroup_vm_map__vmgroup_id`(`vmgroup_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2992020-02-12 12:14:56,487 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (1, UUID(), 'snmp','Linux User CPU - percentage', '1.3.6.1.4.1.2021.11.9.0', now())
3002020-02-12 12:14:56,490 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (2, UUID(), 'snmp','Linux System CPU - percentage', '1.3.6.1.4.1.2021.11.10.0', now())
3012020-02-12 12:14:56,493 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (3, UUID(), 'snmp','Linux CPU Idle - percentage', '1.3.6.1.4.1.2021.11.11.0', now())
3022020-02-12 12:14:56,497 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (100, UUID(), 'netscaler','Response Time - microseconds', 'RESPTIME', now())
3032020-02-12 12:14:56,499 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (4, UUID(), 'cpu','Linux User CPU - percentage - native', '1.3.6.1.4.1.2021.11.9.1', now())
3042020-02-12 12:14:56,505 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (5, UUID(), 'memory','Linux User RAM - percentage - native', '1.3.6.1.4.1.2021.11.10.1', now())
3052020-02-12 12:14:56,505 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`user_ipv6_address` ( `id` bigint unsigned NOT NULL UNIQUE auto_increment, `uuid` varchar(40), `account_id` bigint unsigned NULL, `domain_id` bigint unsigned NULL, `ip_address` char(50) NOT NULL, `data_center_id` bigint unsigned NOT NULL COMMENT 'zone that it belongs to', `vlan_id` bigint unsigned NOT NULL, `state` char(32) NOT NULL default 'Free' COMMENT 'state of the ip address', `mac_address` varchar(40) NOT NULL COMMENT 'mac address of this ip', `source_network_id` bigint unsigned NOT NULL COMMENT 'network id ip belongs to', `network_id` bigint unsigned COMMENT 'network this public ip address is associated with', `physical_network_id` bigint unsigned NOT NULL COMMENT 'physical network id that this configuration is based on', `created` datetime NULL COMMENT 'Date this ip was allocated to someone', PRIMARY KEY (`id`), UNIQUE (`ip_address`, `source_network_id`), CONSTRAINT `fk_user_ipv6_address__source_network_id` FOREIGN KEY (`source_network_id`) REFERENCES `networks`(`id`), CONSTRAINT `fk_user_ipv6_address__network_id` FOREIGN KEY (`network_id`) REFERENCES `networks`(`id`), CONSTRAINT `fk_user_ipv6_address__account_id` FOREIGN KEY (`account_id`) REFERENCES `account`(`id`), CONSTRAINT `fk_user_ipv6_address__vlan_id` FOREIGN KEY (`vlan_id`) REFERENCES `vlan`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_user_ipv6_address__data_center_id` FOREIGN KEY (`data_center_id`) REFERENCES `data_center`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_user_ipv6_address__uuid` UNIQUE (`uuid`), CONSTRAINT `fk_user_ipv6_address__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
3062020-02-12 12:14:56,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`networks` ADD COLUMN `ip6_gateway` varchar(50) COMMENT 'IPv6 gateway for this network'
3072020-02-12 12:14:56,962 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`networks` ADD COLUMN `ip6_cidr` varchar(50) COMMENT 'IPv6 cidr for this network'
3082020-02-12 12:14:57,224 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`nics` ADD COLUMN `ip6_gateway` varchar(50) COMMENT 'gateway for ip6 address'
3092020-02-12 12:14:57,438 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`nics` ADD COLUMN `ip6_cidr` varchar(50) COMMENT 'cidr for ip6 address'
3102020-02-12 12:14:57,645 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vlan` ADD COLUMN `ip6_gateway` varchar(255)
3112020-02-12 12:14:57,842 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vlan` ADD COLUMN `ip6_cidr` varchar(255)
3122020-02-12 12:14:58,029 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vlan` ADD COLUMN `ip6_range` varchar(255)
3132020-02-12 12:14:58,210 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`data_center` ADD COLUMN `ip6_dns1` varchar(255)
3142020-02-12 12:14:58,425 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`data_center` ADD COLUMN `ip6_dns2` varchar(255)
3152020-02-12 12:14:58,658 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`networks` INNER JOIN `cloud`.`vlan` ON networks.id = vlan.network_id SET networks.gateway = vlan.vlan_gateway, networks.ip6_gateway = vlan.ip6_gateway, networks.ip6_cidr = vlan.ip6_cidr WHERE networks.data_center_id = vlan.data_center_id AND networks.physical_network_id = vlan.physical_network_id
3162020-02-12 12:14:58,663 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- DB views for list api
3172020-02-12 12:14:58,664 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`user_vm_view`
3182020-02-12 12:14:58,674 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`user_vm_view` AS select vm_instance.id id, vm_instance.name name, user_vm.display_name display_name, user_vm.user_data user_data, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, instance_group.id instance_group_id, instance_group.uuid instance_group_uuid, instance_group.name instance_group_name, vm_instance.uuid uuid, vm_instance.last_host_id last_host_id, vm_instance.vm_type type, vm_instance.vnc_password vnc_password, vm_instance.limit_cpu_use limit_cpu_use, vm_instance.created created, vm_instance.state state, vm_instance.removed removed, vm_instance.ha_enabled ha_enabled, vm_instance.hypervisor_type hypervisor_type, vm_instance.instance_name instance_name, vm_instance.guest_os_id guest_os_id, guest_os.uuid guest_os_uuid, vm_instance.pod_id pod_id, host_pod_ref.uuid pod_uuid, vm_instance.private_ip_address private_ip_address, vm_instance.private_mac_address private_mac_address, vm_instance.vm_type vm_type, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.is_security_group_enabled security_group_enabled, host.id host_id, host.uuid host_uuid, host.name host_name, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.name template_name, vm_template.display_text template_display_text, vm_template.enable_password password_enabled, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, service_offering.id service_offering_id, disk_offering.uuid service_offering_uuid, service_offering.cpu cpu, service_offering.speed speed, service_offering.ram_size ram_size, disk_offering.name service_offering_name, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.pool_type pool_type, volumes.id volume_id, volumes.uuid volume_uuid, volumes.device_id volume_device_id, volumes.volume_type volume_type, security_group.id security_group_id, security_group.uuid security_group_uuid, security_group.name security_group_name, security_group.description security_group_description, nics.id nic_id, nics.uuid nic_uuid, nics.network_id network_id, nics.ip4_address ip_address, nics.ip6_address ip6_address, nics.ip6_gateway ip6_gateway, nics.ip6_cidr ip6_cidr, nics.default_nic is_default_nic, nics.gateway gateway, nics.netmask netmask, nics.mac_address mac_address, nics.broadcast_uri broadcast_uri, nics.isolation_uri isolation_uri, vpc.id vpc_id, vpc.uuid vpc_uuid, networks.uuid network_uuid, networks.name network_name, networks.traffic_type traffic_type, networks.guest_type guest_type, user_ip_address.id public_ip_id, user_ip_address.uuid public_ip_uuid, user_ip_address.public_ip_address public_ip_address, ssh_keypairs.keypair_name keypair_name, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`user_vm` inner join `cloud`.`vm_instance` ON vm_instance.id = user_vm.id and vm_instance.removed is NULL inner join `cloud`.`account` ON vm_instance.account_id = account.id inner join `cloud`.`domain` ON vm_instance.domain_id = domain.id left join `cloud`.`guest_os` ON vm_instance.guest_os_id = guest_os.id left join `cloud`.`host_pod_ref` ON vm_instance.pod_id = host_pod_ref.id left join `cloud`.`projects` ON projects.project_account_id = account.id left join `cloud`.`instance_group_vm_map` ON vm_instance.id = instance_group_vm_map.instance_id left join `cloud`.`instance_group` ON instance_group_vm_map.group_id = instance_group.id left join `cloud`.`data_center` ON vm_instance.data_center_id = data_center.id left join `cloud`.`host` ON vm_instance.host_id = host.id left join `cloud`.`vm_template` ON vm_instance.vm_template_id = vm_template.id left join `cloud`.`vm_template` iso ON iso.id = user_vm.iso_id left join `cloud`.`service_offering` ON vm_instance.service_offering_id = service_offering.id left join `cloud`.`disk_offering` ON vm_instance.service_offering_id = disk_offering.id left join `cloud`.`volumes` ON vm_instance.id = volumes.instance_id left join `cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left join `cloud`.`security_group_vm_map` ON vm_instance.id = security_group_vm_map.instance_id left join `cloud`.`security_group` ON security_group_vm_map.security_group_id = security_group.id left join `cloud`.`nics` ON vm_instance.id = nics.instance_id left join `cloud`.`networks` ON nics.network_id = networks.id left join `cloud`.`vpc` ON networks.vpc_id = vpc.id left join `cloud`.`user_ip_address` ON user_ip_address.vm_id = vm_instance.id left join `cloud`.`user_vm_details` ON user_vm_details.vm_id = vm_instance.id and user_vm_details.name = 'SSH.PublicKey' left join `cloud`.`ssh_keypairs` ON ssh_keypairs.public_key = user_vm_details.value left join `cloud`.`resource_tags` ON resource_tags.resource_id = vm_instance.id and resource_tags.resource_type = 'UserVm' left join `cloud`.`async_job` ON async_job.instance_id = vm_instance.id and async_job.instance_type = 'VirtualMachine' and async_job.job_status = 0
3192020-02-12 12:14:58,689 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`domain_router_view`
3202020-02-12 12:14:58,693 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`domain_router_view` AS select vm_instance.id id, vm_instance.name name, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, vm_instance.uuid uuid, vm_instance.created created, vm_instance.state state, vm_instance.removed removed, vm_instance.pod_id pod_id, vm_instance.instance_name instance_name, host_pod_ref.uuid pod_uuid, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, data_center.dns1 dns1, data_center.dns2 dns2, data_center.ip6_dns1 ip6_dns1, data_center.ip6_dns2 ip6_dns2, host.id host_id, host.uuid host_uuid, host.name host_name, vm_template.id template_id, vm_template.uuid template_uuid, service_offering.id service_offering_id, disk_offering.uuid service_offering_uuid, disk_offering.name service_offering_name, nics.id nic_id, nics.uuid nic_uuid, nics.network_id network_id, nics.ip4_address ip_address, nics.ip6_address ip6_address, nics.ip6_gateway ip6_gateway, nics.ip6_cidr ip6_cidr, nics.default_nic is_default_nic, nics.gateway gateway, nics.netmask netmask, nics.mac_address mac_address, nics.broadcast_uri broadcast_uri, nics.isolation_uri isolation_uri, vpc.id vpc_id, vpc.uuid vpc_uuid, networks.uuid network_uuid, networks.name network_name, networks.network_domain network_domain, networks.traffic_type traffic_type, networks.guest_type guest_type, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id, domain_router.template_version template_version, domain_router.scripts_version scripts_version, domain_router.is_redundant_router is_redundant_router, domain_router.redundant_state redundant_state, domain_router.stop_pending stop_pending, domain_router.role role from `cloud`.`domain_router` inner join `cloud`.`vm_instance` ON vm_instance.id = domain_router.id inner join `cloud`.`account` ON vm_instance.account_id = account.id inner join `cloud`.`domain` ON vm_instance.domain_id = domain.id left join `cloud`.`host_pod_ref` ON vm_instance.pod_id = host_pod_ref.id left join `cloud`.`projects` ON projects.project_account_id = account.id left join `cloud`.`data_center` ON vm_instance.data_center_id = data_center.id left join `cloud`.`host` ON vm_instance.host_id = host.id left join `cloud`.`vm_template` ON vm_instance.vm_template_id = vm_template.id left join `cloud`.`service_offering` ON vm_instance.service_offering_id = service_offering.id left join `cloud`.`disk_offering` ON vm_instance.service_offering_id = disk_offering.id left join `cloud`.`volumes` ON vm_instance.id = volumes.instance_id left join `cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left join `cloud`.`nics` ON vm_instance.id = nics.instance_id left join `cloud`.`networks` ON nics.network_id = networks.id left join `cloud`.`vpc` ON domain_router.vpc_id = vpc.id left join `cloud`.`async_job` ON async_job.instance_id = vm_instance.id and async_job.instance_type = 'DomainRouter' and async_job.job_status = 0
3212020-02-12 12:14:58,705 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`security_group_view`
3222020-02-12 12:14:58,707 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`security_group_view` AS select security_group.id id, security_group.name name, security_group.description description, security_group.uuid uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, security_group_rule.id rule_id, security_group_rule.uuid rule_uuid, security_group_rule.type rule_type, security_group_rule.start_port rule_start_port, security_group_rule.end_port rule_end_port, security_group_rule.protocol rule_protocol, security_group_rule.allowed_network_id rule_allowed_network_id, security_group_rule.allowed_ip_cidr rule_allowed_ip_cidr, security_group_rule.create_status rule_create_status, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`security_group` left join `cloud`.`security_group_rule` ON security_group.id = security_group_rule.security_group_id inner join `cloud`.`account` ON security_group.account_id = account.id inner join `cloud`.`domain` ON security_group.domain_id = domain.id left join `cloud`.`projects` ON projects.project_account_id = security_group.account_id left join `cloud`.`resource_tags` ON resource_tags.resource_id = security_group.id and resource_tags.resource_type = 'SecurityGroup' left join `cloud`.`async_job` ON async_job.instance_id = security_group.id and async_job.instance_type = 'SecurityGroup' and async_job.job_status = 0
3232020-02-12 12:14:58,723 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`resource_tag_view`
3242020-02-12 12:14:58,730 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`resource_tag_view` AS select resource_tags.id, resource_tags.uuid, resource_tags.key, resource_tags.value, resource_tags.resource_id, resource_tags.resource_uuid, resource_tags.resource_type, resource_tags.customer, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name from `cloud`.`resource_tags` inner join `cloud`.`account` ON resource_tags.account_id = account.id inner join `cloud`.`domain` ON resource_tags.domain_id = domain.id left join `cloud`.`projects` ON projects.project_account_id = resource_tags.account_id
3252020-02-12 12:14:58,748 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`event_view`
3262020-02-12 12:14:58,771 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`event_view` AS select event.id, event.uuid, event.type, event.state, event.description, event.created, event.level, event.parameters, event.start_id, eve.uuid start_uuid, event.user_id, user.username user_name, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name from `cloud`.`event` inner join `cloud`.`account` ON event.account_id = account.id inner join `cloud`.`domain` ON event.domain_id = domain.id inner join `cloud`.`user` ON event.user_id = user.id left join `cloud`.`projects` ON projects.project_account_id = event.account_id left join `cloud`.`event` eve ON event.start_id = eve.id
3272020-02-12 12:14:58,785 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`instance_group_view`
3282020-02-12 12:14:58,787 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`instance_group_view` AS select instance_group.id, instance_group.uuid, instance_group.name, instance_group.removed, instance_group.created, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name from `cloud`.`instance_group` inner join `cloud`.`account` ON instance_group.account_id = account.id inner join `cloud`.`domain` ON account.domain_id = domain.id left join `cloud`.`projects` ON projects.project_account_id = instance_group.account_id
3292020-02-12 12:14:58,799 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`user_view`
3302020-02-12 12:14:58,803 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`user_view` AS select user.id, user.uuid, user.username, user.password, user.firstname, user.lastname, user.email, user.state, user.api_key, user.secret_key, user.created, user.removed, user.timezone, user.registration_token, user.is_registered, user.incorrect_login_attempts, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`user` inner join `cloud`.`account` ON user.account_id = account.id inner join `cloud`.`domain` ON account.domain_id = domain.id left join `cloud`.`async_job` ON async_job.instance_id = user.id and async_job.instance_type = 'User' and async_job.job_status = 0
3312020-02-12 12:14:58,819 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`project_view`
3322020-02-12 12:14:58,820 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`project_view` AS select projects.id, projects.uuid, projects.name, projects.display_text, projects.state, projects.removed, projects.created, account.account_name owner, pacct.account_id, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer from `cloud`.`projects` inner join `cloud`.`domain` ON projects.domain_id = domain.id inner join `cloud`.`project_account` ON projects.id = project_account.project_id and project_account.account_role = 'Admin' inner join `cloud`.`account` ON account.id = project_account.account_id left join `cloud`.`resource_tags` ON resource_tags.resource_id = projects.id and resource_tags.resource_type = 'Project' left join `cloud`.`project_account` pacct ON projects.id = pacct.project_id
3332020-02-12 12:14:58,838 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`project_account_view`
3342020-02-12 12:14:58,844 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`project_account_view` AS select project_account.id, account.id account_id, account.uuid account_uuid, account.account_name, account.type account_type, project_account.account_role, projects.id project_id, projects.uuid project_uuid, projects.name project_name, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`project_account` inner join `cloud`.`account` ON project_account.account_id = account.id inner join `cloud`.`domain` ON account.domain_id = domain.id inner join `cloud`.`projects` ON projects.id = project_account.project_id
3352020-02-12 12:14:58,878 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`project_invitation_view`
3362020-02-12 12:14:58,879 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`project_invitation_view` AS select project_invitations.id, project_invitations.uuid, project_invitations.email, project_invitations.created, project_invitations.state, projects.id project_id, projects.uuid project_uuid, projects.name project_name, account.id account_id, account.uuid account_uuid, account.account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`project_invitations` left join `cloud`.`account` ON project_invitations.account_id = account.id left join `cloud`.`domain` ON project_invitations.domain_id = domain.id left join `cloud`.`projects` ON projects.id = project_invitations.project_id
3372020-02-12 12:14:58,902 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`host_view`
3382020-02-12 12:14:58,904 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`host_view` AS select host.id, host.uuid, host.name, host.status, host.disconnected, host.type, host.private_ip_address, host.version, host.hypervisor_type, host.hypervisor_version, host.capabilities, host.last_ping, host.created, host.removed, host.resource_state, host.mgmt_server_id, host.cpus, host.speed, host.ram, cluster.id cluster_id, cluster.uuid cluster_uuid, cluster.name cluster_name, cluster.cluster_type, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid, host_pod_ref.name pod_name, host_tags.tag, guest_os_category.id guest_os_category_id, guest_os_category.uuid guest_os_category_uuid, guest_os_category.name guest_os_category_name, mem_caps.used_capacity memory_used_capacity, mem_caps.reserved_capacity memory_reserved_capacity, cpu_caps.used_capacity cpu_used_capacity, cpu_caps.reserved_capacity cpu_reserved_capacity, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`host` left join `cloud`.`cluster` ON host.cluster_id = cluster.id left join `cloud`.`data_center` ON host.data_center_id = data_center.id left join `cloud`.`host_pod_ref` ON host.pod_id = host_pod_ref.id left join `cloud`.`host_details` ON host.id = host_details.host_id and host_details.name = 'guest.os.category.id' left join `cloud`.`guest_os_category` ON guest_os_category.id = CONVERT( host_details.value , UNSIGNED) left join `cloud`.`host_tags` ON host_tags.host_id = host.id left join `cloud`.`op_host_capacity` mem_caps ON host.id = mem_caps.host_id and mem_caps.capacity_type = 0 left join `cloud`.`op_host_capacity` cpu_caps ON host.id = cpu_caps.host_id and cpu_caps.capacity_type = 1 left join `cloud`.`async_job` ON async_job.instance_id = host.id and async_job.instance_type = 'Host' and async_job.job_status = 0
3392020-02-12 12:14:58,930 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`volume_view`
3402020-02-12 12:14:58,931 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`volume_view` AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_host_ref.size volume_host_size, volume_host_ref.created volume_host_created, volume_host_ref.format, volume_host_ref.download_pct, volume_host_ref.download_state, volume_host_ref.error_str, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`volumes` inner join `cloud`.`account` ON volumes.account_id = account.id inner join `cloud`.`domain` ON volumes.domain_id = domain.id left join `cloud`.`projects` ON projects.project_account_id = account.id left join `cloud`.`data_center` ON volumes.data_center_id = data_center.id left join `cloud`.`vm_instance` ON volumes.instance_id = vm_instance.id left join `cloud`.`user_vm` ON user_vm.id = vm_instance.id left join `cloud`.`volume_host_ref` ON volumes.id = volume_host_ref.volume_id and volumes.data_center_id = volume_host_ref.zone_id left join `cloud`.`disk_offering` ON volumes.disk_offering_id = disk_offering.id left join `cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id left join `cloud`.`vm_template` ON volumes.template_id = vm_template.id left join `cloud`.`resource_tags` ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join `cloud`.`async_job` ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
3412020-02-12 12:14:58,947 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`account_netstats_view`
3422020-02-12 12:14:58,948 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`account_netstats_view` AS SELECT account_id, sum(net_bytes_received) + sum(current_bytes_received) as bytesReceived, sum(net_bytes_sent) + sum(current_bytes_sent) as bytesSent FROM `cloud`.`user_statistics` group by account_id
3432020-02-12 12:14:58,961 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`account_vmstats_view`
3442020-02-12 12:14:58,963 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`account_vmstats_view` AS SELECT account_id, state, count(*) as vmcount from `cloud`.`vm_instance` group by account_id , state
3452020-02-12 12:14:58,973 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`free_ip_view`
3462020-02-12 12:14:58,974 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`free_ip_view` AS select count(user_ip_address.id) free_ip from `cloud`.`user_ip_address` inner join `cloud`.`vlan` ON vlan.id = user_ip_address.vlan_db_id and vlan.vlan_type = 'VirtualNetwork' where state = 'Free'
3472020-02-12 12:14:58,989 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`account_view`
3482020-02-12 12:14:58,990 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`account_view` AS select account.id, account.uuid, account.account_name, account.type, account.state, account.removed, account.cleanup_needed, account.network_domain, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, account_netstats_view.bytesReceived, account_netstats_view.bytesSent, vmlimit.max vmLimit, vmcount.count vmTotal, runningvm.vmcount runningVms, stoppedvm.vmcount stoppedVms, iplimit.max ipLimit, ipcount.count ipTotal, free_ip_view.free_ip ipFree, volumelimit.max volumeLimit, volumecount.count volumeTotal, snapshotlimit.max snapshotLimit, snapshotcount.count snapshotTotal, templatelimit.max templateLimit, templatecount.count templateTotal, vpclimit.max vpcLimit, vpccount.count vpcTotal, projectlimit.max projectLimit, projectcount.count projectTotal, networklimit.max networkLimit, networkcount.count networkTotal, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`free_ip_view`, `cloud`.`account` inner join `cloud`.`domain` ON account.domain_id = domain.id left join `cloud`.`data_center` ON account.default_zone_id = data_center.id left join `cloud`.`account_netstats_view` ON account.id = account_netstats_view.account_id left join `cloud`.`resource_limit` vmlimit ON account.id = vmlimit.account_id and vmlimit.type = 'user_vm' left join `cloud`.`resource_count` vmcount ON account.id = vmcount.account_id and vmcount.type = 'user_vm' left join `cloud`.`account_vmstats_view` runningvm ON account.id = runningvm.account_id and runningvm.state = 'Running' left join `cloud`.`account_vmstats_view` stoppedvm ON account.id = stoppedvm.account_id and stoppedvm.state = 'Stopped' left join `cloud`.`resource_limit` iplimit ON account.id = iplimit.account_id and iplimit.type = 'public_ip' left join `cloud`.`resource_count` ipcount ON account.id = ipcount.account_id and ipcount.type = 'public_ip' left join `cloud`.`resource_limit` volumelimit ON account.id = volumelimit.account_id and volumelimit.type = 'volume' left join `cloud`.`resource_count` volumecount ON account.id = volumecount.account_id and volumecount.type = 'volume' left join `cloud`.`resource_limit` snapshotlimit ON account.id = snapshotlimit.account_id and snapshotlimit.type = 'snapshot' left join `cloud`.`resource_count` snapshotcount ON account.id = snapshotcount.account_id and snapshotcount.type = 'snapshot' left join `cloud`.`resource_limit` templatelimit ON account.id = templatelimit.account_id and templatelimit.type = 'template' left join `cloud`.`resource_count` templatecount ON account.id = templatecount.account_id and templatecount.type = 'template' left join `cloud`.`resource_limit` vpclimit ON account.id = vpclimit.account_id and vpclimit.type = 'vpc' left join `cloud`.`resource_count` vpccount ON account.id = vpccount.account_id and vpccount.type = 'vpc' left join `cloud`.`resource_limit` projectlimit ON account.id = projectlimit.account_id and projectlimit.type = 'project' left join `cloud`.`resource_count` projectcount ON account.id = projectcount.account_id and projectcount.type = 'project' left join `cloud`.`resource_limit` networklimit ON account.id = networklimit.account_id and networklimit.type = 'network' left join `cloud`.`resource_count` networkcount ON account.id = networkcount.account_id and networkcount.type = 'network' left join `cloud`.`async_job` ON async_job.instance_id = account.id and async_job.instance_type = 'Account' and async_job.job_status = 0
3492020-02-12 12:14:59,021 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`async_job_view`
3502020-02-12 12:14:59,023 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`async_job_view` AS select account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, user.id user_id, user.uuid user_uuid, async_job.id, async_job.uuid, async_job.job_cmd, async_job.job_status, async_job.job_process_status, async_job.job_result_code, async_job.job_result, async_job.created, async_job.removed, async_job.instance_type, async_job.instance_id, CASE WHEN async_job.instance_type = 'Volume' THEN volumes.uuid WHEN async_job.instance_type = 'Template' or async_job.instance_type = 'Iso' THEN vm_template.uuid WHEN async_job.instance_type = 'VirtualMachine' or async_job.instance_type = 'ConsoleProxy' or async_job.instance_type = 'SystemVm' or async_job.instance_type = 'DomainRouter' THEN vm_instance.uuid WHEN async_job.instance_type = 'Snapshot' THEN snapshots.uuid WHEN async_job.instance_type = 'Host' THEN host.uuid WHEN async_job.instance_type = 'StoragePool' THEN storage_pool.uuid WHEN async_job.instance_type = 'IpAddress' THEN user_ip_address.uuid WHEN async_job.instance_type = 'SecurityGroup' THEN security_group.uuid WHEN async_job.instance_type = 'PhysicalNetwork' THEN physical_network.uuid WHEN async_job.instance_type = 'TrafficType' THEN physical_network_traffic_types.uuid WHEN async_job.instance_type = 'PhysicalNetworkServiceProvider' THEN physical_network_service_providers.uuid WHEN async_job.instance_type = 'FirewallRule' THEN firewall_rules.uuid WHEN async_job.instance_type = 'Account' THEN acct.uuid WHEN async_job.instance_type = 'User' THEN us.uuid WHEN async_job.instance_type = 'StaticRoute' THEN static_routes.uuid WHEN async_job.instance_type = 'PrivateGateway' THEN vpc_gateways.uuid WHEN async_job.instance_type = 'Counter' THEN counter.uuid WHEN async_job.instance_type = 'Condition' THEN conditions.uuid WHEN async_job.instance_type = 'AutoScalePolicy' THEN autoscale_policies.uuid WHEN async_job.instance_type = 'AutoScaleVmProfile' THEN autoscale_vmprofiles.uuid WHEN async_job.instance_type = 'AutoScaleVmGroup' THEN autoscale_vmgroups.uuid ELSE null END instance_uuid from `cloud`.`async_job` left join `cloud`.`account` ON async_job.account_id = account.id left join `cloud`.`domain` ON domain.id = account.domain_id left join `cloud`.`user` ON async_job.user_id = user.id left join `cloud`.`volumes` ON async_job.instance_id = volumes.id left join `cloud`.`vm_template` ON async_job.instance_id = vm_template.id left join `cloud`.`vm_instance` ON async_job.instance_id = vm_instance.id left join `cloud`.`snapshots` ON async_job.instance_id = snapshots.id left join `cloud`.`host` ON async_job.instance_id = host.id left join `cloud`.`storage_pool` ON async_job.instance_id = storage_pool.id left join `cloud`.`user_ip_address` ON async_job.instance_id = user_ip_address.id left join `cloud`.`security_group` ON async_job.instance_id = security_group.id left join `cloud`.`physical_network` ON async_job.instance_id = physical_network.id left join `cloud`.`physical_network_traffic_types` ON async_job.instance_id = physical_network_traffic_types.id left join `cloud`.`physical_network_service_providers` ON async_job.instance_id = physical_network_service_providers.id left join `cloud`.`firewall_rules` ON async_job.instance_id = firewall_rules.id left join `cloud`.`account` acct ON async_job.instance_id = acct.id left join `cloud`.`user` us ON async_job.instance_id = us.id left join `cloud`.`static_routes` ON async_job.instance_id = static_routes.id left join `cloud`.`vpc_gateways` ON async_job.instance_id = vpc_gateways.id left join `cloud`.`counter` ON async_job.instance_id = counter.id left join `cloud`.`conditions` ON async_job.instance_id = conditions.id left join `cloud`.`autoscale_policies` ON async_job.instance_id = autoscale_policies.id left join `cloud`.`autoscale_vmprofiles` ON async_job.instance_id = autoscale_vmprofiles.id left join `cloud`.`autoscale_vmgroups` ON async_job.instance_id = autoscale_vmgroups.id
3512020-02-12 12:14:59,045 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`storage_pool_view`
3522020-02-12 12:14:59,048 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`storage_pool_view` AS select storage_pool.id, storage_pool.uuid, storage_pool.name, storage_pool.status, storage_pool.path, storage_pool.pool_type, storage_pool.host_address, storage_pool.created, storage_pool.removed, storage_pool.capacity_bytes, storage_pool.scope, cluster.id cluster_id, cluster.uuid cluster_uuid, cluster.name cluster_name, cluster.cluster_type, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid, host_pod_ref.name pod_name, storage_pool_details.name tag, op_host_capacity.used_capacity disk_used_capacity, op_host_capacity.reserved_capacity disk_reserved_capacity, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`storage_pool` left join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id left join `cloud`.`data_center` ON storage_pool.data_center_id = data_center.id left join `cloud`.`host_pod_ref` ON storage_pool.pod_id = host_pod_ref.id left join `cloud`.`storage_pool_details` ON storage_pool_details.pool_id = storage_pool.id and storage_pool_details.value = 'true' left join `cloud`.`op_host_capacity` ON storage_pool.id = op_host_capacity.host_id and op_host_capacity.capacity_type = 3 left join `cloud`.`async_job` ON async_job.instance_id = storage_pool.id and async_job.instance_type = 'StoragePool' and async_job.job_status = 0
3532020-02-12 12:14:59,059 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`disk_offering_view`
3542020-02-12 12:14:59,060 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`disk_offering_view` AS select disk_offering.id, disk_offering.uuid, disk_offering.name, disk_offering.display_text, disk_offering.disk_size, disk_offering.created, disk_offering.tags, disk_offering.customized, disk_offering.removed, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.sort_key, disk_offering.type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`disk_offering` left join `cloud`.`domain` ON disk_offering.domain_id = domain.id
3552020-02-12 12:14:59,075 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`service_offering_view`
3562020-02-12 12:14:59,077 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`service_offering_view` AS select service_offering.id, disk_offering.uuid, disk_offering.name, disk_offering.display_text, disk_offering.created, disk_offering.tags, disk_offering.removed, disk_offering.use_local_storage, disk_offering.system_use, service_offering.cpu, service_offering.speed, service_offering.ram_size, service_offering.nw_rate, service_offering.mc_rate, service_offering.ha_enabled, service_offering.limit_cpu_use, service_offering.host_tag, service_offering.default_use, service_offering.vm_type, service_offering.sort_key, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`service_offering` inner join `cloud`.`disk_offering` ON service_offering.id = disk_offering.id left join `cloud`.`domain` ON disk_offering.domain_id = domain.id
3572020-02-12 12:14:59,094 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`data_center_view`
3582020-02-12 12:14:59,095 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`data_center_view` AS select data_center.id, data_center.uuid, data_center.name, data_center.is_security_group_enabled, data_center.is_local_storage_enabled, data_center.description, data_center.dns1, data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1, data_center.internal_dns2, data_center.guest_network_cidr, data_center.domain, data_center.networktype, data_center.allocation_state, data_center.zone_token, data_center.dhcp_provider, data_center.removed, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`data_center` left join `cloud`.`domain` ON data_center.domain_id = domain.id
3592020-02-12 12:14:59,109 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`baremetal_dhcp_devices` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `nsp_id` bigint unsigned DEFAULT NULL COMMENT 'Network Service Provider ID', `pod_id` bigint unsigned DEFAULT NULL COMMENT 'Pod id where this dhcp server in', `device_type` varchar(255) DEFAULT NULL COMMENT 'type of the external device', `physical_network_id` bigint unsigned DEFAULT NULL COMMENT 'id of the physical network in to which external dhcp device is added', `host_id` bigint unsigned DEFAULT NULL COMMENT 'host id coresponding to the external dhcp device', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
3602020-02-12 12:14:59,215 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`baremetal_pxe_devices` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `nsp_id` bigint unsigned DEFAULT NULL COMMENT 'Network Service Provider ID', `pod_id` bigint unsigned DEFAULT NULL COMMENT 'Pod id where this pxe server in, for pxe per zone this field is null', `device_type` varchar(255) DEFAULT NULL COMMENT 'type of the pxe device', `physical_network_id` bigint unsigned DEFAULT NULL COMMENT 'id of the physical network in to which external pxe device is added', `host_id` bigint unsigned DEFAULT NULL COMMENT 'host id coresponding to the external pxe device', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
3612020-02-12 12:14:59,332 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`ucs_blade` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `ucs_manager_id` bigint unsigned NOT NULL, `host_id` bigint unsigned DEFAULT NULL, `dn` varchar(512) NOT NULL, `profile_dn` varchar(512) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
3622020-02-12 12:14:59,439 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`ucs_manager` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `zone_id` bigint unsigned NOT NULL, `name` varchar(128) DEFAULT NULL, `url` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
3632020-02-12 12:14:59,548 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) SET foreign_key_checks = 1
3642020-02-12 12:14:59,549 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`configuration` SET value='KVM,XenServer,VMware,Ovm' WHERE name='hypervisor.list'
3652020-02-12 12:14:59,551 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'concurrent.snapshots.threshold.perhost' , NULL, 'Limit number of snapshots that can be handled concurrently; default is NULL - unlimited.')
3662020-02-12 12:14:59,552 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network', 'DEFAULT', 'management-server', 'network.ipv6.search.retry.max' , 10000, 'The maximum number of retrying times to search for an available IPv6 address in the table')
3672020-02-12 12:14:59,553 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Usage', 'DEFAULT', 'management-server', 'traffic.sentinel.exclude.zones' , '', 'Traffic going into specified list of zones is not metered')
3682020-02-12 12:14:59,555 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Usage', 'DEFAULT', 'management-server', 'traffic.sentinel.include.zones' , 'EXTERNAL', 'Traffic going into specified list of zones is metered. For metering all traffic leave this parameter empty')
3692020-02-12 12:14:59,556 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (163, UUID(), 10, 'Ubuntu 12.04 (32-bit)')
3702020-02-12 12:14:59,557 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (164, UUID(), 10, 'Ubuntu 12.04 (64-bit)')
3712020-02-12 12:14:59,558 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP TABLE IF EXISTS `cloud`.`netscaler_pod_ref`
3722020-02-12 12:14:59,613 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`netscaler_pod_ref` ( `id` bigint unsigned NOT NULL auto_increment COMMENT 'id', `external_load_balancer_device_id` bigint unsigned NOT NULL COMMENT 'id of external load balancer device', `pod_id` bigint unsigned NOT NULL COMMENT 'pod id', PRIMARY KEY (`id`), CONSTRAINT `fk_ns_pod_ref__pod_id` FOREIGN KEY (`pod_id`) REFERENCES `cloud`.`host_pod_ref`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_ns_pod_ref__device_id` FOREIGN KEY (`external_load_balancer_device_id`) REFERENCES `external_load_balancer_devices`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
3732020-02-12 12:14:59,733 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'eip.use.multiple.netscalers' , 'false', 'Should be set to true, if there will be multiple NetScaler devices providing EIP service in a zone')
3742020-02-12 12:14:59,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`configuration` set category='Advanced' where category='Advanced '
3752020-02-12 12:14:59,736 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`configuration` set category='Hidden' where category='Hidden '
3762020-02-12 12:14:59,752 DEBUG [c.c.u.d.Upgrade40to41] (main:null) (logid:) Updating region table with Id: 1
3772020-02-12 12:14:59,753 DEBUG [c.c.u.d.Upgrade40to41] (main:null) (logid:) Updating firewall Ingress rule traffic type: com.mysql.cj.jdbc.ClientPreparedStatement: update `cloud`.`firewall_rules` set traffic_type='Ingress' where purpose='Firewall' and ip_address_id is not null and traffic_type is null
3782020-02-12 12:14:59,829 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:) Rolling back the transaction: Time = 17926 Name = Upgrade; called by -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-TransactionLegacy.close:657-TransactionContextInterceptor.invoke:36-ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.invoke:92-ReflectiveMethodInvocation.proceed:185-JdkDynamicAopProxy.invoke:212-$Proxy30.persist:-1-DatabaseUpgradeChecker.upgrade:259-DatabaseUpgradeChecker.check:336-CloudStackExtendedLifeCycle.checkIntegrity:65
3792020-02-12 12:14:59,864 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to upgrade the database
380com.cloud.utils.exception.CloudRuntimeException: Problem with getting the ec attribute
381 at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1454)
382 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
383 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
384 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
385 at java.lang.reflect.Method.invoke(Method.java:498)
386 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338)
387 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
388 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
389 at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)
390 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
391 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
392 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
393 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
394 at com.sun.proxy.$Proxy30.persist(Unknown Source)
395 at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:259)
396 at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336)
397 at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
398 at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55)
399 at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:183)
400 at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52)
401 at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358)
402 at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159)
403 at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
404 at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884)
405 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
406 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)
407 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
408 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
409 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
410 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
411 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)
412 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
413 at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
414 at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
415 at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
416 at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
417 at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
418 at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890)
419 at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532)
420 at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853)
421 at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344)
422 at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515)
423 at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477)
424 at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785)
425 at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261)
426 at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545)
427 at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
428 at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
429 at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
430 at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
431 at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273)
432 at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
433 at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
434 at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115)
435 at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
436 at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
437 at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
438 at org.eclipse.jetty.server.Server.start(Server.java:418)
439 at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
440 at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
441 at org.eclipse.jetty.server.Server.doStart(Server.java:385)
442 at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
443 at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:186)
444 at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:103)
445Caused by: java.lang.IllegalArgumentException: Can not set long field com.cloud.upgrade.dao.VersionVO.id to java.math.BigInteger
446 at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
447 at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
448 at sun.reflect.UnsafeLongFieldAccessorImpl.set(UnsafeLongFieldAccessorImpl.java:102)
449 ... 65 more
4502020-02-12 12:14:59,888 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
4512020-02-12 12:14:59,889 WARN [o.e.j.w.WebAppContext] (main:null) (logid:) Failed startup of context o.e.j.w.WebAppContext@6e38921c{/client,file:///usr/share/cloudstack-management/webapp/,UNAVAILABLE}{/usr/share/cloudstack-management/webapp}
452org.springframework.context.ApplicationContextException: Failed to start bean 'cloudStackLifeCycle'; nested exception is com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
453 at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:186)
454 at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52)
455 at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358)
456 at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159)
457 at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
458 at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884)
459 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
460 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)
461 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
462 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
463 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
464 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
465 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)
466 at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
467 at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
468 at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
469 at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
470 at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
471 at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
472 at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890)
473 at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532)
474 at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853)
475 at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344)
476 at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515)
477 at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477)
478 at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785)
479 at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261)
480 at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545)
481 at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
482 at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
483 at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
484 at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
485 at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273)
486 at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
487 at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
488 at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115)
489 at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
490 at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
491 at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
492 at org.eclipse.jetty.server.Server.start(Server.java:418)
493 at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
494 at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
495 at org.eclipse.jetty.server.Server.doStart(Server.java:385)
496 at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
497 at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:186)
498 at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:103)
499Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
500 at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:265)
501 at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336)
502 at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
503 ... 47 more
504Caused by: com.cloud.utils.exception.CloudRuntimeException: Problem with getting the ec attribute
505 at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1454)
506 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
507 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
508 ... 61 more
509Caused by: java.lang.IllegalArgumentException: Can not set long field com.cloud.upgrade.dao.VersionVO.id to java.math.BigInteger
510 at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
511 at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
512 at sun.reflect.UnsafeLongFieldAccessorImpl.set(UnsafeLongFieldAccessorImpl.java:102)
513 ... 65 more
5142020-02-12 12:14:59,891 INFO [o.e.j.s.h.ContextHandler] (main:null) (logid:) Started o.e.j.s.h.MovedContextHandler@6e2c9341{/,null,AVAILABLE}
5152020-02-12 12:15:00,040 INFO [o.e.j.s.AbstractConnector] (main:null) (logid:) Started ServerConnector@51e2adc7{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
5162020-02-12 12:15:00,040 INFO [o.e.j.s.Server] (main:null) (logid:) Started @39164ms
5172020-02-12 12:43:16,272 INFO [o.e.j.s.AbstractConnector] (Thread-1:null) (logid:) Stopped ServerConnector@51e2adc7{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
5182020-02-12 12:43:16,282 INFO [o.e.j.s.session] (Thread-1:null) (logid:) Stopped scavenging
5192020-02-12 12:43:16,282 INFO [o.e.j.s.h.ContextHandler] (Thread-1:null) (logid:) Stopped o.e.j.s.h.MovedContextHandler@6e2c9341{/,null,UNAVAILABLE}
5202020-02-12 12:43:16,285 INFO [o.e.j.s.h.ContextHandler] (Thread-1:null) (logid:) Stopped o.e.j.w.WebAppContext@6e38921c{/client,null,UNAVAILABLE}{/usr/share/cloudstack-management/webapp}