Aria Operations for Logs UI fails to load or displays a blank spinning screen

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

After logging in to the VMware Aria Operations for Logs user interface, the UI fails to load. You may observe a blank screen with a loading spinner. This behavior can affect the entire cluster or occur only on specific nodes.

 

Environment

Aria Operations for Logs 8.12.x and later

Cause

This issue is typically caused by a high volume of cached session entries within the internal Cassandra database. A large number of records in the tomcat_sessions table can cause significant delays or timeouts during the UI initialization process.

 

Resolution

To resolve this issue, you must truncate the tomcat_sessions table in the Cassandra database.

Prerequisites:

• Take a virtual machine snapshot of all nodes in the cluster before proceeding.

Procedure:

1. Open an SSH session to the primary node of the Aria Operations for Logs cluster.

2. Log in to the Cassandra database by running the following command:

   /usr/lib/loginsight/application/lib/apache-cassandra-*/bin/cqlsh-no-pass
   

3. Check the current number of session records by executing:

   SELECT COUNT(*) FROM logdb.tomcat_sessions;
   

4. If the count exceeds 10,000 records or if the query times out, truncate the table to clear the cache:

   TRUNCATE logdb.tomcat_sessions;
   

5. Type exit to leave the database shell.

6. Restart the Log Insight services on all nodes to apply the changes:

   service loginsight restart