It looks like db.properties is not configured correctly. The mgmt server cannot connect the database.
-Wei On Tue, Apr 9, 2024 at 11:46 AM Francisco Arencibia Quesada <arencibia.franci...@gmail.com> wrote: > > Hi Wei, > > this is it: > 2024-04-09 09:35:18,507 DEBUG [c.c.u.d.DbProperties] (main:null) (logid:) > DB properties were already loaded > 2024-04-09 09:35:18,508 INFO [c.c.u.d.T.Transaction] (main:null) (logid:) > Is Data Base High Availiability enabled? Ans : false > 2024-04-09 09:35:18,508 INFO [c.c.u.d.T.Transaction] (main:null) (logid:) > Using the following URI to connect to cloud database > [jdbc:mysql://localhost:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC]. > 2024-04-09 09:35:18,514 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) > Successfully loaded DB driver com.mysql.cj.jdbc.Driver > 2024-04-09 09:35:18,535 INFO [c.c.u.d.T.Transaction] (main:null) (logid:) > Using the following URI to connect to usage database > [jdbc:mysql://localhost:3306/cloud_usage?autoReconnect=true&serverTimezone=UTC]. > 2024-04-09 09:35:18,536 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) > DB driver com.mysql.cj.jdbc.Driver was already loaded. > 2024-04-09 09:35:18,540 DEBUG [c.c.u.d.DriverLoader] (main:null) (logid:) > DB driver com.mysql.cj.jdbc.Driver was already loaded. > 2024-04-09 09:35:22,983 ERROR [c.c.u.d.Merovingian2] (main:null) (logid:) > Unable to get a new db connection > java.sql.SQLNonTransientConnectionException: Could not create connection to > database server. Attempted reconnect 3 times. Giving up. > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) > at > com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906) > at > com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831) > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) > at > com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) > at > com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) > at > java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) > at > java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) > at > org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) > at > org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:374) > at > org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:918) > at > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:431) > at > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356) > at > org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:141) > at > com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:212) > at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68) > at > com.cloud.utils.db.Merovingian2.createLockController(Merovingian2.java:88) > at > com.cloud.server.LockControllerListener.<init>(LockControllerListener.java:33) > at > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at > java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) > at > org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:211) > at > org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:117) > at > org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:311) > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:296) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1372) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1222) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) > at > org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:920) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) > at > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:171) > at > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:140) > at > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:271) > at > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:276) > at > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:259) > at > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:128) > at > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:78) > at > org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37) > at > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:70) > at > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:57) > at > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:61) > at > org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52) > at > org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1073) > at > org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:572) > at > org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:1002) > at > org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:765) > at > org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:379) > at > org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1449) > at > org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1414) > at > org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:916) > at > org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:288) > at > org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524) > /SQL > > On Tue, Apr 9, 2024 at 11:40 AM Wei ZHOU <ustcweiz...@gmail.com> wrote: > > > The SQLException may tell what's wrong. > > Can you share ? > > > > -Wei > > > > On Tue, Apr 9, 2024 at 11:23 AM Francisco Arencibia Quesada > > <arencibia.franci...@gmail.com> wrote: > > > > > > indeed Wei, SQLException. > > > It is such a weird thing that was working 2days ago, now SQLException :(. > > > > > > > > > Regards > > > > > > On Tue, Apr 9, 2024 at 10:53 AM Wei ZHOU <ustcweiz...@gmail.com> wrote: > > > > > > > Hi Francisco, > > > > > > > > Please check the database connection, and also check if there is > > > > SQLException in the management-server.log > > > > > > > > -Wei > > > > > > > > > > > > On Tue, Apr 9, 2024 at 10:44 AM Francisco Arencibia Quesada > > > > <arencibia.franci...@gmail.com> wrote: > > > > > > > > > > with ubuntu and 4.19 I'm having this issue > > > > > https://github.com/apache/cloudstack/issues/8218 > > > > > 503 error. > > > > > > > > > > Please let us know something about this issue. > > > > > > > > > > Regards > > > > > > > > > > On Tue, Apr 9, 2024 at 9:39 AM Alex Paul < > > alex.chris.jun...@gmail.com> > > > > > wrote: > > > > > > > > > > > Hi Community, > > > > > > > > > > > > Tried with centos 7, upgrade is failing > > > > > > > > > > > > ~~~~~~~~ > > > > > > cloudstack-management-4.18.1.1 FAILED > > > > > > ==============-] 23 MB/s | 1.8 GB 00:00:00 ETA > > > > > > > > > > > > > > > > > > http://download.cloudstack.org/centos/7/4.18/cloudstack-management-4.18.1.1-1.el7.x86_64.rpm > > > > > > : > > > > > > [Errno -1] Package does not match intended download. Suggestion: > > run > > > > yum > > > > > > --enablerepo=cloudstack clean metadata > > > > > > ~~~~~~~~ > > > > > > > > > > > > Cleaning yum metadata does not help > > > > > > > > > > > > Alex > > > > > > > > > > > > > > > > > > > > > > > > On Thu, Apr 4, 2024 at 2:52 AM Francisco Arencibia Quesada < > > > > > > arencibia.franci...@gmail.com> wrote: > > > > > > > > > > > > > Thanks a lot guys, now it works like a charm. > > > > > > > > > > > > > > > > > > > > > Kind regards > > > > > > > > > > > > > > On Wed, Apr 3, 2024 at 8:37 PM Wei ZHOU <ustcweiz...@gmail.com> > > > > wrote: > > > > > > > > > > > > > > > Thanks a lot @Rohit Yadav > > > > > > > > > > > > > > > > I am able to upgrade from 4.18.0.0 to 4.18.1.1 then to > > 4.19.0.1 on > > > > > > > > both ubuntu and rocky8 hosts. > > > > > > > > > > > > > > > > -Wei > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wed, Apr 3, 2024 at 7:49 PM Rohit Yadav < > > > > rohit.ya...@shapeblue.com> > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > Thanks for checking - could you try again, I've purged the > > old > > > > cdn > > > > > > > > cache. It should be fixed now. > > > > > > > > > > > > > > > > > > > > > > > > > > > Regards. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ________________________________ > > > > > > > > > From: Francisco Arencibia Quesada < > > arencibia.franci...@gmail.com > > > > > > > > > > > > > > Sent: Wednesday, April 3, 2024 21:55 > > > > > > > > > To: users@cloudstack.apache.org <users@cloudstack.apache.org > > > > > > > > > > > > Subject: Re: cloudstack 4.19 filesize mismatch > > > > > > > > > > > > > > > > > > now are failing both 4.18 and 4.19 > > > > > > > > > > > > > > > > > > Regards > > > > > > > > > > > > > > > > > > On Wed, Apr 3, 2024 at 6:13 PM Rohit Yadav < > > > > > > rohit.ya...@shapeblue.com> > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > Hi Francisco, > > > > > > > > > > > > > > > > > > > > The repo CDN is being updated, sometimes files are out of > > > > sync. Can > > > > > > > you > > > > > > > > > > run apt-get update and try again and keep us posted if you > > > > still > > > > > > face > > > > > > > > the > > > > > > > > > > issue. > > > > > > > > > > > > > > > > > > > > Regards. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ________________________________ > > > > > > > > > > From: Francisco Arencibia Quesada < > > > > arencibia.franci...@gmail.com> > > > > > > > > > > Sent: Wednesday, April 3, 2024 8:39:23 PM > > > > > > > > > > To: users@cloudstack.apache.org < > > users@cloudstack.apache.org> > > > > > > > > > > Subject: cloudstack 4.19 filesize mismatch > > > > > > > > > > > > > > > > > > > > Good morning guys, > > > > > > > > > > > > > > > > > > > > I want to report an issue with deb packages for 4.19 > > release. > > > > > > > > > > > > > > > > > > > > Please see details below: > > > > > > > > > > > > > > > > > > > > https://pastes.io/utzcxtyako -to check all output > > > > > > > > > > > > > > > > > > > > Get:1 https://download.cloudstack.org/ubuntu jammy/4.19 > > all > > > > > > > > > > cloudstack-common all 4.19.0.1 [117 MB] > > > > > > > > > > Err:1 https://download.cloudstack.org/ubuntu jammy/4.19 > > all > > > > > > > > > > cloudstack-common all 4.19.0.1 > > > > > > > > > > File has unexpected size (116922362 != 116919496). Mirror > > > > sync in > > > > > > > > > > progress? [IP: 195.181.167.51 443] > > > > > > > > > > Hashes of expected file: > > > > > > > > > > - > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > SHA512:00d5571a65ef8029ce668fe2f8769326253615a282e0c6b155410460e7b3d288b062b1d434962b98b26b2be764867010c42fcf39f6ebae68b1bc7e43ea523894 > > > > > > > > > > - > > > > > > > > > > > > > > > > > > > > > SHA256:1f0805bfe95351fe30b55999235fc0e398201d1e3131ad7fd1538ef1b7a144be > > > > > > > > > > - SHA1:496ff9dffbd6299d1efa0b1c788318fbb04c57fa [weak] > > > > > > > > > > - MD5Sum:f162ade7affd9f8a5b8f358e1674f25f [weak] > > > > > > > > > > - Filesize:116919496 [weak] > > > > > > > > > > Get:2 https://download.cloudstack.org/ubuntu jammy/4.19 > > all > > > > > > > > > > cloudstack-management all 4.19.0.1 [1441 MB] > > > > > > > > > > Err:2 https://download.cloudstack.org/ubuntu jammy/4.19 > > all > > > > > > > > > > cloudstack-management all 4.19.0.1 > > > > > > > > > > File has unexpected size (1440658214 != 1440655316). > > Mirror > > > > sync > > > > > > in > > > > > > > > > > progress? [IP: 195.181.167.51 443] > > > > > > > > > > Hashes of expected file: > > > > > > > > > > - > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > SHA512:352a5133cc06b5ca05b097b9dce9e7d670ec89b7602729a9557f69876fe9f8dba568e0008065535c7f3daed4651a97deb18be1849e8bc64459784ba0ed9e20b3 > > > > > > > > > > - > > > > > > > > > > > > > > > > > > > > > SHA256:2f2216acda05088ec39c0157c09e0169fa9b5d30dbeb15cb074e743785f5a6ab > > > > > > > > > > - SHA1:31a04c5f4b271d7bf4cb0919293b3df0fa27e4c1 [weak] > > > > > > > > > > - MD5Sum:f8ce84b0b14e6ef64d235e78ee2a8af6 [weak] > > > > > > > > > > - Filesize:1440655316 [weak] > > > > > > > > > > E: Failed to fetch > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > https://download.cloudstack.org/ubuntu/dists/jammy/4.19/pool/cloudstack-common_4.19.0.1_all.deb > > > > > > > > > > File has unexpected size (116922362 != 116919496). Mirror > > > > sync in > > > > > > > > > > progress? [IP: 195.181.167.51 443] > > > > > > > > > > Hashes of expected file: > > > > > > > > > > - > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > SHA512:00d5571a65ef8029ce668fe2f8769326253615a282e0c6b155410460e7b3d288b062b1d434962b98b26b2be764867010c42fcf39f6ebae68b1bc7e43ea523894 > > > > > > > > > > - > > > > > > > > > > > > > > > > > > > > > SHA256:1f0805bfe95351fe30b55999235fc0e398201d1e3131ad7fd1538ef1b7a144be > > > > > > > > > > - SHA1:496ff9dffbd6299d1efa0b1c788318fbb04c57fa [weak] > > > > > > > > > > - MD5Sum:f162ade7affd9f8a5b8f358e1674f25f [weak] > > > > > > > > > > - Filesize:116919496 [weak] > > > > > > > > > > E: Failed to fetch > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > https://download.cloudstack.org/ubuntu/dists/jammy/4.19/pool/cloudstack-management_4.19.0.1_all.deb > > > > > > > > > > File has unexpected size (1440658214 != 1440655316). > > Mirror > > > > sync > > > > > > in > > > > > > > > > > progress? [IP: 195.181.167.51 443] > > > > > > > > > > Hashes of expected file: > > > > > > > > > > - > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > SHA512:352a5133cc06b5ca05b097b9dce9e7d670ec89b7602729a9557f69876fe9f8dba568e0008065535c7f3daed4651a97deb18be1849e8bc64459784ba0ed9e20b3 > > > > > > > > > > - > > > > > > > > > > > > > > > > > > > > > SHA256:2f2216acda05088ec39c0157c09e0169fa9b5d30dbeb15cb074e743785f5a6ab > > > > > > > > > > - SHA1:31a04c5f4b271d7bf4cb0919293b3df0fa27e4c1 [weak] > > > > > > > > > > - MD5Sum:f8ce84b0b14e6ef64d235e78ee2a8af6 [weak] > > > > > > > > > > - Filesize:1440655316 [weak] > > > > > > > > > > > > > > > > > > > > Kind regards > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > *Francisco Arencibia Quesada.* > > > > > > > > > > *DevOps Engineer* > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > *Francisco Arencibia Quesada.* > > > > > > > > > *DevOps Engineer* > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > *Francisco Arencibia Quesada.* > > > > > > > *DevOps Engineer* > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > *Francisco Arencibia Quesada.* > > > > > *DevOps Engineer* > > > > > > > > > > > > > -- > > > *Francisco Arencibia Quesada.* > > > *DevOps Engineer* > > > > > -- > *Francisco Arencibia Quesada.* > *DevOps Engineer*
