Please check my reply yo Jevgeni on users@ email thread, from 1-2 days ago.
Thx On Mon, 30 Sep 2019, 18:54 Fariborz Navidan, <mdvlinqu...@gmail.com> wrote: > Hello, > > I've just followed upgrade instructions from 4.12 to 4.13 in documentation. > DB update fails with duplicate entry error. Please see log entries bellow: > > [root@fr-kvm1 scripts]# cat > /var/log/cloudstack/management/management-server.log > > 2019-09-30 18:38:09,244 INFO [o.a.c.ServerDaemon] (main:null) (logid:) > Server configuration file found: > /etc/cloudstack/management/server.properties > 2019-09-30 18:38:09,247 INFO [o.a.c.ServerDaemon] (main:null) (logid:) > Initializing server daemon on null, with http.enable=true, http.port=8080, > https.enable=false, https.port=8443, context.path=/client > 2019-09-30 18:38:09,252 INFO [o.e.j.u.log] (main:null) (logid:) Logging > initialized @315ms to org.eclipse.jetty.util.log.Slf4jLog > 2019-09-30 18:38:09,338 INFO [o.e.j.s.Server] (main:null) (logid:) > jetty-9.4.z-SNAPSHOT, build timestamp: 2017-11-21T22:27:37+01:00, git hash: > 82b8fb23f757335bb3329d540ce37a2a2615f0a8 > 2019-09-30 18:38:09,355 INFO [o.e.j.s.AbstractNCSARequestLog] (main:null) > (logid:) Opened /var/log/cloudstack/management/access.log > 2019-09-30 18:38:09,404 INFO [o.e.j.w.StandardDescriptorProcessor] > (main:null) (logid:) NO JSP Support for /client, did not find > org.eclipse.jetty.jsp.JettyJspServlet > 2019-09-30 18:38:09,419 INFO [o.e.j.s.session] (main:null) (logid:) > DefaultSessionIdManager workerName=node0 > 2019-09-30 18:38:09,419 INFO [o.e.j.s.session] (main:null) (logid:) No > SessionScavenger set, using defaults > 2019-09-30 18:38:09,420 INFO [o.e.j.s.session] (main:null) (logid:) > Scavenging every 600000ms > 2019-09-30 18:38:18,265 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [bootstrap] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context.xml] > 2019-09-30 18:38:18,265 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [bootstrap] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml] > 2019-09-30 18:38:18,350 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] > (main:null) (logid:) Encryption Type: file > 2019-09-30 18:38:18,369 INFO [c.c.u.LogUtils] (main:null) (logid:) log4j > configuration found at /etc/cloudstack/management/log4j-cloud.xml > 2019-09-30 18:38:18,378 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loaded module context [bootstrap] in 113 ms > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: bootstrap > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: system > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: core > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: allocator > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: host-allocator-random > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: planner > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: api-planner > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: baremetal-planner > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: explicit-dedication > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: host-affinity > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: host-anti-affinity > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: implicit-dedication > 2019-09-30 18:38:18,379 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-planner > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: skip-heurestics > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: user-concentrated-pod > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-allocator > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: api > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: acl-dynamic-role-based > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: acl-static-role-based > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: cloudian > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ldap > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: md5 > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: metrics > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: pbkdf2 > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: plaintext > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: prometheus > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: quota > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: rate-limit > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: saml2 > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-api > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: sha256salted > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: solidfire-intg-test > 2019-09-30 18:38:18,380 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: vmware-sioc > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: api-config > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: backend > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ca > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: root-ca > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: baremetal-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: hyperv-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: kvm-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ovm-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ovm3-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: > server-alert-adapter-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-fencer > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-investigator > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: vmware-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: xenserver-compute > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: network > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: baremetal-network > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: bigswitch > 2019-09-30 18:38:18,381 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: cisco-vnmc > 2019-09-30 18:38:18,383 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: contrail > 2019-09-30 18:38:18,383 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: elb > 2019-09-30 18:38:18,383 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: f5 > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: globodns > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: netscaler > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: nvp > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: opendaylight > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ovs > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: paloalto > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-network > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: srx > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ssp > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: vcs > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: vmware-network > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: vxlan > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-alert-adapter-backend > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: baremetal-storage > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: > server-alert-adapter-storage > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-storage > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-template-adapter > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage-allocator > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage-image-default > 2019-09-30 18:38:18,384 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage-image-s3 > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage-image-swift > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage-volume-cloudbyte > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage-volume-datera > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage-volume-default > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: storage-volume-solidfire > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: vmware-storage > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: baremetal-discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: hyperv-discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ovm-discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ovm3-discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: secondary-storage-discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: server-discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: vmware-discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: xenserver-discoverer > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: outofbandmanagement > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: ipmitool > 2019-09-30 18:38:18,385 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Module Hierarchy: nested-cloudstack > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-config-system-context.xml] > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-server-system-context.xml] > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-core-system-context.xml] > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-db-system-context.xml] > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-engine-schema-system-checkers-context.xml] > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-config-system-context-inheritable.xml] > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-core-system-context-inheritable.xml] > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-contrail-system-context-inheritable.xml] > 2019-09-30 18:38:18,386 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:null) (logid:) Loading module context [system] from URL > > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml] > 2019-09-30 18:38:18,852 INFO [c.c.u.d.T.Transaction] (main:null) (logid:) > Is Data Base High Availiability enabled? Ans : false > 2019-09-30 18:38:18,880 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) > Successfully loaded DB driver com.mysql.jdbc.Driver > 2019-09-30 18:38:18,892 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) > DB driver com.mysql.jdbc.Driver was already loaded. > 2019-09-30 18:38:18,892 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) > DB driver com.mysql.jdbc.Driver was already loaded. > 2019-09-30 18:38:19,062 DEBUG [c.c.u.d.ConnectionConcierge] (main:null) > (logid:) Registering a database connection for LockMaster1 > 2019-09-30 18:38:19,062 INFO [c.c.u.d.Merovingian2] (main:null) (logid:) > Cleaning up locks for 279278805451094 > 2019-09-30 18:38:19,069 INFO [c.c.u.d.Merovingian2] (main:null) (logid:) > Released 0 locks for 279278805451094 > 2019-09-30 18:38:19,224 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] > (main:null) (logid:) Running system integrity checker > com.cloud.upgrade.DatabaseUpgradeChecker@2d140a7 > 2019-09-30 18:38:19,224 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Grabbing lock to check for database upgrade. > 2019-09-30 18:38:19,245 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) (logid:) > Checking to see if the database is at a version before it was the version > table is created > 2019-09-30 18:38:19,257 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) DB version = 4.12.0.0 Code Version = 4.13.0.0 > 2019-09-30 18:38:19,257 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Database upgrade must be performed from 4.12.0.0 to 4.13.0.0 > 2019-09-30 18:38:19,264 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Running upgrade Upgrade41200to41300 to upgrade from > 4.12.0.0-4.13.0.0 to 4.13.0.0 > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Licensed to the Apache Software Foundation (ASF) under one > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- or more contributor license agreements. See the NOTICE file > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- distributed with this work for additional information > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- regarding copyright ownership. The ASF licenses this file > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- to you under the Apache License, Version 2.0 (the > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- "License"); you may not use this file except in compliance > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- with the License. You may obtain a copy of the License at > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- http://www.apache.org/licenses/LICENSE-2.0 > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Unless required by applicable law or agreed to in writing, > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- software distributed under the License is distributed on an > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- KIND, either express or implied. See the License for the > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- specific language governing permissions and limitations > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- under the License. > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > --; > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Schema upgrade from 4.12.0.0 to 4.13.0.0 > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > --; > 2019-09-30 18:38:19,266 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Add XenServer 7.1.2, 7.6 and 8.0 hypervisor capabilities > 2019-09-30 18:38:19,267 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, > hypervisor_version, max_guests_limit, max_data_volumes_limit, > max_hosts_per_cluster, storage_motion_supported) values (UUID(), > 'XenServer', '7.6.0', 1000, 253, 64, 1) > 2019-09-30 18:38:19,267 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, > hypervisor_version, max_guests_limit, max_data_volumes_limit, > max_hosts_per_cluster, storage_motion_supported) values (UUID(), > 'XenServer', '8.0.0', 1000, 253, 64, 1) > 2019-09-30 18:38:19,267 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, > hypervisor_version, max_guests_limit, max_data_volumes_limit, > max_hosts_per_cluster, storage_motion_supported) values (UUID(), > 'XenServer', '7.1.1', 1000, 253, 64, 1) > 2019-09-30 18:38:19,267 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, > hypervisor_version, max_guests_limit, max_data_volumes_limit, > max_hosts_per_cluster, storage_motion_supported) values (UUID(), > 'XenServer', '7.1.2', 1000, 253, 64, 1) > 2019-09-30 18:38:19,268 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Add VMware 6.7 hypervisor capabilities > 2019-09-30 18:38:19,268 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, > hypervisor_version, max_guests_limit, security_group_enabled, > max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, > vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7', '1024', '0', '59', > '64', '1', '1') > 2019-09-30 18:38:19,268 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, > hypervisor_version, max_guests_limit, security_group_enabled, > max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, > vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7.1', '1024', '0', '59', > '64', '1', '1') > 2019-09-30 18:38:19,268 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, > hypervisor_version, max_guests_limit, security_group_enabled, > max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, > vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7.2', '1024', '0', '59', > '64', '1', '1') > 2019-09-30 18:38:19,268 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid,hypervisor_type, > hypervisor_version, max_guests_limit, security_group_enabled, > max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, > vm_snapshot_enabled) VALUES (UUID(), 'VMware', '6.7.3', '1024', '0', '59', > '64', '1', '1') > 2019-09-30 18:38:19,269 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Update VMware 6.x hypervisor capabilities > 2019-09-30 18:38:19,269 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > UPDATE `cloud`.`hypervisor_capabilities` SET max_guests_limit='1024', > max_data_volumes_limit='59', max_hosts_per_cluster='64' WHERE > (hypervisor_type='VMware' AND hypervisor_version='6.0' ) > 2019-09-30 18:38:19,269 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > UPDATE `cloud`.`hypervisor_capabilities` SET max_guests_limit='1024', > max_data_volumes_limit='59', max_hosts_per_cluster='64' WHERE > (hypervisor_type='VMware' AND hypervisor_version='6.5' ) > 2019-09-30 18:38:19,269 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Add new OS versions > 2019-09-30 18:38:19,269 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > INSERT INTO cloud.guest_os (id, uuid, category_id, display_name, created, > is_user_defined) VALUES ('277', UUID(), '1', 'Ubuntu 17.04', now(), '0') > 2019-09-30 18:38:19,270 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > Error executing: INSERT INTO cloud.guest_os (id, uuid, category_id, > display_name, created, is_user_defined) VALUES ('277', UUID(), '1', 'Ubuntu > 17.04', now(), '0') > 2019-09-30 18:38:19,271 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Duplicate entry '277' for key 'PRIMARY' > 2019-09-30 18:38:19,272 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Unable to execute upgrade script > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Duplicate entry '277' for key 'PRIMARY' > 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:197) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:252) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336) > at > > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65) > at > > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55) > at > > org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:183) > at > > org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52) > at > > org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358) > at > > org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159) > at > > org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123) > at > > org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884) > at > > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79) > at > > org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37) > at > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71) > at > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58) > at > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62) > at > > org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52) > at > > org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890) > at > > org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532) > at > > org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853) > at > > org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344) > at > org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515) > at > > org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477) > at > > org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785) > at > > org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261) > at > org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) > at > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) > at > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113) > at > > org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273) > at > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115) > at > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113) > at > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133) > at org.eclipse.jetty.server.Server.start(Server.java:418) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) > at > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113) > at org.eclipse.jetty.server.Server.doStart(Server.java:385) > at > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:186) > at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:103) > 2019-09-30 18:38:19,273 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:203) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:252) > 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: > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Duplicate entry '277' for key 'PRIMARY' > 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:197) > ... 50 more > 2019-09-30 18:38:19,274 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:) > Rolling back the transaction: Time = 10 Name = Upgrade; called by > > -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-TransactionLegacy.close:657-DatabaseUpgradeChecker.upgrade:267-DatabaseUpgradeChecker.check:336-CloudStackExtendedLifeCycle.checkIntegrity:65-CloudStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:183-DefaultLifecycleProcessor.access$200:52-DefaultLifecycleProcessor$LifecycleGroup.start:358-DefaultLifecycleProcessor.startBeans:159-DefaultLifecycleProcessor.onRefresh:123 > 2019-09-30 18:38:19,275 WARN [o.a.c.s.m.c.ResourceApplicationContext] > (main:null) (logid:) Exception encountered during context initialization - > cancelling refresh attempt: > org.springframework.context.ApplicationContextException: Failed to start > bean 'cloudStackLifeCycle'; nested exception is > com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the > database > 2019-09-30 18:38:19,276 WARN [o.e.j.w.WebAppContext] (main:null) (logid:) > Failed startup of context o.e.j.w.WebAppContext@646be2c3 > > {/client,file:///usr/share/cloudstack-management/webapp/,UNAVAILABLE}{/usr/share/cloudstack-management/webapp} > org.springframework.context.ApplicationContextException: Failed to start > bean 'cloudStackLifeCycle'; nested exception is > com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the > database > at > > org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:186) > at > > org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52) > at > > org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358) > at > > org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159) > at > > org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123) > at > > org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884) > at > > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117) > at > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79) > at > > org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37) > at > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71) > at > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58) > at > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62) > at > > org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52) > at > > org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890) > at > > org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532) > at > > org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853) > at > > org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344) > at > org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515) > at > > org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477) > at > > org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785) > at > > org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261) > at > org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) > at > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) > at > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113) > at > > org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273) > at > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115) > at > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113) > at > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133) > at org.eclipse.jetty.server.Server.start(Server.java:418) > at > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) > at > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113) > at org.eclipse.jetty.server.Server.doStart(Server.java:385) > at > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:186) > at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:103) > Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to > upgrade the database > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:265) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336) > at > > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65) > ... 47 more > Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to > execute upgrade script > at > > com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:203) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:252) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336) > ... 48 more > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Duplicate entry '277' for key 'PRIMARY' > 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:197) > ... 50 more > 2019-09-30 18:38:19,277 INFO [o.e.j.s.h.ContextHandler] (main:null) > (logid:) Started o.e.j.s.h.MovedContextHandler@6e2c9341{/,null,AVAILABLE} > 2019-09-30 18:38:19,295 INFO [o.e.j.s.AbstractConnector] (main:null) > (logid:) Started ServerConnector@51e2adc7{HTTP/1.1,[http/1.1]}{ > 0.0.0.0:8080} > 2019-09-30 18:38:19,296 INFO [o.e.j.s.Server] (main:null) (logid:) Started > @10359ms > [root@fr-kvm1 scripts]# >
