Analysis-Summary Screen Not Opening or Loading Slowly in Security Analytics

Products

• Security Analytics

Issue/Introduction

The Analysis-Summary screen on the Security Analytics web interface either does not open or opens very slowly, sometimes taking over 10 minutes to load.

Observations

• The backend processes of the machine are working normally.

• The issue appears to be related to the GUI.

• Errors are observed in the PostgreSQL logs:

  CakePhp[6102]: CakePHP Error: [PDOException] SQLSTATE[57014]: Query canceled: 7 ERROR: canceling statement due to statement timeout

Cause

The problem is caused by the GUI attempting to execute long-running queries, which results in a statement timeout in PostgreSQL. The backend processes continue to function normally, indicating this is primarily a frontend issue.

Resolution

1. Log in to the system as admin.

2. Navigate to the admin home directory:

 

#sa> cd /home/admin

3. Generate a detailed size listing of the /pfs/packets directory and compress it:

 

#sa> ls -1 -U --size --kibibytes /pfs/packets > /home/admin/ls_pfs_packets_size.out && gzip /home/admin/ls_pfs_packets_size.out

• This creates the file:

 

/home/admin/ls_pfs_packets_size.out.gz

4. Raise a ticket with Broadcom Support Service.

5. Attach the following files to the ticket:

   • /home/admin/ls_pfs_packets_size.out.gz

   • CSR