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.