search cancel

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

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

Attachments