Aria Automation Config UI not responsive

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Sometimes when trying to access the Aria Automation UI though a browser the page never loads. You may see some of the following error messages:

2024-09-17 09:36:27,532 [var.lib.raas.unpack._MEItL6YG6.raas.mods.db.sqla                  ][DEBUG   :216 ][MainProcess:44773] Failed to connect to database: (psycopg2.OperationalError) connection to server at "xxx" (::1), port 5432 failed: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
SSL SYSCALL error: Connection reset by peer

 

(Background on this error at: http://xxx)
2024-09-17 09:54:11,303 [var.lib.raas.unpack._MEIixvTlB.raas.mods.db.init                  ][CRITICAL:216 ][MainProcess:57844] Failed to connect to the storage backend. Trying again in a bit.
2024-09-17 09:54:12,367 [var.lib.raas.unpack._MEIixvTlB.raas.mods.db.sqla                  ][DEBUG   :216 ][MainProcess:57844] Failed to connect to database: (psycopg2.OperationalError) connection to server at "xxx" (::1), port 5432 failed: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
SSL SYSCALL error: Connection reset by peer

2024-09-17 10:58:52,464 [celery.worker.consumer.consumer                                   ][WARNING :216 ][CeleryGrainsCacheWorker:1755575] consumer: Connection to broker lost. Trying to re-establish the connection...
Traceback (most recent call last):
  File "celery/worker/consumer/consumer.py", line 340, in start
    blueprint.start(self)
  File "celery/bootsteps.py", line 116, in start
    step.start(parent)
  File "celery/worker/consumer/consumer.py", line 742, in start
    c.loop(*c.loop_args())
  File "celery/worker/loops.py", line 97, in asynloop
    next(loop)
  File "kombu/asynchronous/hub.py", line 373, in create_loop
    cb(*cbargs)
  File "kombu/transport/redis.py", line 1343, in on_readable

55575] consumer: Cannot connect to redis://default:**@xxx:6379/0: Error 111 connecting to xxx:6379. Connection refused..
Trying again in 2.00 seconds... (1/100)

Environment

Aria Automation Config all versions

Cause

One cause of this behavior can be that the network is down or the Postgres database or Redis is not accessible. 

Resolution

• Check to see if the Postgres service is running and healthy
  • systemctl status postgres-13.service (service name may be different)
• Check to see if the Redis service is running and healthy
  • systemctl status redis
• Check to see if you can reach Redis and Postgres servers from the Aria Automation Config server
  • curl https://<ip adress of Postgres server>
  • curl https://<ip address of Redis server>