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*
