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.