Backup of Derby database fails when UVMS is running as non-priveleged user

book

Article ID: 85687

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

Error Message :
In uvserver.log: 
### 
| 2014-06-19 09:29:06 |INFO | request-worker-5 | com.orsyp.central.derbyrecovery.DerbyBackup | Performing incremental database backup on /appli/univiewer/backup_y001f0o_MgtServer_derbydb/20140619_092906_547; [BACKUP TYPE=BY_NOT_AFFECTING_THE_ARCHIVED_LOG_FLAG]. 
| 2014-06-19 09:29:06 |ERROR| request-worker-5 | 
<...> 
com.orsyp.central.derbyrecovery.DerbyBackup | Error during Derby backup procedure 
java.lang.RuntimeException: Error performing derby backup! 
<...> 
Caused by: java.sql.SQLException: Cannot backup the database, got an I/O Exception while writing to the backup container file /appli/univiewer/backup_y001f0o_MgtServer_derbydb/~20140619_092906_547/uvmsdb/seg0/c4b0.dat. 
<...> 
Caused by: java.sql.SQLException: Java exception: 'File too large: java.io.IOException'.

Patch level detected:Univiewer Management Server 6.4.01
Product Version: Dollar.Universe 6.4.01

Description :UVMS is installed and run as a non-privileged user (non-root user) and the Derby database is not backed up as expected.

Cause

Cause type:
Configuration
Root Cause: If a "File too large" error occurs during the backup procedure of the UVMS database, the UVMS backup will fail because there is not enough File Descriptors for this user.

Environment

OS: Linux

Resolution

Increase the File Descriptors for the users that starts UVMS to 12000 in UVC (UXMAXFD):
Administration tab > UVMS Node Settings > Advanced Settings > Maximum Number of File Descriptors=12000
A restart of UVMS is necessary.

Also increase the File Descriptors on system level (ulimit -n) to match the value of UXMAXFD.

(See documentation UVC Administration)

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.5.01

Additional Information

Workaround :
N/A