DRADISCACHE schema filling up fast and causing registry failure for DevTest 10.6

Products

• CA Application Test
• Service Virtualization

Issue/Introduction

Since upgrading to DevTest 10.6.0 (had the same issue on DevTest 10.5.0)

Saw our RegistryService going down as the LISA_ED_DEV.DRADISCACHE was full.  Had 300 GB of space however, it filled up and caused the failure.

Have it increased however the DBA team said that it's filling up fast and is there a way for auto purging the data.

We have total 5 different schema for all our servers. 

The LISA_ED_Dev is having issues.

The current count is 16362129 yesterday it was 16331084

 

Schema Name	DevTest Component
LISA_DEV	LISA EnterpriseDashboard
LISA_VSCATALOG	LISA IAM
LISA_FUNC	LISA Functional_01 Registry
LISA_ED_Func	LISA Functional_02 Registry
LISA_ED_Dev	LISA SI DEV Registry
LISA_FUNC_PERF	LISA Performance Registry
LISA_APPTEST	LISA Application Test Registry

 

 

Environment

Release : 10.6

Component : CA Service Virtualization

Cause

New Code fix.

Resolution

Open a support case and refer to defect DE453646

Additional Information

Fix is working as expected, since there are too many messages it is taking time to process all the messages. From logs, it looks like 14 threads are created to process the messages and a few messages have huge data as the developer could not find entry for threads like [pool-4-thread-2], [pool-4-thread-3] etc. In few weeks, the count should come to hundreds.