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

Document ID : KB000085687
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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