cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrija Panic <andrija.pa...@gmail.com>
Subject Re: Management server setup issue
Date Sat, 18 Jan 2020 11:37:46 GMT
Cool to have the issue solved but sucks to see it in the first place (I
guess we will have to change the docs to perhaps instruct users to use Epel
repo for the same connector.

Re the failed start of mgmt - remove the databases completely and start
from scratch - never saw that issue so far (I expect when you first run the
cloudstack-setup-management it might have modified the DB, then again when
you run it for the second time it did it again, or something)

As for MySQL 5.7, there is a short caveat - you need to modify either
db.properties or the my.cnf file to make ACS work with MySQL 5.7 (5.6 is OK
by default):
https://blog.widodh.nl/2017/04/apache-cloudstack-and-mysql-5-7/

Cheers

On Sat, 18 Jan 2020 at 10:59, Robert Ward <rwward@gmail.com> wrote:

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


-- 

Andrija Panić

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message