SRM reporting DB backup fails with errno: 24 - Too many open files when using LOCK TABLES
book
Article ID: 243239
calendar_today
Updated On:
Products
CA Spectrum
Issue/Introduction
SRM reporting DB backup fails with errno: 24 - Too many open files when using LOCK TABLES

Resolution
Use --single-transaction parameter.
Example:
./mysqldump --defaults-file=../my-spectrum.cnf -uroot -proot reporting --single-transaction | gzip > /tmp/databackup.sql.gz
Feedback
thumb_up
Yes
thumb_down
No