API tools faq
paste
Guest User

Untitled

a guest
Feb 12th, 2020
344
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 127.12 KB | None | 0 0
raw download clone embed print report
  1. # cat /var/log/cloudstack/management/management-server.l
  2. 2020-02-12 12:14:21,710 INFO [o.a.c.ServerDaemon] (main:null) (logid:) Server configuration file found: /etc/cloudstack/management/server.properties
  3. 2020-02-12 12:14:21,722 INFO [o.a.c.ServerDaemon] (main:null) (logid:) Initializing server daemon on null, with http.enable=true, http.port=8080, https.enable=false, https.port=8443, context.path=/client
  4. 2020-02-12 12:14:21,744 INFO [o.e.j.u.log] (main:null) (logid:) Logging initialized @867ms to org.eclipse.jetty.util.log.Slf4jLog
  5. 2020-02-12 12:14:22,040 INFO [o.e.j.s.Server] (main:null) (logid:) jetty-9.4.z-SNAPSHOT, build timestamp: 2017-11-21T21:27:37Z, git hash: 82b8fb23f757335bb3329d540ce37a2a2615f0a8
  6. 2020-02-12 12:14:22,083 INFO [o.e.j.s.AbstractNCSARequestLog] (main:null) (logid:) Opened /var/log/cloudstack/management/access.log
  7. 2020-02-12 12:14:22,248 INFO [o.e.j.w.StandardDescriptorProcessor] (main:null) (logid:) NO JSP Support for /client, did not find org.eclipse.jetty.jsp.JettyJspServlet
  8. 2020-02-12 12:14:22,293 INFO [o.e.j.s.session] (main:null) (logid:) DefaultSessionIdManager workerName=node0
  9. 2020-02-12 12:14:22,293 INFO [o.e.j.s.session] (main:null) (logid:) No SessionScavenger set, using defaults
  10. 2020-02-12 12:14:22,305 INFO [o.e.j.s.session] (main:null) (logid:) Scavenging every 660000ms
  11. 2020-02-12 12:14:38,135 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [bootstrap] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context.xml]
  12. 2020-02-12 12:14:38,136 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [bootstrap] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
  13. 2020-02-12 12:14:38,542 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] (main:null) (logid:) Encryption Type: file
  14. 2020-02-12 12:14:38,635 INFO [c.c.u.LogUtils] (main:null) (logid:) log4j configuration found at /etc/cloudstack/management/log4j-cloud.xml
  15. 2020-02-12 12:14:38,670 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loaded module context [bootstrap] in 535 ms
  16. 2020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bootstrap
  17. 2020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: system
  18. 2020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: core
  19. 2020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: allocator
  20. 2020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-allocator-random
  21. 2020-02-12 12:14:38,671 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: planner
  22. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-planner
  23. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-planner
  24. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: explicit-dedication
  25. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-affinity
  26. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: host-anti-affinity
  27. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: implicit-dedication
  28. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-planner
  29. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: skip-heurestics
  30. 2020-02-12 12:14:38,672 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: user-concentrated-pod
  31. 2020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-allocator
  32. 2020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api
  33. 2020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-dynamic-role-based
  34. 2020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: acl-static-role-based
  35. 2020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cloudian
  36. 2020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ldap
  37. 2020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: md5
  38. 2020-02-12 12:14:38,673 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: metrics
  39. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: pbkdf2
  40. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: plaintext
  41. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: prometheus
  42. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: quota
  43. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: rate-limit
  44. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: saml2
  45. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-api
  46. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: sha256salted
  47. 2020-02-12 12:14:38,674 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: solidfire-intg-test
  48. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-sioc
  49. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: api-config
  50. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: backend
  51. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ca
  52. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: root-ca
  53. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: compute
  54. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-compute
  55. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-compute
  56. 2020-02-12 12:14:38,675 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: kvm-compute
  57. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-compute
  58. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-compute
  59. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-compute
  60. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-compute
  61. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-fencer
  62. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-investigator
  63. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-compute
  64. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-compute
  65. 2020-02-12 12:14:38,676 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: network
  66. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-network
  67. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: bigswitch
  68. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: cisco-vnmc
  69. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: contrail
  70. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: elb
  71. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: f5
  72. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: globodns
  73. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: netscaler
  74. 2020-02-12 12:14:38,677 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nvp
  75. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: opendaylight
  76. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovs
  77. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: paloalto
  78. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-network
  79. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: srx
  80. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ssp
  81. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vcs
  82. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-network
  83. 2020-02-12 12:14:38,678 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vxlan
  84. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-backend
  85. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage
  86. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-storage
  87. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-alert-adapter-storage
  88. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-storage
  89. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-template-adapter
  90. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-allocator
  91. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-default
  92. 2020-02-12 12:14:38,679 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-s3
  93. 2020-02-12 12:14:38,680 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-image-swift
  94. 2020-02-12 12:14:38,680 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-cloudbyte
  95. 2020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-datera
  96. 2020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-default
  97. 2020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: storage-volume-solidfire
  98. 2020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-storage
  99. 2020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: discoverer
  100. 2020-02-12 12:14:38,722 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: baremetal-discoverer
  101. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: hyperv-discoverer
  102. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm-discoverer
  103. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ovm3-discoverer
  104. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: secondary-storage-discoverer
  105. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: server-discoverer
  106. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: vmware-discoverer
  107. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: xenserver-discoverer
  108. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: outofbandmanagement
  109. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: ipmitool
  110. 2020-02-12 12:14:38,723 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Module Hierarchy: nested-cloudstack
  111. 2020-02-12 12:14:38,724 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-config-system-context.xml]
  112. 2020-02-12 12:14:38,725 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-server-system-context.xml]
  113. 2020-02-12 12:14:38,725 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-core-system-context.xml]
  114. 2020-02-12 12:14:38,725 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-db-system-context.xml]
  115. 2020-02-12 12:14:38,725 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-engine-schema-system-checkers-context.xml]
  116. 2020-02-12 12:14:38,725 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-framework-config-system-context-inheritable.xml]
  117. 2020-02-12 12:14:38,725 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-core-system-context-inheritable.xml]
  118. 2020-02-12 12:14:38,725 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/system/spring-contrail-system-context-inheritable.xml]
  119. 2020-02-12 12:14:38,725 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) (logid:) Loading module context [system] from URL [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.13.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml]
  120. 2020-02-12 12:14:40,616 INFO [c.c.u.d.T.Transaction] (main:null) (logid:) Is Data Base High Availiability enabled? Ans : false
  121. 2020-02-12 12:14:40,744 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) Successfully loaded DB driver com.mysql.jdbc.Driver
  122. 2020-02-12 12:14:40,770 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) DB driver com.mysql.jdbc.Driver was already loaded.
  123. 2020-02-12 12:14:40,771 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) DB driver com.mysql.jdbc.Driver was already loaded.
  124. 2020-02-12 12:14:41,238 DEBUG [c.c.u.d.ConnectionConcierge] (main:null) (logid:) Registering a database connection for LockMaster1
  125. 2020-02-12 12:14:41,239 INFO [c.c.u.d.Merovingian2] (main:null) (logid:) Cleaning up locks for 90520732983863
  126. 2020-02-12 12:14:41,242 INFO [c.c.u.d.Merovingian2] (main:null) (logid:) Released 0 locks for 90520732983863
  127. 2020-02-12 12:14:41,763 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Running system integrity checker com.cloud.upgrade.DatabaseUpgradeChecker@1813f3e9
  128. 2020-02-12 12:14:41,764 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Grabbing lock to check for database upgrade.
  129. 2020-02-12 12:14:41,841 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) (logid:) Checking to see if the database is at a version before it was the version table is created
  130. 2020-02-12 12:14:41,880 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) DB version = 4.0.0 Code Version = 4.13.0.0
  131. 2020-02-12 12:14:41,881 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Database upgrade must be performed from 4.0.0 to 4.13.0.0
  132. 2020-02-12 12:14:41,903 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Running upgrade Upgrade40to41 to upgrade from 4.0.0-4.1.0 to 4.1.0
  133. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Licensed to the Apache Software Foundation (ASF) under one
  134. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- or more contributor license agreements. See the NOTICE file
  135. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- distributed with this work for additional information
  136. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- regarding copyright ownership. The ASF licenses this file
  137. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- to you under the Apache License, Version 2.0 (the
  138. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "License"); you may not use this file except in compliance
  139. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- with the License. You may obtain a copy of the License at
  140. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
  141. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- http://www.apache.org/licenses/LICENSE-2.0
  142. 2020-02-12 12:14:41,908 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --
  143. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Unless required by applicable law or agreed to in writing,
  144. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- software distributed under the License is distributed on an
  145. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  146. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- KIND, either express or implied. See the License for the
  147. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- specific language governing permissions and limitations
  148. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- under the License.
  149. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
  150. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Schema upgrade from 4.0.0 to 4.1.0;
  151. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
  152. 2020-02-12 12:14:41,909 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) use cloud
  153. 2020-02-12 12:14:41,938 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) SET foreign_key_checks = 0
  154. 2020-02-12 12:14:41,947 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_template add size bigint unsigned
  155. 2020-02-12 12:14:42,607 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_template add state varchar(255)
  156. 2020-02-12 12:14:42,895 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_template add update_count bigint unsigned
  157. 2020-02-12 12:14:43,162 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_template add updated datetime
  158. 2020-02-12 12:14:43,424 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table storage_pool add storage_provider_id bigint unsigned
  159. 2020-02-12 12:14:43,634 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table storage_pool add scope varchar(255)
  160. 2020-02-12 12:14:43,847 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table storage_pool modify id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL
  161. 2020-02-12 12:14:44,151 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table template_spool_ref add state varchar(255)
  162. 2020-02-12 12:14:44,326 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table template_spool_ref add update_count bigint unsigned
  163. 2020-02-12 12:14:44,485 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table volumes add disk_type varchar(255)
  164. 2020-02-12 12:14:44,764 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table volumes drop foreign key `fk_volumes__account_id`
  165. 2020-02-12 12:14:44,797 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column disk_offering_id bigint unsigned
  166. 2020-02-12 12:14:45,122 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column cpu int(10) unsigned
  167. 2020-02-12 12:14:45,440 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column ram bigint unsigned
  168. 2020-02-12 12:14:45,769 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column owner varchar(255)
  169. 2020-02-12 12:14:46,121 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column speed int(10) unsigned
  170. 2020-02-12 12:14:46,451 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column host_name varchar(255)
  171. 2020-02-12 12:14:46,780 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column display_name varchar(255)
  172. 2020-02-12 12:14:47,110 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table vm_instance add column `desired_state` varchar(32) NULL
  173. 2020-02-12 12:14:47,460 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table data_center add column owner varchar(255)
  174. 2020-02-12 12:14:47,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table data_center add column created datetime COMMENT 'date created'
  175. 2020-02-12 12:14:47,937 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table data_center add column lastUpdated datetime COMMENT 'last updated'
  176. 2020-02-12 12:14:48,174 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table data_center add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
  177. 2020-02-12 12:14:48,398 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host_pod_ref add column owner varchar(255)
  178. 2020-02-12 12:14:48,631 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host_pod_ref add column created datetime COMMENT 'date created'
  179. 2020-02-12 12:14:48,853 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host_pod_ref add column lastUpdated datetime COMMENT 'last updated'
  180. 2020-02-12 12:14:49,077 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host_pod_ref add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
  181. 2020-02-12 12:14:49,313 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host add column owner varchar(255)
  182. 2020-02-12 12:14:49,572 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host add column lastUpdated datetime COMMENT 'last updated'
  183. 2020-02-12 12:14:49,836 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table host add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
  184. 2020-02-12 12:14:50,084 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table cluster add column owner varchar(255)
  185. 2020-02-12 12:14:50,324 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table cluster add column created datetime COMMENT 'date created'
  186. 2020-02-12 12:14:50,567 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table cluster add column lastUpdated datetime COMMENT 'last updated'
  187. 2020-02-12 12:14:50,815 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) alter table cluster add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
  188. 2020-02-12 12:14:51,057 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`vm_compute_tags` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `compute_tag` varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  189. 2020-02-12 12:14:51,162 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`vm_root_disk_tags` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `root_disk_tag` varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  190. 2020-02-12 12:14:51,240 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`vm_network_map` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `network_id` bigint unsigned NOT NULL COMMENT 'network id', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  191. 2020-02-12 12:14:51,334 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`vm_reservation` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) NOT NULL COMMENT 'reservation id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `data_center_id` bigint unsigned NOT NULL COMMENT 'zone id', `pod_id` bigint unsigned NOT NULL COMMENT 'pod id', `cluster_id` bigint unsigned NOT NULL COMMENT 'cluster id', `host_id` bigint unsigned NOT NULL COMMENT 'host id', `created` datetime COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', CONSTRAINT `uc_vm_reservation__uuid` UNIQUE (`uuid`), PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  192. 2020-02-12 12:14:51,445 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`volume_reservation` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_reservation_id` bigint unsigned NOT NULL COMMENT 'id of the vm reservation', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `volume_id` bigint unsigned NOT NULL COMMENT 'volume id', `pool_id` bigint unsigned NOT NULL COMMENT 'pool assigned to the volume', CONSTRAINT `fk_vm_pool_reservation__vm_reservation_id` FOREIGN KEY (`vm_reservation_id`) REFERENCES `vm_reservation`(`id`) ON DELETE CASCADE, PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  193. 2020-02-12 12:14:51,554 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`s3` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `access_key` varchar(20) NOT NULL COMMENT ' The S3 access key', `secret_key` varchar(40) NOT NULL COMMENT ' The S3 secret key', `end_point` varchar(1024) COMMENT ' The S3 host', `bucket` varchar(63) NOT NULL COMMENT ' The S3 host', `https` tinyint unsigned DEFAULT NULL COMMENT ' Flag indicating whether or not to connect over HTTPS', `connection_timeout` integer COMMENT ' The amount of time to wait (in milliseconds) when initially establishing a connection before giving up and timing out.', `max_error_retry` integer COMMENT ' The maximum number of retry attempts for failed retryable requests (ex: 5xx error responses from services).', `socket_timeout` integer COMMENT ' The amount of time to wait (in milliseconds) for data to be transfered over an established, open connection before the connection times out and is closed.', `created` datetime COMMENT 'date the s3 first signed on', PRIMARY KEY (`id`), CONSTRAINT `uc_s3__uuid` UNIQUE (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  194. 2020-02-12 12:14:51,660 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`template_s3_ref` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `s3_id` bigint unsigned NOT NULL COMMENT ' Associated S3 instance id', `template_id` bigint unsigned NOT NULL COMMENT ' Associated template id', `created` DATETIME NOT NULL COMMENT ' The creation timestamp', `size` bigint unsigned COMMENT ' The size of the object', `physical_size` bigint unsigned DEFAULT 0 COMMENT ' The physical size of the object', PRIMARY KEY (`id`), CONSTRAINT `uc_template_s3_ref__template_id` UNIQUE (`template_id`), CONSTRAINT `fk_template_s3_ref__s3_id` FOREIGN KEY `fk_template_s3_ref__s3_id` (`s3_id`) REFERENCES `s3` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_template_s3_ref__template_id` FOREIGN KEY `fk_template_s3_ref__template_id` (`template_id`) REFERENCES `vm_template` (`id`), INDEX `i_template_s3_ref__s3_id`(`s3_id`), INDEX `i_template_s3_ref__template_id`(`template_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  195. 2020-02-12 12:14:51,784 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 's3.enable', 'false', 'enable s3')
  196. 2020-02-12 12:14:51,785 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'NetworkManager', 'router.check.poolsize' , '10', 'Numbers of threads using to check redundant router status.')
  197. 2020-02-12 12:14:51,787 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`snapshots` ADD COLUMN `s3_id` bigint unsigned COMMENT 'S3 to which this snapshot will be stored'
  198. 2020-02-12 12:14:52,038 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`snapshots` ADD CONSTRAINT `fk_snapshots__s3_id` FOREIGN KEY `fk_snapshots__s3_id` (`s3_id`) REFERENCES `s3` (`id`)
  199. 2020-02-12 12:14:52,117 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`network_offerings` ADD COLUMN `inline` int(1) unsigned NOT NULL DEFAULT 0 COMMENT 'Is this network offering LB provider is in inline mode'
  200. 2020-02-12 12:14:52,330 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`external_load_balancer_devices` DROP COLUMN `is_inline`
  201. 2020-02-12 12:14:52,528 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network','DEFAULT','NetworkManager','network.dhcp.nondefaultnetwork.setgateway.guestos','Windows','The guest OS\'s name start with this fields would result in DHCP server response gateway information even when the network it\'s on is not default network. Names are separated by comma.')
  202. 2020-02-12 12:14:52,531 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` ADD `queue_size` SMALLINT NOT NULL DEFAULT '0' COMMENT 'number of items being processed by the queue'
  203. 2020-02-12 12:14:52,722 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` ADD `queue_size_limit` SMALLINT NOT NULL DEFAULT '1' COMMENT 'max number of items the queue can process concurrently'
  204. 2020-02-12 12:14:52,924 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` DROP INDEX `i_sync_queue__queue_proc_time`
  205. 2020-02-12 12:14:52,981 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` DROP COLUMN `queue_proc_time`
  206. 2020-02-12 12:14:53,174 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue` DROP COLUMN `queue_proc_msid`
  207. 2020-02-12 12:14:53,354 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue_item` ADD `queue_proc_time` DATETIME COMMENT 'when processing started for the item' AFTER `queue_proc_number`
  208. 2020-02-12 12:14:53,556 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`sync_queue_item` ADD INDEX `i_sync_queue__queue_proc_time`(`queue_proc_time`)
  209. 2020-02-12 12:14:53,636 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`inline_load_balancer_nic_map` DROP FOREIGN KEY fk_inline_load_balancer_nic_map__load_balancer_id
  210. 2020-02-12 12:14:53,667 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`inline_load_balancer_nic_map` DROP COLUMN load_balancer_id
  211. 2020-02-12 12:14:53,835 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE upload ADD uuid VARCHAR(40)
  212. 2020-02-12 12:14:54,009 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE async_job modify job_cmd VARCHAR(255)
  213. 2020-02-12 12:14:54,354 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`network_offerings` ADD COLUMN `is_persistent` int(1) unsigned NOT NULL DEFAULT 0 COMMENT 'true if the network offering provides an ability to create persistent networks'
  214. 2020-02-12 12:14:54,603 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- populate uuid column with db id if uuid is null
  215. 2020-02-12 12:14:54,604 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`account` set uuid=id WHERE uuid is NULL
  216. 2020-02-12 12:14:54,608 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`alert` set uuid=id WHERE uuid is NULL
  217. 2020-02-12 12:14:54,613 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`async_job` set uuid=id WHERE uuid is NULL
  218. 2020-02-12 12:14:54,620 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`cluster` set uuid=id WHERE uuid is NULL
  219. 2020-02-12 12:14:54,621 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`data_center` set uuid=id WHERE uuid is NULL
  220. 2020-02-12 12:14:54,623 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`dc_storage_network_ip_range` set uuid=id WHERE uuid is NULL
  221. 2020-02-12 12:14:54,625 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`disk_offering` set uuid=id WHERE uuid is NULL
  222. 2020-02-12 12:14:54,627 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`domain` set uuid=id WHERE uuid is NULL
  223. 2020-02-12 12:14:54,629 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`event` set uuid=id WHERE uuid is NULL
  224. 2020-02-12 12:14:54,632 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`external_firewall_devices` set uuid=id WHERE uuid is NULL
  225. 2020-02-12 12:14:54,635 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`external_load_balancer_devices` set uuid=id WHERE uuid is NULL
  226. 2020-02-12 12:14:54,637 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`external_nicira_nvp_devices` set uuid=id WHERE uuid is NULL
  227. 2020-02-12 12:14:54,638 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`firewall_rules` set uuid=id WHERE uuid is NULL
  228. 2020-02-12 12:14:54,639 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`guest_os` set uuid=id WHERE uuid is NULL
  229. 2020-02-12 12:14:54,640 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`guest_os_category` set uuid=id WHERE uuid is NULL
  230. 2020-02-12 12:14:54,642 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`host` set uuid=id WHERE uuid is NULL
  231. 2020-02-12 12:14:54,643 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`host_pod_ref` set uuid=id WHERE uuid is NULL
  232. 2020-02-12 12:14:54,644 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`hypervisor_capabilities` set uuid=id WHERE uuid is NULL
  233. 2020-02-12 12:14:54,645 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`instance_group` set uuid=id WHERE uuid is NULL
  234. 2020-02-12 12:14:54,665 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`load_balancer_stickiness_policies` set uuid=id WHERE uuid is NULL
  235. 2020-02-12 12:14:54,666 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`network_external_firewall_device_map` set uuid=id WHERE uuid is NULL
  236. 2020-02-12 12:14:54,668 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`network_external_lb_device_map` set uuid=id WHERE uuid is NULL
  237. 2020-02-12 12:14:54,670 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`network_offerings` set uuid=id WHERE uuid is NULL
  238. 2020-02-12 12:14:54,672 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`networks` set uuid=id WHERE uuid is NULL
  239. 2020-02-12 12:14:54,674 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`nics` set uuid=id WHERE uuid is NULL
  240. 2020-02-12 12:14:54,675 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`physical_network` set uuid=id WHERE uuid is NULL
  241. 2020-02-12 12:14:54,676 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`physical_network_service_providers` set uuid=id WHERE uuid is NULL
  242. 2020-02-12 12:14:54,677 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`physical_network_traffic_types` set uuid=id WHERE uuid is NULL
  243. 2020-02-12 12:14:54,678 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`port_profile` set uuid=id WHERE uuid is NULL
  244. 2020-02-12 12:14:54,680 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`project_invitations` set uuid=id WHERE uuid is NULL
  245. 2020-02-12 12:14:54,681 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`projects` set uuid=id WHERE uuid is NULL
  246. 2020-02-12 12:14:54,682 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`resource_tags` set uuid=id WHERE uuid is NULL
  247. 2020-02-12 12:14:54,683 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`s2s_customer_gateway` set uuid=id WHERE uuid is NULL
  248. 2020-02-12 12:14:54,685 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`s2s_vpn_connection` set uuid=id WHERE uuid is NULL
  249. 2020-02-12 12:14:54,686 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`s2s_vpn_gateway` set uuid=id WHERE uuid is NULL
  250. 2020-02-12 12:14:54,688 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`security_group` set uuid=id WHERE uuid is NULL
  251. 2020-02-12 12:14:54,689 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`security_group_rule` set uuid=id WHERE uuid is NULL
  252. 2020-02-12 12:14:54,692 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`snapshot_schedule` set uuid=id WHERE uuid is NULL
  253. 2020-02-12 12:14:54,694 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`snapshots` set uuid=id WHERE uuid is NULL
  254. 2020-02-12 12:14:54,696 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`snapshot_policy` set uuid=id WHERE uuid is NULL
  255. 2020-02-12 12:14:54,697 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`static_routes` set uuid=id WHERE uuid is NULL
  256. 2020-02-12 12:14:54,701 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`storage_pool` set uuid=id WHERE uuid is NULL
  257. 2020-02-12 12:14:54,702 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`swift` set uuid=id WHERE uuid is NULL
  258. 2020-02-12 12:14:54,705 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`upload` set uuid=id WHERE uuid is NULL
  259. 2020-02-12 12:14:54,708 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`user` set uuid=id WHERE uuid is NULL
  260. 2020-02-12 12:14:54,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`user_ip_address` set uuid=id WHERE uuid is NULL
  261. 2020-02-12 12:14:54,713 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`user_vm_temp` set uuid=id WHERE uuid is NULL;
  262. 2020-02-12 12:14:54,713 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`virtual_router_providers` set uuid=id WHERE uuid is NULL
  263. 2020-02-12 12:14:54,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`virtual_supervisor_module` set uuid=id WHERE uuid is NULL
  264. 2020-02-12 12:14:54,718 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vlan` set uuid=id WHERE uuid is NULL
  265. 2020-02-12 12:14:54,721 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vm_instance` set uuid=id WHERE uuid is NULL
  266. 2020-02-12 12:14:54,722 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vm_template` set uuid=id WHERE uuid is NULL
  267. 2020-02-12 12:14:54,723 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vpc` set uuid=id WHERE uuid is NULL
  268. 2020-02-12 12:14:54,724 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vpc_gateways` set uuid=id WHERE uuid is NULL
  269. 2020-02-12 12:14:54,726 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vpc_offerings` set uuid=id WHERE uuid is NULL
  270. 2020-02-12 12:14:54,728 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`vpn_users` set uuid=id WHERE uuid is NULL
  271. 2020-02-12 12:14:54,730 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`volumes` set uuid=id WHERE uuid is NULL
  272. 2020-02-12 12:14:54,731 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`configuration` set value = '/var/cloudstack/mnt' where name = 'mount.parent'
  273. 2020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`autoscale_vmgroups` set uuid=id WHERE uuid is NULL;
  274. 2020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`autoscale_vmprofiles` set uuid=id WHERE uuid is NULL;
  275. 2020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`autoscale_policies` set uuid=id WHERE uuid is NULL;
  276. 2020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`counter` set uuid=id WHERE uuid is NULL;
  277. 2020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- UPDATE `cloud`.`conditions` set uuid=id WHERE uuid is NULL;
  278. 2020-02-12 12:14:54,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'detail.batch.query.size', '2000', 'Default entity detail batch query size for listing')
  279. 2020-02-12 12:14:54,735 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'api.throttling.enabled', 'false', 'Enable/Disable Api rate limit')
  280. 2020-02-12 12:14:54,739 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'api.throttling.interval', '1', 'Time interval (in seconds) to reset API count')
  281. 2020-02-12 12:14:54,741 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'api.throttling.max', '25', 'Max allowed number of APIs within fixed interval')
  282. 2020-02-12 12:14:54,743 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'api.throttling.cachesize', '50000', 'Account based API count cache size')
  283. 2020-02-12 12:14:54,744 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'direct.agent.pool.size', '500', 'Default size for DirectAgentPool')
  284. 2020-02-12 12:14:54,745 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`op_dc_vnet_alloc` DROP INDEX i_op_dc_vnet_alloc__vnet__data_center_id
  285. 2020-02-12 12:14:54,796 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`op_dc_vnet_alloc` ADD CONSTRAINT UNIQUE `i_op_dc_vnet_alloc__vnet__data_center_id`(`vnet`, `physical_network_id`, `data_center_id`)
  286. 2020-02-12 12:14:54,863 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`op_dc_vnet_alloc` DROP INDEX i_op_dc_vnet_alloc__vnet__data_center_id__account_id
  287. 2020-02-12 12:14:54,916 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`region` ( `id` int unsigned NOT NULL UNIQUE, `name` varchar(255) NOT NULL UNIQUE, `end_point` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  288. 2020-02-12 12:14:55,032 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`region` values ('1','Local','http://localhost:8080/client/')
  289. 2020-02-12 12:14:55,037 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`nicira_nvp_router_map` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `logicalrouter_uuid` varchar(255) NOT NULL UNIQUE COMMENT 'nicira uuid of logical router', `network_id` bigint unsigned NOT NULL UNIQUE COMMENT 'cloudstack id of the network', PRIMARY KEY (`id`), CONSTRAINT `fk_nicira_nvp_router_map__network_id` FOREIGN KEY (`network_id`) REFERENCES `networks`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  290. 2020-02-12 12:14:55,162 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`external_bigswitch_vns_devices` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255) UNIQUE, `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical network in to which bigswitch vns device is added', `provider_name` varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this bigswitch vns device', `device_name` varchar(255) NOT NULL COMMENT 'name of the bigswitch vns device', `host_id` bigint unsigned NOT NULL COMMENT 'host id coresponding to the external bigswitch vns device', PRIMARY KEY (`id`), CONSTRAINT `fk_external_bigswitch_vns_devices__host_id` FOREIGN KEY (`host_id`) REFERENCES `host`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_external_bigswitch_vns_devices__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  291. 2020-02-12 12:14:55,294 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`counter` ( `id` bigint unsigned NOT NULL UNIQUE AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `source` varchar(255) NOT NULL COMMENT 'source e.g. netscaler, snmp', `name` varchar(255) NOT NULL COMMENT 'Counter name', `value` varchar(255) NOT NULL COMMENT 'Value in case of source=snmp', `removed` datetime COMMENT 'date removed if not null', `created` datetime NOT NULL COMMENT 'date created', PRIMARY KEY (`id`), CONSTRAINT `uc_counter__uuid` UNIQUE (`uuid`), INDEX `i_counter__removed`(`removed`), INDEX `i_counter__source`(`source`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  292. 2020-02-12 12:14:55,440 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`conditions` ( `id` bigint unsigned NOT NULL UNIQUE AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `counter_id` bigint unsigned NOT NULL COMMENT 'Counter Id', `threshold` bigint unsigned NOT NULL COMMENT 'threshold value for the given counter', `relational_operator` char(2) COMMENT 'relational operator to be used upon the counter and condition', `domain_id` bigint unsigned NOT NULL COMMENT 'domain the Condition belongs to', `account_id` bigint unsigned NOT NULL COMMENT 'owner of this Condition', `removed` datetime COMMENT 'date removed if not null', `created` datetime NOT NULL COMMENT 'date created', PRIMARY KEY (`id`), CONSTRAINT `fk_conditions__counter_id` FOREIGN KEY `fk_condition__counter_id`(`counter_id`) REFERENCES `counter`(`id`), CONSTRAINT `fk_conditions__account_id` FOREIGN KEY `fk_condition__account_id` (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_conditions__domain_id` FOREIGN KEY `fk_condition__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_conditions__uuid` UNIQUE (`uuid`), INDEX `i_conditions__removed`(`removed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  293. 2020-02-12 12:14:55,606 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_vmprofiles` ( `id` bigint unsigned NOT NULL auto_increment, `uuid` varchar(40), `zone_id` bigint unsigned NOT NULL, `domain_id` bigint unsigned NOT NULL, `account_id` bigint unsigned NOT NULL, `autoscale_user_id` bigint unsigned NOT NULL, `service_offering_id` bigint unsigned NOT NULL, `template_id` bigint unsigned NOT NULL, `other_deploy_params` varchar(1024) COMMENT 'other deployment parameters that is in addition to zoneid,serviceofferingid,domainid', `destroy_vm_grace_period` int unsigned COMMENT 'the time allowed for existing connections to get closed before a vm is destroyed', `counter_params` varchar(1024) COMMENT 'the parameters for the counter to be used to get metric information from VMs', `created` datetime NOT NULL COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_vmprofiles__domain_id` FOREIGN KEY `fk_autoscale_vmprofiles__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmprofiles__account_id` FOREIGN KEY `fk_autoscale_vmprofiles__account_id` (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmprofiles__autoscale_user_id` FOREIGN KEY `fk_autoscale_vmprofiles__autoscale_user_id` (`autoscale_user_id`) REFERENCES `user`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_autoscale_vmprofiles__uuid` UNIQUE (`uuid`), INDEX `i_autoscale_vmprofiles__removed`(`removed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  294. 2020-02-12 12:14:55,771 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_policies` ( `id` bigint unsigned NOT NULL auto_increment, `uuid` varchar(40), `domain_id` bigint unsigned NOT NULL, `account_id` bigint unsigned NOT NULL, `duration` int unsigned NOT NULL, `quiet_time` int unsigned NOT NULL, `last_quiet_time` datetime DEFAULT NULL, `action` varchar(15), `created` datetime NOT NULL COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_policies__domain_id` FOREIGN KEY `fk_autoscale_policies__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_policies__account_id` FOREIGN KEY `fk_autoscale_policies__account_id` (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_autoscale_policies__uuid` UNIQUE (`uuid`), INDEX `i_autoscale_policies__removed`(`removed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  295. 2020-02-12 12:14:55,922 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_vmgroups` ( `id` bigint unsigned NOT NULL auto_increment, `uuid` varchar(40), `zone_id` bigint unsigned NOT NULL, `domain_id` bigint unsigned NOT NULL, `account_id` bigint unsigned NOT NULL, `load_balancer_id` bigint unsigned NOT NULL, `min_members` int unsigned DEFAULT 1, `max_members` int unsigned NOT NULL, `member_port` int unsigned NOT NULL, `interval` int unsigned NOT NULL, `profile_id` bigint unsigned NOT NULL, `state` varchar(255) NOT NULL COMMENT 'enabled or disabled, a vmgroup is disabled to stop autoscaling activity', `created` datetime NOT NULL COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_vmgroup__autoscale_vmprofile_id` FOREIGN KEY(`profile_id`) REFERENCES `autoscale_vmprofiles`(`id`), CONSTRAINT `fk_autoscale_vmgroup__load_balancer_id` FOREIGN KEY(`load_balancer_id`) REFERENCES `load_balancing_rules`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroups__domain_id` FOREIGN KEY `fk_autoscale_vmgroups__domain_id` (`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroups__account_id` FOREIGN KEY `fk_autoscale_vmgroups__account_id` (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroups__zone_id` FOREIGN KEY `fk_autoscale_vmgroups__zone_id`(`zone_id`) REFERENCES `data_center`(`id`), CONSTRAINT `uc_autoscale_vmgroups__uuid` UNIQUE (`uuid`), INDEX `i_autoscale_vmgroups__removed`(`removed`), INDEX `i_autoscale_vmgroups__load_balancer_id`(`load_balancer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  296. 2020-02-12 12:14:56,105 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_policy_condition_map` ( `id` bigint unsigned NOT NULL auto_increment, `policy_id` bigint unsigned NOT NULL, `condition_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_policy_condition_map__policy_id` FOREIGN KEY `fk_autoscale_policy_condition_map__policy_id` (`policy_id`) REFERENCES `autoscale_policies` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_policy_condition_map__condition_id` FOREIGN KEY `fk_autoscale_policy_condition_map__condition_id` (`condition_id`) REFERENCES `conditions` (`id`), INDEX `i_autoscale_policy_condition_map__policy_id`(`policy_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  297. 2020-02-12 12:14:56,223 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_vmgroup_policy_map` ( `id` bigint unsigned NOT NULL auto_increment, `vmgroup_id` bigint unsigned NOT NULL, `policy_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_vmgroup_policy_map__vmgroup_id` FOREIGN KEY `fk_autoscale_vmgroup_policy_map__vmgroup_id` (`vmgroup_id`) REFERENCES `autoscale_vmgroups` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroup_policy_map__policy_id` FOREIGN KEY `fk_autoscale_vmgroup_policy_map__policy_id` (`policy_id`) REFERENCES `autoscale_policies` (`id`), INDEX `i_autoscale_vmgroup_policy_map__vmgroup_id`(`vmgroup_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  298. 2020-02-12 12:14:56,352 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`autoscale_vmgroup_vm_map` ( `id` bigint unsigned NOT NULL auto_increment, `vmgroup_id` bigint unsigned NOT NULL, `instance_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_autoscale_vmgroup_vm_map__vmgroup_id` FOREIGN KEY `fk_autoscale_vmgroup_vm_map__vmgroup_id` (`vmgroup_id`) REFERENCES `autoscale_vmgroups` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_autoscale_vmgroup_vm_map__instance_id` FOREIGN KEY `fk_autoscale_vmgroup_vm_map__instance_id` (`instance_id`) REFERENCES `vm_instance` (`id`), INDEX `i_autoscale_vmgroup_vm_map__vmgroup_id`(`vmgroup_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  299. 2020-02-12 12:14:56,487 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (1, UUID(), 'snmp','Linux User CPU - percentage', '1.3.6.1.4.1.2021.11.9.0', now())
  300. 2020-02-12 12:14:56,490 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (2, UUID(), 'snmp','Linux System CPU - percentage', '1.3.6.1.4.1.2021.11.10.0', now())
  301. 2020-02-12 12:14:56,493 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (3, UUID(), 'snmp','Linux CPU Idle - percentage', '1.3.6.1.4.1.2021.11.11.0', now())
  302. 2020-02-12 12:14:56,497 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (100, UUID(), 'netscaler','Response Time - microseconds', 'RESPTIME', now())
  303. 2020-02-12 12:14:56,499 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (4, UUID(), 'cpu','Linux User CPU - percentage - native', '1.3.6.1.4.1.2021.11.9.1', now())
  304. 2020-02-12 12:14:56,505 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT INTO `cloud`.`counter` (id, uuid, source, name, value,created) VALUES (5, UUID(), 'memory','Linux User RAM - percentage - native', '1.3.6.1.4.1.2021.11.10.1', now())
  305. 2020-02-12 12:14:56,505 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`user_ipv6_address` ( `id` bigint unsigned NOT NULL UNIQUE auto_increment, `uuid` varchar(40), `account_id` bigint unsigned NULL, `domain_id` bigint unsigned NULL, `ip_address` char(50) NOT NULL, `data_center_id` bigint unsigned NOT NULL COMMENT 'zone that it belongs to', `vlan_id` bigint unsigned NOT NULL, `state` char(32) NOT NULL default 'Free' COMMENT 'state of the ip address', `mac_address` varchar(40) NOT NULL COMMENT 'mac address of this ip', `source_network_id` bigint unsigned NOT NULL COMMENT 'network id ip belongs to', `network_id` bigint unsigned COMMENT 'network this public ip address is associated with', `physical_network_id` bigint unsigned NOT NULL COMMENT 'physical network id that this configuration is based on', `created` datetime NULL COMMENT 'Date this ip was allocated to someone', PRIMARY KEY (`id`), UNIQUE (`ip_address`, `source_network_id`), CONSTRAINT `fk_user_ipv6_address__source_network_id` FOREIGN KEY (`source_network_id`) REFERENCES `networks`(`id`), CONSTRAINT `fk_user_ipv6_address__network_id` FOREIGN KEY (`network_id`) REFERENCES `networks`(`id`), CONSTRAINT `fk_user_ipv6_address__account_id` FOREIGN KEY (`account_id`) REFERENCES `account`(`id`), CONSTRAINT `fk_user_ipv6_address__vlan_id` FOREIGN KEY (`vlan_id`) REFERENCES `vlan`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_user_ipv6_address__data_center_id` FOREIGN KEY (`data_center_id`) REFERENCES `data_center`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_user_ipv6_address__uuid` UNIQUE (`uuid`), CONSTRAINT `fk_user_ipv6_address__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  306. 2020-02-12 12:14:56,712 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`networks` ADD COLUMN `ip6_gateway` varchar(50) COMMENT 'IPv6 gateway for this network'
  307. 2020-02-12 12:14:56,962 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`networks` ADD COLUMN `ip6_cidr` varchar(50) COMMENT 'IPv6 cidr for this network'
  308. 2020-02-12 12:14:57,224 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`nics` ADD COLUMN `ip6_gateway` varchar(50) COMMENT 'gateway for ip6 address'
  309. 2020-02-12 12:14:57,438 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`nics` ADD COLUMN `ip6_cidr` varchar(50) COMMENT 'cidr for ip6 address'
  310. 2020-02-12 12:14:57,645 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vlan` ADD COLUMN `ip6_gateway` varchar(255)
  311. 2020-02-12 12:14:57,842 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vlan` ADD COLUMN `ip6_cidr` varchar(255)
  312. 2020-02-12 12:14:58,029 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vlan` ADD COLUMN `ip6_range` varchar(255)
  313. 2020-02-12 12:14:58,210 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`data_center` ADD COLUMN `ip6_dns1` varchar(255)
  314. 2020-02-12 12:14:58,425 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`data_center` ADD COLUMN `ip6_dns2` varchar(255)
  315. 2020-02-12 12:14:58,658 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`networks` INNER JOIN `cloud`.`vlan` ON networks.id = vlan.network_id SET networks.gateway = vlan.vlan_gateway, networks.ip6_gateway = vlan.ip6_gateway, networks.ip6_cidr = vlan.ip6_cidr WHERE networks.data_center_id = vlan.data_center_id AND networks.physical_network_id = vlan.physical_network_id
  316. 2020-02-12 12:14:58,663 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- DB views for list api
  317. 2020-02-12 12:14:58,664 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`user_vm_view`
  318. 2020-02-12 12:14:58,674 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`user_vm_view` AS select vm_instance.id id, vm_instance.name name, user_vm.display_name display_name, user_vm.user_data user_data, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, instance_group.id instance_group_id, instance_group.uuid instance_group_uuid, instance_group.name instance_group_name, vm_instance.uuid uuid, vm_instance.last_host_id last_host_id, vm_instance.vm_type type, vm_instance.vnc_password vnc_password, vm_instance.limit_cpu_use limit_cpu_use, vm_instance.created created, vm_instance.state state, vm_instance.removed removed, vm_instance.ha_enabled ha_enabled, vm_instance.hypervisor_type hypervisor_type, vm_instance.instance_name instance_name, vm_instance.guest_os_id guest_os_id, guest_os.uuid guest_os_uuid, vm_instance.pod_id pod_id, host_pod_ref.uuid pod_uuid, vm_instance.private_ip_address private_ip_address, vm_instance.private_mac_address private_mac_address, vm_instance.vm_type vm_type, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.is_security_group_enabled security_group_enabled, host.id host_id, host.uuid host_uuid, host.name host_name, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.name template_name, vm_template.display_text template_display_text, vm_template.enable_password password_enabled, iso.id iso_id, iso.uuid iso_uuid, iso.name iso_name, iso.display_text iso_display_text, service_offering.id service_offering_id, disk_offering.uuid service_offering_uuid, service_offering.cpu cpu, service_offering.speed speed, service_offering.ram_size ram_size, disk_offering.name service_offering_name, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.pool_type pool_type, volumes.id volume_id, volumes.uuid volume_uuid, volumes.device_id volume_device_id, volumes.volume_type volume_type, security_group.id security_group_id, security_group.uuid security_group_uuid, security_group.name security_group_name, security_group.description security_group_description, nics.id nic_id, nics.uuid nic_uuid, nics.network_id network_id, nics.ip4_address ip_address, nics.ip6_address ip6_address, nics.ip6_gateway ip6_gateway, nics.ip6_cidr ip6_cidr, nics.default_nic is_default_nic, nics.gateway gateway, nics.netmask netmask, nics.mac_address mac_address, nics.broadcast_uri broadcast_uri, nics.isolation_uri isolation_uri, vpc.id vpc_id, vpc.uuid vpc_uuid, networks.uuid network_uuid, networks.name network_name, networks.traffic_type traffic_type, networks.guest_type guest_type, user_ip_address.id public_ip_id, user_ip_address.uuid public_ip_uuid, user_ip_address.public_ip_address public_ip_address, ssh_keypairs.keypair_name keypair_name, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`user_vm` inner join `cloud`.`vm_instance` ON vm_instance.id = user_vm.id and vm_instance.removed is NULL inner join `cloud`.`account` ON vm_instance.account_id = account.id inner join `cloud`.`domain` ON vm_instance.domain_id = domain.id left join `cloud`.`guest_os` ON vm_instance.guest_os_id = guest_os.id left join `cloud`.`host_pod_ref` ON vm_instance.pod_id = host_pod_ref.id left join `cloud`.`projects` ON projects.project_account_id = account.id left join `cloud`.`instance_group_vm_map` ON vm_instance.id = instance_group_vm_map.instance_id left join `cloud`.`instance_group` ON instance_group_vm_map.group_id = instance_group.id left join `cloud`.`data_center` ON vm_instance.data_center_id = data_center.id left join `cloud`.`host` ON vm_instance.host_id = host.id left join `cloud`.`vm_template` ON vm_instance.vm_template_id = vm_template.id left join `cloud`.`vm_template` iso ON iso.id = user_vm.iso_id left join `cloud`.`service_offering` ON vm_instance.service_offering_id = service_offering.id left join `cloud`.`disk_offering` ON vm_instance.service_offering_id = disk_offering.id left join `cloud`.`volumes` ON vm_instance.id = volumes.instance_id left join `cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left join `cloud`.`security_group_vm_map` ON vm_instance.id = security_group_vm_map.instance_id left join `cloud`.`security_group` ON security_group_vm_map.security_group_id = security_group.id left join `cloud`.`nics` ON vm_instance.id = nics.instance_id left join `cloud`.`networks` ON nics.network_id = networks.id left join `cloud`.`vpc` ON networks.vpc_id = vpc.id left join `cloud`.`user_ip_address` ON user_ip_address.vm_id = vm_instance.id left join `cloud`.`user_vm_details` ON user_vm_details.vm_id = vm_instance.id and user_vm_details.name = 'SSH.PublicKey' left join `cloud`.`ssh_keypairs` ON ssh_keypairs.public_key = user_vm_details.value left join `cloud`.`resource_tags` ON resource_tags.resource_id = vm_instance.id and resource_tags.resource_type = 'UserVm' left join `cloud`.`async_job` ON async_job.instance_id = vm_instance.id and async_job.instance_type = 'VirtualMachine' and async_job.job_status = 0
  319. 2020-02-12 12:14:58,689 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`domain_router_view`
  320. 2020-02-12 12:14:58,693 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`domain_router_view` AS select vm_instance.id id, vm_instance.name name, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, vm_instance.uuid uuid, vm_instance.created created, vm_instance.state state, vm_instance.removed removed, vm_instance.pod_id pod_id, vm_instance.instance_name instance_name, host_pod_ref.uuid pod_uuid, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, data_center.networktype data_center_type, data_center.dns1 dns1, data_center.dns2 dns2, data_center.ip6_dns1 ip6_dns1, data_center.ip6_dns2 ip6_dns2, host.id host_id, host.uuid host_uuid, host.name host_name, vm_template.id template_id, vm_template.uuid template_uuid, service_offering.id service_offering_id, disk_offering.uuid service_offering_uuid, disk_offering.name service_offering_name, nics.id nic_id, nics.uuid nic_uuid, nics.network_id network_id, nics.ip4_address ip_address, nics.ip6_address ip6_address, nics.ip6_gateway ip6_gateway, nics.ip6_cidr ip6_cidr, nics.default_nic is_default_nic, nics.gateway gateway, nics.netmask netmask, nics.mac_address mac_address, nics.broadcast_uri broadcast_uri, nics.isolation_uri isolation_uri, vpc.id vpc_id, vpc.uuid vpc_uuid, networks.uuid network_uuid, networks.name network_name, networks.network_domain network_domain, networks.traffic_type traffic_type, networks.guest_type guest_type, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id, domain_router.template_version template_version, domain_router.scripts_version scripts_version, domain_router.is_redundant_router is_redundant_router, domain_router.redundant_state redundant_state, domain_router.stop_pending stop_pending, domain_router.role role from `cloud`.`domain_router` inner join `cloud`.`vm_instance` ON vm_instance.id = domain_router.id inner join `cloud`.`account` ON vm_instance.account_id = account.id inner join `cloud`.`domain` ON vm_instance.domain_id = domain.id left join `cloud`.`host_pod_ref` ON vm_instance.pod_id = host_pod_ref.id left join `cloud`.`projects` ON projects.project_account_id = account.id left join `cloud`.`data_center` ON vm_instance.data_center_id = data_center.id left join `cloud`.`host` ON vm_instance.host_id = host.id left join `cloud`.`vm_template` ON vm_instance.vm_template_id = vm_template.id left join `cloud`.`service_offering` ON vm_instance.service_offering_id = service_offering.id left join `cloud`.`disk_offering` ON vm_instance.service_offering_id = disk_offering.id left join `cloud`.`volumes` ON vm_instance.id = volumes.instance_id left join `cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left join `cloud`.`nics` ON vm_instance.id = nics.instance_id left join `cloud`.`networks` ON nics.network_id = networks.id left join `cloud`.`vpc` ON domain_router.vpc_id = vpc.id left join `cloud`.`async_job` ON async_job.instance_id = vm_instance.id and async_job.instance_type = 'DomainRouter' and async_job.job_status = 0
  321. 2020-02-12 12:14:58,705 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`security_group_view`
  322. 2020-02-12 12:14:58,707 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`security_group_view` AS select security_group.id id, security_group.name name, security_group.description description, security_group.uuid uuid, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, security_group_rule.id rule_id, security_group_rule.uuid rule_uuid, security_group_rule.type rule_type, security_group_rule.start_port rule_start_port, security_group_rule.end_port rule_end_port, security_group_rule.protocol rule_protocol, security_group_rule.allowed_network_id rule_allowed_network_id, security_group_rule.allowed_ip_cidr rule_allowed_ip_cidr, security_group_rule.create_status rule_create_status, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`security_group` left join `cloud`.`security_group_rule` ON security_group.id = security_group_rule.security_group_id inner join `cloud`.`account` ON security_group.account_id = account.id inner join `cloud`.`domain` ON security_group.domain_id = domain.id left join `cloud`.`projects` ON projects.project_account_id = security_group.account_id left join `cloud`.`resource_tags` ON resource_tags.resource_id = security_group.id and resource_tags.resource_type = 'SecurityGroup' left join `cloud`.`async_job` ON async_job.instance_id = security_group.id and async_job.instance_type = 'SecurityGroup' and async_job.job_status = 0
  323. 2020-02-12 12:14:58,723 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`resource_tag_view`
  324. 2020-02-12 12:14:58,730 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`resource_tag_view` AS select resource_tags.id, resource_tags.uuid, resource_tags.key, resource_tags.value, resource_tags.resource_id, resource_tags.resource_uuid, resource_tags.resource_type, resource_tags.customer, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name from `cloud`.`resource_tags` inner join `cloud`.`account` ON resource_tags.account_id = account.id inner join `cloud`.`domain` ON resource_tags.domain_id = domain.id left join `cloud`.`projects` ON projects.project_account_id = resource_tags.account_id
  325. 2020-02-12 12:14:58,748 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`event_view`
  326. 2020-02-12 12:14:58,771 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`event_view` AS select event.id, event.uuid, event.type, event.state, event.description, event.created, event.level, event.parameters, event.start_id, eve.uuid start_uuid, event.user_id, user.username user_name, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name from `cloud`.`event` inner join `cloud`.`account` ON event.account_id = account.id inner join `cloud`.`domain` ON event.domain_id = domain.id inner join `cloud`.`user` ON event.user_id = user.id left join `cloud`.`projects` ON projects.project_account_id = event.account_id left join `cloud`.`event` eve ON event.start_id = eve.id
  327. 2020-02-12 12:14:58,785 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`instance_group_view`
  328. 2020-02-12 12:14:58,787 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`instance_group_view` AS select instance_group.id, instance_group.uuid, instance_group.name, instance_group.removed, instance_group.created, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name from `cloud`.`instance_group` inner join `cloud`.`account` ON instance_group.account_id = account.id inner join `cloud`.`domain` ON account.domain_id = domain.id left join `cloud`.`projects` ON projects.project_account_id = instance_group.account_id
  329. 2020-02-12 12:14:58,799 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`user_view`
  330. 2020-02-12 12:14:58,803 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`user_view` AS select user.id, user.uuid, user.username, user.password, user.firstname, user.lastname, user.email, user.state, user.api_key, user.secret_key, user.created, user.removed, user.timezone, user.registration_token, user.is_registered, user.incorrect_login_attempts, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`user` inner join `cloud`.`account` ON user.account_id = account.id inner join `cloud`.`domain` ON account.domain_id = domain.id left join `cloud`.`async_job` ON async_job.instance_id = user.id and async_job.instance_type = 'User' and async_job.job_status = 0
  331. 2020-02-12 12:14:58,819 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`project_view`
  332. 2020-02-12 12:14:58,820 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`project_view` AS select projects.id, projects.uuid, projects.name, projects.display_text, projects.state, projects.removed, projects.created, account.account_name owner, pacct.account_id, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer from `cloud`.`projects` inner join `cloud`.`domain` ON projects.domain_id = domain.id inner join `cloud`.`project_account` ON projects.id = project_account.project_id and project_account.account_role = 'Admin' inner join `cloud`.`account` ON account.id = project_account.account_id left join `cloud`.`resource_tags` ON resource_tags.resource_id = projects.id and resource_tags.resource_type = 'Project' left join `cloud`.`project_account` pacct ON projects.id = pacct.project_id
  333. 2020-02-12 12:14:58,838 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`project_account_view`
  334. 2020-02-12 12:14:58,844 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`project_account_view` AS select project_account.id, account.id account_id, account.uuid account_uuid, account.account_name, account.type account_type, project_account.account_role, projects.id project_id, projects.uuid project_uuid, projects.name project_name, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`project_account` inner join `cloud`.`account` ON project_account.account_id = account.id inner join `cloud`.`domain` ON account.domain_id = domain.id inner join `cloud`.`projects` ON projects.id = project_account.project_id
  335. 2020-02-12 12:14:58,878 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`project_invitation_view`
  336. 2020-02-12 12:14:58,879 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`project_invitation_view` AS select project_invitations.id, project_invitations.uuid, project_invitations.email, project_invitations.created, project_invitations.state, projects.id project_id, projects.uuid project_uuid, projects.name project_name, account.id account_id, account.uuid account_uuid, account.account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`project_invitations` left join `cloud`.`account` ON project_invitations.account_id = account.id left join `cloud`.`domain` ON project_invitations.domain_id = domain.id left join `cloud`.`projects` ON projects.id = project_invitations.project_id
  337. 2020-02-12 12:14:58,902 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`host_view`
  338. 2020-02-12 12:14:58,904 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`host_view` AS select host.id, host.uuid, host.name, host.status, host.disconnected, host.type, host.private_ip_address, host.version, host.hypervisor_type, host.hypervisor_version, host.capabilities, host.last_ping, host.created, host.removed, host.resource_state, host.mgmt_server_id, host.cpus, host.speed, host.ram, cluster.id cluster_id, cluster.uuid cluster_uuid, cluster.name cluster_name, cluster.cluster_type, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid, host_pod_ref.name pod_name, host_tags.tag, guest_os_category.id guest_os_category_id, guest_os_category.uuid guest_os_category_uuid, guest_os_category.name guest_os_category_name, mem_caps.used_capacity memory_used_capacity, mem_caps.reserved_capacity memory_reserved_capacity, cpu_caps.used_capacity cpu_used_capacity, cpu_caps.reserved_capacity cpu_reserved_capacity, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`host` left join `cloud`.`cluster` ON host.cluster_id = cluster.id left join `cloud`.`data_center` ON host.data_center_id = data_center.id left join `cloud`.`host_pod_ref` ON host.pod_id = host_pod_ref.id left join `cloud`.`host_details` ON host.id = host_details.host_id and host_details.name = 'guest.os.category.id' left join `cloud`.`guest_os_category` ON guest_os_category.id = CONVERT( host_details.value , UNSIGNED) left join `cloud`.`host_tags` ON host_tags.host_id = host.id left join `cloud`.`op_host_capacity` mem_caps ON host.id = mem_caps.host_id and mem_caps.capacity_type = 0 left join `cloud`.`op_host_capacity` cpu_caps ON host.id = cpu_caps.host_id and cpu_caps.capacity_type = 1 left join `cloud`.`async_job` ON async_job.instance_id = host.id and async_job.instance_type = 'Host' and async_job.job_status = 0
  339. 2020-02-12 12:14:58,930 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`volume_view`
  340. 2020-02-12 12:14:58,931 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`volume_view` AS select volumes.id, volumes.uuid, volumes.name, volumes.device_id, volumes.volume_type, volumes.size, volumes.created, volumes.state, volumes.attached, volumes.removed, volumes.pod_id, account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, projects.id project_id, projects.uuid project_uuid, projects.name project_name, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, vm_instance.id vm_id, vm_instance.uuid vm_uuid, vm_instance.name vm_name, vm_instance.state vm_state, vm_instance.vm_type, user_vm.display_name vm_display_name, volume_host_ref.size volume_host_size, volume_host_ref.created volume_host_created, volume_host_ref.format, volume_host_ref.download_pct, volume_host_ref.download_state, volume_host_ref.error_str, disk_offering.id disk_offering_id, disk_offering.uuid disk_offering_uuid, disk_offering.name disk_offering_name, disk_offering.display_text disk_offering_display_text, disk_offering.use_local_storage, disk_offering.system_use, storage_pool.id pool_id, storage_pool.uuid pool_uuid, storage_pool.name pool_name, cluster.hypervisor_type, vm_template.id template_id, vm_template.uuid template_uuid, vm_template.extractable, vm_template.type template_type, resource_tags.id tag_id, resource_tags.uuid tag_uuid, resource_tags.key tag_key, resource_tags.value tag_value, resource_tags.domain_id tag_domain_id, resource_tags.account_id tag_account_id, resource_tags.resource_id tag_resource_id, resource_tags.resource_uuid tag_resource_uuid, resource_tags.resource_type tag_resource_type, resource_tags.customer tag_customer, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`volumes` inner join `cloud`.`account` ON volumes.account_id = account.id inner join `cloud`.`domain` ON volumes.domain_id = domain.id left join `cloud`.`projects` ON projects.project_account_id = account.id left join `cloud`.`data_center` ON volumes.data_center_id = data_center.id left join `cloud`.`vm_instance` ON volumes.instance_id = vm_instance.id left join `cloud`.`user_vm` ON user_vm.id = vm_instance.id left join `cloud`.`volume_host_ref` ON volumes.id = volume_host_ref.volume_id and volumes.data_center_id = volume_host_ref.zone_id left join `cloud`.`disk_offering` ON volumes.disk_offering_id = disk_offering.id left join `cloud`.`storage_pool` ON volumes.pool_id = storage_pool.id left join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id left join `cloud`.`vm_template` ON volumes.template_id = vm_template.id left join `cloud`.`resource_tags` ON resource_tags.resource_id = volumes.id and resource_tags.resource_type = 'Volume' left join `cloud`.`async_job` ON async_job.instance_id = volumes.id and async_job.instance_type = 'Volume' and async_job.job_status = 0
  341. 2020-02-12 12:14:58,947 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`account_netstats_view`
  342. 2020-02-12 12:14:58,948 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`account_netstats_view` AS SELECT account_id, sum(net_bytes_received) + sum(current_bytes_received) as bytesReceived, sum(net_bytes_sent) + sum(current_bytes_sent) as bytesSent FROM `cloud`.`user_statistics` group by account_id
  343. 2020-02-12 12:14:58,961 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`account_vmstats_view`
  344. 2020-02-12 12:14:58,963 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`account_vmstats_view` AS SELECT account_id, state, count(*) as vmcount from `cloud`.`vm_instance` group by account_id , state
  345. 2020-02-12 12:14:58,973 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`free_ip_view`
  346. 2020-02-12 12:14:58,974 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`free_ip_view` AS select count(user_ip_address.id) free_ip from `cloud`.`user_ip_address` inner join `cloud`.`vlan` ON vlan.id = user_ip_address.vlan_db_id and vlan.vlan_type = 'VirtualNetwork' where state = 'Free'
  347. 2020-02-12 12:14:58,989 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`account_view`
  348. 2020-02-12 12:14:58,990 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`account_view` AS select account.id, account.uuid, account.account_name, account.type, account.state, account.removed, account.cleanup_needed, account.network_domain, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, account_netstats_view.bytesReceived, account_netstats_view.bytesSent, vmlimit.max vmLimit, vmcount.count vmTotal, runningvm.vmcount runningVms, stoppedvm.vmcount stoppedVms, iplimit.max ipLimit, ipcount.count ipTotal, free_ip_view.free_ip ipFree, volumelimit.max volumeLimit, volumecount.count volumeTotal, snapshotlimit.max snapshotLimit, snapshotcount.count snapshotTotal, templatelimit.max templateLimit, templatecount.count templateTotal, vpclimit.max vpcLimit, vpccount.count vpcTotal, projectlimit.max projectLimit, projectcount.count projectTotal, networklimit.max networkLimit, networkcount.count networkTotal, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`free_ip_view`, `cloud`.`account` inner join `cloud`.`domain` ON account.domain_id = domain.id left join `cloud`.`data_center` ON account.default_zone_id = data_center.id left join `cloud`.`account_netstats_view` ON account.id = account_netstats_view.account_id left join `cloud`.`resource_limit` vmlimit ON account.id = vmlimit.account_id and vmlimit.type = 'user_vm' left join `cloud`.`resource_count` vmcount ON account.id = vmcount.account_id and vmcount.type = 'user_vm' left join `cloud`.`account_vmstats_view` runningvm ON account.id = runningvm.account_id and runningvm.state = 'Running' left join `cloud`.`account_vmstats_view` stoppedvm ON account.id = stoppedvm.account_id and stoppedvm.state = 'Stopped' left join `cloud`.`resource_limit` iplimit ON account.id = iplimit.account_id and iplimit.type = 'public_ip' left join `cloud`.`resource_count` ipcount ON account.id = ipcount.account_id and ipcount.type = 'public_ip' left join `cloud`.`resource_limit` volumelimit ON account.id = volumelimit.account_id and volumelimit.type = 'volume' left join `cloud`.`resource_count` volumecount ON account.id = volumecount.account_id and volumecount.type = 'volume' left join `cloud`.`resource_limit` snapshotlimit ON account.id = snapshotlimit.account_id and snapshotlimit.type = 'snapshot' left join `cloud`.`resource_count` snapshotcount ON account.id = snapshotcount.account_id and snapshotcount.type = 'snapshot' left join `cloud`.`resource_limit` templatelimit ON account.id = templatelimit.account_id and templatelimit.type = 'template' left join `cloud`.`resource_count` templatecount ON account.id = templatecount.account_id and templatecount.type = 'template' left join `cloud`.`resource_limit` vpclimit ON account.id = vpclimit.account_id and vpclimit.type = 'vpc' left join `cloud`.`resource_count` vpccount ON account.id = vpccount.account_id and vpccount.type = 'vpc' left join `cloud`.`resource_limit` projectlimit ON account.id = projectlimit.account_id and projectlimit.type = 'project' left join `cloud`.`resource_count` projectcount ON account.id = projectcount.account_id and projectcount.type = 'project' left join `cloud`.`resource_limit` networklimit ON account.id = networklimit.account_id and networklimit.type = 'network' left join `cloud`.`resource_count` networkcount ON account.id = networkcount.account_id and networkcount.type = 'network' left join `cloud`.`async_job` ON async_job.instance_id = account.id and async_job.instance_type = 'Account' and async_job.job_status = 0
  349. 2020-02-12 12:14:59,021 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`async_job_view`
  350. 2020-02-12 12:14:59,023 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`async_job_view` AS select account.id account_id, account.uuid account_uuid, account.account_name account_name, account.type account_type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path, user.id user_id, user.uuid user_uuid, async_job.id, async_job.uuid, async_job.job_cmd, async_job.job_status, async_job.job_process_status, async_job.job_result_code, async_job.job_result, async_job.created, async_job.removed, async_job.instance_type, async_job.instance_id, CASE WHEN async_job.instance_type = 'Volume' THEN volumes.uuid WHEN async_job.instance_type = 'Template' or async_job.instance_type = 'Iso' THEN vm_template.uuid WHEN async_job.instance_type = 'VirtualMachine' or async_job.instance_type = 'ConsoleProxy' or async_job.instance_type = 'SystemVm' or async_job.instance_type = 'DomainRouter' THEN vm_instance.uuid WHEN async_job.instance_type = 'Snapshot' THEN snapshots.uuid WHEN async_job.instance_type = 'Host' THEN host.uuid WHEN async_job.instance_type = 'StoragePool' THEN storage_pool.uuid WHEN async_job.instance_type = 'IpAddress' THEN user_ip_address.uuid WHEN async_job.instance_type = 'SecurityGroup' THEN security_group.uuid WHEN async_job.instance_type = 'PhysicalNetwork' THEN physical_network.uuid WHEN async_job.instance_type = 'TrafficType' THEN physical_network_traffic_types.uuid WHEN async_job.instance_type = 'PhysicalNetworkServiceProvider' THEN physical_network_service_providers.uuid WHEN async_job.instance_type = 'FirewallRule' THEN firewall_rules.uuid WHEN async_job.instance_type = 'Account' THEN acct.uuid WHEN async_job.instance_type = 'User' THEN us.uuid WHEN async_job.instance_type = 'StaticRoute' THEN static_routes.uuid WHEN async_job.instance_type = 'PrivateGateway' THEN vpc_gateways.uuid WHEN async_job.instance_type = 'Counter' THEN counter.uuid WHEN async_job.instance_type = 'Condition' THEN conditions.uuid WHEN async_job.instance_type = 'AutoScalePolicy' THEN autoscale_policies.uuid WHEN async_job.instance_type = 'AutoScaleVmProfile' THEN autoscale_vmprofiles.uuid WHEN async_job.instance_type = 'AutoScaleVmGroup' THEN autoscale_vmgroups.uuid ELSE null END instance_uuid from `cloud`.`async_job` left join `cloud`.`account` ON async_job.account_id = account.id left join `cloud`.`domain` ON domain.id = account.domain_id left join `cloud`.`user` ON async_job.user_id = user.id left join `cloud`.`volumes` ON async_job.instance_id = volumes.id left join `cloud`.`vm_template` ON async_job.instance_id = vm_template.id left join `cloud`.`vm_instance` ON async_job.instance_id = vm_instance.id left join `cloud`.`snapshots` ON async_job.instance_id = snapshots.id left join `cloud`.`host` ON async_job.instance_id = host.id left join `cloud`.`storage_pool` ON async_job.instance_id = storage_pool.id left join `cloud`.`user_ip_address` ON async_job.instance_id = user_ip_address.id left join `cloud`.`security_group` ON async_job.instance_id = security_group.id left join `cloud`.`physical_network` ON async_job.instance_id = physical_network.id left join `cloud`.`physical_network_traffic_types` ON async_job.instance_id = physical_network_traffic_types.id left join `cloud`.`physical_network_service_providers` ON async_job.instance_id = physical_network_service_providers.id left join `cloud`.`firewall_rules` ON async_job.instance_id = firewall_rules.id left join `cloud`.`account` acct ON async_job.instance_id = acct.id left join `cloud`.`user` us ON async_job.instance_id = us.id left join `cloud`.`static_routes` ON async_job.instance_id = static_routes.id left join `cloud`.`vpc_gateways` ON async_job.instance_id = vpc_gateways.id left join `cloud`.`counter` ON async_job.instance_id = counter.id left join `cloud`.`conditions` ON async_job.instance_id = conditions.id left join `cloud`.`autoscale_policies` ON async_job.instance_id = autoscale_policies.id left join `cloud`.`autoscale_vmprofiles` ON async_job.instance_id = autoscale_vmprofiles.id left join `cloud`.`autoscale_vmgroups` ON async_job.instance_id = autoscale_vmgroups.id
  351. 2020-02-12 12:14:59,045 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`storage_pool_view`
  352. 2020-02-12 12:14:59,048 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`storage_pool_view` AS select storage_pool.id, storage_pool.uuid, storage_pool.name, storage_pool.status, storage_pool.path, storage_pool.pool_type, storage_pool.host_address, storage_pool.created, storage_pool.removed, storage_pool.capacity_bytes, storage_pool.scope, cluster.id cluster_id, cluster.uuid cluster_uuid, cluster.name cluster_name, cluster.cluster_type, data_center.id data_center_id, data_center.uuid data_center_uuid, data_center.name data_center_name, host_pod_ref.id pod_id, host_pod_ref.uuid pod_uuid, host_pod_ref.name pod_name, storage_pool_details.name tag, op_host_capacity.used_capacity disk_used_capacity, op_host_capacity.reserved_capacity disk_reserved_capacity, async_job.id job_id, async_job.uuid job_uuid, async_job.job_status job_status, async_job.account_id job_account_id from `cloud`.`storage_pool` left join `cloud`.`cluster` ON storage_pool.cluster_id = cluster.id left join `cloud`.`data_center` ON storage_pool.data_center_id = data_center.id left join `cloud`.`host_pod_ref` ON storage_pool.pod_id = host_pod_ref.id left join `cloud`.`storage_pool_details` ON storage_pool_details.pool_id = storage_pool.id and storage_pool_details.value = 'true' left join `cloud`.`op_host_capacity` ON storage_pool.id = op_host_capacity.host_id and op_host_capacity.capacity_type = 3 left join `cloud`.`async_job` ON async_job.instance_id = storage_pool.id and async_job.instance_type = 'StoragePool' and async_job.job_status = 0
  353. 2020-02-12 12:14:59,059 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`disk_offering_view`
  354. 2020-02-12 12:14:59,060 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`disk_offering_view` AS select disk_offering.id, disk_offering.uuid, disk_offering.name, disk_offering.display_text, disk_offering.disk_size, disk_offering.created, disk_offering.tags, disk_offering.customized, disk_offering.removed, disk_offering.use_local_storage, disk_offering.system_use, disk_offering.sort_key, disk_offering.type, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`disk_offering` left join `cloud`.`domain` ON disk_offering.domain_id = domain.id
  355. 2020-02-12 12:14:59,075 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`service_offering_view`
  356. 2020-02-12 12:14:59,077 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`service_offering_view` AS select service_offering.id, disk_offering.uuid, disk_offering.name, disk_offering.display_text, disk_offering.created, disk_offering.tags, disk_offering.removed, disk_offering.use_local_storage, disk_offering.system_use, service_offering.cpu, service_offering.speed, service_offering.ram_size, service_offering.nw_rate, service_offering.mc_rate, service_offering.ha_enabled, service_offering.limit_cpu_use, service_offering.host_tag, service_offering.default_use, service_offering.vm_type, service_offering.sort_key, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`service_offering` inner join `cloud`.`disk_offering` ON service_offering.id = disk_offering.id left join `cloud`.`domain` ON disk_offering.domain_id = domain.id
  357. 2020-02-12 12:14:59,094 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP VIEW IF EXISTS `cloud`.`data_center_view`
  358. 2020-02-12 12:14:59,095 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE VIEW `cloud`.`data_center_view` AS select data_center.id, data_center.uuid, data_center.name, data_center.is_security_group_enabled, data_center.is_local_storage_enabled, data_center.description, data_center.dns1, data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1, data_center.internal_dns2, data_center.guest_network_cidr, data_center.domain, data_center.networktype, data_center.allocation_state, data_center.zone_token, data_center.dhcp_provider, data_center.removed, domain.id domain_id, domain.uuid domain_uuid, domain.name domain_name, domain.path domain_path from `cloud`.`data_center` left join `cloud`.`domain` ON data_center.domain_id = domain.id
  359. 2020-02-12 12:14:59,109 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`baremetal_dhcp_devices` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `nsp_id` bigint unsigned DEFAULT NULL COMMENT 'Network Service Provider ID', `pod_id` bigint unsigned DEFAULT NULL COMMENT 'Pod id where this dhcp server in', `device_type` varchar(255) DEFAULT NULL COMMENT 'type of the external device', `physical_network_id` bigint unsigned DEFAULT NULL COMMENT 'id of the physical network in to which external dhcp device is added', `host_id` bigint unsigned DEFAULT NULL COMMENT 'host id coresponding to the external dhcp device', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  360. 2020-02-12 12:14:59,215 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`baremetal_pxe_devices` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `nsp_id` bigint unsigned DEFAULT NULL COMMENT 'Network Service Provider ID', `pod_id` bigint unsigned DEFAULT NULL COMMENT 'Pod id where this pxe server in, for pxe per zone this field is null', `device_type` varchar(255) DEFAULT NULL COMMENT 'type of the pxe device', `physical_network_id` bigint unsigned DEFAULT NULL COMMENT 'id of the physical network in to which external pxe device is added', `host_id` bigint unsigned DEFAULT NULL COMMENT 'host id coresponding to the external pxe device', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  361. 2020-02-12 12:14:59,332 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`ucs_blade` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `ucs_manager_id` bigint unsigned NOT NULL, `host_id` bigint unsigned DEFAULT NULL, `dn` varchar(512) NOT NULL, `profile_dn` varchar(512) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  362. 2020-02-12 12:14:59,439 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`ucs_manager` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) UNIQUE, `zone_id` bigint unsigned NOT NULL, `name` varchar(128) DEFAULT NULL, `url` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  363. 2020-02-12 12:14:59,548 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) SET foreign_key_checks = 1
  364. 2020-02-12 12:14:59,549 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`configuration` SET value='KVM,XenServer,VMware,Ovm' WHERE name='hypervisor.list'
  365. 2020-02-12 12:14:59,551 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'concurrent.snapshots.threshold.perhost' , NULL, 'Limit number of snapshots that can be handled concurrently; default is NULL - unlimited.')
  366. 2020-02-12 12:14:59,552 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network', 'DEFAULT', 'management-server', 'network.ipv6.search.retry.max' , 10000, 'The maximum number of retrying times to search for an available IPv6 address in the table')
  367. 2020-02-12 12:14:59,553 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Usage', 'DEFAULT', 'management-server', 'traffic.sentinel.exclude.zones' , '', 'Traffic going into specified list of zones is not metered')
  368. 2020-02-12 12:14:59,555 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Usage', 'DEFAULT', 'management-server', 'traffic.sentinel.include.zones' , 'EXTERNAL', 'Traffic going into specified list of zones is metered. For metering all traffic leave this parameter empty')
  369. 2020-02-12 12:14:59,556 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (163, UUID(), 10, 'Ubuntu 12.04 (32-bit)')
  370. 2020-02-12 12:14:59,557 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (164, UUID(), 10, 'Ubuntu 12.04 (64-bit)')
  371. 2020-02-12 12:14:59,558 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) DROP TABLE IF EXISTS `cloud`.`netscaler_pod_ref`
  372. 2020-02-12 12:14:59,613 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `cloud`.`netscaler_pod_ref` ( `id` bigint unsigned NOT NULL auto_increment COMMENT 'id', `external_load_balancer_device_id` bigint unsigned NOT NULL COMMENT 'id of external load balancer device', `pod_id` bigint unsigned NOT NULL COMMENT 'pod id', PRIMARY KEY (`id`), CONSTRAINT `fk_ns_pod_ref__pod_id` FOREIGN KEY (`pod_id`) REFERENCES `cloud`.`host_pod_ref`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_ns_pod_ref__device_id` FOREIGN KEY (`external_load_balancer_device_id`) REFERENCES `external_load_balancer_devices`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  373. 2020-02-12 12:14:59,733 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'eip.use.multiple.netscalers' , 'false', 'Should be set to true, if there will be multiple NetScaler devices providing EIP service in a zone')
  374. 2020-02-12 12:14:59,734 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`configuration` set category='Advanced' where category='Advanced '
  375. 2020-02-12 12:14:59,736 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`configuration` set category='Hidden' where category='Hidden '
  376. 2020-02-12 12:14:59,752 DEBUG [c.c.u.d.Upgrade40to41] (main:null) (logid:) Updating region table with Id: 1
  377. 2020-02-12 12:14:59,753 DEBUG [c.c.u.d.Upgrade40to41] (main:null) (logid:) Updating firewall Ingress rule traffic type: com.mysql.cj.jdbc.ClientPreparedStatement: update `cloud`.`firewall_rules` set traffic_type='Ingress' where purpose='Firewall' and ip_address_id is not null and traffic_type is null
  378. 2020-02-12 12:14:59,829 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:) Rolling back the transaction: Time = 17926 Name = Upgrade; called by -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-TransactionLegacy.close:657-TransactionContextInterceptor.invoke:36-ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.invoke:92-ReflectiveMethodInvocation.proceed:185-JdkDynamicAopProxy.invoke:212-$Proxy30.persist:-1-DatabaseUpgradeChecker.upgrade:259-DatabaseUpgradeChecker.check:336-CloudStackExtendedLifeCycle.checkIntegrity:65
  379. 2020-02-12 12:14:59,864 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to upgrade the database
  380. com.cloud.utils.exception.CloudRuntimeException: Problem with getting the ec attribute
  381. at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1454)
  382. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  383. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  384. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  385. at java.lang.reflect.Method.invoke(Method.java:498)
  386. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338)
  387. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
  388. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  389. at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)
  390. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
  391. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  392. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  393. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  394. at com.sun.proxy.$Proxy30.persist(Unknown Source)
  395. at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:259)
  396. at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336)
  397. at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
  398. at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55)
  399. at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:183)
  400. at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52)
  401. at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358)
  402. at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159)
  403. at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
  404. at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884)
  405. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
  406. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)
  407. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
  408. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
  409. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
  410. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
  411. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)
  412. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
  413. at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
  414. at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
  415. at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
  416. at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
  417. at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
  418. at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890)
  419. at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532)
  420. at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853)
  421. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344)
  422. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515)
  423. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477)
  424. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785)
  425. at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261)
  426. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545)
  427. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  428. at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
  429. at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
  430. at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
  431. at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273)
  432. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  433. at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
  434. at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115)
  435. at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
  436. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  437. at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
  438. at org.eclipse.jetty.server.Server.start(Server.java:418)
  439. at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
  440. at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
  441. at org.eclipse.jetty.server.Server.doStart(Server.java:385)
  442. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  443. at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:186)
  444. at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:103)
  445. Caused by: java.lang.IllegalArgumentException: Can not set long field com.cloud.upgrade.dao.VersionVO.id to java.math.BigInteger
  446. at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
  447. at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
  448. at sun.reflect.UnsafeLongFieldAccessorImpl.set(UnsafeLongFieldAccessorImpl.java:102)
  449. ... 65 more
  450. 2020-02-12 12:14:59,888 WARN [o.a.c.s.m.c.ResourceApplicationContext] (main:null) (logid:) Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Failed to start bean 'cloudStackLifeCycle'; nested exception is com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
  451. 2020-02-12 12:14:59,889 WARN [o.e.j.w.WebAppContext] (main:null) (logid:) Failed startup of context o.e.j.w.WebAppContext@6e38921c{/client,file:///usr/share/cloudstack-management/webapp/,UNAVAILABLE}{/usr/share/cloudstack-management/webapp}
  452. org.springframework.context.ApplicationContextException: Failed to start bean 'cloudStackLifeCycle'; nested exception is com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
  453. at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:186)
  454. at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52)
  455. at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358)
  456. at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159)
  457. at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
  458. at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884)
  459. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
  460. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)
  461. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
  462. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
  463. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
  464. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
  465. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)
  466. at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
  467. at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
  468. at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
  469. at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
  470. at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
  471. at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
  472. at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890)
  473. at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532)
  474. at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853)
  475. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344)
  476. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515)
  477. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477)
  478. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785)
  479. at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261)
  480. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545)
  481. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  482. at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
  483. at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
  484. at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
  485. at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273)
  486. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  487. at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
  488. at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115)
  489. at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
  490. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  491. at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
  492. at org.eclipse.jetty.server.Server.start(Server.java:418)
  493. at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
  494. at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
  495. at org.eclipse.jetty.server.Server.doStart(Server.java:385)
  496. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  497. at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:186)
  498. at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:103)
  499. Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
  500. at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:265)
  501. at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:336)
  502. at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
  503. ... 47 more
  504. Caused by: com.cloud.utils.exception.CloudRuntimeException: Problem with getting the ec attribute
  505. at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1454)
  506. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  507. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  508. ... 61 more
  509. Caused by: java.lang.IllegalArgumentException: Can not set long field com.cloud.upgrade.dao.VersionVO.id to java.math.BigInteger
  510. at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
  511. at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
  512. at sun.reflect.UnsafeLongFieldAccessorImpl.set(UnsafeLongFieldAccessorImpl.java:102)
  513. ... 65 more
  514. 2020-02-12 12:14:59,891 INFO [o.e.j.s.h.ContextHandler] (main:null) (logid:) Started o.e.j.s.h.MovedContextHandler@6e2c9341{/,null,AVAILABLE}
  515. 2020-02-12 12:15:00,040 INFO [o.e.j.s.AbstractConnector] (main:null) (logid:) Started ServerConnector@51e2adc7{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
  516. 2020-02-12 12:15:00,040 INFO [o.e.j.s.Server] (main:null) (logid:) Started @39164ms
  517. 2020-02-12 12:43:16,272 INFO [o.e.j.s.AbstractConnector] (Thread-1:null) (logid:) Stopped ServerConnector@51e2adc7{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
  518. 2020-02-12 12:43:16,282 INFO [o.e.j.s.session] (Thread-1:null) (logid:) Stopped scavenging
  519. 2020-02-12 12:43:16,282 INFO [o.e.j.s.h.ContextHandler] (Thread-1:null) (logid:) Stopped o.e.j.s.h.MovedContextHandler@6e2c9341{/,null,UNAVAILABLE}
  520. 2020-02-12 12:43:16,285 INFO [o.e.j.s.h.ContextHandler] (Thread-1:null) (logid:) Stopped o.e.j.w.WebAppContext@6e38921c{/client,null,UNAVAILABLE}{/usr/share/cloudstack-management/webapp}
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!