You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2021/03/09 23:12:11 UTC
[GitHub] [cloudstack] abdelouahabb opened a new issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
abdelouahabb opened a new issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781
I tried a fresh `ubuntu server 20.04.2` with `virt-manager 2.2.1`
```
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
```
And then 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
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb edited a comment on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb edited a comment on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796089227
@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)
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb edited a comment on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb edited a comment on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796268931
@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
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb edited a comment on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb edited a comment on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796430944
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
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796089227
@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`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb closed issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb closed issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rhtyd commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
rhtyd commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-795137378
@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.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb edited a comment on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb edited a comment on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796412428
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.
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
weizhouapache commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796636098
@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
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796661040
@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
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache edited a comment on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
weizhouapache edited a comment on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-795010523
@abdelouahabb
open /etc/java-11-openjdk/security/java.security and change the following line
```
securerandom.source=file:/dev/urandom
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rhtyd commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
rhtyd commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796567360
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.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
weizhouapache commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796198828
> @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.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796268931
@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.
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796412428
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 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.
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
weizhouapache commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-795010523
@abdelouahabb
go to /etc/java-11-openjdk/security/java.security and change the following line
```
securerandom.source=file:/dev/urandom
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] abdelouahabb commented on issue #4781: cloudstack-setup-databases takes more than 5 minutes to complete
Posted by GitBox <gi...@apache.org>.
abdelouahabb commented on issue #4781:
URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796430944
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
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org