SRM reporting DB backup fails with errno: 24 - Too many open files when using LOCK TABLES

Products

• CA Spectrum

Issue/Introduction

SRM reporting DB backup fails with errno: 24 - Too many open files when using LOCK TABLES

Environment

Release :  ALL

 

Resolution

Use --single-transaction parameter.

Example:

./mysqldump --defaults-file=../my-spectrum.cnf -uroot -proot reporting --single-transaction | gzip > /tmp/databackup.sql.gz