'Overall system status' widget causes deadlocks on DB

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

In Dashboard page following error appears time to time :

 

"Failed to get deployment detail for overall system status widget"

 

After a refresh the dashboard page could be displayed without error.

 

In nolio_dm_all.log error like this appears :

 

2023-05-09T09:21:36.993Z [http-nio-8080-exec-7] DEBUG (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:139) - Deadlock found when trying to get lock; try restarting transaction [n/a]
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
...
    at com.nolio.platform.server.reports.query.filter.TmpFilterDao.removeTmpFilter(TmpFilterDao.java:138)
...
2023-05-09T09:21:36.994Z [http-nio-8080-exec-7] WARN  (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:143) - SQL Error: 1213, SQLState: 40001
2023-05-09T09:21:36.994Z [http-nio-8080-exec-7] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144) - Deadlock found when trying to get lock; try restarting transaction
2023-05-09T09:21:36.996Z [http-nio-8080-exec-7] TRACE (org.hibernate.engine.jdbc.internal.JdbcResourceRegistryImpl:211) - Closing prepared statement [com.mysql.jdbc.JDBC42PreparedStatement@5f6c14af: delete from tmp_filter_num where value_key = '56ef7939-a315-4eb5-aba3-99ea36d41afa']

Environment

Release Automation 6.7.7 (6.7 b810)

Release Automation 6.8 (6.8 b538)

Release Automation 6.8.1 (6.8 b738)

 

Cause

There is an index usage problem in tables tmp_filter_num and tmp_filter_str causing sometimes some deadlock.

Resolution

Open a case at CA Broadcom technical support and ask for the SQL script V6.7.0.0.202305240000000__recreate_tmp_filter__tables-_MYSQL.sql

The correction will be included in next Release Automation versions.