XTRABACKUP ERROR: InnoDB: Operating system error number 13 in a file operation.
SYMPTOM: When you receive an ‘access’ error similar to this…
xtrabackup: Generating a list of tablespaces
2017-02-20 08:28:32 7f875a611720 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 2703
main::wait_for_ibbackup_file_create(‘/dbdata/bkups_here/2017-02-20_08-28-32/xtrabackup_suspended_2’) called at /usr/bin/innobackupex line 2723
main::wait_for_ibbackup_suspend(‘/dbdata/bkups_here/2017-02-20_08-28-32/xtrabackup_suspended_2’) called at /usr/bin/innobackupex line 1976
main::backup() called at /usr/bin/innobackupex line 1601
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2703.
PROBLEM: XtraBackup is looking through the database list, even though a specific directory may have been specified, and having issues reviewing the databases containers.
SUGGESTION: Review all ‘directories’ (databases) in the ‘datadir’ directory. Review the engine’s access (usually the ‘mysql’ user). RW access is required. In my case, even though ‘ignore-db-dir=lost+found’ was specified in the ‘my.cnf’, I had to remove the directory ‘lost+found’.
Keywords: mariadb, mysql, percona xtrabackup, error
I solved this error by the following commands"
FIXING MYSQL FAILED TO START
13 Permission Denied OS Error, run the following commands:
Fist of all, read the MSYQL error log which is located /var/log/mysql. You can do so by using cat error.log command.
==============
chown mysql:adm /var/log/mysql/error.log
chown mysql:adm /var/log/mysql
chown root:syslog /var/log
chown root:root /var
chmod 0640 /var/log/mysql/error.log
chmod 0750 /var/log/mysql
chmod 0775 /var/log
chmod 0755 /var
chown mysql.mysql -R /var/lib/mysql
systemctl start mysql.service
systemctl status mysql.service
IMPORTANT:
mysql must be run and owned by a mysq:mysql. Run the command below.
chown mysql.mysql -R /var/lib/mysql