cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Levitskiy <serg...@hotmail.com>
Subject Re: Upgrading from 4.9.3 to 4.11
Date Sat, 03 Nov 2018 14:57:21 GMT
Basically version of Cloudstack you are running has already some pieces of the code that is
part of the upgrade from 4.9.3 to 4.10. This could have happened if you deployed a fix on
the top of 4.9.3 or if a PR was backported to 4.9.3 codebase after you install. You still
can perform successful upgrade with some manual effort:
1. Make a copy of you CS DB.
2. Obtain the file schema-4930to41000.sql. https://github.com/apache/cloudstack/blob/1d05fead49f5c856257a741b07122f5633d2e359/engine/schema/src/main/resources/META-INF/db/schema-4930to41000.sql
3. Execute it on the copy of your DB. It will fail initially with the same error as in yourACS
log
	Error executing: ALTER TABLE `cloud`.`domain_router` ADD COLUMN update_state varchar(64)
DEFAULT NULL
   		 2018-11-02 08:28:48,787 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
    		com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'update_state'
4. Comment line 22 in SQL file. Restore your DB copy
5. Continue steps 2-4 until you have successful processing of SQL file against a copy of your
DB
(6 optional) Likely this will be enough to unblock your upgrade but if you want to ensure
throughout upgrade you might need to repeat the same with 4.11 and 4.11.1 upgrade files. You
will need to do a sequence 4.9.3->4.10->4.11->4.11.1 in each iteration.
	https://github.com/apache/cloudstack/blob/1d05fead49f5c856257a741b07122f5633d2e359/engine/schema/src/main/resources/META-INF/db/schema-41000to41100.sql
	https://github.com/apache/cloudstack/blob/1d05fead49f5c856257a741b07122f5633d2e359/engine/schema/src/main/resources/META-INF/db/schema-41100to41110.sql

7. Now you have adjusted DB upgrade file(s). Next step as to re-try your upgrade. After you
update packages on the first management server but before your re-start the cloudstack-managment
service you need to replace DB upgrade file in /usr/share/cloudstack-management/setup/db

Good luck.

Thanks,
Sergey


    
´╗┐On 11/2/18, 9:19 AM, "McClune, James" <mcclunej@norwalktruckers.net> wrote:

    Hello CloudStack Community,
    
    I was wondering if you could help me a little further. I referenced the
    documentation Rohit sent:
    
    http://docs.cloudstack.apache.org/en/4.11.1.0/upgrading/upgrade/upgrade-4.9.html
    
    I backed up my cloud database and followed the instructions verbatim. My
    CloudStack management server is running on Ubuntu 14.04. When I upgrade my
    packages to 4.11, the management doesn't start correctly (/client 404
    error). I was getting errors along the lines of "Cannot connect to
    database". I checked my db.properties file and made sure the
    cluster.node.ip was set correctly, as well as database authentication (e.g.
    MySQL username/password). I ran the Java command to encrypt my database
    password, as described here:
    
    http://docs.cloudstack.apache.org/projects/cloudstack-administration/en/4.11/management.html#changing-the-database-password
    
    I added the password to db.properties, hoping that my authentication was
    somehow screwed up. I still got the errors. I didn't catch those errors,
    but I'll retry and send them to you.
    
    I also tried doing a manual upgrade and re-importing the database schema.
    However, the 4.9.3 schema is different from 4.11 (as expected), so I
    started to get errors:
    
    root@cloudstack:~# tail -f
    /var/log/cloudstack/management/management-server.log
    2018-11-01 21:04:50,909 INFO  [o.e.j.s.h.ContextHandler] (main:null)
    (logid:) Started o.e.j.s.h.MovedContextHandler@5cdd8682{/,null,AVAILABLE}
    2018-11-02 08:28:23,152 INFO  [o.a.c.ServerDaemon] (main:null) (logid:)
    Server configuration file found:
    /etc/cloudstack/management/server.properties
    2018-11-02 08:28:23,160 INFO  [o.a.c.ServerDaemon] (main:null) (logid:)
    Initializing server daemon on :::8080, with https.enabled=false,
    https.port=8443, context.path=/client
    2018-11-02 08:28:23,172 INFO  [o.e.j.u.log] (main:null) (logid:) Logging
    initialized @853ms to org.eclipse.jetty.util.log.Slf4jLog
    2018-11-02 08:28:23,406 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
    2018-11-02 08:28:23,454 INFO  [o.e.j.s.AbstractNCSARequestLog] (main:null)
    (logid:) Opened /var/log/cloudstack/management/access.log
    2018-11-02 08:28:23,586 INFO  [o.e.j.w.StandardDescriptorProcessor]
    (main:null) (logid:) NO JSP Support for /client, did not find
    org.eclipse.jetty.jsp.JettyJspServlet
    2018-11-02 08:28:23,619 INFO  [o.e.j.s.session] (main:null) (logid:)
    DefaultSessionIdManager workerName=node0
    2018-11-02 08:28:23,619 INFO  [o.e.j.s.session] (main:null) (logid:) No
    SessionScavenger set, using defaults
    2018-11-02 08:28:23,621 INFO  [o.e.j.s.session] (main:null) (logid:)
    Scavenging every 660000ms
    2018-11-02 08:28:45,916 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.11.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context.xml]
    2018-11-02 08:28:45,917 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.11.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
    2018-11-02 08:28:46,132 DEBUG [c.c.u.c.EncryptionSecretKeyChecker]
    (main:null) (logid:) Encryption Type: file
    2018-11-02 08:28:46,186 INFO  [c.c.u.LogUtils] (main:null) (logid:) log4j
    configuration found at /etc/cloudstack/management/log4j-cloud.xml
    2018-11-02 08:28:46,233 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Loaded module context [bootstrap] in 317 ms
    2018-11-02 08:28:46,236 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy: bootstrap
    2018-11-02 08:28:46,236 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:   system
    2018-11-02 08:28:46,237 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:     core
    2018-11-02 08:28:46,237 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:       allocator
    2018-11-02 08:28:46,237 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         host-allocator-random
    2018-11-02 08:28:46,237 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         planner
    2018-11-02 08:28:46,238 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           api-planner
    2018-11-02 08:28:46,238 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           baremetal-planner
    2018-11-02 08:28:46,238 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           explicit-dedication
    2018-11-02 08:28:46,238 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           host-anti-affinity
    2018-11-02 08:28:46,239 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           implicit-dedication
    2018-11-02 08:28:46,239 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           server-planner
    2018-11-02 08:28:46,239 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           skip-heurestics
    2018-11-02 08:28:46,240 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           user-concentrated-pod
    2018-11-02 08:28:46,240 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         server-allocator
    2018-11-02 08:28:46,240 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:       api
    2018-11-02 08:28:46,240 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         acl-dynamic-role-based
    2018-11-02 08:28:46,241 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         acl-static-role-based
    2018-11-02 08:28:46,241 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         cloudian
    2018-11-02 08:28:46,241 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         ldap
    2018-11-02 08:28:46,242 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         md5
    2018-11-02 08:28:46,243 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         metrics
    2018-11-02 08:28:46,243 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         pbkdf2
    2018-11-02 08:28:46,243 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         plaintext
    2018-11-02 08:28:46,244 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         prometheus
    2018-11-02 08:28:46,244 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         quota
    2018-11-02 08:28:46,244 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         rate-limit
    2018-11-02 08:28:46,244 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         saml2
    2018-11-02 08:28:46,244 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         server-api
    2018-11-02 08:28:46,245 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         sha256salted
    2018-11-02 08:28:46,245 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         solidfire-intg-test
    2018-11-02 08:28:46,245 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:       api-config
    2018-11-02 08:28:46,245 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:       backend
    2018-11-02 08:28:46,246 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         ca
    2018-11-02 08:28:46,246 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           root-ca
    2018-11-02 08:28:46,246 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         compute
    2018-11-02 08:28:46,247 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           baremetal-compute
    2018-11-02 08:28:46,247 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           hyperv-compute
    2018-11-02 08:28:46,247 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           kvm-compute
    2018-11-02 08:28:46,247 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           ovm-compute
    2018-11-02 08:28:46,248 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           ovm3-compute
    2018-11-02 08:28:46,248 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:
     server-alert-adapter-compute
    2018-11-02 08:28:46,248 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           server-compute
    2018-11-02 08:28:46,248 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           server-fencer
    2018-11-02 08:28:46,248 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           server-investigator
    2018-11-02 08:28:46,249 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           xenserver-compute
    2018-11-02 08:28:46,249 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         direct-download
    2018-11-02 08:28:46,249 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         network
    2018-11-02 08:28:46,249 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           baremetal-network
    2018-11-02 08:28:46,250 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           bigswitch
    2018-11-02 08:28:46,250 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           contrail
    2018-11-02 08:28:46,252 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           elb
    2018-11-02 08:28:46,252 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           globodns
    2018-11-02 08:28:46,252 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           netscaler
    2018-11-02 08:28:46,253 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           nvp
    2018-11-02 08:28:46,253 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           opendaylight
    2018-11-02 08:28:46,253 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           ovs
    2018-11-02 08:28:46,253 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           paloalto
    2018-11-02 08:28:46,253 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           server-network
    2018-11-02 08:28:46,254 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           ssp
    2018-11-02 08:28:46,254 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           vcs
    2018-11-02 08:28:46,254 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           vsp
    2018-11-02 08:28:46,254 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           vxlan
    2018-11-02 08:28:46,254 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         server-alert-adapter-backend
    2018-11-02 08:28:46,255 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         storage
    2018-11-02 08:28:46,255 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           baremetal-storage
    2018-11-02 08:28:46,255 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:
     server-alert-adapter-storage
    2018-11-02 08:28:46,255 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           server-storage
    2018-11-02 08:28:46,256 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           server-template-adapter
    2018-11-02 08:28:46,256 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           storage-allocator
    2018-11-02 08:28:46,256 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           storage-image-default
    2018-11-02 08:28:46,256 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           storage-image-s3
    2018-11-02 08:28:46,257 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           storage-image-swift
    2018-11-02 08:28:46,257 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           storage-volume-cloudbyte
    2018-11-02 08:28:46,257 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           storage-volume-default
    2018-11-02 08:28:46,257 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:           storage-volume-solidfire
    2018-11-02 08:28:46,257 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:       discoverer
    2018-11-02 08:28:46,258 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         baremetal-discoverer
    2018-11-02 08:28:46,258 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         hyperv-discoverer
    2018-11-02 08:28:46,258 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         ovm-discoverer
    2018-11-02 08:28:46,258 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         ovm3-discoverer
    2018-11-02 08:28:46,258 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         secondary-storage-discoverer
    2018-11-02 08:28:46,259 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         server-discoverer
    2018-11-02 08:28:46,259 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         xenserver-discoverer
    2018-11-02 08:28:46,259 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:       outofbandmanagement
    2018-11-02 08:28:46,259 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         ipmitool
    2018-11-02 08:28:46,259 INFO  [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
    (main:null) (logid:) Module Hierarchy:         nested-cloudstack
    2018-11-02 08:28:46,261 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.11.0.0.jar!/META-INF/cloudstack/system/spring-framework-config-system-context.xml]
    2018-11-02 08:28:46,261 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.11.0.0.jar!/META-INF/cloudstack/system/spring-server-system-context.xml]
    2018-11-02 08:28:46,261 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.11.0.0.jar!/META-INF/cloudstack/system/spring-core-system-context.xml]
    2018-11-02 08:28:46,262 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.11.0.0.jar!/META-INF/cloudstack/system/spring-framework-db-system-context.xml]
    2018-11-02 08:28:46,262 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.11.0.0.jar!/META-INF/cloudstack/system/spring-engine-schema-system-checkers-context.xml]
    2018-11-02 08:28:46,262 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.11.0.0.jar!/META-INF/cloudstack/system/spring-framework-config-system-context-inheritable.xml]
    2018-11-02 08:28:46,263 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.11.0.0.jar!/META-INF/cloudstack/system/spring-core-system-context-inheritable.xml]
    2018-11-02 08:28:46,263 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.11.0.0.jar!/META-INF/cloudstack/system/spring-contrail-system-context-inheritable.xml]
    2018-11-02 08:28:46,263 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.11.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
    2018-11-02 08:28:47,394 INFO  [c.c.u.d.T.Transaction] (main:null) (logid:)
    Is Data Base High Availiability enabled? Ans : false
    2018-11-02 08:28:47,806 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:)
    Successfully loaded DB driver com.mysql.jdbc.Driver
    2018-11-02 08:28:47,815 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:)
    DB driver com.mysql.jdbc.Driver was already loaded.
    2018-11-02 08:28:47,816 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:)
    DB driver com.mysql.jdbc.Driver was already loaded.
    2018-11-02 08:28:48,190 DEBUG [c.c.u.d.ConnectionConcierge] (main:null)
    (logid:) Registering a database connection for LockMaster1
    2018-11-02 08:28:48,192 INFO  [c.c.u.d.Merovingian2] (main:null) (logid:)
    Cleaning up locks for 90520739700260
    2018-11-02 08:28:48,212 INFO  [c.c.u.d.Merovingian2] (main:null) (logid:)
    Released 0 locks for 90520739700260
    2018-11-02 08:28:48,632 INFO  [o.a.c.s.l.CloudStackExtendedLifeCycle]
    (main:null) (logid:) Running system integrity checker
    com.cloud.upgrade.DatabaseUpgradeChecker@988246e
    2018-11-02 08:28:48,635 INFO  [c.c.u.DatabaseUpgradeChecker] (main:null)
    (logid:) Grabbing lock to check for database upgrade.
    2018-11-02 08:28:48,728 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
    2018-11-02 08:28:48,773 INFO  [c.c.u.DatabaseUpgradeChecker] (main:null)
    (logid:) DB version = 4.9.3.0 Code Version = 4.11.0.0
    2018-11-02 08:28:48,774 INFO  [c.c.u.DatabaseUpgradeChecker] (main:null)
    (logid:) Database upgrade must be performed from 4.9.3.0 to 4.11.0.0
    2018-11-02 08:28:48,774 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null)
    (logid:) Running upgrade Upgrade4930to41000 to upgrade from
    4.9.3.0-4.10.0.0 to 4.10.0.0
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- Licensed to the Apache Software Foundation (ASF) under one
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- or more contributor license agreements.  See the NOTICE file
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- distributed with this work for additional information
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- regarding copyright ownership.  The ASF licenses this file
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- to you under the Apache License, Version 2.0 (the
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- "License"); you may not use this file except in compliance
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- with the License.  You may obtain a copy of the License at
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    --   http://www.apache.org/licenses/LICENSE-2.0
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
    2018-11-02 08:28:48,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- Unless required by applicable law or agreed to in writing,
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- software distributed under the License is distributed on an
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- KIND, either express or implied.  See the License for the
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- specific language governing permissions and limitations
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- under the License.
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    --;
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    -- Schema upgrade from 4.9.3.0 to 4.10.0.0;
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    --;
    2018-11-02 08:28:48,781 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
    ALTER TABLE `cloud`.`domain_router` ADD COLUMN  update_state varchar(64)
    DEFAULT NULL
    2018-11-02 08:28:48,784 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
    Error executing: ALTER TABLE `cloud`.`domain_router` ADD COLUMN
    update_state varchar(64) DEFAULT NULL
    2018-11-02 08:28:48,787 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column
    name 'update_state'
    2018-11-02 08:28:48,789 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
    (logid:) Unable to execute upgrade script
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column
    name 'update_state'
    at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
    at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:459)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:557)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:641)
    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:200)
    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.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:241)
    2018-11-02 08:28:48,795 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
    (logid:) Unable to upgrade the database
    com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
    script
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:465)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:557)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:641)
    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:200)
    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.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:241)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
    Duplicate column name 'update_state'
    at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
    at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:459)
    ... 54 more
    2018-11-02 08:28:48,798 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:)
    Rolling back the transaction: Time = 24 Name =  Upgrade; called by
    -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-TransactionLegacy.close:656-DatabaseUpgradeChecker.upgrade:572-DatabaseUpgradeChecker.check:641-CloudStackExtendedLifeCycle.checkIntegrity:65-CloudStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:183-DefaultLifecycleProcessor.access$200:52-DefaultLifecycleProcessor$LifecycleGroup.start:358-DefaultLifecycleProcessor.startBeans:159-DefaultLifecycleProcessor.onRefresh:123
    2018-11-02 08:28:48,804 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
    2018-11-02 08:28:48,806 WARN  [o.e.j.w.WebAppContext] (main:null) (logid:)
    Failed startup of context o.e.j.w.WebAppContext@6b1274d2
    {/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:200)
    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.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:241)
    Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to
    upgrade the database
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:570)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:641)
    at
    org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
    ... 51 more
    Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to
    execute upgrade script
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:465)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:557)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:641)
    ... 52 more
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
    Duplicate column name 'update_state'
    at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
    at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
    at
    com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:459)
    ... 54 more
    2018-11-02 08:28:48,812 INFO  [o.e.j.s.h.ContextHandler] (main:null)
    (logid:) Started o.e.j.s.h.MovedContextHandler@5cdd8682{/,null,AVAILABLE}
    
    Is there a script I can run to update my schema from 4.9.3 to 4.11?
    
    Any help is much appreciated! :)
    
    Best Regards,
    James
    

Mime
View raw message