UVMS Filesystem full due to huge .dat file in uvmsdb folder related to UNI_UV_USERSETTINGS

Products

• CA Automic Dollar Universe

Issue/Introduction

Suddenly, the UVMS filesystem was full due to a huge .dat file that increased abnormously to several GB, like below:

/uvms_folder/data/data/uvmsdb/seg0/

-rw-r--r--. 1 univadm univgrp 2.9G Nov 21 08:19 c1060.dat

Over the week, the file could increase 1GB each week with no reason.

No particular operation was done at the UVMS level.

While reading the file with a text editor, it seem that the file contained the content of the table UNI_UV_USERSETTINGS, but this table only contained 3 rows, so the size is completely abnormal.

Environment

Release : 6.9 and superior

Component: UVMS using the Internal Derby Database

Cause

Unknown, most likely a Derby database bug.

Resolution

Workaround to reduce the db size:

The procedure would be:

1. Stop uvms

2. Backup the folder <uvms_folder>/data/data/uvmsdb

3. Go to the folder <uvms_folder>/app/bin and launch

./uniderby -q "truncate table UNI_UV_USERSETTINGS"

4. Start uvms