I have this problem with a server, but the other installed with ansible is just stuck loading only the title bar loads saying apache cloudstack, but no error in mysql, it is just stuck. I dont understand this was working perfectly, I installed it using an ansible role.
regards On Tue, Apr 9, 2024 at 11:46 AM Francisco Arencibia Quesada < [email protected]> 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 <[email protected]> wrote: > >> The SQLException may tell what's wrong. >> Can you share ? >> >> -Wei >> >> On Tue, Apr 9, 2024 at 11:23 AM Francisco Arencibia Quesada >> <[email protected]> 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 <[email protected]> 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 >> > > <[email protected]> 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 < >> [email protected]> >> > > > 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 < >> > > > > [email protected]> wrote: >> > > > > >> > > > > > Thanks a lot guys, now it works like a charm. >> > > > > > >> > > > > > >> > > > > > Kind regards >> > > > > > >> > > > > > On Wed, Apr 3, 2024 at 8:37 PM Wei ZHOU <[email protected]> >> > > 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 < >> > > [email protected]> >> > > > > > > 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 < >> [email protected] >> > > > >> > > > > > > > Sent: Wednesday, April 3, 2024 21:55 >> > > > > > > > To: [email protected] < >> [email protected]> >> > > > > > > > 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 < >> > > > > [email protected]> >> > > > > > > > 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 < >> > > [email protected]> >> > > > > > > > > Sent: Wednesday, April 3, 2024 8:39:23 PM >> > > > > > > > > To: [email protected] < >> [email protected]> >> > > > > > > > > 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* > -- *Francisco Arencibia Quesada.* *DevOps Engineer*
