You're right. This is the actual problem: Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to initialize a connection to the database for locking purposes Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
But everything seems right in the db.properties file. The host should be the virtual ip of the load balancer, right? -----Original Message----- From: Wei ZHOU <[email protected]> Sent: Wednesday, May 29, 2024 10:28 PM To: [email protected] Subject: Re: HA for management server Hi, The exception is misleading You can check the real exception by grep Exception management-server.log | grep -v NoSuchBeanDefinitionException I guess the root cause is database configuration or db.properties. By the way, it is better mariadb galera cluster have 3 servers. -Wei On Wednesday, May 29, 2024, Alexandru Stan <[email protected]> wrote: > Hello, > > There seems to be issues with installing the management server > databases on a separate server, I setup a galera cluster with 2 > servers and tried to install the management server on a different > server using (where it still > applies) this guide: https://www.shapeblue.com/how- > to-deploy-high-availability-cloudstack-with-mariadb-galera-cluster/ > > However, while the database setup seems to be fine and everything > after, the cloudstack-management service is running but there's no UI. > Checking the status shows this: > > Failed to start module [redfish] due to: [Error creating bean with > name > 'org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0' > defined in URL [jar:file:/usr/share/cloudstack-management/lib/ > cloudstack-4.19.0.1.jar!/META-INF/cloudstack/bootstrap/ > spring-bootstrap-context-inheritable.xml]: Cannot resolve reference to > bean 'DefaultConfigResources' while setting bean property 'locations'; > nested exception is > org.springframework.beans.factory.NoSuchBeanDefinitionException: > No bean named 'DefaultConfigResources' available]. > > Any idea why this happens? > > > -----Original Message----- > From: Jayanth Babu A <[email protected]> > Sent: Monday, May 27, 2024 12:28 PM > To: [email protected] > Subject: Re: HA for management server > > Hello, > Yes, DB clustering with Galera or some other sort should be looked into. > I'm not sure if [1] has worked for someone so far. > > [1] https://docs.cloudstack.apache.org/en/latest/ > adminguide/reliability.html#configuring-database-high-availability > > Thanks, > Jayanth > ________________________________ > From: Alexandru Stan <[email protected]> > Sent: Monday, May 27, 2024 2:48 PM > To: [email protected] <[email protected]> > Subject: RE: HA for management server > > Hi, > > Actually no, I'm just documenting the process so far, so nothing was > done for the DB. For this I assume the info in the official > documentation would be ok? Or something more advanced would be needed, like a > galera cluster? > > > > -----Original Message----- > From: Jayanth Babu A <[email protected]> > Sent: Monday, May 27, 2024 12:12 PM > To: [email protected] > Subject: Re: HA for management server > > Hello Alexandru, > Please see [1] and [2]. I assume your DB HA is taken care of. > > [1] https://checkpoint.url-protection.com/v1/url?o=https% > 3A//docs.cloudstack.apache.org/en/latest/adminguide/reliability.html&g > = ZmEwYjAwNmYwMjIxNTU5ZQ==&h=NmQyMzY5Nzc5YTU2ZDkyYjc4N2ExND > U4Y2Q0OWFkMjQ4OGRhMGZiZjdiNDA5N2NmNmRhM2EwYjUzZGEwMmI2Mg==&p= > Y3AxZTpueHRnZW5pbmZpbml0ZWRhdGFjZW50ZXI6YzpvOmY0ZWFkYmU5NDkz > MjMyMjdjY2EyM2IxN2YzOGZiMWE4OnYxOnA6VA== > [2] https://checkpoint.url-protection.com/v1/url?o=https% > 3A//github.com/apache/cloudstack/issues/8221&g=YzVlNDk3YjI5NTEwMTM5Mg= > =&h= > OTBmN2Q4ZjA3YzRlOTAxZDk1YzcwMmExMTAzYTY4N2VmYjg5MGZkZGQyMDE2 > NTM3MTU4MGUxNDRjNzMzN2E0ZQ==&p=Y3AxZTpueHRnZW5pbmZpbml0ZWRhdG > FjZW50ZXI6YzpvOmY0ZWFkYmU5NDkzMjMyMjdjY2EyM2IxN2YzOGZiMWE4OnYxOnA6VA== > > Regards, > Jayanth Reddy > Engineering Manager > > From: Alexandru Stan <[email protected]> > Date: Monday, 27 May 2024 at 2:38 PM > To: [email protected] <[email protected]> > Subject: HA for management server > Hello, > > Is there any documentation on deployment of multiple management > servers in high availability? Or does anyone have good info on this? > The official documentation does not contain anything relevant unfortunately. > > Thank you! > Disclaimer *** This e-mail contains PRIVILEGED AND CONFIDENTIAL > INFORMATION intended solely for the use of the addressee(s). If you > are not the intended recipient, please notify the sender by e-mail and > delete the original message. Further, you are not authorised to copy, > disclose, or distribute this e-mail or its contents to any other > person and any such actions are unlawful and strictly prohibited. This > e-mail may contain viruses. NxtGen Datacenter & Cloud Technologies > Private Ltd (“NxtGen”) has taken every reasonable precaution to > minimize this risk but is not liable for any damage you may sustain as > a result of any virus in this e-mail. You should carry out your own > virus checks before opening the e-mail or attachment. NxtGen reserves > the right to monitor and review the content of all messages sent to or > from this e-mail address. Messages sent to or from this e-mail address > may be stored on the NxtGen e-mail system. *** End of Disclaimer > ***NXTGEN*** Disclaimer *** This e-mail contains PRIVILEGED AND CONFIDENTIAL > INFORMATION intended solely for the use of the addressee(s). > If you are not the intended recipient, please notify the sender by > e-mail and delete the original message. Further, you are not > authorised to copy, disclose, or distribute this e-mail or its > contents to any other person and any such actions are unlawful and > strictly prohibited. This e-mail may contain viruses. NxtGen > Datacenter & Cloud Technologies Private Ltd > (“NxtGen”) has taken every reasonable precaution to minimize this risk > but is not liable for any damage you may sustain as a result of any > virus in this e-mail. You should carry out your own virus checks > before opening the e-mail or attachment. NxtGen reserves the right to > monitor and review the content of all messages sent to or from this > e-mail address. Messages sent to or from this e-mail address may be stored on > the NxtGen e-mail system. > *** End of Disclaimer ***NXTGEN*** >
