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

book

Article ID: 193474

calendar_today

Updated On:

Products

CLOUDTEST CA Application Test CA Cloud Test Mobile MOBILECLOUD Service Virtualization

Issue/Introduction

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

Today we saw our RegistryService going down as the LISA_ED_DEV.DRADISCACHE was fulled. We had 300 GB of space however, it filled up and caused the failure.

We 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

 

 





Cause

New Code fix.

Environment

Release : 10.6

Component : CA Service Virtualization

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.