cloudstack-setup-databases takes more than 5 minutes to complete

[abdelouahabb]

I tried a fresh ubuntu server 20.04.2 with virt-manager 2.2.1 and cloudstack 4.15.0 downloaded from deb http://packages.shapeblue.com/cloudstack/upstream/debian/4.15 /

root@alien:~# cat /etc/os-release 
NAME="Ubuntu"
VERSION="20.04.2 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.2 LTS"
VERSION_ID="20.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=focal
UBUNTU_CODENAME=focal

I have an issue with database :
My network

root@alien:~# cat /etc/network/interfaces
auto lo
iface lo inet loopback

auto enp1s0
iface enp1s0 inet manual
auto cloudbr0
iface cloudbr0 inet static
address 192.168.122.10
netmask 255.255.255.0
gateway 192.168.122.1
dns-nameservers 8.8.8.8 1.1.1.1
bridge_ports enp1s0
bridge_fd 0
bridge_stp off

When I run the command :
root@alien:~# time cloudstack-setup-databases cloud:cloud@localhost --deploy-as=root:mypassword -i 192.168.122.10
Takes forver at Applying /usr/share/cloudstack-management/setup/create-schema.sql
Here is the full time taken

real	5m24.192s
user	0m1.659s
sys	0m0.273s

Files have been created :

ls /var/lib/mysql/cloud/ | wc -l
136

The /etc/cloudstack/management/db.properties has been successfully created but still not able to make it work, here is the error :

Mar  9 22:05:02 alien java[1222]: WARN  [utils.nio.NioConnection] (main:) (logid:) Unable to connect to remote: is there a server running on port 8250
Mar  9 22:05:03 alien systemd[1]: cloudstack-usage.service: Scheduled restart job, restart counter is at 27.
Mar  9 22:05:03 alien systemd[1]: Stopped CloudStack Usage Server.
Mar  9 22:05:03 alien systemd[1]: Started CloudStack Usage Server.
Mar  9 22:05:04 alien sh[3164]: log4j:WARN No appenders could be found for logger (com.cloud.utils.LogUtils).
Mar  9 22:05:04 alien sh[3164]: log4j:WARN Please initialize the log4j system properly.
Mar  9 22:05:04 alien sh[3164]: log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Mar  9 22:05:04 alien sh[3164]: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
Mar  9 22:05:04 alien sh[3164]: SLF4J: Defaulting to no-operation (NOP) logger implementation
Mar  9 22:05:04 alien sh[3164]: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Mar  9 22:05:05 alien sh[3164]: WARNING: An illegal reflective access operation has occurred
Mar  9 22:05:05 alien sh[3164]: WARNING: Illegal reflective access by net.sf.cglib.core.ReflectUtils$1 (file:/usr/share/cloudstack-usage/lib/cglib-nodep-3.3.0.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain)
Mar  9 22:05:05 alien sh[3164]: WARNING: Please consider reporting this to the maintainers of net.sf.cglib.core.ReflectUtils$1
Mar  9 22:05:05 alien sh[3164]: WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
Mar  9 22:05:05 alien sh[3164]: WARNING: All illegal access operations will be denied in a future release
Mar  9 22:05:06 alien sh[3164]: 22:05:06,416  INFO Transaction:1027 - Is Data Base High Availiability enabled? Ans : false
Mar  9 22:05:06 alien sh[3164]: 22:05:06,457  WARN Transaction:1140 - Unable to load db configuration, using defaults with 5 connections. Falling back on assumed datasource on localhost:3306 using username:password=cloud:cloud. Please check your configuration
Mar  9 22:05:06 alien sh[3164]: java.lang.NumberFormatException: null
Mar  9 22:05:06 alien sh[3164]: #011at java.base/java.lang.Integer.parseInt(Integer.java:614)
Mar  9 22:05:06 alien sh[3164]: #011at java.base/java.lang.Integer.parseInt(Integer.java:770)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.utils.db.TransactionLegacy.initDataSource(TransactionLegacy.java:1030)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.utils.db.TransactionLegacy.<clinit>(TransactionLegacy.java:1008)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.utils.db.TransactionContextBuilder.interceptStart(TransactionContextBuilder.java:49)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:116)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_31632a03.createPartialSelectSql(<generated>)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.utils.db.GenericDaoBase.<init>(GenericDaoBase.java:238)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.usage.dao.UsageDaoImpl.<init>(UsageDaoImpl.java:76)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_31632a03.<init>(<generated>)
Mar  9 22:05:06 alien sh[3164]: #011at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
Mar  9 22:05:06 alien sh[3164]: #011at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
Mar  9 22:05:06 alien sh[3164]: #011at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
Mar  9 22:05:06 alien sh[3164]: #011at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
Mar  9 22:05:06 alien sh[3164]: #011at net.sf.cglib.core.ReflectUtils.newInstance(ReflectUtils.java:291)
Mar  9 22:05:06 alien sh[3164]: #011at net.sf.cglib.proxy.Enhancer$EnhancerFactoryData.newInstance(Enhancer.java:448)
Mar  9 22:05:06 alien sh[3164]: #011at net.sf.cglib.proxy.Enhancer.nextInstance(Enhancer.java:700)
Mar  9 22:05:06 alien sh[3164]: #011at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:298)
Mar  9 22:05:06 alien sh[3164]: #011at net.sf.cglib.proxy.Enhancer.createHelper(Enhancer.java:480)
Mar  9 22:05:06 alien sh[3164]: #011at net.sf.cglib.proxy.Enhancer.create(Enhancer.java:305)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.utils.component.ComponentInstantiationPostProcessor.postProcessBeforeInstantiation(ComponentInstantiationPostProcessor.java:92)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1141)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:1114)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:506)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1287)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1207)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:116)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1422)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:144)
Mar  9 22:05:06 alien sh[3164]: #011at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:85)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.usage.UsageServer.start(UsageServer.java:52)
Mar  9 22:05:06 alien sh[3164]: #011at com.cloud.usage.UsageServer.main(UsageServer.java:41)
Mar  9 22:05:07 alien java[1222]: INFO  [cloud.agent.Agent] (main:) (logid:) Connecting to host:192.168.122.10
Mar  9 22:05:07 alien java[1222]: INFO  [utils.nio.NioClient] (main:) (logid:) Connecting to 192.168.122.10:8250
Mar  9 22:05:07 alien java[1222]: WARN  [utils.nio.NioConnection] (main:) (logid:) Unable to connect to remote: is there a server running on port 8250
Mar  9 22:05:08 alien sh[3164]: 22:05:08,233  INFO ComponentContext:59 - Setup Spring Application context
Mar  9 22:05:09 alien sh[3164]: 22:05:09,174  INFO ComponentContext:108 - Configuring org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_3966e10a
Mar  9 22:05:09 alien sh[3164]: 22:05:09,174  INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserStatsLogDaoImpl_EnhancerByCloudStack_c730c2f4
Mar  9 22:05:09 alien sh[3164]: 22:05:09,175  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMSnapshotDaoImpl_EnhancerByCloudStack_439c6570
Mar  9 22:05:09 alien sh[3164]: 22:05:09,175  INFO ComponentContext:108 - Configuring com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_2ab6cf7e
Mar  9 22:05:09 alien sh[3164]: 22:05:09,181  INFO ComponentContext:108 - Configuring com.cloud.domain.dao.DomainDaoImpl_EnhancerByCloudStack_ba34f021
Mar  9 22:05:09 alien sh[3164]: 22:05:09,181  INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.UserVmDetailsDaoImpl_EnhancerByCloudStack_31f63b4
Mar  9 22:05:09 alien sh[3164]: 22:05:09,183  INFO ComponentContext:108 - Configuring com.cloud.user.dao.SSHKeyPairDaoImpl_EnhancerByCloudStack_1d1a062b
Mar  9 22:05:09 alien sh[3164]: 22:05:09,183  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVmDiskDaoImpl_EnhancerByCloudStack_2830244f
Mar  9 22:05:09 alien sh[3164]: 22:05:09,186  INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserStatisticsDaoImpl_EnhancerByCloudStack_44c200c6
Mar  9 22:05:09 alien sh[3164]: 22:05:09,187  INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaUsageDaoImpl_EnhancerByCloudStack_741af85
Mar  9 22:05:09 alien sh[3164]: 22:05:09,188  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVPNUserDaoImpl_EnhancerByCloudStack_1a07e970
Mar  9 22:05:09 alien sh[3164]: 22:05:09,193  INFO ComponentContext:108 - Configuring com.cloud.event.dao.EventDaoImpl_EnhancerByCloudStack_e8aed401
Mar  9 22:05:09 alien sh[3164]: 22:05:09,194  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageLoadBalancerPolicyDaoImpl_EnhancerByCloudStack_599c0b45
Mar  9 22:05:09 alien sh[3164]: 22:05:09,196  INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserAccountDaoImpl_EnhancerByCloudStack_73812ef4
Mar  9 22:05:09 alien sh[3164]: 22:05:09,197  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageStorageDaoImpl_EnhancerByCloudStack_bd8bc874
Mar  9 22:05:09 alien sh[3164]: 22:05:09,198  INFO ComponentContext:108 - Configuring com.cloud.configuration.dao.ResourceCountDaoImpl_EnhancerByCloudStack_c67102e6
Mar  9 22:05:09 alien sh[3164]: 22:05:09,199  INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaBalanceDaoImpl_EnhancerByCloudStack_c1f3f592
Mar  9 22:05:09 alien sh[3164]: 22:05:09,200  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMInstanceDaoImpl_EnhancerByCloudStack_28323237
Mar  9 22:05:09 alien sh[3164]: 22:05:09,200  INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaEmailTemplatesDaoImpl_EnhancerByCloudStack_23a9bad7
Mar  9 22:05:09 alien sh[3164]: 22:05:09,201  INFO ComponentContext:108 - Configuring com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_dff31831
Mar  9 22:05:09 alien sh[3164]: 22:05:09,203  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageJobDaoImpl_EnhancerByCloudStack_6ad49e62
Mar  9 22:05:09 alien sh[3164]: 22:05:09,204  INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaTariffDaoImpl_EnhancerByCloudStack_f27bfb58
Mar  9 22:05:09 alien sh[3164]: 22:05:09,205  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.ExternalPublicIpStatisticsDaoImpl_EnhancerByCloudStack_e83e9ad0
Mar  9 22:05:09 alien sh[3164]: 22:05:09,206  INFO ComponentContext:108 - Configuring com.cloud.event.dao.UsageEventDetailsDaoImpl_EnhancerByCloudStack_8d74f57a
Mar  9 22:05:09 alien sh[3164]: 22:05:09,206  INFO ComponentContext:108 - Configuring com.cloud.configuration.dao.ResourceLimitDaoImpl_EnhancerByCloudStack_e033685a
Mar  9 22:05:09 alien sh[3164]: 22:05:09,207  INFO ComponentContext:108 - Configuring com.cloud.alert.dao.AlertDaoImpl_EnhancerByCloudStack_67c4995d
Mar  9 22:05:09 alien sh[3164]: 22:05:09,207  INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.ServiceOfferingDaoImpl_EnhancerByCloudStack_59755aa1
Mar  9 22:05:09 alien sh[3164]: 22:05:09,210  INFO ComponentContext:108 - Configuring com.cloud.user.dao.VmDiskStatisticsDaoImpl_EnhancerByCloudStack_32bfd0f5
Mar  9 22:05:09 alien sh[3164]: 22:05:09,211  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsagePortForwardingRuleDaoImpl_EnhancerByCloudStack_2681b259
Mar  9 22:05:09 alien sh[3164]: 22:05:09,211  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageNetworkDaoImpl_EnhancerByCloudStack_c73de189
Mar  9 22:05:09 alien sh[3164]: 22:05:09,212  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVolumeDaoImpl_EnhancerByCloudStack_85e7db9
Mar  9 22:05:09 alien sh[3164]: 22:05:09,212  INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserDaoImpl_EnhancerByCloudStack_80ad52c1
Mar  9 22:05:09 alien sh[3164]: 22:05:09,213  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageNetworkOfferingDaoImpl_EnhancerByCloudStack_b9887cf3
Mar  9 22:05:09 alien sh[3164]: 22:05:09,213  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMSnapshotOnPrimaryDaoImpl_EnhancerByCloudStack_43a32a3f
Mar  9 22:05:09 alien sh[3164]: 22:05:09,213  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageBackupDaoImpl_EnhancerByCloudStack_c0b08ed1
Mar  9 22:05:09 alien sh[3164]: 22:05:09,214  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageSecurityGroupDaoImpl_EnhancerByCloudStack_f2db31b0
Mar  9 22:05:09 alien sh[3164]: 22:05:09,214  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageIPAddressDaoImpl_EnhancerByCloudStack_e5a66432
Mar  9 22:05:09 alien sh[3164]: 22:05:09,215  INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaAccountDaoImpl_EnhancerByCloudStack_2cff11d9
Mar  9 22:05:09 alien sh[3164]: 22:05:09,216  INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaCreditsDaoImpl_EnhancerByCloudStack_dd12e9a4
Mar  9 22:05:09 alien sh[3164]: 22:05:09,216  INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_31632a03
Mar  9 22:05:09 alien sh[3164]: 22:05:09,218  INFO ComponentContext:108 - Configuring com.cloud.usage.UsageManagerImpl_EnhancerByCloudStack_c4d027a
Mar  9 22:05:09 alien sh[3164]: 22:05:09,219  INFO UsageManagerImpl:208 - Implementation Version is 4.15.0.0
Mar  9 22:05:10 alien sh[3164]: 22:05:10,528 ERROR UsageManagerImpl:236 - missing configuration values for usage job, usage.stats.job.exec.time = null, usage.stats.job.aggregation.range = null
Mar  9 22:05:10 alien sh[3164]: 22:05:10,529 ERROR UsageManagerImpl:278 - Unhandled exception configuring UsageManger
Mar  9 22:05:10 alien sh[3164]: javax.naming.ConfigurationException: Missing configuration values for usage job, usage.stats.job.exec.time = null, usage.stats.job.aggregation.range = null
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageManagerImpl.configure(UsageManagerImpl.java:238)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageServer.start(UsageServer.java:54)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageServer.main(UsageServer.java:41)
Mar  9 22:05:10 alien sh[3164]: 22:05:10,530 ERROR ComponentContext:118 - Unhandled exception
Mar  9 22:05:10 alien sh[3164]: javax.naming.ConfigurationException: Unhandled exception configuring UsageManager javax.naming.ConfigurationException: Missing configuration values for usage job, usage.stats.job.exec.time = null, usage.stats.job.aggregation.range = null
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageManagerImpl.configure(UsageManagerImpl.java:279)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageServer.start(UsageServer.java:54)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageServer.main(UsageServer.java:41)
Mar  9 22:05:10 alien sh[3164]: Exception in thread "main" java.lang.RuntimeException: Unable to configure com.cloud.usage.UsageManagerImpl_EnhancerByCloudStack_c4d027a
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:119)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageServer.start(UsageServer.java:54)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageServer.main(UsageServer.java:41)
Mar  9 22:05:10 alien sh[3164]: Caused by: javax.naming.ConfigurationException: Unhandled exception configuring UsageManager javax.naming.ConfigurationException: Missing configuration values for usage job, usage.stats.job.exec.time = null, usage.stats.job.aggregation.range = null
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.usage.UsageManagerImpl.configure(UsageManagerImpl.java:279)
Mar  9 22:05:10 alien sh[3164]: #011at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116)
Mar  9 22:05:10 alien sh[3164]: #011... 2 more
Mar  9 22:05:10 alien systemd[1]: cloudstack-usage.service: Main process exited, code=exited, status=1/FAILURE
Mar  9 22:05:10 alien systemd[1]: cloudstack-usage.service: Failed with result 'exit-code'.
Mar  9 22:05:12 alien java[1222]: INFO  [cloud.agent.Agent] (main:) (logid:) Connecting to host:192.168.122.10
Mar  9 22:05:12 alien java[1222]: INFO  [utils.nio.NioClient] (main:) (logid:) Connecting to 192.168.122.10:8250
Mar  9 22:05:12 alien java[1222]: WARN  [utils.nio.NioConnection] (main:) (logid:) Unable to connect to remote: is there a server running on port 8250
Mar  9 22:05:16 alien ntpd[1042]: Soliciting pool server 2001:67c:1560:8003::c7
Mar  9 22:05:17 alien java[1222]: INFO  [cloud.agent.Agent] (main:) (logid:) Connecting to host:192.168.122.10
Mar  9 22:05:17 alien java[1222]: INFO  [utils.nio.NioClient] (main:) (logid:) Connecting to 192.168.122.10:8250
Mar  9 22:05:17 alien java[1222]: WARN  [utils.nio.NioConnection] (main:) (logid:) Unable to connect to remote: is there a server running on port 8250
Mar  9 22:05:20 alien systemd[1]: cloudstack-usage.service: Scheduled restart job, restart counter is at 28.
Mar  9 22:05:20 alien systemd[1]: Stopped CloudStack Usage Server.
Mar  9 22:05:20 alien systemd[1]: Started CloudStack Usage Server.

Here is my specs :

root@alien:~# kvm-ok 
INFO: /dev/kvm exists
KVM acceleration can be used
root@alien:~# lshw -short
H/W path          Device      Class          Description
========================================================
                              system         Standard PC (Q35 + ICH9, 2009)
/0                            bus            Motherboard
/0/0                          memory         96KiB BIOS
/0/400                        processor      Intel Xeon E312xx (Sandy Bridge, IBRS update)
/0/401                        processor      Intel Xeon E312xx (Sandy Bridge, IBRS update)
/0/1000                       memory         8100MiB System Memory
/0/1000/0                     memory         8100MiB DIMM RAM
/0/100                        bridge         82G33/G31/P35/P31 Express DRAM Controller
/0/100/1                      display        QXL paravirtual graphic card
/0/100/2                      bridge         QEMU PCIe Root port
/0/100/2/0                    network        Virtio network device
/0/100/2/0/0      enp1s0      network        Ethernet interface
/0/100/2.1                    bridge         QEMU PCIe Root port
/0/100/2.1/0                  communication  Virtio console
/0/100/2.1/0/0                generic        Virtual I/O device
/0/100/2.2                    bridge         QEMU PCIe Root port
/0/100/2.2/0                  storage        Virtio block device
/0/100/2.2/0/0    /dev/vda    disk           53GB Virtual I/O device
/0/100/2.2/0/0/1  /dev/vda1   volume         1023KiB BIOS Boot partition
/0/100/2.2/0/0/2  /dev/vda2   volume         1GiB EXT4 volume
/0/100/2.2/0/0/3  /dev/vda3   volume         48GiB EFI partition
/0/100/2.3                    bridge         QEMU PCIe Root port
/0/100/2.3/0                  generic        Virtio memory balloon
/0/100/2.3/0/0                generic        Virtual I/O device
/0/100/2.4                    bridge         QEMU PCIe Root port
/0/100/2.4/0                  generic        Virtio RNG
/0/100/2.4/0/0                generic        Virtual I/O device
/0/100/2.5                    bridge         QEMU PCIe Root port
/0/100/1b                     multimedia     82801I (ICH9 Family) HD Audio Controller
/0/100/1d                     bus            82801I (ICH9 Family) USB UHCI Controller #1
/0/100/1d/1       usb2        bus            UHCI Host Controller
/0/100/1d.1                   bus            82801I (ICH9 Family) USB UHCI Controller #2
/0/100/1d.1/1     usb3        bus            UHCI Host Controller
/0/100/1d.2                   bus            82801I (ICH9 Family) USB UHCI Controller #3
/0/100/1d.2/1     usb4        bus            UHCI Host Controller
/0/100/1d.7                   bus            82801I (ICH9 Family) USB2 EHCI Controller #1
/0/100/1d.7/1     usb1        bus            EHCI Host Controller
/0/100/1d.7/1/1               input          QEMU USB Tablet
/0/100/1f                     bridge         82801IB (ICH9) LPC Interface Controller
/0/100/1f.2                   storage        82801IR/IO/IH (ICH9R/DO/DH) 6 port SATA Controller [AHCI mode]
/0/100/1f.3                   bus            82801I (ICH9 Family) SMBus Controller
/0/1                          system         PnP device PNP0b00
/0/2                          input          PnP device PNP0303
/0/3                          input          PnP device PNP0f13
/0/4                          communication  PnP device PNP0501
/0/5              scsi0       storage        
/0/5/0.0.0        /dev/cdrom  disk           QEMU DVD-ROM

[weizhouapache]

@abdelouahabb

open /etc/java-11-openjdk/security/java.security and change the following line

securerandom.source=file:/dev/urandom

[yadvr]

@abdelouahabb I think you're using a nested env which is slow and lacks entropy, installing/using haveged and the urandom workaround that Wei has proposed will speed things.

[abdelouahabb]

@weizhouapache same thing !
@rhtyd same result, and I have the /usr/sbin/haveged installed,
Tried on Windows with both virtualbox and vmware and never had this result, it was fast, the issue is not only about being slow but this is like the configuration is not being read like it dont exist even if it is there and filled with all the parameters ?
I hope someone else verifies using virt-manager (qemu + kvm) on Ubuntu 20.04
Edit : I tried to execute the files independly, here is the results (lot of warnings...) :

mysql> source /usr/share/cloudstack-management/setup/create-database.sql;
Query OK, 0 rows affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.14 sec)
Query OK, 0 rows affected (0.13 sec)
Query OK, 0 rows affected (0.16 sec)
Query OK, 0 rows affected, 1 warning (0.17 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.12 sec)
Query OK, 0 rows affected (0.28 sec)
Query OK, 1 row affected (0.14 sec)
Query OK, 0 rows affected (0.09 sec)
Query OK, 0 rows affected (0.10 sec)
Query OK, 0 rows affected (0.32 sec)
Query OK, 0 rows affected (0.14 sec)
Query OK, 0 rows affected (0.12 sec)
Query OK, 0 rows affected (0.10 sec)
Query OK, 0 rows affected (0.00 sec)


mysql> source /usr/share/cloudstack-management/setup/create-schema.sql;
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.07 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.85 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 0 rows affected, 1 warning (2.05 sec)
Query OK, 0 rows affected, 1 warning (0.80 sec)
Query OK, 0 rows affected, 3 warnings (1.90 sec)
Query OK, 0 rows affected, 2 warnings (0.77 sec)
Query OK, 0 rows affected, 2 warnings (1.65 sec)
Query OK, 0 rows affected, 12 warnings (1.24 sec)
Query OK, 0 rows affected, 1 warning (1.94 sec)
Query OK, 0 rows affected, 1 warning (0.77 sec)
Query OK, 0 rows affected, 1 warning (0.67 sec)
Query OK, 0 rows affected, 1 warning (0.11 sec)
Query OK, 0 rows affected, 1 warning (1.23 sec)
Query OK, 0 rows affected, 2 warnings (1.60 sec)
Query OK, 0 rows affected, 1 warning (0.73 sec)
Query OK, 1 row affected (0.07 sec)
Query OK, 1 row affected (0.16 sec)
Query OK, 1 row affected (0.14 sec)
Query OK, 1 row affected (0.07 sec)
Query OK, 1 row affected (0.11 sec)
Query OK, 1 row affected (0.14 sec)
Query OK, 1 row affected (0.11 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 1 row affected (0.10 sec)
Query OK, 0 rows affected, 2 warnings (2.15 sec)
Query OK, 0 rows affected, 2 warnings (2.15 sec)
Query OK, 0 rows affected, 1 warning (1.29 sec)
Query OK, 0 rows affected, 1 warning (1.08 sec)
Query OK, 0 rows affected, 1 warning (1.12 sec)
Query OK, 0 rows affected, 1 warning (1.48 sec)
Query OK, 0 rows affected, 1 warning (1.39 sec)
Query OK, 0 rows affected, 1 warning (1.08 sec)
Query OK, 0 rows affected, 1 warning (1.27 sec)
Query OK, 0 rows affected, 1 warning (0.72 sec)
Query OK, 0 rows affected, 1 warning (1.92 sec)
Query OK, 0 rows affected, 1 warning (1.26 sec)
Query OK, 0 rows affected, 5 warnings (1.83 sec)
Query OK, 0 rows affected, 3 warnings (0.85 sec)
Query OK, 0 rows affected, 3 warnings (0.50 sec)
Query OK, 0 rows affected, 2 warnings (0.92 sec)
Query OK, 0 rows affected, 2 warnings (0.78 sec)
Query OK, 0 rows affected, 1 warning (0.96 sec)
Query OK, 0 rows affected, 3 warnings (0.75 sec)
Query OK, 0 rows affected, 7 warnings (2.24 sec)
Query OK, 0 rows affected, 1 warning (0.80 sec)
Query OK, 0 rows affected, 1 warning (0.67 sec)
Query OK, 0 rows affected, 1 warning (0.66 sec)
Query OK, 0 rows affected, 1 warning (1.02 sec)
Query OK, 0 rows affected, 1 warning (0.97 sec)
Query OK, 0 rows affected, 1 warning (0.73 sec)
Query OK, 0 rows affected, 1 warning (1.38 sec)
Query OK, 0 rows affected, 1 warning (1.71 sec)
Query OK, 0 rows affected, 4 warnings (2.69 sec)
Query OK, 0 rows affected, 1 warning (1.26 sec)
Query OK, 0 rows affected, 12 warnings (1.13 sec)
Query OK, 0 rows affected, 1 warning (0.69 sec)
Query OK, 0 rows affected, 3 warnings (3.17 sec)
Query OK, 0 rows affected, 2 warnings (0.83 sec)
Query OK, 0 rows affected, 1 warning (0.60 sec)
Query OK, 0 rows affected, 5 warnings (1.13 sec)
Query OK, 0 rows affected, 2 warnings (0.93 sec)
Query OK, 0 rows affected, 4 warnings (0.98 sec)
Query OK, 0 rows affected, 3 warnings (1.17 sec)
Query OK, 0 rows affected, 1 warning (1.05 sec)
Query OK, 0 rows affected, 1 warning (0.99 sec)
Query OK, 0 rows affected, 2 warnings (0.98 sec)
Query OK, 0 rows affected, 1 warning (1.03 sec)
Query OK, 0 rows affected, 3 warnings (1.39 sec)
Query OK, 0 rows affected, 3 warnings (2.09 sec)
Query OK, 0 rows affected, 1 warning (1.19 sec)
Query OK, 0 rows affected, 1 warning (1.63 sec)
Query OK, 0 rows affected, 2 warnings (1.37 sec)
Query OK, 0 rows affected, 3 warnings (1.02 sec)
Query OK, 0 rows affected, 6 warnings (2.04 sec)
Query OK, 0 rows affected, 1 warning (1.39 sec)
Query OK, 0 rows affected, 1 warning (1.20 sec)
Query OK, 0 rows affected, 1 warning (1.41 sec)
Query OK, 0 rows affected, 6 warnings (1.34 sec)
Query OK, 0 rows affected, 7 warnings (1.10 sec)
Query OK, 0 rows affected, 1 warning (0.57 sec)
Query OK, 0 rows affected, 1 warning (1.50 sec)
Query OK, 0 rows affected, 1 warning (1.58 sec)
Query OK, 0 rows affected, 1 warning (1.81 sec)
Query OK, 0 rows affected, 1 warning (1.62 sec)
Query OK, 0 rows affected, 1 warning (1.24 sec)
Query OK, 0 rows affected, 3 warnings (1.14 sec)
Query OK, 0 rows affected, 1 warning (1.16 sec)
Query OK, 0 rows affected, 1 warning (0.75 sec)
Query OK, 0 rows affected, 1 warning (0.81 sec)
Query OK, 0 rows affected, 2 warnings (0.73 sec)
Query OK, 1 row affected (0.19 sec)
Query OK, 1 row affected (0.14 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 1 row affected (0.12 sec)
Query OK, 1 row affected (0.09 sec)
Query OK, 1 row affected (0.20 sec)
Query OK, 1 row affected (0.15 sec)
Query OK, 1 row affected (0.41 sec)
Query OK, 1 row affected (0.24 sec)
Query OK, 1 row affected (0.06 sec)
Query OK, 1 row affected (0.15 sec)
Query OK, 1 row affected (0.16 sec)
Query OK, 1 row affected (0.19 sec)
Query OK, 1 row affected (0.09 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 0 rows affected, 1 warning (2.19 sec)
Query OK, 0 rows affected, 4 warnings (1.18 sec)
Query OK, 0 rows affected, 1 warning (2.75 sec)
Query OK, 0 rows affected, 1 warning (0.75 sec)
Query OK, 0 rows affected, 1 warning (1.35 sec)
Query OK, 0 rows affected, 1 warning (1.82 sec)
Query OK, 0 rows affected, 1 warning (1.18 sec)
Query OK, 0 rows affected, 1 warning (0.10 sec)
Query OK, 0 rows affected, 1 warning (0.96 sec)
Query OK, 0 rows affected, 1 warning (1.48 sec)
Query OK, 0 rows affected, 1 warning (0.89 sec)
Query OK, 0 rows affected, 1 warning (2.04 sec)
Query OK, 0 rows affected, 1 warning (0.68 sec)
Query OK, 0 rows affected, 1 warning (0.63 sec)
Query OK, 1 row affected (0.24 sec)
Query OK, 0 rows affected, 1 warning (1.06 sec)
Query OK, 1 row affected (0.10 sec)
Query OK, 0 rows affected, 1 warning (1.00 sec)
Query OK, 0 rows affected, 1 warning (0.94 sec)
Query OK, 0 rows affected, 2 warnings (1.10 sec)
Query OK, 0 rows affected, 1 warning (1.02 sec)
Query OK, 0 rows affected, 1 warning (1.10 sec)
Query OK, 0 rows affected, 1 warning (0.76 sec)
Query OK, 0 rows affected, 1 warning (1.99 sec)
Query OK, 0 rows affected, 1 warning (1.13 sec)
Query OK, 0 rows affected, 1 warning (1.52 sec)
Query OK, 0 rows affected, 1 warning (2.08 sec)
Query OK, 0 rows affected, 1 warning (1.86 sec)
Query OK, 0 rows affected, 1 warning (0.74 sec)
Query OK, 0 rows affected, 1 warning (0.82 sec)
Query OK, 0 rows affected, 1 warning (1.58 sec)
Query OK, 0 rows affected, 1 warning (0.89 sec)
Query OK, 0 rows affected, 1 warning (1.18 sec)
Query OK, 0 rows affected, 1 warning (1.01 sec)
Query OK, 0 rows affected, 13 warnings (1.03 sec)
Query OK, 0 rows affected, 4 warnings (1.03 sec)
Query OK, 0 rows affected, 2 warnings (1.22 sec)
Query OK, 0 rows affected, 1 warning (1.16 sec)
Query OK, 0 rows affected, 1 warning (1.53 sec)
Query OK, 0 rows affected, 2 warnings (1.23 sec)
Query OK, 0 rows affected, 1 warning (1.14 sec)
Query OK, 0 rows affected, 1 warning (1.00 sec)
Query OK, 0 rows affected, 5 warnings (0.72 sec)
Query OK, 0 rows affected, 1 warning (0.85 sec)
Query OK, 0 rows affected, 1 warning (2.02 sec)
Query OK, 0 rows affected, 2 warnings (1.17 sec)
Query OK, 0 rows affected, 1 warning (1.77 sec)
Query OK, 0 rows affected, 1 warning (1.35 sec)
Query OK, 0 rows affected, 2 warnings (1.69 sec)
Query OK, 0 rows affected, 2 warnings (1.63 sec)
Query OK, 0 rows affected, 1 warning (0.83 sec)
Query OK, 0 rows affected, 1 warning (1.25 sec)
Query OK, 0 rows affected, 1 warning (2.78 sec)
Query OK, 0 rows affected, 1 warning (1.20 sec)
Query OK, 0 rows affected, 1 warning (1.59 sec)
Query OK, 0 rows affected, 1 warning (1.73 sec)
Query OK, 0 rows affected, 1 warning (1.38 sec)
Query OK, 0 rows affected, 1 warning (1.00 sec)
Query OK, 0 rows affected (0.00 sec)

[weizhouapache]

@weizhouapache same thing !
@rhtyd same result, and I have the /usr/sbin/haveged installed,
Tried on Windows with both virtualbox and vmware and never had this result, it was fast, the issue is not only about being slow but this is like the configuration is not being read like it dont exist even if it is there and filled with all the parameters ?
I hope someone else verifies using virt-manager (qemu + kvm) on Ubuntu 20.04

@abdelouahabb I used ubuntu 20.04 as mgt server some days ago.
I had the same issue and it was fixed by the change I mentioned above.
ps: If you use openjdk14 as default, you need to change the java.security for openjdk14, not the file I mentioned.

Edit : I tried to execute the files independly, here is the results (lot of warnings...) :

mysql> source /usr/share/cloudstack-management/setup/create-database.sql;
Query OK, 0 rows affected (0.00 sec)

@abdelouahabb if you have created the db, you should not execute the sql again.

[abdelouahabb]

@weizhouapache
I reinstalled openjdk 14 and same lag, for the mysql, I tried to get deeper logs about the fact it is too slow, I enabled the warnings and here is some of warnings I get, maybe this is due to mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)) which is the default and not the version 5 which was long ago default with ubuntu ?

mysql> \W
Show warnings enabled.
mysql> source /usr/share/cloudstack-management/setup/create-database.sql;

Query OK, 0 rows affected, 1 warning (0.09 sec)

Note (Code 1305): PROCEDURE mysql.cloud_drop_users_if_exists does not exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.03 sec)
Note (Code 1008): Can't drop database 'billing'; database doesn't exist
Query OK, 0 rows affected (0.16 sec)
Note (Code 1008): Can't drop database 'cloud'; database doesn't exist
Query OK, 1 row affected (0.14 sec)

mysql> source /usr/share/cloudstack-management/setup/create-schema.sql
Query OK, 0 rows affected (0.00 sec)

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
Query OK, 0 rows affected, 1 warning (0.05 sec)

Note (Code 1051): Unknown table 'cloud.port_forwarding_rules_view'
Query OK, 0 rows affected (0.44 sec)

Query OK, 0 rows affected, 1 warning (0.12 sec)

Note (Code 1051): Unknown table 'cloud.ip_forwarding'
Query OK, 0 rows affected, 1 warning (0.18 sec)

Note (Code 1051): Unknown table 'cloud.management_agent'
Query OK, 0 rows affected (1.30 sec)
Note (Code 1051): Unknown table 'cloud.host_zone_ref'
Query OK, 0 rows affected, 1 warning (0.09 sec)

Note (Code 1051): Unknown table 'cloud.data_ceneter'
Query OK, 0 rows affected (0.39 sec)

Query OK, 0 rows affected, 1 warning (0.04 sec)

Note (Code 1051): Unknown table 'cloud.storage'
Query OK, 0 rows affected (0.43 sec)

Query OK, 0 rows affected, 1 warning (0.04 sec)

Note (Code 1051): Unknown table 'cloud.pricing'
Query OK, 0 rows affected (0.39 sec)

Warning (Code 3719): 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.

Edit: unistalled mysql 8 and installed mariadb 10.3 (mysql Ver 15.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2) halfed the time to

real	3m4.760s
user	0m1.271s
sys	0m0.353s

[abdelouahabb]

Confirmed, dont work in nested virtualization using virt-manager even if the system allows it, reinstalled a new clean ubuntu-server 18.04.5 , same bug I got with ubuntu 20.04, except I got the sql performances better than mysql 8 (which is used below with mariadb to mimic old mysql 5.7)
maybe kvm ambiguity and ressources exclusion (runs the same time virt-manager and cloudstack) like what happens in windows with virtualbox because of hyper-v enabled ?

root@alien:~# kvm-ok
INFO: /dev/kvm exists
KVM acceleration can be used
root@alien:~# lshw -class system
alien.akham.local           
    description: Computer
    product: Standard PC (Q35 + ICH9, 2009)
    vendor: QEMU
    version: pc-q35-4.2
    width: 64 bits
    capabilities: smbios-2.8 dmi-2.8 smp vsyscall32
    configuration: boot=normal uuid=422B1414-E11B-DB48-A5A8-71FABD518F5A
root@alien:~# dmesg | grep -i virtual
[    0.000000] Booting paravirtualized kernel on KVM
[    3.357054] systemd[1]: Detected virtualization kvm.

[abdelouahabb]

To make it work , I dident explicitly add the host (dont know why) :
instead of :

cloudstack-setup-databases cloud:cloud@localhost --deploy-as=root:mypassword -i 192.168.122.10

I just run

cloudstack-setup-databases cloud:cloud@localhost --deploy-as=root:mypassword

root@alien:~# cloudstack-setup-databases cloud:cloud@localhost --deploy-as=root:miawmiaw
Mysql user name:cloud                                                           [ OK ]
Mysql user password:******                                                      [ OK ]
Mysql server ip:localhost                                                       [ OK ]
Mysql server port:3306                                                          [ OK ]
Mysql root user name:root                                                       [ OK ]
Mysql root user password:******                                                 [ OK ]
Checking Cloud database files ...                                               [ OK ]
Checking local machine hostname ...                                             [ OK ]
Checking SELinux setup ...                                                      [ OK ]
Detected local IP address as 192.168.122.10, will use as cluster management server node IP[ OK ]
Preparing /etc/cloudstack/management/db.properties                              [ OK ]
Applying /usr/share/cloudstack-management/setup/create-database.sql             [ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema.sql               [ OK ]
Applying /usr/share/cloudstack-management/setup/create-database-premium.sql     [ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema-premium.sql       [ OK ]
Applying /usr/share/cloudstack-management/setup/server-setup.sql                [ OK ]
Applying /usr/share/cloudstack-management/setup/templates.sql                   [ OK ]
Processing encryption ...                                                       [ OK ]
Finalizing setup ...                                                            [ OK ]

CloudStack has successfully initialized database, you can check your database configuration in /etc/cloudstack/management/db.properties

[yadvr]

For 4.15, we recommend sticking to JRE11; newer JREs may not be supported (however as we see in your test it worked).
@abdelouahabb can you close the issue, thanks.

[weizhouapache]

@abdelouahabb
I tested with ubuntu 20.04 lxc container which is running on a ubuntu 20.04 vm, it took 20 seconds to setup the db.

Thu 11 Mar 2021 10:12:08 AM UTC Setting up cloudstack database ...
Mysql user name:cloud                                                           [ ^[[92mOK^[[0m ]
Mysql user password:******                                                      [ ^[[92mOK^[[0m ]
Mysql server ip:10.135.122.41                                                   [ ^[[92mOK^[[0m ]
Mysql server port:3306                                                          [ ^[[92mOK^[[0m ]
Mysql root user name:root                                                       [ ^[[92mOK^[[0m ]
Mysql root user password:******                                                 [ ^[[92mOK^[[0m ]
Using specified cluster management server node IP 10.135.122.40                 [ ^[[92mOK^[[0m ]
Checking Cloud database files ...                                               [ ^[[92mOK^[[0m ]
Checking local machine hostname ...                                             [ ^[[92mOK^[[0m ]
Checking SELinux setup ...                                                      [ ^[[92mOK^[[0m ]
Preparing /etc/cloudstack/management/db.properties                              [ ^[[92mOK^[[0m ]
Applying /usr/share/cloudstack-management/setup/create-database.sql             [ ^[[92mOK^[[0m ]
Applying /usr/share/cloudstack-management/setup/create-schema.sql               [ ^[[92mOK^[[0m ]
Applying /usr/share/cloudstack-management/setup/create-database-premium.sql     [ ^[[92mOK^[[0m ]
Applying /usr/share/cloudstack-management/setup/create-schema-premium.sql       [ ^[[92mOK^[[0m ]
Applying /usr/share/cloudstack-management/setup/server-setup.sql                [ ^[[92mOK^[[0m ]
Applying /usr/share/cloudstack-management/setup/templates.sql                   [ ^[[92mOK^[[0m ]
Processing encryption ...                                                       [ ^[[92mOK^[[0m ]
Finalizing setup ...                                                            [ ^[[92mOK^[[0m ]

CloudStack has successfully initialized database, you can check your database configuration in /etc/cloudstack/management/db.properties

Thu 11 Mar 2021 10:12:28 AM UTC Waiting CloudStack management server to be up .......................Done

os info

root@mgt01:~# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.2 LTS
Release:        20.04
Codename:       focal

root@mgt01:~# update-alternatives --list java
/usr/lib/jvm/java-11-openjdk-amd64/bin/java

root@mgt01:~# grep securerandom.source= /usr/lib/jvm/java-11-openjdk-amd64/conf/security/java.security
securerandom.source=file:/dev/urandom

[abdelouahabb]

@rhtyd sure, i will make further investigation about why it is slow on my machine, thank you !
@weizhouapache how about ubuntu no GUI + on virt manager ?
I will make further investigations on this, thank you very much