On 7/27/24 4:58 AM, Thamanna Farhath wrote:
Hello community, I am currently deploying Trove using Kolla Ansible 2023.1, following the guide provided here:https://satishdotpatel.github.io/trove-dbaas-openstack/ . Despite cleaving to the instructions, I am facing an issue where the Trove instance ends up in an error state.
*trove-guestagent.conf*
I can't immediately solve your problem, but I can point you at some places to look. You have ssh access to the guest VM, which is a good start! The next things you should look at (on the guest) is /var/log/trove/* and look for rabbitmq client errors -- then to see what's actually happening with the db engine, 'docker ps' and 'docker logs' for the appropriate docker container -- likely you'll see some obvious failure to start up in the container log. I have also seen that timeout error when launching large-sized trove instances -- in that case the timeout was because the initial volume format tool so long that things timed out waiting for the format to complete. It should be easy enough to work around that by trying a minimally-sized instance for starters and then adjusting the timeout as needed for the volume size you want to support. Also be warned that Trove was quite fragile until the last couple of releases, so if you're running something older than, say, version Z, all bets are off. Hope that helps! -Andrew
|[DEFAULT] transport_url =rabbit://openstack:USI0SmaT7lPF7MJCxHPZ4alm8wiyxoihssD1VlnA@192.168.1.101:5672,openstack:USI0SmaT7lPF7MJCxHPZ4alm8wiyxoihssD1VlnA@192.168.1.102:5672,openstack:USI0SmaT7lPF7MJCxHPZ4alm8wiyxoihssD1VlnA@192.168.1.103:5672//control_exchange =trove root_grant =ALLroot_grant_option =Truedebug =False| *Docker Status Check:* |docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES f698ee14d928 mysql:5.7.29 "docker-entrypoint.s…" 18 minutes ago Up 18 minutes 0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp database |*Telnet Connection:* |telnet 192.168.50.78 3306 Trying 192.168.50.78... Connected to 192.168.50.78. Escape character is '^]'. J 5.7.29p+C5 }0^k[zH3mysql_native_password| Syslog(SSH into the trove instance) ERROR2002(HY000): Can'tconnecttolocalMySQLserverthroughsocket'/var/run/mysqld/mysqld.sock' (2)\n": Exception: Runningcommanderror: b"mysql: [Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.ERRORtrove.guestagent.datastore.service [None req-a03ff3dd-5a8f-4fd4-80d5-76e31fa16dd0 - - - - - -] Timeout whilewaiting fordatabase status tochange. Expected state healthy, current state isrunning When looking for the missing directory, I discovered it in /var/lib/mysql/mysqld.sock and /var/lib/mysql/mysqld.pid paths.How can I get an active instance?Kindly help me resolve this. Thank you in advance
||
------------------------------------------------------------------------ *Disclaimer :*/ The content of this email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify the sender and remove the messages from your system. If you are not the named addressee, it is strictly forbidden for you to share, circulate, distribute or copy any part of this e-mail to any third party without the written consent of the sender.// /
/// /
/E-mail transmission cannot be guaranteed to be secured or error free as information could be intercepted, corrupted, lost, destroyed, arrive late, incomplete, or may contain viruses. Therefore, we do not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. The recipient should check this e-mail and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email."// /