# Testing for installed programs
WARNING: Turning off multicore support, since pigz isn't there.
mysql ... found.
mysqldump ... found.
# Parsing databases ... done.
....
BUT, later on, get this
WARNING
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Couldn't execute 'show fields from products_options': Out of resources when opening file './orchardgrove/products_options.MYD' (Errcode: 24 "Too many open files") (23)
mysqldump: Got error: 1030: "Got error 24 "Too many open files" from storage engine MyISAM" when using LOCK TABLES
mysqldump: Error: 'Out of resources when opening file '/var/tmp/#sql_5268_2.MAI' (Errcode: 24 "Too many open files")' when trying to dump tablespaces
mysqldump: Error: 'Out of resources when opening file '/var/tmp/#sql_5268_2.MAI' (Errcode: 24 "Too many open files")' when trying to dump tablespaces
...///...
mysqldump: Error: 'Out of resources when opening file '/var/tmp/#sql_5268_2.MAD' (Errcode: 24 "Too many open files")' when trying to dump tablespaces
mysqldump: Got error: 1030: "Got error 24 "Too many open files" from storage engine MyISAM" when using LOCK TABLES
mysqldump: Error: 'Out of resources when opening file '/var/tmp/#sql_5268_2.MAD' (Errcode: 24 "Too many open files")' when trying to dump tablespaces # systemctl status rh-mariadb102-mariadb
what have I screwed up?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
long time user of this script on my 'old' server, with v 2.51
NOW, setting a new server with Centos 7 and rh-mariadb102-mariadb
set server, tec, etc, copied my old files, tried running, got succession of errors, AND MariaDB stopped working
after a brief panic, restarted MariaDB, then, searched for an uptodate version, found it here, installed ver 3, tried, same problems:
it starts OK as so:
# automysqlbackup /etc/automysqlbackup/myserver.conf
Parsed config file "/etc/automysqlbackup/automysqlbackup.conf"
# Checking for permissions to write to folders:
base folder /backup ... exists ... ok.
backup folder /backup/db ... exists ... writable? yes. Proceeding.
checking directory "/backup/db/daily" ... exists.
checking directory "/backup/db/weekly" ... exists.
checking directory "/backup/db/monthly" ... exists.
checking directory "/backup/db/latest" ... exists.
checking directory "/backup/db/tmp" ... exists.
checking directory "/backup/db/fullschema" ... exists.
checking directory "/backup/db/status" ... exists.
# Testing for installed programs
WARNING: Turning off multicore support, since pigz isn't there.
mysql ... found.
mysqldump ... found.
# Parsing databases ... done.
....
BUT, later on, get this
WARNING
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Couldn't execute 'show fields from
products_options': Out of resources when opening file './orchardgrove/products_options.MYD' (Errcode: 24 "Too many open files") (23)mysqldump: Got error: 1030: "Got error 24 "Too many open files" from storage engine MyISAM" when using LOCK TABLES
mysqldump: Error: 'Out of resources when opening file '/var/tmp/#sql_5268_2.MAI' (Errcode: 24 "Too many open files")' when trying to dump tablespaces
mysqldump: Error: 'Out of resources when opening file '/var/tmp/#sql_5268_2.MAI' (Errcode: 24 "Too many open files")' when trying to dump tablespaces
...///...
mysqldump: Error: 'Out of resources when opening file '/var/tmp/#sql_5268_2.MAD' (Errcode: 24 "Too many open files")' when trying to dump tablespaces
mysqldump: Got error: 1030: "Got error 24 "Too many open files" from storage engine MyISAM" when using LOCK TABLES
mysqldump: Error: 'Out of resources when opening file '/var/tmp/#sql_5268_2.MAD' (Errcode: 24 "Too many open files")' when trying to dump tablespaces
# systemctl status rh-mariadb102-mariadb
what have I screwed up?