search cancel

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.

Environment

OS: Linux

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.

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